fix: 工艺路线根据根据日期排序、迷糊查询

gongchunyi

6 小时以前 4c8302471963b00c1522f7e6978b96d5c539e819

fix: 工艺路线根据根据日期排序、迷糊查询

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

@@ -15,8 +15,17 @@
    </resultMap>

    <select id="pageProcessRouteDto" resultType="com.ruoyi.production.dto.ProcessRouteDto">
        select *
        from process_route ps
        order by ps.id
        SELECT
        ps.*,
        p.id AS productId,
        p.product_name AS productName
        FROM process_route ps
        LEFT JOIN product p ON ps.product_model_id = p.id
        <where>
            <if test="c.processRouteName != null and c.processRouteName != ''">
                AND ps.process_route_name LIKE CONCAT('%', #{c.processRouteName}, '%')
            </if>
        </where>
        ORDER BY ps.update_time DESC, ps.id DESC
    </select>
</mapper>