Add city_zipcode3 index

[airbundle] / DataFixtures / AirFixtures.php

diff --git a/DataFixtures/AirFixtures.php b/DataFixtures/AirFixtures.php
index cfaaa62d238fffde813325dbc2a10cb0aa682192..7b3e3a3596325d2d0ce8dd516e2949a55344fbb5 100644 (file)
--- a/DataFixtures/AirFixtures.php
+++ b/DataFixtures/AirFixtures.php
@@ -2,54 +2,88 @@
 
 namespace Rapsys\AirBundle\DataFixtures;
 
 
 namespace Rapsys\AirBundle\DataFixtures;
 

-use Rapsys\AirBundle\Entity\Title;
+use Doctrine\Bundle\FixturesBundle\Fixture;
+use Doctrine\Persistence\ObjectManager;
+use Symfony\Component\DependencyInjection\ContainerAwareInterface;
+use Symfony\Component\DependencyInjection\ContainerInterface;
+use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
+
+use Rapsys\AirBundle\Entity\Civility;

 use Rapsys\AirBundle\Entity\Group;
 use Rapsys\AirBundle\Entity\User;
 use Rapsys\AirBundle\Entity\Location;
 use Rapsys\AirBundle\Entity\Slot;
 
 use Rapsys\AirBundle\Entity\Group;
 use Rapsys\AirBundle\Entity\User;
 use Rapsys\AirBundle\Entity\Location;
 use Rapsys\AirBundle\Entity\Slot;
 

