feat: 完善无人值守系统后端

liu

10 天以前 dd1a51612fcd3c839d31dfa0df83b3d3071c8145

 src/main/java/com/ruoyi/unattended/mapper/UnattendedOperationMapper.java

@@ -1,14 +1,30 @@
package com.ruoyi.unattended.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.account.pojo.AccountReconciliation;
import com.ruoyi.unattended.pojo.UnattendedOperation;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface UnattendedOperationMapper extends BaseMapper<UnattendedOperation> {

    /** 按承运商匹配销售订单 */
    @Select("<script>" +
            "select sales_contract_no as order_no, 'sales' as order_type " +
            "from sales_ledger where customer_name = #{carrierName} " +
            "order by id desc limit 1" +
            "</script>")
    List<Map<String, Object>> matchSalesOrder(@Param("carrierName") String carrierName);

    /** 按承运商匹配采购订单 */
    @Select("<script>" +
            "select purchase_contract_number as order_no, 'purchase' as order_type " +
            "from purchase_ledger where supplier_name = #{carrierName} " +
            "order by id desc limit 1" +
            "</script>")
    List<Map<String, Object>> matchPurchaseOrder(@Param("carrierName") String carrierName);
}