质量检测查询修改排序

yuan

5 天以前 20ad0e6c5ae8553c3a1af2b9ba92f6358f1e408b

质量检测查询修改排序

 src/main/resources/mapper/production/ProductOrderMapper.xml

@@ -64,6 +64,7 @@
                and po.create_time between #{c.startTime} and #{c.endTime}
            </if>
        </where>
        order by po.nps_no desc
    </select>
    <select id="listProcessRoute" resultType="com.ruoyi.production.pojo.ProcessRoute">
        select pr.*

 src/main/resources/mapper/production/ProductWorkOrderMapper.xml

@@ -61,6 +61,7 @@
        <if test="c.productOrderId != null and c.productOrderId != ''">
            and pwo.product_order_id = #{c.productOrderId}
        </if>
        order by po.nps_no desc, pwo.work_order_no desc
    </select>

    <select id="getProductWorkOrderFlowCard" resultType="com.ruoyi.production.dto.ProductWorkOrderDto">

 src/main/resources/mapper/production/ProductionProductMainMapper.xml

@@ -49,7 +49,7 @@
                and ppm.status = #{c.status}
            </if>
        </where>
        order by ppm.id
        order by ppm.id desc 

    </select>
    <select id="getOrderByMainId" resultType="com.ruoyi.production.pojo.ProductOrder">