@extends("common.layout")

@section("header")
    {!! resource('css/dashboard.css') !!}
    {!! resource('js/dashboard/dashboard-common.js') !!}
@endsection

@section("content")
    <div id="dashboard" class="total-stat">
        <div class="max-width" style="width : 1400px">
            <!-- 기간 조회  -->
            <form action="" id="stats-form">
                <div class="site-type flex" >
                    <button type="button" class="tab move-only active" >[전체] 월별 통계</button>
                    <button type="button" class="tab move-only"  onclick="location.href='{{route('statics.academy.stats')}}'">[학원] 팀별 수강&매출요약</button>
                    <button type="button" class="tab move-only" onclick="location.href='{{route('statics.academy.stat-detail')}}'">[학원] 팀별 수강&매출상세</button>
                </div>
                <div class="year-wrap flex">
                    <div class="year-input">
                        <select style="" name="year">
                            @for ($year = 2025; $year <= date('Y'); $year++)
                                <option value="{{ $year }}" @selected($year == Request::get('year', date('Y')))>{{ $year }}</option>
                            @endfor
                        </select>
                    </div>
                </div>
                <div class="apply-wrap flex">
                        <input type="submit" value="조회" class="btn-search" >
                </div>
            </form>
            <article class="static-table-wrap yesterday-stats">
                <div>
                    <p class="table-title">전일(<span>{{$yesterday->format('m/d')}}</span>) 매출 현황</p>
                    <div class="before-academy-stats">
                        <b>총 매출액 {{ number_format($dailyStats['total']) }}원</b>
                        <p>신규 <span>{{$dailyStats['new']['count']}}</span>건 매출액 <span>{{number_format($dailyStats['new']['sum'])}}</span>원 |
                           재등록 <span>{{$dailyStats['re']['count']}}</span>건 매출액 <span>{{number_format($dailyStats['re']['sum'])}}</span>원 |
                           (+) 변경 <span>{{$dailyStats['change']['count']}}</span>건 매출액 <span>{{number_format($dailyStats['change']['sum'])}}</span>원  |
                           (-) 변경(환불) <span>{{$dailyStats['change_refund']['count']}}</span>건 매출액 <span class="red">
                           {{ $dailyStats['change_refund']['sum'] > 0 ? '-' . number_format($dailyStats['change_refund']['sum']) : number_format($dailyStats['change_refund']['sum']) }}</span>원 |
                           기타 <span>{{$dailyStats['etc']['count']}}</span>건 매출액 <span>{{number_format($dailyStats['etc']['sum'])}}</span>원  </p>
                    </div>
                </div>
            </article>
            <article class="static-table-wrap">
                <div>
                    <p class="table-title">어학센터(정산기준)</p>
                </div>
                <table>
                    @php
                        $colCount = count($academyMonthArray);
                        $dynamicWidth = "calc((100% - 390px) / {$colCount})";
                        // $results를 month 기준으로 key로 변환 (빠른 조회용)

                        $resultsByMonth = $academyData->keyBy('month');
                        $detailByMonth = $academyDetail->keyBy('month');
                        // 누계용 변수
                        $totalRevenue = 0;
                        $newRevenue = 0;
                        $reRevenue = 0;
                        $changeRevenue = 0;
                        $refundRevenue= 0;
                        $etcRevenue = 0;
                        $totalGrowthRate = 0;
                    @endphp
                    <colgroup>
                        <col width="130px">
                        @foreach($academyMonthArray as $month)
                            <col width="{{ $dynamicWidth }}">
                        @endforeach
                        <col width="120px">
                    </colgroup>
                    <thead>
                    <tr class="bg-white">
                        <td></td>
                        @foreach($academyMonthArray as $month)
                            <th>{{ \Carbon\Carbon::parse($month.'-01')->month }}월</th>
                        @endforeach
                        <th>누계</th>
                    </tr>
                    </thead>
                    <tbody>
                    <tr class="bg-neutral-light">
                        <td>신규</td>
                        @foreach($academyMonthArray as $month)
                            @php
                                $currNet = $detailByMonth[$month]->payment_new ?? 0;
                                $newRevenue += $currNet;
                            @endphp
                            <td>{{ number_format($currNet) }}</td>
                        @endforeach
                        <td>{{ number_format($newRevenue) }}</td>
                    </tr>
                    <tr class="bg-neutral-light">
                        <td>재등록</td>
                        @foreach($academyMonthArray as $month)
                            @php
                                $currNet = $detailByMonth[$month]->payment_re ?? 0;
                                $reRevenue += $currNet;
                            @endphp
                            <td>{{ number_format($currNet) }}</td>
                        @endforeach
                        <td>{{ number_format($reRevenue) }}</td>
                    </tr>
                    <tr class="bg-neutral-light">
                        <td>(+) 변경</td>
                        @foreach($academyMonthArray as $month)
                            @php
                                $currNet = $detailByMonth[$month]->payment_change ?? 0;
                                $changeRevenue += $currNet;
                            @endphp
                            <td>{{ number_format($currNet) }}</td>
                        @endforeach
                        <td>{{ number_format($changeRevenue) }}</td>
                    </tr>
                    <tr class="bg-neutral-light">
                        <td>(-) 변경 / 환불</td>
                        @foreach($academyMonthArray as $month)
                            @php
                                $currNet = $detailByMonth[$month]->refund_total ?? 0;
                                $refundRevenue += $currNet;
                            @endphp
                            <td class="red">
                                {{ $currNet > 0 ? '-' . number_format($currNet) : number_format($currNet) }}
                            </td>
                        @endforeach
                        <td class="red">
                            {{ $refundRevenue > 0 ? '-' . number_format($refundRevenue) : number_format($refundRevenue) }}
                        </td>
                    </tr>
                    <tr class="bg-neutral-light">
                        <td>기타</td>
                        @foreach($academyMonthArray as $month)
                            @php
                                $currNet = $detailByMonth[$month]->payment_etc ?? 0;
                                $etcRevenue += $currNet;
                            @endphp
                            <td>{{ number_format($currNet) }}</td>
                        @endforeach
                        <td>{{ number_format($etcRevenue) }}</td>
                    </tr>
                    <tr class="bg-neutral-light">
                        <td>합계</td>
                        @foreach($academyMonthArray as $month)
                            @php
                                $currNet = $resultsByMonth[$month]->curr_net ?? 0;
                                $totalRevenue += $currNet;
                            @endphp
                            <td><b>{{ number_format($currNet) }}</b></td>
                        @endforeach
                        <td><b>{{ number_format($totalRevenue) }}</b></td>
                    </tr>
                    <tr>
                        <td>증감율</td>
                        @foreach($academyMonthArray as $month)
                        @php
                            $currNet = $resultsByMonth[$month]->curr_net ?? 0;
                            $prevMonthNet = $resultsByMonth[$month]->prev_net ?? 0;

                            if (is_null($prevMonthNet) || $prevMonthNet == 0) {
                                $growth = null; // 0이 아니라 null로 표시
                            } else {
                                $growth = ($currNet - $prevMonthNet) / $prevMonthNet * 100;
                            }

                            // 색 결정 (양수: 파랑, 음수: 빨강, null: 기본)
                            if (is_null($growth)) {
                                $colorClass = '';
                            } elseif ($growth > 0) {
                                $colorClass = 'text-blue'; // Tailwind 예시
                            } else {
                                $colorClass = 'text-red';
                            }
                        @endphp
                        <td class="{{ $colorClass }}">
                            {{ is_null($growth) ? '-' : number_format($growth, 1) . '%' }}
                        </td>
                        @endforeach
                        <td class="{{ is_null($growth) ? '' : ($growth > 0 ? 'text-blue' : 'text-red') }}">
                            {{ is_null($growth) ? '-' : number_format($growth, 1) . '%' }}
                        </td>
                    </tr>
                    </tbody>
                </table>
            </article>

            <article class="static-table-wrap">
                <div>
                    <p class="table-title">인강</p>
                </div>
                <table>
                    @php
                        $colCount = count($monthArray);
                        $dynamicWidth = "calc((100% - 360px) / {$colCount})";

                        // $results를 month 기준으로 key로 변환 (빠른 조회용)
                        $resultsByMonth = $ieltsData->keyBy('month');
                        // 누계용 변수
                        $totalRevenue = 0;
                        $totalGrowthRate = 0;
                         $totalPaymentRevenue = 0;
                        $totalRefundRevenue = 0;
                    @endphp
                    <colgroup>
                        <col width="100px">
                        @foreach($monthArray as $month)
                            <col style="width:{{ $dynamicWidth }};">
                        @endforeach
                        <col width="120px">
                    </colgroup>
                    <thead>
                    <tr class="bg-white">
                        <td></td>
                        @foreach($monthArray as $month)
                            <th>{{ \Carbon\Carbon::parse($month.'-01')->month }}월</th>
                        @endforeach
                        <th>누계</th>
                    </tr>
                    </thead>
                    <tbody>
                    <tr class="bg-neutral-light">
                        <td>매출액</td>
                        @foreach($monthArray as $month)
                            @php
                                $currPayment = $resultsByMonth[$month]->curr_payment ?? 0;
                                $totalPaymentRevenue += $currPayment;
                            @endphp
                            <td>{{ number_format($currPayment) }}</td>
                        @endforeach
                        <td>{{ number_format($totalPaymentRevenue) }}</td>
                    </tr>
                    <tr class="bg-neutral-light">
                        <td>취소/환불액</td>
                        @foreach($monthArray as $month)
                            @php
                                $currRefund = $resultsByMonth[$month]->curr_refund ?? 0;
                                $totalRefundRevenue += $currRefund;
                            @endphp
                            <td class="red">
                                {{ $currRefund != 0 ? '-'.number_format($currRefund) : number_format($currRefund) }}
                            </td>
                        @endforeach
                        <td class="red">
                            {{ $totalRefundRevenue != 0 ? '-'.number_format($totalRefundRevenue) : number_format($totalRefundRevenue) }}
                        </td>
                    </tr>
                    {{-- 매출액 --}}
                    <tr class="bg-neutral-light">
                        <td><b>합계</b></td>
                        @foreach($monthArray as $month)
                            @php
                                $currNet = $resultsByMonth[$month]->curr_net ?? 0;
                                $totalRevenue += $currNet;
                            @endphp
                            <td><b>{{ number_format($currNet) }}</b></td>
                        @endforeach
                        <td><b>{{ number_format($totalRevenue) }}</b></td>
                    </tr>

                    {{-- 증감율 (전월 대비) --}}
                    <tr>
                        <td class="light-gray text-sub">증감율</td>
                        @foreach($monthArray as $month)
                            @php
                                $currNet = $resultsByMonth[$month]->curr_net ?? 0;
                                $prevMonthNet = $resultsByMonth[$month]->prev_net ?? 0;

                                if (is_null($prevMonthNet) || $prevMonthNet == 0) {
                                    $growth = null; // 0이 아니라 null로 표시
                                } else {
                                    $growth = ($currNet - $prevMonthNet) / $prevMonthNet * 100;
                                }

                                // 색 결정 (양수: 파랑, 음수: 빨강, null: 기본)
                                if (is_null($growth)) {
                                    $colorClass = '';
                                } elseif ($growth > 0) {
                                    $colorClass = 'text-blue'; // Tailwind 예시
                                } else {
                                    $colorClass = 'text-red';
                                }
                            @endphp
                            <td class="{{ $colorClass }}">
                                {{ is_null($growth) ? '-' : number_format($growth, 1) . '%' }}
                            </td>
                        @endforeach
                        <td class="{{ is_null($growth) ? '' : ($growth > 0 ? 'text-blue' : 'text-red') }}">
                            {{ is_null($growth) ? '-' : number_format($growth, 1) . '%' }}
                        </td>
                    </tr>
                    </tbody>
                </table>
            </article>
        </div>
    </div>
@endsection
@push("script")
    <style>
    </style>
    <script>
    </script>
@endpush