CODEWITHSUNDEEP
phplaraveloctobercms
Osuji Kingsley
Osuji Kingsley

Reputation: 371

why is laravel eager loading constraint not working?

I have this as the basic of what i want to do but the constraint is not applying

$this['subs'] = Cat::with([
    'children' => function($query) {
        $query -> where('parent_id', 0);
    }
]) -> get();

Upvotes: 0

Views: 1697

Answers (3)

Hardik Satasiya
Hardik Satasiya

Reputation: 9693

you are using October CMS so you can just use traits nested-tree

docs : https://octobercms.com/docs/database/traits#nested-tree

class Cat extends Model
{
    use \October\Rain\Database\Traits\NestedTree;
}

Now

$model = Cat::where('slug', $param_slug)->first();

and then 

$model->getEagerRoot(); // Returns a list of all root nodes, with ->children eager loaded.
// OR
$model->getEagerChildren(); // Returns direct child nodes, with ->children eager loaded.

You can have ton of options

https://github.com/octobercms/library/blob/master/src/Database/Traits/NestedTree.php

/* General access methods:
 *
 *   $model->getRoot(); // Returns the highest parent of a node.
 *   $model->getRootList(); // Returns an indented array of key and value columns from root.
 *   $model->getParent(); // The direct parent node.
 *   $model->getParents(); // Returns all parents up the tree.
 *   $model->getParentsAndSelf(); // Returns all parents up the tree and self.
 *   $model->getChildren(); // Set of all direct child nodes.
 *   $model->getSiblings(); // Return all siblings (parent's children).
 *   $model->getSiblingsAndSelf(); // Return all siblings and self.
 *   $model->getLeaves(); // Returns all final nodes without children.
 *   $model->getDepth(); // Returns the depth of a current node.
 *   $model->getChildCount(); // Returns number of all children.
 *
 * Query builder methods:
 *
 *   $query->withoutNode(); // Filters a specific node from the results.
 *   $query->withoutSelf(); // Filters current node from the results.
 *   $query->withoutRoot(); // Filters root from the results.
 *   $query->children(); // Filters as direct children down the tree.
 *   $query->allChildren(); // Filters as all children down the tree.
 *   $query->parent(); // Filters as direct parent up the tree.
 *   $query->parents(); // Filters as all parents up the tree.
 *   $query->siblings(); // Filters as all siblings (parent's children).
 *   $query->leaves(); // Filters as all final nodes without children.
 *   $query->getNested(); // Returns an eager loaded collection of results.
 *   $query->listsNested(); // Returns an indented array of key and value columns.
 *
 * Flat result access methods:
 *
 *   $model->getAll(); // Returns everything in correct order.
 *   $model->getAllRoot(); // Returns all root nodes.
 *   $model->getAllChildren(); // Returns all children down the tree.
 *   $model->getAllChildrenAndSelf(); // Returns all children and self.
 *
 * Eager loaded access methods:
 *
 *   $model->getEagerRoot(); // Returns a list of all root nodes, with ->children eager loaded.
 *   $model->getEagerChildren(); // Returns direct child nodes, with ->children eager loaded.
 *
 */

please check it out its really fast and convenient way for parent and child relations.

if any doubt please comment.

Upvotes: 0

Fabián Montero Rodríguez
Fabián Montero Rodríguez

Reputation: 488

Do you have a cat with id = 0?

Try:

Cat::with('children')->find(0)

Supposing you have a cat with id = 0; this will return the cat with id = 0 and its children if has any.

Or:

Cat::has('children')->get()

This will return all the cats that have children.

Or:

Cat::with('children')->get()

This will return all cats and its children if has any

Upvotes: 0

Shuyi
Shuyi

Reputation: 916

the one you are looking for, is whereHas , like this: 


$this['subs'] = Cat::whereHas('children', function ($query) {
                  $query->where('parent_id',0);
               })->get();

putting a query in with just scopes the relationships it queries, not the record set cat itself.

Upvotes: 2

Related Questions