lh_firm_former/src/views/component/personnelFile/constants/simulated.js

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
}