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 showProjectDaily($po_daily_id)
{
$projectDaily = ProjectOrderDaily::find($po_daily_id);
$po_id = $projectDaily->po_id;
$manpower = projectOrderManpower::where('po_id', $po_id)->whereDoesntHave('po_daily_manpower', function ($query) use($po_daily_id) {
$query->where('po_daily_id', '=', $po_daily_id);
})->get();
foreach ($manpower as $k => $v) {
$v->manpower = Manpower::find($v->manpower_id);
}
$projectOrderDailyManpower = projectOrderDailyManpower::where('po_daily_id', $po_daily_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;
}
$data = array("projectDaily" => $projectDaily, "manpower" => $manpower, "projectOrderDailyManpower" => $projectOrderDailyManpower, "totalExpenses" => $totalExpenses);
return view('components.project-order.project-daily', $data);
}
