src/main/java/org/eclipse/openk/contactbasedata/repository/CommunicationRepository.java

/*
 *******************************************************************************
 * Copyright (c) 2019 Contributors to the Eclipse Foundation
 *
 * See the NOTICE file(s) distributed with this work for additional
 * information regarding copyright ownership.
 *
 * This program and the accompanying materials are made available under the
 * terms of the Eclipse Public License v. 2.0 which is available at
 * http://www.eclipse.org/legal/epl-2.0.
 *
 * SPDX-License-Identifier: EPL-2.0
 *******************************************************************************
 */
package org.eclipse.openk.contactbasedata.repository;

import org.eclipse.openk.contactbasedata.model.TblAddress;
import org.eclipse.openk.contactbasedata.model.TblCommunication;
import org.eclipse.openk.contactbasedata.model.TblContact;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;
import java.util.Optional;
import java.util.UUID;

public interface CommunicationRepository extends JpaRepository<TblCommunication, Long> {

    Optional<TblCommunication> findByUuid(UUID uuid);

    @Query("select a from TblCommunication a where a.tblContact.uuid = ?1")
    List< TblCommunication > findByTblContactUuid(final UUID contactUuid);

    Optional<TblCommunication> findByTblContactAndUuid(TblContact tblContact, UUID uuid);

    @Query("select count(*) from TblCommunication a where a.tblContact.id=:contactId and a.refCommunicationType.id=:communicationTypeId")
    Long countByContactIdAndCommunicationTypeId(@Param("contactId") Long contactId, @Param("communicationTypeId") Long communicationTypeId);

    @Query("select count(*) from TblCommunication a where a.tblContact.id=:contactId and a.refCommunicationType.id=:communicationTypeId and uuid <>:communicationUuid")
    Long countByContactIdAndCommunicationTypeIdAndIsNotSame(@Param("contactId") Long supplierId, @Param("communicationTypeId") Long communicationTypeId, @Param("communicationUuid") UUID communicationUuid);
}