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]);
}
/**
* 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'));
}
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]);
}
}
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 static function getActivityOfOneMonth($month, $year)
{
$date = Carbon::create($year, $month, 1, 0);
$initial_date = $date->toDateString();
$last_date = $date->addMonth()->subDay()->toDateString();
$trucks = Car::lists('name');
$activities = Activity::where('date', '>=', $initial_date)->where('date', '<=', $last_date)->get();
return $activities;
}
