@extends('layouts.admin')
@section('title', 'Product | Mintavia Admin')


@section('content')
    <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>
    <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">Purchase Register</h3>

                </div>
                <div class="card-body">
                    <form class="" id="export" method="get" action="{{ route('admin.reports.purchase_register') }}">
                    </form>
                    <form class="" id="filter" method="post"
                        action="{{ route('admin.reports.purchase_register') }}">
                        @csrf
                        <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 %</th>
                                    <th>Basic Tax %</th>
                                    <th>Basic Tax Amt</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 formatDate(dateStr) {
            if (!dateStr) return '';
            let d = new Date(dateStr);
            let day = ("0" + d.getDate()).slice(-2);
            let month = ("0" + (d.getMonth() + 1)).slice(-2);
            let year = d.getFullYear();
            return `${day}-${month}-${year}`;
        }
        (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(); // Global search field

                    $('table tr').each(function() {
                        let rowText = $(this).text().toUpperCase();

                        // Global search: agar user ne global search me kuch likha hai, to wahi match karega
                        let globalMatch = globalSearch === "" || rowText.includes(globalSearch);
                        let billMatch = billNo === "" || rowText.includes(billNo);
                        let accountMatch = accountName === "" || rowText.includes(accountName);

                        // Agar koi bhi match hota hai, to row show ho jaye
                        if (globalMatch && billMatch && accountMatch) {
                            $(this).show();
                        } else {
                            $(this).hide();
                        }
                    });
                });

                // Export PDF button
                $("#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="export_type" value="pdf">`);
                    exportForm.submit();
                });


                $('#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,
                    }).then(function(json) {
                        let Trow = '';
                        let records = 0,
                            tBasic = 0,
                            tDiscAmt = 0,
                            tTaxAmt = 0,
                            tNetAmt = 0,
                            tGrossAmt = 0,
                            tBillDiscAmt = 0,
                            tBasicPer = 0,
                            tBasicTaxAmt = 0,
                            tBillNetAmt = 0,
                            tPackagingCharges = 0,
                            tTransportCharges = 0,
                            tTransportTaxAmt = 0,
                            tBillAdditionalCharges = 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);
                            tGrossAmt += Number(row.gross_amount || 0);
                            tNetAmt += Number(row.net_amount || 0);
                            tBillDiscAmt += Number(row.bill_discount_amount || 0);
                            tBasicPer += Number(row.basic_per || 0);
                            tBasicTaxAmt += Number(row.basic_tax_amt || 0);
                            tBillNetAmt += Number(row.bill_net_amount || 0);
                            tPackagingCharges += Number(row.packaging_charges || 0);
                            tTransportCharges += Number(row.transport_charges || 0);
                            tTransportTaxAmt += Number(row.transport_tax_amt || 0);
                            tBillAdditionalCharges += Number(row
                                .bill_additional_charges || 0);
                            tAdvance += Number(row.advance || 0);
                            tBalance += Number(row.balance || 0);

                            let purchase_register_url =
                                "{{ route('admin.reports.purchase_register_item') }}?bill_id=" +
                                row.id;
                            let edit_url = "{{ route('admin.purchase.edit', ':id') }}"
                                .replace(':id', row.id);

                            Trow += `<tr>
                               <td>${formatDate(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>`;
                        });

                        // **tfoot में टोटल अपडेट करें**
                        $('#table-list').html(Trow);
                        $('#basic').text(tBasic.toFixed(2));
                        $('#discount').text(tDiscAmt.toFixed(2));
                        $('#tax').text(tTaxAmt.toFixed(2));
                        $('#gross').text(tGrossAmt.toFixed(2));
                        $('#net').text(tNetAmt.toFixed(2));
                        $('#bill_discount_amount').text(tBillDiscAmt.toFixed(2));
                        $('#basic_per').text(tBasicPer.toFixed(2));
                        $('#basic_tax_amt').text(tBasicTaxAmt.toFixed(2));
                        $('#bill_net_amount').text(tBillNetAmt.toFixed(2));
                        $('#packaging_charges').text(tPackagingCharges.toFixed(2));
                        $('#transport_charges').text(tTransportCharges.toFixed(2));
                        $('#transport_tax_amt').text(tTransportTaxAmt.toFixed(2));
                        $('#bill_additional_charges').text(tBillAdditionalCharges.toFixed(2));
                        $('#advance').text(tAdvance.toFixed(2));
                        $('#balance').text(tBalance.toFixed(2));

                        // Click event to navigate to item page
                        $('.bill-row').on('click', function() {
                            let bill_id = $(this).data('bill');
                            window.location.href =
                                "{{ route('admin.reports.purchase_register_item') }}?bill_id=" +
                                bill_id;
                        });

                    }).fail(function(xhr, status, error) {
                        console.error("AJAX Error: " + status + " - " + error);
                    });
                });


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