From e4c5493e4195952d16b46f28a69e9e98bde583fa Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期三, 25 八月 2021 10:38:10 +0800
Subject: [PATCH] 加入 添加流程
---
service-common/src/main/java/com/java110/common/bmo/workflow/impl/QueryWorkFlowFirstStaffBMOImpl.java | 28 ++++++++++++++++------------
1 files changed, 16 insertions(+), 12 deletions(-)
diff --git a/service-common/src/main/java/com/java110/common/bmo/workflow/impl/QueryWorkFlowFirstStaffBMOImpl.java b/service-common/src/main/java/com/java110/common/bmo/workflow/impl/QueryWorkFlowFirstStaffBMOImpl.java
index 491fd07..6a1419a 100755
--- a/service-common/src/main/java/com/java110/common/bmo/workflow/impl/QueryWorkFlowFirstStaffBMOImpl.java
+++ b/service-common/src/main/java/com/java110/common/bmo/workflow/impl/QueryWorkFlowFirstStaffBMOImpl.java
@@ -216,11 +216,6 @@
Assert.listOnlyOne(oaWorkflowFormDtos, "鏈缃〃鍗�");
//鏌ヨ琛ㄦ槸鍚﹀瓨鍦�
-// int count = oaWorkflowFormInnerServiceSMOImpl.hasTable(oaWorkflowFormDtos.get(0).getTableName());
-// if (count > 0) { // 宸茬粡閮ㄧ讲杩囦笉鐢ㄥ啀閮ㄧ讲
-// return;
-// }
-
String formJson = oaWorkflowFormDtos.get(0).getFormJson();
Assert.isJsonObject(formJson, "琛ㄥ崟璁捐鍑洪敊锛岃閲嶆柊璁捐");
@@ -232,6 +227,7 @@
StringBuffer sql = new StringBuffer("create table if not exists ");
sql.append(oaWorkflowFormDtos.get(0).getTableName());
sql.append(" (");
+ sql.append("id varchar(30) NOT NULL PRIMARY KEY COMMENT '涓婚敭ID',");
boolean isVarchar = false;
JSONObject validate = null;
for (int componentIndex = 0; componentIndex < components.size(); componentIndex++) {
@@ -281,7 +277,7 @@
sql.append(" not null ");
}
}
- if(!component.containsKey("validate") && isVarchar){
+ if (!component.containsKey("validate") && isVarchar) {
sql.append("(64) ");
}
@@ -289,12 +285,20 @@
sql.append(component.getString("label"));
sql.append("',");
}
- String sqlStr = sql.toString().substring(0,sql.toString().length()-1) + ")";
- logger.debug("閮ㄧ讲琛ㄥ崟sql" + sqlStr);
- int count = oaWorkflowFormInnerServiceSMOImpl.createTable(sqlStr);
- if (count < 1) { // 宸茬粡閮ㄧ讲杩囦笉鐢ㄥ啀閮ㄧ讲
- throw new IllegalArgumentException("閮ㄧ讲琛ㄥ崟澶辫触");
- }
+ sql.append("store_id varchar(30) not null COMMENT '鍟嗘埛ID',");
+ sql.append("create_user_id varchar(30) not null COMMENT '鍒涘缓浜篒D',");
+ sql.append("create_user_name varchar(64) not null COMMENT '鍒涘缓浜�',");
+ sql.append("state varchar(12) not null COMMENT '鐘舵�� 1001 鐢宠 1002 寰呭鏍� 1003 閫�鍥� 1004 濮旀墭 1005 鍔炵粨',");
+ sql.append("create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',");
+ sql.append("status_cd varchar(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥'");
+ sql.append(")");
+ logger.debug("閮ㄧ讲琛ㄥ崟sql" + sql.toString());
+ oaWorkflowFormInnerServiceSMOImpl.createTable(sql.toString());
+
+// int count = oaWorkflowFormInnerServiceSMOImpl.createTable(sqlStr);
+// if (count < 1) { // 宸茬粡閮ㄧ讲杩囦笉鐢ㄥ啀閮ㄧ讲
+// throw new IllegalArgumentException("閮ㄧ讲琛ㄥ崟澶辫触");
+// }
}
@Override
--
Gitblit v1.8.0