From a5bc394eceeaae5923057f1fd919968fd234af23 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期二, 27 五月 2025 17:59:57 +0800 Subject: [PATCH] 2025-05-27 --- src/utils/option.js | 215 +++++++++++++++++++++++++---------------------------- 1 files changed, 102 insertions(+), 113 deletions(-) diff --git a/src/utils/option.js b/src/utils/option.js index 22b20d0..8d52262 100644 --- a/src/utils/option.js +++ b/src/utils/option.js @@ -1,7 +1,4 @@ import nortable from '@/assets/img/normaltable.jpg' -// import mainsubtable from '@/assets/img/mainsubtable.jpg' -import treepage from '@/assets/img/treepage.jpg' -import calendar from '@/assets/img/calendar.jpg' import customImg from '@/assets/img/custom.jpg' import newpage from '@/assets/img/newpage.jpg' import rolemanage from '@/assets/img/rolemanage.jpg' @@ -47,44 +44,15 @@ export const sysTemps = [ { title: '鍩虹琛ㄦ牸', - type: 'CommonTable', - url: nortable, - baseconfig: '', - isSystem: true - }, - { - title: '鍩虹琛ㄦ牸锛堟柊锛�', type: 'BaseTable', url: nortable, baseconfig: '', isSystem: true }, - // { - // title: '涓诲瓙琛ㄨ〃鏍�', - // type: 'CommonTable', - // url: mainsubtable, - // baseconfig: '', - // isSystem: true, - // isSubtable: true - // }, { title: '鑷畾涔�', type: 'CustomPage', url: customImg, - baseconfig: '', - isSystem: true - }, - { - title: '鏍戝舰椤甸潰', - type: 'TreePage', - url: treepage, - baseconfig: '', - isSystem: true - }, - { - title: '鏃ュ巻', - type: 'CalendarPage', - url: calendar, baseconfig: '', isSystem: true }, @@ -111,41 +79,41 @@ date: [ {value: '', text: '绌�'}, {value: '0', text: '浠婂ぉ'}, - {value: 1, text: '鏄ㄥぉ'}, - {value: 2, text: '鍓嶅ぉ'}, - {value: 3, text: '鍓嶄笁澶�'}, - {value: 7, text: '鍓嶄竷澶�'}, - {value: 30, text: '鍓�30澶�'}, - {value: 90, text: '鍓�90澶�'}, - {value: 7300, text: '鍓�20骞�'}, - {value: -1, text: '鏄庡ぉ'}, - {value: -2, text: '鍚庡ぉ'}, - {value: -3, text: '鍚庝笁澶�'}, - {value: -7, text: '鍚庝竷澶�'}, - {value: -30, text: '鍚�30澶�'}, - {value: -90, text: '鍚�90澶�'}, - {value: -180, text: '鍚庡崐骞�'}, - {value: -365, text: '鍚�1骞�'}, - {value: -1095, text: '鍚�3骞�'}, - {value: -1825, text: '鍚�5骞�'}, - {value: -3650, text: '鍚�10骞�'}, - {value: -7300, text: '鍚�20骞�'}, + {value: '1', text: '鏄ㄥぉ'}, + {value: '2', text: '鍓嶅ぉ'}, + {value: '3', text: '鍓嶄笁澶�'}, + {value: '7', text: '鍓嶄竷澶�'}, + {value: '30', text: '鍓�30澶�'}, + {value: '90', text: '鍓�90澶�'}, + {value: '7300', text: '鍓�20骞�'}, + {value: '-1', text: '鏄庡ぉ'}, + {value: '-2', text: '鍚庡ぉ'}, + {value: '-3', text: '鍚庝笁澶�'}, + {value: '-7', text: '鍚庝竷澶�'}, + {value: '-30', text: '鍚�30澶�'}, + {value: '-90', text: '鍚�90澶�'}, + {value: '-180', text: '鍚庡崐骞�'}, + {value: '-365', text: '鍚�1骞�'}, + {value: '-1095', text: '鍚�3骞�'}, + {value: '-1825', text: '鍚�5骞�'}, + {value: '-3650', text: '鍚�10骞�'}, + {value: '-7300', text: '鍚�20骞�'}, ], dateweek: [ {value: '', text: '绌�'}, {value: '0', text: '鏈懆'}, - {value: 1, text: '涓婂懆'}, - {value: 3, text: '鍓嶄笁鍛�'}, - {value: 7, text: '鍓嶄竷鍛�'}, - {value: -1, text: '涓嬪懆'} + {value: '1', text: '涓婂懆'}, + {value: '3', text: '鍓嶄笁鍛�'}, + {value: '7', text: '鍓嶄竷鍛�'}, + {value: '-1', text: '涓嬪懆'} ], datemonth: [ {value: '', text: '绌�'}, {value: '0', text: '鏈湀'}, - {value: 1, text: '涓婃湀'}, - {value: 3, text: '鍓嶄笁鏈�'}, - {value: 7, text: '鍓嶄竷鏈�'}, - {value: -1, text: '涓嬫湀'} + {value: '1', text: '涓婃湀'}, + {value: '3', text: '鍓嶄笁鏈�'}, + {value: '7', text: '鍓嶄竷鏈�'}, + {value: '-1', text: '涓嬫湀'} ], daterange: [ {value: '', text: '绌�'}, @@ -154,41 +122,47 @@ {value: '[3, 0]', text: '杩戜笁澶�'}, {value: '[7, 0]', text: '杩戜竷澶�'}, {value: '[30, 0]', text: '杩�30澶�'}, + {value: '[90, 0]', text: '杩�90澶�'}, {value: '[7, -7]', text: '鍓嶅悗涓冨ぉ'}, {value: '[30, -30]', text: '鍓嶅悗30澶�'}, {value: '[90, -90]', text: '鍓嶅悗90澶�'}, + {value: '[180, -180]', label: '鍓嶅悗180澶�'}, + {value: '[365, -365]', label: '鍓嶅悗365澶�'}, {value: '[-1, -1]', text: '鏄庡ぉ'}, {value: '[-2, -2]', text: '鍚庡ぉ'}, {value: 'week', text: '鏈懆'}, {value: 'month', text: '鏈湀'}, + {value: 'lastMonth', text: '涓婃湀'}, + {value: 'year', text: '鏈勾'}, + {value: 'lastYear', text: '涓婂勾'}, ], datetime: [ {value: '', text: '绌�'}, {value: '0', text: '褰撳墠'}, - {value: 1, text: '鏄ㄥぉ'}, - {value: 3, text: '鍓嶄笁澶�'}, - {value: 7, text: '鍓嶄竷澶�'}, - {value: 30, text: '鍓�30澶�'}, - {value: 90, text: '鍓�90澶�'}, - {value: 7300, text: '鍓�20骞�'}, - {value: -1, text: '鏄庡ぉ'}, - {value: -2, text: '鍚庡ぉ'}, - {value: -3, text: '鍚庝笁澶�'}, - {value: -7, text: '鍚庝竷澶�'}, - {value: -30, text: '鍚�30澶�'}, - {value: -90, text: '鍚�90澶�'}, - {value: -180, text: '鍚庡崐骞�'}, - {value: -365, text: '鍚�1骞�'}, - {value: -1095, text: '鍚�3骞�'}, - {value: -1825, text: '鍚�5骞�'}, - {value: -3650, text: '鍚�10骞�'}, - {value: -7300, text: '鍚�20骞�'}, + {value: '1', text: '鏄ㄥぉ'}, + {value: '3', text: '鍓嶄笁澶�'}, + {value: '7', text: '鍓嶄竷澶�'}, + {value: '30', text: '鍓�30澶�'}, + {value: '90', text: '鍓�90澶�'}, + {value: '7300', text: '鍓�20骞�'}, + {value: '-1', text: '鏄庡ぉ'}, + {value: '-2', text: '鍚庡ぉ'}, + {value: '-3', text: '鍚庝笁澶�'}, + {value: '-7', text: '鍚庝竷澶�'}, + {value: '-30', text: '鍚�30澶�'}, + {value: '-90', text: '鍚�90澶�'}, + {value: '-180', text: '鍚庡崐骞�'}, + {value: '-365', text: '鍚�1骞�'}, + {value: '-1095', text: '鍚�3骞�'}, + {value: '-1825', text: '鍚�5骞�'}, + {value: '-3650', text: '鍚�10骞�'}, + {value: '-7300', text: '鍚�20骞�'}, ] } // 鍖归厤瑙勫垯 export const matchReg = { - text: [{ + class1: [{ value: 'like', text: 'like' }, { @@ -210,20 +184,7 @@ value: '<=', text: '<=' }], - multiselect: [{ - value: 'like', - text: 'like' - }, { - value: 'not like', - text: 'not like' - }], - select: [{ - value: 'like', - text: 'like' - }, { - value: 'not like', - text: 'not like' - }, { + class2: [{ value: '=', text: '=' }, { @@ -239,7 +200,14 @@ value: '<=', text: '<=' }], - date: [{ + class3: [{ + value: 'like', + text: 'like' + }, { + value: 'not like', + text: 'not like' + }], + class4: [{ value: '>=', text: '>=' }, { @@ -249,13 +217,16 @@ value: '=', text: '=' }], - datemonth: [{ + class5: [{ value: 'between', text: 'between' }], - daterange: [{ + class6: [{ value: 'between', text: 'between' + }, { + value: '=', + text: '=' }] } @@ -392,7 +363,7 @@ }] // 鎸夐挳棰滆壊闆� -export const btnCustomClasses = [{ +export const modalClasses = [{ value: 'primary', text: '钃濊壊' }, { @@ -408,17 +379,26 @@ value: 'green', text: '缁胯壊' }, { - value: 'dgreen', - text: '娣辩豢鑹�' -}, { value: 'purple', text: '绱壊' }, { - value: 'cyan', - text: '闈掕壊' + value: 'border-primary', + text: '鐧藉簳钃濇' }, { - value: 'gray', - text: '鐏拌壊' + value: 'border-yellow', + text: '鐧藉簳榛勬' +}, { + value: 'border-orange', + text: '鐧藉簳姗欐' +}, { + value: 'border-danger', + text: '鐧藉簳绾㈡' +}, { + value: 'border-green', + text: '鐧藉簳缁挎' +}, { + value: 'border-purple', + text: '鐧藉簳绱' }] export const calendarColors = [ @@ -524,16 +504,16 @@ 'blue-8': '#0050b3', 'blue-9': '#003a8c', 'blue-10': '#002766', - 'geekblue-1': '#f0f5ff', - 'geekblue-2': '#d6e4ff', - 'geekblue-3': '#adc6ff', - 'geekblue-4': '#85a5ff', - 'geekblue-5': '#597ef7', - 'geekblue-6': '#2f54eb', - 'geekblue-7': '#1d39c4', - 'geekblue-8': '#10239e', - 'geekblue-9': '#061178', - 'geekblue-10': '#030852', + 'geekblue-1': '#f0f6ff', + 'geekblue-2': '#dee9ff', + 'geekblue-3': '#b5ccff', + 'geekblue-4': '#8cadff', + 'geekblue-5': '#638aff', + 'geekblue-6': '#3860f4', + 'geekblue-7': '#2544cf', + 'geekblue-8': '#162ca8', + 'geekblue-9': '#0a1882', + 'geekblue-10': '#060e5c', 'purple-1': '#f9f0ff', 'purple-2': '#efdbff', 'purple-3': '#d3adf7', @@ -949,3 +929,12 @@ } export const queryTableSql = 'select top 999999 TbName,Remark from (select TbName,Remark from sDataDictb where appkey= @appkey@ and Deleted=0 union select a.TbName,Remark from (select TbName,Remark from sDataDictb where appkey= \'\' and Deleted=0 ) a left join (select TbName from sDataDictb where appkey= @appkey@ and Deleted=0 ) b on a.TbName=b.TbName where b.TbName is null ) t order by TbName' + +export const queryPrintSql = `select ID,Images,PrintTempNO+PrintTempName as PN from sPrintTemplate + where appkey= @appkey@ and Deleted=0 and typechartwo='web_print' + union select ID,Images,a.PrintTempNO+PrintTempName as PN + from (select * from sPrintTemplate where appkey= '' and Deleted=0 and typechartwo='web_print') a + left join (select PrintTempNO from sPrintTemplate where appkey= @appkey@ and Deleted=0 ) b + on a.PrintTempNO=b.PrintTempNO + left join (select Srcid from sPrintTemplate_Log where appkey='' and apicode= @appkey@ and Deleted=0 ) c + on a.ID=c.Srcid where b.PrintTempNO is null and c.Srcid is null` \ No newline at end of file -- Gitblit v1.8.0