package com.northglass.repository;
|
|
import java.util.Date;
|
import java.util.List;
|
|
import org.springframework.data.jpa.repository.JpaRepository;
|
import org.springframework.data.jpa.repository.Query;
|
|
import com.northglass.entity.EdgPerimeter;
|
|
;
|
|
public interface EdgPerimeterDao extends JpaRepository<EdgPerimeter, Long>{
|
|
@Query("select sum(width+height) from EdgPerimeter t where t.groups=?1 and date_format(t.startTime,'%Y-%m-%d')=?2")
|
public String findbygroupdate(Long groups,String date1);
|
|
@Query("select sum(width+height) from EdgPerimeter t where t.groups=?1")
|
public String findbysumgroupdate(Long groups);
|
|
@Query("select sum(width+height) from EdgPerimeter t where t.groups=?1 and t.startTime>=?2 and t.startTime<=?3")
|
public String findbydatetime(Long groups,Date date1,Date date2);
|
|
}
|
