From f6dbdd98a13296455b8efc5dadd6e9e4eaa63693 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期一, 11 九月 2023 18:04:37 +0800
Subject: [PATCH] 2023-09-11
---
src/menu/datasource/verifycard/settingform/index.jsx | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/menu/datasource/verifycard/settingform/index.jsx b/src/menu/datasource/verifycard/settingform/index.jsx
index 3255937..e0ae04b 100644
--- a/src/menu/datasource/verifycard/settingform/index.jsx
+++ b/src/menu/datasource/verifycard/settingform/index.jsx
@@ -183,7 +183,7 @@
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 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
--
Gitblit v1.8.0