#!/usr/bin/env python3
"""探索月份工作表結構"""

from google.oauth2 import service_account
from googleapiclient.discovery import build

SPREADSHEET_ID = '1Y708RZgZHL3Gqah9ujiw5brMuxAoW3RFl0txfXq8qrE'

creds = service_account.Credentials.from_service_account_file(
    'service_account_key.json',
    scopes=['https://www.googleapis.com/auth/spreadsheets']
)
service = build('sheets', 'v4', credentials=creds)

# 讀取 2026.01 前20列
for sheet_name in ['2026.01', '2026.02', '2026.03']:
    print(f'\n{"="*60}')
    print(f'=== {sheet_name} 前3列（標題）===')
    result = service.spreadsheets().values().get(
        spreadsheetId=SPREADSHEET_ID,
        range=f'{sheet_name}!A1:P3'
    ).execute()
    rows = result.get('values', [])
    for i, row in enumerate(rows):
        print(f"  Row {i+1}: {row}")

    print(f'\n=== {sheet_name} D="上班日加班" 的前幾列 (A1:P50) ===')
    result = service.spreadsheets().values().get(
        spreadsheetId=SPREADSHEET_ID,
        range=f'{sheet_name}!A1:P50'
    ).execute()
    rows = result.get('values', [])
    for i, row in enumerate(rows):
        # pad row to 16 columns
        while len(row) < 16:
            row.append('')
        d_val = row[3] if len(row) > 3 else ''
        l_val = row[11] if len(row) > 11 else ''
        if '上班日加班' in str(d_val):
            try:
                l_num = float(str(l_val).replace(':', '.')) if l_val else 0
            except:
                l_num = 0
            print(f"  Row {i+1}: B={row[1]}, D={row[3]}, E={row[4]}, F={row[5]}, G={row[6]}, H={row[7]}, K={row[10]}, L={row[11]}")

# 補休登記表完整
print('\n=== 2026年加班選擇補休登記表 全部 ===')
result = service.spreadsheets().values().get(
    spreadsheetId=SPREADSHEET_ID,
    range='2026年加班選擇補休登記表!A1:H30'
).execute()
rows = result.get('values', [])
for i, row in enumerate(rows):
    print(f"  Row {i+1}: {row}")

# 加班登記表完整
print('\n=== 2026年加班登記表 全部 ===')
result = service.spreadsheets().values().get(
    spreadsheetId=SPREADSHEET_ID,
    range='2026年加班登記表!A1:H20'
).execute()
rows = result.get('values', [])
for i, row in enumerate(rows):
    print(f"  Row {i+1}: {row}")