public function addVehicle(Request $request)
{
//saves user sesssion in $user to be used in the redirected page
$user = $request->session()->get('user');
//Gets vehicles categories
$categories = vehicleCategory::all();
$vehicles = vehicleModel::where('vehicleOwnerID', '=', $user[0]->id)->get();
return view('pages.vehicleOwnerAddVehicle', array('categories' => $categories, 'user' => $user, 'vehicles' => $vehicles));
}
public function update(Request $request)
{
//$categories = buildingCategory::all();
$color = "";
$vehicleid = "";
$error = false;
if (isset($request['color']) && !empty($request['color'])) {
$color = $request['color'];
}
if (isset($request['vehicleid']) && !empty($request['vehicleid'])) {
$vehicleid = $request['vehicleid'];
}
// Retrieve use session
$user = $request->session()->get('user');
//Save vehicle for user
$vehicle = vehicleModel::find($vehicleid);
$vehicle->color = $color;
$vehicle->save();
Session::flash('success', 'vehicle successfully updated');
print json_encode(array(1));
}
public function getVehicleAdvancedSearch(Request $request)
{
$error = False;
if (isset($request['vehicleName'])) {
$vehicleName = $request['vehicleName'];
}
if (isset($request['vehicleCategory']) && $request['vehicleCategory'] != -1) {
$vehicleCategory = $request['vehicleCategory'];
} else {
$vehicleCategory = False;
}
if (isset($request['driver']) && $request['driver'] != -1) {
$driver = $request['driver'];
// var_dump($request['buildingFacility']);
} else {
$driver = False;
}
if (isset($request['price'])) {
$price = $request['price'];
// var_dump($request['buildingFacility']);
} else {
$price = False;
}
if (isset($request['transmission']) && $request['transmission'] != -1) {
if ($request['transmission'] == 0) {
$transmission = "Automatic";
} else {
$transmission = "Manual";
}
// var_dump($request['buildingFacility']);
} else {
$transmission = False;
}
if (isset($request['numberOfSeats']) && $request['numberOfSeats'] != -1) {
$numberOfSeats = $request['numberOfSeats'];
// var_dump($request['buildingFacility']);
} else {
$numberOfSeats = False;
}
if (isset($request['checkIn'])) {
$checkIn = $request['checkIn'];
} else {
$checkIn = False;
}
if (isset($request['checkOut'])) {
$checkout = $request['checkOut'];
// var_dump($request['buildingFacility']);
} else {
$checkout = False;
}
$vehicleAvailable = '';
$vehicles = vehicleModel::where('vehicleName', 'Like', $vehicleName . '%')->Where(function ($query) use($vehicleCategory, $driver, $transmission, $price, $numberOfSeats, $vehicleAvailable) {
if ($vehicleCategory) {
$query->where('vehicleCatID', 'like', $vehicleCategory . '%');
}
if ($driver) {
$query->where('driver', 'like', $driver . '%');
}
if ($transmission) {
$query->where('transmission', 'like', $transmission . '%');
}
if ($price) {
$query->where('price', 'like', $price . '%');
}
if ($numberOfSeats) {
$query->where('numOfSeats', 'like', $numberOfSeats . '%');
}
})->get();
$vehicleOccupiedTravel = DB::table('tbltravel')->join('tblvehicle', 'tbltravel.vehicleID', '=', 'tblvehicle.id')->where('tbltravel.pickUpTime1', '<=', $checkIn)->where('tbltravel.pickUpTime2', '>=', $checkout)->select('tblvehicle.*')->get();
/*$vehicleOccupiedBooking = DB::table('tblvehiclebooking')
->join('tblvehicle', 'tblvehiclebooking.vehicleid', '=', 'tblvehicle.id')
->where('tblvehiclebooking.fromdate', '<=', $checkIn)
->where('tblvehiclebooking.todate','>=', $checkout)
->select('tblvehicle.*')
->get();*/
$vehicleOccupiedBooking = DB::table('tblvehiclebooking')->join('tblvehicle', 'tblvehiclebooking.vehicleid', '=', 'tblvehicle.id')->where('tblvehiclebooking.fromdate', '<=', $checkIn)->where('tblvehiclebooking.todate', '>=', $checkout)->select('tblvehicle.*')->get();
//$vehicleTrav = array_diff($vehicles, $vehicleOccupiedTravel);
// var_dump($vehicleOccupiedBooking);
//$vehicleBook = array_diff($vehicles, $vehicleOccupiedBooking);
$vehicles = $this->removeFromArray($vehicles, $vehicleOccupiedTravel);
//var_dump($buildings);
// var_dump(count($vehicles));
$vehicles = $this->removeFromArray($vehicles, $vehicleOccupiedBooking);
// var_dump(count($vehicles));
// die;
//die;
return json_encode($vehicles);
}
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 bookVehicles(Request $request)
{
$user = $request->session()->get('user');
if (is_null($user)) {
return redirect()->action('MainController@index');
} else {
if ($user[0]->type == 'tenant') {
// /var_dump($request['date10']);
// $numDays = $fromDate->diff($toDate)->format("%a");
// $numhours = $fromDate->diff($toDate)->format("%h");
// var_dump($request['vehicleid']);
if (isset($request['vehicleid']) && !empty($request['vehicleid'])) {
$vehicleid = $request['vehicleid'];
}
if (isset($request['date10']) && !empty($request['date10'])) {
$fromDate = new \DateTime($request['date10']);
}
if (isset($request['date11']) && !empty($request['date11'])) {
$toDate = new \DateTime($request['date11']);
}
if (isset($request['lattitude']) && !empty($request['lattitude'])) {
$lattitude = $request['lattitude'];
}
if (isset($request['longitude']) && !empty($request['longitude'])) {
$longitude = $request['longitude'];
}
$CheckvehicleAvail = vehicleBookingModel::where('vehicleid', '=', $vehicleid)->where('todate', '>=', $fromDate)->where('fromdate', '<=', $toDate)->get();
$checkTravel = DB::table('tbltravel')->join('tblbooking', 'tbltravel.bookingID', '=', 'tblbooking.id')->where('tbltravel.vehicleID', '=', $vehicleid)->where('tblbooking.checkin', '>=', $fromDate)->where('tblbooking.checkOut', '<=', $toDate)->select('tblbooking.*')->get();
$arrmsg = array();
if (isset($CheckvehicleAvail) && count($CheckvehicleAvail) > 0 || isset($checkTravel) && count($checkTravel) > 0) {
$arrmsg['status'] = -1;
$arrmsg['msg'] = "This vehicle is not available for the specified date";
} else {
$vehicle = vehicleModel::where('id', '=', $vehicleid)->get();
$numDays = $fromDate->diff($toDate)->format("%r%a");
$numHour1 = $numDays * 24;
$numhours = $fromDate->diff($toDate)->format("%r%h");
$totalHours = $numHour1 + $numhours;
if ($totalHours >= 2) {
$vehiclePrice = $vehicle[0]->price;
$price = $totalHours * $vehiclePrice;
$vehicleBooking = new vehicleBookingModel();
$vehicleBooking->tenantid = $user[0]->id;
$vehicleBooking->vehicleid = $vehicleid;
$vehicleBooking->fromdate = $fromDate;
$vehicleBooking->todate = $toDate;
$vehicleBooking->price = $price;
if (!is_null($request['lattitude'])) {
$vehicleBooking->pickuplat = $lattitude;
}
if (!is_null($request['longitude'])) {
$vehicleBooking->pickuplong = $longitude;
}
$vehicleBooking->save();
$arrmsg['status'] = 1;
$arrmsg['msg'] = "Vehicle booking successful";
} else {
$arrmsg['status'] = -1;
$arrmsg['msg'] = "Minimum Booking timespan is 2 hours";
}
}
return json_encode($arrmsg);
} else {
return response()->view('pages.404', ['user' => $user], 404);
}
}
}
public function vehicleBooking(Request $request)
{
$user = $request->session()->get('user');
if (is_null($user)) {
return redirect()->action('MainController@index');
} else {
if ($user[0]->type == 'tenant') {
$vehicles = vehicleModel::where('created_at', '!=', '')->orderBy('created_at', 'DESC')->paginate(9);
$vehicleCategories = vehicleCategory::all();
return view('pages.tenantBookVehicles', array('user' => $user, 'vehicles' => $vehicles, 'vehicleCategories' => $vehicleCategories));
} else {
return response()->view('pages.404', ['user' => $user], 404);
}
}
}
