@extends('layouts.app')

@section('content')
<style>
    /* Menjamin modal selalu berada di atas layer gelap */
    .modal-backdrop {
        z-index: 1040 !important;
    }
    .modal {
        z-index: 1050 !important;
    }
</style>

<div class="content-box">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div>
            <h2 class="fw-bold">Dataset Historis Forecasting</h2>
            <p class="text-muted mb-0">
                Dataset penelitian digunakan untuk melatih model LSTM.
                Data mingguan apotek digunakan sebagai data operasional untuk proses forecasting.
            </p>
        </div>
        <div>
            <span class="badge bg-success p-2">{{ $statusDataset }}</span>
        </div>
    </div>

    @if(session('success'))
        <div class="alert alert-success alert-dismissible fade show" role="alert">
            {{ session('success') }}
            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
        </div>
    @endif

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

    {{-- STATISTIC CARDS --}}
    <div class="row g-4 mb-4">
        <div class="col-md-3">
            <div class="dashboard-card bg-primary text-white p-3 rounded">
                <h6>Dataset Penelitian</h6>
                <h2 class="mb-0">{{ number_format($totalData) }}</h2>
            </div>
        </div>
        <div class="col-md-3">
            <div class="dashboard-card bg-success text-white p-3 rounded">
                <h6>Jenis Obat</h6>
                <h2 class="mb-0">{{ $totalObat }}</h2>
            </div>
        </div>
        <div class="col-md-3">
            <div class="dashboard-card bg-warning p-3 rounded">
                <h6>Periode Dataset</h6>
                <small class="d-block fw-semibold">
                    {{ $dataTerlama }} <br> s/d <br> {{ $dataTerbaru }}
                </small>
            </div>
        </div>
        <div class="col-md-3">
            <div class="dashboard-card summary-card-purple p-3 rounded text-white" style="background-color: #6f42c1;">
                <h6>Rata-rata Penjualan</h6>
                <h2 class="mb-0">{{ $rataPenjualan }}</h2>
            </div>
        </div>
    </div>

    {{-- CHART & VALIDASI --}}
    <div class="row">
        <div class="col-lg-8">
            <div class="card-custom p-3 border rounded mb-4">
                <h5 class="mb-3">Distribusi Total Penjualan Dataset Penelitian</h5>
                <div style="height:350px">
                    <canvas id="datasetChart"></canvas>
                </div>
            </div>
        </div>
        <div class="col-lg-4">
            <div class="card-custom p-3 border rounded mb-4">
                <h5 class="mb-3">Validasi Dataset Penelitian</h5>
                <table class="table table-sm">
                    <tr>
                        <td>Missing Value</td>
                        <td><span class="badge bg-success">{{ $missingValue }}</span></td>
                    </tr>
                    <tr>
                        <td>Duplicate Data</td>
                        <td><span class="badge bg-success">{{ $duplicateData }}</span></td>
                    </tr>
                    <tr>
                        <td>Penjualan Maksimum</td>
                        <td>{{ $penjualanMaks }}</td>
                    </tr>
                    <tr>
                        <td>Penjualan Minimum</td>
                        <td>{{ $penjualanMin }}</td>
                    </tr>
                    <tr>
                        <td>Status</td>
                        <td><span class="badge bg-primary">{{ $statusDataset }}</span></td>
                    </tr>
                </table>
                <hr>
                <p class="text-muted mb-2"><strong>Insight Dataset</strong></p>
                <ul class="text-muted small ps-3 mb-0">
                    <li>{{ number_format($totalData) }} record dataset penelitian.</li>
                    <li>{{ $totalObat }} jenis obat.</li>
                    <li>Dataset ini hanya digunakan untuk proses pelatihan model LSTM.</li>
                    <li>Data mingguan baru tidak akan mengubah dataset penelitian.</li>
                </ul>
            </div>
        </div>
    </div>

    {{-- DATASET PENELITIAN (READ ONLY) --}}
    <div class="card-custom p-3 border rounded mt-4">
        <div class="d-flex justify-content-between align-items-center mb-3">
            <div>
                <h4 class="mb-1">Dataset Penelitian</h4>
                <small class="text-muted">Dataset ini digunakan sebagai data pelatihan model LSTM.</small>
            </div>
            <span class="badge bg-primary">READ ONLY</span>
        </div>
        <div class="row align-items-center mb-3">
            <div class="col-md-5">
                <form method="GET">
                    <input type="text" class="form-control" name="search" value="{{ request('search') }}" placeholder="Cari nama obat...">
                </form>
            </div>
            <div class="col-md-7 text-end">
                <form class="d-inline" action="/manajemen-data/import" method="POST" enctype="multipart/form-data">
                    @csrf
                    <input type="file" name="file" required>
                    <button type="submit" class="btn btn-success">Import Dataset CSV</button>
                </form>
            </div>
        </div>

        <div class="table-responsive">
            <table class="table table-hover table-bordered align-middle mb-0">
                <thead class="table-dark">
                    <tr>
                        <th width="70">No</th>
                        <th>Tanggal</th>
                        <th>Nama Obat</th>
                        <th width="180">Jumlah Terjual</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($datasetPenelitian as $item)
                    <tr>
                        <td>{{ $loop->iteration + (($datasetPenelitian->currentPage()-1) * $datasetPenelitian->perPage()) }}</td>
                        <td>{{ $item->tanggal }}</td>
                        <td>{{ $item->nama_obat }}</td>
                        <td><span class="badge bg-success">{{ number_format($item->jumlah_terjual) }}</span></td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="4" class="text-center py-3">Dataset penelitian belum tersedia.</td>
                    </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
        <div class="mt-3">
            {{ $datasetPenelitian->links() }}
        </div>
    </div>

    {{-- DATA MINGGUAN APOTEK --}}
    <div class="card-custom p-3 border rounded mt-5">
        <div class="d-flex justify-content-between align-items-center mb-3">
            <div>
                <h4 class="mb-1">Data Mingguan Apotek</h4>
                <small class="text-muted">Data operasional yang ditambahkan setiap minggu dan digunakan sebagai input forecasting LSTM.</small>
            </div>
            <span class="badge bg-success">AKTIF</span>
        </div>
        <div class="row align-items-center mb-3">
            <div class="col-md-6">
                <form method="GET">
                    <input type="text" class="form-control" name="search" value="{{ request('search') }}" placeholder="Cari nama obat...">
                </form>
            </div>
            <div class="col-md-6 text-end">
                <a href="/manajemen-data/create" class="btn btn-primary">Tambah Data Mingguan</a>
            </div>
        </div>

        <div class="table-responsive">
            <table class="table table-hover table-bordered align-middle mb-0">
                <thead class="table-dark">
                    <tr>
                        <th width="70">No</th>
                        <th>Tanggal</th>
                        <th>Nama Obat</th>
                        <th width="170">Jumlah Terjual</th>
                        <th width="170" class="text-center">Aksi</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($data as $item)
                    <tr>
                        <td>{{ $loop->iteration + (($data->currentPage()-1) * $data->perPage()) }}</td>
                        <td>{{ $item->tanggal }}</td>
                        <td>{{ $item->nama_obat }}</td>
                        <td><span class="badge bg-success">{{ number_format($item->jumlah_terjual) }}</span></td>
                        <td class="text-center">
                            <button type="button" class="btn btn-warning btn-sm" data-bs-toggle="modal" data-bs-target="#editModal{{ $item->id }}">
                                <i class="fas fa-edit"></i> Edit
                            </button>

                            @php $showDeleteButton = false; @endphp
                            @if($showDeleteButton)
                            <form action="/manajemen-data/delete/{{ $item->id }}" method="POST" class="d-inline">
                                @csrf
                                @method('DELETE')
                                <button class="btn btn-danger btn-sm">Hapus</button>
                            </form>
                            @endif
                        </td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="5" class="text-center py-3">Belum ada data mingguan.</td>
                    </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
        <div class="mt-3">
            {{ $data->links() }}
        </div>
    </div>
</div>

{{-- ========================================================= --}}
{{-- DAFTAR MODAL EDIT (DILETAKKAN DI LUAR STRUKTUR TABEL) --}}
{{-- ========================================================= --}}
@foreach($data as $item)
<div class="modal fade" id="editModal{{ $item->id }}" tabindex="-1" aria-labelledby="editModalLabel{{ $item->id }}" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <form action="{{ route('data.update', $item->id) }}" method="POST">
                @csrf
                @method('PUT')
                <div class="modal-header">
                    <h5 class="modal-title" id="editModalLabel{{ $item->id }}">Edit Data Mingguan</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <div class="mb-3">
                        <label class="form-label">Tanggal</label>
                        <input type="date" name="tanggal" class="form-control" value="{{ $item->tanggal }}" required>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Nama Obat</label>
                        <select name="nama_obat" class="form-select" required>
                            @foreach($daftarObat as $obat)
                                <option value="{{ $obat }}" {{ $item->nama_obat == $obat ? 'selected' : '' }}>
                                    {{ $obat }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Jumlah Terjual</label>
                        <input type="number" name="jumlah_terjual" class="form-control" value="{{ $item->jumlah_terjual }}" required>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Batal</button>
                    <button type="submit" class="btn btn-primary">Simpan Perubahan</button>
                </div>
            </form>
        </div>
    </div>
</div>
@endforeach

<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
const ctx = document.getElementById('datasetChart');
if (ctx) {
    new Chart(ctx, {
        type: 'bar',
        data: {
            labels: @json($chartLabels),
            datasets: [{
                label: 'Total Penjualan',
                data: @json($chartValues),
                backgroundColor: '#0d6efd',
                borderRadius: 8,
                borderWidth: 0
            }]
        },
        options: {
            responsive: true,
            maintainAspectRatio: false,
            plugins: {
                legend: { display: false },
                title: {
                    display: true,
                    text: 'Distribusi Total Penjualan Dataset Penelitian'
                }
            },
            scales: {
                y: {
                    beginAtZero: true,
                    ticks: { precision: 0 }
                },
                x: {
                    grid: { display: false }
                }
            }
        }
    });
}
</script>
@endsection