Modal: Subscription.php class Subscription extends Model { use HasFactory; public function payments(): HasMany { return $this->hasMany(SubscriptionPayment::class, 'sub_id'); } public function totalDurationDays(): Attribute { return Attribute::make( get: fn() => $this->payments()->sum('duration_days') )->shouldCache(); } } Controller: SubscriptionController.php $subs = SharedServer::from('subscriptions AS ss') ->select(…
Here is my current setup: <?php namespace AppModels; use Exception; use IlluminateDatabaseEloquentModel; use IlluminateDatabaseEloquentRelationsBelongsTo; use IlluminateDatabaseEloquentRelationsBelongsToMany; class Employee extends Model { protected $table = 'employees'; protected $fillable = [ 'first_name', 'last_name', 'gender', 'birthdate', 'nationality_id', 'company_id', ]; public function positions(): BelongsToMany…
When accessing model attrs inside relation logic in laravel the attrs are all null when eager loading, if lazy loading it works fine. Model relation : public function organization() { return $this->belongsTo(Organization::class, 'organization_id'); } public function currentOrder() { // Note…
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`…