From 1a11f7115e61c548f9ffc77d0a9e504307ca71b2 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期二, 24 八月 2021 18:37:20 +0800
Subject: [PATCH] 2021-08-24

---
 src/api/cacheutils.js |   56 +++++++++++++++++++++++++++++++++++++++++++++-----------
 1 files changed, 45 insertions(+), 11 deletions(-)

diff --git a/src/api/cacheutils.js b/src/api/cacheutils.js
index 71983c5..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,7 +137,7 @@
   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
       })
     })
@@ -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)
@@ -201,6 +207,9 @@
           let objectStore = window.GLOB.IndexDB.createObjectStore('configs', { keyPath: 'id' })
           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) {
@@ -306,6 +315,31 @@
   }
 
   /**
+   * @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) {

--
Gitblit v1.8.0