Production Shift Output Report

@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 ?? '-' }}

@foreach ($shift->hourly as $row) @endforeach
Time Target Actual D.Qty Down (Min)
{{ $row->time_slot }} {{ $row->target }} {{ $row->actual }} {{ $row->damaged_quantity }} {{ $row->downtime }}
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 }}

@foreach ($shift->raw_material as $rm) @php $rowTotal = $rm->sand + $rm->stone + $rm->fiber + $rm->f_dust; @endphp @endforeach
RM Wa Sand Stone Fiber F.Dust Total
{{ $rm->rm_wa }} {{ $rm->sand }} {{ $rm->stone }} {{ $rm->fiber }} {{ $rm->f_dust }} {{ $rowTotal }}
Total {{ $rmSand }} {{ $rmStone }} {{ $rmFiber }} {{ $rmDust }} {{ $rmTotal }}

@foreach ($shift->rm_requirement as $req) @php $bal = $req->req_balance - $req->used_kg; @endphp @endforeach
Rm Req Req Balance Used Kg Balance
{{ $req->rm_req }} {{ $req->req_balance }} {{ $req->used_kg }} {{ $bal }}
Total {{ $reqReqBal }} {{ $reqUsed }} {{ $reqBal }}

Pro . Supervisor
Factory Manager
@endforeach