User Tools
niota-docs:niota_constants
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
niota-docs:niota_constants [2021/11/14 10:11] admin |
niota-docs:niota_constants [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ==== PHP-file defined constants ==== | ||
| + | === color theme grid area / color theme admin pages === | ||
| + | * ''VEGA'' - blue | ||
| + | * ''VULCAN'' - red/pink | ||
| + | * ''SANDSTORM'' - yellow/brown | ||
| + | * ''MOSS'' - green | ||
| + | * ''SALVA'' - gray | ||
| + | \\ | ||
| === connection database type === | === connection database type === | ||
| - | * ''DB_TYPE_OCI805'' - Oracle native interface | + | * ''DB_TYPE_OCI805'' - Oracle native interface |
| - | * ''DB_TYPE_ODBC_MSSQL'' - Microsoft SQL Server via ODBC | + | * ''DB_TYPE_ODBC_MSSQL'' - Microsoft SQL Server via ODBC |
| - | * ''DB_TYPE_MSSQL'' - Microsoft SQL Server native interface | + | * ''DB_TYPE_MSSQL'' - Microsoft SQL Server native interface |
| * ''DB_TYPE_ODBC_TERADATA'' - Teradata via ODBC | * ''DB_TYPE_ODBC_TERADATA'' - Teradata via ODBC | ||
| - | * ''DB_TYPE_MYSQLI'' - MySQL Server native | + | * ''DB_TYPE_MYSQLI'' - MySQL server native interface |
| + | \\ | ||
| === connection type === | === connection type === | ||
| * ''CONN_TYPE_DATABASE'' - database | * ''CONN_TYPE_DATABASE'' - database | ||
| * ''CONN_TYPE_WEBSERVICE'' - webservice | * ''CONN_TYPE_WEBSERVICE'' - webservice | ||
| + | \\ | ||
| + | === default pagesize admin / default pagesige grid area === | ||
| + | * ''10'' - display 10 rows per page | ||
| + | * ''20'' - ... | ||
| + | * ''30'' - ... | ||
| + | * ''50'' - ... | ||
| + | * ''100'' - ... | ||
| + | * ''-1'' - display all rows | ||
| + | \\ | ||
| + | === grid area language === | ||
| + | * ''en'' - english | ||
| + | * ''de'' -- deutsch | ||
| + | \\ | ||
| + | === MS SQL server encoding === | ||
| + | * ''SQLSRV_ENC_CHAR'' - | ||
| + | Data is returned in 8-bit characters as specified in the code page of the Windows locale that is set on the system. Any multi-byte characters or characters that do not map into this code page are substituted with a single byte question mark (?) character. **This is the default encoding.** | ||
| + | \\ | ||
| + | ==== application / database defined constants ==== | ||
| + | === special usergroups === | ||
| + | * ''*ALL_GROUP'' - every user in niota is member of this group | ||
| + | * ''*ALL_ADMIN_GROUP'' - every user with admin option activated is member of this group | ||
| + | * ''*ALL_NON_ADMIN_GROUP'' - every user without admin option is member of this group | ||
| + | \\ | ||
| + | === callable object binding === | ||
| + | * ''0'' - table level binding | ||
| + | * ''1'' - line level binding | ||
| + | \\ | ||
| + | === callable object prompt type === | ||
| + | * ''0'' - no target page/no prompt page | ||
| + | * ''1'' - file upload prompt page is displayed | ||
| + | \\ | ||
| + | === callable object type === | ||
| + | * ''0'' - stored procedure | ||
| + | * ''1'' - sql statement | ||
| + | * ''2'' - batch command | ||
| + | * ''3'' - web service call | ||
| + | \\ | ||
| + | === catalogobject configuration parameter === | ||
| + | * ''max_number_validation_err'' - overwrites system value ''MAXNUMBER_VALIDATIONERR'' on catalogobject level | ||
| + | * ''max_number_validation_msg'' - overwrites system value ''MAXNUMBER_VALIDATIONMSG'' on catalogobject level | ||
| + | * ''max_number_validation_row'' - overwrites system value ''MAXNUMBER_VALIDATIONROW'' on catalogobject level | ||
| + | \\ | ||
| + | See [[niota-docs:niota_system_config_defaults|default settings]] for further details. | ||
| + | |||
| + | === column / constraint-operation data type === | ||
| + | * ''D'' - date | ||
| + | * ''T'' - datetime | ||
| + | * ''N'' - numeric | ||
| + | * ''C'' - textual | ||
| + | \\ | ||
| + | === connection type === | ||
| + | * ''0'' - database connection | ||
| + | * ''1'' - web service connection | ||
| + | \\ | ||
| + | === table link type === | ||
| + | * ''0'' - tables are linked in a master-detail relation | ||
| + | * ''1'' - tables are linke as advanced filter relation | ||
| + | \\ | ||
| + | === operations for constraints/ master detail / advanced filter === | ||
| + | * ''0'' - no operation - used for advanced filter feature so set defaults from filter instance to filtered instance | ||
| + | * ''1'' - equals | ||
| + | * ''2'' - not equals | ||
| + | * ''3'' - greater than | ||
| + | * ''4'' - less than | ||
| + | * ''5'' - greater than or equal to | ||
| + | * ''6'' - less than or equal to | ||
| + | * ''7'' - between | ||
| + | * ''8'' - not between | ||
| + | * ''9'' - like | ||
| + | * ''10'' - not like | ||
| + | * ''11'' - starts with | ||
| + | * ''12'' - starts not with | ||
| + | * ''13'' - ends with | ||
| + | * ''14'' - ends not with | ||
| + | \\ | ||
| + | === transaction target page === | ||
| + | * ''niota.php'' - for table loading | ||
| + | * ''execute_callable.php'' - to execute callable objects | ||
| + | \\ | ||
| + | === transaction parameters === | ||
| + | * ''popup_filter'' - define popup filter | ||
| + | * ''selected_instance'' - loads a catalog object instance | ||
| + | * ''callable_object'' - runs a callable object | ||
| + | * ''filter instance'' - popup filter catalog-object-instance | ||
| + | \\ | ||
| + | === usergroup types === | ||
| + | * ''1'' - self group - has only user as it's implicit member | ||
| + | * ''2'' - custom group - may have more then on user as member | ||
| + | \\ | ||
| + | === color codes === | ||
| + | System values, cannot be overwritten. | ||
| + | ^vega ^sandstorm ^vulcan ^moss ^salva ^ | ||
| + | |light |#B8DDE1 |#F1E6B2 |#FCC89B |#C2E189 |#d0d3d4 | ||
| + | |mid |#9BD3DD |#DFD1A7 |#FDBE87 |#B7DD79 |#c1c6c8 | ||
| + | |dark |#77C5D5 |#D9C89C |#FDAA63 |#A4D65E |#a2aaad | ||
| + | |dark(rgb) |119,197,213 |217,200,156 |253,170,99 |164,214,94 |162,170,173 | ||
niota-docs/niota_constants.1636881081.txt.gz · Last modified: 2025/07/17 14:11 (external edit)