public function insertPackage(Request $request)
 {
     $user = $request->session()->get('user');
     $categories = roomCategory::all();
     $buildings = buildingModel::where('landlordID', '=', $user[0]->ID)->get();
     return view('pages.insertPackage', array('user' => $user, 'buildings' => $buildings, 'categories' => $categories));
 }
Beispiel #2
0
 public function rentRoomVehicles(Request $request)
 {
     $user = $request->session()->get('user');
     if (is_null($user)) {
         return redirect()->action('MainController@index');
     } else {
         if ($user[0]->type == 'tenant') {
             //Gets building categories
             $buildingCategories = buildingCategory::all();
             //	$buildings = buildingModel::where('landlordID', '=', $user[0]->ID)->get();
             //return view('pages.landlordAddBuilding',  array('categories' => $categories,'user' => $user, 'buildings' => $buildings));
             //Gets buildings
             $buildings = buildingModel::where('created_at', '!=', '')->orderBy('created_at', 'DESC')->get();
             $buildingFacAr = array();
             foreach ($buildings as $building) {
                 //$buildingFacilities = buildingFacilityModel::where('buildingid', '=', $building->id)->get();
                 $buildingFacilities = buildingFacilityModel::where('buildingid', '=', $building->id)->get();
                 array_push($buildingFacAr, $buildingFacilities);
             }
             $Facilities = facilityModel::all();
             //return view('pages.landlordbuildings',  array('user' => $user, 'buildings' => $buildings));
             return view('pages.bestDeals', array('user' => $user, 'Facilities' => $Facilities, 'buildings' => $buildings, 'buildingCategories' => $buildingCategories, 'buildingFacilities' => $buildingFacAr));
         } else {
             return response()->view('pages.404', ['user' => $user], 404);
         }
     }
 }
Beispiel #3
0
 public function viewPackage(Request $request)
 {
     $user = $request->session()->get('user');
     //Gets buildings
     $buildings = buildingModel::where('landlordID', '=', $user[0]->ID)->get();
     //Gets packages of building
     $packages = packageModel::where('buildingid', '=', $buildings[0]->id)->get();
     //var_dump($packages[0]->id);
     return view('pages.landlordpackages', array('user' => $user, 'packages' => $packages, 'buildings' => $buildings));
 }
Beispiel #4
0
 public function rentRoomVehicles(Request $request)
 {
     $user = $request->session()->get('user');
     //Gets building categories
     //	$categories = buildingCategory::all();
     //	$buildings = buildingModel::where('landlordID', '=', $user[0]->ID)->get();
     //return view('pages.landlordAddBuilding',  array('categories' => $categories,'user' => $user, 'buildings' => $buildings));
     //Gets buildings
     $buildings = buildingModel::where('created_at', '!=', '')->orderBy('created_at', 'DESC')->get();
     //return view('pages.landlordbuildings',  array('user' => $user, 'buildings' => $buildings));
     return view('pages.bestDeals', array('user' => $user, 'buildings' => $buildings));
 }
Beispiel #5
0
 public function index(Request $request)
 {
     $user = $request->session()->get('user');
     $blockedUsers = UserLandlord::where('userStatus', '=', 1)->get();
     $building = buildingModel::orderBy('created_at', 'DESC')->paginate(3);
     foreach ($blockedUsers as $blockedUser) {
         $blocked = $blockedUser['id'];
     }
     if (!empty($blocked)) {
         $buildings = buildingModel::where('landlordID', '=', $blocked)->get();
     } else {
         $buildings = "";
     }
     return view('pages.index', array('user' => $user, 'buildings' => $buildings, 'building' => $building));
 }
