@extends('layouts.master')
@section('title', 'Biller Dashboard')
@section('content')
    <div class="px-6 py-4 border-b border-gray-100 bg-gradient-to-r from-amber-50 to-white">

        <!-- Row 1: Heading -->
        <div class="mb-4 w-full">
            <h2 class="text-2xl font-semibold text-gray-800">{{ session('biller_org_code', '') }} Transaction Information</h2>
        </div>

        <!-- Row 2: Filters (Single Row) -->
        <div class="flex flex-wrap items-end gap-4 w-full">
            <div class="w-80">
                <label for="orgCode" class="block text-xs font-semibold text-gray-600 mb-1">Org Code<span class="text-red-800"> *</span></label>
                <input value="{{ session('biller_org_code', '') }}" type="text" readonly id="orgCode" placeholder="Enter Org Code" class="w-full px-2 py-1 text-sm border border-amber-300 rounded focus:outline-none focus:ring-1 focus:ring-amber-500 text-sm" />
            </div>
            <div class="w-50">
                <label for="startDate" class="block text-xs font-semibold text-gray-600 mb-1">Start Pay Date<span class="text-red-800"> *</span></label>
                <input type="date" id="startDate" placeholder="dd-mm-yyyy" class="w-full px-2 py-1 text-sm border border-amber-300 rounded focus:outline-none focus:ring-1 focus:ring-amber-500 text-sm" />
            </div>
            <div class="w-50">
                <label for="endDate" class="block text-xs font-semibold text-gray-600 mb-1">End Pay Date<span class="text-red-800"> *</span></label>
                <input type="date" id="endDate" placeholder="dd-mm-yyyy" class="w-full px-2 py-1 text-sm border border-amber-300 rounded focus:outline-none focus:ring-1 focus:ring-amber-500 text-sm" />
            </div>
            <div class="w-70">
                <label for="txnId" class="block text-xs font-semibold text-gray-600 mb-1">Transaction ID</label>
                <input type="text" id="txnId" placeholder="Enter Transaction ID"
                       class="w-full px-2 py-1 text-sm border border-amber-300 rounded focus:outline-none focus:ring-1 focus:ring-amber-500 text-sm" />
            </div>
            <div class="w-70">
                <label for="acctNo" class="block text-xs font-semibold text-gray-600 mb-1">Account No</label>
                <input type="text" id="acctNo" placeholder="Enter Account No" class="w-full px-2 py-1 text-sm border border-amber-300 rounded focus:outline-none focus:ring-1 focus:ring-amber-500 text-sm" />
            </div>
            <div class="w-40">
                <label for="mobileNo" class="block text-xs font-semibold text-gray-600 mb-1">Mobile Number</label>
                <input type="text" id="mobileNo" placeholder="Enter Mobile Number"
                       class="w-full px-2 py-1 text-sm border border-amber-300 rounded focus:outline-none focus:ring-1 focus:ring-amber-500 text-sm" />
            </div>
            <div class="flex items-center gap-2">
                <!-- Filter Button -->
                <button id="filterBtn" class="inline-flex items-center gap-1 px-3 py-1.5 bg-amber-400 hover:bg-amber-300 text-gray-700 rounded-lg shadow-sm hover:shadow-md text-sm transition">
                    Filter
                    <svg class="h-4 w-4" fill="none" stroke="currentColor" stroke-width="2" viewBox="0 0 24 24">
                        <path stroke-linecap="round" stroke-linejoin="round" d="M3 4h18M4 8h16M6 12h12M8 16h8" />
                    </svg>
                </button>

                <!-- Download Dropdown -->
                <div class="relative">
                    <button id="downloadBtn" class="inline-flex items-center gap-1 px-3 py-1.5 bg-green-400 hover:bg-green-300 text-gray-700 rounded-lg shadow-sm hover:shadow-md text-sm transition">
                        Download
                        <svg class="h-3 w-3 ml-1" fill="none" stroke="currentColor" stroke-width="2" viewBox="0 0 24 24">
                            <path stroke-linecap="round" stroke-linejoin="round" d="M19 9l-7 7-7-7" />
                        </svg>
                    </button>

                    <!-- Dropdown Menu -->
                    <div class="absolute right-0 mt-2 w-28 bg-white border border-gray-200 rounded-lg shadow-lg hidden" id="downloadMenu">
                        <a href="#" onclick="downloadFile('csv')" class="block px-4 py-2 text-sm text-gray-700 hover:bg-gray-100">CSV</a>
                        <a href="#" onclick="downloadFile('excel')" class="block px-4 py-2 text-sm text-gray-700 hover:bg-gray-100">Excel</a>
                        <a href="#" onclick="downloadFile('pdf')" class="block px-4 py-2 text-sm text-gray-700 hover:bg-gray-100">PDF</a>
                    </div>
                </div>
            </div>

        </div>
    </div>
    <!-- Table -->
    <!-- Summary Section -->
    <div class="mb-6">
        <!-- Date Range Display -->
        <div class="flex flex-wrap items-center justify-between mb-4">
            <h2 class="text-lg font-semibold text-gray-700">Transaction Summary</h2>
            <div class="bg-amber-50 border border-amber-200 text-amber-800 px-4 py-2 rounded-md shadow-sm text-sm font-medium">
                From: <span id="fromDate">01 Oct 2025</span> &nbsp;–&nbsp;
                To: <span id="toDate">25 Oct 2025</span>
            </div>
        </div>

        <!-- Summary Cards -->
        <div class="grid grid-cols-1 sm:grid-cols-2 lg:grid-cols-4 gap-4">
            <!-- Total Data Count -->
            <div class="bg-white shadow-sm border border-amber-200 rounded-lg p-4">
                <div class="text-gray-500 text-sm">Total Records</div>
                <div id="totalCount" class="text-2xl font-semibold text-amber-700 mt-1">0</div>
            </div>

            <!-- Total Principal Amount -->
            <div class="bg-white shadow-sm border border-amber-200 rounded-lg p-4">
                <div class="text-gray-500 text-sm">Total Principal Amount</div>
                <div id="totalPrincipal" class="text-2xl font-semibold text-amber-700 mt-1">৳0.00</div>
            </div>

            <!-- Total VAT Amount -->
            <div class="bg-white shadow-sm border border-amber-200 rounded-lg p-4">
                <div class="text-gray-500 text-sm">Total VAT Amount</div>
                <div id="totalVAT" class="text-2xl font-semibold text-amber-700 mt-1">৳0.00</div>
            </div>

            <!-- Total Amount -->
            <div class="bg-white shadow-sm border border-amber-200 rounded-lg p-4">
                <div class="text-gray-500 text-sm">Total Amount</div>
                <div id="totalAmount" class="text-2xl font-semibold text-amber-700 mt-1">৳0.00</div>
            </div>
        </div>
    </div>
    <div class="overflow-x-auto">
        <table class="min-w-full text-sm text-left border-collapse">
            <thead class="bg-amber-100 text-amber-800">
            <tr>
                <th class="px-4 py-3 font-semibold">Account Number</th>
                <th class="px-4 py-3 font-semibold">Bill Number</th>
                <th class="px-4 py-3 font-semibold">Bill Month</th>
                <th class="px-4 py-3 font-semibold">Consumer Name</th>
                <th class="px-4 py-3 font-semibold">Mobile Number</th>
                <th class="px-4 py-3 font-semibold">Pay Date</th>
                <th class="px-4 py-3 font-semibold">Principal Amount</th>
                <th class="px-4 py-3 font-semibold">VAT Amount</th>
                <th class="px-4 py-3 font-semibold">Total Amount</th>
                <th class="px-4 py-3 font-semibold">bKash Transaction ID</th>
                <th class="px-4 py-3 font-semibold">Others</th>
            </tr>
            </thead>
            <tbody id="transactionsTable" class="divide-y divide-gray-100">
            <tr><td colspan="11" class="text-center py-3 text-gray-500">Use the Filter button to load data</td></tr>
            </tbody>
        </table>
    </div>
    <!-- Pagination -->
    <div class="px-6 py-4 border-t border-gray-100 flex items-center justify-between bg-gray-50">
        <div class="text-xs text-amber-800 font-semibold">Showing <span id="currentItemsShowing">0</span> to <span id="totalItemsShowing">0</span> of <span id="totalItems">0</span> entries</div>
        <div class="flex space-x-2">
            <button id="prevPageBtn" class="px-3 py-1 border border-gray-300 rounded text-sm text-gray-700 bg-white hover:bg-gray-100 disabled:opacity-50 disabled:cursor-not-allowed" disabled>Previous</button>
            <button id="nextPageBtn" class="px-3 py-1 border border-gray-300 rounded text-sm text-white bg-amber-600 hover:bg-amber-700" disabled>Next</button>
        </div>
    </div>
