PART 04 — 帳票設計書
帳票種別・出力項目・レイアウト・データ取得SQL設計で定義すべきこと

-- 受注確認書（R001）データ取得SQL
SELECT
    o.order_no,
    o.order_date,
    c.customer_name,
    c.postal_code,
    c.address,
    od.product_name,
    od.quantity,
    od.unit_price,
    od.tax_type,
    od.quantity * od.unit_price AS subtotal_excl_tax
FROM
    t_order o
    INNER JOIN m_customer c ON o.customer_id = c.customer_id
    INNER JOIN t_order_detail od ON o.order_id = od.order_id
WHERE
    o.order_id = :order_id   -- バインドパラメータ
    AND o.delete_flg = FALSE
ORDER BY
    od.order_detail_seq ASC;

"""
reportlabで請求書PDFを生成するサンプル。
pip install reportlab
"""
from reportlab.lib.pagesizes import A4
from reportlab.lib.units import mm
from reportlab.pdfbase import pdfmetrics
from reportlab.pdfbase.ttfonts import TTFont
from reportlab.pdfgen import canvas
from dataclasses import dataclass
from datetime import date


@dataclass
class InvoiceItem:
    product_name: str
    quantity: int
    unit_price: float
    tax_type: int   # 10 or 8


@dataclass
class Invoice:
    invoice_no: str
    issue_date: date
    customer_name: str
    items: list[InvoiceItem]
    registration_no: str   # インボイス登録番号


def generate_invoice_pdf(invoice: Invoice, output_path: str) -> None:
    """請求書PDFを生成する"""
    # フォント設定（IPAゴシック使用 - インストールパスを確認すること）
    # pdfmetrics.registerFont(TTFont("IPAGothic", "/usr/share/fonts/opentype/ipafont-gothic/ipag.ttf"))

    c = canvas.Canvas(output_path, pagesize=A4)
    width, height = A4

    # タイトル
    c.setFont("Helvetica-Bold", 18)
    c.drawCentredString(width / 2, height - 30 * mm, "請　求　書")

    # 発行日・請求書番号
    c.setFont("Helvetica", 10)
    c.drawRightString(width - 20 * mm, height - 45 * mm, f"発行日: {invoice.issue_date.strftime('%Y年%m月%d日')}")
    c.drawRightString(width - 20 * mm, height - 52 * mm, f"請求書番号: {invoice.invoice_no}")
    c.drawRightString(width - 20 * mm, height - 59 * mm, f"登録番号: {invoice.registration_no}")

    # 宛先
    c.setFont("Helvetica-Bold", 12)
    c.drawString(20 * mm, height - 55 * mm, f"{invoice.customer_name}　御中")

    # 明細テーブルヘッダー
    y = height - 80 * mm
    c.setFont("Helvetica-Bold", 9)
    c.drawString(20 * mm, y, "品名")
    c.drawString(100 * mm, y, "数量")
    c.drawString(120 * mm, y, "単価")
    c.drawString(145 * mm, y, "金額")
    c.drawString(170 * mm, y, "税率")

    # 明細
    c.setFont("Helvetica", 9)
    subtotal_10 = subtotal_8 = 0.0
    for item in invoice.items:
        y -= 8 * mm
        amount = item.quantity * item.unit_price
        if item.tax_type == 10:
            subtotal_10 += amount
        else:
            subtotal_8 += amount

        c.drawString(20 * mm, y, item.product_name)
        c.drawRightString(115 * mm, y, str(item.quantity))
        c.drawRightString(143 * mm, y, f"¥{item.unit_price:,.0f}")
        c.drawRightString(168 * mm, y, f"¥{amount:,.0f}")
        c.drawString(172 * mm, y, f"{item.tax_type}%")

    # 合計
    y -= 15 * mm
    tax_10 = int(subtotal_10 * 0.1)
    tax_8  = int(subtotal_8 * 0.08)
    total  = int(subtotal_10 + subtotal_8 + tax_10 + tax_8)

    c.setFont("Helvetica-Bold", 10)
    c.drawString(120 * mm, y, f"10%対象: ¥{subtotal_10:,.0f}　消費税: ¥{tax_10:,}")
    y -= 7 * mm
    c.drawString(120 * mm, y, f" 8%対象: ¥{subtotal_8:,.0f}　消費税: ¥{tax_8:,}")
    y -= 10 * mm
    c.setFont("Helvetica-Bold", 12)
    c.drawString(120 * mm, y, f"合計（税込）: ¥{total:,}")

    c.save()
    print(f"{output_path} を出力しました")


if __name__ == "__main__":
    sample = Invoice(
        invoice_no="INV-2026-001",
        issue_date=date(2026, 6, 30),
        customer_name="株式会社サンプル",
        registration_no="T-1234567890123",
        items=[
            InvoiceItem("商品A", 10, 5000, 10),
            InvoiceItem("商品B（食料品）", 5, 2000, 8),
        ]
    )
    generate_invoice_pdf(sample, "invoice_sample.pdf")