@extends("common.layout")

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

@section("content")
{{--    @dd($studyPersonCount)--}}
    <div id="dashboard" class="academy-stats">
        <div class="max-width">
            <!-- 기간 조회  -->
            <form action="" id="stats-form">
                <div class="site-type flex" >
                    <button type="button" class="tab move-only" onclick="location.href='{{route('statics.total-stats')}}'" >[전체] 월별 통계</button>
                    <button type="button" class="tab move-only active" >[학원] 팀별 수강&매출요약</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 id="yearSelect" name="year">
                            @for ($year = 2025; $year <= $limitYear; $year++)
                                <option value="{{ $year }}" @selected($year == Request::get('year', date('Y')))>{{ $year }}</option>
                            @endfor
                        </select>
                    </div>
                </div>
                <div class="month-wrap flex">
                    <div class="month-input">
                        @php
                            $currentYear = \Carbon\Carbon::now()->year;
                            $currentMonth = \Carbon\Carbon::now()->month;

                            $selectedYear = Request::get('year', $currentYear);
                            $selectedMonths = Request::get('month', []);

                            // 월이 아무것도 선택되지 않았고, 선택된 연도가 현재 연도일 경우에만 최근 3개월을 기본값으로 설정
                            if (empty($selectedMonths) && $selectedYear == $currentYear) {
                                $startMonth = max(1, $currentMonth - 2); // 현재 월-2 또는 1월 중 큰 값
                                $selectedMonths = range($startMonth, $currentMonth);
                            }

                        @endphp
                        @for($i=12; $i>=1; $i--)
                            @php
                                $isChecked = in_array($i, $selectedMonths);
                            @endphp
                            <label>
                                <input type="checkbox" name="month[]" id="month"
                                       @checked($isChecked) value="{{ $i }}" >
                                <span>{{ $i }}월</span>
                            </label>
                        @endfor
                        <input type="submit" value="조회" class="btn-search">
                    </div>
                    <div class="apply-wrap">
                        <button type="button" onClick="statsExcelDownloads(this);"
                                data-url="{{route('api.static.excel.academy.stats')}}">엑셀 다운로드
                        </button>
                    </div>
                </div>
            </form>

            <article class="static-table-wrap">
                <div>
                    <p class="table-title">수강생 수 & 매출 통계</p>
                    <div class="btn-wrap">
                        <button type="button" class="btn btn-modify btn-edit">수정</button>
                        <button type="button" class="btn btn-modify btn-cancel hide">취소</button>
                        <button type="button" class="btn btn-primary btn-save hide">저장</button>
                    </div>
                </div>
                <table>
                    @php
                        $colCount = count($monthArray); // foreach로 생길 중간 열 개수
                        $dynamicWidth = "calc((100% - 360px) / {$colCount})";
                    @endphp
                    <colgroup>
                        <col width="100px">
                        <col width="140px">
                        @foreach($monthArray as $row)
                            <col style="width:{{ $dynamicWidth }};">
                        @endforeach
                        <col width="120px">
                    </colgroup>
                    <thead>
                    <tr class="light-gray">
                        <td colspan="2">구분</td>
                        @foreach($monthArray as $row)
                            <th>{{Carbon\Carbon::parse($row)->month}}월</th>
                        @endforeach
                        <th>합계</th>
                    </tr>
                    </thead>
                    <tbody>
                    <tr>
                        <td class="light-gray" rowspan="6">인원</td>
                        <td class="light-gray text-left">수강생수</td>
                        @foreach($monthArray as $row)
                            @php
                               $countData  = $monthlyCountData->where('target_month', $row)->first();
                            @endphp
                            <td class="text-right">{{$countData?->student_count ?? 0}}</td>
                            @endforeach
                        <td class="gray text-right">{{$totalCountData->student_count}}</td>
                    </tr>
                    <tr>
                        <td class="light-gray text-sub">①신규</td>
                        @foreach($monthArray as $row)
                        @php
                            $countData  = $monthlyCountData->where('target_month', $row)->first();
                        @endphp
                        <td  class="text-right">{{$countData?->new ?? 0}}</td>
                        @endforeach
                        <td class="gray text-right">{{$totalCountData->new}}</td>
                    </tr>
                    <tr>
                        <td class="light-gray text-sub">②재등록</td>
                        @foreach($monthArray as $row)
                            @php
                                $countData  = $monthlyCountData->where('target_month', $row)->first();
                            @endphp
                            <td  class="text-right">{{$countData?->renew ?? 0}}</td>
                        @endforeach
                        <td class="gray text-right">{{$totalCountData->renew}}</td>
                    </tr>
                    <tr>
                        <td class="light-gray text-sub">③기존</td>
                        @foreach($monthArray as $row)
                            @php
                                $countData  = $monthlyCountData->where('target_month', $row)->first();
                            @endphp
                            <td  class="text-right">{{$countData?->active ?? 0}}</td>
                        @endforeach
                        <td class="gray text-right">{{$totalCountData->active}}</td>
                    </tr>
                    <tr>
                        <td class="light-gray text-left">매출 인원수(①+②)</td>
                        @foreach($monthArray as $row)
                            @php
                                $countData  = $monthlyCountData->where('target_month', $row)->first();
                            @endphp
                            <td  class="text-right">{{$countData?->revenue_person_count ?? 0}}</td>
                        @endforeach
                        <td class="gray text-right">{{$totalCountData->revenue_person_count}}</td>
                    </tr>
                    <tr>
                        <td class="light-gray text-left">환불인원수</td>
                        @foreach($monthArray as $row)
                            @php
                                $countData  = $monthlyCountData->where('target_month', $row)->first();
                            @endphp
                            <td  class="text-right">{{$countData?->refund_person_count ?? 0}}</td>
                        @endforeach
                        <td class="gray text-right">{{$totalCountData->refund_person_count}}</td>
                    </tr>
                    <tr class="gray">
                        <td colspan="2">총 인원</td>
                        @foreach($monthArray as $row)
                            @php
                                $countData  = $monthlyCountData->where('target_month', $row)->first();
                            @endphp
                            <td  class="text-right">{{$countData?->total_person_count ?? 0}}</td>
                        @endforeach
                        <td class="gray text-right">{{$totalCountData->total_person_count}}</td>
                    </tr>

                    <tr>
                        <td class="light-gray" rowspan="7">매출</td>
                        <td class="light-gray">신규</td>
                        @foreach($combinedRevenueData as $key => $data)
                            <td  class="text-right detail-view" data-type="new" data-month="{{$key}}">{{ number_format($data['new']) }}</td>
                        @endforeach
                        <td class="gray text-right" data-type="new" data-month="all">{{ number_format($totalRevenueData['new']) }}</td>
                    </tr>
                    <tr>
                        <td class="light-gray">재등록</td>
                        @foreach($combinedRevenueData as $key => $data)
                            <td  class="text-right detail-view" data-type="renew" data-month="{{$key}}">{{ number_format($data['renew']) }}</td>
                        @endforeach
                        <td class="gray text-right" data-type="renew" data-month="all">{{ number_format($totalRevenueData['renew']) }}</td>
                    </tr>
                    <tr>
                        <td class="light-gray">변경</td>
                        @foreach($combinedRevenueData as $key => $data)
                            <td class="text-right detail-view" data-type="change" data-month="{{$key}}">{{ number_format($data['change']) }}</td>
                        @endforeach
                        <td class="gray text-right" data-type="change" data-month="all">{{ number_format($totalRevenueData['change']) }}</td>
                    </tr>
                    <tr>
                        <td class="light-gray">기타</td>
                        @foreach($combinedRevenueData as $key => $data)
                            <td class="text-right detail-view" data-type="etc" data-month="{{$key}}">{{ number_format($data['etc']) }}</td>
                        @endforeach
                        <td class="gray text-right" data-type="etc" data-month="all">{{ number_format($totalRevenueData['etc']) }}</td>
                    </tr>
                    <tr>
                        <td class="light-gray">시험센터 대여</td>
                        @foreach($combinedCalcData as $month => $data)
                            <td class="text-right">
                                <span class="etc-span">{{ number_format($data['lease']) }}</span>
                                <input type="text" class="form-control text-center etc-input hide number-format" value="{{ number_format($data['lease']) }}" name="lease[]" data-month="{{$month}}">
                            </td>
                        @endforeach
                        <td class="gray text-right">{{ number_format($totalCalcData['lease']) }}</td>
                    </tr>
                    <tr>
                        <td class="light-gray">B2B 쉐어</td>
                        @foreach($combinedCalcData as $month => $data)
                            <td class="text-right">
                                <span class="etc-span">{{ number_format($data['b2b']) }}</span>
                                <input type="text" class="form-control text-center etc-input hide number-format-negative" value="{{ number_format($data['b2b']) }}" name="b2b[]" data-month="{{$month}}">
                            </td>
                        @endforeach
                        <td class="gray text-right">{{ number_format($totalCalcData['b2b']) }}</td>
                    </tr>
                    <tr>
                        <td class="light-gray">환불</td>
                        @foreach($combinedRevenueData as $key => $data)
                            <td class="red text-right detail-view" data-type="refund" data-month="{{$key}}">{{ number_format($data['refund'] * -1) }}</td>
                        @endforeach
                        <td class="gray red text-right detail-view" data-type="refund" data-month="all">{{ number_format($totalRevenueData['refund'] * -1) }}</td>
                    </tr>
                    <tr class="gray">
                        <td colspan="2">총 매출</td>
                        @foreach($combinedRevenueData as $data)
                            <td  class="text-right">{{ number_format($data['total']) }}</td>
                        @endforeach
                        <td  class="text-right">{{ number_format($totalRevenueData['total']) }}</td>
                    </tr>

                    <tr>
                        <td class="light-gray" rowspan="6">정산</td>
                        <td class="light-gray">사업팀 일반</td>
                        @foreach($combinedCalcData as $data)
                            <td class="text-right">{{ number_format($data['business_general']) }}</td>
                        @endforeach
                        <td class="gray text-right">{{ number_format($totalCalcData['business_general']) }}</td>
                    </tr>
                    <tr>
                        <td class="light-gray">사업팀 기타</td>
                        @foreach($combinedCalcData as $month => $data)
                            <td class="text-right">{{ number_format($data['business_etc']) }}</td>
                        @endforeach
                        <td class="gray text-right">{{ number_format($totalCalcData['business_etc']) }}</td>
                    </tr>
                    <tr class="bg-red">
                        <td>사업팀 합계</td>
                        @foreach($combinedCalcData as $data)
                            <td class="text-right">{{ number_format($data['business_general'] + $data['business_etc']) }}</td>
                        @endforeach
                        <td class="total-all-business text-right">{{ number_format($totalCalcData['business_general'] + $totalCalcData['business_etc']) }}</td>
                    </tr>
                    <tr>
                        <td class="light-gray">TNC팀 일반</td>
                        @foreach($combinedCalcData as $data)
                            <td  class="text-right">{{ number_format($data['tnc_general']) }}</td>
                        @endforeach
                        <td class="gray text-right">{{ number_format($totalCalcData['tnc_general']) }}</td>
                    </tr>
                    <tr>
                        <td class="light-gray">TNC팀 기타</td>
                        @foreach($combinedCalcData as $month => $data)
                            <td class="text-right">{{ number_format($data['tnc_etc']) }}</td>
                        @endforeach
                        <td class="gray text-right">{{ number_format($totalCalcData['tnc_etc']) }}</td>
                    </tr>
                    <tr class="bg-blue">
                        <td>TNC팀 합계</td>
                        @foreach($combinedCalcData as $data)
                            <td class="text-right">{{ number_format($data['tnc_general'] + $data['tnc_etc']) }}</td>
                        @endforeach
                        <td class="total-all-tnc text-right">{{ number_format($totalCalcData['tnc_general'] + $totalCalcData['tnc_etc']) }}</td>
                    </tr>
                    </tbody>
                </table>
            </article>
        </div>
    </div>
