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