I N D E X
you must have the rights to write in the directory sql ...
Setting Under state (integration OpenMairie)
To set the state must set
- Parametres title
- Entete Chart
- Data from Table
- Table cell
- Total Table
- Average of the table
- Registration number of the table
- Operations of the table
- Sql (SQL query of the state)
title
- Title: Title text
* Variable: £idx, £aujourdhui ... defined dyn / varetatpdf.inc
* Between [] areas defined in SQL: example [name]
- Height of each line (depending on font size)
- Police (are), attribute, size, borders, alignment of title
- Fond of the title
* With or without (transparent)
* Background color (bottom) => color choices:
- Text color => color choices:
- Intervening early (before the table), end (after painting)
Entete the table
it is the header column that define the areas
the SQL query (eg nom_usage as select name from ...)
display name
- With or without entete
- Fond of entete
* With or without (transparent)
* Background color (bottom) => color choices:
- Text color => color choices:
- Height of the header
edge and alignment for each column SQL
- Border for each column: T = top, L = left, B = bottom, R = right
- Alignment of each column: C = center, L = left, R = right, J = justify
Chart Data
it is the data in the table set out in the areas
the SQL query
- Width of the table (General settings)
- Edge
* With or without (transparent)
* Choice color of the border:
for a better reading of the data it is possible to switch 2
background colors
- Fond1 color => color choices:
- Fond2 color => color choices:
table cell
it acts cells containing the information specified in the
the SQL query
- Bottom of the cell
* With or without (transparent)
- Height of the cell
default font is reduced if the text above and the carriage return
is done for areas texts
- Width of each column: the total width of columns must be equal to the width of the table
edge and alignment for each column SQL
- Border for each column: T = top, L = left, B = bottom, R = right
- Bordure1 for each column: T = top, L = left, B = bottom, R = right
- Alignment of each column: C = center, L = left, R = right, J = justify
Total table
These areas are to configure whether to display a total or more
- Bottom of the cell
* With or without (transparent)
* Choice of the background color:
- Size of the total cell
- Height of the cell total
edge and alignment for each column SQL
- Border for each column: T = top, L = left, B = bottom, R = right
- Alignment of each column: C = center, L = left, R = right, J = justify
Average table
These areas are to configure whether to display one or more medium
- Bottom of the cell
* With or without (transparent)
* Choice of the background color:
- Size of the average cell
- Height of the average cell
edge and alignment for each column SQL
- Border for each column: T = top, L = left, B = bottom, R = right
- Alignment of each column: C = center, L = left, R = right, J = justify
registration number of the table
These areas are to configure whether to display one or more registration number of
- Bottom of the cell
* With or without (transparent)
* Choice of the background color:
- Size of the cell number
- Height of the cell number
edge and alignment for each column SQL
- Border for each column: T = top, L = left, B = bottom, R = right
- Alignment of each column: C = center, L = left, R = right, J = justify
Operations of the table
Numerique, total, average number for each column SQL
- Provides a digital display numerique: 999: alphanumeric, 0 (integer), 1 (1 decimal), 2 (2 decimals) ...
These areas are setting if it is hoped an operation (total, average number )
- Total: 0 without column, column 1
- Average: 0 without column, column 1
- Number: 0 without column, column 1
SQL
- SQL query
* Variable: £idx, £aujourdhui ... defined dyn / varetatpdf.inc
* Between [] areas defined in SQL: example [name]