@extends('layouts.app') @section('title') Detail of Customer Statement @stop @section('breadcrumb') @stop @section('css') @stop @section('content') @php $size= ''; if($projectType->id == \App\ProjectType::society){ $size= \App\ProjectType::society_size; } else { $size= \App\ProjectType::high_rise_size; } @endphp @php $map= ' '; if($projectType->id == \App\ProjectType::society){ $map= \App\ProjectType::society_map; } else { $map= \App\ProjectType::high_rise_map; } @endphp

{{ env('APP_NAME') }}

@if($property->inventory) @if($property->inventory->multiProject) {{ $property->inventory->multiProject->name }} @endif @endif

Account Statement

  Member Information

@php $ownerArray[] = $property->customer->name; if(!empty($property->customer->first_owner)) { $ownerArray[] = $property->customer->first_owner; } if(!empty($property->customer->second_owner)) { $ownerArray[] = $property->customer->second_owner; } @endphp
Ref No: {{ $property->membership_no }} CNIC No. @if(count($ownerArray) > 1) {{str_replace('_' , '' , $property->customer->cnic)}}, {{$property->customer->first_owner_cnic}}, {{$property->customer->second_owner_cnic}} @else @if(($i == 5 || $i == 12) && $property->customer->type == 0) - @endif @endif
Member Name: @if(count($ownerArray) > 1) {{ $property->customer->name }}, {{ $property->customer->first_owner }}, {{ $property->customer->second_owner }} @else {{ $property->customer->name }} @endif @if($property->customer->father_type == 1) {{'S/O:'}} @elseif($property->customer->father_type == 2) {{'D/O:'}} @elseif($property->customer->father_type == 3) {{'W/O:'}} @else {{ 'Company Name' }} @endif @if(count($ownerArray) > 1) {{ $property->customer->father_name }}, {{ $property->customer->first_owner_father }}, {{ $property->customer->second_owner_father }} @else {{ $property->customer->father_name }} @endif
Contact #: {{ $property->customer ? $property->customer->mobile_number : '' }} Address: {{ $property->customer->mailing_address }}
@if($property->inventory->floor) @endif

  Unit's Details

@if($property->inventory->floor ) @endif @if($projectType->id == \App\ProjectType::society) @endif @if($projectType->id == \App\ProjectType::high_rise) @endif @if($property->down_payment_note) @endif @permission('print-membership') @endpermission @permission('print-membership') @endpermission
Project: @if($property->inventory) @if($property->inventory->multiProject) {{ $property->inventory->multiProject->name }} @endif @endif
{{ $map }}: @if($property->inventory->floor) {{ $property->inventory->floor->name }} @endif
Block: {{ $property->inventory->floor->unitBlock ? $property->inventory->floor->unitBlock->name : '' }}
Category: @foreach($property->inventory->categories as $c) @if($c->category) @if($loop->last) {{ $c->category->name }} ({{ $c->category->percent }} ) @else {{ $c->category->name }} ({{ $c->category->percent }} ), @endif @endif @endforeach
Size: {{ $property->inventory->size ? $property->inventory->size->name : '' }} {{ $size }}
Cost Of Land: PKR {{ number_format($property->inventory->total_price) }}
Development Charges: PKR {{ number_format($developmentcharges) }}
Total Price: PKR {{ number_format($property->inventory->total_price) }}
Net Amt: PKR {{ number_format($property->net_pay) }}
Notes: {{ $property->down_payment_note }}
Application Form
Agreement Form
@if($property->booking_type == \App\CustomerProperty::normal) @elseif($property->booking_type == \App\CustomerProperty::full_payment) @endif
Unit/Plot No.: {{ $property->inventory ? $property->inventory->unit_number : '' }}
Unit Type: {{ $property->inventory->type->name }}
Area: {{ $property->inventory->area }}
Discount: {{ number_format($property->discount ) }}
Category Cost: {{ number_format($property->inventory->extra_amount) }}
Booking Type : InstallmentFull Payment
Booking Date: {{ date('d-m-Y', strtotime($property->original_boooking_date)) }}
Schedule Start Date: @if($property->schedule_start_date) {{ date('d-m-Y', strtotime($property->schedule_start_date)) }} @endif
  Rebate's Info +

  Payment Detail

