[Resolved] Limit Numerical Field Value in Child to the Value of Numerical Field in Parent

[Author]

Posts

[jonB-5]

I have 3 Custom Post Types with the following names and setup...

Ticket is Parent of Ticket Variation, which is Parent of Booking

When a Ticket is created, a value is entered to a numerical custom field titled total-available-for-ticket
Ticket Variations have a numerical custom field titled total-available-for-variation
Bookings have a numerical custom field titled total-places-booked

There are two instances where I need to use CRED Form Validation to control what values can be entered, but have been unable to understand the code required to do so. Any help with the following would be appreciated, especially if you could provide code examples!

1. When a Variation is created as a Child of a Ticket (in CRED), the user can enter a value for how many of that Variation are available in the field total-available-for-variation. I need the potential value the user can enter to be limited so that it cannot be higher than the value of the field total-available-for-ticket in the Parent Ticket.

2. When a Booking is created as a Child of a Variation (in CRED), the user can enter a value for how many places have been Booked in the field total-places-booked. I need the potential value the user can enter to be limited so that it cannot be higher than the value of the field total-available-for-variation in the Parent Variation.

[Christian Cox]

Okay here is an example that checks the parent Ticket's custom field value and compares that to the number of Variations being added, and returns an error accordingly:

add_filter('cred_form_validate','my_variation_validation',10,2);
function my_variation_validation($error_fields, $form_data)
{
    //field data are field values and errors
    list($fields,$errors)=$error_fields;
    //validate if specific form
    if ($form_data['id']==12345)
    {
        $ticketID = $fields['_wpcf_belongs_ticket_id']['value'];
        $ticketsAvailable = intval(get_post_meta($ticketID, 'wpcf-total-tickets-available', true));
        if (intval($fields['wpcf-total-available-for-variation']['value']) > $ticketsAvailable)
        {
            //set error message for the total available field
            $errors['wpcf-total-available-for-variation']='A maximum of ' . $ticketsAvailable . ' variation(s) can be added.';
        }
    }
    //return result
    return array($fields,$errors);
}

Modify 12345 to match your new Variation CRED form ID, and adjust the slugs and text as needed.

[jonB-5]

This has worked - I do have a follow up question though...

Do I need to repeat the code for each individual form (New Post and Edit Post) or is there a more efficient way?
I ask because of the comment line in the snippet below

    //validate if specific form
    if ($form_data['id']==12345)

[Christian Cox]

If you need to apply the code to more than one form, you can use this modified version:

add_filter('cred_form_validate','my_variation_validation',10,2);
function my_variation_validation($error_fields, $form_data)
{
    //field data are field values and errors
    list($fields,$errors)=$error_fields;
    $forms = array( 12345, 23456, 34567 );
    //validate if specific form
    if ( in_array( $form_data['id'], $forms ))
    {
        $ticketID = $fields['_wpcf_belongs_ticket_id']['value'];
        $ticketsAvailable = intval(get_post_meta($ticketID, 'wpcf-total-tickets-available', true));
        if (intval($fields['wpcf-total-available-for-variation']['value']) > $ticketsAvailable)
        {
            //set error message for the total available field
            $errors['wpcf-total-available-for-variation']='A maximum of ' . $ticketsAvailable . ' variation(s) can be added.';
        }
    }
    //return result
    return array($fields,$errors);
}

You can add or remove form IDs in a comma-separated list in the $forms variable.

[jonB-5]

Looks like it's all working as hoped - Thanks!