| | |
| | | package com.by4cloud.platformx.business.mapper; |
| | | |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.by4cloud.platformx.business.dto.AnalysisCommonDTO; |
| | | import com.by4cloud.platformx.business.dto.ContracQueryDTO; |
| | | import com.by4cloud.platformx.business.dto.ContractQueryDTO; |
| | | import com.by4cloud.platformx.business.dto.CreditSalesQueryDTO; |
| | | import com.by4cloud.platformx.business.entity.Contract; |
| | | import com.by4cloud.platformx.business.vo.*; |
| | | import com.by4cloud.platformx.common.core.util.R; |
| | | import com.by4cloud.platformx.common.data.datascope.DataScope; |
| | | 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 |
| | | */ |
| | | @Mapper |
| | | public interface ContractMapper extends PlatformxBaseMapper<Contract> { |
| | | Page<ContractCreditSalesPageVo> pageByCredit(Page page, @Param("queryDTO") CreditSalesQueryDTO queryDTO, DataScope comp_id); |
| | | |
| | | List<ContractAmountAnalysisVo> contractAmountAnalysis(@Param("queryDTO")AnalysisCommonDTO commonDTO,@Param("compIds")List<Long> compIds); |
| | | |
| | | List<ContractIncomeAnalysisVo> contractIncomeAnalysis(@Param("queryDTO")AnalysisCommonDTO commonDTO,@Param("compIds")List<Long> compIds); |
| | | |
| | | void setSession(); |
| | | |
| | | List<ContractIncomeAnalysisCompVo> contractIncomeAnalysisByComp(@Param("queryDTO")AnalysisCommonDTO commonDTO,@Param("compId") Long compId); |
| | | |
| | | List<ContractIncomeAnalysisAreaVo> contractAmountAnalysisByArea(@Param("queryDTO")AnalysisCommonDTO commonDTO |
| | | ,@Param("compIds")List<Long> compIds,@Param("smjCompId") Long smj, |
| | | @Param("sgbCompId")Long sgb, @Param("jxcCompId")Long jxc, |
| | | @Param("tfCompId") Long tfgs,@Param("ymjCompId") Long ymj); |
| | | |
| | | List<ContractIncomeAnalysisAreaVo> contractAmountAnalysisByIndustry(@Param("queryDTO")AnalysisCommonDTO commonDTO |
| | | ,@Param("compIds")List<Long> compIds,@Param("smjCompId") Long smj, |
| | | @Param("sgbCompId")Long sgb, @Param("jxcCompId")Long jxc, |
| | | @Param("tfCompId") Long tfgs,@Param("ymjCompId") Long ymj); |
| | | |
| | | List<ContractIncomeAnalysisAreaVo> contractAmountAnalysisByMarket(@Param("queryDTO")AnalysisCommonDTO commonDTO |
| | | ,@Param("compIds")List<Long> compIds,@Param("smjCompId") Long smj, |
| | | @Param("sgbCompId")Long sgb, @Param("jxcCompId")Long jxc, |
| | | @Param("tfCompId") Long tfgs,@Param("ymjCompId") Long ymj); |
| | | |
| | | List<ContractIncomeAnalysisAreaVo> contractAmountAnalysisBySpcBus(@Param("queryDTO")AnalysisCommonDTO commonDTO |
| | | ,@Param("compIds")List<Long> compIds,@Param("smjCompId") Long smj, |
| | | @Param("sgbCompId")Long sgb, @Param("jxcCompId")Long jxc, |
| | | @Param("tfCompId") Long tfgs,@Param("ymjCompId") Long ymj); |
| | | |
| | | |
| | | List<ContractIncomeAnalysisAreaVo> contractAmountAnalysisByExportBus(@Param("queryDTO")AnalysisCommonDTO commonDTO |
| | | ,@Param("compIds")List<Long> compIds,@Param("smjCompId") Long smj, |
| | | @Param("sgbCompId")Long sgb, @Param("jxcCompId")Long jxc, |
| | | @Param("tfCompId") Long tfgs,@Param("ymjCompId") Long ymj); |
| | | |
| | | List<ContractAmountAnalysisCompVo> contractAmountAnalysisByComp(@Param("queryDTO")AnalysisCommonDTO commonDTO,@Param("compId") Long compId); |
| | | |
| | | List<ContractIncomeAnalysisAreaVo> contractAmountAnalysisBySaleModel(@Param("queryDTO")AnalysisCommonDTO commonDTO |
| | | ,@Param("compIds")List<Long> compIds,@Param("smjCompId") Long smj, |
| | | @Param("sgbCompId")Long sgb, @Param("jxcCompId")Long jxc, |
| | | @Param("tfCompId") Long tfgs,@Param("ymjCompId") Long ymj); |
| | | |
| | | Page<ContractPageVo> pageScope(Page page,@Param("queryDTO") ContracQueryDTO queryDTO, DataScope comp_id); |
| | | |
| | | HomeZbjtVo homeZbjt(); |
| | | |
| | | 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(); |
| | | } |