loan-backend/src/main/java/com/loan/system/repository/ContractRepository.java

package com.loan.system.repository;

import com.loan.system.domain.entity.Contract;
import com.loan.system.domain.vo.ContractVO;
import io.swagger.models.Contact;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.transaction.annotation.Transactional;

import java.util.Collection;
import java.util.List;

/**
 * @author EdwinXu
 * @date 2020/9/2 - 15:35
 * @Description
 */
public interface ContractRepository extends JpaRepository<Contract,Long> {

    boolean existsByCaseIdAndBusinessAttrAndIsDelete(Long caseId, String businessAttr, boolean b);

    @Query("SELECT c FROM Contract c WHERE c.caseId = :caseId AND c.businessAttr = :businessAttr AND c.isDelete = :isDelete")
    Contract findByCaseIdAndBusinessAttrAndIsDelete(Long caseId, String businessAttr, boolean b);

    @Transactional
    @Modifying
    @Query("UPDATE Contract c SET " +
            "c.businessAttr = CASE WHEN :#{#contract.businessAttr} IS NOT NULL THEN :#{#contract.businessAttr} ELSE c.businessAttr END, " +
            "c.caseId = CASE WHEN :#{#contract.caseId} IS NOT NULL THEN :#{#contract.caseId} ELSE c.caseId END, " +
            "c.customerId = CASE WHEN :#{#contract.customerId} IS NOT NULL THEN :#{#contract.customerId} ELSE c.customerId END, " +
            "c.contractNo = CASE WHEN :#{#contract.contractNo} IS NOT NULL THEN :#{#contract.contractNo} ELSE c.contractNo END, " +
            "c.contractName = CASE WHEN :#{#contract.contractName} IS NOT NULL THEN :#{#contract.contractName} ELSE c.contractName END, " +
            "c.contractVersion = CASE WHEN :#{#contract.contractVersion} IS NOT NULL THEN :#{#contract.contractVersion} ELSE c.contractVersion END, " +
            "c.contractAmount = CASE WHEN :#{#contract.contractAmount} IS NOT NULL THEN :#{#contract.contractAmount} ELSE c.contractAmount END, " +
            "c.interestRate = CASE WHEN :#{#contract.interestRate} IS NOT NULL THEN :#{#contract.interestRate} ELSE c.interestRate END, " +
            "c.loanPeriod = CASE WHEN :#{#contract.loanPeriod} IS NOT NULL THEN :#{#contract.loanPeriod} ELSE c.loanPeriod END, " +
            "c.content = CASE WHEN :#{#contract.content} IS NOT NULL THEN :#{#contract.content} ELSE c.content END, " +
            "c.signedByCustomer = CASE WHEN :#{#contract.signedByCustomer} IS NOT NULL THEN :#{#contract.signedByCustomer} ELSE c.signedByCustomer END, " +
            "c.signedId = CASE WHEN :#{#contract.signedId} IS NOT NULL THEN :#{#contract.signedId} ELSE c.signedId END, " +
            "c.signedTime = CASE WHEN :#{#contract.signedTime} IS NOT NULL THEN :#{#contract.signedTime} ELSE c.signedTime END, " +
            "c.updateTime = CASE WHEN :#{#contract.updateTime} IS NOT NULL THEN :#{#contract.updateTime} ELSE c.updateTime END, " +
            "c.isDelete = :isDelete  " +
            "WHERE c.id = :id ")
    void updateContractById(Long id, Contract contract, boolean isDelete);

    List<Contract> findByCaseIdAndIsDelete(Long caseId, boolean isDelete);

    @Transactional
    @Modifying
    @Query("UPDATE Contract c SET c.isPush = true WHERE c.id = :contractId")
    void updateIsPushById(Long contractId);

    @Query("SELECT c FROM Contract c WHERE c.caseId = ?1 AND c.isPush = ?2 AND c.isDelete = ?3 ")
    List<Contract> findByCaseIdAndIsPush(Long caseId,Boolean isPush,boolean isDelete);

    @Transactional
    @Modifying
    @Query("update Contract c set c.isDelete= true WHERE c.caseId = ?1")
    void deleteAllByCaseId(Long caseID);

    @Transactional
    @Modifying
    @Query("UPDATE Contract c SET c.contractNo = ?2 WHERE c.id = ?1")
    void updateContractNoById(Long id, String contractNo);

    @Query("SELECT c FROM Contract c WHERE c.id = ?1")
    Contract findContractById(Long contractId);

    @Transactional
    @Modifying
    @Query("UPDATE Contract c SET c.signedByCustomer = false WHERE c.id = ?1")
    void updateSignedCustomerById(Long contractId);

    @Transactional
    @Modifying
    @Query("UPDATE Contract c set c.signedId = null  WHERE c.signedId = ?1")
    void deleteSigned(Long signedId);

    @Transactional
    @Modifying
    @Query("UPDATE Contract c SET " +
            "c.isCleared = CASE WHEN :isCleared IS NOT NULL THEN :isCleared ELSE c.isCleared END," +
            "c.interestAmount = CASE WHEN :interest IS NOT NULL THEN :interest ELSE c.interestAmount END," +
            "c.financeUserId = CASE WHEN :currentId IS NOT NULL THEN :currentId ELSE c.financeUserId END" +
            " where c.id= :contractId and c.isDelete =:isDelete")
    void updateRepayById(boolean isCleared,  Double interest, Long currentId, Long contractId, boolean isDelete);

    @Query("SELECT c.interestAmount FROM Contract c WHERE c.caseId = ?1 AND c.isDelete = ?2")
    List<Double> findIntersetByCaseIdAndIsDelete(Long caseId, boolean b);

    @Query("select c from Contract  c where c.caseId= ?1 and c.isDelete = ?2")
    List<Contract> findByCaseIdAndIsDelete2(Long caseId, boolean b);
}