@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">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <h3 class="card-title">Purchase Register Item</h3>
                    <div class="d-flex ms-auto">
                        <a href="{{ route('admin.reports.purchase_register') }}">
                            <button class="btn btn-sm btn-flat shadow rounded-0 btn-danger">
                                <i class="fa fa-arrow-circle-left"></i> Back
                            </button>
                        </a>
                    </div>
                </div>
                <div class="card-body">
                    <div class="table-responsive mt-3">
                        <table class="table table-sm table-striped table-bordered">
                            <thead>
                                <tr>
                                    <th>Date</th>
                                    <th>Date On As</th>
                                    <th>Own Bill No</th>
                                    <th>Bill No.</th>
                                    <th>Party</th>
                                    <th>Product Name</th>
                                    <th>Part No</th>
                                    <th>Qty</th>
                                    <th>Free</th>
                                    <th>Rate</th>
                                    <th>Basic Amt</th>
                                    <th>Dis Per</th>
                                    <th>Dis Amt</th>
                                    <th>Tax Per</th>
                                    <th>Tax Amt</th>
                                    <th>Net Amount</th>
                                </tr>
                            </thead>
                            <tbody id="table-list">
                                @php
                                    $total_qty = $total_free = $total_basic_amt = $total_dis_amt = $total_tax_amt = $total_net_amount = 0;
                                @endphp
                            
                                @if (!empty($billItems) && !empty($bill))
                                    @foreach ($billItems as $item)
                                        @php
                                            $total_qty += $item->qty ?? 0;
                                            $total_free += $item->free ?? 0;
                                            $total_basic_amt += $item->basic_amt ?? 0;
                                            $total_dis_amt += $item->dis_amt ?? 0;
                                            $total_tax_amt += $item->tax_amt ?? 0;
                                            $total_net_amount += $item->net_amount ?? 0;
                                        @endphp
                            
                                        <tr>
                                            <td>{{ $bill->date ?? '--' }}</td>
                                            <td>{{ $bill->modal_date ?? '--' }}</td>
                                            <td>{{ $bill->modal_bill ?? '--' }}</td>
                                            <td>{{ $bill->bill_no ?? '--' }}</td>
                                            <td>{{ $bill->account->name ?? '--' }}</td> {{-- Account Name --}}
                                            <td>{{ !empty($item->product) ? $item->product->product_name : '--' }}</td>
                                            <td>{{ $item->product_part_no ?? '--' }}</td>
                                            <td>{{ $item->qty ?? 0 }}</td>
                                            <td>{{ $item->free ?? 0 }}</td>
                                            <td>{{ $item->rate ?? 0 }}</td>
                                            <td>{{ $item->basic_amt ?? 0 }}</td>
                                            <td>{{ $item->dis_per ?? 0 }}</td>
                                            <td>{{ $item->dis_amt ?? 0 }}</td>
                                            <td>{{ $item->tax_per ?? 0 }}</td>
                                            <td>{{ $item->tax_amt ?? 0 }}</td>
                                            <td>{{ $item->net_amount ?? 0 }}</td>
                                        </tr>
                                    @endforeach
                            
                                    {{-- ✅ Total Row --}}
                                    <tr style="background-color: #f8f9fa; font-weight: bold;">
                                        <td colspan="7" class="text-end">Total:</td>
                                        <td>{{ $total_qty }}</td>
                                        <td>{{ $total_free }}</td>
                                        <td>-</td> {{-- Rate ka total nahi hota --}}
                                        <td>{{ $total_basic_amt }}</td>
                                        <td>-</td> {{-- Discount Percentage ka total nahi hota --}}
                                        <td>{{ $total_dis_amt }}</td>
                                        <td>-</td> {{-- Tax Percentage ka total nahi hota --}}
                                        <td>{{ $total_tax_amt }}</td>
                                        <td>{{ $total_net_amount }}</td>
                                    </tr>
                                @else
                                    <tr>
                                        <td colspan="14" class="text-center">No records found</td>
                                    </tr>
                                @endif
                            </tbody>                            
                        </table>
                    </div>

                </div>
            </div>
        </div>
    </div>
@endsection

@section('js')
    <script>
        (function($) {
            $(document).ready(function() {
                $('#filter').on('submit', function(e) {
                    e.preventDefault();

                    let url = $(this).attr('action');
                    let formData = new FormData(this);

                    $.ajax({
                        url: url,
                        type: 'POST',
                        data: formData,
                        contentType: false,
                        processData: false,
                        success: function(response) {
                            let Trow = '';
                            let records = 0,
                                tQty = 0,
                                tFree = 0,
                                tBasic = 0,
                                tDiscAmt = 0,
                                tTaxAmt = 0,
                                tNetAmt = 0;

                            if (response.length === 0) {
                                Trow =
                                    '<tr><td colspan="11" class="text-center">No records found</td></tr>';
                            } else {
                                response.forEach(function(row) {
                                    records++;
                                    tQty += Number(row.qty);
                                    tFree += Number(row.free);
                                    tBasic += Number(row.basic_amt);
                                    tDiscAmt += Number(row.dis_amt);
                                    tTaxAmt += Number(row.tax_amt);
                                    tNetAmt += Number(row.net_amount);

                                    Trow += `<tr>
                                        <td>${row.product_name || '-'}</td>
                                        <td>${row.part_no || '-'}</td>
                                        <td>${row.qty || 0}</td>
                                        <td>${row.free || 0}</td>
                                        <td>${row.rate || 0}</td>
                                        <td>${row.basic_amt || 0}</td>
                                        <td>${row.dis_per || 0}</td>
                                        <td>${row.dis_amt || 0}</td>
                                        <td>${row.tax_per || 0}</td>
                                        <td>${row.tax_amt || 0}</td>
                                        <td>${row.net_amount || 0}</td>
                                    </tr>`;
                                });
                            }

                            $('#table-list').html(Trow);
                        },
                        error: function(xhr, status, error) {
                            console.error("Error: " + error);
                            alert("Something went wrong! Please try again.");
                        }
                    });
                });
            });
        })(jQuery);
    </script>
@endsection