新销售面试数据集

SELECT
        sr.id,
        sr.name as '姓名',
        INSERT(sr.phone, 4, 4, '****') as '手机号',
        INSERT(sr.email, 4, 4, '****') as '邮箱',
        sr.qq as 'QQ号',
        stations.name as '岗位',
        (case sr.workplace when 1 then '上海' when 2 then '北京' when 3 then '昆山花桥' end) as '工作地点',
        channel1.name as '一级渠道',
        channel2.name as '二级渠道',
        sr.referrer as '推荐人姓名',
        sr.referrerNo as '推荐人工号',
        sr.referrerStation as '推荐人岗位',
        (case sr.sex when 1 then '男' when 2 then '女' end) as '性别',
        sr.birthDay as '出生日期',
        sr.idCard as '省份证号',
        sr.followerId as '跟进人id',
        u.name as '跟进人姓名',
        (case sr.maritalStatus when 1 then '未婚' when 2 then '已婚' when 3 then '离异' else '' end) as '婚姻状态',
        sr.nativePlace as  '籍贯',
        (case sr.education when 1 then '中专' when 2 then '高中' when 3 then '专科' when 4 then '本科' when 5 then '硕士' when 6 then '博士' when 7 then '其他' else '' end) as '学历',
        sr.specialty as '专业',
        sr.graduationSchool as '毕业学校',
        sr.graduationDate as '毕业年份',
        (case sr.status when 1 then '待处理' when 2 then '再联系' when 3 then '未接通' when 4 then '已邀约' when 5 then '未参加面试' when 6 then '面试通过' when 7 then '已入培' when 8 then '出培' when 9 then '待定' when 10 then '淘汰' when 11 then '通培通过' end) as '简历状态',
        (case sr.backtrack when 1 then '是' when 0 then '否' else '' end) as '是否返聘',
        (case sr.withdraw when 1 then '是' when 0 then '否' else '' end) as '是否抽回',
        (SELECT name FROM sale_reason WHERE sr.withdrawReason = id) as '抽回原因',
        (SELECT name FROM sale_reason WHERE sr.outOneReason = id) as '一级淘汰原因',
        (SELECT name FROM sale_reason WHERE sr.outTwoReason = id) as '二级淘汰原因',
        (case sr.saleExp when 1 then '有' when 0 then '没有' else '' end) as '是否有电话销售经验',
        (case sr.graduate when 1 then '是' when 0 then '否' else '' end) as '是否应届生',
        sr.workExp as '工作经历',
        sr.remark as '备注',
        sr.adjunct as '附件',
        sr.employeeID as '员工编号',
        sr.aliMail as '阿里企业邮箱',
        sr.hiredate as '入职时间',
        sr.interviewer as '面试官姓名',
        sr.newestCommTime as '最新沟通时间',
        sr.interviewTime as '面试时间',
        sr.inTrainTime as '入培时间',
        sr.trainOverTime as '通培通过时间',
        sr.examinationTime as '出培时间',
        sr.outReasonTime as '淘汰时间',
        sr.nextCommTime as '下次沟通时间',
        (case sr.regResouce when 1 then '后台添加' when 2 then '数据导入' when 3 then '报名表' else '' end) as '数据来源',
        (SELECT name FROm view_sale_user WHERE view_sale_user.id = sr.adder) as '简历添加人',
        (SELECT name FROM view_sale_user WHERE view_sale_user.id = sr.trainer) as '培训师',
        sr.department as '入职部门',
        sr.createTime as '简历添加时间',
        sr.updateTime as '更新时间'
FROM
        view_sale_resume sr
LEFT JOIN
        sale_stations stations ON sr.stationId = stations.id
LEFT JOIN
        sale_channel channel1 ON channel1.id = sr.firstChannel
LEFT JOIN
        sale_channel channel2 ON channel2.id = sr.secondChannel
LEFT JOIN
        view_sale_user u ON u.id = sr.followerId
文档更新时间: 2019-08-19 11:54   作者:admin