From 3d1abf712307e48c48f84a014ad9499218735cd3 Mon Sep 17 00:00:00 2001
From: sen <sen@qq.com>
Date: 星期二, 16 十二月 2025 18:49:35 +0800
Subject: [PATCH] 钥匙柜修改
---
tms/src/main/java/com/ruoyi/tms/mapper/TmsQuoteItemMapper.java | 8 ++++++++
1 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/tms/src/main/java/com/ruoyi/tms/mapper/TmsQuoteItemMapper.java b/tms/src/main/java/com/ruoyi/tms/mapper/TmsQuoteItemMapper.java
index c0fb2f7..8da693b 100644
--- a/tms/src/main/java/com/ruoyi/tms/mapper/TmsQuoteItemMapper.java
+++ b/tms/src/main/java/com/ruoyi/tms/mapper/TmsQuoteItemMapper.java
@@ -3,6 +3,8 @@
import java.util.List;
import com.ruoyi.tms.domain.TmsQuoteItem;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
/**
@@ -37,6 +39,12 @@
*/
public List<TmsQuoteItem> selectTmsQuoteItemList(TmsQuoteItem tmsQuoteItem);
+ @Select("select DISTINCT tqi.* from tms_quote_item tqi " +
+ "JOIN tms_quote_plan tqp on tqi.quote_plan_id = tqp.id " +
+ "where tqi.free = #{free} and tqp.provider_id = #{providerId} and tqp.provider_type = #{providerType} and plan_type = 1")
+ public TmsQuoteItem selectTmsQuoteItemByQuoteId(@Param("free") Integer free,@Param("providerType") Integer providerType,@Param("providerId") Integer providerId);
+
+
/**
* 鏂板鎶ヤ环椤圭洰
*
--
Gitblit v1.8.0