[[ ROYAL CAR ]] CHANGE PASSWORD - DYNAMIC BANNER - MULTIPLE IMAGE - LOGIN LOGOUT BACK BUTTON MIDDLEWARE STOP - MAIL DIRECTLY WITH FEEDBACK WITH SAVE IN SQL DB - ADMIN REPLY EXISTING MAILS

[[ ROYAL CAR ]]

CHANGE PASSWORD -

DYNAMIC BANNER -

MULTIPLE IMAGE -

MAIL DIRECTLY WITH FEEDBACK MAIL WITH SAVE IN SQL DB -

ADMIN REPLY EXISTING MAILS -

DYNAMICALLY CSS CHANGE -

DATA TABLE -

HELPER FUNCTION -

USING JOIN QUERY -

AUTH USER LOGIN -

CARBON DATE & FORMAT & PASRSE -

SEARCH BOOKING & AVAILABILITY -

GETTING TESTIMONIAL & SHOW -

SALES REPORT SHOW -

SALES REPORT DATEWISE & CUSTOMER_NAME SEARCH -

INSERT UPDATE DELETE UNLINK PAGINATE RAND -

EXPORT SALES REPORT IN EXCEL FORMAT -

MAIL CUSTOMER SEND AND ADMIN REPLY MESSAGE -

