huanghongfa
2020-12-06 22c0fa7dfd9d558ac09b4239101b6ae47b085573
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbDynDAO.java
@@ -31,23 +31,23 @@
            "FROM\n" +
            "com_pb_dyn d\n" +
            "LEFT JOIN com_pb_dyn_user u ON d.id = u.dyn_id \n" +
            "where d.type=#{type} \n" +
            "<if test='communityId != null and communityId.trim() != &quot;&quot;'>" +
            "d.community_id = #{communityId} \n" +
            "where d.type=#{partyBuildingComPbDynVO.type}  \n" +
            "<if test='partyBuildingComPbDynVO.communityId != null and partyBuildingComPbDynVO.communityId != 0'>" +
            "and d.community_id = #{partyBuildingComPbDynVO.communityId} \n" +
            " </if> " +
            "<if test='title != null and title.trim() != &quot;&quot;'>" +
            "d.title = #{title} \n" +
            "<if test='partyBuildingComPbDynVO.title != null and partyBuildingComPbDynVO.title.trim() != &quot;&quot;'>" +
            "and d.title = #{partyBuildingComPbDynVO.title} \n" +
            " </if> " +
            "<if test='status != null and status.trim() != &quot;&quot;'>" +
            "AND d.`status` = #{status} \n" +
            "<if test='partyBuildingComPbDynVO.status != null and partyBuildingComPbDynVO.status != 0'>" +
            "AND d.`status` = #{partyBuildingComPbDynVO.status} \n" +
            " </if> " +
            "<if test='publishAtBegin != null and publishAtBegin.trim() != &quot;&quot;'>" +
            "AND d.publish_at BETWEEN #{publishAtBegin} \n" +
            "AND #{publishAtEnd} \n" +
            "<if test='partyBuildingComPbDynVO.publishAtBegin != null and partyBuildingComPbDynVO.publishAtBegin.trim() != &quot;&quot;'>" +
            "AND d.publish_at BETWEEN #{partyBuildingComPbDynVO.publishAtBegin} \n" +
            "AND #{partyBuildingComPbDynVO.publishAtEnd} \n" +
            " </if> " +
            "GROUP BY\n" +
            "d.id\n" +
            "ORDER BY d.create_at desc"+
            "</script>")
    IPage<PartyCommitteeVO> pageYnamic(Page page, @Param("partyBuildingComPbDynVO") PartyBuildingComPbDynVO partyBuildingComPbDynVO);
    IPage<PartyBuildingComPbDynVO> pageYnamic(Page page, @Param("partyBuildingComPbDynVO") PartyBuildingComPbDynVO partyBuildingComPbDynVO);
}