Reply To: BiDirectional Repeaters

• cjjr82

• June 19, 2019 at 2:40 am

Hey again,

Hoping this will eventually help someone else, so I am making an update as I have continued working on this.
While working on this, I have failed to find a way to run this using the update_value hook, and therefore currently can only be done when the post is saved. Also just to point out, the posted code is only one side of the script, to do it bidirectional, duplicate from determining the post type and reverse all the field name. I also realized it wouldn’t delete rows if they were removed. So…..

First we have our action for the save post function with a value great then 10 so it runs after the values have saved
add_action('acf/save_post', 'save_post_functions', 20);

Then our function

function save_post_functions( $post_id )

//get the post type and do an if to determine if its a person or department
if ( get_post_type( ) == ‘people’) {
  //get the persons departments and run through them
  $people_departments = get_field(‘people_departments’);
  if ($people_departments) {
    foreach($people_departments as $pdepartments) {
      //make sure the select in the row has a value, if not we do nothing
      if ($pdepartments['select']!='') {
        //get the departments people
        $department_people = get_field('department_people',$pdepartment['select']);
        //see if the person exists in the department already
        $key = array_search($post_id, array_column($department_people, 'select'));
        //build the row to update/add
        $new_row = array( 'select' => $post_id, 'title' => $pdepartments['title'], 'id' => $pdepartments['id']);
        //if $key equals false we add the row, otherwise update it (with key+1 since ACF rows start at 1
        if ($key === false) {
          add_row('department_people',$new_row,$pdepartment['select']);
        } else {
          update_row('department_people',$key+1,$new_row,$pdepartment['select']);
        }
      }
      //that parts done
      //now we check to see what needs to be deleted. 
      //first we get all departments with this persons post_ID using the custom post_ids_from_meta function (below)
      $departments_with_person = post_ids_from_meta('department_people_%_select', $post_id);
      //go through each department and see if it still exists for this person
      foreach($departments_with_person as $dwp) {
        list($dwp_id,$row) = explode("|",$dwp);
        $key2 = array_search($dwp_id, array_column($people_departments, 'select'));
        //if the department does not exists on the person, delete the person from the department
        if($key2 === false) {
          delete_row('department_people',$row+1,$dwp_id);
        }
      }
    }
  }
}

//custom function to get all the departments for this person (or all the people for the department)
`function post_ids_from_meta($key, $value) {
global $wpdb;
if(!is_array($post_ids)) { $post_ids = array(); }
$metas = $wpdb->get_results(“SELECT post_id,meta_key FROM wp_postmeta WHERE meta_value = ‘”.$value.”‘ AND meta_key LIKE ‘”.$key.”%'”);
if($metas) {
foreach($metas as $meta) {
$row_number = explode(‘_’,$meta->meta_key);
array_push($post_ids,$meta->post_id.”|”.$row_number[2]);
}
}
return($post_ids);
}