platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/mapper/ContractMapper.java
@@ -12,8 +12,11 @@
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.List;
import java.util.Map;
/**
 * @author 28254
@@ -70,4 +73,36 @@
   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);
}