Related Objects with relationship attributes

Next topic

Author	Message
paul bolger	Sunday 01 April 2007 4:26:20 pm In a site I am developing we have a database of organisations, and a database of contacts which are associated with the organisations with the eZpublish object relations system. Some of the contacts are related to several organisations, but they may have different roles (manager, for instance) with each organisation. I'm trying to come up with a way to handle this which doesn't involve duplicating the contact for each organisation they represent. Something like assigning the role as an attribute of the object relationship would do the trick, but I have no idea how you would implement this. Would some sort of Custom Tag work for this? Does anyone have any brilliant ideas? Paul Bolger Alice Springs Town Council Paul Bolger
paul bolger	Sunday 01 April 2007 11:39:56 pm Problem solved, but I'm still interested in others' opinions on whether I'm taking the right approach. I've decided to add a 'contacts' XML field to the organisations content class and add the contacts as a bulleted list of embedded objects which means I can add titles inline with the objects. Paul Bolger

Author

Message

Sunday 01 April 2007 4:26:20 pm

In a site I am developing we have a database of organisations, and a database of contacts which are associated with the organisations with the eZpublish object relations system. Some of the contacts are related to several organisations, but they may have different roles (manager, for instance) with each organisation.

I'm trying to come up with a way to handle this which doesn't involve duplicating the contact for each organisation they represent. Something like assigning the role as an attribute of the object relationship would do the trick, but I have no idea how you would implement this.

Would some sort of Custom Tag work for this?

Does anyone have any brilliant ideas?

Paul Bolger
Alice Springs Town Council

Paul Bolger

paul bolger

Sunday 01 April 2007 11:39:56 pm

Problem solved, but I'm still interested in others' opinions on whether I'm taking the right approach. I've decided to add a 'contacts' XML field to the organisations content class and add the contacts as a bulleted list of embedded objects which means I can add titles inline with the objects.

Paul Bolger

eZ debug

Timing:	Jan 19 2025 04:26:59
Script start
Timing:	Jan 19 2025 04:26:59
Module start 'layout'
Timing:	Jan 19 2025 04:26:59
Module start 'content'
Timing:	Jan 19 2025 04:26:59
Module end 'content'
Timing:	Jan 19 2025 04:26:59
Script end

Main resources:

Total runtime	0.8255 sec
Peak memory usage	4,096.0000 KB
Database Queries	52

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0066	589.2891	152.6406
Module start 'layout'	0.0066	0.0034	741.9297	39.4766
Module start 'content'	0.0101	0.8141	781.4063	486.7344
Module end 'content'	0.8241	0.0014	1,268.1406	8.1250
Script end	0.8255		1,276.2656

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0045	0.5432	16	0.0003
Check MTime	0.0015	0.1876	16	0.0001
Mysql Total
Database connection	0.0010	0.1214	1	0.0010
Mysqli_queries	0.7688	93.1333	52	0.0148
Looping result	0.0006	0.0671	50	0.0000
Template Total	0.7788	94.3	2	0.3894
Template load	0.0045	0.5427	2	0.0022
Template processing	0.7743	93.7891	2	0.3871
Template load and register function	0.0001	0.0113	1	0.0001
states
state_id_array	0.0020	0.2373	1	0.0020
state_identifier_array	0.0017	0.2116	2	0.0009
Override
Cache load	0.0035	0.4253	13	0.0003
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0718	1	0.0006
Fetch class attribute name	0.0019	0.2246	3	0.0006
XML
Image XML parsing	0.0005	0.0547	1	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0016	4	0.0000
General
dbfile	0.0008	0.0992	16	0.0001
String conversion	0.0000	0.0012	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
3	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 10 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs