/** * Display a listing of allotmentinquiries * * @return Response */ public function index() { //AllotmentInquiry::where('viewed', 0)->where('status', 1)->update(array('viewed'=> 1)); $from = null; $to = null; if (Input::has('search')) { //dd(Input::all()); $from = Input::get('from'); $to = Input::get('to'); if (Entrust::hasRole('Admin')) { $user_id = Input::get('agent_id'); $allotmentinquiries = AllotmentInquiry::whereHas('user', function ($q) use($user_id) { $q->where('users.id', 'like', '%' . $user_id . '%'); }); } elseif (Entrust::hasRole('Agent')) { $allotmentinquiries = AllotmentInquiry::whereHas('user', function ($q) { $q->where('users.id', '=', Auth::id()); }); } if (!empty($from) && !empty($to)) { $allotmentinquiries = $allotmentinquiries->where('from', '>=', $from)->where('to', '<=', $to); } $allotmentinquiries = $allotmentinquiries->get(); } else { if (Entrust::hasRole('Admin')) { $allotmentinquiries = AllotmentInquiry::orderBy('updated_at', 'desc')->get(); } elseif (Entrust::hasRole('Agent')) { $allotmentinquiries = AllotmentInquiry::where('user_id', Auth::id())->orderBy('updated_at', 'desc')->get(); } } return View::make('inquiries.allotment-inquiries.index', compact('allotmentinquiries', 'user_id', 'from', 'to')); }
public function getConfirmedInquiries() { $allotment_inquiries = null; $rate_inquiries = null; $rInq = RateInquiry::where('status', 1)->where('viewed', 0)->where('user_id', Auth::id())->get(); $aInq = AllotmentInquiry::where('status', 1)->where('viewed', 0)->where('user_id', Auth::id())->get(); $inquiry_count = $rInq->count() + $aInq->count(); // dd($rInq); if ($rInq->count()) { $rate_inquiries = []; foreach ($rInq as $inq) { $rate_inquiries[] = ['id' => $inq->id, 'hotel' => $inq->hotel->name, 'room_type' => $inq->roomType->room_type, 'meal_basis' => $inq->mealBasis->meal_basis, 'room_specification' => $inq->roomSpecification->room_specification, 'from' => $inq->from, 'to' => $inq->to, 'rateinquiries_url' => URL::to('inquiries/rate-inquiries')]; } } if ($aInq->count()) { $allotment_inquiries = []; foreach ($rInq as $inq) { $inq[] = ['id' => $aInq->id, 'hotel' => $aInq->hotel->name, 'room_type' => $aInq->roomType->room_type, 'from' => $aInq->from, 'to' => $aInq->to]; } } $inquiries = ['rate_inquiries' => $rate_inquiries, 'allotment_inquiries' => $allotment_inquiries, 'inquiry_count' => $a = $inquiry_count == 0 ? null : $inquiry_count]; return Response::json($inquiries); }