@extends("common.layout")

@section("header")
    {!! resource('css/dashboard.css') !!}
    {!! resource('js/dashboard/dashboard-common.js') !!}
    <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.0/xlsx.full.min.js"></script>
@endsection

@section("content")

    <div id="dashboard" class="academy-stat-detail">
        <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" onclick="location.href='{{route('statics.academy.stats')}}'">[학원] 팀별 수강&매출요약</button>
                    <button type="button" class="tab move-only active">[학원] 팀별 수강&매출상세</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>
                    <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.stat-detail')}}">엑셀 다운로드
                    </button>
                </div>
            </form>

            <article class="static-table-wrap">
                <div class="table-header active">
                    <p>수강생 현황
                        <svg xmlns="http://www.w3.org/2000/svg" width="16" height="10" viewBox="0 0 16 10" fill="none" >
                            <path d="M8 9.25L0.5 1.75L2.25 0L8 5.75L13.75 0L15.5 1.75L8 9.25Z" fill="#1D1B20"/>
                        </svg>
                    </p>
                </div>

                <div class="table-container active">
                    <div class="hybrid-container">
                        <!-- 왼쪽 고정 열 -->
                        <div class="left-table-wrap">
                            <table class="left-table">
                                <thead>
                                <tr>
                                    <th rowspan="3">수강 구분</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($students['data'] as $category => $group)
                                    <tr class="group-total">
                                        <td>{{$category}}</td>
                                    </tr>
                                    @foreach($group['products'] as $product => $row)
                                        <tr><td>ㄴ{{$product}}</td></tr>
                                    @endforeach
                                @endforeach
                                <tr class="submit"><td>합계</td></tr>
                                <!-- 필요한 만큼 행 추가 -->
                                </tbody>
                            </table>
                        </div>
                        <!-- 오른쪽 스크롤 테이블 -->
                        <div class="right-table-wrap">
                            <table class="right-table">
                                <thead>
                                <tr class="header-dark-gray">
                                    @foreach($students['months'] as $month)
                                        <th colspan="9" class="border-right">{{Carbon::parse($month . '-01')->format('n')}}월</th>
                                    @endforeach
                                    <!-- 필요한 만큼 열 추가 -->
                                </tr>
                                <tr class="header-gray">
                                    @foreach($students['months'] as $month)
                                    <th colspan="2">신규</th>
                                    <th colspan="2">재등록</th>
                                    <th colspan="2">변경</th>
                                    <th colspan="2">환불</th>
                                    <th class="border-right">집계</th>
                                    @endforeach
                                </tr>
                                <tr>
                                    @foreach($students['months'] as $month)

                                            <th class="new">인원수</th>
                                            <th class="new">비중</th>
                                            <th class="renew">인원수</th>
                                            <th class="renew">비중</th>
                                            <th class="change">변경인원수</th>
                                            <th class="change">비중</th>
                                            <th class="refund">환불인원수</th>
                                            <th class="refund">비중</th>
                                            <th class="total border-right">(유지포함)실수강인원수</th>
                                    @endforeach
                                    <!-- 필요한 만큼 열 추가 -->
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($students['data'] as $student)
                                    <tr class="group-total">
                                        @foreach($student['total'] as $key => $row)
                                            <td class="text-right">{{ number_format($row['new_count']) }}</td>
                                            <td class="text-right">
                                                {{ ($students['submit'][$key]['new_count'] ?? 0) > 0
                                                    ? number_format(($row['new_count'] / $students['submit'][$key]['new_count']) * 100, 2)
                                                    : 0 }}%
                                            </td>

                                            <td class="text-right">{{ number_format($row['renew_count']) }}</td>
                                            <td class="text-right">
                                                {{ ($students['submit'][$key]['renew_count'] ?? 0) > 0
                                                    ? number_format(($row['renew_count'] / $students['submit'][$key]['renew_count']) * 100, 2)
                                                    : 0 }}%
                                            </td>

                                            <td class="text-right">{{ number_format($row['change_count']) }}</td>
                                            <td class="text-right">
                                                {{ ($students['submit'][$key]['change_count'] ?? 0) > 0
                                                    ? number_format(($row['change_count'] / $students['submit'][$key]['change_count']) * 100, 2)
                                                    : 0 }}%
                                            </td>

                                            <td class="text-right">{{ number_format($row['refund_count']) }}</td>
                                            <td class="text-right">
                                                {{ ($students['submit'][$key]['refund_count'] ?? 0) > 0
                                                    ? number_format(($row['refund_count'] / $students['submit'][$key]['refund_count']) * 100, 2)
                                                    : 0 }}%
                                            </td>

                                            <td class="border-right text-right">{{ number_format($row['total_count']) }}</td>
                                        @endforeach
                                    </tr>
                                    @foreach($student['products'] as $product)
                                        <tr>
                                            @foreach($product as $key => $row)
                                                <td class="text-right">{{ number_format($row['new_count']) }}</td>
                                                <td class="text-right">
                                                    {{ ($students['submit'][$key]['new_count'] ?? 0) > 0
                                                        ? number_format(($row['new_count'] / $students['submit'][$key]['new_count']) * 100, 2)
                                                        : 0 }}%
                                                </td>

                                                <td class="text-right">{{ number_format($row['renew_count']) }}</td>
                                                <td class="text-right">
                                                    {{ ($students['submit'][$key]['renew_count'] ?? 0) > 0
                                                        ? number_format(($row['renew_count'] / $students['submit'][$key]['renew_count']) * 100, 2)
                                                        : 0 }}%
                                                </td>

                                                <td class="text-right">{{ number_format($row['change_count']) }}</td>
                                                <td class="text-right">
                                                    {{ ($students['submit'][$key]['change_count'] ?? 0) > 0
                                                        ? number_format(($row['change_count'] / $students['submit'][$key]['change_count']) * 100, 2)
                                                        : 0 }}%
                                                </td>

                                                <td class="text-right">{{ number_format($row['refund_count']) }}</td>
                                                <td class="text-right">
                                                    {{ ($students['submit'][$key]['refund_count'] ?? 0) > 0
                                                        ? number_format(($row['refund_count'] / $students['submit'][$key]['refund_count']) * 100, 2)
                                                        : 0 }}%
                                                </td>

                                                <td class="border-right text-right">{{ number_format($row['total_count']) }}</td>
                                            @endforeach
                                        </tr>
                                    @endforeach
                                @endforeach
                                <tr class="submit">
                                    @foreach($students['submit'] as $key =>$submit)
                                        <td class="text-right">{{number_format($submit['new_count'])}}</td>
                                        <td class="text-right">{{number_format(($submit['new_count'] > 0 ? 100: 0))}}%</td>
                                        <td class="text-right">{{number_format($submit['renew_count'])}}</td>
                                        <td class="text-right">{{number_format(($submit['renew_count'] > 0 ? 100: 0))}}%</td>
                                        <td class="text-right">{{number_format($submit['change_count'])}}</td>
                                        <td class="text-right">{{number_format(($submit['change_count'] > 0 ? 100: 0))}}%</td>
                                        <td class="text-right">{{number_format($submit['refund_count'])}}</td>
                                        <td class="text-right">{{number_format(($submit['refund_count'] > 0 ? 100: 0))}}%</td>
                                        <td class="border-right text-right">{{number_format($submit['total_count'])}}</td>
                                    @endforeach
                                </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </article>

            <article class="static-table-wrap">
                <div class="table-header active">
                    <p>사업팀
                        <svg xmlns="http://www.w3.org/2000/svg" width="16" height="10" viewBox="0 0 16 10" fill="none" >
                            <path d="M8 9.25L0.5 1.75L2.25 0L8 5.75L13.75 0L15.5 1.75L8 9.25Z" fill="#1D1B20"/>
                        </svg>
                    </p>
                </div>
                <div class="table-container active">
                    <div class="hybrid-container">
                        <!-- 왼쪽 고정 열 -->
                        <div class="left-table-wrap">
                            <table class="left-table">
                                <thead>
                                <tr>
                                    <th rowspan="3">수강 구분</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($business['data'] as $category => $group)
                                    <tr class="group-total">
                                        <td>{{$category}}</td>
                                    </tr>
                                    @foreach($group['products'] as $product => $row)
                                        <tr><td>ㄴ{{$product}}</td></tr>
                                    @endforeach
                                @endforeach
                                <tr class="submit"><td>합계</td></tr>
                                <!-- 필요한 만큼 행 추가 -->
                                </tbody>
                            </table>
                        </div>
                        <div class="right-table-wrap">
                            <table class="right-table">
                                <thead>
                                <tr class="header-dark-gray">
                                    @foreach($business['months'] as $month)
                                        <th colspan="9" class="border-right">{{Carbon::parse($month . '-01')->format('n')}}월</th>
                                    @endforeach
                                    <!-- 필요한 만큼 열 추가 -->
                                </tr>
                                <tr class="header-gray">
                                    @foreach($business['months'] as $month)
                                        <th colspan="4">수강생수</th>
                                        <th class="border-right" colspan="5">매출액</th>
                                    @endforeach
                                </tr>
                                <tr>
                                    @foreach($business['months'] as $month)
                                        <th class="new">신규인원수</th>
                                        <th class="change">변경인원수</th>
                                        <th class="refund">환불인원수</th>
                                        <th class="total">합계</th>
                                        <th class="new">신규매출액</th>
                                        <th class="change">변경매출액</th>
                                        <th class="refund">환불매출액</th>
                                        <th class="total">총매출액</th>
                                        <th class="total border-right">ARPPU</th>
                                    @endforeach
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($business['data'] as $products)
                                    <tr class="group-total">
                                        @foreach($products['total'] as $row)
                                            <td class="text-right">{{number_format($row['new_count'])}}</td>
                                            <td class="text-right">{{number_format($row['change_count'])}}</td>
                                            <td class="text-right">{{number_format($row['refund_count'])}}</td>
                                            <td class="text-right">{{number_format($row['total_count'])}}</td>
                                            <td class="text-right">{{number_format($row['new_amount'])}}</td>
                                            <td class="text-right">{{number_format($row['change_amount'])}}</td>
                                            <td class="text-right">{{number_format($row['refund_amount'])}}</td>
                                            <td class="text-right">{{number_format($row['total_amount'])}}</td>
                                            <td class="border-right text-right">{{number_format($row['arppu'])}}</td>
                                        @endforeach
                                    </tr>
                                    @foreach($products['products'] as $product)
                                        <tr>
                                            @foreach($product as $row)
                                                <td class="text-right">{{number_format($row['new_count'])}}</td>
                                                <td class="text-right">{{number_format($row['change_count'])}}</td>
                                                <td class="text-right">{{number_format($row['refund_count'])}}</td>
                                                <td class="text-right">{{number_format($row['total_count'])}}</td>
                                                <td class="text-right">{{number_format($row['new_amount'])}}</td>
                                                <td class="text-right">{{number_format($row['change_amount'])}}</td>
                                                <td class="text-right">{{number_format($row['refund_amount'])}}</td>
                                                <td class="text-right">{{number_format($row['total_amount'])}}</td>
                                                <td class="border-right text-right">{{number_format($row['arppu'])}}</td>
                                            @endforeach
                                        </tr>
                                    @endforeach
                                @endforeach
                                <tr class="submit">
                                    @foreach($business['submit'] as $key =>$submit)
                                        <td class="text-right">{{number_format($submit['new_count'])}}</td>
                                        <td class="text-right">{{number_format($submit['change_count'])}}</td>
                                        <td class="text-right">{{number_format($submit['refund_count'])}}</td>
                                        <td class="text-right">{{number_format($submit['total_count'])}}</td>
                                        <td class="text-right">{{number_format($submit['new_amount'])}}</td>
                                        <td class="text-right">{{number_format($submit['change_amount'])}}</td>
                                        <td class="text-right">{{number_format($submit['refund_amount'])}}</td>
                                        <td class="text-right">{{number_format($submit['total_amount'])}}</td>
                                        <td class="border-right text-right">{{number_format($submit['arppu'])}}</td>
                                    @endforeach
                                </tr>
                                </tbody>
                            </table>
                        </div>
                        <!-- 오른쪽 스크롤 테이블 -->

                    </div>
                </div>
            </article>
{{--            @dd($tnc)--}}
            <article class="static-table-wrap">
                <div class="table-header active">
                    <p>TNC팀
                        <svg xmlns="http://www.w3.org/2000/svg" width="16" height="10" viewBox="0 0 16 10" fill="none" >
                            <path d="M8 9.25L0.5 1.75L2.25 0L8 5.75L13.75 0L15.5 1.75L8 9.25Z" fill="#1D1B20"/>
                        </svg>
                    </p>
                </div>
                <div class="table-container active">
                    <div class="hybrid-container">
                        <!-- 왼쪽 고정 열 -->
                        <div class="left-table-wrap">
                            <table class="left-table">
                                <thead>
                                <tr>
                                    <th rowspan="3">수강 구분</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($tnc['data'] as $category => $group)
                                    <tr class="group-total">
                                        <td>{{$category}}</td>
                                    </tr>
                                    @foreach($group['products'] as $product => $row)
                                        <tr><td>ㄴ{{$product}}</td></tr>
                                    @endforeach
                                @endforeach
                                <tr class="submit"><td>합계</td></tr>
                                <!-- 필요한 만큼 행 추가 -->
                                </tbody>
                            </table>
                        </div>
                        <div class="right-table-wrap">
                            <table class="right-table">
                                <thead>
                                <tr class="header-dark-gray">
                                    @foreach($tnc['months'] as $month)
                                        <th colspan="9" class="border-right">{{Carbon::parse($month . '-01')->format('n')}}월</th>
                                    @endforeach
                                    <!-- 필요한 만큼 열 추가 -->
                                </tr>
                                <tr class="header-gray">
                                    @foreach($tnc['months'] as $month)
                                        <th colspan="4">수강생수</th>
                                        <th class="border-right" colspan="5">매출액</th>
                                    @endforeach
                                </tr>
                                <tr>
                                    @foreach($tnc['months'] as $month)
                                        <th class="new">재등록인원수</th>
                                        <th class="change">변경인원수</th>
                                        <th class="refund">환불인원수</th>
                                        <th class="total">합계</th>
                                        <th class="new">재등록매출액</th>
                                        <th class="change">변경매출액</th>
                                        <th class="refund">환불매출액</th>
                                        <th class="total">총매출액</th>
                                        <th class="total border-right">ARPPU</th>
                                    @endforeach
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($tnc['data'] as $products)
                                    <tr class="group-total">
                                        @foreach($products['total'] as $row)
                                            <td class="text-right">{{number_format($row['renew_count'])}}</td>
                                            <td class="text-right">{{number_format($row['change_count'])}}</td>
                                            <td class="text-right">{{number_format($row['refund_count'])}}</td>
                                            <td class="text-right">{{number_format($row['total_count'])}}</td>
                                            <td class="text-right">{{number_format($row['renew_amount'])}}</td>
                                            <td class="text-right">{{number_format($row['change_amount'])}}</td>
                                            <td class="text-right">{{number_format($row['refund_amount'])}}</td>
                                            <td class="text-right">{{number_format($row['total_amount'])}}</td>
                                            <td class="border-right text-right">{{number_format($row['arppu'])}}</td>
                                        @endforeach
                                    </tr>
                                    @foreach($products['products'] as $product)
                                        <tr>
                                            @foreach($product as $row)
                                                <td  class="text-right">{{number_format($row['renew_count'])}}</td>
                                                <td  class="text-right">{{number_format($row['change_count'])}}</td>
                                                <td  class="text-right">{{number_format($row['refund_count'])}}</td>
                                                <td  class="text-right">{{number_format($row['total_count'])}}</td>
                                                <td  class="text-right">{{number_format($row['renew_amount'])}}</td>
                                                <td  class="text-right">{{number_format($row['change_amount'])}}</td>
                                                <td  class="text-right">{{number_format($row['refund_amount'])}}</td>
                                                <td  class="text-right">{{number_format($row['total_amount'])}}</td>
                                                <td class="border-right text-right">{{number_format($row['arppu'])}}</td>
                                            @endforeach
                                        </tr>
                                    @endforeach
                                @endforeach
                                <tr class="submit">
                                    @foreach($tnc['submit'] as $key => $submit)
                                        <td class="text-right">{{number_format($submit['renew_count'])}}</td>
                                        <td class="text-right">{{number_format($submit['change_count'])}}</td>
                                        <td class="text-right">{{number_format($submit['refund_count'])}}</td>
                                        <td class="text-right">{{number_format($submit['total_count'])}}</td>
                                        <td class="text-right">{{number_format($submit['renew_amount'])}}</td>
                                        <td class="text-right">{{number_format($submit['change_amount'])}}</td>
                                        <td class="text-right">{{number_format($submit['refund_amount'])}}</td>
                                        <td class="text-right">{{number_format($submit['total_amount'])}}</td>
                                        <td class="border-right text-right">{{number_format($submit['arppu'])}}</td>
                                    @endforeach
                                </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </article>
        </div>
    </div>
@endsection

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

           $(".table-header").on('click', function () {
               $(this).toggleClass('active');
               $(this).next().toggleClass('active');
           })
       });
       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