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 = { //khjlqrb: "bei_kao_he_ren_", khjlqrb: "bei_kao_he_ren_yu", lhrynlqr: "bei_shou_quan_ren", lhrypxjlb: "peixunrenyuan", lhpxsqb: "can_jia_ren_yuan_", kaoshijilu: "examinee", tjbgb: "xing_ming_", }; if (type === "khjlqrb") { sql = `select * from t_jyrykhjlb where FIND_IN_SET('${val}',${col[type]}) and shi_fou_guo_shen_ = '已完成'`; }else if (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 = '已完成' and examType!='自主考核' 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 = { khjlqrb: { config: [ // { label: '考核时机', width: '15%', type: 'text', field: 'kao_he_shi_ji_' }, { label: "评估时机", width: "10%", type: "text", field: "kao_he_shi_ji_", }, { 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: "fu_jian_" }, { label: "表单", width: "14%", type: "file", field: "kuai_zhao_" }, ], dialog: [ [ { name: "被评估人员", field: "bei_kao_he_ren_", 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: "kao_he_shi_ji_", 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: "mjsbdjmcdhk", }, { label: "授权岗位", width: "16%", type: "position", field: "shou_quan_gang_we", }, // { 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: "neng_li_que_ren_", }, { 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: "mjsbdjmcdhk", }, { name: "能力确认", field: "kao_he_jie_guo_", type: "text" }, ], [ { name: "授权岗位", field: "shou_quan_gang_we", type: "dialog", dialogKey: "gwzzdhk", }, { name: "编制时间", field: "bian_zhi_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 };