@if($export == '1')
AnnexE
{{ __('lbl.report_of_ecollection_and_deposit') }}
{{ __('lbl.by_name_of_intermediary') }}
 
  {{ __('lbl.report_number') }}: ______________________
{{ __('lbl.entity_name') }}: ______________________ {{ __('lbl.sheet_number') }}: ______________________
{{ __('lbl.fund_cluster') }}: _____________________ {{ __('lbl.date') }}: {{$date_today}}
 
@endif @php $order_total = 0;$total_consular_fees = 0;$total_express_fee = 0;$total_admin_fee = 0;$total_surcharge = 0; @endphp @if(!empty($BankTranscations)) @php $order_info_key = ($export == '1') ? 'orderItemInfo' : 'order_item_info'; $pickup_key = ($export == '1') ? 'pickItemsInfo' : 'pickitemsinfo'; $order_customer_info_key = ($export == '1') ? 'orderCustomerInfo' : 'order_customer_info'; @endphp @foreach($BankTranscations as $key => $dList) @php $express_fee = 0.00;$admin_fee = 0.00;$prod_id_array = [];$prod_item_price =[]; $product_ids = isset($dList[$order_info_key][0])?$dList[$order_info_key][0]['product_ids']:[]; $item_prices = isset($dList[$order_info_key][0])?$dList[$order_info_key][0]['item_price']:[]; $prod_id_array = !empty($product_ids) ? explode(',',$product_ids) : null ; $prod_item_price = !empty($item_prices) ? explode(',',$item_prices) : null ; if(!empty($prod_id_array)){ foreach ($prod_id_array as $key => $pid){ if($express_processing_fee_product_id == $pid){ $express_fee = $prod_item_price[$key]; } if($administrative_fee_product_id == $pid){ $admin_fee = $prod_item_price[$key]; } } } @endphp @php $order_total += $dList['order_total']; $total_consular_fees += ($dList['order_total']-$express_fee-$admin_fee); $total_express_fee += $express_fee; $total_admin_fee += $admin_fee; $total_surcharge += ($dList['surcharge']); @endphp @endforeach @endif
{{ __('lbl.date') }} {{ __('lbl.number') }} {{ __('lbl.responsibility_center_code') }} {{ __('lbl.payer') }} {{ __('lbl.perticular') }} {{ __('lbl.prexc_pap') }} {{ __('lbl.total_per_ar') }} {{ __('lbl.consular_fees') }} {{ __('lbl.express_processing_fee') }} {{ __('lbl.administrative_fee') }} {{ __('lbl.surcharge') }}
{{\Carbon\Carbon::parse($dList['created_at'],config('app.timestamp'))->setTimezone(Helper::usertimezone())->format('Y-m-d H:i')}} {{$dList['payment_slip_number']}} {{$responsibility_center_code}} @php $customer_name = isset($dList[$order_customer_info_key]) ? $dList[$order_customer_info_key]['customer_name'] : $dList['clientName']; @endphp {{$customer_name}} @php $particular = ($dList['paymentType']=='CARD') ? $dList['paymentType'].'('.$dList['card_last_4'].')' : $dList['paymentType']; @endphp {{strtoupper($particular)}} {{ storecurrency().number_format($dList['order_total'],2) }} {{ storecurrency().number_format(($dList['order_total']-$express_fee-$admin_fee-$dList['surcharge']),2) }} {{ storecurrency().number_format($express_fee,2) }} {{ storecurrency().number_format($admin_fee,2) }} {{ storecurrency().number_format($dList['surcharge'],2) }}
{{ storecurrency().number_format($order_total,2) }} {{ storecurrency().number_format(($total_consular_fees),2) }} {{ storecurrency().number_format($total_express_fee,2) }} {{ storecurrency().number_format($total_admin_fee,2) }} {{ storecurrency().number_format($total_surcharge,2) }}
@if($export == '1')
 
 
{{ __('lbl.summary') }}: P xxx.xx
{{ __('lbl.undepsosited_colections_per_last_report') }} {{storecurrency().$order_total}}
{{ __('lbl.colections_per_ar_numbers') }} : {{$ar_number}}
Deposits
Date:___________ Ref#_______ xxx.xx ________________ xxx.xx
{{ __('lbl.undeposited_collections_this_report') }} ________________ P xxx.xx

{{ __('lbl.certification') }}
 
I hereby certify on my official that I have reviewed and found in order the above statement of all collections
base on the list provided by (Intermediary) corresponding the period stated above for which electronic AR Nos.
____________to___________inclusive of _(number of)_ transactions, were actually issued by them in to
the amounts shown thereon. I also certify that I have verified and confirmed that the amount of
____________________________was and credited to appropriate bank account of this agency.
 
____________________________________________________________________________________
{{ __('lbl.name_and_sign_of_the_designated_officer') }}
 
 
____________________
{{ __('lbl.official_designation') }} 		({{$date_today}})
Date
@endif