@extends('layouts.app')
@section('title', 'Kartu Stok Bulanan')
@section('page-title', 'Kartu Stok Bulanan')

@push('styles')
<style>
    .stok-table{ font-size:.7rem; border-collapse:collapse; white-space:nowrap; }
    .stok-table th,.stok-table td{ border:1px solid #b9c4d0; padding:2px 4px; text-align:center; }
    .stok-table thead th{ background:#1565c0; color:#fff; position:sticky; top:0; }
    .stok-table .col-desc{ text-align:left; min-width:150px; position:sticky; left:0; background:#e3f2fd; }
    .stok-table .row-rcd td{ color:#c62828; font-weight:600; }
    .stok-table .row-bal{ background:#fff3cd; font-weight:700; }
    .stok-table .label-cell{ background:#f1f5f9; font-weight:600; text-align:left; position:sticky; left:0; }
</style>
@endpush

@section('content')
<div class="card mb-3">
    <div class="card-body">
        <form class="row g-2 align-items-end">
            <div class="col-md-3">
                <label class="form-label small">Bulan</label>
                <select name="month" class="form-select">
                    @foreach(range(1,12) as $m)
                        <option value="{{ $m }}" @selected($month==$m)>{{ \Carbon\Carbon::create(null,$m,1)->translatedFormat('F') }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-2">
                <label class="form-label small">Tahun</label>
                <input type="number" name="year" class="form-control" value="{{ $year }}">
            </div>
            <div class="col-md-3">
                <label class="form-label small">Kategori</label>
                <select name="category_id" class="form-select">
                    <option value="">-- Semua --</option>
                    @foreach($categories as $c)
                        <option value="{{ $c->id }}" @selected($categoryId==$c->id)>{{ $c->name }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-2">
                <button class="btn btn-primary w-100"><i class="bi bi-search"></i> Tampilkan</button>
            </div>
            <div class="col-md-2 d-flex gap-2">
                <button type="button" onclick="window.print()" class="btn btn-outline-secondary flex-fill"><i class="bi bi-printer"></i> Cetak</button>
                <button type="submit" formaction="{{ route('reports.monthly.export') }}" class="btn btn-success flex-fill"><i class="bi bi-file-earmark-excel"></i> Excel</button>
            </div>
        </form>
    </div>
</div>

<div class="card">
    <div class="card-header">
        Kartu Stok — {{ \Carbon\Carbon::create($year,$month,1)->translatedFormat('F Y') }}
        <span class="text-muted small ms-2">RCD=Masuk · ISS=Keluar · DISP=Buang/Rusak</span>
    </div>
    <div class="card-body p-0" style="overflow-x:auto; max-height:75vh;">
        <table class="stok-table">
            <thead>
                <tr>
                    <th class="col-desc" rowspan="2">DESKRIPSI & MEREK</th>
                    <th rowspan="2">UNIT</th>
                    <th rowspan="2">STOK<br>AWAL</th>
                    <th>ISSUES</th>
                    @for($d=1; $d<=7; $d++) <th rowspan="2">{{ $d }}</th> @endfor
                    <th rowspan="2" class="row-bal">BAL<br>INV.</th>
                    @for($d=8; $d<=14; $d++) <th rowspan="2">{{ $d }}</th> @endfor
                    <th rowspan="2" class="row-bal">BAL<br>INV.</th>
                    @for($d=15; $d<=21; $d++) <th rowspan="2">{{ $d }}</th> @endfor
                    <th rowspan="2" class="row-bal">BAL<br>INV.</th>
                    @for($d=22; $d<=31; $d++) <th rowspan="2">{{ $d }}</th> @endfor
                    <th rowspan="2">0</th>
                    <th rowspan="2">END<br>INV.</th>
                </tr>
                <tr>
                    <th>RECEIPT</th>
                </tr>
            </thead>
            <tbody>
            @forelse($report as $row)
                @php 
                    $rowspan = 3;
                    $bal7 = $row['begin_inv'];
                    for($d=1; $d<=7; $d++) {
                        $bal7 += ($row['daily'][$d]['RCD'] ?? 0) - ($row['daily'][$d]['ISS'] ?? 0) - ($row['daily'][$d]['DISP'] ?? 0) + ($row['daily'][$d]['ADJ'] ?? 0);
                    }
                    $bal14 = $bal7;
                    for($d=8; $d<=14; $d++) {
                        $bal14 += ($row['daily'][$d]['RCD'] ?? 0) - ($row['daily'][$d]['ISS'] ?? 0) - ($row['daily'][$d]['DISP'] ?? 0) + ($row['daily'][$d]['ADJ'] ?? 0);
                    }
                    $bal21 = $bal14;
                    for($d=15; $d<=21; $d++) {
                        $bal21 += ($row['daily'][$d]['RCD'] ?? 0) - ($row['daily'][$d]['ISS'] ?? 0) - ($row['daily'][$d]['DISP'] ?? 0) + ($row['daily'][$d]['ADJ'] ?? 0);
                    }
                    $sumAdj = 0;
                    for($d=1; $d<=31; $d++) {
                        $sumAdj += $row['daily'][$d]['ADJ'] ?? 0;
                    }
                @endphp
                {{-- RCD --}}
                <tr class="row-rcd">
                    <td class="col-desc" rowspan="{{ $rowspan }}">
                        <strong>{{ $row['item']->description }}</strong>
                        @if($row['item']->brand_type)<br><span class="text-muted">{{ $row['item']->brand_type }}</span>@endif
                    </td>
                    <td rowspan="{{ $rowspan }}">{{ $row['item']->unit ?? '-' }}</td>
                    <td rowspan="{{ $rowspan }}">{{ $row['begin_inv'] }}</td>
                    <td class="label-cell text-danger">RCD</td>
                    
                    @for($d=1; $d<=7; $d++) <td>{{ ($row['daily'][$d]['RCD'] ?? 0) ?: '' }}</td> @endfor
                    <td rowspan="{{ $rowspan }}" class="row-bal">{{ $bal7 }}</td>
                    
                    @for($d=8; $d<=14; $d++) <td>{{ ($row['daily'][$d]['RCD'] ?? 0) ?: '' }}</td> @endfor
                    <td rowspan="{{ $rowspan }}" class="row-bal">{{ $bal14 }}</td>
                    
                    @for($d=15; $d<=21; $d++) <td>{{ ($row['daily'][$d]['RCD'] ?? 0) ?: '' }}</td> @endfor
                    <td rowspan="{{ $rowspan }}" class="row-bal">{{ $bal21 }}</td>
                    
                    @for($d=22; $d<=31; $d++) <td>{{ ($row['daily'][$d]['RCD'] ?? 0) ?: '' }}</td> @endfor
                    <td rowspan="{{ $rowspan }}">{{ $sumAdj ?: '' }}</td>
                    <td rowspan="{{ $rowspan }}"><strong>{{ $row['end_inv'] }}</strong></td>
                </tr>
                {{-- ISS --}}
                <tr>
                    <td class="label-cell">ISS</td>
                    @for($d=1; $d<=7; $d++) <td>{{ ($row['daily'][$d]['ISS'] ?? 0) ?: '' }}</td> @endfor
                    @for($d=8; $d<=14; $d++) <td>{{ ($row['daily'][$d]['ISS'] ?? 0) ?: '' }}</td> @endfor
                    @for($d=15; $d<=21; $d++) <td>{{ ($row['daily'][$d]['ISS'] ?? 0) ?: '' }}</td> @endfor
                    @for($d=22; $d<=31; $d++) <td>{{ ($row['daily'][$d]['ISS'] ?? 0) ?: '' }}</td> @endfor
                </tr>
                {{-- DISP --}}
                <tr>
                    <td class="label-cell">DISP</td>
                    @for($d=1; $d<=7; $d++) <td>{{ ($row['daily'][$d]['DISP'] ?? 0) ?: '' }}</td> @endfor
                    @for($d=8; $d<=14; $d++) <td>{{ ($row['daily'][$d]['DISP'] ?? 0) ?: '' }}</td> @endfor
                    @for($d=15; $d<=21; $d++) <td>{{ ($row['daily'][$d]['DISP'] ?? 0) ?: '' }}</td> @endfor
                    @for($d=22; $d<=31; $d++) <td>{{ ($row['daily'][$d]['DISP'] ?? 0) ?: '' }}</td> @endfor
                </tr>
            @empty
                <tr><td colspan="40" class="text-center text-muted py-3">Tidak ada data.</td></tr>
            @endforelse
            </tbody>
        </table>
    </div>
</div>
@endsection