/**
|
* @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))', [], () => {
|
|
}, () => {
|
// 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 CACHES (menuid varchar(50), CreateDate varchar(50), LongParam text, CDefine1 varchar(50), CDefine2 varchar(50))', [], () => {
|
|
}, () => {
|
// 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')
|
// tx.executeSql('DROP TABLE CONFIGS')
|
// })
|
} catch (e) {
|
console.warn('WebSql 初始化失败！')
|
window.GLOB.WebSql = null
|
}
|
}
|
|
/**
|
* @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()
|
}
|
|
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 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)
|
})
|
})
|
}
|
|
/**
|
* @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)
|
})
|
})
|
}
|
}
|
|
/**
|
* @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
|
|
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)
|
})
|
}
|
})
|
}
|
|
/**
|
* @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 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 将缓存数据写入websql
|
*/
|
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中超过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
|
*/
|
static openIndexDB (db) {
|
try {
|
let request = window.indexedDB.open(db, 2)
|
request.onerror = () => {
|
console.warn('IndexedDB 初始化失败！')
|
}
|
request.onsuccess = () => {
|
window.GLOB.IndexDB = request.result
|
}
|
request.onupgradeneeded = (event) => {
|
window.GLOB.IndexDB = event.target.result
|
if (!window.GLOB.IndexDB.objectStoreNames.contains('version')) {
|
window.GLOB.IndexDB.createObjectStore('version', { keyPath: 'id' })
|
}
|
if (!window.GLOB.IndexDB.objectStoreNames.contains('configs')) {
|
let objectStore = window.GLOB.IndexDB.createObjectStore('configs', { keyPath: 'id' })
|
objectStore.createIndex('menuid', 'menuid', { unique: false })
|
objectStore.createIndex('userid', 'userid', { unique: false })
|
}
|
if (!window.GLOB.IndexDB.objectStoreNames.contains('caches')) {
|
window.GLOB.IndexDB.createObjectStore('caches', { keyPath: 'menuid' })
|
}
|
if (window.GLOB.systemType === '' && !window.GLOB.IndexDB.objectStoreNames.contains('funcs')) {
|
window.GLOB.IndexDB.createObjectStore('funcs', { keyPath: 'id' })
|
}
|
}
|
} catch (e) {
|
console.warn('IndexedDB 初始化失败！')
|
window.GLOB.IndexDB = null
|
}
|
}
|
|
/**
|
* @description 获取IndexedDB中保存信息版本
|
*/
|
static getIndexDBVersion () {
|
if (!window.GLOB.IndexDB) {
|
return Promise.reject()
|
}
|
|
let deffers = []
|
|
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 updateIndexDBversion (version) {
|
if (!window.GLOB.IndexDB || !version) return
|
|
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 {
|
let add = objectStore.add(version)
|
|
add.onerror = () => {
|
window.GLOB.IndexDB = null
|
}
|
}
|
}
|
}
|
}
|
|
/**
|
* @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 (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)
|
|
request.onerror = () => {
|
window.GLOB.IndexDB = null
|
reject()
|
}
|
|
request.onsuccess = () => {
|
if (request.result) {
|
resolve(request.result)
|
} else {
|
reject()
|
}
|
}
|
})
|
}
|
|
/**
|
* @description 将数据写入IndexedDB
|
*/
|
static writeInIndexDB (data) {
|
if (!window.GLOB.IndexDB || !data) return
|
|
window.GLOB.IndexDB.transaction(['configs'], 'readwrite').objectStore('configs').add(data)
|
}
|
|
/**
|
* @description 将数据写入IndexedDB
|
*/
|
static writeCacheInIndexDB (data) {
|
if (!window.GLOB.IndexDB) return
|
|
let objectStore = window.GLOB.IndexDB.transaction(['caches'], 'readwrite').objectStore('caches')
|
objectStore.delete(data.menuid)
|
|
if (data.LongParam) {
|
objectStore.add(data)
|
}
|
}
|
|
/**
|
* @description 获取IndexedDB中的配置信息
|
*/
|
static getIndexDBCacheConfig (MenuID) {
|
if (!window.GLOB.IndexDB) return Promise.resolve()
|
|
return new Promise((resolve, reject) => {
|
let request = window.GLOB.IndexDB.transaction(['caches']).objectStore('caches').get(MenuID)
|
|
request.onerror = () => {
|
resolve()
|
}
|
|
request.onsuccess = () => {
|
resolve(request.result)
|
}
|
})
|
}
|
|
/**
|
* @description 删除IndexedDB中超过7天的缓存信息
|
*/
|
static delIndexDBCacheConfig (date, type) {
|
if (!window.GLOB.IndexDB) return
|
|
if (type === 'all') {
|
window.GLOB.IndexDB.transaction(['caches'], 'readwrite').objectStore('caches').clear()
|
} else {
|
let request = window.GLOB.IndexDB.transaction(['caches'], 'readwrite').objectStore('caches').openCursor()
|
|
request.onsuccess = (e) => {
|
let cursor = e.target.result
|
if (cursor) {
|
if (cursor.value.CreateDate < date) {
|
cursor.delete()
|
}
|
cursor.continue()
|
}
|
}
|
}
|
}
|
}
|
