@extends('admin.layouts.app')

@section('title', 'Shipment Wise Inventory Report')
@section('page_title', 'Shipment Wise Inventory Report')

@section('content')
@if(session('success'))
    <div class="alert alert-success alert-dismissible fade show">
        {{ session('success') }}
        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
    </div>
@endif
@if(session('error'))
    <div class="alert alert-danger alert-dismissible fade show">
        {{ session('error') }}
        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
    </div>
@endif

<div class="card mb-4">
    <div class="card-header">
        <div class="d-flex justify-content-between align-items-center">
            <h5 class="mb-0">Shipment Number List</h5>
        </div>
    </div>
    <div class="card-body">
        <div class="table-responsive">
            <table class="table table-bordered table-striped">
                <thead>
                    <tr>
                        <th>#</th>
                        <th>Shipment Number</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($allShipments as $index => $shipment)
                        <tr>
                            <td>{{ $index + 1 }}</td>
                            <td>
                                <a href="{{ route('inventory.shipment.report', ['shipment_number' => $shipment]) }}">{{ $shipment }}</a>
                            </td>
                            <td>
                                <button type="button" class="btn btn-sm btn-warning" data-bs-toggle="modal" data-bs-target="#editModal{{ $index }}">
                                    <i class="fas fa-edit"></i> Edit
                                </button>
                            </td>
                        </tr>

                        <div class="modal fade" id="editModal{{ $index }}" tabindex="-1">
                            <div class="modal-dialog">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title">Edit Shipment Number</h5>
                                        <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                                    </div>
                                    <form action="{{ route('inventory.shipment.update') }}" method="POST">
                                        @csrf
                                        <div class="modal-body">
                                            <div class="mb-3">
                                                <label class="form-label">Current Shipment Number</label>
                                                <input type="text" class="form-control" value="{{ $shipment }}" readonly>
                                                <input type="hidden" name="old_shipment_number" value="{{ $shipment }}">
                                            </div>
                                            <div class="mb-3">
                                                <label class="form-label">New Shipment Number <span class="text-danger">*</span></label>
                                                <input type="text" name="new_shipment_number" class="form-control" value="{{ $shipment }}" required>
                                            </div>
                                        </div>
                                        <div class="modal-footer">
                                            <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                                            <button type="submit" class="btn btn-warning">Update</button>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                    @empty
                        <tr>
                            <td colspan="3" class="text-center">No shipment numbers found.</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>

