Example #1
0
 public function liensutiles()
 {
     $liens = Lien::all();
     // POUR PAGE TYPE
     $lastActu = Actualites::orderBy('dateActualite', 'desc')->take(1)->get();
     $lastInfo = Alerte::orderBy('dateAlerte', 'desc')->take(1)->get();
     return View::make('public.pages.liensutiles')->with('liens', $liens)->with('lastActu', $lastActu)->with('lastInfo', $lastInfo);
 }
 public function updateLien($id)
 {
     $file = Input::file('logoLien');
     if (empty($file)) {
         $lien = Lien::find($id);
         $input = ["libelleLien" => Input::get('libelleLien'), "urlLien" => Input::get('urlLien')];
         $messages = array('required' => ":attribute est requis pour l'ajout d'un nouveau lien.", 'unique' => ':attribute est déjà utilisé');
         $rules = array('urlLien' => 'required');
         // Si le nom du lien a été changé
         if (Input::get('libelleLien') != $lien->libelleLien) {
             $rules['libelleLien'] = 'required|unique:lien,libelleLien';
         }
         $validator = Validator::make(Input::all(), $rules, $messages);
         if ($validator->fails()) {
             $messages = $validator->messages();
             return Redirect::to(URL::previous())->withErrors($validator);
         } else {
             Session::flash('flash_msg', "Les modifications ont bien été changées.");
             Session::flash('flash_type', "success");
             $lien->fill($input)->save();
             return Redirect::to("/admin/liensutiles");
         }
     } else {
         $taille = $file->getSize();
         if ($taille < 5242880 || $taille != false) {
             $ext = Input::file('logoLien')->getClientOriginalExtension();
             $lien = Lien::find($id);
             unlink('../public/img/upload/' . $lien->logoLien);
             $nameFile = Str::slug(Input::get('libelleLien'), '-');
             $file->move('../public/img/upload', $nameFile . '.' . $ext);
             $input = ["libelleLien" => Input::get('libelleLien'), "urlLien" => Input::get('urlLien'), "logoLien" => $nameFile . '.' . $ext];
             $messages = array('required' => ":attribute est requis pour l'ajout d'un nouveau lien.", 'unique' => ':attribute est déjà utilisé');
             $rules = array('urlLien' => 'required', 'logoLien' => 'required');
             // Si le nom du lien a été changé
             if (Input::get('libelleLien') != $lien->libelleLien) {
                 $rules['libelleLien'] = 'required|unique:lien,libelleLien';
             }
             $validator = Validator::make(Input::all(), $rules, $messages);
             if ($validator->fails()) {
                 $messages = $validator->messages();
                 return Redirect::to(URL::previous())->withErrors($validator);
             } else {
                 Session::flash('flash_msg', "Les modifications ont bien été changées.");
                 Session::flash('flash_type', "success");
                 $lien->fill($input)->save();
                 return Redirect::to("/admin/liensutiles");
             }
         } else {
             Session::flash('flash_msg', "Le fichier est trop volumineux.");
             Session::flash('flash_type', "fail");
             return Redirect::to("/admin/liensutiles");
         }
     }
 }
