From 96118de3ac74f5468cf5d4ac73d6ea3bec1da010 Mon Sep 17 00:00:00 2001
From: shiyunteng <shiyunteng@example.com>
Date: 星期五, 20 十一月 2026 14:36:25 +0800
Subject: [PATCH] feat:新增销售指标 产品板块 重点工作 专项业务 产品收入和合同统计修改功能 feat:承兑新增承兑编号字段 feat:客商主数据更新名称 专项业务去年同月字段 机动车销售发票地址字段及判断 feat:银行流水更新客户id feat:机动车销售发票新增税务及代码字段 feat:流水更新按钮参数 feat:检索新增标的物运维按钮
---
platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/mapper/ContractMapper.java | 46 +++++++++++++++++++++++++++++++++++-----------
1 files changed, 35 insertions(+), 11 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 8950d86..9d97573 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
@@ -14,7 +14,10 @@
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
@@ -72,15 +75,36 @@
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);
+ List<String> homeZgsColum(@Param("compId") Long compId,@Param("compIds") List<Long> compIds);
+
+ ZbjtStatisticVo zbjtStatisticByContract(@Param("compId") Long compId,@Param("compIds") List<Long> compIds);
+
+ 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