/** * Display a listing of rateinquiries * * @return Response */ public function index() { //RateInquiry::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'); $rateinquiries = RateInquiry::whereHas('user', function ($q) use($user_id) { $q->where('users.id', 'like', '%' . $user_id . '%'); }); } elseif (Entrust::hasRole('Agent')) { $rateinquiries = RateInquiry::whereHas('user', function ($q) { $q->where('users.id', '=', Auth::id()); }); } if (!empty($from) && !empty($to)) { $rateinquiries = $rateinquiries->where('from', '>=', $from)->where('to', '<=', $to); } $rateinquiries = $rateinquiries->get(); } else { if (Entrust::hasRole('Admin')) { $rateinquiries = RateInquiry::orderBy('updated_at', 'desc')->get(); } elseif (Entrust::hasRole('Agent')) { $rateinquiries = RateInquiry::where('user_id', Auth::id())->orderBy('updated_at', 'desc')->get(); } } return View::make('inquiries.rate-inquiries.index', compact('rateinquiries', 'user_id', 'from', 'to')); }