public function index()
{
$title = 'HOME';
$repository = $this->repository;
$employees = Employee::where('license_expire', '<', Carbon::now()->addDays(30))->orWhere('visa_expire', '<', Carbon::now()->addDays(30))->get();
$vehicles = Vehicles::where('registration_expire', '<', Carbon::now()->addDays(30))->get();
return view('pages.home', compact('title', 'employees', 'vehicles', 'repository'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector
*/
public function index()
{
$title = 'VEHICLES';
if (Input::has('description')) {
$description = Input::get('description');
$vehicles = Vehicles::where('brand', 'like', '%' . $description . '%')->orWhere('model', 'like', '%' . $description . '%')->orWhere('remarks', 'like', '%' . $description . '%')->paginate(10);
} elseif (Input::has('bid')) {
$bid = Input::get('bid');
$vehicles = Vehicles::where('bid', $bid)->paginate(10);
} elseif (Input::has('vendor')) {
$vendor = Input::get('vendor');
$vehicles = Vehicles::where('vendor', 'like', '%' . $vendor . '%')->paginate(10);
} elseif (Input::has('registration')) {
$registration = Input::get('registration');
$vehicles = Vehicles::where('registration', 'like', '%' . $registration . '%')->paginate(10);
} elseif (Input::has('seat')) {
$seat = Input::get('seat');
$vehicles = Vehicles::where('seat', $seat)->paginate(10);
} else {
$vehicles = Vehicles::paginate(10);
}
$repository = $this->repository;
return view('vehicle.index', compact('title', 'vehicles', 'route', 'repository'));
}
public function vehicleRegistrationExpire()
{
return Vehicles::where('registration_expire', '<', Carbon::now()->addDays(30))->count();
}
public function currentVehicle($id)
{
return Vehicles::where('cid', $id)->where('status', 'Active')->lists('registration', 'id');
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$client = Client::findOrFail($id);
$title = $client->name;
$drivers = Employee::where('cid', $id)->where('status', 'Active')->get(['name']);
$vehicles = Vehicles::where('cid', $id)->where('status', 'Active')->get(['registration']);
$repository = $this->repository;
return view('client.show', compact('title', 'client', 'status', 'repository', 'drivers', 'vehicles'));
}
