@extends('admin.admin_dashboard')

@section('admin')
<div class="content-body default-height">
    <div class="container-fluid">
        <div class="row page-titles">
            <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="#">Home</a></li>
                <li class="breadcrumb-item active">Due Report</li>
            </ol>
        </div>

        <div class="row">
            <div class="col-xl-12">

                <!-- ============ Filter Card ============ -->
                <div class="filter cm-content-box box-primary">
                    <div class="content-title SlideToolHeader">
                        <div class="cpa">
                            <i class="fa-solid fa-filter me-2"></i> Filter
                        </div>
                        <div class="tools">
                            <a href="#" class="expand handle"><i class="fal fa-angle-down"></i></a>
                        </div>
                    </div>

                    <div class="cm-content-body form excerpt">
                        <div class="card-body">
                            <form id="reportFilters" class="row gx-2 gy-2 align-items-end">
                                @csrf

                                <!-- Session -->
                                <div class="col-md-3">
                                    <label class="form-label">Session</label>
                                    <select name="session_id" id="session_id" class="form-control">
                                        <option value="">-- All Sessions --</option>
                                        @foreach($sessions as $s)
                                            <option value="{{ $s->id }}">
                                                {{ $s->name }}

                                            </option>
                                        @endforeach
                                    </select>
                                </div>

                                <!-- Class -->
                                <div class="col-md-3">
                                    <label class="form-label">Class</label>
                                    <select name="class_id" id="class_id" class="form-control">
                                        <option value="">-- All Classes --</option>
                                        @foreach($classes as $c)
                                            <option value="{{ $c->id }}">{{ $c->name }}</option>
                                        @endforeach
                                    </select>
                                </div>

                                <!-- Section -->
                                <div class="col-md-3">
                                    <label class="form-label">Section</label>
                                    <select name="section_id" id="section_id" class="form-control">
                                        <option value="">-- Select Section --</option>
                                    </select>
                                </div>

                                <!-- Buttons -->
                                <div class="col-md-3 text-end mt-2">
                                    <button type="button" id="applyFilters" class="btn btn-primary">
                                        <i class="fa fa-search me-1"></i> Apply Filters
                                    </button>
                                    <button type="button" id="resetFilters" class="btn btn-secondary">
                                        <i class="fa fa-refresh me-1"></i> Reset
                                    </button>
                                </div>

                                <!-- ========== Column Selection (only for print/view hide/show) ========== -->
                                <div class="col-12 mt-4">
                                    <h6><i class="fa-solid fa-table me-1"></i> Choose Columns to Print</h6>

                                    <label>
                                        <input type="checkbox" class="col-toggle"
                                               data-col="col-sl" checked> SL
                                    </label>

                                    <label class="ms-3">
                                        <input type="checkbox" class="col-toggle"
                                               data-col="col-name" checked> Student Name
                                    </label>

                                    <label class="ms-3">
                                        <input type="checkbox" class="col-toggle"
                                               data-col="col-class" checked> Class
                                    </label>

                                    <label class="ms-3">
                                        <input type="checkbox" class="col-toggle"
                                               data-col="col-section" checked> Section
                                    </label>

                                    <label class="ms-3">
                                        <input type="checkbox" class="col-toggle"
                                               data-col="col-roll" checked> Roll
                                    </label>

                                    <label class="ms-3">
                                        <input type="checkbox" class="col-toggle"
                                               data-col="col-due" checked> Due
                                    </label>

                                    <label class="ms-3">
                                        <input type="checkbox" class="col-toggle"
                                               data-col="col-due-list" checked> Due Fee List
                                    </label>

                                    <label class="ms-3">
                                        <input type="checkbox" class="col-toggle"
                                               data-col="col-total" checked> Total Amount
                                    </label>
                                </div>

                            </form>
                        </div>
                    </div>
                </div>

                <!-- ============ Report Output ============ -->
                <div class="col-12">
                    <div class="card p-3">
                        <div id="reportContainer">
                            <div class="text-center py-5">
                                <em>Apply filters to generate Due Report</em>
                            </div>
                        </div>
                    </div>
                </div>

            </div>
        </div>

    </div>
</div>