Beispiel #6
0
 public function getAdvancedSearch(Request $request)
 {
     $error = False;
     if (isset($request['buildingName'])) {
         $buildingName = $request['buildingName'];
     } else {
         $buildingName = False;
         $error = True;
     }
     if ($error == False) {
         if (isset($request['buildingLocation'])) {
             $buildingLocation = $request['buildingLocation'];
         } else {
             $buildingLocation = False;
         }
         if (isset($request['buildingCat']) && $request['buildingCat'] != -1) {
             $buildingCat = $request['buildingCat'];
         } else {
             $buildingCat = False;
         }
         if (isset($request['buildingFacility']) && $request['buildingFacility'] != -1) {
             $buildingFacility = $request['buildingFacility'];
             //	var_dump($request['buildingFacility']);
         } else {
             $buildingFacility = False;
         }
         if (isset($request['checkIn']) && $request['checkIn'] != -1) {
             $checkIn = $request['checkIn'];
             //	var_dump($request['buildingFacility']);
         } else {
             $checkIn = False;
         }
         if (isset($request['checkOut']) && $request['checkOut'] != -1) {
             $checkOut = $request['checkOut'];
             //	var_dump($request['buildingFacility']);
         } else {
             $checkOut = False;
         }
         $buildings = buildingModel::where('buildingName', 'Like', $buildingName . '%')->Where(function ($query) use($buildingLocation, $buildingCat, $buildingFacility) {
             if ($buildingLocation) {
                 $query->where('buildingLocation', 'like', $buildingLocation . '%');
             }
             if ($buildingCat) {
                 $query->where('buildingCatID', 'like', $buildingCat . '%');
             }
         })->get();
         /**
         								 $buildingBooked = DB::table('tblbooking')
         										            ->join('tblbuilding', 'tblbooking.buildingID', '=', 'tblbuilding.id')
         										            ->join('tblbuildingcat', 'tblbuildingcat.id', '=', 'tblbuilding.buildingCatID')
         										            ->where('tblbooking.checkin','<=', $checkIn )
         										            ->where('tblbooking.checkOut','>=', $checkOut)
         										            ->where('tblbuildingcat.buildingCatName','!=', 'Appartment')
         										            ->where('tblbuildingcat.buildingCatName','!=', 'Hotel')
         										            ->select('tblbuilding.*')
         
         										            ->get();
         
         
         										          
         
         
         								$rooms = roomModel::all();
         
         
         
         
         								 $roomsBooked = DB::table('tblroombooking')
         										            ->join('tblbooking', 'tblroombooking.bookingid', '=', 'tblbooking.id')
         										            ->join('tblbuilding', 'tblbooking.buildingID', '=', 'tblbuilding.id')
         										            ->join('tblbuildingcat', 'tblbuildingcat.id', '=', 'tblbuilding.buildingCatID')
         										            ->join('tblroom', 'tblroom.buildingid', '=', 'tblbuilding.id')
         										            ->where('tblbooking.checkin','<=', $checkIn )
         										            ->where('tblbooking.checkOut','>=', $checkOut)
         										            ->where('tblbuildingcat.buildingCatName','!=', 'Bungalow')
         										            ->where('tblbuildingcat.buildingCatName','!=', 'House')
         										            ->where('tblbuildingcat.buildingCatName','!=', 'Villa')
         										            ->where('tblbuildingcat.buildingCatName','!=', 'Penthouse')
         										            ->select('tblroom.*')
         
         										            ->get();
         
         
         
         				        //   var_dump($roomsBooked);die;
         					  						  //$vehicleTrav =  array_diff($vehicles, $vehicleOccupiedTravel);
         					  						 	 		
           											//	  var_dump($vehicleOccupiedBooking);
         
         														//$vehicleBook =  array_diff($vehicles, $vehicleOccupiedBooking);
                              				  	
         	
         													$buildings = $this->removeFromArray($buildings, $buildingBooked);
         
         													$rooms = $this->removeFromArray($rooms, $roomsBooked);
         
         
         														//$vehicles = $this->removeFromArray($vehicles, $vehicleOccupiedBooking);
         							
         
         //var_dump($buildings);						
         													var_dump($building);die;
         
         //var_dump($request['buildingCat']);
         
         
         //var_dump($buildings);
         													
         **/
         return json_encode($buildings);
     }
 }
