public function getTotalCost() { $projectOrderDailyManpower = projectOrderDailyManpower::where('po_daily_id', $this->id)->get(); $totalExpenses = 0; foreach ($projectOrderDailyManpower as $k => $v) { $v->manpower = Manpower::find($v->manpower_id); $time_in = ""; $time_out = ""; $total = 0; if ($v->in) { $time_in = new Carbon($v->in); $time_in = $time_in->format('h:i A'); $startTime = Carbon::parse($v->in); } if ($v->out) { $time_out = new Carbon($v->out); $time_out = $time_out->format('h:i A'); $finishTime = Carbon::parse($v->out); $total = $finishTime->diffInHours($startTime); } $v->time_in = $time_in; $v->time_out = $time_out; $v->total = $total; $v->totalCost = $total * $v->rate; $totalExpenses = $totalExpenses + $v->totalCost; } return $totalExpenses; }
public function post(Request $request) { $id = $request->input('id'); if ($id != "") { array_splice(Manpower::$validation_rules, 0, 1); } $validate = Validator::make($request->all(), Manpower::$validation_rules); if ($validate->passes()) { $employee_id = $request->input('employee_id'); $first_name = $request->input('first_name'); $last_name = $request->input('last_name'); $birthdate = $request->input('birthdate'); $address = $request->input('address'); $position = $request->input('position'); $rate = $request->input('rate'); if ($id != "") { $manpower = Manpower::find($id); } else { $manpower = new Manpower(); } $manpower->employee_id = $employee_id; $manpower->first_name = $first_name; $manpower->last_name = $last_name; $manpower->position = $position; $manpower->address = $address; $manpower->birthdate = $birthdate; $manpower->rate = $rate; if ($manpower->save()) { if ($id != "") { return redirect()->action('ManpowerController@add', $id)->with('success', 'Manpower has been successfully saved'); } else { return $this->redirect_to_manpower_add->with('success', 'Manpower has been successfully saved'); } } } else { if ($id != "") { return redirect()->action('ManpowerController@add', $id)->withErrors($validate)->withInput(); } else { return $this->redirect_to_manpower_add->withErrors($validate)->withInput(); } } }
public function assignManpowerToProjectDaily($po_daily_id, $manpower_id) { $manpower = Manpower::find($manpower_id); $po_daily_manpower = new ProjectOrderDailyManpower(); $po_daily_manpower->po_daily_id = $po_daily_id; $po_daily_manpower->manpower_id = $manpower_id; $po_daily_manpower->rate = $manpower->rate; if ($po_daily_manpower->save()) { return redirect()->action('ProjectOrderController@showProjectDaily', $po_daily_id)->with('success', 'Manpower has been successfully added'); } }