Setup

Linux

Setup the application with:

composer install

When composer will finish the download of all dependencies, Composer will ask you to give the database information to can use this one with Doctrine.

After this, enter this commands:

Doctrine:database:create
Doctrine:schema:update --force

Now, the installation is finished. Please read the "Data insertion" section to have a functional application like during the demonstration on YouTube.

Data insertion

Please execute this SQL scripts to setup the website on your server.

Person table

INSERT INTO `person` (`id`, `username`, `username_canonical`, `email`, `email_canonical`, `enabled`, `salt`, `password`, `last_login`, `confirmation_token`, `password_requested_at`, `roles`) VALUES
(1, 'PP-0001', 'pp-0001', 'nicolas.boulfroy@hotmail.fr', 'nicolas.boulfroy@hotmail.fr', 1, NULL, '$2y$13$YB87URRl19CHP2ux8Im0U.7UyPjvyqIhMAVJ5Ut/PZjtjntpTxGRy', '2018-01-28 14:32:23', NULL, NULL, 'a:1:{i:0;s:16:\"ROLE_SUPER_ADMIN\";}'),
(2, 'PP-0002', 'pp-0002', 'pierre@osef.com', 'pierre@osef.com', 1, NULL, '$2y$13$4LBtpJGm3Gf7E5b8G6guSO5kl87q.VLvzQw2bWjngkWF0qhnRopPy', '2018-01-28 14:29:07', NULL, NULL, 'a:1:{i:0;s:15:\"ROLE_PROSPECTOR\";}'),
(3, 'PP-0003', 'pp-0003', 'michel@osef.com', 'michel@osef.com', 1, NULL, '$2y$13$wruSCguoqKzbNj6xwi3jTu.VUHt4X6USLhs4GEU0aHBFQvREOJyfC', '2018-01-28 14:29:25', NULL, NULL, 'a:1:{i:0;s:15:\"ROLE_ACCOUNTANT\";}'),
(4, 'PP-0004', 'pp-0004', 'charles@osef.com', 'charles@osef.com', 1, NULL, '$2y$13$f5Wt2gaMmuU9BSMhMD6RCO0ovKwJrDRtk81LYJjwa5JYz8h.C3ze.', '2018-01-28 14:29:35', NULL, NULL, 'a:1:{i:0;s:15:\"ROLE_SUPERVISOR\";}');

The password for all accounts is : $PiD19!a

Power table

INSERT INTO `power`(`id`, `designation`, `cost`) VALUES 
(1, '4CV', 0.493), (2, '5CV', 0.543), (3, '6CV', 0.568), (4, '7CV', 0.595);

Car table

INSERT INTO `car`(`id`, `power_id`, `numberPlate`) VALUES 
(1, 1, 'DE57UGK');

Profile table

INSERT INTO `profile`(`id`, `person_id`, `car_id`, `lastName`, `firstName`, `mobilePhoneNumber`, `phoneNumber`) VALUES 
(1, 2, 1, 'SILVERLIGHT', 'Bill', '0646581978', '0148963349');

Parameter table

INSERT INTO parameter (`id`, `designation`, `value`) VALUES
(1, 'night', '80.00'),
(2, 'meal', '29.00');