Ryo_Shimano
Claude Sonnet 4.6
ๆใฎใฟๅฏใปๆฉใฎใฟๅฏใฎไธญๅคฎใปใซ้ป่ฒๅกใใ้คๅป
e809d1f Download export/pdf_exporter.py from sdu-shift/app: direct link, hf CLI and curl.
- Browser
- Download file 26.9 kB
-
https://huggingface.co/spaces/sdu-shift/app/resolve/main/export/pdf_exporter.py
- Command line
-
hf download hf://spaces/sdu-shift/app/export/pdf_exporter.py
-
curl -L -o pdf_exporter.py https://huggingface.co/spaces/sdu-shift/app/resolve/main/export/pdf_exporter.py
26.9 kB
| """PDFๅบๅใขใธใฅใผใซ๏ผSDU_shift ใใณใใฌใผใๅ็พๆนๅผ๏ผ | |
| export/templates/SDU_shift_template.xlsx ใจๅใ็ด้ขใฌใคใขใฆใใ reportlab ใงๅ็พใใใ | |
| Excelๅบๅ๏ผใใณใใฌใผใๆตใ่พผใฟ๏ผใๅฐๅทใใใจใใจๅใ่ฆใ็ฎใซใชใใใใ | |
| ใใณใใฌใผใใฎๅฎๆธฌๅค๏ผๅๅน ใป่ก้ซใปใใฉใณใใตใคใบใป็ฝซ็ท๏ผใ็ธฎๅฐบใใฆๆ็ปใใใ | |
| ็ด้ขๆงๆ๏ผ1ๆฅ = 3ๅ: ้ๅงๆๅป / ๅบๅใ("-")ใปๅ่ / ็ตไบๆๅปใๆฅไปใใญใใฏใฏๆ้ๆฅๆฐๅ๏ผ: | |
| ๆฅไปใปๆๆฅ / ใกใข1(3่ก) / ใกใข2 / ๆ้ฃ่ฆ่พผใปๅคไบ็ด | |
| ใญใใใณ็คพๅก(2ๆ ) / ใญใใใณAใปP(18ๆ ) | |
| 2ใใญใใฏ็ฎใใใใผ๏ผๆฅไปใปๆๆฅใปๆ้ฃ่ฆ่พผใปๅคไบ็ด๏ผ | |
| ใใผใซ็คพๅก(3ๆ ) / ใใผใซAใปP(16ๆ ) | |
| ใใใฟใผ๏ผๆฅไปใปๆๆฅ๏ผ | |
| ๆ ใ่ถณใใชใใฐใซใผใใฏ่กใ่ฟฝๅ ใใใๅฐๅท่จญๅฎใฏ A4ๆจชใป1ใใผใธใใฃใใใๅ็พใ | |
| """ | |
| from __future__ import annotations | |
| from datetime import date | |
| import os | |
| from reportlab.lib.pagesizes import A4, landscape | |
| from reportlab.lib import colors | |
| from reportlab.platypus import Table, TableStyle, Paragraph | |
| from reportlab.pdfgen import canvas | |
| from reportlab.lib.styles import ParagraphStyle | |
| from reportlab.pdfbase import pdfmetrics | |
| from reportlab.pdfbase.ttfonts import TTFont | |
| from reportlab.lib.enums import TA_CENTER | |
| from models.employee import Employee | |
| from models.schedule import SchedulePeriod | |
| from utils.constants import TimeSlot, EmploymentType, PrimaryPosition | |
| from utils.holidays import holiday_set | |
| DAY_JP = ["ๆ", "็ซ", "ๆฐด", "ๆจ", "้", "ๅ", "ๆฅ"] | |
| # โโ ใใณใใฌใผใใฎใฌใคใขใฆใๅฎๆธฌๅค โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| N_BLOCKS = 16 # ใใณใใฌใผใใฎๆๅคงๆฅไปใใญใใฏๆฐ๏ผๅฎ้ใฏๆ้ๆฅๆฐๅใ ใๆ็ป๏ผ | |
| COLS_PER_DAY = 3 # 1ๆฅ = 3ๅ๏ผ้ๅง / ๅบๅใใปๅ่ / ็ตไบ๏ผ | |
| NAME_W_CH = 17.63 # ๆฐๅๅๅน ๏ผExcelๆๅญๅไฝ๏ผ | |
| DAY_W_CH = 5.75 # ๆฅไป1ๅๅน ๏ผExcelๆๅญๅไฝ๏ผ | |
| CH_PT = 5.25 # Excelๅๅน 1ๆๅญ โ 5.25pt | |
| H_DATE = 30.0 # ๆฅไปใปๆๆฅใปๅพๆฅญๅก่กใฎ่ก้ซ(pt) | |
| H_MEMO1 = 15.0 # ใกใข1๏ผร3่ก๏ผ | |
| H_MEMO2 = 45.0 # ใกใข2 | |
| H_FORE = 39.75 # ๆ้ฃ่ฆ่พผใปๅคไบ็ด | |
| F_TITLE = 24.0 # ใฟใคใใซ | |
| F_FORE = 20.0 # ๆ้ฃ่ฆ่พผใปๅคไบ็ดใฎๅค | |
| F_DATE = 18.0 # ๆฅไปใปๆๆฅ | |
| F_NAME = 14.0 # ๆฐๅใปใฉใใซ | |
| F_CELL = 12.0 # ใทใใใปใซ | |
| F_MEMO = 11.0 # ใกใข1ใฎๆๅญ | |
| K_FT_SLOTS, K_PT_SLOTS = 2, 18 # ใญใใใณ็คพๅก / AใปP ใฎๆ ๆฐ | |
| H_FT_SLOTS, H_PT_SLOTS = 3, 16 # ใใผใซ็คพๅก / AใปP ใฎๆ ๆฐ | |
| # ๅฐๅทไฝ็ฝ๏ผใใณใใฌใผใใฎใใผใธ่จญๅฎ: ๅทฆๅณ0.118inใปไธไธ0.157in๏ผ | |
| MARGIN_LR = 8.5 | |
| MARGIN_TB = 11.3 | |
| # ในใใผใฟในๅฅใฎใปใซๅกใ๏ผๅฎๆใคใกใผใธ SDU_Shift_full.xlsx ใซๆบๆ ๏ผ | |
| COL_NOTE = colors.HexColor("#FFFF00") # ้ป: ๅ่ใกใข | |
| COL_LEAVE = colors.HexColor("#B3E5A1") # ็ท: ๆ็ตฆ๏ผ3ใปใซๅ จไฝ๏ผ | |
| COL_FTOFF = colors.HexColor("#FF0000") # ่ตค: ็คพๅกใฎไผใฟใปๆๅฎไผ๏ผ3ใปใซๅ จไฝ๏ผ | |
| COL_SAT = colors.HexColor("#60CBF3") # ๆฐด่ฒ: ๅๆใฎๆฅไปใปๆๆฅ | |
| COL_SUN = colors.HexColor("#F6C6AC") # ใชใฌใณใธ: ๆฅๆใป็ฅๆฅใฎๆฅไปใปๆๆฅ | |
| COL_MEMO = colors.HexColor("#FF0000") # ใกใข1ใปใกใข2ใฎๆๅญ่ฒ๏ผ่ตค๏ผ | |
| MED, THIN = 0.8, 0.3 # ็ฝซ็ทๅน (pt): medium / thin | |
| # โโ ใใฉใณใ็ป้ฒ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| def _register_font() -> str: | |
| """ๆฅๆฌ่ชใใฉใณใใ็ป้ฒใๅฉ็จไธๅฏใฎๅ ดๅใฏ Helvetica ใซใใฉใผใซใใใฏใ | |
| ๅ ใทใผใใๅ จใปใซๅคชๅญใฎใใใๅๆขฑใฎๅคชๅญใใฉใณใ๏ผBIZ UDGothic Bold, OFL๏ผใ | |
| ๆๅชๅ ใงไฝฟใใ่ฆใคใใใชใๅ ดๅใฎใฟใทในใใ ใใฉใณใใๆขใใ""" | |
| import glob | |
| from pathlib import Path | |
| candidates = [ | |
| # ๅๆขฑใใฉใณใ๏ผๅคชๅญ๏ผ | |
| str(Path(__file__).parent / "fonts" / "BIZUDGothic-Bold.ttf"), | |
| # Linux: IPA Gothic (.ttf, ReportLabไบๆ) | |
| "/usr/share/fonts/opentype/ipafont-gothic/ipag.ttf", | |
| "/usr/share/fonts/opentype/ipafont-gothic/ipagp.ttf", | |
| # Windows | |
| "C:/Windows/Fonts/meiryo.ttc", | |
| "C:/Windows/Fonts/YuGothR.ttc", | |
| "C:/Windows/Fonts/msgothic.ttc", | |
| # macOS | |
| "/System/Library/Fonts/ใใฉใฎใ่งใดใทใใฏ W3.ttc", | |
| "/Library/Fonts/Osaka.ttf", | |
| ] | |
| # glob fallback | |
| candidates += sorted(glob.glob("/usr/share/fonts/**/*.ttf", recursive=True)) | |
| for path in candidates: | |
| if os.path.exists(path): | |
| try: | |
| font = TTFont("JpFont", path) | |
| # ๆฅๆฌ่ชใฐใชใใๆใคใใฉใณใใฎใฟๆก็จ๏ผ่ฑ่ ๅ้ฒๆญข๏ผ | |
| if 0x65E5 in getattr(font.face, "charToGlyph", {}): # ใๆฅใ | |
| pdfmetrics.registerFont(font) | |
| return "JpFont" | |
| except Exception: | |
| continue | |
| # TTFใ่ฆใคใใใชใๅ ดๅใฏ reportlab ๅ ่ตใฎCJK CIDใใฉใณใใไฝฟใ | |
| try: | |
| from reportlab.pdfbase.cidfonts import UnicodeCIDFont | |
| pdfmetrics.registerFont(UnicodeCIDFont("HeiseiKakuGo-W5")) | |
| return "HeiseiKakuGo-W5" | |
| except Exception: | |
| return "Helvetica" | |
| # โโ ใฆใผใใฃใชใใฃ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| def _to_decimal(time_str: str) -> str: | |
| """'HH:MM' โ ๅฐๆฐๆๅปๆๅญๅ ('5.75', '22.5', '13' ใชใฉ)""" | |
| if not time_str: | |
| return "" | |
| try: | |
| h, m = map(int, time_str.split(":")) | |
| if m == 0: | |
| return str(h) | |
| val = h + m / 60.0 | |
| return f"{val:.2f}".rstrip("0").rstrip(".") | |
| except Exception: | |
| return time_str | |
| def _get_shift_cells( | |
| emp_id: int, | |
| date_str: str, | |
| assignments: dict, | |
| req_map: dict, | |
| cell_notes: dict, | |
| ) -> tuple[str, str, str, str]: | |
| """ | |
| (้ๅงๆๅปใปใซ, ๅบๅใ/ๅ่ใปใซ, ็ตไบๆๅปใปใซ, ในใฟใคใซ็จฎๅฅ) ใ่ฟใใ | |
| ในใฟใคใซ็จฎๅฅ: 'assigned' | 'assigned_note' | 'leave' | 'off' | 'ft_off' | 'am_only' | 'pm_only' | |
| assignments ใฎๅคใฏ (position_value, is_reinforcement, reinf_start, reinf_end) ใฎ4ใฟใใซใ | |
| """ | |
| from utils.shift_patterns import PATTERN_MAP | |
| req = req_map.get((emp_id, date_str)) | |
| note = (req.note or "").strip() if req else "" | |
| # ในใฟใใๅๅฅใณใกใณใ๏ผใปใซๅไฝใฎใกใข๏ผใใใใฐๅชๅ ใใฆๅบๅใใปใซใซ่กจ็คบ | |
| cnote = (cell_notes.get((emp_id, date_str)) or "").strip() | |
| if cnote: | |
| note = cnote | |
| # ๆญฃ็คพๅกๅธๆไผ | |
| if req and req.pattern_id == "off_request": | |
| return "", "-", "", "ft_off" | |
| # ๆ็ตฆใใงใใฏ๏ผpaid_leave ใใฟใผใณ or ใกใขใซใๆ็ตฆใ๏ผ | |
| if (req and req.pattern_id == "paid_leave") or "ๆ็ตฆ" in note: | |
| return "", "ๆ็ตฆ", "", "leave" | |
| # ใขใตใคใณ็ขบ่ช | |
| b_raw = assignments.get((emp_id, date_str, TimeSlot.BREAKFAST.value)) | |
| d_raw = assignments.get((emp_id, date_str, TimeSlot.DINNER.value)) | |
| if not b_raw and not d_raw: | |
| if req and req.pattern_id == "am_only": | |
| return "6", "-", "15", "am_only" | |
| if req and req.pattern_id == "pm_only": | |
| return "14", "-", "23", "pm_only" | |
| if cnote: | |
| return "", cnote, "", "assigned_note" | |
| return "", "-", "", "off" | |
| # 4ใฟใใซใใไฝ็ฝฎๆ ๅ ฑใๅฑ้ | |
| b_pos, _b_is_reinf, b_rs, b_re = b_raw if b_raw else (None, False, None, None) | |
| d_pos, _d_is_reinf, d_rs, d_re = d_raw if d_raw else (None, False, None, None) | |
| # ๅฟๆดใปๅธๆๆ้ใใใฎๅคๆดใฏ reinf_start/reinf_end ใๅชๅ ใใฆไฝฟ็จ | |
| if (b_rs and b_re) or (d_rs and d_re): | |
| if b_raw and not d_raw and b_rs and b_re: | |
| s, e = _to_decimal(b_rs), _to_decimal(b_re) | |
| elif d_raw and not b_raw and d_rs and d_re: | |
| s, e = _to_decimal(d_rs), _to_decimal(d_re) | |
| elif b_raw and d_raw: | |
| s = _to_decimal(b_rs) if b_rs else "6" | |
| e = _to_decimal(d_re) if d_re else "23" | |
| else: | |
| s, e = _slot_default(b_pos, d_pos) | |
| if note: | |
| return s, note, e, "assigned_note" | |
| return s, "-", e, "assigned" | |
| # ๆๅปๅๅพ๏ผใใฟใผใณใใ๏ผ | |
| # ใใใใซใใฏๆ้ฃใปใใฃใใผไธกๆนใๅฒๅฝๆธใฟใฎๅ ดๅใฎใฟ้ใ่กจ็คบใซใใใ | |
| # ็ๆนใฎใฟใฎๅฒๅฝใฎๅ ดๅใฏๅฎ้ใฎๅฒๅฝๆ้ๅธฏใ่กจ็คบใใใ | |
| if req and req.pattern_id == "double" and b_raw and d_raw: | |
| s, e = "6", "23" | |
| elif req and req.pattern_id == "custom" and req.custom_start and req.custom_end: | |
| s = _to_decimal(req.custom_start) | |
| e = _to_decimal(req.custom_end) | |
| elif req and req.pattern_id and req.pattern_id != "double": | |
| p = PATTERN_MAP.get(req.pattern_id) | |
| if p and p.start and p.end: | |
| s = _to_decimal(p.start) | |
| e = _to_decimal(p.end) | |
| else: | |
| s, e = _slot_default(b_pos, d_pos) | |
| else: | |
| s, e = _slot_default(b_pos, d_pos) | |
| # ๅ่ใๆๅปใฎ้๏ผๅบๅใใปใซ๏ผใซๆใๅฝขๅผ | |
| if note: | |
| return s, note, e, "assigned_note" | |
| return s, "-", e, "assigned" | |
| def _slot_default(b_pos, d_pos) -> tuple[str, str]: | |
| """ใใธใทใงใณๅฅใฎใใใฉใซใๅคๅๆ้ใ่ฟใ๏ผHH:MM ใๅฐๆฐๆๅปใซๅคๆ๏ผ""" | |
| from db import repositories as repo | |
| pos_key = b_pos or d_pos or "hall" # ใใธใทใงใณๅ ("hall" or "kitchen") | |
| if b_pos and d_pos: | |
| s = _to_decimal(repo.get_app_setting(f"ft_{pos_key}_breakfast_start", "06:00")) | |
| e = _to_decimal(repo.get_app_setting(f"ft_{pos_key}_dinner_end", "22:00")) | |
| elif b_pos: | |
| s = _to_decimal(repo.get_app_setting(f"ft_{pos_key}_breakfast_start", "06:00")) | |
| e = _to_decimal(repo.get_app_setting(f"ft_{pos_key}_breakfast_end", "11:00")) | |
| else: | |
| s = _to_decimal(repo.get_app_setting(f"ft_{pos_key}_dinner_start", "17:00")) | |
| e = _to_decimal(repo.get_app_setting(f"ft_{pos_key}_dinner_end", "22:00")) | |
| return s, e | |
| def _block_col(i: int) -> int: | |
| """ๆฅไปใใญใใฏ i (0ๅงใพใ) ใฎๅ ้ ญๅ๏ผใใผใใซๅ ใคใณใใใฏในใๅทฆๆฐๅๅ=0๏ผ""" | |
| return 1 + i * COLS_PER_DAY | |
| # โโ ใกใคใณๅบๅ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| def export_pdf( | |
| path: str, | |
| period: SchedulePeriod, | |
| employees: list[Employee], | |
| assignments: dict, | |
| show_reservation_counts: bool = True, | |
| ): | |
| """SDU_shift ใใณใใฌใผใใจๅใ็ด้ขใฎ PDF ใๅบๅใใ๏ผA4ๆจชใป1ใใผใธใใฃใใ๏ผใ | |
| show_reservation_counts=False ใฎๅ ดๅใใๆ้ฃ่ฆ่พผใใๅคไบ็ดใ่ก๏ผ1ใป2ใใญใใฏ็ฎใจใ๏ผ | |
| ใฎ้ซใใ0ใซใใฆๅบๅใใ็ใ๏ผๅ จไฝๅจ็ฅ็จใทใใ่กจๅใ๏ผใ""" | |
| from db import repositories as repo | |
| requests = repo.get_shift_requests(period.id) | |
| req_map = {(r.employee_id, r.date): r for r in requests} | |
| notes = repo.get_schedule_notes(period.id) # ๅ จไฝๅใใ็ฅใใ โ ใกใข1ๆฌ | |
| staff_notes = repo.get_staff_notes(period.id) # ็คพๅกๅใใ็ฅใใ โ ใกใข2ๆฌ | |
| reserves = repo.get_reservation_counts(period.id) | |
| cell_notes = repo.get_cell_notes(period.id) # ในใฟใใๅๅฅใณใกใณใ โ ๅบๅใใปใซ | |
| font = _register_font() | |
| dates = list(period.date_range())[:N_BLOCKS] | |
| n = len(dates) | |
| holidays = holiday_set(dates) | |
| # โโ ๅพๆฅญๅกใใใณใใฌใผใใฎ4ใฐใซใผใใซๅ้ก๏ผExcelๅบๅใจๅไธใญใธใใฏ๏ผโโ | |
| def _out_pos(e): | |
| return e.output_position or e.primary_position | |
| def _is_ft(e): | |
| return e.employment_type == EmploymentType.FULL_TIME | |
| kitchen = [e for e in employees if _out_pos(e) == PrimaryPosition.KITCHEN] | |
| hall = [e for e in employees if _out_pos(e) != PrimaryPosition.KITCHEN] | |
| k_ft = [e for e in kitchen if _is_ft(e)] | |
| k_pt = [e for e in kitchen if not _is_ft(e)] | |
| h_ft = [e for e in hall if _is_ft(e)] | |
| h_pt = [e for e in hall if not _is_ft(e)] | |
| k_ft_n = max(K_FT_SLOTS, len(k_ft)) | |
| k_pt_n = max(K_PT_SLOTS, len(k_pt)) | |
| h_ft_n = max(H_FT_SLOTS, len(h_ft)) | |
| h_pt_n = max(H_PT_SLOTS, len(h_pt)) | |
| # โโ ใฟใคใใซ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| start_d = date.fromisoformat(period.start_date) | |
| half = "ๅๅ" if start_d.day <= 15 else "ๅพๅ" | |
| draft = "" if period.status == "confirmed" else "(ๆก)" | |
| title = f"{start_d.month}ๆใ{half}{draft}" | |
| # โโ ็ธฎๅฐบ่จ็ฎ๏ผA4ๆจช1ใใผใธใใฃใใใฎๅ็พ๏ผโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| page_w, page_h = landscape(A4) | |
| avail_w = page_w - 2 * MARGIN_LR | |
| avail_h = page_h - 2 * MARGIN_TB | |
| n_cols = 2 + n * COLS_PER_DAY # ๆใฎๆฅๆฐใซๅใใใใญใใฏๆฐใๅฏๅคใซใ็ฉบ็ฝใไฝใใชใ | |
| natural_w = (2 * NAME_W_CH + n * COLS_PER_DAY * DAY_W_CH) * CH_PT | |
| # ๆ้ฃ่ฆ่พผใปๅคไบ็ด่กใฏ show_reservation_counts=False ใฎๅ ดๅใ้ซใ0ใซใใฆ็ใ | |
| fore_h = H_FORE if show_reservation_counts else 0.0 | |
| fore_h2 = H_DATE if show_reservation_counts else 0.0 | |
| # ่กๆงๆ: ใใใใผ8่ก + Kๆ + 2ใใญใใฏ็ฎ4่ก + Hๆ + ใใใฟใผ2่ก | |
| row_heights_nat: list[float] = [] | |
| row_heights_nat += [H_DATE, H_DATE, H_MEMO1, H_MEMO1, H_MEMO1, H_MEMO2, fore_h, fore_h] | |
| row_heights_nat += [H_DATE] * (k_ft_n + k_pt_n) | |
| row_heights_nat += [H_DATE, H_DATE, fore_h2, fore_h2] | |
| row_heights_nat += [H_DATE] * (h_ft_n + h_pt_n) | |
| row_heights_nat += [H_DATE] * 2 | |
| row_heights_nat += [15.0] # ๅกไพ่ก | |
| natural_h = sum(row_heights_nat) | |
| sx = avail_w / natural_w # ๆจชใฏ็ดๅน ใใฃใฑใใซไฝฟใ | |
| # ็ธฆใฏ1ใใผใธใซๅใพใใใ็ธฎๅฐ๏ผไธธใ่ชคๅทฎใงใฎๆนใใผใธใ้ฒใใใๅ ใใซไฝ่ฃใๆใใใ๏ผ | |
| sy = min(avail_h * 0.995 / natural_h, sx) | |
| f = min(sx, sy) # ใใฉใณใใฏๅฐใใๆนใฎ็ธฎๅฐบใซๅใใใ | |
| col_widths = ([NAME_W_CH * CH_PT * sx] | |
| + [DAY_W_CH * CH_PT * sx] * (n * COLS_PER_DAY) | |
| + [NAME_W_CH * CH_PT * sx]) | |
| row_heights = [h * sy for h in row_heights_nat] | |
| # โโ ่กใคใณใใใฏใน โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| R_DATE1, R_DOW1, R_MEMO1, R_MEMO2, R_BF, R_DIN = 0, 1, 2, 5, 6, 7 | |
| k_ft_row = 8 | |
| k_pt_row = k_ft_row + k_ft_n | |
| r_date2 = k_pt_row + k_pt_n | |
| r_dow2, r_bf2, r_din2 = r_date2 + 1, r_date2 + 2, r_date2 + 3 | |
| h_ft_row = r_date2 + 4 | |
| h_pt_row = h_ft_row + h_ft_n | |
| r_date3 = h_pt_row + h_pt_n | |
| r_dow3 = r_date3 + 1 | |
| r_legend = r_dow3 + 1 | |
| n_rows = r_legend + 1 | |
| # โโ ใใผใฟ่กๅใจในใฟใคใซ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| data = [["" for _ in range(n_cols)] for _ in range(n_rows)] | |
| cmds: list[tuple] = [ | |
| ("FONTNAME", (0, 0), (-1, -1), font), | |
| ("FONTSIZE", (0, 0), (-1, -1), F_CELL * f), | |
| # LEADING ใๆๅญใตใคใบใซ่ฟฝๅพใใใชใใจ็ธฆไธญๅคฎใใใใใ๏ผๆขๅฎ12ptๅบๅฎใฎใใ๏ผ | |
| ("LEADING", (0, 0), (-1, -1), F_CELL * f * 1.2), | |
| ("ALIGN", (0, 0), (-1, -1), "CENTER"), | |
| ("VALIGN", (0, 0), (-1, -1), "MIDDLE"), | |
| ("LEFTPADDING", (0, 0), (-1, -1), 1), | |
| ("RIGHTPADDING", (0, 0), (-1, -1), 1), | |
| ("TOPPADDING", (0, 0), (-1, -1), 0), | |
| ("BOTTOMPADDING", (0, 0), (-1, -1), 0), | |
| ("TEXTCOLOR", (0, 0), (-1, -1), colors.black), | |
| ] | |
| # ใกใข1ใปใกใข2ใฏ่ตคๅญ18pt๏ผๅฎๆใคใกใผใธๆบๆ ๏ผ | |
| memo_style = ParagraphStyle( | |
| "memo", fontName=font, fontSize=F_DATE * f, leading=F_DATE * f * 1.1, | |
| alignment=TA_CENTER, textColor=COL_MEMO) | |
| name_w = NAME_W_CH * CH_PT * sx | |
| cell_w = DAY_W_CH * CH_PT * sx | |
| def _shrink_size(text: str, base_pt: float, width_pt: float) -> float | None: | |
| """shrink_to_fit ็ธๅฝ: ๆๅญๅใใปใซๅน ใ่ถ ใใๅ ดๅใฎ็ธฎๅฐใใฉใณใใตใคใบใ่ฟใใ | |
| ๅใพใๅ ดๅใฏ None๏ผๆขๅฎใตใคใบใฎใพใพ๏ผใ""" | |
| if not text: | |
| return None | |
| w = pdfmetrics.stringWidth(str(text), font, base_pt) | |
| avail = width_pt - 1.5 | |
| if w <= avail: | |
| return None | |
| return max(2.5, base_pt * avail / w) | |
| def _set_title(c, r): | |
| """ๆฐๅๅใฎใฟใคใใซใปใซ๏ผๆๅญๅใงๆธใใ็ธฆๆจชใจใไธญๅคฎใซๆใใ๏ผ""" | |
| data[r][c] = title | |
| sz = _shrink_size(title, F_TITLE * f, name_w) or F_TITLE * f | |
| cmds.append(("FONTSIZE", (c, r), (c, r), sz)) | |
| cmds.append(("LEADING", (c, r), (c, r), sz * 1.2)) | |
| def _span(c0, r0, c1, r1): | |
| cmds.append(("SPAN", (c0, r0), (c1, r1))) | |
| def _font_size(row, size, c0=0, c1=-1): | |
| cmds.append(("FONTSIZE", (c0, row), (c1, row), size * f)) | |
| cmds.append(("LEADING", (c0, row), (c1, row), size * f * 1.2)) | |
| # โโ ใใใใผ๏ผๆฅไปใปๆๆฅใปใกใข1ใปใกใข2ใปๆ้ฃ่ฆ่พผใปๅคไบ็ด๏ผโโโโโโโโโโ | |
| def _fill_date_rows(r_date, r_dow): | |
| for i in range(n): | |
| c0 = _block_col(i) | |
| _span(c0, r_date, c0 + 2, r_date) | |
| _span(c0, r_dow, c0 + 2, r_dow) | |
| if i < n: | |
| d = dates[i] | |
| data[r_date][c0] = str(d.day) | |
| data[r_dow][c0] = DAY_JP[d.weekday()] | |
| # ๅๆ=ๆฐด่ฒ / ๆฅๆใป็ฅๆฅ=ใชใฌใณใธ | |
| if d.weekday() == 5: | |
| cmds.append(("BACKGROUND", (c0, r_date), (c0 + 2, r_dow), COL_SAT)) | |
| elif d.weekday() == 6 or d.isoformat() in holidays: | |
| cmds.append(("BACKGROUND", (c0, r_date), (c0 + 2, r_dow), COL_SUN)) | |
| _font_size(r_date, F_DATE) | |
| _font_size(r_dow, F_DATE) | |
| _fill_date_rows(R_DATE1, R_DOW1) | |
| # ใฟใคใใซ๏ผๅทฆๅณๆฐๅๅใๆฅไปใใกใข1ใฎ5่กใถใใ็ธฆใใผใธ๏ผ | |
| _span(0, R_DATE1, 0, R_MEMO1 + 2) | |
| _span(n_cols - 1, R_DATE1, n_cols - 1, R_MEMO1 + 2) | |
| _set_title(0, R_DATE1) | |
| _set_title(n_cols - 1, R_DATE1) | |
| for i in range(n): | |
| c0 = _block_col(i) | |
| _span(c0, R_MEMO1, c0 + 2, R_MEMO1 + 2) # ใกใข1: 3ๅร3่ก | |
| _span(c0, R_MEMO2, c0 + 2, R_MEMO2) | |
| if show_reservation_counts: | |
| _span(c0, R_BF, c0 + 2, R_BF) | |
| _span(c0, R_DIN, c0 + 2, R_DIN) | |
| if i < n: | |
| ds = dates[i].isoformat() | |
| note = notes.get(ds, "") | |
| note2 = staff_notes.get(ds, "") | |
| if note: | |
| data[R_MEMO1][c0] = Paragraph(note, memo_style) | |
| if note2: | |
| data[R_MEMO2][c0] = Paragraph(note2, memo_style) | |
| if show_reservation_counts: | |
| res = reserves.get(ds, {}) | |
| if res.get("breakfast") is not None: | |
| data[R_BF][c0] = str(res["breakfast"]) | |
| if res.get("dinner") is not None: | |
| data[R_DIN][c0] = str(res["dinner"]) | |
| if show_reservation_counts: | |
| data[R_BF][0] = "ๆ้ฃ่ฆ่พผ" | |
| data[R_BF][n_cols - 1] = "ๆ้ฃ่ฆ่พผ" | |
| data[R_DIN][0] = "ๅคไบ็ด" | |
| data[R_DIN][n_cols - 1] = "ๅคไบ็ด" | |
| _font_size(R_BF, F_FORE) | |
| _font_size(R_DIN, F_FORE) | |
| _font_size(R_BF, F_NAME, 0, 0) | |
| _font_size(R_BF, F_NAME, n_cols - 1, n_cols - 1) | |
| _font_size(R_DIN, F_NAME, 0, 0) | |
| _font_size(R_DIN, F_NAME, n_cols - 1, n_cols - 1) | |
| # โโ 2ใใญใใฏ็ฎใใใใผใปใใใฟใผ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| _fill_date_rows(r_date2, r_dow2) | |
| _span(0, r_date2, 0, r_dow2) | |
| _span(n_cols - 1, r_date2, n_cols - 1, r_dow2) | |
| _set_title(0, r_date2) | |
| _set_title(n_cols - 1, r_date2) | |
| if show_reservation_counts: | |
| for i in range(n): | |
| c0 = _block_col(i) | |
| _span(c0, r_bf2, c0 + 2, r_bf2) | |
| _span(c0, r_din2, c0 + 2, r_din2) | |
| if i < n: | |
| res = reserves.get(dates[i].isoformat(), {}) | |
| if res.get("breakfast") is not None: | |
| data[r_bf2][c0] = str(res["breakfast"]) | |
| if res.get("dinner") is not None: | |
| data[r_din2][c0] = str(res["dinner"]) | |
| data[r_bf2][0] = "ๆ้ฃ่ฆ่พผ" | |
| data[r_bf2][n_cols - 1] = "ๆ้ฃ่ฆ่พผ" | |
| data[r_din2][0] = "ๅคไบ็ด" | |
| data[r_din2][n_cols - 1] = "ๅคไบ็ด" | |
| _font_size(r_bf2, F_FORE) | |
| _font_size(r_din2, F_FORE) | |
| for rr in (r_bf2, r_din2): | |
| _font_size(rr, F_NAME, 0, 0) | |
| _font_size(rr, F_NAME, n_cols - 1, n_cols - 1) | |
| _fill_date_rows(r_date3, r_dow3) | |
| _span(0, r_date3, 0, r_dow3) | |
| _span(n_cols - 1, r_date3, n_cols - 1, r_dow3) | |
| _set_title(0, r_date3) | |
| _set_title(n_cols - 1, r_date3) | |
| # โโ ๅพๆฅญๅก่ก โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| def _fill_group(start_row: int, slot_count: int, emps: list[Employee]): | |
| for j in range(slot_count): | |
| r = start_row + j | |
| _font_size(r, F_NAME, 0, 0) | |
| _font_size(r, F_NAME, n_cols - 1, n_cols - 1) | |
| if j >= len(emps): | |
| continue | |
| emp = emps[j] | |
| data[r][0] = emp.name | |
| data[r][n_cols - 1] = emp.name | |
| # ๆฐๅใๅๅน ใ่ถ ใใๅ ดๅใฏ็ธฎๅฐ๏ผshrink_to_fit ๅ็พ๏ผ | |
| sz = _shrink_size(emp.name, F_NAME * f, name_w) | |
| if sz: | |
| for cc in (0, n_cols - 1): | |
| cmds.append(("FONTSIZE", (cc, r), (cc, r), sz)) | |
| cmds.append(("LEADING", (cc, r), (cc, r), sz * 1.2)) | |
| for i, d in enumerate(dates): | |
| c0 = _block_col(i) | |
| s_txt, m_txt, e_txt, style = _get_shift_cells( | |
| emp.id, d.isoformat(), assignments, req_map, cell_notes) | |
| data[r][c0] = s_txt | |
| data[r][c0 + 1] = m_txt | |
| data[r][c0 + 2] = e_txt | |
| # ๅ่็ญใๅๅน ใ่ถ ใใๅ ดๅใฏ็ธฎๅฐ๏ผshrink_to_fit ๅ็พ๏ผ | |
| for cc, txt in ((c0, s_txt), (c0 + 1, m_txt), (c0 + 2, e_txt)): | |
| sz = _shrink_size(txt, F_CELL * f, cell_w) | |
| if sz: | |
| cmds.append(("FONTSIZE", (cc, r), (cc, r), sz)) | |
| cmds.append(("LEADING", (cc, r), (cc, r), sz * 1.2)) | |
| if style == "assigned_note": | |
| cmds.append(("BACKGROUND", (c0 + 1, r), (c0 + 1, r), COL_NOTE)) | |
| elif style == "leave": | |
| # ๆ็ตฆใฏ3ใปใซๅ จไฝใ็ทๅกใ๏ผๅฎๆใคใกใผใธๆบๆ ๏ผ | |
| cmds.append(("BACKGROUND", (c0, r), (c0 + 2, r), COL_LEAVE)) | |
| elif style == "ft_off" or ( | |
| style == "off" and emp.employment_type == EmploymentType.FULL_TIME | |
| ): | |
| # ็คพๅกใฎไผใฟใปๆๅฎไผใฏ3ใปใซๅ จไฝใ่ตคๅกใ | |
| cmds.append(("BACKGROUND", (c0, r), (c0 + 2, r), COL_FTOFF)) | |
| _fill_group(k_ft_row, k_ft_n, k_ft) | |
| _fill_group(k_pt_row, k_pt_n, k_pt) | |
| _fill_group(h_ft_row, h_ft_n, h_ft) | |
| _fill_group(h_pt_row, h_pt_n, h_pt) | |
| # โโ ็ฝซ็ท๏ผใใณใใฌใผใใฎ medium/thin ไฝฟใๅใใๅ็พ๏ผโโโโโโโโโโโโโโโโ | |
| last = n_cols - 1 | |
| # ็ธฆ็ท: ๆฐๅๅใฎไธกๅดใจๆฅไปใใญใใฏๅข็ใฏ medium | |
| for c in [0, 1] + [_block_col(i) for i in range(1, n)] + [last]: | |
| cmds.append(("LINEBEFORE", (c, 0), (c, -1), MED, colors.black)) | |
| cmds.append(("LINEAFTER", (last, 0), (last, -1), MED, colors.black)) | |
| def _hline(row, weight, where="below", data_only=False): | |
| """ๆจช็ฝซ็ทใdata_only=True ใฏใฟใคใใซใฎ็ธฆใใผใธๅ ใ่ฒซ้ใใใชใใใ | |
| ๆฅไปใใญใใฏๅใฎใฟใซ็ทใๅผใใ""" | |
| cmd = "LINEBELOW" if where == "below" else "LINEABOVE" | |
| c0, c1 = (1, n_cols - 2) if data_only else (0, -1) | |
| cmds.append((cmd, (c0, row), (c1, row), weight, colors.black)) | |
| # ใใใใผ้จ๏ผๆฅไปใปๆๆฅใฎๅบๅใใฏใฟใคใใซใปใซ(็ธฆใใผใธ)ๅ ใชใฎใงใใผใฟๅใฎใฟ๏ผ | |
| _hline(R_DATE1, MED, "above") | |
| _hline(R_DATE1, THIN, data_only=True) | |
| _hline(R_DOW1, MED, data_only=True) | |
| _hline(R_MEMO1 + 2, MED) | |
| _hline(R_MEMO2, MED) | |
| _hline(R_BF, MED) | |
| _hline(R_DIN, MED) | |
| # ๅพๆฅญๅก่ก: ่ก้ thinใใใญใใฏๆซๅฐพ medium | |
| for r in range(k_ft_row, r_date2): | |
| _hline(r, THIN) | |
| _hline(r_date2 - 1, MED) | |
| for r in range(h_ft_row, r_date3): | |
| _hline(r, THIN) | |
| _hline(r_date3 - 1, MED) | |
| # 2ใใญใใฏ็ฎใใใใผ | |
| _hline(r_date2, THIN, data_only=True) | |
| _hline(r_dow2, MED) | |
| _hline(r_bf2, MED) | |
| _hline(r_din2, MED) | |
| # ใใใฟใผ | |
| _hline(r_date3, THIN, data_only=True) | |
| _hline(r_dow3, MED) | |
| _hline(r_legend, MED) | |
| # โโ ๅกไพ่ก๏ผ้ป=ใกใข / ่ตค=็คพๅกไผ / ็ท=ๆ็ตฆ๏ผโโโโโโโโโโโโโโโโโโโโโโโโโโ | |
| data[r_legend][0] = "ๅกไพ:" | |
| for i, (bg, label) in enumerate( | |
| [(COL_NOTE, "ใกใข"), (COL_FTOFF, "็คพๅกไผ"), (COL_LEAVE, "ๆ็ตฆ")]): | |
| c0 = _block_col(i) | |
| _span(c0, r_legend, c0 + 2, r_legend) | |
| cmds.append(("BACKGROUND", (c0, r_legend), (c0 + 2, r_legend), bg)) | |
| data[r_legend][c0] = label | |
| _font_size(r_legend, F_CELL) | |
| # โโ ใใญใฅใกใณใ็ๆ๏ผCanvas็ดๆ็ปใง1ใใผใธใไฟ่จผ๏ผโโโโโโโโโโโโโโโโโ | |
| table = Table(data, colWidths=col_widths, rowHeights=row_heights) | |
| table.setStyle(TableStyle(cmds)) | |
| canv = canvas.Canvas(path, pagesize=landscape(A4)) | |
| canv.setTitle(f"ใทใใ่กจ {period.start_date}ใ{period.end_date}") | |
| _, table_h = table.wrapOn(canv, avail_w, avail_h) | |
| table.drawOn(canv, MARGIN_LR, page_h - MARGIN_TB - table_h) | |
| canv.save() | |