上传的图像用于项目: 'CST技术支持'
  1. CST技术支持
  2. SLAL2-1077

入职记录新增报表

XMLWord打印

    • Icon: Change Change
    • 解决结果: 完成
    • Icon: High High
    • 202009
    • Y-易路产品-
    • tuhutest
    • 基础通用功能
    • 隐藏

      select
      a.applicant_without_request x_applicant_without_request,
      a.phone_number x_phone_number,
      a.estimated_onboard_date x_estimated_onboard_date,
      a.supervisor_id x_supervisor_id,
      a.x_onboardaddress x_x_onboardaddress,
      a.x_jobtitle x_x_jobtitle,
      a.x_salary x_x_salary,
      a.x_recruitment_sources x_x_recruitment_sources,
      c.x_education_type x_x_education_type,
      c.education_start x_education_start,
      c.education_end x_education_end,
      c.school x_school,
      c.profession x_profession,
      c.education_background x_education_background,
      c.academic_degree x_academic_degree,
      c.x_school_classes x_x_school_classes,
      c.certificate_code x_certificate_code,
      c.x_verification x_x_verification,
      c.the_highest_degree x_the_highest_degree,
      d.x_foreignlanguages x_x_foreignlanguages,
      d.x_languageslevel x_x_languageslevel,
      d.x_proficiency x_x_proficiency,
      d.x_languagenotes x_x_languagenotes,
      e.certificate x_certificate,
      e.start_date x_start_date_ct,
      e.end_date x_end_date_ct,
      e.training_id x_training_id,
      f.company x_company,
      f.industry x_industry,
      f.start_date x_start_date_work,
      f.end_date x_end_date_work,
      f.department x_department,
      f.job x_job,
      f.referee x_referee,
      f.referee_contact x_referee_contact
      from hr_recruitment_enroll a
      left join hr_applicant b
      on a.applicant_id=b.id
      left join applicant_education c
      on b.id=c.applicant_id
      left join x_builder_language_model d
      on b.id = d.x_code
      left join applicant_train_experience e
      on e.applicant_id = b.id
      left join hr_employment_history f
      on f.applicant_id=b.id

      显示
      select a.applicant_without_request x_applicant_without_request, a.phone_number x_phone_number, a.estimated_onboard_date x_estimated_onboard_date, a.supervisor_id x_supervisor_id, a.x_onboardaddress x_x_onboardaddress, a.x_jobtitle x_x_jobtitle, a.x_salary x_x_salary, a.x_recruitment_sources x_x_recruitment_sources, c.x_education_type x_x_education_type, c.education_start x_education_start, c.education_end x_education_end, c.school x_school, c.profession x_profession, c.education_background x_education_background, c.academic_degree x_academic_degree, c.x_school_classes x_x_school_classes, c.certificate_code x_certificate_code, c.x_verification x_x_verification, c.the_highest_degree x_the_highest_degree, d.x_foreignlanguages x_x_foreignlanguages, d.x_languageslevel x_x_languageslevel, d.x_proficiency x_x_proficiency, d.x_languagenotes x_x_languagenotes, e.certificate x_certificate, e.start_date x_start_date_ct, e.end_date x_end_date_ct, e.training_id x_training_id, f.company x_company, f.industry x_industry, f.start_date x_start_date_work, f.end_date x_end_date_work, f.department x_department, f.job x_job, f.referee x_referee, f.referee_contact x_referee_contact from hr_recruitment_enroll a left join hr_applicant b on a.applicant_id=b.id left join applicant_education c on b.id=c.applicant_id left join x_builder_language_model d on b.id = d.x_code left join applicant_train_experience e on e.applicant_id = b.id left join hr_employment_history f on f.applicant_id=b.id

      途虎快速入职菜单希望新增一个报表,用于显示入职记录处员工/店长填写的数据,并汇总下载,字段见附件

            grant.yang 杨光磊
            liuxz 刘襄周
            表决:
            0 为这个问题表决

              创建日期:
              已更新:
              已解决: