Revize 72a438f3

+ location persistence
+ last available collections
+ available collections code rework

website/src/OpenDataManager.php

@@ -3 +3 @@
 namespace App\OpenData;
 
 use MongoDB\Driver\Query;
-use MongoDB\Driver\Command;
 use MongoDB\Driver\Manager;
 
 class OpenDataManager implements IOpenDataManager {
@@ -54 +53 @@
     }
 
     public function isCollectionAvailable($name, $date) {
-        $command = new Command(['listCollections' => 1, 'filter' => ['name' => $name.$date]]);
-        $result = $this->manager->executeCommand('open-data-db', $command)->toArray();
+        $result = $this->manager->executeQuery('open-data-db.'.$name, new Query(['date' => $date], []));
 
-        return !empty($result);
+        return !empty($result->toArray());
     }
 
     public function getDatesWithAvailableCollection() {
-        $command = new Command(['listCollections' => 1]);
-        $result = $this->manager->executeCommand('open-data-db', $command)->toArray();
+        $available = $this->getAvailableCollections();
+        $result = [];
+
+        foreach ($available as $key => $value) {
+            $dates = $this->manager->executeQuery('open-data-db.'.$value['key-name'], new Query([], ['projection' => ['date' => true, '_id' => false]]));
+            $dates->setTypeMap(['root' => 'array']);
+            $result = array_merge($result, array_map(function ($item) {return $item['date']; }, $dates->toArray()));
+        }
+
+        return array_values(array_unique($result));
+    }
+
+    public function getLastAvailableCollections() {
+        $available = $this->getAvailableCollections();
+        $result = [];
+
+        foreach ($available as $key => $value) {
+            $date = $this->manager->executeQuery('open-data-db.'.$value['key-name'], new Query([], ['sort' => ['date' => -1], 'limit' => 1, 'projection' => ['date' => true, '_id' => false]]));
+            $date->setTypeMap(['root' => 'array']);
 
-        $dates = [];
-        foreach ($result as $value) {
-            if (preg_match('/\\d{4}-\\d{2}-\\d{2}/', $value->name)) {
-                array_push($dates, substr($value->name, -10));
+            $date_array = $date->toArray();
+            if (!empty($date_array)) {
+                $result[$value['key-name']] = $date_array[0]['date'];
             }
         }
 
-        return array_values(array_unique($dates));
+        return $result;
     }
 
     public function getMaxCollectionNumberAtDay($name, $date) {