@foreach($report as $row)
@php
$bal7 = $row['begin_inv'];
for($d=1; $d<=7; $d++) {
$bal7 += $row['daily'][$d]['RCD'] - $row['daily'][$d]['ISS'] - $row['daily'][$d]['DISP'] + $row['daily'][$d]['ADJ'];
}
$bal14 = $bal7;
for($d=8; $d<=14; $d++) {
$bal14 += $row['daily'][$d]['RCD'] - $row['daily'][$d]['ISS'] - $row['daily'][$d]['DISP'] + $row['daily'][$d]['ADJ'];
}
$bal21 = $bal14;
for($d=15; $d<=21; $d++) {
$bal21 += $row['daily'][$d]['RCD'] - $row['daily'][$d]['ISS'] - $row['daily'][$d]['DISP'] + $row['daily'][$d]['ADJ'];
}
$sumAdj = 0;
for($d=1; $d<=31; $d++) {
$sumAdj += $row['daily'][$d]['ADJ'];
}
@endphp
{{-- RCD ROW --}}
{{ $row['item']->description }}
@if($row['item']->brand_type)
{{ $row['item']->brand_type }}
@endif
|
{{ $row['item']->unit ?? '-' }} |
{{ $row['begin_inv'] }} |
RCD |
@for($d=1; $d<=7; $d++) {{ $row['daily'][$d]['RCD'] ?: '' }} | @endfor
{{ $bal7 }} |
@for($d=8; $d<=14; $d++) {{ $row['daily'][$d]['RCD'] ?: '' }} | @endfor
{{ $bal14 }} |
@for($d=15; $d<=21; $d++) {{ $row['daily'][$d]['RCD'] ?: '' }} | @endfor
{{ $bal21 }} |
@for($d=22; $d<=31; $d++) {{ $row['daily'][$d]['RCD'] ?: '' }} | @endfor
{{ $sumAdj ?: '' }} |
{{ $row['end_inv'] }} |
{{-- ISS ROW --}}
| ISS |
@for($d=1; $d<=7; $d++) {{ $row['daily'][$d]['ISS'] ?: '' }} | @endfor
@for($d=8; $d<=14; $d++) {{ $row['daily'][$d]['ISS'] ?: '' }} | @endfor
@for($d=15; $d<=21; $d++) {{ $row['daily'][$d]['ISS'] ?: '' }} | @endfor
@for($d=22; $d<=31; $d++) {{ $row['daily'][$d]['ISS'] ?: '' }} | @endfor
{{-- DISP ROW --}}
| DISP |
@for($d=1; $d<=7; $d++) {{ $row['daily'][$d]['DISP'] ?: '' }} | @endfor
@for($d=8; $d<=14; $d++) {{ $row['daily'][$d]['DISP'] ?: '' }} | @endfor
@for($d=15; $d<=21; $d++) {{ $row['daily'][$d]['DISP'] ?: '' }} | @endfor
@for($d=22; $d<=31; $d++) {{ $row['daily'][$d]['DISP'] ?: '' }} | @endfor
@endforeach