annual-insurance-word-report

by lin-shiwu

Install this Skill

curl -fsSL -o annual-insurance-word-report.zip https://skill.seembox.com/api/v1/skills/annual-insurance-word-report/download && unzip annual-insurance-word-report.zip

Download annual-insurance-word-report.zip

SKILL.md About

---
name: annual-insurance-word-report-openclaw
description: 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:

```bash
pip install -r requirements.txt
```

Run with an explicit year:

```bash
python src/main.py --year 2023
```

Run with request text extraction:

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

Custom database example:

```bash
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`.

_meta.json Metadata

{
  "ownerId": "kn7d3yjrn680g9432fjw949dks83f58v",
  "publishedAt": 1775099395691,
  "slug": "annual-insurance-word-report",
  "version": "1.0.0"
}