@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>Staff Sales Report</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 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="table-responsive pb-3">
            <table class="table table-bordered table-hover w-100" id="staffReportTable">
                <thead class="table-light">
                    <tr>
                        <th>S.No</th>
                        <th>Staff ID</th>
                        <th>Staff Name</th>
                        <th>Total Bills</th>
                        <th>Completed Bills</th>
                        <th>Cancelled Bills</th>
                        <th>Earnings</th>
                    </tr>
                </thead>
                <tbody></tbody>
            </table>
        </div>

    </div>

    <link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css">
    <link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.4.2/css/buttons.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.datatables.net/buttons/2.4.2/js/dataTables.buttons.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.2/js/buttons.html5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.2/js/buttons.print.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.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: () => table.ajax.reload()
            });
            flatpickr("#toDate", {
                dateFormat: "Y-m-d", altInput: true, altFormat: "d/m/Y", allowInput: true,
                defaultDate: new Date(), onChange: () => table.ajax.reload()
            });

            let table = $('#staffReportTable').DataTable({
                processing: true,
                serverSide: true,
                searching: false,      // customSearch box drives filtering instead
                ordering: true,
                info: true,
                lengthChange: true,
                lengthMenu: [[10, 25, 50, 100, -1], [10, 25, 50, 100, "All"]],
                pageLength: 10,
                order: [[2, 'asc']],

                ajax: {
                    url: "{{ route('branch.staff_sales_report_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('Staff report error:', xhr.responseText);
                        alert(xhr.responseJSON?.message || 'Unable to load staff report.');
                    }
                },

                columnDefs: [
                    {
                        targets: '_all',
                        className: 'text-nowrap'
                    }
                ],

                columns: [
                    { data: 'DT_RowIndex', name: '', searchable: false, orderable: false, defaultContent: '' },
                    { data: 'staff_user_id', name: 'staff_user_id' },
                    { data: 'staff_name', name: 'staff_name' },
                    { data: 'total_bills', name: 'total_bills' },
                    { data: 'completed_bills', name: 'completed_bills' },
                    { data: 'cancelled_bills', name: 'cancelled_bills' },
                    { data: 'earnings', name: 'earnings' },
                ],

                dom: 'Blfrtip',
                buttons: [
                    {
                        extend: 'excelHtml5',
                        title: 'Staff_Sales_Report',
                        filename: function () {
                            const now = new Date();
                            const d = String(now.getDate()).padStart(2, '0') + '-' +
                                String(now.getMonth() + 1).padStart(2, '0') + '-' +
                                String(now.getFullYear()).slice(-2);
                            return 'Staff_Sales_Report_' + d;
                        },
                        className: 'd-none'
                    },

                ],

                language: {
                    processing: 'Loading staff report...',
                    emptyTable: 'No staff found',
                    zeroRecords: 'No matching staff found'
                }
            });

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

            $('#billedByFilter, #staffFilter, #statusFilter').on('change', () => 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();
            });


            $('#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 originalLength = table.page.len();
            //     table.page.len(-1).draw();
            //     table.one('draw', function () {
            //         table.button('.buttons-print').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('branch.staff_sales_report_print') }}?" + params.toString(), '_blank');
            });

        });
    </script>

@endsection