@extends('layouts.master')
@section('title', 'Monthly Transaction Dashboard')

@section('style')
    <style>
        .chart-container {
            width: 100%;
            max-width: 1000px;
            margin: auto;
            padding: 20px;
            background: #fff;
            border-radius: 16px;
            box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
        }

        .dashboard-header {
            text-align: center;
            margin-bottom: 2rem;
        }

        .form-inline-custom {
            display: flex;
            flex-wrap: wrap;
            gap: 1rem;
            align-items: end;
            justify-content: center;
            margin-bottom: 2rem;
        }

        .form-inline-custom .form-group {
            min-width: 200px;
        }
    </style>
@endsection

@section('script')
    <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
    <script>
        document.addEventListener('DOMContentLoaded', function() {
            const ctx = document.getElementById('monthlyTransactionChart').getContext('2d');

            const transactions = @json($transactions);
            const returns = @json($returns);

            // สร้าง mapping เดือน -> จำนวน
            const orderMap = {};
            transactions.forEach(t => orderMap[t.month] = t.total_orders);

            const returnMap = {};
            returns.forEach(r => returnMap[r.month] = r.total_returns);

            // รวมเดือนทั้งหมด
            const allMonths = [...new Set([...transactions.map(t => t.month), ...returns.map(r => r.month)])]
        .sort();

            const orderData = allMonths.map(m => orderMap[m] || 0);
            const returnData = allMonths.map(m => returnMap[m] || 0);

            new Chart(ctx, {
                type: 'bar',
                data: {
                    labels: allMonths,
                    datasets: [{
                            label: 'จำนวนเบิก',
                            data: orderData,
                            backgroundColor: 'rgba(54, 162, 235, 0.7)'
                        },
                        {
                            label: 'จำนวนคืน',
                            data: returnData,
                            backgroundColor: 'rgba(255, 99, 132, 0.7)'
                        }
                    ]
                },
                options: {
                    responsive: true,
                    plugins: {
                        title: {
                            display: true,
                            text: '📊 รายงานเบิก-คืน รายเดือน'
                        }
                    },
                    scales: {
                        y: {
                            beginAtZero: true,
                            ticks: {
                                stepSize: 1
                            }
                        }
                    }
                }
            });
        });
    </script>
@endsection

@section('content')

    @include('layouts.header')
    @include('layouts.title')

    <section>
        <div class="container py-4">
            <div class="dashboard-header">
                <h2 class="fw-bold">📅 Monthly Transaction Dashboard</h2>
                <p class="text-muted">เลือกช่วงวันที่เพื่อดูสรุปรายเดือน</p>
            </div>

            <form method="GET" action="{{ route('monthlytransactiondashboard') }}" class="form-inline-custom mb-4">
                <div class="form-group">
                    <label for="start_date">เริ่มวันที่:</label>
                    <input type="date" id="start_date" name="start_date" class="form-control" value="{{ $startDate }}">
                </div>

                <div class="form-group">
                    <label for="end_date">ถึงวันที่:</label>
                    <input type="date" id="end_date" name="end_date" class="form-control" value="{{ $endDate }}">
                </div>

                <button type="submit" class="btn btn-primary">
                    <i class="bi bi-search"></i> แสดงผล
                </button>
            </form>

            <div class="chart-container">
                <canvas id="monthlyTransactionChart" height="120"></canvas>
            </div>
        </div>
    </section>

    @include('layouts.footer')
@endsection