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 imei=#{imei} ")
    Integer deleteDeviceByImei(@Param("imei") String imei);

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

     @Update("update  nb_device   " +
             "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);


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

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