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

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

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

package com.yuanlrc.base.dao.home;

import com.yuanlrc.base.entity.home.RunOrder;
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.List;

/**
 * 跑腿订单处理层
 */
@Repository
public interface RunOrderDao extends JpaRepository<RunOrder,Long>, JpaSpecificationExecutor<RunOrder> {

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

    /**
     * 通过订单编号查找
     */
    @Query("select r from RunOrder r where runorder_num = :runOrderNum")
    public RunOrder findByNum(String runOrderNum);

    /**
     * 得到最大id
     */
    @Query("select max(id) from RunOrder ")
    public Integer findMaxId();

    /**
     * 通过订单状态得到订单
     */
    @Query("select r from RunOrder r where status = :status")
    public List<RunOrder> findByStatus(@Param("status")int status);


    /**
     * 通过发布者得到所有订单
     */
    @Query(value = "select * from db_run_order r where order_num like %?2% and release_id =?1",nativeQuery = true)
    public List<RunOrder> findByRelease(@Param("id")Long id,@Param("orderNum")String oderNum);


    /**
     * 更新订单浏览量
     * @param id
     * @return
     */
    @Transactional
    @Modifying
    @Query(value = "update db_run_order set views=views+1 where id=:id",nativeQuery = true)
    int updateViews(@Param("id")Long id);