Beispiel #7
0
 private function getQueryVehicles(Request $request)
 {
     $initialised = false;
     $query = '';
     //Search by id
     if ($request['id'] != null) {
         $query = vehicleModel::where('id', '=', $request['id']);
         $initialised = true;
     }
     //Search by landlord
     if ($request['vehicleOwnerID'] != null && $initialised) {
         $query->where('vehicleOwnerID', '=', $request['vehicleOwnerID']);
     } else {
         if (!$initialised) {
             $query = vehicleModel::where('vehicleOwnerID', '=', $request['vehicleOwnerID']);
             $initialised = true;
         }
     }
     //Search by buildingcategory
     if ($request['category'] != null && $initialised) {
         $query->where('category', '=', $request['category']);
     } else {
         if (!$initialised) {
             $query = vehicleModel::where('vehicleCatID', '=', $request['category']);
             $initialised = true;
         }
     }
     //Search by desc
     if ($request['name'] != null && $initialised) {
         $query->where('name', 'LIKE', "%" . $request['name'] . "%");
     } else {
         if (!$initialised) {
             $query = vehicleModel::where('name', 'LIKE', "%" . $request['name'] . "%");
             $initialised = true;
         }
     }
     //Search by buildingcategory
     if ($request['numOfSeats'] != null && $initialised) {
         $query->where('numOfSeats', 'LIKE', "%" . $request['numOfSeats'] . "%");
     } else {
         if (!$initialised) {
             $query = buildingModel::where('numOfSeats', 'LIKE', "%" . $request['numOfSeats'] . "%");
             $initialised = true;
         }
     }
     //limit query
     if ($request['limit'] != null && $query != '') {
         $query->take($request['limit']);
     }
     $vehicles = $query->get();
     return $vehicles;
 }
 public function insertPackage(Request $request)
 {
     $user = $request->session()->get('user');
     if (is_null($user)) {
         return redirect()->action('MainController@index');
     } elseif ($user[0]->type == 'Landlord') {
         $categories = roomCategory::all();
         $buildings = buildingModel::where('landlordID', '=', $user[0]->id)->get();
         return view('pages.insertPackage', array('user' => $user, 'buildings' => $buildings, 'categories' => $categories));
     } else {
         return response()->view('pages.404', ['user' => $user], 404);
     }
 }
 public function getbuildingCat(Request $request)
 {
     $error = false;
     if (isset($request['building'])) {
         $buildingid = $request['building'];
     } else {
         $error = true;
         $buildingid = false;
     }
     $building = buildingModel::where('id', '=', $buildingid)->get();
     $buildingCatName = $building[0]->category->buildingCatName;
     json_encode($buildingCatName);
 }
Beispiel #10
0
 public function update(Request $request)
 {
     //$categories = buildingCategory::all();
     if (isset($request['buildingid']) && !empty($request['buildingid'])) {
         $buildingid = $request['buildingid'];
     }
     if (isset($request['buildingdesc']) && !empty($request['buildingdesc'])) {
         $buildingdesc = $request['buildingdesc'];
     }
     if (isset($request['buildingLocation']) && !empty($request['buildingLocation'])) {
         $buildingLocation = $request['buildingLocation'];
     }
     // Retrieve use session
     $user = $request->session()->get('user');
     //Save building for user
     $building = buildingModel::find($buildingid);
     $building->buildingLocation = $buildingLocation;
     $building->desc = $buildingdesc;
     $building->save();
     Session::flash('success', 'Building successfully updated');
     print json_encode(array(1));
 }