Net Price: PKR {{ number_format($property->net_pay) }} Received Amount: PKR {{ number_format($amount) }}    ({{ number_format($receivedAmtPer , 2) }} % ) Outstanding Amt: PKR {{ number_format($outstandingAmt) }}    ({{ number_format($outstandingAmtPer , 2) }} % )
Over Due Amt. PKR {{ number_format($overDue) }}     ({{ number_format($overDuePer , 2) }} % ) PDC. PKR {{ number_format($pdc_receipt) }}    ({{ number_format($pdcReceiptPer , 2) }} % ) Paid Surcharge PKR {{ number_format($paidSurcharge) }}

{{ env('APP_NAME') }}

Name @if($property->customer->father_type == 1) {{'Mr.'}} @elseif($property->customer->father_type == 2) {{'Ms.'}} @elseif($property->customer->father_type == 3) {{'Mrs.'}} @else {{ 'Company Name' }} @endif {{$property->customer->name}} Address: {{$property->customer->mailing_address}}
@if($property->customer->type == 0) {{ 'CNIC No:' }} @else {{ 'Incorporation no' }} @endif @if(($i == 5 || $i == 12) && $property->customer->type == 0) - @endif

Apartment Details:

File No:
{{$property->inventory->unit_number}}
Block:
Floor:
Type:
{{$property->inventory->type->name}}
Reference No::
{{$property->membership_no}}
Category:
@foreach($property->inventory->categories as $c) @if($loop->last) {{$c->category->name}} @else {{$c->category->name}} @endif @endforeach
Apartment No:
{{$property->inventory->unit_number}}
Gross Area (Sft.):
{{number_format($property->inventory->size->name)}}

Payment Plan:

