package com.northglass.repository;
|
|
import java.io.Serializable;
|
import java.util.Date;
|
import java.util.List;
|
|
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 com.northglass.constants.StateConstants.TaskState;
|
import com.northglass.entity.ReportTask;
|
|
|
public interface ReportTaskDao extends JpaSpecificationExecutor<ReportTask> , JpaRepository<ReportTask, Serializable>{
|
//根据产线查找所有的统计任务
|
@Query("select t from ReportTask t where t.loadMachine.id=?1")
|
public List<ReportTask> findByLoadMachineId(long loadMachineId);
|
|
//根据产线查找所有的统计任务
|
@Query("select t from ReportTask t ")
|
public List<ReportTask> findByLoadMachine();
|
|
//根据opt任务查找所有的统计任务
|
@Query("select t from ReportTask t where t.optPattern.id=?1")
|
public List<ReportTask> findByoptPatternId(long optPatternId);
|
|
//根据optname查找所有的统计任务
|
@Query("select t from ReportTask t where t.opt_name=?1")
|
public List<ReportTask> findByOptName(String optName);
|
|
//根据optname查找是否存在
|
@Query("select t from ReportTask t where t.opt_name like ?1%")
|
public List<ReportTask> findByOptNameLike(String optName);
|
|
//根据optname查找所有未完成状态的的任务
|
@Query("select t from ReportTask t where t.opt_name=?1 and t.state = '"+TaskState.NOT_COMPLETE+"'")
|
public List<ReportTask> findNotCompleteByOptName(String optName);
|
|
//根据optname清空任务记录
|
@Modifying
|
@Query("delete from ReportTask t where t.opt_name = ?1")
|
public void deleteByOptName(String optName);
|
|
//根据产线拿到optname
|
@Query("select t.opt_name from ReportTask t where t.opt_name like %?1%")
|
public List<String> findOptName(String name);
|
|
|
|
|
//---------------------------从此开始多条件查询语句------------------------------------------
|
//没有选中任何条件（查询当前产线下的所有任务）
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1")
|
public List<ReportTask> findReportTasks(long loadmachineId);
|
|
//有一个条件时（当前产线）
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2%")
|
public List<ReportTask> findReportTasksByOptName(long loadmachineId,String opt_name);
|
|
|
//有一个条件时（当前产线）
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.state = ?2")
|
public List<ReportTask> findReportTasksByState(long loadmachineId,String state);
|
|
|
//有一个条件时（当前产线）
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.reson = ?2")
|
public List<ReportTask> findReportTasksByReson(long loadmachineId,String reson);
|
|
//有一个条件时（当前产线）
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.start_time >= ?2")
|
public List<ReportTask> findReportTasksBystartTime(long loadmachineId,Date start_time);
|
|
//有一个条件时（当前产线）
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.complete_time >= ?2")
|
public List<ReportTask> findReportTasksByCompleteTime(long loadmachineId,Date complete_time);
|
|
//有两个条件时
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.state = ?3")
|
public List<ReportTask> findReportTasksByOptNameAndState(long loadmachineId,String opt_name,String state);
|
|
//有两个条件时
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.reson = ?3")
|
public List<ReportTask> findReportTasksByOptNameAndReson(long loadmachineId,String opt_name,String reson);
|
|
//有两个条件时
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.start_time >= ?3")
|
public List<ReportTask> findReportTasksByOptNameAndStartTime(long loadmachineId,String opt_name,Date start_time);
|
|
//有两个条件时
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.complete_time >= ?3")
|
public List<ReportTask> findReportTasksByOptNameAndCompleteTime(long loadmachineId,String opt_name,Date complete_time);
|
|
//有两个条件时
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.state = ?2 and t.reson = ?3")
|
public List<ReportTask> findReportTasksByStateAndReason(long loadmachineId,String state,String reson);
|
|
//有两个条件时
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.state = ?2 and t.start_time >= ?3")
|
public List<ReportTask> findReportTasksByStateAndStartTime(long loadmachineId,String state,Date start_time);
|
|
//有两个条件时
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.state = ?2 and t.complete_time >= ?3")
|
public List<ReportTask> findReportTasksByStateAndCompleteTime(long loadmachineId,String state,Date complete_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.reson = ?2 and t.start_time >= ?3")
|
public List<ReportTask> findReportTasksByResonAndStartTime(long loadmachineId,String reson,Date start_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.reson = ?2 and t.complete_time >= ?3")
|
public List<ReportTask> findReportTasksByResonAndCompleteTime(long loadmachineId,String reson,Date complete_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.start_time >= ?2 and t.complete_time >= ?3")
|
public List<ReportTask> findReportTasksByStartTimeAndCompleteTime(long loadmachineId,Date start_time,Date complete_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.state = ?3 and t.reson = ?4")
|
public List<ReportTask> findReportTasksByOptNameAndStateAndReason(long loadmachineId,String opt_name,String state,String reson);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.state = ?3 and t.start_time >= ?4")
|
public List<ReportTask> findReportTasksByOptNameAndStateAndStartTime(long loadmachineId,String opt_name,String state,Date start_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.state = ?3 and t.complete_time >= ?4")
|
public List<ReportTask> findReportTasksByOptNameAndStateAndCompleteTime(long loadmachineId,String opt_name,String state,Date complete_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.reson = ?3 and t.start_time >= ?4")
|
public List<ReportTask> findReportTasksByOptNameAndReasonAndStartTime(long loadmachineId,String opt_name,String reson,Date start_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.reson = ?3 and t.complete_time >= ?4")
|
public List<ReportTask> findReportTasksByOptNameAndReasonAndCompleteTime(long loadmachineId,String opt_name,String reson,Date complete_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.start_time >= ?3 and t.complete_time >= ?4")
|
public List<ReportTask> findReportTasksByOptNameAndStartTimeAndCompleteTime(long loadmachineId,String opt_name,Date start_time,Date complete_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.state = ?2 and t.reson = ?3 and t.start_time >= ?4")
|
public List<ReportTask> findReportTasksByStateAndReasonAndStartTime(long loadmachineId,String state,String reson,Date start_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.state = ?2 and t.reson = ?3 and t.complete_time >= ?4")
|
public List<ReportTask> findReportTasksByStateAndReasonAndCompleteTime(long loadmachineId,String state,String reson,Date complete_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.state = ?2 and t.start_time >= ?3 and t.complete_time >= ?4")
|
public List<ReportTask> findReportTasksByStateAndStartTimeAndCompleteTime(long loadmachineId,String state,Date start_time,Date complete_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.reson = ?2 and t.start_time >= ?3 and t.complete_time >= ?4")
|
public List<ReportTask> findReportTasksByResonAndStartTimeAndCompleteTime(long loadmachineId,String reson,Date start_time,Date complete_time);
|
|
//四个值
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.state = ?3 and t.reson = ?4 and t.start_time >= ?5")
|
public List<ReportTask> findReportTasksByOptNameAndStateAndResonAndStartTime(long loadmachineId,String opt_name,String state,String reson,Date start_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.state = ?3 and t.reson = ?4 and t.complete_time >= ?5")
|
public List<ReportTask> findReportTasksByOptNameAndStateAndResonAndCompleteTime(long loadmachineId,String opt_name,String state,String reson,Date complete_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.state = ?3 and t.start_time >= ?4 and t.complete_time >= ?5")
|
public List<ReportTask> findReportTasksByOptNameAndStateAndStartTimeAndCompleteTime(long loadmachineId,String opt_name,String state,Date start_time,Date complete_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.reson = ?3 and t.start_time >= ?4 and t.complete_time >= ?5")
|
public List<ReportTask> findReportTasksByOptNameAndReasonAndStartTimeAndCompleteTime(long loadmachineId,String opt_name,String reson,Date start_time,Date complete_time);
|
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.state = ?2 and t.reson = ?3 and t.start_time >= ?4 and t.complete_time >= ?5")
|
public List<ReportTask> findReportTasksByStateAndReasonAndStartTimeAndCompleteTime(long loadmachineId,String state,String reson,Date start_time,Date complete_time);
|
|
//五个值
|
@Query("select t from ReportTask t where t.loadMachine.id = ?1 and t.opt_name like ?2% and t.state = ?3 and t.reson = ?4 and t.start_time >= ?5 and t.complete_time >= ?6")
|
public List<ReportTask> findReportTasksByOptNameAndStateAndReasonAndStartTimeAndCompleteTime(long loadmachineId,String state,String reson,Date start_time,Date complete_time);
|
|
}
|
