@extends('layouts.app')

@section('content')
    <div class="row">
        <div class="card">
            <div class="card-header">
                <div class="d-flex justify-content-between align-items-center">
                    <div class="">
                        <h4>Report FIFO</h4>
                        <p class="f-m-light mt-1">We already set start date are 7 days before this day for database
                            performance purpose</p>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="card">
        <div class="card-body">
            <div class="table-responsive">
                <table class="display table table-striped tasble-hover" id="basic-1">
                    <thead>
                        <tr>
                            <th>Material Code</th>
                            <th>Good Receive No</th>
                            <th>Good Receive Date</th>
                            <th>Good Receive Qty</th>
                            <th>Total Pemakaian</th>
                            <th>Sisa Qty</th>
                            <th>Details</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($fifos as $materialCode => $fifo)
                            @php
                                $material = \App\Models\Material::where('code', $materialCode)->first();
                            @endphp
                            @foreach ($fifo as $f)
                                <tr>
                                    <td>{{ $materialCode }}</td>
                                    <td>{{ $f['no'] }}</td>
                                    <td>{{ $f['date'] }}</td>
                                    <td>{{ $f['qty'] }} {{ $material->uom_code }}</td>
                                    <td>{{ $f['qty'] - $f['balance'] }} {{ $material->uom_code }}</td>
                                    <td>{{ $f['balance'] }} {{ $material->uom_code }}</td>
                                    <td>
                                        @if (count($f['usages']) > 0)
                                            <!-- Button for expanding details -->
                                            <button class="btn btn-primary btn-sm" type="button" data-bs-toggle="collapse"
                                                data-bs-target="#details-{{ $loop->parent->index }}-{{ $loop->index }}"
                                                aria-expanded="false"
                                                aria-controls="details-{{ $loop->parent->index }}-{{ $loop->index }}">
                                                Sales
                                            </button>
                                        @endif
                                    </td>
                                </tr>
                                <tr class="collapse-row">
                                    <td colspan="7">
                                        <div class="collapse" id="details-{{ $loop->parent->index }}-{{ $loop->index }}">
                                            <div class="card card-body border-light mt-2">
                                                @foreach ($f['usages'] as $usage)
                                                    <div class="border rounded p-2 mb-2">
                                                        <strong>PO Buyer No:</strong> {{ $usage['po_buyer_no'] }}<br>
                                                        <strong>BOM No:</strong> {{ $usage['bom_no'] }}<br>
                                                        <strong>BOM Start Date:</strong> {{ $usage['bom_start_date'] }}<br>
                                                        <strong>Finish Good SJ No:</strong> {{ $usage['no'] }}<br>
                                                        <strong>Finish Good SJ Date:</strong> {{ $usage['date'] }}<br>
                                                        <strong>Material Code:</strong> {{ $usage['material_code'] }}<br>
                                                        <strong>Finish Good SJ Qty:</strong> {{ $usage['qty'] }}
                                                        {{ $usage['material_uom'] }}<br>
                                                        <strong>Kebutuhan:</strong> {{ $usage['material_usage'] }}
                                                        {{ $material->uom_code }}<br>
                                                        <strong>Pemakaian:</strong> {{ $usage['used'] }}
                                                        {{ $material->uom_code }}<br>
                                                        <strong>Sisa Kebutuhan:</strong> {{ $usage['remaining'] }}
                                                        {{ $material->uom_code }}
                                                    </div>
                                                @endforeach
                                            </div>
                                        </div>
                                    </td>
                                </tr>
                            @endforeach
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
@endsection

@section('js')
@endsection