Esempio n. 1
0
 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index(Request $request)
 {
     $keyword = trim($request->input('keyword'));
     $field_date = trim($request->input('field_date')) ? 'desc' : 'asc';
     $field_today = trim($request->input('field_today')) ? true : false;
     // 在用户昵称, 手机号, 电子邮箱中查询关键字
     $feedbacks = Feedback::WhereHas('user', function ($query) use($keyword) {
         $query->where('nickname', 'like', "%{$keyword}%")->orWhere('cellphone', 'like', "%{$keyword}%")->orWhere('email', 'like', "%{$keyword}%");
     });
     // 在当天中查找记录
     if ($field_today) {
         $feedbacks->whereBetween('created_at', [Carbon::now()->startOfDay(), Carbon::now()->endOfDay()]);
     }
     // 按创建时间排序并分页
     $feedbacks = $feedbacks->orderBy('created_at', $field_date)->paginate(10);
     return view('feedback.index', compact('feedbacks'));
 }