Preserve the order of nodes in fetch function

Previous topic

Developer

Next topic

Author	Message
Simone D'Amico	Friday 21 January 2011 9:04:22 am Hi guys, I've an array in ini file that contains the node ID of contents to display in one page. Something like this: [PLPMenu] MenuArray[] MenuArray[]=121 MenuArray[]=60 MenuArray[]=61 MenuArray[]=62 MenuArray[]=63 MenuArray[]=111 To retrieve the content nodes, I've used the following code: {def $menu = ezini('PLPMenu', 'MenuArray', 'plp.ini')} {def $menu_items = fetch( 'content', 'node', hash( 'node_id', $menu ))} It works fine but I need to preserve the order of nodes. The fetch function, instead, returns the nodes ordered by node ID. It returns the nodes in the order 60, 61, 62, 63, 111, 121 but I need the array order. How can I preserve the right order of nodes?
Franck Magnan	Sunday 23 January 2011 7:36:48 am Hello Simone, it seems you made a mistakes in your template code: The content/node fetch function retrieve a node and you use it to retrieve an array. In your code, $menu_item is not an array but a node. The content/node fetch function needs a node_id in argument and you passed it $menu which is an array If you want to get an array of nodes, you need to use such a code : {def $menu = ezini('PLPMenu', 'MenuArray', 'plp.ini') $nodes = array() $current_node = false() } {foreach $menu as $node_id} {set $current_node=fetch( 'content', 'node', hash( 'node_id', $node_id ))} {if is_object($current_node)} {set $nodes = $nodes\|append($current_node)} {/if} {/foreach} {undef $menu $nodes} Then, in your config file, you can get an order if you use an index. For example, you can modify your code to get: [PLPMenu] MenuArray[] MenuArray[1]=121 MenuArray[2]=60 MenuArray[3]=61 MenuArray[4]=62 MenuArray[5]=63 MenuArray[6]=111 -- Developer at Open Wide
Simone D'Amico	Monday 24 January 2011 1:15:32 am Hi Frank, your post helped me a lot in finding the right solution! Instead of calling content/fetch node function outside foreach loop, now i use the foreach with $menu values and, inside I use the fetch function with single node. In this way I preserve the right order. :) Thanks a lot! :)

Author

Message

Simone D'Amico

Friday 21 January 2011 9:04:22 am

Hi guys,

I've an array in ini file that contains the node ID of contents to display in one page. Something like this:

[PLPMenu]
MenuArray[]
MenuArray[]=121
MenuArray[]=60
MenuArray[]=61
MenuArray[]=62
MenuArray[]=63
MenuArray[]=111

To retrieve the content nodes, I've used the following code:

{def $menu = ezini('PLPMenu', 'MenuArray', 'plp.ini')}
{def $menu_items = fetch( 'content', 'node', hash( 'node_id', $menu ))}

It works fine but I need to preserve the order of nodes. The fetch function, instead, returns the nodes ordered by node ID. It returns the nodes in the order 60, 61, 62, 63, 111, 121 but I need the array order.

How can I preserve the right order of nodes?

Franck Magnan

Sunday 23 January 2011 7:36:48 am

Hello Simone,
it seems you made a mistakes in your template code:

The content/node fetch function retrieve a node and you use it to retrieve an array.
In your code, $menu_item is not an array but a node.
The content/node fetch function needs a node_id in argument and you passed it $menu which is an array

If you want to get an array of nodes, you need to use such a code :

{def
     $menu = ezini('PLPMenu', 'MenuArray', 'plp.ini')
     $nodes = array()
     $current_node = false()
}
   {foreach $menu as $node_id}
     {set $current_node=fetch( 'content', 'node', hash( 'node_id', $node_id ))}
     {if is_object($current_node)}
       {set $nodes = $nodes|append($current_node)}
     {/if}
   {/foreach}
{undef $menu $nodes}

Then, in your config file, you can get an order if you use an index.
For example, you can modify your code to get:

[PLPMenu]
MenuArray[]
MenuArray[1]=121
MenuArray[2]=60
MenuArray[3]=61
MenuArray[4]=62
MenuArray[5]=63
MenuArray[6]=111

--
Developer at Open Wide

Simone D'Amico

Monday 24 January 2011 1:15:32 am

Hi Frank,

your post helped me a lot in finding the right solution!

Instead of calling content/fetch node function outside foreach loop, now i use the foreach with $menu values and, inside I use the fetch function with single node.

In this way I preserve the right order. :)

Thanks a lot! :)

eZ debug

Timing:	Jan 18 2025 05:01:18
Script start
Timing:	Jan 18 2025 05:01:18
Module start 'layout'
Timing:	Jan 18 2025 05:01:18
Module start 'content'
Timing:	Jan 18 2025 05:01:19
Module end 'content'
Timing:	Jan 18 2025 05:01:19
Script end

Main resources:

Total runtime	1.2154 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.0055	588.0469	152.6406
Module start 'layout'	0.0055	0.0033	740.6875	39.4844
Module start 'content'	0.0088	1.2053	780.1719	541.3516
Module end 'content'	1.2141	0.0013	1,321.5234	12.1250
Script end	1.2154		1,333.6484

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	0.2461	16	0.0002
Check MTime	0.0013	0.1030	16	0.0001
Mysql Total
Database connection	0.0009	0.0714	1	0.0009
Mysqli_queries	1.1632	95.7029	57	0.0204
Looping result	0.0006	0.0455	55	0.0000
Template Total	1.1740	96.6	2	0.5870
Template load	0.0019	0.1566	2	0.0010
Template processing	1.1721	96.4370	2	0.5860
Template load and register function	0.0002	0.0164	1	0.0002
states
state_id_array	0.0013	0.1042	1	0.0013
state_identifier_array	0.0017	0.1412	2	0.0009
Override
Cache load	0.0016	0.1347	29	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0004	0.0360	2	0.0002
Fetch class attribute name	0.0015	0.1247	4	0.0004
XML
Image XML parsing	0.0005	0.0405	2	0.0002
class_abstraction
Instantiating content class attribute	0.0000	0.0007	4	0.0000
General
dbfile	0.0014	0.1157	15	0.0001
String conversion	0.0000	0.0005	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
7	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
4	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezxmltags/li.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/li.tpl
1	content/datatype/view/ezxmltags/ul.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/ul.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 22 Number of unique templates used: 9

Time used to render debug report: 0.0001 secs