fix:sql调整

xusd

2 days ago 067afa6387c75cc94d79ec9db9544a0b9db437a4

 dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/service/CaseTaskService.java

@@ -417,7 +417,7 @@
                            || FlowNodeEnum.FLOW_NODE_QJ_DFP.getIndex().equals(caseTask.getNodeId())
                            || FlowNodeEnum.FLOW_NODE_SJ_DFP.getIndex().equals(caseTask.getNodeId())) {
                        tabList.add(sqjl);

                        tabList.add(lcdb);
                        sl.setName("自行受理");
                        buttonList.add(sl);
                        buttonList.add(jb);
@@ -460,7 +460,7 @@
                            || FlowNodeEnum.FLOW_NODE_QJ_DSL.getIndex().equals(caseTask.getNodeId())
                            || FlowNodeEnum.FLOW_NODE_SJ_DSL.getIndex().equals(caseTask.getNodeId())) {
                        tabList.add(sqjl);

                        tabList.add(lcdb);
                        buttonList.add(sl);
                        buttonList.add(ht);
                        buttonList.add(xqcl);
@@ -542,7 +542,7 @@
                    // 联合处置-待受理
                    if (FlowNodeEnum.FLOW_NODE_DSL.getIndex().equals(caseTask.getNodeId())) {
                        tabList.add(sqjl);

                        tabList.add(lcdb);
                        buttonList.add(sl);
                        buttonList.add(ht);
                        buttonList.add(tabcl);
@@ -902,9 +902,28 @@
                                lfdjAssist.setNodeShowName("来访登记");
                                lfdjAssist.setHandleUserName(caseInfo.getInputUserName());
                                lfdjAssist.setHandleUnitName(caseInfo.getInputUnitName());
                            } else {
                            }
                            if (CaseBaseConstsEnum.CASE_CANAL_2.getIndex().equals(caseInfo.getCanal())) {
                                lfdjAssist.setNodeShowName(caseInfo.getCanalName());
                                lfdjAssist.setHandleUnitName(caseInfo.getInputUserName() + "（当事人）");
                            }
                            if (CaseBaseConstsEnum.CASE_CANAL_3.getIndex().equals(caseInfo.getCanal())) {
                                lfdjAssist.setNodeShowName("自行排查");
                                lfdjAssist.setHandleUserName(caseInfo.getInputUserName());
                                lfdjAssist.setHandleUnitName(caseInfo.getInputUnitName());
                                if (CaseBaseConstsEnum.CASE_CANAL_SECOND_2.getIndex().equals(caseInfo.getCanalSecond())) {
                                    lfdjAssist.setHandleUserName("系统自动获取");
                                    lfdjAssist.setHandleUnitName(caseInfo.getCanalSecondName());
                                }
                                if (CaseBaseConstsEnum.CASE_CANAL_SECOND_7.getIndex().equals(caseInfo.getCanalSecond())) {
                                    lfdjAssist.setHandleUserName("系统自动获取");
                                    lfdjAssist.setHandleUnitName(caseInfo.getCanalSecondName());
                                }
                            }
                            if (CaseBaseConstsEnum.CASE_CANAL_4.getIndex().equals(caseInfo.getCanal())) {
                                lfdjAssist.setNodeShowName("协同推送");
                                lfdjAssist.setHandleUserName("系统自动获取");
                                lfdjAssist.setHandleUnitName(caseInfo.getCanalSecondName());
                            }
                            lfdjAssist.setTaskType(SHOW_TASK_TYPE_1);
                            lfdjAssist.setStatus(CaseTaskConsts.TASK_STATUS_2);
@@ -1067,7 +1086,7 @@
                                            || caseTask.getNodeId().equals(FlowNodeEnum.FLOW_NODE_ZJ_DFP.getIndex())
                                            || caseTask.getNodeId().equals(FlowNodeEnum.FLOW_NODE_QJ_DFP.getIndex())
                                            || caseTask.getNodeId().equals(FlowNodeEnum.FLOW_NODE_SJ_DFP.getIndex())) {
                                        webCaseFlowDTO.setStatusName("待受理");
                                        webCaseFlowDTO.setStatusName("待分派");
                                    }
                                    // 受理节点
                                    if (caseTask.getNodeId().equals(FlowNodeEnum.FLOW_NODE_DSL.getIndex())