export const baseDataObj = { employee: { title: '', data: { id: '', name: '名字', photo: '', jianDingZiGeZ: '', gender: '', status: '', mobile: '', email: '', job: '', positions: '' } }, ryjbqk: { title: '', data: { id: '', parentId: '', jianDangRiQi: '2024-09-12', chuShengRiQi: '2024-09-12', nianLing: '1', zuiGaoXueLiX: '本科', yuanBiYeYuanXi: '学校', ruZhiShiJian: '2024-11-11', zhiChengDengJi: '高级', zhiCheng: '主任', qianZiTuWen: '1305918421677899776', shenFenZhengHao: '232323232323232323232', baoMiXieYi: '1305918421677899776', chengNuoHan: '1305918421677899776', sheBao: '1305918421677899776', renYuanLeiXing: '提供支持性服务的外部人员', fujIan: '1305918421677899776' } }, jyjl: { title: '', data: [ { id: '', parentId: '', kaiShiShiJian: '2024-09-12', jieShuShiJian: '2024-09-13', xueXiao: '学校', zhuanYe: '软件', xueLiXueWei: '学士', fuJian: '1305918421677899776' }, { id: '', parentId: '', kaiShiShiJian: '2024-09-12', jieShuShiJian: '2024-09-13', xueXiao: '学校', zhuanYe: '软件', xueLiXueWei: '学士', fuJian: '1305918421677899776' } ] }, gzjl: { title: '', data: [ { id: '', parentId: '', ruZhiShiJian: '2024-09-12', liZhiShiJian: '2024-09-13', danWeiMingCheng: '医院', buMen: '临检', zhiWei: '检验员', gongZuoNeiRong: '检测', fuJian: '1305918421677899776' }, { id: '', parentId: '', ruZhiShiJian: '2024-09-12', liZhiShiJian: '2024-09-13', danWeiMingCheng: '医院', buMen: '临检', zhiWei: '检验员', gongZuoNeiRong: '检测', fuJian: '1305918421677899776' } ] }, zsb: { title: '', data: [ { id: '', parentId: '', zhengShuMingC: '毕业证书', zhengJianHao: '201101101-002', faZhengDanWei: '学校', faZhengShiJian: '2024-09-12', dangAnBaoCun: '原件', huoJiangZhengS: '1305918421677899776' }, { id: '', parentId: '', zhengShuMingC: '毕业证书', zhengJianHao: '201101101-002', faZhengDanWei: '学校', faZhengShiJian: '2024-09-12', dangAnBaoCun: '原件', huoJiangZhengS: '1305918421677899776' } ] } } export const externalSourceDataObj = { kyxmglb: { display: 'Y', title: '', data: [ { id: '', parentId: '', tenantId: '', xingMing: 'name', xiangMuMingChe: '1212121', xiangMuBianHao: '121212', zhuChiCanYu: '参与', quanBuCanYuRe: '1212', qiZhiShiJian: '2024-09-12', ziZhiDanWei: '111', jieShuShiJian: '2024-09-13', xiangMuLeiXing: '1212', liXiangJingFei: '1212', shangCLXWD: '1305918421677899776' }, { id: '', parentId: '', tenantId: '', xingMing: '2024-09-12', xiangMuMingChe: '1212121', xiangMuBianHao: '121212', zhuChiCanYu: '参与', quanBuCanYuRe: '1212', qiZhiShiJian: '2024-09-12', ziZhiDanWei: '111', jieShuShiJian: '2024-09-13', xiangMuLeiXing: '1212', liXiangJingFei: '1212', shangCLXWD: '1305918421677899776' } ] }, kjhjcgglb: { display: 'Y', title: '', data: [ { id: '', parentId: '', tenantId: '', xingMing: 'name', jiangLiLeiXing: 'qww', jiangLiXiangMu: '研究', huoJiangShiJia: '2024-09-13', quanBuHuoJiang: '1,2,3', geRenPaiMing: '1', danWei: '医院', paiMing: '2', shangCHJZS: '1305918421677899776' }, { id: '', parentId: '', tenantId: '', xingMing: 'name', jiangLiLeiXing: 'qww', jiangLiXiangMu: '研究', huoJiangShiJia: '2024-09-13', quanBuHuoJiang: '1,2,3', geRenPaiMing: '1', danWei: '医院', paiMing: '2', shangCHJZS: '1305918421677899776' } ] }, SCIwzglb: { display: 'Y', title: '', data: [ { id: '', parentId: '', tenantId: '', xingMing: 'name', qiJuanHao: '20220101-111', lunWenTiMu: '题目', yingXiangYZIf: '23', quanBuZuoZhe: '1,2,3', geRenPaiMing: '2', qiKanMingCheng: '名称', lunWenLianJie: 'https://', faBiaoShiJian: '2024-09-12', wosHao: '243234', shangChuanYuan: '1305918421677899776', beiZhu: 'dffsfsdfsdf' }, { id: '', parentId: '', tenantId: '', xingMing: 'name', qiJuanHao: '20220101-111', lunWenTiMu: '题目', yingXiangYZIf: '23', quanBuZuoZhe: '1,2,3', geRenPaiMing: '2', qiKanMingCheng: '名称', lunWenLianJie: 'https://', faBiaoShiJian: '2024-09-12', wosHao: '243234', shangChuanYuan: '1305918421677899776', beiZhu: 'dffsfsdfsdf' } ] }, zwlwglb: { display: 'Y', title: '', data: [ { id: '', parentId: '', tenantId: '', xingMing: 'name', faBiaoShiJian: '2024-09-12', lunWenTiMu: '', qiKanLeiBie: 'CSCD核心库与扩展库及EI', quanBuZuoZhe: '1,2,3', lunWenLianJie: 'https://', qiKanMingCheng: '期刊', geRenPaiMing: '2', qiJuanHao: '22', issnHao: '666', shangChuanYuan: '1305918421677899776', beiZhuA: '2132137239812739' }, { id: '', parentId: '', tenantId: '', xingMing: 'name', faBiaoShiJian: '2024-09-12', lunWenTiMu: '', qiKanLeiBie: 'CSCD核心库与扩展库及EI', quanBuZuoZhe: '1,2,3', lunWenLianJie: 'https://', qiKanMingCheng: '期刊', geRenPaiMing: '2', qiJuanHao: '22', issnHao: '666', shangChuanYuan: '1305918421677899776', beiZhuA: '2132137239812739' } ] }, kyzzglb: { display: 'Y', title: '', data: [ { id: '', parentId: '', tenantId: '', xingMing: 'name', chuBanShe: '出版社', zhuanZhuoMingChen: '书名', chuBanShiJian: '2024-09-12', quanBuZuoZhe: '1,2,3', bianZhuanZiShu: '100002', zhuBianBianWei: '主编', lianJie: 'https://', shangChuanYuan: '1305918421677899776', beiZhu: 'sdfsfsdff' }, { id: '', parentId: '', tenantId: '', xingMing: 'name', chuBanShe: '出版社', zhuanZhuoMingChen: '书名', chuBanShiJian: '2024-09-12', quanBuZuoZhe: '1,2,3', bianZhuanZiShu: '100002', zhuBianBianWei: '主编', lianJie: 'https://', shangChuanYuan: '1305918421677899776', beiZhu: 'sdfsfsdff' } ] }, kyzlglb: { display: 'Y', title: '', data: [ { id: '', parentId: '', tenantId: '', xingMing: 'name', leiBie: '类别', zhuanLiMingCheng: '', shenQingShiJian: '2024-09-12', quanBuShenQingRen: '人', shouQuanShiJian: '2024-09-12', zhuanLiQuanRen: '人', geRenPaiMing: '2', fuJian: '1305918421677899776', beiZhu: 'sdfsfsdff' }, { id: '', parentId: '', tenantId: '', xingMing: 'name', leiBie: '类别', zhuanLiMingCheng: '', shenQingShiJian: '2024-09-12', quanBuShenQingRen: '人', shouQuanShiJian: '2024-09-12', zhuanLiQuanRen: '人', geRenPaiMing: '2', fuJian: '1305918421677899776', beiZhu: 'sdfsfsdff' } ] }, jxjyxmxshdglb: { display: 'Y', title: '', data: [ { id: '', parentId: '', tenantId: '', xingMing: 'name', xueFen: '34', xiangMuBianHao: '20120102-002', juBanShiJian: '2024-09-12', quanBuZuoZhe: '1,2,3', juBanDiDian: '会议室', huiYiMingCheng: '开会', heZuoDanWei: '医院', xueFenJiBie: '国家级继教项目', huoDXCZPSC: '1305918421677899776', huiYiTongZhiS: '1305918421677899776' }, { id: '', parentId: '', tenantId: '', xingMing: 'name', xueFen: '34', xiangMuBianHao: '20120102-002', juBanShiJian: '2024-09-12', quanBuZuoZhe: '1,2,3', juBanDiDian: '会议室', huiYiMingCheng: '开会', heZuoDanWei: '医院', xueFenJiBie: '国家级继教项目', huoDXCZPSC: '1305918421677899776', huiYiTongZhiS: '1305918421677899776' } ] }, kphdglb: { display: 'Y', title: '', data: [ { id: '', parentId: '', tenantId: '', xingMing: 'name', kePuBianHao: '123', huoDongShiJian: '2024-09-09', kePuXingShi: '科普文章', fuJian: '1305918421677899776', beiZhu: '12312321321321' } ] } } export const tabName = { kphdglb: 'kphd', kyxmglb: 'kyxm', kjhjcgglb: 'kjhjcg', SCIwzglb: 'sci', zwlwglb: 'zwlw', kyzzglb: 'kyzz', kyzlglb: 'kyzl', jxjyxmxshdglb: 'jxjy', bmsm: 'bmsm' } export const data = '{"id":"","shiFouGuoShen":"已编制","jiaoYuId":"1315704890411974656,1309159909132075008","gongZuoId":"1309159909136269313,1315700904648769536,1309159909136269312","neiBuId":"1304386884142628865","waiBuId":"","kaoHeId":"","keYanId":"1278845812985561088","huoJiangId":"1313555341203472384,1314646912695009280","scIid":"","zhongWenId":"1313562201641975808","zhuanZhuoId":"1314884868894621696","zhuanLiId":"1313563580292923392","jiXuId":"","zhengShuId":"1309159909136269315,1309159909136269314,1315704890915291136","kaoShiId":"","bianZhiBuMen":"1259815242628595712","bianZhiRen":"702117247933480960","bianZhiShiJian":"2024-12-10 11:16","buMen":"1040707811132047360","dianHua":"18373382991","mingCheng":"702117247933480960","youXiang":"938764563@qq.com","yuanGongBianHao":"12231","diZhi":"2222","xingBie":"male","gangWei":"466555953945247744","jianDangRiQi":"","zuiGaoXueLiXueWei":"博士","zhiChengDengJi":"中级","shenFenZhengHaoMa":"","chuShengRiQi":"1996-07-11","nianLing":28,"biYeYuanXiao":"","ruZhiShiJian":"","zhiCheng":"","qianZiTuWen":"","baoMiXieYi":"","chengNuoHan":"","sheBao":"","jyjl":[],"gzjl":[],"xygpx":[],"pxjl":[],"rykhda":[],"kyxm":[],"kjhjcg":[],"SCIwztjb":[],"zwlw":[],"kyzz":[],"kyzl":[],"jxjyxmxshd":[],"zsb":[],"ksjlb":[]}' // export const baseName = { // ryjbqk: 'kphd', // kyxmglb: 'kyxm', // kjhjcgglb: 'kjhjcg', // SCIwzglb: 'sci', // zwlwglb: 'zwlw', // kyzzglb: 'kyzz', // kyzlglb: 'kyzl', // jxjyxmxshdglb: 'jxjy', // bmsm: 'bmsm' // } export function correlationSql (type, val) { let sql = `` const col = { jyrykhjlb: 'bei_kao_he_ren_yu', lhrynlqr: 'bei_shou_quan_ren', lhrypxjlb: 'peixunrenyuan', lhpxsqb: 'can_jia_ren_yuan_', kaoshijilu: 'examinee', tjbgb: 'xing_ming_' } if (type === 'jyrykhjlb' || type === 'lhrynlqr' || type === 'lhpxsqb') { sql = `select * from t_${type} where FIND_IN_SET('${val}',${col[type]}) and shi_fou_guo_shen_ = '已完成' ` } else if (type === 'kaoshijilu') { sql = `select * from v_examination where FIND_IN_SET('${val}',${col[type]}) and paperState = '已完成' ORDER BY createTime asc` } else if (type === 'lhrypxjlb') { sql = `select * from v_wodepeixun where FIND_IN_SET('${val}',${col[type]}) and shi_fou_guo_shen_ = '已结束' ` } else if (type === 'tjbgb') { sql = `select * from t_${type} where FIND_IN_SET('${val}',${col[type]})` } return sql } export const correlationConfig = { jyrykhjlb: { config: [ { label: '考核时机', width: '15%', type: 'text', field: 'kao_he_shi_ji_' }, { label: '岗位类型', width: '10%', type: 'text', field: 'gang_wei_lei_xing' }, { label: '考核时间', width: '15%', type: 'text', field: 'bian_zhi_shi_jian' }, { label: '总分', width: '10%', type: 'text', field: 'zong_fen_' }, { label: '考核结果', width: '12%', type: 'text', field: 'kao_he_jie_guo_' }, { label: '附件', width: '14%', type: 'file', field: 'shang_chuan_fu_ji' }, { label: '表单', width: '14%', type: 'file', field: 'kuai_zhao_' } ], dialog: [ [{ name: '被考核人员', field: 'bei_kao_he_ren_yu', type: 'user' }, { name: '考核时间', field: 'bian_zhi_shi_jian', type: 'text' }], [{ name: '考核时机', field: 'kao_he_shi_ji_', type: 'text' }, { name: '总分', field: 'zong_fen_', type: 'text' }], [{ name: '岗位类型', field: 'gang_wei_lei_xing', type: 'text' }, { name: '考核结果', field: 'kao_he_jie_guo_', type: 'text' }], [{ name: '附件', field: 'shang_chuan_fu_ji', type: 'file' }], [{ name: '表单', field: 'kuai_zhao_', type: 'file' }] ] }, lhrynlqr: { config: [ { label: '授权使用设备', width: '20%', type: 'dialog', field: 'shou_quan_shi_yon', dialogKey: 'sbwxdhk' }, { label: '授权岗位', width: '16%', type: 'dialog', field: 'shou_quan_gang_we', dialogKey: 'gwzzdhkrysqy' }, { label: '审核人', width: '10%', type: 'user', field: 'shen_he_ren_' }, { label: '检验专业', width: '10%', type: 'text', field: 'jian_yan_zhuan_ye' }, { label: '能力评估结果', width: '10%', type: 'text', field: 'kao_he_jie_guo_' }, { label: '附件', width: '12%', type: 'file', field: 'shang_chuan_fu_ji' }, { label: '表单', width: '12%', type: 'file', field: 'kuai_zhao_' } ], dialog: [ [{ name: '授权使用设备', field: 'shou_quan_shi_yon', type: 'dialog', dialogKey: 'sbwxdhk' }, { name: '能力评估结果', field: 'kao_he_jie_guo_', type: 'text' }], [{ name: '授权岗位', field: 'shou_quan_gang_we', type: 'dialog', dialogKey: 'gwzzdhkrysqy' }, { name: '考核日期', field: 'kao_he_shi_jian_', type: 'text' }], [{ name: '审核人', field: 'shen_he_ren_', type: 'user' }, { name: '检验专业', field: 'jian_yan_zhuan_ye', type: 'text' }], [{ name: '考核记录', field: 'xuan_ze_kao_he_ji', type: 'dialog', dialogKey: 'jyrykhdhkrysqy' }, { name: '是否合格', field: 'shi_fou_he_ge_', type: 'text' }], [{ name: '附件', field: 'shang_chuan_fu_ji', type: 'file' }], [{ name: '表单', field: 'kuai_zhao_', type: 'file' }] ] }, lhrypxjlb: { config: [ { label: '培训主题', width: '15%', type: 'text', field: 'pei_xun_nei_rong_' }, { label: '培训老师', width: '12%', type: 'text', field: 'pei_xun_lao_shi_' }, { label: '培训时间', width: '12%', type: 'text', field: 'pei_xun_shi_jian_' }, { label: '培训地点', width: '10%', type: 'text', field: 'pei_xun_di_dian_' }, { label: '培训内容', width: '12%', type: 'text', field: 'pei_xun_xue_xi_ne' }, { label: '见证性材料', width: '14%', type: 'file', field: 'jian_zheng_xing_c' }, { label: '表单', width: '14%', type: 'file', field: 'jlbkuai_zhao_' } ], dialog: [ [{ name: '培训主题', field: 'pei_xun_nei_rong_', type: 'text' }, { name: '培训目标', field: 'pei_xun_mu_di_', type: 'text' }], [{ name: '培训开始时间', field: 'pei_xun_shi_jian_', type: 'text' }, { name: '培训结束时间', field: 'pei_xun_jie_shu_s', type: 'text' }], [{ name: '培训老师', field: 'pei_xun_lao_shi_', type: 'text' }, { name: '培训地点', field: 'pei_xun_di_dian_', type: 'text' }], [{ name: '培训内容', field: 'pei_xun_xue_xi_ne', type: 'text' }], [{ name: '见证性材料', field: 'jian_zheng_xing_c', type: 'file' }], [{ name: '图片', field: 'tu_pian_id_', type: 'file' }], [{ name: '表单', field: 'jlbkuai_zhao_', type: 'file' }] ] }, lhpxsqb: { config: [ { label: '培训主题', width: '23%', type: 'text', field: 'pei_xun_nei_rong_' }, { label: '开始时间', width: '10%', type: 'text', field: 'pei_xun_kai_shi_s' }, { label: '结束时间', width: '10%', type: 'text', field: 'pei_xun_jie_shu_s' }, { label: '培训机构', width: '17%', type: 'text', field: 'pei_xun_ji_gou_' }, { label: '附件', width: '15%', type: 'file', field: 'pei_xun_fu_jian_' }, { label: '表单', width: '15%', type: 'file', field: 'kuai_zhao_' } ], dialog: [ [{ name: '培训主题', field: 'pei_xun_nei_rong_', type: 'text' }], [{ name: '培训目的', field: 'pei_xun_mu_di_', type: 'text' }], [{ name: '开始时间', field: 'pei_xun_kai_shi_s', type: 'text' }, { name: '结束时间', field: 'pei_xun_jie_shu_s', type: 'text' }], [{ name: '培训机构', field: 'pei_xun_ji_gou_', type: 'text' }, { name: '培训老师', field: 'pei_xun_lao_shi_', type: 'text' }], [{ name: '培训地点', field: 'pei_xun_di_dian_', type: 'text' }, { name: '参会形式', field: 'can_hui_xing_shi_', type: 'text' }], [{ name: '培训天数', field: 'pei_xun_tian_shu_', type: 'text' }, { name: '培训时长', field: 'pei_xun_shi_chang', type: 'text' }], [{ name: '是否有证书', field: 'shi_fou_you_zheng', type: 'text' }, { name: '发证单位', field: 'fa_zheng_dan_wei_', type: 'text' }], [{ name: '是否通过考核', field: 'shi_fou_kao_he_', type: 'text' }, { name: '考核情况', field: 'kao_he_qing_kuang', type: 'text' }], [{ name: '附件', field: 'pei_xun_fu_jian_', type: 'file' }], [{ name: '表单', field: 'kuai_zhao_', type: 'file' }] ] }, kaoshijilu: { config: [ { label: '考试名称', width: '15%', type: 'text', field: 'examName' }, { label: '考试题库', width: '15%', type: 'text', field: 'bankName' }, { label: '题库类型', width: '15%', type: 'text', field: 'bankType' }, { label: '考试题数', width: '10%', type: 'text', field: 'questionCount' }, { label: '考试总分', width: '10%', type: 'text', field: 'totalScore' }, { label: '得分', width: '10%', type: 'secondaryTreatment', field: 'panduandefen' }, { label: '考试达标状态', width: '10%', type: 'secondaryTreatment', field: 'panduanexamDesc' }, { label: '开始时间', width: '15%', type: 'text', field: 'startDate' }, { label: '参考次数', width: '10%', type: 'text', field: 'submittedCount' }, { label: '完成次数', width: '10%', type: 'text', field: 'completedCount' }, { label: '达标分值占比', width: '10%', type: 'text', field: 'qualifiedRadio' }, { label: '计分方式', width: '10%', type: 'text', field: 'scoringType' } ], dialog: [ [{ name: '考试名称', field: 'examName', type: 'text' }, { name: '考试达标状态', field: 'panduanexamDesc', type: 'secondaryTreatment' }], [{ name: '考试题库', field: 'bankName', type: 'text' }, { name: '开始时间', field: 'startDate', type: 'text' }], [{ name: '题库类型', field: 'bankType', type: 'text' }, { name: '参考次数', field: 'submittedCount', type: 'text' }], [{ name: '考试题数', field: 'questionCount', type: 'text' }, { name: '完成次数', field: 'completedCount', type: 'text' }], [{ name: '考试总分', field: 'totalScore', type: 'text' }, { name: '达标分值占比', field: 'qualifiedRadio', type: 'text' }], [{ name: '得分', field: 'panduandefen', type: 'secondaryTreatment' }, { name: '计分方式', field: 'scoringType', type: 'text' }] ] }, tjbgb: { config: [ { label: '体检日期', width: '20%', type: 'text', field: 'ti_jian_shi_jian_' }, { label: '体检机构', width: '30%', type: 'text', field: 'ti_jian_ji_gou_' }, { label: '附件', width: '40%', type: 'file', field: 'fu_jian_' } ], dialog: [ [{ name: '体检日期', field: 'ti_jian_shi_jian_', type: 'text' }, { name: '体检机构', field: 'ti_jian_ji_gou_', type: 'text' }], [{ name: '附件', field: 'fu_jian_', type: 'file' }] ] } } export default { baseDataObj, externalSourceDataObj, tabName, data, correlationSql // baseName }