Revize d8f6e6f2

Re #8094
+ method for retrieving all dates with at least one dataset

website/src/Controller/HeatmapController.php

@@ -54 +54 @@
     public function availableDatasets(IOpenDataManager $manager, $date = '01012020') {
         return $this->json($manager->getAvailableCollectionsByDay($date));
     }
+
+    /**
+     * @Route("heatmap/dates", name="dates")
+     */
+    public function datesWithAvailableDatasets(IOpenDataManager $manager) {
+        return $this->json($manager->getDatesWithAvailableCollection());
+    }
 }

website/src/IOpenDataManager.php

@@ -11 +11 @@
 
     public function isCollectionAvailable($name, $date);
 
+    public function getDatesWithAvailableCollection();
+
     public function getMaxCollectionNumberAtDay($name, $date);
 }

website/src/OpenDataManager.php

@@ -60 +60 @@
         return !empty($result);
     }
 
+    public function getDatesWithAvailableCollection() {
+        $command = new Command(['listCollections' => 1]);
+        $result = $this->manager->executeCommand('open-data-db', $command)->toArray();
+
+        $dates = [];
+        foreach ($result as $value) {
+            if (preg_match('/\\d{4}-\\d{2}-\\d{2}/', $value->name)) {
+                array_push($dates, substr($value->name, -10));
+            }
+        }
+
+        return array_values(array_unique($dates));
+    }
+
     public function getMaxCollectionNumberAtDay($name, $date) {
         $max = $this->manager->executeQuery('open-data-db.'.$name.$date, new Query([], ['sort' => ['number' => -1], 'limit' => 1]));