-class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Symfony\Component\DependencyInjection\ContainerAwareInterface {
+class AirFixtures extends Fixture implements ContainerAwareInterface {

        /**
         * @var ContainerInterface
         */
        private $container;
 
        /**
         * @var ContainerInterface
         */
        private $container;
 

-       public function setContainer(\Symfony\Component\DependencyInjection\ContainerInterface $container = null)
-       {
+       /**
+        * @var UserPasswordHasherInterface
+        */
+       private $hasher;
+
+       public function setContainer(ContainerInterface $container = null) {

                $this->container = $container;
                $this->container = $container;

+               $this->hasher = $this->container->get('security.password_hasher_factory');

        }
 
        /**
         * {@inheritDoc}
         */
        }
 
        /**
         * {@inheritDoc}
         */

-       public function load(\Doctrine\Common\Persistence\ObjectManager $manager) {
-               $encoder = $this->container->get('security.password_encoder');
-
-               //Title tree
-               $titleTree = array(
-                       'M.' => 'Monsieur',
-                       'Mlle' => 'Mademoiselle',
-                       'Mme' => 'Madame'
+       public function load(ObjectManager $manager) {
+               //Civility tree
+               $civilityTree = array(
+                       'Mister',
+                       'Madam',
+                       'Miss'

                );
 
                //Create titles
                );
 
                //Create titles

-               $titles = array();
-               foreach($titleTree as $shortData => $titleData) {
-                       $title = new Title();
-                       $title->setShort($shortData);
-                       $title->setTitle($titleData);
-                       $title->setCreated(new \DateTime('now'));
-                       $title->setUpdated(new \DateTime('now'));
-                       $manager->persist($title);
-                       $titles[$shortData] = $title;
-                       unset($title);
+               $civilitys = array();
+               foreach($civilityTree as $civilityData) {
+                       $civility = new Civility();
+                       $civility->setTitle($civilityData);
+                       $civility->setCreated(new \DateTime('now'));
+                       $civility->setUpdated(new \DateTime('now'));
+                       $manager->persist($civility);
+                       $civilitys[$civilityData] = $civility;
+                       unset($civility);
+               }
+
+               //TODO: insert countries from https://raw.githubusercontent.com/raramuridesign/mysql-country-list/master/country-lists/mysql-country-list-detailed-info.sql
+               #CREATE TABLE `countries` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(2) NOT NULL, `alpha` varchar(3) NOT NULL, `title` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `created` datetime NOT NULL, `updated` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`), UNIQUE KEY `alpha` (`alpha`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+               #insert into countries (code, alpha, title, created, updated) select countryCode, isoAlpha3, countryName, NOW(), NOW() FROM apps_countries_detailed ORDER BY countryCode ASC, isoAlpha3 ASC;
+
+               //Dance tree
+               $danceTree = array(
+                       'Argentine Tango' => [
+                          'Milonga', 'Class and milonga', 'Public class', 'Private class'
+                       ]
+               );
+
+               //Create titles
+               $dances = array();
+               foreach($danceTree as $danceTitle => $danceData) {
+                       foreach($danceData as $danceType) {
+                               $dance = new Dance($danceTitle, $danceType);
+                               $dance->setCreated(new \DateTime('now'));
+                               $dance->setUpdated(new \DateTime('now'));
+                               $manager->persist($dance);
+                               unset($dance);
+                       }

                }
 
                //Group tree
                }
 
                //Group tree

+               //XXX: ROLE_XXX is required by

                $groupTree = array(
                $groupTree = array(

-                       'ROLE_USER',
-                       'ROLE_ADMIN',
-                       'ROLE_SUPER'
+                       'User',
+                       'Guest',
+                       'Regular',
+                       'Senior',
+                       'Admin'

                );
 
                //Create groups
                );
 
                //Create groups


@@ -69,72 +103,57 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                //User tree
                $userTree = array(
                        array(
                //User tree
                $userTree = array(
                        array(

-                               'short' => 'M.',
-                               'group' => 'ROLE_SUPER',
-                               'mail' => 'airlibre@rapsys.eu',
-                               'pseudonym' => 'Rapsys',
+                               'short' => 'Mr.',
+                               'group' => 'Admin',
+                               'mail' => 'tango@rapsys.eu',
+                               'pseudonym' => 'Milonga Raphaël',

                                'forename' => 'Raphaël',
                                'surname' => 'Gertz',
                                'forename' => 'Raphaël',
                                'surname' => 'Gertz',

+                               'phone' => '+33677952829',

                                'password' => 'test'
                        ),
                                'password' => 'test'
                        ),

+                       /*array(
+                               'short' => 'Mr.',
+                               'group' => 'Senior',
+                               'mail' => 'denis.courvoisier@wanadoo.fr',
+                               'pseudonym' => 'DJ Sined',
+                               'forename' => 'Denis',
+                               'surname' => 'Courvoisier',
+                               'phone' => '+33600000000',
+                               'password' => 'test'
+                       ),*/

                        array(
                        array(

-                               'short' => 'M.',
-                               'group' => 'ROLE_ADMIN',
+                               'short' => 'Mr.',
+                               'group' => 'Senior',

                                'mail' => 'rannou402@orange.fr',
                                'mail' => 'rannou402@orange.fr',

-                               'pseudonym' => 'Mitch',
+                               'pseudonym' => 'Trio Tango',

                                'forename' => 'Michel',
                                'surname' => 'Rannou',
                                'forename' => 'Michel',
                                'surname' => 'Rannou',

+                               'phone' => '+33600000000',

                                'password' => 'test'
                        ),
                                'password' => 'test'
                        ),

-                       array(
-                               'short' => 'Mlle',
-                               'group' => 'ROLE_ADMIN',
+                       /*array(
+                               'short' => 'Ms.',
+                               'group' => 'Regular',

                                'mail' => 'roxmaps@gmail.com',
                                'pseudonym' => 'Roxana',
                                'forename' => 'Roxana',
                                'surname' => 'Prado',
                                'mail' => 'roxmaps@gmail.com',
                                'pseudonym' => 'Roxana',
                                'forename' => 'Roxana',
                                'surname' => 'Prado',

+                               'phone' => '+33600000000',

                                'password' => 'test'
                                'password' => 'test'

-                       ),
-                       array(
-                               'short' => 'M.',
-                               'group' => 'ROLE_ADMIN',
-                               'mail' => 'majid.ghedjatti@gmail.com',
-                               'pseudonym' => 'El Guerrillero',
-                               'forename' => 'Majid',
-                               'surname' => 'Ghedjatti',
-                               'password' => 'test'
-                       ),
-                       array(
-                               'short' => 'M.',
-                               'group' => 'ROLE_ADMIN',
-                               'mail' => 'denis.courvoisier@wanadoo.fr',
-                               'pseudonym' => 'Sined',
-                               'forename' => 'Denis',
-                               'surname' => 'Courvoisier',
-                               'password' => 'test'
-                       ),
-                       array(
-                               'short' => 'M.',
-                               'group' => 'ROLE_ADMIN',
-                               'mail' => 'kastango13@gmail.com',
-                               'pseudonym' => 'Kastrat',
-                               'forename' => 'Kastrat',
-                               'surname' => 'Hasaj',
-                               'password' => 'test'
-                       ),
+                       ),*/

                );
 
                //Create users
                $users = array();
                foreach($userTree as $userData) {
                );
 
                //Create users
                $users = array();
                foreach($userTree as $userData) {

-                       $user = new User();
-                       $user->setMail($userData['mail']);
+                       $user = new User($userData['mail']);

                        $user->setPseudonym($userData['pseudonym']);
                        $user->setForename($userData['forename']);
                        $user->setSurname($userData['surname']);
                        $user->setPseudonym($userData['pseudonym']);
                        $user->setForename($userData['forename']);
                        $user->setSurname($userData['surname']);

-                       $user->setPassword($encoder->encodePassword($user, $userData['password']));
-                       $user->setActive(true);
-                       $user->setTitle($titles[$userData['short']]);
+                       $user->setPhone($userData['phone']);
+                       $user->setPassword($this->hasher->hashPassword($user, $userData['password']));
+                       $user->setCivility($civilitys[$userData['short']]);

                        $user->addGroup($groups[$userData['group']]);
                        $user->setCreated(new \DateTime('now'));
                        $user->setUpdated(new \DateTime('now'));
                        $user->addGroup($groups[$userData['group']]);
                        $user->setCreated(new \DateTime('now'));
                        $user->setUpdated(new \DateTime('now'));


@@ -147,47 +166,148 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                $manager->flush();
 
                //Location tree
                $manager->flush();
 
                //Location tree

+               //XXX: adding a new zipcode here requires matching accuweather uris in Command/WeatherCommand.php

                $locationTree = [
                        [
                $locationTree = [
                        [

-                               'title' => 'Esplanade du Trocadéro',
+                               'title' => 'Garnier opera',
+                               'short' => 'Garnier',
+                               'address' => '10 Place de l\'Opéra',
+                               'zipcode' => '75009',
+                               'city' => 'Paris',
+                               'latitude' => 48.871268,
+                               'longitude' => 2.331832,
+                               'hotspot' => true
+                       ],
+                       [
+                               'title' => 'Tino-Rossi garden',
+                               'short' => 'Docks',
+                               'address' => '2 Quai Saint-Bernard',
+                               'zipcode' => '75005',
+                               'city' => 'Paris',
+                               'latitude' => 48.847736,
+                               'longitude' => 2.360953,
+                               'hotspot' => true
+                       ],
+                       [
+                               'title' => 'Trocadero esplanade',
+                               'short' => 'Trocadero',

                                'address' => '1 Avenue Hussein 1er de Jordanie',
                                #75016 pour meteo-france, accuweather supporte 75116
                                'zipcode' => '75116',
                                'city' => 'Paris',
                                'address' => '1 Avenue Hussein 1er de Jordanie',
                                #75016 pour meteo-france, accuweather supporte 75116
                                'zipcode' => '75116',
                                'city' => 'Paris',

-                               'latitude' => 48.8619,
-                               'longitude' => 2.2888
+                               'latitude' => 48.861888,
+                               'longitude' => 2.288853,
+                               'hotspot' => false

                        ],
                        [
                        ],
                        [

-                               'title' => 'Opéra Garnier',
-                               'address' => 'Place de l\'Opéra',
-                               'zipcode' => '75009',
+                               'title' => 'Colette place',
+                               'short' => 'Colette',
+                               'address' => 'Galerie du Théâtre Français',
+                               'zipcode' => '75001',
+                               'city' => 'Paris',
+                               'latitude' => 48.863219,
+                               'longitude' => 2.335847,
+                               'hotspot' => false
+                       ],
+                       [
+                               'title' => 'Swan island',
+                               'short' => 'Swan',
+                               'address' => 'Allée des Cygnes',
+                               'zipcode' => '75015',

                                'city' => 'Paris',
                                'city' => 'Paris',

-                               'latitude' => 48.871365,
-                               'longitude' => 2.332026
+                               'latitude' => 48.849976, #48.849976
+                               'longitude' => 2.279603, #2.2796029,
+                               'hotspot' => false

                        ],
                        [
                        ],
                        [

-                               'title' => 'Marché Saint Honoré',
+                               'title' => 'Jussieu esplanade',
+                               'short' => 'Jussieu',
+                               'address' => '25 rue des Fossés Saint-Bernard',
+                               'zipcode' => '75005',
+                               'city' => 'Paris',
+                               'latitude' => 48.847955, #48.8479548
+                               'longitude' => 2.353291, #2.3532907,
+                               'hotspot' => false
+                       ],
+                       [
+                               'title' => 'Orleans gallery',
+                               'short' => 'Orleans',
+                               'address' => '8 Galerie du Jardin',
+                               'zipcode' => '75001',
+                               'city' => 'Paris',
+                               'latitude' => 48.863885,
+                               'longitude' => 2.337387,
+                               'hotspot' => false
+                       ],
+                       [
+                               'title' => 'Orsay museum',
+                               'short' => 'Orsay',
+                               'address' => '1 rue de la Légion d\'Honneur',
+                               'zipcode' => '75007',
+                               'city' => 'Paris',
+                               'latitude' => 48.860418,
+                               'longitude' => 2.325815,
+                               'hotspot' => false
+                       ],
+                       [
+                               'title' => 'Saint-Honore market',
+                               'short' => 'Honore',

                                'address' => '1 Passage des Jacobins',
                                'zipcode' => '75001',
                                'city' => 'Paris',
                                'address' => '1 Passage des Jacobins',
                                'zipcode' => '75001',
                                'city' => 'Paris',

-                               'latitude' => 48.8668,
-                               'longitude' => 2.331659
+                               'latitude' => 48.866992,
+                               'longitude' => 2.331752,
+                               'hotspot' => false

                        ],
                        [
                        ],
                        [

-                               'title' => 'Jardin Tino-Rossi',
-                               'address' => '2 Quai Saint-Bernard',
-                               'zipcode' => '75005',
+                               'title' => 'Igor Stravinsky place',
+                               'short' => 'Stravinsky',
+                               'address' => '2 rue Brisemiche',
+                               'zipcode' => '75004',

                                'city' => 'Paris',
                                'city' => 'Paris',

-                               'latitude' => 48.847736,
-                               'longitude' => 2.360953
+                               'latitude' => 48.859244,
+                               'longitude' => 2.351289,
+                               'hotspot' => false

                        ],
                        [
                        ],
                        [

-                               'title' => 'Palais de Tokyo',
-                               'address' => '13 Avenue du Président Wilson',
+                               'title' => 'Tokyo palace',
+                               'short' => 'Tokyo',
+                               'address' => '14 Avenue de New York',

                                'zipcode' => '75116',
                                'city' => 'Paris',
                                'zipcode' => '75116',
                                'city' => 'Paris',

-                               'latitude' => 48.864567,
-                               'longitude' => 2.296892
+                               'latitude' => 48.863827,
+                               'longitude' => 2.297339,
+                               'hotspot' => false
+                       ],
+                       [
+                               'title' => 'Drawings\' garden',
+                               'short' => 'Villette',
+                               'address' => 'Allée du Belvédère',
+                               'zipcode' => '75019',
+                               'city' => 'Paris',
+                               'latitude' => 48.892503,
+                               'longitude' => 2.389300,
+                               'hotspot' => false
+                       ],
+                       [
+                               'title' => 'Louvre palace',
+                               'short' => 'Louvre',
+                               'address' => 'Quai François Mitterrand',
+                               'zipcode' => '75001',
+                               'city' => 'Paris',
+                               'latitude' => 48.860386,
+                               'longitude' => 2.332611,
+                               'hotspot' => false
+                       ],
+                       [
+                               'title' => 'Monde garden',
+                               'short' => 'Monde',
+                               'address' => '63 avenue Pierre Mendès-France',
+                               'zipcode' => '75013',
+                               'city' => 'Paris',
+                               'latitude' => 48.840451,
+                               'longitude' => 2.367638,
+                               'hotspot' => false

                        ]
                ];
 
                        ]
                ];
 


@@ -196,11 +316,13 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                foreach($locationTree as $locationData) {
                        $location = new Location();
                        $location->setTitle($locationData['title']);
                foreach($locationTree as $locationData) {
                        $location = new Location();
                        $location->setTitle($locationData['title']);

+                       $location->setShort($locationData['short']);

                        $location->setAddress($locationData['address']);
                        $location->setZipcode($locationData['zipcode']);
                        $location->setCity($locationData['city']);
                        $location->setLatitude($locationData['latitude']);
                        $location->setLongitude($locationData['longitude']);
                        $location->setAddress($locationData['address']);
                        $location->setZipcode($locationData['zipcode']);
                        $location->setCity($locationData['city']);
                        $location->setLatitude($locationData['latitude']);
                        $location->setLongitude($locationData['longitude']);

+                       $location->setHotspot($locationData['hotspot']);

                        $location->setCreated(new \DateTime('now'));
                        $location->setUpdated(new \DateTime('now'));
                        $manager->persist($location);
                        $location->setCreated(new \DateTime('now'));
                        $location->setUpdated(new \DateTime('now'));
                        $manager->persist($location);


@@ -213,26 +335,17 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
 
                //Slot tree
                $slotTree = [
 
                //Slot tree
                $slotTree = [

-                       [
-                               'begin' => '14:00:00 UTC',
-                               'end' => '19:00:00 UTC'
-                       ],
-                       [
-                               'begin' => '19:00:00 UTC',
-                               'end' => '23:00:00 UTC'
-                       ],
-                       [
-                               'begin' => '23:00:00 UTC',
-                               'end' => '02:00:00 UTC'
-                       ]
+                       'Morning',
+                       'Afternoon',
+                       'Evening',
+                       'After'

                ];
 
                //Create slots
                $slots = array();
                foreach($slotTree as $slotData) {
                        $slot = new Slot();
                ];
 
                //Create slots
                $slots = array();
                foreach($slotTree as $slotData) {
                        $slot = new Slot();

-                       $slot->setBegin(new \DateTime($slotData['begin']));
-                       $slot->setEnd(new \DateTime($slotData['end']));
+                       $slot->setTitle($slotData);

                        $slot->setCreated(new \DateTime('now'));
                        $slot->setUpdated(new \DateTime('now'));
                        $manager->persist($slot);
                        $slot->setCreated(new \DateTime('now'));
                        $slot->setUpdated(new \DateTime('now'));
                        $manager->persist($slot);