@extends('layouts.admin')
@section('title', 'Product | Mintavia Admin')
<style>
    .table-responsive {
        max-height: 550px;
        /* Adjust height as needed */
        overflow-y: auto;
    }

    .table thead th {
        position: sticky;
        top: 0;
        background: white;
        z-index: 1000;
    }
</style>

@section('content')
    <div class="row">
        <div class="col-12">
            @if (isset($message) && $message)
                @switch($message['status'])
                    @case('success')
                        <script>
                            window.onload = function() {
                                toastr.success("{{ $message['message'] }}")
                            }
                        </script>
                    @break

                    @case('error')
                        <script>
                            window.onload = function() {
                                toastr.error("{{ $message['message'] }}")
                            }
                        </script>
                    @break
                @endswitch
            @endif
            <div class="card card-primary" wire:init="loadPosts">
                <div class="card-header d-flex align-items-center">
                    <h3 class="card-title">Sale Quotation Register</h3>

                </div>
                <div class="card-body">
                    <form class="" id="export" method="get"
                        action="{{ route('admin.reports.sale_orders_register') }}">
                    </form>
                    <form class="" id="filter" method="post"
                        action="{{ route('admin.reports.sale_orders_register') }}">
                        @csrf
                        <input type="hidden" name="transaction_type" value="SaleOrder">

                        <div class="row">
                            <div class="col-md-2">
                                <x-admin-input type="date" name="fromDate" id="from-date"
                                    value="{{ date('Y-m-d') }}"></x-admin-input>
                            </div>
                            <div class="col-md-2">
                                <x-admin-input type="date" name="toDate" id="to-date"
                                    value="{{ date('Y-m-d') }}"></x-admin-input>
                            </div>
                            <div class="col-md-1">
                                <button class="btn btn-success">OK</button>
                            </div>
                            <div class="col-md-1">
                                <button class="btn btn-success" id="export-pdf-btn">Export PDF</button>
                            </div>

                            <div class="col-2">
                                <input type="text" name="bill_no" id="bill_no" class="search-query form-control"
                                    placeholder="Bill NO" />
                            </div>
                            <div class="col-2">
                                <input type="text" name="account_name" id="account_name"
                                    class="search-query form-control" placeholder="Prty Name" />
                            </div>
                            <div class="col-2">
                                <input type="text" name="global_search" id="global_search"
                                    class="search-query form-control" placeholder="Search" />
                            </div>
                        </div>
                    </form>
                    <div class="table-responsive mt-1">
                        <table class="table table-sm table-striped table-bordered">
                            <thead>
                                <tr>
                                    <th>Date</th>
                                    <th>Bill No.</th>
                                    <th>Party</th>
                                    <th>Basic Amount</th>
                                    <th>Discount Amount</th>
                                    <th>Tax Amount</th>
                                    <th>Gross Amount</th>
                                    <th>Bill Discount %</th>
                                    <th>Bill Discount Amount</th>
                                    <th>Basic Tax %</th>
                                    <th>Basic Tax Amt</th>
                                    <th>Bill Net Amount</th>
                                    <th>Packaging Charges</th>
                                    <th>Tax Packaging</th>
                                    <th>Packaging Tax Amt</th>
                                    <th>Transport Charges</th>
                                    <th>Tax Transport</th>
                                    <th>Transport Tax Amt</th>
                                    <th>Additional Charges</th>
                                    <th>Net Amount</th>
                                    <th>Advance</th>
                                    <th>Balance</th>
                                    <th>Remark (Short)</th>
                                    <th>Remark (Long)</th>
                                    <th>Action</th>
                                </tr>
                            </thead>
                            <tbody id="table-list">
                                <!-- AJAX se data yahan load hoga -->
                            </tbody>
                            <tfoot>
                                <tr>
                                    <td colspan="3"><strong>Total:</strong></td>
                                    <td id="basic">0.00</td>
                                    <td id="discount">0.00</td>
                                    <td id="tax">0.00</td>
                                    <td></td>
                                    <td></td>
                                    <td id="bill_discount_amount">0.00</td>
                                    <td id="basic_per">0.00</td>
                                    <td></td>
                                    <td id="basic_tax_amt">0.00</td>
                                    <td id="bill_net_amount">0.00</td>
                                    <td id="packaging_charges">0.00</td>
                                    <td></td>
                                    <td></td>
                                    <td id="transport_charges">0.00</td>
                                    <td></td>
                                    <td id="transport_tax_amt">0.00</td>
                                    <td id="bill_additional_charges">0.00</td>
                                    <td id="net">0.00</td>
                                    <td id="advance">0.00</td>
                                    <td id="balance">0.00</td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection


