[Resolved] Save Child Post Field Average and Count to Parent Post Field

[Author]

Posts

[OliverJ8211]

I have a custom post type of "company" with a child custom post type of "company-review".

The "company" post type has 2 fields of "company-ratings-average" and "company-ratings-total"

The "company-review" custom post type has a custom field of "company-rating".

There is a cred form with ID 722. That cred form is on the company post type page and when a user fills out that cred form it creates a "company-review" child post attached to the company post. The cred form has the field of "company-rating".

What I want is when a user fills out that cred form it populates the "company-ratings-average" field of the "company" with the average of all the "company-rating" fields and the "company-ratings-total" with the total number of company-review child posts.

I am following along with this post: https://toolset.com/forums/topic/sort-by-highest-rated/

Here is my code:

function update_company_review($post_id, $form_data) {
// if specific form, change ID to the CRED "Review" ID
if ($form_data['id'] == 722) {
// Get ID of Company Being Reviewed
$parent_post = $_POST['@company-company-review_parent'];

$args = array(
'posts_per_page' => -1,
'post_type' => 'company-review',
'meta_key' => '@company-company-review_parent',
'meta_value' => $parent_post,
);
$reviews = get_posts($args);

$sum = 0;
$num = 0;
foreach ($reviews as $review) {
$ratings = get_post_meta($review->ID, 'wpcf-company-rating', true);
if ($ratings) {
$sum += $ratings;
$num++;
}
}
$average = ($num > 0) ? $sum / $num : 0;

// You can keep or adjust the rounding logic as needed
$res = round($average * 2) / 2; // Rounds to nearest 0.5

update_post_meta($parent_post, 'wpcf-company-ratings-average', $res);
update_post_meta($parent_post, 'wpcf-company-ratings-total', $num);
}
}
add_action('cred_save_data', 'update_company_review', 10, 2);

My issue is that the "company-ratings-average" and "company-ratings-total" fields just end up being 0.

Any help is appreciated and let me know if you need more info.

[Minesh]

Hello. Thank you for contacting the Toolset support.

To get the related child posts, you can use the post relationship API function: toolset_get_related_posts
=> https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/#toolset_get_related_posts

What if you try to use the following code:

function update_company_review($post_id, $form_data) {
// if specific form, change ID to the CRED "Review" ID
if ($form_data['id'] == 722) {
// Get ID of Company Being Reviewed
$parent_post = $_POST['@company-company-review_parent'];


$reviews = toolset_get_related_posts($parent_post,'company-review','parent',999,0,array(),'post_object','child');

$sum = 0;
$num = 0;
foreach ($reviews as $review) {
$ratings = get_post_meta($review->ID, 'wpcf-company-rating', true);
if ($ratings) {
$sum += $ratings;
$num++;
}
}
$average = ($num > 0) ? $sum / $num : 0;

// You can keep or adjust the rounding logic as needed
$res = round($average * 2) / 2; // Rounds to nearest 0.5

update_post_meta($parent_post, 'wpcf-company-ratings-average', $res);
update_post_meta($parent_post, 'wpcf-company-ratings-total', $num);
}
}
add_action('cred_save_data', 'update_company_review', 10, 2);

If above code does not help then I will require problem URL where you added the form as well as the admin access details and also share where you added the code you shared.

[OliverJ8211]

Just tried this code and it is still showing 0's for both fields. Please request a private message so I can send you login and other info.

[Minesh]

Please send me admin access details as well as the problem URL where I can see the form and where you added the code you shared.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I have set the next reply to private which means only you and I have access to it.

[Minesh]

Can you please check now:

I've adjusted the hook as given under:

function update_company_review($post_id, $form_data) {
// if specific form, change ID to the CRED "Review" ID
if ($form_data['id'] == 722) {
// Get ID of Company Being Reviewed
$parent_post = $_POST['@company-company-review_parent'];
 
$reviews = toolset_get_related_posts($parent_post,'company-company-review','parent',999,0,array(),'post_object','child');
	
$sum = 0;
$num = 0;
foreach ($reviews as $review) {
$ratings = get_post_meta($review->ID, 'wpcf-company-rating', true);
if ($ratings) {
$sum += $ratings;
$num++;
}
}
$average = ($num > 0) ? $sum / $num : 0;
 
// You can keep or adjust the rounding logic as needed
$res = round($average * 2) / 2; // Rounds to nearest 0.5
 
update_post_meta($parent_post, 'wpcf-company-ratings-average', $res);
update_post_meta($parent_post, 'wpcf-company-ratings-total', $num);
}
}
add_action('cred_submit_complete', 'update_company_review', 10, 2);

There were issue with post relationship slug. I've adjusted the correct slug: company-company-review

Also, we are using the Form's hook "cred_submit_complete". Can you please confirm it works as expected now.

More info:
- https://toolset.com/documentation/programmer-reference/cred-api/#cred_submit_complete

[OliverJ8211]

That works great! Thank You! I just realized that the edit form needs to update the 2 fields as well. Would you mind updating the code to add form ID: 783 which is the "Company Review Form Edit"? It uses the exact same fields.

[Minesh]

What if you try to use the following code:

function update_company_review($post_id, $form_data) {
// if specific form, change ID to the CRED "Review" ID

$allowed_form_ids = array(722,783);

if (in_array($form_data['id'],$allowed_form_ids) ) {
// Get ID of Company Being Reviewed
$parent_post = $_POST['@company-company-review_parent'];
  
$reviews = toolset_get_related_posts($parent_post,'company-company-review','parent',999,0,array(),'post_object','child');
     
$sum = 0;
$num = 0;
foreach ($reviews as $review) {
$ratings = get_post_meta($review->ID, 'wpcf-company-rating', true);
if ($ratings) {
$sum += $ratings;
$num++;
}
}
$average = ($num > 0) ? $sum / $num : 0;
  
// You can keep or adjust the rounding logic as needed
$res = round($average * 2) / 2; // Rounds to nearest 0.5
  
update_post_meta($parent_post, 'wpcf-company-ratings-average', $res);
update_post_meta($parent_post, 'wpcf-company-ratings-total', $num);
}
}
add_action('cred_submit_complete', 'update_company_review', 10, 2);

Can you please confirm it works as expected.

[OliverJ8211]

That works perfectly. Thank You for your time and help. Have a great rest of your day.