| | |
| | | import zhCN from '@/locales/zh-CN/model.js' |
| | | import enUS from '@/locales/en-US/model.js' |
| | | 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' |
| | | |
| | | const _dict = sessionStorage.getItem('lang') !== 'en-US' ? zhCN : enUS |
| | | |
| | | // 表单校验规则 |
| | | export const formRule = { |
| | |
| | | export const sysTemps = [ |
| | | { |
| | | title: '基础表格', |
| | | type: 'CommonTable', |
| | | type: 'BaseTable', |
| | | url: nortable, |
| | | baseconfig: '', |
| | | isSystem: true |
| | | }, |
| | | // { |
| | | // title: '主子表表格', |
| | | // type: 'CommonTable', |
| | | // url: mainsubtable, |
| | | // baseconfig: '', |
| | | // isSystem: true, |
| | | // isSubtable: true |
| | | // }, |
| | | { |
| | | title: '自定义', |
| | | type: 'CustomPage', |
| | |
| | | isSystem: true |
| | | }, |
| | | { |
| | | title: '树形页面', |
| | | type: 'TreePage', |
| | | url: treepage, |
| | | baseconfig: '', |
| | | isSystem: true |
| | | }, |
| | | { |
| | | title: '日历', |
| | | type: 'CalendarPage', |
| | | url: calendar, |
| | | baseconfig: '', |
| | | isSystem: true |
| | | }, |
| | | { |
| | | title: '外部页面', |
| | | type: 'NewPage', |
| | | url: customImg, |
| | | url: newpage, |
| | | baseconfig: '', |
| | | isSystem: true |
| | | }, |
| | |
| | | // 日期默认值选择范围 |
| | | export const dateOptions = { |
| | | date: [ |
| | | {value: '', text: _dict['model.empty']}, |
| | | {value: '', text: '空'}, |
| | | {value: '0', text: '今天'}, |
| | | {value: 1, text: '昨天'}, |
| | | {value: 2, text: '前天'}, |
| | |
| | | {value: -7300, text: '后20年'}, |
| | | ], |
| | | dateweek: [ |
| | | {value: '', text: _dict['model.empty']}, |
| | | {value: '', text: '空'}, |
| | | {value: '0', text: '本周'}, |
| | | {value: 1, text: '上周'}, |
| | | {value: 3, text: '前三周'}, |
| | |
| | | {value: -1, text: '下周'} |
| | | ], |
| | | datemonth: [ |
| | | {value: '', text: _dict['model.empty']}, |
| | | {value: '', text: '空'}, |
| | | {value: '0', text: '本月'}, |
| | | {value: 1, text: '上月'}, |
| | | {value: 3, text: '前三月'}, |
| | |
| | | {value: -1, text: '下月'} |
| | | ], |
| | | daterange: [ |
| | | {value: '', text: _dict['model.empty']}, |
| | | {value: '', text: '空'}, |
| | | {value: '[0, 0]', text: '今天'}, |
| | | {value: '[1, 1]', text: '昨天'}, |
| | | {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: _dict['model.empty']}, |
| | | {value: '', text: '空'}, |
| | | {value: '0', text: '当前'}, |
| | | {value: 1, text: '昨天'}, |
| | | {value: 3, text: '前三天'}, |
| | |
| | | |
| | | // 匹配规则 |
| | | export const matchReg = { |
| | | text: [{ |
| | | class1: [{ |
| | | value: 'like', |
| | | text: 'like' |
| | | }, { |
| | |
| | | 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: '=' |
| | | }, { |
| | |
| | | value: '<=', |
| | | text: '<=' |
| | | }], |
| | | date: [{ |
| | | class3: [{ |
| | | value: 'like', |
| | | text: 'like' |
| | | }, { |
| | | value: 'not like', |
| | | text: 'not like' |
| | | }], |
| | | class4: [{ |
| | | value: '>=', |
| | | text: '>=' |
| | | }, { |
| | |
| | | value: '=', |
| | | text: '=' |
| | | }], |
| | | datemonth: [{ |
| | | class5: [{ |
| | | value: 'between', |
| | | text: 'between' |
| | | }], |
| | | daterange: [{ |
| | | class6: [{ |
| | | value: 'between', |
| | | text: 'between' |
| | | }, { |
| | | value: '=', |
| | | text: '=' |
| | | }] |
| | | } |
| | | |
| | |
| | | }] |
| | | |
| | | // 按钮颜色集 |
| | | export const btnCustomClasses = [{ |
| | | export const modalClasses = [{ |
| | | value: 'primary', |
| | | text: '蓝色' |
| | | }, { |
| | |
| | | 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 = [ |
| | |
| | | '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', |
| | |
| | | } |
| | | |
| | | 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` |