Report Parameters

Product*

@error('selectedProduct') {{ $message }} @enderror @if($productSearchVisible == true)

@endif

Start Date* @error('start_date') {{ $message }} @enderror

End Date* @error('end_date') {{ $message }} @enderror

Generating Report..

MARY GRACE FOODS, INC.

Deliveries Summary (Per Product)

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.
Amount is based on average unit price of item.

@if(empty($data))

Branch Code	Branch	Deliveries	Convert In	Transfer In	Advanced Order In	Amount
NO DATA

@else @php $rd_grand = 0; @endphp @foreach($products as $p) @if($data->where('item_code',$p->item_code)->count() > 0) @php $rd_total = 0; @endphp @foreach ($data->where('item_code',$p->item_code) as $index => $d) @php $item = $price_data->where('item_code',$d->item_code)->first(); $price = isset($item->avg_price) ? $item->avg_price : 0; $rd_amount = $price * $d->s_deliveries; $rd_total += $rd_amount; @endphp @endforeach @php $rd_grand += $rd_total; @endphp

{{ $p->item_code}} {{ $p->item_description}}
Branch Code	Branch	Deliveries	Convert In	Transfer In	Advanced Order In	Amount
{{ $d->branch_code}}	{{ $d->branch_name}}	{{ $d->s_deliveries}}	{{ $d->s_convert_in}}	{{ $d->s_transfer_in}}	{{ $d->s_advanced_order_in}}	{{ number_format($rd_amount,2) }}
TOTAL		{{ $data->where('item_code',$p->item_code)->sum('s_deliveries') }}	{{ number_format($rd_total,2) }}

@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