From 5fc2fc57afc63a906ec5567e91aeab72d20aab7d Mon Sep 17 00:00:00 2001
From: Your Name <you@example.com>
Date: 星期一, 16 一月 2023 23:17:50 +0800
Subject: [PATCH] 优化代码

---
 service-common/src/main/java/com/java110/common/bmo/workflow/impl/QueryWorkFlowFirstStaffBMOImpl.java |   48 ++++++++++++++++++++++++++++++------------------
 1 files changed, 30 insertions(+), 18 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 c4458b3..56d8f5c 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
@@ -10,20 +10,23 @@
 import com.java110.common.dao.IWorkflowStepStaffServiceDao;
 import com.java110.core.annotation.Java110Transactional;
 import com.java110.core.factory.GenerateCodeFactory;
+import com.java110.core.log.LoggerFactory;
 import com.java110.dto.oaWorkflow.OaWorkflowDto;
 import com.java110.dto.oaWorkflowForm.OaWorkflowFormDto;
 import com.java110.dto.oaWorkflowXml.OaWorkflowXmlDto;
 import com.java110.dto.org.OrgDto;
+import com.java110.dto.org.OrgStaffRelDto;
 import com.java110.dto.workflow.WorkflowDto;
 import com.java110.dto.workflow.WorkflowModelDto;
 import com.java110.intf.oa.IOaWorkflowFormInnerServiceSMO;
 import com.java110.intf.oa.IOaWorkflowInnerServiceSMO;
 import com.java110.intf.oa.IOaWorkflowXmlInnerServiceSMO;
+import com.java110.intf.store.IOrgStaffRelV1InnerServiceSMO;
 import com.java110.intf.user.IOrgInnerServiceSMO;
 import com.java110.po.oaWorkflow.OaWorkflowPo;
 import com.java110.po.oaWorkflowXml.OaWorkflowXmlPo;
+import com.java110.utils.exception.CmdException;
 import com.java110.utils.util.Assert;
-import com.java110.utils.util.Base64Convert;
 import com.java110.utils.util.BeanConvertUtil;
 import com.java110.utils.util.StringUtil;
 import com.java110.vo.ResultVo;
@@ -43,7 +46,6 @@
 import org.dom4j.DocumentHelper;
 import org.dom4j.Element;
 import org.slf4j.Logger;
-import org.slf4j.LoggerFactory;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.http.ResponseEntity;
 import org.springframework.stereotype.Service;
@@ -80,6 +82,9 @@
     private IOaWorkflowFormInnerServiceSMO oaWorkflowFormInnerServiceSMOImpl;
 
     @Autowired
+    private IOrgStaffRelV1InnerServiceSMO orgStaffRelV1InnerServiceSMOImpl;
+
+    @Autowired
     private RepositoryService repositoryService;
 
     @Autowired
@@ -98,7 +103,7 @@
         List<Map> workflows = workflowServiceDaoImpl.getWorkflowInfo(BeanConvertUtil.beanCovertMap(workflowDto));
 
         if (workflows == null || workflows.size() < 1) {
-            return null;
+            return ResultVo.createResponseEntity(ResultVo.CODE_ERROR, "鏈煡璇㈠埌娴佺▼");
         }
 
         WorkflowDto tmpWorkflowDto = BeanConvertUtil.covertBean(workflows.get(0), WorkflowDto.class);
@@ -129,17 +134,20 @@
         }
 
         Map staffInfo = workflowStepStaffs.get(0);
+        String staffId = staffInfo.get("staffId") + "";
+        OrgStaffRelDto orgDto = new OrgStaffRelDto();
+        if (staffId.startsWith("${")) {
+            return ResultVo.createResponseEntity(orgDto);
+        }
+        orgDto.setStaffId(staffId);
 
-        OrgDto orgDto = new OrgDto();
-        orgDto.setStaffId(staffInfo.get("staffId") + "");
-
-        List<OrgDto> orgDtos = orgInnerServiceSMOImpl.queryOrgs(orgDto);
-
-        if (orgDtos == null || orgDtos.size() < 1) {
+        OrgStaffRelDto orgStaffRelDto = new OrgStaffRelDto();
+        orgStaffRelDto.setStaffId(staffId);
+        List<OrgStaffRelDto> orgStaffRelDtos = orgStaffRelV1InnerServiceSMOImpl.queryStaffOrgNames(orgStaffRelDto);
+        if (orgStaffRelDtos == null || orgStaffRelDtos.size() < 1) {
             return ResultVo.createResponseEntity(ResultVo.CODE_ERROR, "鏈煡璇㈠埌鍛樺伐缁勭粐淇℃伅");
         }
-
-        orgDto = orgDtos.get(0);
+        orgDto = orgStaffRelDtos.get(0);
         orgDto.setStaffName(staffInfo.get("staffName") + "");
 
         return ResultVo.createResponseEntity(orgDto);
@@ -156,17 +164,20 @@
 
         Assert.listOnlyOne(oaWorkflowDtos, "鏈寘鍚祦绋�");
 
-        //琛ㄥ崟 閮ㄧ讲
-        deployForm(oaWorkflowDtos.get(0));
+        //鏅�氭祦绋嬮渶瑕侀儴缃� 琛ㄥ崟 鍏朵粬绫诲瀷涓嶉渶瑕侀儴缃�
+        if(OaWorkflowDto.FLOW_TYPE_PUBLIC.equals(oaWorkflowDtos.get(0).getFlowType())) {
+            //琛ㄥ崟 閮ㄧ讲
+            deployForm(oaWorkflowDtos.get(0));
+        }
 
         String deploymentid = "";
         try {
             Model modelData = repositoryService.getModel(workflowModelDto.getModelId());
             byte[] bpmnBytes = null;
             bpmnBytes = repositoryService.getModelEditorSource(workflowModelDto.getModelId());
-            String encoded = Base64Convert.byteToBase64(bpmnBytes);
-            byte[] decoded = Base64Convert.base64ToByte(encoded);
-            String xml = new String(decoded);
+            if(bpmnBytes == null || bpmnBytes.length< 1){
+                throw new CmdException("鏈缃祦绋�");
+            }
             String processName = modelData.getName() + ".bpmn20.xml";
             ByteArrayInputStream in = new ByteArrayInputStream(bpmnBytes);
             Deployment deployment = repositoryService.createDeployment().name(oaWorkflowDtos.get(0).getFlowName())
@@ -180,6 +191,7 @@
                 .createProcessDefinitionQuery()
                 .deploymentId(deploymentid)
                 .singleResult();
+
         //鏇存柊閮ㄩ棬娴佺▼鍏崇郴琛�
         workflowModelDto.setDeploymentId(deploymentid);
 
@@ -258,7 +270,7 @@
                 sql.append(" varchar");
                 isVarchar = true;
             } else if ("textarea".equals(component.getString("type"))) {
-                sql.append(" longtext");
+                sql.append(" longtext CHARACTER SET utf8");
             } else if ("textdate".equals(component.getString("type"))) {
                 sql.append(" date");
             } else if ("textdatetime".equals(component.getString("type"))) {
@@ -295,7 +307,7 @@
         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(")");
+        sql.append(") DEFAULT CHARSET=utf8");
         logger.debug("閮ㄧ讲琛ㄥ崟sql" + sql.toString());
         oaWorkflowFormInnerServiceSMOImpl.createTable(sql.toString());
 

--
Gitblit v1.8.0