/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $user = Auth::user(); $qb = ReferralInformation::orderBy('created_at', 'DESC'); AddressHelper::addAddressQueryScope($qb); if ($request->has('search')) { if ($request->has('search.keyword')) { $qb->where(function ($query) use($request) { $query->orWhere('name', 'LIKE', '%' . $request->input('search.keyword') . '%')->orWhere('contact_number', 'LIKE', '%' . $request->input('search.keyword') . '%')->orWhere('other_contact_number', 'LIKE', '%' . $request->input('search.keyword') . '%')->orWhere('name', 'LIKE', '%' . $request->input('search.keyword') . '%')->orWhere('email', 'LIKE', '%' . $request->input('search.keyword') . '%')->orWhere('address', 'LIKE', '%' . $request->input('search.keyword') . '%')->orWhere('province_name', 'LIKE', '%' . $request->input('search.keyword') . '%')->orWhere('city_name', 'LIKE', '%' . $request->input('search.keyword') . '%')->orWhere('subdistrict_name', 'LIKE', '%' . $request->input('search.keyword') . '%'); }); } if ($request->has('search.agent')) { $qb->whereHas('user', function ($query) use($request) { $query->where('id', $request->input('search.agent')); }); } if ($request->input('search.status', 'all') != 'all') { $qb->where('status', $request->input('search.status')); } if ($request->input('search.followed_up', 'all') != 'all') { $followedUp = $request->input('search.followed_up') == 'yes'; $qb->where('followed_up', $followedUp); } } $agentOptions = []; if ($user->is('agent')) { $qb->where('user_id', $user->id); } elseif ($user->is('property_manager')) { $qb->where('province', $user->profile->province); } else { $agentOptions = AgentHelper::getAgentOptions(); } $referrals = $qb->paginate(50); $referrals->appends(['search' => $request->input('search')]); $statusOptions = ['all' => 'Status'] + ReferralInformation::getStatusOptions(); $followedUpOptions = ['all' => 'Follow Up Status', 'yes' => 'Followed Up', 'no' => 'Unfollowed Up']; return view('admin.referrals.index', ['referrals' => $referrals, 'statusOptions' => $statusOptions, 'followedUpOptions' => $followedUpOptions, 'agentOptions' => $agentOptions]); }