Report Parameters
Report Parameters
@error('selectedBranch') {{ $message }} @enderror @if($branchSearchVisible == true)
    • @if(auth()->user()->access_scope == 0) @endif @if(auth()->user()->access_scope == 1 || auth()->user()->access_scope == 0) @endif @if(auth()->user()->access_scope == 2 || auth()->user()->access_scope == 0) @endif @if(auth()->user()->access_scope == 3 || auth()->user()->access_scope == 0) @endif @foreach($branch_selection as $branch) @endforeach
@endif
@error('transaction_date') {{ $message }} @enderror
@error('selectedHour') {{ $message }} @enderror
Generating Report..
Toggle Report Parameters
Inventory Report (Detailed)
Ensaymada, Cheese Roll, and Mamon Only
Report Date: {{ date('M j, Y g:i:s a',strtotime(now()))}} Generated By: {{ auth()->user()->name}}
Coverage: {{date('M j, Y',strtotime($transaction_date))}}
*Note: Coverage date is based on Actual Date.
Red Item Code and Description means item is out of stock.
Blue Item Code and Description means item has no movement.
Ensaymada is quantified by Box of 6.
Cheese Roll is quantified by Box of 12.
Mamon is quantified by Box of 6.
Legend:
PAR - PAR Stocks BEG - Beginning Balance RD - Deliveries
PO - Pull-Outs CI - Convert In CO - Convert Out
TI - Transfer In TO - Transfer Out CD - Condemned
SOLD - Sold AOI - Advanced Order In AOO - Advanced Order Out
UM - Unmet Demand REM - Remaining PROJ - Projection
@if(empty($data))
Item Code Description PAR BEG RD PO CI CO TI TO CD SOLD AOI AOO UM REM PROJ
NO DATA
@else @foreach($branches as $b) @if($data->where('branch_id',$b->id)->count() > 0) @php $c_hour = ($data->where('branch_id',$b->id)->first())->m_hour; @endphp @foreach ($data->where('branch_id',$b->id) as $index => $d) @php $remaining = $d->m_beginning + $d->s_deliveries - $d->s_pull_outs + $d->s_convert_in - $d->s_convert_out + $d->s_transfer_in - $d->s_transfer_out - $d->s_spoilage - $d->s_sales + $d->s_advanced_order_in - $d->s_advanced_order_out; $status= ['cell', 'text-primary' => $d->m_beginning == 0 && $d->s_deliveries == 0 && $d->s_pull_outs == 0 && $d->s_convert_in == 0 && $d->s_convert_out == 0 && $d->s_transfer_out == 0 && $d->s_transfer_in == 0 && $d->s_spoilage == 0 && $d->s_sales == 0 && $d->s_advanced_order_in == 0 && $d->s_advanced_order_out == 0, 'text-danger' => $remaining <= 0 && ($d->s_deliveries <> 0 || $d->s_pull_outs <> 0 || $d->s_convert_in <> 0 || $d->s_convert_out <> 0 || $d->s_transfer_out <> 0 || $d->s_transfer_in <> 0 || $d->s_spoilage <> 0 || $d->s_sales <> 0 || $d->s_advanced_order_in <> 0 || $d->s_advanced_order_out <> 0)] @endphp @if($d->item_code == 'CR4') @else @endif @endforeach
{{ $b->branch_code}} {{ $b->branch_name}} | HOUR: {{ $c_hour.':00 - '.$c_hour.':59'}}
Item Code Description PAR BEG RD PO CI CO TI TO CD SOLD AOI AOO UM REM PROJ
{{ $d->item_code}} {{ $d->item_description}}{{ intdiv($d->s_par_stock,12).'.'.abs($d->s_par_stock%12) }} {{ intdiv($d->m_beginning,12).'.'.abs($d->m_beginning%12) }} {{ intdiv($d->s_deliveries,12).'.'.abs($d->s_deliveries%12) }} {{ intdiv($d->s_pull_outs,12).'.'.abs($d->s_pull_outs%12) }} {{ intdiv($d->s_convert_in,12).'.'.abs($d->s_convert_in%12) }} {{ intdiv($d->s_convert_out,12).'.'.abs($d->s_convert_out%12) }} {{ intdiv($d->s_transfer_in,12).'.'.abs($d->s_transfer_in%12) }} {{ intdiv($d->s_transfer_out,12).'.'.abs($d->s_transfer_out%12) }} {{ intdiv($d->s_spoilage,12).'.'.abs($d->s_spoilage%12) }} {{ intdiv($d->s_sales,12).'.'.abs($d->s_sales%12) }} {{ intdiv($d->s_advanced_order_in,12).'.'.abs($d->s_advanced_order_in%12) }} {{ intdiv($d->s_advanced_order_out,12).'.'.abs($d->s_advanced_order_out%12) }} {{ intdiv($d->s_unmet_demand,12).'.'.abs($d->s_unmet_demand%12) }} @if($remaining < 0)-@endif{{ intdiv($remaining,12).'.'.abs($remaining%12) }} {{ intdiv($d->s_par_stock - $remaining,12).'.'.abs(($d->s_par_stock - $remaining)%12) }}{{ intdiv($d->s_par_stock,6).'.'.abs($d->s_par_stock%6) }} {{ intdiv($d->m_beginning,6).'.'.abs($d->m_beginning%6) }} {{ intdiv($d->s_deliveries,6).'.'.abs($d->s_deliveries%6) }} {{ intdiv($d->s_pull_outs,6).'.'.abs($d->s_pull_outs%6) }} {{ intdiv($d->s_convert_in,6).'.'.abs($d->s_convert_in%6) }} {{ intdiv($d->s_convert_out,6).'.'.abs($d->s_convert_out%6) }} {{ intdiv($d->s_transfer_in,6).'.'.abs($d->s_transfer_in%6) }} {{ intdiv($d->s_transfer_out,6).'.'.abs($d->s_transfer_out%6) }} {{ intdiv($d->s_spoilage,6).'.'.abs($d->s_spoilage%6) }} {{ intdiv($d->s_sales,6).'.'.abs($d->s_sales%6) }} {{ intdiv($d->s_advanced_order_in,6).'.'.abs($d->s_advanced_order_in%6) }} {{ intdiv($d->s_advanced_order_out,6).'.'.abs($d->s_advanced_order_out%6) }} {{ intdiv($d->s_unmet_demand,6).'.'.abs($d->s_unmet_demand%6) }} @if($remaining < 0)-@endif{{ intdiv($remaining,6).'.'.abs($remaining%6) }} {{ intdiv($d->s_par_stock - $remaining,6).'.'.abs(($d->s_par_stock - $remaining)%6) }}
@endif @endforeach @endif
@push('custom-scripts') @endpush