id_, paper_base_id_, user_id_, user_name_, ip_, start_time_, end_time_, answer_time_, sys_score_, user_score_, total_score_, mark_user_, mark_time_, status_, record_ SELECT d.*,q.* FROM exam_user_record_detail d LEFT JOIN exam_questions_info q on q.id_ = d.question_id_ WHERE d.record_id_ = #{vo.recordId} order by d.create_time_ asc SELECT user_id_,user_name_,position_id_,account_ FROM exam_user_record where paper_id_ = #{paperId} SELECT b.total_score_,b.paper_type_,s.* ,sp.plan_start_time_,sp.plan_end_time_,b.name_ as paperName, r.name_ as roomName,b.total_number_,sp.time_length_,b.subject_name_ as subjectName FROM exam_user_record s LEFT JOIN exam_paper_setting sp ON sp.paper_id_ = s.paper_id_ LEFT JOIN exam_paper_base b on b.id_ = s.paper_id_ LEFT JOIN exam_room_info r on r.id_ = sp.room_id_ ${ew.customSqlSegment} SELECT b.total_score_, b.subject_name_, b.paper_type_, b.name_ AS paperName, s.plan_start_time_,s.plan_end_time_, COALESCE ( a.avgScore, 0 ) AS avgScore, COALESCE ( a.actualCount, 0 ) AS actualCount, COALESCE ( a.lackCount, 0 ) AS lackCount, COALESCE ( t.passCount, 0 ) AS passCount FROM exam_paper_base b LEFT JOIN exam_paper_setting s ON s.paper_id_ = b.id_ LEFT JOIN (SELECT u.paper_id_, AVG ( u.sys_score_ ) as avgScore, sum(case when u.status_ in ('1','6','7','8') then 1 else 0 end) as lackCount, sum(case when u.status_ in ('2','3','4','5') then 1 else 0 end) as actualCount FROM exam_user_record u GROUP BY u.paper_id_) a on a.paper_id_ = b.id_ LEFT JOIN (SELECT count(*) as passCount,s.paper_id_ FROM exam_paper_setting s LEFT JOIN exam_user_record u on u.paper_id_ = s.paper_id_ WHERE u.total_score_ > s.pass_score_ GROUP BY s.paper_id_) t on t.paper_id_ = a.paper_id_ ${ew.customSqlSegment} SELECT count(*) as userCount FROM uc_user WHERE is_dele_ = '0' and USER_TYPE_='2' SELECT b.total_score_,s.* ,b.name_ as paperName,sp.plan_start_time_,sp.plan_end_time_ FROM exam_user_record s LEFT JOIN exam_paper_base b on b.id_ = s.paper_id_ LEFT JOIN exam_paper_setting sp ON sp.paper_id_ = s.paper_id_ where s.user_id_ =#{userId} and s.status_ != '0' SELECT b.total_score_,b.paper_type_,s.* ,sp.plan_start_time_,sp.plan_end_time_,b.name_ as paperName, r.name_ as roomName,b.total_number_,sp.time_length_,b.subject_name_ as subjectName FROM exam_user_record s LEFT JOIN exam_paper_setting sp ON sp.paper_id_ = s.paper_id_ LEFT JOIN exam_paper_base b on b.id_ = s.paper_id_ LEFT JOIN exam_room_info r on r.id_ = sp.room_id_ left JOIN exam_user_evaluation e on e.user_id_ = s.user_id_ and e.position_id_ = s.position_id_ and e.year_ = to_char((SELECT s.start_time_::timestamp),'yyyy') ${ew.customSqlSegment} SELECT s.* FROM exam_user_record s LEFT JOIN exam_paper_base b ON b.id_ = s.paper_id_ WHERE b.is_dele_ = '0' and b.paper_type_ ='2' and s.status_ = '5' AND s.position_id_ =#{vo.positionId} AND s.user_id_ = #{vo.userId} and s.level_ is not null and b.create_time_> date_trunc('year', now()) and date_trunc('year', now()) + interval '1 year' > b.create_time_ SELECT b.id_ as paperId, s.user_id_ as userId, s.user_name_ as userName, b.subject_name_ as subjectName, su.train_type_ as trainType, s.sys_score_ as score, s.level_ as level FROM exam_user_record s LEFT JOIN exam_paper_setting sp ON sp.paper_id_ = s.paper_id_ LEFT JOIN exam_paper_base b ON b.id_ = s.paper_id_ LEFT JOIN exam_subject_info su ON su.id_ = b.subject_id_ WHERE s.user_id_ = #{userId} AND b.paper_type_ = '2' AND EXTRACT(YEAR FROM sp.plan_start_time_) <= #{year} AND EXTRACT(YEAR FROM sp.plan_end_time_) >= #{year} AND su.train_type_ in ('2','4')