@extends('admin.layouts.app')
@section('title','Product / Inventory Report')
@section('breadcrumb') <span>/</span> <a href="{{ route('admin.reports.index') }}" style="color:inherit;text-decoration:none;">Reports</a> <span>/</span> Products @endsection

@section('content')
<div class="page-header">
    <div><h1>Product / Inventory Report</h1><p class="page-subtitle">Stock levels, transactions and movement history</p></div>
    <div class="d-flex gap-2">
        @if(auth()->user()->hasPermission('reports.export'))
        <div class="dropdown">
            <button class="btn btn-success dropdown-toggle" data-bs-toggle="dropdown"><i class="fas fa-download me-2"></i>Export</button>
            <ul class="dropdown-menu">
                <li><a class="dropdown-item" href="{{ route('admin.reports.export','products') }}?format=pdf"><i class="fas fa-file-pdf text-danger me-2"></i>PDF</a></li>
                <li><a class="dropdown-item" href="{{ route('admin.reports.export','products') }}?format=csv"><i class="fas fa-file-csv text-success me-2"></i>CSV</a></li>
                <li><a class="dropdown-item" href="{{ route('admin.reports.export','products') }}?format=xlsx"><i class="fas fa-file-excel text-success me-2"></i>Excel</a></li>
            </ul>
        </div>
        @endif
        <button onclick="window.print()" class="btn btn-outline-secondary"><i class="fas fa-print me-2"></i>Print</button>
    </div>
</div>

<div class="row g-3 mb-4">
    <div class="col-6 col-md-3"><div class="card p-3 text-center" style="border-top:3px solid #0e7490;"><div style="font-size:11px;color:#64748b;font-weight:600;text-transform:uppercase;">Total Products</div><div style="font-size:20px;font-weight:700;">{{ $summary['total'] }}</div></div></div>
    <div class="col-6 col-md-3"><div class="card p-3 text-center" style="border-top:3px solid #16a34a;"><div style="font-size:11px;color:#64748b;font-weight:600;text-transform:uppercase;">Total Stock In</div><div style="font-size:20px;font-weight:700;">{{ $summary['total_in'] }}</div></div></div>
    <div class="col-6 col-md-3"><div class="card p-3 text-center" style="border-top:3px solid #dc2626;"><div style="font-size:11px;color:#64748b;font-weight:600;text-transform:uppercase;">Total Stock Out</div><div style="font-size:20px;font-weight:700;">{{ $summary['total_out'] }}</div></div></div>
    <div class="col-6 col-md-3"><div class="card p-3 text-center" style="border-top:3px solid #d97706;"><div style="font-size:11px;color:#64748b;font-weight:600;text-transform:uppercase;">Low / Out of Stock</div><div style="font-size:20px;font-weight:700;">{{ $summary['low_stock'] }} / {{ $summary['out_of_stock'] }}</div></div></div>
</div>

<div class="card">
    <div class="card-header d-flex align-items-center justify-content-between">
        <h6 class="mb-0 fw-700"><i class="fas fa-boxes text-primary me-2"></i>Product Records</h6>
        <span class="badge bg-primary">{{ $products->count() }} records</span>
    </div>
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table table-hover mb-0" id="reportTable">
                <thead style="background:#f8fafc;">
                    <tr><th class="ps-3">Code</th><th>Name</th><th>Category</th><th>Unit</th><th>Current Stock</th><th>Transactions</th><th>Status</th></tr>
                </thead>
                <tbody>
                    @forelse($products as $p)
                    @php $stockColor = $p->current_quantity == 0 ? 'danger' : ($p->current_quantity < 10 ? 'warning' : 'success'); @endphp
                    <tr>
                        <td class="ps-3"><code style="font-size:11px;">{{ $p->product_code }}</code></td>
                        <td style="font-weight:600;font-size:13px;"><a href="{{ route('admin.csr.products.show',$p) }}">{{ $p->product_name }}</a></td>
                        <td style="font-size:12px;">{{ $p->category ?? '—' }}</td>
                        <td style="font-size:12px;">{{ $p->unit ?? '—' }}</td>
                        <td><span class="badge bg-{{ $stockColor }}">{{ $p->current_quantity }}</span></td>
                        <td>{{ $p->stockTransactions->count() }}</td>
                        <td><span class="badge bg-{{ $p->status==='active'?'success':'secondary' }}">{{ ucfirst($p->status) }}</span></td>
                    </tr>
                    @empty
                    <tr><td colspan="7" class="text-center py-4 text-muted">No products found</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script>
$(document).ready(function() { $('#reportTable').DataTable({ ...window.dtDefaults, paging: false, info: false }); });
</script>
@endpush