Result {{ $title_menu }}

{{-- Calculate totals --}} @php // Initialize totals for before upgrade $totalRollBefore = 0; $totalWeightBefore = 0; $totalOffGradeBefore = 0; // Initialize total off grade for before upgrade // Calculate totals for before upgrade foreach ($beforeUpgrade as $rowBefore) { $totalRollBefore += $rowBefore->batch; // Assuming batch represents roll $totalWeightBefore += $rowBefore->quantity; // Assuming quantity is weight $totalOffGradeBefore += $rowBefore->quantity; // Total off grade } // Initialize totals for after upgrade $totalRollAfter = 0; $totalWeightAfter = 0; $totalOffGradeAfter = 0; // Initialize total off grade for after upgrade // Calculate totals for after upgrade foreach ($afterUpgrade as $rowAfter) { $totalRollAfter += $rowAfter->batch; // Assuming batch represents roll $totalWeightAfter += $rowAfter->quantity; // Assuming quantity is weight $totalOffGradeAfter += $rowAfter->quantity; // Total off grade } // Initialize totals for Quality Control $totalRollQC = 0; $totalWeightQC = 0; $totalOffGradeQC = 0; // Initialize total off grade for Quality Control // Calculate totals for Quality Control foreach ($upgradeByQC as $qcItem) { $totalRollQC += $qcItem->batch; // Assuming batch represents roll $totalWeightQC += $qcItem->quantity; // Assuming quantity is weight $totalOffGradeQC += $qcItem->quantity; // Total off grade } // Initialize totals for Production $totalRollProduksi = 0; $totalWeightProduksi = 0; $totalOffGradeProduksi = 0; // Initialize total off grade for Production // Calculate totals for Production foreach ($upgradeByProduksi as $produksiItem) { $totalRollProduksi += $produksiItem->batch; // Assuming batch represents roll $totalWeightProduksi += $produksiItem->quantity; // Assuming quantity is weight $totalOffGradeProduksi += $produksiItem->quantity; // Total off grade } // Initialize totals for Marketing $totalRollMarketing = 0; $totalWeightMarketing = 0; $totalOffGradeMarketing = 0; // Initialize total off grade for Marketing // Calculate totals for Marketing foreach ($upgradeByMarketing as $marketingItem) { $totalRollMarketing += $marketingItem->batch; // Assuming batch represents roll $totalWeightMarketing += $marketingItem->quantity; // Assuming quantity is weight $totalOffGradeMarketing += $marketingItem->quantity; // Total off grade } @endphp {{-- Blade table integration --}}

{{-- Check result data --}} @if ($table_result) @php // Reset for accumulated total percentage weights $totalPercentageWeightBefore = 0; $totalPercentageWeightAfter = 0; $totalPercentageWeightQC = 0; $totalPercentageWeightProduksi = 0; $totalPercentageWeightMarketing = 0; @endphp @foreach ($beforeUpgrade as $index => $rowBefore) @php // Calculate percentage weight before upgrade $percentageWeightBefore = $totalOffGradeBefore > 0 ? ($rowBefore->quantity / $totalOffGradeBefore) * 100 : 0; $totalPercentageWeightBefore += $percentageWeightBefore; @endphp {{-- After Upgrade Data --}} @php $afterBatch = $afterQuantity = $percentageWeightAfter = 0; if ( isset($afterUpgrade[$index]) && $beforeUpgrade[$index]->remark == $afterUpgrade[$index]->remark ) { $afterBatch = $afterUpgrade[$index]->batch; $afterQuantity = $afterUpgrade[$index]->quantity; $percentageWeightAfter = $totalOffGradeAfter > 0 ? ($afterQuantity / $totalOffGradeAfter) * 100 : 0; $totalPercentageWeightAfter += $percentageWeightAfter; } @endphp {{-- Quality Control Data --}} @php $qualityControlBatchCount = $qualityControlQuantity = 0; foreach ($upgradeByQC as $qcItem) { if ($qcItem->remark == $rowBefore->remark) { $qualityControlBatchCount = $qcItem->batch; $qualityControlQuantity = $qcItem->quantity; break; } } $qualityControlPercentage = $totalOffGradeQC > 0 ? ($qualityControlQuantity / $totalOffGradeQC) * 100 : 0; $totalPercentageWeightQC += $qualityControlPercentage; @endphp {{-- Production Data --}} @php $produksiBatchCount = $produksiQuantity = 0; foreach ($upgradeByProduksi as $produksiItem) { if ($produksiItem->remark == $rowBefore->remark) { $produksiBatchCount = $produksiItem->batch; $produksiQuantity = $produksiItem->quantity; break; } } $produksiPercentage = $totalOffGradeProduksi > 0 ? ($produksiQuantity / $totalOffGradeProduksi) * 100 : 0; $totalPercentageWeightProduksi += $produksiPercentage; @endphp {{-- Marketing Data --}} @php $marketingBatchCount = $marketingQuantity = 0; foreach ($upgradeByMarketing as $marketingItem) { if ($marketingItem->remark == $rowBefore->remark) { $marketingBatchCount = $marketingItem->batch; $marketingQuantity = $marketingItem->quantity; break; } } $marketingPercentage = $totalOffGradeMarketing > 0 ? ($marketingQuantity / $totalOffGradeMarketing) * 100 : 0; $totalPercentageWeightMarketing += $marketingPercentage; @endphp @endforeach @php // Calculate % Off Grade For Before Upgrade Section $totalOffGradeWeight = $totalWeightBefore; // Total off grade weight $totalProduksiWeight = $total_weight; // Total production weight $percentageOffGrade = $totalProduksiWeight > 0 ? ($totalOffGradeWeight / $totalProduksiWeight) * 100 : 0; @endphp @php // Calculate % Off Grade For After Upgrade Section $totalOffGradeWeight = $totalWeightAfter; // Total off grade weight $totalProduksiWeight = $total_weight; // Total production weight $percentageOffGrade = $totalProduksiWeight > 0 ? ($totalOffGradeWeight / $totalProduksiWeight) * 100 : 0; @endphp @else {{-- Update colspan to match total columns --}} @endif

