Hi guys
*caveat I am not a php guy, but have bolted this together from a few posts and some experience with Toolsets 🙂
What am I trying to do:
Create a review section that updates each time a new one is submitted giving the average.
I have two relationships:
Companies (parent)
Reviews (child)
I have a (CRED) Toolset Form that is on the "Company" parent page to submit the "reviews".
When the form is submitted I use a function /cred api hook to evaluate all "reviews" for a number then save this to the parent 'company' custom field (for an average reviews rating to be displayed on the parent).
This works when I add the form directly to the "Company" page perfectly as I expect - however when adding to a different page it does not (and I would like to).
websitename.com/add-review?parent_company_id=75 <-- is the link on the "review" button.
Now I know this is not working because its trying to look for the relationship of the 'page' - and its not here... so, I tried to modify it but I am stuck.
--- Here is the code that works on the Company page directly with a cred form ---
/* */
/* Shortcode for average of Child:Reviews wpcf-review - ONLY Works on the Parent Post Type */
/* */
add_shortcode('avg-reviews', 'rating_average_func_reviews');
add_action('cred_submit_complete', 'rating_average_func_reviews',10,2);
function rating_average_func_reviews($post_id, $form_data)
{
// if a specific form
if ($form_data['id']==415)
{
$relationship = 'company-review';//Edit the exact slug of the relationship you want to target
$related_post_id = toolset_get_related_post($post_id, $relationship );//can be repeated to get another related post of other type
$child_posts = toolset_get_related_posts(
get_the_ID(), //Post to query by.
'company-review', //Slug of the relationship to query by
'parent', //Name of the element role to query by.
100, //Maximum number of returned results
0, //Result offset
array(
'meta_key' => 'wpcf-review',
'orderby' => 'meta_value',
'order' => 'ASC',
),//Additional query arguments
'post_id', //Determines return type
'child' // which posts from the relationship should be returned
);
$sum = 0;
$num = 0;
foreach ($child_posts as $child_post) {
$ratings = get_post_meta($child_post, 'wpcf-review', true);
if($ratings) {
$sum += $ratings;
$num++;
}
}
$average = 0;
if($num>0) {
//$average = $sum/$num; // dont use this since $num might be wrong if one rating is 0
$average = round($sum/count($child_posts), 1);
}
//Example of what to do with such data
update_post_meta($related_post_id, 'wpcf-review-total', $average);
return $average;
}
}
--- Here is my attempt at making it work ---
now because its on a page that has the Form and its got a URL parameter from the parent post with its ID - i try to use this.
--> this when I get the URL parameter parent ID: $parent_company = ($_GET['parent_company_id']);
add_shortcode('avg-reviews-new', 'rating_average_func_reviews_new');
add_action('cred_submit_complete', 'rating_average_func_reviews_new',10,2);
function rating_average_func_reviews_new($post_id, $form_data)
{
// if a specific form
if ($form_data['id']==415)
{
$relationship = 'company-review';//Edit the exact slug of the relationship you want to target
$related_post_id = toolset_get_related_post($post_id, $relationship );//can be repeated to get another related post of other type
$parent_company = ($_GET['parent_company_id']);
$child_posts = toolset_get_related_posts(
$parent_company, //Post to query by.
$relationship, //Slug of the relationship to query by
'parent', //Name of the element role to query by.
100, //Maximum number of returned results
0, //Result offset
array(
'meta_key' => 'wpcf-review',
'orderby' => 'meta_value',
'order' => 'ASC',
),//Additional query arguments - this might be unnecessary in my case
'post_id', //Determines return type
'child' // which posts from the relationship should be returned
);
$sum = 0;
$num = 0;
foreach ($child_posts as $child_post) {
$ratings = get_post_meta($child_post, 'wpcf-review', true);
if($ratings) {
$sum += $ratings;
$num++;
}
}
$average = 0;
if($num>0) {
//$average = $sum/$num; // dont use this since $num might be wrong if one rating is 0
$average = round($sum/count($child_posts), 1);
}
//Example of what to do with such data
update_post_meta($parent_company, 'wpcf-review-total', $average);
return $average;
}
}
-----------------------------------------------------------------------------------------------------
It doesn't return anything ... so I am obviously doing something wrong.
Help 🙂 Please
