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
|
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<!-- Global confiduration -->
<entry key="database.driver">com.mysql.jdbc.Driver</entry>
<entry key="database.url">jdbc:mysql://localhost:3306/[DATABASE]?allowMultiQueries=true</entry>
<entry key="database.user">[USER]</entry>
<entry key="database.password">[PASSWORD]</entry>
<!-- Database refresh delay in seconds -->
<entry key="database.refreshDelay">300</entry>
<entry key="database.selectDevice">
SELECT imeiNumber AS id, imeiNumber AS imei FROM Device WHERE imeiNumber <> '';
</entry>
<entry key="database.insertPosition">
START TRANSACTION;
UPDATE Device SET lastValidLatitude = :latitude, lastValidLongitude = :longitude, lastGPSTimestamp = UNIX_TIMESTAMP(:time), lastUpdateTime = UNIX_TIMESTAMP(NOW()) WHERE imeiNumber = :device_id;
SELECT @accountID := accountID, @deviceID := deviceID FROM Device WHERE imeiNumber = :device_id;
INSERT INTO EventData (accountID, deviceID, timestamp, statusCode, latitude, longitude, speedKPH, heading, altitude, rawData, creationTime, address)
VALUES (@accountID, @deviceID, UNIX_TIMESTAMP(:time), 0, :latitude, :longitude, :speed, :course, :altitude, '', UNIX_TIMESTAMP(NOW()), :address);
COMMIT;
</entry>
<entry key="database.updateLatestPosition">
DO 0;
</entry>
<!-- Web interface port -->
<entry key="http.enable">false</entry>
<!-- Geocoder options -->
<entry key="geocoder.enable">true</entry>
<!-- Logging options -->
<entry key="logger.enable">true</entry>
<entry key="logger.file">[LOG]</entry>
<!-- Xexun server configuration -->
<entry key="xexun.enable">true</entry>
<entry key="xexun.port">5000</entry>
<!-- Gps103 server configuration -->
<entry key="gps103.enable">true</entry>
<entry key="gps103.port">5001</entry>
<!-- Tk103 server configuration -->
<entry key="tk103.enable">true</entry>
<entry key="tk103.port">5002</entry>
<!-- Gl100 server configuration -->
<entry key="gl100.enable">true</entry>
<entry key="gl100.port">5003</entry>
<!-- Gl200 server configuration -->
<entry key="gl200.enable">true</entry>
<entry key="gl200.port">5004</entry>
<!-- T55 server configuration -->
<entry key="t55.enable">true</entry>
<entry key="t55.port">5005</entry>
<!-- Xexun 2 server configuration -->
<entry key="xexun2.enable">true</entry>
<entry key="xexun2.port">5006</entry>
<!-- AVL-08 server configuration -->
<entry key="avl08.enable">true</entry>
<entry key="avl08.port">5007</entry>
<!-- Enfora server configuration -->
<entry key="enfora.enable">true</entry>
<entry key="enfora.port">5008</entry>
<!-- Meiligao server configuration -->
<entry key="meiligao.enable">true</entry>
<entry key="meiligao.port">5009</entry>
<!-- Maxon server configuration -->
<entry key="maxon.enable">true</entry>
<entry key="maxon.port">5010</entry>
<!-- ST-210 server configuration -->
<entry key="st210.enable">true</entry>
<entry key="st210.port">5011</entry>
<!-- Progress server configuration -->
<entry key="progress.enable">true</entry>
<entry key="progress.port">5012</entry>
<!-- H02 server configuration -->
<entry key="h02.enable">true</entry>
<entry key="h02.port">5013</entry>
<!-- JT600 server configuration -->
<entry key="jt600.enable">true</entry>
<entry key="jt600.port">5014</entry>
<!-- EV603 server configuration -->
<entry key="ev603.enable">true</entry>
<entry key="ev603.port">5015</entry>
<!-- V680 server configuration -->
<entry key="v680.enable">true</entry>
<entry key="v680.port">5016</entry>
<!-- PT502 server configuration -->
<entry key="pt502.enable">true</entry>
<entry key="pt502.port">5017</entry>
<!-- TR20 server configuration -->
<entry key="tr20.enable">true</entry>
<entry key="tr20.port">5018</entry>
<!-- Navis server configuration -->
<entry key="navis.enable">true</entry>
<entry key="navis.port">5019</entry>
<!-- Meitrack server configuration -->
<entry key="meitrack.enable">true</entry>
<entry key="meitrack.port">5020</entry>
<!-- Skypatrol server configuration -->
<entry key="skypatrol.enable">true</entry>
<entry key="skypatrol.port">5021</entry>
<!-- GT02 server configuration -->
<entry key="gt02.enable">true</entry>
<entry key="gt02.port">5022</entry>
<!-- GT06 server configuration -->
<entry key="gt06.enable">true</entry>
<entry key="gt06.port">5023</entry>
</properties>
|
