From 3ca91a731665962918a026f521c556f4745ebf35 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期一, 16 十一月 2020 19:20:19 +0800 Subject: [PATCH] 2020-11-16 --- src/utils/utils.js | 10 +++++++++- 1 files changed, 9 insertions(+), 1 deletions(-) diff --git a/src/utils/utils.js b/src/utils/utils.js index 02e850e..8df4de7 100644 --- a/src/utils/utils.js +++ b/src/utils/utils.js @@ -163,6 +163,10 @@ }) // 鏇挎崲%绗︼紙鏁版嵁搴撲腑瑙f瀽鍚巗ql鎶ラ敊锛� value = value.replace(/%/ig, ' mpercent ') + // 澶栬仈鏁版嵁搴撴浛鎹� + if (window.GLOB.externalDatabase !== null) { + value = value.replace(/@db@/ig, `[${window.GLOB.externalDatabase}]..`) + } // encode缂栫爜锛堜腑鏂囧瓧绗﹁秴鍑篵ase64鍔犲瘑鑼冨洿锛� value = window.btoa(window.encodeURIComponent(value)) // 鎻掑叆瀛楃 @@ -230,6 +234,10 @@ // 1銆佹浛鎹�%绗︼紙鏁版嵁搴撲腑瑙f瀽鍚巗ql鎶ラ敊锛� value = value.replace(/%/ig, ' mpercent ') + // 澶栬仈鏁版嵁搴撴浛鎹� + if (window.GLOB.externalDatabase !== null) { + value = value.replace(/@db@/ig, `[${window.GLOB.externalDatabase}]..`) + } let encodesql = (val) => { if (!val) return '' @@ -689,7 +697,7 @@ if (item.orderBy) { sql = `select ${item.type === 'checkcard' ? 'top 20' : ''} ${arrfield} from (select distinct ${arrfield},${item.orderBy} as orderfield from ${_datasource} ) a order by orderfield ${item.orderType}` } else { - sql = `select ${item.type === 'checkcard' ? 'top 20' : ''} ${arrfield} from (select distinct ${arrfield} from ${_datasource})` + sql = `select ${item.type === 'checkcard' ? 'top 20' : ''} ${arrfield} from (select distinct ${arrfield} from ${_datasource}) a` } return { -- Gitblit v1.8.0