| | |
| | | "a.id activityId,\n" + |
| | | "a.NAME,\n" + |
| | | "a.address,\n" + |
| | | "a.satus,\n" + |
| | | "a.status,\n" + |
| | | "a.create_at releaseTimeBegin,\n" + |
| | | "a.activity_time_begin,\n" + |
| | | "a.activity_time_end,\n" + |
| | |
| | | "enroll_time_end \n" + |
| | | "FROM\n" + |
| | | "com_bp_activity \n" + |
| | | "where community_id=#{communityId}\n"+ |
| | | "<if test='name != null and name.trim() != ""'>" + |
| | | "and name = #{name} \n" + |
| | | "where community_id=#{partyBuildingActivityVO.communityId}\n"+ |
| | | "<if test='partyBuildingActivityVO.name != null and partyBuildingActivityVO.name.trim() != ""'>" + |
| | | "and name = #{partyBuildingActivityVO.name} \n" + |
| | | " </if> " + |
| | | "<if test='status != null and status.trim() != ""'>" + |
| | | "AND `status` = #{status} \n" + |
| | | "<if test='partyBuildingActivityVO.status != null and partyBuildingActivityVO.status != 0'>" + |
| | | "AND `status` = #{partyBuildingActivityVO.status} \n" + |
| | | " </if> " + |
| | | "<if test='releaseTimeBegin != null and releaseTimeBegin.trim() != ""'>" + |
| | | "AND release_time BETWEEN #{releaseTimeBegin} \n" + |
| | | "AND #{releaseTimeEnd} \n" + |
| | | "<if test='partyBuildingActivityVO.releaseTimeBegin != null and partyBuildingActivityVO.releaseTimeBegin.trim() != ""'>" + |
| | | "AND release_time BETWEEN #{partyBuildingActivityVO.releaseTimeBegin} \n" + |
| | | "AND #{partyBuildingActivityVO.releaseTimeEnd} \n" + |
| | | " </if> " + |
| | | "<if test='activityTimeBegin != null and activityTimeBegin.trim() != ""'>" + |
| | | "AND activity_time_begin BETWEEN #{activityTimeBegin} \n" + |
| | | "AND #{activityTimeEnd}" + |
| | | "<if test='partyBuildingActivityVO.activityTimeBegin != null and partyBuildingActivityVO.activityTimeBegin.trim() != ""'>" + |
| | | "AND activity_time_begin BETWEEN #{partyBuildingActivityVO.activityTimeBegin} \n" + |
| | | "AND #{partyBuildingActivityVO.activityTimeEnd}" + |
| | | " </if> " + |
| | | "order by create_at desc "+ |
| | | "</script>") |