| | |
| | | "com_pb_activity a\n" + |
| | | "left join sys_user u on a.create_by=u.user_id \n" + |
| | | "where a.community_id=#{partyBuildingActivityVO.communityId}\n" + |
| | | " and a.`status` not in(5,6) \n"+ |
| | | "<if test='partyBuildingActivityVO.name != null and partyBuildingActivityVO.name.trim() != ""'>" + |
| | | "and a.name = #{partyBuildingActivityVO.name} \n" + |
| | | " </if> " + |
| | | "<if test='partyBuildingActivityVO.isAppliets != null and partyBuildingActivityVO.isAppliets==1'>" + |
| | | " and a.`status` not in(5,6) " + |
| | | " </if> " + |
| | | "<if test='partyBuildingActivityVO.status != null and partyBuildingActivityVO.status != 0 and partyBuildingActivityVO.isAppliets ==null '>" + |
| | | "AND a.`status` = #{partyBuildingActivityVO.status} \n" + |
| | | " </if> " + |