and much more

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------`

https://ashallendesign.co.uk/blog/how-to-create-your-own-helper-functions-in-laravel

.ENV FILE

MAIL_MAILER=smtp
MAIL_HOST=smtp.gmail.com
MAIL_PORT=465
MAIL_USERNAME=MAIL@DOMAIN.com
MAIL_PASSWORD="PASSWORD"
MAIL_ENCRYPTION=tls
MAIL_FROM_ADDRESS=MAIL@DOMAIN.com
MAIL_FROM_NAME="Car Dekho"

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=cardekho
DB_USERNAME=root
DB_PASSWORD=

COMPOSER.JSON

"autoload": {
        "psr-4": {
            "App\\": "app/",
            "Database\\Factories\\": "database/factories/",
            "Database\\Seeders\\": "database/seeders/"
        },
        "files": [
            "app/helpers.php"
        ]
    },

WEB.PHP IN ROUTES

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\CarController;

use App\Http\Controllers\AdminController;

use App\Http\Controllers\DriverController;

use App\Http\Controllers\Customer;

use Illuminate\Support\Facades\Auth;

use App\Http\Controllers\CustomerController;

Route::get('/',[CarController::class,'index']);

Route::get('/about',[CarController::class,'about']);

Route::get('/booking/{id}',[CarController::class,'booking']);

Route::post('/booking_details',[CarController::class,'booking_details']); // booking_details

Route::get('/contact',[CarController::class,'contact']);

Route::get('/detail/{id}',[CarController::class,'detail']);

Route::get('/service',[CarController::class,'service']);

Route::get('/team',[CarController::class,'team']);

Route::get('/car',[CarController::class,'car']);

Route::get('/testimonial',[CarController::class,'testimonial']);

Route::post('/confmac',[CarController::class, 'confmac']);

Route::post('/clcontact',[CarController::class,'clcontact']);

Route::get('/driverProfile/{id}',[CarController::class,'driverProfile']);

// // ------------------------------------------------------------------------------

// Customer routes // Customer routes // Customer routes // Customer routes // Customer routes

// chck_avail

Route::post('/chck_avail',[CarController::class,'chck_avail']);

//search for availability top search area

Route::post('/search_avail',[CarController::class,'search_avail']);

Route::post('/srchFromAvai',[CarController::class,'srchFromAvai']);

// ------------------------------------------------------------------------------

// DRiver routes // DRiver routes // DRiver routes // DRiver routes // DRiver routes

Route::get('/driver',[DriverController::class,'driver_portal']);

// driverRegister driverLogin

Route::get('/driverRegister',[DriverController::class,'driverRegister']);

Route::post('/driver_reg',[DriverController::class,'driver_reg']);

Route::get('/driverLogin',[DriverController::class,'driverLogin']);

Route::post('/driver_login',[DriverController::class,'driver_login']);

// driverLogout

Route::get('/driverLogout',[DriverController::class,'driverLogout']);

// ------------------------------------------------------------------------------

// Admin routes // Admin routes // Admin routes // Admin routes // Admin routes

Route::get('/adregister',[AdminController::class,'register']);

Route::get('/adforget_pass',[AdminController::class,'forget_pass']);

Route::get('/adlogin',[AdminController::class,'login']);

// adfrinac

Route::post('/adfrinac',[AdminController::class,'adfrinac']);

Route::post('/adlgac',[AdminController::class,'adlgac']);

Route::middleware('OnlyAccess')->group(function(){

// only logged in users related routes here

// common for driver customer and admin

Route::get('/adindex',[AdminController::class,'index']);

Route::get('/adlogout', function () {

if(session()->has('adeu')){

session()->forget('adeu');

session()->forget('user_id');

}

Auth::logout();

// index function in admin helps to redirect back

return redirect('adlogin');

});

// common ends

// show own account

Route::get('/adacc',[AdminController::class,'adacc']);

});

Route::group(['middleware'=>['disable_back_btn']], function(){

Route::middleware('Driver')->group(function(){

Route::get('/driverindex', function(){

return "Driver Logged in";

});

// /driver related routes here

// driverAccount

Route::get('/driverAccount',[DriverController::class,'driverAccount']);

Route::post('/driver_update',[DriverController::class,'driver_update']);

// driverPassword

Route::get('/driverPassword',[DriverController::class,'driverPassword']);

Route::post('/driver_Pass_Chng',[DriverController::class,'driver_Pass_Chng']);

// driver OnRequest

Route::get('/onRequest',[DriverController::class,'onRequest']);

Route::get('/dvr_availunavail/{id}/{status}',[DriverController::class,'dvr_availunavail']);

Route::post('/dvr_rply',[DriverController::class,'dvr_rply']);

Route::get('/bookings',[DriverController::class,'bookings']);

Route::get('/bookingConfirm/{id}/{status}',[DriverController::class,'bookingConfirm']);

Route::post('/SrchCustmrasDriver',[DriverController::class,'SrchCustmrasDriver']);// Driver Search

Route::get('/earnings',[DriverController::class,'earnings']);// earnings

Route::get('/viewTrip/{id}',[DriverController::class,'viewTrip']);// viewTrip

Route::get('/regTrips/{id}/{status}',[DriverController::class,'regTrips']);// regTrips

Route::get('/feedbackMailSend/{id}',[DriverController::class,'feedbackMailSend']);// Feedback Mail Send

});

Route::middleware('Customer')->group(function(){

Route::get('/customerindex', function(){

return "Customer Logged in";

});

// /cutomer related routes here

Route::get('/chkRequests',[CustomerController::class,'chkRequests']);

Route::get('/RequestSrch_cs',[CustomerController::class,'RequestSrch_cs'])->name('RequestSrch_cs');

Route::post('/avai_date_srch_cs',[CustomerController::class,'avai_date_srch_cs']);

Route::get('/BookingSrch_cs',[CustomerController::class,'BookingSrch_cs'])->name('BookingSrch_cs');

Route::post('/bkk_date_srch_cs',[CustomerController::class,'bkk_date_srch_cs']);

Route::get('/chkBooking',[CustomerController::class,'chkBooking']);

Route::get('/myTrip/{id}',[CustomerController::class,'myTrip']);

Route::get('/myTrip2/{id}',[CustomerController::class,'myTrip2']);

Route::get('/addTesti/{id}',[CustomerController::class,'addTesti']);

Route::post('/submitTesti',[CustomerController::class,'submitTesti']);

});

Route::group(['middleware'=>['adlgchk']], function(){

Route::middleware('isAdmin')->group(function(){

// if checked by isAdmin, driver & customer cannot access it

// Route::get('/adindex',[AdminController::class,'index']);

// Route::get('/adlogout', function () {

// if(session()->has('adeu')){

// session()->forget('adeu');

// }

// Auth::logout();

// return redirect('adlogin');

// });

// driver & customer cannot access these routes

Route::get('/admail',[AdminController::class,'mailbox']);

Route::post('/admailsend',[AdminController::class,'admailsend']);

Route::get('/mail_rply/{id}',[AdminController::class,'mail_rply']);

// Route::get('/adacc',[AdminController::class,'adacc']); mail_rply

Route::post('/adfrupdateac',[AdminController::class,'adupac']);

Route::get('/adchpas',[AdminController::class,'adchpas']);

Route::post('/adpassupdate',[AdminController::class,'adpassupdate']);

Route::get('/chnger',[AdminController::class,'pagebannertitlechangeview']);

Route::post('/acinacfmac',[AdminController::class,'acinacfmac'])->name('acinacfmac');

// acinacfmac pggedit

Route::post('/pggedit',[AdminController::class,'pggedit']);

Route::post('/editpggac',[AdminController::class,'editpggac']);

Route::post('/mailsrch',[AdminController::class,'mailsrch']);

Route::get('/add_page',[AdminController::class,'pgadds']);

Route::get('/deletepage/{id}',[AdminController::class,'pgdeletes']);

Route::post('/addpggac',[AdminController::class,'addpggac']);

Route::get('/user_roles',[AdminController::class,'user_roles']);

Route::post('/usersrch',[AdminController::class,'user_srch']);

Route::get('/user_roles',[AdminController::class,'user_roles']);

Route::post('/user_role_edit',[AdminController::class,'user_role_edit']);

Route::post('/edit_ac_user_role',[AdminController::class,'edit_ac_user_role']);

Route::get('/add_user_role',[AdminController::class,'add_user_role']);

Route::post('/add_ac_user_role',[AdminController::class,'add_ac_user_role']);

Route::post('/user_role_delete',[AdminController::class,'user_role_delete']);

Route::post('/acInacUserDri',[AdminController::class,'acInacUserDri'])->name('acInacUserDri');

Route::get('/driverList',[AdminController::class,'driverList']);

// car list

Route::get('/carList',[AdminController::class, 'carList']);

Route::get('/addCars',[AdminController::class, 'addCars']);

Route::post('/car_added',[AdminController::class, 'car_added']);

Route::post('/car_edit',[AdminController::class, 'car_edit']); // car edit car_edit

Route::post('/car_edit_ac',[AdminController::class, 'car_edit_ac']);

Route::get('/carDelete/{id}',[AdminController::class,'carDelete']);

Route::post('/acInacCars',[AdminController::class,'acInacCars'])->name('acInacCars');

Route::get('/readRequest',[AdminController::class,'readRequest']);

Route::get('/RequestSrch',[AdminController::class,'RequestSrch'])->name('RequestSrch');

Route::post('/avai_date_srch',[AdminController::class,'avai_date_srch']);

Route::get('/bookingList',[AdminController::class,'bookingList']);

Route::get('/BookingSrch',[AdminController::class,'BookingSrch'])->name('BookingSrch');

Route::post('/bkk_date_srch',[AdminController::class,'bkk_date_srch']);

Route::get('/allDr_Cu',[AdminController::class,'allDr_Cu']);

Route::get('/userSel/{type}',[AdminController::class,'userSel']);

Route::get('/adShowTrip/{id}',[AdminController::class,'adShowTrip']);

Route::get('/drEarnings',[AdminController::class,'drEarnings']);

Route::get('/showTesti',[AdminController::class,'showTesti']);

Route::post('/testiAcIn',[AdminController::class,'testiAcIn']);

Route::get('/delTestimonial/{id}',[AdminController::class,'delTestimonial']);

Route::get('/bkkSrch',[AdminController::class,'bkkSrch'])->name('bkkSrch');

Route::post('/earning_date_srch',[AdminController::class,'earning_date_srch']);

Route::post('/excelExport',[AdminController::class,'excelExport']);

});

//isAdmin ends here

} );

//grp end

} );

Route::get('/hsd', function(){

return view('hackingsessiondata');

}

);

Route::get('/mail', function(){

return view('admin.mail');

} );

VIES FILES

ABOUT.BLADE.PHP

@include('header')

<head>

<title>ABOUT </title>

</head>

@if(isset($page)) @if($page->active)

{{$page->title}} @endif

@else

About

@endif

</h1>

@if(isset($page)) @if($page->active)

{{$page->title}} @endif

@else

About

@endif

</h6>

</div>

<h1 class="display-4 text-uppercase text-center mb-5">Welcome To <span class="text-primary">Royal Cars</span></h1>

<p>Justo et eos et ut takimata sed sadipscing dolore lorem, et elitr labore labore voluptua no rebum sed, stet voluptua amet sed elitr ea dolor dolores no clita. Dolores diam magna clita ea eos amet, amet rebum voluptua vero vero sed clita accusam takimata. Nonumy labore ipsum sea voluptua sea eos sit justo, no ipsum sanctus sanctus no et no ipsum amet, tempor labore est labore no. Eos diam eirmod lorem ut eirmod, ipsum diam sadipscing stet dolores elitr elitr eirmod dolore. Magna elitr accusam takimata labore, et at erat eirmod consetetur tempor eirmod invidunt est, ipsum nonumy at et.</p>

</div>

</div>

<h4 class="text-uppercase m-0">24/7 Car Rental Support</h4>

</div>

</div>

<h4 class="text-light text-uppercase m-0">Car Reservation Anytime</h4>

</div>

</div>

<h4 class="text-uppercase m-0">Lots Of Pickup Locations</h4>

</div>

<h3 class="text-uppercase text-light mb-3">Want to be driver?</h3>

<p class="mb-4">Lorem justo sit sit ipsum eos lorem kasd, kasd labore</p>

<a class="btn btn-primary py-2 px-4" href="/driver">Start Now</a>

</div>

<h3 class="text-uppercase text-light mb-3">Looking for a car?</h3>

<p class="mb-4">Lorem justo sit sit ipsum eos lorem kasd, kasd labore</p>

<a class="btn btn-primary py-2 px-4" href="/car">Start Now</a>

</div>

</div>

@include('footer')

availReqSrch.blade.php

@include('header')

<head>

<title>SEARCH </title>

</head>

@if (isset($page))

@if ($page->active)

@endif

@else

@endif

</h1>

@if (isset($page))

@if ($page->active)

@endif

@else

@endif

</h6>

</div>

<thead>

<th> Customer </th>

<th> Driver </th>

<th> Pickup Location </th>

<th> Drop Location </th>

<th> Pickup Date </th>

<th> Pickup Time </th>

<th> Available </th>

</tr>

</thead>

<tbody>

<?php $c = 1; ?>{{-- ['adeu' => $adfn, 'data'=>$data, 'cust'=>$cust, 'car'=>$car, 'driver'=>$driver --}}

@if(count($data)>0)

@foreach ($data as $item)

<tr @if ($item->available) style="background: #ebb96e5b" @endif>

<td>{{ findCust($item->customer_id) }}</td>

<td>{{ findDri($item->driver_id)}}</td>

<td>{{ findCar($item->car_id) }}</td>

<td>{{ findLoc($item->puloc) }}</td>

<td>{{ findLoc($item->droploc) }}</td>

<td>{{ $item->pudate }}</td>

<td>{{ $item->putime }}</td>

<td>

@if ($item->mail)

@else

<h5 class="text-info">No Mails</h5>

@endif

</td>

<td>

{{-- null => no res, 0=>unavi 1=> avai book now 2=> booked 3=> booking confirm --}}

@if ($item->available == null)

<h5 class="text-info">No response</h5>

@else

@if($item->available == 1)

<h5 class="text-success">Available</h5>

@elseif( $item->available == 0 || $item->available == 5 )

<h5 class="text-danger">Unavailable</h5>

@elseif( $item->available == 2)

<h5 class="text-primary">Booking Done</h5>

@elseif( $item->available == 3)

<h5 class="text-success">Booking Confirmed

<a href="/myTrip/{{$item->id}}" class='text-primary' data-toggle="tooltip" data-placement="top" title="Show Ride Details"><i class="fa fa-arrow-circle-right"></i></a>

</h5>

@elseif( $item->available == 4)

<h5 class="text-danger">Booking Cancled</h5>

@endif

</td>

</tr>

@endforeach

@else

<td colspan="10" class="text-center"> No Data Found</td>

@endif

</tbody>

</table>

</div>

@include('footer')

booking.blade.php

@include('header')

<head>

<title>BOOKING</title>

</head>

@if(isset($page)) @if($page->active)

{{$page->title}} @endif

@else

Car Booking

@endif

</h1>

@if(isset($page)) @if($page->active)

{{$page->title}} @endif

@else

Car Booking

@endif

</h6>

</div>

@if(session()->has('success'))

<strong>{{session()->get('success')}}</strong>

</button>

</div>

@endif

@if(session()->has('error'))

<strong>{{session()->get('error')}}</strong>

</button>

</div>

@endif

<h1 class="display-4 text-uppercase mb-5">{{$car->brand}} {{$car->name}}</h1>

<?php $img = explode(', ',$car->image); ?>

</div>

<h4 class="mb-2">${{$car->price}}.00/Day</h4>

<h6 class="mr-2">Rating:</h6>

</div>

<p> {{$car->desc}}, tempor voluptua sit consetetur sit. Aliquyam diam amet diam et eos sadipscing labore. Clita erat ipsum et lorem et sit, sed stet no labore lorem sit. Sanctus clita duo justo et tempor consetetur takimata eirmod, dolores takimata consetetur invidunt</p>

<h6>Share on:</h6>

</div>

<span>Model: {{$car->year}}</span>

</div>

</div>

<span>{{$car->kmpl}}km/liter</span>

</div>

<span>{{$car->features}}</span>

</div>

@csrf

<h2 class="mb-4">Personal Detail</h2>

@if(isset($bookdata))

@foreach($drivers as $driver)

@if($bookdata->driver_id==$driver->id)

<option value="{{ $driver->id }}" selected> {{ $driver->name }}</option>

@endif

@endforeach

@else

<option value="">Select Driver</option>

@foreach($drivers as $driver)

<option value="{{ $driver->id }}" > {{ $driver->name }}</option>

@endforeach

@endif

</select>

</div>

</div>

<h2 class="mb-4">Booking Detail</h2>

@if(isset($bookdata))

@foreach($locations as $loc)

@if($bookdata->puloc==$loc->id)

<option value="{{ $loc->id }}" selected> {{ $loc->area }}</option>

@endif

@endforeach

@else

<option value="">Pickup Location</option>

@foreach($locations as $loc)

@endforeach

@endif

</select>

</div>

@if(isset($bookdata))

@foreach($locations as $loc)

@if($bookdata->droploc==$loc->id)

@endif

@endforeach

@else

<option selected>Drop Location</option>

@foreach($locations as $loc)

@endforeach

@endif

</select>

</div>

<input type="text" name="pudate" id="pudate" class="form-control p-4 datetimepicker-input" placeholder="Pickup Date"

data-target="#date22" data-toggle="datetimepicker" @if(isset($bookdata)) value="{{$bookdata->pudate}}" readonly @endif/>

</div>

<input type="text" name="putime" id="putime" class="form-control p-4 datetimepicker-input" placeholder="Pickup Time"

data-target="#time2" data-toggle="datetimepicker" @if(isset($bookdata)) value="{{$bookdata->putime}}" readonly @endif/>

</div>

<option value="0" selected>Select Adult</option>

<option value="1">Adult 1</option>

<option value="2">Adult 2</option>

<option value="3">Adult 3</option>

</select>

</div>

<option value="0" selected>Select Child</option>

<option value="1">Child 1</option>

<option value="2">Child 2</option>

<option value="3">Child 3</option>

</select>

</div>

</div>

<h2 class="text-primary mb-4">Payment</h2>

</div>

</div>

<label class="custom-control-label" for="googlepay">Google Pay</label>

</div>

<label class="custom-control-label" for="banktransfer">Bank Transfer</label>

</div>

{{-- <input type="hidden" name="user_id" value="{{$car->id}}"> cus --}}

<button class="btn btn-block btn-primary py-3" onclick="checking()" type="submit">Reserve Now</button>

</div>

</form>

function checking(){

puloc = document.getElementById('puloc').value;

drloc= document.getElementById('drloc').value;

pudate= document.getElementById('pudate').value;

putime = document.getElementById('putime').value;

driverSel = document.getElementById('driverSel').value;

var varDate = new Date(pudate); //dd-mm-YYYY

var today = new Date();

// console.log(varDate);

// console.log(today);

if(puloc == drloc)

{

alert('Pickup location and Drop location cannot be same');

event.preventDefault();

return false;

}

if(puloc =='' || drloc =='' || pudate=='' || putime=='' || driverSel=='' )

{

alert('Data cannot be blank');

event.preventDefault();

return false;

}

return true;

}

</script>

</div>

@include('footer')

car.blade.php

@include('header')

<head>

</head>

@if(isset($page)) @if($page->active)

{{$page->title}} @endif

@else

Car Listing

@endif

</h1>

@if(isset($page)) @if($page->active)

{{$page->title}} @endif

@else

Car Listing

@endif

</h6>

</div>

@foreach($cars as $car)

@if($car->status)

<?php $imgx = explode(', ',$car->image); ?>

<h4 class="text-uppercase mb-4"> {{$car->brand}} {{$car->name}}</h4>

</div>

</div>

</div>

<a class="btn btn-primary px-3" href="detail/{{$car->id}}">${{$car->price}}.00/Day</a>

</div>

@endif

@endforeach

</div>

<h3 class="text-uppercase text-light mb-3">Want to be driver?</h3>

<p class="mb-4">Lorem justo sit sit ipsum eos lorem kasd, kasd labore</p>

<a class="btn btn-primary py-2 px-4" href="/driver">Start Now</a>

</div>

<h3 class="text-uppercase text-light mb-3">Looking for a car?</h3>

<p class="mb-4">Lorem justo sit sit ipsum eos lorem kasd, kasd labore</p>

<a class="btn btn-primary py-2 px-4" href="/car">Start Now</a>

</div>

</div>

@include('footer')

contact.blade.php

@include('header')

<head>

<title>CONTACT </title>

</head>

@if(isset($page)) @if($page->active)

{{$page->title}} @endif

@else

Contact

@endif

</h1>

<h6 class="text-uppercase text-body m-0">@if(isset($page)) @if($page->active)

{{$page->title}} @endif

@else

Contact

@endif </h6>

</div>

@if(session()->has('success'))

<strong>{{session()->get('success')}}</strong>

</button>

</div>

@endif

@if(session()->has('error'))

<strong>{{session()->get('error')}}</strong>

</button>

</div>

@endif

<h1 class="display-4 text-uppercase text-center mb-5">Contact Us</h1>

@csrf

</div>

</div>

</div>

</div>

<div>

<button class="btn btn-primary py-3 px-5" type="submit">Send Message</button>

</div>

</form>

</div>

<h5 class="text-light">Head Office</h5>

<p>123 Street, New York, USA</p>

</div>

<h5 class="text-light">Branch Office</h5>

<p>123 Street, New York, USA</p>

</div>

<h5 class="text-light">Customer Service</h5>

<p>customer@example.com</p>

</div>

<h5 class="text-light">Return & Refund</h5>

<p class="m-0">refund@example.com</p>

</div>

@include('footer')

detail.blade.php

@include('header')

<head>

<title>DETAILS </title>

</head>

@if(isset($page)) @if($page->active)

{{$page->title}} @else

Car Detail @endif

@else

Car Detail

@endif

</h1>

@if(isset($page)) @if($page->active)

{{$page->title}} @else

Car Detail @endif

@else

Car Detail

@endif

</h6>

</div>

@if(session()->has('success'))

<strong>{{session()->get('success')}}</strong>

</button>

</div>

@endif

@if(session()->has('error'))

<strong>{{session()->get('error')}}</strong>

</button>

</div>

@endif

<h1 class="display-4 text-uppercase mb-5"> {{$car->brand}} {{$car->name}}</h1>

<?php $img = explode(', ',$car->image); ?>

</div>

</div>

</div>

</div>

<p>{{$car->desc}}. Aliquyam diam amet diam et eos sadipscing labore. Clita erat ipsum et lorem et sit, sed stet no labore lorem sit. Sanctus clita duo justo et tempor consetetur takimata eirmod, dolores takimata consetetur invidunt magna dolores aliquyam dolores dolore. Amet erat amet et magna</p>

<span>Model: {{$car->year}}</span>

</div>

</div>

<span>{{$car->kmpl}}km/liter</span>

</div>

<span>{{$car->features}}</span>

</div>

<span>${{$car->price}}.00/Day</span>

</div>

<h3 class="text-primary text-center mb-4">Check Availability</h3>

@csrf

<option selected>Pickup Location</option>

@foreach($locations as $loc)

@endforeach

</select>

</div>

<option selected>Drop Location</option>

@foreach($locations as $loc)

@endforeach

</select>

</div>

{{-- <div class="form-group">

<input type="text" id="pudate" name="pudate" class="form-control p-4 datetimepicker-input" placeholder="Pickup Date"

data-target="#date12" data-toggle="datetimepicker" />

</div>

</div> --}}

<input type="date" id="pudateh" name="pudate"

class="p-4 form-control datetimepicker-input"@if (isset($req)) value="{{ $req->pudate }}" @endif />

</div>

var today = new Date();

var dd = String(today.getDate()).padStart(2, '0');

var mm = String(today.getMonth() + 1).padStart(2, '0');

var yyyy = today.getFullYear();

today = yyyy + '-' + mm + '-' + dd;

$('#pudateh').attr('min',today);

</script>

<input type="text" id="putime" name="putime" class="form-control p-4 datetimepicker-input" placeholder="Pickup Time"

data-target="#time2" data-toggle="datetimepicker" />

</div>

<option selected>Select Driver</option>

@foreach($drivers as $driver)

<option value="{{$driver->id}}"> {{$driver->name }}</option>

@endforeach

</select>

</div>

<button class="btn btn-primary btn-block" onclick="checking()" type="submit" style="height: 50px;">Check Now</button>

</div>

</form>

function checking(){

puloc = document.getElementById('puloc').value;

drloc= document.getElementById('drloc').value;

pudate= document.getElementById('pudate').value;

putime = document.getElementById('putime').value;

driverSel = document.getElementById('driverSel').value;

var varDate = new Date(pudate); //dd-mm-YYYY

var today = new Date().toLocaleString();

// console.log(varDate);

// console.log(today);

console.log(today, varDate, puloc ,drloc ,pudate,putime, driverSel);

if(puloc == drloc)

{

alert('Pickup location and Drop location cannot be same');

event.preventDefault();

return false;

}

if(puloc =='' || drloc =='' || pudate=='' || putime=='' || driverSel=='' )

{

alert('Data cannot be blank');

event.preventDefault();

return false;

}

return true;

}

</script>

{{-- <div class="form-group mb-0">

<a href="booking/{{$car->id}}" class="btn btn-primary btn-block" style="height: 50px;">Book Now</a>

</div> --}}

</div>

<h2 class="mb-4">Related Cars</h2>

@foreach($relatedcars as $rcar)

<?php $carImg = explode(', ',$rcar->image); ?>

<h4 class="text-uppercase mb-4"> {{$rcar->brand}} {{$rcar->name}}</h4>

</div>

</div>

</div>

<a class="btn btn-primary px-3" href="detail/{{$rcar->id}}">${{$rcar->price}}.00/Day</a>

</div>

@endforeach

{{-- <div class="rent-item">

<h4 class="text-uppercase mb-4">Mercedes Benz R3</h4>

</div>

</div>

</div>

</div>

<h4 class="text-uppercase mb-4">Mercedes Benz R3</h4>

</div>

</div>

</div>

</div>

<h4 class="text-uppercase mb-4">Mercedes Benz R3</h4>

</div>

</div>

</div>

</div> --}}

</div>

@include('footer')

driverProfile.blade.php

@include('header')

<head>

<title>DETAILS </title>

</head>

@if(isset($page)) @if($page->active)

{{$page->title}} @else

Car Detail @endif

@else

Car Detail

@endif

</h1>

@if(isset($page)) @if($page->active)

{{$page->title}} @else

Car Detail @endif

@else

Car Detail

@endif

</h6>

</div>

<h1 class="text-info ">Driver Account</h1>

<h6 class="text-muted mt-2"> Drivers are most trustworthy, loyal and geniune persons. <br> Trust Us and make your next ride being a King, and<br>

<strong> The information associated with your Royal Car are real and helful. </strong>

</h6>

<img src="{{$data->image}}" style=" border: 4px solid #cddc39; padding: 2px; border-radius: 50%; border-top-color: #ff5722; border-left-color: #ff5722; width: 25%;height: 15%;">

</div>

<div class="my-2 mb-5 text-muted text-center">Recent Image</div>

</div>

<strong class="card-title"> Driver Account </strong>

</div>

<label for="file-input" class=" form-control-label"> Username </label>

</div>

<input type="text" name="name" id="name" placeholder="Username" value="{{ $data->name }}" class="form-control" disabled>

</div>

<label for="file-input" class=" form-control-label"> Email Address </label>

</div>

<input type="email" name="email" id="email" placeholder="Email" value="{{ $data->email }}" class="form-control" disabled>

</div>

<label for="file-input" class=" form-control-label"> Phone </label>

</div>

<input type="number" id="file-input" name="phone" class="form-control" value="{{ $data->phone }}" disabled >

</div>

<label for="file-input" class=" form-control-label"> Address </label>

</div>

<input type="text" id="file-input" name="address" class="form-control" value="{{ $data->address }}" disabled>

</div>

<label for="file-input" class=" form-control-label"> Licence No </label>

</div>

<input type="text" id="file-input" name="licenceNo" class="form-control" value="{{ $data->licenceNo }}" disabled>

</div>

</div>

<input type="" id="file-input" name="carNo" class="form-control" value="{{ $data->carNo }}" disabled>

</div>

<label for="file-input" class=" form-control-label"> Years of Experience </label>

</div>

<option value="">-- Select --</option>

<option value="1" @if($data->experience==1) selected @endif>1</option>

<option value="2" @if($data->experience==2) selected @endif>2</option>

<option value="3" @if($data->experience==3) selected @endif>3</option>

<option value="5" @if($data->experience==5) selected @endif>5</option>

</select>

</div>

</div>@include('footer')

footer.blade.php

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

<h4 class="text-uppercase text-light mb-4">Get In Touch</h4>

<p class="mb-2"><i class="fa fa-map-marker-alt text-white mr-3"></i>123 Street, New York, USA</p>

<p><i class="fa fa-envelope text-white mr-3"></i>info@example.com</p>

<h6 class="text-uppercase text-white py-2">Follow Us</h6>

</div>

<h4 class="text-uppercase text-light mb-4">Usefull Links</h4>

<a class="text-body mb-2" href="#"><i class="fa fa-angle-right text-white mr-2"></i>Private Policy</a>

<a class="text-body mb-2" href="#"><i class="fa fa-angle-right text-white mr-2"></i>Term & Conditions</a>

<a class="text-body mb-2" href="#"><i class="fa fa-angle-right text-white mr-2"></i>New Member Registration</a>

<a class="text-body mb-2" href="#"><i class="fa fa-angle-right text-white mr-2"></i>Affiliate Programme</a>

<a class="text-body mb-2" href="#"><i class="fa fa-angle-right text-white mr-2"></i>Return & Refund</a>

</div>

<h4 class="text-uppercase text-light mb-4">Car Gallery</h4>

</div>

</div>

</div>

</div>

</div>

</div>

<h4 class="text-uppercase text-light mb-4">Newsletter</h4>

<p class="mb-4">Volup amet magna clita tempor. Tempor sea eos vero ipsum. Lorem lorem sit sed elitr sed kasd et</p>

</div>

<i>Lorem sit sed elitr sed kasd et</i>

</div>

<p class="m-0 text-center text-body">Designed by <a href="https://htmlcodex.com">HTML Codex</a></p>

</div>

</body>

</html>

header.blade.php

<!DOCTYPE html>

<head>

rel="stylesheet">

</head>

<body>

<a class="text-body px-3" href=""><i class="fa fa-envelope mr-2"></i>info@example.com</a>

</div>

@if (session()->has('adeu'))

<span> Welcome

{{ session()->get('adeu')['name'] }},

</span>

@endif

<a class="text-body px-3" href="driver"> Drive with Us</a>

</a>

</a>

</a>

</a>

</a>

{{-- <span class="text-body px-3">|</span>

Search</a> --}}

</div>

<h1 class="text-uppercase text-primary mb-1">Royal Cars</h1>

</a>

</button>

<a href="/about" class="nav-item nav-link ">About</a>

<a href="/service" class="nav-item nav-link">Service</a>

</div>

<a href="#" class="nav-link dropdown-toggle" data-toggle="dropdown">Pages</a>

<a href="/testimonial" class="dropdown-item">Testimonial</a>

</div>

<a href="contact" class="nav-item nav-link">Contact</a>

@if (session()->has('adeu'))

<a href="/adindex" class="nav-item nav-link">Dashboard</a>

<a href="/adlogout" class="nav-item nav-link">Logout</a>

@else

<a href="/adlogin" class="nav-item nav-link">Login</a>

@endif

</div>

</nav>

</div>

@csrf

<option value="" selected>Pickup Location</option>

@foreach ($locations as $loc)

<option value="{{ $loc->id }}"

@if (isset($req)) @if ($req->puloc == $loc->id) selected @endif

@endif>{{ $loc->area }}</option>

@endforeach

</select>

</div>

<option value="" selected>Drop Location</option>

@foreach ($locations as $loc)

<option value="{{ $loc->id }}"

@if (isset($req)) @if ($req->drloc == $loc->id) selected @endif

@endif>{{ $loc->area }}</option>

@endforeach

</select>

</div>

<input type="date" id="pudateh22" name="pudate"

class="p-4 form-control "@if (isset($req)) value="{{ $req->pudate }}" @endif />

</div>

var today = new Date();

var dd = String(today.getDate()).padStart(2, '0');

var mm = String(today.getMonth() + 1).padStart(2, '0');

var yyyy = today.getFullYear();

today = yyyy + '-' + mm + '-' + dd;

$('#pudateh22').attr('min',today);

</script>

{{-- <div class="col-xl-2 col-lg-4 col-md-6">

<input type="text" id="putimeh" name="putime" class="form-control p-4 datetimepicker-input" placeholder="Time Pickup "

data-target="#time1" data-toggle="datetimepicker" />

</div>

</div> --}}

<option value="" selected>Select A Car</option>

@foreach ($cars as $car)

<option value="{{ $car->id }}"

@if (isset($req)) @if ($req->car_id == $car->id) selected @endif

@endif> {{ $car->name }}</option>

@endforeach

</select>

</div>

<option value="" selected>Driver</option>

@foreach ($drivers as $driver)

<option value="{{ $driver->id }}"

@if (isset($req)) @if ($req->driverSel == $driver->id) selected @endif

@endif> {{ $driver->name }}</option>

@endforeach

</select>

</div>

<button class="btn btn-primary btn-block mb-3" type="submit" style="height: 50px;">Search Now</button>

</div>

</form>

function checking2() {

puloc = document.getElementById('puloch').value;

drloc = document.getElementById('drloch').value;

pudate = document.getElementById('pudateh').value;

putime = document.getElementById('putimeh').value;

carSel = document.getElementById('car_idh').value;

driverSel = document.getElementById('driverSelh').value;

var varDate = new Date(pudate); //dd-mm-YYYY

var today = new Date();

// console.log(puloc ,drloc ,pudate,putime, driverSel, carSel);

// if(puloc == drloc)

// {

// alert('Pickup location and Drop location cannot be same');

// event.preventDefault();

// return false;

// }

if (pudate == '') {

alert('Date cannot be blank');

event.preventDefault();

return false;

}

if (varDate <= today) {

alert("Please check car for Present Date or for some Upcoming Event!");

event.preventDefault();

return false;

}

return true;

}

</script>

</div>

@if (isset($page))

@if ($page->active)

@if ($page->page != 'home')

<style>

.page-header {

height: 400px;

margin-bottom: 90px;

display: flex;

flex-direction: column;

align-items: center;

justify-content: center;

background: linear-gradient(rgba(28, 30, 50, .8), rgba(28, 30, 50, .8)), url({{ $page->image }});

background-attachment: fixed;

}

.bg-banner {

background: linear-gradient(rgba(28, 30, 50, .9), rgba(28, 30, 50, .9)), url({{ $page->image }});

background-attachment: fixed;

}

</style>

@else

<?php $arr = explode(', ', $page->image); ?>

<style>

.bg-banner {

background: linear-gradient(rgba(28, 30, 50, .9), rgba(28, 30, 50, .9)), url({{ $arr[0] }});

background-attachment: fixed;

}

</style>

@endif

@else

<style>

.page-header {

height: 400px;

margin-bottom: 90px;

display: flex;

flex-direction: column;

align-items: center;

justify-content: center;

background: linear-gradient(rgba(28, 30, 50, .9), rgba(28, 30, 50, .9)), url(../img/no_image_available.jpeg);

background-attachment: fixed;

}

.bg-banner {

background: linear-gradient(rgba(28, 30, 50, .9), rgba(28, 30, 50, .9)), url(../img/no_image_available.jpeg);

background-attachment: fixed;

}

</style>

@endif

@else

<style>

.page-header {

height: 400px;

margin-bottom: 90px;

display: flex;

flex-direction: column;

align-items: center;

justify-content: center;

background: linear-gradient(rgba(28, 30, 50, .9), rgba(28, 30, 50, .9)), url(../img/no_image_available.jpeg);

background-attachment: fixed;

}

.bg-banner {

background: linear-gradient(rgba(28, 30, 50, .9), rgba(28, 30, 50, .9)), url(../img/no_image_available.jpeg);

background-attachment: fixed;

}

</style>

@endif

index.blade.php

@include('header')

<head>

<title>ROYAL CARS - Car Rental HTML Template</title>

</head>

@if(isset($page))

@if($page->active==1)

<?php $arr = explode(", ",$page->image); $count=1; ?>

@foreach($arr as $card)

{{-- <img src="{{$card}}" alt="{{$page->title}} banner" height="60px" width="70px">--}}

<h1 class="display-1 text-white mb-md-4">{{$page->title}}</h1>

<a href="" class="btn btn-primary py-md-3 px-md-5 mt-2">Reserve Now</a>

</div>

<?php $count++; ?>

@endforeach

@else

<h1 class="display-1 text-white mb-md-4">Quality Cars with Unlimited Miles</h1>

<a href="" class="btn btn-primary py-md-3 px-md-5 mt-2">Reserve Now</a>

</div>

<h1 class="display-1 text-white mb-md-4">Quality Cars with Unlimited Miles</h1>

<a href="" class="btn btn-primary py-md-3 px-md-5 mt-2">Reserve Now</a>

</div>

@endif

@else

<h1 class="display-1 text-white mb-md-4">Quality Cars with Unlimited Miles</h1>

<a href="" class="btn btn-primary py-md-3 px-md-5 mt-2">Reserve Now</a>

</div>

<h1 class="display-1 text-white mb-md-4">Quality Cars with Unlimited Miles</h1>

<a href="" class="btn btn-primary py-md-3 px-md-5 mt-2">Reserve Now</a>

</div>

@endif

{{-- <div class="carousel-item active">

<h1 class="display-1 text-white mb-md-4">Quality Cars with Unlimited Miles</h1>

<a href="" class="btn btn-primary py-md-3 px-md-5 mt-2">Reserve Now</a>

</div>

</div> --}}

</div>

</div>

</a>

</div>

</a>

</div>

<h1 class="display-4 text-uppercase text-center mb-5">Welcome To <span class="text-primary">Royal Cars</span></h1>

</div>

</div>

<h4 class="text-uppercase m-0">24/7 Car Rental Support</h4>

</div>

</div>

<h4 class="text-light text-uppercase m-0">Car Reservation Anytime</h4>

</div>

</div>

<h4 class="text-uppercase m-0">Lots Of Pickup Locations</h4>

</div>

<h1 class="display-4 text-uppercase text-center mb-5">Our Services</h1>

</div>

</div>

<h4 class="text-uppercase mb-3">Car Rental</h4>

<p class="m-0">Kasd dolor no lorem nonumy sit labore tempor at justo rebum rebum stet, justo elitr dolor amet sit sea sed</p>

</div>

</div>

</div>

<h4 class="text-uppercase mb-3">Car Financing</h4>

<p class="m-0">Kasd dolor no lorem nonumy sit labore tempor at justo rebum rebum stet, justo elitr dolor amet sit sea sed</p>

</div>

</div>

</div>

<h4 class="text-uppercase mb-3">Car Inspection</h4>

<p class="m-0">Kasd dolor no lorem nonumy sit labore tempor at justo rebum rebum stet, justo elitr dolor amet sit sea sed</p>

</div>

</div>

</div>

<h4 class="text-uppercase mb-3">Auto Repairing</h4>

<p class="m-0">Kasd dolor no lorem nonumy sit labore tempor at justo rebum rebum stet, justo elitr dolor amet sit sea sed</p>

</div>

</div>

</div>

<h4 class="text-uppercase mb-3">Auto Painting</h4>

<p class="m-0">Kasd dolor no lorem nonumy sit labore tempor at justo rebum rebum stet, justo elitr dolor amet sit sea sed</p>

</div>

</div>

</div>

<h4 class="text-uppercase mb-3">Auto Cleaning</h4>

<p class="m-0">Kasd dolor no lorem nonumy sit labore tempor at justo rebum rebum stet, justo elitr dolor amet sit sea sed</p>

</div>

<h1 class="text-uppercase text-light mb-4">Special Offer For New Members</h1>

<p class="mb-4">Only for Sunday from 1st Jan to 30th Jan 2045</p>

<a class="btn btn-primary mt-2 py-3 px-5" href="">Register Now</a>

</div>

@if(isset($cars))

<?php $c=1; ?>

@foreach($cars as $car)

<?php $img = explode(',', $car->image); $c++; ?>

<h4 class="text-uppercase mb-4">{{$car->brand }} {{$car->name}}</h4>

</div>

</div>

</div>

<a class="btn btn-primary px-3" href="detail/{{$car->id}}">$ {{$car->price}}.00/Day</a>

</div>

@endforeach

@else

<h4 class="text-uppercase mb-4">NO CARS AVAILABLE</h4>

</div>

</div>

</div>

</div>

@endif

</div>

@foreach($drivers as $driver)

<img class="img-fluid w-100" src="{{$driver->image}}" style="height:270px" alt="">

</a>

<h4 class="text-uppercase">{{$driver->name}}</h4>

<p class="m-0">Experience: {{$driver->experience}}</p>

</div>

@endforeach

<h4 class="text-uppercase">Sing Queen</h4>

<p class="m-0">Experience: 2</p>

</div>

<h3 class="text-uppercase text-light mb-3">Want to be driver?</h3>

<p class="mb-4">Lorem justo sit sit ipsum eos lorem kasd, kasd labore</p>

<a class="btn btn-primary py-2 px-4" href="driver">Start Now</a>

</div>

<h3 class="text-uppercase text-light mb-3">Looking for a car?</h3>

<p class="mb-4">Lorem justo sit sit ipsum eos lorem kasd, kasd labore</p>

<a class="btn btn-primary py-2 px-4" href="car">Start Now</a>

</div>

</div>

<h1 class="display-4 text-uppercase text-center mb-5">Our Client's Say</h1>

@foreach($testimonials as $t)

</div>

<h4 class="text-uppercase mb-2">{{ findCustomer($t->book_id)}}</h4>

<i class="mb-2">Rating: <?php for($i = 0; $i < (int)$t->rating; $i++){ ?>

<?php } ?><br></i>

<p class="m-0">{{$t->message}}</p>

</div>

@endforeach

</div>

<h4 class="text-uppercase mb-2">PORTAL QUEEN</h4>

<i class="mb-2">Rating: <?php for($i = 0; $i < 3; $i++){ ?>

<?php } ?><br></i>

<p class="m-0">Kasd dolor no lorem nonumy sit labore tempor at justo rebum rebum stet, justo elitr dolor amet sit sea sed</p>

</div>

<h1 class="display-4 text-uppercase text-center mb-5">Contact Us</h1>

@if(session()->has('success'))

<strong>{{session()->get('success')}}</strong>

</button>

</div>

@endif

@csrf

</div>

</div>

</div>

</div>

<div>

<button class="btn btn-primary py-3 px-5" type="submit">Send Message</button>

</div>

</form>

</div>

<h5 class="text-light">Head Office</h5>

<p>123 Street, New York, USA</p>

</div>

<h5 class="text-light">Branch Office</h5>

<p>123 Street, New York, USA</p>

</div>

<h5 class="text-light">Customer Service</h5>

<p>customer@example.com</p>

</div>

<h5 class="text-light">Return & Refund</h5>

<p class="m-0">refund@example.com</p>

</div>

@include('footer')

mailsend.blade.php

<!DOCTYPE html>

<head>

<title>Document</title>

</head>

<body>

Thank u

we got the mail

</body>

</html>

searchResults.blade.php

{{-- @include('header')

<head>

<title>SEARCH </title>

</head>

@if (isset($page))

@if ($page->active)

@endif

@else

@endif

</h1>

@if (isset($page))

@if ($page->active)

@endif

@else

@endif

</h6>

</div>

<!-- Page Header Start - ->

<h1 class="display-4 text-uppercase text-center mb-5"> Available Cars </h1>

{{-- ['cars'=>$cars, 'drivers' => $drivers,'locations'=>$locations, 'availCars'=> $availCars, 'availDrivers'=> $availDrivers] - -}}

@if (isset($availCars))

<?php $c = 1; ?>

@foreach ($availCars as $rcar)

<div

@if ($c == 2) class="active service-item d-flex flex-column justify-content-center px-4 mb-4" @else class="service-item d-flex flex-column justify-content-center px-4 mb-4" @endif>

<div class="d-flex align-items-center justify-content-center bg-primary ml-n4"

style="width: 150px; height: 100px;">

<?php $carImg = explode(', ', $rcar->image); ?>

<img class="img-fluid mb-4" src="{{ $carImg[2] }}"

style="width:100%; height:100%">

</div>

</div>

<h4 class="text-uppercase mb-3"> {{ $rcar->brand }} {{ $rcar->name }}</h4>

</div>

</div>

</div>

<a class="btn btn-primary px-3"

href="detail/{{ $rcar->id }}">${{ $rcar->price }}.00/Day</a>

</div>

@endforeach

@endif

</div>

<!-- Services End - ->

<h1 class="display-4 text-uppercase text-center mb-5"> Available Drivers </h1>

{{-- ['cars'=>$cars, 'drivers' => $drivers,'locations'=>$locations, 'availCars'=> $availCars, 'availDrivers'=> $availDrivers] - -}}

@if (isset($availDrivers))

<?php $c = 1; ?>

@foreach ($availDrivers as $rdr)

<div

@if ($c == 2) class="active service-item d-flex flex-column justify-content-center px-4 mb-4" @else class="service-item d-flex flex-column justify-content-center px-4 mb-4" @endif>

<div class="d-flex align-items-center justify-content-center bg-primary ml-n4"

style="width: 150px; height: 100px;">

<img class="img-fluid mb-4" src="{{ $rdr->image }}"

style="width:100%; height:100%">

</div>

</div>

<span> Experience: {{ $rdr->experience }}</span>

</div>

@endforeach

@endif

</div>

<h2 class="mb-4">Related Cars</h2>

@foreach ($cars as $rcar)

<?php $carImg = explode(', ', $rcar->image); ?>

<h4 class="text-uppercase mb-4"> {{ $rcar->brand }} {{ $rcar->name }}</h4>

</div>

</div>

</div>

<a class="btn btn-primary px-3" href="detail/{{ $rcar->id }}">${{ $rcar->price }}.00/Day</a>

</div>

@endforeach

</div>

@include('footer') --}}

service.blade.php

@include('header')

<head>

<title>SERVICE </title>

</head>

@if(isset($page)) @if($page->active)

{{$page->title}} @endif

@else

Service

@endif

</h1>

@if(isset($page)) @if($page->active)

{{$page->title}} @endif

@else

Service

@endif

</h6>

</div>

<h1 class="display-4 text-uppercase text-center mb-5">Our Services</h1>

</div>

</div>

<h4 class="text-uppercase mb-3">Car Rental</h4>

<p class="m-0">Kasd dolor no lorem nonumy sit labore tempor at justo rebum rebum stet, justo elitr dolor amet sit sea sed</p>

</div>

</div>

</div>

<h4 class="text-uppercase mb-3">Car Financing</h4>

<p class="m-0">Kasd dolor no lorem nonumy sit labore tempor at justo rebum rebum stet, justo elitr dolor amet sit sea sed</p>

</div>

</div>

</div>

<h4 class="text-uppercase mb-3">Car Inspection</h4>

<p class="m-0">Kasd dolor no lorem nonumy sit labore tempor at justo rebum rebum stet, justo elitr dolor amet sit sea sed</p>

</div>

</div>

</div>

<h4 class="text-uppercase mb-3">Auto Repairing</h4>

<p class="m-0">Kasd dolor no lorem nonumy sit labore tempor at justo rebum rebum stet, justo elitr dolor amet sit sea sed</p>

</div>

</div>

</div>

<h4 class="text-uppercase mb-3">Auto Painting</h4>

<p class="m-0">Kasd dolor no lorem nonumy sit labore tempor at justo rebum rebum stet, justo elitr dolor amet sit sea sed</p>

</div>

</div>

</div>

<h4 class="text-uppercase mb-3">Auto Cleaning</h4>

<p class="m-0">Kasd dolor no lorem nonumy sit labore tempor at justo rebum rebum stet, justo elitr dolor amet sit sea sed</p>

</div>

<h1 class="text-uppercase text-light mb-4">Special Offer For New Members</h1>

<p class="mb-4">Only for Sunday from 1st Jan to 30th Jan 2045</p>

<a class="btn btn-primary mt-2 py-3 px-5" href="">Register Now</a>

</div>

@include('footer')

srchFromAvai.blade.php

@include('header')

<head>

<title>SEARCH </title>

</head>

@if (isset($page))

@if ($page->active)

@endif

@else

@endif

</h1>

@if (isset($page))

@if ($page->active)

@endif

@else

@endif

</h6>

</div>

{{-- <div class="container-fluid py-5">

<h1 class="display-4 text-uppercase text-center mb-5"> Available Cars </h1>

{{-- ['cars'=>$cars, 'drivers' => $drivers,'locations'=>$locations, 'availCars'=> $availCars, 'availDrivers'=> $availDrivers] - -}}

@if (isset($availCars))

<?php $c = 1; ?>

@foreach ($availCars as $rcar)

<div

@if ($c == 2) class="active service-item d-flex flex-column justify-content-center px-4 mb-4" @else class="service-item d-flex flex-column justify-content-center px-4 mb-4" @endif>

<div class="d-flex align-items-center justify-content-center bg-primary ml-n4"

style="width: 150px; height: 100px;">

<?php $carImg = explode(', ', $rcar->image); ?>

<img class="img-fluid mb-4" src="{{ $carImg[2] }}"

style="width:100%; height:100%">

</div>

</div>

<h4 class="text-uppercase mb-3"> {{ $rcar->brand }} {{ $rcar->name }}</h4>

</div>

</div>

</div>

<a class="btn btn-primary px-3"

href="detail/{{ $rcar->id }}">${{ $rcar->price }}.00/Day</a>

</div>

@endforeach

@endif

</div>

</div> --}}

{{--

<h1 class="display-4 text-uppercase text-center mb-5"> Available Drivers </h1>

{{-- ['cars'=>$cars, 'drivers' => $drivers,'locations'=>$locations, 'availCars'=> $availCars, 'availDrivers'=> $availDrivers] --}}

@if (isset($availDrivers))

<?php $c = 1; ?>

@foreach ($availDrivers as $rdr)

<div

@if ($c == 2) class="active service-item d-flex flex-column justify-content-center px-4 mb-4" @else class="service-item d-flex flex-column justify-content-center px-4 mb-4" @endif>

<div class="d-flex align-items-center justify-content-center bg-primary ml-n4"

style="width: 150px; height: 100px;">

<img class="img-fluid mb-4" src="{{ $rdr->image }}"

style="width:100%; height:100%">

</div>

</div>

<span> Experience: {{ $rdr->experience }}</span>

</div>

@endforeach

@endif

</div>

</div> --}}

<h2 class="mb-4">Related Cars</h2>

@foreach ($cars as $rcar)

<?php $carImg = explode(', ', $rcar->image); ?>

<h4 class="text-uppercase mb-4"> {{ $rcar->brand }} {{ $rcar->name }}</h4>

</div>

</div>

</div>

<a class="btn btn-primary px-3" href="detail/{{ $rcar->id }}">${{ $rcar->price }}.00/Day</a>

</div>

@endforeach

</div>

@include('footer')

team.blade.php

@include('header')

<head>

</head>

@if(isset($page)) @if($page->active)

{{$page->title}} @endif

@else

The Team

@endif

</h1>

@if(isset($page)) @if($page->active)

{{$page->title}} @endif

@else

The Team

@endif

</h6>

</div>

@foreach($drivers as $driver)

<img class="img-fluid w-100" src="{{$driver->image}}" style="height:270px" alt="">

</a>

<h4 class="text-uppercase">{{$driver->name}}</h4>

<p class="m-0">Experience: {{$driver->experience}}</p>

</div>

@endforeach

<h4 class="text-uppercase">Sing Queen</h4>

<p class="m-0">Experience: 2</p>

</div>

@include('footer')

testimonial.blade.php

@include('header')

<head>

<title>TESTIMONIAL </title>

</head>

@if(isset($page)) @if($page->active)

{{$page->title}} @endif

@else

Testimonial

@endif

</h1>

@if(isset($page)) @if($page->active)

{{$page->title}} @endif

@else

Testimonial

@endif </h6>

</div>

<h1 class="display-4 text-uppercase text-center mb-5">Our Client's Say</h1>

@foreach($testimonials as $t)

</div>

<h4 class="text-uppercase mb-2">{{ findCustomer($t->book_id)}}</h4>

<i class="mb-2">Rating: <?php for($i = 0; $i < (int)$t->rating; $i++){ ?>

<?php } ?><br></i>

<p class="m-0">{{$t->message}}</p>

</div>

@endforeach

</div>

<h4 class="text-uppercase mb-2">PORTAL QUEEN</h4>

<i class="mb-2">Rating: <?php for($i = 0; $i < 3; $i++){ ?>

<?php } ?><br></i>

<p class="m-0">Kasd dolor no lorem nonumy sit labore tempor at justo rebum rebum stet, justo elitr dolor amet sit sea sed</p>

</div>

@include('footer')

Driver view files

account.blade.php

@include('driver.header')

<head>

<title>Driver Login </title>

</head>

<h1 class="text-info ">My Account</h1>

<h6 class="text-muted mt-2"> You're almost done. <br> Make sure you've saved your work, and<br>

<strong> The information associated with your Royal Car still exists. </strong>

</h6>

<img src="{{$data->image}}" style=" border: 4px solid #cddc39; padding: 2px; border-radius: 50%; border-top-color: #ff5722; border-left-color: #ff5722; width: 25%;height: 15%;">

</div>

<div class="my-2 mb-5 text-muted text-center">Recent Image</div>

</div>

<strong class="card-title"> Driver Account </strong>

</div>

@csrf

<input type="hidden" name="old_img" value="{{ $data->image }}">

<label for="file-input" class=" form-control-label"> Username </label>

</div>

<input type="text" name="name" id="name" placeholder="Username" value="{{ $data->name }}" class="form-control">

</div>

<label for="file-input" class=" form-control-label"> Email Address </label>

</div>

<input type="email" name="email" id="email" placeholder="Email" value="{{ $data->email }}" class="form-control" >

</div>

<label for="file-input" class=" form-control-label"> Phone </label>

</div>

<input type="number" id="file-input" name="phone" class="form-control" value="{{ $data->phone }}" >

</div>

<label for="file-input" class=" form-control-label"> Address </label>

</div>

<input type="text" id="file-input" name="address" class="form-control" value="{{ $data->address }}" >

</div>

<label for="file-input" class=" form-control-label"> Licence No </label>

</div>

<input type="text" id="file-input" name="licenceNo" class="form-control" value="{{ $data->licenceNo }}" >

</div>

</div>

<input type="" id="file-input" name="carNo" class="form-control" value="{{ $data->carNo }}">

</div>

<label for="file-input" class=" form-control-label"> Years of Experience </label>

</div>

<option value="">-- Select --</option>

<option value="1" @if($data->experience==1) selected @endif>1</option>

<option value="3" @if($data->experience==3) selected @endif>3</option>

<option value="5" @if($data->experience==5) selected @endif>5</option>

</select>

</div>

<label for="file-multiple-input" class=" form-control-label"> Set New Image</label>

</div>

</div>

<button class="form-control btn btn-outline-success" type="submit">Update</button>

</form>

</div>

@include('driver.footrr')

driver_portal.blade.php

@include('driver.header')

<head>

<title>Driver_Portal</title>

</head>

@include('driver.searchCom')

</div>

<h5 class="text-primary">TRANSPORT NETWORK SERVICES</h5>

<p>We’ve developed a fully integrated portal to help you achieve this.</p>

</div>

<h5 class="text-success">TRACK DRIVER ACCESS AND BEHAVIOUR</h5>

<p>Track driver training, send news, keep up to date driver profiles.</p>

</div>

<h5 class="text-warning">DRIVER PORTAL</h5>

<p>Safety management compliance tools & tracking for the fleet.</p>

</div>

<span class="visually-hidden">Previous</span>

</button>

</button>

</div>

<h5 class="card-title">Drive For Us</h5>

<p class="card-text">Some quick example text to build on the card title and make up the bulk of the card's content.</p>

<a href="#" class="btn btn-primary">Go somewhere</a>

</div>

<h5 class="card-title">Partner With Car</h5>

<p class="card-text">Some quick example text to build on the card title and make up the bulk of the card's content.</p>

<a href="#" class="btn btn-primary">Go somewhere</a>

</div>

<h5 class="card-title">Fleet Operator</h5>

<p class="card-text">Some quick example text to build on the card title and make up the bulk of the card's content.</p>

<a href="#" class="btn btn-primary">Go somewhere</a>

</div>

@include('driver.footrr')

driverRegister.blade.php

@include('driver.header')

<head>

<title>Driver Registration</title>

</head>

<strong class="card-title"> Driver Registration </strong>

</div>

@csrf

</div>

</div>

<label for="file-input" class=" form-control-label"> Email</label>

</div>

</div>

<label for="file-input" class=" form-control-label"> Password</label>

</div>

</div>

<label for="file-input" class=" form-control-label"> Phone </label>

</div>

</div>

<label for="file-input" class=" form-control-label"> Address </label>

</div>

</div>

<label for="file-input" class=" form-control-label"> Licence No </label>

</div>

</div>

</div>

</div>

<label for="file-input" class=" form-control-label"> Years of Experience </label>

</div>

<option value="">-- Select --</option>

</select>

</div>

<label for="file-multiple-input" class=" form-control-label"> Set New Image</label>

</div>

</div>

<button class="btn btn-primary form-control" type="submit">Register</button>

<p class="text-muted mt-2"> Royal Car Driver salary ranges between ₹ 0.3 Lakhs to ₹ 4.0 Lakhs.</p>

</div>

</form>

<style>

label.error {

color: red;

font-size: 1rem;

display: block;

margin-top: 5px;

}

label.error.fail-alert {

border: 2px solid red;

border-radius: 4px;

line-height: 1;

padding: 2px 0 6px 6px;

background: #ffe6eb;

}

input.valid.success-alert {

border: 2px solid #4CAF50;

color: green;

}

</style>

$(document).ready(function() {

$("#basic-form").validate({

errorClass: "error fail-alert",

validClass: "valid success-alert",

rules: {

name : {

required: true,

minlength: 3

email: {

required: true,

email: true,

password: {

required: true,

phone : {

required: true,

min:5

address: {

required: true,

licenceNo: {

required: true,

carNo: {

required: true,

experience: {

required: true,

adimg:{

required: true,

extension: "jpg|jpeg|png|ico|bmp"

}

messages : {

minlength: "Name should be at least 3 characters"

email: {

email: "The email should be in the format: abc@domain.tld",

required: "** Fill it right now!",

unique: "** Change it right now!",

password: {

required: "Please fill password",

}

});

</script>

</div>

@include('driver.footrr')

earnings.blade.php

@include('driver.header')

<head>

<title>EARNINGs</title>

</head>

<h5 class="card-title w-100 bd-highlight text-light">EARNINGs </h5>

<p class="my-auto flex-shrink-1 bd-highlight">{{ findDri(session()->get('driver_id')) }}</p>

</div>

<thead>

<tr>

<th> Customer </th>

<th> Mobile No </th>

<th> Pickup Date </th>

<th> Payment Mode </th>

<th> Total </th>

</tr>

</thead>

<?php $c=1; $t=0; ?>

@if(isset($onReq))

@foreach($onReq as $item)

<tr>

<td>{{ findCust($item->customer_id) }}</td>

<td>{{ $item->mobile }}</td>

<td>{{ findCar($item->car_id) }}</td>

<td>{{$item->pudate}}</td>

<td>{{$item->paymentMode}}</td>

<td>{{$item->total}}</td>

<?php $t=$t+$item->total; ?>

</tr>

@endforeach

@else

<tr>

<td colspan="8"> No Data Found</td>

</tr>

@endif

</tbody>

<tfoot>

<tr>

<td colspan="6"> <h4 class="text-primary"> Grand Total =</h4> </td>

</tr>

</tfoot>

</table>

$(document).ready( function () {

var table = $('#table_id').DataTable();

} );

</script>

{{-- <script type="text/javascript" language="javascript" >

$(document).ready(function(){

var dataTable = $('#table_id').DataTable({

"processing" : true,

"serverSide" : true,

"order" : [],

"ajax" : {

url:"fetch",

type:"POST"

drawCallback:function(settings)

{

$('#total_order').html(settings.json.total);

}

});

</script> --}}

</div>

@include('driver.footrr')

footrr.blade.php

<h4 class="text-uppercase text-light mb-4">Get In Touch</h4>

<p class="mb-2"><i class="fa fa-map-marker-alt text-white mr-3"></i>123 Street, New York, USA</p>

<p><i class="fa fa-envelope text-white mr-3"></i>info@example.com</p>

<h6 class="text-uppercase text-white py-2">Follow Us</h6>

</div>

<h4 class="text-uppercase text-light mb-4">Usefull Links</h4>

<a class="text-body mb-2" href="#"><i class="fa fa-angle-right text-white mr-2"></i>Private Policy</a>

<a class="text-body mb-2" href="#"><i class="fa fa-angle-right text-white mr-2"></i>Term & Conditions</a>

<a class="text-body mb-2" href="#"><i class="fa fa-angle-right text-white mr-2"></i>New Member Registration</a>

<a class="text-body mb-2" href="#"><i class="fa fa-angle-right text-white mr-2"></i>Affiliate Programme</a>

<a class="text-body mb-2" href="#"><i class="fa fa-angle-right text-white mr-2"></i>Return & Refund</a>

</div>

<h4 class="text-uppercase text-light mb-4">Car Gallery</h4>

</div>

</div>

</div>

</div>

</div>

</div>

<h4 class="text-uppercase text-light mb-4">Newsletter</h4>

<p class="mb-4">Volup amet magna clita tempor. Tempor sea eos vero ipsum. Lorem lorem sit sed elitr sed kasd et</p>

</div>

<i>Lorem sit sed elitr sed kasd et</i>

</div>

<p class="m-0 text-center text-body">Designed by <a href="https://htmlcodex.com">HTML Codex</a></p>

</div>

</body>

</html>

header.blade.php

<!doctype html>

<head>

<style>

input:invalid{

animation: shake .3s infinite;

}

@keyframes shake{

25% { transform: translateX(4px)}

50% { transform: translateX(-4px); border-color: #d10707;}

75% { transform: translateX(4px)}

}

</style>

</head>

<body>

<a class="text-body px-3" href=""><i class="fa fa-envelope mr-2"></i>info@example.com</a>

</div>

<a class="text-body px-3" href="driver"> Drive with Us</a>

</a>

</a>

</a>

</a>

</a>

</div>

<h1 class="text-uppercase text-primary mb-1">Royal Cars</h1>

</a>

</button>

@if(isDriverLogin())

<a class="nav-link" href="driverAccount">Account</a>

<a class="nav-link" href="driverPassword">Change Password</a>

</a>

<li><a class=" nav-link " href="onRequest">On Requests</a></li>

<li><a class=" nav-link" href="bookings">Bookings</a></li>

<li><a class=" nav-link" href="earnings">Earnings</a></li>

</ul>

</li>

<a class="nav-link" href="driverLogout">Logout</a>

@else

<a class="nav-link" href="driverRegister">Register Now</a>

<a class="nav-link" href="driverLogin">Login</a>

@endif

</div>

@if(session()->has('status'))

<span class="badge p-2 fs-6 rounded-pill bg-success">{{session()->get('status')}}</span>

</div>

@endif

@if(session()->has('error'))

<span class="badge p-2 fs-6 rounded-pill bg-danger">{{session()->get('error')}}</span>

</div>

@endif

</div>

</nav>

</div>

@include('driver.header')

<head>

<title>Driver Login </title>

</head>

<h1 class="text-warning ">Get Started</h1>

<h6 class="text-muted mt-4"> Make the most of your time on the road <br> on the platform with the largest

network of <strong> active riders.</strong> </h6>

</div>

<strong class="card-title"> Driver Login </strong>

</div>

@csrf

<label for="file-input" class=" form-control-label"> Email</label>

</div>

</div>

<label for="file-input" class=" form-control-label"> Password</label>

</div>

</div>

<button class="btn btn-dark form-control" type="submit">Login </button>

</div>

</form>

</div>

@include('driver.footrr')

mailchkg.blade.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<!--[if (mso 16)]>

a {text-decoration: none;}

</style>

<![endif]-->

<!--[if gte mso 9]>

<xml>

<o:OfficeDocumentSettings>

<o:AllowPNG></o:AllowPNG>

<o:PixelsPerInch>96</o:PixelsPerInch>

</o:OfficeDocumentSettings>

</xml>

<![endif]-->

</head>

<body>

<!--[if gte mso 9]>

<v:background xmlns:v="urn:schemas-microsoft-com:vml" fill="t">

<v:fill type="tile" color="#FFE7F3"></v:fill>

</v:background>

<![endif]-->

<tbody>

<tr>

<tbody>

<tr>

<tbody>

<tr>

<tbody>

<tr>

<tbody>

<tr>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

<tbody>

<tr>

<tbody>

<tr>

<p style="font-size: 48px; font-family: 'playfair display', georgia, 'times new roman', serif;"><strong><em>    ROYAL CARS</em></strong><br></p>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

<tbody>

<tr>

<tbody>

<tr>

<tbody>

<tr>

<tbody>

<tr>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

<tr>

<tbody>

<tr>

<tbody>

<tr>

<p style="font-size: 22px; font-family: arial, 'helvetica neue', helvetica, sans-serif;"><strong>{{$AdminReply['message']}}</strong></p>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

<tr>

<tbody>

<tr>

<tbody>

<tr>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</div>

</body>

</html>

onBooking.blade.php

@include('driver.header')

<head>

<title>ALL BOOKINGs</title>

</head>

<h5 class="card-title w-100 bd-highlight text-light">BOOKINGs </h5>

<p class="my-auto flex-shrink-1 bd-highlight">{{ findDri(session()->get('driver_id')) }}</p>

</div>

<thead>

<tr>

<th> Customer </th>

<th> Mobile No </th>

<th> Pickup Location </th>

<th> Drop Location </th>

<th> Pickup Date </th>

<th> Pickup Time </th>

<th> Adult Person </th>

<th> Child Person </th>

<th> Message </th>

<th> Payment Mode </th>

<th> Booking Actions </th>

</tr>

</thead>

<?php $c=1; ?>

@foreach($onReq as $item)

<tr @if($item->status=='1') style="background: #ebb96e5b" @endif>

<td>{{ findCust($item->customer_id) }}</td>

<td>{{ $item->mobile }}</td>

<td>{{ findCar($item->car_id) }}</td>

<td>{{ findLoc($item->puloc) }}</td>

<td>{{findLoc($item->drloc)}} </td>

<td>{{$item->pudate}}</td>

<td>{{$item->putime}}</td>

<td>{{$item->personAd}}</td>

<td>{{$item->personCh}}</td>

<td>

</span></td>

<td>{{$item->paymentMode}}</td>

<td>

@if($item->status=='2')

<a href="/bookingConfirm/{{$item->id}}/true" class='text-success fs-5 mx-2' data-toggle="tooltip" data-placement="top" title="Confirm Booking then click it"><i class="fa fa-check-square" aria-hidden="true"></i></a>

<a href="/bookingConfirm/{{$item->id}}/false" class='text-danger fs-5' data-toggle="tooltip" data-placement="top" title="Busy then click it, Automatically cancle other requests on that date" ><i class="fa fa-times-square" aria-hidden="true"></i></a>

@else

<a href="/bookingConfirm/{{$item->id}}/null" class='text-success fs-5 mx-2' data-toggle="tooltip" data-placement="top" @if($item->status) title="Recent: Available. Want to undo" @else title="Recent: Unavailable. Want to undo" @endif> <i class="fa fa-undo" aria-hidden="true"></i> </a>

@endif

</td>

<td>

<a href="/viewTrip/{{$item->id}}" class='text-primary fs-5 mx-2' data-toggle="tooltip" data-placement="top" title="Quality Ride"><i class="fa fa-external-link" aria-hidden="true"></i></a>

</td>

</tr>

@endforeach

</tbody>

</table>

$(document).ready( function () {

$('#table_id').DataTable();

} );

</script>

</div>

@include('driver.footrr')

onRequest.blade.php

@include('driver.header')

<head>

<title>ALL ON REQUESTs</title>

</head>

<h5 class="card-title w-100 bd-highlight text-light">On Requests </h5>

<p class="my-auto flex-shrink-1 bd-highlight">{{ findDri(session()->get('driver_id')) }}</p>

</div>

<thead>

<tr>

<th> Customer </th>

<th> Pickup Location </th>

<th> Drop Location </th>

<th> Pickup Date </th>

<th> Pickup Time </th>

<th> Available </th>

</tr>

</thead>

<tbody>

<?php $c=1; ?>

@foreach($onReq as $item)

<tr @if($item->available) style="background: #ebb96e5b" @endif>

<td>{{ findCust($item->customer_id) }}</td>

{{-- <td>{{ findDri($item->driver_id)}}</td> --}}

<td>{{ findCar($item->car_id) }}</td>

<td>{{ findLoc($item->puloc) }}</td>

<td>{{ findLoc($item->droploc) }}</td>

<td>{{$item->pudate}}</td>

<td>{{$item->putime}}</td>

<td>

@if($item->mail)

@else

@csrf

</form>

@endif

</td>

<td>

@if($item->available==null)

<a href="dvr_availunavail/{{$item->id}}/true" class='text-success fs-5 mx-4' data-toggle="tooltip" data-placement="top" title="Available then click it"><i class="fa fa-check-square" aria-hidden="true"></i></a>

<a href="dvr_availunavail/{{$item->id}}/false" class='text-danger fs-5' data-toggle="tooltip" data-placement="top" title="Busy then click it" ><i class="fa fa-times-square" aria-hidden="true"></i></a>

@else

<a href="dvr_availunavail/{{$item->id}}/null" class='text-success fs-5 mx-4' data-toggle="tooltip" data-placement="top" @if($item->available) title="Recent: Available. Want to undo" @else title="Recent: Unavailable. Want to undo" @endif> <i class="fa fa-undo" aria-hidden="true"></i> </a>

@endif

</td>

</tr>

@endforeach

</tbody>

</table>

$(document).ready( function () {

$('#table_id').DataTable();

} );

</script>

</div>

<a href="#" class="btn"> Check Bookings <i class="fa fa-arrow-right" aria-hidden="true"></i>

</a>

</div>

@include('driver.footrr')

pswdchng.blade.php

@include('driver.header')

<head>

<title>Driver Change Password </title>

</head>

<h1 class="text-success ">My Profile</h1>

<h6 class="text-muted mt-4"><strong>Keep it Up!</strong> <br>Remember: The longer and more random your password, the better! </h6>

</div>

<strong class="card-title"> Driver Change Password </strong>

</div>

@csrf

<label for="file-input" class=" form-control-label"> Old Password</label>

</div>

</div>

<label for="file-input" class=" form-control-label"> New Password</label>

</div>

</div>

<label for="file-input" class=" form-control-label"> Confirm Password</label>

</div>

</div>

<button class="btn btn-outline-success form-control" type="submit"> Update Password </button>

</div>

</form>

</div>

@include('driver.footrr')

search_bkkngs.blade.php

@include('driver.header')

<head>

<title>Driver_Portal</title>

</head>

@include('driver.searchCom')

<h5 class="card-title w-100 bd-highlight text-light">Search Results on Booking</h5>

<p class="my-auto flex-shrink-1 bd-highlight">{{ findDri(session()->get('driver_id')) }}</p>

</div>

<thead>

<tr>

<th> Customer </th>

<th> Mobile No </th>

<th> Pickup Location </th>

<th> Drop Location </th>

<th> Pickup Date </th>

<th> Pickup Time </th>

<th> Adult Person </th>

<th> Child Person </th>

<th> Message </th>

<th> Payment Mode </th>

<th> Booking Actions </th>

</tr>

</thead>

<?php $c=1; ?>

@if(isset($data))

@foreach($data as $item)

<tr @if($item->status=='1') style="background: #ebb96e5b" @endif>

<td>{{ findCust($item->customer_id) }}</td>

<td>{{ $item->mobile }}</td>

<td>{{ findCar($item->car_id) }}</td>

<td>{{ findLoc($item->puloc) }}</td>

<td>{{findLoc($item->drloc)}} </td>

<td>{{$item->pudate}}</td>

<td>{{$item->putime}}</td>

<td>{{$item->personAd}}</td>

<td>{{$item->personCh}}</td>

<td>

</span></td>

<td>{{$item->paymentMode}}</td>

<td>

@if($item->status=='2')

<a href="bookingConfirm/{{$item->id}}/true" class='text-success fs-5 mx-4' data-toggle="tooltip" data-placement="top" title="Confirm Booking then click it"><i class="fa fa-check-square" aria-hidden="true"></i></a>

<a href="bookingConfirm/{{$item->id}}/false" class='text-danger fs-5' data-toggle="tooltip" data-placement="top" title="Busy then click it, Automatically cancle other requests on that date" ><i class="fa fa-times-square" aria-hidden="true"></i></a>

@else

<a href="bookingConfirm/{{$item->id}}/null" class='text-success fs-5 mx-4' data-toggle="tooltip" data-placement="top" @if($item->status) title="Recent: Available. Want to undo" @else title="Recent: Unavailable. Want to undo" @endif> <i class="fa fa-undo" aria-hidden="true"></i> </a>

@endif

</td>

<td>

<a href="/viewTrip/{{$item->id}}" class='text-primary fs-5 mx-2' data-toggle="tooltip" data-placement="top" title="Quality Ride"><i class="fa fa-external-link" aria-hidden="true"></i></a>

</td>

</tr>

@endforeach

@else

<tr>

<td colspan="13"> No Data Found</td>

</tr>

@endif

</tbody>

</table>

$(document).ready( function () {

$('#table_id').DataTable();

} );

</script>

</div>

@include('driver.footrr')

searchCom.blade.php

@csrf

<option value="" selected>Pickup Location</option>

@foreach ($locations as $loc)

<option value="{{ $loc->id }}"

@if (isset($req)) @if ($req->puloc == $loc->id) selected @endif

@endif>{{ $loc->area }}</option>

@endforeach

</select>

</div>

<option value="" selected>Drop Location</option>

@foreach ($locations as $loc)

<option value="{{ $loc->id }}"

@if (isset($req)) @if ($req->drloc == $loc->id) selected @endif

@endif>{{ $loc->area }}</option>

@endforeach

</select>

</div>

<input type="date" id="pudateh22" name="pudate"

class="p-4 form-control "@if (isset($req)) value="{{ $req->pudate }}" @endif />

</div>

var today = new Date();

var dd = String(today.getDate()).padStart(2, '0');

var mm = String(today.getMonth() + 1).padStart(2, '0');

var yyyy = today.getFullYear();

today = yyyy + '-' + mm + '-' + dd;

$('#pudateh22').attr('min',today);

</script>

<option value="" selected>Select A Car</option>

@foreach ($cars as $car)

<option value="{{ $car->id }}"

@if (isset($req)) @if ($req->car_id == $car->id) selected @endif

@endif> {{ $car->name }}</option>

@endforeach

</select>

</div>

<option value="" selected>Customer</option>

@foreach ($customers as $customer)

<option value="{{ $customer->id }}"

@if (isset($req)) @if ($req->customerSel == $customer->id) selected @endif

@endif> {{ $customer->name }}</option>

@endforeach

</select>

</div>

<button class="btn btn-primary btn-block mb-3" type="submit" style="height: 50px;">Search Now</button>

</div>

</form>

function checking2() {

puloc = document.getElementById('puloch').value;

drloc = document.getElementById('drloch').value;

pudate = document.getElementById('pudateh').value;

putime = document.getElementById('putimeh').value;

carSel = document.getElementById('car_idh').value;

var varDate = new Date(pudate); //dd-mm-YYYY

var today = new Date();

// console.log(puloc ,drloc ,pudate,putime, driverSel, carSel);

// if(puloc == drloc)

// {

// alert('Pickup location and Drop location cannot be same');

// event.preventDefault();

// return false;

// }

if (pudate == '') {

alert('Date cannot be blank');

event.preventDefault();

return false;

}

return true;

}

</script>

</div>

viewTrip.blade.php

@include('driver.header')

<head>

</head>

<strong class="card-title"> Customer Trip View </strong>

</div>

<label for="file-input" class=" form-control-label"> Customer Name</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ findCust($item->customer_id) }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Mobile No</label>

</div>

<input class="form-control" type="text" name="name" value="{{ $item->mobile }}" readonly>

</div>

</div>

<input class="form-control" type="text" name="name"

value="{{ findCar($item->car_id) }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Pickup Location</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ findLoc($item->puloc) }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Drop Location</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ findLoc($item->drloc) }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> PickUp Date</label>

</div>

<input class="form-control" type="text" name="name" value="{{ $item->pudate }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> PickUp Time</label>

</div>

<input class="form-control" type="text" name="name" value="{{ $item->putime }}" readonly>

</div>

<label for="file-input" class=" form-control-label">Adult Persons</label>

</div>

<input class="form-control" type="text" name="name" value="{{ $item->personAd }}" readonly>

</div>

<label for="file-input" class=" form-control-label">Child Persons</label>

</div>

<input class="form-control" type="text" name="name" value="{{ $item->personCh }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Message</label>

</div>

<input class="form-control" type="text" name="name" value="{{ $item->message }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Price </label>

</div>

<input class="form-control" type="text" name="name"

value="$ {{ $item->total }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Payment Mode</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->paymentMode }}" readonly>

</div>

<strong class="card-title"> Driver Action </strong>

</div>

<label for="file-input" class=" form-control-label"> Current Status</label>

@if ($item->bookStatus == '0' && $item->status == '1')

<i class="fa fa-car" aria-hidden="true"></i> Trip Started

@elseif($item->bookStatus == '1')

<i class="fa fa-street-view" aria-hidden="true"></i> Arrived At Location

@elseif($item->bookStatus == '2')

<i class="fa fa-id-badge" aria-hidden="true"></i> Pickup Customer Done

@elseif($item->bookStatus == '3')

<i class="fa fa-blind" aria-hidden="true"></i> Drop Customer

@elseif($item->bookStatus == '4')

<i class="fa fa-check" aria-hidden="true"></i> Payment Success

@elseif($item->bookStatus == '5')

<i class="fa fa-bell" aria-hidden="true"></i> Payment Due

@elseif($item->bookStatus == '6')

<i class="fa fa-times " aria-hidden="true"></i> Problem Case Arries

@endif

</div>

<label for="file-input" class=" form-control-label"> Change Status</label>

<a href="/regTrips/{{ $item->id }}/start" class='form-control text-secondary fs-5 mx-2'

data-toggle="tooltip" data-placement="top" title="Start This Ride"><i class="fa fa-car"

aria-hidden="true"></i> Start This Ride</a>

<a href="/regTrips/{{ $item->id }}/arrive" class='form-control text-success fs-5 mx-2'

data-toggle="tooltip" data-placement="top" title="Arrived At Location"><i

class="fa fa-street-view" aria-hidden="true"></i>

Arrived At Location</a>

<a href="/regTrips/{{ $item->id }}/pickup" class='form-control text-info fs-5 mx-2'

data-toggle="tooltip" data-placement="top" title="Pickup Customer Done"><i

class="fa fa-id-badge" aria-hidden="true"></i> Pickup

Customer Done</a>

<a href="/regTrips/{{ $item->id }}/drop" class='form-control text-primary fs-5 mx-2'

data-toggle="tooltip" data-placement="top" title="Drop Customer"><i class="fa fa-blind"

aria-hidden="true"></i> Drop

Customer</a>

<a href="/regTrips/{{ $item->id }}/paySuccess"

class='form-control text-Success fs-5 mx-2' data-toggle="tooltip" data-placement="top"

title="Payment Success"><i class="fa fa-check" aria-hidden="true"></i> Payment

Success</a>

<a href="/regTrips/{{ $item->id }}/payDue" class=' form-control text-warning fs-5 mx-2'

data-toggle="tooltip" data-placement="top" title="Payment Due"><i class="fa fa-bell"

aria-hidden="true"></i> Payment

Due</a>

<a href="/regTrips/{{ $item->id }}/sos" class='text-danger form-control fs-5 mx-2'

data-toggle="tooltip" data-placement="top" title="Exception Case"><i class="fa fa-times"

aria-hidden="true"></i> Any Problem</a>

</div>

<label for="file-input" class=" form-control-label"> Customer Feedback</label>

<a href="/feedbackMailSend/{{$item->id}}" class='form-control fs-5 mx-2'> <i class="fa fa-envelope text-info"

aria-hidden="true"></i> Feedback Form <i class="fa fa-paper-plane text-success"

aria-hidden="true"></i> </a>

</div>

@include('driver.footrr')

Customer blade view files

chkBooking.blade.php

<!DOCTYPE html>

<head>

<title>Bookings</title>

media="all">

media="all">

</head>

@include('admin.adcommon.sidemenu')

@if (session()->has('status'))

<strong>{{ session()->get('status') }}</strong>

</button>

</div>

@endif

@if (session()->has('error'))

<strong>{{ session()->get('error') }}</strong>

</button>

</div>

@endif

<h2 class="title-1 mr-5">Booking Table</h2>

<button type="submit" class="btn" title="search" onclick="srchval()"><i

class="fa fa-search" aria-hidden="true"></i>

</button>

</div>

</form>

function srchval() {

data = document.getElementById('srch').value;

if (!data) {

alert("Search Fields are Empty!");

event.preventDefault();

return false;

}

</script>

</div>

@csrf

<input type="date" class="form-control input-sm" id="fromdate" name="start_date" @if(isset($req)) value={{$req->start_date}} @endif >

</div>

<input type="date" class="form-control input-sm" id="todate" name="end_date" @if(isset($req)) value={{$req->end_date}} @endif >

</div>

</button>

</div>

</form>

function dateval(){

fromdate=document.getElementById('fromdate').value;

todate=document.getElementById('todate').value;

// console.log(fromdate);

// console.log(todate);

if (Date.parse(fromdate) > Date.parse(todate)) {

alert("Invalid Date Range!\nStart Date cannot be after End Date!")

fromdate=Date;

event.preventDefault();

return false;

}

if(!fromdate || !todate){

alert("Date Fields are Empty!");

event.preventDefault();

return false;

}

</script>

</div>

<thead>

<tr>

<th> Driver Name </th>

<th> Customer Name </th>

<th> Mobile </th>

<th> Pickup Location </th>

<th> Drop Location </th>

<th> Pickup Date </th>

<th> Pickup Time </th>

<th> Adults </th>

<th> Childs </th>

<th> Message </th>

<th> Payment Mode </th>

<th> Total </th>

<th> Check Status </th>

</tr>

</thead>

<tbody>

<?php $c = 1; ?>{{-- ['adeu' => $adfn, 'data'=>$data, 'cust'=>$cust, 'car'=>$car, 'driver'=>$driver --}}

@if(count($data)>0)

@foreach ($data as $item)

<tr @if ($item->available) style="background: #ebb96e5b" @endif>

<td>{{ findCar($item->car_id) }}</td>

<td>{{ findDri($item->driver_id)}}</td>

<td>{{ findCust($item->customer_id)}}</td>

<td>{{ $item->mobile }}</td>

<td>{{ findLoc($item->puloc) }}</td>

<td>{{ findLoc($item->drloc) }}</td>

<td>{{ $item->pudate }}</td>

<td>{{ $item->putime }}</td>

<td>{{ $item->personAd }}</td>

<td>{{ $item->personCh }}</td>

<td>{{ $item->message }}</td>

<td>{{ $item->paymentMode }}</td>

<td>{{ $item->total }}</td>

<td>

@if ($item->status=='1')

<a href="/myTrip2/{{$item->id}}" class='text-success' data-toggle="tooltip" data-placement="top" title="Show Ride Details"> Booking Confirm <i class="fa fa-arrow-circle-right"></i></a>

@elseif($item->status=='0')

<h5 class="text-dark">Booking Cancle</h5>

@else

<h5 class="text-info">No Response</h5>

@endif

</td>

</tr>

@endforeach

@else

<td colspan="15" class="text-center"> No Data Found</td>

@endif

</tbody>

</table>

</div>

@if(!isset($srchbck) )

@if(!isset($req))

</div>

@endif

@if(isset($srchbck) || isset($req))

</div>

@endif

</div>

</p>

</div>

</body>

</html>

chkRequest.blade.php

<!DOCTYPE html>

<head>

<title>Car Availability</title>

media="all">

media="all">

</head>

@include('admin.adcommon.sidemenu')

@if (session()->has('status'))

<strong>{{ session()->get('status') }}</strong>

</button>

</div>

@endif

@if (session()->has('error'))

<strong>{{ session()->get('error') }}</strong>

</button>

</div>

@endif

<h2 class="title-1 mr-2">Availability Table</h2>

<button type="submit" class="btn" title="search" onclick="srchval()"><i

class="fa fa-search" aria-hidden="true"></i>

</button>

</div>

</form>

function srchval() {

data = document.getElementById('srch').value;

if (!data) {

alert("Search Fields are Empty!");

event.preventDefault();

return false;

}

</script>

</div>

@csrf

<input type="date" class="form-control input-sm" id="fromdate" name="start_date" @if(isset($req)) value={{$req->start_date}} @endif >

</div>

<input type="date" class="form-control input-sm" id="todate" name="end_date" @if(isset($req)) value={{$req->end_date}} @endif >

</div>

</button>

</div>

</form>

function dateval(){

fromdate=document.getElementById('fromdate').value;

todate=document.getElementById('todate').value;

// console.log(fromdate);

// console.log(todate);

if (Date.parse(fromdate) > Date.parse(todate)) {

alert("Invalid Date Range!\nStart Date cannot be after End Date!")

fromdate=Date;

event.preventDefault();

return false;

}

if(!fromdate || !todate){

alert("Date Fields are Empty!");

event.preventDefault();

return false;

}

</script>

</div>

<thead>

<tr>

<th> Customer </th>

<th> Driver </th>

<th> Pickup Location </th>

<th> Drop Location </th>

<th> Pickup Date </th>

<th> Pickup Time </th>

<th> Available </th>

</tr>

</thead>

<tbody>

<?php $c = 1; ?>{{-- ['adeu' => $adfn, 'data'=>$data, 'cust'=>$cust, 'car'=>$car, 'driver'=>$driver --}}

@if(count($data)>0)

@foreach ($data as $item)

<tr @if ($item->available) style="background: #ebb96e5b" @endif>

<td>{{ findCust($item->customer_id) }}</td>

<td>{{ findDri($item->driver_id)}}</td>

<td>{{ findCar($item->car_id) }}</td>

<td>{{ findLoc($item->puloc) }}</td>

<td>{{ findLoc($item->droploc) }}</td>

<td>{{ $item->pudate }}</td>

<td>{{ $item->putime }}</td>

<td>

@if ($item->mail)

@else

<h5 class="text-info">No Mails</h5>

@endif

</td>

<td>

@if ($item->available == null)

<h5 class="text-info">No response</h5>

@else

@if($item->available == 1)

<h5 class="text-success">Available</h5>

@else

<h5 class="text-danger">Unavailable</h5>

@endif

</td>

</tr>

@endforeach

@else

<td colspan="10" class="text-center"> No Data Found</td>

@endif

</tbody>

</table>

</div>

@if(!isset($srchbck) )

@if(!isset($req))

</div>

@endif

@if(isset($srchbck)|| isset($req))

</div>

@endif

</div>

</p>

</div>

</body>

</html>

fdFormSubmit.blade.php

<!doctype html>

<head>

<title>Feedback Form </title>

</head>

<body>

<h1 class="text-uppercase text-warning mb-1 mx-5"> <i> Royal Cars </i></h1>

<h4 class="text-uppercase text-light my-auto">Feedback Form</h4>

</div>

<strong class="card-title"> Feedback Form </strong>

</div>

@csrf

<textarea class="border border-success " name="message" cols="80" rows="5"

placeholder=" Hi, Share your thoughts, You may have a beautiful ride."></textarea>

<br>

<input type="radio" value="1" class="mx-2" name="rating" required="required"> <i

class="fa fa-star text-warning"></i>

<input type="radio" value="2" class="mx-2" name="rating" required="required"> <i

class="fa fa-star text-warning"></i> <i class="fa fa-star text-warning"></i>

<input type="radio" value="3" class="mx-2" name="rating" required="required"> <i

class="fa fa-star text-warning"></i> <i class="fa fa-star text-warning"></i> <i

class="fa fa-star text-warning"></i>

<input type="radio" value="4" class="mx-2" name="rating" required="required"> <i

class="fa fa-star text-warning"></i> <i class="fa fa-star text-warning"></i> <i

class="fa fa-star text-warning"></i> <i class="fa fa-star text-warning"></i>

<input type="radio" value="5" class="mx-2" name="rating" required="required"> <i

class="fa fa-star text-warning"></i> <i class="fa fa-star text-warning"></i> <i

class="fa fa-star text-warning"></i>

</div>

<i class="fa fa-arrow-right "></i> Submit

</button>

</form>

<p>Have a beautiful Ride ahead !! Best Wishes from "Royal Cars.</p>

</div>

</body>

</html>

fdmail.blade.php

<!DOCTYPE html>

<html>

<head>

<title>FeedBack Mail</title>

</head>

<body>

<tbody>

<tr>

<td>

Hello!

</td>

</tr>

<tr>

<td>

Please click the button below for feedback your last ride.

</td>

</tr>

<tr>

<td><a style='color:green;' href='http://cardekho.loc/addTesti/{{$data}}'> Feedback Form </a> </td>

</tr>

<tr>

<td>

If you did not share this feedback, no further action is required.

</td>

</tr>

<tr>

<td>

Regards,

</td>

</tr>

<tr>

<td>Royal Cars</td>

</tr>

</tbody>

</table>

</div>

</body>

</html>

myTrip.blade.php

<!DOCTYPE html>

<head>

media="all">

media="all">

</head>

@include('admin.adcommon.sidemenu')

<head>

<title>My Trip Details</title>

</head>

<strong class="card-title"> Customer Trip View </strong>

<span class="ml-5 badge badge-light"> {{feedbackDone($item->id)}}</span>

</div>

<label for="file-input" class=" form-control-label"> Customer Name</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ findCust($item->customer_id) }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Mobile No</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->mobile }}" readonly>

</div>

</div>

<input class="form-control" type="text" name="name"

value="{{ findCar($item->car_id) }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Pickup Location</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ findLoc($item->puloc) }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Drop Location</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ findLoc($item->drloc) }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> PickUp

Date</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->pudate }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> PickUp

Time</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->putime }}" readonly>

</div>

<label for="file-input" class=" form-control-label">Adult

Persons</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->personAd }}" readonly>

</div>

<label for="file-input" class=" form-control-label">Child

Persons</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->personCh }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Message</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->message }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Price </label>

</div>

<input class="form-control" type="text" name="name"

value="$ {{ $item->total }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Payment

Mode</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->paymentMode }}" readonly>

</div>

<strong class="card-title"> Driver Details </strong>

</div>

<label for="file-input" class=" form-control-label"> Current

Status</label>

@if ($item->bookStatus == '0' && $item->status == '1')

<i class="fa fa-car text-secondary" aria-hidden="true"></i> Trip

Started

@elseif($item->bookStatus == '1')

Arrived At Location

@elseif($item->bookStatus == '2')

Pickup Customer

@elseif($item->bookStatus == '3')

<i class="fa fa-blind text-warning" aria-hidden="true"></i> Drop Customer

@elseif($item->bookStatus == '4')

Payment Success

@elseif($item->bookStatus == '5')

<i class="fa fa-bell text-warning" aria-hidden="true"></i> Payment Due

@elseif($item->bookStatus == '6')

<i class="fa fa-times text-danger" aria-hidden="true"></i> SOS

@endif

</div>

<label for="file-input" class=" form-control-label"> Driver Ratings:</label>

<?php for($i = 0; $i < ratingAvg($driverData->id); $i++){ ?>

<?php } ?><br>

<label for="file-input" class=" form-control-label"> Driver Name</label>

<input class="form-control" type="text" name="name"

value="{{ findDri($item->driver_id) }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Phone No:</label>

<input class="form-control" type="text" name="phone"

value="{{ $driverData->phone }}" readonly>

</div>

<input class="form-control" type="text" name="phone"

value="{{ $driverData->carNo }}" readonly>

</div>

<label for="file-input" class=" form-control-label">Experience:</label>

<input class="form-control" type="text" name="phone"

value="{{ $driverData->experience }} yrs" readonly>

</div>

</body>

</html>

Admin blade view files

inside adcommon folder files

ftrjq.blade.php

</script>

</script>

</script>

</script>

{{-- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script> --}}

</body>

</html>

header.blade.php

<!DOCTYPE html>

<head>

</head>

sidemenu.blade.php

</a>

</span>

</button>

</div>

<i class="fas fa-tachometer-alt"></i>Dashboard</a>

</li>

@if(auth()->user())

<?php $rolelist= explode(', ', auth()->user()->role_id); ?>

@foreach($rolelist as $role)

@if($role == 1)

<i class="fas fa-copy"></i>Enquiry</a>

<li>

<a href="/admail">Mails</a>

</li>

</ul>

</li>

<i class="fas fa-th-list"></i> Banner</a>

</li>

<i class="fas fa-user"></i> Users</a>

</li>

<i class="fas fa-user"></i> Users</a>

</li>

</li>

@endif

@if($role== 2)

<i class="fas fa-user"></i> Driver</a>

</li>

@endif

@if($role== 3)

<i class="fas fa-user"></i> Customer</a>

</li>

@endif

@endforeach

@endif

</ul>

</div>

</nav>

</header>

</a>

</div>

<i class="fas fa-tachometer-alt"></i> Dashboard</a>

</li>

@if(userRole()==1)

<i class="fas fa-user"></i> Customers</a>

</li>

<i class="fas fa-copy"></i>Enquiry</a>

<li>

<i class="fas fa-envelope"></i> Mails</a>

</li>

<i class="fas fa-braille"></i> Availability</a>

</li>

<i class="fa fa-list-alt"></i> Bookings</a>

</li>

<i class="fa fa-bar-chart-o"></i> Sales Report</a>

</li>

</ul>

</li>

<i class="fas fa-th-list"></i> Banner</a>

</li>

<i class="fas fa-id-card"></i> Drivers</a>

</li>

<i class="fas fa-user"></i> All Users</a>

</li>

<i class="fas fa-user"></i> Testimonials</a>

</li>

</li>

@elseif(userRole()==2)

<i class="fas fa-user"></i> Driver</a>

</li>

@elseif(userRole()==3)

<i class="fas fa-user"></i> Car Availability</a>

</li>

<i class="fas fa-user"></i> Car Bookings</a>

</li>

<i class="fas fa-user"></i> Royal Cars</a>

</li>

@endif

</ul>

</nav>

</div>

</aside>

<img src="{{$adeu->image}}" alt="{{ session()->get('adeu')['name']}}" />

</div>

<a class="js-acc-btn" href="#">{{ session()->get('adeu')['name']}}</a>

</div>

<img src="{{$adeu->image}}" alt="{{ session()->get('adeu')['name']}}" />

</a>

</div>

<a href="#">{{ session()->get('adeu')['name']}}</a>

</h5>

<span class="email">{{ session()->get('adeu')['email']}}</span>

</div>

<i class="zmdi zmdi-account"></i>Account</a>

</div>

<i class="zmdi zmdi-account"></i>Reset Password</a>

</div>

<i class="zmdi zmdi-power"></i>Logout</a>

</div>

</header>

adaccount.blade.php

@include('admin.adcommon.header')

<head>

<title>Admin Account</title>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('message'))

<strong>{{session()->get('message')}}</strong>

</button>

</div>

@endif

<h2 class="title-1">Admin Account Details </h2>

</div>

<img src="{{$adeu->image}}" width="200px" alt="">

<label for="">Recent Image</label>

</div>

<h2 style="text-align:right;float:right;" class="btn btn-info"> {{$data2[0]->title}} </h2>

</div>

@csrf

<input type="hidden" name="old_img" value="{{$adeu->image}}">

<label>Username</label>

</div>

<label>Email Address</label>

<input class="au-input au-input--full" type="email" name="email" id="email" placeholder="Email" value="{{$adeu->email}}">

</div>

<label>Upload Image</label>

</div>

<button class="au-btn au-btn--block au-btn--green m-b-20" type="submit">Update</button>

</form>

</div>

<style>

label.error {

color: red;

font-size: 1rem;

display: block;

margin-top: 5px;

}

label.error.fail-alert {

border: 2px solid red;

border-radius: 4px;

line-height: 1;

padding: 2px 0 6px 6px;

background: #ffe6eb;

}

input.valid.success-alert {

border: 2px solid #4CAF50;

color: green;

}

</style>

$(document).ready(function() {

$("#basic-form").validate({

errorClass: "error fail-alert",

validClass: "valid success-alert",

rules: {

name : {

required: true,

minlength: 3

email: {

required: true,

email: true,

password: {

required: true,

},phone:{

required: true,

min:999999999,

max:9999999999

},adimg:{

extension: "jpg|jpeg|png|ico|bmp"

}

messages : {

minlength: "** Name should be at least 3 characters"

email: {

email: "** The email should be in the format: abc@domain.tld",

required: "** Fill it right now!",

unique: "** Change it right now!",

password: {

required: "** Please fill password",

},phone:{

required: "** Please fill phone",

min: "** Not lesser than 10 digit number",

max: "** Not greater than 10 digit number",

}

});

</script>

</div>

</div>

@include('admin.adcommon.ftrjq')

add_user_role.blade.php

@include('admin.adcommon.header')

<head>

<title>Create User Page</title>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('wrlgcr'))

<strong>{{session()->get('wrlgcr')}}</strong>

</button>

</div>

@endif

<h2 class="title-1">Create new User </h2>

</div>

<strong class="card-title">Create new User </strong>

@if (count($errors) > 0)

<ul>

@foreach ($errors->all() as $error)

<li>{{ $error }}</li>

@endforeach

</ul>

</div>

@endif

</div>

@csrf

</div>

</div>

<label for="file-input" class=" form-control-label"> Email</label>

</div>

</div>

<label for="file-input" class=" form-control-label"> Password</label>

</div>

</div>

</div>

@foreach($eduall as $role)

@if(strtoupper($role->title)!='ADMIN')

<input type="radio" id="{{$role->id}}" name="roles" value="{{$role->id}}" class="form-check-input mx-3"> {{$role->title}}

</label>

@endif

@endforeach

</div>

{{-- body 'adeu' => $adfn, 'user'=> $usr , 'eduall' => $rolesall, 'data2' =>$data2 --}}

</div>

<label for="file-multiple-input" class=" form-control-label"> Set New Image </label>

</div>

</div>

<button class="au-btn au-btn--block au-btn--green " type="submit"> Update </button>

</form>

</div>

</div>

@include('admin.adcommon.ftrjq')

addpage.blade.php

@include('admin.adcommon.header')

<head>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('wrlgcr'))

<strong>{{session()->get('wrlgcr')}}</strong>

</button>

</div>

@endif

<h2 class="title-1">Create Page Banner & Title </h2>

</div>

<strong class="card-title"> Banner Create Page </strong>

@if (count($errors) > 0)

<ul>

@foreach ($errors->all() as $error)

<li>{{ $error }}</li>

@endforeach

</ul>

</div>

@endif

</div>

@csrf

</div>

</div>

<label for="file-input" class=" form-control-label">Page Title</label>

</div>

</div>

<label for="file-input" class=" form-control-label">Page Active</label>

</div>

<input type="radio" id="file-input" name="pgact" class="mx-5" value="1"> <span for="">Active</span>

<input type="radio" id="file-input" name="pgact" value="0" class="mx-5"><span for="" >Inactive</span>

</div>

<label for="file-multiple-input" class=" form-control-label">Multiple File input</label>

</div>

</div>

<button class="au-btn au-btn--block au-btn--green m-b-20" type="submit">Create</button>

</form>

</div>

</div>

@include('admin.adcommon.ftrjq')

adShowTrip.blade.php

<!DOCTYPE html>

<head>

media="all">

media="all">

</head>

@include('admin.adcommon.sidemenu')

<head>

<title>My Trip Details</title>

</head>

<strong class="card-title"> Customer Trip View </strong>

</div>

<label for="file-input" class=" form-control-label"> Customer

Name</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ findCust($item->customer_id) }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Mobile No</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->mobile }}" readonly>

</div>

</div>

<input class="form-control" type="text" name="name"

value="{{ findCar($item->car_id) }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Pickup

Location</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ findLoc($item->puloc) }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Drop

Location</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ findLoc($item->drloc) }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> PickUp

Date</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->pudate }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> PickUp

Time</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->putime }}" readonly>

</div>

<label for="file-input" class=" form-control-label">Adult

Persons</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->personAd }}" readonly>

</div>

<label for="file-input" class=" form-control-label">Child

Persons</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->personCh }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Message</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->message }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Price </label>

</div>

<input class="form-control" type="text" name="name"

value="$ {{ $item->total }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Payment

Mode</label>

</div>

<input class="form-control" type="text" name="name"

value="{{ $item->paymentMode }}" readonly>

</div>

<strong class="card-title"> Driver Details </strong>

<?php

for($i = 0; $i < $driverData->experience; $i++){

<?php } ?>

</div>

<label for="file-input" class=" form-control-label"> Current

Status</label>

@if ($item->bookStatus == '0' && $item->status == '1')

<i class="fa fa-car text-secondary" aria-hidden="true"></i> Trip

Started

@elseif($item->bookStatus == '1')

Arrived At Location

@elseif($item->bookStatus == '2')

Pickup Customer

@elseif($item->bookStatus == '3')

<i class="fa fa-blind text-warning" aria-hidden="true"></i> Drop Customer

@elseif($item->bookStatus == '4')

Payment Success

@elseif($item->bookStatus == '5')

<i class="fa fa-bell text-warning" aria-hidden="true"></i> Payment Due

@elseif($item->bookStatus == '6')

<i class="fa fa-times text-danger" aria-hidden="true"></i> SOS

@endif

</div>

<label for="file-input" class=" form-control-label"> Driver

Details:</label><br>

<label for="file-input" class=" form-control-label"> Driver Name</label>

<input class="form-control" type="text" name="name"

value="{{ findDri($item->driver_id) }}" readonly>

</div>

<label for="file-input" class=" form-control-label"> Phone No:</label>

<input class="form-control" type="text" name="phone"

value="{{ $driverData->phone }}" readonly>

</div>

<input class="form-control" type="text" name="phone"

value="{{ $driverData->carNo }}" readonly>

</div>

<label for="file-input" class=" form-control-label">Experience:</label>

<input class="form-control" type="text" name="phone"

value="{{$driverData->experience}} yrs" readonly>

</div>

</body>

</html>

allDr_Cu.blade.php

<!DOCTYPE html>

<head>

<title>All User Roles</title>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('status'))

<strong>{{session()->get('status')}}</strong>

</button>

</div>

@endif

@if(session()->has('error'))

<strong>{{session()->get('error')}}</strong>

</button>

</div>

@endif

<h2 class="title-1">All Users Table</h2>

</div>

@csrf

</div>

</button>

</div>

</form>

<option value="/allDr_Cu">Please select All</option>

<option value="/userSel/customer" @if(isset($srch)) @if($srch=='customer') selected @endif @endif> Customer </option></a>

<option value="/userSel/driver" @if(isset($srch)) @if($srch=='driver') selected @endif @endif>Driver</option>

</select>

</div>

function urlHandler(value) {

window.location.assign(`${value}`);

}

</script>

{{-- <script src="https://code.jquery.com/jquery-3.6.1.min.js"></script>

--}}

{{-- <script type="text/javascript">

$("document").ready(function () {

$('select[name="select"]').on('change', function () {

var catType = $(this).val();

console.log(catType);

if (catType) {

$.ajax({

url: '/allDr_CuJQ/' + catType,

type: "GET",

dataType: "json",

success: function (data) {

console.log('Data found from link'+ data);

// $('select[name="subcategory"]').empty();

// $.each(data, function (key, value) {

// $('select[name="subcategory"]').append('<td>' + value + '</td>');

// })

}

})

} else {

$('select[name="subcategory"]').empty();

}

});

</script> --}}

function srchval(){

data=document.getElementById('srch').value;

if(!data){

alert("Search Fields are Empty!");

event.preventDefault();

return false;

}

let pattern = /[^0-9]/g;

let result = data.match(pattern);

if( data.match(pattern)==null)

{

alert("Only Name and Email are allowed!");

event.preventDefault();

return false;

}

return true;

}

</script>

</div>

<thead>

<tr>

<th>Email</th>

<th>Image</th>

<th>Status</th>

<th>Actions</th>

</tr>

</thead>

<tbody>

<?php $c=1; ?>

@if(isset($users))

@if(count($users)>0)

@foreach($users as $user)

<td> <span class="block-email">{{ $user->email}}</span> </td>

<td> <span class="status--process"> {{getRole( $user)}}</span> </td>

<td>

<img src="{{$user->image}}" alt="{{$user->name}} banner" height="60px" width="70px">

</td>

<td> @if($user->active)

@csrf

<input value="{{$user->id}}" type="hidden" name="user_id">

<i class="fa fa-eye"></i> Active

</button>

</form>

@else

@csrf

<input value="{{$user->id}}" type="hidden" name="user_id">

<i class="fa fa-eye-slash"></i> Inactive

</button>

</form>

@endif

</td>

<td>

@csrf

</button>

</form>

@csrf

</button>

</form>

</div>

</td>

</tr>

@endforeach

@else

<td colspan="7" class="text-center"> No Data Found</td>

@endif

@if(isset($drivers))

@if(count($drivers)>0)

@foreach($drivers as $user)

<td> <span class="block-email">{{ $user->email}}</span> </td>

<td> <span class="status--process"> {{getRole( $user)}}</span> </td>

<td>

<img src="{{$user->image}}" alt="{{$user->name}} banner" height="60px" width="70px">

</td>

<td> @if($user->active)

@csrf

<input value="{{$user->id}}" type="hidden" name="user_id">

<i class="fa fa-eye"></i> Active

</button>

</form>

@else

@csrf

<input value="{{$user->id}}" type="hidden" name="user_id">

<i class="fa fa-eye-slash"></i> Inactive

</button>

</form>

@endif

</td>

<td>

@csrf

</button>

</form>

@csrf

</button>

</form>

</div>

</td>

</tr>

@endforeach

@else

<td colspan="7" class="text-center"> No Data Found</td>

@endif

</tbody>

</table>

</div>

@if(isset($srch)) <a href="/allDr_Cu"> <i class="fa fa-reply"></i> Back to all</a> @endif

</div>

</div>

</div>

</script>

</script>

</script>

</script>

</body>

</html>

booking.blade.php

<!DOCTYPE html>

<head>

<title>Bookings</title>

media="all">

media="all">

</head>

@include('admin.adcommon.sidemenu')

@if (session()->has('status'))

<strong>{{ session()->get('status') }}</strong>

</button>

</div>

@endif

@if (session()->has('error'))

<strong>{{ session()->get('error') }}</strong>

</button>

</div>

@endif

<h2 class="title-1 mr-5">Booking Table</h2>

<button type="submit" class="btn" title="search" onclick="srchval()"><i

class="fa fa-search" aria-hidden="true"></i>

</button>

</div>

</form>

function srchval() {

data = document.getElementById('srch').value;

if (!data) {

alert("Search Fields are Empty!");

event.preventDefault();

return false;

}

</script>

</div>

@csrf

<input type="date" class="form-control input-sm" id="fromdate" name="start_date" @if(isset($req)) value={{$req->start_date}} @endif >

</div>

<input type="date" class="form-control input-sm" id="todate" name="end_date" @if(isset($req)) value={{$req->end_date}} @endif >

</div>

</button>

</div>

</form>

function dateval(){

fromdate=document.getElementById('fromdate').value;

todate=document.getElementById('todate').value;

// console.log(fromdate);

// console.log(todate);

if (Date.parse(fromdate) > Date.parse(todate)) {

alert("Invalid Date Range!\nStart Date cannot be after End Date!")

fromdate=Date;

event.preventDefault();

return false;

}

if(!fromdate || !todate){

alert("Date Fields are Empty!");

event.preventDefault();

return false;

}

</script>

</div>

<thead>

<tr>

<th> Driver Name </th>

<th> Customer Name </th>

<th> Mobile </th>

<th> Pickup Location </th>

<th> Drop Location </th>

<th> Pickup Date </th>

<th> Pickup Time </th>

<th> Adults </th>

<th> Childs </th>

<th> Message </th>

<th> Payment Mode </th>

<th> Total </th>

<th> Available </th>

</tr>

</thead>

<tbody>

<?php $c = 1; ?>{{-- ['adeu' => $adfn, 'data'=>$data, 'cust'=>$cust, 'car'=>$car, 'driver'=>$driver --}}

@if(count($data)>0)

@foreach ($data as $item)

<tr @if ($item->available) style="background: #ebb96e5b" @endif>

<td>{{ findCar($item->car_id) }}</td>

<td>{{ findDri($item->driver_id)}}</td>

<td>{{ findCust($item->customer_id)}}</td>

<td>{{ $item->mobile }}</td>

<td>{{ findLoc($item->puloc) }}</td>

<td>{{ findLoc($item->drloc) }}</td>

<td>{{ $item->pudate }}</td>

<td>{{ $item->putime }}</td>

<td>{{ $item->personAd }}</td>

<td>{{ $item->personCh }}</td>

<td>{{ $item->message }}</td>

<td>{{ $item->paymentMode }}</td>

<td>{{ $item->total }}</td>

<td>

@if ($item->bkkStatus=='1' || $item->status=='1')

<a href="/adShowTrip/{{$item->id}}" class='text-success' data-toggle="tooltip" data-placement="top" title="Show Ride"><i class="fa fa-desktop"> Booking Confirmed </i> </a>

@elseif($item->bkkStatus=='0'|| $item->status=='0')

<h5 class="text-dark">Booking Cancle</h5>

@else

<h5 class="text-info">No Response</h5>

@endif

</td>

</tr>

@endforeach

@else

<td colspan="10" class="text-center"> No Data Found</td>

@endif

</tbody>

</table>

</div>

@if(!isset($srchbck) )

@if(!isset($req))

</div>

@endif

@if(isset($srchbck))

</div>

@endif

</div>

</p>

</div>

</body>

</html>

car_edit.blade.php

@include('admin.adcommon.header')

<head>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('wrlgcr'))

<strong>{{session()->get('wrlgcr')}}</strong>

</button>

</div>

@endif

<h2 class="title-1">Edit Car Details </h2>

</div>

Recent Image

</div>

<?php $imagex = explode(', ', $car->image) ?>

@foreach($imagex as $imag)

@endforeach

</div>

<strong class="card-title">Car Details Edit Page </strong>

</div>

@csrf

<input type="hidden" name="pgimz" value="{{$car->image}}">

</div>

</div>

<label for="file-input" class=" form-control-label"> Brand</label>

</div>

<input type="text" id="file-input" name="brand" class="form-control" value="{{$car->brand}}">

</div>

</div>

<input type="text" id="file-input" name="carNo" class="form-control" value="{{$car->carNo}}">

</div>

<label for="file-input" class=" form-control-label">Person</label>

</div>

<input type="text" id="file-input" name="person" class="form-control" value="{{$car->person}}">

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

<label for="file-input" class=" form-control-label"> Features</label>

</div>

<input type="text" id="file-input" name="features" class="form-control" value="{{$car->features}}">

</div>

<label for="file-input" class=" form-control-label"> Description</label>

</div>

</div>

<label for="file-input" class="bg-warning form-control-label">Price/Day</label>

</div>

<input type="text" id="file-input" name="price" class="form-control" value="{{$car->price}}">

</div>

<label for="file-input" class=" form-control-label">Status</label>

</div>

<input type="radio" id="file-input" name="status" class="mx-5" @if($car->status=='1') checked @endif value="1"> <span for="">Active</span>

<input type="radio" id="file-input" name="status" value="0" @if($car->status=="0") checked @endif class="mx-5"><span for="" >Inactive</span>

</div>

<label for="file-multiple-input" class=" form-control-label">Multiple Images</label>

</div>

</div>

<button class="au-btn au-btn--block au-btn--green " type="submit">UPDATE</button>

</form>

</div>

</div>

@include('admin.adcommon.ftrjq')

carAdding.blade.php

@include('admin.adcommon.header')

<head>

<title>Car Adding Page</title>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('wrlgcr'))

<strong>{{session()->get('wrlgcr')}}</strong>

</button>

</div>

@endif

</div>

<strong class="card-title"> Car Adding Form </strong>

@if (count($errors) > 0)

<ul>

@foreach ($errors->all() as $error)

<li>{{ $error }}</li>

@endforeach

</ul>

</div>

@endif

</div>

@csrf

</div>

</div>

<label for="file-input" class=" form-control-label"> Brand</label>

</div>

</div>

</div>

</div>

<label for="file-input" class=" form-control-label">Person</label>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

<label for="file-input" class=" form-control-label"> Features</label>

</div>

</div>

<label for="file-input" class=" form-control-label"> Description</label>

</div>

</div>

<label for="file-input" class="bg-warning form-control-label">Price/Day</label>

</div>

</div>

<label for="file-input" class=" form-control-label">Status</label>

</div>

<input type="radio" id="file-input" name="status" class="mx-5" value="1"> <span for="">Active</span>

<input type="radio" id="file-input" name="status" value="0" class="mx-5"><span for="" >Inactive</span>

</div>

<label for="file-multiple-input" class=" form-control-label">Multiple Images</label>

</div>

</div>

<button class="au-btn au-btn--block au-btn--green " type="submit">Create</button>

</form>

</div>

</div>

@include('admin.adcommon.ftrjq')

carList.blade.php

<!DOCTYPE html>

<head>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('status'))

<strong>{{session()->get('status')}}</strong>

</button>

</div>

@endif

@if(session()->has('error'))

<strong>{{session()->get('error')}}</strong>

</button>

</div>

@endif

<h2 class="title-1">Car Table</h2>

</div>

<thead>

<tr>

<th>Brand</th>

<th>Seats</th>

<th>Features</th>

<th>Description</th>

<th>Image</th>

<th>Price</th>

<th>Status</th>

<th>Actions</th>

</tr>

</thead>

<tbody>

<?php $c=1; ?>

@if(isset($cars) && count($cars)>0)

@foreach($cars as $car)

<td> {{ $car->brand}}</td>

<td> {{ $car->carNo}}</td>

<td> {{ $car->person}}</td>

<td> {{ $car->features}}</td>

<td data-toggle="tooltip" data-placement="left" title=" {{$car->desc }}" > {{ substr($car->desc, 0, 15) }}</td>

<td> <span class="status--process"> @if($car->book) Booked @else Available @endif </span></td>

<td>

<?php $arr = explode(", ",$car->image); ?>

@foreach($arr as $card)

<img src="{{$card}}" alt="{{$car->name}} banner" height="60px" width="70px">

@endforeach

{{-- <img src="{{$car->image}}" alt="{{$car->name}} banner" height="60px" width="70px"> --}}

</td>

<td> ${{$car->price}}/Day</td>

<td>

@if($car->status)

@csrf

<input value="{{$car->id}}" type="hidden" name="car_id">

<i class="fa fa-eye"></i> Active

</button>

</form>

@else

@csrf

<input value="{{$car->id}}" type="hidden" name="car_id">

<i class="fa fa-eye-slash"></i> Inactive

</button>

</form>

@endif

</td>

<td>

@csrf

<input type="hidden" name="old_img" value="{{$car->image}}">

</button>

</form>

<a href="carDelete/{{$car->id}}" class="item mx-3" data-toggle="tooltip" data-placement="top" title="Click to Delete">

</a>

{{-- <a href="user_role_delete/{{$user['id']}}" class="btn btn-danger btn-sm text-light">Delete</a> --}}

</div>

</td>

</tr>

@endforeach

@else

<td colspan="17" class="text-center"> No Data Found</td>

@endif

</tbody>

</table>

</div>

</div>

</div>

</script>

</script>

</script>

</script>

</body>

</html>

changer.blade.php

<!DOCTYPE html>

<head>

<title>Page Tables</title>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('status'))

<strong>{{session()->get('status')}}</strong>

</button>

</div>

@endif

@if(session()->has('error'))

<strong>{{session()->get('error')}}</strong>

</button>

</div>

@endif

<h2 class="title-1">Page Table</h2>

</div>

<thead>

<tr>

<th>Title</th>

<th>Image</th>

<th>Change Status</th>

</tr>

</thead>

<tbody>

<?php $c=1; ?>

@foreach($pages as $page)

<td>

<span class="block-email">{{ $page->title}}</span>

</td>

<?php $arr = explode(", ",$page->image); ?>

@foreach($arr as $card)

<img src="{{$card}}" alt="{{$page->title}} banner" height="60px" width="70px">

@endforeach

</td>

{{-- <td class="desc">

@if($page->active)

{{ $page->active}} Yes

</button>

@else

{{ $page->active}} No

</button>

@endif

</td> --}}

<td>

@if($page->active)

@csrf

<input value="{{$page->id}}" type="hidden" name="id">

<i class="fa fa-eye"></i> Active

</button>

</form>

@else

@csrf

<input value="{{$page->id}}" type="hidden" name="id">

<i class="fa fa-eye-slash"></i> Inactive

</button>

</form>

@endif

@csrf

<i class="zmdi zmdi-edit"></i> Edit

</button>

</form>

<a href="deletepage/{{$page->id}}" class="btn btn-danger btn-sm text-light">Delete</a>

{{--

</button>

</button> --}}

</div>

</td>

</tr>

@endforeach

</tbody>

</table>

</div>

</div>

</div>

</script>

</script>

</script>

</script>

</body>

</html>

chnps.blade.php

@include('admin.adcommon.header')

<head>

<title>Change Password</title>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('wrlgcr'))

<strong>{{session()->get('wrlgcr')}}</strong>

</button>

</div>

@endif

<h2 class="title-1">Change Password </h2>

</div>

<strong class="card-title">Change Password</strong>

</div>

@csrf

<input type="hidden" name="ademail" value="{{$adeu->email}}">

<label>Old Password</label>

</div>

<label>New Password</label>

</div>

<label for="">Confirm Password</label>

</div>

<button class="au-btn au-btn--block au-btn--green m-b-20" type="submit">Update</button>

</form>

</div>

</div>

@include('admin.adcommon.ftrjq')

drEarnings.blade.php

<!DOCTYPE html>

<head>

<title>Driver Earnings</title>

media="all">

media="all">

</head>

@include('admin.adcommon.sidemenu')

<h2 class="title-1 mr-5">Sales Report</h2>

@if(isset($srMnth))

@endif

<button type="submit" class="btn" title="search" onclick="srchval()"><i

class="fa fa-search" aria-hidden="true"></i>

</button>

</div>

</form>

function srchval() {

data = document.getElementById('srch').value;

if (!data) {

alert("Search Fields are Empty!");

event.preventDefault();

return false;

}

</script>

</div>

@csrf

@if(isset($srchbck))

@endif

<option disabled="disabled" @if(!isset($srMnth)) selected="selected" @endif value="">Select Month</option>

<option value="1" @if(isset($srMnth)) @if($srMnth=='1') selected @endif @endif>January</option>

<option value="2" @if(isset($srMnth)) @if($srMnth=='2') selected @endif @endif>February</option>

<option value="3" @if(isset($srMnth)) @if($srMnth=='3') selected @endif @endif>March</option>

<option value="4" @if(isset($srMnth)) @if($srMnth=='4') selected @endif @endif>April</option>

<option value="8" @if(isset($srMnth)) @if($srMnth=='8') selected @endif @endif>August</option>

<option value="9" @if(isset($srMnth)) @if($srMnth=='9') selected @endif @endif>September</option>

<option value="10"@if(isset($srMnth)) @if($srMnth=='10') selected @endif @endif>October</option>

<option value="11" @if(isset($srMnth))@if($srMnth=='11') selected @endif @endif>November</option>

<option value="12"@if(isset($srMnth)) @if($srMnth=='12') selected @endif @endif>December</option>

</select>

</button>

</div>

</form>

</div>

@csrf

<button class="btn btn-outline-info">Export <i class="fa fa-arrow-right"></i> </button>

</form>

</div>

<thead>

<tr>

<th> Driver Name </th>

<th> Customer Name </th>

<th> Payment Mode </th>

<th> Income </th>

<th> Status </th>

</tr>

</thead>

<tbody>

<?php $c = 1;

$t = 0; ?>

@if (count($data) > 0)

@foreach ($data as $item)

<tr>

<td>{{ findDri($item->driver_id) }}</td>

<td>{{ findCust($item->customer_id) }}</td>

<td>{{ $item->pudate }}</td>

<td>{{ $item->paymentMode }}</td>

<td>$ {{ $item->total }}.00</td>

<td>

@if ($item->bookStatus == '4' && $item->status == '1')

<h5> Completed </h5>

@elseif($item->bookStatus == '0' && $item->status == '0')

<h5 class="text-danger">Booking Cancel</h5>

@elseif($item->bookStatus == '5')

Payment Due

@elseif($item->bookStatus == '3' || $item->bookStatus == '2' || $item->bookStatus == '1')

Ongoing Process

@else

<h5 class="text-info">No Response</h5>

@endif

</td>

<?php

if ($item->bookStatus == '4' && $item->status == '1') {

$t = $t + $item->total;

}

</tr>

@endforeach

@else

<td colspan="10" class="text-center"> No Data Found</td>

@endif

</tbody>

<tfoot>

<h4 class="text-light"> Grand Total =</h4>

</td>

</td>

</tr>

</tfoot>

</table>

</div>

@if(isset($srMnth)) <a href="/drEarnings"> <i class="fa fa-reply"></i> Back to all</a> @endif

</div>

{{--

@foreach ($driver_info as $dr_info)

<img class="align-self-center rounded-circle mr-3" style="width:85px; height:85px;" alt="" src="{{ driver_details('image', $dr_info->driver_id)}}">

</a>

<h2 class="text-light display-6"> {{ findDri($dr_info->driver_id) }} </h2>

<p class="text-light">Experience: {{ driver_details('experience', $dr_info->driver_id)}} </p>

<p class="text-light">Income: $ {{$dr_info->income}}.00 </p>

</div>

<i class="fa fa-users"></i> On Requests

<span class="badge badge-primary pull-right">{{driver_details('request', $dr_info->driver_id)}}</span>

</a>

</li>

<i class="fa fa-tasks"></i> Total Bookings

<span class="badge badge-danger pull-right">{{ $dr_info->total}}</span>

</a>

</li>

<i class="fa fa-calendar"></i> Working Days

<span class="badge badge-success pull-right">{{driver_details('workingDay', $dr_info->driver_id)}}</span>

</a>

</li>

<i class="fa fa-globe"></i> No of Customers

<span class="badge badge-warning pull-right r-activity">{{driver_details('customer', $dr_info->driver_id)}}</span>

</a>

</li>

</ul>

</section>

</aside>

@endforeach

</div>

</div> --}}

</div>

</body>

</html>

driver_role.blade.php

<!DOCTYPE html>

<head>

<title>Driver Roles</title>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('status'))

<strong>{{session()->get('status')}}</strong>

</button>

</div>

@endif

@if(session()->has('error'))

<strong>{{session()->get('error')}}</strong>

</button>

</div>

@endif

</div>

<h2 class="title-1">Driver Table</h2>

</div>

@csrf

</div>

</button>

</div>

</form>

function srchval(){

data=document.getElementById('driver_srch').value;

if(data=='') {

alert("Please Search for Name or Email")

event.preventDefault();

return false;

}

let pattern = /[^0-9]/g;

let result = data.match(pattern);

if( data.match(pattern)==null)

{

alert("Only Name and Email are allowed!");

event.preventDefault();

return false;

}

return true;

}

</script>

</div>

<thead>

<tr>

<th>Email</th>

<th>Image</th>

<th>Status</th>

<th>Actions</th>

</tr>

</thead>

<tbody>

<?php $c=1; ?>

@if(count($drivers)>0)

@foreach($drivers as $user)

<td> <span class="block-email">{{ $user->email}}</span> </td>

<td> <span class="status--process"> {{getRole( $user)}} </span> </td>

<td>

<img src="{{$user->image}}" alt="{{$user->name}} banner" height="60px" width="70px">

</td>

<td> @if($user->active)

@csrf

<input value="{{$user->id}}" type="hidden" name="driver_id">

<i class="fa fa-eye"></i> Active

</button>

</form>

@else

@csrf

<input value="{{$user->id}}" type="hidden" name="driver_id">

<i class="fa fa-eye-slash"></i> Inactive

</button>

</form>

@endif

</td>

<td>

@csrf

</button>

</form>

@csrf

</button>

</form>

</div>

</td>

</tr>

@endforeach

@else

<td colspan="7" class="text-center"> No Data Found</td>

@endif

</tbody>

</table>

</div>

</div>

@if(isset($srch)) <a href="/driverList"> <i class="fa fa-reply"></i> Back to all</a> @endif

</div>

</div>

</script>

</script>

</script>

</script>

</body>

</html>

editpage.blade.php

@include('admin.adcommon.header')

<head>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('wrlgcr'))

<strong>{{session()->get('wrlgcr')}}</strong>

</button>

</div>

@endif

<h2 class="title-1">Edit Page Banner & Title </h2>

</div>

<strong class="card-title">Banner Edit Page </strong>

</div>

@csrf

<input type="hidden" name="pgimz" value="{{$pg->image}}">

</div>

<input type="text" id="file-input" name="pgpage" class="form-control" value="{{$pg->page}}" readonly>

</div>

<label for="file-input" class=" form-control-label">Page Title</label>

</div>

<input type="text" id="file-input" name="pgtitle" class="form-control" value="{{ $pg->title}}">

</div>

<label for="file-input" class=" form-control-label">Page Active</label>

</div>

<input type="radio" id="file-input" name="pgact" class="mx-5" value="1" @if($pg->active==1) checked @endif> <span for="">Active</span>

<input type="radio" id="file-input" name="pgact" value="0" class="mx-5" @if($pg->active==0) checked @endif><span for="">Inactive</span>

</div>

<label for="file-multiple-input" class=" form-control-label">Multiple File input</label>

</div>

</div>

<button class="au-btn au-btn--block au-btn--green m-b-20" type="submit">Update</button>

</form>

</div>

</div>

@include('admin.adcommon.ftrjq')

forget_pass.blade.php

@include('admin.adcommon.header')

<head>

<title>Forget Password</title>

</head>

{{-- @include('admin.adcommon.sidemenu') @include('admin.adcommon.ftrjq')--}}

</a>

</div>

<label>Email Address</label>

</div>

<button class="au-btn au-btn--block au-btn--green m-b-20" type="submit">submit</button>

</form>

</div>

@include('admin.adcommon.ftrjq')

index.blade.php

@include('admin.adcommon.header')

<head>

<title>Dashboard</title>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('message'))

<strong>{{session()->get('message')}}</strong>

</button>

</div>

@endif

<h2 class="title-1">overview </h2>

</div>

</div>

<h2>{{$data['driverCnt'] }}</h2>

<span>No of Active Drivers</span>

</div>

</div>

</div>

<h2>{{ $data['carCnt'] }}</h2>

</div>

</div>

</div>

<h2> {{ $data['bkngCnt'] }}</h2>

<span>Active Bookings</span>

</div>

</div>

</div>

<h2>${{$data['total'] }}</h2>

<span>Total Income</span>

</div>

</div>

{{-- <div class="row">

</div>

</div> --}}

</div>

</div>

@include('admin.adcommon.ftrjq')

@include('admin.adcommon.header')

<head>

<title>Login</title>

</head>

@if(Session::has('wrlgcr'))

<strong>{{ Session::get('wrlgcr') }}</strong>

</button>

</div>

@endif

</a>

</div>

@csrf

<label>Email Address</label>

</div>

<label>Password</label>

</div>

<label>

<input type="checkbox" name="remember">Remember Me

</label>

<label>

<a href="adforget_pass">Forgotten Password?</a>

</label>

</div>

</form>

<p>

Don't you have account?

</p>

</div>

@include('admin.adcommon.ftrjq')

mail.blade.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

</head>

<body>

<!--[if gte mso 9]>

<v:background xmlns:v="urn:schemas-microsoft-com:vml" fill="t">

<v:fill type="tile" color="#ffffff"></v:fill>

</v:background>

<![endif]-->

<tbody>

<tr>

<tbody>

<tr>

<tbody>

<tr>

<tbody>

<tr>

<tbody>

<tr>

<h1 style="color: #ffffff;"><strong>Hello {{ $adminMail['name'] }}, </strong><br></h1>

</td>

</tr>

</tr>

<tr>

<tbody>

<tr>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</div>

</body>

</html>

mailbox.blade.php

@include('admin.adcommon.header')

<head>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('message'))

<strong>{{session()->get('message')}}</strong>

</button>

</div>

@endif

</div>

@csrf

<input type="date" class="form-control input-sm" id="fromdate" name="start_date" @if(isset($req)) value={{$req->start_date}} @endif >

</div>

<input type="date" class="form-control input-sm" id="todate" name="end_date" @if(isset($req)) value={{$req->end_date}} @endif >

</div>

</button>

</div>

</form>

function dateval(){

fromdate=document.getElementById('fromdate').value;

todate=document.getElementById('todate').value;

// console.log(fromdate);

// console.log(todate);

if (Date.parse(fromdate) > Date.parse(todate)) {

alert("Invalid Date Range!\nStart Date cannot be after End Date!")

fromdate=Date;

event.preventDefault();

return false;

}

if(!fromdate || !todate){

alert("Date Fields are Empty!");

event.preventDefault();

return false;

}

</script>

</div>

<thead>

<tr>

<th scope="col">Date</th> {{-- created_at --}}

<th scope="col">Email</th>

<th scope="col">Subject</th>

<th scope="col">Message</th>

<th scope="col">Reply</th>

<th scope="col">Action</th>

<?php $c=1; ?>

</tr>

</thead>

<tbody>

@if(count($data)==0)

<td colspan="8" class="text-center"> <h6>No Data Found</h6> </td>

@endif

@foreach($data as $seu)

<tr>

<td scope="col"> {{ $seu['created_at'] }} </td>

<td scope="col" style=" text-overflow: ellipsis; word-wrap: break-word; overflow: hidden; max-width: 2em;"> {{ $seu['email'] }} </td>

<td scope="col" style=" text-overflow: ellipsis; word-wrap: break-word; overflow: hidden; max-width: 2em;"> {{ $seu['subject'] }}</td>

<td scope="col" style=" text-overflow: ellipsis; word-wrap: break-word; overflow: hidden; max-width: 2em;"> {{ $seu['message'] }} </td>

@if($seu['status']==0)

@else

<span class="badge badge-info float-right mt-1 mb-1"> <h5> Replied </h5></span>

@endif

</td>

<td>

{{-- <a href="{{url('admailsend',$seu['id'])}}" class='text-info p-2'> <i class="fa fa-paper-plane" aria-hidden="true"></i></a> --}}

</td>

</tr>

@endforeach

</tr>

</tbody>

</table>

</div>

</div>

</div>

@include('admin.adcommon.ftrjq')

mailreply.blade.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

</head>

<body>

<!--[if gte mso 9]>

<v:background xmlns:v="urn:schemas-microsoft-com:vml" fill="t">

<v:fill type="tile" color="#FFE7F3"></v:fill>

</v:background>

<![endif]-->

<tbody>

<tr>

<tbody>

<tr>

<tbody>

<tr>

<tbody>

<tr>

<tbody>

<tr>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

<tbody>

<tr>

<tbody>

<tr>

<p style="font-size: 48px; font-family: 'playfair display', georgia, 'times new roman', serif;"><strong><em>    ROYAL CARS</em></strong><br></p>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

<tbody>

<tr>

<tbody>

<tr>

<tbody>

<tr>

<tbody>

<tr>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

<tr>

<tbody>

<tr>

<tbody>

<tr>

<p style="font-size: 22px; font-family: arial, 'helvetica neue', helvetica, sans-serif;"><strong>{{$AdminReply['message']}}</strong></p>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

<tr>

<tbody>

<tr>

<tbody>

<tr>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

</div>

</body>

</html>

readRequest.blade.php

<!DOCTYPE html>

<head>

<title>All Requests</title>

media="all">

media="all">

</head>

@include('admin.adcommon.sidemenu')

@if (session()->has('status'))

<strong>{{ session()->get('status') }}</strong>

</button>

</div>

@endif

@if (session()->has('error'))

<strong>{{ session()->get('error') }}</strong>

</button>

</div>

@endif

<h2 class="title-1 mr-5">Availability Table</h2>

<button type="submit" class="btn" title="search" onclick="srchval()"><i

class="fa fa-search" aria-hidden="true"></i>

</button>

</div>

</form>

function srchval() {

data = document.getElementById('srch').value;

if (!data) {

alert("Search Fields are Empty!");

event.preventDefault();

return false;

}

</script>

</div>

@csrf

<input type="date" class="form-control input-sm" id="fromdate" name="start_date" @if(isset($req)) value={{$req->start_date}} @endif >

</div>

<input type="date" class="form-control input-sm" id="todate" name="end_date" @if(isset($req)) value={{$req->end_date}} @endif >

</div>

</button>

</div>

</form>

function dateval(){

fromdate=document.getElementById('fromdate').value;

todate=document.getElementById('todate').value;

// console.log(fromdate);

// console.log(todate);

if (Date.parse(fromdate) > Date.parse(todate)) {

alert("Invalid Date Range!\nStart Date cannot be after End Date!")

fromdate=Date;

event.preventDefault();

return false;

}

if(!fromdate || !todate){

alert("Date Fields are Empty!");

event.preventDefault();

return false;

}

</script>

</div>

<thead>

<tr>

<th> Customer </th>

<th> Driver </th>

<th> Pickup Location </th>

<th> Drop Location </th>

<th> Pickup Date </th>

<th> Pickup Time </th>

<th> Available </th>

</tr>

</thead>

<tbody>

<?php $c = 1; ?>{{-- ['adeu' => $adfn, 'data'=>$data, 'cust'=>$cust, 'car'=>$car, 'driver'=>$driver --}}

@if(count($data)>0)

@foreach ($data as $item)

<tr @if ($item->available) style="background: #ebb96e5b" @endif>

<td>{{ findCust($item->customer_id) }}</td>

<td>{{ findDri($item->driver_id)}}</td>

<td>{{ findCar($item->car_id) }}</td>

<td>{{ findLoc($item->puloc) }}</td>

<td>{{ findLoc($item->droploc) }}</td>

<td>{{ $item->pudate }}</td>

<td>{{ $item->putime }}</td>

<td>

@if ($item->mail)

@else

<h5 class="text-info">No Mails</h5>

@endif

</td>

<td>

@if ($item->available == null)

<h5 class="text-info">No response</h5>

@else

@if($item->available == 1)

<h5 class="text-primary">Available</h5>

@elseif($item->available == 2)

<h5 class="text-secondary">Booking Done</h5>

@elseif($item->available == 3)

<h5 class="text-success">Booking Confirmed</h5>

@elseif($item->available == 0 || $item->available == 5 )

<h5 class="text-danger">Rejected</h5>

@endif

</td>

</tr>

@endforeach

@else

<td colspan="10" class="text-center"> No Data Found</td>

@endif

</tbody>

</table>

</div>

@if(!isset($srchbck))

@if(!isset($req))

</div>

@endif

@if(isset($srchbck))

</div>

@endif

@if(isset($req))

</div>

@endif

</div>

</p>

</div>

</body>

</html>

@include('admin.adcommon.header')

<head>

<title>Register</title>

</head>

</a>

</div>

@csrf

<label>Username</label>

</div>

<label>Email Address</label>

</div>

<label>Password</label>

</div>

<label>Upload Image</label>

</div>

<button class="au-btn au-btn--block au-btn--green m-b-20" type="submit">register</button>

</form>

<style>

label.error {

color: red;

font-size: 1rem;

display: block;

margin-top: 5px;

}

label.error.fail-alert {

border: 2px solid red;

border-radius: 4px;

line-height: 1;

padding: 2px 0 6px 6px;

background: #ffe6eb;

}

input.valid.success-alert {

border: 2px solid #4CAF50;

color: green;

}

</style>

$(document).ready(function() {

$("#basic-form").validate({

errorClass: "error fail-alert",

validClass: "valid success-alert",

rules: {

name : {

required: true,

minlength: 3

email: {

required: true,

email: true,

password: {

required: true,

adimg:{

required: true,

extension: "jpg|jpeg|png|ico|bmp"

}

messages : {

minlength: "Name should be at least 3 characters"

email: {

email: "The email should be in the format: abc@domain.tld",

required: "** Fill it right now!",

unique: "** Change it right now!",

password: {

required: "Please fill password",

}

});

</script>

<p>

Already have account?

</p>

</div>

@include('admin.adcommon.ftrjq')

reply_mail.blade.php

@include('admin.adcommon.header')

<head>

<title>Mail Reply Page</title>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('wrlgcr'))

<strong>{{session()->get('wrlgcr')}}</strong>

</button>

</div>

@endif

<h2 class="title-1">Mail Reply Page </h2>

</div>

<strong class="card-title">Mail Reply Page </strong>

</div>

@csrf

<label for="file-input" class=" form-control-label">Sender Name</label>

</div>

</div>

<label for="file-input" class=" form-control-label">Sender Subject</label>

</div>

<input type="text" id="file-input" name="subject" class="form-control" value="{{$enrr->subject}}">

</div>

<label for="file-input" class=" form-control-label">Sender Message</label>

</div>

<input type="text" id="file-input" name="message" class="form-control" value="{{$enrr->message}}">

</div>

<label for="file-input" class=" form-control-label">Reply Him/Her</label>

</div>

</div>

<button class="au-btn au-btn--block au-btn--green m-b-20" type="submit">Send Reply</button>

</form>

</div>

</div>

@include('admin.adcommon.ftrjq')

testimonials.blade.php

<!DOCTYPE html>

<head>

<title>Testimonials List</title>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('status'))

<strong>{{session()->get('status')}}</strong>

</button>

</div>

@endif

@if(session()->has('error'))

<strong>{{session()->get('error')}}</strong>

</button>

</div>

@endif

<h2 class="title-1">User Reviews</h2>

</div>

<thead>

<tr>

<th>Customer Name</th>

<th>Message</th>

<th>Status</th>

<th>Actions</th>

</tr>

</thead>

<tbody>

<?php $c=1; ?>

@if(isset($testis) && count($testis)>0)

@foreach($testis as $t)

<td> <span class="block-email">{{ findCustomer($t->book_id)}}</span> </td>

{{-- <td> <span class="block-email">{{ $t->book_id}}</span> </td> --}}

<td> {{ $t->message}}</td>

<td>

@if($t->status)

@csrf

<input value="{{$t->id}}" type="hidden" name="t_id">

<i class="fa fa-eye"></i> Active

</button>

</form>

@else

@csrf

<input value="{{$t->id}}" type="hidden" name="t_id">

<i class="fa fa-eye-slash"></i> Inactive

</button>

</form>

@endif

</td>

<td>

<a href="delTestimonial/{{$t->id}}" class="item mx-3" data-toggle="tooltip" data-placement="top" title="Click to Delete">

</a>

{{-- <a href="user_role_delete/{{$user['id']}}" class="btn btn-danger btn-sm text-light">Delete</a> --}}

</div>

</td>

</tr>

@endforeach

@else

<td colspan="17" class="text-center"> No Data Found</td>

@endif

</tbody>

</table>

</div>

</div>

</div>

</script>

</script>

</script>

</script>

</body>

</html>

user_edit_roles.blade.php

@include('admin.adcommon.header')

<head>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('wrlgcr'))

<strong>{{session()->get('wrlgcr')}}</strong>

</button>

</div>

@endif

</div>

{{-- body 'adeu' => $adfn, 'user'=> $usr , 'eduall' => $rolesall, 'data2' =>$data2 --}}

<span style="float:right;" class="btn btn-dark text-light"> {{$data2[0]->title}} </span>

</div>

@csrf

<input type="hidden" name="pgimz" value="{{$user->image}}">

</div>

</div>

<label for="file-input" class=" form-control-label"> Email</label>

</div>

<input type="email" id="file-input" name="email" class="form-control" value="{{$user->email}}">

</div>

<label for="file-multiple-input" class=" form-control-label"> Set New Image</label>

</div>

</div>

<button class="au-btn au-btn--block au-btn--green m-b-20" type="submit">Update</button>

</form>

</div>

</div>

@include('admin.adcommon.ftrjq')

user_roles.blade.php

<!DOCTYPE html>

<head>

<title>User Roles</title>

</head>

@include('admin.adcommon.sidemenu')

@if(session()->has('status'))

<strong>{{session()->get('status')}}</strong>

</button>

</div>

@endif

@if(session()->has('error'))

<strong>{{session()->get('error')}}</strong>

</button>

</div>

@endif

<h2 class="title-1">Users Table</h2>

</div>

@csrf

</div>

</button>

</div>

</form>

function srchval(){

data=document.getElementById('srch').value;

if(!data){

alert("Search Fields are Empty!");

event.preventDefault();

return false;

}

let pattern = /[^0-9]/g;

let result = data.match(pattern);

if( data.match(pattern)==null)

{

alert("Only Name and Email are allowed!");

event.preventDefault();

return false;

}

return true;

}

</script>

</div>

<thead>

<tr>

<th>Email</th>

<th>Image</th>

<th>Status</th>

<th>Actions</th>

</tr>

</thead>

<tbody>

<?php $c=1; ?>

@if(count($users)>0)

@foreach($users as $user)

<td> <span class="block-email">{{ $user->email}}</span> </td>

<td> <span class="status--process"> {{getRole( $user)}}</span> </td>

<td>

<img src="{{$user->image}}" alt="{{$user->name}} banner" height="60px" width="70px">

</td>

<td> @if($user->active)

@csrf

<input value="{{$user->id}}" type="hidden" name="user_id">

<i class="fa fa-eye"></i> Active

</button>

</form>

@else

@csrf

<input value="{{$user->id}}" type="hidden" name="user_id">

<i class="fa fa-eye-slash"></i> Inactive

</button>

</form>

@endif

</td>

<td>

@csrf

</button>

</form>

@csrf

</button>

</form>

</div>

</td>

</tr>

@endforeach

@else

<td colspan="7" class="text-center"> No Data Found</td>

@endif

</tbody>

</table>

</div>

@if(isset($srch)) <a href="/user_roles"> <i class="fa fa-reply"></i> Back to all</a> @endif

</div>

</div>

</div>

</script>

</script>

</script>

</script>

</body>

</html>

In public folder >> css >> JS and imgs are store.

In database >> migrations >> migrate some tables.

enquiries

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

return new class extends Migration

{

public function up()

{

Schema::create('enquiries', function (Blueprint $table) {

$table->id();

$table->string('name')->nullable();

$table->string('email')->nullable();

$table->string('subject')->nullable();

$table->longText('message')->nullable();

$table->integer('status')->default('0');

$table->timestamps();

});

}

public function down()

{

Schema::dropIfExists('enquiries');

}

};

roles

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

return new class extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

Schema::create('roles', function (Blueprint $table) {

$table->id();

$table->string('title')->nullable();

$table->timestamps();

});

}

public function down()

{

Schema::dropIfExists('roles');

}

};

pages

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

return new class extends Migration

{

public function up()

{

Schema::create('pages', function (Blueprint $table) {

$table->id();

$table->string('page')->nullable();

$table->string('title')->nullable();

$table->string('image')->nullable();

$table->integer('active')->nullable();

$table->timestamps();

});

}

public function down()

{

Schema::dropIfExists('pages');

}

};

drivers

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

return new class extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

Schema::create('drivers', function (Blueprint $table) {

$table->id();

// Name Email Phone Address LicenceNo CarNo Salary Active

$table->string('name')->nullable();

$table->string('email')->nullable();

$table->string('password')->nullable();

$table->bigInteger('phone')->nullable();

$table->string('address')->nullable();

$table->string('carNo')->nullable();

$table->string('licenceNo')->nullable();

$table->string('experience')->nullable();

$table->string('salary')->nullable();

$table->string('image')->nullable();

$table->string('role_id')->default('2');

$table->string('active')->default('1');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('drivers');

}

};

cars

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

return new class extends Migration

{

public function up()

{

Schema::create('cars', function (Blueprint $table) {

$table->id();

$table->string('name')->nullable();

$table->string('brand')->nullable();

$table->string('carNo')->nullable();

$table->string('person')->nullable();

$table->string('gear')->nullable();

$table->string('year')->nullable();

$table->string('kmpl')->nullable();

$table->string('runs')->nullable();

$table->integer('price')->nullable();

$table->string('image')->nullable();

$table->string('features')->nullable();

$table->string('desc')->nullable();

$table->string('status')->nullable();

$table->string('book')->nullable();

$table->timestamps();

});

}

public function down()

{

Schema::dropIfExists('cars');

}

};

bookings

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

return new class extends Migration

{

public function up()

{

Schema::create('bookings', function (Blueprint $table) {

$table->id();

$table->integer('car_id')->nullable();

$table->integer('customer_id')->nullable();

$table->integer('driver_id')->nullable();

$table->string('avai_id')->nullable();

$table->bigInteger('mobile')->nullable();

$table->string('puloc')->nullable();

$table->string('drloc')->nullable();

$table->date('pudate')->nullable();

$table->string('putime')->nullable();

$table->string('personAd')->nullable();

$table->string('personCh')->nullable();

$table->string('message')->nullable();

$table->string('paymentMode')->nullable();

$table->string('total')->nullable();

$table->string('bookStatus')->default('0');

$table->string('status')->default('2');

// $table->string('')->nullable();

$table->timestamps();

});

}

public function down()

{

Schema::dropIfExists('bookings');

}

};

availabilities

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

return new class extends Migration

{

public function up()

{

Schema::create('availabilities', function (Blueprint $table) {

$table->id();

$table->string('customer_id')->nullable();

$table->string('driver_id')->nullable();

$table->string('car_id')->nullable();

$table->string('puloc')->nullable();

$table->string('droploc')->nullable();

$table->date('pudate')->nullable();

$table->string('putime')->nullable();

$table->string('mail')->nullable();

$table->string('available')->nullable();

$table->timestamps();

});

}

public function down()

{

Schema::dropIfExists('availabilities');

}

};

locations

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

return new class extends Migration

{

public function up()

{

Schema::create('locations', function (Blueprint $table) {

$table->id();

$table->string('area')->nullable();

$table->string('active')->nullable();

$table->timestamps();

});

}

public function down()

{

Schema::dropIfExists('locations');

}

};

testimonials

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

return new class extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

Schema::create('testimonials', function (Blueprint $table) {

$table->id();

$table->string('book_id')->nullable();

$table->string('message')->nullable();

$table->string('rating')->nullable();

$table->string('status')->nullable();

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('testimonials');

}

};

In side Seeder

location

<?php

namespace Database\Seeders;

use Illuminate\Database\Console\Seeds\WithoutModelEvents;

use Illuminate\Database\Seeder;

use DB;

class locationSeeder extends Seeder

{

/**

* Run the database seeds.

* @return void

public function run()

{

// DB::table('locations')->delete();

// DB::table('locations')->insert([

// [

// 'area' => 'Alipore',

// 'active' => '1',

// ],

// [

// 'area' => 'Park Street',

// 'active' => '1',

// ],

// [

// 'area' => 'Kasba',

// 'active' => '1',

// ],

// [

// 'area' => 'Science City',

// 'active' => '1',

// ],

// [

// 'area' => 'New Town',

// 'active' => '1',

// ],

// [

// 'area' => 'Eden Gardens',

// 'active' => '1',

// ],

// [

// 'area' => 'Town Hall',

// 'active' => '1',

// ],

// [

// 'area' => 'Sealdah',

// 'active' => '1',

// ],

// [

// 'area' => 'Phoolbagan',

// 'active' => '1',

// ],

// [

// 'area' => 'Howrah',

// 'active' => '1',

// ],

// [

// 'area' => 'Kalighat',

// 'active' => '1',

// ],

// [

// 'area' => 'Dakshineswar',

// 'active' => '1',

// ],

// [

// 'area' => 'Rajarhat',

// 'active' => '1',

// ],

// [

// 'area' => 'Karunamoyee',

// 'active' => '1',

// ]

// ]);

}

page

<?php

namespace Database\Seeders;

use Illuminate\Database\Console\Seeds\WithoutModelEvents;

use Illuminate\Database\Seeder;

use DB;

class pageSeeder extends Seeder

{

/**

* Run the database seeds.

* @return void

public function run()

{

// DB::table('pages')->delete();

// //

// DB::table('pages')->insert([

// [

// 'page' => 'home',

// 'title' => 'HOME',

// 'active' => '1',

// ],

// [

// 'page' => 'about',

// 'title' => 'ABOUT',

// 'active' => '1',

// ],

// [

// 'page' => 'service',

// 'title' => 'SERVICE',

// 'active' => '1',

// ],

// [

// 'page' => 'carlist',

// 'title' => 'CAR LIST',

// 'active' => '1',

// ],

// [

// 'page' => 'cardetail',

// 'title' => 'CAR DETAIL',

// 'active' => '1',

// ],

// [

// 'page' => 'carbooking',

// 'title' => 'CAR BOOKING',

// 'active' => '1',

// ],

// [

// 'page' => 'theteam',

// 'title' => 'THE TEAM',

// 'active' => '1',

// ],

// [

// 'page' => 'testimonial',

// 'title' => 'TESTIMONIAL',

// 'active' => '1',

// ],

// [

// 'page' => 'contact',

// 'title' => 'CONTACT',

// 'active' => '1',

// ]

// ]);

}

role

<?php

namespace Database\Seeders;

use Illuminate\Database\Console\Seeds\WithoutModelEvents;

use Illuminate\Database\Seeder;

use DB;

class RoleSeeder extends Seeder

{

/**

* Run the database seeds.

* @return void

public function run()

{

// DB::table('roles')->delete();

// //

// DB::table('roles')->insert([

// [

// 'title' => 'admin',

// ],

// [

// 'title' => 'driver',

// ],

// [

// 'title' => 'customer',

// ]

// ]);

}

Inside app >> helpers.php file

<?php

function test(){

return "Laravel";

}

function userRole(){

$id= session()->get('user_id');

$data= DB::table('users')->where('id',$id)->first();

return $data->role_id;

}

function isDriverLogin(){

$id= session()->get('driver_id');

$data= DB::table('drivers')->where('id',$id)->first();

// dd($data);

if($data)

return true;

else

return false;

}

function getRole($usr){

$roles = DB::table('roles')->get();

foreach($roles as $role){

if($role->id == $usr->role_id)

{

return $role->title;

}

return "no roles";

}

function findCust($customer_id){

$cust = DB::table('users')->where('id',$customer_id)->first();

return $cust->name;

}

// $car = car::all();

// $driver = driver::all(); findDri($item->driver_id)

function findDri($driver_id){

$user = DB::table('drivers')->get();

foreach($user as $pr){

if($pr->id == $driver_id){

return $pr->name;

}

function findCar($car_id){

$car = DB::table('cars')->get();

foreach($car as $pr){

if($pr->id == $car_id){

return $pr->brand.' '.$pr->name;

}

function findLoc($loc){

$locas = DB::table('locations')->get();

foreach($locas as $pr){

if($pr->id == $loc){

return $pr->area;

}

// Booking table status 2= no response 1= confirm 0= failed

// available table available null= no response 1= confirm 0=failed

function isDriverLoc($Did, $puid, $dpid){

if( ($Did=='1') && ($puid =='1' || $puid =='2' || $puid =='3' || $puid =='4' || $puid =='5') && ($dpid =='1' || $dpid =='2' || $dpid =='3' || $dpid =='4' || $dpid =='5') )

{ return true; }

elseif( ($Did=='7') && ($puid =='8' || $puid =='7' || $puid =='6' || $puid =='9' || $puid =='10' ) && ($dpid =='6' || $dpid =='7' || $dpid =='8' || $dpid =='9' || $dpid =='10') ){

return true;

}

elseif( ($Did=='8') && ($puid =='15' || $puid =='14' || $puid =='13' || $puid =='12' || $puid =='11' || $puid =='8' || $puid =='7' || $puid =='6' || $puid =='9' || $puid =='10' ) && ( $dpid =='6' || $dpid =='7' || $dpid =='8' || $dpid =='9' || $dpid =='10' || $dpid =='11' || $dpid =='12' || $dpid =='13' || $dpid =='14' || $dpid =='15') ){

return true;

}

return false;

}

function DriverLocas($Did){

if($Did=='1')

{

$locDriwise = findLoc('1').' '.findLoc('2').' '.findLoc('3').' '.findLoc('4').' '.findLoc('5');

return $locDriwise;

}

elseif($Did=='7')

{

$locDriwise = findLoc('6').' '. findLoc('7').' '.findLoc('8').' '.findLoc('9').' '.findLoc('10');

return $locDriwise;

}

elseif($Did=='8')

{

$locDriwise = findLoc('6').' '. findLoc('7').' '.findLoc('8').' '.findLoc('9').' '.findLoc('10').' '. findLoc('11').' '.findLoc('12').' '.findLoc('13').' '.findLoc('14').' '.findLoc('15');

return $locDriwise;

}

return false;

}

# code...

function driver_details($type, $id)

{

$driverData = DB::table('drivers')->get();

foreach($driverData as $dr){

if($dr->id==$id){

if($type == 'experience'){

return $dr->experience;

}

if($type == 'image'){

return $dr->image;

}

if($type=='request'){

return DB::table('availabilities')->where('driver_id',$id)->count();

}

if($type=='phone'){

return $dr->phone;

}

if($type=='workingDay'){

return DB::table('bookings')->where('driver_id',$id)->distinct('pudate')->count('pudate');

}

if($type=='customer'){

return DB::table('bookings')->where('driver_id',$id)->distinct('customer_id')->count('customer_id');

}

if($type=='income'){

$data= DB::table('bookings')->select(DB::raw('sum(total) as income'))

->where('driver_id',$id)->first();

return $data->income;

}

// type==experience, type==carNo

}

function findCustomer($id){

$data = DB::table('bookings')->where('id',$id)->first();

$customer_name = DB::table('users')->where('id',$data->customer_id)->first();

// dd($customer_name);

return $customer_name->name;

}

function feedbackDone($id){

$data = DB::table('testimonials')->where('book_id',$id)->first();

if($data){

return "Feedback Done. Thank You.";

}else{

return "Please give your Feedback.";

}

function ratingAvg($driver_id){

$bkDrDatas = DB::table('bookings')->where('driver_id',$driver_id)->get();

$ctn=0;

$noOftest = 0;

foreach($bkDrDatas as $data){

$data2 = DB::table('testimonials')->where('book_id',$data->id)->first();

if(isset($data2)) {

$ctn = $ctn + (int)$data2->rating ;

$noOftest = $noOftest + 1;

}

if($noOftest==0){

return ceil(1);

}else{

return ceil($ctn/$noOftest);

}

Models are

admin

availability

booking

car

driver

enquiry

location

pages

role

testimonial

user

In app> mail folder

adminMail.php

<?php

namespace App\Mail;

use Illuminate\Bus\Queueable;

use Illuminate\Contracts\Queue\ShouldQueue;

use Illuminate\Mail\Mailable;

use Illuminate\Queue\SerializesModels;

class adminMail extends Mailable

{

use Queueable, SerializesModels;

/**

* Create a new message instance.

* @return void

public function __construct($adminMail)

{

$this->adminMail = $adminMail;

}

/**

* Build the message.

* @return $this

public function build()

{

// return $this->view('view.name');

return $this->view('admin.mail')->with('adminMail',$this->adminMail);

}

AdminReply.blade.php

<?php

namespace App\Mail;

use Illuminate\Bus\Queueable;

use Illuminate\Contracts\Queue\ShouldQueue;

use Illuminate\Mail\Mailable;

use Illuminate\Queue\SerializesModels;

class AdminReply extends Mailable

{

use Queueable, SerializesModels;

public function __construct($adminReply)

{

$this->adminReply = $adminReply;

}

public function build()

{

return $this->view('admin.mailreply')->with('AdminReply',$this->adminReply);

// return $this->view('view.name');

}

clMail.php

<?php

namespace App\Mail;

use Illuminate\Bus\Queueable;

use Illuminate\Contracts\Queue\ShouldQueue;

use Illuminate\Mail\Mailable;

use Illuminate\Queue\SerializesModels;

class clMail extends Mailable

{

use Queueable, SerializesModels;

public function __construct($data)

{

$this->data = $data;

}

public function build()

{

return $this->view('mailsend')->with('data', $this->data);

}

FeedbackMail.blade.php

<?php

namespace App\Mail;

use Illuminate\Bus\Queueable;

use Illuminate\Contracts\Queue\ShouldQueue;

use Illuminate\Mail\Mailable;

use Illuminate\Queue\SerializesModels;

class FeedbackMail extends Mailable

{

use Queueable, SerializesModels;

/**

* Create a new message instance.

* @return void

public function __construct($id)

{

$this->id = $id;

}

/**

* Build the message.

* @return $this

public function build()

{

return $this->view('customer.fdmail')->with('data',$this->id);

}

Add middleware to App/Kernal.php

<?php

namespace App\Http;

use Illuminate\Foundation\Http\Kernel as HttpKernel;

class Kernel extends HttpKernel

{

/**

* The application's global HTTP middleware stack.

* These middleware are run during every request to your application.

* @var array<int, class-string|string>

protected $middleware = [

\App\Http\Middleware\TrustProxies::class,

\Illuminate\Http\Middleware\HandleCors::class,

\App\Http\Middleware\PreventRequestsDuringMaintenance::class,

\Illuminate\Foundation\Http\Middleware\ValidatePostSize::class,

\App\Http\Middleware\TrimStrings::class,

\Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull::class,

];

/**

* The application's route middleware groups.

* @var array<string, array<int, class-string|string>>

protected $middlewareGroups = [

'web' => [

\App\Http\Middleware\EncryptCookies::class,

\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class,

\Illuminate\Session\Middleware\StartSession::class,

\Illuminate\View\Middleware\ShareErrorsFromSession::class,

\App\Http\Middleware\VerifyCsrfToken::class,

\Illuminate\Routing\Middleware\SubstituteBindings::class,

'api' => [

// \Laravel\Sanctum\Http\Middleware\EnsureFrontendRequestsAreStateful::class,

'throttle:api',

\Illuminate\Routing\Middleware\SubstituteBindings::class,

'adlgchk'=>[

\App\Http\Middleware\adlgchk::class,

'isAdmin' => [

\App\Http\Middleware\isAdmin::class

'Driver' => [

\App\Http\Middleware\Driver::class

'Customer' => [

\App\Http\Middleware\Customer::class

'OnlyAccess' => [

\App\Http\Middleware\OnlyAccess::class

];

/**

* The application's route middleware.

* These middleware may be assigned to groups or used individually.

* @var array<string, class-string|string>

protected $routeMiddleware = [

'auth' => \App\Http\Middleware\Authenticate::class,

'auth.basic' => \Illuminate\Auth\Middleware\AuthenticateWithBasicAuth::class,

'auth.session' => \Illuminate\Session\Middleware\AuthenticateSession::class,

'cache.headers' => \Illuminate\Http\Middleware\SetCacheHeaders::class,

'can' => \Illuminate\Auth\Middleware\Authorize::class,

'guest' => \App\Http\Middleware\RedirectIfAuthenticated::class,

'password.confirm' => \Illuminate\Auth\Middleware\RequirePassword::class,

'signed' => \App\Http\Middleware\ValidateSignature::class,

'throttle' => \Illuminate\Routing\Middleware\ThrottleRequests::class,

'verified' => \Illuminate\Auth\Middleware\EnsureEmailIsVerified::class,

'disable_back_btn' => \App\Http\Middleware\DisableBackBtn::class,

];

}

IN app/http/middleware

adlgchk.php

<?php

namespace App\Http\Middleware;

use Closure;

use Illuminate\Http\Request;

use Session;

class adlgchk

{

public function handle(Request $request, Closure $next)

{

if(!session()->has('adeu')){

return redirect('adlogin');

}

return $next($request);

}

customer.php

<?php

namespace App\Http\Middleware;

use Closure;

use Illuminate\Http\Request;

use Illuminate\Support\Facades\Auth;

class Customer

{

/**

* Handle an incoming request.

* @param \Illuminate\Http\Request $request

* @param \Closure(\Illuminate\Http\Request): (\Illuminate\Http\Response|\Illuminate\Http\RedirectResponse) $next

* @return \Illuminate\Http\Response|\Illuminate\Http\RedirectResponse

public function handle(Request $request, Closure $next)

{

if(Auth::check()){

// dd(auth()->user()->role_id);

if(auth()->user()->role_id == 3){

return $next($request);

}

Auth::logout();

return redirect('adlogin');

}

DisableBackBtn.php

<?php

namespace App\Http\Middleware;

use Closure;

use Illuminate\Http\Request;

class DisableBackBtn

{

/**

* Handle an incoming request.

* @param \Illuminate\Http\Request $request

* @param \Closure(\Illuminate\Http\Request): (\Illuminate\Http\Response|\Illuminate\Http\RedirectResponse) $next

* @return \Illuminate\Http\Response|\Illuminate\Http\RedirectResponse

public function handle(Request $request, Closure $next)

{

$response= $next($request);

$response->headers->set('Cache-Control', 'nocache, no-store, max-age=0, must-revalidate');

$response->headers->set('Pragma','no-cache');

$response->headers->set('Expires','Sat, 01 Jan 2000 00:00:00 GMT');

return $response;

}

Driver.php

<?php

namespace App\Http\Middleware;

use Closure;

use Illuminate\Http\Request;

use Illuminate\Support\Facades\Auth;

use Session;

class Driver

{

/**

* Handle an incoming request.

* @param \Illuminate\Http\Request $request

* @param \Closure(\Illuminate\Http\Request): (\Illuminate\Http\Response|\Illuminate\Http\RedirectResponse) $next

* @return \Illuminate\Http\Response|\Illuminate\Http\RedirectResponse

public function handle(Request $request, Closure $next)

{

if(session()->has('driver_id')){

return $next($request);

}

return redirect('driver');

}

isAdmin.php

<?php

namespace App\Http\Middleware;

use Closure;

use Illuminate\Http\Request;

use Illuminate\Support\Facades\Auth;

class isAdmin

{

/**

* Handle an incoming request.

* @param \Illuminate\Http\Request $request

* @param \Closure(\Illuminate\Http\Request): (\Illuminate\Http\Response|\Illuminate\Http\RedirectResponse) $next

* @return \Illuminate\Http\Response|\Illuminate\Http\RedirectResponse

public function handle(Request $request, Closure $next)

{

// dd(Auth::user()->role_id);

// dd(Auth::check());

if(Auth::check()){

if(Auth()->user()->role_id == 1){

return $next($request);

}

Auth::logout();

return redirect('adlogin');

}

OnlyAccess.blade.php

<?php

namespace App\Http\Middleware;

use Closure;

use Illuminate\Http\Request;

use Illuminate\Support\Facades\Auth;

class OnlyAccess

{

/**

* Handle an incoming request.

* @param \Illuminate\Http\Request $request

* @param \Closure(\Illuminate\Http\Request): (\Illuminate\Http\Response|\Illuminate\Http\RedirectResponse) $next

* @return \Illuminate\Http\Response|\Illuminate\Http\RedirectResponse

public function handle(Request $request, Closure $next)

{

if(Auth::check()){

return $next($request);

}

Auth::logout();

return redirect('adlogin');

}

Inside App\Http\Controllers

adminController.blade.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\user;

use App\Models\pages;

use App\Models\Role;

use App\Models\enquiry;

use App\Models\car;

use App\Models\driver;

use App\Models\availability;

use App\Models\booking;

use App\Models\testimonial;

use Hash;

use Session;

use DB;

use App\Mail\adminMail;

use Illuminate\Support\Facades\Mail;

use Carbon\Carbon;

use Illuminate\Support\Facades\Auth;

class AdminController extends Controller

{

function register() {

return view('admin.register');

}

function forget_pass() {

return view('admin.forget_pass');

}

function login() {

return view('admin.login');

}

function index() {

if (Auth::check()) { // The user is logged in...

$driverCnt =driver::where('active','1')->count();

$carCnt = car::where('status','1')->count();

$bkngCnt = booking::where('status','1')->count();

// dd($bkngCnt);

$tInc = booking::where('status','1')->get();

$total=0;

foreach($tInc as $row){

$total = $total + $row->total;

}

// dd($total);

$data['driverCnt'] = $driverCnt;

$data['carCnt'] = $carCnt;

$data['bkngCnt'] = $bkngCnt;

$data['total'] =$total;

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.index',['adeu' => $adfn,'data'=>$data]);

}

return redirect()->back();

} //ok

function adfrinac(Request $r){

$r->validate([

'name' => 'required',

'email' => 'required |unique:users',

'password' => 'required',

// 'role' => 'required',

'adimg' => 'image|mimes:jpg,jpeg,png,ico,bmp'

]);

if($r->hasFile('adimg')) {

$file_type = $r->file('adimg')->extension();

$file_path = $r->file('adimg')->storeAs('admin/images/pf', time() . '.' . $file_type, 'public');

$r->file('adimg')->move(public_path('admin/images/pf'), time() . '.' . $file_type);

}

$nwad = new user;

$nwad->name = $r->name;

$nwad->email = $r->email;

$nwad->password = Hash::make($r->password);

// $nwad->role = $r->role;

$nwad->image=$file_path;

$nwad->save();

// Session::flash('message', "Records are Added Successfully");

return redirect('adlogin');

}//okok

// admin login

function adlgac(Request $r){

// email

$user = user::where('email',$r->email)->first();

$adcnt = user::where('email',$r->email)->count();

if($adcnt > 0){

if($user->active == 1){

if(Hash::check($r->password, $user->password )){

$r->session()->put('adeu',$user);

$r->session()->put('user_id',$user->id);

Auth::login($user);

return redirect('adindex')->with('message',' Login Successfully. ');

}else{

return redirect()->back()->with('wrlgcr','** Username or Password does not match');

}

}else{

return redirect()->back()->with('wrlgcr',' You are blocked for a limited period of time.');

}

}else{

return redirect()->back()->with('wrlgcr','** Username or Password does not match');

}

}//okok

// mail box blade view page

function mailbox(){

$data = enquiry::paginate(5);

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.mailbox',['data'=>$data,'adeu' => $adfn]);

}

// admin mail sending // admin reply mail post

function admailsend(Request $req){

$enrr = enquiry::find($req->sid);

$adminmail=[

'name'=> $enrr->name,

'email'=> $enrr->email,

'subject'=> $req->subject,

'message'=> $req->rply,

];

Mail::to($enrr->email)->send(new adminMail($adminmail));

DB::table('enquiries')->where('id',$req->sid)->update(['status' => '1']);

return view('admin.mailreply',['AdminReply'=>$adminmail]);

}

// admin reply data fetch

public function mail_rply($id)

{

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$enrr = enquiry::find($id);

return view('admin.reply_mail',['adeu' => $adfn, 'enrr' => $enrr]);

}

// admin account data fetch

function adacc(){

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data2 = role::select("*")->whereIn('id', explode(', ', $adfn->role_id))->get();

return view('admin.adaccount',['adeu' => $adfn, 'data2'=>$data2]);

}

// admin account update

public function adupac(Request $req)

{

$req->validate([

'name' => 'required',

'email' => 'required|email|unique:users,email,'.$req->adid,

'adimg' => 'image|mimes:jpg,jpeg,png,ico,bmp'

]);

if ($req->hasFile('adimg')) {

if($req->old_img != '' )

unlink($req->old_img);

$file_type = $req->file('adimg')->extension();

$file_path = $req->file('adimg')->storeAs('admin/images/pf', time() . '.' . $file_type, 'public');

$req->file('adimg')->move(public_path('admin/images/pf'), time() . '.' . $file_type);

}else{

$file_path=$req->old_img;

}

$adur = DB::table('users')

->where('id', $req->adid)

->update([

'name' => $req->name,

'email' => $req->email,

'image' => $file_path,

]);

Session::flash('message', "Records Updated Successfully");

return redirect('adindex');

}

// admin change password view page

function adchpas(){

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.chnps',['adeu' => $adfn]);

}

// admin password update action

function adpassupdate(Request $req){

$adfn = user::where('email',$req->ademail)->first();

$adcnt = user::where('email',$req->ademail)->count();

if($adcnt > 0){

if(Hash::check($req->op, $adfn->password )){

if($req->op != $req->np){

if($req->np == $req->cp){

$adur = DB::table('users')

->where('id', $req->adid)

->update([

'password' => Hash::make($req->np),

]);

Session::flash('message', "Password Updated Successfully");

return redirect('adindex');

}else{

return redirect()->back()->with('wrlgcr','** New Password and Confirm Password does not match');

}

}else{

return redirect()->back()->with('wrlgcr','** Old Password and New Password are Same, Need to be changed.');

}

}else{

return redirect()->back()->with('wrlgcr','** Old Password and Database Password does not match');

}

}else{

return redirect()->back()->with('wrlgcr','** Invalid User');

}

// banner page view list page

function pagebannertitlechangeview(){

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$pages = pages::all();

// return $pages;

return view('admin.changer',['adeu' => $adfn, 'pages'=>$pages]);

}

// banner page active inactive post method

function acinacfmac(Request $req){

$pg = pages::where('id',$req->id)->first();

if($pg->active == 1)

$c=0;

else

$c=1;

$pg = DB::table('pages')

->where('id', $req->id)

->update(['active' =>$c ]);

return redirect('chnger')->with('status','Page status changed');

}

// banner edit page view data fetch

function pggedit(Request $req){

$pg = pages::where('id',$req->pggid)->first();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.editpage',['pg'=>$pg,'adeu' => $adfn]);

}

// page edit post

public function editpggac(Request $req)

{

$insert=array();

if($req->hasfile('images')) {

if($req->pgimz!=null){

$img = explode(', ', $req->pgimz);

foreach($img as $image){

unlink($image);

}

foreach($req->file('images') as $key => $file)

{

$rnff = rand(0, 99999);

$file_type = $file->extension();

$file_path = $file->storeAs('admin/images/bg', $rnff . time() . '.' . $file_type, 'public');

$file->move(public_path('admin/images/bg'), $rnff . time(). '.' . $file_type);

array_push($insert,$file_path);

}

$insert= implode(", ",$insert);

}else{

$insert = $req->pgimz; }

$data = DB::table('pages')->where('id',$req->adid)->update(['active' => $req->pgact, 'page' => $req->pgpage, 'title' => $req->pgtitle, 'image' => $insert ]);

return redirect('chnger')->with('status','Successfully Updated Page Data');

}

// date wise mail search

public function mailsrch(Request $req)

{

$start_date = Carbon::parse($req->start_date)->toDateTimeString();

$end_date = Carbon::parse($req->end_date)->toDateTimeString();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = enquiry::whereBetween('created_at', [$start_date, $end_date])->paginate(5);

return view('admin.mailbox',['data'=>$data,'adeu' => $adfn, 'req'=>$req]);

}

// page add view fetch method

public function pgadds()

{

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.addpage',['adeu' => $adfn]);

}

// page delete

public function pgdeletes($pid)

{

$pg = pages::find($pid);

$pd = DB::table('pages')->where('id', $pid)->delete();

return redirect('chnger')->with('status','Successfully Deleted '. $pg->page.' Page Data');

}

// page add action post

public function addpggac(Request $req)

{

$req->validate([

'page' => 'required|unique:pages',

'title' => 'required',

'pgact' => 'required',

]);

$insert=array();

if($req->hasfile('images'))

{

foreach($req->file('images') as $key => $file)

{

$rnff = rand(0, 99999);

$file_type = $file->extension();

$file_path = $file->storeAs('admin/images/bg', $rnff . time() . '.' . $file_type, 'public');

$file->move(public_path('admin/images/bg'), $rnff . time(). '.' . $file_type);

array_push($insert,$file_path);

}

$insert= implode(", ",$insert);

}

$data = DB::table('pages')->insert(['active' => $req->pgact, 'page' => $req->page, 'title' => $req->title, 'image' => $insert ]);

return redirect('chnger')->with('status','Successfully Created Page Data');

}

// USER ROLE

public function user_roles() {

$users = user::all();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.user_roles',['adeu' => $adfn, 'users'=> $users]);

}

// DRIVER ROLE

public function driverList()

{

$adfn = user::where('email',session()->get('adeu')['email'] )->first(); //sidebar data

$drivers = driver::all(); //driver data

return view('admin.driver_roles',['adeu' => $adfn, 'drivers'=>$drivers]);

}

// USER ROLE EDIT

public function user_role_edit(Request $req)

{

// dd($req->driver_id);

if(isset($req->user_id)){

$usr = user::find($req->user_id);

$isUser= true;

}elseif(isset($req->driver_id)){

$usr = driver::find($req->driver_id);

$isUser = false;

}

$data2 = role::select("*")->whereIn('id', explode(', ', $usr->role_id))->get();

// dd($usr);

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.user_edit_roles',['adeu' => $adfn, 'user'=> $usr , 'isUser'=>$isUser, 'data2' =>$data2]);

}

// user role edit fun

public function edit_ac_user_role(Request $req)

{

if($req->isUser){

$usr = user::find($req->user_id);

if ($req->hasFile('image')) {

if($req->pgimz != '' )

unlink($req->pgimz);

//echo "";

$file_type = $req->file('image')->extension();

$file_path = $req->file('image')->storeAs('admin/images/pf', time() . '.' . $file_type, 'public');

$req->file('image')->move(public_path('admin/images/pf'), time() . '.' . $file_type);

}else{

$file_path=$req->pgimz;

}

DB::table('users')->where('id',$req->adid)->update(['name' => $req->name, 'email' => $req->email, 'image' => $file_path ]);

return redirect('user_roles')->with('status','Successfully Updated User');

}else{

$eu = driver::find($req->driver_id);

if ($req->hasFile('image')) {

if($req->pgimz != '' )

unlink($req->pgimz);

//echo "";

$file_type = $req->file('image')->extension();

$file_path = $req->file('image')->storeAs('admin/images/driver', time() . '.' . $file_type, 'public');

$req->file('image')->move(public_path('admin/images/driver'), time() . '.' . $file_type);

}else{

$file_path=$req->pgimz; }

DB::table('drivers')->where('id',$req->adid)->update(['name' => $req->name, 'email' => $req->email, 'image' => $file_path ]);

return redirect('driverList')->with('status','Successfully Updated User');

}

// add new user

public function add_user_role()

{

$rolesall = role::all();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.add_user_role',['adeu' => $adfn, 'eduall' => $rolesall]);

}

public function add_ac_user_role(Request $req){

#name, email, roles, image

$req->validate([

'name' => 'required',

'email' => 'required|unique:users',

'roles' => 'required',

'password' => 'required',

'image' => 'image|mimes:jpg,jpeg,png,ico,bmp'

]);

$file_type = $req->file('image')->extension();

$file_path = $req->file('image')->storeAs('admin/images/pf', time() . '.' . $file_type, 'public');

$req->file('image')->move(public_path('admin/images/pf'), time() . '.' . $file_type);

$password = Hash::make($req->password);

if($req->roles == 2){

// dd($extract);

DB::table('drivers')->insert([

'name' => $req->name,

'email' => $req->email,

'password' => Hash::make($req->password),

'image' => $file_path,

'role_id' => $req->roles,

'salary' => '18000',

]);

Session::flash('status', "Successfully Updated Driver.");

return redirect('driverList');

}else{

$data = DB::table('users')->insert(['name' => $req->name, 'email' => $req->email, 'password' => $password, 'role_id' => $req->roles, 'image' => $file_path ]);

}

return redirect('user_roles')->with('status',' Successfully Updated User.');

}

// Delete users

public function user_role_delete(Request $req)

{

// dd($req->user_id);

if(isset($req->user_id)){

$data = DB::table('users')->where('id',$req->user_id)->get();

$role = $data[0]->role_id;

$users = User::select("*")->whereIn('role_id', [1])->get();

if($role == 1 && count($users) == 1)

{

return redirect('user_roles')->with('error',' Admin Cannot be Deleted.');

}else if($role == 1 && count($users) > 1 && session()->get('adeu')['id'] == $id){

// more than one admin

DB::table('users')->where('id',$req->user_id)->delete();

Session::forget('adeu');

return redirect('adlogin');

}

// else customer

DB::table('users')->where('id',$req->user_id)->delete();

}elseif(isset($req->driver_id)){

DB::table('drivers')->where('id',$req->driver_id)->delete();

return redirect('driverList')->with('status','Successfully Updated User');

}

return redirect('user_roles')->with('status',' Successfully Deleted User');

}

// User Driver active inactive function

public function acInacUserDri(Request $req)

{

$c=0;

if(isset($req->user_id)){

$user = user::where('id',$req->user_id)->first();

if($user->active == 1)

$c=0;

else

$c=1;

$pg = DB::table('users')

->where('id', $req->user_id)

->update(['active' =>$c ]);

if($c==0) //inactive

{

return redirect('user_roles')->with('status',' Successfully Deactivated User.');

}else

{

return redirect('user_roles')->with('status',' Successfully Activated User.');

}

}elseif(isset($req->driver_id)){

$driver = Driver::where('id',$req->driver_id)->first();

if($driver->active == 1)

$c=0;

else

$c=1;

$pg = DB::table('drivers')

->where('id', $req->driver_id)

->update(['active' =>$c ]);

if($c==0) //inactive

{

return redirect('driverList')->with('status',' Successfully Deactivated Driver.');

}else

{

return redirect('driverList')->with('status',' Successfully Activated Driver.');

}

// customer user search field

public function user_srch(Request $req){

if(isset($req->srch)){

$data = DB::table('users')->where('email','LIKE','%'.$req->srch.'%' )->orWhere('name','LIKE', '%'.$req->srch.'%')->get();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.user_roles',['adeu' => $adfn, 'users'=>$data, 'srch'=>$req->srch]);

}else if(isset($req->driver_srch)) {

$data = DB::table('drivers')->where('email','LIKE','%'.$req->driver_srch.'%' )->orWhere('name','LIKE', '%'.$req->driver_srch.'%')->get();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.driver_roles',['adeu' => $adfn, 'drivers'=>$data, 'srch'=>$req->driver_srch]);

}

// CAR DATA CAR MODEL CAR MIGRATIONS // CAR DATA CAR MODEL CAR MIGRATIONS // CAR DATA CAR MODEL CAR MIGRATIONS

// Fetching Car data

public function carList()

{

$cars = car::all();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.carList',['adeu' => $adfn, 'cars' => $cars]);

}

# add car blade file

public function addCars()

{

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.carAdding',['adeu' => $adfn]);

}

#adding car post method

public function car_added(Request $req)

{

$req->validate([

'name' => 'required',

'brand' => 'required',

'carNo' => 'required',

'person' => 'required',

'gear' => 'required',

'year' => 'required',

'kmpl' => 'required',

'features' => 'required',

'status' => 'required',

'runs' => 'required' ,

'price' => 'required',

'images' => 'required'

]);

// array of images

$insert=array();

if($req->hasfile('images'))

{

foreach($req->file('images') as $key => $file)

{

$rnff = rand(0, 99999);

$file_type = $file->extension();

$file_path = $file->storeAs('admin/images/cars', $rnff . time() . '.' . $file_type, 'public');

$file->move(public_path('admin/images/cars'), $rnff . time(). '.' . $file_type);

array_push($insert,$file_path);

}

$insert= implode(", ",$insert);

}else{

$insert = $req->pgimz;

}

$car = new car;

$car->name = $req->name;

$car->brand = $req->brand;

$car->carNo = $req->carNo;

$car->person = $req->person;

$car->gear = $req->gear;

$car->year = $req->year;

$car->kmpl = $req->kmpl;

$car->status = $req->status;

$car->features = $req->features;

$car->desc = $req->desc;

$car->price = $req->price;

$car->runs = $req->runs;

$car->image= $insert;

$car->book= '0';

$car->save();

Session::flash('message', "Car Added Successfully");

return redirect('carList');

}

// car edit page view with value

public function car_edit(Request $req)

{

$car = car::find($req->car_id);

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

// return view('admin.carAdding',['adeu' => $adfn]);

return view('admin.car_edit',['adeu' => $adfn, 'car'=>$car]);

}

// car_edit_action

public function car_edit_ac(Request $req)

{

$req->validate([

'name' => 'required',

'brand' => 'required',

'carNo' => 'required',

'person' => 'required',

'gear' => 'required',

'year' => 'required',

'kmpl' => 'required',

'features' => 'required',

'status' => 'required',

'runs' => 'required' ,

'price' => 'required',

]);

// array of images

$insert=array();

if($req->hasfile('images'))

{

if($req->pgimz != '' )

unlink($req->pgimz);

foreach($req->file('images') as $key => $file)

{

$rnff = rand(0, 99999);

$file_type = $file->extension();

$file_path = $file->storeAs('admin/images/cars', $rnff . time() . '.' . $file_type, 'public');

$file->move(public_path('admin/images/cars'), $rnff . time(). '.' . $file_type);

array_push($insert,$file_path);

}

$insert= implode(", ",$insert);

}else{

$insert = $req->pgimz;

}

$car = car::find($req->car_id);

$car->name = $req->name;

$car->brand = $req->brand;

$car->carNo = $req->carNo;

$car->person = $req->person;

$car->gear = $req->gear;

$car->year = $req->year;

$car->kmpl = $req->kmpl;

$car->status = $req->status;

$car->features = $req->features;

$car->desc = $req->desc;

$car->price = $req->price;

$car->runs = $req->runs;

$car->image= $insert;

$car->save();

Session::flash('status', $car->name." Car Updated Successfully");

return redirect('carList');

}

// Car Delete action

public function carDelete($id)

{

$car = DB::table('cars')->where('id',$id)->first();

if($car->image != '' ){

$img = explode(', ', $car->image);

foreach($img as $image){

unlink($image);

}

DB::table('cars')->where('id',$id)->delete();

return redirect('carList')->with('status',' Car Deleted Successfully. ');

}

public function acInacCars(Request $req)

{

$c=0;

if(isset($req->car_id)){

$car = car::where('id',$req->car_id)->first();

if($car->status == 1)

$c=0;

else

$c=1;

$pg = DB::table('cars')

->where('id', $req->car_id)

->update(['status' =>$c ]);

}

if($c==0) //inactive

{

return redirect('carList')->with('status',' Successfully Deactivated Car.');

}else

{

return redirect('carList')->with('status',' Successfully Activated Car.');

}

// Admin Show all available request list

public function readRequest()

{

$data = availability::paginate(5);

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.readRequest',['adeu' => $adfn, 'data'=>$data]);

}

// search field on Admin Show all available request list

// get method act as post

// Joining multiple table and check using where clause

public function RequestSrch(Request $req){

$srch= $req->input('srch');

if(strtoupper($srch) == 'NO MAILS') {

$data = availability::where('mail','0')->get();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.readRequest',['adeu' => $adfn, 'data'=>$data , 'srchbck'=>$srch]);

}else if(strtoupper($srch) == 'MAIL SENT'){

$data = availability::where('mail','1')->get();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.readRequest',['adeu' => $adfn, 'data'=>$data, 'srchbck'=>$srch]);

}else if( strtoupper($srch) == 'NO RESPONSE'){

$data = availability::where('available',null)->get();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.readRequest',['adeu' => $adfn, 'data'=>$data, 'srchbck'=>$srch]);

}else if( strtoupper($srch) == 'REJECTED'){

$data = availability::where('available','0')->get();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.readRequest',['adeu' => $adfn, 'data'=>$data, 'srchbck'=>$srch]);

}

else if( strtoupper($srch) == 'AVAILABLE'){

$data = availability::where('available','1')->get();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.readRequest',['adeu' => $adfn, 'data'=>$data, 'srchbck'=>$srch]);

}

$data= availability::join('drivers','drivers.id', '=', 'availabilities.driver_id')

->join('cars', 'cars.id', '=', 'availabilities.car_id')

->join('locations', 'locations.id', '=', 'availabilities.puloc')

->join('locations as l2', 'l2.id', '=', 'availabilities.droploc')

->join('users', 'users.id', '=', 'availabilities.customer_id')

->where('drivers.name','LIKE', '%'.$srch.'%')

->orWhere('cars.name', 'LIKE','%'.$srch.'%')

->orWhere('cars.brand', 'LIKE','%'.$srch.'%')

->orWhere('locations.area', 'LIKE','%'.$srch.'%')

->orWhere('availabilities.pudate', 'LIKE','%'.$srch.'%')

->orWhere('availabilities.putime', 'LIKE','%'.$srch.'%')

->orWhere('users.name', 'LIKE','%'.$srch.'%')

->orWhere('l2.area', 'LIKE','%'.$srch.'%')

->get();

// dd( $data);

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.readRequest',['adeu' => $adfn, 'data'=>$data,'srchbck'=>$srch]);

}

// date wise availability search

public function avai_date_srch(Request $req)

{

$start_date = Carbon::parse($req->start_date)->toDateTimeString();

$end_date = Carbon::parse($req->end_date)->toDateTimeString();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = availability::whereBetween('pudate', [$start_date, $end_date])->get();

return view('admin.readRequest',['data'=>$data,'adeu' => $adfn, 'req'=>$req]);

}

// Booking page view fun

public function bookingList()

{

// dd('admin booking page');

$data = booking::paginate(5);

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.bookings',['adeu' => $adfn, 'data'=>$data]);

}

// All views Driver & Customer

public function allDr_Cu()

{

$customers = user::where('role_id',3)->get();

$drivers = driver::all();

// dd($customers);

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.allDr_Cu',['adeu' => $adfn, 'users'=>$customers, 'drivers'=>$drivers]);

}

public function userSel($data)

{

if($data == 'customer')

{

$customers = user::where('role_id',3)->get();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.allDr_Cu',['adeu' => $adfn, 'users'=>$customers, 'srch'=>$data ]);

}

elseif($data == 'driver'){

$drivers = driver::all();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.allDr_Cu',['adeu' => $adfn, 'drivers'=>$drivers, 'srch'=>$data]);

}

return redirect()->back() ;

}

// JQUERY IMPLEMENT IN ALL DATA SELECT WISE

// public function allDr_CuJQ($type)

// {

// // dd($type);

// if($type == 'customer'){

// $customers = user::where('role_id',3)->get();

// $drivers=null;

// }elseif ($type == 'driver'){

// $drivers = driver::all();

// $customers=null;

// }else{

// $customers = user::where('role_id',3)->get();

// $drivers = driver::all();

// }

// // dd($customers);

// $adfn = user::where('email',session()->get('adeu')['email'] )->first();

// return view('admin.allDr_Cu',['adeu' => $adfn, 'users'=>$customers, 'drivers'=>$drivers]);

// }

// booking table admin blade search function

public function BookingSrch(Request $req)

{

$srch= $req->input('srch');

if( strtoupper($srch) == 'NO RESPONSE'){

$data = booking::where('status','2')->get();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.bookings',['adeu' => $adfn, 'data'=>$data, 'srchbck'=>$srch]);

}else if( strtoupper($srch) == 'BOOKING CANCLE'){

$data = booking::where('status','0')->get();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.bookings',['adeu' => $adfn, 'data'=>$data, 'srchbck'=>$srch]);

}

else if( strtoupper($srch) == 'BOOKING CONFIRM'){

$data = booking::where('status','1')->get();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.bookings',['adeu' => $adfn, 'data'=>$data, 'srchbck'=>$srch]);

}

$data= booking::join('drivers','drivers.id', '=', 'bookings.driver_id')

->join('cars', 'cars.id', '=', 'bookings.car_id')

->join('locations', 'locations.id', '=', 'bookings.puloc')

->join('locations as l2', 'l2.id', '=', 'bookings.drloc')

->join('users', 'users.id', '=', 'bookings.customer_id')

->where('drivers.name','LIKE', '%'.$srch.'%')

->orWhere('cars.name', 'LIKE','%'.$srch.'%')

->orWhere('cars.brand', 'LIKE','%'.$srch.'%')

->orWhere('locations.area', 'LIKE','%'.$srch.'%')

->orWhere('bookings.pudate', 'LIKE','%'.$srch.'%')

->orWhere('bookings.putime', 'LIKE','%'.$srch.'%')

->orWhere('bookings.mobile', 'LIKE','%'.$srch.'%')

->orWhere('users.name', 'LIKE','%'.$srch.'%')

->orWhere('l2.area', 'LIKE','%'.$srch.'%')

->select('*','bookings.status as bkkStatus')

->get();

// dd( $data);

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.bookings',['adeu' => $adfn, 'data'=>$data,'srchbck'=>$srch]);

}

// date wise booking search

public function bkk_date_srch(Request $req)

{

$start_date = Carbon::parse($req->start_date)->toDateTimeString();

$end_date = Carbon::parse($req->end_date)->toDateTimeString();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = booking::whereBetween('pudate', [$start_date, $end_date])->get();

return view('admin.bookings',['data'=>$data,'adeu' => $adfn, 'req'=>$req]);

}

# admin show specific booking details

public function adShowTrip($id)

{

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = booking::where('id', $id)->first();

$driverData = driver::where('id',$data->driver_id)->first();

return view('admin.adShowTrip',['item'=>$data,'adeu' => $adfn, 'driverData'=>$driverData]);

}

# admin show driver earnings blade view file..

public function drEarnings()

{

$driver_info = DB::table('bookings')

->select('driver_id', DB::raw('count(*) as total'), DB::raw('sum(total) as income'))

->groupBy('driver_id')

->get();

$bookings = DB::table('bookings')->get();

// dd($bookings);

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.drEarnings',['driver_info'=>$driver_info, 'adeu' => $adfn, 'data'=>$bookings]);

}

# admin show all testimonials

public function showTesti()

{

$testis = testimonial::all();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

return view('admin.testimonials',['testis'=>$testis, 'adeu' => $adfn]);

}

# testimonial active Inactive function

public function testiAcIn(Request $req)

{

$data = testimonial::where('id',$req->t_id)->first();

if($req->type=='active'){

$data2 = testimonial::where('id',$req->t_id)->update(['status'=>'1']);

}elseif($req->type=='inactive'){

$data2 = DB::table('testimonials')->where('id',$req->t_id)->update(['status'=>'0']);

}

// dd($data,$req->t_id,$data2);

return redirect()->back()->with('status',' Successfully Updated Testimonial.'); ;

}

# testimonial edit function

public function delTestimonial($id)

{

DB::table('testimonials')->where('id',$id)->delete();

return redirect()->back()->with('status',' Successfully Deleted Testimonial.'); ;

}

# driver name wise search

public function bkkSrch(Request $req)

{

$srch= $req->input('srch');

$mnth = $req->input('month');

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

if(isset($mnth)){

$data= booking::join('drivers','drivers.id', '=', 'bookings.driver_id')

->where('drivers.name','LIKE', '%'.$srch.'%')

->whereMonth(

'pudate',

Carbon::createFromFormat('m', $req->month)

)->get();

return view('admin.drEarnings',['adeu' => $adfn, 'data'=>$data,'srchbck'=>$srch, 'srMnth'=>$mnth]);

}else{

$data= booking::join('drivers','drivers.id', '=', 'bookings.driver_id')

->where('drivers.name','LIKE', '%'.$srch.'%')

->get();

return view('admin.drEarnings',['adeu' => $adfn, 'data'=>$data,'srchbck'=>$srch]);

}

# Datewise search

public function earning_date_srch(Request $req)

{

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

if(isset($req->srch)){

$dataFetch = booking::join('drivers','drivers.id', '=', 'bookings.driver_id')

->where('drivers.name','LIKE', '%'.$req->srch.'%')

->whereMonth(

'pudate',

Carbon::createFromFormat('m', $req->month)

)->get();

return view('admin.drEarnings',['adeu' => $adfn, 'data'=>$dataFetch,'srMnth'=>$req->month, 'srchbck'=>$req->srch]);

}else{

$dataFetch = booking::whereMonth(

'pudate',

Carbon::createFromFormat('m', $req->month)

)->get();

return view('admin.drEarnings',['adeu' => $adfn, 'data'=>$dataFetch,'srMnth'=>$req->month]);

}

// $data11=DB::table('carbookingmodels')->where('pickupdate','like',$req->searchd.'/%')->get();

}

// export excel file of Sales Report

public function excelExport(Request $req)

{

$fileName = "members-data_" . date('Y-m-d') . ".xls";

$fields = array('Sr No.', 'Driver Name', 'Customer Name', ' Pickup Date', 'Payment Mode', 'Income', 'Status');

$excelData = implode("\t", array_values($fields)) . "\n";

$query = DB::table('bookings')->get();

$arrexplode = json_decode($req->data);

$c=1;

foreach($arrexplode as $row){

if($row->bookStatus=='4'){

$status = 'Complete';

}elseif($row->bookStatus=='0'){

$status = 'Canceled';

}elseif($row->bookStatus=='5'){

$status = 'Payment Due';

}elseif($row->bookStatus=='3' || $row->bookStatus=='2' ){

$status = 'Ongoing Process';

}else{

$status = 'No Response';

}

$lineData = array($c++, findDri($row->driver_id), findCust($row->customer_id), $row->pudate, $row->paymentMode, '$ '.$row->total.'.00' , $status );

$excelData .= implode("\t", array_values($lineData)) . "\n";

}

// Headers for download

header("Content-Type: application/vnd.ms-excel");

header("Content-Disposition: attachment; filename=\"$fileName\"");

// Render excel data

echo $excelData;

}

CarController.blade.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Notification;

use Carbon\Carbon;

use DB;

use App\Notifications\SendEmailNotification;

use Illuminate\Support\Facades\Mail;

use App\Mail\clMail;

use App\Mail\adminMail;

use App\Models\booking;

use App\Models\enquiry;

use App\Models\driver;

use App\Models\pages;

use App\Models\Car;

use App\Models\user;

use App\Models\Role;

use App\Models\availability;

use App\Models\location;

use Hash;

use Session;

use Illuminate\Support\Facades\Auth;

class CarController extends Controller

{

public function index(){

$page=pages::where('page','=','home')->first();

$cars = car::all()->take(6);

$drivers = driver::all();

$locations = DB::table('locations')->get();

$testimonials = DB::table('testimonials')->get();

return view('index',['page'=>$page, 'drivers' => $drivers, 'cars' => $cars, 'locations'=>$locations, 'testimonials'=>$testimonials]);

}

public function about(){

$page=pages::where('page','=','about')->first();

$cars = car::all();

$drivers = driver::all();

$locations = DB::table('locations')->get();

return view('about',['page'=>$page, 'drivers' => $drivers, 'cars' => $cars, 'locations'=>$locations]);

}

public function booking($id){

$page=pages::where('page','=','carbooking')->first();

if (str_contains($id, "bookid=")) { // when id has booking id

$bookid = substr($id,7);

$bookdata = DB::table('availabilities')->where('id',$bookid)->first();

$bookdata->pudate= Carbon::parse($bookdata->pudate)->format('m/d/Y');

$car = DB::table('cars')->where('id',$bookdata->car_id)->first();

}else{ // for all booking car

$car = DB::table('cars')->where('id',$id)->first();

$bookdata=null;

$bookid=null;

}

$drivers = driver::all();

$cars = car::all();

$locations = DB::table('locations')->get();

return view('booking',['page'=>$page, 'car'=>$car, 'cars'=>$cars, 'drivers' => $drivers,'locations'=>$locations, 'bookdata'=> $bookdata, 'bookid'=>$bookid]);

}

public function contact(){

$page=pages::where('page','=','contact')->first();

$drivers = driver::all();

$cars = car::all();

$locations = DB::table('locations')->get();

return view('contact',['page'=>$page, 'cars'=>$cars, 'drivers' => $drivers,'locations'=>$locations]);

}

public function detail($id){

$page=pages::where('page','=','cardetail')->first();

$car = DB::table('cars')->where('id',$id)->first();

$relatedcars = DB::table('cars')->select('*')->whereNotIn('id',[$id])->get()->take(4);

// dd( $relatedcars);

$drivers = driver::all();

$cars = car::all();

$locations = DB::table('locations')->get();

return view('detail',['page'=>$page, 'car'=>$car, 'relatedcars' => $relatedcars, 'drivers' => $drivers, 'cars' => $cars, 'locations'=>$locations]);

}

public function service(){

$page=pages::where('page','=','service')->first();

$drivers = driver::all();

$cars = car::all();

$locations = DB::table('locations')->get();

return view('service',['page'=>$page, 'cars'=>$cars, 'drivers' => $drivers,'locations'=>$locations]);

}

public function team(){

$page=pages::where('page','=','theteam')->first();

$drivers = driver::all();

$cars = car::all();

$locations = DB::table('locations')->get();

return view('team',['page'=>$page, 'cars'=>$cars, 'drivers' => $drivers,'locations'=>$locations]);

}

public function car(){

$page=pages::where('page','=','carlist')->first();

$drivers = driver::all();

$cars = car::all();

$locations = DB::table('locations')->get();

return view('car',['page'=>$page, 'cars'=>$cars, 'drivers' => $drivers,'locations'=>$locations]);

}

public function testimonial(){

$page=pages::where('page','=','testimonial')->first();

$drivers = driver::all();

$cars = car::all();

$locations = DB::table('locations')->get();

$testimonials = DB::table('testimonials')->get();

return view('testimonial',['page'=>$page , 'cars'=>$cars, 'drivers' => $drivers,'locations'=>$locations, 'testimonials'=>$testimonials]);

}

# driver profile show

public function driverProfile($id)

{

$page=pages::where('page','=','driverProfile')->first();

$idDr = driver::where('id',$id)->first();

$drivers = driver::all();

$cars = car::all();

$locations = DB::table('locations')->get();

return view('driverProfile',['page'=>$page , 'cars'=>$cars, 'drivers' => $drivers,'locations'=>$locations, 'data'=>$idDr]);

}

public function confmac(Request $req){

$enrr = new enquiry;

$enrr->name = $req->enname;

$enrr->email = $req->enemail;

$enrr->subject = $req->ensubject;

$enrr->message = $req->enmsgbdy;

$enrr->save();

return redirect('contact')->with('success','Mail sent successfully.');

}

public function clcontact(Request $req)

{

$enrr = new enquiry;

$enrr->name = $req->enname;

$enrr->email = $req->enemail;

$enrr->subject = $req->ensubject;

$enrr->message = $req->enmsgbdy;

$enrr->save();

// $data= array('name'=>$req->enname);

// Mail::send(['data'=>'mailsend'], $data, function($message) use ($req){

// $message->to($req->enemail,$req->enname)->subject('Feedback from Royal Cars');

// $message->text('Hello '.$req->enname.','.PHP_EOL.' We received your mail, Our employee contact with you soon.'.PHP_EOL.'Thank you');

// $message->from('sk.saifuddin@brainiuminfotech.com','Royal Cars SK Saifuddin');

// });

$adminmail=[

'name'=> $req->enname,

'email'=> $req->enemail,

'subject'=> $req->ensubject,

'message'=>'Hello '.$req->enname.','.PHP_EOL.' We received your mail, Our employee contact with you soon.'.PHP_EOL.'Thank you'

];

Mail::to($enrr->email)->send(new adminMail($adminmail));

return redirect('/')->with('success','Mail Sent Successfully.');

}

// CAR DATA CAR MODEL CAR MIGRATIONS // CAR DATA CAR MODEL CAR MIGRATIONS // CAR DATA CAR MODEL CAR MIGRATIONS

// booking details save to db

public function booking_details(Request $req)

{

$req->validate([

'mobile' =>'required',

'puloc' => 'required',

'drloc' => 'required',

'pudate' => 'required',

'putime' => 'required',

'personAd'=> 'required',

'personCh'=> 'required',

'message'=> 'required',

'payment'=> 'required',

'driverSel'=> 'required',

]);

$car = Car::find($req->car_id);

$start_date = Carbon::parse($req->pudate)->toDateTimeString();

$user = user::where('id',session()->get('user_id') )->first();

if(isset($user)){

if(! isDriverLoc($req->driverSel, $req->puloc, $req->drloc)){

return redirect()->back()->with('error','Driver is Not Available for these Locations. Locations are: '.DriverLocas($req->driverSel));

}

$srch_date = Carbon::parse($req->pudate)->format('Y-m-d'); //srch for available drivers

$bookingChecks = DB::table('bookings')->get();

foreach($bookingChecks as $singleBk){

if($singleBk->pudate == $srch_date && $singleBk->status=='1' && $singleBk->driver_id== $req->driverSel ){

return redirect()->back()->with('error','Driver is Not Available.');

}

if($singleBk->avai_id==$req->bookid){

return redirect()->back()->with('error','Already Booked. Nice Try!!');

}

if($user->role_id=='3') {

$data = DB::table('bookings')->insert([

'car_id'=> $req->car_id,

'customer_id'=> $user->id,

'avai_id'=>$req->bookid,

'driver_id'=> $req->driverSel,

'mobile' => $req->mobile,

'puloc' => $req->puloc,

'drloc' => $req->drloc,

'pudate' => $start_date ,

'putime' => $req->putime,

'personAd' => $req->personAd,

'personCh'=> $req->personCh,

'message' => $req->message,

'paymentMode' => $req->payment,

'total' => $car->price,

'status' => '2',

]);

$statusChange =availability::where('id',$req->bookid)->update(['available'=>'2']);

return redirect()->back()->with('success','Booking Set Successfully.');

}else{

return redirect('adlogin')->with('wrlgcr','You are not logged in, Login to Continue.');

}

}else{

return redirect('adlogin')->with('wrlgcr','You are not logged in, Login to Continue.');

}

// customer must login check

// check available function for register in DB

public function chck_avail(Request $req)

{

$user = user::where('id',session()->get('user_id') )->first();

if(isset($user)){

$srch_date = Carbon::parse($req->pudate)->format('Y-m-d'); //srch for available drivers

$bookingChecks = DB::table('bookings')->get();

foreach($bookingChecks as $singleBk){

if($singleBk->pudate == $srch_date && $singleBk->driver_id==$req->driverSel && $singleBk->status=='1'){

return redirect()->back()->with('error','Driver is Not Available.');

}

if(! isDriverLoc($req->driverSel, $req->puloc, $req->drloc)){

return redirect()->back()->with('error','Driver is Not Available for these Locations. Locations are: '.DriverLocas($req->driverSel));

}

if($user->role_id=='3') {

$pudate = Carbon::parse($req->pudate)->toDateTimeString();

$data =DB::table('availabilities')->insert([

'customer_id' => $user->id,

'car_id'=> $req->car_id,

'driver_id'=> $req->driverSel,

'puloc'=> $req->puloc,

'droploc' => $req->drloc,

'pudate'=> $pudate,

'putime'=> $req->putime,

'available'=> null,

'mail'=> '0',

]);

return redirect()->back()->with('success','Checking of Availability Set Successfully.');

}else{

return redirect('adlogin')->with('wrlgcr','You are not logged in, Login to Continue.');

}

}else{

return redirect('adlogin')->with('wrlgcr','You are not logged in, Login to Continue.');

}

// NOT USING FUNCTION

// search field function search method

// public function search_avail(Request $req)

// {

// $user = user::where('id',session()->get('user_id') )->first();

// if(isset($user)){

// $srch_date = Carbon::parse($req->pudate)->format('Y-m-d'); //srch for available drivers & cars

// $carIds = array();

// $bookingChecks = DB::table('bookings')->get();

// if(!isset($req->car_id)) {

// foreach($bookingChecks as $singleBk){

// if($singleBk->pudate == $srch_date && $singleBk->status=='1' ){

// array_push($carIds , $singleBk->car_id);

// } // 1, 7, 8 is booked drivers

// }

// }else{

// foreach($bookingChecks as $singleBk){

// if(($singleBk->pudate == $srch_date && $singleBk->status=='1' ) || ( $singleBk->car_id == $req->car_id ) ){

// array_push($carIds , $singleBk->car_id);

// } // 1, 7, 8 is booked drivers

// }

// $availCars = car::whereNotIn('id',$carIds)->get();

// $driverIds = array();

// $bookingChecks = DB::table('bookings')->get();

// if(!isset($req->driverSel)){

// foreach($bookingChecks as $singleBk){

// if($singleBk->pudate == $srch_date && $singleBk->status=='1' ){

// array_push($driverIds , $singleBk->driver_id);

// } // 1, 7, 8 is booked drivers

// }

// }else{

// foreach($bookingChecks as $singleBk){

// if( ($singleBk->pudate == $srch_date && $singleBk->status=='1') || ( $singleBk->driver_id == $req->driverSel)){

// array_push($driverIds , $singleBk->driver_id);

// } // 1, 7, 8 is booked drivers

// }

// $availDrivers = driver::whereNotIn('id',$driverIds)->get();

// $drivers = driver::all();

// $cars = car::all();

// $locations = DB::table('locations')->get();

// $page=pages::where('page','=','search')->first();

// return view('searchResults',['page'=>$page ,'cars'=>$cars, 'drivers' => $drivers,'locations'=>$locations, 'availCars'=> $availCars, 'availDrivers'=> $availDrivers,'req'=>$req]);

// }else{

// return redirect('adlogin')->with('wrlgcr','You are not logged in, Login to Continue.');

// }

// search for check available in royal car search button at top

function srchFromAvai(Request $req){

$user = user::where('id',session()->get('user_id') )->first();

if(isset($user)){

if(isset($req->drloc))

$drloc = [$req->drloc];

else

$drloc = location::select('id')->get();

if(isset($req->puloc))

$ploc = [$req->puloc];

else

$ploc = location::select('id')->get();

if(isset($req->car_id))

$car_id = [$req->car_id];

else

$car_id = car::select('id')->get();

if(isset($req->driverSel))

$d_id = [$req->driverSel];

else

$d_id = driver::select('id')->get();

if(isset($req->pudate)){

$srch_date = Carbon::parse($req->pudate)->format('Y-m-d');

$data= availability::where('customer_id',$user->id)->where('pudate',$srch_date)->whereIn('droploc',$drloc)->whereIn('puloc',$ploc)->whereIn('car_id',$car_id)->whereIn('driver_id',$d_id)->get();

}

else{

$mytime = Carbon::today();

$futureDate = Carbon::now();

$futureDate->addDays(60);

// dd($futureDate);

$data= availability::where('customer_id',$user->id)->whereIn('droploc',$drloc)->whereIn('puloc',$ploc)->whereIn('car_id',$car_id)->whereBetween('pudate',[$mytime->toDateTimeString(), $futureDate->toDateTimeString()])->whereIn('driver_id',$d_id)->get();

}

$drivers = driver::all();

$cars = car::all();

$locations = DB::table('locations')->get();

$page=pages::where('page','=','search')->first();

return view('avaiReqSrch',['page'=>$page ,'cars'=>$cars, 'drivers' => $drivers,'locations'=>$locations, 'req'=>$req, 'data'=>$data]);

}else{

return redirect('adlogin')->with('wrlgcr','You are not logged in, Login to Continue.');

}

customerController.blade.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\user;

use App\Models\pages;

use App\Models\Role;

use App\Models\enquiry;

use App\Models\car;

use App\Models\booking;

use App\Models\driver;

use App\Models\availability;

use App\Models\testimonial;

use Hash;

use Session;

use DB;

use App\Mail\adminMail;

use Illuminate\Support\Facades\Mail;

use Carbon\Carbon;

use Illuminate\Support\Facades\Auth;

class CustomerController extends Controller

{

public function chkRequests()

{

$user = user::where('email',session()->get('adeu')['email'] )->first();

$data = availability::select("*")->where('customer_id',$user->id)->paginate(5);

// dd($data);

return view('customer.chkRequest',['adeu' => $user, 'data'=>$data]);

}

// search field on Admin Show all available request list

// get method act as post

// Joining multiple table and check using where clause

public function RequestSrch_cs(Request $req){

$srch= $req->input('srch');

if(strtoupper($srch) == 'NO MAILS') {

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = availability::where('mail','0')->where('customer_id',$adfn->id)->get();

return view('customer.chkRequest',['adeu' => $adfn, 'data'=>$data,'srchbck'=>$srch]);

}else if(strtoupper($srch) == 'MAIL SENT'){

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = availability::where('mail','1')->where('customer_id',$adfn->id)->get();

return view('customer.chkRequest',['adeu' => $adfn, 'data'=>$data,'srchbck'=>$srch]);

}else if( strtoupper($srch) == 'NO RESPONSE'){

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = availability::where('available',null)->where('customer_id',$adfn->id)->get();

return view('customer.chkRequest',['adeu' => $adfn, 'data'=>$data,'srchbck'=>$srch]);

}else if( strtoupper($srch) == 'REJECTED'){

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = availability::where('available','0')->where('customer_id',$adfn->id)->get();

return view('customer.chkRequest',['adeu' => $adfn, 'data'=>$data,'srchbck'=>$srch]);

}

else if( strtoupper($srch) == 'AVAILABLE'){

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = availability::where('available','1')->where('customer_id',$adfn->id)->get();

return view('customer.chkRequest',['adeu' => $adfn, 'data'=>$data,'srchbck'=>$srch]);

}

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data= availability::join('drivers','drivers.id', '=', 'availabilities.driver_id')

->join('cars', 'cars.id', '=', 'availabilities.car_id')

->join('locations', 'locations.id', '=', 'availabilities.puloc')

->join('locations as l2', 'l2.id', '=', 'availabilities.droploc')

->join('users', 'users.id', '=', 'availabilities.customer_id')

->where('drivers.name','LIKE', '%'.$srch.'%')

->orWhere('cars.name', 'LIKE','%'.$srch.'%')

->orWhere('cars.brand', 'LIKE','%'.$srch.'%')

->orWhere('locations.area', 'LIKE','%'.$srch.'%')

->orWhere('availabilities.pudate', 'LIKE','%'.$srch.'%')

->orWhere('availabilities.putime', 'LIKE','%'.$srch.'%')

// ->orWhere('users.name', 'LIKE','%'.$srch.'%')

->orWhere('l2.area', 'LIKE','%'.$srch.'%')

->get();

// dd( $data);

return view('customer.chkRequest',['adeu' => $adfn, 'data'=>$data,'srchbck'=>$srch]);

}

// date wise availability search

public function avai_date_srch_cs(Request $req)

{

$start_date = Carbon::parse($req->start_date)->toDateTimeString();

$end_date = Carbon::parse($req->end_date)->toDateTimeString();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = availability::whereBetween('pudate', [$start_date, $end_date])->where('customer_id',$adfn->id)->get();

return view('customer.chkRequest',['data'=>$data,'adeu' => $adfn, 'req'=>$req]);

}

// chkBooking blade view page fetch

// Booking page view fun

public function chkBooking()

{

// dd('admin booking page');

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

// dd($adfn) ;

$data = booking::where('customer_id',$adfn->id)->paginate(5);

return view('customer.chkBooking',['adeu' => $adfn, 'data'=>$data]);

}

// taking input field booking search

public function BookingSrch_cs(Request $req){

$srch= $req->input('srch');

if( strtoupper($srch) == 'NO RESPONSE'){

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = booking::where('status','2')->where('customer_id',$adfn->id)->get();

return view('customer.chkBooking',['adeu' => $adfn, 'data'=>$data, 'srchbck'=>$srch]);

}else if( strtoupper($srch) == 'BOOKING CANCLE'){

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = booking::where('status','0')->where('customer_id',$adfn->id)->get();

return view('customer.chkBooking',['adeu' => $adfn, 'data'=>$data, 'srchbck'=>$srch]);

}

else if( strtoupper($srch) == 'BOOKING CONFIRM'){

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = booking::where('status','1')->where('customer_id',$adfn->id)->get();

return view('customer.chkBooking',['adeu' => $adfn, 'data'=>$data, 'srchbck'=>$srch]);

}

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data= booking::join('drivers','drivers.id', '=', 'bookings.driver_id')

->join('cars', 'cars.id', '=', 'bookings.car_id')

->join('locations', 'locations.id', '=', 'bookings.puloc')

->join('locations as l2', 'l2.id', '=', 'bookings.drloc')

->join('users', 'users.id', '=', 'bookings.customer_id')

->where('drivers.name','LIKE', '%'.$srch.'%')

->orWhere('cars.name', 'LIKE','%'.$srch.'%')

->orWhere('cars.brand', 'LIKE','%'.$srch.'%')

->orWhere('locations.area', 'LIKE','%'.$srch.'%')

->orWhere('bookings.pudate', 'LIKE','%'.$srch.'%')

->orWhere('bookings.mobile', 'LIKE','%'.$srch.'%')

->orWhere('bookings.putime', 'LIKE','%'.$srch.'%')

->orWhere('l2.area', 'LIKE','%'.$srch.'%')

->get();

// dd( $data);

// dd('ok');

return view('customer.chkBooking',['adeu' => $adfn, 'data'=>$data,'srchbck'=>$srch]);

}

// date wise booking search

public function bkk_date_srch_cs(Request $req)

{

$start_date = Carbon::parse($req->start_date)->toDateTimeString();

$end_date = Carbon::parse($req->end_date)->toDateTimeString();

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = booking::whereBetween('pudate', [$start_date, $end_date])->where('customer_id',$adfn->id)->get();

return view('customer.chkBooking',['data'=>$data,'adeu' => $adfn, 'req'=>$req]);

}

# Customer check ride status on idwise here

public function myTrip($id)

{

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data=booking::where('avai_id',$id)->first();

$driverData = driver::where('id',$data->driver_id)->first();

return view('customer.myTrip',['item'=>$data,'adeu' => $adfn, 'driverData'=>$driverData]);

}

public function myTrip2($id)

{

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data=booking::where('id',$id)->first();

// dd($data) ;

$driverData = driver::where('id',$data->driver_id)->first();

return view('customer.myTrip',['item'=>$data,'adeu' => $adfn, 'driverData'=>$driverData]);

}

# Customer add testimonial when

public function addTesti($id)

{

$adfn = user::where('email',session()->get('adeu')['email'] )->first();

$data = booking::where('id',$id)->first();

return view('customer.fdFormSubmit',['adeu' => $adfn, 'item'=>$data]);

}

public function submitTesti(Request $req)

{

$testiData= DB::table('testimonials')->get();

foreach($testiData as $data){

if($req->bkk_id == $data->book_id)

{

return "<script>window.close();</script>";

}

$data = booking::where('id',$req->bkk_id)->first();

$testimonial = DB::table('testimonials')->insert(['book_id'=>$req->bkk_id,'message'=>$req->message,'rating'=>$req->rating,'status'=>'1']);

return "<script>window.close();</script>";

}

Driver.blade.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Notification;

use Carbon\Carbon;

use DB;

use App\Notifications\SendEmailNotification;

use Illuminate\Support\Facades\Mail;

use App\Mail\clMail;

use App\Mail\adminMail;

use App\Mail\FeedbackMail;

use App\Models\booking;

use App\Models\enquiry;

use App\Models\driver;

use App\Models\pages;

use App\Models\Car;

use App\Models\user;

use App\Models\Role;

use App\Models\availability;

use App\Models\location;

use Hash;

use Session;

use Illuminate\Support\Facades\Auth;

class DriverController extends Controller

{

# driver homepage view blade

public function driver_portal(){

$cars = car::all();

$customers = user::where('role_id','3')->get();

$locations = DB::table('locations')->get();

return view('driver.driver_portal',[ 'customers' => $customers, 'cars' => $cars, 'locations'=>$locations ]);

}

#Search for customer booking related data

public function SrchCustmrasDriver(Request $req)

{

$user = driver::where('id',session()->get('driver_id') )->first();

if(isset($user)){

if(isset($req->drloc))

$drloc = [$req->drloc];

else

$drloc = location::select('id')->get();

if(isset($req->puloc))

$ploc = [$req->puloc];

else

$ploc = location::select('id')->get();

if(isset($req->car_id))

$car_id = [$req->car_id];

else

$car_id = car::select('id')->get();

if(isset($req->customerSel))

$c_id = [$req->customerSel];

else

$c_id = user::select('id')->where('role_id','3')->get();

if(isset($req->pudate)){

$srch_date = Carbon::parse($req->pudate)->format('Y-m-d');

$data= booking::where('driver_id',$user->id)->where('pudate',$srch_date)->whereIn('drloc',$drloc)->whereIn('puloc',$ploc)->whereIn('car_id',$car_id)->whereIn('customer_id',$c_id)->get();

}

else{

$mytime = Carbon::today();

$futureDate = Carbon::now();

$futureDate->addDays(60);

$data= booking::where('driver_id',$user->id)->whereIn('drloc',$drloc)->whereIn('puloc',$ploc)->whereIn('car_id',$car_id)->whereBetween('pudate',[$mytime->toDateTimeString(), $futureDate->toDateTimeString()])->whereIn('customer_id',$c_id)->get();

}

$cars = car::all();

$customers = user::where('role_id','3')->get();

$locations = DB::table('locations')->get();

return view('driver.search_bkkngs',['customers' => $customers, 'cars'=>$cars, 'locations'=>$locations, 'req'=>$req, 'data'=>$data]);

}else{

return redirect('driverLogin')->with('error','You are not logged in, Login to Continue.');

}

# register page blade

public function driverRegister(Request $req)

{

return view('driver.driverRegister');

}

#register form submit

public function driver_reg(Request $req)

{

$req->validate([

'name' => 'required',

'email' => 'required|email|unique:drivers',

'password' => 'required',

'phone' => 'required',

'address' => 'required',

'licenceNo' => 'required',

'carNo' => 'required',

'experience' => 'required',

'adimg' => 'required|image|mimes:jpg,jpeg,png'

]);

$file_type = $req->file('adimg')->extension(); // image

$file_path = $req->file('adimg')->storeAs('admin/images/driver', time() . '.' . $file_type, 'public');

$req->file('adimg')->move(public_path('admin/images/driver'), time() . '.' . $file_type);

DB::table('drivers')->insert([

'name' => $req->name,

'email' => $req->email,

'password' => Hash::make($req->password),

'phone' => $req->phone,

'address' => $req->address,

'licenceNo' => $req->licenceNo,

'carNo' => $req->carNo,

'experience' => $req->experience,

'image' => $file_path,

'salary' => '18000',

]);

Session::flash('status', "Successfully Registered");

return redirect('driver');

}

# login blade

public function driverLogin()

{

return view('driver.login');

}

# login action

public function driver_login(Request $req)

{

$req->validate([

'email' => 'required',

'password' => 'required',

]);

$driver = driver::where('email',$req->email)->first();

$drivercnt = driver::where('email',$req->email)->count();

if($drivercnt > 0){

if($driver->active){

if(Hash::check($req->password, $driver->password )){

$req->session()->put('driver',$driver);

$req->session()->put('driver_id',$driver->id);

// Auth::login($driver);

return redirect('driver')->with('status',' Login Successfully. ');

}else{

return redirect()->back()->with('error','Username or Password does not match');

}

}else{

return redirect()->back()->with('error','You are blocked.');

}

}else{

return redirect()->back()->with('error','Username or Password does not match');

}

// on Request table page view blade get

public function onRequest()

{

$id= session()->get('driver_id');

$data = driver::where('id',$id)->first();

$onReq = availability::where('driver_id',$id)->get();

$cars = car::all();

$customers = user::where('role_id','3')->get();

$locations = DB::table('locations')->get();

return view('driver.onRequest',[ 'customers' => $customers, 'cars' => $cars, 'locations'=>$locations, 'data'=>$data, 'onReq'=>$onReq ]);

// return view('driver.onRequest',['data'=>$data, 'onReq'=>$onReq]);

}

// Driver change availability

public function dvr_availunavail($id, $status)

{

$onReq = availability::where('id',$id)->get();

if($status=='true'){

$c=1;

}else if($status=='false'){

$c=0;

}else{

$c=null;

}

$pg = DB::table('availabilities')

->where('id', $id)

->update(['available' =>$c ]);

return redirect()->back()->with('status',' Availability Changing Successfully');

}

// driver available mail sending id-> $req->a_id

public function dvr_rply(Request $req)

{

$enrr = availability::find($req->a_id);

$cust = user::find($enrr->customer_id);

$car = car::find($enrr->car_id);

$driver = driver::find($enrr->driver_id);

$puloc = location::find( $enrr->puloc);

$droploc = location::find( $enrr->droploc);

$message = 'Hello '.$cust->name.', '.PHP_EOL.'Car Name: '.$car->name.PHP_EOL.'Car Brand: '.$car->brand.PHP_EOL.'At Price: '.$car->price.PHP_EOL.'Pickup Location: '.$puloc->area.PHP_EOL.'Drop Location: '.$droploc->area.PHP_EOL.'Pickup Date: '.$enrr->pudate.PHP_EOL.'Pickup Time: '.$enrr->putime.PHP_EOL.'Driver Name: '.$driver->name.PHP_EOL.PHP_EOL.'Thank you, Visit Again. ';

$adminmail=[

'name'=> $cust->name,

'email'=> $cust->email,

'subject'=> 'Car Available at '.$puloc->area.' Date: '.$enrr->pudate,

'message'=> $message,

];

Mail::to($cust->email)->send(new adminMail($adminmail));

DB::table('availabilities')->where('id',$req->a_id)->update(['mail' => '1']);

return view('admin.mailreply',['AdminReply'=>$adminmail]);

}

# Driver blade view

public function driverAccount()

{

$id= session()->get('driver_id');

$data = driver::where('id',$id)->first();

return view('driver.account',['data'=>$data]);

}

// driver_update

public function driver_update(Request $req)

{

$req->validate([

'name' => 'required',

'email' => 'required|email|unique:drivers,email,'.$req->adid,

'phone' => 'required',

'address' => 'required',

'licenceNo' => 'required',

'carNo' => 'required',

'experience' => 'required',

'adimg' => 'image|mimes:jpg,jpeg,png'

]);

if ($req->hasFile('adimg')) {

if($req->adimg !='' )

unlink($req->old_img);

$file_type = $req->file('adimg')->extension();

$file_path = $req->file('adimg')->storeAs('admin/images/driver', time() . '.' . $file_type, 'public');

$req->file('adimg')->move(public_path('admin/images/driver'), time() . '.' . $file_type);

}else{

$file_path=$req->old_img;

}

$adur = DB::table('drivers')

->where('id', $req->adid)

->update([

'name' => $req->name,

'email' => $req->email,

'phone' => $req->phone,

'address' => $req->address,

'licenceNo' => $req->licenceNo,

'carNo' => $req->carNo,

'experience' => $req->experience,

'image' => $file_path,

]);

Session::flash('status', "Records Updated Successfully");

return redirect('driver');

}

// driver Password view blade load

public function driverPassword()

{

$id= session()->get('driver_id');

$data = driver::where('id',$id)->first();

return view('driver.pswdchng',['data'=>$data]);

}

// driver Logout

public function driverLogout()

{

if(session()->has('driver_id')){

session()->forget('driver_id');

}

return redirect('driver');

}

// password change

function driver_Pass_Chng(Request $req){

$id= session()->get('driver_id');

$data = driver::where('id',$id)->first();

$datacnt = driver::where('id',$id)->count();

if($datacnt > 0){

if(Hash::check($req->op, $data->password )){

if($req->op != $req->np){

if($req->np == $req->cp){

$adur = DB::table('drivers')

->where('id', $id)

->update([

'password' => Hash::make($req->np),

]);

Session::flash('status', "Password Updated Successfully");

return redirect('driver');

}else{

return redirect()->back()->with('error','** New Password and Confirm Password does not match');

}

}else{

return redirect()->back()->with('error','** Old Password and New Password are Same.');

}

}else{

return redirect()->back()->with('error','** Old Password and Database Password does not match');

}

}else{

return redirect()->back()->with('error','** Invalid User');

}

// booking table driver view page

function bookings(){

$id= session()->get('driver_id');

$data = driver::where('id',$id)->first();

$onReq = booking::where('driver_id',$id)->get();

return view('driver.onBooking',['data'=>$data, 'onReq'=>$onReq]);

}

// Driver booking Confirm

public function bookingConfirm($id, $status)

{

$bookReq = booking::where('id',$id)->first();

$Did= session()->get('driver_id');

$onReq = availability::where('pudate',$bookReq->pudate)->get(); // dd($bookReq); // dd($bookReq->pudate); dd($onReq);

if($status=='true'){

$c=1;

if(count($onReq)>0){

$upAv = DB::table('availabilities')

->where('driver_id', $Did)

->where('pudate',$bookReq->pudate)

->where('id',$bookReq->avai_id)

->update(['available' => '3' ]);

$upAv = DB::table('availabilities')

->where('driver_id', $Did)

->where('pudate',$bookReq->pudate)

->whereNotIn('id',[$bookReq->avai_id])

->where('available',null)

->update(['available' => '5' ]);

$upAv = DB::table('availabilities')

->where('driver_id', $Did)

->where('pudate',$bookReq->pudate)

->whereNotIn('id',[$bookReq->avai_id])

->whereIn('available',['1','2'])

->update(['available' => '0' ]);

}

$othrOnDateBookingDisabled = booking::whereNotIn('id',[$id])->where('pudate',$bookReq->pudate)->where('driver_id', $Did)->update(['status' => '0' ]);

}else if($status=='false'){

$c=0;

}else{

$c=2;

if(count($onReq)>0){

$upAv = DB::table('availabilities')

->where('driver_id', $Did)

->where('pudate',$bookReq->pudate)

->where('id',$bookReq->avai_id)

->update(['available' => '1' ]);

$upAv = DB::table('availabilities')

->where('driver_id', $Did)

->where('pudate',$bookReq->pudate)

->whereNotIn('id',[$bookReq->avai_id])

->where('available','5')

->update(['available' => null ]);

$upAv = DB::table('availabilities')

->where('driver_id', $Did)

->where('pudate',$bookReq->pudate)

->where('available','0')

->update(['available' => '1' ]);

}

$othrOnDateBookingDisabled = booking::whereNotIn('id',[$id])->where('pudate',$bookReq->pudate)->where('driver_id', $Did)->update(['status' => '2' ]);

}

$pg = DB::table('bookings')

->where('id', $id)

->update(['status' =>$c ]);

return redirect('bookings')->with('status',' Availability Changing Successfully');

}

# driver earnings blade

public function earnings()

{

$data = booking::where('status','1')->orderBy('pudate', 'DESC')->get();

return view('driver.earnings',['onReq'=>$data]);

}

public function regTrips($id,$status)

{

if($status=='start'){

booking::where('id',$id)->update(['bookStatus'=>'0']);

}

else if($status=='arrive'){

booking::where('id',$id)->update(['bookStatus'=>'1']);

}

else if($status=='pickup'){

booking::where('id',$id)->update(['bookStatus'=>'2']);

}

else if($status=='drop'){

booking::where('id',$id)->update(['bookStatus'=>'3']);

}

else if($status=='paySuccess'){

booking::where('id',$id)->update(['bookStatus'=>'4']);

}

else if($status=='payDue'){

booking::where('id',$id)->update(['bookStatus'=>'5']);

}

else if($status=='sos'){

booking::where('id',$id)->update(['bookStatus'=>'6']);

}

return redirect()->back()->with('status','Driver Trip Updated');

}

public function viewTrip($id)

{

$data = booking::where('id',$id)->first();

return view('driver.viewTrip',['item'=>$data]);

}

// driver send feedback mail

public function feedbackMailSend($id)

{

$enrr = booking::where('id',$id)->first();

$customer = DB::table('users')->where('id',$enrr->customer_id)->first();

Mail::to($customer->email)->send(new FeedbackMail($id));

return redirect()->back();

}

Search This Blog

FULL STACK DEV

[[ ROYAL CAR ]] CHANGE PASSWORD - DYNAMIC BANNER - MULTIPLE IMAGE - LOGIN LOGOUT BACK BUTTON MIDDLEWARE STOP - MAIL DIRECTLY WITH FEEDBACK WITH SAVE IN SQL DB - ADMIN REPLY EXISTING MAILS - DYNAMICALLY CSS CHANGE

Comments

Post a Comment

Popular posts from this blog

Sahari

Linux Terminal