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_test.sql | 33 +++++++++++++++++++++++++++++++++ 1 files changed, 33 insertions(+), 0 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_test.sql b/pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_test.sql new file mode 100644 index 0000000..8cfb169 --- /dev/null +++ b/pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_test.sql @@ -0,0 +1,33 @@ +/* + Navicat Premium Data Transfer + + Source Server : 鏈満mysql8.0.34 + Source Server Type : MySQL + Source Server Version : 80034 + Source Host : localhost:3306 + Source Schema : pipirr_ym + + Target Server Type : MySQL + Target Server Version : 80034 + File Encoding : 65001 + + Date: 18/10/2023 10:35:54 +*/ + +SET NAMES utf8mb4; +SET FOREIGN_KEY_CHECKS = 0; + +-- ---------------------------- +-- Table structure for ba_test +-- ---------------------------- +DROP TABLE IF EXISTS demo_test; +CREATE TABLE `ba_test` ( + `id` bigint NOT NULL, + `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, + `phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, + `nick_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, + `create_dt` varchar(19) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; + +SET FOREIGN_KEY_CHECKS = 1; -- Gitblit v1.8.0