wlyy2.0/svr/svr-wlyy-health-bank/src/main/java/com/yihu/jw/dao/TaskDao.java

package com.yihu.jw.dao;/**
 * Created by nature of king on 2018/5/10.
 */

import com.yihu.jw.entity.health.bank.TaskDO;
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.PagingAndSortingRepository;

import javax.print.DocFlavor;
import java.util.List;

/**
 * @author wangzhinan
 * @create 2018-05-10 11:17
 * @desc health bank task dict
 **/
public interface TaskDao extends PagingAndSortingRepository<TaskDO,String>,JpaSpecificationExecutor<TaskDO> {
    @Query("select t from TaskDO t where t.transactionId = ?1 and t.type='ACTIVITY_TASK'")
    List<TaskDO> selectByActivityId(String transactionId);

    @Query("select t from TaskDO t where t.transactionId = ?1 and t.type='RULE_TASK'")
    TaskDO selectByTaskRuleId(String transactionId);


    @Query("select t from TaskDO t where t.id = ?1 ")
    TaskDO selectById(String id);

    @Modifying
    @Query("delete from TaskDO t where t.transactionId=?1")
    void deleteByTransactionId(String transactionId);

}