springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActQuestnaireAnswerContentDAO.java
@@ -30,7 +30,7 @@ @Select("<script> " + "SELECT qs.id AS sub_id, ac.choice as option_name, COUNT(ac.user_id) as total, ac.answer_content as answerContent, ac.type,\n" + " CONCAT(ROUND( COUNT(ac.user_id) /(SELECT COUNT(*) FROM com_act_questnaire_answer_content WHERE sub_id = qs.id) *100), '%') AS proportion\n" + "FROM com_act_questnaire qn LEFT JOIN com_act_questnaire_sub qs ON qn.id = qs.que_Id\n" + "FROM com_act_questnaire qn LEFT JOIN com_act_questnaire_sub qs ON qn.id = qs.que_id\n" + " LEFT JOIN com_act_questnaire_answer_content ac ON qs.id = ac.sub_id\n" + "WHERE qn.id=#{questId} \n" + "GROUP BY qs.id, ac.choice\n" + "ORDER BY qs.id" + "</script>") List<UserSubAnswerSelectionStatVO> selectQuestnaireStat(@Param("questId") Long questId); @@ -50,7 +50,7 @@ * 问卷ID */ @Select("<script> " + "SELECT u.name as user_name, ac.user_id , ac.create_at \n" + "FROM com_act_questnaire qn LEFT JOIN com_act_questnaire_sub qs ON qn.id = qs.que_Id\n" + "FROM com_act_questnaire qn LEFT JOIN com_act_questnaire_sub qs ON qn.id = qs.que_id\n" + " LEFT JOIN com_act_questnaire_answer_content ac ON qs.id = ac.sub_id\n" + " LEFT JOIN sys_user u ON ac.user_id = u.user_id \n" + "WHERE qn.id=#{pageQuestnaireAnswerDTO.questId}\n" + "GROUP BY user_id\n" + "ORDER BY ac.create_at\n" + "</script>") @@ -78,7 +78,7 @@ * 用户ID */ @Select("<script> " + "SELECT COUNT(*)\n" + "FROM com_act_questnaire q LEFT JOIN com_act_questnaire_sub qs ON q.id = qs.que_Id\n" + "FROM com_act_questnaire q LEFT JOIN com_act_questnaire_sub qs ON q.id = qs.que_id\n" + "LEFT JOIN com_act_questnaire_answer_content ac ON qs.id = ac.sub_id\n" + "WHERE q.id = #{questId} AND ac.user_id = #{userId}\n" + "</script>") Integer selectUserCountByQuestnaireId(@Param("questId") String questId, @Param("userId") Long userId); springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActQuestnaireAnswerContentDOMapper.xml
@@ -36,7 +36,7 @@ FROM com_act_questnaire_answer_content caqac LEFT JOIN com_act_questnaire_sub caqs ON caqac.sub_id = caqs.id LEFT JOIN com_act_questnaire caq ON caqs.que_Id = caq.id LEFT JOIN com_act_questnaire caq ON caqs.que_id = caq.id LEFT JOIN sys_user su ON caqac.user_id = su.user_id LEFT JOIN com_act_questnaire_user_answer caqua ON caqua.id = caqac.answer_id WHERE springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActQuestnaireDOMapper.xml
@@ -59,8 +59,8 @@ </select> <delete id="deleteQuesSubAll"> delete from com_act_questnaire_sub where que_Id = #{queId}; delete from com_act_questnaire_sub_selection where que_Id = #{queId}; delete from com_act_questnaire_sub where que_id = #{queId}; delete from com_act_questnaire_sub_selection where que_id = #{queId}; </delete> <select id="getQuesDetailAdmin" resultType="com.panzhihua.common.model.vos.community.questnaire.QuestnaireDetailAdminVO"> @@ -138,7 +138,7 @@ com_act_questnaire_sub_selection AS caqss LEFT JOIN com_act_questnaire_sub AS caqs ON caqs.id = caqss.que_sub_id WHERE caqss.que_Id = #{summaryDTO.questId} caqss.que_id = #{summaryDTO.questId} order by caqss.create_at asc </select> @@ -159,7 +159,7 @@ com_act_questnaire_sub_selection AS caqss LEFT JOIN com_act_questnaire_sub AS caqs ON caqs.id = caqss.que_sub_id WHERE caqss.que_Id = #{questId} caqss.que_id = #{questId} order by caqss.create_at asc </select>
