id_, company_id_, company_name_, task_name_, task_describe_, task_type_, subject_id_, task_start_date_, task_end_date_, study_hour_,required_learning_time_,is_dele_, create_by_, create_name_, CREATE_ORG_NAME_, reate_company_id_, create_company_name_, CREATE_ORG_ID_, create_time_, update_by_, update_name_, update_company_name_, update_company_id_, update_org_id_, update_org_name_, update_time_, last_time_, tenant_id_ SELECT * FROM ( SELECT t.*, c.conf_name_ AS taskConfName, ou.org_id_ FROM biz_train_task t LEFT JOIN biz_train_task_conf c ON c.id_ = t.task_conf_id_ LEFT JOIN uc_org_user ou ON ou.user_id_ = t.user_id_ and ou.is_dele_ = '0' ) s ${ew.customSqlSegment} GROUP BY s.id_, s.taskConfName, s.org_id_ SELECT * FROM ( SELECT t.*, s.user_id_ AS userId, s.task_id_ as taskId, SUM( s.video_time_ ) AS videoTime, SUM( s.study_time_ ) AS studyTime FROM biz_train_task t LEFT JOIN biz_train_data_study_log s ON s.task_id_ = t.id_ GROUP BY t.id_, s.task_id_, s.user_id_ ) s ${ew.customSqlSegment} GROUP BY s.id_, s.userId, s.taskId select * from (SELECT *,IFNULL(count(user_id_),0) as personNum FROM biz_train_task group by task_conf_id_,id_) s ${ew.customSqlSegment} SELECT u.fullname_ AS userName, u.sex_, t.user_id_, t.content_, t.study_time_, t.train_user_names_, t.task_start_date_, t.task_end_date_ FROM biz_train_task t LEFT JOIN uc_user u ON u.id_ = t.user_id_ WHERE t.task_type_ = '1' AND u.id_ in #{userId} SELECT o.name_ as orgName, ou.user_id_, o.grade_ as grade FROM uc_org_user ou LEFT JOIN uc_org o on ou.org_id_ = o.id_ WHERE o.org_kind_='ogn' AND ou.user_id_ in #{userId} GROUP BY ou.org_id_,ou.user_id_ ORDER BY o.grade_ SELECT user_id_,code_,value_ FROM uc_user_params WHERE is_dele_ != '1' and user_id_ in #{userId} SELECT o.name_ AS orgName, ou.user_id_, "" AS positionName FROM uc_org_user ou LEFT JOIN uc_org o ON ou.org_id_ = o.id_ WHERE ou.is_dele_ = '0' AND ou.user_id_ in #{userId} GROUP BY ou.org_id_, ou.user_id_, -- 添加 user_id_ 到 GROUP BY 中 o.name_ UNION ALL SELECT "" AS orgName, ou.user_id_, p.pos_name_ AS positionName FROM uc_org_user ou LEFT JOIN uc_org_post p ON ou.pos_id_ = p.id_ WHERE ou.pos_id_ IS NOT NULL AND ou.is_dele_ = '0' AND ou.user_id_ in #{userId} GROUP BY ou.org_id_, ou.user_id_, -- 添加 user_id_ 到 GROUP BY 中 p.pos_name_ SELECT u.id_ AS id, u.sex_ AS sex, u.fullname_ AS userName, u.address_ AS address, u.mobile_ AS mobile FROM uc_user u WHERE u.is_dele_ != '1' AND u.id_ in #{userId} SELECT id_ AS id, user_id_ AS userId, birthday_ AS birthday, diploma_ AS diploma, hire_date_ AS hireDate, id_number_ AS idNumber, job_title_ AS jobTitle, work_type_ AS workType, skills_ AS skills, work_experience_ AS workExperience FROM biz_user_extend WHERE user_id_ IN #{userId}