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
|
<?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/gts?allowMultiQueries=true</entry>
<entry key="database.user">user</entry>
<entry key="database.password">password</entry>
<!-->
id - Integer
imei - String
<-->
<entry key="database.selectDevice">
SELECT imeiNumber AS id, imeiNumber AS imei FROM Device WHERE imeiNumber <> '';
</entry>
<!-->
device_id - Integer
time - Date
valid - Boolean
latitude - Double
longitude - Double
speed - Double
course - Double
power - Double (NULL for some protocols)
extended_info - String (XML)
<-->
<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 VALUES (@accountID, @deviceID, UNIX_TIMESTAMP(:time), 0, :latitude, :longitude, 0, :speed, :course, 0, '', 0, '', '', '', 0, 0, 0, '0000000001', UNIX_TIMESTAMP(NOW()));
COMMIT;
</entry>
<!-- Xexun server configuration -->
<entry key="xexun.enable">true</entry>
<entry key="xexun.port">5000</entry>
<entry key="xexun.resetDelay">0</entry>
<!-- Gps103 server configuration -->
<entry key="gps103.enable">true</entry>
<entry key="gps103.port">5001</entry>
<entry key="gps103.resetDelay">0</entry>
<!-- Tk103 server configuration -->
<entry key="tk103.enable">true</entry>
<entry key="tk103.port">5002</entry>
<entry key="tk103.resetDelay">0</entry>
<!-- Gl100 server configuration -->
<entry key="gl100.enable">true</entry>
<entry key="gl100.port">5003</entry>
<entry key="gl100.resetDelay">0</entry>
<!-- Gl200 server configuration -->
<entry key="gl200.enable">true</entry>
<entry key="gl200.port">5004</entry>
<entry key="gl200.resetDelay">0</entry>
<!-- T55 server configuration -->
<entry key="t55.enable">true</entry>
<entry key="t55.port">5005</entry>
<entry key="t55.resetDelay">0</entry>
<!-- Xexun 2 server configuration -->
<entry key="xexun2.enable">true</entry>
<entry key="xexun2.port">5006</entry>
<entry key="xexun2.resetDelay">0</entry>
<!-- AVL-08 server configuration -->
<entry key="xexun2.enable">true</entry>
<entry key="xexun2.port">5007</entry>
<entry key="xexun2.resetDelay">0</entry>
</properties>
|
