package com.sandu.ximon.dao.mapper;
|
|
import cn.hutool.core.date.DateTime;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.sandu.ximon.dao.bo.LightReportDataBo;
|
import com.sandu.ximon.dao.domain.LightReportData;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.springframework.transaction.annotation.Propagation;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import java.util.List;
|
|
/**
|
* @Entity com.sandu.ximon.dao.domain.LightReportData
|
*/
|
@Mapper
|
public interface LightReportDataMapper extends BaseMapper<LightReportData> {
|
|
/**
|
* 获取指定设备吗最新上报的一条数据
|
*
|
* @param deviceCodeList 指定设备码
|
* @return 上报数据
|
*/
|
List<LightReportData> getNewestReportByDeviceCode(List<String> deviceCodeList);
|
|
|
/**
|
* 获取上报数据列表
|
*
|
* @param keyword 关键词
|
* @param deviceCode 设备码
|
* @return 上报数据
|
*/
|
@Transactional(propagation = Propagation.REQUIRES_NEW)
|
List<LightReportDataBo> listReportData(String keyword, String deviceCode);
|
|
/**
|
* 带用户ID查询
|
*
|
* @param keyword
|
* @param deviceCode
|
* @param userid
|
* @return
|
*/
|
List<LightReportDataBo> listReportDataByUserid(String keyword, String deviceCode, Long userid);
|
|
List<LightReportDataBo> reportDataList(List<String> deviceCodeList, DateTime startDate, DateTime endDate);
|
}
|