public function getSearch(Request $request) { // $userid = $request->input('userid', ''); $pid = $request->input('pid', ''); $start = $request->input('start', ''); $end = $request->input('end', ''); $warn_type = $request->input('warn_type', ''); $set = Member::join('data_warn_save', 'data_warn_save.userid', '=', 'member.id')->select('*')->addSelect('member.userid'); if ($warn_type) { $set = $set->where('data_warn_save.type', '=', $warn_type); } if ($pid) { $set = $set->where('member.pid', 'like', '%' . $pid . '%'); } if ($start) { $set = $set->where('data_warn_save.time', '>=', strtotime($start)); } if ($end) { $set = $set->where('data_warn_save.time', '<', strtotime($end) + 3600 * 24); } if (\Auth::user()->user_type != 0) { $set = $set->where('member.fid', '=', \Auth::user()->id); } return view('warning.index')->with(['items' => $set->paginate(10), 'warn_type' => $warn_type, 'pid' => $pid, 'start' => $start, 'end' => $end]); }
public function getSearch(Request $request) { $pid = $request->input('pid', ''); $userid = $request->input('userid', ''); $saled = $request->input('saled', ''); $status = $request->input('status', ''); //$active = $request->input('check')[2]; //查时间数据库开销太大,故没加 $set = Member::join('product_ext', 'product_ext.pid', '=', 'member.pid')->select('*'); if ($pid) { $set = $set->where('member.pid', 'like', '%' . $pid . '%'); } if ($userid) { $set = $set->where('member.userid', 'like', '%' . $userid . '%'); } if ($saled != '') { $set = $set->where('saled', $saled); } if ($status != '') { $set = $set->where('member.status', $status); } if (\Auth::user()->user_type != 0) { $set = $set->where('fid', '=', \Auth::user()->id); } return view('watch.index')->with(['items' => $set->paginate(10), 'pid' => $pid, 'userid' => $userid, 'saled' => $saled, 'status' => $status]); }