@extends('Branch.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="date" id="fromDate" class="form-control"> --}}
                <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="date" id="toDate" class="form-control" value="{{ now()->format('Y-m-d') }}"> --}}
                <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 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 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="row m-2 g-3" id="summaryCardsRow">
            <div class="col-md-3">
                <div class="card p-3 h-100 border-start border-4 border-primary">
                    <div class="text-muted small fw-semibold">Total Bills</div>
                    <div class="fs-4 fw-bold" id="cardTotalBills">0</div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="card p-3 h-100 border-start border-4 border-success">
                    <div class="text-muted small fw-semibold">Completed Bills</div>
                    <div class="fs-4 fw-bold" id="cardCompletedBills">0</div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="card p-3 h-100 border-start border-4 border-danger">
                    <div class="text-muted small fw-semibold">Cancelled Bills</div>
                    <div class="fs-4 fw-bold" id="cardCancelledBills">0</div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="card p-3 h-100 border-start border-4 border-warning">
                    <div class="text-muted small fw-semibold">Earnings</div>
                    <div class="fs-4 fw-bold" id="cardProfit">₹ 0.00</div>
                </div>
            </div>
        </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('branch.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();
                    loadSummaryCards();
                }
            });

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

            function getSummaryFilterParams() {
                return {
                    from_date: $('#fromDate').val(),
                    to_date: $('#toDate').val(),
                    order_id: $('#orderIdSearch').val(),
                    billed_by: $('#billedByFilter').val(),
                    staff_id: $('#staffFilter').val(),
                    search: $('#customSearch').val(),
                };
            }

            function loadSummaryCards() {
                $.get("{{ route('branch.sales_bill_summary') }}", getSummaryFilterParams())
                    .done(function (res) {
                        if (!res.status) return;
                        $('#cardTotalBills').text(res.data.total_bills);
                        $('#cardCompletedBills').text(res.data.completed_bills);
                        $('#cardCancelledBills').text(res.data.cancelled_bills);
                        $('#cardProfit').text('₹ ' + Number(res.data.profit).toFixed(2));
                    })
                    .fail(function (xhr) {
                        console.error('Summary cards error:', xhr.responseText);
                    });
            }

            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('branch.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('branch.sales_bill_view', ['id' => '__ID__']) }}"
                                .replace('__ID__', row.id);

                            let editUrl = "{{ route('branch.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(); loadSummaryCards(); }, 400);
            });

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

            // Status filter only affects the table rows, not the cards —
            // the cards always show the full breakdown across all statuses.
            $('#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('');
                $('#billedByFilter')[0].tomselect.clear();
                $('#staffFilter')[0].tomselect.clear();
                $('#statusFilter').val('');
                table.ajax.reload();
                loadSummaryCards();
            });

            loadSummaryCards();

            $('#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();
                });
            });

            // $('#exportBtn').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.location.href = "{{ route('branch.sales_bill_export') }}?" + params.toString();
            // });

            $('#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('branch.sales_bill_print') }}?" + params.toString(), '_blank');
            });

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

        });
    </script>

@endsection