@endsection
@push('scripts')
    <script>
        const today = new Date();
        const yesterday = new Date();
        yesterday.setDate(today.getDate());
        const endPicker = flatpickr("#endDate", {
            dateFormat: "d-m-Y",
            allowInput: true,
            maxDate: today
        });

        const startPicker = flatpickr("#startDate", {
            dateFormat: "d-m-Y",
            allowInput: true,
            maxDate: yesterday, // Start date cannot be today
            onChange: function(selectedDates) {
                if (selectedDates.length) {
                    const startDate = selectedDates[0];

                    // Max end date is start + 90, but not beyond today
                    let maxEndDate = new Date(startDate);
                    maxEndDate.setDate(startDate.getDate() + 90);
                    if (maxEndDate > today) maxEndDate = today;

                    endPicker.set('minDate', startDate);
                    endPicker.set('maxDate', maxEndDate);

                    const currentEndDate = endPicker.selectedDates[0];
                    if (currentEndDate) {
                        if (currentEndDate < startDate || currentEndDate > maxEndDate) {
                            endPicker.setDate(startDate);
                        }
                    }
                }
            }
        });

        const downloadBtn = document.querySelector('.relative button');
        const downloadMenu = document.getElementById('downloadMenu');

        downloadBtn.addEventListener('click', () => {
            downloadMenu.classList.toggle('hidden');
        });

        document.addEventListener('click', (e) => {
            if (!downloadBtn.contains(e.target) && !downloadMenu.contains(e.target)) {
                downloadMenu.classList.add('hidden');
            }
        });

        async function downloadFile(type) {
            const orgcode = document.getElementById('orgCode').value;
            const startdate = document.getElementById('startDate').value;
            const enddate = document.getElementById('endDate').value;

            if (!orgcode || !startdate || !enddate) {
                Swal.fire({
                    text: "Org Code, Start Date and End Date are required.",
                    icon: "error"
                });
                return;
            }

            Swal.fire({
                title: '<span style="font-size: 1.0rem; color: #92400e;">Downloading...</span>', // smaller title
                html: `
        <div style="font-size: 0.875rem; color: #92400e; margin-bottom: 0.5rem;">Please wait while your file is being prepared.</div>
        <div id="progressContainer" style="width: 100%; background: #fef3c7; border-radius: 0.5rem; height: 12px; overflow: hidden;">
            <div id="progressBar" style="width: 0%; height: 100%; background: #f59e0b; border-radius: 0.5rem;"></div>
        </div>
        <p id="progressText" style="margin-top: 0.25rem; font-size: 0.75rem; color: #92400e;">0%</p>
    `,
                allowOutsideClick: false,
                showConfirmButton: false,
                width: '320px', // smaller popup
                background: '#fffbeb', // light amber background
                didOpen: () => {
                    const progressBar = document.getElementById('progressBar');
                    const progressText = document.getElementById('progressText');

                    let simulatedProgress = 0;
                    const interval = setInterval(() => {
                        if (simulatedProgress < 90) {
                            simulatedProgress += Math.random() * 3;
                            simulatedProgress = Math.min(simulatedProgress, 90);
                            progressBar.style.width = simulatedProgress + '%';
                            progressText.innerText = Math.floor(simulatedProgress) + '%';
                        }
                    }, 200);

                    // Store interval reference for later clearing when download finishes
                    Swal.interval = interval;
                }
            });

            const progressBar = document.getElementById('progressBar');
            const progressText = document.getElementById('progressText');

            // Simulate progress
            let simulatedProgress = 0;
            const interval = setInterval(() => {
                if (simulatedProgress < 95) { // cap at 95% until download finishes
                    simulatedProgress += Math.random() * 3; // increment randomly
                    simulatedProgress = Math.min(simulatedProgress, 95);
                    progressBar.style.width = simulatedProgress + '%';
                    progressText.innerText = Math.floor(simulatedProgress) + '%';
                }
            }, 200);

            try {
                const response = await fetch(`/transactions/downloads/${type}?orgcode=${orgcode}&startdate=${startdate}&enddate=${enddate}`, {
                    method: 'GET'
                });

                const blob = await response.blob();
                clearInterval(interval); // stop simulated progress

                progressBar.style.width = '100%';
                progressText.innerText = '100%';

                // Trigger file download
                const url = window.URL.createObjectURL(blob);
                const a = document.createElement('a');
                a.href = url;
                const now = new Date();
                const pad = n => String(n).padStart(2, '0');

                const dateTimeStr =
                    now.getFullYear().toString() +
                    pad(now.getMonth() + 1) +
                    pad(now.getDate()) +
                    pad(now.getHours()) +
                    pad(now.getMinutes()) +
                    pad(now.getSeconds());
                a.download = `transactions_data_${dateTimeStr}.${type === 'csv' ? 'csv' : type === 'excel' ? 'xlsx' : 'pdf'}`;
                document.body.appendChild(a);
                a.click();
                a.remove();
                window.URL.revokeObjectURL(url);

                Swal.close();
            } catch (err) {
                clearInterval(interval);
                Swal.fire({
                    icon: 'error',
                    text: 'Download failed: ' + err.message
                });
            }
        }
    </script>
    <script>
        document.addEventListener("DOMContentLoaded", function() {
            const filterBtn = document.getElementById('filterBtn');
            const tableBody = document.getElementById('transactionsTable');
            const prevPageBtn = document.getElementById('prevPageBtn');
            const nextPageBtn = document.getElementById('nextPageBtn');
            // Transaction Summary section
            const summarySection = document.querySelector('.mb-6');
            const fromDateEl = document.getElementById('fromDate');
            const toDateEl = document.getElementById('toDate');
            const totalCountEl = document.getElementById('totalCount');
            const totalPrincipalEl = document.getElementById('totalPrincipal');
            const totalVATEl = document.getElementById('totalVAT');
            const totalAmountEl = document.getElementById('totalAmount');

            // Hide summary section by default
            summarySection.style.display = "none";
            let currentPage = 1;
            let totalPages = 1;

            function loadData(page = 1) {
                const payload = {
                    orgcode: document.getElementById('orgCode').value,
                    bank_tran_id: document.getElementById('txnId').value,
                    acc_num: document.getElementById('acctNo').value,
                    user_mobile: document.getElementById('mobileNo').value,
                    startdate: document.getElementById('startDate').value,
                    enddate: document.getElementById('endDate').value,
                    offset: (page - 1) * 10,
                    limit: 10
                };

                // Mandatory field check
                if(!payload.orgcode || !payload.startdate || !payload.enddate){
                    Swal.fire({
                        text: "Org Code, Start Date and End Date are required.",
                        icon: "error"
                    });
                    return;
                }

                tableBody.innerHTML = `<tr><td colspan="11" class="text-center py-3 text-gray-500">
                                                <div class="text-center">
                                                    <div role="status">
                                                        <svg aria-hidden="true" class="inline w-8 h-8 text-gray-200 animate-spin dark:text-gray-600 fill-amber-600" viewBox="0 0 100 101" fill="none" xmlns="http://www.w3.org/2000/svg">
                                                            <path d="M100 50.5908C100 78.2051 77.6142 100.591 50 100.591C22.3858 100.591 0 78.2051 0 50.5908C0 22.9766 22.3858 0.59082 50 0.59082C77.6142 0.59082 100 22.9766 100 50.5908ZM9.08144 50.5908C9.08144 73.1895 27.4013 91.5094 50 91.5094C72.5987 91.5094 90.9186 73.1895 90.9186 50.5908C90.9186 27.9921 72.5987 9.67226 50 9.67226C27.4013 9.67226 9.08144 27.9921 9.08144 50.5908Z" fill="currentColor"/>
                                                            <path d="M93.9676 39.0409C96.393 38.4038 97.8624 35.9116 97.0079 33.5539C95.2932 28.8227 92.871 24.3692 89.8167 20.348C85.8452 15.1192 80.8826 10.7238 75.2124 7.41289C69.5422 4.10194 63.2754 1.94025 56.7698 1.05124C51.7666 0.367541 46.6976 0.446843 41.7345 1.27873C39.2613 1.69328 37.813 4.19778 38.4501 6.62326C39.0873 9.04874 41.5694 10.4717 44.0505 10.1071C47.8511 9.54855 51.7191 9.52689 55.5402 10.0491C60.8642 10.7766 65.9928 12.5457 70.6331 15.2552C75.2735 17.9648 79.3347 21.5619 82.5849 25.841C84.9175 28.9121 86.7997 32.2913 88.1811 35.8758C89.083 38.2158 91.5421 39.6781 93.9676 39.0409Z" fill="currentFill"/>
                                                        </svg>
                                                        <span class="sr-only">Loading...</span>
                                                    </div>
                                                </div>
                                        </td></tr>`;

                fetch("{{ route('get-transactions') }}", {
                    method: "POST",
                    headers: {
                        "Content-Type": "application/json",
                        "X-CSRF-TOKEN": "{{ csrf_token() }}"
                    },
                    body: JSON.stringify(payload)
                })
                    .then(res => res.json())
                    .then(data => {
                        totalCountEl.textContent = data.total_count || 0;
                        totalPrincipalEl.textContent = `৳${Number(data.total_prin_amt || 0).toLocaleString('en-BD', {minimumFractionDigits: 2})}`;
                        totalVATEl.textContent = `৳${Number(data.total_vat_amt || 0).toLocaleString('en-BD', {minimumFractionDigits: 2})}`;
                        totalAmountEl.textContent = `৳${Number(data.total_tot_amt || 0).toLocaleString('en-BD', {minimumFractionDigits: 2})}`;
                        // inside .then(data => { ... })
                        const startDate = payload.startdate;
                        const endDate = payload.enddate;

                        function parseDDMMYYYY(dateStr) {
                            if (!dateStr) return null;
                            const [day, month, year] = dateStr.split('-');
                            return new Date(`${year}-${month}-${day}`);
                        }

                        const fromDate = parseDDMMYYYY(startDate);
                        const toDate = parseDDMMYYYY(endDate);

                        fromDateEl.textContent = fromDate
                            ? fromDate.toLocaleDateString('en-GB', { day: '2-digit', month: 'short', year: 'numeric' })
                            : 'N/A';

                        toDateEl.textContent = toDate
                            ? toDate.toLocaleDateString('en-GB', { day: '2-digit', month: 'short', year: 'numeric' })
                            : 'N/A';
                        if(data.data && data.data.length > 0){
                            tableBody.innerHTML = '';
                            data.data.forEach(item => {
                                // Build Others string with conditional '#' separators and styling
                                let othersValues = [
                                    item.SUBID || '',
                                    item.CONTACTNO || '',
                                    item.EXTENDEDPARAMETER1 || '',
                                    item.EXTENDEDPARAMETER2 || '',
                                    item.EXTENDEDPARAMETER3 || '',
                                    item.EXTENDEDPARAMETER4 || '',
                                    item.EXTENDEDPARAMETER5 || ''
                                ];

                                // Array of Tailwind color classes for each value
                                const colorClasses = [
                                    'text-blue-600 font-bold',
                                    'text-green-600 font-bold',
                                    'text-purple-600 font-bold',
                                    'text-orange-600 font-bold',
                                    'text-pink-600 font-bold',
                                    'text-indigo-600 font-bold',
                                    'text-red-600 font-bold'
                                ];

                                let Others = othersValues
                                    .map((val, index) => val !== '' ? `<span class="${colorClasses[index]}">${val}</span>` : '')
                                    .filter(val => val !== '')
                                    .join('<span class="text-gray-400 mx-1">#</span>');

                                tableBody.innerHTML += `
                                    <tr class="hover:bg-gray-50 transition">
                                        <td class="px-4 py-3">${item.ACC_NUM || ''}</td>
                                        <td class="px-4 py-3">${item.BILL_NUM || ''}</td>
                                        <td class="px-4 py-3">${item.BILL_MON || ''}</td>
                                        <td class="px-4 py-3">${item.CONS_NAME || ''}</td>
                                        <td class="px-4 py-3">${item.USER_MOBILE || ''}</td>
                                        <td class="px-4 py-3">${item.PAY_DATE || ''}</td>
                                        <td class="px-4 py-3 text-right">${item.PRIN_AMT || ''}</td>
                                        <td class="px-4 py-3 text-right">${item.VAT_AMT || ''}</td>
                                        <td class="px-4 py-3 text-right">${item.TOT_AMT || ''}</td>
                                        <td class="px-4 py-3 text-right">${item.BKASH_TRANS_ID || ''}</td>
                                        <td class="px-4 py-3">${Others}</td>
                                    </tr>
                                `;
                            });

                            currentPage = page;
                            totalPages = Math.ceil(data.total / 10);
                            prevPageBtn.disabled = currentPage <= 1;
                            nextPageBtn.disabled = currentPage >= totalPages;

                            // Update info
                            document.getElementById('currentItemsShowing').innerText = (payload.offset + 1);
                            document.getElementById('totalItemsShowing').innerText = payload.offset + data.data.length;
                            document.getElementById('totalItems').innerText = data.total;

                            // ✅ Show the summary section
                            summarySection.style.display = "block";
                        } else {
                            summarySection.style.display = "none";
                            tableBody.innerHTML = `<tr><td colspan="11" class="text-center py-3 text-gray-500">No records found</td></tr>`;
                        }
                    })
                    .catch(() => {
                        summarySection.style.display = "none";
                        tableBody.innerHTML = `<tr><td colspan="11" class="text-center py-3 text-red-500">Error loading data</td></tr>`;
                    });
            }

            filterBtn.addEventListener('click', function(){ loadData(1); });
            prevPageBtn.addEventListener('click', function(){ if(currentPage > 1) loadData(currentPage - 1); });
            nextPageBtn.addEventListener('click', function(){ if(currentPage < totalPages) loadData(currentPage + 1); });
        });
    </script>
@endpush