app / export /pdf_exporter.py
Ryo_Shimano
Claude Sonnet 4.6
ๆœใฎใฟๅฏใƒปๆ™ฉใฎใฟๅฏใฎไธญๅคฎใ‚ปใƒซ้ป„่‰ฒๅก—ใ‚Šใ‚’้™คๅŽป
e809d1f
Raw History Blame Contribute Delete
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()