Working with data in a Loop

Next topic

Author	Message
Matt Dorn	Monday 27 October 2003 1:40:08 am Maybe somebody can help me. As a Web developer on other platforms, I've been in many situations where it made sense to sort data on the basis of some category field, then display the data broken down by that category. For example, let's say I have a 5-record result set that looks like this: Company: Productos AC Country: Spain Company: ABC, Inc. Country: U.S. Company: XYZ Gmbh. Country: Germany Company: Acme Enterprises Country: U.S. Company: Gonzales, SA Country: Spain Now, if I return this data sorted by country, in a language like PHP I could create a loop, and store the country name in a buffer variable before moving to the next iteration, then I'd compare the buffer country value to the current country value, and if it's different, create a delimiter (---------) in the display. So the output would look like this: XYZ Gmbh. - Germany ------------ Gonzales SA - Spain Productos AC - Spain ------------ ABC Inc. - U.S. Acme Enteprises - U.S. In EZPublish, while I can sort the data appropriately, it seems I don't have enough control within the looping structure to accomplish this. I have a loop that looks like this: {section name=Child loop=fetch(content, list, hash( parent_node_id, $node.node_id, limit, $page_limit, offset, $view_parameters.offset, sort_by,array(array('attribute',true(),215)), class_filter_type, include, class_filter_array, array( 18 ) ) )} $Child:item.data_map.country.data_text} {/section} Is there anything I can do here to accomplish my goal?
Vivienne van Velzen	Monday 27 October 2003 3:46:38 am Hi Matt, Couldn't you do something like this: {let name=myroot mytext="" } {section loop=fetch...} {section show=$myroot:mytext\|ne($:item.attribute)} ----------<br> {/section} {$:item.data_map.country.data_text}<br> {set mytext=$:item.attribute} {/section} {/let} Where $mytext is the buffer variable you mentioned. Note that I moved the namespace (the section no longer has a name, the surrounding let has), so the 'set' function works. Hope this helps, Vivienne
Matt Dorn	Monday 27 October 2003 9:38:05 am Vivienne, you are a master! I guess my main problem was not knowing how to manipulate the namespace properly (I assumed you could nest them, and still be able to set the variables in the parent namespace). Anyway, this works perfectly. Thanks so much for your help! Matt

Author

Message

Monday 27 October 2003 1:40:08 am

Maybe somebody can help me.

As a Web developer on other platforms, I've been in many situations where it made sense to sort data on the basis of some category field, then display the data broken down by that category.

For example, let's say I have a 5-record result set that looks like this:

Company: Productos AC
Country: Spain

Company: ABC, Inc.
Country: U.S.

Company: XYZ Gmbh.
Country: Germany

Company: Acme Enterprises
Country: U.S.

Company: Gonzales, SA
Country: Spain

Now, if I return this data sorted by country, in a language like PHP I could create a loop, and store the country name in a buffer variable before moving to the next iteration, then I'd compare the buffer country value to the current country value, and if it's different, create a delimiter (---------) in the display. So the output would look like this:

XYZ Gmbh. - Germany
------------
Gonzales SA - Spain
Productos AC - Spain
------------
ABC Inc. - U.S.
Acme Enteprises - U.S.

In EZPublish, while I can sort the data appropriately, it seems I don't have enough control within the looping structure to accomplish this.

I have a loop that looks like this:


    {section name=Child loop=fetch(content, list, hash( 
        parent_node_id, $node.node_id,
        limit, $page_limit,
        offset, $view_parameters.offset,
        sort_by,array(array('attribute',true(),215)),
        class_filter_type, include, 
        class_filter_array, array( 18 ) ) )}
        
        $Child:item.data_map.country.data_text}
        
    {/section}

Is there anything I can do here to accomplish my goal?

Vivienne van Velzen

Monday 27 October 2003 3:46:38 am

Hi Matt,

Couldn't you do something like this:

{let name=myroot
     mytext=""
}
{section loop=fetch...}
    {section show=$myroot:mytext|ne($:item.attribute)}
        ----------<br>
    {/section}
    {$:item.data_map.country.data_text}<br>
    {set mytext=$:item.attribute}
{/section}
{/let}

Where $mytext is the buffer variable you mentioned. Note that I moved the namespace (the section no longer has a name, the surrounding let has), so the 'set' function works.
Hope this helps,

Vivienne

Matt Dorn

Monday 27 October 2003 9:38:05 am

Vivienne, you are a master! I guess my main problem was not knowing how to manipulate the namespace properly (I assumed you could nest them, and still be able to set the variables in the parent namespace).

Anyway, this works perfectly. Thanks so much for your help!

Matt

eZ debug

Timing:	Jan 19 2025 04:36:02
Script start
Timing:	Jan 19 2025 04:36:02
Module start 'layout'
Timing:	Jan 19 2025 04:36:02
Module start 'content'
Timing:	Jan 19 2025 04:36:03
Module end 'content'
Timing:	Jan 19 2025 04:36:03
Script end

Main resources:

Total runtime	0.6485 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0084	589.1563	152.6250
Module start 'layout'	0.0084	0.0038	741.7813	39.4453
Module start 'content'	0.0122	0.6351	781.2266	480.3438
Module end 'content'	0.6473	0.0012	1,261.5703	12.1641
Script end	0.6485		1,273.7344

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0036	0.5498	16	0.0002
Check MTime	0.0014	0.2234	16	0.0001
Mysql Total
Database connection	0.0016	0.2527	1	0.0016
Mysqli_queries	0.5911	91.1524	57	0.0104
Looping result	0.0006	0.0862	55	0.0000
Template Total	0.6151	94.8	2	0.3075
Template load	0.0019	0.2894	2	0.0009
Template processing	0.6132	94.5526	2	0.3066
Template load and register function	0.0002	0.0365	1	0.0002
states
state_id_array	0.0010	0.1599	1	0.0010
state_identifier_array	0.0013	0.2000	2	0.0006
Override
Cache load	0.0016	0.2503	39	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0007	0.1085	2	0.0004
Fetch class attribute name	0.0012	0.1790	3	0.0004
XML
Image XML parsing	0.0003	0.0486	2	0.0002
class_abstraction
Instantiating content class attribute	0.0000	0.0016	3	0.0000
General
dbfile	0.0008	0.1195	10	0.0001
String conversion	0.0000	0.0015	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
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
11	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
7	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
2	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 25 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs