package com.casic.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.casic.entity.NbDevice;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.Map;

@Mapper
public interface NbDeviceMapper extends BaseMapper<NbDevice> {

    @Select("delete   " +
            "from  nb_device " +
            "where device_id=#{deviceId} ")
    Integer deleteDeviceByDeviceId(@Param("deviceId") String deviceId);

    @Select("select id,device_id " +
            "from  nb_device " +
            "where imei=#{imei} ")
    Map<String, String> getDeviceByImei(@Param("imei") String imei);

    @Update("update  nb_device   " +
            "set device_id = #{deviceId}  " +
            "where  imei =#{imei}   ")
    Integer setDeviceIdByImei(@Param("imei") String imei, @Param("deviceId") String deviceId);

    @Select("select devcode   " +
            "from  nb_device " +
            "where imei=#{imei} ")
    String getDevcodeByImei(@Param("imei") String imei);

    @Select("select devcode   " +
            "from   nb_device " +
            "where  device_id=#{deviceId} " +
            "  limit 1 ")
    String getDevcodeByDeviceId(@Param("deviceId") String deviceId);


    @Select("select id   " +
            "from   nb_device " +
            "where  device_id=#{deviceId}" +
            "  limit 1 ")
    String isDeviceId(@Param("deviceId") String deviceId);

    @Update("update nb_device   " +
            "set  recent_conf=#{recentConf} " +
            "where device_id=#{deviceId}  ")
    Integer updateRecentByDevciceId(@Param("deviceId") String deviceId, @Param("recentConf") String recentConf);

    @Select("SELECT cell " +
            " from lucency_gas_data "+
            " WHERE device_id = #{deviceId} "+
            " and cell is NOT NULL "+
            " ORDER BY uptime desc "+
            " LIMIT 1 ")
    String getLastCellByDeviceId(@Param("deviceId")String deviceId);


    @Select("select  recent_conf   " +
            "from  nb_device " +
            "where device_id=#{deviceId}  ")
    String getRecentByDevciceId(@Param("deviceId") String deviceId);
}