Managechart is a web application (PHP + js) which allows you to build interactive charts from SQL queries in databases (Postgresql, MySQL, ...). It is based on the symfony framework and the Highcharts / Stocks Javascript libraries. The charts thus created can then be embeded into web pages (iframe) and their content and display can be configured by injecting parameters into the URL. It is particularly suitable for operation with the geoCMS web mapping viewer

1. Connect your datasources (PostgreSQL, MySQL)

2. Edit SQL Requests

3. Choose a Chart Type

4. Edit your chart

5. Visualize

6. Embed with iframe

https://www-iuem.univ-brest.fr/wapps/managechart/en/chart/show/{{chart id}}/{{width in px or auto}}/{{heigth in px or auto}}/{{parameter in type defined in request}}?{{background=color|transparent}}

name color guide : https://htmlcolorcodes.com/fr/noms-de-couleur/

Exemple : https://managechart.univ-brest.fr/en/chart/show/291/800/auto/2?background=LightYellow

https://gitlab.in2p3.fr/Mathias.Rouan/docker-managechart

• PHP >= 7.2.5
• yarn or npm
• composer
• the symfony cli

$ composer install

$ yarn install

For development run

$ yarn run dev

For production run

$ yarn run build

The default database configuration can be found in the .env file, under the DATABASE_URL variable.

Migration

php bin/console doctrine:migrations:migrate

$ symfony server:start