platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/mapper/ContractMapper.java
@@ -3,13 +3,16 @@
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;
@@ -66,4 +69,18 @@
    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);
}