| | |
|---|
| | | * @param questId |
|---|
| | | * 问卷ID |
|---|
| | | */ |
|---|
| | | @Select("<script> " + "SELECT ac.* \n" |
|---|
| | | + "FROM com_act_questnaire_answer_content ac left JOIN com_act_questnaire_sub qs ON ac.sub_id = qs.id \n" |
|---|
| | | + " LEFT JOIN com_act_questnaire qn ON qs.que_Id = qn.id \n" + "WHERE qn.id=#{questId}\n" |
|---|
| | | + "ORDER BY ac.user_id, qs.id " + "</script>") |
|---|
| | | List<ComActQuestnaireAnswerContentDO> selectListByQuestnaire(@Param("questId") Long questId); |
|---|
| | | // @Select("<script> " + "SELECT ac.* \n" |
|---|
| | | // + "FROM com_act_questnaire_answer_content ac left JOIN com_act_questnaire_sub qs ON ac.sub_id = qs.id \n" |
|---|
| | | // + " LEFT JOIN com_act_questnaire qn ON qs.que_Id = qn.id \n" + "WHERE qn.id=#{questId}\n" |
|---|
| | | // + "ORDER BY ac.user_id, qs.id " + "</script>") |
|---|
| | | List<ComActQuestnaireAnswerContentVO> selectListByQuestnaire(@Param("questId") Long questId); |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 查询问卷用户回答数据 |
|---|
