update

whycrzg

2021-01-29 b421fde8f3499b638c117cc2cb9a49f260fb3481

 src/main/java/com/fgkj/mapper/impl/Batt_devalarm_dataMapper.java

@@ -36,7 +36,19 @@
    public List serchTopAlmInDev();
   
    //项目下方的滚动，查询最新设备告警
    public List serchTopDevTen(Object obj);
   @Select("select distinct db_alarm.tb_devalarm_data.dev_id,db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.stationid,db_battinf.tb_battinf.fbsdevicename,dev_ip,alm_type,alm_start_time " +
         "  from db_alarm.tb_devalarm_data,db_battinf.tb_battinf" +
         "  where alm_cleared_type=0 " +
         "  and db_alarm.tb_devalarm_data.dev_id=db_battinf.tb_battinf.fbsdeviceid " +
         "  and  db_alarm.tb_devalarm_data.dev_id  in (select distinct db_battinf.tb_battinf.FbsDeviceId " +
         " from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf   " +
         " where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId   " +
         " and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id  " +
         " and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid  " +
         " and db_user.tb_user_inf.uid=#{uId})" +
         " order by alm_start_time desc " +
         "  limit 0,5")
    public List<Batt_devalarm_data> serchTopDevTen(User_inf obj);

    //项目下方的滚动，查询该设备告警的实时信息
    public List serchDev_alarm(Batt_devalarm_data ddata);