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..

Transfers 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.
TI amount and TO amount is based on average unit price of item.

@if(empty($data))

Branch Code	Branch	Transfer In	TI Amount	Transfer Out	TO Amount
NO DATA

@else @php $ti_grand = 0; $to_grand = 0; @endphp @foreach($products as $p) @if($data->where('item_code',$p->item_code)->count() > 0) @php $ti_total = 0; $to_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; $ti_amount = $price * $d->s_transfer_in; $to_amount = $price * $d->s_transfer_out; $ti_total += $ti_amount; $to_total += $to_amount; @endphp @endforeach @php $ti_grand += $ti_total; $to_grand += $to_total; @endphp

{{ $p->item_code}} {{ $p->item_description}}
Branch Code	Branch	Transfer In	TI Amount	Transfer Out	TO Amount
{{ $d->branch_code}}	{{ $d->branch_name}}	{{ $d->s_transfer_in }}	{{ number_format($ti_amount,2) }}	{{ $d->s_transfer_out }}	{{ number_format($to_amount,2) }}
TOTAL		{{ $data->where('item_code',$p->item_code)->sum('s_transfer_in') }}	{{ number_format($ti_total,2) }}	{{ $data->where('item_code',$p->item_code)->sum('s_transfer_out') }}	{{ number_format($to_total,2) }}

@endif @endforeach

		Transfer In	TI Amount	Transfer Out	TO Amount
GRAND TOTAL		{{ $data->sum('s_transfer_in') }}	{{ number_format($ti_grand,2) }}	{{ $data->sum('s_transfer_out') }}	{{ number_format($to_grand,2) }}

@endif

@push('custom-scripts') @endpush