I apologize the delay here
1. Yes, you are correct - my REVIEWS post type is set up as a child of the LISTING post type, and I am using the "Create Child Post" link from the listing post, so that the review gets created under the appropriate listing.
OK great. So we have many reviews, being Child of a Listing.
2. You're also correct (I think, in terms of my limited understanding of what the code is doing...) that the shortcodes generate the figures "on the fly" as it were, and do not ever save a value to the parent listing post.
Yes, I'm pretty sure here, as I don't see any Updates to the DDBB in that code, but only a return value of a types_child_posts();
3. Ideally I would like to be able to include the "average-rating" score as a saved field, so that it can be included in a parametric search. (I'm not so interested in creating a field to record the number of the reviews - just the average scores.)
==> You want to search the parent Listing by Scores.
==> So you need a Field saved in that Parent Post Type (average-rating)
==> You update that Field with the total count of reviews which currently is returned by rating_average ShortCode.
==> You can use that same code, in a update_post_meta function.
==> Ideally that update action happens when a new Review is submitted, that means, you integrate the code in your CRED API function "my_save_data_action" (which BTW i would recommend to re-name to a unique identifier)
So your CRED API function is triggered when a Review is submitted.
Below a code example, and here the logic process:
1. Review is submitted
2. It gets the value of currently submitted star-field value
3. Sum it to the already existing average value of the parent Listing
5. Update the Listing (parent) field average-score with this value.
The problem is, you already have many reviews stored, right?
You need to populate your parent Post Listing at least once so to populate the average listing amount with the total of reviews you already have.
After, every listing review (new review) will just sum the new value to it.
To update with what you already have, either do that manually or create a Custom PHP Script (can be in a CRED from) that you trigger ONCE.
To then update the review-average field each time in your Review CRED API code, go with so,thing like this:
(read comments inline for study purposes)
function my_save_data_action($post_id, $form_data)
{
// if a specific form
if ($form_data['id']==5958) {
if (isset($_POST['my_post_content'])) {
// update the standard post content field
$my_post = array(
'ID' => $post_id,
'post_content' => $_POST['my_post_content']
);
// Update the post into the database
wp_update_post( $my_post );
}
//Get the curretn reveiw star value
$star_value_this_review = get_post_meta($post_id, 'wpcf-your-star-value-field', true);
//Get the parent post ID of this post (listing)
$parent_post_id = get_post_meta($post_id, '_wpcf_belongs_your-parent-post-type-slug_id');
//get the listings average reveiw value
$listing_parent_total_stars = get_post_meta($parent_post_id, 'wpcf-average-rating', true);
//Sum the current lsitings total reveiw to the new review
$total = $star_value_this_review + $listing_parent_total_stars;
//Update the avergae reveiw of the parent listing
update_post_meta($parent_post_id, 'wpcf-average-rating', $total);
}
}
add_action('cred_save_data', 'my_save_data_action',10,2);
Please also refer to the WordPress Codex and PHP Codex to understand the process better:
https://codex.wordpress.org/Function_Reference/update_post_meta
https://developer.wordpress.org/reference/functions/get_post_meta/
hidden link
Please do not hesitate to open a new thread if other issues or problems arise
Thank you for your patience.
