279 lines
14 KiB
Python
279 lines
14 KiB
Python
#!/usr/bin/env python3
|
||
"""把「一张报销单一次冲多笔备用金」配到费用报销单上(额度台账多选冲销)。
|
||
|
||
cd backend/scripts
|
||
python3 -m advance_offset --check # 干跑:只说会改什么、后端认不认,不落库
|
||
python3 -m advance_offset # 配上:冲销明细逐行挂备用金额度
|
||
python3 -m advance_offset --show # 看现在配成了什么样
|
||
python3 -m advance_offset --revert # 撤掉额度控制,明细表回到纯手填
|
||
|
||
前置:先跑 ``python3 -m advance_cash --quota`` 把备用金额度定义配好——备用金申请单
|
||
办结即自动生成一行「应冲销额度」,台账不用人建。本脚本只做一件事:把这份额度挂到
|
||
费用报销单的冲销明细表上;缺的「备用金单号」「本次冲销金额」两列由它补出来。
|
||
|
||
配完之后报销单是这样用的:冲销明细的「备用金单号」变成额度下拉,只列本人名下还没
|
||
冲销完的备用金;选中一笔,借款金额 / 已冲销 / 还可冲自己落到这一行;再填本次冲销金额。
|
||
一行冲一笔,一张单可以填几行冲几笔。合计与超支都由后端按台账算:同一笔的多行合起来
|
||
判、合起来记,超了哪笔就点名挡哪笔。方案出处 ``docs/quota-control-design.md``。
|
||
"""
|
||
|
||
from __future__ import annotations
|
||
|
||
import argparse
|
||
import json
|
||
import sys
|
||
from pathlib import Path
|
||
|
||
sys.path.insert(0, str(Path(__file__).resolve().parent))
|
||
|
||
from advance_cash import PROCESS_NAME, QUOTA, QUOTA_CODE # noqa: E402
|
||
from expense.common import admin, ok # noqa: E402
|
||
|
||
FORM_NAME = "费用报销单"
|
||
TABLE_KEY = "offsetItems"
|
||
#: 选台账那一列 / 本次金额那一列(库里没有就按这两个键名补建,也可以用参数改)
|
||
PICK_COLUMN = "loanNo"
|
||
AMOUNT_COLUMN = "offsetAmount"
|
||
#: 额度维度键,与 advance_cash.QUOTA["dims"] 对上:一笔备用金一个维度
|
||
DIM_KEY = "advanceNo"
|
||
#: 行内三列(选中台账后由后端写)
|
||
ROW_SHOW = {"total": "loanAmount", "used": "loanUsed", "avail": "loanRemain"}
|
||
#: 表头三格:这张单在这几笔备用金上的合计
|
||
HEAD_SHOW = {"total": "advanceTotal", "used": "advanceUsed", "avail": "advanceRemain"}
|
||
ROW_TOTAL = ("借款金额", 2)
|
||
ROW_COLUMNS = {"loanUsed": ("已冲销", 2), "loanRemain": ("还可冲", 2)}
|
||
HEAD_COLUMNS = {"advanceTotal": ("涉及借款合计", 4), "advanceUsed": ("提交前已冲合计", 4),
|
||
"advanceRemain": ("本次之后剩余", 4)}
|
||
|
||
|
||
def quota_config(pick: str = PICK_COLUMN, amount: str = AMOUNT_COLUMN) -> dict:
|
||
"""挂在明细表字段上的那份额度配置(后端只认这一份)。"""
|
||
return {
|
||
"def": QUOTA_CODE,
|
||
"rows": {"dims": {DIM_KEY: pick}, "amount": amount, "show": dict(ROW_SHOW)},
|
||
"show": dict(HEAD_SHOW),
|
||
"over": "hard",
|
||
"message": "这笔备用金共 {total} 元,已冲 {used} 元,还可冲 {avail} 元,本次多冲 {over} 元",
|
||
}
|
||
|
||
|
||
def ensure_def(token: str) -> None:
|
||
"""额度定义在不在;不在就按备用金那份建出来(办结生成额度那一套照抄)。"""
|
||
defs = {row["code"]: row for row in ok("GET", "/design/quotas/defs", token)}
|
||
if QUOTA_CODE in defs:
|
||
print(f" 额度定义 {QUOTA_CODE}({defs[QUOTA_CODE]['name']}):已存在,不动")
|
||
return
|
||
process = next((row for row in ok("GET", "/process/processes", token, params={"page_size": 200})
|
||
if row.get("name") == PROCESS_NAME), None)
|
||
if process is None:
|
||
raise SystemExit(f"库里没有「{PROCESS_NAME}」,也还没有额度定义 {QUOTA_CODE}:"
|
||
"先跑 python3 -m advance_cash --quota 把备用金那套配好")
|
||
ok("POST", "/design/quotas/defs", token, dict(QUOTA, issue_process=process["id"]))
|
||
print(f" 额度定义 {QUOTA_CODE}({QUOTA['name']}):新建,备用金办结自动生成额度")
|
||
|
||
|
||
def find_form(token: str, name: str) -> dict:
|
||
for row in ok("GET", "/process/forms", token, params={"page_size": 200}):
|
||
if row["name"] == name:
|
||
return ok("GET", f"/process/forms/{row['id']}", token)
|
||
raise SystemExit(f"库里还没有表单「{name}」,先跑 python3 -m cost_reimburse 建出来")
|
||
|
||
|
||
def fields_of(form: dict) -> list[dict]:
|
||
return [dict(item) for item in (form.get("content") or {}).get("fields") or []]
|
||
|
||
|
||
def table_field(fields: list[dict], table_key: str) -> dict:
|
||
for item in fields:
|
||
if str(item.get("key") or "") == table_key:
|
||
if str(item.get("type") or "") != "table":
|
||
raise SystemExit(f"字段「{table_key}」不是明细表,逐行冲额度挂不上去")
|
||
return item
|
||
raise SystemExit(f"这张表单里找不到明细表「{table_key}」,本脚本不敢乱配"
|
||
"(要看这张单有哪些表,用 --show 配合改 --table)")
|
||
|
||
|
||
def patch_table(table: dict, pick: str, amount: str) -> tuple[list[str], bool]:
|
||
"""该有的列补齐 + 挂额度配置,返回 (动了哪几处, 是否新建了选台账那一列)。"""
|
||
done: list[str] = []
|
||
created_pick = False
|
||
columns = table.setdefault("columns", [])
|
||
|
||
def at(key: str) -> int:
|
||
return next((index for index, item in enumerate(columns)
|
||
if str(item.get("key") or "") == key), -1)
|
||
|
||
if at(pick) < 0:
|
||
columns.insert(max(at(amount), 0), {"key": pick, "label": "备用金单号", "type": "select",
|
||
"required": True, "span": 3})
|
||
created_pick = True
|
||
done.append("补了「备用金单号」列:填报时从额度台账里选(这张单原来没有这一列)")
|
||
elif columns[at(pick)].get("type") != "select":
|
||
columns[at(pick)]["type"] = "select"
|
||
done.append("「备用金单号」改成下拉选台账(选项由额度台账供,不用配字典)")
|
||
|
||
if at(amount) < 0:
|
||
columns.append({"key": amount, "label": "本次冲销金额", "type": "money",
|
||
"required": True, "span": 2, "min": 0})
|
||
done.append("补了「本次冲销金额」列:只有这一列的钱才真扣到台账上")
|
||
|
||
total = ROW_SHOW["total"]
|
||
if at(total) < 0:
|
||
columns.insert(max(at(amount), 0), {"key": total, "label": ROW_TOTAL[0], "type": "money",
|
||
"readonly": True, "span": ROW_TOTAL[1], "min": 0})
|
||
done.append(f"补了「{ROW_TOTAL[0]}」列(后端按台账写)")
|
||
elif not columns[at(total)].get("readonly"):
|
||
columns[at(total)]["readonly"] = True
|
||
done.append(f"「{ROW_TOTAL[0]}」设为只读:以台账为准,人手改不动")
|
||
|
||
for key, (label, span) in ROW_COLUMNS.items():
|
||
if at(key) >= 0:
|
||
columns[at(key)]["readonly"] = True
|
||
continue
|
||
columns.insert(max(at(amount), 0), {"key": key, "label": label, "type": "money",
|
||
"readonly": True, "span": span, "min": 0})
|
||
done.append(f"补了「{label}」列(后端写,前端改不动)")
|
||
|
||
table["quota"] = quota_config(pick, amount)
|
||
done.append(f"挂上额度控制:{QUOTA_CODE} 逐行冲(一行一笔,同一笔的多行合起来算)")
|
||
return done, created_pick
|
||
|
||
|
||
PICK_HINT = (" 注意:「备用金单号」是新加的列,之前填过的冲销明细行里没有它。"
|
||
"配完之后那些行再次提交会被挡(填了本次金额却没选台账),要么补选要么删行。")
|
||
|
||
|
||
def patch_header(fields: list[dict], table_key: str) -> list[str]:
|
||
"""表头那三格:这张单在这几笔备用金上的合计。"""
|
||
done: list[str] = []
|
||
known = {str(item.get("key") or "") for item in fields}
|
||
at = next(index for index, item in enumerate(fields) if str(item.get("key") or "") == table_key)
|
||
for offset, (key, (label, span)) in enumerate(HEAD_COLUMNS.items(), start=1):
|
||
if key in known:
|
||
continue
|
||
fields.insert(at + offset, {"key": key, "label": label, "type": "money", "readonly": True,
|
||
"span": span})
|
||
done.append(f"表头补了「{label}」")
|
||
return done
|
||
|
||
|
||
def validate(token: str, form: dict, fields: list[dict]) -> dict:
|
||
"""过一遍后端那道设计期闸门:配歪了当场说,别等发起人点提交才发现根本没生效。"""
|
||
content = dict(form.get("content") or {}, fields=fields)
|
||
problems = ok("POST", "/process/forms/validate", token, {"content": content}).get("problems", [])
|
||
if problems:
|
||
raise SystemExit("这样存会被后端挡下来:" + ";".join(problems))
|
||
return content
|
||
|
||
|
||
def save(token: str, form: dict, fields: list[dict]) -> None:
|
||
ok("PUT", f"/process/forms/{form['id']}", token,
|
||
{"name": form["name"], "description": form.get("description") or "",
|
||
"content": validate(token, form, fields)})
|
||
|
||
|
||
def check(token: str, opts: argparse.Namespace) -> None:
|
||
"""干跑:只读表单 + 过后端校验,一句库都不写。"""
|
||
print("=== 备用金多选冲销(干跑,不落库)===")
|
||
defs = {row["code"]: row for row in ok("GET", "/design/quotas/defs", token)}
|
||
print(f" 额度定义 {QUOTA_CODE}:{'已存在' if QUOTA_CODE in defs else '还没有,正式配时按备用金那份建'}")
|
||
form = find_form(token, opts.form)
|
||
fields = fields_of(form)
|
||
done, created_pick = patch_table(table_field(fields, opts.table), opts.pick, opts.amount)
|
||
done += patch_header(fields, opts.table)
|
||
if QUOTA_CODE not in defs:
|
||
# 定义还没有时后端必然报「额度定义不存在」,那不是配置配歪了,别拿它吓人
|
||
for line in done:
|
||
print(f" - {line}")
|
||
print(" 额度定义还没建,正式配时先按备用金那份建出来再存,这里跳过后端校验。")
|
||
if created_pick:
|
||
print(PICK_HINT)
|
||
return
|
||
validate(token, form, fields)
|
||
for line in done:
|
||
print(f" - {line}")
|
||
print(" 后端校验通过。要真配上去掉 --check 再跑一次。")
|
||
if created_pick:
|
||
print(PICK_HINT)
|
||
|
||
|
||
def apply_config(token: str, opts: argparse.Namespace) -> None:
|
||
print("=== 备用金多选冲销 ===")
|
||
ensure_def(token)
|
||
form = find_form(token, opts.form)
|
||
fields = fields_of(form)
|
||
done, created_pick = patch_table(table_field(fields, opts.table), opts.pick, opts.amount)
|
||
done += patch_header(fields, opts.table)
|
||
save(token, form, fields)
|
||
for line in done:
|
||
print(f" - {line}")
|
||
print(f" 「{opts.form}」已保存:冲销明细里选备用金即可,一张单可填多行冲多笔。")
|
||
if created_pick:
|
||
print(PICK_HINT)
|
||
|
||
|
||
def revert(token: str, opts: argparse.Namespace) -> None:
|
||
print("=== 撤掉备用金额度控制 ===")
|
||
form = find_form(token, opts.form)
|
||
fields = fields_of(form)
|
||
table = table_field(fields, opts.table)
|
||
cfg = table.pop("quota", None)
|
||
if cfg:
|
||
print(f" - 摘掉「{opts.table}」上的额度控制")
|
||
# 选台账那一列是为额度才改成下拉的;摘了额度还留着下拉就成了「没选项也没字典」,
|
||
# 表单直接存不回去,所以按配置里记的列名退回文本列
|
||
rows = cfg.get("rows") if isinstance(cfg.get("rows"), dict) else {}
|
||
dims = rows.get("dims") if isinstance(rows.get("dims"), dict) else {}
|
||
picks = {str(value).strip() for value in dims.values() if str(value or "").strip()} or {opts.pick}
|
||
for column in table.get("columns") or []:
|
||
key = str(column.get("key") or "")
|
||
sourced = bool(str(column.get("dictCode") or "").strip()) or bool(column.get("options"))
|
||
if key in picks and str(column.get("type") or "") == "select" and not sourced:
|
||
column["type"] = "text"
|
||
print(f" - 列「{column.get('label') or key}」退回文本填写")
|
||
else:
|
||
print(" 本来就没挂额度控制,没动")
|
||
for key in HEAD_SHOW.values():
|
||
if any(str(item.get("key") or "") == key for item in fields):
|
||
fields = [item for item in fields if str(item.get("key") or "") != key]
|
||
print(f" - 移除表头「{HEAD_COLUMNS[key][0]}」")
|
||
save(token, form, fields)
|
||
print(" 明细表回到手填。多出来的金额列留着(历史单据里存过值),台账与流水一分不动。")
|
||
|
||
|
||
def show(token: str, opts: argparse.Namespace) -> None:
|
||
form = find_form(token, opts.form)
|
||
table = table_field(fields_of(form), opts.table)
|
||
cfg = table.get("quota") or {}
|
||
print(f"「{opts.form}」的 {opts.table}.quota =")
|
||
print(json.dumps(cfg, ensure_ascii=False, indent=2) if cfg else " (没配)")
|
||
print(" 列:", "、".join(str(item.get("label") or item.get("key"))
|
||
for item in table.get("columns") or []))
|
||
|
||
|
||
def main() -> int:
|
||
parser = argparse.ArgumentParser(description=__doc__,
|
||
formatter_class=argparse.RawDescriptionHelpFormatter)
|
||
parser.add_argument("--form", default=FORM_NAME, help=f"目标表单名(默认 {FORM_NAME})")
|
||
parser.add_argument("--table", default=TABLE_KEY, help=f"冲销明细表字段名(默认 {TABLE_KEY})")
|
||
parser.add_argument("--pick", default=PICK_COLUMN, help="选台账那一列的列名")
|
||
parser.add_argument("--amount", default=AMOUNT_COLUMN, help="本次金额那一列的列名")
|
||
parser.add_argument("--check", action="store_true", help="干跑:看会改什么,不落库")
|
||
parser.add_argument("--revert", action="store_true", help="撤掉额度控制")
|
||
parser.add_argument("--show", action="store_true", help="只看现在的配置")
|
||
opts = parser.parse_args()
|
||
token = admin()
|
||
if opts.show:
|
||
show(token, opts)
|
||
elif opts.check:
|
||
check(token, opts)
|
||
elif opts.revert:
|
||
revert(token, opts)
|
||
else:
|
||
apply_config(token, opts)
|
||
return 0
|
||
|
||
|
||
if __name__ == "__main__":
|
||
raise SystemExit(main())
|