Technical Documentation
| ID | Category | Req. | Element | Action |
|---|---|---|---|---|
| 203 | string | no | $zz['conditions'][n]['scope'] * record: with 'having' or 'where'; add['sql'], add['key_field_name'] * query: with 'sql' and 'key_field_name' * value: with 'sql' and 'field_name' * access: with 'function' and custom fields * upload (thought of, not yet implemented) * where: with 'field_name', triggers if a WHERE is set in the query for this field_name (shortcut in fields definition possible) * multi: if script is called via zzform_multi() * subrecord: with subrecord and where * noid: if an ID is so far not set (add before insert) * editing: checks where and POST value for a given field_name and if the adjoining query returns true, the condition is met (useful for adding/changing records, where a condition depends on a field value) | Show |
| 208 | string: SQL | no | $zz['conditions'][n]['sql'] | Show |
| 209 | string: field | no | $zz['conditions'][n]['key_field_ | Show |
| 943 | integer | no | $zz['conditions'][n]['subrecord' | Show |
| 205 | string: SQL | no | $zz['conditions'][n]['where'] | Show |
| 948 | boolean | no | $zz['dont_show_h1'] if set to true, h1 will not be shown | Show |
| 235 | array: path | no | $zz['dynamic_referer'] referer which links back to previous page, overwrites $zz_conf['referer'] and must be array with field1, string1 etc. Relations: $zz['fields'][n]['path']; $zz_conf['referer'] | Show |
| 242 | string | no | $zz['extra_action'] action to be performed after or before insert, update, delete
array values: `before_update`, `before_insert`, `before_delete`, `after_update`, `after_insert`, `after_delete`, `upload`
value: file to be included without ending ".inc.php"; alternatively this might also be the name of an existing function
if you do insert/update/delete queries, you might want to add them to the logging table with zz_log_sql($sql, $user, $record_id); ($sql being the query, $user the username) Relations: ACTION | Show |
| 10 | array | yes | $zz['fields'][n] Description of all table fields which shall be shown to edit a record or in list display (array). 'n' is a number and may be chosen freely (no order required). First field definition must be PRIMARY_KEY For the display order in form and list view, the order in the code is important, not the order of the numbers | Show |
| 354 | string | no | $zz['fields'][n]['access'] access on record basis
`show`: makes a subrecord not editable, just viewable Relations: $zz['access'] | Show |
| 983 | boolean | no | $zz['fields'][n]['add_details_de Relations: $zz['fields'][n]['add_details'] | Show |
| 420 | string | no | $zz['fields'][n]['add_details'] add detail records in different table, attention: current input will not be saved. Field gets ID #zz_add_details_x_y_z where x is table no [0...n], y is for subtable no [0 if main table, else 0...n] z is field number in zz-array Relations: select | Show |
| 437 | string: HTML | no | $zz['fields'][n]['add_details_ta | Show |
| 866 | boolean | no | $zz['fields'][n]['always_check_s | Show |
| 409 | string | no | $zz['fields'][n]['auto_value'] increment | ... // 1 will be added and inserted in 'default' Relations: number | Show |
| 430 | array | no | $zz['fields'][n]['calculation_fi Relations: calculated | Show |
| 431 | string | no | $zz['fields'][n]['calculation'] hours | sum (only supported modes) Relations: calculated | Show |
| 919 | string | no | $zz['fields'][n]['character_set' | Show |
| 199 | string: HTML | no | $zz['fields'][n]['class_add'] class name that will be shown if a subrecord will be added Relations: subtable | Show |
| 176 | string: HTML | no | $zz['fields'][n]['class'] class="" (some classes will be added by zzform, e. g. idrow, ...) | Show |
348 records total