@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.sidebar')
    @include('layouts.header-sub')

    <section class="wrapper bg-light">
        <div class="container py-14 py-md-16">
            <div class="row gx-lg-8 gx-xl-12">

                <div class="col-md-12">
                    <h5 class="display-1 mb-3" style="font-size: 30px">@yield('title')</h5>
                    <p class="lead fs-lg pe-lg-15 pe-xxl-12"></p>
                </div>

                <div class="col-lg-12">
                    <div class="blog single">
                        <div class="card">
                            <div class="card-body">
                                <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>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>

    @include('layouts.footer')
@endsection