package com.boying.dao;
|
|
import com.boying.common.BaseDao;
|
import com.boying.entity.TicketBlack;
|
import org.springframework.data.jpa.repository.Query;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.Date;
|
import java.util.List;
|
|
@Repository("ticketBlackDao")
|
public interface TicketBlackDao extends BaseDao<TicketBlack, Long>{
|
|
@Query(nativeQuery = true,value = "update TicketBlack set blackType=1 where createTime<:dateLessMonth and status=0")
|
void updateType(Date dateLessMonth);
|
|
@Query(value = "select count(id) from TicketBlack where blackType=1")
|
long count1();
|
|
@Query(value = "select count(id) from TicketBlack where blackType=1 and createTime>:startTime and createTime<:endTime")
|
long count2(Date startTime,Date endTime);
|
|
@Query(value = "from TicketBlack where createTime<:dateLessMonth and status=0 and blackType=0")
|
List<TicketBlack> findAll1(Date dateLessMonth);
|
}
|
