public function edit($id) { $activity = Activity::find($id); $cars = Car::lists('name', 'id'); $customers = Customer::lists('name', 'id'); $locations = Location::lists('name', 'id'); $costs = null; $items = null; $ondayOtherCosts = null; if ($activity->type == "On Day") { $data = Onday::where('activity_id', '=', $id)->get()->pop(); $ondayOtherCosts = OndayOtherCost::where('onday_id', $data->id)->get(); } else { if ($activity->type == "Maintenance") { $data = Maintenance::where('activity_id', '=', $id)->get()->pop(); $costs = $activity->maintenance->items; $items = Item::lists('name', 'id')->sort(); } else { if ($activity->type == "Nil") { $data = Nil::where('activity_id', '=', $id)->get()->pop(); } } } return view('activity.edit', ['activity' => $activity, 'data' => $data, 'cars' => $cars, 'customers' => $customers, 'locations' => $locations, 'costs' => $costs, 'items' => $items, 'ondayOtherCosts' => $ondayOtherCosts]); }
public function showActivity() { Session::forget('maintenance'); $cars = Car::lists('name', 'id')->sort(); $activities = Activity::orderBy('created_at', 'desc')->take(10)->get(); return view('activity', ['cars' => $cars, 'activities' => $activities]); }
public function storeCar(Request $request) { $car = Car::create($request->all()); $investor = \Auth::user()->investor; $investor->cars()->save($car); return redirect('/investor/cars/'); }
public function run() { // $faker = Faker\Factory::create(); for ($i = 0; $i < 50; $i++) { Car::create(['reg_no' => strtoupper(str_random(3)) . "-" . strtoupper(str_random(3)), 'make' => $faker->colorName, 'investor_id' => $faker->biasedNumberBetween(1, 10), 'available_since' => $faker->date('d-m-Y'), 'comments' => '']); } }
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() { DB::table('cars')->delete(); for ($i = 0; $i < count($this->items); $i++) { $row = array_combine(['id', 'domestic', 'name', 'image'], $this->items[$i]); Car::create($row); } }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $item = Inquiry::with('carinfo')->findOrFail($id); $cars = Car::lists('name', 'id')->all(); $cities = City::lists('name', 'id')->all(); foreach (config('vars.car_info.color') as $key => $value) { $colors[$key] = $value['name']; } return view('admin.inquiries.edit', compact('item', 'cars', 'cities', 'colors')); }
/** * 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 static function updateCar($request, $id) { if ($id && $request) { DB::transaction(function () use($request, $id) { $Car = Car::find($id); $Car->price = $request->input('price'); $Car->save(); $CarModel = CarModel::find($Car->model_id); $CarModel->name = $request->input('model.name'); $CarModel->save(); $CarMake = CarMake::find($Car->make_id); $CarMake->name = $request->input('make.name'); $CarMake->save(); }); return TRUE; } else { return FALSE; } }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // //dd($this->User()->id); $cars = array(); $models = array(); $car = Car::all(); $title = "Ajout Disponibilité"; foreach ($car as $c) { $cars[$c->id] = $c->model; } $model = Modele::all(); foreach ($model as $m) { $models[$m->id] = $m->name; } $date = \Carbon\Carbon::today(); $date = $date->format('Y-m-d'); return view('TestDrives/disponibility-test-drive', ['title' => $title, 'cars' => $cars, 'date' => $date, 'models' => $models]); }
public function run() { //luxury DB::table('cars')->delete(); Car::create(array('manufacturer' => 'Ford', 'model' => 'Mustang', 'year' => '2015', 'type' => 'Luxury', 'mileage' => '50000')); Car::create(array('manufacturer' => 'Bugatti', 'model' => 'Veyron 16.4', 'year' => '2015', 'type' => 'Luxury', 'mileage' => '30000')); Car::create(array('manufacturer' => 'Lamborghini', 'model' => 'Aventador', 'year' => '2015', 'type' => 'Luxury', 'mileage' => '20000')); Car::create(array('manufacturer' => 'Tesla', 'model' => 'Model X', 'year' => '2015', 'type' => 'Luxury', 'mileage' => '10000')); //standard Car::create(array('manufacturer' => 'Ford', 'model' => 'Escape', 'year' => '2015', 'type' => 'Standard', 'mileage' => '60000')); Car::create(array('manufacturer' => 'Kia', 'model' => 'Optima', 'year' => '2015', 'type' => 'Standard', 'mileage' => '40000')); Car::create(array('manufacturer' => 'Mitsubishi', 'model' => 'Lancer', 'year' => '2015', 'type' => 'Standard', 'mileage' => '20000')); Car::create(array('manufacturer' => 'Chevrolet', 'model' => 'Malibu', 'year' => '2015', 'type' => 'Standard', 'mileage' => '50000')); //compact Car::create(array('manufacturer' => 'Kia', 'model' => 'Soul', 'year' => '2015', 'type' => 'Compact', 'mileage' => '10000')); Car::create(array('manufacturer' => 'Honda', 'model' => 'Fit', 'year' => '2015', 'type' => 'Compact', 'mileage' => '30000')); Car::create(array('manufacturer' => 'Ford', 'model' => 'Fiesta', 'year' => '2015', 'type' => 'Compact', 'mileage' => '40000')); Car::create(array('manufacturer' => 'Toyota', 'model' => 'Yaris', 'year' => '2015', 'type' => 'Compact', 'mileage' => '60000')); }
public function homepage() { $user = Auth::user() ?: false; $cars = Car::with('inquiriesCount')->orderBy('domestic', 'asc')->orderBy('name')->get(); $cars1 = $cars->filter(function ($item) { return $item->name == "ВАЗ"; }); $cars2 = $cars->filter(function ($item) { return $item->name != "ВАЗ"; }); $cars = $cars1->merge($cars2); $carsList = $cars->lists('name', 'id')->toArray(); $lastInquiries = Inquiry::with('car', 'city')->orderBy('created_at', 'desc')->paginate(config('vars.inquiries_per_page')); $lastInquiries->setPath('inquiry/index'); Carbon::setLocale(config('app.locale')); $lastNews = News::orderBy('published_at', 'desc')->paginate(config('vars.news_per_page')); $lastNews->setPath('news/index'); $cities = City::lists('name', 'id')->all(); $blocks = Block::all()->keyBy('alias'); $faq = Faq::all(); return view('homepage', compact('user', 'cars', 'carsList', 'lastInquiries', 'lastNews', 'cities', 'blocks', 'faq')); }
public function create(Request $request) { Car::create(['mark' => $request->mark, 'model' => $request->model, 'year' => $request->year, 'register_number' => $request->register_number, 'color' => $request->color, 'sts' => $request->sts, 'status' => 'free', 'user_id' => Auth::user()->id]); return redirect('cars/all'); }
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 destroy($id) { $car = Car::find($id); $car->delete(); return redirect(route('carList')); }
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 the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request, $id) { return DB::transaction(function () use($request, $id) { $update_travel = Travel::find($id); if ($update_travel->status != 1) { return response()->json(['status'], 403); } $update_travel->car_id = intval(Input::get('car_id')); $update_travel->reason = Input::get('reason'); $update_travel->observations = Input::get('observations'); $update_travel->travel_date = Carbon::createFromFormat('d/m/Y', Input::get('date')); $update_travel->total_distance = floatval(Input::get('total_distance')); $performance = Car::find($update_travel->car_id)->value('km_liter'); $update_travel->estimate_cost = $update_travel->total_distance / $performance * Gas::all()->first()->price; $update_travel->save(); foreach ($update_travel->travelDetails as $detail) { $detail->delete(); } $routes = Input::get('routes'); foreach ($routes as $route) { $new_detail = new TravelDetail(); $new_detail->travel_id = $update_travel->id; $new_detail->route_id = $route['id']; $new_detail->save(); } $request->session()->flash('success_msg', 'Viaje #' . $id . ' actualizado exitosamente. Notifique al contador para la autorización!'); return response()->json(['ok'], 200); }); }
/** * 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 show_devis() { $title = 'Devis'; $quotations = Quotation::all(); $cars = Car::all(); $customers = Customer::all(); /* return view('Mail/mail_devis',[ 'finition'=>$request->finition, 'basic_price'=>$request->basic_price, 'tva'=>$request->tva, 'frais_imm'=>$request->frais_imm, 'tme'=>$request->tme, 'frais_timbre'=>$request->frais_timbre, 'prix_tot'=>$request->prix_total_voiture, 'options'=>$options, 'prix_options'=>$request->prix_options, 'name'=>$customer->name, 'last_name'=>$customer->last_name, 'datetime'=>$datetime] );*/ }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy(Car $car) { if ($car->repairs->count() == 0) { $car->delete(); return Redirect::route('cars.index')->with('message', 'Car deleted'); } return Redirect::route('cars.index')->with('message', 'Car NOT deleted; delete the associated cars first'); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $ot = Ot::find($id); $ot_detail = OtDetail::where('ot_id', $id)->get(); $report = Report::where('ot_id', $id)->get(); $requester = Requester::find($ot->requester_id); $ot->requester_id = $requester->name; if ($report[0]->user_id != 0) { $user = User::find($report[0]->user_id); $report[0]->user_id = $user->name; } else { $report[0]->user_id = "No ingresado"; } $report[0]->status = Report::$statuses[$report[0]->status]; if ($ot->group_id != 0) { $group = Group::find($ot->group_id); $ot->group_id = $group->name; } else { $ot->group_id = "No ingresado"; } if ($ot->car_id != 0) { $car = Car::find($ot->car_id); $ot->car_id = $car->name; } else { $ot->car_id = "No ingresado"; } if ($ot->driver_user_id != 0) { $driver = User::find($ot->driver_user_id); $ot->driver_user_id = $driver->name; } else { $ot->driver_user_id = "No ingresado"; } if ($ot_detail[0]->allowance_id != 0) { $allowance = Allowance::find($ot_detail[0]->allowance_id); $ot_detail[0]->allowance_id = $allowance->name; } else { $ot_detail[0]->allowance_id = "No ingresado"; } if ($ot->type == 1) { $ot->status = Ot::$statusesDt[$ot->status]; if ($ot_detail[0]->ingdt_user_id != 0) { $ingdt_user_id = User::find($ot_detail[0]->ingdt_user_id); $ot_detail[0]->ingdt_user_id = $ingdt_user_id->name; } else { $ot_detail[0]->ingdt_user_id = "No ingresado"; } if ($ot_detail[0]->ingdt_user_id != 0) { $ingdt_user_id = User::find($ot_detail[0]->ingdt_user_id); $ot_detail[0]->ingdt_user_id = $ingdt_user_id->name; } else { $ot_detail[0]->ingdt_user_id = "No ingresado"; } $ot_detail[0]->detail_type = Ot::$typeDt[$ot_detail[0]->detail_type]; } return json_encode(array('ot' => $ot, 'ot_detail' => $ot_detail, 'report' => $report)); }
public function receipt($id) { if (Auth::check()) { $rental = Rental::find($id); $car = Car::find($rental->car_id); return view('history.receipt', compact('rental', 'car')); } else { return Redirect::to('/'); } }
public function makeCar(MakeCarRequest $request) { $car = new Car(); $car->name = Input::get('name'); $car->description = Input::get('description'); $car->image = Input::get('image'); $car->speed = Input::get('speed'); $car->armor = Input::get('armor'); $car->value = Input::get('value'); $car->price = Input::get('price'); $car->save(); return redirect('/admin'); }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $item = Carmodel::findOrFail($id); $cars = Car::orderBy('name')->get()->lists('name', 'id')->all(); return view('admin.carmodels.edit', compact('item', 'cars')); }
public function processMonthlyCostRevenue(Request $request) { $trucks = Car::lists('name'); $truck_list = array(); foreach ($trucks as $truck) { array_push($truck_list, $truck); } $revenue = array(); $activities = $this->getActivityOfOneMonth($request->input('month'), $request->input('year')); $costs = array(); foreach ($trucks as $truck) { array_push($costs, 0); } foreach ($trucks as $truck) { array_push($revenue, 0); } foreach ($activities as $activity) { $key = array_search($activity->car->name, $truck_list); $costs[$key] = $costs[$key] + $activity->cost; $revenue[$key] = $revenue[$key] + $activity->fare; } $date = $this->getDateString($request); if ($request->type == "api_call") { return response()->json(['trucks' => $trucks, 'costs' => $costs, 'revenue' => $revenue, 'date' => $date]); } else { return view('report.index', ['trucks' => $trucks, 'costs' => $costs, 'revenue' => $revenue, 'date' => $date]); } }
/** * car rental history * @param $id * @param Request $request * @return \Illuminate\Http\JsonResponse */ public function histories($id, Request $request) { //valdate month $this->validate($request, ['month' => 'required|date_format:m-Y']); //get rental history $histories = Car::with(['histories' => function ($query) use($request) { $monthyear = explode('-', $request->input('month')); $query->join('client', 'client.id', '=', 'rental.client-id')->whereRaw('(EXTRACT(MONTH FROM "date-from") = \'' . $monthyear[0] . '\' AND EXTRACT(YEAR FROM "date-from") = \'' . $monthyear[1] . '\') OR (EXTRACT(MONTH FROM "date-to") = \'' . $monthyear[0] . '\' AND EXTRACT(YEAR FROM "date-to") = \'' . $monthyear[1] . '\')')->select('car-id', 'client.name AS rent-by', 'date-from', 'date-to'); }])->find($id); if ($histories == null) { $histories = ['error' => 'Car data not found']; } return response()->json($histories); }
public function destroy($id) { $car = Car::find($id); $car->delete(); return redirect('cars'); }
public function form($id, Request $request) { $item = Inquiry::with('carinfo')->findOrFail($id); $cars = Car::lists('name', 'id')->all(); $cities = City::lists('name', 'id')->all(); foreach (config('vars.car_info.color') as $key => $value) { $colors[$key] = $value['name']; } return view('partials._inquiry_form', compact('item', 'cars', 'cities', 'colors')); }
public function update(Request $request) { $car = Car::find($request->input('id')); $car->reg_no = $request->input('reg_no'); $car->make = $request->input('make'); $dt_avail = new Carbon($request->input('available_since')); $car->available_since = $dt_avail->format("d-m-Y"); $car->comments = $request->input('comments'); $car->save(); return redirect(url('/investor/cars/' . $car->id)); }
/** * Update a car * * @param $id, $request * @return update result */ public function update($id, $request) { return Car::where('id', $id)->update($request); }