@section('js')
    <script>
        (function($) {
            $(function() {

                // Session storage se data restore karna
                if (sessionStorage.getItem('tableData')) {
                    $('#table-list').html(sessionStorage.getItem('tableData'));
                    let recordData = JSON.parse(sessionStorage.getItem('recordData'));
                    $('#records').text(recordData.records);
                    $('#qty').text(recordData.qty);
                    $('#free').text(recordData.free);
                    $('#basic').text(recordData.basic);
                    $('#discount').text(recordData.discount);
                    $('#tax').text(recordData.tax);
                    $('#net').text(recordData.net);
                }

                $(document).on('keyup', '#bill_no, #account_name', function() {
                    $("#filter").submit();
                });

                $(document).on('keyup', '#global_search', function() {
                    let billNo = $('#bill_no').val().trim().toUpperCase();
                    let accountName = $('#account_name').val().trim().toUpperCase();
                    let globalSearch = $('#global_search').val().trim().toUpperCase();

                    $('table tr').each(function() {
                        let rowText = $(this).text().toUpperCase();
                        let globalMatch = globalSearch === "" || rowText.includes(globalSearch);
                        let billMatch = billNo === "" || rowText.includes(billNo);
                        let accountMatch = accountName === "" || rowText.includes(accountName);

                        if (globalMatch && billMatch && accountMatch) {
                            $(this).show();
                        } else {
                            $(this).hide();
                        }
                    });
                });

                // ✅ Sirf ek hi submit handler
                $('#filter').on('submit', function(e) {
                    e.preventDefault();
                    let url = $(this).attr('action');
                    const formdata = new FormData(this);

                    $.ajax({
                        url: url,
                        type: 'post',
                        contentType: false,
                        processData: false,
                        data: formdata,
                        dataType: 'json'
                    }).done(function(json) {
                        let Trow = '';
                        let records = 0;
                        let tBasic = 0,
                            tDiscAmt = 0,
                            tTaxAmt = 0,
                            tNetAmt = 0,
                            tAdditional = 0,
                            tAdvance = 0,
                            tBalance = 0;

                        json.forEach(function(row) {
                            records++;
                            tBasic += Number(row.basic_amt) || 0;
                            tDiscAmt += Number(row.dis_amt) || 0;
                            tTaxAmt += Number(row.tax_amt) || 0;
                            tNetAmt += Number(row.net_amount) || 0;
                            tAdditional += Number(row.bill_additional_charges) || 0;
                            tAdvance += Number(row.advance) || 0;
                            tBalance += Number(row.balance) || 0;

                            let purchase_register_url =
                                "{{ route('admin.reports.sale_orders_item') }}?bill_id=" +
                                (row.id || row.bill_no);

                            let edit_url = "{{ route('admin.sale.order-edit', ':id') }}"
                                .replace(':id', row.id || row.bill_no);

                            Trow += `<tr>
                        <td>${row.date || ''}</td>
                        <td>${row.bill_no || ''}</td>
                                <td>${row.account_name || ''}</td>
                                <td>${row.basic_amount || ''}</td>
                                <td>${row.discount_amount || ''}</td>
                                 <td>${row.after_discount_amount || ''}</td>
                                <td>${row.tax_amt || ''}</td>
                                <td>${row.gross_amount || ''}</td>
                                <td>${row.bill_discount_per || ''}</td>
                                <td>${row.bill_discount_amount || ''}</td>
                                <td>${row.basic_tax_per || ''}</td>
                                <td>${row.basic_tax_amt || ''}</td>
                                <td>${row.net_amount || ''}</td>
                                <td>${row.packaging_charges || ''}</td>
                                <td>${row.tax_packaging || ''}</td>
                                <td>${row.packaging_tax_amt || ''}</td>
                                <td>${row.transport_charges || ''}</td>
                                <td>${row.tax_transport || ''}</td>
                                <td>${row.transport_tax_amt || ''}</td>
                                <td>${row.bill_additional_charges || ''}</td>
                                <td>${row.total_net_amt || ''}</td>
                                <td>${row.advance || ''}</td>
                                <td>${row.balance || ''}</td>
                                <td>${row.remark || ''}</td>
                                <td>${row.remark_long || ''}</td>
                        <td>
                            <a href="${purchase_register_url}" class="btn btn-warning">E</a>
                            <a href="${edit_url}">
                                <button class="btn btn-success btn-sm">
                                    <i class="fa fa-pencil-alt"></i>
                                </button>
                            </a>
                        </td>
                    </tr>`;
                        });

                        $('#table-list').html(Trow);
                        $('#records').html(records);
                        $('#basic').html(tBasic.toFixed(2));
                        $('#discount').html(tDiscAmt.toFixed(2));
                        $('#tax').html(tTaxAmt.toFixed(2));
                        $('#net').html(tNetAmt.toFixed(2));
                        $('#additional').html(tAdditional.toFixed(2));
                        $('#advance').html(tAdvance.toFixed(2));
                        $('#balance').html(tBalance.toFixed(2));
                    });
                });

                // ✅ Page load hone par default me SaleOrder ka data le aao
                $("#filter").submit();

                $("#export-pdf-btn").on('click', function(e) {
                    e.preventDefault();
                    let fromDate = $('#from-date').val();
                    let toDate = $('#to-date').val();
                    let billNo = $('#bill_no').val();
                    let accountName = $('#account_name').val();

                    let exportForm = $('#export');
                    exportForm.empty();
                    exportForm.append(`<input type="hidden" name="fromDate" value="${fromDate}">`);
                    exportForm.append(`<input type="hidden" name="toDate" value="${toDate}">`);
                    exportForm.append(`<input type="hidden" name="bill_no" value="${billNo}">`);
                    exportForm.append(
                        `<input type="hidden" name="account_name" value="${accountName}">`);
                    exportForm.append(
                        `<input type="hidden" name="transaction_type" value="SaleOrder">`);
                    exportForm.append(`<input type="hidden" name="export_type" value="pdf">`);
                    exportForm.submit();
                });

            });
        })(jQuery);
    </script>
@endsection