com.gamewin.weixin.repository.ManageQRcodeDao.java Source code

Introduction

Here is the source code for com.gamewin.weixin.repository.ManageQRcodeDao.java

Source

/*******************************************************************************
 * Copyright (c) 2005, 2014 springside.github.io
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 *******************************************************************************/
package com.gamewin.weixin.repository;

import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
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 com.gamewin.weixin.entity.ManageQRcode;

public interface ManageQRcodeDao
        extends PagingAndSortingRepository<ManageQRcode, Long>, JpaSpecificationExecutor<ManageQRcode> {

    Page<ManageQRcode> findByUserId(Long id, Pageable pageRequest);

    Page<ManageQRcode> findByTaskId(Long id, Pageable pageRequest);

    @Modifying
    @Query("update from ManageQRcode qr set qr.qrState='N' where qr.task.id=?1")
    void invalidAllQRCode(Long taskId);
}