GpsDataRecovery.java
4.71 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
package com.bsth.data.gpsdata.recovery;
import com.bsth.data.BasicData;
import com.bsth.data.gpsdata.GpsEntity;
import com.bsth.data.gpsdata.analyse.components.GpsArrival;
import com.bsth.util.db.DBUtils_MS;
import com.google.common.collect.ArrayListMultimap;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;
import java.util.concurrent.CountDownLatch;
import java.util.concurrent.ExecutorService;
import java.util.concurrent.Executors;
/**
* 数据恢复
* Created by panzhao on 2016/12/24.
*/
public class GpsDataRecovery {
static Logger logger = LoggerFactory.getLogger(GpsDataRecovery.class);
public static boolean run;
static ExecutorService threadPool = Executors.newFixedThreadPool(50);
private static CountDownLatch count;
public static void recovery() {
List<GpsEntity> list = loadData();
//按车辆分组数据
ArrayListMultimap<String, GpsEntity> listMap = ArrayListMultimap.create();
for (GpsEntity gps : list) {
if(gps.getNbbm() != null)
listMap.put(gps.getNbbm(), gps);
}
count = new CountDownLatch(listMap.keySet().size());
Set<String> keys = listMap.keySet();
for (String nbbm : keys) {
threadPool.execute(new RecoveryDataThread(listMap.get(nbbm), count));
/*if(nbbm.equals("W9A-250"))
new RecoveryDataThread(listMap.get(nbbm), count).run();*/
}
try {
//等待子线程结束
count.await();
logger.info("GPS 数据恢复完成....");
} catch (InterruptedException e) {
logger.error("", e);
}
}
/**
* 加载当天的gps数据
*
* @return
*/
public static List<GpsEntity> loadData() {
Calendar calendar = Calendar.getInstance();
int dayOfYear = calendar.get(Calendar.DAY_OF_YEAR);
String sql = "select DEVICE_ID,LAT,LON,TS,SPEED_GPS,LINE_ID,SERVICE_STATE from BSTH_C_GPS_INFO where days_year=" + dayOfYear;
JdbcTemplate jdbcTemplate = new JdbcTemplate(DBUtils_MS.getDataSource());
List<GpsEntity> list =
jdbcTemplate.query(sql, new RowMapper<GpsEntity>() {
@Override
public GpsEntity mapRow(ResultSet rs, int rowNum) throws SQLException {
GpsEntity gps = new GpsEntity();
gps.setDeviceId(rs.getString("DEVICE_ID"));
gps.setNbbm(BasicData.deviceId2NbbmMap.get(gps.getDeviceId()));
gps.setSpeed(rs.getFloat("SPEED_GPS"));
gps.setLat(rs.getFloat("LAT"));
gps.setLon(rs.getFloat("LON"));
gps.setLineId(rs.getString("LINE_ID"));
gps.setTimestamp(rs.getLong("TS"));
gps.setUpDown(getUpOrDown(rs.getLong("SERVICE_STATE")));
return gps;
}
});
return list;
}
/**
* 王通 2016/6/29 9:23:24 获取车辆线路上下行
*
* @return -1无效 0上行 1下行
*/
public static int getUpOrDown(long serviceState) {
if ((serviceState & 0x00020000) == 0x00020000 || (serviceState & 0x80000000) == 0x80000000
|| (serviceState & 0x01000000) == 0x01000000 || (serviceState & 0x08000000) == 0x08000000)
return -1;
return (((serviceState & 0x10000000) == 0x10000000) ? 1 : 0);
}
public static class RecoveryDataThread implements Runnable {
List<GpsEntity> list;
CountDownLatch count;
public RecoveryDataThread(List<GpsEntity> list, CountDownLatch count) {
this.list = list;
this.count = count;
}
@Override
public void run() {
try {
//排序
Collections.sort(list, new GpsComp());
//依次跑完gps
//int i = 0;
for(GpsEntity gps : list){
/* i++;
if(i == 383){
System.out.println("aaa");
}*/
GpsArrival.arrival(gps);
}
} catch (Exception e) {
logger.error("", e);
} finally {
count.countDown();
}
}
}
public static class GpsComp implements Comparator<GpsEntity>{
@Override
public int compare(GpsEntity g1, GpsEntity g2) {
return (int) (g1.getTimestamp() - g2.getTimestamp());
}
}
}