Sale Price: {{number_format($property->inventory->total_price - $property->inventory->extra_amount)}}
Discount: {{number_format($property->discount )}}
Final Unit Price: {{number_format($property->net_pay)}}
Received Amount: {{number_format($amount)}} ({{ number_format($receivedAmtPer , 2) }} % )
Outstanding Amount: {{number_format($property->net_pay - $amount)}} ({{ number_format($outstandingAmtPer , 2) }} % )
@php $inst_counter=0; @endphp @foreach($property->statement as $st) @if($st->payment_head == \App\CustomerStatement::installment) @php $inst_counter++; @endphp @endif @endforeach
Price / Sft.:
{{number_format(($property->inventory->total_price - $property->inventory->extra_amount ) /$property->inventory->size->name)}}
No. of Installments:
Down + {{$inst_counter}} Inst.
Overdue Amount:
{{number_format($overDue)}}
@foreach($periorities as $periority) @foreach($property->statement->where('payment_head','!=',\App\CustomerStatement::development) as $statement) @if($statement->due > 0 && ($statement->payment_head == $periority->payment_head ) || ($statement->payment_head == \App\CustomerStatement::other && !in_array($statement->payment_head , $otherArray))) @php if($statement->payment_head == \App\CustomerStatement::other) { $otherArray[] = $statement->payment_head; } @endphp @if($statement->balance > 0 && $statement->due_date < Carbon\Carbon::today()) @else @endif @if($statement->balance > 0 && $statement->due_date < Carbon\Carbon::today()) @else @endif @if($statement->payment_head == \App\CustomerStatement::down_payment) @elseif($statement->payment_head == \App\CustomerStatement::possession) @elseif($statement->payment_head == \App\CustomerStatement::installment) @elseif($statement->payment_head == \App\CustomerStatement::other) @elseif($statement->payment_head == \App\CustomerStatement::allotment) @elseif($statement->payment_head == \App\CustomerStatement::confirmation) @elseif($statement->payment_head == \App\CustomerStatement::booking) @elseif($statement->payment_head == \App\CustomerStatement::development) @elseif($statement->payment_head == \App\CustomerStatement::file_processing) @elseif($statement->payment_head == \App\CustomerStatement::registration) @elseif($statement->payment_head == \App\CustomerStatement::ballon) @elseif($statement->payment_head == \App\CustomerStatement::balloting) @else @endif @if($statement->is_deleted == false) @if($statement->receipt) @if($statement->receipt->payment_method == \App\Receipt::cash) @elseif($statement->receipt->payment_method == \App\Receipt::bank) @elseif($statement->receipt->payment_method == \App\Receipt::adjustment) @elseif($statement->receipt->payment_method == \App\Receipt::cheque) @elseif($statement->receipt->payment_method == \App\Receipt::merging) @else @endif @else @endif @else @endif @if($statement->is_deleted == false) @if($statement->received) @else @endif @else @endif @endif @endforeach @endforeach
Payment Head Due Date Due Amt. Received Amt. Balance Payment Mode Receipt # Receipt Date Surcharge Amt Balance Amt.
@if( $property->booking_type == \App\CustomerProperty::full_payment) {{'Full Payment'}} @else {{'Down Payment'}} @endif Possession Fee @if (!str_contains($statement->inst_no , '-b')) Installment - {{str_replace('-a' , '' , $statement->inst_no)}} @else       Installment @endif OtherAllotmentConfirmationBookingDevelopmentFile ProcessingRegistrationBallon PaymentBalloting {{ date('d-m-Y', strtotime($statement->due_date)) }} {{ number_format($statement->due) }} @if($statement->is_deleted == false){{ number_format($statement->received) }} @else 0 @endif @if($statement->is_deleted == false) {{ number_format($statement->balance) }} @else {{ number_format($statement->due) }} @endif CashBankAdjustmentChequeMerging@if($statement->is_deleted == false) {{ $statement->rcpt_no }} @endif @if($statement->is_deleted == false) {{ $statement->rcpt_date ? date('d-m-Y', strtotime($statement->rcpt_date)) : '' }} @endif {{ number_format($statement->surcharge) }} {{ number_format($total) }}
Total {{ number_format($received) }} Total WaveOff ({{ $waiveOff }}) {{ number_format($surcharge - $waiveOff) }} {{ number_format($total) }}

@if($projectType->id == \App\ProjectType::society) {{-- Development Charges --}}
@foreach($periorities as $periority) @foreach($property->statement->where('payment_head',\App\CustomerStatement::development) as $statement) @if($statement->due > 0 && ($statement->payment_head == $periority->payment_head ) || ($statement->payment_head == \App\CustomerStatement::other && !in_array($statement->payment_head , $otherArray))) @php if($statement->payment_head == \App\CustomerStatement::other) { $otherArray[] = $statement->payment_head; } @endphp @if($statement->balance > 0 && $statement->due_date < Carbon\Carbon::today()) @else @endif @if($statement->payment_head == \App\CustomerStatement::development) @else @endif @if($statement->is_deleted == false) @if($statement->receipt) @if($statement->receipt->payment_method == \App\Receipt::cash) @elseif($statement->receipt->payment_method == \App\Receipt::bank) @elseif($statement->receipt->payment_method == \App\Receipt::adjustment) @elseif($statement->receipt->payment_method == \App\Receipt::cheque) @elseif($statement->receipt->payment_method == \App\Receipt::merging) @else @endif @else @endif @else @endif @if($statement->is_deleted == false) @if($statement->received) @else @endif @else @endif @endif @endforeach @endforeach
Payment Head Due Date Due Amt. Received Amt. Balance Payment Mode Receipt # Receipt Date Surcharge Amt Balance Amt.
Development {{ date('d-m-Y', strtotime($statement->due_date)) }} {{ number_format($statement->due) }} @if($statement->is_deleted == false){{ number_format($statement->received) }}@else 0 @endif @if($statement->is_deleted == false){{ number_format($statement->balance) }} @else {{ number_format($statement->due) }} @endif CashBankAdjustmentChequeMerging@if($statement->is_deleted == false) {{ $statement->rcpt_no }} @endif @if($statement->is_deleted == false) {{ $statement->rcpt_date ? date('d-m-Y', strtotime($statement->rcpt_date)) : '' }} @endif {{ number_format($statement->surcharge) }} {{ number_format($development_total) }}
Total {{ number_format($development_due) }} {{ number_format($development_received) }} Total WaveOff ({{ $waiveOff }}) {{ number_format($development_surcharge - $waiveOff) }} {{ number_format($development_total) }}

