search; $list = PointQueueLog::getList($search) ->orderBy('id', 'desc') ->paginate(); $pager = PaginationHelper::show($list->total(), $list->currentPage(), $list->perPage()); return view('point.queueLog', [ 'list' => $list, 'pager' => $pager, 'search' => $search ]); } public function parentIndex() { $search = request()->search; $query = ParentRewardLog::uniacid()->where('expect_reward_time', '<>', 0) ->with([ 'hasOneOrder' => function ($query) { $query->select('id', 'order_sn', 'uid')->with(['belongsToMember' => function ($query) { $query->select('uid', 'nickname', 'avatar'); }]); }, 'hasOneMember' => function ($query) { $query->select('uid', 'nickname', 'avatar'); }, ])->orderBy('id', 'DESC'); if ($search['status'] || $search['status'] === '0' || $search['status'] === 0) { $query->where('status', $search['status']); } if ($search['order_sn']) { $query->whereHas('hasOneOrder', function ($query) use ($search) { $query->where('order_sn', 'like', "%{$search['order_sn']}%"); }); } if ($search['uid']) { $query->where('uid', $search['uid']); } if ($search['member_kwd']) { $query->whereHas('hasOneMember', function ($query) use ($search) { $query->where('nickname', 'like', "%{$search['member_kwd']}%") ->orWhere('mobile', 'like', "%{$search['member_kwd']}%") ->orWhere('realname', 'like', "%{$search['member_kwd']}%"); }); } $list = $query->paginate(); $pager = PaginationHelper::show($list->total(), $list->currentPage(), $list->perPage()); return view('point.parentQueueLog', [ 'list' => $list, 'pager' => $pager, 'search' => $search ]); } }