@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 Challan Register</h3>

                </div>
                <div class="card-body">
                    <form class="" id="export" method="get"
                        action="{{ route('admin.reports.sale_challan_register') }}">
                    </form>
                    <form class="" id="filter" method="post"
                        action="{{ route('admin.reports.sale_challan_register') }}">
                        @csrf
                        <div class="row">
                            <div class="col-md-3">
                                <x-admin-input type="date" name="fromDate" id="from-date"
                                    value="{{ date('Y-m-d') }}"></x-admin-input>
                            </div>
                            <div class="col-md-3">
                                <x-admin-input type="date" name="toDate" id="to-date"
                                    value="{{ date('Y-m-d') }}"></x-admin-input>
                            </div>
                            <div class="col-md-2">
                                <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>
                    </form>
                    <div class="table-responsive mt-1">
                        <table class="table table-sm table-striped table-bordered">
                            <thead>
                                <tr>
                                    <th class="col-date" style="vertical-align: top;">Date</th>
                                    <th style="vertical-align: top;">Bill No.</th>
                                    <th class="col-party" style="vertical-align: top;">Party</th>
                                    <th style="vertical-align: top;">Bs Amt.</th>
                                    <th style="vertical-align: top;">Dis Amt.</th>
                                    <th style="vertical-align: top;">after dis Amt.</th>
                                    <th style="vertical-align: top;">Tax Amt.</th>
                                    <th style="vertical-align: top;">Gross Amt.</th>
                                    <th style="vertical-align: top;">Bill Disc. %</th>
                                    <th style="vertical-align: top;">Bill Disc.Amt.</th>
                                    <th style="vertical-align: top;">Basic Tax %</th>
                                    <th style="vertical-align: top;">Basic Tax Amt</th>
                                    <th style="vertical-align: top;">Bill Net Amount</th>
                                    <th style="vertical-align: top;">Packaging Charges</th>
                                    <th style="vertical-align: top;">Tax Packaging</th>
                                    <th style="vertical-align: top;">Paking Tax Amt</th>
                                    <th style="vertical-align: top;">Trans.Charg.</th>
                                    <th style="vertical-align: top;">Trans.Tax</th>
                                    <th style="vertical-align: top;">Trans.Tax Amt</th>
                                    <th style="vertical-align: top;">Add.Charg.</th>
                                    <th style="vertical-align: top;">Net Amount</th>
                                    <th style="vertical-align: top;">Adv. Cash</th>
                                    <th style="vertical-align: top;">Bal.Amt.</th>
                                    <th style="vertical-align: top;">Remark (Short)</th>
                                    <th style="vertical-align: top;">Remark (Long)</th>
                                    <th style="vertical-align: top;">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() {
                $('#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' // ✅ yahan se json direct milega
                    }).done(function(json) {
                        console.log(json)
                        let Trow = ''
                        let records = 0
                        let tQty = 0
                        let tFree = 0
                        let tBasic = 0
                        let tDiscAmt = 0
                        let tTaxAmt = 0
                        let tNetAmt = 0

                        json.forEach(function(row) {
                            records++
                            tQty += Number(row.qty) || 0
                            tFree += Number(row.free) || 0
                            tBasic += Number(row.basic_amt) || 0
                            tDiscAmt += Number(row.dis_amt) || 0
                            tTaxAmt += Number(row.tax_amt) || 0
                            tNetAmt += Number(row.net_amount) || 0

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

                            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>`;
                        })

                        $('#table-list').html(Trow)
                        $('#records').html(records)
                        $('#qty').html(tQty)
                        $('#free').html(tFree)
                        $('#basic').html(tBasic.toFixed(2))
                        $('#discount').html(tDiscAmt.toFixed(2))
                        $('#tax').html(tTaxAmt.toFixed(2))
                        $('#net').html(tNetAmt.toFixed(2))
                    })
                })

                // ✅ 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();
                });

                // ✅ Page load pe default data lana
                $('#filter').submit()
            })
        })(jQuery)
    </script>

@endsection