'desc'],$pagesize=10) { $currentQuery = $this->model; if(isset($search['keyword']) && ! empty($search['keyword'])) { $keywords = '%' . $search['keyword'] . '%'; $currentQuery = $currentQuery->where(function ($query) use ($keywords) { $query->where('id' , 'like', $keywords) ->orwhere('name', 'like', $keywords); }); } $currentQuery = $currentQuery->where(function ($query) use ($search) { $query->where('store_id',$search['storeid']); }); if($orderby && is_array($orderby)){ foreach ($orderby AS $field => $value){ $currentQuery = $currentQuery -> orderBy($field, $value); } } $currentQuery = $currentQuery->paginate($pagesize); return $currentQuery; } }