@extends('admin.layouts.adminapp')
@section('style')
<link href='https://cdn.jsdelivr.net/npm/froala-editor@latest/css/froala_editor.pkgd.min.css' rel='stylesheet' type='text/css' />
<style>
    .table {
        width: 100%;
        table-layout: fixed;
        border-collapse: collapse;
        margin-bottom: 20px;
    }
    .table th, .table td {
        border: 1px solid #ddd;
        padding: 8px;
        word-wrap: break-word;
        text-align: center;
    }
    .table th {
        background-color: #f2f2f2;
    }
    .tab  { 
            text-align: center; 
        }
    .text-center {
        text-align: center;
    }
</style>
  <style>
    .table-wrapper {
      max-height: 750px;  /* Set the desired height for the table */
      overflow-y: auto;   /* Enables vertical scrolling */
      display: block;     /* Makes the table wrapper block-level so that the scrolling works */
    }
  
    .table {
      width: 100%;
      border-collapse: collapse;  /* Ensures no space between table borders */
    }
  
    .table thead {
      background: #ffc107; /* Optional: Adds a background color to the header */
      position: sticky;     /* Makes the header sticky */
      top: 0;               /* Sticks the header to the top */
      z-index: 1;           /* Ensures the header stays above the table body */
    }
  
    .table th, .table td {
      padding: 8px;         /* Adds padding to the cells */
      border: 1px solid #ddd; /* Adds a border to the cells */
    }
  </style>
  <meta name="csrf-token" content="{{ csrf_token() }}">


@endsection
@section('content')
    @php
        $TotalAmount = 0;
        
     
        
    @endphp
