From 9bb9952db0b22034b4aea1f486df827d77a03031 Mon Sep 17 00:00:00 2001 From: cloudroam <cloudroam> Date: 星期四, 17 十月 2024 14:41:35 +0800 Subject: [PATCH] add:销售合计统计运费+打包费;售后扣平台款字段,增加增加统计售后“打包运费(散户)”字段 --- src/main/resources/script/db.sql | 6 ++++++ 1 files changed, 6 insertions(+), 0 deletions(-) diff --git a/src/main/resources/script/db.sql b/src/main/resources/script/db.sql index 7023286..4f84f97 100644 --- a/src/main/resources/script/db.sql +++ b/src/main/resources/script/db.sql @@ -104,3 +104,9 @@ INSERT INTO t_code_value(ID,TYPE_CODE,VALUE,LABEL,DESCRIPTION,SEQ,STATUS) VALUES ('CHECK_AUDIT_STATUS_REJECTED','CHECK_AUDIT_STATUS','REJECTED','已拒绝','已拒绝',2,'A'); +==================================================20240826 +delete from t_code_value where type_code = 'SETTLEMENT_STATUS'; +INSERT INTO t_code_value(ID,TYPE_CODE,VALUE,LABEL,DESCRIPTION,SEQ,STATUS) VALUES ('SETTLEMENT_STATUS_PENDING','SETTLEMENT_STATUS','PENDING','待结算','待结算',1,'A'); +INSERT INTO t_code_value(ID,TYPE_CODE,VALUE,LABEL,DESCRIPTION,SEQ,STATUS) VALUES ('SETTLEMENT_STATUS_PROCESSING','SETTLEMENT_STATUS','PROCESSING','结算中','结算中',2,'A'); +INSERT INTO t_code_value(ID,TYPE_CODE,VALUE,LABEL,DESCRIPTION,SEQ,STATUS) VALUES ('SETTLEMENT_STATUS_FAILED','SETTLEMENT_STATUS','FAILED','结算失败','结算失败',3,'A'); +INSERT INTO t_code_value(ID,TYPE_CODE,VALUE,LABEL,DESCRIPTION,SEQ,STATUS) VALUES ('SETTLEMENT_STATUS_COMPLETED','SETTLEMENT_STATUS','COMPLETED','结算成功','结算成功',4,'A'); \ No newline at end of file -- Gitblit v1.9.3