From cf8e332b14ca79859fcd89f2ac097ed7c6aa66c5 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期日, 01 十二月 2019 18:15:45 +0800
Subject: [PATCH] 2019-12-01
---
src/utils/utils.js | 191 +++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 191 insertions(+), 0 deletions(-)
diff --git a/src/utils/utils.js b/src/utils/utils.js
index 48e9cf9..a312464 100644
--- a/src/utils/utils.js
+++ b/src/utils/utils.js
@@ -1,3 +1,5 @@
+import moment from 'moment'
+
export default class Utils {
/**
* @description 鐢熸垚32浣島uid string + 鏃堕棿
@@ -30,6 +32,195 @@
}
/**
+ * @description sql鍔犲瘑
+ * @return {String} value
+ */
+ static formatOptions (value) {
+ // 浜х敓涓�涓柊鐨凣UID鍊�
+ let format = [{
+ key: 'select',
+ value: ' msltk '
+ }, {
+ key: 'from',
+ value: ' mfrmk '
+ }, {
+ key: 'where',
+ value: ' mwhrk '
+ }, {
+ key: 'order by',
+ value: ' modbk '
+ }, {
+ key: 'asc',
+ value: ' modack '
+ }, {
+ key: 'desc',
+ value: ' moddesk '
+ }, {
+ key: 'top',
+ value: ' mtpk '
+ }, {
+ key: 'like',
+ value: ' mlkk '
+ }, {
+ key: 'not like',
+ value: ' mnlkk '
+ }, {
+ key: 'between',
+ value: ' mbtnk '
+ }, {
+ key: 'and',
+ value: ' madk '
+ }, {
+ key: 'insert',
+ value: ' mistk '
+ }, {
+ key: 'into',
+ value: ' mitk '
+ }, {
+ key: 'update',
+ value: ' muptk '
+ }, {
+ key: 'delete',
+ value: ' mdelk '
+ }, {
+ key: 'begin',
+ value: ' mbgink '
+ }, {
+ key: 'end',
+ value: ' medk '
+ }, {
+ key: 'if',
+ value: ' mefk '
+ }, {
+ key: 'while',
+ value: ' mwilk '
+ }, {
+ key: 'create',
+ value: ' mcrtk '
+ }, {
+ key: 'alter',
+ value: ' matek '
+ }, {
+ key: 'len',
+ value: ' mlnk '
+ }, {
+ key: 'left',
+ value: ' mlftk '
+ }, {
+ key: 'right',
+ value: ' mritk '
+ }, {
+ key: 'union',
+ value: ' munok '
+ }, {
+ key: 'varchar',
+ value: ' mvcrk '
+ }, {
+ key: 'getdate',
+ value: ' mgtdtk '
+ }, {
+ key: 'TRY',
+ value: ' mtryonek '
+ }, {
+ key: 'TRAN',
+ value: ' mtrnk '
+ }, {
+ key: 'goto',
+ value: ' mgtk '
+ }, {
+ key: 'set',
+ value: ' mstk '
+ }, {
+ key: 'ROLLBACK',
+ value: ' mrlbkk '
+ }]
+ format.forEach(item => {
+ let reg = new RegExp('(^|\\s)' + item.key + '(\\s|$)', 'ig')
+ value = value.replace(reg, item.value)
+ })
+ value = value.replace(/(^\s|\s$)/ig, '')
+ value = window.btoa(window.encodeURIComponent(value))
+ let index = Math.floor(Math.random() * value.length)
+ value = value.slice(0, index) + 'minKe' + value.slice(index)
+ value = window.btoa(value)
+ // value = value.replace(/%/ig, 'mpercent')
+ // .replace(/>/ig, 'greateror')
+ // .replace(/</ig, 'lessor')
+ // .replace(/!=/ig, 'noequal')
+ // .replace(/=/ig, 'equal')
+ // .replace(/,/ig, 'comma')
+ // .replace(/>=/ig, 'greaterorequal')
+ // .replace(/<=/ig, 'lessorequal')
+ // .replace(/@/ig, 'matk')
+ // .replace(/\(/ig, 'mlbrktsk')
+ // .replace(/\)/ig, 'mrbrktsk')
+ // .replace(/\*/ig, 'mastrsk')
+ // .replace(/'/ig, 'mqotek')
+ // .replace(/\s/ig, 'mspace')
+ return value
+ }
+
+ /**
+ * @description 鎷兼帴鎼滅储鏉′欢
+ * @param {Array} searches 鎼滅储鏉′欢
+ * @return {String} searchText 鎷兼帴缁撴灉
+ */
+ static mainjointsearchkey (searches) {
+ if (!searches || searches.length === 0) return ''
+
+ if (searches[0].hasOwnProperty('initval')) {
+ let newsearches = []
+ searches.forEach(search => {
+ let item = {
+ key: search.field,
+ match: search.match,
+ type: search.type,
+ value: search.initval
+ }
+ if (item.type === 'date') {
+ item.value = item.value ? moment().subtract(item.value, 'days').format('YYYY-MM-DD') : ''
+ } else if (item.type === 'datemonth') {
+ item.value = item.value ? moment().subtract(item.value, 'month').format('YYYY-MM') : ''
+ } else if (item.type === 'dateweek') {
+ item.value = item.value ? [moment().subtract(item.value * 7, 'days').startOf('week').format('YYYY-MM-DD'),
+ moment().subtract(item.value * 7, 'days').endOf('week').format('YYYY-MM-DD')] : ''
+ } else if (item.type === 'daterange') {
+ item.value = item.value ? [moment().subtract(item.value, 'days').format('YYYY-MM-DD'),
+ moment().subtract(item.value === 1 ? 1 : 0, 'days').format('YYYY-MM-DD')] : ''
+ }
+ newsearches.push(item)
+ })
+ searches = newsearches
+ }
+
+ let searchText = ''
+ searches.forEach(item => {
+ if (!item.value) return
+ // eslint-disable-next-line
+ searchText += (searchText !== '' ? ' ' + 'AND' + ' ' : '')
+ if (item.type === 'text' || item.type === 'select') {
+ // eslint-disable-next-line
+ let str = item.match === '=' ? '' : '%'
+ // eslint-disable-next-line
+ searchText += item.key + ' ' + item.match + ' ' + '\'' + str + item.value + str + '\''
+ } else if (item.type === 'date' || item.type === 'datemonth') {
+ // eslint-disable-next-line
+ searchText += '(' + item.key + ' ' + item.match + ' ' + '\'' + item.value + '\')'
+ } else if (item.type === 'dateweek') {
+ // eslint-disable-next-line
+ searchText += '(' + item.key + ' ' + item.match + ' ' + '\'' + item.value[0] + '\' AND \'' + item.value[1] + '\')'
+ } else if (item.type === 'daterange') {
+ // eslint-disable-next-line
+ searchText += '(' + item.key + ' ' + item.match + ' ' + '\'' + item.value[0] + '\' AND \'' + item.value[1] + '\')'
+ } else {
+ // eslint-disable-next-line
+ searchText += '(' + item.key + ' ' + item.match + ' ' + '\'' + item.value + '\')'
+ }
+ })
+ return searchText
+ }
+
+ /**
* @description 鎷兼帴鎼滅储鏉′欢
* @param {Array} searches 鎼滅储鏉′欢
* @return {String} searchText 鎷兼帴缁撴灉
--
Gitblit v1.8.0