<!--start page wrapper -->
<div class="page-wrapper">
    <div class="page-content">
        <!--breadcrumb-->
        <div class="page-breadcrumb d-none d-sm-flex align-items-center mb-3">
            <div class="breadcrumb-title pe-3">Property   </div>
            <div class="ps-3">
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb mb-0 p-0">
                        <li class="breadcrumb-item"><a href="javascript:;"><i class="bx bx-home-alt"></i></a>
                        </li>
                        <li class="breadcrumb-item active" aria-current="page"> Cash Desk </li>
                    </ol>
                </nav>
            </div>
            <div class="ms-auto">
                <div class="btn-group">
                </div>
            </div>
        </div>
        <div class="row">
            <div class="col-12">
                <!-- Displaying Success Message -->
                @if(session('success'))
                    <div class="alert alert-success">
                        {{ session('success') }}
                    </div>
                @endif

                <!-- Displaying Error Messages -->
                @if($errors->any())
                    <div class="alert alert-danger">
                        <ul>
                            @foreach($errors->all() as $error)
                                <li>{{ $error }}</li>
                            @endforeach
                        </ul>
                    </div>
                @endif
            </div>
        </div>
      <!-- Include jQuery -->
        <div class="row">
            <div class="col-lg-12 mx-auto">
                <div class="card">
                    <div class="card-header radius-15 bg-primary">
                        <div class="d-flex align-items-center">
                            <h6 class="mb-0 text-white">Property Cash Desk Search</h6>
                        </div>
                    </div>
                    <div class="card-body">
                        <div class="row mb-2"> 
                            <div class="col m-2 d-grid">
                                <a href="#{{ route('properties.self-assessment-form', $property->id) }}" 
                                   target="_blank" 
                                   class="btn btn-outline-primary" 
                                   aria-label="Open Self Assessment Form in new tab">
                                    SAF
                                </a>
                            </div>
                        
                            <div class="col m-2 d-grid">
                                <a href="{{ route('properties.ledger-report', $property->id) }}" 
                                   target="_blank" 
                                   class="btn btn-outline-primary" 
                                   aria-label="Open Ledger Report in new tab">
                                    Ledger
                                </a>
                            </div> 

                            <div class="col m-2 d-grid">
                                <a href="#" target="_blank"  class="btn btn-outline-primary">Detail Ledger</a>
                            </div>
                            <!--<div class="col m-2 d-grid">-->
                            <!--    <a href="#" class="btn btn-outline-primary">Bill Generation</a>-->
                            <!--</div>-->
                            <!--<div class="col m-2 d-grid">-->
                            <!--    <a href="#" class="btn btn-outline-primary">174</a>-->
                            <!--</div>-->
                            <!--<div class="col m-2 d-grid">-->
                            <!--    <a href="#" class="btn btn-outline-primary">173</a>-->
                            <!--</div>-->
                            
                            <div class="col m-2 d-grid">
                                <a href="{{ route('properties.show',$property->id)  }}" target="_blank"   class="btn btn-outline-primary">Demand Note</a>
                            </div>
                            <div class="col m-2 d-grid">
                                <a href="{{ route('properties.edit',$property->id)  }}" class="btn btn-outline-primary">Edit </a>
                            </div>
                             
                            <hr>
                        </div>

                        <div class="row mb-2">  
                            
                            <div class="col mb-2">
                                <label class="mb-1 fw-bold d-block">Curent Year</label>
                                <div>2025-26</div>
                            </div>
                            <div class="col mb-2">
                                <label class="mb-1 fw-bold d-block">ULB</label>
                                <div>{{ $property->ulbNameCode }}</div>
                            </div>

                             
                            <hr>
                        </div>
                        @php
                        $ownerDetails = is_array($property->ownerDetails)? $property->ownerDetails : json_decode($property->ownerDetails);
                        @endphp
                        <table class="table table-bordered table-striped">
    <thead class="table-dark">
        <tr>
            <th colspan="4">Customer Details</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <th>Owner Name (English/Hindi)</th>
            <td>{{ $ownerDetails[0]->name ?? '-' }}</td>
            <th>Father / Husband (English/Hindi)</th>
            <td>{{ $ownerDetails[0]->fatherName ?? '-' }}</td>
        </tr>
        <tr>
            <th>Mobile</th>
            <td>{{ $ownerDetails[0]->mobile ?? '-' }}</td>
            <th>Email</th>
            <td>{{ $ownerDetails[0]->email ?? '-' }}</td>
        </tr>

        <tr class="table-secondary">
            <th colspan="4">Property Details</th>
        </tr>
        <tr>
            <th>Property Id</th>
            <td>{{ $property->nagarpalikaId ?? '-' }}</td>
            <th>Parcel No</th>
            <td>{{ $property->parcelNo ?? '-' }}</td>
        </tr>
        <tr>
            <th>Ward Name</th>
            <td>{{ $property->ward?->name ?? '-' }}</td>
            <th>Property Rate Zone</th>
            <td>
                {{ ($property->taxRateZone == 'Other' ? $property->taxRateZoneOther . ' (' . $property->taxRateZone . ')' : $property->tax_rate_zone->name) ?? '-' }}
            </td>
        </tr>
        <tr>
            <th>Property Area</th>
            <td colspan="3">{{ $property->totalBuiltUpAreaSqFt ?? '-' }} SqFt</td>
        </tr>
        <tr>
            <th>Property Address</th>
            <td colspan="3">
                {{ $property->houseNo ?? '' }} {{ $property->streetNoName ?? '' }} {{ $property->locality ?? '' }}
                {{ $property->colony ?? '' }} {{ $property->city ?? '' }} {{ $property->pincode ?? '' }}
            </td>
        </tr>
        <tr>
            <th>Correspondence Address</th>
            <td colspan="3">
                {{ $property->presentHouseNo ?? '' }} {{ $property->presentStreetNoName ?? '' }} {{ $property->presentLocality ?? '' }}
                {{ $property->presentColony ?? '' }} {{ $property->presentCity ?? '' }} {{ $property->presentPincode ?? '' }}
            </td>
        </tr>
        <tr>
            <th><a href="#">Update Mobile</a></th>
            <td></td>
            <th><a href="#">Update Property Id</a></th>
            <td></td>
        </tr>
    </tbody>
