Commit Graph

344 Commits

Author SHA1 Message Date
Benjamin Dauvergne 6552014b2c fix grouped data when there is no drilldown chosen (fixes #12718) 2016-07-25 16:13:23 +02:00
Benjamin Dauvergne afe0f1f167 redirect sole warehouse (fixes #12716) 2016-07-25 15:27:51 +02:00
Benjamin Dauvergne 7a4b76c7fd debian: load hobo agent after execing debian_config_common (fixes #12737)
It needs to override hobo_deploy command from hobo.agent.common.
2016-07-25 15:20:18 +02:00
Benjamin Dauvergne 6cec6f382c factorize stylesheets and js from templates (fixes #12734) 2016-07-25 15:19:24 +02:00
Benjamin Dauvergne fb23c28f1f use .to_json() method to expose measures and dimensions to templates (fixes #12735) 2016-07-25 15:19:24 +02:00
Benjamin Dauvergne c51df1f593 change service label to 'Statistiques' (fixes #12736) 2016-07-25 15:19:17 +02:00
Benjamin Dauvergne 256a76e41e MANIFEST.in: add static files 2016-07-22 17:52:55 +02:00
Benjamin Dauvergne 1788df5777 debian: modify INSTALLED_APPS before loading debian_config_common
INSTALLED_APPS is copied into TENANT_APPS by debian_config_common so it needs to
be complete before loading debian_config_common.
2016-07-22 17:36:03 +02:00
Benjamin Dauvergne 4a6b6e0471 if value should be float but is not, show 'Non applicable' 2016-07-22 16:14:46 +02:00
Benjamin Dauvergne 69fb738818 improve cube view
* make it compatible with django-select2 >=5 by implemting a dummy templatetag
* use jquery.form.js to submit cube settings
* use addclear.js to clear data fields
* make one chart by measure
* use pie charts for percent measure
* add automatic coloring of charts
* use a button style for the Download PNG link of charts
* add URL to bookmark cube settings
2016-07-22 15:54:50 +02:00
Benjamin Dauvergne 4d45677cf1 debian: fix cron.d 2016-07-21 15:07:36 +02:00
Benjamin Dauvergne 6f807b2fdb debian: fix typo in control 2016-07-21 14:32:10 +02:00
Benjamin Dauvergne 214e825659 improve cube view
* float cube form on the right
* fix multiple loading of django-select2
* make the representation choosable between table and charts
* group dimension cells in tables
* add label to y-axis of bar charts
* separte measures into multiple charts
* reduce decimals to 2 in charts
2016-07-21 14:25:40 +02:00
Benjamin Dauvergne c6aa7e30b3 limit django-select2 version to <5 2016-07-21 14:25:40 +02:00
Benjamin Dauvergne 0ca768ef06 views: make menu_json returns JSONP data 2016-07-18 16:55:45 +02:00
Benjamin Dauvergne 8e06e82f09 forms: pass width=resolve option to Select2 widgets 2016-07-18 11:54:12 +02:00
Benjamin Dauvergne 83d3573ea7 templates: do not clobber headers from gadjo/base.html overloading in publik-base-theme 2016-07-18 11:29:35 +02:00
Benjamin Dauvergne 899b810e3d debian: add synchronization scripts for w.c.s. instances 2016-07-15 18:24:48 +02:00
Benjamin Dauvergne 7b174d9ce0 add hobo agent 2016-07-15 17:14:46 +02:00
Benjamin Dauvergne 3e0204663e add compatibility with django-select2 < 5 2016-07-15 16:29:58 +02:00
Benjamin Dauvergne 8d4436868a remove debuging statement 2016-07-15 16:28:37 +02:00
Benjamin Dauvergne a6959ccdab add missing tests and templates 2016-07-14 19:23:03 +02:00
Benjamin Dauvergne 17e4461781 add more tests and publik integration
- authorization based on superuser status of users
- menu.json view for portal agent integration
- login/logout page for standalone launch
- tests of basic access control on menu.json and homepage views
2016-07-14 10:21:00 +02:00
Benjamin Dauvergne 1e43909507 debian packaging 2016-06-24 15:54:12 +02:00
Benjamin Dauvergne 7b587daeaa bijoe: fix bad indenting in EngineDimension.members() 2016-06-18 09:36:26 +02:00
Benjamin Dauvergne b06a5eeb45 bijoe: improve style of data tables 2016-06-18 09:36:26 +02:00
Benjamin Dauvergne 08fbfcff05 bijoe: style improvement 2016-06-18 09:36:26 +02:00
Benjamin Dauvergne 1b610753be bijoe: display total count of facts in each warehouses 2016-06-18 09:36:26 +02:00
Benjamin Dauvergne 7e1fc353f3 wcs_olap: improve display of decimal values (for french users) 2016-06-18 09:36:26 +02:00
Benjamin Dauvergne 45a1ba23a8 bijoe: order warehouses by name when displayed 2016-06-18 09:36:26 +02:00
Benjamin Dauvergne 521ccd5e38 bijoe: fix naming of local setting file environment variable 2016-06-18 09:36:26 +02:00
Benjamin Dauvergne 63dd871697 bijoe: add a count method to EngineCube 2016-06-18 09:36:26 +02:00
Benjamin Dauvergne c99b876e3e bijoe: add a cubes iterator to engine 2016-06-18 09:36:26 +02:00
Benjamin Dauvergne e50adcb532 bijoe: generate isoweek dimension for date dimension 2016-05-25 10:33:57 +02:00
Benjamin Dauvergne 32d5d1316a bijoe: flatten Decimal to unicode in JSON export 2016-05-25 10:12:50 +02:00
Benjamin Dauvergne 0db609c84c bijoe: hide chart when there is no data 2016-05-25 10:12:26 +02:00
Benjamin Dauvergne 43da5dbf74 bijoe: improve table style 2016-05-25 10:12:15 +02:00
Benjamin Dauvergne 6c8d417216 bijoe: fix z-index of ODS export button 2016-05-25 10:11:51 +02:00
Benjamin Dauvergne fab899f323 bijoe: make psycopg2 return unicode strings 2016-05-25 10:11:12 +02:00
Benjamin Dauvergne 8dde361806 add ods package from w.c.s. 2016-05-25 01:48:04 +02:00
Benjamin Dauvergne b6df6a2a35 bi-joe: BI engine and frontend for PostgreSQL 2016-05-25 01:24:07 +02:00
Benjamin Dauvergne adbf712825 add debian packaging 2016-05-19 11:13:12 +02:00
Benjamin Dauvergne cb206893cd wcs-olap: build a start schema from data exported by w.c.s. API
Given such an .INI file:

	[https://demarches.triffouilly.fr/]
	orig = bi.triffouilly.fr
	key = 452b8964
	pg_dsn = dbname=publik-bi
	email = bi@entrouvert.com
	schema = triffouilly
	# slugs = recette-technique-ajout-d-un-enfant

It builds a schema named 'triffouilly' in the pre-existing database named 'publik-bi', the schema will contains tables named:

    channel (label varchar)
    role (label varchar)
    category (label varchar)
    form (category, label)
    formdata : parent table of all formdata tables)
        (form, receipt_time, year, month, dow, hour, channel, backoffice, generic_status)
    status (generic statuses: new, in progress & closed
        label

    for each formdef tables named:

       formdata_{formdef.slug}
       status_{formdef.slug}

       for each anonymisable
2016-05-19 11:13:12 +02:00
Benjamin Dauvergne b6b28a96cd add cubes configuration for 3m 2016-01-09 22:06:12 +01:00