package com.by4cloud.platformx.business.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.by4cloud.platformx.business.vo.CustBankVo;
import com.by4cloud.platformx.business.vo.CustInfoVo;
import com.by4cloud.platformx.business.vo.OrgInfoVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
@DS("druid_bip_view")
public interface BipViewMapper {

	@Select("select  certificate_id, cust_name,legal_person,registration_address,cust_code,country,custclass from mdm_send.mdm_cust_base_info_tra_send WHERE is_deleted = '0' and cust_name = #{companyName}")
	CustInfoVo selectBaseInfoByCustName(String companyName);

	@Select("SELECT mcbats.bank_account,mcbats.bank_name FROM mdm_send.mdm_cust_bank_account_tra_send AS mcbats  WHERE is_deleted = '0' and holder_name = #{companyName}")
	List<CustBankVo> selectBankByCustName(String companyName);

	@Select("select org_code,org_name,org_level from mdm_send.mdp_organize_tra_send WHERE is_deleted = '0' and org_name = #{companyName} ")
	List<OrgInfoVo> selectOrgByName(String partyA);
}