/** * 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'); }