From bc5ec1017fd8a140ec5c30ea9e8ea839d5bf1bda Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期二, 15 十二月 2020 16:22:20 +0800
Subject: [PATCH] 2020-12-15
---
src/templates/sharecomponent/settingcalcomponent/verifycard/utils.jsx | 44 ++++++++++++++++++++++++++------------------
1 files changed, 26 insertions(+), 18 deletions(-)
diff --git a/src/templates/sharecomponent/settingcalcomponent/verifycard/utils.jsx b/src/templates/sharecomponent/settingcalcomponent/verifycard/utils.jsx
index dd9ef88..3c4d069 100644
--- a/src/templates/sharecomponent/settingcalcomponent/verifycard/utils.jsx
+++ b/src/templates/sharecomponent/settingcalcomponent/verifycard/utils.jsx
@@ -7,7 +7,7 @@
* @return {Object} setting 椤甸潰璁剧疆
* @return {Array} columns 鏄剧ず瀛楁
*/
- static getDebugSql (setting, scripts, columns, searches) {
+ static getDebugSql (setting, scripts, columns, searches, calendar) {
let sql = ''
let _dataresource = ''
let _customScript = ''
@@ -39,27 +39,31 @@
}
// 姝ｅ垯鏇挎崲
- let _regoptions = searches.map(item => {
- return {
- reg: new RegExp('@' + item.key + '@', 'ig'),
- value: `'${item.value}'`
- }
- })
+ let _regoptions = []
let _search = ''
- // 鏃ュ巻涓殑骞翠唤鏇挎崲
if (setting.queryType === 'statistics' || _customScript) {
- _regoptions.push({
- reg: new RegExp('@calendarDate@', 'ig'),
- value: `1970-01-01 00:00:00.000`
- })
- _regoptions.push({
- reg: new RegExp('@calendarDate1@', 'ig'),
- value: `2030-12-31 23:59:59.999`
+ _regoptions = searches.map(item => {
+ return {
+ reg: new RegExp('@' + item.key + '@', 'ig'),
+ value: `'0'`
+ }
})
}
- if (setting.queryType === 'statistics' && _dataresource) {
+ // 鏃ュ巻涓殑骞翠唤鏇挎崲
+ if (calendar.refresh === 'true') {
+ _regoptions.push({
+ reg: new RegExp('@calendarDate@', 'ig'),
+ value: `'1970-01-01 00:00:00.000'`
+ })
+ _regoptions.push({
+ reg: new RegExp('@calendarDate1@', 'ig'),
+ value: `'2030-12-31 23:59:59.999'`
+ })
+ }
+
+ if ((setting.queryType === 'statistics' || calendar.refresh === 'true') && _dataresource) {
_regoptions.forEach(item => {
_dataresource = _dataresource.replace(item.reg, item.value)
})
@@ -96,15 +100,19 @@
}
if (_customScript) {
- sql = `${_customScript}
+ sql = `/* sql 楠岃瘉 */
+ ${_customScript}
${_dataresource}
aaa:
if @ErrorCode!=''
insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@
`
} else {
- sql = _dataresource
+ sql = `/* sql 楠岃瘉 */
+ ${_dataresource}`
}
+ sql = sql.replace(/\n\s{8}/ig, '\n')
+ console.info(sql)
return sql
}
--
Gitblit v1.8.0