@extends('admin.layouts.app')

@section('title', 'Inventory')
@section('page_title', 'Inventory Management')

@section('content')
<div class="card mb-4">
    <div class="card-header">
        <div class="d-flex justify-content-between align-items-center">
            <h5 class="mb-0">Overall Inventory List</h5>
        </div>
    </div>
    <div class="card-body">
        <style>
            .inventory-table { font-size: 12px; }
            .inventory-table th { background-color: #3b82f6; color: white; font-size: 11px; padding: 8px 5px; }
            .inventory-table td { padding: 6px 5px; vertical-align: middle; }
        </style>
        
        <form method="GET" action="{{ route('inventory.index') }}" class="mb-4">
            <div class="row">
                <div class="col-md-3">
                    <label class="form-label">Category</label>
                    <select name="category_id" class="form-select">
                        <option value="">All Categories</option>
                        @foreach($categories as $category)
                            <option value="{{ $category->id }}" {{ request('category_id') == $category->id ? 'selected' : '' }}>
                                {{ $category->name }}
                            </option>
                            @if($category->children && $category->children->count() > 0)
                                @foreach($category->children as $child)
                                    <option value="{{ $child->id }}" {{ request('category_id') == $child->id ? 'selected' : '' }}>
                                        &nbsp;&nbsp;&nbsp;↳ {{ $child->name }}
                                    </option>
                                @endforeach
                            @endif
                        @endforeach
                    </select>
                </div>
                <div class="col-md-3">
                    <label class="form-label">Stock Status</label>
                    <select name="stock_status" class="form-select">
                        <option value="">All</option>
                        <option value="low" {{ request('stock_status') == 'low' ? 'selected' : '' }}>Low Stock</option>
                        <option value="out" {{ request('stock_status') == 'out' ? 'selected' : '' }}>Out of Stock</option>
                        <option value="available" {{ request('stock_status') == 'available' ? 'selected' : '' }}>Available</option>
                    </select>
                </div>
                <div class="col-md-3">
                    <label class="form-label">&nbsp;</label>
                    <button type="submit" class="btn btn-primary w-100">Filter</button>
                </div>
                <div class="col-md-3">
                    <label class="form-label">&nbsp;</label>
                    <a href="{{ route('inventory.index') }}" class="btn btn-secondary w-100">Reset</a>
                </div>
            </div>
        </form>
        
        <style>
    .inventory-table { font-size: 12px; }
    .inventory-table th { background-color: #3b82f6; color: white; font-size: 11px; padding: 8px 5px; }
    .inventory-table td { padding: 6px 5px; vertical-align: middle; }
</style>

<div class="table-responsive">
            <table class="table table-bordered table-striped inventory-table">
                <thead>
                    <tr>
                        <th>ID</th>
                        <th>Product Name</th>
                        <th>Code</th>
                        <th>Category</th>
                        <th>Unit</th>
                        <th>Purchase</th>
                        <th>Purchase Return</th>
                        <th>Sales</th>
                        <th>Sales Return</th>
                        <th>Wastage</th>
                        <th>Total In</th>
                        <th>Total Out</th>
                        <th>Current Stock</th>
                        <th>Stock Value</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($products as $product)
                        @php
                            $purchase = $purchaseTotals[$product->id] ?? 0;
                            $purchaseReturn = $purchaseReturnTotals[$product->id] ?? 0;
                            $sales = $saleTotals[$product->id] ?? 0;
                            $salesReturn = $saleReturnTotals[$product->id] ?? 0;
                            $wastage = $wastageTotals[$product->id] ?? 0;
                            $totalIn = $purchase + $salesReturn + $product->opening_stock;
                            $totalOut = $sales + $purchaseReturn + $wastage;
                            $calculatedStock = $totalIn - $totalOut;
                            $stockValue = $calculatedStock * ($product->purchase_price ?? 0);
                        @endphp
                        <tr class="{{ $calculatedStock <= 0 ? 'table-danger' : ($calculatedStock <= $product->alert_quantity ? 'table-warning' : '') }}">
                            <td>{{ $product->id }}</td>
                            <td>{{ $product->name }}</td>
                            <td>{{ $product->code }}</td>
                            <td>
                                @if($product->category)
                                    @if($product->category->parent)
                                        <span class="text-muted">{{ $product->category->parent->name }} →</span> {{ $product->category->name }}
                                    @else
                                        {{ $product->category->name }}
                                    @endif
                                @else
                                    N/A
                                @endif
                            </td>
                            <td>{{ $product->unit->short_name ?? 'N/A' }}</td>
                            <td class="text-success">{{ number_format($purchase, 3) }}</td>
                            <td class="text-danger">{{ number_format($purchaseReturn, 3) }}</td>
                            <td class="text-danger">{{ number_format($sales, 3) }}</td>
                            <td class="text-success">{{ number_format($salesReturn, 3) }}</td>
                            <td class="text-danger">{{ number_format($wastage, 3) }}</td>
                            <td class="text-success">{{ number_format($totalIn, 3) }}</td>
                            <td class="text-danger">{{ number_format($totalOut, 3) }}</td>
                            <td>
                                @if($calculatedStock <= 0)
                                    <span class="badge bg-danger">Out of Stock</span>
                                @elseif($calculatedStock <= $product->alert_quantity)
                                    <span class="badge bg-warning">{{ number_format($calculatedStock, 3) }}</span>
                                @else
                                    <span class="badge bg-success">{{ number_format($calculatedStock, 3) }}</span>
                                @endif
                            </td>
                            <td class="text-end">{{ number_format($stockValue, 2) }}</td>
                            <td>
                                <a href="{{ route('products.show', $product->id) }}" class="btn btn-sm btn-info" title="View">
                                    <i class="fa fa-eye"></i>
                                </a>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="15" class="text-center">No products found</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot class="table-secondary">
                    @php
                        $tPurchase = 0; $tPurchaseReturn = 0; $tSales = 0; $tSalesReturn = 0;
                        $tWastage = 0; $tTotalIn = 0; $tTotalOut = 0; $tStockVal = 0; $tStockQty = 0;
                        foreach($products as $p) {
                            $pu = $purchaseTotals[$p->id] ?? 0;
                            $pr = $purchaseReturnTotals[$p->id] ?? 0;
                            $sa = $saleTotals[$p->id] ?? 0;
                            $sr = $saleReturnTotals[$p->id] ?? 0;
                            $wa = $wastageTotals[$p->id] ?? 0;
                            $ti = $pu + $sr + $p->opening_stock;
                            $to = $sa + $pr + $wa;
                            $sk = $ti - $to;
                            $tPurchase += $pu; $tPurchaseReturn += $pr; $tSales += $sa;
                            $tSalesReturn += $sr; $tWastage += $wa; $tTotalIn += $ti;
                            $tTotalOut += $to; $tStockQty += $sk; $tStockVal += $sk * ($p->purchase_price ?? 0);
                        }
                    @endphp
                    <tr>
                        <th colspan="5" class="text-end">Total:</th>
                        <th class="text-end text-success">{{ number_format($tPurchase, 3) }}</th>
                        <th class="text-end text-danger">{{ number_format($tPurchaseReturn, 3) }}</th>
                        <th class="text-end text-danger">{{ number_format($tSales, 3) }}</th>
                        <th class="text-end text-success">{{ number_format($tSalesReturn, 3) }}</th>
                        <th class="text-end text-danger">{{ number_format($tWastage, 3) }}</th>
                        <th class="text-end text-success">{{ number_format($tTotalIn, 3) }}</th>
                        <th class="text-end text-danger">{{ number_format($tTotalOut, 3) }}</th>
                        <th class="text-end">{{ number_format($tStockQty, 3) }}</th>
                        <th class="text-end">{{ number_format($tStockVal, 2) }}</th>
                        <th></th>
                    </tr>
                </tfoot>
            </table>
        </div>
        {{ $products->withQueryString()->links() }}
    </div>
</div>

<div class="card">
    <div class="card-header">
        <div class="d-flex justify-content-between align-items-center">
            <h5 class="mb-0">Shipment Wise Inventory Report</h5>
        </div>
    </div>
    <div class="card-body">
        <form method="GET" action="{{ route('inventory.index') }}" class="mb-4">
            <div class="row">
                <div class="col-md-6">
                    <label class="form-label">Select Shipment Number</label>
                    <select name="shipment_number" class="form-select" onchange="this.form.submit()">
                        <option value="">-- Select Shipment Number --</option>
                        @foreach($allShipments as $shipment)
                            <option value="{{ $shipment }}" {{ $shipmentNumber == $shipment ? 'selected' : '' }}>
                                {{ $shipment }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-3">
                    <label class="form-label">&nbsp;</label>
                    <button type="submit" class="btn btn-primary w-100">View Report</button>
                </div>
                <div class="col-md-3">
                    <label class="form-label">&nbsp;</label>
                    <a href="{{ route('inventory.index') }}" class="btn btn-secondary w-100">Reset</a>
                </div>
            </div>
        </form>

        @if($shipmentNumber)
            <h5 class="mb-3">Shipment Number: <span class="text-primary">{{ $shipmentNumber }}</span></h5>
            
            @php
                $allProducts = collect();
                foreach($purchaseItems as $item) {
                    $allProducts->put($item->product_id, $item->product);
                }
                foreach($saleItems as $item) {
                    $allProducts->put($item->product_id, $item->product);
                }
                foreach($wastageItems as $item) {
                    $allProducts->put($item->product_id, $item->product);
                }
                foreach($purchaseReturnItems as $item) {
                    $allProducts->put($item->product_id, $item->product);
                }
                foreach($saleReturnItems as $item) {
                    $allProducts->put($item->product_id, $item->product);
                }
@endphp

            <div class="table-responsive">
                <table class="table table-bordered table-striped inventory-table">
                    <thead>
                        <tr>
                            <th>Product Name</th>
                            <th>Code</th>
                            <th>Unit</th>
                            <th>Purchase</th>
                            <th>Purchase Return</th>
                            <th>Sales</th>
                            <th>Sales Return</th>
                            <th>Wastage</th>
                            <th>Total In</th>
                            <th>Total Out</th>
                            <th>Current Stock</th>
                            <th>Stock Value</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($allProducts as $productId => $product)
                            @php
                                $purchaseQty = $purchaseItems->where('product_id', $productId)->sum('quantity');
                                $saleQty = $saleItems->where('product_id', $productId)->sum('quantity');
                                $wastageQty = $wastageItems->where('product_id', $productId)->sum('quantity');
                                $purchaseReturnQty = $purchaseReturnItems->where('product_id', $productId)->sum('quantity');
                                $saleReturnQty = $saleReturnItems->where('product_id', $productId)->sum('quantity');
                                
                                $totalIn = $purchaseQty + $saleReturnQty;
                                $totalOut = $saleQty + $wastageQty + $purchaseReturnQty;
                                $stockVal = ($totalIn - $totalOut) * ($product->purchase_price ?? 0);
                            @endphp
                            <tr>
                                <td>{{ $product->name ?? 'N/A' }}</td>
                                <td>{{ $product->code ?? 'N/A' }}</td>
                                <td>{{ $product->unit->short_name ?? 'N/A' }}</td>
                                <td class="text-success">{{ number_format($purchaseQty, 3) }}</td>
                                <td class="text-danger">{{ number_format($purchaseReturnQty, 3) }}</td>
                                <td class="text-danger">{{ number_format($saleQty, 3) }}</td>
                                <td class="text-success">{{ number_format($saleReturnQty, 3) }}</td>
                                <td class="text-danger">{{ number_format($wastageQty, 3) }}</td>
                                <td class="text-success"><strong>{{ number_format($totalIn, 3) }}</strong></td>
                                <td class="text-danger"><strong>{{ number_format($totalOut, 3) }}</strong></td>
                                <td>
                                    @if(($totalIn - $totalOut) <= 0)
                                        <span class="badge bg-danger">Out of Stock</span>
                                    @elseif(($totalIn - $totalOut) <= ($product->alert_quantity ?? 0))
                                        <span class="badge bg-warning">{{ number_format($totalIn - $totalOut, 3) }}</span>
                                    @else
                                        <span class="badge bg-success">{{ number_format($totalIn - $totalOut, 3) }}</span>
                                    @endif
                                </td>
                                <td class="text-end">{{ number_format($stockVal, 2) }}</td>
                                <td>
                                    @if($product)
                                    <a href="{{ route('products.show', $product->id) }}" class="btn btn-sm btn-info" title="View">
                                        <i class="fa fa-eye"></i>
                                    </a>
                                    @endif
                                </td>
                            </tr>
                        @endforeach
                        
                        @if($allProducts->count() > 0)
                        @php
                            $totalStockValue = 0;
                            foreach($allProducts as $pid => $p) {
                                $pq = $purchaseItems->where('product_id', $pid)->sum('quantity');
                                $sq = $saleItems->where('product_id', $pid)->sum('quantity');
                                $wq = $wastageItems->where('product_id', $pid)->sum('quantity');
                                $prq = $purchaseReturnItems->where('product_id', $pid)->sum('quantity');
                                $srq = $saleReturnItems->where('product_id', $pid)->sum('quantity');
                                $stk = ($pq + $srq) - ($sq + $wq + $prq);
                                $totalStockValue += $stk * ($p->purchase_price ?? 0);
                            }
                        @endphp
                        <tr class="table-secondary">
                            <th colspan="3">Total</th>
                            <th class="text-success">{{ number_format($purchaseItems->sum('quantity'), 3) }}</th>
                            <th class="text-danger">{{ number_format($purchaseReturnItems->sum('quantity'), 3) }}</th>
                            <th class="text-danger">{{ number_format($saleItems->sum('quantity'), 3) }}</th>
                            <th class="text-success">{{ number_format($saleReturnItems->sum('quantity'), 3) }}</th>
                            <th class="text-danger">{{ number_format($wastageItems->sum('quantity'), 3) }}</th>
                            <th class="text-success">{{ number_format($purchaseItems->sum('quantity') + $saleReturnItems->sum('quantity'), 3) }}</th>
                            <th class="text-danger">{{ number_format($saleItems->sum('quantity') + $wastageItems->sum('quantity') + $purchaseReturnItems->sum('quantity'), 3) }}</th>
                            <th></th>
                            <th class="text-end">{{ number_format($totalStockValue, 2) }}</th>
                            <th></th>
                        </tr>
                        @endif
                    </tbody>
                </table>
            </div>

            @if($allProducts->count() == 0)
                <div class="alert alert-info">No inventory records found for this shipment number.</div>
            @endif

        @else
            <div class="alert alert-info">Please select a shipment number to view the inventory report.</div>
        @endif
    </div>
</div>
@endsection