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