@extends('layouts.admin.index')
@section('content')
@section('css')
    <link rel="stylesheet" href="/assets/css/bracket.dark.min.css">
    <link rel="stylesheet" href="/assets/css/bracket.min.css">
    <link rel="stylesheet" href="/assets/css/bracket.oreo.min.css">
    <link rel="stylesheet" href="/assets/css/bracket.simple-white.min.css">
    <link rel="stylesheet" href="/assets/css/custom/style.css">
    <style>
     .main-content .content{
       margin-top: 30px !important;

     }

     .nested-left img{
        margin: 0px !important;
        width: 80% !important;
     }
    
    </style>
@endsection
@section('title','Money Receipt')

<div class="row row-sm">
    <div class="col-md-12 col-xl-12 col-xs-12 col-sm-12">
        <div class="card border custom-card">
            <div class="card-header custom-card-header d-flex no_print">
                <h5 class="main-content-label mb-0">{{ trans('cruds.money_receipt') }}</h5>
                <div class="card-options">
                    <a href="javascript:;" class="card-options-collapse py-0" data-bs-toggle="card-collapse"><i
                            class="fe fe-chevron-up"></i></a>
                    <a href="javascript:;" class="card-options-fullscreen py-0" data-bs-toggle="card-fullscreen"><i
                            class="fe fe-maximize"></i></a>
                    <a href="javascript:;" class="card-options-remove py-0" data-bs-toggle="card-remove"><i
                            class="fe fe-x"></i></a>
                    @include('admin.common.print')
                </div>
            </div>
            <div class="card-body">
                <div class="row">
                    <div class="col-md-12">
                        <div class="money-receipt">
                            <div class="sheet-outer A4">
                                <div class="sheet padding">
                                    <!-- customer copy -->
                                    <div class="customer-copy position-relative">
                                        <div class="title">
                                            <h4 class="text-center">Fanam Real State Ltd.</h4>
                                            <span class="fw-500">Money Receipt</span>
                                        </div>
                                        <div class="content">
                                            <div class="d-flex justify-content-between w-100 mb-1">
                                            {{-- 12Nov2025 Frontend Code Update Starts(Shakib)  --}}
                                                {{-- <p class="fw-500">MR No : {{ isset($collection)?$collection->collection_prefix.$collection->collection_no:'' }}</p> --}}
                                                <p class="fw-500">MR No : PFC-{{ isset($collection)?$collection->collection_no:'' }}</p>
                                            {{-- 12Nov2025 Frontend Code Update Ends(Shakib)  --}}    
                                                <p class="fw-500">Date : {{ isset($collection)?$collection->collection_date:'' }}</p>
                                            </div>
                                            <div class="custom-row">
                                                <div class="left">
                                                    <table class="w-100">
                                                        <tr>
                                                            <td>Project Name</td>
                                                            <td colspan="2">{{ (isset($collection) && $collection->project)?$collection->project->project_name:'' }}</td>
                                                        </tr>
                                                        <tr>
                                                            <td>Client Name</td>
                                                            <td colspan="2" class="fw-500">
                                                                @if((isset($collection) && $collection->customer))
                                                                    {{ $collection->customer->firstname??'' }} {{ $collection->customer->lastname??'' }}
                                                                @endif

                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>Acc/File No</td>
                                                            <td colspan="2" class="fw-500">
                                                                @if((isset($collection) && $collection->booking))
                                                                    {{ $collection->booking->file_no??'' }}
                                                                @endif
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>Amount</td>
                                                            <td colspan="2"><span class="fw-500">Tk. </span>
                                                                {{ money_format_bd($collection->collection_amount ?? 0) }}
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>In words</td>
                                                            {{-- <td colspan="2"><span class="fw-500">Tk. </span>
                                                                {{ convert_number_to_words($collection->collection_amount??0) }}
                                                            </td> --}}

                                                            <td colspan="2">
                                                                <span class="fw-500">Tk. </span>
                                                                @php
                                                                    $amount = $collection->collection_amount ?? 0;

                                                                    // Check if decimal part is zero
                                                                    if (strpos($amount, '.') !== false) {
                                                                        list($intPart, $fraction) = explode('.', $amount);
                                                                        if ((int)$fraction === 0) {
                                                                            $amount_in_words = convert_number_to_words($intPart);
                                                                        } else {
                                                                            $amount_in_words = convert_number_to_words($amount);
                                                                        }
                                                                    } else {
                                                                        $amount_in_words = convert_number_to_words($amount);
                                                                    }
                                                                @endphp

                                                                {{ $amount_in_words }} Taka only
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>Deposit Purpose</td>
                                                            <td colspan="2">
                                                            {{-- 12Nov2025 Html Code & Backend Code Starts(Shakib)  --}}
                                                            @if($collection && $collection->details)

                                                                @php
                                                                    $downPayments = [];
                                                                    $installments = [];
                                                                    $booking = [];

                                                                    // প্রতিটি schedule_id অনুযায়ী total paid বের করো একবারে
                                                                    $scheduleSums = \Illuminate\Support\Facades\DB::table('collection_details')
                                                                        ->select('payment_schedule_detail_id', \Illuminate\Support\Facades\DB::raw('SUM(schedule_amount) as total_paid'))
                                                                        ->groupBy('payment_schedule_detail_id')
                                                                        ->pluck('total_paid', 'payment_schedule_detail_id')
                                                                        ->toArray();
                                                                @endphp

                                                                @foreach ($collection->details as $collection_detail)
                                                                    @php
                                                                        $payment_id = $collection_detail->payment_schedule_detail_id;
                                                                        $type = $collection_detail?->paymentSchedule?->payment_type;
                                                                        $name = $collection_detail?->paymentSchedule?->payment_name;
                                                                        $total_amount = $collection_detail?->paymentSchedule?->payment_amount;
                                                                        $date = date('d-M-y', strtotime($collection->collection_date));

                                                                        // এই schedule এর মোট কত টাকা দেওয়া হয়েছে
                                                                        $amount_paid = $scheduleSums[$payment_id] ?? 0;

                                                                        // check করো এই record টা last payment কিনা
                                                                        $last_payment = \App\PaymentCollectionDetails::where('payment_schedule_detail_id', $payment_id)
                                                                            ->orderBy('id', 'desc')
                                                                            ->first();

                                                                        if ($last_payment && $last_payment->id == $collection_detail->id && $amount_paid == $total_amount) {
                                                                            $text = $name . " (Rest)/" . $date; // শেষ payment ও পুরো পরিমাণ
                                                                        } else {
                                                                            $text = $name . " (Par)/" . $date; // partial payment
                                                                        }

                                                                        // Type অনুযায়ী array তে রাখো
                                                                        if($type == "DP") {
                                                                            $downPayments[$payment_id] = $text;
                                                                        } elseif($type == "installment") {
                                                                            $installments[$payment_id] = $text;
                                                                        } elseif($type == "Booking") {
                                                                            $booking[$payment_id] = $text;
                                                                        }
                                                                    @endphp
                                                                @endforeach

                                                                {{-- Down Payments --}}
                                                                @if(count($downPayments) > 0)
                                                                    {{ implode(', ', array_unique($downPayments)) }}
                                                                @endif

                                                                {{-- Installments --}}
                                                                @if(count($installments) > 0)
                                                                    @if(count($downPayments) > 0), @endif
                                                                    {{ implode(', ', array_unique($installments)) }}
                                                                @endif

                                                                {{-- Booking --}}
                                                                @if(count($booking) > 0)
                                                                    @if(count($downPayments) > 0 || count($installments) > 0), @endif
                                                                    {{ implode(', ', array_unique($booking)) }}
                                                                @endif

                                                            @endif
                                                            {{-- 12Nov2025 Html Code & Backend Code Starts(Shakib)  --}}
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>Payment Mode</td>
                                                            <td colspan="2" class="fw-500">
                                                                {{ $collection->collection_mode??'' }}
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td rowspan="2">Cash/CHQ/DD/PO</td>
                                                            @if($collection->collection_mode == "Cheque")
                                                                <td class="fw-500">Cheque No : {{ $collection->cheque_no }}</td>
                                                                <td class="fw-500">Date : {{ $collection->cheque_date }}</td>
                                                                <tr>
                                                                    <td class="fw-500">Bank : {{ $collection->cheque->bank_name }}</td>
                                                                    <td class="fw-500">Routing No : {{ $collection->cheque_details }}</td>
                                                                </tr>
                                                            @elseif($collection->collection_mode == "Direct Deposit (Cash)")  
                                                                <td class="fw-500">Bank : {{ $collection->dpCash->bank_name }}</td>
                                                                <td class="fw-500">Date : {{ $collection->dep_cash_date }}</td>
                                                                <tr>
                                                                    <td colspan="2" class="fw-500">DP Slip No : {{ $collection->dep_cash_slip_no }}</td>
                                                                </tr>  
                                                            @elseif($collection->collection_mode == "Direct Deposit (Cheque)")  
                                                                <td class="fw-500">Bank : {{ $collection->dpCheque->bank_name }}</td>
                                                                <td class="fw-500">Date : {{ $collection->dep_cheque_date }}</td>
                                                                <tr>
                                                                    <td colspan="2" class="fw-500">DP Slip No : {{ $collection->dep_cheque_slip_no }}</td>
                                                                </tr>
                                                            @elseif($collection->collection_mode == "Fund Transfer")  
                                                                <td class="fw-500">From Bank : {{ $collection->fundTrFrom->bank_name }}</td>
                                                                <td class="fw-500">To Bank : {{ $collection->fundTrTo->bank_name  }}</td>
                                                                <tr>
                                                                    <td colspan="2" class="fw-500">Transfer Date : {{ $collection->fund_trans_date }}</td>
                                                                </tr>  
                                                            @elseif($collection->collection_mode == "Pay Order")  
                                                                <td class="fw-500">Bank : {{ $collection->payOrder->bank_name }}</td>
                                                                <td class="fw-500">Pay Order Date : {{ $collection->pay_order_date }}</td>
                                                                <tr>
                                                                    <td colspan="2" class="fw-500">Pay Order No : {{ $collection->pay_order_no }}</td>
                                                                </tr>
                                                            @elseif($collection->collection_mode == "Demand Draft")  
                                                                <td class="fw-500">Bank : {{ $collection->demandDraft->bank_name }}</td>
                                                                <td class="fw-500">Draft Date : {{ $collection->demand_draft_date }}</td>
                                                            @elseif($collection->collection_mode == "Cash")  
                                                                 <td>-</td>
                                                                <td>-</td>
                                                                <tr>
                                                                    <td>-</td>
                                                                    <td>-</td>
                                                                </tr>
                                                            @endif
                                                            
                                                        </tr>
                                                        <tr>
                                                            <td>Remarks</td>
                                                            <td colspan="2">
                                                               {{ $collection->remarks??'' }}
                                                            </td>
                                                        </tr>
                                                    </table>
                                                    <div class="custom-row mt-2">
                                                        <div class="nested-left">
                                                            <img src="{{asset('uploads/images/fanam_group.jpg')}}" height="60px"
                                                                alt="">
                                                        </div>
                                                        <div class="nested-right">
                                                            <table class="w-100">
                                                                <tr>
                                                                    <td></td>
                                                                    <td></td>
                                                                </tr>
                                                                <tr>
                                                                    <td class="text-center">Prepared By</td>
                                                                    <td class="text-center">Deposited By</td>
                                                                </tr>
                                                            </table>
                                                            
                                                        </div>
                                                    </div>
                                                </div>
                                                
                                                <div class="right">
                                                    <table class="w-100">
                                                        <tr>
                                                            <td colspan="2" class="text-center fw-500">MR Details</td>
                                                        </tr>
                                                        {{-- @if($collection && $collection->details)

                                                            @foreach ($collection->details as $collection_detail)

                                                                <tr>
                                                                    <td>{{ $collection_detail?->paymentSchedule?->payment_name }}</td>
                                                                    <td><span class="fw-500">Tk.&nbsp;</span>{{ $collection_detail?->schedule_amount??'' }}</td>
                                                                </tr>

                                                            @endforeach
                                                        @endif --}}
                                                        <tr>
                                                            <td>1000X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>500X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>100X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>50X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>20X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>10X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>5X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>2X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>1X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td class="fw-500">Cash Amount</td>
                                                            <td><span class="fw-500">Tk.&nbsp;</span>{{ isset($collection) ? money_format_bd($collection->collection_mode == 'Cash' ? $collection->collection_amount : 0) : money_format_bd(0) }}</td>
                                                        </tr>
                                                        <tr>
                                                            <td>Chq/PO/DD Amount</td>
                                                            <td><span class="fw-500">Tk.&nbsp;</span>
                                                            {{ isset($collection) ? money_format_bd($collection->collection_mode == 'Cheque' ? $collection->collection_amount : 0) : money_format_bd(0) }}
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>Total</td>
                                                            <td><span class="fw-500">Tk.&nbsp;</span>{{ isset($collection) ? money_format_bd($collection->collection_amount ?? 0) : money_format_bd(0) }}</td>
                                                        </tr>
                                                    </table>
                                                </div>
                                            </div>
                                            {{-- 12Nov2025 Html Code Starts(Shakib) --}}
                                            <div style="width: 91%;">
                                                <p class="small" style="text-align: end;">
                                                    N.B: This money receipt will be valid subject to encashment
                                                    of Cheque / P.O / D.D.
                                                </p>
                                            </div>
                                            {{-- 12Nov2025 Html Code Ends(Shakib) --}}
                                        </div>
                                        <p class="r-copy  position-absolute">Customer Copy</p>
                                    </div>
                                    <hr class="custom-hr">
                                    <!-- office copy -->
                                    <div class="office-copy position-relative" style="margin-top: 20px;">
                                        <div class="title">
                                            <h4 class="text-center">Fanam Real State Ltd.</h4>
                                            <span class="fw-500">Money Receipt</span>
                                        </div>
                                        <div class="content">
                                            <div class="d-flex justify-content-between w-100 mb-1">
                                                {{-- 12Nov2025 Frontend Code Update Starts(Shakib)  --}}
                                                {{-- <p class="fw-500">MR No : {{ isset($collection)?$collection->collection_prefix.$collection->collection_no:'' }}</p> --}}
                                                <p class="fw-500">MR No : PFC-{{ isset($collection)?$collection->collection_no:'' }}</p>
                                                {{-- 12Nov2025 Frontend Code Update Ends(Shakib)  --}} 
                                                <p class="fw-500">Date : {{ isset($collection)?$collection->collection_date:'' }}</p>
                                            </div>
                                            <div class="custom-row">
                                                <div class="left">
                                                  <table class="w-100">
                                                        <tr>
                                                            <td>Project Name</td>
                                                            <td colspan="2">{{ (isset($collection) && $collection->project)?$collection->project->project_name:'' }}</td>
                                                        </tr>
                                                        <tr>
                                                            <td>Client Name</td>
                                                            <td colspan="2" class="fw-500">
                                                                @if((isset($collection) && $collection->customer))
                                                                    {{ $collection->customer->firstname??'' }} {{ $collection->customer->lastname??'' }}
                                                                @endif

                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>Acc/File No</td>
                                                            <td colspan="2" class="fw-500">
                                                                @if((isset($collection) && $collection->booking))
                                                                    {{ $collection->booking->file_no??'' }}
                                                                @endif
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>Amount</td>
                                                            <td colspan="2"><span class="fw-500">Tk. </span>
                                                                {{ money_format_bd($collection->collection_amount ?? 0) }}
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>In words</td>
                                                            <td colspan="2">
                                                                <span class="fw-500">Tk. </span>
                                                                @php
                                                                    $amount = $collection->collection_amount ?? 0;

                                                                    // Check if decimal part is zero
                                                                    if (strpos($amount, '.') !== false) {
                                                                        list($intPart, $fraction) = explode('.', $amount);
                                                                        if ((int)$fraction === 0) {
                                                                            $amount_in_words = convert_number_to_words($intPart);
                                                                        } else {
                                                                            $amount_in_words = convert_number_to_words($amount);
                                                                        }
                                                                    } else {
                                                                        $amount_in_words = convert_number_to_words($amount);
                                                                    }
                                                                @endphp

                                                                {{ $amount_in_words }} Taka only
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>Deposit Purpose</td>
                                                            <td colspan="2">
                                                                {{-- 12Nov2025 Html Code & Backend Code Starts(Shakib)  --}}
                                                            @if($collection && $collection->details)

                                                                @php
                                                                    $downPayments = [];
                                                                    $installments = [];
                                                                    $booking = [];

                                                                    // প্রতিটি schedule_id অনুযায়ী total paid বের করো একবারে
                                                                    $scheduleSums = \Illuminate\Support\Facades\DB::table('collection_details')
                                                                        ->select('payment_schedule_detail_id', \Illuminate\Support\Facades\DB::raw('SUM(schedule_amount) as total_paid'))
                                                                        ->groupBy('payment_schedule_detail_id')
                                                                        ->pluck('total_paid', 'payment_schedule_detail_id')
                                                                        ->toArray();
                                                                @endphp

                                                                @foreach ($collection->details as $collection_detail)
                                                                    @php
                                                                        $payment_id = $collection_detail->payment_schedule_detail_id;
                                                                        $type = $collection_detail?->paymentSchedule?->payment_type;
                                                                        $name = $collection_detail?->paymentSchedule?->payment_name;
                                                                        $total_amount = $collection_detail?->paymentSchedule?->payment_amount;
                                                                        $date = date('d-M-y', strtotime($collection->collection_date));

                                                                        // এই schedule এর মোট কত টাকা দেওয়া হয়েছে
                                                                        $amount_paid = $scheduleSums[$payment_id] ?? 0;

                                                                        // check করো এই record টা last payment কিনা
                                                                        $last_payment = \App\PaymentCollectionDetails::where('payment_schedule_detail_id', $payment_id)
                                                                            ->orderBy('id', 'desc')
                                                                            ->first();

                                                                        if ($last_payment && $last_payment->id == $collection_detail->id && $amount_paid == $total_amount) {
                                                                            $text = $name . " (Rest)/" . $date; // শেষ payment ও পুরো পরিমাণ
                                                                        } else {
                                                                            $text = $name . " (Par)/" . $date; // partial payment
                                                                        }

                                                                        // Type অনুযায়ী array তে রাখো
                                                                        if($type == "DP") {
                                                                            $downPayments[$payment_id] = $text;
                                                                        } elseif($type == "installment") {
                                                                            $installments[$payment_id] = $text;
                                                                        } elseif($type == "Booking") {
                                                                            $booking[$payment_id] = $text;
                                                                        }
                                                                    @endphp
                                                                @endforeach

                                                                {{-- Down Payments --}}
                                                                @if(count($downPayments) > 0)
                                                                    {{ implode(', ', array_unique($downPayments)) }}
                                                                @endif

                                                                {{-- Installments --}}
                                                                @if(count($installments) > 0)
                                                                    @if(count($downPayments) > 0), @endif
                                                                    {{ implode(', ', array_unique($installments)) }}
                                                                @endif

                                                                {{-- Booking --}}
                                                                @if(count($booking) > 0)
                                                                    @if(count($downPayments) > 0 || count($installments) > 0), @endif
                                                                    {{ implode(', ', array_unique($booking)) }}
                                                                @endif

                                                            @endif
                                                            {{-- 12Nov2025 Html Code & Backend Code Starts(Shakib)  --}}
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>Payment Mode</td>
                                                            <td colspan="2" class="fw-500">
                                                                {{ $collection->collection_mode??'' }}
                                                            </td>
                                                        </tr>
                                                        {{-- <tr>
                                                            <td rowspan="2">Cash/CHQ/DD/PO</td>
                                                            <td>-</td>
                                                            <td>-</td>
                                                            <tr>
                                                            <td>-</td>
                                                            <td>-</td>
                                                            </tr>
                                                        </tr> --}}
                                                        <tr>
                                                            <td rowspan="2">Cash/CHQ/DD/PO</td>
                                                            @if($collection->collection_mode == "Cheque")
                                                                <td class="fw-500">Cheque No : {{ $collection->cheque_no }}</td>
                                                                <td class="fw-500">Date : {{ $collection->cheque_date }}</td>
                                                                <tr>
                                                                    <td class="fw-500">Bank : {{ $collection->cheque->bank_name }}</td>
                                                                    <td class="fw-500">Routing No : {{ $collection->cheque_details }}</td>
                                                                </tr>
                                                            @elseif($collection->collection_mode == "Direct Deposit (Cash)")  
                                                                <td class="fw-500">Bank : {{ $collection->dpCash->bank_name }}</td>
                                                                <td class="fw-500">Date : {{ $collection->dep_cash_date }}</td>
                                                                <tr>
                                                                    <td colspan="2" class="fw-500">DP Slip No : {{ $collection->dep_cash_slip_no }}</td>
                                                                </tr>  
                                                            @elseif($collection->collection_mode == "Direct Deposit (Cheque)")  
                                                                <td class="fw-500">Bank : {{ $collection->dpCheque->bank_name }}</td>
                                                                <td class="fw-500">Date : {{ $collection->dep_cheque_date }}</td>
                                                                <tr>
                                                                    <td colspan="2" class="fw-500">DP Slip No : {{ $collection->dep_cheque_slip_no }}</td>
                                                                </tr>
                                                            @elseif($collection->collection_mode == "Fund Transfer")  
                                                                <td class="fw-500">From Bank : {{ $collection->fundTrFrom->bank_name }}</td>
                                                                <td class="fw-500">To Bank : {{ $collection->fundTrTo->bank_name  }}</td>
                                                                <tr>
                                                                    <td colspan="2" class="fw-500">Transfer Date : {{ $collection->fund_trans_date }}</td>
                                                                </tr>  
                                                            @elseif($collection->collection_mode == "Pay Order")  
                                                                <td class="fw-500">Bank : {{ $collection->payOrder->bank_name }}</td>
                                                                <td class="fw-500">Pay Order Date : {{ $collection->pay_order_date }}</td>
                                                                <tr>
                                                                    <td colspan="2" class="fw-500">Pay Order No : {{ $collection->pay_order_no }}</td>
                                                                </tr>
                                                            @elseif($collection->collection_mode == "Demand Draft")  
                                                                <td class="fw-500">Bank : {{ $collection->demandDraft->bank_name }}</td>
                                                                <td class="fw-500">Draft Date : {{ $collection->demand_draft_date }}</td>
                                                            @elseif($collection->collection_mode == "Cash")  
                                                                 <td>-</td>
                                                                <td>-</td>
                                                                <tr>
                                                                    <td>-</td>
                                                                    <td>-</td>
                                                                </tr>
                                                            @endif
                                                            
                                                        </tr>
                                                        <tr>
                                                            <td>Remarks</td>
                                                            <td colspan="2">
                                                               {{ $collection->remarks??'' }}
                                                            </td>
                                                        </tr>
                                                    </table>
                                                    <div class="custom-row mt-2">
                                                        <div class="nested-left">
                                                            <img src="{{asset('uploads/images/fanam_group.jpg')}}" height="60px"
                                                                alt="">
                                                        </div>
                                                        <div class="nested-right">
                                                            <table class="w-100">
                                                                <tr>
                                                                    <td></td>
                                                                    <td></td>
                                                                </tr>
                                                                <tr>
                                                                    <td class="text-center">Prepared By</td>
                                                                    <td class="text-center">Deposited By</td>
                                                                </tr>
                                                            </table>
                                                            {{-- <p class="small">
                                                                N.B: This money receipt will be valid subject to encashment
                                                                of Cheque / P.O / D.D.
                                                            </p> --}}
                                                        </div>
                                                        
                                                    </div>
                                                    
                                                </div>
                                                <div class="right">
                                                    <table class="w-100">
                                                        <tr>
                                                            <td colspan="2" class="text-center fw-500">MR Details</td>
                                                        </tr>
                                                        {{-- @if($collection && $collection->details)

                                                            @foreach ($collection->details as $collection_detail)

                                                                <tr>
                                                                    <td>{{ $collection_detail?->paymentSchedule?->payment_name }}</td>
                                                                    <td><span class="fw-500">Tk.&nbsp;</span>{{ $collection_detail?->schedule_amount??'' }}</td>
                                                                </tr>

                                                            @endforeach
                                                        @endif --}}
                                                        <tr>
                                                            <td>1000X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>500X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>100X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>50X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>20X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>10X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>5X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>2X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>1X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td class="fw-500">Cash Amount</td>
                                                            <td><span class="fw-500">Tk.&nbsp;</span>{{ isset($collection) ? money_format_bd($collection->collection_mode == 'Cash' ? $collection->collection_amount : 0) : money_format_bd(0) }}</td>
                                                        </tr>
                                                        <tr>
                                                            <td>Chq/PO/DD Amount</td>
                                                            <td><span class="fw-500">Tk.&nbsp;</span>{{ isset($collection) ? money_format_bd($collection->collection_mode == 'Cheque' ? $collection->collection_amount : 0) : money_format_bd(0) }}</td>
                                                        </tr>
                                                        <tr>
                                                            <td>Total</td>
                                                            <td><span class="fw-500">Tk.&nbsp;</span>{{ isset($collection) ? money_format_bd($collection->collection_amount ?? 0) : money_format_bd(0) }}</td>
                                                        </tr>
                                                    </table>
                                                </div>
                                            </div>
                                            {{-- 12Nov2025 Html Code Starts(Shakib) --}}
                                                <div style="width: 91%;">
                                                    <p class="small" style="text-align: end;">
                                                        N.B: This money receipt will be valid subject to encashment
                                                        of Cheque / P.O / D.D.
                                                    </p>
                                                </div>
                                            {{-- 12Nov2025 Html Code Ends(Shakib) --}}
                                        </div>
                                        <p class="r-copy office position-absolute">Office Copy</p>
                                    </div>
                                    <hr class="custom-hr">
                                    <!-- accounts copy -->
                                    <div class="accounts-copy position-relative" style="margin-top: 20px;">
                                        <div class="title">
                                            <h4 class="text-center">Fanam Real State Ltd.</h4>
                                            <span class="fw-500">Money Receipt</span>
                                        </div>
                                        <div class="content">
                                            <div class="d-flex justify-content-between w-100 mb-1">
                                                {{-- 12Nov2025 Frontend Code Update Starts(Shakib)  --}}
                                                {{-- <p class="fw-500">MR No : {{ isset($collection)?$collection->collection_prefix.$collection->collection_no:'' }}</p> --}}
                                                <p class="fw-500">MR No : PFC-{{ isset($collection)?$collection->collection_no:'' }}</p>
                                                {{-- 12Nov2025 Frontend Code Update Ends(Shakib)  --}} 
                                                <p class="fw-500">Date : {{ isset($collection)?$collection->collection_date:'' }}</p>
                                            </div>
                                            <div class="custom-row">
                                                <div class="left">
                                                   <table class="w-100">
                                                        <tr>
                                                            <td>Project Name</td>
                                                            <td colspan="2">{{ (isset($collection) && $collection->project)?$collection->project->project_name:'' }}</td>
                                                        </tr>
                                                        <tr>
                                                            <td>Client Name</td>
                                                            <td colspan="2" class="fw-500">
                                                                @if((isset($collection) && $collection->customer))
                                                                    {{ $collection->customer->firstname??'' }} {{ $collection->customer->lastname??'' }}
                                                                @endif

                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>Acc/File No</td>
                                                            <td colspan="2" class="fw-500">
                                                                @if((isset($collection) && $collection->booking))
                                                                    {{ $collection->booking->file_no??'' }}
                                                                @endif
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>Amount</td>
                                                            <td colspan="2"><span class="fw-500">Tk. </span>
                                                                {{ money_format_bd($collection->collection_amount ?? 0) }}
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>In words</td>
                                                            <td colspan="2">
                                                                <span class="fw-500">Tk. </span>
                                                                @php
                                                                    $amount = $collection->collection_amount ?? 0;

                                                                    // Check if decimal part is zero
                                                                    if (strpos($amount, '.') !== false) {
                                                                        list($intPart, $fraction) = explode('.', $amount);
                                                                        if ((int)$fraction === 0) {
                                                                            $amount_in_words = convert_number_to_words($intPart);
                                                                        } else {
                                                                            $amount_in_words = convert_number_to_words($amount);
                                                                        }
                                                                    } else {
                                                                        $amount_in_words = convert_number_to_words($amount);
                                                                    }
                                                                @endphp

                                                                {{ $amount_in_words }} Taka only
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>Deposit Purpose</td>
                                                            <td colspan="2">
                                                                {{-- 12Nov2025 Html Code & Backend Code Starts(Shakib)  --}}
                                                            @if($collection && $collection->details)

                                                                @php
                                                                    $downPayments = [];
                                                                    $installments = [];
                                                                    $booking = [];

                                                                    // প্রতিটি schedule_id অনুযায়ী total paid বের করো একবারে
                                                                    $scheduleSums = \Illuminate\Support\Facades\DB::table('collection_details')
                                                                        ->select('payment_schedule_detail_id', \Illuminate\Support\Facades\DB::raw('SUM(schedule_amount) as total_paid'))
                                                                        ->groupBy('payment_schedule_detail_id')
                                                                        ->pluck('total_paid', 'payment_schedule_detail_id')
                                                                        ->toArray();
                                                                @endphp

                                                                @foreach ($collection->details as $collection_detail)
                                                                    @php
                                                                        $payment_id = $collection_detail->payment_schedule_detail_id;
                                                                        $type = $collection_detail?->paymentSchedule?->payment_type;
                                                                        $name = $collection_detail?->paymentSchedule?->payment_name;
                                                                        $total_amount = $collection_detail?->paymentSchedule?->payment_amount;
                                                                        $date = date('d-M-y', strtotime($collection->collection_date));

                                                                        // এই schedule এর মোট কত টাকা দেওয়া হয়েছে
                                                                        $amount_paid = $scheduleSums[$payment_id] ?? 0;

                                                                        // check করো এই record টা last payment কিনা
                                                                        $last_payment = \App\PaymentCollectionDetails::where('payment_schedule_detail_id', $payment_id)
                                                                            ->orderBy('id', 'desc')
                                                                            ->first();

                                                                        if ($last_payment && $last_payment->id == $collection_detail->id && $amount_paid == $total_amount) {
                                                                            $text = $name . " (Rest)/" . $date; // শেষ payment ও পুরো পরিমাণ
                                                                        } else {
                                                                            $text = $name . " (Par)/" . $date; // partial payment
                                                                        }

                                                                        // Type অনুযায়ী array তে রাখো
                                                                        if($type == "DP") {
                                                                            $downPayments[$payment_id] = $text;
                                                                        } elseif($type == "installment") {
                                                                            $installments[$payment_id] = $text;
                                                                        } elseif($type == "Booking") {
                                                                            $booking[$payment_id] = $text;
                                                                        }
                                                                    @endphp
                                                                @endforeach

                                                                {{-- Down Payments --}}
                                                                @if(count($downPayments) > 0)
                                                                    {{ implode(', ', array_unique($downPayments)) }}
                                                                @endif

                                                                {{-- Installments --}}
                                                                @if(count($installments) > 0)
                                                                    @if(count($downPayments) > 0), @endif
                                                                    {{ implode(', ', array_unique($installments)) }}
                                                                @endif

                                                                {{-- Booking --}}
                                                                @if(count($booking) > 0)
                                                                    @if(count($downPayments) > 0 || count($installments) > 0), @endif
                                                                    {{ implode(', ', array_unique($booking)) }}
                                                                @endif

                                                            @endif
                                                            {{-- 12Nov2025 Html Code & Backend Code Starts(Shakib)  --}}
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>Payment Mode</td>
                                                            <td colspan="2" class="fw-500">
                                                                {{ $collection->collection_mode??'' }}
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td rowspan="2">Cash/CHQ/DD/PO</td>
                                                            @if($collection->collection_mode == "Cheque")
                                                                <td class="fw-500">Cheque No : {{ $collection->cheque_no }}</td>
                                                                <td class="fw-500">Date : {{ $collection->cheque_date }}</td>
                                                                <tr>
                                                                    <td class="fw-500">Bank : {{ $collection->cheque->bank_name }}</td>
                                                                    <td class="fw-500">Routing No : {{ $collection->cheque_details }}</td>
                                                                </tr>
                                                            @elseif($collection->collection_mode == "Direct Deposit (Cash)")  
                                                                <td class="fw-500">Bank : {{ $collection->dpCash->bank_name }}</td>
                                                                <td class="fw-500">Date : {{ $collection->dep_cash_date }}</td>
                                                                <tr>
                                                                    <td colspan="2" class="fw-500">DP Slip No : {{ $collection->dep_cash_slip_no }}</td>
                                                                </tr>  
                                                            @elseif($collection->collection_mode == "Direct Deposit (Cheque)")  
                                                                <td class="fw-500">Bank : {{ $collection->dpCheque->bank_name }}</td>
                                                                <td class="fw-500">Date : {{ $collection->dep_cheque_date }}</td>
                                                                <tr>
                                                                    <td colspan="2" class="fw-500">DP Slip No : {{ $collection->dep_cheque_slip_no }}</td>
                                                                </tr>
                                                            @elseif($collection->collection_mode == "Fund Transfer")  
                                                                <td class="fw-500">From Bank : {{ $collection->fundTrFrom->bank_name }}</td>
                                                                <td class="fw-500">To Bank : {{ $collection->fundTrTo->bank_name  }}</td>
                                                                <tr>
                                                                    <td colspan="2" class="fw-500">Transfer Date : {{ $collection->fund_trans_date }}</td>
                                                                </tr>  
                                                            @elseif($collection->collection_mode == "Pay Order")  
                                                                <td class="fw-500">Bank : {{ $collection->payOrder->bank_name }}</td>
                                                                <td class="fw-500">Pay Order Date : {{ $collection->pay_order_date }}</td>
                                                                <tr>
                                                                    <td colspan="2" class="fw-500">Pay Order No : {{ $collection->pay_order_no }}</td>
                                                                </tr>
                                                            @elseif($collection->collection_mode == "Demand Draft")  
                                                                <td class="fw-500">Bank : {{ $collection->demandDraft->bank_name }}</td>
                                                                <td class="fw-500">Draft Date : {{ $collection->demand_draft_date }}</td>
                                                            @elseif($collection->collection_mode == "Cash")  
                                                                 <td>-</td>
                                                                <td>-</td>
                                                                <tr>
                                                                    <td>-</td>
                                                                    <td>-</td>
                                                                </tr>
                                                            @endif
                                                            
                                                        </tr>
                                                        <tr>
                                                            <td>Remarks</td>
                                                            <td colspan="2">
                                                               {{ $collection->remarks??'' }}
                                                            </td>
                                                        </tr>
                                                    </table>
                                                    <div class="custom-row mt-2">
                                                        <div class="nested-left">
                                                            <img src="{{asset('uploads/images/fanam_group.jpg')}}" height="60px"
                                                                alt="">
                                                        </div>
                                                        <div class="nested-right">
                                                            <table class="w-100">
                                                                <tr>
                                                                    <td></td>
                                                                    <td></td>
                                                                </tr>
                                                                <tr>
                                                                    <td class="text-center">Prepared By</td>
                                                                    <td class="text-center">Deposited By</td>
                                                                </tr>
                                                            </table>
                                                            {{-- <p class="small">
                                                                N.B: This money receipt will be valid subject to encashment
                                                                of Cheque / P.O / D.D.
                                                            </p> --}}
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="right">
                                                    <table class="w-100">
                                                        <tr>
                                                            <td colspan="2" class="text-center fw-500">MR Details</td>
                                                        </tr>
                                                        {{-- @if($collection && $collection->details)

                                                            @foreach ($collection->details as $collection_detail)

                                                                <tr>
                                                                    <td>{{ $collection_detail?->paymentSchedule?->payment_name }}</td>
                                                                    <td><span class="fw-500">Tk.&nbsp;</span>{{ $collection_detail?->schedule_amount??'' }}</td>
                                                                </tr>

                                                            @endforeach
                                                        @endif --}}
                                                        <tr>
                                                            <td>1000X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>500X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>100X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>50X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>20X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>10X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>5X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>2X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td>1X</td>
                                                            <td></td>
                                                        </tr>
                                                        <tr>
                                                            <td class="fw-500">Cash Amount</td>
                                                            <td><span class="fw-500">Tk.&nbsp;</span>{{ isset($collection) ? money_format_bd($collection->collection_mode == 'Cash' ? $collection->collection_amount : 0) : money_format_bd(0) }}</td>
                                                        </tr>
                                                        <tr>
                                                            <td>Chq/PO/DD Amount</td>
                                                            <td><span class="fw-500">Tk.&nbsp;</span>{{ isset($collection) ? money_format_bd($collection->collection_mode == 'Cheque' ? $collection->collection_amount : 0) : money_format_bd(0) }}</td>
                                                        </tr>
                                                        <tr>
                                                            <td>Total</td>
                                                            <td><span class="fw-500">Tk.&nbsp;</span>{{ isset($collection) ? money_format_bd($collection->collection_amount ?? 0) : money_format_bd(0) }}</td>
                                                        </tr>
                                                    </table>
                                                </div>
                                            </div>
                                            {{-- 12Nov2025 Html Code Starts(Shakib) --}}
                                                <div style="width: 91%;">
                                                    <p class="small" style="text-align: end;">
                                                        N.B: This money receipt will be valid subject to encashment
                                                        of Cheque / P.O / D.D.
                                                    </p>
                                                </div>
                                            {{-- 12Nov2025 Html Code Ends(Shakib) --}}
                                        </div>
                                        <p class="r-copy position-absolute">Accounts Copy</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="card-footer">
                <a class="btn ripple btn-warning btn-rounded" href="{{ url()->previous() }}">
                    {{ trans('cruds.back_to_list') }}
                </a>
            </div>
        </div>
    </div>
</div>
@endsection