forked from kidgrow-microservices-platform
parent: f14deee7 | patch | commit | ignore whitespace
houruijun
2020-11-04 f07d47834745d3e634094f7203543cb29bfb90f8 
修改bug：在创建时间一样的情况下，分页查询数据排序混乱
1 files modified
3 ■■■■■ changed files
kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/ProductOrderDetailMapper.xml 3 ●●●●● patch | view | raw | blame | history 
 kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/ProductOrderDetailMapper.xml


@@ -261,8 +261,7 @@


    order_id IN ( SELECT id FROM product_order WHERE hospital_id = #{hospitalId} AND department_id = #{departmentId} AND is_del = 0 AND enabled = 1 )


    AND is_del = 0


    AND enabled = 1


ORDER BY


    create_time DESC


ORDER BY id DESC


    </select>


    <select id="getUserdProduct" resultType="int">


        SELECT