Revize 3fef37e1

refs #6975: Pridan export do csv pro time-period a day-period.

backend/app/Http/Controllers/DeviceController.php

@@ -74 +74 @@
      * @param $id
      * @return Zarizeni
      */
-    public function getDeviceById($id) {
+    public function getDeviceById($id)
+    {
         return Zarizeni::findByIdJoinAddress($id);
     }
 
@@ -84 +85 @@
      * @param Request $request
      * @param $deviceId
      */
-    public function findTrafficByDevice(Request $request, $deviceId) {
+    public function findTrafficByDevice(Request $request, $deviceId)
+    {
         // nacti parametry
         $params = $this->loadDateTimeDirectionConstraints($request);
         $dateFrom = $params[self::DATE_FROM_PARAM];
@@ -96 +98 @@
         return Zaznam::findByDevice($deviceId, $dateFrom, $dateTo, $timeFrom, $timeTo, $direction);
     }
 
+    public function findDayAverageTrafficByDevice(Request $request, $deviceId) {
+        // nacti parametry
+        $params = $this->loadDateTimeDirectionConstraints($request);
+        $dateFrom = $params[self::DATE_FROM_PARAM];
+        $dateTo = $params[self::DATE_TO_PARAM];
+        $direction = $params[self::DIRECTION_PARAM];
+
+        return Zaznam::averageByDay($deviceId, $dateFrom, $dateTo, $direction);
+    }
+
     /**
      * Nacte zarizeni spolecne se vsemi jeho zaznamy (podle url parametru) a vrati je jako stahnutelny csv soubor.
      * Csv bude obsahovat udaje o zarizeni na prvni radce, udaje o doprave na nasledujicich.
@@ -106 +118 @@
      * @param $id
      * @return Mixed_
      */
-    public function getDeviceByIdAsCsv(Request $request, $id) {
-        $device = $this->getDeviceById($id);
+    public function getDeviceByIdAsCsv(Request $request, $id)
+    {
+        return $this->createCsvFileForDeviceData(
+            $this->findDeviceByIdSetDates($request, $id),
+            $this->findTrafficByDevice($request, $id),
+            'doprava-export-'
+        );
+    }
 
+    public function getTrafficAverageByDevice(Request $request, $id)
+    {
+        $device = $this->findDeviceByIdSetDates($request, $id);
         if ($device != null) {
-            $devArray = json_decode(json_encode($device), true);
-            // tmp file
-            $tmpFileName = 'doprava-export-'.time().'.csv';
-            $tmpFilePath = tempnam(sys_get_temp_dir(), $tmpFileName);
-            $df = fopen($tmpFilePath, 'w');
-
-            // hlavicka pro zarizeni
-            fputcsv($df, array_keys($devArray));
-            fputcsv($df, $devArray);
 
-            // zaznamy o doprave
-            $traffic = $this->findTrafficByDevice($request, $id);
-            if ($traffic != null && count($traffic) > 0) {
-
-                // hlavicka pro zaznamy
-                $tr = $this->stdClassToArray($traffic[0]);
-                fputcsv($df, array_keys($tr));
-
-                // samotna data
-                foreach ($traffic as $tr) {
-                    $tr = $this->stdClassToArray($tr);
-                    fputcsv($df, $tr);
-                }
-            }
-            fclose($df);
-            return response()->download($tmpFilePath, $tmpFileName, array())->deleteFileAfterSend(true);
+            $device->traffics = $this->findTrafficAverageByDevice($request, $id);
+            return json_encode($device);
         } else {
             return response('Not found.', 404);
         }
     }
 
     /**
-     * Konvertuje objekt typu stdClass na pole pomoci funkci json_decode(), json_encode().
+     * Vrati prumerna data o doprave pro dane zarizeni jako stahnutelny csv soubor.
      *
-     * @param $object
-     * @return Array_
+     * @param Request $request
+     * @param integer $id Id zarizeni.
+     * @return Mixed_
      */
-    private function stdClassToArray($object) {
-        return json_decode(json_encode($object), true);
+    public function getTrafficAverageByDeviceCsv(Request $request, $id) {
+        return $this->createCsvFileForDeviceData(
+            $this->findDeviceByIdSetDates($request, $id),
+            $this->findDayAverageTrafficByDevice($request, $id),
+            'doprava-prumery-export-'
+            );
     }
 
-    public function getTrafficAverageByDevice(Request $request, $id)
-    {
+    /**
+     * Vrati prumerna data o doprave (pouze data o doprave) pro dane zarizeni.
+     *
+     * @param Request $request Request s parametry.
+     * @param $deviceId Id zarizeni.
+     * @return Mixed_
+     */
+    public function findTrafficAverageByDevice(Request $request, $deviceId) {
         // nacti parametry
         $params = $this->loadDateTimeDirectionConstraints($request);
         $dateFrom = $params[self::DATE_FROM_PARAM];
@@ -161 +170 @@
         $timeTo = $params[self::TIME_TO_PARAM];
         $direction = $params[self::DIRECTION_PARAM];
 
-        $device = Zarizeni::findByIdJoinAddress($id);
-        if ($device != null) {
-            $device->dateFrom = $dateFrom;
-            $device->dateTo = $dateTo;
-
-            if ($direction != null) {
-                $device->direction = intval($direction);
-            }
-
-            $device->traffics = Zaznam::averageByDevice($id, $dateFrom, $dateTo, $timeFrom, $timeTo, $direction);
-            return json_encode($device);
-        } else {
-            return response('Not found.', 404);
-        }
+        return Zaznam::averageByDevice($deviceId, $dateFrom, $dateTo, $timeFrom, $timeTo, $direction);
     }
 
     /**
@@ -184 +180 @@
      * @param $id Id zarizeni.
      * @return Mixed_
      */
-    public function getTrafficDayAverage(Request $request, $id) {
-        // nacteni parametru
-        $params = $this->loadDateTimeDirectionConstraints($request);
-        $dateFrom = $params[self::DATE_FROM_PARAM];
-        $dateTo = $params[self::DATE_TO_PARAM];
-        $direction = $params[self::DIRECTION_PARAM];
+    public function getTrafficDayAverage(Request $request, $id)
+    {
+        $device = $this->findDeviceByIdSetDates($request, $id);
 
-        $device = Zarizeni::findByIdJoinAddress($id);
         if ($device != null) {
-            $device->dateFrom = $dateFrom;
-            $device->dateTo = $dateTo;
-
-            if ($direction != null) {
-                $device->direction = intval($direction);
-            }
-
-            $device->traffics = Zaznam::averageByDay($id, $dateFrom, $dateTo, $direction);
+            $device->traffics = $this->findDayAverageTrafficByDevice($request, $id);
             return json_encode($device);
         } else {
             return response('Not found.', 404);
         }
     }
 
+
+    /**
+     * Vrati denni prumery pro jendotlive typy vozidel jako stahnutelny csv soubor.
+     *
+     * @param Request $request Request.
+     * @param $id Id zarizeni.
+     * @return Mixed_
+     */
+    public function getTrafficDayAverageCsv(Request $request, $id)
+    {
+        return $this->createCsvFileForDeviceData(
+            $this->findDeviceByIdSetDates($request, $id),
+            $this->findDayAverageTrafficByDevice($request, $id),
+            'doprava-denni-prumery-export-'
+        );
+    }
+
     public function getAll()
     {
         return Zarizeni::getAllJoinAddress();
@@ -262 +264 @@
 
         return $params;
     }
+
+    /**
+     * Konvertuje objekt typu stdClass na pole pomoci funkci json_decode(), json_encode().
+     *
+     * @param $object
+     * @return Array_
+     */
+    private function stdClassToArray($object)
+    {
+        return json_decode(json_encode($object), true);
+    }
+
+    /**
+     * Prida hlavicku pole a data z pole do csv souboru.
+     *
+     * @param $df Ukazatel na soubor.
+     * @param $array Pole.
+     */
+    private function addArrayToCsvFile($df, $array) {
+        if ($array != null && count($array) > 0) {
+            $row = $this->stdClassToArray($array[0]);
+            fputcsv($df, array_keys($row));
+
+            foreach ($array as $row) {
+                fputcsv($df, $row);
+            }
+        }
+    }
+
+    /**
+     * Funkce se pokusi nalezt zarizeni (s adresou) podle id a pokud najde, pokusi se z requestu dostat hodnoty parametru DATE_FROM,
+     * DATE_TO a DIRECTION, ktere pak prida do nalezeneho zarizeni, ktere vrati. Pokud request uvedene parametry neobsahuje, budou
+     * v zarizeni nastaveny na null.
+     *
+     * Pokud zarizeni nenajde, vrati null.
+     *
+     * @param Request $request Request s parametry.
+     * @param integer $id id zarizeni.
+     * @return Mixed_
+     */
+    private function findDeviceByIdSetDates(Request $request, $id) {
+        // nacteni parametru
+        $params = $this->loadDateTimeDirectionConstraints($request);
+        $dateFrom = $params[self::DATE_FROM_PARAM];
+        $dateTo = $params[self::DATE_TO_PARAM];
+        $direction = $params[self::DIRECTION_PARAM];
+
+        $device = Zarizeni::findByIdJoinAddress($id);
+        if ($device != null) {
+            $device->dateFrom = $dateFrom;
+            $device->dateTo = $dateTo;
+
+            if ($direction != null) {
+                $device->direction = intval($direction);
+            }
+        }
+
+        return $device;
+    }
+
+    /**
+     * Vytvoří csv soubor pro zarizeni a souvisejici data o doprave a vynuti jeho stazeni.
+     *
+     * @param Mixed_ $device Metadata zarizeni (tj. zarizeni bez dat o doprave). Pokud null, je vracena response 404.
+     * @param Mixed_ $traffic Data o doprave.
+     * @param string $namePrefix Prefix jmena stahovaneho souboru.
+     * @return Mixed_
+     */
+    private function createCsvFileForDeviceData($device, $traffic, $namePrefix) {
+
+        if ($device != null) {
+            $devArray = json_decode(json_encode($device), true);
+            // tmp file
+            $tmpFileName = $namePrefix . time() . '.csv';
+            $tmpFilePath = tempnam(sys_get_temp_dir(), $tmpFileName);
+            $df = fopen($tmpFilePath, 'w');
+
+            // hlavicka pro zarizeni
+            fputcsv($df, array_keys($devArray));
+            fputcsv($df, $devArray);
+
+            // zaznamy o doprave
+            $traffic = $this->stdClassToArray($traffic);
+            $this->addArrayToCsvFile($df, $traffic);
+            fclose($df);
+            return response()->download($tmpFilePath, $tmpFileName, array())->deleteFileAfterSend(true);
+        } else {
+            return response('Not found.', 404);
+        }
+    }
 }

backend/app/Http/routes.php

@@ -32 +32 @@
 
 
 /**
- * Vrati zaznamy o doprav e za casovy usek pro dane zarizeni.
+ * Vrati zaznamy o doprave za casovy usek pro dane zarizeni.
  */
 $app->get($apiUrlRoot.'devices/{id}', [
     'middleware' => [$corsMiddle, $jwtMiddle],
@@ -52 +52 @@
     'uses' => 'DeviceController@getTrafficAverageByDevice'
 ]);
 
+/**
+ * Vrati prumery dopravy pro danze zarizeni za casovy usek jako csv.
+ */
+$app->get($apiUrlRoot.'devices/{id}/time-period/csv', [
+    'middleware' => $jwtMiddle,
+    'uses' => 'DeviceController@getTrafficAverageByDeviceCsv'
+]);
+
 
 /**
- * Vrati denni prumery podle typu vozidla
+ * Vrati denni prumery podle typu vozidla.
  */
 $app->get($apiUrlRoot.'devices/{id}/day-period', [
     'middleware' => [$corsMiddle, $jwtMiddle],
     'uses' => 'DeviceController@getTrafficDayAverage'
 ]);
 
+/**
+ * Vrati denni prumery podle typu vozidla jako csv soubor.
+ */
+$app->get($apiUrlRoot.'devices/{id}/day-period/csv', [
+    'middleware' => $jwtMiddle,
+    'uses' => 'DeviceController@getTrafficDayAverageCsv'
+]);
+
 /**
  * Vrati vsechny typy aut.
  */