lin

Generate annual insurance welfare Word reports from `gh_hg_bscyearall_dues` in OpenClaw format. The packaged Python entry extracts the target year, inspects MySQL column comments, maps business fields into the bundled Word template, and writes the final `.docx` report.

Annual Insurance Word Report

What this package does

• Resolves the target year from year or from request_text
• Queries gh_hg_bscyearall_dues
• Reads INFORMATION_SCHEMA.COLUMNS comments before rendering
• Fills the bundled yearly Word template without depending on Word COM
• Writes the finished .docx file to outputs/ by default

Inputs

• request_text: optional natural-language request, for example 帮我生成2023年业务报告
• year: optional explicit year, for example 2023
• template_path: optional custom .docx template path
• output_path: optional custom output .docx path
• db_host: optional, default 127.0.0.1
• db_port: optional, default 3306
• db_user: optional, default root
• db_password: optional, default root
• database: optional, default test_db
• table_name: optional, default gh_hg_bscyearall_dues
• charset: optional, default utf8mb4
• mysql_cli: optional fallback path to mysql CLI if PyMySQL is unavailable

Run

Install dependencies:

pip install -r requirements.txt

Run with an explicit year:

python src/main.py --year 2023

Run with request text extraction:

python src/main.py --request-text "帮我生成2023年业务报告"

Custom database example:

python src/main.py --year 2023 --database test_db --db-user root --db-password root

Notes

• The default output path is outputs/annual-insurance-report-<year>.docx.
• The default template is stored as text in assets/beijing_office_annual_template.docx.base64.txt and is restored to a temporary .docx at runtime.
• The package keeps the original business mapping: 团意、子女、女工、重疾、轻症、住院、津贴、补充、两癌、综合A、综合B、合计.
• If PyMySQL is not installed, the entry falls back to the mysql CLI when mysql_cli is provided or mysql is on PATH.