fix(mapper): 修复多个查询的排序和字段映射问题

liyong

2026-04-21 bb7b2eaea4df4407e623f3438adbecb0f6188fd7

fix(mapper): 修复多个查询的排序和字段映射问题

- 在采购发票查询中添加 purchase_contract_number 字段到 GROUP BY 子句并按 sales_contract_no 降序排列
- 为个人考勤记录查询添加按 id 降序排列的排序规则
- 为生产产品主表查询修正 quantity 字段映射为 finished_num 并添加按 id 降序排列
- 为产品工单查询添加按 id 降序排列的排序规则
- 为库存盘点查询添加按 update_time 降序排列的排序规则

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

@@ -35,6 +35,7 @@
        <if test="c.version != null">
            and version = #{c.version}
        </if>
        order by id desc
    </select>
    <select id="getById" resultType="com.ruoyi.production.dto.ProductBomDto">
        select pb.*,

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

@@ -77,6 +77,7 @@
                pm.unit,
                p.product_name,
                po.nps_no
        order by pwo.id desc
    </select>
    <select id="selectWorkOrderStartStats" resultType="com.ruoyi.production.dto.ProductWorkOrderDto">
        SELECT

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

@@ -69,7 +69,7 @@
        pm.model as product_model_name,
        pm.unit,
        slpa.process,
        ppo.quantity,
        slpa.finished_num as quantity,
        slpa.work_hours,
        slpa.work_hours * slpa.finished_num AS wages
        FROM
@@ -95,6 +95,7 @@
                and slpa.scheduling_date &lt; date_add(#{ew.entryDateEnd}, INTERVAL 1 DAY)
            </if>
        </where>
                order by ppm.id desc
    </select>
    <select id="listMain" resultType="java.lang.Long">
        SELECT ppm.id FROM production_product_main ppm

 src/main/resources/mapper/purchase/InvoicePurchaseMapper.xml

@@ -26,9 +26,10 @@
        GROUP BY
        sl.sales_contract_no,
        sl.customer_name,
        sl.contract_amount
        sl.contract_amount,
        pl.purchase_contract_number
        ORDER BY
        sl.sales_contract_no
        sl.sales_contract_no desc
    </select>
    <select id="listVat" resultType="com.ruoyi.purchase.dto.VatDto">
        select *

 src/main/resources/mapper/staff/PersonalAttendanceRecordsMapper.xml

@@ -39,6 +39,7 @@
            and personal_attendance_records.date &gt;= #{params.date}
            and personal_attendance_records.date &lt; DATE_ADD(DATE(#{params.date}), INTERVAL 1 DAY)
        </if>
        order by personal_attendance_records.id desc
    </select>

    <!-- 查询指定日期没有考勤记录的在职员工（在指定时间之前入职的） -->
@@ -58,6 +59,7 @@
        WHERE par.staff_on_job_id = soj.id
        AND par.date = #{date}
        )
        ORDER BY soj.id
    </select>

    <!-- 检查指定员工在指定日期是否已存在考勤记录 -->

 src/main/resources/mapper/stock/StockInventoryMapper.xml

@@ -72,6 +72,7 @@
        <if test="ew.productName != null and ew.productName !=''">
            and p.product_name like concat('%',#{ew.productName},'%')
        </if>
        order by si.update_time desc
    </select>

    <select id="pageListCombinedStockInventory" resultType="com.ruoyi.stock.dto.StockInventoryDto">