Resume Off Grade (all) - {{ $nama_filter }} - {{ $period }}
No	Remark	Before Upgrade			After Upgrade			Upgrade by
		Before Upgrade			After Upgrade			Quality Control			Produksi			Marketing
		Roll	Weight (kg)	% Weight	Roll	Weight (kg)	% Weight	Roll	Weight (kg)	% Weight	Roll	Weight (kg)	% Weight	Roll	Weight (kg)	% Weight
{{ $index + 1 }}	{{ $rowBefore->remark }}	{{ $rowBefore->batch }}	{{ number_format($rowBefore->quantity, 1) }}	{{ number_format($percentageWeightBefore, 2) }}%	{{ $afterBatch }}	{{ number_format($afterQuantity, 1) }}	{{ number_format($percentageWeightAfter, 2) }}%	{{ $qualityControlBatchCount }}	{{ number_format($qualityControlQuantity, 1) }}	{{ number_format($qualityControlPercentage, 2) }}%	{{ $produksiBatchCount }}	{{ number_format($produksiQuantity, 1) }}	{{ number_format($produksiPercentage, 2) }}%	{{ $marketingBatchCount }}	{{ number_format($marketingQuantity, 1) }}	{{ number_format($marketingPercentage, 2) }}%
Total Off Grade		{{ $totalRollBefore }}	{{ number_format($totalWeightBefore, 1) }}	{{ number_format($totalPercentageWeightBefore, 2) }}%	{{ $totalRollAfter }}	{{ number_format($totalWeightAfter, 1) }}	{{ number_format($totalPercentageWeightAfter, 2) }}%	{{ $totalRollQC }}	{{ number_format($totalWeightQC, 1) }}	{{ number_format($totalPercentageWeightQC, 2) }}%	{{ $totalRollProduksi }}	{{ number_format($totalWeightProduksi, 1) }}	{{ number_format($totalPercentageWeightProduksi, 2) }}%	{{ $totalRollMarketing }}	{{ number_format($totalWeightMarketing, 1) }}	{{ number_format($totalPercentageWeightMarketing, 2) }}%
Total Produksi		{{ number_format($total_produksi) }}	{{ number_format($total_weight, 1) }}		{{ number_format($total_produksi) }}	{{ number_format($total_weight, 1) }}
% Off Grade			{{ number_format($percentageOffGrade, 2) }}%			{{ number_format($percentageOffGrade, 2) }}%
Data not found!

{{-- Check result data --}} @if ($table_result) @foreach ($detailReport1 as $index => $row) @endforeach @else @endif

Detail - {{ $period }}
Remark	Item	Customer Name	Qty (pcs)	Qty (kg)
{{ $row->remark }}	{{ $row->item }}	{{ $row->name }}	{{ $row->qty_pcs }}	{{ number_format($row->qty_kg, 1) }}
Data not found!