Laravel search through relationship

Question

Going straight to the point here. I have a search functionality on my List of Items. However, I also want to search all items by category.

Here's what I have done so far. I am really new to laravel and eloquent so please bear with me.

Category Table

public function up()
{
    Schema::create('categories', function (Blueprint $table) {
        $table->increments('id');
        $table->string('code', 30);
        $table->string('name');
        $table->softDeletes();
        $table->timestamps();
    });
}

Item Table

public function up()
{
    Schema::create('items', function (Blueprint $table) {
        $table->increments('id');
        $table->integer('category_id')->unsigned();
        $table->string('code', 30);
        $table->string('name');
        $table->softDeletes();
        $table->timestamps();
    });

    Schema::table('items', function($table){
        $table->foreign('category_id')->references('id')->on('categories');
    });
}

Here's my code:

public function search(){
    $q = Input::get ( 'q' );
    if($q != ""){
        $items = Item::with('Category')
                    ->where ( 'name', 'LIKE', '%' . $q . '%' ) 
                    ->orWhere ( 'code', 'LIKE', '%' . $q . '%' )
                    ->whereHas('Category', function($cat){
                        $cat->where('name', 'hardware');
                    })->paginate(1)->setPath('');

        $items = $items->appends ( array (
                    'q' => Input::get ( 'q' ) 
            ) );
    }else{
        $items = Item::orderBy('id', 'desc')->paginate(10);
    }

    $softDeletesItems = Item::onlyTrashed()->get();
    return view('item.index', compact('items', 'softDeletesItems'));
}

is there a way for me to do a orWHere('category.name', 'LIKE', '%'. $q .'%')?

can you proviide both item and category table columns so we can check — Vision Coderz
– Vision Coderz, Commented Sep 28, 2017 at 3:37
->whereHas('Category', function($query) use($q){ $query->where('name', 'hardware')->orWHere('name', 'LIKE', '%'. $q .'%') — Vision Coderz
– Vision Coderz, Commented Sep 28, 2017 at 3:46
@iCoders yes sir is there a way for me to do a ->orWhere ( 'categories.name', 'LIKE', '%' . $q . '%' )? — Sam Teng Wong
– Sam Teng Wong, Commented Sep 28, 2017 at 3:47

Vision Coderz · Accepted Answer · 2017-09-28 03:54:01Z

2

->whereHas('Category', function($query) use($q){

                       $query->where('name', 'LIKE', '%'. $q .'%')

         })->paginate(1)->setPath('');

answered Sep 28, 2017 at 3:54

Vision Coderz

8,0786 gold badges40 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sam Teng Wong · Accepted Answer · 2017-09-28 03:58:52Z

2

Here's what I did to achieve it.

    $items = Item
            ::join('categories', 'items.category_id', '=', 'categories.id')
            ->where ( 'items.name', 'LIKE', '%' . $q . '%' ) 
            ->orWhere ( 'items.code', 'LIKE', '%' . $q . '%' )
            ->orWhere('categories.name', 'LIKE', '%' . $q . '%')
            ->select('*')
            ->paginate(1)->setPath('');

answered Sep 28, 2017 at 3:58

Sam Teng Wong

2,4495 gold badges38 silver badges58 bronze badges

Collectives™ on Stack Overflow

Laravel search through relationship

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related