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);
}
