From 930a74e9fb7bd74e7fb0875b13d16657c1163c58 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期五, 13 一月 2023 10:17:41 +0800
Subject: [PATCH] 2023-01-13
---
src/api/cacheutils.js | 337 ++++++++++++++++++++++++++++++++++++-------------------
1 files changed, 221 insertions(+), 116 deletions(-)
diff --git a/src/api/cacheutils.js b/src/api/cacheutils.js
index 71983c5..542bfde 100644
--- a/src/api/cacheutils.js
+++ b/src/api/cacheutils.js
@@ -5,10 +5,9 @@
/**
* @description 鎵撳紑websql
*/
- static openWebSql () {
- let service = window.GLOB.service ? '-' + window.GLOB.service.replace('/', '') : ''
+ static openWebSql (db) {
try {
- window.GLOB.WebSql = openDatabase(`mkdb${service}`, '1', 'mk-pc-database', 50 * 1024 * 1024)
+ window.GLOB.WebSql = openDatabase(db, '1', 'mk-pc-database', 50 * 1024 * 1024)
window.GLOB.WebSql.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))', [], () => {
@@ -22,6 +21,15 @@
// eslint-disable-next-line
throw 'CREATE TABLE ERROR'
})
+
+ if (window.GLOB.systemType === '') {
+ tx.executeSql('CREATE TABLE IF NOT EXISTS FUNCS (func_code varchar(50), key_sql text, CDefine1 varchar(50), CDefine2 varchar(50), CDefine3 varchar(50))', [], () => {
+
+ }, () => {
+ // eslint-disable-next-line
+ throw 'CREATE TABLE ERROR'
+ })
+ }
})
// window.GLOB.WebSql.transaction(tx => {
// tx.executeSql('DROP TABLE VERSIONS')
@@ -34,41 +42,81 @@
}
/**
+ * @description 娓呯┖鍑芥暟
+ */
+ static clearFuncs () {
+ if (window.GLOB.systemType !== '') return
+
+ if (window.GLOB.WebSql) {
+ window.GLOB.WebSql.transaction(tx => {
+ tx.executeSql('DELETE FROM FUNCS')
+
+ tx.executeSql(`UPDATE VERSIONS SET createDate='1970-01-01 14:59:09.000' where CDefine1='funcs'`)
+ })
+ } else if (window.GLOB.IndexDB) {
+ let objectStore = window.GLOB.IndexDB.transaction(['funcs'], 'readwrite').objectStore('funcs')
+ objectStore.clear()
+
+ window.GLOB.IndexDB.transaction(['version'], 'readwrite').objectStore('version').delete('funcs')
+ }
+ }
+
+ /**
* @description 鑾峰彇websql涓繚瀛樹俊鎭増鏈�
*/
static getWebSqlVersion () {
if (!window.GLOB.WebSql) {
return Promise.reject()
}
- return new Promise((resolve, reject) => {
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql('SELECT * FROM VERSIONS', [], (tx, results) => {
- if (results.rows.length === 0) {
- tx.executeSql('DELETE FROM CONFIGS')
+
+ let deffers = []
+
+ deffers.push(
+ new Promise((resolve) => {
+ window.GLOB.WebSql.transaction(tx => {
+ tx.executeSql("SELECT * FROM VERSIONS where CDefine1='LongParam'", [], (tx, results) => {
+ if (results.rows[0]) {
+ resolve(results.rows[0])
+ } else {
+ resolve({version: '', createDate: ''})
+ }
+ }, (tx, results) => {
+ console.warn(results)
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) => {
- window.GLOB.WebSql = null
- reject()
- console.warn(results)
+ })
})
})
- })
- }
+ )
- /**
- * @description 娓呯┖websql涓繚瀛樼殑閰嶇疆淇℃伅
- */
- static clearWebSqlConfig () {
- if (!window.GLOB.WebSql) return
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql(`DELETE FROM CONFIGS`, [], () => {}, () => { window.GLOB.WebSql = null })
+ deffers.push(
+ new Promise((resolve) => {
+ window.GLOB.WebSql.transaction(tx => {
+ tx.executeSql(`SELECT * FROM CONFIGS`, [], (tx, results) => {
+ let menus = []
+ for (let i = 0; i < results.rows.length; i++) {
+ menus.push(`'${results.rows[i].menuid}','${results.rows[i].openEdition || 'mk'}'`)
+ }
+ resolve(menus)
+ }, (tx, results) => {
+ console.warn(results)
+ resolve([])
+ })
+ })
+ })
+ )
+
+ return new Promise((resolve) => {
+ Promise.all(deffers).then(res => {
+ let result = res[0]
+
+ if (result.createDate && !/^\d{4}-\d{2}-\d{2}/.test(result.createDate)) {
+ result.createDate = ''
+ }
+
+ result.menuids = res[1].join(';')
+
+ resolve(result)
+ })
})
}
@@ -76,12 +124,21 @@
* @description 鍒犻櫎websql涓繚瀛樼殑閰嶇疆淇℃伅
*/
static delWebSqlConfig (keys) {
- if (!window.GLOB.WebSql || !keys) return
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql(`DELETE FROM CONFIGS where menuid in (${keys})`, [], () => {}, () => {
- window.GLOB.WebSql = null
+ if (!window.GLOB.WebSql) return
+
+ if (!keys) {
+ window.GLOB.WebSql.transaction(tx => {
+ tx.executeSql(`DELETE FROM CONFIGS`, [], () => {}, (tx, results) => {
+ console.warn(results)
+ })
})
- })
+ } else {
+ window.GLOB.WebSql.transaction(tx => {
+ tx.executeSql(`DELETE FROM CONFIGS where menuid in (${keys})`, [], () => {}, (tx, results) => {
+ console.warn(results)
+ })
+ })
+ }
}
/**
@@ -93,22 +150,10 @@
window.GLOB.WebSql.transaction(tx => {
tx.executeSql(`DELETE FROM CONFIGS where menuid='${menuId}'`, [], () => {
resolve()
- }, () => {
- window.GLOB.WebSql = null
+ }, (tx, results) => {
+ console.warn(results)
resolve()
})
- })
- })
- }
-
- /**
- * @description 鏇存柊websql涓厤缃俊鎭殑淇濆瓨鏃堕棿
- */
- static updateWebSqlTime (curTime) {
- if (!window.GLOB.WebSql || !curTime) return
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql(`UPDATE VERSIONS SET createDate='${curTime}'`, [], () => {}, () => {
- window.GLOB.WebSql = null
})
})
}
@@ -117,23 +162,16 @@
* @description 鏇存柊websql涓厤缃俊鎭殑鐗堟湰
*/
static updateWebSqlversion (version, curTime) {
- if (!window.GLOB.WebSql || !curTime || !version) return
+ if (!window.GLOB.WebSql) return
+
window.GLOB.WebSql.transaction(tx => {
- tx.executeSql(`UPDATE VERSIONS SET version='${version}', createDate='${curTime}'`, [], () => {}, () => {
- window.GLOB.WebSql = null
- })
- })
- }
-
- /**
- * @description 鍒涘缓websql涓厤缃俊鎭殑鐗堟湰
- */
- static createWebSqlversion (version, curTime) {
- if (!window.GLOB.WebSql || !curTime || !version) return
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql('INSERT INTO VERSIONS (version, createDate) VALUES (?, ?)', [version, curTime], () => {}, () => {
- window.GLOB.WebSql = null
- })
+ tx.executeSql(`DELETE FROM VERSIONS where CDefine1='LongParam'`)
+
+ if (version) {
+ tx.executeSql('INSERT INTO VERSIONS (version, createDate, CDefine1) VALUES (?, ?, ?)', [version, curTime, 'LongParam'], () => {}, (tx, results) => {
+ console.warn(results)
+ })
+ }
})
}
@@ -161,7 +199,6 @@
reject()
}
}, (tx, results) => {
- window.GLOB.WebSql = null
console.warn(results)
reject()
})
@@ -182,10 +219,9 @@
/**
* @description 鎵撳紑IndexedDB
*/
- static openIndexDB () {
- let service = window.GLOB.service ? '-' + window.GLOB.service.replace('/', '') : ''
+ static openIndexDB (db) {
try {
- let request = window.indexedDB.open(`mkdb${service}`, 1)
+ let request = window.indexedDB.open(db, 1)
request.onerror = () => {
console.warn('IndexedDB 鍒濆鍖栧け璐ワ紒')
}
@@ -202,6 +238,9 @@
objectStore.createIndex('menuid', 'menuid', { unique: false })
objectStore.createIndex('userid', 'userid', { unique: false })
}
+ if (window.GLOB.systemType === '' && !window.GLOB.IndexDB.objectStoreNames.contains('funcs')) {
+ window.GLOB.IndexDB.createObjectStore('funcs', { keyPath: 'id' })
+ }
}
} catch (e) {
console.warn('IndexedDB 鍒濆鍖栧け璐ワ紒')
@@ -216,38 +255,66 @@
if (!window.GLOB.IndexDB) {
return Promise.reject()
}
- return new Promise((resolve, reject) => {
- let request = window.GLOB.IndexDB.transaction(['version'])
- .objectStore('version')
- .get('mksoft')
- request.onerror = (event) => {
- window.GLOB.IndexDB = null
- console.warn(event)
- reject()
- }
+ let deffers = []
- request.onsuccess = () => {
- if (request.result) {
- resolve(request.result)
- } else {
- this.clearIndexDBConfig()
+ deffers.push(
+ new Promise((resolve) => {
+ let request = window.GLOB.IndexDB.transaction(['version'])
+ .objectStore('version')
+ .get('mksoft')
+
+ request.onerror = (event) => {
+ window.GLOB.IndexDB = null
+ console.warn(event)
resolve({version: '', createDate: ''})
}
- }
+
+ request.onsuccess = () => {
+ if (request.result) {
+ resolve(request.result)
+ } else {
+ resolve({version: '', createDate: ''})
+ }
+ }
+ })
+ )
+
+ deffers.push(
+ new Promise((resolve) => {
+ let request = window.GLOB.IndexDB.transaction(['configs']).objectStore('configs').openCursor()
+ let menus = []
+
+ request.onerror = () => {
+ window.GLOB.IndexDB = null
+ resolve(menus)
+ }
+
+ request.onsuccess = (e) => {
+ let cursor = e.target.result
+ if (cursor) {
+ menus.push(`'${cursor.value.menuid}','${cursor.value.open_edition || 'mk'}'`)
+ cursor.continue()
+ } else {
+ resolve(menus)
+ }
+ }
+ })
+ )
+
+ return new Promise((resolve) => {
+ Promise.all(deffers).then(res => {
+ let result = res[0]
+
+ if (result.createDate && !/^\d{4}-\d{2}-\d{2}/.test(result.createDate)) {
+ result.createDate = ''
+ }
+
+ result.menuids = res[1].join(';')
+
+ resolve(result)
+ })
})
- }
-
- /**
- * @description 娓呯┖IndexedDB涓繚瀛樼殑閰嶇疆淇℃伅
- */
- static clearIndexDBConfig () {
- if (!window.GLOB.IndexDB) return
- let request = window.GLOB.IndexDB.transaction(['configs'], 'readwrite').objectStore('configs').clear()
-
- request.onerror = () => {
- window.GLOB.IndexDB = null
- }
}
/**
@@ -256,29 +323,35 @@
static updateIndexDBversion (version) {
if (!window.GLOB.IndexDB || !version) return
- version.id = 'mksoft'
+ if (!version) {
+ let request = window.GLOB.IndexDB.transaction(['configs'], 'readwrite').objectStore('configs').delete('mksoft')
+
+ request.onerror = () => {
+ window.GLOB.IndexDB = null
+ }
+ } else {
+ version.id = 'mksoft'
- let objectStore = window.GLOB.IndexDB.transaction(['version'], 'readwrite').objectStore('version')
- let request = objectStore.get('mksoft')
-
- request.onerror = () => {
- window.GLOB.IndexDB = null
- }
-
- request.onsuccess = () => {
- if (request.result) {
- let put = objectStore.put(version)
-
- put.onerror = () => {
- window.GLOB.IndexDB = null
- }
- } else {
- this.clearIndexDBConfig()
-
- let add = objectStore.add(version)
-
- add.onerror = () => {
- window.GLOB.IndexDB = null
+ let objectStore = window.GLOB.IndexDB.transaction(['version'], 'readwrite').objectStore('version')
+ let request = objectStore.get('mksoft')
+
+ request.onerror = () => {
+ window.GLOB.IndexDB = null
+ }
+
+ request.onsuccess = () => {
+ if (request.result) {
+ let put = objectStore.put(version)
+
+ put.onerror = () => {
+ window.GLOB.IndexDB = null
+ }
+ } else {
+ let add = objectStore.add(version)
+
+ add.onerror = () => {
+ window.GLOB.IndexDB = null
+ }
}
}
}
@@ -306,11 +379,43 @@
}
/**
+ * @description 鍒犻櫎IndexedDB涓繚瀛樼殑閰嶇疆淇℃伅-鎵归噺
+ */
+ static delIndexDBConfig (menuids) {
+ if (!window.GLOB.IndexDB) return
+
+ if (!menuids) {
+ let request = window.GLOB.IndexDB.transaction(['configs'], 'readwrite').objectStore('configs').clear()
+
+ request.onerror = () => {
+ window.GLOB.IndexDB = null
+ }
+ } else {
+ let request = window.GLOB.IndexDB.transaction(['configs'], 'readwrite').objectStore('configs').openCursor()
+
+ request.onerror = () => {
+ window.GLOB.IndexDB = null
+ }
+
+ request.onsuccess = (e) => {
+ let cursor = e.target.result
+ if (cursor) {
+ if (menuids.includes(cursor.value.menuid)) {
+ cursor.delete()
+ }
+ cursor.continue()
+ }
+ }
+ }
+ }
+
+ /**
* @description 鑾峰彇IndexedDB涓殑閰嶇疆淇℃伅
*/
static getIndexDBMenuConfig (MenuID, userid) {
if (!window.GLOB.IndexDB || !MenuID || !userid) return Promise.reject()
let key = MenuID + userid
+
return new Promise((resolve, reject) => {
let request = window.GLOB.IndexDB.transaction(['configs']).objectStore('configs').get(key)
--
Gitblit v1.8.0