Level 14
// Model Product
$productObj = new Product;
$products = $productObj->where('status', '=',$status)
->where('collection', '=',$collection)
->where(function($query) use($product_category1,$product_category2){
// and (`product_category`= ? OR product_category=?)
$query->where('product_category', '=',$product_category1)
->orWhere('product_category', '=',$product_category2)
})
->where(function($query1)use ($data){
// and (`designer`=? OR `designer`=?)
// do same as above
})
->orderBy($columnName, $ascOrDesc)
->take($countTake)
->skip($countSkip)
->get();