@extends('garage.layouts.app')

@section('title', $reportTitle)

@push('styles')
<style>
    .sr-wrap { background:#fff; border:1px solid #e2e8f0; border-radius:14px; box-shadow:0 10px 28px rgba(15,23,42,.08); }
    .sr-head { padding:.9rem 1rem; border-bottom:1px solid #e2e8f0; background:linear-gradient(135deg,#eff6ff,#ecfeff); }
    .sr-filter { padding:.8rem 1rem; border-bottom:1px solid #edf2f7; background:#f8fafc; }
    .sr-grid { display:grid; gap:.55rem; grid-template-columns:repeat(6,minmax(0,1fr)); }
    .sr-grid .sr-col2 { grid-column:span 2; }
    .sr-grid label { font-size:.72rem; color:#64748b; font-weight:700; margin-bottom:.12rem; }
    .sr-grid input,.sr-grid select { width:100%; border:1px solid #dbe3ee; border-radius:9px; padding:.38rem .52rem; font-size:.8rem; background:#fff; }
    .sr-actions { display:flex; flex-wrap:wrap; gap:.4rem; align-items:center; margin-top:.65rem; }
    .sr-total-badges { display:flex; gap:.45rem; flex-wrap:wrap; margin-left:auto; }
    .sr-total-badge { font-size:.72rem; font-weight:700; border:1px solid #dbe3ee; border-radius:999px; padding:.2rem .58rem; background:#fff; color:#334155; }
    .sr-table thead th { font-size:.68rem; text-transform:uppercase; letter-spacing:.05em; color:#64748b; background:#f8fafc; position:sticky; top:0; z-index:2; }
    .sr-table td { font-size:.82rem; }
    .sr-foot { padding:.7rem 1rem; border-top:1px solid #eef2f7; font-size:.78rem; color:#475569; background:#fafcff; }
    @media print {
        .sr-filter,.sr-no-print,.sidebar,.navbar { display:none !important; }
        .sr-wrap { box-shadow:none; border-color:#cbd5e1; }
    }
</style>
@endpush

@section('content')
<div class="container-fluid px-2 px-lg-3 py-3">
    <div class="sr-wrap">
        <div class="sr-head d-flex flex-wrap justify-content-between align-items-start gap-2">
            <div>
                <h1 class="h5 mb-0"><i class="bi bi-graph-up-arrow me-1 text-primary"></i>{{ $reportTitle }}</h1>
                <p class="small text-muted mt-1 mb-0">Opening + Inward − Outward. Net purchase = purchase − purchase return; net sale = sale − sale return. Inward includes purchases and sale returns; outward includes purchase returns, sales, and issuances.</p>
            </div>
            <div class="sr-no-print">
                <a href="{{ route('garage.reports.index') }}" class="btn btn-sm btn-outline-secondary">All reports</a>
            </div>
        </div>

        <form method="GET" class="sr-filter sr-no-print">
            <div class="sr-grid">
                <div><label>Date from</label><input type="date" name="date_from" value="{{ $filters['date_from'] }}"></div>
                <div><label>Date to</label><input type="date" name="date_to" value="{{ $filters['date_to'] }}"></div>
                <div><label>As-on date</label><input type="date" name="as_on_date" value="{{ $filters['as_on_date'] }}"></div>
                <div>
                    <label>Vendor</label>
                    <select name="vendor_id">
                        <option value="">All</option>
                        @foreach(($filterOptions['vendors'] ?? []) as $v)
                            <option value="{{ $v->id }}" {{ (string)$filters['vendor_id'] === (string)$v->id ? 'selected' : '' }}>{{ $v->name }}</option>
                        @endforeach
                    </select>
                </div>
                <div>
                    <label>Item / Part</label>
                    <select name="part_id">
                        <option value="">All</option>
                        @foreach(($filterOptions['parts'] ?? []) as $p)
                            <option value="{{ $p->id }}" {{ (string)$filters['part_id'] === (string)$p->id ? 'selected' : '' }}>
                                {{ $p->name }} ({{ $p->inventory_code ?: ($p->code ?: '-') }})
                            </option>
                        @endforeach
                    </select>
                </div>
                <div>
                    <label>Category</label>
                    <select name="category_id">
                        <option value="">All</option>
                        @foreach(($filterOptions['categories'] ?? []) as $c)
                            <option value="{{ $c->id }}" {{ (string)$filters['category_id'] === (string)$c->id ? 'selected' : '' }}>{{ $c->name }}</option>
                        @endforeach
                    </select>
                </div>

                <div>
                    <label>Brand</label>
                    <select name="brand">
                        <option value="">All</option>
                        @foreach(($filterOptions['brands'] ?? []) as $b)
                            <option value="{{ $b }}" {{ (string)$filters['brand'] === (string)$b ? 'selected' : '' }}>{{ $b }}</option>
                        @endforeach
                    </select>
                </div>
                <div>
                    <label>Company</label>
                    <select name="company">
                        <option value="">All</option>
                        @foreach(($filterOptions['companies'] ?? []) as $company)
                            <option value="{{ $company }}" {{ (string)$filters['company'] === (string)$company ? 'selected' : '' }}>{{ $company }}</option>
                        @endforeach
                    </select>
                </div>
                <div>
                    <label>Branch</label>
                    <select name="branch">
                        <option value="">All</option>
                        @foreach(($filterOptions['branches'] ?? []) as $branch)
                            <option value="{{ $branch }}" {{ (string)$filters['branch'] === (string)$branch ? 'selected' : '' }}>{{ $branch }}</option>
                        @endforeach
                    </select>
                </div>
                <div>
                    <label>Location</label>
                    <select name="location">
                        <option value="">All</option>
                        @foreach(($filterOptions['locations'] ?? []) as $loc)
                            <option value="{{ $loc }}" {{ (string)$filters['location'] === (string)$loc ? 'selected' : '' }}>{{ $loc }}</option>
                        @endforeach
                    </select>
                </div>
                <div>
                    <label>Entry type</label>
                    <select name="entry_type">
                        <option value="">All</option>
                        @foreach(['opening' => 'Opening','purchase' => 'Purchase','issue' => 'Issue','sale' => 'Sale','adjustment' => 'Adjustment'] as $k => $v)
                            <option value="{{ $k }}" {{ (string)$filters['entry_type'] === $k ? 'selected' : '' }}>{{ $v }}</option>
                        @endforeach
                    </select>
                </div>
                <div><label>Invoice no</label><input type="text" name="invoice_no" value="{{ $filters['invoice_no'] }}" placeholder="INV/PO/BILL"></div>
                <div><label>Reference no</label><input type="text" name="reference_no" value="{{ $filters['reference_no'] }}" placeholder="Ref"></div>

                <div><label>Qty min</label><input type="number" step="0.01" name="qty_min" value="{{ $filters['qty_min'] }}"></div>
                <div><label>Qty max</label><input type="number" step="0.01" name="qty_max" value="{{ $filters['qty_max'] }}"></div>
                <div><label>Rate min</label><input type="number" step="0.01" name="rate_min" value="{{ $filters['rate_min'] }}"></div>
                <div><label>Rate max</label><input type="number" step="0.01" name="rate_max" value="{{ $filters['rate_max'] }}"></div>
                <div><label>Amount min</label><input type="number" step="0.01" name="amount_min" value="{{ $filters['amount_min'] }}"></div>
                <div><label>Amount max</label><input type="number" step="0.01" name="amount_max" value="{{ $filters['amount_max'] }}"></div>

                <div>
                    <label>Stock status</label>
                    <select name="stock_status">
                        <option value="">All</option>
                        <option value="in-stock" {{ $filters['stock_status'] === 'in-stock' ? 'selected' : '' }}>In stock</option>
                        <option value="low" {{ $filters['stock_status'] === 'low' ? 'selected' : '' }}>Low</option>
                        <option value="negative" {{ $filters['stock_status'] === 'negative' ? 'selected' : '' }}>Negative</option>
                    </select>
                </div>
                <div class="sr-col2"><label>Search keyword</label><input type="text" name="keyword" value="{{ $filters['keyword'] }}" placeholder="Item, brand, code..."></div>
            </div>

            <div class="sr-actions">
                <button type="submit" class="btn btn-sm btn-primary"><i class="bi bi-funnel me-1"></i>Apply filters</button>
                <a href="{{ route('garage.reports.stock.show', ['slug' => $reportSlug]) }}" class="btn btn-sm btn-outline-secondary">Clear</a>
                <a href="{{ request()->fullUrlWithQuery(['export' => 'excel']) }}" class="btn btn-sm btn-outline-success"><i class="bi bi-file-earmark-excel me-1"></i>Excel</a>
                <a href="{{ request()->fullUrlWithQuery(['export' => 'pdf']) }}" class="btn btn-sm btn-outline-danger" target="_blank" rel="noopener noreferrer"><i class="bi bi-file-earmark-pdf me-1"></i>PDF</a>
                <a href="{{ request()->fullUrlWithQuery(['print' => 1]) }}" class="btn btn-sm btn-outline-dark" target="_blank" rel="noopener noreferrer"><i class="bi bi-printer me-1"></i>Print</a>

                <div class="sr-total-badges">
                    <span class="sr-total-badge">Rows: {{ number_format((int)($totals['rows'] ?? 0)) }}</span>
                    @if(isset($totals['purch_qty']))
                        <span class="sr-total-badge">Purch: {{ number_format((float)$totals['purch_qty'], 2) }}</span>
                    @endif
                    @if(isset($totals['return_qty']))
                        <span class="sr-total-badge">Returned: {{ number_format((float)$totals['return_qty'], 2) }}</span>
                    @endif
                    @if(isset($totals['net_qty']))
                        <span class="sr-total-badge">Net: {{ number_format((float)$totals['net_qty'], 2) }}</span>
                    @endif
                    @if(isset($totals['qty']))
                        <span class="sr-total-badge">Qty: {{ number_format((float)$totals['qty'], 2) }}</span>
                    @endif
                    @if(isset($totals['amount']))
                        <span class="sr-total-badge">Amount: {{ number_format((float)$totals['amount'], 2) }}</span>
                    @endif
                    @if(isset($totals['closing_value']))
                        <span class="sr-total-badge">Closing Value: {{ number_format((float)$totals['closing_value'], 2) }}</span>
                    @endif
                </div>
            </div>
        </form>

        <div class="table-responsive">
            <table class="table table-sm table-hover mb-0 sr-table">
                <thead>
                <tr>
                    @foreach($columns as $c)
                        <th>{{ $c }}</th>
                    @endforeach
                </tr>
                </thead>
                <tbody>
                @forelse($rows as $r)
                    <tr>
                        @foreach($r as $v)
                            <td>{{ is_numeric($v) ? number_format((float)$v, 2) : $v }}</td>
                        @endforeach
                    </tr>
                @empty
                    <tr><td colspan="{{ count($columns) }}" class="text-center text-muted py-4">No data for selected filters.</td></tr>
                @endforelse
                </tbody>
            </table>
        </div>

        <div class="sr-foot">
            Showing {{ number_format(count($rows)) }} rows. Stock formula: Opening + Inward - Outward.
            @if($printMode)
                <script>window.addEventListener('load', function () { window.print(); });</script>
            @endif
        </div>
    </div>
</div>
@endsection