# odtReportSQL
This scalable library defines a complete reports/documents system for php-mySQL applications.
Features:
- Based on templates created using OpenOffice (.odt files)
- Templates can be of any size (A4, A3...) and multipage.
- On templates this system can do:
* Simple substitution based on couples #field#/value.
* Blocks and nested blocks duplication (any deep) or deletion.
* Pictures substitution.
- The HTML User Inteface is build by System and can be easy added at an existing php application. Add 2 lines ( see odtReportSQL-test.php)
* <?php include('odtReportSQL.php'); ?>
* <?php echo getReportMenu('this_page'); ?>
- This system is DB driven, using 2 tables to define all templates substitutions and UI
- Scalable:
* odtphp.php defines template substitution engine
* odtphpsql.php adds substitution queries definitions in DB
* odtReportSQL.php adds an UI defined in DB
- Any document as an URL definition.
- To add a new document is only required to make the new template and to update the DB.
- The resulting documents can be open using OpenOffice and saved in almost any format.
This system was developped to be used with a school examinations management software, with more than 25 different documents (letters, certificates, ufficial records, grade tables, notices...) from 1 to 68 pages.
see install.txt.
### TODO
- Templates issue
Description: The new document is build, but you get an error openning it: it is inusable.
Cause: The Template is sensible to the LibreOffice/OpenOffice version used.
- The "OpenOffice/4.1.8$Win32 OpenOffice.org_project/418m3$Build-9803" works without probems
- The "LibreOffice/7.3.0.3$Windows_x86 LibreOffice_project/0f246aa12d0eee4a0f7adcefbf7c878fc2238db3" don't works.
Workaround: This affect only the template setup, not the user documents creation and use.
Use allways same (old) version of OpenOffice to build and update your Templates, e.g. [https://downloads.sourceforge.net/project/openofficeorg.mirror/4.1.8/binaries/it/Apache_OpenOffice_4.1.8_Win_x86_install_it.exe](https://downloads.sourceforge.net/project/openofficeorg.mirror/4.1.8/binaries/it/Apache_OpenOffice_4.1.8_Win_x86_install_it.exe)
- More translations (files language_xx.php).
- More DB Interfaces (file commonSQL.php). Done: see common_pdo.php.
UPDATE
- 2020-02-09 the common_pdo.php file replaces the obsolete commonSQL.php file
- 2022-02-02 Used this library in the new project: tuyaDaemon.toolokit (https://github.com/msillano/tuyaDAEMON/tree/main/tuyaDAEMON.toolkit): minor bugs correction and update to php 8.
- Examples of result pages (pdf) are in the 
- Tested on:
- Windows 11, php 8.1.2, MariaDB 10.4.22
- Android 11, php 4.1, MySql 5.1
The php 8 use requires also an update of pclzip.lib (here as "lib\pclzip.2.8.4.lib.php").
|
Download
