package com.fengdu.gas.repository.mapper;
|
|
import com.fengdu.gas.repository.BasicMapper;import com.fengdu.gas.repository.po.FacilityRunTimePO;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* 设备运行时长 mapper
|
* @author zr
|
*/
|
public interface FacilityRunTimeMapper extends BasicMapper<FacilityRunTimePO> {
|
@Select("SELECT r.*\n" +
|
" FROM facility_run_time r\n" +
|
" INNER JOIN (\n" +
|
" SELECT facility_id, MAX(create_time) AS max_timestamp\n" +
|
" FROM facility_run_time WHERE open_time IS NOT NULL AND open_time<>'' AND close_time IS NOT NULL AND close_time <>''\n" +
|
" GROUP BY facility_id\n" +
|
" ) AS latest ON r.facility_id = latest.facility_id AND r.create_time = latest.max_timestamp;")
|
List<FacilityRunTimePO> getDataTime();
|
|
@Select("select * from facility_run_time where is_delete=0 and open_time IS NOT NULL AND open_time<>'' AND close_time IS NOT NULL AND close_time <>'' ")
|
List<FacilityRunTimePO>selectByDataTime();
|
}
|
