public function rentSpecific($type) { if (Auth::check()) { //get cars of specific type $sectionArray = array(); if ($type == "Luxury") { $cars = Car::where('type', '=', "Luxury")->get(); array_push($sectionArray, "Luxury"); } else { if ($type == "Standard") { $cars = Car::where('type', '=', "Standard")->get(); array_push($sectionArray, "Standard"); } else { if ($type == "Compact") { $cars = Car::where('type', '=', "Compact")->get(); array_push($sectionArray, "Compact"); } else { return Redirect::to('/'); } } } return view('rental.index', compact('cars', 'sectionArray')); } else { return Redirect::to('/'); } }
/** * Responds to requests to GET /cars */ public function getIndex(Request $request) { # Get all the cars "owned" by the current logged in user # Sort in descending order by id $cars = \App\Car::where('user_id', '=', \Auth::id())->orderBy('id', 'DESC')->get(); return view('cars.index')->with('cars', $cars); }
public function updateCar(Request $request, $id) { if ($id) { Car::where('id', $id)->update(['model_id' => $request->input('model_id'), 'make_id' => $request->input('make_id'), 'price' => $request->input('price')]); return response()->json(array("status" => "success", "code" => "update"), 200); } return response()->json(array("status" => "error", "code" => "update"), 404); }
/** * Run the database seeds. * * @return void */ public function run() { $cars = ['GS450h' => ['Sedan', 'Luxury', 'Hybrid'], 'Grand Cherokee' => ['SUV', 'Premium'], 'Accord Hybrid' => ['Sedan', 'Hybrid'], 'IS 350' => ['Sedan'], 'Prius v' => ['Sedan', 'Hybrid'], 'Mirai' => ['Sedan', 'Fuel Cell'], 'Fit' => ['Sedan'], 'B-Class' => ['Sedan', 'Hybrid'], 'Tucson EV' => ['SUV', 'Fuel Cell']]; # For each car, insert into it its tags from above foreach ($cars as $model => $tags) { $car = \App\Car::where('model', 'like', $model)->first(); foreach ($tags as $tagName) { $tag = \App\Tag::where('name', 'LIKE', $tagName)->first(); $car->tags()->save($tag); } } }
public function update(Request $request, $id) { // $car = Car::find($id); $imgs = $car->picture; $icone = $car->icon_finition; if (Input::hasFile('picture')) { $tab = json_decode($imgs); foreach ($tab as $t) { unlink(base_path("uploads/" . $t)); } $images = Input::file('picture'); $imgs = json_encode($this->getNewImg($images)); $this->updateManifest(); } if (Input::hasFile('icon_finition')) { unlink(base_path("uploads/" . $icone)); $images = Input::file('icon_finition'); $imgs = json_encode($this->getNewImg($images)); $this->updateManifest(); } Car::where('id', $id)->update(['finition' => $request->finition, 'icon_finition' => $icone, 'description' => $request->description, 'consommation' => $request->consommation, 'picture' => $imgs, 'video' => $request->video, 'basic_price' => $request->basic_price, 'test_drive' => $request->test_drive]); $tab_new_options = $request->tab_option; $tab_old_options = $request->tab_old_option; if (!empty($tab_new_options)) { $options = explode('-', $tab_new_options); //--ADD TO PRICE TABLE foreach ($options as $option) { if ($option != '0' && is_numeric(intval($option))) { $v = intval($option); $new_price = 'price-' . $option; if (isset($request->{$new_price})) { DB::insert('insert into option_cars (car_id,option_id,option_price) values (?,?,?)', [$id, $v, $request->{$new_price}]); } } } } if (!empty($tab_old_options)) { $options = explode('-', $tab_old_options); //--ADD TO PRICE TABLE foreach ($options as $option) { if ($option != '0' && is_numeric(intval($option))) { $v = intval($option); $new_price = 'price-' . $option; if (isset($request->{$new_price})) { OptionCar::where('car_id', $id)->where('option_id', $option)->update(['option_price' => $request->{$new_price}]); } } } } return redirect(route('carEdit', $id)); }
/** * Show the form for creating a new resource. * * @return Response */ public function form($type) { $requesters = Requester::all(); $allowances = Allowance::all(); $drivers = User::where('user_type_id', 4)->get(); $cars = Car::where('status', 3)->get(); if ($type == 1) { $uDts = User::where('user_type_id', 1)->get(); $match = ['user_type_id' => 1, 'subtype' => 3]; $uReport = User::where($match)->get(); $gDts = Group::where('type', 1)->get(); return view('admin.ots.formdt', compact('requesters', 'allowances', 'uDts', 'gDts', 'uReport', 'drivers', 'cars')); } elseif ($type == 2) { $gAsrs = Group::where('type', 2)->get(); $uAsrs = User::where('user_type_id', 2)->get(); return view('admin.ots.formAsr', compact('requesters', 'allowances', 'uAsrs', 'gAsrs', 'drivers', 'cars', 'jefe')); } elseif ($type == 3) { $uDts = User::where('user_type_id', 1)->get(); $match = ['user_type_id' => 1, 'subtype' => 3]; $uReport = User::where($match)->get(); $gDts = Group::where('type', 1)->get(); return view('admin.ots.formBch', compact('requesters', 'allowances', 'uDts', 'gDts', 'uReport', 'drivers', 'cars')); } }
public function getCar() { $query = Input::get('name'); $searchValues = preg_split('/\\s+/', $query); // split on 1+ whitespace $res = Car::where(function ($q) use($searchValues) { foreach ($searchValues as $value) { $q->orWhere('brand', 'like', "%{$value}%")->orWhere('plates', 'like', "%{$value}%")->orWhere('description', 'like', "%{$value}%"); } })->get(); return response()->json($res); }
public function purchaseCar() { $user = Auth::user(); $radioButton = Input::get('radio'); if ($radioButton == 'Nissan Micra') { $car = Car::where('name', '=', 'Nissan Micra')->first(); if ($user->money >= $car->price) { $user->money -= $car->price; $user->assignCar($car); $user->save(); session()->flash('flash_message', 'You bought the item!'); return redirect('/shop'); } else { session()->flash('flash_message_important', 'Not Enough Money!'); return redirect('/shop'); } } elseif ($radioButton == 'Peugeot 107') { $car = Car::where('name', '=', 'Peugeot 107')->first(); if ($user->money >= $car->price) { $user->money -= $car->price; $user->assignCar($car); $user->save(); session()->flash('flash_message', 'You bought the item!'); return redirect('/shop'); } else { session()->flash('flash_message_important', 'Not Enough Money!'); return redirect('/shop'); } } elseif ($radioButton == 'Fiat Punto') { $car = Car::where('name', '=', 'Fiat Punto')->first(); if ($user->money >= $car->price) { $user->money -= $car->price; $user->assignCar($car); $user->save(); session()->flash('flash_message', 'You bought the item!'); return redirect('/shop'); } else { session()->flash('flash_message_important', 'Not Enough Money!'); return redirect('/shop'); } } elseif ($radioButton == 'Mini Cooper S') { $car = Car::where('name', '=', 'Mini Cooper S')->first(); if ($user->money >= $car->price) { $user->money -= $car->price; $user->assignCar($car); $user->save(); session()->flash('flash_message', 'You bought the item!'); return redirect('/shop'); } else { session()->flash('flash_message_important', 'Not Enough Money!'); return redirect('/shop'); } } elseif ($radioButton == 'Vauxhall Insignia') { $car = Car::where('name', '=', 'Vauxhall Insignia')->first(); if ($user->money >= $car->price) { $user->money -= $car->price; $user->assignCar($car); $user->save(); session()->flash('flash_message', 'You bought the item!'); return redirect('/shop'); } else { session()->flash('flash_message_important', 'Not Enough Money!'); return redirect('/shop'); } } elseif ($radioButton == 'Audi A3') { $car = Car::where('name', '=', 'Audi A3')->first(); if ($user->money >= $car->price) { $user->money -= $car->price; $user->assignCar($car); $user->save(); session()->flash('flash_message', 'You bought the item!'); return redirect('/shop'); } else { session()->flash('flash_message_important', 'Not Enough Money!'); return redirect('/shop'); } } elseif ($radioButton == 'BMW 1 Series M Sport') { $car = Car::where('name', '=', 'BMW 1 Series M Sport')->first(); if ($user->money >= $car->price) { $user->money -= $car->price; $user->assignCar($car); $user->save(); session()->flash('flash_message', 'You bought the item!'); return redirect('/shop'); } else { session()->flash('flash_message_important', 'Not Enough Money!'); return redirect('/shop'); } } elseif ($radioButton == 'Audi RS7') { $car = Car::where('name', '=', 'Audi RS7')->first(); if ($user->money >= $car->price) { $user->money -= $car->price; $user->assignCar($car); $user->save(); session()->flash('flash_message', 'You bought the item!'); return redirect('/shop'); } else { session()->flash('flash_message_important', 'Not Enough Money!'); return redirect('/shop'); } } elseif ($radioButton == 'Ferrari 599 GTB Fiorano') { $car = Car::where('name', '=', 'Ferrari 599 GTB Fiorano')->first(); if ($user->money >= $car->price) { $user->money -= $car->price; $user->assignCar($car); $user->save(); session()->flash('flash_message', 'You bought the item!'); return redirect('/shop'); } else { session()->flash('flash_message_important', 'Not Enough Money!'); return redirect('/shop'); } } elseif ($radioButton == 'Mercedes-Benz SLR McLaren') { $car = Car::where('name', '=', 'Mercedes-Benz SLR McLaren')->first(); if ($user->money >= $car->price) { $user->money -= $car->price; $user->assignCar($car); $user->save(); session()->flash('flash_message', 'You bought the item!'); return redirect('/shop'); } else { session()->flash('flash_message_important', 'Not Enough Money!'); return redirect('/shop'); } } elseif ($radioButton == 'Bugatti Veyron') { $car = Car::where('name', '=', 'Bugatti Veyron')->first(); if ($user->money >= $car->price) { $user->money -= $car->price; $user->assignCar($car); $user->save(); session()->flash('flash_message', 'You bought the item!'); return redirect('/shop'); } else { session()->flash('flash_message_important', 'Not Enough Money!'); return redirect('/shop'); } } else { session()->flash('flash_message_important', 'You Failed To Purchase The Item!!'); return redirect('/shop'); } }
/** * Update a car * * @param $id, $request * @return update result */ public function update($id, $request) { return Car::where('id', $id)->update($request); }
/** * Update the specified resource in storage. * * @param int $id * @param CarRequest $request * @return Response */ public function update($id, CarRequest $request) { $car = Car::where('id', '=', $id)->firstOrFail(); $car->update($request->all()); return redirect('car'); }
/** * -------------------------------- * Search Car by Year Model, Manufacturer Name and Manufacturer Code * -------------------------------- * URL: /cars/search/{string} * @param $str * @return mixed * */ public function search($str) { return Car::where(function ($query) use($str) { $query->where('Model_Year', 'LIKE', '%' . $str . '%')->orWhere('Vehicle_Manufacturer_Name', 'LIKE', '%' . $str . '%')->orWhere('Veh_Mfr_Code', 'LIKE', '%' . $str . '%'); })->get(); }