Revize 5d0f8ac1

Re #7857
+ mongo propojení přes php-extension - symfony mongo-odm-bundle se pro
naši aplikaci nehodí

.docker-compose-dev.yml

@@ -44 +44 @@
                volumes:
                         - data-db:/data/db
                         - ./dev-dump:/dev-dump
+                        
 volumes:
     data-db:
+    
 networks:
        frontend:
        backend:

scripts/dev/build.bat

@@ -1 +1 @@
 docker-compose down
 docker-compose -f .docker-compose-dev.yml up --build -d
+docker-compose exec php-fpm composer config extra.symfony.allow-contrib true --no-interaction --working-dir=/var/www/symfony
 docker-compose exec php-fpm composer install --no-interaction --working-dir=/var/www/symfony
 docker-compose exec php-fpm composer update --no-interaction --working-dir=/var/www/symfony
-docker-compose exec database mongorestore --username root --password root --authenticationDatabase admin --db open-data-db ./dev-dump/admin
-docker-compose exec database mongorestore --username root --password root --authenticationDatabase admin --db open-data-db ./dev-dump/data
+

website/composer.json

@@ -7 +7 @@
         "php": "^7.2.5",
         "ext-ctype": "*",
         "ext-iconv": "*",
+        "doctrine/annotations": "*",
         "sensio/framework-extra-bundle": "^5.5",
         "symfony/console": "5.0.*",
         "symfony/dotenv": "5.0.*",
         "symfony/flex": "^1.3.1",
         "symfony/framework-bundle": "5.0.*",
-        "symfony/yaml": "5.0.*",
-        "doctrine/annotations": "*",
-        "symfony/twig-pack" : "*",
-        "doctrine/mongodb-odm-bundle": "*"
+        "symfony/twig-pack": "*",
+        "symfony/yaml": "5.0.*"
     },
     "require-dev": {
         "friendsofphp/php-cs-fixer": "^2.16",
@@ -63 +62 @@
     },
     "extra": {
         "symfony": {
-            "allow-contrib": false,
+            "allow-contrib": "true",
             "require": "5.0.*"
         }
     }

website/composer.lock

@@ -4 +4 @@
         "Read more about it at https://getcomposer.org/doc/01-basic-usage.md#installing-dependencies",
         "This file is @generated automatically"
     ],
-    "content-hash": "88fc942d3af8ccdab2c606f3ba3cb47f",
+    "content-hash": "d3c2690381cd0996c18c1c04aa5ca9aa",
     "packages": [
         {
             "name": "doctrine/annotations",

website/config/bundles.php

@@ -4 +4 @@
     Symfony\Bundle\FrameworkBundle\FrameworkBundle::class => ['all' => true],
     Sensio\Bundle\FrameworkExtraBundle\SensioFrameworkExtraBundle::class => ['all' => true],
     Symfony\Bundle\TwigBundle\TwigBundle::class => ['all' => true],
-    Twig\Extra\TwigExtraBundle\TwigExtraBundle::class => ['all' => true],
+    Twig\Extra\TwigExtraBundle\TwigExtraBundle::class => ['all' => true]
 ];

website/src/Controller/HeatmapController.php

@@ -4 +4 @@
 
 use Symfony\Component\Routing\Annotation\Route;
 use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
+use Doctrine\ODM\MongoDB\DocumentManager;
+use App\Entity\OpenData;
+use MongoDB\Client;
 
 class HeatmapController extends AbstractController {
 
@@ -12 +15 @@
      */
     public function index() {
 
+        $client = new Client(
+            'mongodb://root:root@database',
+            [],
+            [
+                'typeMap' => [
+                    'array' => 'array',
+                    'document' => 'array',
+                    'root' => 'array',
+                ],
+            ]
+        );
+        
+        $db = $client->selectDatabase('open-data-db');
+        $collection = $db->selectCollection("KOLOBEZKY31102018");
+        $openData = $collection->find();
+
         return $this->render('heatmap.html.twig', [
-            'title' => 'Hello World!',
+            'open_data' => $openData->toArray()
         ]);
     }
 }

website/templates/heatmap.html.twig

@@ -2 +2 @@
 
 {% block body %}
 
-    <h1> {{ title }} </h1>
+    {% for data in open_data %}
+        {{ data._id}} {{data.place}} {{ data.x }} {{ data.y }} {{ data.number }} {{ data.date }}<br>
+    {% endfor %}
 
 {% endblock %}