Revize 9bc023de

refs #6975: Cors middleware zmenen z globalniho na lokalni (kvuli stahovani), pridan endpoint pro stazeni dat ve formatu csv.

backend/app/Http/Controllers/DeviceController.php

@@ -12 +12 @@
 use App\Model\Zarizeni;
 use App\Model\Zaznam;
 use Illuminate\Http\Request;
+use phpDocumentor\Reflection\Types\Array_;
+use phpDocumentor\Reflection\Types\Mixed_;
 
 class DeviceController extends Controller
 {
@@ -55 +57 @@
      * @param $id
      * @return \Symfony\Component\HttpFoundation\Response
      */
-    public function getDeviceById(Request $request, $id)
+    public function getDeviceByIdWithTraffic(Request $request, $id)
     {
+        $device = $this->getDeviceById($id);
+        if ($device != null) {
+            $device->traffics = $this->findTrafficByDevice($request, $id);
+            return json_encode($device);
+        } else {
+            return response('Not found.', 404);
+        }
+    }
 
+    /**
+     * Vrati zarizeni podle id, nebo null, pokud neni nalezeno.
+     *
+     * @param $id
+     * @return Zarizeni
+     */
+    public function getDeviceById($id) {
+        return Zarizeni::findByIdJoinAddress($id);
+    }
+
+    /**
+     * Vrati zaznamy o doprave pro dane zarizeni. Request obsahuje dodatecne url parametry.
+     *
+     * @param Request $request
+     * @param $deviceId
+     */
+    public function findTrafficByDevice(Request $request, $deviceId) {
         // nacti parametry
         $params = $this->loadDateTimeDirectionConstraints($request);
         $dateFrom = $params[self::DATE_FROM_PARAM];
@@ -66 +93 @@
         $timeTo = $params[self::TIME_TO_PARAM];
         $direction = $params[self::DIRECTION_PARAM];
 
-        $device = Zarizeni::findByIdJoinAddress($id);
+        return Zaznam::findByDevice($deviceId, $dateFrom, $dateTo, $timeFrom, $timeTo, $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.
+     *
+     * Pokud zarizeni nebylo nalezeno, je vracena 404.
+     *
+     * @param Request $request
+     * @param $id
+     * @return Mixed_
+     */
+    public function getDeviceByIdAsCsv(Request $request, $id) {
+        $device = $this->getDeviceById($id);
+
         if ($device != null) {
-            $device->traffics = Zaznam::findByDevice($id, $dateFrom, $dateTo, $timeFrom, $timeTo, $direction);
-            return json_encode($device);
+            $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);
         } else {
             return response('Not found.', 404);
         }
     }
 
+    /**
+     * 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);
+    }
+
     public function getTrafficAverageByDevice(Request $request, $id)
     {
         // nacti parametry

backend/app/Http/routes.php

@@ -24 +24 @@
  * Vrati seznam mericich zarizeni.
  */
 $app->get($apiUrlRoot.'devices', [
-    'middleware' => 'jwtauth',
+    'middleware' => ['cors', 'jwtauth'],
     'uses' => 'DeviceController@getDevice'
 ]);
 
@@ -33 +33 @@
  * Vrati zaznamy o doprav e za casovy usek pro dane zarizeni.
  */
 $app->get($apiUrlRoot.'devices/{id}', [
+    'middleware' => ['cors', 'jwtauth'],
+    'uses' => 'DeviceController@getDeviceByIdWithTraffic'
+]);
+
+$app->get($apiUrlRoot.'devices/{id}/csv', [
     'middleware' => 'jwtauth',
-    'uses' => 'DeviceController@getDeviceById'
+    'uses' => 'DeviceController@getDeviceByIdAsCsv'
 ]);
 
 /**
  * Vrati prumery dopravy pro danze zarizeni za casovy usek.
  */
 $app->get($apiUrlRoot.'devices/{id}/time-period', [
-   'middleware' => 'jwtauth',
+    'middleware' => ['cors', 'jwtauth'],
     'uses' => 'DeviceController@getTrafficAverageByDevice'
 ]);
 
@@ -50 +55 @@
  * Vrati vsechny typy aut.
  */
 $app->get($apiUrlRoot.'vehicles', [
-    'middleware' => 'jwtauth',
+    'middleware' => ['cors', 'jwtauth'],
     'uses' => 'VehicleController@getAll'
 ]);
 
@@ -58 +63 @@
  * Vrati vsechna mesta.
  */
 $app->get($apiUrlRoot.'cities', [
-    'middleware' => 'jwtauth',
+    'middleware' => ['cors', 'jwtauth'],
     'uses' => 'LocationController@getCities'
 ]);
 

backend/bootstrap/app.php

@@ -61 +61 @@
 
 $app->routeMiddleware([
     'jwtauth' => App\Http\Middleware\JWTAuthenticate::class,
+    'cors' => App\Http\Middleware\CorsMiddleware::class
 ]);
 
 /**
  * Cors middleware, ktery zpracuje OPTION requesty.
  */
-$app->middleware([
-App\Http\Middleware\CorsMiddleware::class
-]);
+//$app->middleware([
+//]);
 
 // $app->routeMiddleware([
 //     'auth' => App\Http\Middleware\Authenticate::class,