</table>

                        <hr>
                         @php 
                        $floorData = json_decode($property->floorData);
                        if (!is_array($floorData)) {
                            $floorData = json_decode($floorData);
                        }
                    
                        $plinth = []; $plinthSm = [];
                        if($property->propertyUse!=5)
                        {
                            foreach ($floorData as $floor) {
                                $type = $floor->floorType;
                                $area = $floor->areaSqFt ?? 0;
                                $areaSm = $floor->areaSqMt ?? 0;
                        
                                if (!isset($plinth[$type])) {
                                    $plinth[$type] = 0;
                                    $plinthSm[$type] = 0;
                                }
                        
                                $plinth[$type] += $area;
                                $plinthSm[$type] += $areaSm;
                            }
                        }
                        
                        // ✅ Total plinth area
                        $totalPlinth = array_sum($plinth);
                        $totalPlinthSm = array_sum($plinthSm);
                    
                        // ✅ Format to two decimal places
                    //    echo "Total Plinth (SqFt): " . number_format($totalPlinth, 2) . "<br>";
                      //  echo "Total Plinth (SqMt): " . number_format($totalPlinthSm, 2);
                    
                        //print_r($plinth); 
                        //echo reset($plinth);
                        //echo reset($plinthSm);
                    @endphp
                        <div class="row mb-2"> 
                            <h6 class="fw-bold mb-3 pb-2"><a href="#"> <b>संपत्ति के निर्मित क्षेत्रफल का विवरण / Details of Constructed Area of the Property</b></a></h6>
                            <!-- border-bottom-->
                            <div class="col border-bottom mb-2">
                                <table class="table table-striped text-center" border="1" cellspacing="0" cellpadding="6" width="100%"> 
                                    <tr>
                                        <th class="tab" rowspan="3">तल फ्लोर / Floor</th>
                                        <th class="tab" colspan="4">पक्का / Pucca</th>
                                        <th class="tab" colspan="4">आंशिक पक्का / Semi-Pucca</th>
                                        <th class="tab" colspan="4">कच्चा / Kachcha</th>
                                        <th class="tab"  rowspan="3" >खुली भूमि / Open Land</th>
                    
                                        <th class="tab" rowspan="3">योग / Total</th>
                                    </tr>
                                    <tr>
                                        <th class="tab" colspan="2">आवासीय / Residential</th>
                                        <th class="tab" colspan="2">व्यावसायिक / Commercial</th>
                                        <th class="tab" colspan="2">आवासीय / Residential</th>
                                        <th class="tab" colspan="2">व्यावसायिक / Commercial</th>
                                        <th class="tab" colspan="2">आवासीय / Residential</th>
                                        <th class="tab" colspan="2">व्यावसायिक / Commercial</th>
                                    </tr>
                                    <tr>
                                        <th class="tab">स्वयं के उपयोग में / Self-use</th>
                                        <th class="tab">किराये पर / Rented</th>
                                        <th class="tab">स्वयं के उपयोग में / Self-use</th>
                                        <th class="tab">किराये पर / Rented</th>
                                        <th class="tab">स्वयं के उपयोग में / Self-use</th>
                                        <th class="tab">किराये पर / Rented</th>
                                        <th class="tab">स्वयं के उपयोग में / Self-use</th>
                                        <th class="tab">किराये पर / Rented</th>
                                        <th class="tab">स्वयं के उपयोग में / Self-use</th>
                                        <th class="tab">किराये पर / Rented</th>
                                        <th class="tab">स्वयं के उपयोग में / Self-use</th>
                                        <th class="tab">किराये पर / Rented</th>
                                    </tr>
                                    <!-- Add data rows here --> 
    
                                    @php
                                        $tt = array_fill(1, 14, 0);
                                        $floorData = json_decode($property->floorData);
                                        if (!is_array($floorData)) $floorData = json_decode($floorData);
                                    @endphp
                            
                                    @foreach($floorData as $floor)
                                        @php
                                            $t = array_fill(1, 14, 0);
                                            $type = $floor->constructionType; 
                                            $usage = in_array($floor->usageType, [1, 5]) ? 1 : 2;
                                            $factor  = in_array($floor->usageFactor, [1, 'Other']) ? 1 : 2;  
                                            $area = $floor->areaSqFt;
                                            $indexMap = [
                                                    1 => [1 => [1 => 1, 2 => 2], 2 => [1 => 3, 2 => 4]], // पक्का
                                                    2 => [1 => [1 => 5, 2 => 6], 2 => [1 => 7, 2 => 8]], // आंशिक पक्का
                                                    3 => [1 => [1 => 9, 2 => 10], 2 => [1 => 11, 2 => 12]], // कच्चा
                                                    4 => [1 => [1 => 5, 2 => 6], 2 => [1 => 7, 2 => 8]], // Teen
                                                    5 => [1 => [1 => 13, 2 => 13], 2 => [1 => 13, 2 => 13]], // आंशिक पक्का
                                                    'Other' => [1 => [1 => 5, 2 => 6], 2 => [1 => 7, 2 => 8]], // आंशिक पक्का
                                                ];
                                            $index = $indexMap[$type][$usage][$factor];
                                            if($property->propertyUse!=5)
                                                $t[$index] = $area;
                                            else
                                                $t[13] = $property->plotAreaSqFt ;
                                                
                                                
                                            $tt[$index] += $area;
                                            $t[14] = array_sum($t);
                                            $tt[14] += $t[14]; 
                                        @endphp
                                        <tr>
                                            <td class="tab"> 
                                                @if($property->propertyUse!=5)
                                                {{ $floor->floorType == 'Other' ? $floor->floorTypeOther . ' (' . $floor->floorType . ')' : floorType($floor->floorType, $floors) }}
                                                @else
                                                {{  $property->property_use->name }}
                                                @endif
                                            </td>
                                            @for($i = 1; $i <= 14; $i++)
                                                <td class="tab bold">{{ $t[$i] }}</td>
                                            @endfor
                                        </tr>
                                    @endforeach
                                        <tr>
                                            <td>योग</td>
                                            @for($i = 1; $i <= 14; $i++)
                                                <td class="tab bold">{{ $tt[$i] }}</td>
                                            @endfor
                                        </tr>
                                    </table>
                                    
                                <!--<table class="table table-striped">-->
                                <!--    <thead>-->
                                <!--        <tr>-->
                                <!--            <th><input type="checkbox"></th>-->
                                <!--            <th>No.</th>-->
                                <!--            <th>Usage Type</th>-->
                                <!--            <th>Usage Factor</th>-->
                                <!--            <th>Floor</th>-->
                                <!--            <th>Construction</th>-->
                                <!--            <th>Area (SqFt)</th>-->
                                <!--            <th>Rate</th>-->
                                <!--            <th>ALV</th>-->
                                <!--            <th>Discount</th>-->
                                <!--            <th>TPV</th>-->
                                <!--            <th>Action</th>-->
                                <!--        </tr>-->
                                <!--    </thead>-->
                                <!--    <tbody>-->
                                        <!-- Table rows go here -->
                                <!--    </tbody>-->
                                <!--</table>-->
                            
                            </div>
                        </div>
                        <div class="row mb-2"> 
                            <h6 class="fw-bold mb-3 pb-2"><a href="#"><b>  आयाम विवरण / Dimension Details </b></a></h6>
                            <div class="col border-bottom mb-2">
                                <table class="table table-striped text-center">
                                    <tr class="text-center">
                                        <th class="tab">Usage type <br> (उपयोग प्रकार)</th>
                                        <th class="tab">Usage Factor <br> (उपयोग कारक)</th>
                                        <th class="tab">Floor <br> (तल)</th>
                                        <th class="tab">Construction <br> (निर्माण)</th>
                                        <th class="tab">Area <br> (क्षेत्रफल)</th>
                                        <th class="tab">Rate <br> (दर)</th>
                                        <th class="tab">ALV <br> (वार्षिक मूल्यांकन)</th>
                                        <th class="tab">TPV (10%) <br> (संपत्ति का 10% मूल्य)</th>
                                    </tr>
                            
                                    @php
                                        $TotalAmount = 0; $WTotalAmount=0;$DTotalAmount=0;
                                    @endphp
                            
                                    @foreach($floorData as $floor)
                                        @php
                                            $rate = calculateRatePHP($floor->constructionType, $floor->usageType, $floor->usageFactor, $property->taxRateZone, $property->ward?->id); 
                                            
                                            if ($property->propertyUse != 5)
                                                $area = $floor->areaSqFt;
                                            else
                                                $area = $property->plotAreaSqFt;
                            
                                            $area = $floor->areaSqFt;
                                            // $baseAmount = (($area * 80) / 100) * $rate * 12;
                                            $baseAmount = ($property->propertyUse!=5) ? ((($area * 80) / 100) * $rate * 12 ): ($area  * $rate * 12 );
                                            $discount = ($baseAmount * 10) / 100;
                                            $Wdiscount = ($baseAmount * 7.5) / 100;
                                            $Ddiscount = ($baseAmount * 2.5) / 100;
                                            $finalAmount = $baseAmount - $discount;
                            
                                            $TotalAmount += $discount;
                                            
                                            $WTotalAmount += ($property->propertyUse!=5 &&  $property->isMuncipalWaterSupply!='no')? $Wdiscount :0;
                                            $DTotalAmount += ($property->propertyUse!=5 &&  $property->isMuncipalWaterSupply!='no')? $Ddiscount :0;
                                            
                                        @endphp
                            
                                        <tr>  
                                            <td class="bold">
                                                {{ $floor->usageType == 'Other' ? $floor->usageTypeOther . ' (' . $floor->usageType . ')' : usageType2($floor->usageType, $floorUsageType) }}
                                            </td>
                                            <td class="bold">
                                                {{ $floor->usageFactor == 'Other' ? $floor->usageFactorOther . ' (' . $floor->usageFactor . ')' : usageFactors($floor->usageFactor, $usagsFactors) }}
                                            </td> 
                                            <td class="bold">
                                                {{ $floor->floorType == 'Other' ? $floor->floorTypeOther . ' (' . $floor->floorType . ')' : floorType($floor->floorType, $floors) }}
                                            </td>
                                            <td class="bold">
                                                {{ $floor->constructionType == 'Other' ? $floor->constructionTypeOther . ' (' . $floor->constructionType . ')' : yearOfConstructions($floor->constructionType, $natureOfConstructionLists) }}
                                            </td> 
                                            <td class="bold">{{ $area }} SqFt</td>    
                                            <td class="bold tab">{{ number_format($rate, 2) }}</td>
                                            <td class="bold tab">{{ number_format($baseAmount, 2) }}</td>
                                            <th class="bold tab">{{ number_format($discount, 2) }}</th> 
                                        </tr>
                                    @endforeach
                            
                                    <tr>
                                        <th style="text-align: left" colspan="7">
                                            1. संपत्ति कर कुल देय राशि 10% है।/Total due property tax is 10%.
                                        </th>
                                        <th class="bold">₹{{ number_format($TotalAmount, 2) }}/-</th>
                                     </tr>
                                     <tr>
                                        <th style="text-align: left" colspan="7">
                                             2. जल कर 7.5% कार्य प्रगति पर है।/Water Tax (7.5%) 
                                        </th>
                                        <th class="bold">₹{{ number_format($WTotalAmount, 2) }}/-</th>
                                     </tr>
                                     <tr>
                                        <th style="text-align: left" colspan="7">
                                            3. ड्रैनेज  कर 2.5% कार्य प्रगति पर है।/Drainage Tax (2.5%) 
                                        </th>
                                        <th class="bold">₹{{ number_format($DTotalAmount, 2) }}/-</th>
                                    </tr>
                            
                                    <tr>
                                        <th style="text-align: left" colspan="7">
                                            * विगत वर्षो का कोई पूर्व भुगतान लंबित है तो लंबित भुगतान तत्काल जमा करें<br>
                                            If there are any pending payments from previous years, please deposit the pending amount immediately.
                                        </th>
                                        <th class="bold"><a target="_new" href="{{ route('properties.cash-desk-propary-tax-info-and-pay', $property->id) }} " class="btn btn-info btn-sm">Pay Now</a></th>
                                    </tr>
                                </table>
                            </div> 
                        </div>
                         
                         
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@section('script')

