From dd1a51612fcd3c839d31dfa0df83b3d3071c8145 Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期五, 30 十月 2026 17:50:11 +0800
Subject: [PATCH] feat: 完善无人值守系统后端
---
src/main/java/com/ruoyi/unattended/mapper/UnattendedOperationMapper.java | 22 +++++++++++++++++++---
1 files changed, 19 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/ruoyi/unattended/mapper/UnattendedOperationMapper.java b/src/main/java/com/ruoyi/unattended/mapper/UnattendedOperationMapper.java
index c215d9c..78ddb9f 100644
--- a/src/main/java/com/ruoyi/unattended/mapper/UnattendedOperationMapper.java
+++ b/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);
}
--
Gitblit v1.9.3