unis-oa/backend/scripts/advance_offset.py

279 lines
14 KiB
Python
Raw Permalink Blame History

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

#!/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())