| | |
|---|
| | | LEFT JOIN com_act_discuss_option_user ou ON do.id=ou.discuss_option_id AND ou.user_id=#{pageComActDiscussDTO.loginUserId} |
|---|
| | | </if> |
|---|
| | | WHERE d.is_del = 2 AND d.status != 1 |
|---|
| | | <if test="pageComActDiscussDTO.communityId ！=null and pageComActDiscussDTO.communityId !='' "> |
|---|
| | | <if test="pageComActDiscussDTO.communityId !=null and pageComActDiscussDTO.communityId !='' "> |
|---|
| | | AND d.community_id = ${pageComActDiscussDTO.communityId} |
|---|
| | | </if> |
|---|
| | | <if test="pageComActDiscussDTO.status ！=null and pageComActDiscussDTO.status !='' "> |
|---|
| | | <if test="pageComActDiscussDTO.status !=null and pageComActDiscussDTO.status !='' "> |
|---|
| | | AND d.status = ${pageComActDiscussDTO.status} |
|---|
| | | </if> |
|---|
| | | <if test="pageComActDiscussDTO.keyWord ！=null and pageComActDiscussDTO.keyWord !='' "> |
|---|
| | | <if test="pageComActDiscussDTO.keyWord !=null and pageComActDiscussDTO.keyWord !='' "> |
|---|
| | | AND d.vote_title like concat('%',${pageComActDiscussDTO.keyWord},'%') |
|---|
| | | </if> |
|---|
| | | <if test="pageComActDiscussDTO.isPbMember == 0"> |
|---|
