ContractRelationRepository.java

package common.repository;

import common.model.ContractRelation;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.math.BigInteger;
import java.util.List;


/**
 * 合同 关联信息
 */
public interface ContractRelationRepository extends JpaRepository<ContractRelation, Long> {

    @Query(value = "select  relation_id id from contract_relation where main_contract  in ?1 union all select  main_contract id from contract_relation where  relation_id  in ?1",nativeQuery = true)
    List<BigInteger> findRelationIds(List contractId);

    @Query(value = "select * from contract_relation where main_contract = ?1 and relation_id = ?2 and platform = ?3",nativeQuery = true)
    ContractRelation findByRelationData(Long mainContract, Long relationId, String platform);

    @Query(value = "select  a.* from contract_relation a  left join contract b on a.relation_id = b.id  where main_contract  = ?1 and b.status <>'del'  ",nativeQuery = true)
    List<ContractRelation> findRelationIdsMain(String contractId);
}