/** * Store a newly created rateinquiry in storage. * * @return Response */ public function store() { $validator = Validator::make($data = Input::all(), RateInquiry::$rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } $data->user_id = Auth::id(); if (RateInquiry::create($data)) { $hotel_users = DB::table('users')->leftJoin('hotel_user', 'users.id', '=', 'hotel_user.user_id')->where('hotel_user.hotel_id', $data->hotel_id)->get(); Mail::send('emails/rate-inquiry', function ($message) use($hotel_users, $data) { $message->subject('New Inquiry')->from('*****@*****.**', 'SriLankaHotels.Travel')->bcc('*****@*****.**', 'SriLankaHotels.Travel'); if (!empty($hotel_users)) { foreach ($hotel_users as $hotel_user) { $message->to($hotel_user->email, $hotel_user->first_name); } } }); } return Redirect::route('inquiries.rate-inquiries.index'); }
public function requestRate() { $st_date = Session::get('st_date'); $ed_date = Session::get('ed_date'); if (Auth::check()) { $user_id = Auth::user()->id; } if (Session::has('market')) { $market = Session::get('market'); } //dd($room_count); if (Input::has('room_refer_id')) { $room_identity = Input::get('room_refer_id'); $room_identity_array = explode("_", $room_identity); $hotel_id = $room_identity_array[0]; $room_type = $room_identity_array[1]; $room_specification = $room_identity_array[2]; $meal_basis = $room_identity_array[3]; $room_count = Session::get('room_count'); $request_rate = array('hotel_id' => $hotel_id, 'user_id' => $user_id, 'from' => $st_date, 'to' => $ed_date, 'room_specification_id' => $room_specification, 'room_type_id' => $room_type, 'meal_basis_id' => $meal_basis, 'room_count' => $room_count, 'market_id' => $market); $request_rate_id = RateInquiry::create($request_rate); return Response::json(true); } else { $hotel_id = Input::get('hotel_id'); $room_specification = Input::get('room_specification'); $room_type = Input::get('room_type'); $meal_basis = Input::get('meal_basis'); $room_count = Session::get('room_count'); $request_rate = array('hotel_id' => $hotel_id, 'user_id' => $user_id, 'from' => $st_date, 'to' => $ed_date, 'room_specification_id' => $room_specification, 'room_type_id' => $room_type, 'meal_basis_id' => $meal_basis, 'room_count' => $room_count, 'market_id' => $market); $request_rate_id = RateInquiry::create($request_rate); return Redirect::to('/reservations'); } }