Beispiel #11
0
 public function register(Request $request)
 {
     $user = $request->session()->get('user');
     if (is_null($user)) {
         return false;
     }
     $error = false;
     $status = array('success' => 0, 'msg' => 'Error occured');
     $user = $request->session()->get('user');
     $building = buildingModel::where("id", '=', $request['buildingId'])->first();
     $buildingCat = buildingCategory::where('id', '=', $building->buildingCatID)->get();
     if (isset($request['date10']) && !empty($request['date10'])) {
         $date10Obj = $request['date10'];
     } else {
         $error = true;
     }
     if (isset($request['date11']) && !empty($request['date11'])) {
         $date11Obj = $request['date11'];
     } else {
         $error = true;
     }
     if (isset($request['packages']) && !empty($request['packages'])) {
         //$packageObj = $request['package'];
         //$package = packageModel::find ($request['package']);
         if ($buildingCat[0]->buildingCatName == "Hotel" || $buildingCat[0]->buildingCatName == "Appartment") {
             $bookings = bookingModel::where('tenantID', "=", $user[0]->id)->where('checkin', '>=', $date10Obj)->where('checkout', '<=', $date11Obj)->get();
             if (sizeof($bookings) > 0) {
                 $status['msg'] = "Booking conflict has been detected for the period " . $date10Obj . " - " . $date11Obj;
                 return $status;
             } else {
                 //Check if all rooms available in this package
                 $buildingId = $request['buildingId'];
                 $error = false;
                 $roomPackage = array();
                 foreach ($request['packages'] as $packaged) {
                     if (isset($packaged['package'])) {
                         $idpackage = $packaged['package'];
                         $child = $packaged['child'];
                         $adult = $packaged['adult'];
                         $roomsNum = $packaged['room'];
                         $package = packageModel::find($idpackage);
                         //var_dump($packaged->id);
                         $rooms = DB::table('tblroom')->select(DB::raw('*'))->where('buildingid', '=', $buildingId)->where('roomCatID', '=', $package->roomCategoryID)->get();
                         $roomsub = DB::table('tblroombooking')->join('tblroom', 'tblroombooking.roomId', '=', 'tblroom.id')->join('tblbooking', 'tblroombooking.bookingId', '=', 'tblbooking.id')->where('tblroom.roomCatID', '=', $package->roomCategoryID)->where('tblroom.buildingID', '=', $buildingId)->where('tblbooking.checkin', '>=', $date10Obj)->where('tblbooking.checkOut', '<=', $date11Obj)->select('tblroom.*')->get();
                         if (!empty($rooms) && !empty($roomsub)) {
                             $roomsAvailable = array_diff($rooms, $roomsub);
                         } else {
                             if (!empty($rooms)) {
                                 $roomsAvailable = $rooms;
                             } else {
                                 if (!empty($roomsub)) {
                                     $roomsAvailable = array();
                                 } else {
                                     $roomsAvailable = array();
                                 }
                             }
                         }
                         if (isset($roomsNum) && $roomsNum > 0 && $roomsNum <= count($roomsAvailable)) {
                             $roomPackage[$idpackage] = $roomsAvailable;
                             //success
                         } else {
                             if ($roomsNum == 0 && $roomsNum > count($roomsAvailable)) {
                                 $error = true;
                                 $status['msg'] = "No selected room ";
                             } else {
                                 if ($roomsNum > 0 && $roomsNum > count($roomsAvailable)) {
                                     $error = true;
                                     $status['msg'] = "Not enough rooms for the period " . $date10Obj . " - " . $date11Obj . "  for package" . $package->packageName;
                                 } else {
                                     $error = true;
                                     $status['msg'] = "Error ";
                                 }
                             }
                         }
                     }
                 }
                 //iF ALL ROOMS AVAILABLE AND NO ERROR INSERT INTO BOOKING
                 //INSERT INTO ROOMBOOKING
                 if (!$error) {
                     $booking = new bookingModel();
                     $booking->checkin = $date10Obj;
                     $booking->checkOut = $date11Obj;
                     $booking->tenantID = $user[0]->id;
                     $booking->buildingID = $request['buildingId'];
                     $booking->save();
                     $price = 0;
                     foreach ($request['packages'] as $packaged) {
                         if (isset($packaged['package'])) {
                             $idpackage = $packaged['package'];
                             $child = $packaged['child'];
                             $adult = $packaged['adult'];
                             $roomsNum = $packaged['room'];
                             $roomPackage[$idpackage];
                             $package = packageModel::find($idpackage);
                             //insert into booking package
                             $bookingpackage = new bookingPackageModel();
                             $bookingpackage->booking_id = $booking->id;
                             $bookingpackage->package_id = $idpackage;
                             $bookingpackage->save();
                             //insert into roombooking
                             $availablerooms = $roomPackage[$idpackage];
                             for ($i = 0; $i < $roomsNum; $i++) {
                                 $roomBookingModel = new roomBookingModel();
                                 $roomBookingModel->roomId = $availablerooms[$i]->id;
                                 $roomBookingModel->bookingId = $booking->id;
                                 $roomBookingModel->save();
                             }
                             $priceArr = $booking->getPrice($package, $booking);
                             $price += (double) $priceArr['days'] * ($priceArr['child'] * $child + $adult * $priceArr['adult']);
                         }
                     }
                     $booking->price = $price;
                     $booking->save();
                     $status['success'] = 1;
                     $status['msg'] = "Booking successfully registered";
                     if (count($request['block-vehicle']) > 0) {
                         foreach ($request['block-vehicle'] as $blockVehicle) {
                             if (isset($blockVehicle)) {
                                 $vehicle = $blockVehicle['vehicle'];
                                 $travelModel = new travelModel();
                                 $travelModel->bookingID = $booking->id;
                                 $travelModel->vehicleID = $vehicle;
                                 $travelModel->dispach = $blockVehicle['dispatch'];
                                 $travelModel->pickUpTime1 = $booking->checkin;
                                 $travelModel->pickUpLocation1 = $user[0]->Address;
                                 $travelModel->pickUpDestination1 = $booking->building->buildingLocation;
                                 if ($travelModel->dispach == 'true') {
                                     $travelModel->pickUpTime2 = $booking->checkOut;
                                     $travelModel->pickUpLocation2 = $booking->building->buildingLocation;
                                     $travelModel->pickUpDestination2 = $user[0]->Address;
                                 }
                                 $travelModel->save();
                             }
                         }
                     }
                 }
             }
         } else {
             $bookings = bookingModel::where('tenantID', '=', $user[0]->id)->where('checkin', '>=', $date10Obj)->where('checkout', '<=', $date11Obj)->get();
             if (!$error) {
                 if (sizeof($bookings) > 0) {
                     $status['msg'] = "Booking conflict has been detected for the period " . $date10Obj . " - " . $date11Obj;
                 } else {
                     $booking = new bookingModel();
                     $booking->checkin = $date10Obj;
                     $booking->checkOut = $date11Obj;
                     $booking->tenantID = $user[0]->id;
                     $booking->buildingID = $request['buildingId'];
                     $booking->save();
                     $price = 0;
                     foreach ($request['packages'] as $packaged) {
                         if (isset($packaged['package'])) {
                             //Access array packaged key pacakges, ie:number of selected packages
                             $idpackage = $packaged['package'];
                             $child = $packaged['child'];
                             $adult = $packaged['adult'];
                             $package = packageModel::find($idpackage);
                             $price += $booking->getPrice($package, $booking);
                             //Add to booking
                             $bookingpackage = new bookingPackageModel();
                             $bookingpackage->booking_id = $booking->id;
                             $bookingpackage->package_id = $idpackage;
                             $bookingpackage->save();
                         }
                     }
                     //update price in booking
                     $booking->price = $price;
                     $booking->save();
                     $status['success'] = 1;
                     $status['msg'] = "Booking successfully registered";
                     if (!empty($request['block-vehicle'])) {
                         foreach ($request['block-vehicle'] as $blockVehicle) {
                             if (isset($blockVehicle)) {
                                 $vehicle = $blockVehicle['vehicle'];
                                 $travelModel = new travelModel();
                                 $travelModel->bookingID = $booking->id;
                                 $travelModel->vehicleID = $vehicle;
                                 $travelModel->dispach = $blockVehicle['dispatch'];
                                 $travelModel->pickUpTime1 = $booking->checkin;
                                 $travelModel->pickUpLocation1 = $user[0]->Address;
                                 $travelModel->pickUpDestination1 = $booking->building->buildingLocation;
                                 if ($travelModel->dispach == 'true') {
                                     $travelModel->pickUpTime2 = $booking->checkOut;
                                     $travelModel->pickUpLocation2 = $booking->building->buildingLocation;
                                     $travelModel->pickUpDestination2 = $user[0]->Address;
                                 }
                                 $travelModel->save();
                             }
                         }
                     }
                 }
             }
         }
     }
     return $status;
 }