| | |
| | | " </if> " + |
| | | "where p.del_tag = 0 and p.status !=2"+ |
| | | "<if test='comActEasyPhotoVO.communityId != null and comActEasyPhotoVO.communityId != 0'>" + |
| | | " and p.community_id=#{comActEasyPhotoVO.communityId} " + |
| | | " and p.community_id = #{comActEasyPhotoVO.communityId} " + |
| | | " </if> " + |
| | | "<if test='comActEasyPhotoVO.happenAddr != null and comActEasyPhotoVO.happenAddr.trim() != ""'>" + |
| | | "AND p.happen_addr like concat(#{comActEasyPhotoVO.happenAddr},'%') " + |
| | |
| | | "and p.handler_id=#{comActEasyPhotoVO.backUserId}"+ |
| | | " </if> " + |
| | | "<if test='comActEasyPhotoVO.communityId != null and comActEasyPhotoVO.communityId != 0'>" + |
| | | " and p.community_id=#{comActEasyPhotoVO.communityId} " + |
| | | " and p.community_id = #{comActEasyPhotoVO.communityId} " + |
| | | " </if> " + |
| | | "<if test='comActEasyPhotoVO.happenAddr != null and comActEasyPhotoVO.happenAddr.trim() != ""'>" + |
| | | "AND p.happen_addr like concat(#{comActEasyPhotoVO.happenAddr},'%') " + |
| | |
| | | " <where>" + |
| | | " p.del_tag = 0 " + |
| | | "<if test='comActEasyPhotoVO.communityId != null and comActEasyPhotoVO.communityId != 0'>" + |
| | | " and p.community_id=#{comActEasyPhotoVO.communityId} " + |
| | | " and p.community_id = #{comActEasyPhotoVO.communityId} " + |
| | | " </if> " + |
| | | "<if test='comActEasyPhotoVO.status != null and comActEasyPhotoVO.status!=0' >" + |
| | | "AND p.`status` = #{comActEasyPhotoVO.status} " + |