@extends('user::layouts/panel')

@section('module-content')
    <div class="container-fluid py-4">
      <div class="card shadow-sm border-0 mb-4 rounded-3">
          <div class="card-body p-3">
              <!-- 週數查詢 -->
              <h5 class="card-title text-primary fw-bold mb-3">
                  <i class="fas fa-calendar-week me-2"></i>依週數查詢
              </h5>
              <div class="row g-3 align-items-end justify-content-center mb-4">
                  <div class="col-md-4">
                      <label class="form-label small text-muted">開始週</label>
                      <select id="startWeekSelect" class="form-select">
                          @foreach($availableWeeks as $week)
                              <option value="{{ $week['year'] }}-{{ $week['week'] }}"
                                  {{ (intval($startDate->isoWeekYear()) == intval($week['year']) && intval($startDate->isoWeek()) == intval($week['week'])) ? 'selected' : '' }}>
                                  {{ $week['year'] }}年第{{ $week['week'] }}週
                              </option>
                          @endforeach
                      </select>
                  </div>
                  <div class="col-md-4">
                      <label class="form-label small text-muted">結束週</label>
                      <select id="endWeekSelect" class="form-select">
                          @foreach($availableWeeks as $week)
                              <option value="{{ $week['year'] }}-{{ $week['week'] }}"
                                  {{ (intval($endDate->isoWeekYear()) == intval($week['year']) && intval($endDate->isoWeek()) == intval($week['week'])) ? 'selected' : '' }}>
                                  {{ $week['year'] }}年第{{ $week['week'] }}週
                              </option>
                          @endforeach
                      </select>
                  </div>
                  <div class="col-md-2">
                      <button type="button" id="weekSearchBtn" class="btn btn-primary w-100 d-flex align-items-center justify-content-center">
                          <i class="fas fa-search me-2"></i>查詢
                      </button>
                  </div>
              </div>

              <!-- 日期區間查詢 -->
              <h5 class="card-title text-primary fw-bold mb-3">
                  <i class="fas fa-calendar-alt me-2"></i>依日期區間查詢
              </h5>
              <form id="dateSearchForm">
                  <div class="row g-3 align-items-end justify-content-center">
                      <div class="col-md-4">
                          <label for="start_date" class="form-label small text-muted">開始日期</label>
                          <div class="input-group">
                              <span class="input-group-text bg-light border-end-0">
                                  <i class="far fa-calendar-alt"></i>
                              </span>
                              <input type="date" id="start_date" name="start_date" class="form-control border-start-0 ps-0" value="{{ $startDate->format('Y-m-d') }}">
                          </div>
                      </div>
                      <div class="col-md-4">
                          <label for="end_date" class="form-label small text-muted">結束日期</label>
                          <div class="input-group">
                              <span class="input-group-text bg-light border-end-0">
                                  <i class="far fa-calendar-alt"></i>
                              </span>
                              <input type="date" id="end_date" name="end_date" class="form-control border-start-0 ps-0" value="{{ $endDate->format('Y-m-d') }}">
                          </div>
                      </div>
                      <div class="col-md-2">
                          <button type="button" id="date-search-btn" class="btn btn-primary w-100 d-flex align-items-center justify-content-center">
                              <i class="fas fa-search me-2"></i>查詢
                          </button>
                      </div>
                  </div>
              </form>
          </div>
      </div>

      <!-- 篩選區域 -->
      <div class="card shadow-sm border-0 rounded-3">
          <div class="d-flex align-items-center justify-content-between">
            <div class="card-header bg-white py-3 border-0">
                <h5 class="card-title text-primary fw-bold mb-0">
                    <i class="fas fa-filter me-2"></i>進階篩選
                </h5>
            </div>
            <!-- 人天/小時切換按鈕 -->
            <div class="d-flex align-items-center gap-2 me-3">
              <div class="btn-group" role="group" aria-label="工時顯示單位">
                  <input type="radio" class="btn-check" name="timeUnitToggle" id="showHours" value="hours" checked>
                  <label class="btn btn-outline-info" for="showHours">
                      <i class="fas fa-clock me-1"></i>小時
                  </label>
                  <input type="radio" class="btn-check" name="timeUnitToggle" id="showManDays" value="manDays">
                  <label class="btn btn-outline-info" for="showManDays">
                      <i class="fas fa-user-clock me-1"></i>人天
                  </label>
              </div>
            </div>
          </div>
          <div class="card-body p-3">
              <div class="row g-4">
                  <!-- 人員篩選 -->
                  <div class="col-md-5">
                      <label for="userFilter" class="form-label d-flex align-items-center">
                          <i class="fas fa-users me-2 text-secondary"></i>
                          <span>人員篩選</span>
                      </label>
                      <select class="form-select select2" id="userFilter" multiple data-placeholder="選擇人員">
                          @foreach($allUsers as $user)
                              <option value="{{ $user->id }}">{{ $user->name }}</option>
                          @endforeach
                      </select>
                      <div class="form-text">可多選或清除重設</div>
                  </div>

                  <!-- 專案類型篩選 -->
                  <div class="col-md-7">
                      <label class="form-label d-flex align-items-center">
                          <i class="fas fa-briefcase me-2 text-secondary"></i>
                          <span>專案類型篩選</span>
                      </label>
                      <div class="btn-group w-100" role="group">
                          <input type="radio" class="btn-check" name="projectTypeFilter" id="all" value="all" checked>
                          <label class="btn btn-outline-primary" for="all">
                              <i class="fas fa-th me-1"></i>全部
                          </label>

                          <input type="radio" class="btn-check" name="projectTypeFilter" id="development" value="開發/執行">
                          <label class="btn btn-outline-primary" for="development">
                              <i class="fas fa-code me-1"></i>開發/執行
                          </label>

                          <input type="radio" class="btn-check" name="projectTypeFilter" id="maintenance" value="維護">
                          <label class="btn btn-outline-primary" for="maintenance">
                              <i class="fas fa-wrench me-1"></i>維護
                          </label>

                          <input type="radio" class="btn-check" name="projectTypeFilter" id="warranty" value="保固">
                          <label class="btn btn-outline-primary" for="warranty">
                              <i class="fas fa-shield-alt me-1"></i>保固
                          </label>

                          <input type="radio" class="btn-check" name="projectTypeFilter" id="others" value="其他">
                          <label class="btn btn-outline-primary" for="others">
                              <i class="fas fa-ellipsis-h me-1"></i>其他
                          </label>
                      </div>

                      {{-- 添加顯示控制開關 --}}
                      <div class="form-check mt-2">
                        <input class="form-check-input" type="checkbox" id="hideEmptyProjects" checked>
                        <label class="form-check-label" for="hideEmptyProjects">
                            <i class="fas fa-eye-slash me-1"></i>隱藏未執行案子
                        </label>
                      </div>
                  </div>
              </div>
          </div>
      </div>
    </div>

    <div class="card mb-5 border-0 shadow">
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-striped table-hover">
                    <thead class="table-light">
                        <tr>
                            <th class="client text-center">客戶</th>
                            <th class="project-name text-center">專案名稱</th>
                            <th class="due-date text-center">預計結案日</th>
                            <th class="estimated-man-days text-center">評估人天</th>
                            @foreach($allUsers as $user)
                                <th colspan="{{ $user->need_task_record ? 2 : 1 }}" data-user-id="{{ $user->id }}" class="text-center user-name">
                                    {{ $user->name }}
                                    <br>
                                    工時紀錄
                                </th>
                            @endforeach
                            <th class="estimated-man-days-proportion text-center">累積總人天</th>
                            <th class="estimated-man-days-proportion text-center">累計執行人天佔比</th>
                            <th class="actual-completion-percentage text-center">實際完成比</th>
                            <th class="progress-difference text-center">進度差異比</th>
                        </tr>
                    </thead>
                    <tbody>
                          @foreach($projectsByType as $type => $projects)
                          <tr class="table-secondary project-type-row" data-type="{{ $type }}">
                              <th colspan="{{ 8 + count($allUsers) + $allUsers->sum(function($user) { return $user->need_task_record ? 1 : 0; }) }}" class="text-center">
                                  <h5>{{ $type }}</h5>
                              </th>
                          </tr>
                          @if(count($projects) > 0)
                              @foreach($projects as $data)
                                  <tr>
                                      <td class="text-center align-middle">{{ $data['client'] }}</td>
                                      <td class="text-center align-middle">
                                          <small class="text-muted">{{ $data['serial_number'] ?? '-' }}</small><br>
                                          {{ $data['project_name'] }}
                                      </td>
                                      <td class="text-center align-middle">{{ $data['due_date'] }}</td>
                                      <td class="text-center align-middle">{{ number_format($data['estimated_man_days'], 2) }}</td>
                                      @foreach($allUsers as $user)
                                          <td class="time-record text-center align-middle" data-user-id="{{ $user->id }}">
                                              @if(isset($data['time_records'][$user->id]))
                                                  @php
                                                      $billableHours = $data['time_records'][$user->id]->sum();
                                                      $billableManDays = $data['time_records_man_days'][$user->id]->sum();
                                                  @endphp
                                                  <span class="hours-display">{{ $billableHours }}小時</span>
                                                  <span class="man-days-display d-none">
                                                      {{ number_format($billableManDays, 2) }}人天
                                                  </span>
                                              @else
                                                  <span class="hours-display">-</span>
                                                  <span class="man-days-display d-none">-</span>
                                              @endif
                                          </td>
                                          @if($user->need_task_record)
                                          <td class="test-time-record text-center align-middle" data-user-id="{{ $user->id }}" data-test-time="true">
                                              @if(isset($data['test_time_records'][$user->id]))
                                                  @php
                                                      $testHours = $data['test_time_records'][$user->id]->sum();
                                                      $testManDays = $data['test_time_records_man_days'][$user->id]->sum();
                                                  @endphp
                                                  <span class="hours-display">{{ $testHours }}小時</span>
                                                  <span class="man-days-display d-none">
                                                      {{ number_format($testManDays, 2) }}人天
                                                  </span>
                                              @else
                                                  <span class="hours-display">-</span>
                                                  <span class="man-days-display d-none">-</span>
                                              @endif
                                          </td>
                                          @endif
                                      @endforeach
                                      <td class="text-center align-middle">{{ number_format($data['total_man_days'], 2) }}</td>
                                      <td class="text-center align-middle">{{ number_format($data['man_day_percentage'], 2) }}%</td>
                                      <td class="text-center align-middle">{{ number_format($data['actual_completion_percentage'], 2) }}%</td>
                                      <td class="text-center align-middle">
                                          <span class="text-{{ $data['progress_difference'] >= 0 ? 'success' : 'danger' }}">
                                              {{ $data['progress_difference'] >= 0 ? '+' : '' }}{{ number_format($data['progress_difference'], 2) }}%
                                          </span>
                                      </td>
                                  </tr>
                              @endforeach

                              {{-- 添加分類小計 --}}
                              <tr class="table-info">
                                  <td colspan="4" class="text-center"><strong>{{ $type }} 小計</strong></td>
                                  {{-- <td class="text-center">{{ number_format(collect($projects)->sum('estimated_man_days'), 2) }}人天</td> --}}
                                  @foreach($allUsers as $user)
                                      <td class="text-center align-middle" data-user-id="{{ $user->id }}">
                                          @php
                                              $userHoursTotal = collect($projects)->sum(function($data) use ($user) {
                                                  return isset($data['time_records'][$user->id])
                                                      ? $data['time_records'][$user->id]->sum()
                                                      : 0;
                                              });

                                              $userManDaysTotal = collect($projects)->sum(function($data) use ($user) {
                                                  return isset($data['time_records_man_days'][$user->id])
                                                      ? $data['time_records_man_days'][$user->id]->sum()
                                                      : 0;
                                              });
                                          @endphp
                                          <span class="hours-display">{{ $userHoursTotal > 0 ? $userHoursTotal . '小時' : '-' }}</span>
                                          <span class="man-days-display d-none">
                                              {{ $userManDaysTotal > 0 ? number_format($userManDaysTotal, 2) . '人天' : '-' }}
                                          </span>
                                      </td>
                                      @if($user->need_task_record)
                                      <td class="text-center align-middle" data-user-id="{{ $user->id }}" data-test-time="true">
                                          @php
                                              $userTestHoursTotal = collect($projects)->sum(function($data) use ($user) {
                                                  return isset($data['test_time_records'][$user->id])
                                                      ? $data['test_time_records'][$user->id]->sum()
                                                      : 0;
                                              });

                                              $userTestManDaysTotal = collect($projects)->sum(function($data) use ($user) {
                                                  return isset($data['test_time_records_man_days'][$user->id])
                                                      ? $data['test_time_records_man_days'][$user->id]->sum()
                                                      : 0;
                                              });
                                          @endphp
                                          <span class="hours-display">{{ $userTestHoursTotal > 0 ? $userTestHoursTotal . '小時' : '-' }}</span>
                                          <span class="man-days-display d-none">
                                              {{ $userTestManDaysTotal > 0 ? number_format($userTestManDaysTotal, 2) . '人天' : '-' }}
                                          </span>
                                      </td>
                                      @endif
                                  @endforeach
                                  {{-- <td class="text-center">{{ number_format(collect($projects)->sum('total_man_days'), 2) }}人天</td>
                                  <td class="text-center">{{ number_format(collect($projects)->sum('man_day_percentage'), 2) }}%</td>
                                  <td class="text-center">{{ number_format(collect($projects)->sum('actual_completion_percentage'), 2) }}%</td> --}}
                                  {{-- <td class="text-center">
                                      <span class="text-{{ collect($projects)->sum('progress_difference') >= 0 ? 'success' : 'danger' }}">
                                          {{ collect($projects)->sum('progress_difference') >= 0 ? '+' : '' }}{{ number_format(collect($projects)->sum('progress_difference'), 2) }}%
                                      </span>
                                  </td> --}}
                                  <td colspan="4"></td>
                              </tr>
                          @else
                              <tr>
                                  <td colspan="{{ 8 + count($allUsers) + $allUsers->sum(function($user) { return $user->need_task_record ? 1 : 0; }) }}" class="text-center text-muted">
                                      此類別尚無專案資料
                                  </td>
                              </tr>
                          @endif
                      @endforeach

                      {{-- 底部總計 --}}
                      <tr class="table-dark">
                          <td colspan="3" class="text-center align-middle"><strong>實際執行人天</strong></td>
                          <td class="text-center align-middle">{{ number_format(collect($userStats)->sum('total_man_days'), 2) }}</td>
                          @foreach($allUsers as $user)
                              <td class="text-center align-middle" data-user-id="{{ $user->id }}">
                                  {{ number_format($userStats[$user->id]['total_man_days'], 2) }}
                              </td>
                              @if($user->need_task_record)
                              <td class="text-center align-middle" data-user-id="{{ $user->id }}" data-test-time="true">
                                  {{ number_format($userStats[$user->id]['test_man_days'] ?? 0, 2) }}
                              </td>
                              @endif
                          @endforeach
                          <td></td>
                          <td></td>
                          <td></td>
                          <td></td>
                      </tr>
                      <tr class="table-dark">
                          <td colspan="3" class="text-center align-middle"><strong>應執行人天</strong></td>
                          <td class="text-center align-middle">{{ number_format(collect($userStats)->sum('standard_man_days'), 1) }}</td>
                          @foreach($allUsers as $user)
                              <td class="text-center align-middle" data-user-id="{{ $user->id }}">
                                  {{ number_format($userStats[$user->id]['standard_man_days'], 1) }}
                              </td>
                              @if($user->need_task_record)
                              <td class="text-center align-middle" data-user-id="{{ $user->id }}" data-test-time="true">
                                  -
                              </td>
                              @endif
                          @endforeach
                          <td></td>
                          <td></td>
                          <td></td>
                          <td></td>
                      </tr>
                      <tr class="table-dark">
                          <td colspan="3" class="text-center align-middle"><strong>加班時數</strong></td>
                          <td class="text-center align-middle">{{ number_format(collect($userStats)->sum('overtime_hours'), 2) }}</td>
                          @foreach($allUsers as $user)
                              <td class="text-center align-middle" data-user-id="{{ $user->id }}">
                                  {{ number_format($userStats[$user->id]['overtime_hours'], 2) }}
                              </td>
                              @if($user->need_task_record)
                              <td class="text-center align-middle" data-user-id="{{ $user->id }}" data-test-time="true">
                                  -
                              </td>
                              @endif
                          @endforeach
                          <td></td>
                          <td></td>
                          <td></td>
                          <td></td>
                      </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
@endsection

@push('meta')
<meta name="period-statistics-show-url" content="{{ route('panel.task.period-statistics.show', ['start_year' => ':start_year', 'start_week' => ':start_week', 'end_year' => ':end_year', 'end_week' => ':end_week']) }}">
@endpush

@push('links')
    <link rel="stylesheet" href="{{ Module::asset('task:css/sheet.css') }}">
    <link rel="stylesheet" href="{{ Module::asset('task:css/table.css') }}">
@endpush

@push('scripts')
@vite('resources/js/moment.js')
<script src="{{ Module::asset('task:js/toggleTimeDisplayUnit.js') }}" type="module"></script>
<script src="{{ Module::asset('task:js/applyFilters.js') }}" type="module"></script>
<script src="{{ Module::asset('task:js/period-statistics/show.js') }}"></script>
@endpush