This is how you can do it: User::where(‘id’, $id)->with([‘groups.permissions’ => function ($q) use (&$permissions) { $permissions = $q->get()->unique(); }])->first(); // then $permissions; // collection of unique permissions of the user with id = $id
You could add a raw query and do something like this: Model::orderBy(DB::raw(‘LENGTH(text), text’)); Or, in modern versions of Laravel: Model::orderByRaw(‘LENGTH(text), text’);
To clarify something: paginating eager-loaded relationships is somewhat of a misconception. The point of eager loading is to retrieve all relationships in as few queries as you can. If you want to retrieve 10 topics, all of which have 35 posts, you will only need two queries. Sweet! That said, paginating an eager-loaded relationship is … Read more
You should use with(‘children’) in the children relation and with(‘parent’) in the parent relations. For your code to be recursive: public function parent() { return $this->belongsTo(‘App\CourseModule’,’parent_id’)->where(‘parent_id’,0)->with(‘parent’); } public function children() { return $this->hasMany(‘App\CourseModule’,’parent_id’)->with(‘children’); } Note: Make sure your code has some or the other exit conditions otherwise it will end up in a never ending … Read more
Eager loading uses separate queries so you need join for this: $products = Shop\Product::join(‘shop_products_options as po’, ‘po.product_id’, ‘=’, ‘products.id’) ->orderBy(‘po.pinned’, ‘desc’) ->select(‘products.*’) // just to avoid fetching anything from joined table ->with(‘options’) // if you need options data anyway ->paginate(5); SELECT clause is there in order to not appending joined columns to your Product model. … Read more
Heres the magic behind the scenes… /** * Save the model and all of its relationships. * * @return bool */ public function push() { if ( ! $this->save()) return false; // To sync all of the relationships to the database, we will simply spin through // the relationships and save each model via this … Read more
User::all() and User::get() will do the exact same thing. all() is a static method on the Eloquent\Model. All it does is create a new query object and call get() on it. With all(), you cannot modify the query performed at all (except you can choose the columns to select by passing them as parameters). get() … Read more
Perhaps this was not possible a few years ago but in recent versions of Laravel you can definitely do: User::where(‘age’, ‘<‘, 18)->update([‘under_18’ => 1]); Worth noting that you need the where method before calling update.
I think that this is the correct way: class Game extends Eloquent { // many more stuff here // relation without any constraints …works fine public function videos() { return $this->hasMany(‘Video’); } // results in a “problem”, se examples below public function available_videos() { return $this->videos()->where(‘available’,’=’, 1); } } And then you’ll have to $game … Read more
You can use toArray() of eloquent as below. The toArray method converts the collection into a plain PHP array. If the collection’s values are Eloquent models, the models will also be converted to arrays $comments_collection = $post->comments()->get()->toArray() From Laravel Docs: toArray also converts all of the collection’s nested objects that are an instance of Arrayable … Read more