Claude Sonnet 4.6
ๆชไฝฟ็จใฎใๅบๅฎใทใใใใฟใผใณใใๅบๅฎไธๅฏๆฅใๆฉ่ฝใๅ้ค
7660d20 Download scripts/seed_test_data.py from sdu-shift/app: direct link, hf CLI and curl.
- Browser
- Download file 27.3 kB
-
https://huggingface.co/spaces/sdu-shift/app/resolve/main/scripts/seed_test_data.py
- Command line
-
hf download hf://spaces/sdu-shift/app/scripts/seed_test_data.py
-
curl -L -o seed_test_data.py https://huggingface.co/spaces/sdu-shift/app/resolve/main/scripts/seed_test_data.py
27.3 kB
| #!/usr/bin/env python3 | |
| """ | |
| ใในใใใผใฟ็ๆในใฏใชใใ โ 3ๆๅๅใทใใ (3/1ใ3/15) | |
| ๅฎ้ใฎ็ขบๅฎใทใใ่กจใDBใซ็ป้ฒใใ็ขบๅฎๅใฎๅธๆใทใใ๏ผๅฎ้ใฎใทใใใซ | |
| ่ฟใใไธ้จ็ฐใชใใใชใจใผใทใงใณ๏ผใๅใใใฆๆๅ ฅใใพใใ | |
| ไฝฟใๆน: | |
| cd /home/shift-tool | |
| python scripts/seed_test_data.py # ใใผใฟใ่ฟฝๅ | |
| python scripts/seed_test_data.py --reset # ๅ จใใผใฟๅ้คๅพใซ่ฟฝๅ | |
| """ | |
| from __future__ import annotations | |
| import sys, os, random, argparse | |
| sys.path.insert(0, os.path.dirname(os.path.dirname(os.path.abspath(__file__)))) | |
| from db.database import initialize_db, get_connection | |
| from db import repositories as repo | |
| from models.employee import Employee | |
| from models.schedule import SchedulePeriod, ShiftRequest, ShiftAssignment | |
| from utils.constants import EmploymentType, SkillLevel, TimeSlot, Position | |
| from utils.shift_patterns import ALL_PATTERNS, PATTERN_MAP, ShiftPattern | |
| random.seed(42) # ๅ็พๆงใฎใใไนฑๆฐ | |
| # โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| # ๅฎๆฐ | |
| # โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| PERIOD_START = "2024-03-01" | |
| PERIOD_END = "2024-03-15" | |
| # ในใญใใๅคๅฎใฎ้พๅค | |
| BREAKFAST_START, BREAKFAST_END = 6.0, 11.0 | |
| DINNER_START, DINNER_END = 17.0, 23.0 | |
| MIN_OVERLAP_H = 2.0 | |
| # โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| # ๅพๆฅญๅกใในใฟใผ | |
| # (name, employment_type, hall_skill, kitchen_skill, default_position) | |
| # default_position: ไธปใซๆ ๅฝใใใใธใทใงใณ ('hall' / 'kitchen') | |
| # โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| EMPLOYEE_MASTER = [ | |
| # โโ ๆญฃ็คพๅก๏ผใใผใซ็ณปใป็ฎก็่ท๏ผ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| ("ๆฑ ๅฑฑ", "full_time", "leader", "general", "hall"), | |
| ("ๅฎๆฌ", "full_time", "leader", "general", "hall"), | |
| ("๏จๆฌ", "full_time", "leader", "general", "hall"), | |
| # โโ ๆญฃ็คพๅก๏ผใญใใใณ็ณปใป็ฎก็่ท๏ผ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| ("ๅฒก็ฐ", "full_time", "general", "leader", "kitchen"), | |
| ("้็ฐ", "full_time", "general", "leader", "kitchen"), | |
| ("ใฟใชใช", "full_time", "general", "veteran", "kitchen"), | |
| # โโ ใขใซใใคใ๏ผๆ้ฃใใผใซ็ณป๏ผ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| ("ๆ", "part_time", "veteran", "beginner", "hall"), | |
| ("ใใใค", "part_time", "veteran", "beginner", "hall"), | |
| ("็ดฐ็ฐ", "part_time", "general", "general", "hall"), | |
| ("ใขใในใใฟ", "part_time", "general", "beginner", "hall"), | |
| ("ใใใน", "part_time", "general", "beginner", "hall"), | |
| ("ใฌใธใผใ", "part_time", "general", "beginner", "hall"), | |
| ("ใใซใทใฃใ", "part_time", "general", "beginner", "hall"), | |
| ("่คๅ ", "part_time", "general", "beginner", "hall"), | |
| ("ไธ็ฐ", "part_time", "general", "beginner", "hall"), | |
| ("ๆดฅๆณขๅค", "part_time", "general", "beginner", "hall"), | |
| ("ใซใใชใ", "part_time", "general", "beginner", "hall"), | |
| ("ใญใ ", "part_time", "general", "beginner", "hall"), | |
| ("้ฝ่ค", "part_time", "general", "beginner", "hall"), | |
| ("่ค็", "part_time", "beginner","beginner", "hall"), | |
| # โโ ใขใซใใคใ๏ผๆ้ฃใญใใใณ็ณป๏ผ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| ("็ฐไธญ", "part_time", "beginner","general", "kitchen"), | |
| ("ๅณถ้", "part_time", "beginner","veteran", "kitchen"), # ๆ้ฃใญใใใณๆๅคๆ ๅฝ | |
| ("ใใฃใผ", "part_time", "beginner","veteran", "kitchen"), # ๆ้ฃใญใใใณๅธธ้ฃ | |
| ("ๅ็ฐ", "part_time", "general", "veteran", "kitchen"), # ๆ้ฃใญใใใณๅธธ้ฃ | |
| ("ๅ", "part_time", "beginner","beginner", "kitchen"), | |
| # โโ ใขใซใใคใ๏ผใใฃใใผใใผใซ็ณป๏ผ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| ("ๅๆ่", "part_time", "general", "beginner", "hall"), | |
| ("ใใชใขใณ", "part_time", "general", "beginner", "hall"), | |
| ("ไธญๅฎถ", "part_time", "general", "beginner", "hall"), | |
| ("ๅ ไน ", "part_time", "general", "beginner", "hall"), | |
| ("ๅๅฟ็ฉ", "part_time", "general", "beginner", "hall"), | |
| ("ๅฒกๆฌ", "part_time", "general", "general", "hall"), | |
| ("ๅปฃ็ฐ", "part_time", "beginner","beginner", "hall"), | |
| ("ใชใใ", "part_time", "general", "beginner", "hall"), | |
| ("้ดๆจ", "part_time", "general", "beginner", "hall"), | |
| # โโ ใขใซใใคใ๏ผใใฃใใผใญใใใณ็ณป๏ผ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| ("ๅๅค", "part_time", "beginner","general", "kitchen"), | |
| ("ๅๆฌ", "part_time", "beginner","general", "kitchen"), | |
| # โโ ใใฎไป โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| ("ไบไธ", "part_time", "beginner","beginner", "hall"), | |
| ("ใขใชใฃใผ", "part_time", "beginner","beginner", "hall"), | |
| ] | |
| # โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| # ็ขบๅฎใทใใใใผใฟ (CSVใใๆฝๅบ) | |
| # ๅฝขๅผ: {name: {date: (start_decimal, end_decimal, note)}} | |
| # - start/end ใ None ใฎๅ ดๅใฏๆ็ตฆใไผใฟ | |
| # - note == "ๆ็ตฆ" โ ๆ็ตฆไผๆ | |
| # โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| CONFIRMED_SHIFTS: dict[str, dict[str, tuple]] = { | |
| "ๆฑ ๅฑฑ": { | |
| "2024-03-01": (13.0, 22.5, ""), | |
| "2024-03-03": (13.0, 22.5, ""), | |
| "2024-03-04": (13.0, 22.5, ""), | |
| "2024-03-06": (13.0, 22.5, ""), | |
| "2024-03-08": (13.0, 22.5, ""), | |
| "2024-03-09": (None, None, "ๆ็ตฆ"), | |
| "2024-03-10": (13.0, 22.5, ""), | |
| "2024-03-11": (13.0, 22.5, ""), | |
| "2024-03-13": (13.0, 22.5, ""), | |
| "2024-03-14": (13.0, 22.5, ""), | |
| }, | |
| "ๅฎๆฌ": { | |
| "2024-03-02": (13.0, 22.5, ""), | |
| "2024-03-03": (13.0, 22.5, ""), | |
| "2024-03-05": (13.0, 22.5, ""), | |
| "2024-03-06": (13.0, 22.5, ""), | |
| "2024-03-08": (13.0, 22.5, ""), | |
| "2024-03-09": (13.0, 22.5, ""), | |
| "2024-03-11": (13.0, 22.5, ""), | |
| "2024-03-12": (13.0, 22.5, ""), | |
| "2024-03-13": (13.0, 22.5, ""), | |
| "2024-03-14": (None, None, "ๆ็ตฆ"), | |
| }, | |
| "๏จๆฌ": { | |
| "2024-03-01": (13.0, 22.5, ""), | |
| "2024-03-02": (13.0, 22.5, ""), | |
| "2024-03-03": (13.0, 22.5, ""), | |
| "2024-03-04": (13.0, 22.5, ""), | |
| "2024-03-06": (13.0, 22.5, ""), | |
| "2024-03-07": (13.0, 22.5, ""), | |
| "2024-03-08": (13.0, 22.5, ""), | |
| "2024-03-10": (13.0, 22.5, ""), | |
| "2024-03-11": (13.0, 22.5, ""), | |
| "2024-03-14": (13.0, 22.5, ""), | |
| "2024-03-15": (13.0, 22.5, ""), | |
| }, | |
| "ๅฒก็ฐ": { | |
| "2024-03-02": (14.0, 23.0, ""), | |
| "2024-03-03": (10.0, 23.0, "ไผๆฉ4h"), | |
| "2024-03-04": (14.0, 23.0, ""), | |
| "2024-03-06": (14.0, 23.0, ""), | |
| "2024-03-07": (10.0, 19.0, ""), | |
| "2024-03-08": (14.0, 23.0, ""), | |
| "2024-03-10": (14.0, 23.0, ""), | |
| "2024-03-11": (None, None, "ๆ็ตฆ"), | |
| "2024-03-12": (14.0, 23.0, ""), | |
| }, | |
| "้็ฐ": { | |
| "2024-03-01": (14.0, 23.0, ""), | |
| "2024-03-02": (14.0, 23.0, ""), | |
| "2024-03-05": (14.0, 23.0, ""), | |
| "2024-03-06": (14.0, 23.0, ""), | |
| "2024-03-07": (14.0, 23.0, ""), | |
| "2024-03-09": (14.0, 23.0, ""), | |
| "2024-03-11": (14.0, 23.0, ""), | |
| "2024-03-12": (14.0, 23.0, ""), | |
| "2024-03-13": (12.0, 23.0, ""), | |
| }, | |
| "ใฟใชใช": { | |
| "2024-03-01": (5.75, 14.75, ""), | |
| "2024-03-03": (14.0, 23.0, ""), | |
| "2024-03-04": (14.0, 23.0, ""), | |
| "2024-03-05": (14.0, 23.0, ""), | |
| "2024-03-06": (5.75, 14.75, ""), | |
| "2024-03-09": (14.0, 23.0, ""), | |
| "2024-03-10": (14.0, 23.0, ""), | |
| "2024-03-11": (14.0, 23.0, ""), | |
| "2024-03-12": (5.75, 14.75, ""), | |
| }, | |
| "ๆ": { | |
| "2024-03-02": (5.75, 14.75, ""), | |
| "2024-03-03": (5.75, 11.5, ""), | |
| "2024-03-05": (5.75, 11.5, ""), | |
| "2024-03-06": (5.75, 14.75, ""), | |
| "2024-03-07": (5.75, 14.75, ""), | |
| "2024-03-08": (5.75, 11.5, ""), | |
| "2024-03-10": (5.75, 14.75, ""), | |
| "2024-03-11": (5.75, 14.75, ""), | |
| "2024-03-13": (5.75, 14.75, ""), | |
| "2024-03-15": (5.75, 14.75, ""), | |
| }, | |
| "ใใใค": { | |
| "2024-03-01": (5.75, 14.75, ""), | |
| "2024-03-03": (5.75, 14.5, ""), | |
| "2024-03-04": (5.75, 14.75, ""), | |
| "2024-03-05": (5.75, 11.5, ""), | |
| "2024-03-09": (5.75, 14.75, ""), | |
| "2024-03-10": (5.75, 11.5, ""), | |
| "2024-03-11": (5.75, 14.75, ""), | |
| "2024-03-12": (5.75, 14.75, ""), | |
| }, | |
| "็ดฐ็ฐ": { | |
| "2024-03-01": (5.75, 11.5, ""), | |
| "2024-03-02": (5.75, 11.5, ""), | |
| "2024-03-04": (5.75, 11.5, ""), | |
| "2024-03-05": (5.75, 14.75, ""), | |
| "2024-03-08": (5.75, 14.75, ""), | |
| "2024-03-09": (5.75, 11.5, ""), | |
| "2024-03-10": (5.75, 11.5, ""), | |
| "2024-03-11": (5.75, 11.5, ""), | |
| "2024-03-13": (17.0, 23.0, ""), # ใใฃใใผใซใๅ ฅใ | |
| }, | |
| "ใขใในใใฟ": { | |
| "2024-03-01": (6.0, 11.5, ""), | |
| "2024-03-04": (6.0, 11.5, ""), | |
| "2024-03-08": (6.0, 11.5, ""), | |
| "2024-03-13": (6.0, 11.5, ""), | |
| }, | |
| "ใใใน": { | |
| "2024-03-02": (6.0, 11.5, ""), | |
| "2024-03-05": (6.5, 11.5, ""), | |
| "2024-03-09": (6.0, 11.5, ""), | |
| }, | |
| "ใฌใธใผใ": { | |
| "2024-03-06": (6.0, 11.5, ""), | |
| "2024-03-11": (6.0, 11.5, ""), | |
| }, | |
| "ใใซใทใฃใ": { | |
| "2024-03-07": (6.0, 11.5, ""), | |
| "2024-03-12": (6.0, 11.5, ""), | |
| }, | |
| "่คๅ ": { | |
| "2024-03-01": (5.75, 11.5, ""), | |
| "2024-03-04": (5.75, 11.5, ""), | |
| "2024-03-07": (5.75, 11.5, ""), | |
| "2024-03-08": (5.75, 11.5, ""), | |
| }, | |
| "ไธ็ฐ": { | |
| "2024-03-03": (5.75, 11.5, ""), | |
| "2024-03-10": (5.75, 11.5, ""), | |
| }, | |
| "ๆดฅๆณขๅค": { | |
| "2024-03-02": (6.0, 11.5, ""), | |
| "2024-03-11": (6.0, 11.5, ""), | |
| }, | |
| "ใซใใชใ": { | |
| "2024-03-01": (6.0, 11.5, "ๆๅ"), | |
| "2024-03-02": (6.0, 11.5, ""), | |
| "2024-03-08": (6.0, 11.5, ""), | |
| "2024-03-10": (6.0, 11.5, ""), | |
| }, | |
| "ใญใ ": { | |
| "2024-03-09": (18.0, 22.5, "ๅคๅ"), | |
| "2024-03-10": (18.0, 22.5, ""), | |
| }, | |
| "้ฝ่ค": { | |
| "2024-03-03": (6.0, 11.5, ""), | |
| "2024-03-06": (6.0, 11.5, ""), | |
| "2024-03-07": (6.0, 11.5, ""), | |
| }, | |
| "่ค็": { | |
| "2024-03-05": (6.0, 9.0, ""), | |
| "2024-03-10": (6.0, 9.0, ""), | |
| }, | |
| "็ฐไธญ": { | |
| "2024-03-09": (6.5, 10.0, ""), | |
| "2024-03-14": (6.5, 10.0, ""), | |
| }, | |
| "ๅณถ้": { | |
| "2024-03-04": (6.0, 10.0, ""), | |
| "2024-03-05": (6.0, 10.0, ""), | |
| "2024-03-07": (6.0, 10.0, ""), | |
| "2024-03-11": (6.5, 10.0, ""), | |
| "2024-03-12": (6.0, 10.0, ""), | |
| }, | |
| "ใใฃใผ": { | |
| "2024-03-02": (7.0, 11.0, ""), | |
| "2024-03-07": (7.0, 11.0, ""), | |
| "2024-03-09": (6.5, 10.0, ""), | |
| "2024-03-12": (18.0, 22.5, ""), # ใใพใซใใฃใใผใ | |
| }, | |
| "ๅ็ฐ": { | |
| "2024-03-04": (6.0, 10.5, ""), | |
| "2024-03-06": (6.5, 10.0, ""), | |
| "2024-03-07": (6.0, 10.0, ""), | |
| "2024-03-12": (6.5, 10.5, ""), | |
| "2024-03-15": (17.5, 22.0, ""), | |
| }, | |
| "ๅ": { | |
| "2024-03-03": (6.0, 10.0, ""), | |
| "2024-03-08": (None, None, "ๆ็ตฆ"), | |
| "2024-03-11": (6.0, 9.0, ""), | |
| "2024-03-14": (6.0, 10.0, ""), | |
| }, | |
| "ๅๆ่": { | |
| "2024-03-01": (18.5, 23.0, "ใใผใซๅ ผไปป"), | |
| "2024-03-09": (18.5, 23.0, "ใใผใซๅ ผไปป"), | |
| "2024-03-10": (18.0, 23.0, "ใใผใซๅ ผไปป"), | |
| }, | |
| "ใใชใขใณ": { | |
| "2024-03-01": (17.0, 22.5, ""), | |
| "2024-03-03": (17.0, 22.5, ""), | |
| "2024-03-05": (17.0, 22.5, ""), | |
| "2024-03-10": (17.0, 22.5, ""), | |
| "2024-03-11": (17.0, 22.5, ""), | |
| }, | |
| "ไธญๅฎถ": { | |
| "2024-03-02": (17.0, 23.0, "ๅคๅ"), | |
| "2024-03-04": (17.0, 23.0, ""), | |
| "2024-03-11": (17.0, 23.0, ""), | |
| }, | |
| "ๅ ไน ": { | |
| "2024-03-11": (17.5, 22.5, "ใใผใซๅ ผไปป"), | |
| }, | |
| "ๅๅฟ็ฉ": { | |
| "2024-03-06": (17.5, 23.0, ""), | |
| }, | |
| "ๅฒกๆฌ": { | |
| "2024-03-01": (17.5, 22.0, ""), | |
| "2024-03-03": (18.0, 22.0, ""), | |
| "2024-03-04": (18.0, 22.0, ""), | |
| "2024-03-05": (18.0, 23.0, ""), | |
| "2024-03-06": (17.5, 21.0, ""), | |
| "2024-03-08": (17.5, 21.0, ""), | |
| "2024-03-09": (18.75, 22.0, "ใญใใใณๅ ผไปป"), | |
| "2024-03-11": (18.0, 23.0, ""), | |
| }, | |
| "ๅปฃ็ฐ": { | |
| "2024-03-02": (18.0, 22.5, ""), | |
| "2024-03-06": (18.5, 22.5, ""), | |
| }, | |
| "ใชใใ": { | |
| "2024-03-06": (18.0, 23.0, ""), | |
| "2024-03-08": (18.5, 23.0, ""), | |
| }, | |
| "้ดๆจ": { | |
| "2024-03-01": (6.5, 11.5, ""), | |
| "2024-03-15": (18.0, 23.0, ""), | |
| }, | |
| "ๅๅค": { | |
| "2024-03-03": (17.5, 23.0, "ใญใใใณ"), | |
| "2024-03-07": (18.0, 23.0, ""), | |
| "2024-03-11": (18.0, 23.0, ""), | |
| "2024-03-13": (17.0, 23.0, ""), | |
| "2024-03-14": (18.0, 23.0, ""), | |
| }, | |
| "ๅๆฌ": { | |
| "2024-03-06": (18.0, 21.5, "ใญใใใณๅ ผไปป"), | |
| "2024-03-09": (18.0, 21.5, ""), | |
| }, | |
| "ไบไธ": {}, # ใทใใใชใ | |
| "ใขใชใฃใผ": { | |
| "2024-03-12": (18.0, 21.0, ""), | |
| }, | |
| } | |
| # โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| # ใฆใผใใฃใชใใฃ้ขๆฐ | |
| # โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| def dec_to_hhmm(dec: float) -> str: | |
| """ๅฐๆฐๆๅป (5.75) โ 'HH:MM' ('05:45')""" | |
| h = int(dec) | |
| m = round((dec - h) * 60) | |
| if m == 60: | |
| h += 1 | |
| m = 0 | |
| return f"{h:02d}:{m:02d}" | |
| def overlaps_slot(s: float, e: float, slot_s: float, slot_e: float) -> bool: | |
| """ใทใใใในใญใใใจ MIN_OVERLAP_H ๆ้ไปฅไธ้ใชใใ""" | |
| overlap = max(0.0, min(e, slot_e) - max(s, slot_s)) | |
| return overlap >= MIN_OVERLAP_H | |
| def get_timeslots(s: float, e: float) -> list[str]: | |
| """(start, end) ใๆ้ฃใปใใฃใใผใฎใฉใกใใใซใใผใใใ่ฟใ""" | |
| slots = [] | |
| if overlaps_slot(s, e, BREAKFAST_START, BREAKFAST_END): | |
| slots.append(TimeSlot.BREAKFAST.value) | |
| if overlaps_slot(s, e, DINNER_START, DINNER_END): | |
| slots.append(TimeSlot.DINNER.value) | |
| return slots | |
| def find_pattern_id(s: float, e: float) -> tuple[str, str | None, str | None]: | |
| """ | |
| (start, end) ใซๆใ่ฟใใใฟใผใณIDใ่ฟใใ | |
| ้พๅคๅ ใซ่ฉฒๅฝใชใใใฐ "custom" ใ่ฟใใ | |
| """ | |
| THRESHOLD = 0.3 # 18ๅไปฅๅ ใชใไธ่ดใจใฟใชใ | |
| best, best_diff = None, float("inf") | |
| for p in ALL_PATTERNS: | |
| if p.id in ("custom", "double") or not p.start or not p.end: | |
| continue | |
| diff = abs(p.start_hour() - s) + abs(p.end_hour() - e) | |
| if diff < best_diff: | |
| best_diff = diff | |
| best = p | |
| if best and best_diff <= THRESHOLD: | |
| return best.id, None, None | |
| return "custom", dec_to_hhmm(s), dec_to_hhmm(e) | |
| # โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| # ๅธๆใทใใใฎใใชใจใผใทใงใณ็ๆ๏ผ็ขบๅฎๅใๆจกๆฌ๏ผ | |
| # โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| # ็ขบๅฎใทใใใจ็ฐใชใใๅธๆใใ็ๆใใใใใฎใซใผใซ: | |
| # โ ็ขบๅฎใทใใใจๅใๆฅ โ ๅใใใฟใผใณใงๅธๆ | |
| # โก ไธ้จใฎๆฅใฏใไฝๅใซ็ฉบใใๅ ฅใใใ๏ผๅธๆใใใๅ ฅใใชใใฃใๆฅ๏ผ | |
| # โข ๆญฃ็คพๅกใฏๅธๆ๏ผ็ขบๅฎ๏ผใปใผๅบๅฎ๏ผ | |
| def _random_extra_dates(name: str, confirmed_dates: set, all_dates: list) -> set: | |
| """็ขบๅฎใใใชใใฃใใไฝๅใฎๅธๆๆฅใใใฉใณใใ ใง่ฟฝๅ ๏ผใขใซใใคใใฎใฟ๏ผ""" | |
| candidates = [d for d in all_dates if d not in confirmed_dates] | |
| n_extra = random.randint(0, min(3, len(candidates))) | |
| return set(random.sample(candidates, n_extra)) | |
| def build_requests( | |
| emp: Employee, | |
| confirmed: dict[str, tuple], | |
| all_dates: list[str], | |
| employment_type: str, | |
| ) -> list[ShiftRequest]: | |
| """ShiftRequest ใฎใชในใใ็ๆ๏ผ็ขบๅฎๅใฎๅธๆใทใใ๏ผ""" | |
| requests = [] | |
| confirmed_dates = set(confirmed.keys()) | |
| # ใขใซใใคใ: ไฝๅๅธๆๆฅใ่ฟฝๅ | |
| if employment_type == "part_time": | |
| extra = _random_extra_dates(emp.name, confirmed_dates, all_dates) | |
| else: | |
| extra = set() | |
| for date_str in all_dates: | |
| if date_str in confirmed: | |
| s, e, note = confirmed[date_str] | |
| if note == "ๆ็ตฆ": | |
| # ๆ็ตฆใฏๅธๆใซ "ๆ็ตฆ" ใใผใใๅ ฅใใ | |
| req = ShiftRequest( | |
| employee_id=emp.id, | |
| date=date_str, | |
| pattern_id=None, | |
| note="ๆ็ตฆ", | |
| ) | |
| elif s is None: | |
| continue # ไผใฟใฏใชใฏใจในใไธ่ฆ | |
| else: | |
| pid, cs, ce = find_pattern_id(s, e) | |
| req = ShiftRequest( | |
| employee_id=emp.id, | |
| date=date_str, | |
| pattern_id=pid, | |
| custom_start=cs, | |
| custom_end=ce, | |
| note=note, | |
| ) | |
| requests.append(req) | |
| elif date_str in extra: | |
| # ไฝๅๅธๆ: ไธปใซไฝฟใใใฟใผใณๅธฏใๅ็พ | |
| # ็ขบๅฎใทใใใฎใใฟใผใณใใไปฃ่กจ็ใชๆ้ๅธฏใๆจๅฎ | |
| if confirmed: | |
| sample = [v for v in confirmed.values() if v[0] is not None] | |
| if sample: | |
| ss, se, _ = random.choice(sample) | |
| pid, cs, ce = find_pattern_id(ss, se) | |
| requests.append(ShiftRequest( | |
| employee_id=emp.id, | |
| date=date_str, | |
| pattern_id=pid, | |
| custom_start=cs, | |
| custom_end=ce, | |
| note="", | |
| )) | |
| return requests | |
| # โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| # ็ขบๅฎใขใตใคใณ็ๆ | |
| # โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| def build_assignments( | |
| emp: Employee, | |
| confirmed: dict[str, tuple], | |
| default_pos: str, | |
| period_id: int, | |
| ) -> list[ShiftAssignment]: | |
| """ShiftAssignment ใฎใชในใใ็ๆ๏ผ็ขบๅฎใทใใ๏ผ""" | |
| assignments = [] | |
| for date_str, (s, e, note) in confirmed.items(): | |
| if s is None: | |
| continue # ๆ็ตฆใปไผใฟ | |
| slots = get_timeslots(s, e) | |
| # ๅ่ใซใใธใทใงใณๆ ๅ ฑใใใๅ ดๅใฏๅชๅ | |
| pos_str = default_pos | |
| note_lower = note.lower() | |
| if "ใใผใซ" in note: | |
| pos_str = "hall" | |
| elif "ใญใใใณ" in note: | |
| pos_str = "kitchen" | |
| for slot_str in slots: | |
| assignments.append(ShiftAssignment( | |
| employee_id=emp.id, | |
| date=date_str, | |
| time_slot=TimeSlot(slot_str), | |
| position=Position(pos_str), | |
| )) | |
| return assignments | |
| # โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| # ใกใคใณๅฆ็ | |
| # โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| def reset_db(): | |
| """ๅ จใใผใฟใๅ้ค๏ผใใผใใซๆง้ ใฏ็ถญๆ๏ผ""" | |
| conn = get_connection() | |
| conn.execute("DELETE FROM shift_assignments") | |
| conn.execute("DELETE FROM shift_requests") | |
| conn.execute("DELETE FROM schedule_periods") | |
| conn.execute("DELETE FROM employees") | |
| conn.commit() | |
| conn.close() | |
| print("โ ๆขๅญใใผใฟใใชใปใใใใพใใ") | |
| def main(): | |
| parser = argparse.ArgumentParser(description="ใในใใใผใฟ็ๆ") | |
| parser.add_argument("--reset", action="store_true", help="ๆขๅญใใผใฟใๅ จๅ้คใใฆใใ่ฟฝๅ ") | |
| args = parser.parse_args() | |
| initialize_db() | |
| if args.reset: | |
| reset_db() | |
| # โโ ๅพๆฅญๅกใ็ป้ฒ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| print("ๅพๆฅญๅกใ็ป้ฒไธญ...") | |
| emp_map: dict[str, Employee] = {} | |
| for name, emp_type, hall_sk, kit_sk, _ in EMPLOYEE_MASTER: | |
| emp = Employee( | |
| id=None, | |
| name=name, | |
| employment_type=EmploymentType(emp_type), | |
| hall_skill_breakfast=SkillLevel(hall_sk), | |
| hall_skill_dinner=SkillLevel(hall_sk), | |
| kitchen_skill_breakfast=SkillLevel(kit_sk), | |
| kitchen_skill_dinner=SkillLevel(kit_sk), | |
| ) | |
| saved = repo.save_employee(emp) | |
| emp_map[name] = saved | |
| print(f" โ {len(emp_map)} ๅใ็ป้ฒ") | |
| # โโ ๆ้ใ็ป้ฒ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| period = repo.save_period(SchedulePeriod( | |
| id=None, | |
| start_date=PERIOD_START, | |
| end_date=PERIOD_END, | |
| status="draft", | |
| )) | |
| print(f" โ ๆ้ {PERIOD_START}ใ{PERIOD_END} (id={period.id}) ใ็ป้ฒ") | |
| from datetime import date, timedelta | |
| start_d = date.fromisoformat(PERIOD_START) | |
| end_d = date.fromisoformat(PERIOD_END) | |
| all_dates = [] | |
| cur = start_d | |
| while cur <= end_d: | |
| all_dates.append(cur.isoformat()) | |
| cur += timedelta(days=1) | |
| # โโ ๅธๆใทใใใ็ป้ฒ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| print("ๅธๆใทใใ(็ขบๅฎๅ)ใ็ป้ฒไธญ...") | |
| pos_map = {name: pos for name, _, _, _, pos in EMPLOYEE_MASTER} | |
| total_req = 0 | |
| for name, emp in emp_map.items(): | |
| confirmed = CONFIRMED_SHIFTS.get(name, {}) | |
| emp_type = next(t for n, t, _, _, _ in EMPLOYEE_MASTER if n == name) | |
| requests = build_requests(emp, confirmed, all_dates, emp_type) | |
| if requests: | |
| repo.save_shift_requests(period.id, requests) | |
| total_req += len(requests) | |
| print(f" โ {total_req} ไปถใฎๅธๆใทใใใ็ป้ฒ") | |
| # โโ ็ขบๅฎใทใใใขใตใคใณใ็ป้ฒ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| print("็ขบๅฎใทใใ(ใขใตใคใณ)ใ็ป้ฒไธญ...") | |
| all_assignments: list[ShiftAssignment] = [] | |
| for name, emp in emp_map.items(): | |
| confirmed = CONFIRMED_SHIFTS.get(name, {}) | |
| default_pos = pos_map.get(name, "hall") | |
| assignments = build_assignments(emp, confirmed, default_pos, period.id) | |
| all_assignments.extend(assignments) | |
| repo.save_assignments(period.id, all_assignments) | |
| print(f" โ {len(all_assignments)} ไปถใฎใขใตใคใณใ็ป้ฒ") | |
| # โโ ๅถ็ดใใงใใฏใตใใช โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| print("\n=== ๆฅๅฅๅถ็ดใใงใใฏ (ๆ้ฃ/ใใฃใใผ) ===") | |
| from collections import defaultdict | |
| from utils.constants import SHIFT_CONSTRAINTS | |
| assign_map = defaultdict(int) | |
| for a in all_assignments: | |
| assign_map[(a.date, a.time_slot.value, a.position.value)] += 1 | |
| violations = 0 | |
| for ds in all_dates: | |
| d = date.fromisoformat(ds) | |
| issues = [] | |
| for (slot, pos), c in SHIFT_CONSTRAINTS.items(): | |
| cnt = assign_map[(ds, slot.value, pos.value)] | |
| if cnt < c["min"]: | |
| issues.append( | |
| f" โ {slot.short_label()}{pos.label()}: {cnt}ๅ < min{c['min']}" | |
| ) | |
| violations += 1 | |
| if issues: | |
| dow = ["ๆ","็ซ","ๆฐด","ๆจ","้","ๅ","ๆฅ"][d.weekday()] | |
| print(f" {d.month}/{d.day}({dow})") | |
| for msg in issues: | |
| print(msg) | |
| if violations == 0: | |
| print(" ๅ จๆฅ็จใงไบบๅกๅถ็ดใฏใชใข โ") | |
| else: | |
| print(f"\n โ {violations}ไปถใฎๅถ็ด้ๅ๏ผๅฎ้ใฎใทใใ่กจใๅฟ ๅฎใซๅ็พใใ็ตๆ๏ผ") | |
| print(" โป ใในใ็จใใผใฟใฎใใใไธ้จๆฅ็จใงในใฟใใใๅฐใชใๅ ดๅใใใใพใ") | |
| print("\nโ ใในใใใผใฟใฎ็ๆใๅฎไบใใพใใ") | |
| print(f" ๆ้ID: {period.id}") | |
| print(f" ๅพๆฅญๅก: {len(emp_map)} ๅ") | |
| print(f" ๅธๆใทใใ: {total_req} ไปถ") | |
| print(f" ็ขบๅฎใขใตใคใณ: {len(all_assignments)} ไปถ") | |
| print("\nใขใใชใ่ตทๅใใฆใใทใใ่กจ ็ขบ่ชใป็ทจ้ใ็ป้ขใง็ขบ่ชใงใใพใใ") | |
| if __name__ == "__main__": | |
| main() | |