/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
$vehicles = Vehicle::where('users_id', '=', Auth::user()->id)->get();
if ($vehicles->count() > 0) {
return View::make('chances.create', compact('vehicles'));
} else {
return View::make('vehicles.create')->withErrors('You must add a vehicle to create a Chance');
}
}
public static function DriverResponse($driver)
{
$driver_id = $driver->id;
$count = VehicleDriverOwner::where('vehicle_driver_owners_driver_id', $driver_id)->count();
if ($count) {
$driver_vehicle_owner_id = VehicleDriverOwner::where('vehicle_driver_owners_driver_id', $driver_id)->first()->vehicle_driver_owners_vehicle_id;
if (isset($driver_vehicle_owner_id)) {
$vehicle_data = Vehicle::where('id', $driver_vehicle_owner_id)->first();
if (empty($vehicle_data)) {
$owner_data = array();
} else {
$owner_data = Helpers::search_data($vehicle_data, $driver_id);
}
} else {
$owner_data = array();
}
} else {
$owner_data = array();
}
//check if user is authorised
$driver_vehicle_auth_count = VehicleDriverAuthorized::where('vehicle_driver_authorized_driver_id', $driver_id)->count();
if ($driver_vehicle_auth_count) {
//if found return data
$driver_vehicle_auth_id = VehicleDriverAuthorized::where('vehicle_driver_authorized_driver_id', $driver_id)->first()->vehicle_driver_authorized_vehicle_id;
if (!empty($driver_vehicle_auth_id)) {
$vehicle_data = Vehicle::where('id', $driver_vehicle_auth_id)->first();
if (empty($vehicle_data)) {
$auth_data = array();
} else {
$auth_data = Helpers::search_data($vehicle_data, $driver_id);
}
} else {
$auth_data = array();
}
} else {
$auth_data = array();
}
$data = array('owners' => $owner_data, 'auth' => $auth_data);
echo Helpers::response_data('200', 'Success', $data);
}
public function index()
{
$vin = Input::get('vin', '');
$vehicle = Vehicle::where('vin', '=', $vin)->first();
$dealer = Dealer::where('id', '=', $vehicle->dealer)->first();
$click = new Click();
$click->vin = $vehicle->vin;
$click->dealer = $dealer->dealer;
$click->state = $vehicle->state;
$click->datetime = date("Y-m-d H:i:s");
$click->ip = $_SERVER['REMOTE_ADDR'];
$click->paid = $vehicle->paid;
$click->save();
$dealer->current_clicks = $dealer->current_clicks + 1;
if ($vehicle->paid > 0) {
$dealer->paid_clicks = $dealer->paid_clicks + 1;
}
if ($dealer->active == 1 && $dealer->monthly_clicks <= $dealer->paid_clicks) {
$dealer->active = 0;
DB::table('vehicle')->where('dealer', $dealer->id)->update(array('paid' => 0, 'modified' => 1));
}
$dealer->save();
return Redirect::to($vehicle->url);
}
/**
* This function is responsible for all the data that is
* needed by different pages viaajax
*
* @return Depends on what what is being called
*/
public function data()
{
// BEGIN CHECK VEHICLE VIN
if (isset($_POST['vehicles_vin']) && $_POST['vehicles_vin'] != "") {
$vehicles_vin = $_POST['vehicles_vin'];
$vehicles_vin_status = Vehicle::where('vehicles_vin', $vehicles_vin)->withTrashed()->get()->count();
if ($vehicles_vin_status > 0) {
return 1;
}
}
// END CHECK VEHICLE VIN
// BEGIN CHECK VEHICLE LIC NO
if (isset($_POST['registrations_licence_plate_no']) && $_POST['registrations_licence_plate_no'] != "") {
$registrations_licence_plate_no = $_POST['registrations_licence_plate_no'];
$registrations_licence_plate_no_status = Registration::withTrashed()->where('registrations_licence_plate_no', $registrations_licence_plate_no)->get()->count();
if ($registrations_licence_plate_no_status > 0) {
return 1;
}
}
// END CHECK VEHICLE LIC NO
// BEGIN SHOW ALL MAKES (USER CLICKED ON YEAR)
if (isset($_POST['inp']) && $_POST['inp'] == 1) {
/* REMOVE TO SHOW ALL MODELS
$model_make_ar = ['-1' => 'Select Make'] + Model::distinct()->orderBy('model_make_id')->lists('model_make_id', 'model_make_id');
*/
$vehicles_year = $_POST['vehicles_year'];
$model_make_ar = ['-1' => 'Select Make'] + Model::where('model_year', $vehicles_year)->distinct()->orderBy('model_make_id')->lists('model_make_id', 'model_make_id');
$model_make_ar['add_new'] = "Add New";
foreach ($model_make_ar as $model_make_ar_fet) {
echo "<option value='{$model_make_ar_fet}'>{$model_make_ar_fet}</option>";
}
}
// END SHOW ALL MAKES (USER CLICKED ON YEAR)
// BEGIN SHOW ALL ASSOCIATED MODELS NAME AND TRIM (USER CLICKED ON MAKE)
if (isset($_POST['inp']) && $_POST['inp'] == 2) {
$vehicles_year = $_POST['vehicles_year'];
$vehicles_make_id = $_POST['vehicles_make_id'];
$vehicles_name_trim_arr = Model::where('model_year', $vehicles_year)->where('model_make_id', $vehicles_make_id)->get(['model_name', 'model_trim'])->toArray();
foreach ($vehicles_name_trim_arr as $vehicles_name_trim_arr_fet) {
$vehicles_name_trim[] = implode(', ', $vehicles_name_trim_arr_fet);
}
$vehicles_name_trim = array_unique($vehicles_name_trim);
sort($vehicles_name_trim);
$firstOp = "<option value='-1'>Select Model</option>";
echo $firstOp;
foreach ($vehicles_name_trim as $vehicles_name_trim_fet) {
echo "<option value='{$vehicles_name_trim_fet}'>{$vehicles_name_trim_fet}</option>";
}
}
// BEGIN SHOW ALL ASSOCIATED MODELS NAME AND TRIM (USER CLICKED ON MAKE)
// BEGIN SHOW ALL ASSOCIATED BODY STYLE (USER CLICKED ON MODEL)
if (isset($_POST['inp']) && $_POST['inp'] == 3) {
$vehicles_year = $_POST['vehicles_year'];
$vehicles_make_id = $_POST['vehicles_make_id'];
$vehicles_name_trim = $_POST['vehicles_name_trim'];
$vehicles_name_trim_ar = explode(',', $vehicles_name_trim);
$model_name = trim($vehicles_name_trim_ar[0]);
$model_trim = trim($vehicles_name_trim_ar[1]);
$vehicles_body_ar = array_filter(array_unique(Model::where('model_year', $vehicles_year)->where('model_make_id', $vehicles_make_id)->where('model_name', $model_name)->where('model_trim', $model_trim)->lists('model_body')));
sort($vehicles_body_ar);
$firstOp = "<option value='-1'>Select Body Style</option>";
echo $firstOp;
foreach ($vehicles_body_ar as $vehicles_body) {
echo "<option value='{$vehicles_body}'>{$vehicles_body}</option>";
}
}
// END SHOW ALL ASSOCIATED BODY STYLE (USER CLICKED ON MODEL)
// BEGIN SHOW ASSOCIATED BODY WEIGHT (USER CLICKED ON BODY STYLE)
// ALSO RESPONSIBLE FOR REPLYING TO AJAX REQUEST WHEN USER CLICKED ON MODEL
if (isset($_POST['inp']) && $_POST['inp'] == 4) {
$vehicles_year = $_POST['vehicles_year'];
$vehicles_make_id = $_POST['vehicles_make_id'];
$vehicles_name_trim = $_POST['vehicles_name_trim'];
$vehicles_name_trim_ar = explode(',', $vehicles_name_trim);
$model_name = trim($vehicles_name_trim_ar[0]);
$model_trim = trim($vehicles_name_trim_ar[1]);
// USER CLICKED ON MODEL
if (!isset($_POST['vehicles_body'])) {
$model_weight_kg_ar = array_filter(array_unique(Model::where('model_make_id', $vehicles_make_id)->where('model_name', $model_name)->where('model_trim', $model_trim)->where('model_year', $vehicles_year)->lists('model_weight_kg')));
if (!empty($model_weight_kg_ar)) {
sort($model_weight_kg_ar);
$firstOp = "<option value='-1'>Select Gross Weight</option>";
echo $firstOp;
foreach ($model_weight_kg_ar as $model_weight_kg_ar_fet) {
echo "<option value='{$model_weight_kg_ar_fet}'>{$model_weight_kg_ar_fet}</option>";
}
} else {
return 0;
}
} else {
$vehicles_body = $_POST['vehicles_body'];
$model_weight_kg_ar = array_filter(array_unique(Model::where('model_make_id', $vehicles_make_id)->where('model_name', $model_name)->where('model_trim', $model_trim)->where('model_body', $vehicles_body)->where('model_year', $vehicles_year)->lists('model_weight_kg')));
if (!empty($model_weight_kg_ar)) {
sort($model_weight_kg_ar);
$firstOp = "<option value='-1'>Select Gross Weight</option>";
echo $firstOp;
foreach ($model_weight_kg_ar as $model_weight_kg_ar_fet) {
echo "<option value='{$model_weight_kg_ar_fet}'>{$model_weight_kg_ar_fet}</option>";
}
} else {
return 0;
}
}
}
// END SHOW ASSOCIATED BODY WEIGHT (USER CLICKED ON BODY STYLE)
// BEGIN CLICK ON VEHICLE USE TYPE
if (isset($_POST['inp']) && $_POST['inp'] == 5) {
$vehicles_use_type = $_POST['vehicles_use_type'];
$vehicles_weight_kg = $_POST['vehicles_weight_kg'];
// BEGIN SWITCH TO SWITCH BETWEEN DIFFERENT VEHICLE USE TYPES (EXCEPT COMMERCIAL - PASSENGER)
switch ($vehicles_use_type) {
//NONE SELECTED
case -1:
$firstOp = "<option value='-1'>Select Class</option>";
echo $firstOp;
break;
// BEGIN COMMERCIAL OWN GOODS VEHICLE
// BEGIN COMMERCIAL OWN GOODS VEHICLE
case 3:
// CHECK VALUES BETWEEN MIN AND MAX WEIGHT
$vehicle_class_ar = FeesCommercialOwnGood::whereRaw('? BETWEEN coalesce(`fees_commercial_own_goods_min_kg`) AND coalesce(`fees_commercial_own_goods_max_kg`, ?)', [$vehicles_weight_kg, 10000])->lists('fees_commercial_own_goods_class', 'id');
foreach ($vehicle_class_ar as $id => $vehicle_class_ar_fet) {
echo "<option value='{$id}'>{$vehicle_class_ar_fet}</option>";
}
break;
// END COMMERCIAL OWN GOODS VEHICLE
// BEGIN MOTORCYCLE
// END COMMERCIAL OWN GOODS VEHICLE
// BEGIN MOTORCYCLE
case 8:
$vehicle_class_ar = FeesMotorcycle::lists('fees_motorcycle_class', 'id');
$firstOp = "<option value='-1'>Select Class</option>";
asort($vehicle_class_ar);
echo $firstOp;
foreach ($vehicle_class_ar as $id => $vehicle_class_ar_fet) {
echo "<option value='{$id}'>{$vehicle_class_ar_fet}</option>";
}
break;
// END MOTORCYCLE
// BEGIN PRIVATE NGO, GG/MUNICIPALITY, COMPANYRENTAL AND RENTAL
// END MOTORCYCLE
// BEGIN PRIVATE NGO, GG/MUNICIPALITY, COMPANYRENTAL AND RENTAL
default:
if ($vehicles_weight_kg != -1) {
// CHECK VALUES BETWEEN MIN AND MAX WEIGHT
$vehicle_class_ar = FeesPrivate::whereRaw('? BETWEEN coalesce(`fees_private_min_kg`) AND coalesce(`fees_private_max_kg`, ?)', [$vehicles_weight_kg, 10000])->lists('fees_private_class', 'id');
foreach ($vehicle_class_ar as $id => $vehicle_class_ar_fet) {
echo "<option value='{$id}'>{$vehicle_class_ar_fet}</option>";
}
}
// END PRIVATE NGO, GG/MUNICIPALITY, COMPANYRENTAL AND RENTAL
}
// END SWITCH TO SWITCH BETWEEN DIFFERENT VEHICLE USE TYPES (EXCEPT COMMERCIAL - PASSENGER)
}
// END CLICK ON VEHICLE USE TYPE
// BEGIN CLICK ON VEHICLE USE TYPE(COMMERCIAL PASSENGERS)
if (isset($_POST['inp']) && $_POST['inp'] == 6) {
$vehicle_class_ar = FeesCommercialPassenger::lists('fees_commercial_passengers_no_of_passenger', 'id');
$firstOp = "<option value='-1'>Select No. Of Passengers</option>";
ksort($vehicle_class_ar);
echo $firstOp;
foreach ($vehicle_class_ar as $id => $vehicle_class_ar_fet) {
echo "<option value='{$id}'>{$vehicle_class_ar_fet}</option>";
}
}
// END CLICK ON VEHICLE USE TYPE(COMMERCIAL PASSENGERS)
// BEGIN CLICK ON NO. OF PASSENGERS
if (isset($_POST['inp']) && $_POST['inp'] == 7) {
$vehicles_no_of_passengers = $_POST['vehicles_no_of_passengers'];
$vehicle_class_ar = FeesCommercialPassenger::where('id', $vehicles_no_of_passengers)->lists('fees_commercial_passengers_class', 'id');
foreach ($vehicle_class_ar as $id => $vehicle_class_ar_fet) {
echo "<option value='{$id}'>{$vehicle_class_ar_fet}</option>";
}
}
// END CLICK ON NO. OF PASSENGERS
// BEGIN AJAX REQUEST TO GENERATE REGISTRATION NO. (MODEL ALREADY IN DB)
if (isset($_POST['inp']) && $_POST['inp'] == 8) {
$vehicles_make_id = trim(Input::get('vehicles_make_id'));
$vehicles_name_trim = trim(Input::get('vehicles_name_trim'));
$vehicles_name_trim_ar = explode(',', $vehicles_name_trim);
$model_name = trim($vehicles_name_trim_ar[0]);
$model_trim = trim($vehicles_name_trim_ar[1]);
$vehicles_body = trim(Input::get('vehicles_body'));
$vehicles_weight_kg = trim(Input::get('vehicles_weight_kg'));
$new_wt = (int) Input::get('new_wt');
$vehicles_year = trim(Input::get('vehicles_year'));
$vehicles_use_type = Input::get('vehicles_use_type');
$vehicles_class = Input::get('vehicles_class');
$vehicles_class_abbr = trim(Input::get('vehicles_class_abbr'));
// IF DEFAULT WEIGHT IS PRESENT
if ($new_wt) {
// IF MODEL HAS BODY
if ($vehicles_body) {
$model = Model::where('model_make_id', $vehicles_make_id)->where('model_name', $model_name)->where('model_trim', $model_trim)->where('model_body', $vehicles_body)->whereNull('model_weight_kg')->first();
} else {
$model = Model::where('model_make_id', $vehicles_make_id)->where('model_name', $model_name)->where('model_trim', $model_trim)->whereNull('model_body')->whereNull('model_weight_kg')->first();
}
} else {
// IF MODEL HAS BODY
if ($vehicles_body) {
$model = Model::where('model_make_id', $vehicles_make_id)->where('model_name', $model_name)->where('model_trim', $model_trim)->where('model_body', $vehicles_body)->where('model_weight_kg', $vehicles_weight_kg)->first();
} else {
$model = Model::where('model_make_id', $vehicles_make_id)->where('model_name', $model_name)->where('model_trim', $model_trim)->whereNull('model_body')->where('model_weight_kg', $vehicles_weight_kg)->first();
}
}
$model_year = $model->model_year;
$model_make_id = strtoupper(substr($model->model_make_id, 0, 4));
$year = date("Y");
$class_sequence = Vehicle::vehicleRegistrationSequence($vehicles_use_type, $vehicles_class);
//$class_sequence = str_pad(Vehicle::withTrashed()->where('vehicles_use_type', $vehicles_use_type)->where('vehicles_class', $vehicles_class)->count()+1, 7, 0, STR_PAD_LEFT);
return $vehicles_class_abbr . "-" . $year . "-" . $model_year . "-" . $model_make_id . "-" . $class_sequence;
}
// END AJAX REQUEST TO GENERATE REGISTRATION NO. (MODEL ALREADY IN DB)
// BEGIN AJAX REQUEST TO GENERATE REGISTRATION NO. (NEW MODEL)
if (isset($_POST['inp']) && $_POST['inp'] == 9) {
$vehicles_make_id = strtoupper(substr(trim(Input::get('vehicles_make_id')), 0, 4));
$vehicles_year = trim(Input::get('vehicles_year'));
$vehicles_use_type = Input::get('vehicles_use_type');
$vehicles_class = Input::get('vehicles_class');
$vehicles_class_abbr = trim(Input::get('vehicles_class_abbr'));
$year = date("Y");
$class_sequence = Vehicle::vehicleRegistrationSequence($vehicles_use_type, $vehicles_class);
//$class_sequence = str_pad(Vehicle::withTrashed()->where('vehicles_use_type', $vehicles_use_type)->where('vehicles_class', $vehicles_class)->count()+1, 7, 0, STR_PAD_LEFT);
return $registration_number = $vehicles_class_abbr . "-" . $year . "-" . $vehicles_year . "-" . $vehicles_make_id . "-" . $class_sequence;
}
// END AJAX REQUEST TO GENERATE REGISTRATION NO. (NEW MODEL)
// BEGIN AJAX REQUEST TO SHOW VEHICLE SEARCHED BY USING REGISTRATION NO. (vehicle.search, vehicle.search-by-reg)
if (isset($_POST['registrations_no']) && $_POST['registrations_no'] != "") {
$registrations_no = $_POST['registrations_no'];
$vehicles_id_count = Registration::withTrashed()->where('registrations_no', $registrations_no)->count();
if ($vehicles_id_count != 0) {
$vehicles_id = Registration::withTrashed()->where('registrations_no', $registrations_no)->first()->registrations_vehicle_id;
$vehicles = Vehicle::withTrashed()->find($vehicles_id);
$vehicles_vin = $vehicles->vehicles_vin;
$vehicles_model_id = $vehicles->vehicles_model_id;
$vehicles_use_type_id = $vehicles->vehicles_use_type;
$model = Model::find($vehicles_model_id);
$model_make_id = $model->model_make_id;
$model_name = $model->model_name;
$vehicle_use_types_name = VehicleUseType::find($vehicles_use_type_id)->vehicle_use_types_name;
$url = URL::route('vehicle.edit', [$vehicles_id]);
$urlShow = URL::route('vehicle.show', [$vehicles_id]);
echo "<tr>";
echo "<td><a href={$urlShow}>{$vehicles_vin}</a></td>";
echo "<td>{$model_make_id}</td>";
echo "<td>{$model_name}</td>";
echo "<td>{$vehicle_use_types_name}</td>";
echo "<td><a href={$urlShow} class='btn default btn-xs purple'>\n\t\t\t\t\t\t<i class='fa fa-edit'></i>Details</a></td>";
echo "</tr>";
} else {
return 0;
}
}
// END AJAX REQUEST TO SHOW VEHICLE SEARCHED BY USING REGISTRATION NO.
// BEGIN AJAX REQUEST TO SHOW VEHICLE HISTORY SEARCHED BY USING REGISTRATION NO. TO VIEW ITS HISTORY (vehicle.search-vehicle-history)
if (isset($_POST['registrations_no_search_history']) && $_POST['registrations_no_search_history'] != "") {
$registrations_no = $_POST['registrations_no_search_history'];
$vehicles_id_count = Registration::where('registrations_no', $registrations_no)->count();
if ($vehicles_id_count != 0) {
$vehicles_id = Registration::where('registrations_no', $registrations_no)->first()->registrations_vehicle_id;
$vehicles = Vehicle::find($vehicles_id);
$vehicles_vin = $vehicles->vehicles_vin;
$vehicles_model_id = $vehicles->vehicles_model_id;
$vehicles_use_type_id = $vehicles->vehicles_use_type;
$model = Model::find($vehicles_model_id);
$model_make_id = $model->model_make_id;
$model_name = $model->model_name;
$vehicle_use_types_name = VehicleUseType::find($vehicles_use_type_id)->vehicle_use_types_name;
//$urlShow = URL::route('vehicle.show', [$vehicles_id]);
$urlHistory = URL::route('print.vehicle.history', [$vehicles_id]);
echo "<tr>";
echo "<td><a href={$urlHistory}>{$vehicles_vin}</a></td>";
echo "<td>{$model_make_id}</td>";
echo "<td>{$model_name}</td>";
echo "<td>{$vehicle_use_types_name}</td>";
echo "<td><a href={$urlHistory} class='btn default btn-xs purple'>\n\t\t\t\t\t\t</i>History</a></td>";
echo "</tr>";
} else {
return 0;
}
}
// END AJAX REQUEST TO SHOW VEHICLE HISTORY SEARCHED BY USING REGISTRATION NO.
// BEGIN AJAX REQUEST TO SHOW VEHICLE SEARCHED BY USING REGISTRATION NO. TO CHANGE ITS OWNER (vehicle.search-change-owner)
if (isset($_POST['registrations_no_change_owner']) && $_POST['registrations_no_change_owner'] != "") {
$registrations_no = $_POST['registrations_no_change_owner'];
$vehicles_id_count = Registration::where('registrations_no', $registrations_no)->count();
if ($vehicles_id_count != 0) {
$vehicles_id = Registration::where('registrations_no', $registrations_no)->first()->registrations_vehicle_id;
$vehicles = Vehicle::find($vehicles_id);
$vehicles_vin = $vehicles->vehicles_vin;
$vehicles_model_id = $vehicles->vehicles_model_id;
$vehicles_use_type_id = $vehicles->vehicles_use_type;
$model = Model::find($vehicles_model_id);
$model_make_id = $model->model_make_id;
$model_name = $model->model_name;
$vehicle_use_types_name = VehicleUseType::find($vehicles_use_type_id)->vehicle_use_types_name;
$url = URL::route('change.owner.edit', [$vehicles_id]);
echo "<tr>";
echo "<td><a href={$url}>{$vehicles_vin}</a></td>";
echo "<td>{$model_make_id}</td>";
echo "<td>{$model_name}</td>";
echo "<td>{$vehicle_use_types_name}</td>";
echo "<td><a href={$url} class='btn default btn-xs purple'>\n\t\t\t\t\t\t</i>Change Owner</a></td>";
echo "</tr>";
} else {
return 0;
}
}
// END AJAX REQUEST TO SHOW VEHICLE HISTORY SEARCHED BY USING REGISTRATION NO.
// BEGIN AJAX REQUEST TO SHOW VEHICLE SEARCHED BY USING REGISTRATION NO. TO UPDATE IT (vehicle.search-vehicle-update)
if (isset($_POST['registrations_no_search_update']) && $_POST['registrations_no_search_update'] != "") {
$registrations_no = $_POST['registrations_no_search_update'];
$vehicles_id_count = Registration::where('registrations_no', $registrations_no)->count();
if ($vehicles_id_count != 0) {
$vehicles_id = Registration::where('registrations_no', $registrations_no)->first()->registrations_vehicle_id;
$vehicles = Vehicle::find($vehicles_id);
$vehicles_vin = $vehicles->vehicles_vin;
$vehicles_model_id = $vehicles->vehicles_model_id;
$vehicles_use_type_id = $vehicles->vehicles_use_type;
$model = Model::find($vehicles_model_id);
$model_make_id = $model->model_make_id;
$model_name = $model->model_name;
$vehicle_use_types_name = VehicleUseType::find($vehicles_use_type_id)->vehicle_use_types_name;
$url = URL::route('vehicle.edit', [$vehicles_id]);
echo "<tr>";
echo "<td><a href={$url}>{$vehicles_vin}</a></td>";
echo "<td>{$model_make_id}</td>";
echo "<td>{$model_name}</td>";
echo "<td>{$vehicle_use_types_name}</td>";
echo "<td><a href={$url} class='btn default btn-xs purple'>\n\t\t\t\t\t\t</i>Update Vehicle</a></td>";
echo "</tr>";
} else {
return 0;
}
}
// END AJAX REQUEST TO SHOW VEHICLE HISTORY SEARCHED BY USING REGISTRATION NO.
// BEGIN AJAX REQUEST TO SHOW VEHICLE SEARCHED BY USING REGISTRATION NO. TO EDIT/UPDATE STICKER (vehicle.search-sticker)
if (isset($_POST['registrations_no_update_sticker']) && $_POST['registrations_no_update_sticker'] != "") {
$registrations_no = $_POST['registrations_no_update_sticker'];
$vehicles_id_count = Registration::where('registrations_no', $registrations_no)->count();
if ($vehicles_id_count != 0) {
$vehicles_id = Registration::where('registrations_no', $registrations_no)->first()->registrations_vehicle_id;
$vehicles = Vehicle::find($vehicles_id);
$vehicles_vin = $vehicles->vehicles_vin;
$vehicles_model_id = $vehicles->vehicles_model_id;
$vehicles_use_type_id = $vehicles->vehicles_use_type;
$model = Model::find($vehicles_model_id);
$model_make_id = $model->model_make_id;
$model_name = $model->model_name;
$vehicle_use_types_name = VehicleUseType::find($vehicles_use_type_id)->vehicle_use_types_name;
$url = URL::route('vehicle.sticker', [$vehicles_id]);
echo "<tr>";
echo "<td><a href={$url}>{$vehicles_vin}</a></td>";
echo "<td>{$model_make_id}</td>";
echo "<td>{$model_name}</td>";
echo "<td>{$vehicle_use_types_name}</td>";
echo "<td><a href={$url} class='btn default btn-xs purple'>\n\t\t\t\t\t\t</i>Issue/Renew Sticker</a></td>";
echo "</tr>";
} else {
return 0;
}
}
// END AJAX REQUEST TO SHOW VEHICLE HISTORY SEARCHED BY USING REGISTRATION NO.
// BEGIN AJAX REQUEST TO SHOW VEHICLE SEARCHED BY USING LICENSE PLATE NO (vehicle.search)
if (isset($_POST['registrations_licence_plate_no_search']) && $_POST['registrations_licence_plate_no_search'] != "") {
$registrations_licence_plate_no = $_POST['registrations_licence_plate_no_search'];
$vehicles_id_count = Registration::withTrashed()->where('registrations_licence_plate_no', $registrations_licence_plate_no)->count();
if ($vehicles_id_count != 0) {
$vehicles_id = Registration::withTrashed()->where('registrations_licence_plate_no', $registrations_licence_plate_no)->first()->registrations_vehicle_id;
$vehicles = Vehicle::withTrashed()->find($vehicles_id);
$vehicles_vin = $vehicles->vehicles_vin;
$vehicles_model_id = $vehicles->vehicles_model_id;
$vehicles_use_type_id = $vehicles->vehicles_use_type;
$model = Model::find($vehicles_model_id);
$model_make_id = $model->model_make_id;
$model_name = $model->model_name;
$vehicle_use_types_name = VehicleUseType::find($vehicles_use_type_id)->vehicle_use_types_name;
$url = URL::route('vehicle.edit', [$vehicles_id]);
$urlShow = URL::route('vehicle.show', [$vehicles_id]);
echo "<tr>";
echo "<td><a href={$urlShow}>{$vehicles_vin}</a></td>";
echo "<td>{$model_make_id}</td>";
echo "<td>{$model_name}</td>";
echo "<td>{$vehicle_use_types_name}</td>";
echo "<td><a href={$url} class='btn default btn-xs purple'>\n\t\t\t\t\t\t<i class='fa fa-edit'></i>Edit</a></td>";
echo "</tr>";
} else {
return 0;
}
}
// END AJAX REQUEST TO SHOW VEHICLE SEARCHED BY USING LICENSE PLATE NO
// BEGIN AJAX REQUEST TO SHOW VEHICLE SEARCHED BY USING DRIVER NIN (vehicle.search)
if (isset($_POST['owners_nin_search']) && $_POST['owners_nin_search'] != "") {
$owners_nin = $_POST['owners_nin_search'];
$owner = Driver::where('drivers_nin', $owners_nin)->first();
// DRIVER EXISTS
if ($owner) {
//$owner->id;
$vehicles = $owner->vehicleOwnerTransferred;
if ($vehicles->count() > 0) {
$row = "";
foreach ($vehicles as $vehicle) {
$vehicles_id = $vehicle->id;
$vehicles_vin = $vehicle->vehicles_vin;
$model_make_id = $vehicle->model->model_make_id;
$model_name = $vehicle->model->model_name;
$vehicle_use_types_name = $vehicle->vehicleUseType->vehicle_use_types_name;
$urlShow = URL::route('vehicle.show', [$vehicles_id]);
$url = URL::route('vehicle.edit', [$vehicles_id]);
$row .= "<tr>";
$row .= "<td><a href={$urlShow}>{$vehicles_vin}</a></td>";
$row .= "<td>{$model_make_id}</td>";
$row .= "<td>{$model_name}</td>";
$row .= "<td>{$vehicle_use_types_name}</td>";
$row .= "<td><a href={$url} class='btn default btn-xs purple'>\n\t\t\t\t\t\t\t\t<i class='fa fa-edit'></i>Edit</a></td>";
$row .= "</tr>";
}
return $row;
}
}
}
// END AJAX REQUEST TO SHOW VEHICLE SEARCHED BY USING DRIVER NIN
// BEGIN AJAX REQUEST TO SHOW VEHICLE SEARCHED BY USING STICKER (vehicle.search)
if (isset($_POST['registrations_sticker_serial_no_search']) && $_POST['registrations_sticker_serial_no_search'] != "") {
$registrations_sticker_serial_no = $_POST['registrations_sticker_serial_no_search'];
$regRow = Registration::withTrashed()->where('registrations_sticker_serial_no', $registrations_sticker_serial_no)->first();
if ($regRow) {
$vehicles_id = $regRow->vehicle->id;
$vehicles_vin = $regRow->vehicle->vehicles_vin;
$model_make_id = $regRow->vehicle->model->model_make_id;
$model_name = $regRow->vehicle->model->model_name;
$vehicle_use_types_name = $regRow->vehicle->vehicleUseType->vehicle_use_types_name;
$urlShow = URL::route('vehicle.show', [$vehicles_id]);
$url = URL::route('vehicle.edit', [$vehicles_id]);
$row = "";
$row .= "<tr>";
$row .= "<td><a href={$urlShow}>{$vehicles_vin}</a></td>";
$row .= "<td>{$model_make_id}</td>";
$row .= "<td>{$model_name}</td>";
$row .= "<td>{$vehicle_use_types_name}</td>";
$row .= "<td><a href={$url} class='btn default btn-xs purple'>\n\t\t\t\t\t\t<i class='fa fa-edit'></i>Edit</a></td>";
$row .= "</tr>";
return $row;
}
}
// END AJAX REQUEST TO SHOW VEHICLE SEARCHED BY USING STICKER
// BEGIN AJAX REQUEST TO SHOW VEHICLE SEARCHED BY USING COLLATERAL ID (vehicle.search)
if (isset($_POST['liens_collateral_id_search']) && $_POST['liens_collateral_id_search'] != "") {
$liens_collateral_id = $_POST['liens_collateral_id_search'];
$lien_id_count = Lien::where('liens_collateral_id', $liens_collateral_id)->count();
if ($lien_id_count != 0) {
$lien = Lien::where('liens_collateral_id', $liens_collateral_id)->first();
$vehicle = $lien->vehicle;
$vehicles_id = $vehicle->id;
$vehicles = Vehicle::find($vehicles_id);
$vehicles_vin = $vehicles->vehicles_vin;
$vehicles_model_id = $vehicles->vehicles_model_id;
$vehicles_use_type_id = $vehicles->vehicles_use_type;
$model = Model::find($vehicles_model_id);
$model_make_id = $model->model_make_id;
$model_name = $model->model_name;
$vehicle_use_types_name = VehicleUseType::find($vehicles_use_type_id)->vehicle_use_types_name;
$url = URL::route('vehicle.edit', [$vehicles_id]);
$urlShow = URL::route('vehicle.show', [$vehicles_id]);
echo "<tr>";
echo "<td><a href={$urlShow}>{$vehicles_vin}</a></td>";
echo "<td>{$model_make_id}</td>";
echo "<td>{$model_name}</td>";
echo "<td>{$vehicle_use_types_name}</td>";
echo "<td><a href={$url} class='btn default btn-xs purple'>\n\t\t\t\t\t\t<i class='fa fa-edit'></i>Edit</a></td>";
echo "</tr>";
} else {
return 0;
}
}
// END AJAX REQUEST TO SHOW VEHICLE SEARCHED BY USING COLLATERAL ID
// BEGIN AJAX REQUEST TO CHECK IF FINES ARE ASSOCIATED WITH THE VEHICLE (FROM vehicle.show.blade.php)
if (isset($_POST['vehicle_associated_fines']) && $_POST['vehicle_associated_fines'] != "") {
//VEHICLE ID
$vehicle_id = $_POST['vehicle_associated_fines'];
return Vehicle::getVehiclePendingFinesMessage($vehicle_id);
}
// END AJAX REQUEST TO CHECK IF FINES ARE ASSOCIATED WITH THE VEHICLE (FROM vehicle.show.blade.php)
// BEGIN AJAX REQUEST TO ADD NEW STICKER AND UPDATE ODOMETER (FROM vehicle.show.blade.php)
if (isset($_POST['registrations_sticker_serial_no']) && $_POST['registrations_sticker_serial_no'] != "") {
// VEHICLE ID
$vehicles_id = trim($_POST['vehicles_id']);
$registrations_sticker_serial_no = trim($_POST['registrations_sticker_serial_no']);
// TAKE OLD ODOMETER IN LOG AND Update Odometer(Coming from registration renewal)
if (isset($_POST['vehicles_odometer']) && $_POST['vehicles_odometer'] != 0) {
$vehicles_odometer = $_POST['vehicles_odometer'];
LogVehicleOdometer::create(['log_vehicle_odometer_vehicle_id' => $vehicles_id, 'log_vehicle_odometer_old_odometer' => $vehicles_odometer, 'log_vehicle_odometer_sticker' => $registrations_sticker_serial_no, 'log_vehicle_odometer_status' => 3]);
Vehicle::find($vehicles_id)->update(['vehicles_odometer' => $vehicles_odometer]);
} else {
$logRow = LogVehicleOdometer::where('log_vehicle_odometer_vehicle_id', $vehicles_id)->where('log_vehicle_odometer_status', 1)->first();
$logRow->log_vehicle_odometer_sticker = $registrations_sticker_serial_no;
$logRow->save();
//MARK FINES AS PAID(CASE IN WHICH VEHICLE STICKER IS BEING GENERATED FOR A VEHICLE WITH PRE-REGISTRATION FINES)
//VEHICLE FINES
$vehicleVoilations = ViolateVehicle::where('vehicle_id', $vehicles_id)->where('status', 2);
if ($vehicleVoilations->count()) {
$vehicleVoilations->update(['status' => 1]);
}
//DRIVER FINES
$driverVoilations = ViolateDriver::where('vehicle_id', $vehicles_id)->where('status', 2);
if ($driverVoilations->count()) {
$driverVoilations->update(['status' => 1]);
}
}
return Registration::registerSticker($vehicles_id, $registrations_sticker_serial_no);
}
// END AJAX REQUEST TO ADD NEW STICKER
// BEGIN AJAX REQUEST TO CHECK IF STICKER IS ALREADY PRESENT
if (Input::get('inp') == 10) {
$registrations_sticker_serial_no = Input::get('sticker_no');
$reg_check1 = Registration::where('registrations_sticker_serial_no', $registrations_sticker_serial_no)->first();
if ($reg_check1) {
return $reg_check1;
} else {
return LogVehicleOdometer::where('log_vehicle_odometer_sticker', $registrations_sticker_serial_no)->first();
}
}
// END AJAX REQUEST TO CHECK IF STICKER IS ALREADY PRESENT
// BEGIN AJAX REQUEST TO CHECK IF NIN ALREADY IN DATABASE
if (Input::get('inp') == 11) {
$old_drivers_nin_val_new = Input::get('old_drivers_nin_val_new');
$owner = Driver::where('drivers_nin', $old_drivers_nin_val_new)->first();
if ($owner) {
if ($owner->drivers_mname) {
$owners_name = $owner->drivers_fname . " " . $owner->drivers_mname . " " . $owner->drivers_lname;
} else {
$owners_name = $owner->drivers_fname . " " . $owner->drivers_lname;
}
$url = URL::route('driver.history', [$owner->id]);
return "NIN already registered to <a href={$url}>{$owners_name}</a>";
}
}
// END AJAX REQUEST TO CHECK IF NIN ALREADY IN DATABASE
// BEGIN AJAX REQUEST TO CHECK IF Driver LICENSE NUMBER ALREADY IN DATABASE
if (Input::get('inp') == 12) {
$old_drivers_license_no_val_new = Input::get('old_drivers_license_no_val_new');
$owner = Driver::where('drivers_license_no', $old_drivers_license_no_val_new)->first();
if ($owner) {
if ($owner->drivers_mname) {
$owners_name = $owner->drivers_fname . " " . $owner->drivers_mname . " " . $owner->drivers_lname;
} else {
$owners_name = $owner->drivers_fname . " " . $owner->drivers_lname;
}
$url = URL::route('driver.history', [$owner->id]);
return "License already registered to <a href={$url}>{$owners_name}</a>";
}
}
// END AJAX REQUEST TO CHECK IF Driver LICENSE NUMBER ALREADY IN DATABASE
}
public function transportCart()
{
if (Input::has('vehicle_type')) {
if (Input::has('pick_up_date')) {
$pick_up_date = date("y-m-d", strtotime(Input::get('pick_up_date')));
}
if (Input::has('drop_off_date')) {
$drop_off_date = date("y-m-d", strtotime(Input::get('drop_off_date')));
}
$vehicle_type = Input::get('vehicle_type');
$vehicle_id = Vehicle::where('vehicle_type', $vehicle_type)->first()->id;
$origin = Input::get('origin');
$origin_id = City::where('city', $origin)->select('id')->first()->id;
$destination_1 = Input::get('destination_1');
$destination_2 = Input::get('destination_2');
$destination_3 = Input::get('destination_3');
$destination_1_id = City::where('city', $destination_1)->select('id')->first()->id;
$destination_2_id = City::where('city', $destination_2)->select('id')->first()->id;
$destination_3_id = City::where('city', $destination_3)->select('id')->first()->id;
$pick_up_time_hour = Input::get('pick_up_time_hour');
$pick_up_time_minutes = Input::get('pick_up_time_minutes');
$drop_off_time_hour = Input::get('drop_off_time_hour');
$drop_off_time_minutes = Input::get('drop_off_time_minutes');
$distance = Input::get('totalDistance');
$vehicle_cost = Vehicle::where('id', $vehicle_id)->first()->rate;
$transport_cart_key = $vehicle_id . '_' . $origin_id . '_' . $destination_1_id;
$cost = $distance * $vehicle_cost;
if (!empty($destination_3)) {
$destination_last = $destination_3;
} elseif (!empty($destination_2)) {
$destination_last = $destination_2;
} else {
$destination_last = $destination_1;
}
$transport_cart_box = array('vehicle_type' => $vehicle_type, 'vehicle_id' => $vehicle_id, 'origin' => $origin, 'destination_1' => $destination_1, 'destination_2' => $destination_2, 'destination_3' => $destination_3, 'destination_last' => $destination_last, 'pick_up_date' => $pick_up_date, 'pick_up_time_hour' => $pick_up_time_hour, 'pick_up_time_minutes' => $pick_up_time_minutes, 'drop_off_date' => $drop_off_date, 'drop_off_time_hour' => $drop_off_time_hour, 'drop_off_time_minutes' => $drop_off_time_minutes, 'transport_cart_key' => $transport_cart_key, 'cost' => number_format($cost, 2));
if (Session::has('transport_cart_box')) {
$data = Session::get('transport_cart_box');
$data[$transport_cart_key] = $transport_cart_box;
} else {
$data = [];
$data[$transport_cart_key] = $transport_cart_box;
}
Session::put('transport_cart_box', $data);
}
if (Session::has('transport_cart_box') || Input::has('vehicle_type')) {
return Response::json(Session::get('transport_cart_box'));
} else {
return null;
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$users = User::all();
$vehicles = Auth::user()->isClient() ? Vehicle::where('user_id', '=', Auth::id())->get() : Vehicle::all();
return View::make('dashboard')->with('title', 'Dashboard')->with('vehicles', $vehicles);
}
public function store()
{
$data = array('message' => 'Vehicle added successfully', 'success' => true);
try {
$input = Input::json();
$vin = Input::get('vin', '');
$sign = Input::get('sign', '');
if (!empty($vin) && !empty($sign)) {
$hash = hash('sha256', $vin . '-' . $this->secret);
if ($hash == $sign) {
$cars = Vehicle::where('vin', '=', $vin);
if ($cars->count() > 0) {
$data['message'] = 'Vehicle already exists';
$data['success'] = false;
} else {
$car = new Vehicle();
$car->vin = $vin;
$car->url = $input->get('url', '');
$car->address = $input->get('address', '');
$car->city = $input->get('city', '');
$car->state = $input->get('state', '');
$car->photo = $input->get('photo', '');
$car->certified = $this->getBoolean($input, 'certified');
$car->year = $this->getInt($input, 'year');
$car->miles = $this->getInt($input, 'miles');
$car->zip = $this->getInt($input, 'zip');
$car->doors = $this->getInt($input, 'doors');
$car->cylinders = $this->getInt($input, 'cylinders');
$car->price = $this->getDouble($input, 'price');
$car->latitude = $this->getDouble($input, 'latitude');
$car->longitude = $this->getDouble($input, 'longitude');
$car->make = $this->getPropertyId($input, 'make');
$car->model = $this->getPropertyId($input, 'model');
$car->feature = $this->getPropertyId($input, 'feature');
$car->status = $this->getPropertyId($input, 'status');
$car->body = $this->getPropertyId($input, 'body');
$car->fuel = $this->getPropertyId($input, 'fuel');
$car->drive = $this->getPropertyId($input, 'drive');
$car->interior = $this->getPropertyId($input, 'interior');
$car->exterior = $this->getPropertyId($input, 'exterior');
$car->transmission = $this->getPropertyId($input, 'transmission');
$this->setSuggestions($car, $input->get('make', ''), $input->get('model', ''));
$car = $this->setDealerProperties($car, $input, 'dealer');
$car->paid = 0;
$car->modified = 1;
$car->deleted = 0;
$car->save();
}
} else {
$data['message'] = 'Authentication failed';
$data['success'] = false;
}
} else {
$data['message'] = 'Required parameters missing';
$data['success'] = false;
}
} catch (Illuminate\Database\QueryException $sql_exception) {
$data['message'] = 'Invalid data found';
$data['success'] = false;
} catch (Exception $exception) {
$data['message'] = 'Unknown error occurred';
$data['message'] = $exception->getMessage();
$data['success'] = false;
}
return Response::json($data);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy(User $user)
{
if (!Auth::user()->isAdmin()) {
return View::make('errors.noedit')->with('title', 'Error Message');
}
$vehicles = Vehicle::where('user_id', '=', $user->id)->count();
if ($vehicles > 0) {
$vehicles->inspection()->delete();
$vehicles->inspectordetails()->delete();
$vehicles->certificate()->delete();
$vehicles->delete();
}
$user->delete();
return Redirect::to('users')->with('success', 'User deleted successfully');
}
public function saveCar()
{
$this->layout->body_class = 'user';
$vin = Input::get('vin', '');
if (Auth::check() && !empty($vin)) {
$values = Vehicle::where('vin', '=', $vin);
if ($values->count()) {
$car = new SavedCar();
$car->vehicle = $values->first()->vin;
$car->user = Auth::user()->id;
$car->datetime = date("Y-m-d H:i:s");
$car->save();
}
}
}
public static function checkVin($vehicles_vin)
{
$vehicles_vin_status = Vehicle::where('vehicles_vin', $vehicles_vin)->get()->count();
if ($vehicles_vin_status > 0) {
return 1;
}
}
public function active_vehicles(Request $request)
{
$vehicle = Vehicle::where('status', 'AVAILABLE')->get();
return response()->json(['count' => count($vehicle), 'data' => $vehicle]);
}
/*
|--------------------------------------------------------------------------
| Application Routes
|--------------------------------------------------------------------------
|
| Here is where you can register all of the routes for an application.
| It's a breeze. Simply tell Laravel the URIs it should respond to
| and give it the Closure to execute when that URI is requested.
|
*/
Route::group(array('before' => 'checktoken'), function () {
Route::resource('user', 'UserController');
Route::get('registervehicle', 'VehicleController@create');
Route::get('vehiclelist', 'VehicleController@index');
Route::resource('vehicle', 'VehicleController');
Route::get('chanceslist', 'ChanceController@index');
Route::get('registerchance', 'ChanceController@create');
Route::resource('chance', 'ChanceController');
Route::resource('usersofchance', 'UsersofChanceController');
Route::resource('comments', 'CommentsController');
Route::resource('rated', 'RatedController');
Route::get('profile', function () {
$vehicle = Vehicle::where('users_id', '=', Auth::user()->id)->get();
return View::make('users.profile')->with('vehicles', $vehicle);
});
});
Route::get('/', 'SessionsController@create');
Route::get('login', 'SessionsController@create');
Route::get('logout', 'SessionsController@destroy');
Route::resource('sessions', 'SessionsController');
public function index()
{
$vehicle = Vehicle::where('users_id', '=', Auth::user()->id)->get()->toJson();
return $vehicle;
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$vehicles = Auth::user()->isClient() ? Vehicle::where('user_id', '=', Auth::id())->get() : Vehicle::all();
return View::make('vehicles.index')->with('vehicles', $vehicles)->with('title', 'All Vehicles');
}
