From 72b971c98c46531064d74b68fc8fe8864ed0b544 Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Tue, 08 Nov 2022 09:04:56 +0800
Subject: [PATCH] 大屏溯源统计次数sql修改
---
src/main/java/org/springblade/modules/sale/mapper/SaleMapper.java | 18 +++++++++++++-----
1 files changed, 13 insertions(+), 5 deletions(-)
diff --git a/src/main/java/org/springblade/modules/sale/mapper/SaleMapper.java b/src/main/java/org/springblade/modules/sale/mapper/SaleMapper.java
index f4df1f4..962365d 100644
--- a/src/main/java/org/springblade/modules/sale/mapper/SaleMapper.java
+++ b/src/main/java/org/springblade/modules/sale/mapper/SaleMapper.java
@@ -16,6 +16,7 @@
*/
package org.springblade.modules.sale.mapper;
+import org.apache.ibatis.annotations.Param;
import org.springblade.modules.sale.entity.Sale;
import org.springblade.modules.sale.vo.SaleVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
@@ -38,9 +39,16 @@
* @param sale
* @return
*/
- List<SaleVO> selectSalePage(IPage page, SaleVO sale);
- Map<String, String> selctSaletCount();
- List<Map<Object,String>> selctSaletZ();
- List<Map<Object,String>> selectMarketCirculate();
- List<Map<Object,String>> selectMarketDistrict();
+ List<SaleVO> selectSalePage(IPage page, @Param("sale") SaleVO sale);
+ Map<String, String> selctSaletCount(String farmId);
+ List<Map<Object,String>> selctSaletZ(@Param("sale") SaleVO sale);
+
+ /**
+ * 统计市场流通/去年流通量/本月流通量
+ * @param sale
+ * @return
+ */
+ List<Map<Object,String>> selectMarketCirculate(@Param("sale") SaleVO sale);
+
+ List<Map<Object,String>> selectMarketDistrict(String farmId,String startTime,String endTime);
}
--
Gitblit v1.9.3