EZselection and fetching data from two classes

Wednesday 11 January 2006 3:24:55 am

Here is my problem:
I want to fetch data using the Ezselection in two different classes.

I have one class - called the "producer"-class that have information about the producer.
Then i have another class- called the "product"-class that have information about the specific product. These two have Class id, 17 and 16.

Now in the admin I've made the structure so:

Qualified producers
All node ID: 132
___A-E
______Producer1 (the information about the producer such as name ++++)
_________product1 ( the information about the specific product such as type++++)
_________product2 (next product same producer)
______product3
______Producer2
_________ product1
_________.......
___F-J
___....
___ ....

In the product I have a set of attributes with Selections using style SINGLE choice.
My task is to look at the choice of the selection and only if the choice is lets say apples, then the producer+productinformation will be shown.

Example of how admin look

A-E
___Producer1 (the information about the producer such as name ++++)
______apples ( the information about the specific product such as type++++)
______apples (next product (the same as above and same producer)
______bananas (same producer but different type)
___Producer2
______bananas (not an apple - shouldn't be shown
______.......
F-J

In this case only the information about Producer1 should be shown, not the Producer2.
Ok - i hope this explained my problem.
Here is my code that i cannot get to work:

{let prod=fetch('content','list',hash(parent_node_id,132,depth, 3,class_filter_type,"include",class_filter_array,array(17,16),sort_by,array(array(priority))))}
{section name=Prod loop=$prod}
{switch match=$:item.data_map.product.content.0}
{case match=0}
{attribute_view_gui attribute=$:item.object.data_map.producer_name}
{attribute_view_gui attribute=$:item.object.data_map.product}
{attribute_view_gui attribute=$:item.object.data_map.product_category}	
<br>
{/case}
{case}{/case}
{/switch}								
{/section}
{/let}

What is displayes is something like this
Producer1
apples
apples
apples
Producer2
Producer3
apples
apples

I show all the producers even though that the producer (producer2) doesn't have a product where the selection of the single choise is selected to be apple.

I would very much appreciate to get some help. I've been stuck with this all night and went to bed 5 o'clock in the morning.....

Thanks in advance
Kristoffer Raun

<i>If you can't describe what you are doing as a process, you don't know what you're doing.</i>
W. Edwards Deming

Wednesday 11 January 2006 4:19:36 am

Hi and thanks for the fast response

product is not a ezselection
Product (actually called qualified_product) is a class with an selection-attribute that has the indentifier called product .

Without the 0 (zero) i just get all producers

producer1
producer2
producer3

even though that some of them only have "bananas" and not "apples"

the 0 (zero) was something i fould in this post:
http://ez.no/community/forum/developer/ezselection_problems/re_ezselection_problems

I've also tried "another" approach when fetching to exclude producers without apples

{let category=fetch('content','list',hash(parent_node_id,132,depth, 4,class_filter_type,"include",class_filter_array,array(16,17),'attribute_filter_array', array('and',array( 'qualified_product/product', '=', '1' ),array('producer/producer_name','!=', '0') )))}

same loop as before (only with a zero as the difference) :-)

Thanks again

<i>If you can't describe what you are doing as a process, you don't know what you're doing.</i>
W. Edwards Deming

Wednesday 11 January 2006 6:18:08 am

I've tried the what you suggested

{section name=Prod loop=$prod max=2}

{switch match=$:item.data_map.product.content}
{case match=0}
				{$:item.data_map.product.content.0|attribute(show)} 								
		
<br>
{/case}
{case}do nothing{/case}	
{/switch}	
		
{/section}

Then i get the following debug
No such attribute for array(6): product
Choose one of following: producer_name, producer_address, producer_phone,
producer_fax, producer_link, producer_image

From my limited knowledge, i guess that there is a problem fetching the class with the ID 16, the product class.
Is this the correct fetching?
class_filter_array,array(17,16) or chould it be
class_filter_array,array(16,17)?

/Kristoffer

<i>If you can't describe what you are doing as a process, you don't know what you're doing.</i>
W. Edwards Deming

Thursday 12 January 2006 2:33:52 pm

I must say that I'm close to giving up.

I can show the relevant information, but even thought that I (at least try to) get some of the data away (all producers that do NOT have apples lets say.) it's apparently fetched.

I can get it to show the producers, and the products, but my role when i want to limit the search to ONLY show the producers with the apples doesn't work

The output is
Producer1
Apples
Apples
Apples
Apples
Apples
Producer2
Apples
Apples
Apples
Apples
Producer3
Apples
Producer4
Producer5
Apples
Apples
Producer6
Producer7

Now you notice Producer 4 and 6. They do NOT have any apples and shouldn't be shown.
The fetchfunction copies the producers without apples (also them with peaches and Oranges), otherwise they wouldn't be shown.
What is happening

my code is here

{let category=fetch('content','list',hash(parent_node_id,132,depth, 4,class_filter_type,"include",class_filter_array,array(16,17),'attribute_filter_array', array('and',array( 'qualified_product/product', '=', '1' ),array('producer/producer_name','!=', '0') )))}


{section name=Cat loop=$category}

{switch match=$Cat:item.data_map.product.content.0}
												{case match=0}
											{section show=$:item.object.data_map.product_category.content.is_empty|not}
            <div class="attribute-long">
                {attribute_view_gui attribute=$:item.object.data_map.producer_name}
            </div>
        {/section}{attribute_view_gui attribute=$:item.object.data_map.producer_name}{attribute_view_gui attribute=$:item.object.data_map.product}
{attribute_view_gui attribute=$:item.object.data_map.product_category}<br>
											{/case}
											{case}{/case}
							{/switch}	

{/section}







{/let}

I have tried the attribute show, but since i can only do it 2-3 times in order to avoid crash, i cannot see whats relevant in the debug since there is a long way down to "Producer4" without apples.
Also notice that the Section apparently loops more than one time (two times), Is this due to the fetching of two classes and that EZ wants to make the loop 2 times.

I'm unfortunately getting more and more tired of things like this. Even though you can do cool stuff with EZ - it's a pain in the *** with things like this!

/Kristoffer

<i>If you can't describe what you are doing as a process, you don't know what you're doing.</i>
W. Edwards Deming

Thursday 12 January 2006 2:59:03 pm

And got in one time - ADMIN is painfully slow
Template processing takes forever????

Timing: Feb 13 2006 00:01:57
Script start
Notice: eZMySQLDB::query(0.000 ms) query number per page:0 Feb 13 2006 00:01:57
SET NAMES 'utf8'
Timing: Feb 13 2006 00:01:57
Module start 'content'
Warning: eZTemplate:def Feb 13 2006 00:01:57
Variable 'nodeContent' is already defined.
Warning: eZTemplate:def Feb 13 2006 00:01:57
Variable 'nodeContent' is already defined.
Warning: eZTemplate:def Feb 13 2006 00:01:57
Variable 'nodeContent' is already defined.
Warning: eZTemplate:def Feb 13 2006 00:01:57
Variable 'nodeContent' is already defined.
Warning: eZTemplate:def Feb 13 2006 00:01:57
Variable 'nodeContent' is already defined.
Timing: Feb 13 2006 00:01:57
Module end 'content'
Timing: Feb 13 2006 00:01:57
End

Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory
Script start 0.0000 sec 0.2019 sec 0.0000KB 0.0000KB
Module start 'content' 0.2019 sec 2.6402 sec 0.0000KB 0.0000KB
Module end 'content' 2.8421 sec 55.6087 sec 0.0000KB 0.0000KB
End 58.4508 sec 0.0000KB 0.0000KB
Total runtime: 58.8743 sec

Time accumulators:
Accumulator Elapsed Percent Count Average
ini_load
Load cache 0.1763 sec 0.2995% 19 0.0093 sec
Mysql Total
Mysql_queries 4.0811 sec 6.9311% 484 0.0084 sec
Looping result 0.1177 sec 0.1998% 479 0.0002 sec
Template Total 58.4542 sec 99.3% 3 19.4847 sec
Template load 0.5607 sec 0.9522% 3 0.1869 sec
String conversion in template resource 0.0364 sec 0.0618% 27 0.0013 sec
Template parser: create text elements 0.5219 sec 0.8864% 27 0.0193 sec
Template parser: remove whitespace 0.1221 sec 0.2074% 27 0.0045 sec
Template parser: construct tree 2.4823 sec 4.2158% 27 0.0919 sec
Template load and register function 0.0434 sec 0.0737% 11 0.0039 sec
Template processing 57.8918 sec 98.3205% 3 19.2973 sec
override
Cache load 4.1425 sec 7.0355% 690 0.0060 sec
Matching rules 0.0310 sec 0.0526% 16 0.0019 sec
class_abstraction
Instantiating content class attribute 0.0177 sec 0.0300% 2 0.0088 sec
General
String conversion 0.0244 sec 0.0415% 27 0.0009 sec
String conversion w/ mbstring 0.0180 sec 0.0305% 27 0.0007 sec
Total script time: 58.8807 sec

<i>If you can't describe what you are doing as a process, you don't know what you're doing.</i>
W. Edwards Deming

Friday 13 January 2006 2:04:07 am

Hi

The error maxium execution time of 60 seconds can be fixed with editing your php.ini file and adjusting the "max_execution_time = " variable.

Secondly if the systems is very slow you should check your cache settings in the site.ini (your override file).

Section only loops once. However, for each loop you do two print of an producer names if various conditions are set. Furthermore you should decide on either limiting the producers to show either in the fetch or the looping of the fetched objects.

Cheers
Tore