| | |
|---|
| | | + " left join com_act_questnaire_user_answer as caqua on caqua.questnaire_id = caq.id and caqua.user_id = #{pageQuestnaireDTO.userId} " |
|---|
| | | + "WHERE " + " caq.state IN ( 2, 3 ) " |
|---|
| | | + " AND caq.community_id = #{pageQuestnaireDTO.communityId} and caq.is_hide = 0 " + "ORDER BY " |
|---|
| | | + " caq.state ASC, " + " isAnswer desc, " + " caq.create_at DESC" + "</script>") |
|---|
| | | + " caq.state ASC, " + " isAnswer ASC, " + " caq.create_at DESC" + "</script>") |
|---|
| | | IPage<QuestnaireListVo> selectPageList(Page page, @Param("pageQuestnaireDTO") PageQuestnaireDTO pageQuestnaireDTO); |
|---|
| | | |
|---|
| | | @Select("<script>" |
|---|
