platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/mapper/ContractMapper.java
@@ -12,6 +12,7 @@
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;
@@ -70,4 +71,16 @@
   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);
}