<div class="card">
    <div class="card-header">
        <div class="d-flex justify-content-between align-items-center">
            <h5 class="mb-0">Inventory Report - Shipment Wise</h5>
        </div>
    </div>
    <div class="card-body">
        <form method="GET" action="{{ route('inventory.shipment.report') }}" 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.shipment.report') }}" 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>
            
            @if($purchaseItems->count() > 0)
            <div class="mb-4">
                <h6 class="text-success">Purchase Items (Stock In)</h6>
                <div class="table-responsive">
                    <table class="table table-bordered table-striped">
                        <thead>
                            <tr>
                                <th>Product</th>
                                <th>Code</th>
                                <th>Unit</th>
                                <th>Quantity</th>
                                <th>Rate</th>
                                <th>Amount</th>
                                <th>Supplier</th>
                                <th>Date</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($purchaseItems as $item)
                                <tr>
                                    <td>{{ $item->product->name ?? 'N/A' }}</td>
                                    <td>{{ $item->product->code ?? 'N/A' }}</td>
                                    <td>{{ $item->product->unit->short_name ?? 'N/A' }}</td>
                                    <td>{{ number_format($item->quantity, 3) }}</td>
                                    <td>{{ number_format($item->rate, 2) }}</td>
                                    <td>{{ number_format($item->amount, 2) }}</td>
                                    <td>{{ $item->purchase->supplier->name ?? 'N/A' }}</td>
                                    <td>{{ $item->purchase->date ?? 'N/A' }}</td>
                                </tr>
                            @endforeach
                            <tr class="table-success">
                                <th colspan="3">Total</th>
                                <th>{{ number_format($purchaseItems->sum('quantity'), 3) }}</th>
                                <th></th>
                                <th>{{ number_format($purchaseItems->sum('amount'), 2) }}</th>
                                <th colspan="2"></th>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
            @endif

            @if($saleItems->count() > 0)
            <div class="mb-4">
                <h6 class="text-danger">Sale Items (Stock Out)</h6>
                <div class="table-responsive">
                    <table class="table table-bordered table-striped">
                        <thead>
                            <tr>
                                <th>Product</th>
                                <th>Code</th>
                                <th>Unit</th>
                                <th>Quantity</th>
                                <th>Rate</th>
                                <th>Amount</th>
                                <th>Customer</th>
                                <th>Date</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($saleItems as $item)
                                <tr>
                                    <td>{{ $item->product->name ?? 'N/A' }}</td>
                                    <td>{{ $item->product->code ?? 'N/A' }}</td>
                                    <td>{{ $item->product->unit->short_name ?? 'N/A' }}</td>
                                    <td>{{ number_format($item->quantity, 3) }}</td>
                                    <td>{{ number_format($item->rate, 2) }}</td>
                                    <td>{{ number_format($item->amount, 2) }}</td>
                                    <td>{{ $item->sale->customer->name ?? 'N/A' }}</td>
                                    <td>{{ $item->sale->date ?? 'N/A' }}</td>
                                </tr>
                            @endforeach
                            <tr class="table-danger">
                                <th colspan="3">Total</th>
                                <th>{{ number_format($saleItems->sum('quantity'), 3) }}</th>
                                <th></th>
                                <th>{{ number_format($saleItems->sum('amount'), 2) }}</th>
                                <th colspan="2"></th>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
            @endif

            @if($wastageItems->count() > 0)
            <div class="mb-4">
                <h6 class="text-warning">Wastage Items (Stock Out)</h6>
                <div class="table-responsive">
                    <table class="table table-bordered table-striped">
                        <thead>
                            <tr>
                                <th>Product</th>
                                <th>Code</th>
                                <th>Unit</th>
                                <th>Quantity</th>
                                <th>Rate</th>
                                <th>Amount</th>
                                <th>Date</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($wastageItems as $item)
                                <tr>
                                    <td>{{ $item->product->name ?? 'N/A' }}</td>
                                    <td>{{ $item->product->code ?? 'N/A' }}</td>
                                    <td>{{ $item->product->unit->short_name ?? 'N/A' }}</td>
                                    <td>{{ number_format($item->quantity, 3) }}</td>
                                    <td>{{ number_format($item->rate, 2) }}</td>
                                    <td>{{ number_format($item->amount, 2) }}</td>
                                    <td>{{ $item->wastage->date ?? 'N/A' }}</td>
                                </tr>
                            @endforeach
                            <tr class="table-warning">
                                <th colspan="3">Total</th>
                                <th>{{ number_format($wastageItems->sum('quantity'), 3) }}</th>
                                <th></th>
                                <th>{{ number_format($wastageItems->sum('amount'), 2) }}</th>
                                <th></th>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
            @endif

            @if($purchaseReturns->count() > 0)
            <div class="mb-4">
                <h6 class="text-info">Purchase Return Items (Stock Out)</h6>
                <div class="table-responsive">
                    <table class="table table-bordered table-striped">
                        <thead>
                            <tr>
                                <th>Product</th>
                                <th>Code</th>
                                <th>Unit</th>
                                <th>Quantity</th>
                                <th>Rate</th>
                                <th>Amount</th>
                                <th>Supplier</th>
                                <th>Date</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($purchaseReturns as $item)
                                <tr>
                                    <td>{{ $item->product->name ?? 'N/A' }}</td>
                                    <td>{{ $item->product->code ?? 'N/A' }}</td>
                                    <td>{{ $item->product->unit->short_name ?? 'N/A' }}</td>
                                    <td>{{ number_format($item->quantity, 3) }}</td>
                                    <td>{{ number_format($item->rate, 2) }}</td>
                                    <td>{{ number_format($item->amount, 2) }}</td>
                                    <td>{{ $item->purchaseReturn->purchase->supplier->name ?? 'N/A' }}</td>
                                    <td>{{ $item->purchaseReturn->date ?? 'N/A' }}</td>
                                </tr>
                            @endforeach
                            <tr class="table-info">
                                <th colspan="3">Total</th>
                                <th>{{ number_format($purchaseReturns->sum('quantity'), 3) }}</th>
                                <th></th>
                                <th>{{ number_format($purchaseReturns->sum('amount'), 2) }}</th>
                                <th colspan="2"></th>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
            @endif

            @if($saleReturns->count() > 0)
            <div class="mb-4">
                <h6 class="text-primary">Sale Return Items (Stock In)</h6>
                <div class="table-responsive">
                    <table class="table table-bordered table-striped">
                        <thead>
                            <tr>
                                <th>Product</th>
                                <th>Code</th>
                                <th>Unit</th>
                                <th>Quantity</th>
                                <th>Rate</th>
                                <th>Amount</th>
                                <th>Customer</th>
                                <th>Date</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($saleReturns as $item)
                                <tr>
                                    <td>{{ $item->product->name ?? 'N/A' }}</td>
                                    <td>{{ $item->product->code ?? 'N/A' }}</td>
                                    <td>{{ $item->product->unit->short_name ?? 'N/A' }}</td>
                                    <td>{{ number_format($item->quantity, 3) }}</td>
                                    <td>{{ number_format($item->rate, 2) }}</td>
                                    <td>{{ number_format($item->amount, 2) }}</td>
                                    <td>{{ $item->saleReturn->sale->customer->name ?? 'N/A' }}</td>
                                    <td>{{ $item->saleReturn->date ?? 'N/A' }}</td>
                                </tr>
                            @endforeach
                            <tr class="table-primary">
                                <th colspan="3">Total</th>
                                <th>{{ number_format($saleReturns->sum('quantity'), 3) }}</th>
                                <th></th>
                                <th>{{ number_format($saleReturns->sum('amount'), 2) }}</th>
                                <th colspan="2"></th>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
            @endif

            @if($purchaseItems->count() == 0 && $saleItems->count() == 0 && $wastageItems->count() == 0 && $purchaseReturns->count() == 0 && $saleReturns->count() == 0)
                <div class="alert alert-info">No inventory records found for this shipment number.</div>
            @endif

            @if($purchaseItems->count() > 0 || $saleItems->count() > 0 || $wastageItems->count() > 0 || $purchaseReturns->count() > 0 || $saleReturns->count() > 0)
            <div class="card mt-4">
                <div class="card-header">
                    <h6 class="mb-0">Summary for Shipment: {{ $shipmentNumber }}</h6>
                </div>
                <div class="card-body">
                    <table class="table table-bordered">
                        <tr>
                            <th>Total Stock In (Purchases + Sale Returns)</th>
                            <td class="text-success">
                                {{ number_format($purchaseItems->sum('quantity') + $saleReturns->sum('quantity'), 3) }}
                            </td>
                        </tr>
                        <tr>
                            <th>Total Stock Out (Sales + Wastage + Purchase Returns)</th>
                            <td class="text-danger">
                                {{ number_format($saleItems->sum('quantity') + $wastageItems->sum('quantity') + $purchaseReturns->sum('quantity'), 3) }}
                            </td>
                        </tr>
                        <tr>
                            <th>Net Inventory Movement</th>
                            <td class="{{ ($purchaseItems->sum('quantity') + $saleReturns->sum('quantity') - $saleItems->sum('quantity') - $wastageItems->sum('quantity') - $purchaseReturns->sum('quantity')) >= 0 ? 'text-success' : 'text-danger' }}">
                                {{ number_format($purchaseItems->sum('quantity') + $saleReturns->sum('quantity') - $saleItems->sum('quantity') - $wastageItems->sum('quantity') - $purchaseReturns->sum('quantity'), 3) }}
                            </td>
                        </tr>
                    </table>
                </div>
            </div>
            @endif
        @else
            <div class="alert alert-info">Please select a shipment number to view the inventory report.</div>
        @endif
    </div>
</div>
@endsection