[solved] Count total of field values from pages in selector

[Martinus]

 

I retieve my Products by $items as $item.
Inside each $item-page is a $rating field.

$item1 has $rating value 4
$item2 has $rating value 3
etc.

I need to count the $rating field-value inside each $item-page that match my selector to get the average.
To see how many $item each seller has, I used the code below. But I do not know how to proceed:

<?php 
	$qty = $pages->count("parent=/products/, seller=$item"); 
	echo $qty; 
?>

[flydev]

Hi, you could use PageSum for simplicity. Just install the module and then for example:

$selector = "parent=/products/, seller=$item"; // your selector
$cnt = $pages->count($selector); // number of pages that match $selector
if(!$cnt) echo 'No rated product found';
$sum = $pages->sum($selector, "rating"); // get sum of all matched products from "rating" field with "PageSum"
$avg = $sum / $cnt; // math
echo "Average rating of {$item->title} product (x$cnt) is ". number_format($avg, 2); // format number as needed

 

[Martinus]

Oh thanks for that! I prefer not to install to much extra's though.

I also came up with a solution:

<?php 
    $avg = $pages->find("parent=/products/, seller=amazon, rating>0"); 
    $a = array(); 					// create new array
    foreach($avg as $nr) { 			// loop through items from selector
    	$rating = $nr->rating; 		// place the found number in a variable
    	array_push($a, $rating); 	// place the variable in the created array
    } 
    print_r ($a); 					// check array
    echo array_sum($a); 			// sum of all values in array
?>

 

[AndZyk]

Hello @Martinus,

maybe findRaw() could simplify your solution:

$a = $pages->findRaw("parent=/products/, seller=amazon, rating>0", "rating");
print_r ($a); 					// check array
echo array_sum($a); 			// sum of all values in array

Regards, Andreas

[Martinus]

Hi @AndZyk,

Your code is what I needed. More small and easier to read. Thank you so much ?