#

luxiaotao1123

2021-08-27 6f906b70ac1b18fb9c0f10620318981ced79f8e1

#

 src/main/resources/mapper/WaitMatinMapper.xml

@@ -51,20 +51,26 @@
    <select id="getHeadPage" resultMap="BaseResultMap">
        select * from
        (
        select distinct bill_no, bill_type, appe_time,
        ROW_NUMBER() over (order by appe_time) as row
        from ints_wait_matin
        <include refid="condition"></include>
            select *,
            ROW_NUMBER() over (order by appe_time) as row
            from (
                select distinct bill_no, bill_type, appe_time
                from ints_wait_matin
                <include refid="condition"></include>
            ) r
        ) t where t.row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize})
    </select>

    <select id="getHeadPageCount" parameterType="java.util.Map" resultType="java.lang.Integer">
        select count(1) from
        (
        select distinct bill_no, bill_type, appe_time,
        ROW_NUMBER() over (order by appe_time) as row
        from ints_wait_matin
        <include refid="condition"></include>
            select *,
            ROW_NUMBER() over (order by appe_time) as row
            from (
                select distinct bill_no, bill_type, appe_time
                from ints_wait_matin
                <include refid="condition"></include>
            ) r
        ) t
    </select>