@extends('layouts.app') @section('title') @if($block == 'summary' ) SUMMARY OF BOOKING, RECOVERY AND RECEIVABLES   From {{date('d/m/Y' , strtotime($from_date))}}  To  {{date('d/m/Y' , strtotime($to_date))}} @else Account Statement & Recovery Sheet      From {{date('d/m/Y' , strtotime($from_date))}}  To  {{date('d/m/Y' , strtotime($to_date))}} @endif @stop @section('css') @stop @section('breadcrumb')
  1. Home
  2. Account Statement
@stop @section('content')

@foreach($project_names as $key => $project_name) {{ $project_name }} @if($key < count($project_names) - 1) , @endif @endforeach

Account Statement & Recovery Sheet

Recovery Sheet(Due, Received & OS As On)
FROM  {{date('d/m/Y', strtotime($from_date))}}  To  {{date('d/m/Y', strtotime($to_date))}}
Date: {{date('d/m/Y')}}
User ID:   {{Auth::user()->name}}
{{ csrf_field() }}
@foreach ($period as $key=> $dt) @endforeach @foreach ($period as $key=> $dt) @endforeach @foreach($unit_blocks as $unit_blook) @foreach($floor_data as $f) @if($unit_blook->name == $f['block']) @endif @endforeach @php if(($block_total_units_amount - $block_booked_units_amount) > 0 ) { $block_discount = $block_total_units_amount - $block_booked_units_amount; } @endphp @foreach ($period as $key=> $dt) @endforeach @endforeach {{-- @foreach ($period as $key=> $dt) @endforeach --}} @foreach ($period as $dt) @endforeach @if($block == 'combined') @foreach ($period as $dt) @endforeach @endif @foreach($unit_blocks as $unit_block) @foreach($properties as $property) @if($loop->first && $block != 'combined') @foreach ($period as $dt) @endforeach @foreach ($period as $dt) @endforeach @endif @if(!empty($property->inventory->floor->unit_block)) @if(( ($filter_type == 'filter' && $block > 0 && $block == $property->inventory->floor->unit_block->id) || $filter_type == 'all' ) && $unit_block->id == $property->inventory->floor->unit_block->id) @php foreach ($period as $dt) { $output = '-'; $totalAmount = 0; $de_date = ''; $sumOfDueAmount = array_reduce($dueMonth[$property->id], function ($a, $b) { isset($a[$b['due_date']]) ? $a[$b['due_date']]['due'] += $b['due'] : $a[$b['due_date']] = $b; return $a; }); if(!empty($sumOfDueAmount)) { foreach($sumOfDueAmount as $s) { if ($dt->format("M Y") == date('M Y', strtotime($s['due_date']))) { $output = ' ('.number_format($s['due']).')'; $totalAmount = $s['due']; $de_date = date('M Y', strtotime($s['due_date'])); } } } $totalArray[] = array('date' => $de_date, 'amount' => $totalAmount); echo ''; } @endphp @endif @endif @endforeach @php $sum = array_reduce($totalArray, function ($a, $b) { isset($a[$b['date']]) ? $a[$b['date']]['amount'] += $b['amount'] : $a[$b['date']] = $b; return $a; }); @endphp @foreach ($period as $dt) @php $totalOutput = 0; $grandTotalAmount = 0; $grand_de_date = ''; @endphp @if(!empty($sum) ) @foreach($sum as $month) @if ($dt->format("M Y") == $month['date']) @php $totalOutput = number_format($month['amount']); $grandTotalAmount = $month['amount']; $grand_de_date = $month['date']; @endphp @endif @endforeach @endif @php $grand_total[] = array('date' => $grand_de_date, 'amount' => $grandTotalAmount); @endphp @endforeach @endforeach @php $grand_sum = array_reduce($grand_total, function ($a, $b) { isset($a[$b['date']]) ? $a[$b['date']]['amount'] += $b['amount'] : $a[$b['date']] = $b; return $a; }); @endphp @foreach ($period as $dt) @php $totalOutput = 0; @endphp @if(!empty($grand_sum) ) @foreach($grand_sum as $month) @if ($dt->format("M Y") == $month['date']) @php $totalOutput = number_format($month['amount']); @endphp @endif @endforeach @endif @endforeach
NO. OF UNITS TOTAL AREA (In {{env('SIZE')}}) TOTAL SALES VALUE (In Rs.) RECOVERY AND RECEIVEABLE AG. BOOKED UNITS
Sr. Block Total Booked Unbooked All Units Booked Un-Booked Booked Discount Booked(Net) Un-Booked Total Recovery Balance Receivables Overdues Future Ins. {{$dt->format("M Y")}}
{{$serial_no++}} {{ $unit_blook->name }} {{number_format($block_total_units_count)}} {{number_format($block_booked_units_count)}} {{number_format($block_un_booked_units_count)}} {{number_format($block_total_units_area)}} {{number_format($block_booked_units_area)}} {{number_format($block_un_booked_units_area)}} {{number_format($block_total_units_amount)}} {{number_format($block_discount)}} {{number_format($block_booked_units_amount)}} {{number_format($block_un_booked_units_amount)}} {{number_format( ($block_total_units_amount + $block_un_booked_units_amount) - $block_discount )}} {{number_format($block_recovery)}} {{number_format($block_receivable)}} {{number_format($block_overdue)}} {{number_format($block_future)}}
Total. {{number_format($grand_block_total_units_count)}} {{number_format($grand_block_booked_units_count)}} {{number_format($grand_block_un_booked_units_count)}} {{number_format($grand_block_total_units_area)}} {{number_format($grand_block_booked_units_area)}} {{number_format($grand_block_un_booked_units_area)}} {{number_format($grand_block_booked_units_amount)}} {{number_format($grand_block_discount)}} {{number_format($grand_block_total_units_amount)}} {{number_format($grand_block_un_booked_units_amount)}} {{number_format($grand_block_total_units_amount + $grand_block_un_booked_units_amount)}} {{number_format($grand_block_recovery)}} {{number_format($grand_block_overdue + $grand_block_future)}} {{number_format($grand_block_overdue)}} {{number_format($grand_block_future)}}
                             
