package com.ruoyi.unattended.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
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);
}