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('selectedProduct') {{ $message }} @enderror @if($productSearchVisible == true)
    • @foreach($product_selection as $product) @endforeach
@endif
@error('transaction_date') {{ $message }} @enderror
@error('selectedHour') {{ $message }} @enderror
Generating Report..
Toggle Report Parameters
Inventory Report (Detailed)
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.
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 @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}} {{ $d->s_par_stock }} {{ $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 }} {{ $d->s_unmet_demand }} {{ $remaining }} {{ $d->s_par_stock - $remaining }}
@endif @endforeach @endif
@push('custom-scripts') @endpush