游瑞烽 / average_speed · Files

package com.bsth.repository;

import com.bsth.entity.ScheduleRealInfo;
import org.springframework.data.jpa.repository.EntityGraph;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ScheduleRealInfoRepository extends PagingAndSortingRepository<ScheduleRealInfo, Long> {
	
	//按照时间段统计
//	@EntityGraph(value = "scheduleRealInfo_cTasks", type = EntityGraph.EntityGraphType.FETCH)
	@Query("select DISTINCT s from ScheduleRealInfo s where s.scheduleDateStr=?1 order by s.xlBm, s.lpName, s.fcno")
	List<ScheduleRealInfo> scheduleByDateAndLineTj(String scheduleDateStr);
	
}