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:	Feb 03 2025 03:52:23
Script start
Timing:	Feb 03 2025 03:52:23
Module start 'layout'
Timing:	Feb 03 2025 03:52:23
Module start 'content'
Timing:	Feb 03 2025 03:52:23
Module end 'content'
Timing:	Feb 03 2025 03:52:23
Script end

Main resources:

Total runtime	0.0159 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0054	591.6016	152.6328
Module start 'layout'	0.0054	0.0033	744.2344	216.1406
Module start 'content'	0.0087	0.0052	960.3750	204.7266
Module end 'content'	0.0139	0.0019	1,165.1016	34.2891
Script end	0.0159		1,199.3906

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	19.3853	14	0.0002
Check MTime	0.0015	9.6312	14	0.0001
Mysql Total
Database connection	0.0008	4.7878	1	0.0008
Mysqli_queries	0.0017	10.9301	3	0.0006
Looping result	0.0000	0.0810	1	0.0000
Template Total	0.0016	9.9	1	0.0016
Template load	0.0009	5.5048	1	0.0009
Template processing	0.0007	4.3408	1	0.0007
Override
Cache load	0.0006	3.9764	1	0.0006
General
dbfile	0.0003	1.7804	8	0.0000
String conversion	0.0000	0.0450	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	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs