public function addRoom(Request $request) { $user = $request->session()->get('user'); if (is_null($user)) { return redirect()->action('MainController@index'); } elseif ($user[0]->type == 'Landlord') { //Gets room categories $categories = roomCategory::all(); //Gets buildings $buildings = buildingModel::where('landlordID', '=', $user[0]->id)->get(); $facilities = facilityModel::all(); //Get rooms $rooms = roomModel::where('landlordID', '=', $user[0]->id)->get(); $AddRoomFacilities = roomModel::where('landlordID', '=', $user[0]->id)->get(); $roomFacAr = array(); foreach ($rooms as $room) { $roomFacilities = roomFacilityModel::where('roomid', '=', $room->id)->get(); // array_push($roomFacAr, $roomFacilities); } return view('pages.landlordAddRoom', array('categories' => $categories, 'user' => $user, 'roomFacilities' => $roomFacAr, 'buildings' => $buildings, 'facilities' => $facilities, 'rooms' => $rooms, 'AddRoomFacilities' => $AddRoomFacilities)); } else { return response()->view('pages.404', ['user' => $user], 404); } }
public function addRoom(Request $request) { $user = $request->session()->get('user'); //Gets room categories $categories = roomCategory::all(); //Gets buildings $buildings = buildingModel::where('landlordID', '=', $user[0]->ID)->get(); //Get rooms $rooms = roomModel::where('landlordID', '=', $user[0]->ID)->get(); return view('pages.landlordAddRoom', array('categories' => $categories, 'user' => $user, 'buildings' => $buildings, 'rooms' => $rooms)); }
public function delete(Request $request) { $user = $request->session()->get('user'); if (is_null($user)) { return false; } if ($request['id'] != null) { $buildings = buildingModel::where('id', '=', $request['id'])->delete(); // delete facilities $buildingFacilities = buildingFacilityModel::where("buildingid", "=", $request['id'])->delete(); //delete room //delete room facilities //delete room booking $rooms = roomModel::where("buildingID", "=", $request['id'])->get(); foreach ($rooms as $room) { roomFacilityModel::where("roomid", "=", $room->id)->delete(); roomBookingModel::where("roomid", "=", $room->id)->delete(); $room->delete(); } //delete packages $packages = packageModel::where("buildingid", "=", $request['id'])->delete(); //delete booking //delete travel $bookings = bookingModel::where("buildingID", "=", $request['id'])->get(); foreach ($bookings as $booking) { bookingPackageModel::where("booking_id", "=", $booking->id)->delete(); travelModel::where("bookingID", "=", $booking->id)->delete(); $booking->delete(); } } print json_encode(array()); }
function addRoomFacility(Request $request) { $user = $request->session()->get('user'); if (is_null($user)) { return false; } $error = 1; $messge = array(); if (isset($_REQUEST['ddlAddRoomFacility']) && !empty($_REQUEST['ddlAddRoomFacility'])) { $ddlAddRoomFacility = $_REQUEST['ddlAddRoomFacility']; } if (isset($_REQUEST['AddfacilityCheckboxes']) && !empty($_REQUEST['AddfacilityCheckboxes'])) { $AddfacilityCheckboxes = $_REQUEST['AddfacilityCheckboxes']; } $roomFacilities = roomFacilityModel::where('roomid', '=', $ddlAddRoomFacility)->get(); $facilities = array(); foreach ($AddfacilityCheckboxes as $facilityCheckbox) { $messgeTmp = array(); $facilityExists = $this->checkFacilityExists($roomFacilities, $facilityCheckbox); if (!empty($roomFacilities) && $facilityExists[0]) { $messgeTmp['status'] = -1; $messgeTmp['msg'] = $facilityExists[1] . " facility Already exists"; } else { $facility = new roomFacilityModel(); $facility->facilityid = $facilityCheckbox; $facility->roomid = $ddlAddRoomFacility; $facility->save(); $room = roomModel::where('id', '=', $ddlAddRoomFacility)->get(); $fac = facilityModel::where('id', '=', $facilityCheckbox)->get(); $facility['facility'] = $fac; $facility['room'] = $room; $messgeTmp['status'] = 1; $messgeTmp['msg'] = "Facility Successfully added"; $messgeTmp['facility'] = $facility; //return redirect()->action('LandlordController@addRoom'); array_push($facilities, $facility); } array_push($messge, $messgeTmp); } echo json_encode($messge); }