public function setPriceInRangeForRoomType(Request $request)
{
$room_type = $request['room_type'];
$price = $request['price'];
$start_dt = $request['start_dt'];
$end_dt = $request['end_dt'];
$date = date("Y-m-d", strtotime($start_dt));
$base_room = RoomType::find($room_type);
$i = 0;
while (strtotime($date) <= strtotime($end_dt)) {
$room_day = RoomCalendar::firstOrNew(array('room_type_id' => $room_type, 'day' => $date));
if (!$room_day->id) {
$room_day->availability = $base_room->base_availability;
}
$room_day->rate = $price;
$room_day->save();
$date = date("Y-m-d", strtotime("+1 day", strtotime($date)));
$i++;
}
return response("Success updated " . $i . " dates", 200);
}
/**
* edit room tye info
*
* @param Request $request
* @return \Illuminate\Http\JsonResponse
*
*/
public function admin_edit_roomtype(Request $request)
{
$roomType = RoomType::find($request->input('id'));
$id = $request->input('id');
$rate = DB::select(DB::raw("select a.*,\n (select b.meal_type_name from MEAL_TYPES b where b.meal_type_id = a.meal_type_id) as meal\n from RATES a where a.room_type_id = '{$id}'"));
//RATE::where('room_type_id',$request->input('id'))->get();
$images = ROOM_IMAGE::where('room_type_id', $request->input('id'))->get();
$rf = RoomTypeFurnish::where('room_type_id', $request->input('id'))->get();
$rs = RoomTypeService::where('room_type_id', $request->input('id'))->get();
return response()->json(['info' => $roomType, 'images' => $images, 'rs' => $rs, 'rf' => $rf, 'rate' => $rate]);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$roomType = RoomType::find($id);
$roomType->delete();
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index($roomTypeId)
{
return response()->json(RoomType::find($roomTypeId)->rooms);
}
