File: //var/www/html/punjabcabs/app/Http/Controllers/Resource/ProviderFleetResource.php
<?php
namespace App\Http\Controllers\Resource;
use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use Illuminate\Database\Eloquent\ModelNotFoundException;
use DB;
use Exception;
use Auth;
use \Carbon\Carbon;
use App\Provider;
use App\UserRequests;
use App\UserRequestPayment;
use App\Helpers\Helper;
use App\ProviderApplication;
class ProviderFleetResource extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$providers = Provider::with('service','totalrequest','accepted','cancelled')
->where('fleet', Auth::user()->id )
->orderBy('id', 'DESC')
->get();
return view('fleet.providers.index', compact('providers'));
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
return view('fleet.providers.create');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$this->validate($request, [
'first_name' => 'required|max:255',
'last_name' => 'required|max:255',
'email' => 'required|unique:providers,email|email|max:255',
'mobile' => 'digits_between:6,13',
'avatar' => 'mimes:jpeg,jpg,bmp,png|max:5242880',
'password' => 'required|min:6|confirmed',
]);
try{
$provider = $request->all();
$provider['password'] = bcrypt($request->password);
$provider['fleet'] = Auth::user()->id;
if($request->hasFile('avatar')) {
$provider['avatar'] = $request->avatar->store('provider/profile');
}
$provider = Provider::create($provider);
return back()->with('flash_success','Provider Details Saved Successfully');
}
catch (Exception $e) {
return back()->with('flash_error', 'Provider Not Found');
}
}
/**
* Display the specified resource.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function show($id)
{
try {
$provider = Provider::findOrFail($id);
return view('fleet.providers.provider-details', compact('provider'));
} catch (ModelNotFoundException $e) {
return $e;
}
}
/**
* Show the form for editing the specified resource.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
try {
$provider = Provider::findOrFail($id);
return view('fleet.providers.edit',compact('provider'));
} catch (ModelNotFoundException $e) {
return $e;
}
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$this->validate($request, [
'first_name' => 'required|max:255',
'last_name' => 'required|max:255',
'mobile' => 'digits_between:6,13',
'avatar' => 'mimes:jpeg,jpg,bmp,png|max:5242880',
]);
try {
$provider = Provider::findOrFail($id);
if($request->hasFile('avatar')) {
if($provider->avatar) {
Storage::delete($provider->avatar);
}
$provider->avatar = $request->avatar->store('provider/profile');
}
$provider->first_name = $request->first_name;
$provider->last_name = $request->last_name;
$provider->mobile = $request->mobile;
$provider->save();
return redirect()->route('fleet.provider.index')->with('flash_success', 'Provider Updated Successfully');
}
catch (ModelNotFoundException $e) {
return back()->with('flash_error', 'Provider Not Found');
}
}
/**
* Remove the specified resource from storage.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
try {
Provider::find($id)->delete();
return back()->with('message', 'Provider deleted successfully');
}
catch (Exception $e) {
return back()->with('flash_error', 'Provider Not Found');
}
}
/**
* Remove the specified resource from storage.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function approve($id)
{
try {
$Provider = Provider::findOrFail($id);
if($Provider->service) {
if($Provider->service->license_status ==2){
return redirect()->route('fleet.provider.document.index', $id)->with('flash_error', "Driver License certificate Expired");
}
if($Provider->service->insurance_status ==2){
return redirect()->route('fleet.provider.document.index', $id)->with('flash_error', "Driver Insurance certificate Expired");
}
$Provider->update(['status' => 'approved']);
return back()->with('flash_success', "Provider Approved");
} else {
return redirect()->route('fleet.provider.document.index', $id)->with('flash_error', "Provider has not been assigned a service type!");
}
} catch (ModelNotFoundException $e) {
return back()->with('flash_error', "Something went wrong! Please try again later.");
}
}
/**
* Remove the specified resource from storage.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function disapprove($id)
{
Provider::where('id',$id)->update(['status' => 'banned']);
return back()->with('flash_success', "Provider Disapproved");
}
/**
* Remove the specified resource from storage.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function request($id){
try{
$requests = UserRequests::where('user_requests.provider_id',$id)
->RequestHistory()
->get();
$provider_id = $id;
return view('fleet.request.index', compact('requests','provider_id'));
} catch (Exception $e) {
return back()->with('flash_error','Something Went Wrong!');
}
}
/**
* account statements.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function statement($id){
try{
$Provider = Provider::find($id);
$revenue = UserRequestPayment::whereHas('request', function($query) use($id) {
$query->where('provider_id', $id );
})->select(\DB::raw(
'SUM(ROUND(fixed) + ROUND(distance)) as overall, SUM(ROUND(commision)) as commission'
))->get();
$Provider = Provider::find($id);
$providerid = $id;
$Joined = $Provider->created_at ? '- Joined '.$Provider->created_at->diffForHumans() : '';
$page = $Provider->first_name."'s Overall Statement ". $Joined;
return view('fleet.providers.provider-content', compact('page','providerid'));
} catch (Exception $e) {
return back()->with('flash_error','Something Went Wrong!');
}
}
/**
* provider base statements rows.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function fleet_content(Request $request){
$columns = array(
0 =>'id',
1 =>'booking_id',
2=> 's_address',
3=> 'd_address',
4=> 'detail',
5=> 'created_at',
6=> 'status',
7=> 'payment_mode',
8=> 'total',
9=> 'commission',
10=> 'earned',
);
$fromdate = '';
$todate = Carbon::now();
$payment_type ='';
$tripstatus ='';
$id = $request->providerid;
if($request->fromdate !=''){
$fromdate = Helper::date_formatter($request->fromdate);
}
if($request->todate !=''){
$todate = Helper::date_formatter($request->todate);
}
if($request->has('payment')){
$payment_type = $request->payment;
}
if($request->has('tripstatus')){
$tripstatus = $request->tripstatus;
}
$main_detail = UserRequests::with('payment')
->where('provider_id',$id)
->where('created_at', '>=', $fromdate)
->where('created_at', '<', $todate)
->where('status', 'LIKE', '%'.$tripstatus.'%')
->where('payment_mode','LIKE', '%'.$payment_type.'%');
$cancel_rides = UserRequests::where('status','CANCELLED')
->where('provider_id',$id)
->where('created_at', '>=', $fromdate)
->where('created_at', '<', $todate)
->where('status', 'LIKE', '%'.$tripstatus.'%')
->where('payment_mode','LIKE', '%'.$payment_type.'%');
$revenue = UserRequestPayment::whereHas('request', function($query) use($id) {
$query->where('provider_id', $id );
})->select(\DB::raw(
'SUM(total) as overall, SUM(commision) as commission'
))->where('created_at', '>=', $fromdate)
->where('created_at', '<', $todate)->get();
$total_cancel = $cancel_rides->count();
$total_revenue = currency($revenue[0]->overall);
$total_commission = currency($revenue[0]->commission);
$totalData = $main_detail->count();
$totalFiltered = $totalData;
$limit = $request->input('length');
$start = $request->input('start');
$order = $columns[$request->input('order.0.column')];
$dir = $request->input('order.0.dir');
if(empty($request->input('search.value')))
{
$rides = $main_detail
->offset($start)
->limit($limit)
->orderBy('id','desc')
->get();
}
else {
$search = $request->input('search.value');
$rides = $main_detail
->where('booking_id','LIKE',"%{$search}%")
->orWhere('s_address', 'LIKE',"%{$search}%")
->orWhere('d_address', 'LIKE',"%{$search}%")
->orWhere('created_at', 'LIKE',"%{$search}%")
->offset($start)
->limit($limit)
->orderBy('id','desc')
->get();
$totalFiltered = $main_detail
->where('booking_id','LIKE',"%{$search}%")
->orWhere('s_address', 'LIKE',"%{$search}%")
->orWhere('d_address', 'LIKE',"%{$search}%")
->orWhere('created_at', 'LIKE',"%{$search}%")
->count();
}
$data = array();
if(!empty($rides))
{
foreach ($rides as $index => $ride)
{
$view = route('fleet.requests.show',$ride->id);
if($ride->s_address != ''){ $s_address = $ride->s_address;}else{$s_address = "Not Provided";}
if($ride->d_address != ''){ $d_address = $ride->d_address;}else{$d_address = "Not Provided";}
if($ride->status != 'CANCELLED'){ $detail = '<a class="text-primary" href="'.$view.'"><div class="label label-table label-info">'.trans("admin.member.view").'</div></a>'; }else{$detail= '<span>'.trans("admin.member.no_details_found").'</span>'; }
if($ride->status == "COMPLETED"){$status = '<span class="label label-table label-success">'.$ride->status.'</span>';}
elseif($ride->status == "CANCELLED"){$status = '<span class="label label-table label-danger">'.$ride->status.'</span>';}
else{$status = '<span class="label label-table label-primary">'.$ride->status.'</span>';}
$nestedData['id'] = $start + 1;
$nestedData['booking_id'] = $ride->booking_id;
$nestedData['s_address'] = $s_address;
$nestedData['d_address'] = $d_address;
$nestedData['detail'] = $detail;
$nestedData['created_at'] = date('d-m-Y',strtotime($ride->created_at));
$nestedData['status'] = $status;
$nestedData['payment_mode'] = $ride->payment_mode;
$nestedData['total'] = currency($ride->payment['total']);
$nestedData['commission'] = currency($ride->payment['commision']);
$nestedData['earned'] = currency($ride->payment['total'] - $ride->payment['commision']);
$data[] = $nestedData;
$start++;
}
}
$percentage = 0.00;
if($total_cancel != 0){
$percentage = round($total_cancel / $totalFiltered, 2);
}
$json_data = array(
"draw" => intval($request->input('draw')),
"recordsTotal" => intval($totalData),
"recordsFiltered" => intval($totalFiltered),
"data" => $data,
"cancel_rides" => $total_cancel,
"revenue" => $total_revenue,
"commission" => $total_commission,
"percentage" => $percentage
);
echo json_encode($json_data);
}
/**
* Remove the specified resource from storage.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function application($id){
try{
$Provider = Provider::findOrFail($id);
$ProviderApplication = ProviderApplication::where('provider_id',$id)->first();
return view('fleet.providers.document.application', compact('Provider', 'ProviderApplication'));
} catch (Exception $e) {
return back()->with('flash_error','Something Went Wrong!');
}
}
}