aboutsummaryrefslogtreecommitdiff
path: root/opengts.cfg
blob: ba9fb4da51bb205b41006210e62a9fad4d309b1e (plain)
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 &lt;&gt; '';
    </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>