Transactions Report

Biller Name	{{ $filters['orgcode'] ?? 'N/A' }}
Start Date	{{ $filters['startdate'] ?? '' }}
End Date	{{ $filters['enddate'] ?? '' }}
Printed Date & Time	{{ now()->format('d/m/Y H:i:s') }}

Principal Amount	{{ number_format($totals['total_prin_amt'] ?? 0, 2) }}
VAT Amount	{{ number_format($totals['total_vat_amt'] ?? 0, 2) }}
Total Amount	{{ number_format($totals['total_tot_amt'] ?? 0, 2) }}

@php $serial = 1; // Helper function to mask phone numbers (e.g., 01712345156 -> 017XXXXX156) $maskMobile = function (?string $mobile): string { $mobile = trim((string) $mobile); if (strlen($mobile) >= 11) { return substr($mobile, 0, 3) . 'XXXXX' . substr($mobile, -3); } return $mobile; }; // Helper function to mask bill numbers (keeps first 2 and last 2 digits, masks middle) $maskBillNum = function (?string $billNum): string { $billNum = trim((string) $billNum); $length = strlen($billNum); if ($length > 4) { $maskLength = $length - 4; return substr($billNum, 0, 2) . str_repeat('X', $maskLength) . substr($billNum, -2); } return $billNum; }; @endphp @foreach (collect($data)->chunk(160) as $chunk) @if(session('biller_org_code')=="GOLDENLINE") @elseif (session('biller_org_code')=="AZADDATB") @elseif (session('biller_org_code')=="Deshlogistics") @else @endif @foreach ($chunk as $item) @php $othersValues = [ $item['SUBID'] ?? '', $item['CONTACTNO'] ?? '', $item['EXTENDEDPARAMETER1'] ?? '', $item['EXTENDEDPARAMETER2'] ?? '', $item['EXTENDEDPARAMETER3'] ?? '', $item['EXTENDEDPARAMETER4'] ?? '', $item['EXTENDEDPARAMETER5'] ?? '', $item['EXT_PARAM1'] ?? '', $item['EXT_PARAM2'] ?? '', $item['EXT_PARAM3'] ?? '', $item['EXT_PARAM4'] ?? '', $item['EXT_PARAM5'] ?? '', $item['EXT_PARAM6'] ?? '', ]; $othersValues = array_filter($othersValues, fn ($v) => !empty(trim($v))); $others = implode(' # ', $othersValues); $maskedMobile = $maskMobile($item['USER_MOBILE'] ?? ''); $maskedBillNum = $maskBillNum($item['BILL_NUM'] ?? ''); @endphp @endforeach

Serial	Agent Code	Bill Number	Agent Phone Number	Counter/Agent Name	Mobile Number	Pay Date	Principal Amount	VAT Amount	Total Amount	bKash Transaction ID	Others
Serial	Account Number	Bill Number	Consumer Name	Bill Month	Mobile Number	Pay Date	Principal Amount	VAT Amount	Total Amount	bKash Transaction ID	Others
Serial	Trip ID	Bill Number	Consumer Name	Bill Month	Mobile Number	Pay Date	Principal Amount	VAT Amount	Total Amount	bKash Transaction ID	Others
Serial	Account Number	Bill Number	Bill Month	Consumer Name	Mobile Number	Pay Date	Principal Amount	VAT Amount	Total Amount	bKash Transaction ID	Others
{{ $serial++ }}	{{ $item['ACC_NUM'] ?? '' }}	{{ $maskedBillNum }}	{{ $item['BILL_MON'] ?? '' }}	{{ $item['CONS_NAME'] ?? '' }}	{{ $maskedMobile }}	{{ $item['PAY_DATE'] ?? '' }}	{{ number_format($item['PRIN_AMT'] ?? 0, 2) }}	{{ number_format($item['VAT_AMT'] ?? 0, 2) }}	{{ number_format($item['TOT_AMT'] ?? 0, 2) }}	{{ $item['BKASH_TRANS_ID'] ?? '' }}	{{ $others }}

@if (!$loop->last)

@endif @endforeach