File: //var/www/html/punjabcabs/Original_Backup/app/Http/Controllers/FleetController.php
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Helpers\Helper;
use Auth;
use Setting;
use Exception;
use \Carbon\Carbon;
use DB;
use App\User;
use App\Fleet;
use App\Provider;
use App\UserPayment;
use App\ServiceType;
use App\UserRequests;
use App\ProviderService;
use App\UserRequestRating;
use App\UserRequestPayment;
class FleetController extends Controller
{
/**
* Create a new controller instance.
*
* @return void
*/
public function __construct()
{
$this->middleware('fleet');
}
/**
* Dashboard.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function dashboard()
{
try{
$getting_ride = UserRequests::has('user')
->whereHas('provider', function($query) {
$query->where('fleet', Auth::user()->id );
})
->orderBy('id','desc');
$rides = $getting_ride->get();
$all_rides = $getting_ride->get()->pluck('id');
$cancel_rides = UserRequests::where('status','CANCELLED')
->whereHas('provider', function($query) {
$query->where('fleet', Auth::user()->id );
})->count();
$service = ServiceType::count();
$revenue = UserRequestPayment::whereIn('request_id',$all_rides)->sum('total');
$providers = Provider::where('fleet', Auth::user()->id)->take(10)->orderBy('rating','desc')->get();
return view('fleet.dashboard',compact('providers','service','rides','cancel_rides','revenue'));
}
catch(Exception $e){
return redirect()->route('fleet.user.index')->with('flash_error','Something Went Wrong with Dashboard!');
}
}
/**
* Map of all Users and Drivers.
*
* @return \Illuminate\Http\Response
*/
public function map_index()
{
return view('fleet.map.index');
}
/**
* Map of all Users and Drivers.
*
* @return \Illuminate\Http\Response
*/
public function map_ajax()
{
try {
$Providers = Provider::where('latitude', '!=', 0)
->where('longitude', '!=', 0)
->where('fleet', Auth::user()->id)
->with('service')
->get();
$Users = User::where('latitude', '!=', 0)
->where('longitude', '!=', 0)
->get();
for ($i=0; $i < sizeof($Users); $i++) {
$Users[$i]->status = 'user';
}
$All = $Users->merge($Providers);
return $All;
} catch (Exception $e) {
return [];
}
}
/**
* Remove the specified resource from storage.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function profile()
{
return view('fleet.account.profile');
}
/**
* Remove the specified resource from storage.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function profile_update(Request $request)
{
$this->validate($request,[
'name' => 'required|max:255',
'company' => 'required|max:255',
'mobile' => 'required|digits_between:6,13',
'logo' => 'mimes:jpeg,jpg,bmp,png|max:5242880',
]);
try{
$fleet = Auth::guard('fleet')->user();
$fleet->name = $request->name;
$fleet->mobile = $request->mobile;
$fleet->company = $request->company;
if($request->hasFile('logo')){
$fleet->logo = $request->logo->store('fleet/profile');
}
$fleet->save();
return redirect()->back()->with('flash_success','Profile Updated');
}
catch (Exception $e) {
return back()->with('flash_error','Something Went Wrong!');
}
}
/**
* Remove the specified resource from storage.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function password()
{
return view('fleet.account.change-password');
}
/**
* Remove the specified resource from storage.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function password_update(Request $request)
{
$this->validate($request,[
'old_password' => 'required',
'password' => 'required|min:6|confirmed',
]);
try {
$Fleet = Fleet::find(Auth::guard('fleet')->user()->id);
if(password_verify($request->old_password, $Fleet->password))
{
$Fleet->password = bcrypt($request->password);
$Fleet->save();
return redirect()->back()->with('flash_success','Password Updated');
} else {
return back()->with('flash_error','Password entered doesn\'t match');
}
} catch (Exception $e) {
return back()->with('flash_error','Something Went Wrong!');
}
}
/**
* Provider Rating.
*
* @return \Illuminate\Http\Response
*/
public function provider_review()
{
try {
$rides = UserRequests::whereHas('provider', function($query) {
$query->where('fleet', Auth::user()->id );
})->get()->pluck('id');
$Reviews = UserRequestRating::whereIn('request_id',$rides)
->where('provider_id','!=',0)
->with('user','provider')
->get();
return view('fleet.review.provider_review',compact('Reviews'));
} catch(Exception $e) {
return back()->with('flash_error','Something Went Wrong!');
}
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function fleetreviewprovider_row(Request $request){
$columns = array(
0 =>'id',
1 =>'request_id',
2=> 'user_name',
3=> 'provider_name',
4=> 'rating',
5=> 'date_time',
6=> 'comments',
);
$rides = UserRequests::whereHas('provider', function($query) {
$query->where('fleet', Auth::user()->id );
})->get()->pluck('id');
$provider_review = UserRequestRating::whereIn('request_id',$rides)
->where('provider_id','!=', 0)
->with('user','provider');
$totalData = $provider_review->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')))
{
$Reviews = $provider_review->offset($start)
->limit($limit)
->orderBy('id','desc')
->get();
}
else {
$search = $request->input('search.value');
$Reviews = $provider_review->where('request_id','LIKE',"%{$search}%")
->offset($start)
->limit($limit)
->orderBy('id','desc')
->get();
$totalFiltered = $provider_review->where('request_id','LIKE',"%{$search}%")
->count();
}
$data = array();
if(!empty($Reviews))
{
foreach ($Reviews as $index => $review)
{
if($review->user){
if($review->user->first_name != ''){ $first_name = $review->user->first_name;}else{$first_name = "";}
if($review->user->last_name != ''){ $last_name = $review->user->last_name;}else{$last_name = "";}
}else{
$first_name ='Not Found';
$last_name ='Not Found';
}
if($review->provider){
if($review->provider->first_name != ''){ $provider_first_name = $review->provider->first_name;}else{$provider_first_name = "";}
if($review->provider->last_name != ''){ $provider_last_name = $review->provider->last_name;}else{$provider_last_name = "";}
}else{
$provider_first_name = 'Not Found';
$provider_last_name = 'Not Found';
}
$rating = '<div className="rating-outer">
<input type="hidden" value="'.$review->provider_rating.'" name="rating" class="rating"/>
</div>';
$user_name = $first_name.' '.$last_name;
$provider_name = $provider_first_name.' '.$provider_last_name;
$nestedData['id'] = $start + 1;
$nestedData['request_id'] = $review->request_id;
$nestedData['user_name'] = $user_name;
$nestedData['provider_name'] = $provider_name;
$nestedData['rating'] = $rating;
$nestedData['date_time'] = datetime_formatter($review->created_at);
$nestedData['comments'] = $review->provider_comment;
$data[] = $nestedData;
$start++;
}
}
$json_data = array(
"draw" => intval($request->input('draw')),
"recordsTotal" => intval($totalData),
"recordsFiltered" => intval($totalFiltered),
"data" => $data
);
echo json_encode($json_data);
}
/**
* Remove the specified resource from storage.
*
* @param \App\ProviderService
* @return \Illuminate\Http\Response
*/
public function destory_provider_service($id){
try {
ProviderService::find($id)->delete();
return back()->with('message', 'Service deleted successfully');
} catch (Exception $e) {
return back()->with('flash_error','Something Went Wrong!');
}
}
/**
* account statements.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function statement($type = 'individual'){
try{
$page = 'Ride Statement';
if($type == 'individual'){
$page = 'Provider Ride Statement';
}elseif($type == 'today'){
$page = 'Today Statement - '. date('d M Y');
}elseif($type == 'monthly'){
$page = 'This Month Statement - '. date('F');
}elseif($type == 'yearly'){
$page = 'This Year Statement - '. date('Y');
}
$type_data = $type;
return view('fleet.providers.statement', compact('page','type_data'));
} catch (Exception $e) {
return back()->with('flash_error','Something Went Wrong!');
}
}
public function statement_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 ='';
if($request->type_data !=''){
$type = $request->type_data;
if($type == 'today'){ $fromdate = Carbon::today(); }
if($type == 'monthly'){ $fromdate = Carbon::now()->startOfMonth(); }
if($type == 'yearly'){ $fromdate = Carbon::now()->year; }
}
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('created_at', '>=', $fromdate)
->where('created_at', '<', $todate)
->where('status', 'LIKE', '%'.$tripstatus.'%')
->where('payment_mode','LIKE', '%'.$payment_type.'%')
->whereHas('provider', function($query) {
$query->where('fleet', Auth::user()->id );
});
$cancel_rides = UserRequests::where('status','CANCELLED')
->where('created_at', '>=', $fromdate)
->where('created_at', '<', $todate)
->where('status', 'LIKE', '%'.$tripstatus.'%')
->where('payment_mode','LIKE', '%'.$payment_type.'%')
->whereHas('provider', function($query) {
$query->where('fleet', Auth::user()->id );
});
$revenue = UserRequestPayment::select(\DB::raw(
'SUM(total) as overall, SUM(commision) as commission'))
->join('user_requests', 'user_request_payments.request_id', '=', 'user_requests.id')
->join('providers', 'user_requests.provider_id', '=', 'providers.id')
->where('providers.fleet', '=', Auth::user()->id)->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);
}
/**
* account statements today.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function statement_today(){
return $this->statement('today');
}
/**
* account statements monthly.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function statement_monthly(){
return $this->statement('monthly');
}
/**
* account statements monthly.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function statement_yearly(){
return $this->statement('yearly');
}
/**
* account statements.
*
* @param \App\Provider $provider
* @return \Illuminate\Http\Response
*/
public function statement_provider(){
try{
$Providers = Provider::where('fleet',Auth::user()->id)->get();
foreach($Providers as $index => $Provider){
$Rides = UserRequests::where('provider_id',$Provider->id)
->orderBy('id','desc')
->get()->pluck('id');
$Providers[$index]->rides_count = $Rides->count();
$Providers[$index]->payment = UserRequestPayment::whereIn('request_id', $Rides)
->select(\DB::raw(
'SUM(total) as overall, SUM(commision) as commission, SUM(total - commision) as earning' ))->get();
}
return view('fleet.providers.provider-statement', compact('Providers'))->with('page','Providers Statement');
} catch (Exception $e) {
return back()->with('flash_error','Something Went Wrong!');
}
}
}