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('start_date') {{ $message }} @enderror
@error('end_date') {{ $message }} @enderror
Generating Report..
Toggle Report Parameters
MARY GRACE FOODS
Inbound Items Report
Report Date: {{ date('M j, Y g:i:s a',strtotime(now()))}} Generated By: {{ auth()->user()->name}}
Coverage: {{date('M j, Y',strtotime($start_date)).' - '.date('M j, Y',strtotime($end_date))}}
*Note: Coverage date is based on Actual Date.
@if(empty($data))
Branch Code Branch Deliveries Convert In Transfer In Advanced Order In
NO DATA
@else @php $rd_grand = 0; @endphp @foreach($products as $p) @if($data->where('item_code',$p->item_code)->count() > 0) @php $brs = $data->where('item_code',$p->item_code)->unique('branch_code')->pluck('branch_code'); @endphp @foreach($brs as $br) @foreach ($data->where('item_code',$p->item_code)->where('branch_code',$br) as $index => $d) @endforeach @endforeach
{{ $p->item_code}} {{ $p->item_description}}
Branch Code Branch Deliveries Convert In Transfer In Advanced Order In
{{ $data->where('branch_code',$br)->first()->branch_code }} {{ $data->where('branch_code',$br)->first()->branch_name }}
{{ $d->inventory_date}} {{ $d->s_deliveries}} {{ $d->s_convert_in}} {{ $d->s_transfer_in}} {{ $d->s_advanced_order_in}}
BRANCH TOTAL {{ $data->where('item_code',$p->item_code)->where('branch_code',$br)->sum('s_deliveries') }} {{ $data->where('item_code',$p->item_code)->where('branch_code',$br)->sum('s_convert_in') }} {{ $data->where('item_code',$p->item_code)->where('branch_code',$br)->sum('s_transfer_in') }} {{ $data->where('item_code',$p->item_code)->where('branch_code',$br)->sum('s_advanced_order_in') }}
ITEM SUB-TOTAL {{ $data->where('item_code',$p->item_code)->sum('s_deliveries') }} {{ $data->where('item_code',$p->item_code)->sum('s_convert_in') }} {{ $data->where('item_code',$p->item_code)->sum('s_transfer_in') }} {{ $data->where('item_code',$p->item_code)->sum('s_advanced_order_in') }}
@endif @endforeach
Deliveries Convert In Transfer In Advanced Order In
GRAND TOTAL {{ $data->sum('s_deliveries') }} {{ $data->sum('s_convert_in') }} {{ $data->sum('s_transfer_in') }} {{ $data->sum('s_advanced_order_in') }}
@endif
@push('custom-scripts') @endpush