template-healthcheck-export.php

<?php
/**
 * Template Name: Export - Healthcheck
 */

$args = array(
  'post_type' => 'healthchecks',
  'posts_per_page' => -1,
  'orderby' => 'ID',
  'order' => 'DESC',
  'meta_query' => array(
    array(
      'key' => 'incomplete',
      'compare' => 'NOT EXISTS'
    )
  )
);

$posts = get_posts($args);

$answers = array();
$healthcheck_ids = array();

$i = 0;
foreach($posts as $post) {
  // get associate initiave post object
  $initiative = get_post($post->post_title);
  
  // only display the first ID and helathchecks for published initiatives;
  if(!in_array($post->post_title, $healthcheck_ids) && $initiative->post_status == 'publish') {
    $healthcheck_ids[] = $post->post_title;
    $question_groups = get_fields($post->ID);
    
    $initiative_title = get_post($post->post_title);
    
    if($question_groups) {
      $questions[0] = 'Initiative';
      $answers[$i][0] = $initiative_title->post_title;
      $answers[$i][1] = $post->ID;
      
      foreach($question_groups as $key => $group) {
        // var_dump($group);
        foreach ($group as $label => $response) {
          // add question the first time
          if($i == 0) {
            $full_question = get_field_object($key . '_' . $label, 4642)['label'];
            $questions[] = str_replace('group_', '', $key) . ('.') . str_replace('q', '', $label) . ': ' . $full_question;
          }
          $answers[$i][] = $response;
        }
      }
    }
  }
  $i++;
}

$export_data[] = $questions;
foreach($answers as $answer_set) {
  $export_data[] = $answer_set;
}

//secure the export
if(is_user_role('administrator') || is_user_role('super_hub')) {
  outputCsv(date('Ymd') . '_healthcheck_responses.csv', $export_data);
} else {
  wp_redirect(esc_url(add_query_arg('error_code', '1', '/error')));
} ?>