CDS/page-hub-data-export.php at master · transitionnetwork/CDS · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
<?php

$args = array(
  'post_type' => 'initiatives',
  'posts_per_page' => -1,
  'post_status' => 'publish',
  'tax_query' => array(
    array(
      'taxonomy' => 'hub',
      'terms' => get_query_var('hub_id')
    ),
  )
);

$init_query = new WP_Query($args); ?>

<?php session_start();

$export_data = array();

$export_data[] = ["Name", "Status", "Hub", "Country", "Last Healthcheck Date", "tags", "Hub Email", "Address", "City", "Province", "Post Code", "Website URL", "Twitter", "Facebook", "Instagram", "Youtube", "Number of people organising and running", "Number of participants", "More information on these numbers", "Foundation date", "Paid roles?", "Legal structure", "Legal structure detail", "How active?", "Live projects", "Live project details.."];

while ($init_query->have_posts()) : $init_query->the_post();

  $country_term = get_the_terms($post->ID, 'country')[0];
  $hub_term = get_the_terms($post->ID, 'hub')[0];

  $name = get_the_title();
  $status = get_post_status();
  $hub = $hub_term->name;
  $country = $country_term->name;

  $healthcheck_args = array(
    'post_type' => 'healthchecks',
    'title' => $post->ID,
    'posts_per_page' => 1,
    'orderby' => 'post_date',
    'order' => 'DESC'
  );

  $latest_healthcheck = '';

  $latest_healthcheck_post = get_posts($healthcheck_args);

  if($latest_healthcheck_post) {
    $latest_healthcheck = $latest_healthcheck_post[0]->post_date;
  }

  $tags = get_group_tags($post);
  $tag_output = array();

  if(is_array($tags)) {
    foreach($tags as $tag) {
      $tag_output[] = $tag['label'];
    }
    $tag_output = implode(', ', $tag_output);
  }

  $email = get_field('email', $post->ID);

  $address = get_field('address_line_1', $post->ID);
  $city = get_field('city', $post->ID);
  $province = get_field('province', $post->ID);
  $postal_code = get_field('postal_code', $post->ID);

  $website = get_field('website', $post->ID);
  $twitter = get_field('twitter', $post->ID);
  $facebook = get_field('facebook', $post->ID);
  $instagram = get_field('instagram', $post->ID);
  $youtube = get_field('youtube', $post->ID);

  $no_people = get_field('group_detail_number_of_people');
  $no_participants = get_field('group_detail_number_of_participants');
  $no_people_more_info = get_field('group_detail_number_more_info');
  $date_founded = get_field('group_detail_date');
  $paid_roles = get_field('group_detail_paid_roles');
  $legal_structure = get_field('group_detail_legal_structure');
  $legal_structure_detail = get_field('group_detail_legal_structure_detail');
  $active = get_field('group_detail_active');

  $live_projects = get_field('group_detail_live_projects');
  if($live_projects) {
    $project_output = [];
    foreach ($live_projects as $project) {
      $project_output[] = $project['label'];
    }
    $live_projects = implode(' | ', $project_output);
  }

  $live_projects_detail = get_field('group_detail_live_projects_detail');

  $export_data[] = [$name, $status, $hub, $country, $latest_healthcheck, $tag_output, $email, $address, $city, $province, $postal_code, $website, $twitter, $facebook, $instagram, $youtube, $no_people, $no_participants, $no_people_more_info, $date_founded, $paid_roles, $legal_structure, $legal_structure_detail, $active, $live_projects, $live_projects_detail];


endwhile; ?>
<?php outputCsv(date('Ymd') . '_' . $hub_term->slug . '_Initiative_Export.csv', $export_data); ?>