/** * Display a listing of the SisterDownloadApp. * GET|HEAD /sisterDownloadApps * * @return Response */ public function index(Request $request) { $offset = $request->page ? $request->page : 1; $limit = $request->limit ? $request->limit : 12; $isAllow = $request->isAllow ? $request->isAllow : ''; $offset = ($offset - 1) * $limit; if ($isAllow && $isAllow != '') { $posts = SisterDownloadApp::where('isAllow', $isAllow)->orderBy('id', 'desc')->offset($offset)->limit($limit)->get(); } else { $posts = SisterDownloadApp::orderBy('id', 'desc')->offset($offset)->limit($limit)->get(); } return response()->json($posts); }
public function search($input) { $query = SisterDownloadApp::query(); $columns = Schema::getColumnListing('sisterDownloadApps'); $attributes = array(); foreach ($columns as $attribute) { if (isset($input[$attribute]) and !empty($input[$attribute])) { $query->where($attribute, $input[$attribute]); $attributes[$attribute] = $input[$attribute]; } else { $attributes[$attribute] = null; } } return [$query->get(), $attributes]; }