优化查询闽西功能

java110

2021-07-28 ca3576ce00dcecb189aaffc08749c787262262ff

优化查询闽西功能

 java110-db/src/main/resources/mapper/report/ReportFeeYearCollectionDetailServiceDaoImplMapper.xml

@@ -47,6 +47,12 @@
        <if test="collectionId !=null and collectionId != ''">
            and t.collection_id= #{collectionId}
        </if>
        <if test="collectionIds !=null ">
            and t.collection_id in
            <foreach collection="collectionIds" item="item" open="(" close=")" separator=",">
                #{item}
            </foreach>
        </if>
        order by t.collection_year
        <if test="page != -1 and page != null ">
            limit #{page}, #{row}