From 3875da845b8fae679bd784d1246101a5fb1b61b5 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期三, 15 三月 2023 16:33:20 +0800
Subject: [PATCH] 2023-03-15
---
src/api/cacheutils.js | 476 +++++++++++++++++++++++++++++-----------------------------
1 files changed, 238 insertions(+), 238 deletions(-)
diff --git a/src/api/cacheutils.js b/src/api/cacheutils.js
index 1c174d9..244587a 100644
--- a/src/api/cacheutils.js
+++ b/src/api/cacheutils.js
@@ -2,274 +2,274 @@
* @description 缂撳瓨宸ュ叿绫�
*/
export default class CacheUtils {
- /**
- * @description 鎵撳紑websql
- */
- static openWebSql (db) {
- try {
- 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))', [], () => {
+ // /**
+ // * @description 鎵撳紑websql
+ // */
+ // static openWebSql (db) {
+ // try {
+ // 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))', [], () => {
- }, () => {
- // 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'
+ // })
+ // 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'
- })
+ // }, () => {
+ // // eslint-disable-next-line
+ // throw 'CREATE TABLE ERROR'
+ // })
- tx.executeSql('CREATE TABLE IF NOT EXISTS CACHES (menuid varchar(50), CreateDate varchar(50), LongParam text, CDefine1 varchar(50), CDefine2 varchar(50))', [], () => {
+ // tx.executeSql('CREATE TABLE IF NOT EXISTS CACHES (menuid varchar(50), CreateDate varchar(50), LongParam text, CDefine1 varchar(50), CDefine2 varchar(50))', [], () => {
- }, () => {
- // eslint-disable-next-line
- throw 'CREATE TABLE ERROR'
- })
+ // }, () => {
+ // // 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))', [], () => {
+ // 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')
- // tx.executeSql('DROP TABLE CONFIGS')
- // })
- } catch (e) {
- console.warn('WebSql 鍒濆鍖栧け璐ワ紒')
- window.GLOB.WebSql = null
+ // }, () => {
+ // // eslint-disable-next-line
+ // throw 'CREATE TABLE ERROR'
+ // })
+ // }
+ // })
+ // // window.GLOB.WebSql.transaction(tx => {
+ // // tx.executeSql('DROP TABLE VERSIONS')
+ // // tx.executeSql('DROP TABLE CONFIGS')
+ // // })
+ // } catch (e) {
+ // console.warn('WebSql 鍒濆鍖栧け璐ワ紒')
+ // window.GLOB.WebSql = null
- if (window.indexedDB) {
- this.openIndexDB(db)
- }
- }
- }
+ // if (window.indexedDB) {
+ // this.openIndexDB(db)
+ // }
+ // }
+ // }
- /**
- * @description 娓呯┖鍑芥暟
- */
- static clearFuncs () {
- if (window.GLOB.systemType !== '') return
+ // /**
+ // * @description 娓呯┖鍑芥暟
+ // */
+ // static clearFuncs () {
+ // if (window.GLOB.systemType !== '') return
- if (window.GLOB.WebSql) {
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql('DELETE FROM FUNCS')
+ // 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()
+ // 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')
- }
- }
+ // window.GLOB.IndexDB.transaction(['version'], 'readwrite').objectStore('version').delete('funcs')
+ // }
+ // }
- /**
- * @description 鑾峰彇websql涓繚瀛樹俊鎭増鏈�
- */
- static getWebSqlVersion () {
- if (!window.GLOB.WebSql) {
- return Promise.reject()
- }
+ // /**
+ // * @description 鑾峰彇websql涓繚瀛樹俊鎭増鏈�
+ // */
+ // static getWebSqlVersion () {
+ // if (!window.GLOB.WebSql) {
+ // return Promise.reject()
+ // }
- let deffers = []
+ // 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: ''})
- })
- })
- })
- )
+ // 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: ''})
+ // })
+ // })
+ // })
+ // )
- 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([])
- })
- })
- })
- )
+ // 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]
+ // 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 = ''
- }
+ // if (result.createDate && !/^\d{4}-\d{2}-\d{2}/.test(result.createDate)) {
+ // result.createDate = ''
+ // }
- result.menuids = res[1].join(';')
+ // result.menuids = res[1].join(';')
- resolve(result)
- })
- })
- }
+ // resolve(result)
+ // })
+ // })
+ // }
- /**
- * @description 鍒犻櫎websql涓繚瀛樼殑閰嶇疆淇℃伅
- */
- static delWebSqlConfig (keys) {
- if (!window.GLOB.WebSql) return
+ // /**
+ // * @description 鍒犻櫎websql涓繚瀛樼殑閰嶇疆淇℃伅
+ // */
+ // static delWebSqlConfig (keys) {
+ // 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)
- })
- })
- }
- }
+ // 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)
+ // })
+ // })
+ // }
+ // }
- /**
- * @description 鍒犻櫎websql涓繚瀛樼殑閰嶇疆淇℃伅
- */
- static delMenuWebSqlConfig (menuId) {
- if (!window.GLOB.WebSql || !menuId) return Promise.resolve()
- return new Promise(resolve => {
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql(`DELETE FROM CONFIGS where menuid='${menuId}'`, [], () => {
- resolve()
- }, (tx, results) => {
- console.warn(results)
- resolve()
- })
- })
- })
- }
+ // /**
+ // * @description 鍒犻櫎websql涓繚瀛樼殑閰嶇疆淇℃伅
+ // */
+ // static delMenuWebSqlConfig (menuId) {
+ // if (!window.GLOB.WebSql || !menuId) return Promise.resolve()
+ // return new Promise(resolve => {
+ // window.GLOB.WebSql.transaction(tx => {
+ // tx.executeSql(`DELETE FROM CONFIGS where menuid='${menuId}'`, [], () => {
+ // resolve()
+ // }, (tx, results) => {
+ // console.warn(results)
+ // resolve()
+ // })
+ // })
+ // })
+ // }
- /**
- * @description 鏇存柊websql涓厤缃俊鎭殑鐗堟湰
- */
- static updateWebSqlversion (version, curTime) {
- if (!window.GLOB.WebSql) return
+ // /**
+ // * @description 鏇存柊websql涓厤缃俊鎭殑鐗堟湰
+ // */
+ // static updateWebSqlversion (version, curTime) {
+ // if (!window.GLOB.WebSql) return
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql(`DELETE FROM VERSIONS where CDefine1='LongParam'`)
+ // window.GLOB.WebSql.transaction(tx => {
+ // 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)
- })
- }
- })
- }
+ // if (version) {
+ // tx.executeSql('INSERT INTO VERSIONS (version, createDate, CDefine1) VALUES (?, ?, ?)', [version, curTime, 'LongParam'], () => {}, (tx, results) => {
+ // console.warn(results)
+ // })
+ // }
+ // })
+ // }
- /**
- * @description 鑾峰彇websql涓殑閰嶇疆淇℃伅
- */
- static getWebSqlMenuConfig (MenuID, userid) {
- if (!window.GLOB.WebSql || !MenuID || !userid) return Promise.reject()
- return new Promise((resolve, reject) => {
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql(`SELECT * FROM CONFIGS WHERE menuid='${MenuID}' and userid='${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 {
- reject()
- }
- }, (tx, results) => {
- console.warn(results)
- reject()
- })
- })
- })
- }
+ // /**
+ // * @description 鑾峰彇websql涓殑閰嶇疆淇℃伅
+ // */
+ // static getWebSqlMenuConfig (MenuID, userid) {
+ // if (!window.GLOB.WebSql || !MenuID || !userid) return Promise.reject()
+ // return new Promise((resolve, reject) => {
+ // window.GLOB.WebSql.transaction(tx => {
+ // tx.executeSql(`SELECT * FROM CONFIGS WHERE menuid='${MenuID}' and userid='${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 {
+ // reject()
+ // }
+ // }, (tx, results) => {
+ // console.warn(results)
+ // reject()
+ // })
+ // })
+ // })
+ // }
- /**
- * @description 灏嗘暟鎹啓鍏ebsql
- */
- static writeInWebSql (data) {
- if (!window.GLOB.WebSql || !data) return
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql('INSERT INTO CONFIGS (menuid, userid, openEdition, webEdition, LongParam, LongParamUser) VALUES (?, ?, ?, ?, ?, ?)', data)
- })
- }
+ // /**
+ // * @description 灏嗘暟鎹啓鍏ebsql
+ // */
+ // static writeInWebSql (data) {
+ // if (!window.GLOB.WebSql || !data) return
+ // window.GLOB.WebSql.transaction(tx => {
+ // tx.executeSql('INSERT INTO CONFIGS (menuid, userid, openEdition, webEdition, LongParam, LongParamUser) VALUES (?, ?, ?, ?, ?, ?)', data)
+ // })
+ // }
- /**
- * @description 灏嗙紦瀛樻暟鎹啓鍏ebsql
- */
- static writeCacheInWebSql (data) {
- if (!window.GLOB.WebSql) return
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql(`DELETE FROM CACHES where menuid='${data[0]}'`)
- if (data[2]) {
- tx.executeSql('INSERT INTO CACHES (menuid, CreateDate, LongParam) VALUES (?, ?, ?)', data)
- }
- })
- }
+ // /**
+ // * @description 灏嗙紦瀛樻暟鎹啓鍏ebsql
+ // */
+ // static writeCacheInWebSql (data) {
+ // if (!window.GLOB.WebSql) return
+ // window.GLOB.WebSql.transaction(tx => {
+ // tx.executeSql(`DELETE FROM CACHES where menuid='${data[0]}'`)
+ // if (data[2]) {
+ // tx.executeSql('INSERT INTO CACHES (menuid, CreateDate, LongParam) VALUES (?, ?, ?)', data)
+ // }
+ // })
+ // }
- /**
- * @description 鑾峰彇websql涓殑閰嶇疆淇℃伅
- */
- static getWebSqlCacheConfig (MenuID) {
- if (!window.GLOB.WebSql) return Promise.resolve()
- return new Promise((resolve, reject) => {
- window.GLOB.WebSql.transaction(tx => {
- tx.executeSql(`SELECT * FROM CACHES WHERE menuid='${MenuID}'`, [], (tx, results) => {
- resolve(results.rows[0])
- }, (tx, results) => {
- console.warn(results)
- resolve()
- })
- })
- })
- }
+ // /**
+ // * @description 鑾峰彇websql涓殑閰嶇疆淇℃伅
+ // */
+ // static getWebSqlCacheConfig (MenuID) {
+ // if (!window.GLOB.WebSql) return Promise.resolve()
+ // return new Promise((resolve, reject) => {
+ // window.GLOB.WebSql.transaction(tx => {
+ // tx.executeSql(`SELECT * FROM CACHES WHERE menuid='${MenuID}'`, [], (tx, results) => {
+ // resolve(results.rows[0])
+ // }, (tx, results) => {
+ // console.warn(results)
+ // resolve()
+ // })
+ // })
+ // })
+ // }
- /**
- * @description 鍒犻櫎websql涓秴杩�7澶╃殑缂撳瓨淇℃伅
- */
- static delWebSqlCacheConfig (date, type) {
- if (!window.GLOB.WebSql) return
- window.GLOB.WebSql.transaction(tx => {
- if (type === 'all') {
- tx.executeSql('DELETE FROM CACHES')
- } else {
- tx.executeSql(`DELETE FROM CACHES where CreateDate<'${date}'`)
- }
- })
- }
+ // /**
+ // * @description 鍒犻櫎websql涓秴杩�7澶╃殑缂撳瓨淇℃伅
+ // */
+ // static delWebSqlCacheConfig (date, type) {
+ // if (!window.GLOB.WebSql) return
+ // window.GLOB.WebSql.transaction(tx => {
+ // if (type === 'all') {
+ // tx.executeSql('DELETE FROM CACHES')
+ // } else {
+ // tx.executeSql(`DELETE FROM CACHES where CreateDate<'${date}'`)
+ // }
+ // })
+ // }
/**
* @description 鎵撳紑IndexedDB
--
Gitblit v1.8.0