@endif {{-- End Development Charges --}} @if($property->booking_type == \App\CustomerProperty::full_payment ) @if($property->fullPayment)

Discount Payment Terms


Total Amount : {{ number_format($property->fullPayment->total_amount) }}
Discount Percentage : {{ $property->fullPayment->discount_percentage }} %
Discount Amount {{ number_format($property->fullPayment->discount_amount) }}
Net Amount {{ number_format($property->fullPayment->discount_amount - $property->fullPayment->deduction_amount) }}
@if($property->fullPayment->return_tenure == \App\CustomerProperty::monthly) @elseif($property->fullPayment->return_tenure == \App\CustomerProperty::quarterly) @elseif($property->fullPayment->return_tenure == \App\CustomerProperty::semi_annually) @elseif($property->fullPayment->return_tenure == \App\CustomerProperty::annually) @else @endif
Total Tenure : {{ $property->fullPayment->total_tenure }} months
Return Tenure : Monthly Quarterly Semi Annually Annually
Deduction Amount : {{ number_format($property->fullPayment->deduction_amount) }}
@foreach($property->fullPaymentStatement as $statement) @endforeach
inst # Due Date Due Amount Paid Amount Receipt # Receipt Date Balance Amount
{{ $count++ }} {{ date('d-m-Y', strtotime($statement->due_date)) }} {{ number_format($statement->due) }} {{ number_format($statement->received) }} {{ $statement->receipt_no }} {{ $statement->receipt_date ? date('d-m-Y', strtotime($statement->receipt_date)) : '' }} {{ number_format($statement->due - $statement->received) }}
Total {{ number_format($due) }} {{ number_format($received) }} {{ number_format($balance) }}
@endif @endif @if($property->propertyTax)

Property Tax Record

@foreach($property->PropertyTax as $tax) @if($tax->statement->payment_head == \App\CustomerStatement::down_payment) @elseif($tax->statement->payment_head == \App\CustomerStatement::possession) @elseif($tax->statement->payment_head == \App\CustomerStatement::installment) @elseif($tax->statement->payment_head == \App\CustomerStatement::other) @elseif($tax->statement->payment_head == \App\CustomerStatement::allotment) @elseif($tax->statement->payment_head == \App\CustomerStatement::confirmation) @elseif($tax->statement->payment_head == \App\CustomerStatement::booking) @elseif($tax->statement->payment_head == \App\CustomerStatement::development) @elseif($tax->statement->payment_head == \App\CustomerStatement::file_processing) @elseif($tax->statement->payment_head == \App\CustomerStatement::registration) @elseif($tax->statement->payment_head == \App\CustomerStatement::ballon) @elseif($tax->statement->payment_head == \App\CustomerStatement::balloting) @else @endif @endforeach
Sr # inst # Tax Pay By Payment Received Status CPR Action
{{$sr++}}Down PaymentPossession FeeInstallment - {{$tax->statement->inst_no}}OtherAllotmentConfirmationBookingDevelopmentFile ProcessingRegistrationBallon PaymentBalloting {{ number_format($tax->tax) }} @if($tax->tax_pay_by == \App\Receipt::customer) Customer @else Company @endif {{ $tax->tax_payment_received == \App\CustomerPropertyTax::paid ? 'YES' : 'NO' }} {{ $tax->status == \App\CustomerPropertyTax::paid ? 'Paid' : 'UnPaid' }} @if($tax->status)
Reference # {{ $tax->reference }} @endif
@if($tax->cpr)  Download @endif @if($tax->tax_pay_by == \App\Receipt::customer) @endif
Total {{ number_format($sum) }}
@endif
@stop @section('js') @stop