tested in laravel 4.2 for belongsToMany relationships if you’re in the model: //copy attributes $new = $this->replicate(); //save model before you recreate relations (so it has an id) $new->push(); //reset relations on EXISTING MODEL (this way you can control which ones will be loaded $this->relations = []; //load relations on EXISTING MODEL $this->load(‘relation1′,’relation2’); //re-sync everything … Read more
You’re already doing it! save() will check if something in the model has changed. If it hasn’t it won’t run a db query. Here’s the relevant part of code in Illuminate\Database\Eloquent\Model@performUpdate: protected function performUpdate(Builder $query, array $options = []) { $dirty = $this->getDirty(); if (count($dirty) > 0) { // runs update query } return true; … Read more
You can only do a withCount() on a defined relation of the model. However, a relationship can be hasManyThrough which would achieve what you are after. class Tutorial extends Model { function chapters() { return $this->hasMany(‘App\Chapter’); } function videos() { return $this->hasManyThrough(‘App\Video’, ‘App\Chapter’); } } And then you can do: Tutorial::withCount([‘chapters’, ‘videos’]) Docs: https://laravel.com/docs/5.3/eloquent-relationships#has-many-through
In terms of performance you can’t really optimize anything here (except if you were to move from eloquent relations to joins). With or without whereHas, two queries will be run. One to select all users another one to load the related models. When you add the whereHas condition a subquery is added, but it’s still … Read more
Faced same problem with laravel 5.3 They are trying to enforce strict query writing came with mysql-5.7 However to disabled this just go to config/database.php and change strict flag ‘mysql’ => [ . . . ‘strict’ => false, //’strict’ => true, . . ], Hope this will solve your problem too. PS – For details … Read more
You’ll have to add multiple whereHas for that: $query = User::with(‘activities’); foreach($selectedActivities as $activityId){ $query->whereHas(‘activities’, function($q) use ($activityId){ $q->where(‘id’, $activityId); }); } $userByActivities = $query->get();
Since Laravel 4.1, inside your model (in this case Company and People) you can set the protected property $morphClass to whatever you want. <?php namespace Lion; class Company extends \Eloquent { protected $morphClass=”Company”; } Now in your table you can store the type without the namespace: | id | realatable_type | relatable_id | 2 | … Read more
Instead of creating two records use a new function. public function friends() { return $this->belongsToMany(‘User’, ‘friend_user’, ‘user_id’, ‘friend_id’); } // Same table, self referencing, but change the key order public function theFriends() { return $this->belongsToMany(‘User’, ‘friend_user’, ‘friend_id’, ‘user_id’); } //You can then call opposite record(s) using: foreach( Auth::user()->theFriends as $theFriends ) I used this approach … Read more
Lets take a different approach in solving your problem. First lets setup relationship for the various models respectively. class User extends Model { public function agentProfile() { return $this->hasOne(AgentProfile::class); } public function institutionProfile() { return $this->hasOne(InstitutionProfile::class); } public function schoolProfile() { return $this->hasOne(SchoolProfile::class); } public function academyProfile() { return $this->hasOne(AcademyProfile::class); } // create scope to … Read more
Like the docs say: Insert, update, delete “You may also use the create method to save a new model in a single line. The inserted model instance will be returned to you from the method. However, before doing so, you will need to specify either a fillable or guarded attribute on the model, as all … Read more