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]);
}