Example #3
0
 /**
  * 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
 }
function ajouterPara()
{
    $newParag = new Paragraphe();
    $newParag->titrePara = $_POST['textTitrePara'];
    $newParag->contenuPara = $_POST['textCont'];
    $numpara = $newParag->creerParagraphe();
    $laPage = new Page();
    $laPage->numpage = $_GET['numpage'];
    $laPage->id_m = $_GET['id'];
    $laPage->numpara = $numpara;
    $laPage->ordre = $_POST['selectOrdre'];
    $laPage->colonne = $_POST['selectType'];
    $laPage->liste = $_POST['radioListe'];
    $laPage->typeTitre = $_POST['radioTypeTitre'];
    $laPage->ajouterParagraphe();
    // On l'ajoute à la page
    for ($i = 1; $i <= $_POST['nbLiens']; $i++) {
        // On traite l'ajout de liens
        $valUrl = "textUrlLien" . $i . "_";
        $valPage = "selectPage" . $i . "_";
        if (${$valUrl} || ${$valPage}) {
            $valLib = "textLibLien" . $i . "_";
            $valTexte = "textTexteLien" . $i . "_";
            $valOrdre = "selectOrdreLien" . $i . "_";
            $valFen = "radioFen" . $i . "_";
            $newLien = new Lien();
            $newLien->numpara = $numpara;
            $newLien->libLien = ${$valLib};
            $newLien->texteLien = ${$valTexte};
            if (${$valPage}) {
                $pageLien = new Page();
                $pageLien->numpage = ${$valPage};
                $pageLien->infosPage();
                $newLien->numpage = ${$valPage};
                $newLien->urlLien = $pageLien->aliasPage;
            } else {
                $newLien->urlLien = ${$valUrl};
            }
            $newLien->fenLien = ${$valFen};
            $newLien->ordreLien = ${$valOrdre};
            $newLien->creerLien();
        }
        //fin if ($$valUrl)
    }
    //fin du for
    for ($i = 1; $i <= $nbPhotos; $i++) {
        // On traite l'association de photos
        $valSelect = "selectPhoto" . $i . "_";
        $valFile = "filePhoto" . $i . "_";
        if (${$valSelect} || isset($_FILES[$valFile]['tmp_name']) && $_FILES[$valFile]['tmp_name'] != "") {
            $valLeg = "textLegPh" . $i . "_";
            $valOrdre = "selectOrdrePhoto" . $i . "_";
            $valTaille = "radioTaille" . $i . "_";
            if (${$valSelect}) {
                // on associe une photo existante
                $newParag->numphoto = ${$valSelect};
                $newParag->ordrePhoto = ${$valOrdre};
                $newParag->legPhoto = ${$valLeg};
                $newParag->associerPhoto();
            } else {
                if (isset($_FILES[$valFile]['tmp_name']) && $_FILES[$valFile]['tmp_name'] != "") {
                    // on cr�e une photo
                    $newPhoto = new Photo();
                    $newPhoto->nomPhoto = normaliza(basename($_FILES[$valFile]['name']));
                    $newPhoto->tmp_name = $_FILES[$valFile]['tmp_name'];
                    $newPhoto->taille = ${$valTaille};
                    $numphoto = $newPhoto->creerPhoto();
                    // On associe ensuite la photo au paragraphe
                    $newParag->numphoto = $numphoto;
                    $newParag->ordrePhoto = ${$valOrdre};
                    $newParag->legPhoto = ${$valLeg};
                    $newParag->associerPhoto();
                }
            }
        }
        //fin if ($$valSelect || $$valFile)
    }
    //fin du for
    for ($i = 1; $i <= $nbVideos; $i++) {
        // On traite l'association de vidéos
        $valSelect = "selectVideo" . $i . "_";
        $valFile = "fileVideo" . $i . "_";
        if (${$valSelect} || isset($_FILES[$valFile]['tmp_name']) && $_FILES[$valFile]['tmp_name'] != "") {
            $valLeg = "textLegVi" . $i . "_";
            $valOrdre = "selectOrdreVideo" . $i . "_";
            if (${$valSelect}) {
                // on associe une vidéo existante
                $newParag->numvideo = ${$valSelect};
                $newParag->ordreVideo = ${$valOrdre};
                $newParag->legVideo = ${$valLeg};
                $newParag->associerVideo();
            } else {
                if (isset($_FILES[$valFile]['tmp_name']) && $_FILES[$valFile]['tmp_name'] != "") {
                    // on cree une video
                    $newVideo = new Video();
                    $newVideo->nomVideo = normaliza(basename($_FILES[$valFile]['name']));
                    $newVideo->tmp_name = $_FILES[$valFile]['tmp_name'];
                    $numvideo = $newVideo->creerVideo();
                    // On associe ensuite la vidéo au paragraphe
                    $newParag->numvideo = $numvideo;
                    $newParag->ordreVideo = ${$valOrdre};
                    $newParag->legVideo = ${$valLeg};
                    $newParag->associerVideo();
                }
            }
        }
        //fin if ($$valSelect || $$valFile)
    }
    //fin du for
    for ($i = 1; $i <= $nbFichiers; $i++) {
        // On traite l'association de fichiers
        //$valSelect="selectFich".$i."_";
        $valFile = "fileFich" . $i . "_";
        if (isset($_FILES[$valFile]['tmp_name']) && $_FILES[$valFile]['tmp_name'] != "") {
            $valOrdre = "selectOrdreFich" . $i . "_";
            $valLib = "textLibFich" . $i . "_";
            $newFichier = new Fichier();
            $newFichier->nomFichier = normaliza(basename($_FILES[$valFile]['name']));
            $newFichier->tmp_name = $_FILES[$valFile]['tmp_name'];
            $numfichier = $newFichier->creerFichier();
            // On associe ensuite le fichier au paragraphe
            $newParag->numfichier = $numfichier;
            $newParag->ordreFichier = ${$valOrdre};
            $newParag->libFichier = ${$valLib};
            $newParag->associerFichier();
        }
        //fin if ($$valSelect || $$valFile)
    }
    //fin du for
    if (!$action) {
        //on est en création de page
        if (!$paragraphe) {
            $pg_admin = "lister-page";
        } else {
            $creer_page = 1;
        }
    } else {
        //on est en modification de page
        if (!$paragraphe) {
            $onglet = "mod_para";
        } else {
            $onglet = "aj_para";
        }
    }
}
                                $modifParag->legVideo = $textLegVi;
                                $modifParag->modifierVideo();
                            }
                        }
                    }
                    //fin if ($selectPhoto || ...)
                    $mes = "La vidéo est modifiée!";
                    $fermer = 1;
                }
            }
        }
    }
    //fin else if ($numphoto)
}
if ($numlien) {
    $leLien = new Lien();
    $leLien->numlien = $numlien;
    $leLien->infosLien();
} else {
    if ($numfichier) {
        $leFichier = new Fichier();
        $leFichier->numfichier = $numfichier;
        $leFichier->numparafichier = $numparafichier;
        $leFichier->infosFichier();
    } else {
        if ($numphoto) {
            $laPhoto = new Photo();
            $laPhoto->numphoto = $numphoto;
            $laPhoto->numparaphoto = $numparaphoto;
            $laPhoto->infosPhoto();
        } else {
Example #6
0
<?php

/* Date de cration: 26/06/2008 */
include "../connexion.php";
include "../fonctions.php";
/*** Include des classes ****/
require_once "classes.php";
if ($id) {
    $uti = new Utilisateur();
    $uti->id = $id;
}
if ($div == "li_liens" . $numlien) {
    /**$fichier_fds=SelectSimple("fichier_fds","su_produits","numprod",$numprod); 
      if ($fichier_fds && file_exists($chem."fichiers/".$fichier_fds)) unlink($chem."fichiers/".$fichier_fds); 
      mysql_query("UPDATE su_produits SET fds='', fichier_fds='', date_fds='', lg_fds='' WHERE numprod='$numprod'");  **/
    $supLien = new Lien();
    $supLien->numlien = $numlien;
    $supLien->supprimerLien();
} else {
    if ($div == "li_fichiers" . $numfichier) {
        $supPara = new Paragraphe();
        $supPara->numparafichier = $numparafichier;
        $supPara->enleverFichier();
    } else {
        if ($div == "li_photos" . $numphoto) {
            $supPara = new Paragraphe();
            $supPara->numphoto = $numphoto;
            $supPara->numparaphoto = $numparaphoto;
            $supPara->enleverPhoto();
        } else {
            if ($div == "li_videos" . $numvideo) {
Example #7
0
 $newActu->titrePara = $textTitre;
 $newActu->contenuPara = $textCont;
 $newActu->accueil = $radioAccueil;
 $newActu->date_actu = $textDate;
 if (!$numpara) {
     $numpara = $newActu->creerParagraphe();
     $newActu->creerActu();
     $cree = 1;
 } else {
     $newActu->numpara = $numpara;
     $newActu->modifierParagraphe();
     $newActu->modifierActu();
 }
 //Le lien
 if ($textUrlLien) {
     $newLien = new Lien();
     $newLien->numpara = $numpara;
     $newLien->libLien = $textLibLien;
     $newLien->texteLien = $textTexteLien;
     $newLien->urlLien = $textUrlLien;
     $newLien->fenLien = $radioFen;
     $newLien->creerLien();
 }
 // La vignette
 if ($selectPhoto || isset($_FILES["filePhoto"]['tmp_name']) && $_FILES["filePhoto"]['tmp_name'] != "") {
     if ($selectPhoto) {
         // on associe une photo existante
         $newActu->numphoto = $selectPhoto;
         $newActu->legPhoto = $textLegPh;
         $newActu->associerPhoto();
     } else {