ps-inquiry/src/main/java/com/uas/ps/inquiry/dao/PurcInquiryItemDao.java

package com.uas.ps.inquiry.dao;

import com.uas.ps.inquiry.model.PurcInquiryItem;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import javax.transaction.Transactional;

/**
 * 公共询价明细的操作
 *
 * Created by hejq on 2018-01-14.
 */
@Repository
public interface PurcInquiryItemDao extends JpaSpecificationExecutor<PurcInquiryItem>, JpaRepository<PurcInquiryItem, Long> {

    /**
     * 通过关联主表id更新询价明细状态
     *
     * @param sourceId 主表id
     */
    @Transactional
    @Modifying(clearAutomatically = true)
    @Query("update PurcInquiryItem set overdue = 1 where inquiry.id = :sourceId")
    void updateStatus(@Param("sourceId") Long sourceId);

    /**
     * 通过id维护该询价明细客户报价数据
     *
     * @param sourceId
     * @param amount
     */
    @Transactional
    @Modifying
    @Query("update PurcInquiryItem set offerAmount = coalesce(offerAmount, 0) + :amount where id = :sourceId")
    void updateAmount(@Param("sourceId") Long sourceId, @Param("amount") Integer amount);
}