| | |
| | | public Response getAllBattStateInSz2(Integer userId) { |
| | | Map<String,Object> map=new HashMap<>(); |
| | | Map<String,Integer> allTypemap=new HashMap<>(); |
| | | allTypemap.put("浮充",0); |
| | | allTypemap.put("充电",0); |
| | | allTypemap.put("放电",0); |
| | | allTypemap.put("均充",0); |
| | | allTypemap.put("内阻测试",0); |
| | | //setDefalut(map); |
| | | try { |
| | | //查询电池状态(去除未知) |
| | |
| | | select tb_batt_rtstate.*,StationName9 as stationName9 |
| | | from db_ram_db.tb_batt_rtstate,db_battinf.tb_battinf |
| | | where tb_batt_rtstate.batt_state!=0 |
| | | and tb_batt_rtstate.BattGroupId=db_battinf.tb_battinf.BattGroupId |
| | | and tb_batt_rtstate.BattGroupId |
| | | in (select distinct db_battinf.tb_battinf.battgroupid |
| | | from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf |