How to search for an item with relationships (SOLVED)

Can you post your models?

Product.php

class Product extends Model { protected $guarded = []; public function store() { return $this->belongsTo(Store::class); }

public function category()
{
    return $this->belongsTo(Category::class);
}

public function branch()
{
    return $this->hasMany(BranchInventory::class);
}

}

Branch.php

class Branch extends Model { protected $guarded = [];

public function store()
{
    return $this->belongsTo(Store::class);
}

public function branchInventory()
{
    return $this->hasMany(BranchInventory::class);
}

}

BranchInventory.php

class BranchInventory extends Model { protected $guarded = [];

public function branch()
{
    return $this->belongsTo(Branch::class);
}

public function product()
{
    return $this->belongsTo(Product::class);
}

}

I want to use branchesInventory branch_id and product_id to connect with branches table

Take a look on a recent topic on a similar question. https://laracasts.com/discuss/channels/eloquent/query-with-attributes-from-related-model

@MichalOravec 's answer will give you some clues about how to handle this.

THANK YOU! But am i doing this right?

    $city = 'Manila';
    foreach ($arr as $line) {
        $products[] = \App\Product::where('name', 'LIKE', '%' . $line . '%')
            ->whereHas('branch', function ($query) use ($city) {
                $query->whereHas('branch', function ($query) use ($city) {
                    $query->where('city', $city);
                });
            })
            ->get();
    }

@himala Yes it's exactly same think, so

$search = 'all purpose flour';

$city = 'Manilla';

$products = App\Product::where('name', 'LIKE', "%{$search}%")->whereHas('branch', function($query) use ($city) {
    $query->where('city', $city);
})->get()

Thank you so much!! I've been trying to figure this out for about 6 hours now. Thanks again!

@himala I think your whole code should be like this

$city = 'Manilla';

$products = App\Product::where(function ($query) use ($arr) {
    foreach ($arr as $line) {
        $query->orWhere('name', 'LIKE', "%{$line}%");
    }      
})->whereHas('branch', function($query) use ($city) {
    $query->where('city', $city);
})->get()

I tried to do that but it produces an error maybe because I have 'branch' function in my products that returns hasMany BranchInventory::class

which has the branch_id

and my BranchInventory has 'branch' function that returns hasMany 'Branch::class' so i can compare them with

branch_id from BranchInventory an the id from the Branch table. My naming convention is wrong

@himala It's up to you, could you mark this thread as solved? Thanks.

Thanks again!!