| | |
| | | "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() != ""'>" + |
| | | "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() != ""'>" + |
| | | "d.title = #{title} \n" + |
| | | "<if test='partyBuildingComPbDynVO.title != null and partyBuildingComPbDynVO.title.trim() != ""'>" + |
| | | "and d.title = #{partyBuildingComPbDynVO.title} \n" + |
| | | " </if> " + |
| | | "<if test='status != null and status.trim() != ""'>" + |
| | | "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() != ""'>" + |
| | | "AND d.publish_at BETWEEN #{publishAtBegin} \n" + |
| | | "AND #{publishAtEnd} \n" + |
| | | "<if test='partyBuildingComPbDynVO.publishAtBegin != null and partyBuildingComPbDynVO.publishAtBegin.trim() != ""'>" + |
| | | "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); |
| | | } |