/**
* Update the specified resource in storage.
*
* @param Request $request
* @param int $id
* @return Response
*/
public function update(Request $request, $id)
{
$this->validate($request, ['name' => 'required']);
$item = Car::findOrFail($id);
$item->update($request->all() + ($request->has('domestic') ? [] : ['domestic' => 0]));
$item->saveImage($item, $request);
Flash::success("Запись - {$id} обновлена");
return redirect(route('admin.cars.index'));
}
public function affiche($id)
{
$title = "voiture";
$options = $idCategries = array();
$customers = array();
$customer = Customer::all();
foreach ($customer as $c) {
$customers[$c->id] = $c->name . ' ' . $c->last_name;
}
if (isset($id) && !empty($id)) {
$car = Car::findOrFail($id);
$options = current($car->optioncars()->lists('option_id'));
if (!empty($options)) {
$ids = implode(",", $options);
//option ID's
$prices = OptionCar::whereRaw('option_id in (' . $ids . ' ) and car_id=' . $id . ' order by option_id')->get();
foreach ($prices as $price) {
$prices_car[$price->option_id]['price'] = $price->option_price;
$prices_car[$price->option_id]['id'] = $price->id;
}
$optionsList = Option::whereRaw('id in (' . $ids . ' ) order by id')->get();
foreach ($optionsList as $option) {
$el = $option->category_id;
if (!in_array($el, $idCategries)) {
//if not exist in array
array_push($idCategries, $el);
}
}
$idCategries = implode(",", $idCategries);
$categories = Category::whereRaw('id in (' . $idCategries . ')')->get();
foreach ($categories as $cat) {
foreach ($optionsList as $option) {
if ($option['category_id'] == $cat['id']) {
$listcategories[$cat->id]['name'] = $cat->name_category;
$listcategories[$cat->id]['options'][$option->id]['name'] = $option->name;
$listcategories[$cat->id]['options'][$option->id]['description'] = $option->description;
$listcategories[$cat->id]['options'][$option->id]['price'] = $prices_car[$option->id]['price'];
$listcategories[$cat->id]['options'][$option->id]['id'] = $prices_car[$option->id]['id'];
}
}
}
return view('Cars/car-details', ['categories' => $listcategories, 'title' => $title, 'car' => $car, 'customers' => $customers]);
} else {
return view('Cars/car-details', ['categories' => null, 'car' => $car, 'title' => $title]);
}
}
}
public function show($id)
{
$car = Car::findOrFail($id);
return view('investor.assets.car.details', compact('car'));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$car = Car::findOrFail($id);
$car->delete();
return $id;
}
public function getCategoriesFront($id_car)
{
//$car=Car::where('id',$id_car)->get();
$idCategries = array();
$car = Car::findOrFail($id_car);
$options = current($car->optioncars()->lists('option_id'));
if (!empty($options)) {
$ids = implode(",", $options);
//option ID's
$prices = OptionCar::whereRaw('option_id in (' . $ids . ' ) and car_id=' . $id_car . ' order by option_id')->get();
foreach ($prices as $price) {
$prices_car[$price->option_id]['price'] = $price->option_price;
$prices_car[$price->option_id]['id'] = $price->id;
}
$optionsList = Option::whereRaw('id in (' . $ids . ' ) order by id')->get();
foreach ($optionsList as $option) {
$el = $option->category_id;
if (!in_array($el, $idCategries)) {
//if not exist in array
array_push($idCategries, $el);
}
}
$idCategries = implode(",", $idCategries);
$categories = Category::whereRaw('id in (' . $idCategries . ')')->get();
foreach ($categories as $cat) {
foreach ($optionsList as $option) {
if ($option['category_id'] == $cat['id']) {
$listcategories[$cat->id]['name'] = $cat->name_category;
$listcategories[$cat->id]['icone'] = $cat->icon;
$listcategories[$cat->id]['options'][$option->id]['name'] = $option->name;
$listcategories[$cat->id]['options'][$option->id]['description'] = $option->description;
$listcategories[$cat->id]['options'][$option->id]['price'] = $prices_car[$option->id]['price'];
$listcategories[$cat->id]['options'][$option->id]['id'] = $prices_car[$option->id]['id'];
}
}
}
return $listcategories;
}
}
