@php $totalVat= $data['unitsale_details']->net_price*($data['unitsale_details']->vat_percentage/100) @endphp @foreach ($data['unitsale_contact_joint']->clients as $index => $item) @endforeach @if ($totalVat==0) @else @endif @php $balance = 0; $totalDue = 0; $totalReceipts = 0; $totalLatePayment = 0; @endphp @foreach ($data['model'] as $index => $item) @if ($item->due > 0) @php $balance += $item->due; $totalDue += $item->due; @endphp @elseif ($item->late_amount != 0) @php $balance += $item->late_amount; $totalLatePayment += $item->late_amount; @endphp @elseif ($item->mount_received) @php $balance -= $item->mount_received; $totalReceipts += $item->mount_received; @endphp @endif @php $receipt_date = $item->due_date; @endphp @endforeach @php $totaldld = 0; $totaldldrec=0; $balancedld = 0; @endphp @foreach ($data['unitsale_details']->dld_admin_ledger as $index => $item) @php $totaldld += $item->charges; $totaldldrec += $item->amount_receipts; $balancedld += $item->charges -$item->amount_receipts; @endphp @endforeach @if (isset($data['unitsale_details']->extra_charges_ledger)) @php $totalAmountExtra = 0; $totalExtReceipts = 0; $balance = 0; @endphp @foreach ($data['unitsale_details']->extra_charges_ledger as $index => $item) @php $totalAmountExtra += $item->charges; $totalExtReceipts += $item->amount_receipts; $balance += $item->charges - $item->amount_receipts; @endphp @endforeach @endif @if($data['axtra_amount'][0]->amount>0) @endif @if($data['transfer_amount']) @endif @if($data['unitsale_details']->additional_discount) @endif @if (isset($data['unitsale_details']->pdc_installment_ledger)) @php $totalMount = 0; @endphp @foreach ($data['unitsale_details']->pdc_installment_ledger as $index => $item) @php $totalMount += $item->amount_received; @endphp @endforeach @endif @if (count($data['unitsale_details']->bounce_receipts) > 0) @php $totalBounceMount = 0; @endphp @foreach ($data['unitsale_details']->bounce_receipts as $index => $item) @php $totalBounceMount += $item->amount_received; @endphp @endforeach @endif

	Customer Details	{{$item->client ? ($item->client->id + 1000000) : '-'}} | {{$item->client ? ($item->client->person) : '-'}}
	Address	{{$item->client ? ($item->client->billing_address) : '-'}}
	Mobile	{{$item->client ? ($item->client->mobile_no) : '-'}}
	Email	{{$item->client ? ($item->client->email) : '-'}}
	Purchase Date	{{$data['unitsale_details'] ? date('d-M-Y', strtotime($data['unitsale_details']->booking_date)) : '-'}}
	Purchase Price	{{number_format($data['unitsale_details'] ? $data['unitsale_details']->net_price : '')}}
	Paid Up	{{ number_format($data['total_receipts'] ?? 0,2) }}
	PDC'S In Hand	{{ number_format($data['total_pdcs'] ?? 0,2) }}
	Unit No	{{$data['unitsale_details'] ? ($data['unitsale_details']->unit ? $data['unitsale_details']->unit->unitname : '') : ''}}
	Type	{{$data['unitsale_details'] ? $data['unitsale_details']->unittype['unittype']: ''}}
	Project	{{$data['unitsale_details'] ? $data['unitsale_details']->building->project['projectname']: ''}}
	VAT	Not Applicable	{{ number_format($totalVat ?? 0,2) }}
	DUES SUMMARY AS OF {{date('d-M-Y')}}
	Installment	Admin Charges / Unit registration	Late Payment Charges	Total Payment Due
	{{number_format($data['total_installment']- $data['installment_receipts'] ?? 0,2)}}	{{number_format(($data['unitsale_details']->dld_charges + $data['unitsale_details']->admin_fee - $data['total_dld_admin_receipts']) ?? 0,2)}}	{{number_format(($data['total_late_payment'] ) ?? 0,2)}}	{{ number_format(($data['total_dues']+$data['unitsale_details']->dld_charges + $data['unitsale_details']->admin_fee - $data['total_dld_admin_receipts']) ?? 0,2) }}
