From f561deb896de5754d94d17447f3d87aedcbd3198 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期一, 18 九月 2023 20:02:38 +0800
Subject: [PATCH] Merge branch 'positec' into bms

---
 src/menu/datasource/verifycard/settingform/index.jsx |    5 ++++-
 1 files changed, 4 insertions(+), 1 deletions(-)

diff --git a/src/menu/datasource/verifycard/settingform/index.jsx b/src/menu/datasource/verifycard/settingform/index.jsx
index 3255937..612259d 100644
--- a/src/menu/datasource/verifycard/settingform/index.jsx
+++ b/src/menu/datasource/verifycard/settingform/index.jsx
@@ -16,6 +16,7 @@
 class SettingForm extends Component {
   static propTpyes = {
     updateStatus: PropTypes.func,
+    addProcess: PropTypes.func,
     config: PropTypes.object,     // 缁勪欢閰嶇疆
     setting: PropTypes.object,    // 鏁版嵁婧愰厤缃�
     columns: PropTypes.array,     // 鍒楄缃�
@@ -183,11 +184,13 @@
   addProcess = () => {
     let _sql = this.props.form.getFieldValue('dataresource')
 
-    _sql = _sql + `\n/* select a.*,case when isnull(w.remark,'')='' then a.remark else w.remark end as remark_w,case when isnull(w.statusname,'')='' then a.statusname else w.statusname end as statusname_w,w.status as status_w  from 鏁版嵁婧� a left join (select * from  s_my_works_flow  where works_flow_code='娴佺▼缂栫爜' and deleted=0) w on a.id=w.works_flow_id where  isnull(w.status,0)=0 */`
+    _sql = _sql + `\n/* select a.*,w.remark as remark_w,w.statusname as statusname_w,w.status as status_w,w.works_flow_param from (鏁版嵁婧�) a inner join (select * from  s_my_works_flow  where works_flow_code=@works_flow_code@ and status=0 and deleted=0) w on a.id=w.works_flow_id */`
 
     this.props.form.setFieldsValue({
       dataresource: _sql
     })
+
+    this.props.addProcess()
   }
 
   render() {

--
Gitblit v1.8.0