| | |
| | | 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.util.List; |
| | | |
| | |
| | | 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); |
| | | } |