<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.3/xlsx.full.min.js"></script> 
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.5.20/jspdf.plugin.autotable.min.js"></script>
 
<script>
    const startYear = 2020;
    const currentYear = new Date().getFullYear() + 1; // Add one extra year
    const select = document.getElementById('assessmentYear');

    for (let year = startYear; year < currentYear; year++) {
        const nextYear = year + 1;
        const optionText = `${year}-${nextYear}`;
        const option = new Option(optionText, optionText);
        select.add(option);
    }
</script>

<!--<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>-->

<!-- Add this in your <head> -->
<meta name="csrf-token" content="{{ csrf_token() }}">

<script>
    // Attach CSRF token to all AJAX requests
    $.ajaxSetup({
        headers: {
            'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
        }
    });

    function loadS(page = 1) {
        const requestData = {
            ulb: $('#ulb').val(),
            assessmentYear: $('#assessmentYear').val(),
            property_no: $('#property_no').val(),
            owner_name: $('#owner_name').val(),
            mobile_no: $('#mobile_no').val(),
            wardNo: $('#wardNo').val(),
            taxRateZone: $('#taxRateZone').val(),
            parcelNo: $('#parcelNo').val(),
            city: $('#city').val(),
            pincode: $('#pincode').val(),
            street_name: $('#street_name').val(),
            page: page
        };

        $.ajax({
            url: '{{ url('admin/properties/cash-desk') }}', // <-- Laravel route
            method: 'POST',
            data: requestData,
            dataType: 'json',
            success: function(response) {
                console.log(response);
                renderTable(response.surveyForms.data);
                renderPagination(response.surveyForms.current_page, response.surveyForms.last_page);
            },
            error: function(xhr) {
                console.error('Error loading data:', xhr);
                $('#surveyTableBody').html(`<tr><td colspan="9">Error loading data</td></tr>`);
            }
        });
    }

    function renderTable(data) {
        const tbody = $('#surveyTableBody');
        tbody.empty();

        if (!data || data.length === 0) {
            tbody.append(`<tr><td colspan="9">No records found.</td></tr>`);
            return;
        }

        data.forEach(item => {
            let ownerDetails = null;
            if (typeof item.ownerDetails === 'string') 
            {    
                ownerDetails = JSON.parse(item.ownerDetails);
            } 
            else 
            {
                ownerDetails = item.ownerDetails; 
            }
            
            //let ownerDetails = JSON.parse(item.ownerDetails);
            let ownerName = 'N/A';
            if (ownerDetails.length > 0) {
                ownerName = ['Naa','Na ','Na','Noo','Nooo'].includes(ownerDetails[0].name) ? 'N/A' : ownerDetails[0].name;
            }

            let fatherName = 'N/A';
            if (ownerDetails.length > 0) {
                fatherName = ['Naa','Na ','Na','Noo','Nooo'].includes(ownerDetails[0].fatherName) ? 'N/A' : ownerDetails[0].fatherName;
            }
            let mobile = ownerDetails.length > 0 ? ownerDetails[0].mobile : 'N/A';
            const row = `
                <tr>
                    <td><a target="_new" href="{{ route('properties.cash-desk-propary-tax-info', '') }}/${item.id}" class="btn btn-info btn-sm">${item.nagarpalikaId || ''}</a> </td>
                    <td>${item.parcelNo || ''}</td>
                    <td>${ownerName || ''}</td>
                    <td>${mobile || ''}</td>
                    <td>${item.ward.name || ''}</td>
                    <td>${item.tax_rate_zone.name || ''}</td> 
                    <td>${item.city || ''}</td>
                    <td>${item.pincode || ''}</td>
                    <td>${item.streetNoName || ''}</td>
                </tr>
            `;
            tbody.append(row);
        });
    }

    function renderPagination(currentPage, totalPages) {
        const pagination = $('#paginationLinks');
        console.log(currentPage);
        console.log(totalPages);
        pagination.empty();

        if (totalPages <= 1) return;

        let html = '';

        if (currentPage > 1) {
            html += `<button class="btn btn-sm btn-outline-primary me-1" onclick="loadS(${currentPage - 1})">Previous</button>`;
        }

        if (currentPage < totalPages) {
            html += `<button class="btn btn-sm btn-outline-primary" onclick="loadS(${currentPage + 1})">Next</button>`;
        }

        pagination.html(html);
    }
</script>

 
  
@endsection