From c78051cc51032d4e29d35ca356d11d77a473eced Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期一, 09 八月 2021 18:20:08 +0800 Subject: [PATCH] 2021-08-09 --- src/api/cacheutils.js | 118 ++++++++++++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 105 insertions(+), 13 deletions(-) diff --git a/src/api/cacheutils.js b/src/api/cacheutils.js index 409b427..aa742fc 100644 --- a/src/api/cacheutils.js +++ b/src/api/cacheutils.js @@ -5,7 +5,7 @@ /** * @description 鎵撳紑websql */ - static openWebSql () { + static openWebSql (sysType) { let service = window.GLOB.service ? '-' + window.GLOB.service.replace('/', '') : '' try { window.GLOB.WebSql = openDatabase(`mkdb${service}`, '1', 'mk-pc-database', 50 * 1024 * 1024) @@ -22,6 +22,15 @@ // eslint-disable-next-line throw 'CREATE TABLE ERROR' }) + + if (sysType === 'local' && 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') @@ -42,16 +51,13 @@ } return new Promise((resolve, reject) => { window.GLOB.WebSql.transaction(tx => { - tx.executeSql('SELECT * FROM VERSIONS', [], (tx, results) => { + tx.executeSql("SELECT * FROM VERSIONS where CDefine1='LongParam'", [], (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: ''}) + } else { + resolve(results.rows[0]) } }, (tx, results) => { window.GLOB.WebSql = null @@ -107,7 +113,7 @@ static updateWebSqlTime (curTime) { if (!window.GLOB.WebSql || !curTime) return window.GLOB.WebSql.transaction(tx => { - tx.executeSql(`UPDATE VERSIONS SET createDate='${curTime}'`, [], () => {}, () => { + tx.executeSql(`UPDATE VERSIONS SET createDate='${curTime}' where CDefine1='LongParam'`, [], () => {}, () => { window.GLOB.WebSql = null }) }) @@ -119,7 +125,7 @@ static updateWebSqlversion (version, curTime) { if (!window.GLOB.WebSql || !curTime || !version) return window.GLOB.WebSql.transaction(tx => { - tx.executeSql(`UPDATE VERSIONS SET version='${version}', createDate='${curTime}'`, [], () => {}, () => { + tx.executeSql(`UPDATE VERSIONS SET version='${version}', createDate='${curTime}' where CDefine1='LongParam'`, [], () => {}, () => { window.GLOB.WebSql = null }) }) @@ -131,14 +137,14 @@ 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], () => {}, () => { + tx.executeSql('INSERT INTO VERSIONS (version, createDate, CDefine1) VALUES (?, ?, ?)', [version, curTime, 'LongParam'], () => {}, () => { window.GLOB.WebSql = null }) }) } /** - * @description 鍒涘缓websql涓厤缃俊鎭殑淇濆瓨鏃堕棿 + * @description 鑾峰彇websql涓殑閰嶇疆淇℃伅 */ static getWebSqlMenuConfig (MenuID, userid) { if (!window.GLOB.WebSql || !MenuID || !userid) return Promise.reject() @@ -182,7 +188,7 @@ /** * @description 鎵撳紑IndexedDB */ - static openIndexDB () { + static openIndexDB (sysType) { let service = window.GLOB.service ? '-' + window.GLOB.service.replace('/', '') : '' try { let request = window.indexedDB.open(`mkdb${service}`, 1) @@ -199,9 +205,11 @@ } if (!window.GLOB.IndexDB.objectStoreNames.contains('configs')) { let objectStore = window.GLOB.IndexDB.createObjectStore('configs', { keyPath: 'id' }) - objectStore.createIndex('type', 'type', { unique: false }) objectStore.createIndex('menuid', 'menuid', { unique: false }) objectStore.createIndex('userid', 'userid', { unique: false }) + } + if (window.GLOB.systemType === '' && sysType === 'local' && !window.GLOB.IndexDB.objectStoreNames.contains('funcs')) { + window.GLOB.IndexDB.createObjectStore('funcs', { keyPath: 'id' }) } } } catch (e) { @@ -285,4 +293,88 @@ } } + /** + * @description 鍒犻櫎IndexedDB涓繚瀛樼殑閰嶇疆淇℃伅 + */ + static delMenuIndexDBConfig (key) { + if (!window.GLOB.IndexDB || !key) return Promise.resolve() + + return new Promise(resolve => { + let request = window.GLOB.IndexDB.transaction(['configs'], 'readwrite') + .objectStore('configs') + .delete(key) + + request.onsuccess = () => { + resolve() + } + request.onerror = () => { + window.GLOB.IndexDB = null + resolve() + } + }) + } + + /** + * @description 鍒犻櫎IndexedDB涓繚瀛樼殑閰嶇疆淇℃伅-鎵归噺 + */ + static delIndexDBConfig (keys) { + if (!window.GLOB.IndexDB || !keys) return + + let objectStore = window.GLOB.IndexDB.transaction(['configs'], 'readwrite').objectStore('configs') + + objectStore.openCursor().onsuccess = (event) => { + let cursor = event.target.result + + if (cursor) { + if (cursor.value && keys.includes(cursor.value.menuid)) { + let request = objectStore.delete(cursor.key) + + request.onerror = () => { + window.GLOB.IndexDB = null + } + } + + 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) + + request.onerror = () => { + window.GLOB.IndexDB = null + reject() + } + + request.onsuccess = () => { + if (request.result) { + resolve(request.result) + } else { + reject() + } + } + }) + } + + /** + * @description 灏嗘暟鎹啓鍏ndexedDB + */ + static writeInIndexDB (data) { + if (!window.GLOB.IndexDB || !data) return + + let request = window.GLOB.IndexDB.transaction(['configs'], 'readwrite') + .objectStore('configs') + .add(data) + + request.onerror = () => { + window.GLOB.IndexDB = null + } + } } \ No newline at end of file -- Gitblit v1.8.0