I have two tables tasks and task_hours, And I'm using one to many relationship in task model.(task can have many hours logs). And displaying task data at frontend in table (datatable) using with relationships to task_hours (as per query below).…
I have three models: Vehicle, LiveData, and Place. In my Vehicle model, I currently have a relationship between Vehicle and LiveData that gets the latest LiveData for a vehicle: public function latestPosition(): HasOne { return $this->hasOne(LiveData::class)->latestOfMany(); } Now in my…
I have a model Facility that has rates (tariffs). The Rate model has a relationship to a RateType. The RateType has a column weight. I want to sort the Facility's rates based on those weights. I would like to always…
I have made a category and a posts table. On post table I'm storing the category id's in the JSON format on posts table. Now, I would like to get total count of posts for each category where categories are…
I have the following models/tables: branch: id - integer department: id - integer teacher: id - integer branch_department_id - integer branch_department: id - integer branch_id - integer department_id - integer each branch has many departments through the pivot table branch_department…
Given a Dues and Payment Laravel Eloquent models with the following defined relationships: /** * Get the payment(s) for this set of dues */ public function payments() { return $this->hasMany(Payment::class); } /** * Get the Dues to which this payment…
I have theses tables : chevals : id name courses : id name horses_races : id cheval_id course_id For no french speakers, cheval = horse, and course = race. I want to make a relation ship between horses and races.…
I have class People extends Model { public function invoices() { return $this->hasMany(Invoice::class)->orderBy('date', 'desc'); } } ... class Invoice extends Model { public function person() { return $this->belongsTo(People::class, 'people_id'); } public function latestInvoice(){ return $this->hasOne(Invoice::class)->latestOfMany(); } } ... class Clerk…
I'm developing an application where a User can be of type Admin, Client, Supplier or Manager. Each type (except Admin) has it's own model with respective data, and related with a user_id. For example: users - id - name -…
I have two models, one for Company and one for Invoice. There is a one-to-many relationship as the company can have many invoices. I am now setting up the index page for the invoices, but in the index page, I…