@extends('master')
@section('content')
<div class="container">
    <div class="row">
        <div class="col">
            <div class="page-description d-flex align-items-center">
                <h1 class="mb-0">Detail Item Berlebih</h1>
                <i class="material-icons-two-tone me-2" style="font-size: 50px;">inventory_2</i>
            </div>
        </div>
    </div>

    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <div class="d-flex justify-content-between align-items-center">
                        <h5 class="card-title">Detail Perhitungan Item Berlebih</h5>
                        <a href="{{ route('dashboard-visual.index') }}" class="btn btn-primary">
                            <i class="material-icons">arrow_back</i> Kembali
                        </a>
                    </div>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-bordered">
                            <thead>
                                <tr>
                                    <th>Kode Item</th>
                                    <th>Deskripsi</th>
                                    <th>Total Stok</th>
                                    <th>Detail Stok</th>
                                    <th>Sumber MinMax</th>
                                    <th>Batas Max</th>
                                    <th>Monthly Needs</th>
                                    <th>Qty Berlebih</th>
                                    <th>Harga</th>
                                    <th>Value Berlebih</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($excessDetails as $detail)
                                <tr>
                                    <td>{{ $detail['item_code'] }}</td>
                                    <td>{{ $detail['description'] }}</td>
                                    <td>{{ $detail['stock_details']['total'] }}</td>
                                    <td>
                                        Master: {{ $detail['stock_details']['master'] }}<br>
                                        Mikro: {{ $detail['stock_details']['mikro'] }}<br>
                                        CPO: {{ $detail['stock_details']['cpo'] }}<br>
                                        CI: {{ $detail['stock_details']['ci'] }}
                                    </td>
                                    <td>{{ $detail['minmax_info']['source'] }}</td>
                                    <td>{{ $detail['minmax_info']['max'] }}</td>
                                    <td>{{ $detail['minmax_info']['monthly_needs'] }}</td>
                                    <td>{{ $detail['excess_qty'] }}</td>
                                    <td>Rp {{ number_format($detail['price'], 0, ',', '.') }}</td>
                                    <td>Rp {{ number_format($detail['excess_value'], 0, ',', '.') }}</td>
                                </tr>
                                @endforeach
                            </tbody>
                            <tfoot>
                                <tr>
                                    <td colspan="9" class="text-end"><strong>Total Value Berlebih:</strong></td>
                                    <td><strong>Rp {{ number_format($totalExcessValue, 0, ',', '.') }}</strong></td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection