finder function

finder.php

$post = $request->all(); //Initialize the request
$test = DB::table('products')
->where('subcategory_id','=',$post['subcategory_id']);

if(isset($post['specification_id']) && !(isset($post['brand_id'])))
{
$query = $query->where('subspecification_id','=',$post['specification_id']);
}
elseif(!(isset($post['specification_id'])) && isset($post['brand_id']))
{
$query = $query->where('brand_id','=',$post['brand_id']);
}
else
{
$query = $query->where('subspecification_id','=',$post['specification_id'])
->where('brand_id','=',$post['brand_id']);
}

$test = $test->get();