@extends('layouts.admin')
@section('styles')
    <style>
        .bg-blue {
            background: #004b64 !important;
        }
    </style>
@endsection
@section('content')
    <main role="main" class="flex-shrink-0">
        <div class="container custom-container">
            <div class="login-5 mt-50 mb-50">
                <div class="container-fluid">
                    <div class="row no-gutters">
                        <div class="col-sm-12">
                            <div class="container-fluid">
                                <div class="card">
                                    <div class="card-header d-flex align-items-center justify-content-between py-3 px-3">
                                        <h4 class="mb-0 fw-bold fs-4">UTR Report</h4>
                                    </div>

                                    <div class="card-body">
                                        <div class="table-responsive">
                                            <h5 class="mb-2 text-center">--- Advance & Payment History ---</h5>
                                            <table class="table table-bordered table-hover">
                                                <thead class="bg-blue">
                                                    <tr>
                                                        <th class="bg-blue">Sr. No.</th>
                                                        <th class="bg-blue">UTR No.</th>
                                                        <th class="bg-blue">Date</th>
                                                        <th class="bg-blue">Transcode</th>
                                                        <th class="bg-blue">Beneficiary Name</th>
                                                        <th class="bg-blue">Bank Name</th>
                                                        <th class="bg-blue">Account No</th>
                                                        <th class="bg-blue">IFSC</th>
                                                        <th class="bg-blue">Amount</th>
                                                        <th class="bg-blue">Purpose Of Payment</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @php 
                                                    // prd($UtrData); 
                                                    $i = 0;
                                                    @endphp
                                                    @if(isset($UtrData) && !empty($UtrData))
                                                        @foreach($UtrData as $utrs)
                                                            <tr>
                                                                <td>{{ ++$i }}</td>
                                                                <td>{{ $utrs->{'UTR No'} ?? '' }}</td>
                                                                <td>{{ date('d-m-Y',strtotime($utrs->{'UTR Date'})) ?? '' }}</td>
                                                                <td>{{ $utrs->{'NTA Transcode'} ?? ''}}</td>
                                                                <td>{{ $utrs->{'BeneficiaryName'} ?? ''}}</td>
                                                                <td>{{ $utrs->{'BankName'} ?? ''}}</td>
                                                                <td>{{ $utrs->{'AccountNo'} ?? '' }}</td>
                                                                <td>{{ $utrs->{'IFSC'} ?? ''}}</td>
                                                                <td>{{ $utrs->{'Amount'} ?? '' }}</td>
                                                                <td>{{ $utrs->{'Description'} ?? '' }}</td>
                                                            </tr>
                                                        @endforeach
                                                    @endif
                                                </tbody>
                                            </table>

                                            <h5 class="mb-2 text-center">--- Payment Recovery History ---</h5>
                                            <table class="table table-bordered table-hover">
                                                <thead class="bg-blue">
                                                    <tr>
                                                        <th class="bg-blue">Sr. No.</th>
                                                        <th class="bg-blue">Transaction No.</th>
                                                        <th class="bg-blue">Transaction Date</th>
                                                        <th class="bg-blue">Beneficiary Name</th>
                                                        <th class="bg-blue">Bank Name</th>
                                                        <th class="bg-blue">Account No</th>
                                                        <th class="bg-blue">IFSC</th>
                                                        <th class="bg-blue">Amount To Be Paid</th>
                                                        <th class="bg-blue">Amount Paid To NTA</th>
                                                        <th class="bg-blue">Remarks</th>
                                                        <th class="bg-blue">Attachment</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @php 
                                                        // Extract unique TnxNo values
                                                        $TnxNo = collect($UtrData)
                                                                    ->pluck('TnxNo')
                                                                    ->unique()
                                                                    ->sort()
                                                                    ->values()
                                                                    ->toArray() ?? [];
                                                        $i = 0;
                                                    @endphp
                                                    
                                                    @if(isset($UtrData) && !empty($UtrData))
                                                        @foreach($TnxNo as $tnx)
                                                            @php
                                                                // Get the group of records for each unique TnxNo
                                                                $utrsGroup = collect($UtrData)->where('TnxNo', $tnx);
                                                            @endphp
                                                
                                                            @foreach($utrsGroup as $utrs)
                                                                <tr>
                                                                    @if($loop->first)
                                                                        <td>{{ ++$i }}</td>
                                                                        <td>{{ $utrs->{'TnxNo'} ?? '' }}</td>
                                                                        <td>{{ date('d-m-Y', strtotime($utrs->{'TnxDate'})) ?? '' }}</td>
                                                                        <td>{{ $utrs->{'BeneficiaryNamePaid'} ?? '' }}</td>
                                                                        <td>{{ $utrs->{'BankNamePaid'} ?? '' }}</td>
                                                                        <td>{{ $utrs->{'AccountNoPaid'} ?? '' }}</td>
                                                                        <td>{{ $utrs->{'IFSCPaid'} ?? '' }}</td>
                                                                        <td>{{ $utrsGroup->sum('AmountToBePaid') ?? '' }}</td>
                                                                        <td>{{ $utrsGroup->sum('AmountPaid') ?? '' }}</td>
                                                                        <td>{{ $utrs->{'Remarks'} ?? '' }}</td>
                                                                        <td>
                                                                            <a href="{{ asset('uploads/utr/' . $utrs->{'Attachment'} ?? '') }}" download>
                                                                                <i class="fa fa-download text-primary fs-4" aria-hidden="true"></i>
                                                                            </a>
                                                                        </td>
                                                                        
                                                                    @endif
                                                                </tr>
                                                            @endforeach
                                                        @endforeach
                                                    @endif
                                                </tbody>
                                                
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </main>
@endsection