不良品推送修改

whyclxw

2024-07-23 b790f058f791a66c1030843e48c23b179877193e

不良品推送修改

 src/main/resources/mapper/DefectiveProductsMapper.xml

@@ -22,6 +22,7 @@
    <select id="getDefectiveLimit" resultMap="defectiveList">
        select * from tb_defective_products
        <where>
         1=1
            <if test="dto.startTime!=null">
                and start_time>=#{dto.startTime}
            </if>
@@ -41,7 +42,7 @@
           order by start_time desc
    </select>

    <select id="selectDefectiveHis">
    <select id="selectDefectiveHis" resultType="defectiveProductsHistory">
        select * from tb_defective_products_history
        where deft_id=#{deftId}
        order by record_time desc