@endsection

@push("script")
    <script>
        const totalMonth = {!! json_encode($monthArray) !!};


       $(function () {
           // 백엔드에서 내려오는 기준 yyyy-mm
           let limitYearMonth = "{{$limitYear}}-{{$limitMonth}}";
           let parts = limitYearMonth.split('-');
           let limitYear = parseInt(parts[0], 10);
           let limitMonth = parseInt(parts[1], 10);

           function updateMonths() {
               var selectedYear = parseInt($('#yearSelect').val(), 10);

               $('.month-input input[type="checkbox"]').each(function() {
                   var month = parseInt($(this).val(), 10);

                   if (selectedYear < limitYear) {
                       // 기준 연도보다 작으면 전부 활성화
                       $(this).prop('disabled', false);
                   } else if (selectedYear === limitYear) {
                       // 기준 연도와 같으면 기준 월 이하만 활성화
                       if (month <= limitMonth) {
                           $(this).prop('disabled', false);
                       } else {
                           $(this).prop('disabled', true).prop('checked', false);
                       }
                   } else {
                       // 기준 연도보다 크면 전부 disabled
                       $(this).prop('disabled', true).prop('checked', false);
                   }
               });
           }

           // 연도 select 바뀔 때 적용
           $('#yearSelect').on('change', updateMonths);

           // 페이지 로드 시 한 번 초기화
           updateMonths();

           $('.number-format').on("keyup", function() {
               const number = Number($(this).val().replace(/[^0-9]/g, ''));
               $(this).val(number.toLocaleString());
           });

           $('.number-format-negative').on("keyup", function () {
               let val = $(this).val().trim();
               // 맨 앞의 "-"만 허용, 나머지는 숫자만
               val = val.replace(/(?!^-)[^0-9]/g, '');
               // "-"만 입력된 경우는 그대로 두기
               let number = (val === "-") ? "-" : parseInt(val, 10);
               // NaN 방지 + 포맷 적용
               let formatted = (isNaN(number) || number === "-") ? val : number.toLocaleString();

               $(this).val(formatted);
           });

           $(document).on("click", ".btn-save", function () {
               $('.etc-input').attr('readonly', false);


               let leaseMap = {};
               $("input[name='lease[]']").each(function () {
                   let month = $(this).data("month"); // data-month 값
                   leaseMap[month] = $(this).val();
               });

               let b2bMap = {};
               $("input[name='b2b[]']").each(function () {
                   let month = $(this).data("month"); // data-month 값
                   b2bMap[month] = $(this).val();
               });


               let businessMap = {};
               $("input[name='business_etc[]']").each(function () {
                   let month = $(this).data("month"); // data-month 값
                   businessMap[month] = $(this).val();
               });

               let tncMap = {};
               $("input[name='tnc_etc[]']").each(function () {
                   let month = $(this).data("month"); // data-month 값
                   tncMap[month] = $(this).val();
               });


               let payload = {
                   business: businessMap,
                   tnc: tncMap,
                   lease : leaseMap,
                   b2b : b2bMap
               };

               alertify.confirm("확인", "저장하시겠습니까?", async () => {

                   const result = await customFetch("{{ route('api.static.change.academy.stats') }}", {
                       method: "POST",
                       body : JSON.stringify(payload) ,
                       headers: { "Content-Type" : "application/json"}
                   });

                   if (result.status) {
                       alertify.alert("완료", "수정되었습니다.", () => {
                               location.reload();
                       });
                   } else {
                       alertify.alert("error", result.message);
                   }

               }, () => {});
               //저장처리
           });

           $(document).on("click", ".btn-edit", function () {
               $('.etc-input').removeClass("hide");
               $('.etc-span').addClass("hide");
               $(this).addClass("hide");                 // 수정 버튼 숨기기
               $(".btn-cancel, .btn-save").removeClass("hide"); // 취소, 저장 보이기
           });

           $(document).on("click", ".btn-cancel", function () {
               $('.etc-input').addClass("hide");
               $('.etc-span').removeClass("hide");
               $(this).addClass("hide");                 // 취소 숨기기
               $(".btn-save").addClass("hide");          // 저장 숨기기
               $(".btn-edit").removeClass("hide");       // 수정 다시 보이기

               $('.etc-input').each(function (){
                   $(this).val($(this).parent('td').find('.etc-span').text());
               });
           });
       });


        $(document).on('click', 'td.detail-view', function () {
            const data = $(this).data();
            let url = '{{ route('payment.popup-calculation-list', ['service' => 'academy']) }}';

            if (data.month === 'all') {
                data.month = totalMonth; // 배열 그대로
            }

            const queryString = $.param(data, true); // ⭐ 중요
            url += '?' + queryString;

            window.open(url, "_blank", "width=700; height=500");
        });

       function statsExcelDownloads(button) {
           const form = document.getElementById('stats-form');
           const url = button.dataset.url; // 블레이드에서 지정한 URL

           // Form 데이터를 URL 파라미터로 변환
           const formData = new FormData(form);
           const queryString = new URLSearchParams(formData).toString();

           // 새 창에서 엑셀 다운로드
           window.open(url + '?' + queryString, '_blank');
       }
    </script>
@endpush