@extends('Billing.layout')

@section('content')
    <meta name="csrf-token" content="{{ csrf_token() }}">
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/flatpickr/dist/flatpickr.min.css">

    <link href="https://cdn.jsdelivr.net/npm/tom-select/dist/css/tom-select.css" rel="stylesheet">
    <script src="https://cdn.jsdelivr.net/npm/tom-select/dist/js/tom-select.complete.min.js"></script>

    <div class="row align-items-center justify-content-between mb-3 mt-3 m-2">
        <div class="col-auto">
            <h5>Sales Bills</h5>
        </div>
        <div class="col-auto d-flex gap-2">
            {{-- <button type="button" id="printBtn" class="btn btn-label-secondary">Print</button>
            <button type="button" id="exportBtn" class="btn btn-label-secondary">Export</button> --}}
        </div>
    </div>

    <div class="card p-0 m-2">

        <div class="row mb-3 align-items-end p-3 g-2">

            <div class="col-md-2">
                <label class="form-label fw-semibold">From Date</label>
                <input type="text" class="form-control" id="fromDate" placeholder="DD/MM/YYYY">
            </div>

            <div class="col-md-2">
                <label class="form-label fw-semibold">To Date</label>
                <input type="text" class="form-control" id="toDate" placeholder="DD/MM/YYYY">
            </div>

            <div class="col-md-2">
                <label class="form-label fw-semibold">Order ID</label>
                <input type="text" id="orderIdSearch" class="form-control" placeholder="Search Order ID" autocomplete="off">
            </div>

            <div class="col-md-2">
                <label class="form-label fw-semibold">Billed By</label>
                <select id="billedByFilter">
                    <option value="">All Counters</option>
                    @foreach($billingCounters ?? $counters ?? [] as $counter)
                        <option value="{{ $counter->id }}">{{ $counter->counter_name }}</option>
                    @endforeach
                </select>
            </div>

            <div class="col-md-2">
                <label class="form-label fw-semibold">Staff</label>
                <select id="staffFilter">
                    <option value="">All Staff</option>
                    @foreach($staffList ?? $staffs ?? [] as $staff)
                        <option value="{{ $staff->id }}">{{ $staff->name }}</option>
                    @endforeach
                </select>
            </div>

            <div class="col-md-2">
                <label class="form-label fw-semibold">Status</label>
                <select id="statusFilter" class="form-select">
                    <option value="">All Status</option>
                    <option value="completed">Completed</option>
                    <option value="cancelled">Cancelled</option>
                    <option value="held">Held</option>
                </select>
            </div>

            <div class="col-md-3">
                <label class="form-label fw-semibold">Search</label>
                <input type="text" id="customSearch" class="form-control" placeholder="Search Bills..." autocomplete="off">
            </div>

            <div class="col-md-1">
                <label class="form-label fw-semibold">&nbsp;</label>
                <button type="button" id="resetBtn" class="btn btn-outline-secondary w-100">Reset</button>
            </div>

            <script>
                new TomSelect("#billedByFilter", { sortField: { field: "text", direction: "asc" } });
                new TomSelect("#staffFilter", { sortField: { field: "text", direction: "asc" } });
            </script>

        </div>

        <div class="table-responsive pb-3">

            <table class="table table-bordered table-hover w-100" id="usersTable">

                <thead class="table-light">
                    <tr>
                        <th>S.No</th>
                        <th>Date</th>
                        <th class="text-nowrap">Customer Name</th>
                        <th class="text-nowrap">Customer Phone</th>
                        <th class="text-nowrap">Order ID</th>
                        <th>Serial No</th>
                        <th class="text-nowrap">Billed By</th>
                        <th class="text-nowrap">Billed In</th>
                        <th class="text-nowrap">Sold By</th>
                        <th>Payment</th>
                        <th>Total</th>
                        <th>Status</th>
                        <th>Action</th>
                    </tr>
                </thead>

                <tbody></tbody>

            </table>

        </div>

    </div>

    {{-- Cancel Bill Modal --}}
    <div class="modal fade" id="cancelBillModal" tabindex="-1">
        <div class="modal-dialog modal-sm modal-dialog-centered">
            <div class="modal-content rounded-4 p-4 py-5">
                <form action="{{ route('billing.cancel_bill') }}" method="POST">
                    @csrf
                    <h5 class="fw-bold mb-2 text-center">Cancel Bill</h5>
                    <p class="text-muted text-center">Are you sure you want to cancel this bill?</p>
                    <input type="hidden" name="id" id="cancelOrderId">
                    <div class="mb-2 text-start">
                        <label class="form-label fw-semibold">Remark</label>
                        <textarea name="remark" id="cancelRemark" class="form-control" rows="3"
                            placeholder="Reason for cancellation" required></textarea>
                    </div>
                    <div class="d-flex justify-content-center gap-3 mt-3">
                        <button type="button" class="btn btn-outline-primary" data-bs-dismiss="modal">No, Keep It</button>
                        <button type="submit" class="btn btn-danger">Yes, Cancel</button>
                    </div>
                </form>
            </div>
        </div>
    </div>

    <link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css">
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/flatpickr"></script>

    <script>
        $(document).ready(function () {

            flatpickr("#fromDate", {
                dateFormat: "Y-m-d",
                altInput: true,
                altFormat: "d/m/Y",
                allowInput: true,
                onChange: function () {
                    table.ajax.reload();
                }
            });

            flatpickr("#toDate", {
                dateFormat: "Y-m-d",
                altInput: true,
                altFormat: "d/m/Y",
                allowInput: true,
                defaultDate: new Date(),
                onChange: function () {
                    table.ajax.reload();
                }
            });

            let table = $('#usersTable').DataTable({

                processing: true,
                serverSide: true,
                responsive: false,
                autoWidth: false,
                searching: false,          // built-in box hidden; customSearch handles it
                ordering: true,
                info: true,
                lengthChange: true,
                lengthMenu: [[10, 25, 50, 100, -1], [10, 25, 50, 100, "All"]],
                pageLength: 10,
                order: [[1, 'desc']],

                ajax: {
                    url: "{{ route('billing.sales_bill_data') }}",
                    type: 'GET',
                    data: function (d) {
                        d.from_date = $('#fromDate').val();
                        d.to_date = $('#toDate').val();
                        d.order_id = $('#orderIdSearch').val();
                        d.billed_by = $('#billedByFilter').val();
                        d.staff_id = $('#staffFilter').val();
                        d.status = $('#statusFilter').val();
                        d.search = $('#customSearch').val();
                    },
                    error: function (xhr) {
                        console.error('Sales bill error:', xhr.responseText);
                        alert(xhr.responseJSON?.message || 'Unable to load sales bills.');
                    }
                },
                columnDefs: [
                    {
                        targets: '_all',
                        className: 'text-nowrap'
                    }
                ],
                dom: 'Blfrtip',

                buttons: [{
                    extend: 'excelHtml5',
                    title: 'Sales_Bill_Report',
                    filename: function () {
                        var now = new Date();
                        var date =
                            String(now.getDate()).padStart(2, '0') + '-' +
                            String(now.getMonth() + 1).padStart(2, '0') + '-' +
                            String(now.getFullYear()).slice(-2);
                        return 'Sales_Bill_Report_' + date;
                    },
                    exportOptions: {
                        columns: ':not(:last-child)'
                    },
                    className: 'd-none'
                }],

                columns: [
                    { data: 'DT_RowIndex', searchable: false, orderable: false, defaultContent: '' },
                    { data: 'created_at', name: 'created_at', defaultContent: '-' },
                    { data: 'customer_name', name: 'customer_name', defaultContent: '-' },
                    { data: 'customer_phone', name: 'customer_phone', defaultContent: '-' },
                    { data: 'order_id', name: 'order_id', defaultContent: '-' },
                    {
                        data: 'daily_serial_number',
                        name: 'daily_serial_number',
                        searchable: true,
                        defaultContent: '-'
                    },
                    { data: 'billed_by', name: '', orderable: false, searchable: false, defaultContent: '-' },
                    { data: 'billed_in', name: 'billed_in', defaultContent: '-' },
                    { data: 'staff_name', name: '', orderable: false, searchable: false, defaultContent: '-' },
                    { data: 'payment_mode', name: 'payment_mode', defaultContent: '-' },
                    { data: 'total', name: 'total', defaultContent: '₹ 0.00' },
                    { data: 'status', name: 'status', orderable: false, searchable: false, defaultContent: '-' },
                    {
                        data: null,
                        name: 'action',
                        orderable: false,
                        searchable: false,
                        render: function (data, type, row) {

                            let viewUrl = "{{ route('billing.sales_bill_view', ['id' => '__ID__']) }}"
                                .replace('__ID__', row.id);

                            let editUrl = "{{ route('billing.edit_billing', ['id' => '__ID__']) }}"
                                .replace('__ID__', row.id);

                            return `
                                        <div class="d-flex gap-2">
                                            <a href="${viewUrl}" class="btn btn-sm btn-primary">
                                                <i class="fa fa-eye"></i> View
                                            </a>
                                            <a href="${editUrl}" class="btn btn-sm btn-warning">
                                                <i class="fa fa-edit"></i> Edit
                                            </a>
                                            <button type="button" class="btn btn-sm btn-outline-danger cancelBillBtn" data-id="${row.order_id}">
                                                Cancel
                                            </button>
                                        </div>
                                    `;
                        }
                    }
                ]

            });

            let billSearchTimer;
            $('#customSearch, #orderIdSearch').on('input', function () {
                clearTimeout(billSearchTimer);
                billSearchTimer = setTimeout(() => { table.ajax.reload(); }, 400);
            });

            $('#billedByFilter, #staffFilter').on('change', function () {
                table.ajax.reload();
            });

            // Status filter only affects the table rows
            $('#statusFilter').on('change', function () {
                table.ajax.reload();
            });

            $('#resetBtn').on('click', function () {
                $('#fromDate')[0]._flatpickr.clear();
                $('#toDate')[0]._flatpickr.setDate(new Date());
                $('#orderIdSearch').val('');
                $('#customSearch').val('');
                if ($('#billedByFilter')[0]?.tomselect) $('#billedByFilter')[0].tomselect.clear();
                if ($('#staffFilter')[0]?.tomselect) $('#staffFilter')[0].tomselect.clear();
                $('#statusFilter').val('');
                table.ajax.reload();
            });

            $('#exportBtn').on('click', function () {
                const originalLength = table.page.len();

                table.page.len(-1).draw();

                table.one('draw', function () {
                    table.button('.buttons-excel').trigger();
                    table.page.len(originalLength).draw();
                });
            });

            $('#printBtn').on('click', function () {
                const params = new URLSearchParams({
                    from_date: $('#fromDate').val() || '',
                    to_date: $('#toDate').val() || '',
                    order_id: $('#orderIdSearch').val() || '',
                    billed_by: $('#billedByFilter').val() || '',
                    staff_id: $('#staffFilter').val() || '',
                    status: $('#statusFilter').val() || '',
                    search: $('#customSearch').val() || ''
                });
                window.open("{{ route('billing.sales_bill_print') }}?" + params.toString(), '_blank');
            });

            $(document).on('click', '.cancelBillBtn', function () {
                $('#cancelOrderId').val($(this).data('id'));
                $('#cancelRemark').val('');
                $('#cancelBillModal').modal('show');
            });

        });
    </script>

@endsection