I'm working on an application using Laravel 10, and I'm facing a performance issue related to eager loading nested relationships and custom accessors. Scenario: I have three models: User, Post, and Comment. A User has many Posts. A Post has…
i have the following models <?php namespace AppModelsMastersSystem; class UserActivationCode extends IlluminateDatabaseEloquentModel { public $table = "user_activation_codes"; } <?php namespace AppModels; use AppModelsModel; use ModulesRequestsModelsEmploymentLeaveType; use AppModelsMastersSystemUserActivationCode; class EmployeeEmployment extends IlluminateDatabaseEloquentModel { public $table = "employee_employments"; public function employeeProfileScore() {…
As @JonasStaudenmeir answered on laravel eager loading with limit, which query looks like: User::select('id') ->with([ 'posts' => fn($query) => $query->select(['id', 'user_id'])->limit(4) ]) ->limit(2) ->get(); select `id` from `users` limit 2 select * from (select `id`, `user_id`, row_number() over (partition by…
What I want to do is something like this : $listOfYears = Invoice::pluck('year') ; // [ 2001, 2002, 2003 ] $products = Product::whereYearIn('purchase_date',$listOfYears)->get(); the field purchase_date is type date so you can't just use whereIn, you need to apply whereYear…
I have 2 models: Supplier and Product which are connected via SupplierProduct table with additional fields For a given $supplier I need to load it's SupplierProducts (with attached products) filtered by where conditions in both SupplierProduct and Product models Loading…
I am trying to improve at laravel, the story here is that I have customers, customers can have appointments and users create appointments for the customers. Visit model: class Visit extends Model { use HasFactory; protected $fillable = [ 'user_id',…
my product has relation called values which is like this: public function values() { return $this->hasManyThrough(VariantValue::class, VariantProductOption::class, 'product_id', 'product_option_id'); } everything works fine but when i have a multiple products in a single pages n+1 problem happens: select `variant_sku_values`.*, `variant_sku_product_options`.`product_id`…
I have two models, User and Post, where a User can have multiple Post models. In my application, I only want to retrieve the title column from the related Post model when querying for a User. Here is my current…
Let's say I have a model called Research. Each research belongsToMany Location models. And each Location model BelongsToMany Contact models. BUT, each Contact is also related to Research. class Research extends Model { protected $table = 'researches'; public function locations()…