AtkShuttleRelation - Revision history

Agx: added atkNode example

2015-04-02T17:41:23Z

added atkNode example

← Older revision		Revision as of 17:41, 2 April 2015
Line 32:		Line 32:
	$policy->hasMany('employees', array('through' => 'project_employee'));		$policy->hasMany('employees', array('through' => 'project_employee'));
	}		}


			=== Example atkNode ===
			An example with non normalized tables.

			$rel = $this->add(new atkShuttleRelation( 'surface', 'agx.content_to_surface', 'agx.content_filter_surface', AF_HIDE_ADD \| AF_HIDE_LIST \| AF_CASCADE_DELETE \| AF_HIDE_SEARCH ) );
			$rel->setLocalKey('cms_id_product');
			$rel->setRemoteKey('cms_id_surface');

Sandy at 09:36, 4 October 2010

2010-10-04T09:36:00Z

← Older revision		Revision as of 09:36, 4 October 2010
Line 25:		Line 25:

	'''Be careful''' when using the AF_HIDE flag in the itermediate (A_B) node for the atkManyToOneRelation, in combination with multilanguage fields. When a relation is hidden, the key (a_id) will not be processed and no check on the language is done. This causes the added record to appear multiple times (once for every language), since a_id is not unique in the intermediate table.		'''Be careful''' when using the AF_HIDE flag in the itermediate (A_B) node for the atkManyToOneRelation, in combination with multilanguage fields. When a relation is hidden, the key (a_id) will not be processed and no check on the language is done. This causes the added record to appear multiple times (once for every language), since a_id is not unique in the intermediate table.

			=== Example atkMetaNode ===
			A project has many employees, an employee has many projects

			public static function meta(atkMetaPolicy $policy) {
			$policy->hasMany('employees', array('through' => 'project_employee'));
			}

bahtiar at 21:54, 18 August 2008

2008-08-18T21:54:46Z

← Older revision		Revision as of 21:54, 18 August 2008
Line 1:		Line 1:
			{{relation}}

	An atkShuttleRelation extends the atkManyToManyRelation. The relation shows two lists, one with elements that are currently linked to the master record, and one with available records to choose from. A many-to-many relation uses an intermediate table.		An atkShuttleRelation extends the atkManyToManyRelation. The relation shows two lists, one with elements that are currently linked to the master record, and one with available records to choose from. A many-to-many relation uses an intermediate table.

Line 23:		Line 25:

	'''Be careful''' when using the AF_HIDE flag in the itermediate (A_B) node for the atkManyToOneRelation, in combination with multilanguage fields. When a relation is hidden, the key (a_id) will not be processed and no check on the language is done. This causes the added record to appear multiple times (once for every language), since a_id is not unique in the intermediate table.		'''Be careful''' when using the AF_HIDE flag in the itermediate (A_B) node for the atkManyToOneRelation, in combination with multilanguage fields. When a relation is hidden, the key (a_id) will not be processed and no check on the language is done. This causes the added record to appear multiple times (once for every language), since a_id is not unique in the intermediate table.


	~~[[Category:Relations]]~~

Jeroenvs: added constructor desc

2007-03-13T14:03:47Z

added constructor desc

← Older revision		Revision as of 14:03, 13 March 2007
Line 1:		Line 1:
	An atkShuttleRelation extends the atkManyToManyRelation. The relation shows two lists, one with elements that are currently linked to the master record, and one with available records to choose from. A many-to-many relation uses an intermediate table.		An atkShuttleRelation extends the atkManyToManyRelation. The relation shows two lists, one with elements that are currently linked to the master record, and one with available records to choose from. A many-to-many relation uses an intermediate table.

			function atkShuttleRelation($name, $link, $destination, $flags=0)
			* String $name The name of the relation.
			* String $link The full name of the node that is used as intermediairy node.
			* String $destination The full name of the node that is the other end of the relation.
			* int $flags Flags for the relation.


			The intermediairy node is assumed to have 2 attributes that are named after the nodes at both ends of the relation. For example, if node 'project' has a M2M relation with 'activity', then the intermediairy node 'project_activity' is assumed to have an attribute named 'project' and one that is named 'activity'.

	If you do not want to use the default primary keys, you can override them by using the functions:		If you do not want to use the default primary keys, you can override them by using the functions:

Jeroenvs: added picture

2007-03-13T14:00:02Z

added picture

← Older revision		Revision as of 14:00, 13 March 2007
Line 10:		Line 10:
	One person (node A) can have several skills (node B) and the same skill applies to more than one person.		One person (node A) can have several skills (node B) and the same skill applies to more than one person.

	[[image:atkShuttle.~~jpg~~\|center]]		[[image:atkShuttle.JPG\|center]]

Jeroenvs at 13:58, 13 March 2007

2007-03-13T13:58:20Z

New page

An atkShuttleRelation extends the atkManyToManyRelation. The relation shows two lists, one with elements that are currently linked to the master record, and one with available records to choose from. A many-to-many relation uses an intermediate table.

If you do not want to use the default primary keys, you can override them by using the functions:
setLocalKey("a_id");
setRemoteKey("b_id");

'''Example'''

One person (node A) can have several skills (node B) and the same skill applies to more than one person.

[[image:atkShuttle.jpg|center]]

'''Be careful''' when using the AF_HIDE flag in the itermediate (A_B) node for the atkManyToOneRelation, in combination with multilanguage fields. When a relation is hidden, the key (a_id) will not be processed and no check on the language is done. This causes the added record to appear multiple times (once for every language), since a_id is not unique in the intermediate table.

[[Category:Relations]]