| | |
| | | " com_act_questnaire aq \n" + |
| | | " LEFT JOIN sys_user u on aq.create_by = u.user_id \n" + |
| | | " where aq.is_hide=0 " + |
| | | "<if test='communityId != null and communityId!=0 '>\n" + |
| | | "<if test='communityId != null and communityId!=0l '>\n" + |
| | | " and aq.community_id = #{communityId}\n" + |
| | | " </if> " + |
| | | "<if test='pageQuestnaireDTO.state != null '>\n" + |
| | |
| | | " </if> \n" + |
| | | |
| | | "<if test='pageQuestnaireDTO.startTime != null '>\n" + |
| | | " AND aq.create_at BETWEEN \n" + |
| | | "#{pageComActDTO.startTime} \n" + |
| | | " AND #{pageQuestnaireDTO.endTime}\n" + |
| | | " AND aq.create_at <![CDATA[>=]]> #{pageQuestnaireDTO.startTime} \n" + |
| | | "</if>" + |
| | | "<if test='pageQuestnaireDTO.endTime != null '>\n" + |
| | | " AND aq.create_at <![CDATA[<=]]> #{pageQuestnaireDTO.endTime} \n" + |
| | | " </if> \n" + |
| | | " ORDER BY \n" + |
| | | " aq.create_at DESC" + |