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();
}