From c19de84fa332a00c651f28e3a52292fd14f143a1 Mon Sep 17 00:00:00 2001 From: liurunyu <lry9898@163.com> Date: 星期二, 23 九月 2025 17:30:07 +0800 Subject: [PATCH] 陆常丽反应软件系统财务对账时而数据不准确,分析源码,找到bug原因是,财务对账统计只有用户点击后才会触发统计功能,把历史上及当天进行了统计,如果当天统计时未下班,例如是中午触发统计了,而下午又进行了充值售水,但下班后未再点击触发对账统计,那么今天的对账统计完成了但数据不对。编写自动任务,在下半夜进行对账统计。 --- pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_power.sql | 11 +++++++++++ 1 files changed, 11 insertions(+), 0 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_power.sql b/pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_power.sql new file mode 100644 index 0000000..3a72530 --- /dev/null +++ b/pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_power.sql @@ -0,0 +1,11 @@ +-- auto Generated on 2023-10-21 +-- DROP TABLE IF EXISTS ba_power; +CREATE TABLE ba_power( + id BIGINT (15) UNIQUE NOT NULL AUTO_INCREMENT COMMENT 'id', + num INT (11) NOT NULL DEFAULT -1 COMMENT '鏉冮檺缂栧彿', + `name` VARCHAR (50) NOT NULL DEFAULT '' COMMENT '鏉冮檺鍚嶇О', + `type` VARCHAR (50) NOT NULL DEFAULT '' COMMENT '鏉冮檺绫诲埆', + PRIMARY KEY (id) +)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT 'ba_power'; + +ALTER TABLE ba_privilege COMMENT '鏉冮檺琛�'; \ No newline at end of file -- Gitblit v1.8.0