From 8a5dbe0a1bd68c21d4c1e06a55e1190246774a1f Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton@traccar.org>
Date: Mon, 4 Jul 2022 14:30:11 -0700
Subject: Implement CSV export (fix #2961)

---
 .../org/traccar/reports/CsvExportProvider.java     | 76 ++++++++++++++++++++++
 .../org/traccar/reports/KmlExportProvider.java     |  2 +-
 2 files changed, 77 insertions(+), 1 deletion(-)
 create mode 100644 src/main/java/org/traccar/reports/CsvExportProvider.java

(limited to 'src/main/java/org/traccar/reports')

diff --git a/src/main/java/org/traccar/reports/CsvExportProvider.java b/src/main/java/org/traccar/reports/CsvExportProvider.java
new file mode 100644
index 000000000..df55c470e
--- /dev/null
+++ b/src/main/java/org/traccar/reports/CsvExportProvider.java
@@ -0,0 +1,76 @@
+/*
+ * Copyright 2022 Anton Tananaev (anton@traccar.org)
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package org.traccar.reports;
+
+import org.traccar.helper.DateUtil;
+import org.traccar.helper.model.PositionUtil;
+import org.traccar.model.Position;
+import org.traccar.storage.Storage;
+import org.traccar.storage.StorageException;
+
+import javax.inject.Inject;
+import java.io.OutputStream;
+import java.io.PrintWriter;
+import java.util.Date;
+import java.util.LinkedHashMap;
+import java.util.Objects;
+import java.util.function.Function;
+import java.util.stream.Collectors;
+
+public class CsvExportProvider {
+
+    private final Storage storage;
+
+    @Inject
+    public CsvExportProvider(Storage storage) {
+        this.storage = storage;
+    }
+
+    public void generate(
+            OutputStream outputStream, long deviceId, Date from, Date to) throws StorageException {
+
+        var positions = PositionUtil.getPositions(storage, deviceId, from, to);
+
+        var attributes = positions.stream()
+                .flatMap((position -> position.getAttributes().keySet().stream()))
+                .collect(Collectors.toUnmodifiableSet());
+
+        var properties = new LinkedHashMap<String, Function<Position, Object>>();
+        properties.put("id", Position::getId);
+        properties.put("deviceId", Position::getDeviceId);
+        properties.put("protocol", Position::getProtocol);
+        properties.put("serverTime", position -> DateUtil.formatDate(position.getServerTime()));
+        properties.put("deviceTime", position -> DateUtil.formatDate(position.getDeviceTime()));
+        properties.put("fixTime", position -> DateUtil.formatDate(position.getFixTime()));
+        properties.put("valid", Position::getValid);
+        properties.put("latitude", Position::getLatitude);
+        properties.put("longitude", Position::getLongitude);
+        properties.put("altitude", Position::getAltitude);
+        properties.put("speed", Position::getSpeed);
+        properties.put("course", Position::getCourse);
+        properties.put("address", Position::getAddress);
+        properties.put("accuracy", Position::getAccuracy);
+        attributes.forEach(key -> properties.put(key, position -> position.getAttributes().get(key)));
+
+        try (PrintWriter writer = new PrintWriter(outputStream)) {
+            writer.println(String.join(",", properties.keySet()));
+            positions.forEach(position -> writer.println(properties.values().stream()
+                    .map(f -> Objects.toString(f.apply(position), ""))
+                    .collect(Collectors.joining(","))));
+        }
+    }
+
+}
diff --git a/src/main/java/org/traccar/reports/KmlExportProvider.java b/src/main/java/org/traccar/reports/KmlExportProvider.java
index 977897833..e8b5c4278 100644
--- a/src/main/java/org/traccar/reports/KmlExportProvider.java
+++ b/src/main/java/org/traccar/reports/KmlExportProvider.java
@@ -39,7 +39,7 @@ public class KmlExportProvider {
         this.storage = storage;
     }
 
-    public void generateKml(
+    public void generate(
             OutputStream outputStream, long deviceId, Date from, Date to) throws StorageException {
 
         var device = storage.getObject(Device.class, new Request(
-- 
cgit v1.2.3