From e83e0dd1b6fffd09c48561f3b69fa5a50df4a942 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期四, 04 二月 2021 19:01:01 +0800
Subject: [PATCH] 2021-02-04
---
src/api/index.js | 335 ++++++++++++++++++-------------------------------------
1 files changed, 109 insertions(+), 226 deletions(-)
diff --git a/src/api/index.js b/src/api/index.js
index 6b43e5e..587fafd 100644
--- a/src/api/index.js
+++ b/src/api/index.js
@@ -4,36 +4,21 @@
import md5 from 'md5'
import moment from 'moment'
import Utils from '@/utils/utils.js'
+import CacheUtils from './cacheutils'
import options from '@/store/options.js'
-let mkDataBase = null
+window.GLOB.WebSql = null
+window.GLOB.IndexDB = null
+const systemMenuKeys = `1581067625930haged11ieaivpavv77k,1581734956310scks442ul2d955g9tu5,1583991994144ndddg0bhh0is6shi0v1,1583979633842550imkchl4qt4qppsiv,1578900109100np8aqd0a77q3na46oas,16044812935562g807p3p12huk8kokmb,
+ 1585192949946f3et2ts8tn82krmumdf,15855615451212m12ip23vpcm79kloro,1587005717541lov40vg61q7l1rbveon,1590458676585agbbr63t6ihighg2i1g,1602315375262ikd33ii0nii34pt861o,1582771068837vsv54a089lgp45migbg,
+ 1582777675954ifu05upurs465omoth7,158294809668898cklbv6c5bou8e1fpu,1584676379094iktph45fb8imhg96bql,1584695125339vo5g7iqgfn01qmrd6s2,1584699661372vhmpp9dn9foo0eob722,15848421131551gg04ie8sitsd3f7467,
+ 1589782279158ngr675kk3oksin35sul,1589788042787ffdt9hle4s45k9r1nvs,15900310928174dro07ihfckghpb5h13,1594095599055qicg2eb642v5qglhnuo,1599613340050c8nu6rbst9d4emnnbsq,1577972969199lei1g0qkvlh4tkc908m,
+ 1578479100252lfbp29v1kafk4s4q4ig,1577971621421tg4v0i1ur8873k7e0ob,1577929944419lgc5h3hepum765e2k7u,1588493493409k9guqp067d31lu7blsv`
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
- }
+ CacheUtils.openWebSql()
+} else if (window.indexedDB) {
+ CacheUtils.openIndexDB()
}
axios.defaults.crossDomain = true
@@ -259,163 +244,106 @@
*/
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'
+ if (!window.GLOB.WebSql && !window.GLOB.IndexDB) {
+ return Promise.reject()
+ }
- 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 = this.encryptParam(param)
-
+ if (window.GLOB.WebSql) {
return new Promise((resolve, reject) => {
- axios({
- url: `/webapi/dostars${param.func ? '/' + param.func : ''}`,
- method: 'post',
- data: param
- }).then(res => {
- if (!res.status) {
- reject()
- return
+ CacheUtils.getWebSqlVersion().then(msg => {
+ 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,
}
- let clear = false
- let version = res.app_version || '1.00'
- appVersion.newVersion = version
- appVersion.oldVersion = appVersion.oldVersion || version
-
- if (res.menu_data && res.menu_data.length > 0) {
- let keys = `1581067625930haged11ieaivpavv77k,1581734956310scks442ul2d955g9tu5,1583991994144ndddg0bhh0is6shi0v1,1583979633842550imkchl4qt4qppsiv,1578900109100np8aqd0a77q3na46oas,16044812935562g807p3p12huk8kokmb,
- 1585192949946f3et2ts8tn82krmumdf,15855615451212m12ip23vpcm79kloro,1587005717541lov40vg61q7l1rbveon,1590458676585agbbr63t6ihighg2i1g,1602315375262ikd33ii0nii34pt861o,1582771068837vsv54a089lgp45migbg,
- 1582777675954ifu05upurs465omoth7,158294809668898cklbv6c5bou8e1fpu,1584676379094iktph45fb8imhg96bql,1584695125339vo5g7iqgfn01qmrd6s2,1584699661372vhmpp9dn9foo0eob722,15848421131551gg04ie8sitsd3f7467,
- 1589782279158ngr675kk3oksin35sul,1589788042787ffdt9hle4s45k9r1nvs,15900310928174dro07ihfckghpb5h13,1594095599055qicg2eb642v5qglhnuo,1599613340050c8nu6rbst9d4emnnbsq,1577972969199lei1g0qkvlh4tkc908m,
- 1578479100252lfbp29v1kafk4s4q4ig,1577971621421tg4v0i1ur8873k7e0ob,1577929944419lgc5h3hepum765e2k7u,1588493493409k9guqp067d31lu7blsv`
-
- res.menu_data.forEach(mid => {
- if (keys.indexOf(mid.menuid) > -1) {
- clear = true
- }
- })
- }
-
- mkDataBase.transaction(tx => {
- if (clear) {
- tx.executeSql(`DELETE FROM CONFIGS`, [], () => {}, () => { reject() })
- } else 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()
+
+ this.getSystemConfig(param).then(res => {
+ if (!res.status) {
+ reject()
+ return
+ }
+ let clear = false
+ let version = res.app_version || '1.00'
+ appVersion.newVersion = version
+ appVersion.oldVersion = appVersion.oldVersion || version
+
+ if (res.menu_data && res.menu_data.length > 0) {
+ res.menu_data.forEach(mid => {
+ if (systemMenuKeys.indexOf(mid.menuid) > -1) {
+ clear = true
+ }
})
+ }
+
+ if (clear) {
+ CacheUtils.clearWebSqlConfig()
+ } else if (res.menu_data && res.menu_data.length > 0) {
+ let keys = res.menu_data.map(mid => `'${mid.menuid}'`).join(',')
+ CacheUtils.delWebSqlConfig(keys)
}
if (msg.version) {
- tx.executeSql(`UPDATE VERSIONS SET createDate='${curTime}'`, [], () => {
- resolve()
- }, () => {
- reject()
- })
+ CacheUtils.updateWebSqlTime(curTime)
} else {
- tx.executeSql('INSERT INTO VERSIONS (version, createDate) VALUES (?, ?)', [version, curTime], () => {
- resolve()
- }, () => {
- reject()
- })
+ CacheUtils.createWebSqlversion(version, curTime)
}
+
+ resolve(appVersion)
})
+ }, () => {
+ reject()
})
- })
- }, () => {
- mkDataBase = null
- _reject()
- return Promise.reject()
- }).then(() => {
- _resolve(appVersion)
- }, () => {
- mkDataBase = null
- _reject()
- })
+ })
+ } else {
+ return new Promise((resolve, reject) => {
+ CacheUtils.getIndexDBVersion().then(msg => {
+ 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,
+ }
+
+ this.getSystemConfig(param).then(res => {
+ if (!res.status) {
+ reject()
+ return
+ }
+ let version = res.app_version || '1.00'
+ appVersion.newVersion = version
+ appVersion.oldVersion = appVersion.oldVersion || version
+
+ if (res.menu_data && res.menu_data.length > 0) {
+ CacheUtils.clearIndexDBConfig()
+ }
+
+ CacheUtils.updateIndexDBversion({version: version, createDate: curTime})
+
+ resolve(appVersion)
+ })
+ }, () => {
+ reject()
+ })
+ })
+ }
}
/**
* @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})
- })
- })
- })
+ let curTime = moment().format('YYYY-MM-DD HH:mm:ss') + '.000'
+ CacheUtils.clearWebSqlConfig()
+ CacheUtils.updateWebSqlversion(newVersion, curTime)
+ CacheUtils.clearIndexDBConfig()
+ CacheUtils.updateIndexDBversion({version: newVersion, createDate: curTime})
}
/**
* @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
- })
- })
- })
+ return CacheUtils.delMenuWebSqlConfig(menuId)
}
/**
@@ -570,50 +498,23 @@
_param = JSON.stringify(_param)
_param = md5(_param)
- if (mkDataBase) {
- param = this.encryptParam(param)
-
+ if (window.GLOB.WebSql) {
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 : ''}`,
- method: 'post',
- 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)
- })
+ CacheUtils.getWebSqlMenuConfig(param.MenuID, param.userid).then(res => {
+ resolve(res)
+ }, () => {
+ param = this.encryptParam(param)
+ axios({
+ url: `/webapi/dostars${param.func ? '/' + param.func : ''}`,
+ method: 'post',
+ data: param
+ }).then(res => {
+ if (res.status && window.GLOB.WebSql) {
+ CacheUtils.writeInWebSql([param.MenuID, param.userid, res.open_edition, res.web_edition, res.LongParam, res.LongParamUser])
+ } else if (res.status) {
+ window.GLOB.CacheMap.set(_param, res)
}
- }, (tx, results) => {
- mkDataBase = null
- console.warn(results)
-
- axios({
- url: `/webapi/dostars${param.func ? '/' + param.func : ''}`,
- method: 'post',
- data: param
- }).then(res => {
- if (res.status) {
- window.GLOB.CacheMap.set(_param, res)
- }
- resolve(res)
- })
+ resolve(res)
})
})
})
@@ -654,20 +555,12 @@
let _param = md5(JSON.stringify(param))
- if (mkDataBase) {
+ if (window.GLOB.WebSql) {
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, message: '', status: true })
- } else {
- resolve({ ErrCode: 'S', ErrMesg: '', LongParam: '', message: '', status: false })
- }
- }, (tx, results) => {
- mkDataBase = null
- resolve({ErrCode: 'S', ErrMesg: '', LongParam: '', message: '', status: false})
- })
+ CacheUtils.getWebSqlMenuConfig(param.MenuID, param.userid).then(res => {
+ resolve(res)
+ }, () => {
+ resolve({ ErrCode: 'S', ErrMesg: '', LongParam: '', message: '', status: false })
})
})
} else if (window.GLOB.CacheMap.has(_param)) {
@@ -675,16 +568,6 @@
} else {
return Promise.resolve({ErrCode: 'S', ErrMesg: '', LongParam: '', message: '', status: false})
}
- }
-
- /**
- * @description 灏嗘暟鎹啓鍏ebsql
- */
- writeInWebSql (data) {
- if (!mkDataBase) return
- mkDataBase.transaction(tx => {
- tx.executeSql('INSERT INTO CONFIGS (menuid, userid, openEdition, webEdition, LongParam, LongParamUser) VALUES (?, ?, ?, ?, ?, ?)', data)
- })
}
/**
--
Gitblit v1.8.0