public function search(Request $request) { $keyword = $request->input('keyword'); if ($keyword == '') { return []; } $dramas = Drama::select('id', 'title', 'alias', 'type', 'era', 'genre', 'original', 'count', 'state', 'sc')->where('title', 'LIKE', '%' . $keyword . '%')->orWhere('alias', 'LIKE', '%' . $keyword . '%')->get(); return $dramas; }
public function index(Request $request) { //数据库查询参数 $scope = []; //性向筛选 if ($request->has('type')) { $scope['type'] = ['=', $request->input('type')]; } //时代筛选 if ($request->has('era')) { $scope['era'] = ['=', $request->input('era')]; } //原创性筛选 if ($request->has('original')) { $scope['original'] = ['=', $request->input('original')]; } //进度筛选,结合state与count字段 if ($request->has('state')) { switch ($request->input('state')) { case 0: //连载中 $scope['state'] = ['=', 0]; break; case 1: //已完结 $scope['state'] = ['=', 1]; $scope['count'] = ['>', 1]; break; case 2: //全一期 $scope['state'] = ['=', 1]; $scope['count'] = ['=', 1]; break; case 3: //已坑 $scope['state'] = ['=', 2]; break; } } //主役筛选 if ($request->has('cv')) { $scope['sc'] = ['LIKE', '%' . $request->input('cv') . '%']; } //排序 if ($request->has('sort')) { $sort = $request->input('sort'); } else { $sort = 'id'; } if ($request->has('order')) { $order = $request->input('order'); } else { $order = 'desc'; } $dramas = Drama::select('id', 'title', 'alias', 'type', 'era', 'genre', 'original', 'count', 'state', 'sc')->multiwhere($scope)->orderBy($sort, $order)->simplePaginate(20); return $dramas; }
public function search(Request $request) { if ($request->input('title') != '') { $dramas = Drama::select('id', 'sc')->where('title', $request->input('title'))->get(); return $dramas; } }