src/main/java/com/yuanlrc/base/dao/home/ReceiveOrderDao.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.yuanlrc.base.dao.home;

import com.yuanlrc.base.entity.home.ReceiveOrder;
import com.yuanlrc.base.entity.home.ReceiveOrder;
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;
import java.util.Date;
import java.util.List;

/**
 * 接单记录处理层
 */
@Repository
public interface ReceiveOrderDao extends JpaRepository<ReceiveOrder,Long>, JpaSpecificationExecutor<ReceiveOrder> {

    /**
     * 通过id查找
     */
    @Query("select r from ReceiveOrder r where id = :id")
    public ReceiveOrder find(@Param("id") Long id);

    /**
     * 根据当前用户查询接单记录
     * @param mid
     * @return
     */
    public List<ReceiveOrder>findByMemberId(@Param("id")Long mid);

    /**
     * 根据订单id查找接单记录
     * @param id
     * @return
     */
    public ReceiveOrder findByRunOrderId(@Param("id")Long id);


    /**
     * 根据当前用户查询接单流程记录
     * @param id
     * @return
     */
    public List<ReceiveOrder> findByRunOrderReleaseMemberId(@Param("id")Long id);


    /**
     * 完成配送更新订单
     * @param receiveOrder
     * @return
     */
    @Transactional
    @Modifying
    @Query(value = "update db_receive_order set status=:#{#receiveOrder.status},end_time=:#{#receiveOrder.endTime},use_time=:#{#receiveOrder.useTime} where id=:#{#receiveOrder.id}",nativeQuery = true)
    int updateReceiveOrder(@Param("receiveOrder") ReceiveOrder receiveOrder);