huanghongfa
2020-12-06 22c0fa7dfd9d558ac09b4239101b6ae47b085573
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComBpActivityDAO.java
@@ -26,7 +26,7 @@
            "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" +
@@ -65,20 +65,20 @@
            "enroll_time_end \n" +
            "FROM\n" +
            "com_bp_activity \n" +
            "where community_id=#{communityId}\n"+
            "<if test='name != null and name.trim() != &quot;&quot;'>" +
            "and name = #{name} \n" +
            "where community_id=#{partyBuildingActivityVO.communityId}\n"+
            "<if test='partyBuildingActivityVO.name != null and partyBuildingActivityVO.name.trim() != &quot;&quot;'>" +
            "and name = #{partyBuildingActivityVO.name} \n" +
            " </if> " +
            "<if test='status != null and status.trim() != &quot;&quot;'>" +
            "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() != &quot;&quot;'>" +
            "AND release_time BETWEEN #{releaseTimeBegin} \n" +
            "AND #{releaseTimeEnd} \n" +
            "<if test='partyBuildingActivityVO.releaseTimeBegin != null and partyBuildingActivityVO.releaseTimeBegin.trim() != &quot;&quot;'>" +
            "AND release_time BETWEEN #{partyBuildingActivityVO.releaseTimeBegin} \n" +
            "AND #{partyBuildingActivityVO.releaseTimeEnd} \n" +
            " </if> " +
            "<if test='activityTimeBegin != null and activityTimeBegin.trim() != &quot;&quot;'>" +
            "AND activity_time_begin BETWEEN #{activityTimeBegin} \n" +
            "AND #{activityTimeEnd}" +
            "<if test='partyBuildingActivityVO.activityTimeBegin != null and partyBuildingActivityVO.activityTimeBegin.trim() != &quot;&quot;'>" +
            "AND activity_time_begin BETWEEN #{partyBuildingActivityVO.activityTimeBegin} \n" +
            "AND #{partyBuildingActivityVO.activityTimeEnd}" +
            " </if> " +
            "order by create_at desc "+
            "</script>")