@foreach ($data as $shift)
@php
$tTarget = $shift->hourly->sum('target');
$tActual = $shift->hourly->sum('actual');
$tDmg = $shift->hourly->sum('damaged_quantity');
$tDown = $shift->hourly->sum('downtime');
$eff = $tTarget > 0 ? round(($tActual / $tTarget) * 100, 2) : 0;
$rmSand = $shift->raw_material->sum('sand');
$rmStone = $shift->raw_material->sum('stone');
$rmFiber = $shift->raw_material->sum('fiber');
$rmDust = $shift->raw_material->sum('f_dust');
$rmTotal = $rmSand + $rmStone + $rmFiber + $rmDust;
$reqReqBal = $shift->rm_requirement->sum('req_balance');
$reqUsed = $shift->rm_requirement->sum('used_kg');
$reqBal = $reqReqBal - $reqUsed;
@endphp
| Shipment |
{{ $shift->shipment ?? '-' }} |
| Customer Order |
{{ $shift->customer_order_id ?? '-' }} |
| Shift |
{{ $shift->shift ?? '-' }} |
| Factory |
{{ $shift->factory ?? '-' }} |
| Out Side Factory |
{{ $shift->outside_factory ?? '-' }} |
| Order Quantity |
{{ $shift->order_quantity ?? 0 }} |
| Complete Quantity |
{{ $shift->complete_quantity ?? 0 }} |
| Supervisor |
{{ $shift->supervisor ?? '-' }} |
| Line Leader |
{{ $shift->line_leader ?? '-' }} |
| Time |
Target |
Actual |
D.Qty |
Down (Min) |
@foreach ($shift->hourly as $row)
| {{ $row->time_slot }} |
{{ $row->target }} |
{{ $row->actual }} |
{{ $row->damaged_quantity }} |
{{ $row->downtime }} |
@endforeach
| Total |
{{ $tTarget }} |
{{ $tActual }} |
{{ $tDmg }} |
{{ $tDown }} |
| % |
Efficiency : {{ $eff }}%
|
| Down Time |
| Down Time |
{{ $tDown }} Min |
| Workers - Siever Section |
| Male |
{{ $shift->no_of_mele_workers ?? 0 }} |
| Female |
{{ $shift->no_of_female_workers ?? 0 }} |
| RM Wa |
Sand |
Stone |
Fiber |
F.Dust |
Total |
@foreach ($shift->raw_material as $rm)
@php
$rowTotal = $rm->sand + $rm->stone + $rm->fiber + $rm->f_dust;
@endphp
| {{ $rm->rm_wa }} |
{{ $rm->sand }} |
{{ $rm->stone }} |
{{ $rm->fiber }} |
{{ $rm->f_dust }} |
{{ $rowTotal }} |
@endforeach
| Total |
{{ $rmSand }} |
{{ $rmStone }} |
{{ $rmFiber }} |
{{ $rmDust }} |
{{ $rmTotal }} |
| Rm Req |
Req Balance |
Used Kg |
Balance |
@foreach ($shift->rm_requirement as $req)
@php
$bal = $req->req_balance - $req->used_kg;
@endphp
| {{ $req->rm_req }} |
{{ $req->req_balance }} |
{{ $req->used_kg }} |
{{ $bal }} |
@endforeach
| Total |
{{ $reqReqBal }} |
{{ $reqUsed }} |
{{ $reqBal }} |
|
Pro . Supervisor
|
Factory Manager
|
@endforeach