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