From 91c1c308abec43a67335cdebb574940ed41b09cf Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Wed, 05 Aug 2020 16:56:16 +0800 Subject: [PATCH] 修改预测参数,提交到数据库 --- src/main/java/com/moral/mapper/DeviceMapper.java | 41 +++++++++++++++++++++++++++++++++++------ 1 files changed, 35 insertions(+), 6 deletions(-) diff --git a/src/main/java/com/moral/mapper/DeviceMapper.java b/src/main/java/com/moral/mapper/DeviceMapper.java index b77c595..b2bd249 100644 --- a/src/main/java/com/moral/mapper/DeviceMapper.java +++ b/src/main/java/com/moral/mapper/DeviceMapper.java @@ -1,12 +1,13 @@ package com.moral.mapper; +import java.util.Date; import java.util.List; import java.util.Map; -import org.apache.ibatis.annotations.Param; - import com.moral.common.mapper.BaseMapper; import com.moral.entity.Device; + +import org.apache.ibatis.annotations.Param; import tk.mybatis.mapper.entity.Example; public interface DeviceMapper extends BaseMapper<Device>{ @@ -18,13 +19,41 @@ List<Map<String, Object>> getDeviceVersionIdByMonitorPoint(Integer monitorPointId); - List<Device> selectByOrgIdAndDevName(@Param("orgId")Integer orgId,@Param("devName")String devName); - List<Device> selectByOrgIdAndMpId(@Param("orgId")Integer orgId,@Param("mpId")Integer mpId); + List<Device> selectByOrgIdAndDevName(@Param("orgId")Integer orgId, @Param("orgIds")List<Integer> orgIds,@Param("devState") String state,@Param("name")String name); + + /** + * + * @param orgId + * @param mpId + * @return ��������������������� + */ + List<Device> selectByOrgIdAndMpId(@Param("orgId")Integer orgId,@Param("orgIds")List<Integer> orgIds,@Param("mpId")Integer mpId); List<Device> selectByMap(Map<String, Object> params); Device selectWithOrgIdsByMac(String mac); - List<Integer> getDeviceVersionIdByAreaCode(Map<String, Object> parameters); - Integer getDeviceCountByRegion(Map<String, Object> parameters); + List<Map> countByTimes(@Param("start")Date start,@Param("end")Date end,@Param("format")String format); + List<Device> getDevicesByProfession(Map<String, Object> parameters); + + List<Device> getDevicesByOrganizationId(Map<String, Object> parameters); + List<Map<String, Object>> getDevicesStateByRegion(Map<String, Object> parameters); + + List<Device> getDeviceList(Example example); + String getLimitDataByDevice(Map<String, Object> parameters); + + List<String> getMacsByOrganizationId(@Param("organizationIdList") List<Object> organizationIdList); + + List<Device> getDeviceById1(@Param("id") int id); + + //������������������ + List<Device> getDeviceById2(@Param("id") int id); + + List<Device> getDeviceById3(@Param("id") int id); + + List<Integer> getHasWindDirAndWindSpeedDeviceVersion(); + + List<Device> selectDevicesAll(Map<String, Object> params); + + List<Device> getDeviceListByMonitorPointIds(List<Integer> id); } \ No newline at end of file -- Gitblit v1.8.0