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