id_, user_id_, user_name_, evaluation_time_, in_count_, not_count_, total_count, level_, position_id_ SELECT e.* from exam_user_evaluation e ${ew.customSqlSegment} SELECT e.id_, e.subject_name_, o.user_id_, u.fullname_ AS userName, y.year_, y.totalCount, COALESCE ( e.in_count_, 0 ) AS inCount, (y.totalCount - COALESCE ( e.in_count_, 0 )) as notCount, y.position_id_, e.evaluation_time_, e.level_ FROM uc_user u LEFT JOIN uc_org_user o on u.id_ = o.user_id_ LEFT JOIN ( SELECT e.position_id_,e.year_,count(e.*) as totalCount FROM exam_year_assessment_sub e GROUP BY e.position_id_,e.year_) y on o.pos_id_ = y.position_id_ LEFT JOIN exam_user_evaluation e on e.user_id_ = u.id_ and y.position_id_ = e.position_id_ ${ew.customSqlSegment} WHERE AND y.position_id_ is not NULL SELECT subject_ids_ AS subjectId, subject_name_ AS subjectName FROM exam_year_assessment_sub WHERE position_id_ = #{vo.positionId} AND year_ = #{vo.year} SELECT b.id_ as paperId,b.name_ as name FROM exam_paper_base b LEFT JOIN exam_paper_setting s on s.paper_id_ = b.id_ WHERE b.is_dele_ = '0' AND b.paper_type_ = '2' AND b.create_time_ > date_trunc( 'year', now( ) ) AND date_trunc( 'year', now( ) ) + INTERVAL '1 year' > b.create_time_ and s.status_ not in('1') AND b.subject_id_ = #{ vo.subjectId} SELECT s.name_ as subjectName, s.id_ as subjectId FROM exam_subject_info s LEFT JOIN exam_subject_pos p ON s.id_ = p.subject_id_ WHERE p.position_id_ = #{positionId} AND s.train_type_ = #{type} SELECT d.subject_name_ AS subjectname FROM exam_user_evaluation_detail d LEFT JOIN uc_org_user u ON u.user_id_ = d.user_id_ WHERE d.type_ = '2' AND u.org_id_ = #{orgId} AND d.year_ = #{year} GROUP BY d.subject_name_ SELECT DISTINCT s.name_ FROM exam_subject_info s LEFT JOIN exam_subject_pos p ON s.id_ = p.subject_id_ LEFT JOIN (SELECT s.* FROM (SELECT count(*) as count,p.position_id_ FROM exam_subject_info s LEFT JOIN exam_subject_pos p ON s.id_ = p.subject_id_ WHERE s.train_type_ = '4' and s.is_dele_ ='0' AND p.org_id_ = #{orgId} GROUP BY s.train_type_,p.position_id_) s ORDER BY s.count desc LIMIT 1) a on a.position_id_ = p.position_id_ WHERE s.train_type_ = '4' and s.is_dele_ ='0' AND p.org_id_ = #{orgId} SELECT DISTINCT s.name_ FROM exam_subject_info s LEFT JOIN exam_subject_pos p ON s.id_ = p.subject_id_ LEFT JOIN (SELECT s.* FROM (SELECT count(*) as count,p.org_id_ FROM exam_subject_info s LEFT JOIN exam_subject_pos p ON s.id_ = p.subject_id_ WHERE s.train_type_ = '4' and s.is_dele_ ='0' AND p.org_id_ = #{orgId} GROUP BY s.train_type_,p.org_id_) s ORDER BY s.count desc LIMIT 1) a on a.org_id_ = p.org_id_ WHERE s.train_type_ = '4' and s.is_dele_ ='0' AND p.org_id_ = #{orgId} SELECT s.*,p.pos_name_ as posName FROM (SELECT e.position_id_ as positionId, e.year_, COUNT ( 1 ) AS shouldCount, COUNT ( CASE WHEN e.in_count_ = 0 THEN '1' END ) AS lackCount, COUNT ( CASE WHEN e.in_count_ > 0 THEN '1' END ) AS actualCount, COUNT ( CASE WHEN e.level_ = '4' or e.level_ is null THEN '1' END ) AS noPassCount, COUNT ( CASE WHEN e.level_ != '4' THEN '1' END ) AS passCount FROM exam_user_evaluation e GROUP BY e.position_id_, e.year_) s LEFT JOIN uc_org_post p on p.id_ = s.positionId ${ew.customSqlSegment} SELECT * FROM exam_org_evaluation ${ew.customSqlSegment} SELECT p.pos_name_ as posName,s.subject_ids_ as subjectId, s.* FROM exam_year_assessment_sub s LEFT JOIN uc_org_post P ON P.id_ = s.position_id_ ${ew.customSqlSegment} SELECT pos_id_ as positionId, COUNT ( * ) as shouldCount FROM uc_org_user WHERE is_dele_='0' and pos_id_ in #{posId} GROUP BY pos_id_ SELECT e.position_id_ AS positionId, e.year_, e.subject_id_ as subjectId, COUNT ( 1 ) AS actualCount, COUNT ( CASE WHEN e.level_ = '4' OR e.level_ IS NULL THEN '1' END ) AS noPassCount, COUNT ( CASE WHEN e.level_ != '4' THEN '1' END ) AS passCount FROM exam_user_evaluation_detail e WHERE e.year_=#{year} GROUP BY e.position_id_, e.year_, e.subject_id_ SELECT e.* from exam_user_evaluation e ${ew.customSqlSegment}