<!-- ============ Send SMS Modal ============ -->
<div class="modal fade" id="sendSmsModal" tabindex="-1" aria-labelledby="sendSmsModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="sendSmsModalLabel">Send Due Fee Reminder SMS</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <div class="mb-3">
                    <label for="paymentDeadlineDate" class="form-label">Payment Deadline Date <span class="text-danger">*</span></label>
                    <input type="date" class="form-control" id="paymentDeadlineDate" required>
                </div>

                <div class="mb-3">
                    <label for="smsSchoolName" class="form-label">স্কুলের নাম <span class="text-danger">*</span></label>
                    <input type="text" class="form-control" id="smsSchoolName" placeholder="স্কুলের নাম বাংলায় লিখুন">
                </div>

                <div class="mb-3">
                    <label for="smsBodyTemplate" class="form-label">SMS Body <span class="text-danger">*</span></label>
                    <textarea class="form-control" id="smsBodyTemplate" rows="6" style="white-space: pre-wrap;"></textarea>
                    <small class="text-muted d-block mt-1">
                        Use placeholders: <code>{student_name}</code>, <code>{month}</code>, <code>{deadline_date}</code>, <code>{school_name}</code>, <code>{due_months_phrase}</code>
                    </small>
                </div>

                <div class="mb-3">
                    <label class="form-label">SMS Preview (Personalized)</label>
                    <textarea class="form-control" id="smsPreview" rows="12" readonly style="white-space: pre-wrap; font-size: 13px; font-family: monospace;"></textarea>
                </div>

                <div class="alert alert-info small mb-0">
                    <strong>Note:</strong> This SMS will be sent to all students with due fees listed in the report.
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                <button type="button" class="btn btn-primary" id="sendSmsBtn">
                    <i class="fa fa-paper-plane me-1"></i> Send SMS
                </button>
            </div>
        </div>
    </div>
</div>
@endsection


@section('customjs')
<script>
document.addEventListener('DOMContentLoaded', function () {

    const applyBtn        = document.getElementById('applyFilters');
    const resetBtn        = document.getElementById('resetFilters');
    const reportContainer = document.getElementById('reportContainer');
    const token           = document.querySelector('meta[name="csrf-token"]').getAttribute('content');
    const DEBUG_DUE_REPORT = ['localhost', '127.0.0.1'].includes(window.location.hostname)
        || window.location.hostname.endsWith('.test');

    function debugLog(...args) {
        if (DEBUG_DUE_REPORT) {
            console.log(...args);
        }
    }

    function debugError(...args) {
        if (DEBUG_DUE_REPORT) {
            console.error(...args);
        }
    }

    // ========== AJAX Fetch ==========
    applyBtn.addEventListener('click', fetchReport);

    function getSelectedStudentIds() {
        const rowCheckboxes = currentRowCheckboxes.length
            ? currentRowCheckboxes
            : Array.from(document.querySelectorAll('.report-row-checkbox'));

        return rowCheckboxes
            .filter((checkbox) => checkbox.checked)
            .map((checkbox) => parseInt(checkbox.dataset.studentId || '', 10))
            .filter((studentId) => Number.isInteger(studentId) && studentId > 0);
    }

    function getSelectedReportRows() {
        const selectedIds = getSelectedStudentIds();
        const rows = window.smartShikkhaReportData?.reportData || [];

        const rowCheckboxes = currentRowCheckboxes.length
            ? currentRowCheckboxes
            : Array.from(document.querySelectorAll('.report-row-checkbox'));

        if (selectedIds.length === 0) {
            // Fallback for environments where data-student-id may be missing/mismatched
            return rows.filter((_, index) => Boolean(rowCheckboxes[index]?.checked));
        }

        const selectedIdSet = new Set(selectedIds);
        const selectedRows = rows.filter((row) => selectedIdSet.has(parseInt(row.student_id || '', 10)));

        if (selectedRows.length > 0) {
            return selectedRows;
        }

        // Secondary fallback: preserve checked-row intent even if id mapping fails
        return rows.filter((_, index) => Boolean(rowCheckboxes[index]?.checked));
    }

    function syncSelectAllCheckbox() {
        const selectAll = document.getElementById('selectAllDueStudents');
        if (!selectAll) return;

        const rowCheckboxes = currentRowCheckboxes.length
            ? currentRowCheckboxes
            : Array.from(document.querySelectorAll('.report-row-checkbox'));

        if (rowCheckboxes.length === 0) {
            selectAll.checked = false;
            selectAll.indeterminate = false;
            return;
        }

        const checkedCount = rowCheckboxes.filter((checkbox) => checkbox.checked).length;
        selectAll.checked = checkedCount === rowCheckboxes.length;
        selectAll.indeterminate = checkedCount > 0 && checkedCount < rowCheckboxes.length;
    }

    function refreshSmsSelectionState() {
        if (window.smartShikkhaSingleSmsData) {
            reportData = window.smartShikkhaSingleSmsData.reportData || [];
            schoolInfo = window.smartShikkhaSingleSmsData.schoolInfo || {};
        } else {
            const selectedRows = getSelectedReportRows();
            reportData = selectedRows;
            if (window.smartShikkhaReportData) {
                schoolInfo = window.smartShikkhaReportData.schoolInfo || {};
            }
        }

        scheduleSmsPreviewGeneration(true);
    }

    window.openBulkSmsModal = function () {
        window.smartShikkhaSingleSmsData = null;

        if (window.smartShikkhaReportData) {
            reportData = getSelectedReportRows();
            schoolInfo = window.smartShikkhaReportData.schoolInfo || {};

            if (!reportData.length) {
                const rowCheckboxes = currentRowCheckboxes.length
                    ? currentRowCheckboxes
                    : Array.from(document.querySelectorAll('.report-row-checkbox'));

                if (rowCheckboxes.some((checkbox) => checkbox.checked)) {
                    const rows = window.smartShikkhaReportData.reportData || [];
                    reportData = rows.filter((_, index) => Boolean(rowCheckboxes[index]?.checked));
                }
            }
        }

        if (!reportData.length) {
            toastr.error('Please select at least one student', 'Validation Error');
            return;
        }

        const modal = bootstrap.Modal.getOrCreateInstance(smsModal);
        modal.show();
    };

    window.openSingleSmsModal = function (rowData) {
        const rowCheckbox = document.querySelector(`.report-row-checkbox[data-student-id="${rowData.student_id}"]`);
        if (rowCheckbox && !rowCheckbox.checked) {
            toastr.error('This student is unselected in the report', 'Validation Error');
            return;
        }

        window.smartShikkhaSingleSmsData = {
            reportData: [rowData],
            schoolInfo: schoolInfo || window.smartShikkhaReportData?.schoolInfo || {}
        };

        reportData = window.smartShikkhaSingleSmsData.reportData;
        schoolInfo = window.smartShikkhaSingleSmsData.schoolInfo;

        const modal = bootstrap.Modal.getOrCreateInstance(smsModal);
        modal.show();
    };

    resetBtn.addEventListener('click', function () {
        document.getElementById('reportFilters').reset();
        document.getElementById('section_id').innerHTML = '<option value="">-- Select Section --</option>';
        clearSmsReportState();
        reportContainer.innerHTML =
            '<div class="text-center py-5"><em>Apply filters to generate Due Report</em></div>';
    });

    function fetchReport() {
        const form = document.getElementById('reportFilters');
        const data = new FormData(form);
        const requestId = ++activeReportRequestId;

        // A new filter request invalidates any previous SMS payload
        clearSmsReportState();

        reportContainer.innerHTML =
            '<div class="text-center py-4 text-primary">Loading...</div>';

        fetch("{{ route('accounting.due.report.data') }}", {
            method: "POST",
            headers: {
                "X-CSRF-TOKEN": token,
                "Accept": "application/json",
            },
            body: data
        })
        .then(r => r.json())
        .then(resp => {
            // Ignore stale responses when multiple filter requests are fired quickly
            if (requestId !== activeReportRequestId) return;

            if (resp.success) {
                reportContainer.innerHTML = resp.html;
                refreshRowCheckboxCache();

                // Data কে সরাসরি grab করো response থেকে
                if (resp.reportData) {
                    window.smartShikkhaReportData = {
                        reportData: resp.reportData,
                        schoolInfo: resp.schoolInfo
                    };
                    window.smartShikkhaSingleSmsData = null;
                    reportData = resp.reportData;
                    schoolInfo = resp.schoolInfo || {};
                    debugLog('✓ Data loaded:', resp.reportData.length, 'students');
                }

                requestAnimationFrame(() => {
                    applyColumnVisibility();
                    syncSelectAllCheckbox();
                });
            } else {
                clearSmsReportState();
                reportContainer.innerHTML =
                    '<div class="text-danger p-3">No data found.</div>';
            }
        })
        .catch(err => {
            if (requestId !== activeReportRequestId) return;

            clearSmsReportState();
            debugError(err);
            reportContainer.innerHTML =
                '<div class="text-danger p-3">Error fetching report.</div>';
        });
    }

    // ========== Section Load ==========
    document.getElementById('class_id').addEventListener('change', function () {
        const classId       = this.value;
        const sectionSelect = document.getElementById('section_id');

        // Changing class means previously loaded report/SMS data is stale
        clearSmsReportState();

        if (!classId) {
            sectionSelect.innerHTML = '<option value="">-- Select Section --</option>';
            return;
        }

        sectionSelect.innerHTML = '<option>Loading...</option>';

        fetch(`/admin/get-sections-by-class/${classId}`)
            .then(res => res.json())
            .then(data => {
                const sections = data.sections ?? data;
                const options = ['<option value="">-- Select Section --</option>'];

                sections.forEach(sec => {
                    options.push(`<option value="${sec.id}">${sec.name}</option>`);
                });

                sectionSelect.innerHTML = options.join('');
            })
            .catch(() => {
                sectionSelect.innerHTML = '<option value="">Error loading</option>';
            });
    });

    reportContainer.addEventListener('click', function (event) {
        const button = event.target.closest('.send-individual-sms-btn');
        if (!button) return;

        try {
            const rowData = JSON.parse(button.dataset.row || '{}');
            window.openSingleSmsModal(rowData);
        } catch (error) {
            debugError('Failed to parse row data for SMS', error);
            toastr.error('Unable to open SMS for this student', 'Error');
        }
    });

    reportContainer.addEventListener('change', function (event) {
        const checkbox = event.target.closest('.report-row-checkbox');
        if (checkbox) {
            syncSelectAllCheckbox();
            if (window.smartShikkhaSingleSmsData || smsModal?.classList.contains('show')) {
                refreshSmsSelectionState();
            }
        }

        if (event.target && event.target.id === 'selectAllDueStudents') {
            const checked = event.target.checked;

            if (!currentRowCheckboxes.length) {
                refreshRowCheckboxCache();
            }

            currentRowCheckboxes.forEach((rowCheckbox) => {
                rowCheckbox.checked = checked;
            });

            syncSelectAllCheckbox();
            if (window.smartShikkhaSingleSmsData || smsModal?.classList.contains('show')) {
                refreshSmsSelectionState();
            }
        }
    });

    // ========== Column Hide/Show (view + print) ==========
    const colToggles = document.querySelectorAll('.col-toggle');

    colToggles.forEach(chk => {
        chk.addEventListener('change', applyColumnVisibility);
    });

    function applyColumnVisibility() {
        const printArea = document.getElementById('printArea');
        if (!printArea) return; // report এখনও লোড হয়নি

        colToggles.forEach(chk => {
            const colClass = chk.dataset.col;
            printArea.classList.toggle(`hide-${colClass}`, !chk.checked);
        });
    }

    // ========== Print ==========
    window.printReport = function () {
        const srcPrintArea = document.getElementById('printArea');
        if (!srcPrintArea) return;

        // clone retains the current column visibility classes
        const clone = srcPrintArea.cloneNode(true);

        const w = window.open("", "", "width=1000,height=700");
        w.document.write('<html><head><title>Due Report</title>');
        w.document.write(`
            <style>
                @page {
                    size: A4 portrait;
                    margin: 18mm 14mm 18mm 14mm;
                }
                body {
                    font-family: "Segoe UI", Arial, sans-serif;
                    margin: 0;
                    padding: 10px;
                    color:#000;
                    text-align: center;
                }
                table {
                    width: 100%;
                    border-collapse: collapse;
                    margin-top: 15px;
                }
                th, td {
                    border: 1px solid #444;
                    padding: 6px 5px;
                    font-size: 12px;
                    text-align: center;
                }
                th {
                    background:#e3f2fd;
                    font-weight: 600;
                }
                .print-header h4 { margin:0; font-size:18px; font-weight:700; }
                .print-header p  { margin:0; font-size:13px; }
                .print-header h5 { margin:6px 0 0; font-size:14px; font-weight:600; }
                @media print {
                    button { display:none; }
                    .col-select { display:none !important; }
                    .col-sms-action { display:none !important; }
                }
            </style>
        `);
        w.document.write('</head><body>');
        w.document.write(clone.innerHTML);
        w.document.write('</body></html>');
        w.document.close();

        w.onload = function () {
            w.focus();
            w.print();
            setTimeout(() => w.close(), 500);
        };
    };

    // ========== Send SMS Modal Logic ==========
    const smsModal = document.getElementById('sendSmsModal');
    const paymentDeadlineInput = document.getElementById('paymentDeadlineDate');
    const smsSchoolNameInput = document.getElementById('smsSchoolName');
    const smsBodyTemplateInput = document.getElementById('smsBodyTemplate');
    const smsPreviewArea = document.getElementById('smsPreview');
    const sendSmsBtn = document.getElementById('sendSmsBtn');
    const DEFAULT_BN_SCHOOL_NAME = 'মাসকট ইনোভেটিভ স্কুল এন্ড কলেজ';

    let reportData = [];
    let schoolInfo = {};
    let activeReportRequestId = 0;
    let smsPreviewRafId = null;
    let smsPreviewDebounceTimer = null;
    let currentRowCheckboxes = [];

    function refreshRowCheckboxCache() {
        currentRowCheckboxes = Array.from(document.querySelectorAll('.report-row-checkbox'));
    }

    function clearSmsReportState(clearPreview = true) {
        reportData = [];
        schoolInfo = {};
        window.smartShikkhaReportData = null;
        window.smartShikkhaSingleSmsData = null;
        currentRowCheckboxes = [];

        if (clearPreview) {
            smsPreviewArea.value = '';
        }
    }

    smsModal.addEventListener('shown.bs.modal', function () {
        // Data already set by fetchReport()
        if (window.smartShikkhaSingleSmsData) {
            reportData = window.smartShikkhaSingleSmsData.reportData || [];
            schoolInfo = window.smartShikkhaSingleSmsData.schoolInfo || {};
            debugLog('✓ Single student SMS data ready:', reportData.length, 'students');
        } else if (window.smartShikkhaReportData) {
            reportData = getSelectedReportRows();
            schoolInfo = window.smartShikkhaReportData.schoolInfo || {};
            debugLog('✓ Data ready:', reportData.length, 'students');
        } else {
            smsPreviewArea.value = 'No student data. Please generate report first.';
            return;
        }

        // Set today's date if not set
        if (!paymentDeadlineInput.value) {
            const today = new Date().toISOString().split('T')[0];
            paymentDeadlineInput.value = today;
        }

        if (!smsSchoolNameInput.value.trim()) {
            smsSchoolNameInput.value = DEFAULT_BN_SCHOOL_NAME;
        }

        if (!smsBodyTemplateInput.value.trim() || isLegacySmsTemplate(smsBodyTemplateInput.value)) {
            smsBodyTemplateInput.value = getDefaultSmsTemplate();
        }

        // Always regenerate preview on modal open (date may be unchanged on second open)
        scheduleSmsPreviewGeneration(true);
    });

    paymentDeadlineInput.addEventListener('change', () => scheduleSmsPreviewGeneration(true));
    paymentDeadlineInput.addEventListener('input', scheduleSmsPreviewGeneration);
    smsSchoolNameInput.addEventListener('change', () => scheduleSmsPreviewGeneration(true));
    smsSchoolNameInput.addEventListener('input', scheduleSmsPreviewGeneration);
    smsBodyTemplateInput.addEventListener('change', () => scheduleSmsPreviewGeneration(true));
    smsBodyTemplateInput.addEventListener('input', scheduleSmsPreviewGeneration);

    function scheduleSmsPreviewGeneration(immediate = false) {
        if (smsPreviewDebounceTimer) {
            clearTimeout(smsPreviewDebounceTimer);
            smsPreviewDebounceTimer = null;
        }

        const runPreview = () => {
            if (smsPreviewRafId !== null) {
                cancelAnimationFrame(smsPreviewRafId);
            }

            smsPreviewRafId = requestAnimationFrame(() => {
                smsPreviewRafId = null;
                generateSmsPreview();
            });
        };

        if (immediate) {
            runPreview();
            return;
        }

        smsPreviewDebounceTimer = setTimeout(runPreview, 120);
    }

    function generateSmsPreview() {
        const deadlineDate = paymentDeadlineInput.value;
        const schoolNameInput = smsSchoolNameInput.value.trim();
        const smsTemplate = smsBodyTemplateInput.value.trim();
        debugLog('Date input value:', deadlineDate);
        if (!deadlineDate) {
            smsPreviewArea.value = '';
            return;
        }

        if (!schoolNameInput) {
            smsPreviewArea.value = 'Please write school name first.';
            return;
        }

        if (!smsTemplate) {
            smsPreviewArea.value = 'Please write SMS body first.';
            return;
        }

        if (!reportData || reportData.length === 0) {
            debugError('No report data loaded');
            smsPreviewArea.value = 'No student data loaded.';
            return;
        }

        debugLog('Generating SMS preview for', reportData.length, 'students');

        // Generate SMS for all students
        let allSmsTexts = [];

        reportData.forEach((firstStudent, index) => {
            try {
                const [year, month, day] = deadlineDate.split('-');
                const formattedDeadline = `${day}/${month}/${year}`;

                // Extract number - due_months should be a number
                let dueMonthsNumber = firstStudent.due_months;
                if (typeof dueMonthsNumber === 'string') {
                    dueMonthsNumber = parseInt(dueMonthsNumber.replace(/[^\d]/g, '')) || 1;
                }

                const studentName = firstStudent.name || 'Student';
                const schoolName = schoolNameInput;
                const lastMonthLabel = firstStudent.due_fee_notes && firstStudent.due_fee_notes.length > 0
                    ? firstStudent.due_fee_notes[firstStudent.due_fee_notes.length - 1].label.match(/\(([^)]+)\)/)?.[1] || 'Current Month'
                    : 'Current Month';

                const smsBody = applySmsTemplate(smsTemplate, {
                    student_name: studentName,
                    month: lastMonthLabel,
                    deadline_date: formattedDeadline,
                    school_name: schoolName,
                    due_months_phrase: formatDueMonthsEnglishPhrase(dueMonthsNumber),
                    due_months: formatDueMonthsEnglishPhrase(dueMonthsNumber)
                });

                allSmsTexts.push(smsBody);
            } catch (err) {
                debugError('Error generating SMS for student', index, err);
            }
        });

        const previewLimit = 5;
        const previewTexts = allSmsTexts.slice(0, previewLimit);
        let finalPreviewText = previewTexts.join('\n\n---\n\n');

        if (allSmsTexts.length > previewLimit) {
            finalPreviewText += `\n\n---\n\nShowing first ${previewLimit} previews out of ${allSmsTexts.length} students.`;
        }

        smsPreviewArea.value = finalPreviewText;
        debugLog('SMS preview generated for', allSmsTexts.length, 'students');
    }

    sendSmsBtn.addEventListener('click', function () {
        const deadlineDate = paymentDeadlineInput.value;
        const schoolNameInput = smsSchoolNameInput.value.trim();
        const smsTemplate = smsBodyTemplateInput.value.trim();
        if (!window.smartShikkhaSingleSmsData) {
            reportData = getSelectedReportRows();
        }

        if (!deadlineDate) {
            toastr.error('Please select a payment deadline date', 'Validation Error');
            return;
        }

        if (!schoolNameInput) {
            toastr.error('Please write school name', 'Validation Error');
            return;
        }

        if (!smsTemplate) {
            toastr.error('Please write SMS body', 'Validation Error');
            return;
        }

        if (reportData.length === 0) {
            toastr.error('No student data found', 'Error');
            return;
        }

        sendSmsBtn.disabled = true;
        sendSmsBtn.innerHTML = '<i class="fa fa-spinner fa-spin me-1"></i> Sending...';

        const [year, month, day] = deadlineDate.split('-');
        const formattedDeadline = `${day}/${month}/${year}`;

        fetch('{{ route("accounting.due.send.sms") }}', {
            method: 'POST',
            headers: {
                'X-CSRF-TOKEN': token,
                'Content-Type': 'application/json',
                'Accept': 'application/json'
            },
            body: JSON.stringify({
                deadline_date: formattedDeadline,
                school_name: schoolNameInput,
                sms_template: smsTemplate,
                report_data: reportData,
                school_info: schoolInfo,
                selected_student_ids: reportData.map((student) => student.student_id).filter(Boolean)
            })
        })
        .then(r => r.json())
        .then(resp => {
            sendSmsBtn.disabled = false;
            sendSmsBtn.innerHTML = '<i class="fa fa-paper-plane me-1"></i> Send SMS';

            if (resp.success) {
                toastr.success(resp.message, 'Success');
                const smsModal2 = bootstrap.Modal.getInstance(smsModal);
                if (smsModal2) smsModal2.hide();
            } else {
                toastr.error(resp.message || 'Failed to send SMS', 'Error');
            }
        })
        .catch(err => {
            debugError(err);
            sendSmsBtn.disabled = false;
            sendSmsBtn.innerHTML = '<i class="fa fa-paper-plane me-1"></i> Send SMS';
            toastr.error('Error sending SMS', 'Error');
        });
    });

    function formatDueMonthsEnglishPhrase(num) {
        const banglaWords = {
            1: 'এক',
            2: 'দুই',
            3: 'তিন',
            4: 'চার',
            5: 'পাঁচ',
            6: 'ছয়',
            7: 'সাত',
            8: 'আট',
            9: 'নয়',
            10: 'দশ',
            11: 'এগারো',
            12: 'বারো'
        };

        const banglaDigits = '০১২৩৪৫৬৭৮৯';
        const numericValue = parseInt(num, 10);
        const safeValue = Number.isInteger(numericValue) && numericValue > 0 ? numericValue : 0;
        const digitText = String(safeValue).replace(/\d/g, (digit) => banglaDigits[digit] ?? digit);
        const word = banglaWords[safeValue] || digitText;

        return `${digitText} (${word})`;
    }

    function getDefaultSmsTemplate() {
        return `আসসালামু আলাইকুম।
সম্মানিত অভিভাবক, আপনার আদরের সন্তান "{student_name}" এর {school_name} এর {month} পর্যন্ত {due_months_phrase} মাসের টিউশন ফিস বকেয়া হয়েছে।
আগামী {deadline_date} তারিখের মধ্যে পরিশোধ না করলে প্রতিষ্ঠানের নিয়ম অনুযায়ী উক্ত শিক্ষার্থীর ভর্তি বাতিল হয়ে যাবে।
- অধ্যক্ষ`;
    }

    function isLegacySmsTemplate(template) {
        const normalized = String(template || '').replace(/\s+/g, ' ').trim().toLowerCase();
        return normalized.includes('honorable guardian')
            || normalized.includes('outstanding tuition')
            || normalized.includes('please clear the dues');
    }

    function applySmsTemplate(template, data) {
        let message = template;

        Object.keys(data).forEach((key) => {
            const value = data[key] ?? '';
            const regex = new RegExp(`\\{\\s*${key}\\s*\\}`, 'gi');
            message = message.replace(regex, value);
        });

        if (!/\{\s*due_months_phrase\s*\}/i.test(template) && data.due_months_phrase) {
            message = message.replace(/\{\s*month\s*\}/gi, `${data.month} পর্যন্ত মোট ${data.due_months_phrase} বকেয়া`);
        }

        const hasStudent = /\{\s*student_name\s*\}/i.test(template);
        const hasMonth = /\{\s*month\s*\}/i.test(template);

        if (!hasStudent || !hasMonth) {
            message = `শিক্ষার্থী: ${data.student_name}\nমাস: ${data.month}\n${message}`;
        }

        return message;
    }

});
</script>
@endsection