/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function map()
{
$current_user = User::where('id', Auth::id())->get();
if (count($current_user) == 0) {
$user_operation_areas = [];
foreach (Operation_area::select()->get() as $op_area) {
$user_operation_areas[] = $op_area->id;
}
} else {
$user_operation_areas = explode(',', $current_user[0]->operation_areas);
}
$operation_areas = Operation_area::select()->whereIn('id', $user_operation_areas)->get();
$emergency_cases = emergencyCase::select()->whereIn('operation_area', $user_operation_areas)->orderBy('created_at', 'desc')->get();
$vehicles = Vehicle::select()->where('public', '=', true)->get();
return view('pages.home_map', compact('operation_areas', 'emergency_cases', 'vehicles'));
}
/** store vehicles license */
public function store_license(Request $request)
{
$license_types = LicenseTypeVehicle::where('vehicle_id', $request->vehicle_id)->get();
$vehicle = Vehicle::select('plate_number', 'client_id')->findOrFail($request->vehicle_id);
$cur_date = date("Y-m-d H:i:s");
foreach ($license_types as $license_type) {
$license_type_id = $license_type->license_type_id;
if (isset($request->{'status_' . $license_type_id})) {
$save = LicenseRenewalRequest::where('license_type_id', '=', $license_type->license_type_id)->where('vehicle_id', '=', $request->vehicle_id)->where('status', '!=', $request->{'status_' . $license_type_id})->update(['status' => $request->{'status_' . $license_type_id}]);
//update renewal request where there is chnage in the status.
if ($save) {
// create notification.
switch ($request->{'status_' . $license_type_id}) {
case 'pending':
$status = "The renewal request for the vehicle {$vehicle->plate_number} status has marked pending";
$type = "renewal_request";
break;
case 'in-progress':
$status = "Your renewal request for the vehicle {$vehicle->plate_number} is in progress";
$type = "renewal_request";
break;
case 'completed':
$status = "Your renewal request for the vehicle {$vehicle->plate_number} has completed";
$type = "renewal_completed";
break;
}
$input_data = array('sent_to' => $vehicle->client_id, 'sent_on' => $cur_date, 'message' => $status, 'type' => $type);
LicenseNotification::create($input_data);
}
//
}
global $formated_start_date;
$start_date = $request->{'license_type_start_' . $license_type->license_type_id};
$formated_start_date = date('Y-m-d', strtotime($start_date));
$formated_end_date = date('Y-m-d', strtotime('+365 days', strtotime($start_date)));
$saved_license = LicenseTypeVehicle::where('vehicle_id', $request->vehicle_id)->where('license_type_id', $license_type_id)->where(function ($query) {
global $formated_start_date;
$query->where('license_start_on', '=', $formated_start_date)->orWhere('license_start_on', '=', '0000-00-00 00:00:00');
})->get()->toArray();
// check the form license date with the db license date
if (empty($saved_license)) {
// license date has changed
LicenseTypeVehicle::where('id', $license_type->id)->update(['deleted_at' => date("Y-m-d H:i:s")]);
$insert_data = array('license_type_id' => $license_type->license_type_id, 'vehicle_id' => $request->vehicle_id, 'license_start_on' => $formated_start_date, 'license_end_on' => $formated_end_date);
LicenseTypeVehicle::create($insert_data);
//soft delete the previous license date
//insert the new date
} else {
LicenseTypeVehicle::where('id', $license_type->id)->update(['license_start_on' => $formated_start_date, 'license_end_on' => $formated_end_date]);
}
/* $start_date = $request->{'license_type_start_'.$license_type->license_type_id};
$formated_start_date = date('Y-m-d', strtotime($start_date));
$formated_end_date = date('Y-m-d', strtotime('+365 days',strtotime($start_date)));
LicenseTypeVehicle::where('id', $license_type->id)
->update(['license_start_on' => $formated_start_date, 'license_end_on' => $formated_end_date, 'updated_at' => date("Y-m-d H:i:s")]);
*/
}
Session::flash('flash_message', trans('vehicle.vehicle_on_update'));
return Redirect::to($request->redirect_to);
}