From 145580fd820bb31334f2e71643413e846b7ce904 Mon Sep 17 00:00:00 2001
From: shiyunteng <shiyunteng@example.com>
Date: 星期五, 30 十月 2026 15:53:20 +0800
Subject: [PATCH] feat:统计内容1-8页

---
 platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/mapper/ContractMapper.java |   47 +++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 47 insertions(+), 0 deletions(-)

diff --git a/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/mapper/ContractMapper.java b/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/mapper/ContractMapper.java
index 933b6c2..f44f9a3 100644
--- a/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/mapper/ContractMapper.java
+++ b/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/mapper/ContractMapper.java
@@ -12,8 +12,12 @@
 import com.by4cloud.platformx.common.data.datascope.PlatformxBaseMapper;
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
 
+import java.math.BigDecimal;
+import java.util.Date;
 import java.util.List;
+import java.util.Map;
 
 /**
  * @author 28254
@@ -70,4 +74,47 @@
 	HomeZgsVo homeZgs(@Param("compId") Long compId);
 
 	Page<FourAssociationPageVo> fourAssociation(Page page,@Param("queryDTO") ContractQueryDTO queryDTO, DataScope comp_id);
+
+	@Select("SELECT\n" +
+			"\tbc.province \n" +
+			"FROM\n" +
+			"\tcontract c\n" +
+			"\tLEFT JOIN business_customer bc ON bc.id = c.party_a_id \n" +
+			"WHERE\n" +
+			"\tbc.province IS NOT NULL \n" +
+			"and c.party_b_id = #{compId}" +
+			"GROUP BY\n" +
+			"\tbc.province;")
+    List<String> homeZgsColum(@Param("compId") Long compId);
+
+    ZbjtStatisticVo zbjtStatisticByContract();
+
+	ZbjtStatisticByContractAmountVo zbjtStatisticByContractAmount();
+
+	ZbjtStatisticByContractAmountProVo zbjtStatisticByContractAmountPro();
+
+	ZbjtStatisticByContractAmountClassVo zbjtStatisticByContractAmountClass();
+
+	ZbjtStatisticByContractAmountSupplyVo zbjtStatisticByContractAmountSupply();
+
+	ZbjtStatisticByContractAmountClassVo zbjtStatisticByContractAmountYS();
+
+	List<ZbjtIndicatorTrendVo> zbjtIndicatorTrend(@Param("startMon") String startMon,@Param("endMon") String endMon);
+
+	List<ZbjtIndicatorTrendVo> zbjtPlanAchieced(@Param("compId")Long compId);
+
+	List<ZbjtIndicatorTrendVo> zbjtPlanAchiecedSmj();
+
+    List<ContractExportExceVO> export(@Param("queryDTO")ContracQueryDTO queryDTO, DataScope comp_id);
+
+    HomeZbjtVo homeZbjtYearAndMon(@Param("startMon") Date monstart,@Param("endMon") Date endMon,@Param("startYear") Date yearstart,@Param("endYear") Date yearend);
+
+	List<GcpbkwcqkItemVo> pjsxywwcqkHT(@Param("type") String type,@Param("monstart") Date monstart,@Param("monend")  Date monend);
+
+	List<GcpbkwcqkItemVo> cksxywwcqkHT(@Param("type") String type,@Param("monstart") Date monstart,@Param("monend")  Date monend);
+
+	List<GcpbkwcqkItemVo> dxsxywwcqkHT(@Param("type") String type,@Param("monstart") Date monstart,@Param("monend")  Date monend);
+
+	@Select(" select syr from a_smj_ht where id = 1")
+    String selectYZSH();
 }

--
Gitblit v1.9.1