龚焕茏
2024-05-24 2bf92184d4584cac58b76b8d1ea0b3b0ff34b4fb
fix:统计修改
1个文件已修改
2 ■■■ 已修改文件
src/main/resources/mapper/ExamPaperAnswerMapper.xml 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/resources/mapper/ExamPaperAnswerMapper.xml
@@ -535,7 +535,7 @@
      t_department a
        LEFT JOIN t_user_department b ON a.id = b.department_id
        LEFT JOIN t_exam_paper_answer c ON b.user_id = c.create_user AND (c.invalid = 0 OR c.invalid IS NULL) AND c.exam_paper_id = #{id}
        LEFT JOIN t_exam_paper_user d ON c.exam_paper_id = d.exam_paper_id and b.user_id = d.user_id
        LEFT JOIN t_exam_paper_user d ON b.user_id = d.user_id AND d.exam_paper_id = #{id}
    GROUP BY
      a.id, a.name
  </select>