@extends('backend.partials.master')
@section('title')
    Monthly Billing
@endsection
@section('maincontent')
<main class="content">
    <div class="container-fluid p-0">
        <!-- <div class="row mb-2 mb-xl-3">
            <div class="col-auto d-none d-sm-block">
                <h3><strong></strong>Customer Invoices</h3>
            </div>
        </div> -->
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-body">
                        <h4><strong></strong>Monthly Billing</h4>
                        <form id="filterForm">
                            <div class="row">
                                 <div class="mb-3 col-md-3">
                                    <label class="form-label" for="from_date">From Date</label>
                                    <input type="date" name="from_date" id="from_date" class="form-control">
                                </div>
                                <div class="mb-3 col-md-3">
                                    <label class="form-label" for="to_date">To Date</label>
                                    <input type="date" name="to_date" id="to_date" class="form-control">
                                </div>
                                <div class="mb-3 col-md-2 d-flex align-items-end">
                                    <button type="button" id="searchBtn" class="btn btn-primary">Search</button>
                                </div>
                            </div>
                        </form>
                        <table id="datatables-buttons" class="table table-striped nowrap" style="width:100%">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th>Date</th>
                                    <th>Customer</th>
                                    <th>Max sqft</th>
                                    <th>Rate</th>
                                    <th>Total Amount</th>
                                    <th>PDF</th>
                                </tr>
                                <tr>
                                    <th></th>
                                    <th><input type="text" class="form-control" placeholder="Search date"></th>
                                    <th><input type="text" class="form-control" placeholder="Search customer"></th>
                                    <th><input type="text" class="form-control" placeholder="Search max sqft"></th>
                                    <th><input type="text" class="form-control" placeholder="Search rate"></th>
                                    <th><input type="text" class="form-control" placeholder="Search total amount"></th>
                                    <th></th>
                                </tr>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div>

    </div>
</main>
@endsection
<script>
    document.addEventListener("DOMContentLoaded", function() {
        const today = new Date();

        const formatDate = (date) => {
            const year = date.getFullYear();
            const month = String(date.getMonth() + 1).padStart(2, '0'); 
            const day = String(date.getDate()).padStart(2, '0');
            return `${year}-${month}-${day}`;
        };

        let fromDate, toDate;

        fromDate = new Date(today.getFullYear(), today.getMonth(), 1); 
        toDate = new Date(today.getFullYear(), today.getMonth() + 1, 0); 

        document.getElementById('from_date').value = formatDate(fromDate);
        document.getElementById('to_date').value = formatDate(toDate);
        
        // Datatables with Buttons
        var datatablesButtons = $("#datatables-buttons").DataTable({
            // responsive: true,
            // scrollX: true,
            processing: true,
            serverSide: true,
            orderCellsTop: true,
            fixedHeader: true,
             ajax: {
            url: "{{ route('customers.monthlybilling') }}",
            data: function (d) {
                d.from_date = $('#from_date').val(); 
                d.to_date = $('#to_date').val(); 
                d.customer_id = $('#customer_id').val(); 
                }
            },
            columns: [
                { data: 'DT_RowIndex', name: 'DT_RowIndex', orderable: false, searchable: false },
                { data: 'date', name: 'date' },
                { data: 'customer_id', name: 'customer_id' },
                { data: 'max_sqft', name: 'max_sqft' }, 
                { data: 'rate', name: 'rate' },
                { data: 'amount', name: 'amount' },
                { data: 'pdf_path', name: 'pdf_path' },
            ],
            dom: "<'row'<'col-md-6'l>>" +
            "<'row'<'col-12 mt-2'B>>" +
            "<'row'<'col-sm-12'tr>>" +
            "<'row'<'col-md-5'i><'col-md-7'p>>",
            buttons: ['copy', 'excel', 'pdf', 'print',
                {
                    extend: 'colvis',   // #xdc48; Column visibility button
                    text: 'Columns'
                }
            ],
            lengthMenu: [
                [10, 25, 50, 100, -1],
                [10, 25, 50, 100, "All"]
            ],
            drawCallback: function () {
                feather.replace(); // draw feather icons after each render
            }
        });
        // ✅ On search button click, reload the table with selected customer
        $('#searchBtn').on('click', function () {
            datatablesButtons.ajax.reload();
        });
        // Apply search filters from second header row
        $('#datatables-buttons thead tr:eq(1) th').each(function (i) {
            var input = $(this).find("input, select");
            if (input.length) {
                $(input).on("keyup change clear", function () {
                    if (datatablesButtons.column(i).search() !== this.value) {
                        datatablesButtons.column(i).search(this.value).draw();
                    }
                });
            }
        });
    });
</script>
<!-- searchable dropdown script start-->
<script>
    document.addEventListener("DOMContentLoaded", function() {
        // Choices.js
        new Choices(document.querySelector(".choices-single-customer"));
    });
</script>
<!-- searchable dropdown script end-->