From 1090ecbbc2d88cc577324710017a4d332a4dd714 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期三, 22 九月 2021 18:13:00 +0800 Subject: [PATCH] 2021-09-22 --- src/templates/sharecomponent/settingcomponent/settingform/utils.jsx | 31 +++++++++++++++++++++++++++++-- 1 files changed, 29 insertions(+), 2 deletions(-) diff --git a/src/templates/sharecomponent/settingcomponent/settingform/utils.jsx b/src/templates/sharecomponent/settingcomponent/settingform/utils.jsx index 3b8c1e9..4514dca 100644 --- a/src/templates/sharecomponent/settingcomponent/settingform/utils.jsx +++ b/src/templates/sharecomponent/settingcomponent/settingform/utils.jsx @@ -39,8 +39,11 @@ _customScript = _customScript.replace(/@\$|\$@/ig, '') _dataresource = _dataresource.replace(/@select\$|\$select@/ig, '') _customScript = _customScript.replace(/@select\$|\$select@/ig, '') - _dataresource = _dataresource.replace(/@sum\$|\$sum@/ig, '') + // _dataresource = _dataresource.replace(/@sum\$|\$sum@/ig, '') _customScript = _customScript.replace(/@sum\$|\$sum@/ig, '') + + _dataresource = _dataresource.replace(/\$sum@/ig, '/*$sum@') + _dataresource = _dataresource.replace(/@sum\$/ig, '@sum$*/') // 澶栬仈鏁版嵁搴撴浛鎹� if (window.GLOB.externalDatabase !== null) { @@ -97,6 +100,25 @@ }) } + let sumSql = '' + + if (arr_field && _dataresource && /\/\*\$sum@/ig.test(_dataresource)) { + let _sql = _dataresource.replace(/\/\*\$sum@|@sum\$\*\//ig, '') + _sql = `${_sql} ${_search}` + if (_customScript) { + sumSql = `/* sql sum楠岃瘉 */ + ${_customScript} + ${_sql} + aaa: + if @ErrorCode!='' + insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@ + ` + } else { + sumSql = `/* sql sum楠岃瘉 */ + ${_sql}` + } + } + // 鏁版嵁婧愬鐞�, 瀛樺湪鏄剧ず鍒楁椂 if (arr_field && _dataresource) { if (/\s/.test(_dataresource)) { @@ -121,7 +143,12 @@ sql = sql.replace(/\n\s{8}/ig, '\n') console.info(sql) - return sql + if (sumSql) { + sumSql = sumSql.replace(/\n\s{10}/ig, '\n') + console.info(sumSql) + } + + return { sql, sumSql } } /** -- Gitblit v1.8.0