Schedule
SR#	Description	Date	Amount	Receipt	Late Payment	Balance
{{ $index+1 }}	{{ $item->mount_received > 0 ? (str_contains(strtolower($item->descr), 'discount') > 0 ? 'Additional Discount' :'Receipt') : $item->descr }}	{{ $item->due_date ? date('d-M-Y', strtotime($item->due_date ?? '')) : '-'}}	{{ number_format($item->due ?? 0,2) }}	{{ number_format($item->mount_received ?? 0,2) }}	{{ number_format($item->late_amount ?? 0,2) }}	{{ number_format($balance ?? 0,2) }}
Total			{{ number_format($totalDue ?? 0,2) }}	{{ number_format($totalReceipts ?? 0,2) }}	{{ number_format($totalLatePayment ?? 0,2) }}
UNIT REGISTRATION / ADMIN CHARGES
SR#	Description	Date	Amount	Receipt	Balance
{{ $index+1 }}	{{ $item->charge_type }}	{{ $item->transaction_date ? date('d-M-Y', strtotime($item->transaction_date ?? '')) : '-'}}	{{ number_format($item->charges ?? 0,2) }}	{{ number_format($item->amount_receipts ?? 0,2) }}	{{ number_format($balancedld ?? 0,2) }}
Total			{{ number_format($totaldld ?? 0,2) }}	{{ number_format($totaldldrec ?? 0,2) }}
OTHER CHARGES
SR#	Description	Date	Amount	Receipt	Balance
{{ $index+1 }}	{{ $item->Details ? $item->Details : '-' }}	{{ $item->transaction_date ? date('d-M-Y', strtotime($item->transaction_date ?? '')) : '-'}}	{{ number_format($item->charges ?? 0,2) }}	{{ number_format($item->amount_receipts ?? 0,2) }}	{{ number_format($balance ?? 0,2) }}
Total			{{ number_format($totalAmountExtra ?? 0,2) }}	{{ number_format($totalExtReceipts ?? 0,2) }}
Summary
SR#	Description	Amount
1	Admin Fee	{{ number_format($data['unitsale_details']->admin_fee ?? 0,2) }}
2	DLD Charges	{{ number_format($data['unitsale_details']->dld_charges ?? 0,2) }}
3	Purchase Price	{{ number_format($data['unitsale_details']->net_price ?? 0,2) }}
4	Other Charges	{{ number_format($totalAmountExtra ?? 0,2) }}
5	VAT (If Applicable)	{{ number_format($totalVat ?? 0,2) }}
Total		{{ number_format($data['unitsale_details']->dld_charges + $data['unitsale_details']->admin_fee+$totalAmountExtra +$data['unitsale_details']->net_price + $totalVat ?? 0,2) }}
Total Penalties		{{ number_format($totalLatePayment ?? 0,2) }}
Refunds if Any		{{ number_format($data['axtra_amount'][0]->amount ?? 0,2) }}
Amount Transferred		{{ number_format($data['transfer_amount'] ?? 0,2) }}
Discount		{{ number_format($data['unitsale_details']->additional_discount ?? 0,2) }}
Total Receipts		{{ number_format($totalReceipts + $totaldldrec + $totalExtReceipts ?? 0,2) }}
Net Balance		{{ number_format(($data['unitsale_details']->dld_charges + $data['unitsale_details']->admin_fee+ $totalAmountExtra +$data['unitsale_details']->net_price+$totalVat + $totalLatePayment +$data['axtra_amount'][0]->amount) - ($totalReceipts + $totaldldrec + $totalExtReceipts - $data['transfer_amount'] ) ?? 0,2) }}
COLLECTED POST DATED CHEQUES DETAIL
SR#	Chq Date	Chq No	Amount
{{ $index+1 }}	{{ $item->payment_date ? date('d-M-Y', strtotime($item->payment_date ?? '')) : '-'}}	{{ $item->chq_no }}	{{ number_format($item->amount_received ?? 0,2) }}
Total			{{number_format($totalMount ?? 0,2)}}
BOUNCED CHEQUES
SR#	Chq Date	Chq No	Amount
{{ $index+1 }}	{{ $item->payment_date ? date('d-M-Y', strtotime($item->payment_date ?? '')) : '-'}}	{{ $item->chq_no }}	{{ number_format($item->amount_received ?? 0,2) }}