package com.moral.monitor.dao;
import com.moral.monitor.entity.*;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.List;

/**
 * Created by a on 2017/4/7.
 */
@Repository
public interface TaskDao {
    //插入logger表
    public void insertTologger(String mac, String receiveMsg, String date);
    //插入history表
    public void insertTohistory(String mac, String sensor, String mac_key, String mac_value);
    //查找state表
    public List<State> selectFromstate(String mac, String mac_key);
    //删除stata表
    public void deleteFromstateBymacandmackey(String mac, String mac_key);
    //插入state表
    public void insertTostate(String mac, String sensor, String mac_key, String mac_value);
   //更新state表
    public void updatestate(String mac_value, String mac, String mac_key);
    //找到此设备的所有传感的报警信息
    public List<AlarmSensor> findAllsensorBymac(String mac,String ver);
    //根据此设备此传感器报警组找到用户
    public List<User> findAlluserBysensor(String alarm);
    //查找sensor表
    public List<Sensor> selectFromsensorByver(String ver);
    //查找equipment表
    public Equipment selectFromequipment(String mac);
    //插入alarmlog表
    public void insertToalarmlog(String mac, String sensor, double value, String alarm_desc, String equipmentAddress,int state,String name,String unit);
    //插入noticelog表
    public void insertTonoticelog(int userid, String username, String noticetype, String mac, String equipmentname, String alarm_content, String sensor,String address,int sensorlevle,String date);
    //更新equipmentstate表
    public void updateequipmentstate(int state, String mac);
    //查找alarmlog表
    public Alarmlog selectFromalarmlog(String mac);
    //查找state表
    public List<State> selectFromstateGroupbymac();
    //查找logger表
    public String selectFromloggerbymacandtime(String mac, String date);
    //查找noticelog表
    public Noticelog selectFromnoticelogBynameandsensor(String username, String sensor);
    //插入offlinelog
    public void insertToofflinelog(String name, String address, String repairman);
    //查找mac表
    public List<AlarmSensor> selectFrommacBymac(String mac);
    //查找alarmlog表
    public Alarmlog selectFromalarmlogBysensor(String mac,String sensor);
    //更新alarmlog表
    public void updatealarmlogstate(int id);
    //查找noticelog表
    public Noticelog selectnoticelogbystate();
    //查找user表
    public User selectuserbyuid(int uid);
    //更新noticelog表
    public void updatenoticelogstate(int id);


    /*Listener 中逻辑中用到的部分*/
    //按mac查找即时表
    public List<State> findstateBymac(String mac);

    //查找设备已绑定的传感器
    public List<Mac> findmacBymac(String mac);
    public List<Critical> findcritical();



}