Sr No. Unit No. Client Name Dealer Booking Date Unit Floor Area(Sft.) Unit Block Booked Price Discount Booked (Net) Total Received Balance Receivables Overdue Future Installments {{$dt->format("M Y")}}
{{$unit_block->name}}
Sr No. Unit No. Client Name Dealer Booking Date Unit Floor Area(Sft.) Unit Block Booked Price Discount Booked (Net) Total Received Balance Receivables Overdue Future Installments {{$dt->format("M Y")}}
{{$count++}} {{$property->inventory ? $property->inventory->unit_number : ''}} {{$property->customer ? $property->customer->name : ''}} @if($property->dealer) {{$property->dealer ? $property->dealer->name:''}} @endif {{date('d/m/Y', strtotime($property->booking_date)) }} {{$property->inventory ? $property->inventory->floor->name : ''}} {{$property->inventory ? number_format($property->inventory->size->name) : ''}} {{$property->inventory ? $property->inventory->floor->unit_block->name : ''}} {{number_format($property->inventory->total_price)}} @if(($property->inventory->total_price - $property->net_pay) > 0 ) {{ number_format( $property->inventory->total_price - $property->net_pay ) }} @else {{'-'}} @endif {{number_format($property->net_pay)}} {{number_format($receivedAmt[$property->id])}} {{number_format(($property->net_pay - $receivedAmt[$property->id] ) )}} {{number_format($overDueAmt[$property->id])}} {{number_format(($property->net_pay - $outStandingAmount[$property->id]) - $overDueAmt[$property->id] )}} '.$output.'
Sub Total- {{$unit_block->name}} {{number_format($sqrt)}} {{number_format($booked_price)}} {{number_format($discount)}} {{number_format($net_pay)}} {{number_format($received)}} {{number_format($balance_receivables)}} {{number_format($overdue)}} {{number_format($future_installments)}}({{$totalOutput}})
Grand Total {{number_format($grand_total_sqrt)}} {{number_format($grand_booked_price)}} {{number_format($grand_discount)}} {{number_format($grand_net_pay)}} {{number_format($grand_received)}} {{number_format($grand_balance_receivables)}} {{number_format($grand_overdue)}} {{number_format($grand_future_installments)}}({{$totalOutput}})
Assign  
@stop @section('js') @stop