From e28ae518fddc930dcb26d70a4456ee1b28fb0ecc Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton.tananaev@gmail.com>
Date: Sun, 7 Mar 2021 22:42:47 -0800
Subject: Rename event time field

---
 schema/changelog-4.13.xml                            |  15 +++++++++++++++
 schema/changelog-master.xml                          |   1 +
 setup/default.xml                                    |   2 +-
 .../org/traccar/database/NotificationManager.java    |   2 +-
 src/main/java/org/traccar/model/Event.java           |  12 ++++++------
 templates/export/events.xlsx                         | Bin 12607 -> 8763 bytes
 6 files changed, 24 insertions(+), 8 deletions(-)
 create mode 100644 schema/changelog-4.13.xml

diff --git a/schema/changelog-4.13.xml b/schema/changelog-4.13.xml
new file mode 100644
index 000000000..ead5c6c28
--- /dev/null
+++ b/schema/changelog-4.13.xml
@@ -0,0 +1,15 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<databaseChangeLog
+  xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
+  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+  xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
+                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.4.xsd"
+  logicalFilePath="changelog-4.13">
+
+  <changeSet author="author" id="changelog-4.13">
+
+    <renameColumn tableName="tc_events" columnDataType="TIMESTAMP" oldColumnName="servertime" newColumnName="eventtime" />
+
+  </changeSet>
+
+</databaseChangeLog>
diff --git a/schema/changelog-master.xml b/schema/changelog-master.xml
index 7d4475df7..df54737a2 100644
--- a/schema/changelog-master.xml
+++ b/schema/changelog-master.xml
@@ -27,5 +27,6 @@
   <include file="changelog-4.9.xml" relativeToChangelogFile="true" />
   <include file="changelog-4.10.xml" relativeToChangelogFile="true" />
   <include file="changelog-4.11.xml" relativeToChangelogFile="true" />
+  <include file="changelog-4.13.xml" relativeToChangelogFile="true" />
 
 </databaseChangeLog>
diff --git a/setup/default.xml b/setup/default.xml
index eca6e56ff..b4e8d95e1 100644
--- a/setup/default.xml
+++ b/setup/default.xml
@@ -57,7 +57,7 @@
     </entry>
 
     <entry key='database.selectEvents'>
-        SELECT * FROM tc_events WHERE deviceId = :deviceId AND serverTime BETWEEN :from AND :to ORDER BY serverTime
+        SELECT * FROM tc_events WHERE deviceId = :deviceId AND eventTime BETWEEN :from AND :to ORDER BY eventTime
     </entry>
 
     <entry key='database.selectStatistics'>
diff --git a/src/main/java/org/traccar/database/NotificationManager.java b/src/main/java/org/traccar/database/NotificationManager.java
index ccad192f6..c4fc48ebf 100644
--- a/src/main/java/org/traccar/database/NotificationManager.java
+++ b/src/main/java/org/traccar/database/NotificationManager.java
@@ -90,7 +90,7 @@ public class NotificationManager extends ExtendedObjectManager<Notification> {
                     usersToForward.add(userId);
                 }
                 final Set<String> notificators = new HashSet<>();
-                for (long notificationId : getEffectiveNotifications(userId, deviceId, event.getServerTime())) {
+                for (long notificationId : getEffectiveNotifications(userId, deviceId, event.getEventTime())) {
                     Notification notification = getById(notificationId);
                     if (getById(notificationId).getType().equals(event.getType())) {
                         boolean filter = false;
diff --git a/src/main/java/org/traccar/model/Event.java b/src/main/java/org/traccar/model/Event.java
index 5eee2a0a0..47b74811a 100644
--- a/src/main/java/org/traccar/model/Event.java
+++ b/src/main/java/org/traccar/model/Event.java
@@ -27,7 +27,7 @@ public class Event extends Message {
     public Event(String type, long deviceId) {
         setType(type);
         setDeviceId(deviceId);
-        this.serverTime = new Date();
+        this.eventTime = new Date();
     }
 
     public Event() {
@@ -62,14 +62,14 @@ public class Event extends Message {
 
     public static final String TYPE_DRIVER_CHANGED = "driverChanged";
 
-    private Date serverTime;
+    private Date eventTime;
 
-    public Date getServerTime() {
-        return serverTime;
+    public Date getEventTime() {
+        return eventTime;
     }
 
-    public void setServerTime(Date serverTime) {
-        this.serverTime = serverTime;
+    public void setEventTime(Date eventTime) {
+        this.eventTime = eventTime;
     }
 
     private long positionId;
diff --git a/templates/export/events.xlsx b/templates/export/events.xlsx
index c658414b4..a6366750c 100644
Binary files a/templates/export/events.xlsx and b/templates/export/events.xlsx differ
-- 
cgit v1.2.3