Technical Documentation

Show a record

	Cancel Submit data …
ID	757
Category	string: SQL
Required	no
Element	$zz['conditional_fields'][n]['sql']
Description
Description de
Example	$zz['conditional_fields'][5]['sql'] = 'SELECT '.$zz_conf['prefix'].'objectrelations.* , CONCAT(child_categories.identifier, ": ", '.$zz_conf['prefix'].'objects.identifier) AS child , CONCAT(parent_categories.identifier, ": ", parents.identifier) AS parent , '.$zz_conf['prefix'].'properties.identifier AS property , '.$zz_conf['prefix'].'objects.category_id FROM '.$zz_conf['prefix'].'objectrelations LEFT JOIN '.$zz_conf['prefix'].'objects parents ON parents.object_id = '.$zz_conf['prefix'].'objectrelations.parent_object_id LEFT JOIN '.$zz_conf['prefix'].'categories parent_categories ON parent_categories.category_id = parents.category_id LEFT JOIN '.$zz_conf['prefix'].'objects ON '.$zz_conf['prefix'].'objects.object_id = '.$zz_conf['prefix'].'objectrelations.child_object_id LEFT JOIN '.$zz_conf['prefix'].'categories child_categories ON child_categories.category_id = '.$zz_conf['prefix'].'objects.category_id LEFT JOIN '.$zz_conf['prefix'].'properties ON '.$zz_conf['prefix'].'objectrelations.relation_type_property_id = '.$zz_conf['prefix'].'properties.property_id ' .' WHERE parents.category_id = %parent_category_id% AND relation_type_property_id != '.$zz_setting['property_ids']['relation_type']['part'];
Default value
Mother ID	$zz['conditional_fields'][n] \| [752]
Relation
Updated	27 Jun 2011 11:50:11

Selection Teilbaum:: $ops; $page; $zz; $zz_conf; $zz_conf INTERNAL; $zz_conf UPLOAD; $zz_error; $zz_page; $zz_setting; $zz_sql; $zz_tab; $zz_var; WEBSERVER_DIRECTORY; zz_constants; zz_fieldtypes; zz_states; zzbrick; zzform; zzwrap; – all –

ID	Category	Req.	Element	Action
6	array	yes	$zz Description of database table and fields	Show
353	string	no	$zz['access'] allows to restrict access to main record, like $zz['fields'][n]['access'] to subtables * add_only: only allow to add record, do not show anything else (add new record-link, list table, ...) * edit_only: only allow to edit record, do not show anything else (add new record-link, list table, ...) * show: only view records * show_edit_add (no deletion possible) * show_and_add (no deletion and editing possible, but adding new records) * show_and_delete * add_then_edit: only allow to add a new record, then to reedit this record if it already exists (only works with GET['where']...) * edit_details_only: do not edit main record, allow only detail records to be edited, no deletion and adding possible * edit_details_and_add: do not edit main record, allow only detail records to be edited, adding possible (works only in combination with conditions) * none: only show list, no possibility to do anything with the records * all: allows to do everything * search_but_no_list: shows search form but no list (search form normally is tied to list), no editing allowed Relations: $zz['fields'][n]['access']	Show
954	boolean	no	$zz['add_from_source_id'] Allows to add from source_id even if the access to that ID is restricted by a $zz['where'] or $_GET['where']	Show
751	array	no	$zz['conditional_fields']	Show
752	array	no	$zz['conditional_fields'][n]	Show
759	array	no	$zz['conditional_fields'][n]['fields'] Relations: $zz['fields'][n]	Show
758	string	no	$zz['conditional_fields'][n]['max_records']	Show
754	boolean	no	$zz['conditional_fields'][n]['remove_template']	Show
757	string: SQL	no	$zz['conditional_fields'][n]['sql']	Show
756	string	no	$zz['conditional_fields'][n]['table_name']	Show
753	integer	no	$zz['conditional_fields'][n]['template_field']	Show
755	string	no	$zz['conditional_fields'][n]['title']	Show
204	array	no	$zz['conditions'] Numerical indexed array of conditions	Show
798	boolean	no	$zz['conditions'][n]['add']['always'] if set to true this means that the corresponding condition is always true if a record will be added	Show
207	string: field	no	$zz['conditions'][n]['add']['key_field_name'] To make clear if a condition is true or not while adding a record. Key field name; the corresponding value from $zz_conf['add'] will be used for the SQL query in 'sql'. Relations: $zz['conditions'][n]['add']['sql']; $zz_conf['add']	Show
206	string: SQL	no	$zz['conditions'][n]['add']['sql'] To make clear if a condition is true or not while adding a record. SQL query ending with `WHERE key_field_name = ` where value of 'key_field_name' will be added. Together with the 'where' or 'having'-condition, if this SQL query returns more than 0 lines, the condition is considered as true. If no line is returned, the condition is considered as false. Relations: $zz['conditions'][n]['add']['key_field_name']; $zz_conf['add']	Show
910	boolean	no	$zz['conditions'][n]['add']['where'] if set to true, WHERE restrictions will be checked by this condition ($zz['conditions'][n]['where'] must be set) Relations: $zz['conditions'][n]['where']	Show
212	string: field	no	$zz['conditions'][n]['field_name']	Show
815	string: function	no	$zz['conditions'][n]['function'] use function which has to return a list of allowed IDs (ID => true)	Show
211	string: SQL	no	$zz['conditions'][n]['having']	Show

Export (CSV Excel)

348 records total