@extends('layouts.layout-horizontal')
@section('title', 'Product Price List')

@section('content')
<div class="card">
    <div class="card-header d-flex align-items-center justify-content-between">
        <div>
            <h5 class="mb-0">Product Price List</h5>
            <small class="text-muted">Latest purchase and sale details across all stock companies.</small>
        </div>
        <span class="badge bg-light text-dark">{{ $products->count() }} products</span>
    </div>
    <div class="card-body">
        <div data-st data-st-export="excel,print" data-st-filename="product-price-list-{{ now()->format('Y-m-d') }}">
            <div class="table-responsive">
                <table class="table table-hover table-sm align-middle">
                    <thead class="table-light">
                        <tr>
                            <th class="text-center">Sr. No.</th>
                            <th>Product ID</th>
                            <th>HSN</th>
                            <th>Name of Product</th>
                            <th>Unit</th>
                            <th class="text-end">Purchase Rate</th>
                            <th class="text-end">GST, if Applicable</th>
                            <th class="text-end">Cost with GST</th>
                            <th class="text-end">Last Sold Rate</th>
                            <th>Last Sold Date</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($products as $product)
                        <tr>
                            <td class="text-center text-muted">{{ $loop->iteration }}</td>
                            <td>{{ $product->product_id ?: '-' }}</td>
                            <td>{{ $product->hsn ?: '-' }}</td>
                            <td>
                                <button type="button" class="btn btn-link p-0 fw-semibold text-start product-history-link"
                                    data-product-id="{{ $product->id }}"
                                    data-product-name="{{ $product->name }}"
                                    data-product-code="{{ $product->product_id }}"
                                    data-bs-toggle="modal" data-bs-target="#productHistoryModal">
                                    {{ $product->name }}
                                </button>
                            </td>
                            <td>{{ $product->unit ?: '-' }}</td>
                            <td class="text-end">
                                @if($product->purchase_rate !== null)
                                    {{ indian_number($product->purchase_rate, 2) }}
                                @else
                                    <span class="text-muted">-</span>
                                @endif
                            </td>
                            <td class="text-end">
                                @if((float) ($product->gst_percent ?? 0) > 0)
                                    {{ indian_number($product->gst_percent, 2) }}%
                                @else
                                    <span class="text-muted">-</span>
                                @endif
                            </td>
                            <td class="text-end">
                                @if($product->cost_with_gst !== null)
                                    {{ indian_number($product->cost_with_gst, 2) }}
                                @else
                                    <span class="text-muted">-</span>
                                @endif
                            </td>
                            <td class="text-end">
                                @if($product->last_sold_rate !== null)
                                    {{ indian_number($product->last_sold_rate, 2) }}
                                @else
                                    <span class="text-muted">-</span>
                                @endif
                            </td>
                            <td>
                                {{ $product->last_sold_date ? \Carbon\Carbon::parse($product->last_sold_date)->format('d-M-Y') : '-' }}
                            </td>
                        </tr>
                        @empty
                        <tr>
                            <td colspan="10" class="text-center text-muted py-4">No products found.</td>
                        </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="productHistoryModal" tabindex="-1" aria-labelledby="productHistoryLabel" aria-hidden="true">
    <div class="modal-dialog modal-xl modal-dialog-scrollable">
        <div class="modal-content">
            <div class="modal-header">
                <div>
                    <h5 class="modal-title" id="productHistoryLabel">Product History</h5>
                    <small class="text-muted" id="productHistoryMeta"></small>
                </div>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <div id="productHistoryLoading" class="text-center py-5">
                    <div class="spinner-border text-primary" role="status"></div>
                    <div class="text-muted mt-2">Loading product history...</div>
                </div>
                <div id="productHistoryEmpty" class="text-center text-muted py-5 d-none">No product movements found.</div>
                <div class="table-responsive d-none" id="productHistoryTableWrap">
                    <table class="table table-sm table-hover align-middle mb-0">
                        <thead class="table-light">
                            <tr>
                                <th>Date</th>
                                <th>Company</th>
                                <th>Type</th>
                                <th>Bill No.</th>
                                <th>Party</th>
                                <th class="text-end">In</th>
                                <th class="text-end">Out</th>
                                <th class="text-end">Rate</th>
                                <th class="text-end">Amount</th>
                            </tr>
                        </thead>
                        <tbody id="productHistoryRows"></tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('scripts')
<script>
document.addEventListener('DOMContentLoaded', function () {
    const modal = document.getElementById('productHistoryModal');
    const loading = document.getElementById('productHistoryLoading');
    const empty = document.getElementById('productHistoryEmpty');
    const tableWrap = document.getElementById('productHistoryTableWrap');
    const rows = document.getElementById('productHistoryRows');

    const escapeHtml = value => String(value ?? '').replace(/[&<>'"]/g, char => ({ '&': '&amp;', '<': '&lt;', '>': '&gt;', "'": '&#039;', '"': '&quot;' })[char]);
    const formatNumber = value => Number(value || 0).toLocaleString('en-IN', { minimumFractionDigits: 2, maximumFractionDigits: 2 });
    const formatDate = value => value ? new Date(`${value}T00:00:00`).toLocaleDateString('en-GB', { day: '2-digit', month: 'short', year: 'numeric' }) : '-';

    document.querySelectorAll('.product-history-link').forEach(button => {
        button.addEventListener('click', async function () {
            document.getElementById('productHistoryLabel').textContent = this.dataset.productName;
            document.getElementById('productHistoryMeta').textContent = this.dataset.productCode || '';
            loading.classList.remove('d-none');
            empty.classList.add('d-none');
            tableWrap.classList.add('d-none');
            rows.innerHTML = '';

            try {
                const response = await fetch(`{{ url('api/products') }}/${this.dataset.productId}/ledger?start=2020-04-01&end={{ now()->toDateString() }}`, {
                    headers: { 'Accept': 'application/json', 'X-Requested-With': 'XMLHttpRequest' },
                });
                if (!response.ok) throw new Error(`HTTP ${response.status}`);

                const data = await response.json();
                const history = data.companies.flatMap(company => company.rows.map(row => ({ ...row, company: company.company_name })))
                    .sort((a, b) => b.date.localeCompare(a.date));

                if (!history.length) {
                    empty.classList.remove('d-none');
                    return;
                }

                rows.innerHTML = history.map(row => `
                    <tr>
                        <td>${formatDate(row.date)}</td>
                        <td>${escapeHtml(row.company)}</td>
                        <td>${escapeHtml(row.kind.replace('_', ' '))}</td>
                        <td>${escapeHtml(row.bill_no || '-')}</td>
                        <td>${escapeHtml(row.party || '-')}</td>
                        <td class="text-end text-success">${row.qty_in ? '+' + formatNumber(row.qty_in) : '-'}</td>
                        <td class="text-end text-danger">${row.qty_out ? '-' + formatNumber(row.qty_out) : '-'}</td>
                        <td class="text-end">${formatNumber(row.rate)}</td>
                        <td class="text-end">${formatNumber(row.amount)}</td>
                    </tr>`).join('');
                tableWrap.classList.remove('d-none');
            } catch (error) {
                empty.textContent = 'Unable to load product history.';
                empty.classList.remove('d-none');
            } finally {
                loading.classList.add('d-none');
            }
        });
    });
});
</script>
@endsection