From 3683e1475e8d74f690172a468518d88d91a69ccc Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期四, 20 八月 2020 20:15:48 +0800
Subject: [PATCH] 2020-08-20
---
src/api/index.js | 319 ++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 313 insertions(+), 6 deletions(-)
diff --git a/src/api/index.js b/src/api/index.js
index d917c41..ac8f0f2 100644
--- a/src/api/index.js
+++ b/src/api/index.js
@@ -6,6 +6,37 @@
import Utils from '@/utils/utils.js'
import options from '@/store/options.js'
+let mkDataBase = null
+let storUsable = false
+
+if (window.openDatabase) {
+ let service = window.GLOB.service ? '-' + window.GLOB.service.replace('/', '') : ''
+ try {
+ mkDataBase = openDatabase(`mkdb${service}`, '1', 'mk-pc-database', 50 * 1024 * 1024)
+ mkDataBase.transaction(tx => {
+ tx.executeSql('CREATE TABLE IF NOT EXISTS VERSIONS (version varchar(50), createDate varchar(50), CDefine1 varchar(50), CDefine2 varchar(50), CDefine3 varchar(50))', [], () => {
+
+ }, () => {
+ // eslint-disable-next-line
+ throw 'CREATE TABLE ERROR'
+ })
+ tx.executeSql('CREATE TABLE IF NOT EXISTS CONFIGS (menuid varchar(50), userid varchar(50), openEdition varchar(50), webEdition varchar(50), LongParam text, LongParamUser text, CDefine1 varchar(50), CDefine2 varchar(50), CDefine3 varchar(50), CDefine4 varchar(50), CDefine5 varchar(50))', [], () => {
+
+ }, () => {
+ // eslint-disable-next-line
+ throw 'CREATE TABLE ERROR'
+ })
+ })
+ // mkDataBase.transaction(tx => {
+ // tx.executeSql('DROP TABLE VERSIONS')
+ // tx.executeSql('DROP TABLE CONFIGS')
+ // })
+ } catch (e) {
+ console.warn(e)
+ mkDataBase = null
+ }
+}
+
axios.defaults.crossDomain = true
axios.defaults.headers.post['Content-Type'] = 'application/x-www-form-urlencoded;charset=UTF-8'
axios.defaults.withCredentials = true
@@ -199,6 +230,163 @@
}
/**
+ * @description 鑾峰彇绯荤粺鐗堟湰淇℃伅锛屽惎鐢ㄦ垨鏇存柊websql
+ */
+ getAppVersion (_resolve, _reject) {
+ let appVersion = {}
+
+ new Promise((resolve, reject) => {
+ if (!mkDataBase) {
+ reject()
+ } else {
+ mkDataBase.transaction(tx => {
+ if (!mkDataBase) {
+ reject()
+ return
+ }
+ tx.executeSql('SELECT * FROM VERSIONS', [], (tx, results) => {
+ if (results.rows.length === 0) {
+ tx.executeSql('DELETE FROM CONFIGS')
+ resolve({version: '', createDate: ''})
+ } else if (results.rows.length === 1) {
+ resolve(results.rows[0])
+ } else if (results.rows.length > 1) {
+ tx.executeSql('DELETE FROM VERSIONS')
+ tx.executeSql('DELETE FROM CONFIGS')
+ resolve({version: '', createDate: ''})
+ }
+ }, (tx, results) => {
+ reject()
+ console.warn(results)
+ })
+ })
+ }
+ }).then(msg => {
+ if (msg.version) {
+ appVersion.oldVersion = msg.version
+ }
+ let curTime = moment().format('YYYY-MM-DD HH:mm:ss') + '.000'
+
+ let param = {
+ func: 's_get_app_version',
+ modifydate: msg.createDate || curTime,
+ }
+
+ param.userid = sessionStorage.getItem('UserID') || ''
+ param.lang = localStorage.getItem('lang') || ''
+ param.SessionUid = localStorage.getItem('SessionUid') || ''
+ param.LoginUID = sessionStorage.getItem('LoginUID') || ''
+ param.appkey = window.GLOB.appkey || ''
+
+ if (window.GLOB.mainSystemApi) {
+ param.rduri = window.GLOB.mainSystemApi
+ }
+
+ param.nonc = Utils.getuuid()
+
+ let keys = Object.keys(param).sort()
+ let values = ''
+ keys.forEach(key => {
+ if (key === 'rduri' || key === 't') return
+ if (typeof(param[key]) === 'object') {
+ values += key + JSON.stringify(param[key])
+ } else {
+ values += key + param[key]
+ }
+ })
+ param.sign = md5(values)
+ param.t = new Date().getTime()
+
+ return new Promise((resolve, reject) => {
+ axios({
+ url: `/webapi/dostars${param.func ? '/' + param.func : ''}`,
+ data: param
+ }).then(res => {
+ if (!res.status) {
+ reject()
+ return
+ }
+ let version = res.app_version || '1.00'
+ appVersion.newVersion = version
+ appVersion.oldVersion = appVersion.oldVersion || version
+
+ mkDataBase.transaction(tx => {
+ if (res.menu_data && res.menu_data.length > 0) {
+ let keys = res.menu_data.map(mid => `'${mid.menuid}'`)
+ tx.executeSql(`DELETE FROM CONFIGS where menuid in (${keys.join(',')})`, [], () => {}, () => {
+ reject()
+ })
+ }
+ if (msg.version) {
+ tx.executeSql(`UPDATE VERSIONS SET createDate='${curTime}'`, [], () => {
+ resolve()
+ }, () => {
+ reject()
+ })
+ } else {
+ tx.executeSql('INSERT INTO VERSIONS (version, createDate) VALUES (?, ?)', [version, curTime], () => {
+ resolve()
+ }, () => {
+ reject()
+ })
+ }
+ })
+ })
+ })
+ }, () => {
+ _reject()
+ mkDataBase = null
+ return Promise.reject()
+ }).then(() => {
+ storUsable = true
+ _resolve(appVersion)
+ })
+ }
+
+ /**
+ * @description 鏇存柊绯荤粺鐗堟湰淇℃伅锛屾竻绌洪厤缃俊鎭�
+ */
+ updateAppVersion (newVersion) {
+ return new Promise(resolve => {
+ if (!mkDataBase) {
+ resolve({status: false})
+ return
+ }
+ let curTime = moment().format('YYYY-MM-DD HH:mm:ss') + '.000'
+
+ mkDataBase.transaction(tx => {
+ tx.executeSql(`DELETE FROM CONFIGS`, [], () => {}, () => {
+ resolve({status: false})
+ })
+ tx.executeSql(`UPDATE VERSIONS SET version='${newVersion}', createDate='${curTime}'`, [], () => {
+ resolve({status: true})
+ }, () => {
+ resolve({status: false})
+ })
+ })
+ })
+ }
+
+ /**
+ * @description 鍒犻櫎鏌愪釜鑿滃崟閰嶇疆淇℃伅
+ */
+ deleteMenuStorage (menuId) {
+ return new Promise(resolve => {
+ if (!mkDataBase) {
+ resolve()
+ return
+ }
+ mkDataBase.transaction(tx => {
+ tx.executeSql(`DELETE FROM CONFIGS where menuid='${menuId}'`, [], () => {
+ resolve()
+ }, () => {
+ mkDataBase = null
+ })
+ })
+ })
+ }
+
+ /**
* @description 鑾峰彇鎴栦慨鏀逛簯绔厤缃�
*/
getCloudConfig (param) {
@@ -311,30 +499,149 @@
}
/**
- * @description 鑾峰彇绯荤粺閰嶇疆锛屼紭鍏堜粠缂撳瓨涓彇鍊硷紝澧炲姞appkey
+ * @description 鑾峰彇绯荤粺閰嶇疆锛屽彇鍊间紭鍏堢瓑绾ebsql銆佺紦瀛樸�佹湇鍔″櫒
* @param {Object} param 璇锋眰鍙傛暟
- * @param {Boolean} SSO 鏄惁涓哄崟鐐圭櫥褰曞湴鍧�
*/
- getSystemCacheConfig (param, SSO = true) {
+ getCacheConfig (param) {
param.userid = sessionStorage.getItem('UserID') || ''
param.lang = localStorage.getItem('lang') || ''
param.SessionUid = localStorage.getItem('SessionUid') || ''
param.LoginUID = sessionStorage.getItem('LoginUID') || ''
param.appkey = window.GLOB.appkey || ''
- if (sessionStorage.getItem('isEditState') === 'true' && SSO) { // 缂栬緫鐘舵�侊紝鍗曠偣鐧诲綍鏈嶅姟鍣ㄤ负浜戠
+ if (sessionStorage.getItem('isEditState') === 'true') { // 缂栬緫鐘舵�侊紝鍗曠偣鐧诲綍鏈嶅姟鍣ㄤ负浜戠
if (options.cloudServiceApi) { // 瀛樺湪浜戠鍦板潃鏃讹紝浣跨敤浜戠绯荤粺鍙傛暟
param.rduri = options.cloudServiceApi
param.userid = sessionStorage.getItem('CloudUserID') || ''
param.LoginUID = sessionStorage.getItem('CloudLoginUID') || ''
}
- } else if (window.GLOB.mainSystemApi && SSO) {
+ } else if (window.GLOB.mainSystemApi) {
param.rduri = window.GLOB.mainSystemApi
}
let _param = JSON.parse(JSON.stringify(param)) // 缂撳瓨鏍￠獙锛屽幓闄ゆ椂闂村拰鍔犲瘑瀛楃
delete _param.timestamp
delete _param.secretkey
+ delete _param.open_key
+ _param = JSON.stringify(_param)
+ _param = md5(_param)
+
+ if (mkDataBase && storUsable) {
+ param.nonc = Utils.getuuid()
+
+ let keys = Object.keys(param).sort()
+ let values = ''
+ keys.forEach(key => {
+ if (key === 'rduri' || key === 't') return
+ if (typeof(param[key]) === 'object') {
+ values += key + JSON.stringify(param[key])
+ } else {
+ values += key + param[key]
+ }
+ })
+ param.sign = md5(values)
+ param.t = new Date().getTime()
+
+ return new Promise(resolve => {
+ mkDataBase.transaction(tx => {
+ tx.executeSql(`SELECT * FROM CONFIGS WHERE menuid='${param.MenuID}' and userid='${param.userid}'`, [], (tx, results) => {
+ let paramItem = results.rows[0]
+ if (paramItem) {
+ resolve({
+ ErrCode: 'S',
+ ErrMesg: '',
+ LongParam: paramItem.LongParam,
+ LongParamUser: paramItem.LongParamUser,
+ message: '',
+ open_edition: paramItem.openEdition,
+ status: true,
+ web_edition: paramItem.webEdition
+ })
+ } else {
+ axios({
+ url: `/webapi/dostars${param.func ? '/' + param.func : ''}`,
+ data: param
+ }).then(res => {
+ if (res.status) {
+ this.writeInWebSql([param.MenuID, param.userid, res.open_edition, res.web_edition, res.LongParam, res.LongParamUser])
+ }
+ resolve(res)
+ })
+ }
+ }, (tx, results) => {
+ axios({
+ url: `/webapi/dostars${param.func ? '/' + param.func : ''}`,
+ data: param
+ }).then(res => {
+ if (res.status) {
+ window.GLOB.CacheMap.set(_param, res)
+ }
+ resolve(res)
+ })
+ mkDataBase = null
+ storUsable = false
+ console.warn(results)
+ })
+ })
+ })
+ } else if (window.GLOB.CacheMap.has(_param)) {
+ return Promise.resolve(window.GLOB.CacheMap.get(_param))
+ } else {
+ param.nonc = Utils.getuuid()
+
+ let keys = Object.keys(param).sort()
+ let values = ''
+ keys.forEach(key => {
+ if (key === 'rduri' || key === 't') return
+ if (typeof(param[key]) === 'object') {
+ values += key + JSON.stringify(param[key])
+ } else {
+ values += key + param[key]
+ }
+ })
+ param.sign = md5(values)
+ param.t = new Date().getTime()
+
+ return new Promise(resolve => {
+ axios({
+ url: `/webapi/dostars${param.func ? '/' + param.func : ''}`,
+ data: param
+ }).then(res => {
+ if (res.status) {
+ window.GLOB.CacheMap.set(_param, res)
+ }
+ resolve(res)
+ })
+ })
+ }
+ }
+
+ /**
+ * @description 灏嗘暟鎹啓鍏ebsql
+ */
+ writeInWebSql (data) {
+ if (!mkDataBase) return
+ mkDataBase.transaction(tx => {
+ tx.executeSql('INSERT INTO CONFIGS (menuid, userid, openEdition, webEdition, LongParam, LongParamUser) VALUES (?, ?, ?, ?, ?, ?)', data)
+ })
+ }
+
+ /**
+ * @description 鑾峰彇绯荤粺閰嶇疆锛屼紭鍏堜粠缂撳瓨涓彇鍊硷紝澧炲姞appkey
+ * @param {Object} param 璇锋眰鍙傛暟
+ * @param {Boolean} SSO 鏄惁涓哄崟鐐圭櫥褰曞湴鍧�
+ */
+ getSystemCacheConfig (param) {
+ param.userid = param.userid || sessionStorage.getItem('UserID') || ''
+ param.lang = localStorage.getItem('lang') || ''
+ param.SessionUid = localStorage.getItem('SessionUid') || ''
+ param.LoginUID = param.LoginUID || sessionStorage.getItem('LoginUID') || ''
+ param.appkey = window.GLOB.appkey || ''
+
+ let _param = JSON.parse(JSON.stringify(param)) // 缂撳瓨鏍￠獙锛屽幓闄ゆ椂闂村拰鍔犲瘑瀛楃
+ delete _param.timestamp
+ delete _param.secretkey
+ delete _param.open_key
_param = JSON.stringify(_param)
_param = md5(_param)
@@ -353,7 +660,7 @@
values += key + param[key]
}
})
- param.sign = md5(values)
+ param.sign = md5(values)
param.t = new Date().getTime()
return new Promise(resolve => {
--
Gitblit v1.8.0