samedi 8 juillet 2017

Pagination not working on multiple querying

I have a multiple query, but for some reason the pagination is not working, i dont no if the ussue is the way i construct it.

My code:

 $query = \DB::table('products');


   if ($request->has('type') && $type) {
        $query->where('product_type_id', $type);
    }

    if ($request->has('material') && $material) {
      $query->join("product_attribute_materials","products.id","=","product_attribute_materials.product_id")
        ->whereIn("product_attribute_materials.product_material_id", $material);
    }

    if($request->has('businessarea') && $area){
        $query->join("product_attribute_businessareas","products.id","=","product_attribute_businessareas.product_id")
        ->whereIn("product_attribute_businessareas.product_businessarea_id", $area);
    }

    $products = $query->paginate(15);



from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2uDIJkW
via IFTTT

Aucun commentaire:

Enregistrer un commentaire