| | |
|---|
| | | // + "COUNT( DISTINCT c.id ) commentNum, " + "u.name userName, " + "u.nick_name userNickName, " + "d.create_at " |
|---|
| | | // + "FROM " + "com_act_discuss d " + "JOIN sys_user u ON d.user_id = u.user_id " |
|---|
| | | // + "LEFT JOIN com_act_discuss_comment c ON d.id = c.discuss_id " |
|---|
| | | // + " where d.community_id=#{pageComActDiscussDTO.communityId}" |
|---|
| | | // + " where d.community_id = #{pageComActDiscussDTO.communityId}" |
|---|
| | | // + "<if test='pageComActDiscussDTO.subject != null and pageComActDiscussDTO.subject.trim() != ""'>" |
|---|
| | | // + " and d.`discuss_subject` LIKE concat( #{pageComActDiscussDTO.subject}, '%' ) " + " </if> " |
|---|
| | | // + "<if test='pageComActDiscussDTO.begin != null '>" + "AND d.create_at BETWEEN #{pageComActDiscussDTO.begin} " |
|---|
| | |
|---|
| | | // + "LEFT JOIN com_act_discuss_user du ON d.id = du.discuss_id " |
|---|
| | | // + "<if test='pageComActDiscussDTO.loginUserId != null '>" |
|---|
| | | // + "LEFT JOIN com_act_discuss_option_user ou on do.id=ou.discuss_option_id and ou.user_id=#{pageComActDiscussDTO.loginUserId} " |
|---|
| | | // + " </if> " + " where d.community_id=#{pageComActDiscussDTO.communityId}" + " and d.is_del = 2" |
|---|
| | | // + " </if> " + " where d.community_id = #{pageComActDiscussDTO.communityId}" + " and d.is_del = 2" |
|---|
| | | // + "<if test='pageComActDiscussDTO.type != null '>" |
|---|
| | | // + " and d.`type` = #{pageComActDiscussDTO.type} " + " </if> " |
|---|
| | | // + "<if test='pageComActDiscussDTO.subject != null and pageComActDiscussDTO.subject.trim() != ""'>" |
|---|
| | |
|---|
| | | IPage<ComActDiscussCommentVO> pageDiscussCommentApplets(Page page, |
|---|
| | | @Param("pageComActDiscussCommentDTO") PageComActDiscussCommentDTO pageComActDiscussCommentDTO); |
|---|
| | | |
|---|
| | | @Select("select name,address from com_act where community_id=#{communityId}") |
|---|
| | | @Select("select name,address from com_act where community_id = #{communityId}") |
|---|
| | | ComActVO selectCommunity(Long communityId); |
|---|
| | | |
|---|
| | | @Select("SELECT " + "if(du.id is not null,1,0)haveSign, " + "if(ou.id is not null,1,0)haveVote " + "FROM " |
|---|
