i am casting an array [1,2] and in my model I have this setup protected $casts = [ 'skills' => 'array' ]; and I have my relationship setup like this public function skills(){ return $this->hasMany(Skill::class,'id'); } now my problem is…
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 a project using Laravel v9.19 and PHP 8.0. Here is a part of that project's database which is relevant to the question: One user can have many orders, but each order has only one user (one-to-many relationship).…
I am developing a database for giveaways. I have two main tables: participants and giveaways with an N:N relationship since a participant can participate to one or more giveaways and a giveaway can have one or more participants. My (simplified)…
I've got a requirement for a set of models with the same database table, but they need to implement certain methods in a different way. Given a set of classes like this: class Item { protected $table = 'items'; }…
I have a User and Lesson models. these models are not related to each other. users table: id, username, password, is_active lessons table: id, title User class User extends Modle { // code } Lesson class Lessosn extends Modle {…
I have set the connection to two databases properly. I also have created eloquent table models and I can query a single table relationship from another database easily e.g. $user->customer User model class User extends Model { protected $connection =…
I am developing a sort of multi-tenant application with Laravel 11 on PHP 8.3, where each "user" must belong to a "company". For user management, I started from Laravel Breeze, and then modified the users table to include a company_id…
I have two tables that are connected with a pivot table. shows: +----+--------+ | id | show | +----+--------+ | 1 | show1 | | 2 | show2 | | 3 | show3 | +----+--------+ draft_types: +----+--------+ | id |…
I have an eloquent query: $cameras=Jump::Video() ->with('flight','flight.aircraft','flight.airfield') ->with('student','student.logininfo','student.logininfo.reservations') ->with('camera','camera.status') ->whereBetween('data',[ $from, $to]) ->orderBy($sortBy, $orderDesc) ->paginate($request->perPage); and relations between student, logininfo and reservations Model Jump.php public function scopeVideo($query) { return $query->where('exercise', '104'); } public function student() { return $this->hasOne('AppModelsPersonalData','id','student'); } Model…