app / scripts /seed_test_data.py
m1m02530125's picture
Claude Sonnet 4.6
ๆœชไฝฟ็”จใฎใ€Œๅ›บๅฎšใ‚ทใƒ•ใƒˆใƒ‘ใ‚ฟใƒผใƒณใ€ใ€Œๅ›บๅฎšไธๅฏๆ—ฅใ€ๆฉŸ่ƒฝใ‚’ๅ‰Š้™ค
7660d20
Raw History Blame Contribute Delete
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()