# 2024-03-12
- INIT: Addon initialization
# 2024-07-03/05
- ADDED: Display charts with Query Builder data - v0.4
- ADDED: Query Builder missing fields management
- ADDED: Built-in missing fields management
# 2024-07-30
- ADDED: Added nb records created graph - v0.5
# 2024-08-01
- FIXED: lic_ws fix
# 2024-09-11
- CHANGED: Refactored graph creation to integrate live preview, preview query builder graph - v0.6
- ADDED: Filter on custom range on graph preview
# 2024-09-12
- ADDED: Can now set some data filters on graph creation & preview (built in mode, lines bars graphs) - v0.7
# 2024-09-17/19
- ADDED: Templates & new date filters - v0.8 - v0.9
- ADDED: Can now choose image or dynamic graph for templates URL, can save date filter period after selection in view
- ADDED: Template URL modal now manages default and custom select values
- ADDED: Filters and templates for preset
- ADDED: Added genotype strains default field in filters
# 2024-09-25/27
- ADDED: Added Project code to filters & templates for lines and bars graphs, improved template URL display modal - v1.0
- ADDED: Added Project code to pie and donut graphs data selection
- FIXED: Remove filters when graph is removed
- ADDED: Added Project code to filters & templates for pies and donuts
- ADDED: Remove a template
- CHANGED: Refactored Querybuilder fields configuration in DB and in classes to harmonize with other special fields, fixed fields display_order bug - v1.001
- ADDED: Added Keeper to filters & templates
- CHANGED: Graph/template creation button is now in main menu
- FIXED: New graph created is now sortable
# 2024-09-30
- ADDED: Graph creation: on filter selection, display a select with values if filter has predefined values
# 2024-10-01
- ADDED: Graph edition and update - v1.002
# 2024-10-03
- ADDED: Boxplot and violin graphs, working for types field, select, date, datetime, project code - v1.003
- ADDED: Added experimental parameter to_blob=1 to graph short url, to return image blob as text only
# 2024-10-08
- ADDED: Multi Y axis for line, bar, boxplot, violin graphs - v1.004
- ADDED: Graph duplication (in graph menu)
# 2024-10-14/16
- ADDED: View for LC record - v1.005
- ADDED: Templates edition, improved templates list
- ADDED: On View setup modal, added an option to choose if graphs are removed or transfered to another view, on view deletion
# 2024-11-20
- ADDED: Graphs on Chemicals Lots - v1.006
# 2024-11-29
- ADDED: Dynamic filters on graphs and templates, refactored external tab for LC to use ajax - v1.007
# 2024-12-04
- ADDED: Dynamic filters in get.php URL, show dynamic filters in template popin
# 2024-12-09/13
- ADDED: New type table - v1.008
- ADDED: Added field type autocomplete for filters and templates, fixed bugs, fixed warnings - v1.009
- ADDED: Added field type autocomplete for pies and donuts
- ADDED: Added field type link for tables
# 2024-12-17/18
- FIXED: Fixed JS error on graph preview
- ADDED: Copied tooltip on copy click - v1.010
- CHANGED: Tables ordered by date DESC
************** 2025 **************
2025-01-06
- ADDED: Last n points for tables - v1.011
2025-01-15
- FIXED: Fixed some problems on last n points on type table
- FIXED: Fixed some problems on last n points on linear and class graphs
2025-01-22/24
- CHANGED: Refactored data retrieval to be more generic and evolutive
- ADDED: Table sorting on basic data, custom select and yes_no fields, project_code
- ADDED: Table sorting on sample_type, org, keeper/author/main_operator - v1.012
- ADDED: add ReportBuilder
- BUG: Error getting lab information ReportBuilder
- BUG: Remove ReportBuilder license - v1.1
- ADDED: Added boxplot and violin graphs for query builder
- ADDED: Added table & table sorting for query builder - v1.101
2025-01-27/31
- BUG: Avoid XSS attacks from printing data (ReportBuilder) (DEV-742)
- CHANGED: When a QB field has no legend, take the field name to avoid empty name
- CHANGED: In table view, show ASC button first and DESC second
- ADDED: Added filters, dynamic filters, and templates for query builder graphs
- CHANGED: Silent errors when graph is shown directly by URL - v1.102
2025-02-04/07
- CHANGED: Improved preset: changed sum_records_created to sum_by, and can now sum on every field - v1.103
- BUG: Incorrect display of field names due to HTML entities (ReportBuilder) (DEV-816)
- CHANGED: Updated element titles (ReportBuilder) (DEV-816)
- CHANGED: Restricted advanced header to allow only one option (ReportBuilder) (DEV-816)
- BUG: Fixed distortion of the default logo (ReportBuilder) (DEV-816)
- CHANGED: Light table styles when showed by URL call
- ADDED: Added a setup page with palette management, only one default palette for now - v1.104
2025-02-10/13
- BUG: Fixed project code retrieval on table graphs
- BUG: Fixed template url in popin when multiple filters
- CHANGED: Major upgrade for dompurify (DEV-825)
- ADDED: Templates without link to module now appears in LC record tab and show all module points with sample template field value than opened record - v1.105
- CHANGED: Template URL page now uses assets with absolute path
- BUG: Error printing preview (ReportBuilder) (DEV-828)
- ADDED: Display fields on footer (ReportBuilder) (DEV-828)
- ADDED: In LC labgraphs tab, highlight record point on graph (line, bar, table)
- CHANGED: Improve UX (ReportBuilder)
- CHANGED: Now templates are attached to a view, and so can be duplicate from view - v1.106
2025-02-19/21
- ADDED: Can now choose Y axis for Sum By preset, summing values instead of summing records rows
- FIXED: Fixed last N points save on the fly bug
- FIXED: Fixed multiple warnings
- CHANGED: get.php now rendering strictly minimum css and js files as needed - v1.107
- ADDED: License management: default 30d demo for report builder, limit 5 graphs (line/bar) and 1 template - v1.108
- CHANGED: Now on click on create graph menu button, redirect to homepage and automatically open the popin
- FIXED: Fixed a bug on pie/donut charts when data used is keeper/main_operator/author
- FIXED: Fixed a bug on users/groups data filtering
2025-02-25
- ADDED: Added new graph type radar for built-in graphs, working with templates and data CSV export - v1.109
2025-02-25
- ADDED: Allow add and remove columns table element Report Builder (DEV-837)
- BUG: Allow save custom elements report builder (DEV-893)
- ADDED: Synchronize module header changes (DEV-895) - v1.110
- ADDED: Added radar graphs for data from query builder, and fixed potential bug on built in radar
- ADDED: use fields as values custom elements report builder (DEV-894)
- CHANGED: Refactored query builder graphs filtering
- CHANGED: Updated Chartjs from 4.4.4 to 4.4.8 and boxplot and annotations plugins
- BUG: Error displaying data when group by selected report builder
- BUG: custom fields printing empty values report builder
2025-03-06
- ADDED: added image element ReportBuilder (DEV-912)
- ADDED: added page break element ReportBuilder (DEV-911)
- BUG: Wrong display when no data found from data source ReportBuilder
- BUG: Error when clicking to back to datasource selections ReportBuilder
- BUG: prevent unnecessary page refreshes and improve performance ReportBuilder
- BUG: restart states when no datasource selected ReportBuilder
- BUG: Wrong display selecting element ReportBuilder
- BUG: Add missing field database ReportBuilder - v1.111 (DEV-935)
- BUG: Error getting data using Local QueryBuilder (DEV-941)
- BUG: Resolved an issue preventing module activation (DEV-946)
- BUG: Wrong display preview ids (DEV-950)
- ADDED: Prevent users from leaving the page without saving ReportBuilder (DEV-933)
- BUG: Temporal image was not deleted ReportBuilder
2025-03-14
- BUG: Line break doesn't work on elements ReportBuilder
- BUG: wrong display custom fields when no preview value selected
2025-03-18
- ADDED: Labgraphs API to return graph list by owner (DEV-980) - v1.112
- BUG: Remove library html2pdf (DEV-997)
- ADDED: New printing mode (DEV-997)
2025-03-20
- FIXED: Fixed fatal on template popin: display values used in data - v1.113
2025-03-25/27
- BUG: dont save when no datasource selected (ReportBuilder)
- BUG: Incorrect page height calculation in ReportBuilder
- BUG: Corrected validation for adding elements in ReportBuilder
- BUG: Printing empty table ReportBuilder
- BUG: delete editable box inside table (ReportBuilder)
- BUG: Error Changing table alignment (ReportBuilder)
- BUG: When a admin is full acess (no group), he now sees all data from user
- BUG: When a graph is shared, now filters are also duplicated - v1.114
- FIXED: Fixed critical Potential SQL injection via string-based query concatenation (DEV-1031) - v1.115
2025-03-31
- ADDED: added Labgraph element ReportBuilder (DEV-981)
- BUG: display empty paragraph element ReportBuilder
2025-03-02/03
- FIXED: Fixed some encoding problems
- ADDED: Proportional legend when direct call
2025-04-03
- FIXED: wrong display text drag and drop fields on preview (ReportBuilder)
- FIXED: Improve labgraphs element (ReportBuilder)
- FIXED: Error switching beetween models (ReportBuilder)
2025-04-08
- FIXED: Error editing table content (ReportBuilder)
- FIXED: Individual configuration was not working (ReportBuilder)
- FIXED: Remove templates of labgraph list (ReportBuilder)
2025-04-14
- FIXED: Previously added elements are removed when selecting the data source (ReportBuilder)
- FIXED: Incorrect images display on header (ReportBuilder) (DEV-1092)
- FIXED: Error when adding element after datasource elements (ReportBuilder)
- FIXED: Duplicated elements when loading template (ReportBuilder)
2025-05-05/06
- FIXED: LabGraph element table now correctly retains formatting configuration (ReportBuilder)
- FIXED: Allow multi print from labcollector (ReportBuilder) (DEV-1107)
- ADDED: French translations - v1.116
2025-05-07/09
- FIXED: Prevent users from leaving the page without saving (ReportBuilder) (DEV-933)
- FIXED: Error json encode "Malformed UTF-8 characters, possibly incorrectly encoded"
2025/12/05
- ADDED: added translations to ReportBuilder
2025-05-15/16
- FIXED: Incorrect API encoding characters
- ADDED: New option table_remove_empty_data=0|1 to remove empty columns/lines, new option silent_no_data=0|1 to show/hide graph has no data message (DEV-1158) - v1.117
- ADDED: Allow use graph templates on report (ReportBuilder)