| | |
| | | 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; |
| | | |
| | | |
| | | /** |
| | |
| | | */ |
| | | 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); |
| | | |
| | | |
| | | /** |
| | | * 新增报价项目 |
| | | * |