Multisite Main Site Options Page Filter Child Site

• mikestemple

• January 1, 2020 at 4:48 am

I have a multisite and am trying to accomplish the following.

On the main site I have a options page with 3 fields:

promotion_1 Wysiwyg Editor (the html of the promotion)
promotion_1_storelist Multiple Select (a list of all sites in the multisite)
promotion_1_expiration Date Picker (standard date picker)

I want to be able to add the promotion (promotion_1) to the selected sites chosen in the Multiple Select List (promotion_1_storelist) and have the promotion expire on the promotion_1_expiration date. If the site is not selected in the Multiple Select List (promotion_1_storelist) the promotion is not shown.
On every child site I add the shortcode “center_promotions1” to display the promotion (using shortcode as not every site gets the promotion so abstracted it out of the template).

I have the expiration working fine and can pull from the main site and display on a child site. I have 2 issues:
1) How do I filter the Multiple Select List (promotion_1_storelist) and show the promotion only if the child site is selected?
2) Is there a way to pull in a list of the sites in the multisite and list them in the Multiple Select List (promotion_1_storelist field_5e0a476fc3745)?

Below is my code so far. It shows the promotion on every site no matter what sites are selected:

// Promotions display on a Location page
function get_promotions1(){
	 ob_start();
$main_blog = 1;
$today1 = date('Ymd');
$currentsite1 = get_current_blog_id();

switch_to_blog( $main_blog );
$centerpromotions1 = get_field('promotion_1', 'option');
$storelist1 = get_field('promotion_1_storelist', 'option');
$expiredate1 = get_field('promotion_1_expiration', 'option'); 

$args = array(
	'meta_query' => array(
	 array(
		'key' => $storelist1, // name of custom field
		'value' => '"' . $currentsite1 . '"', // matches exactly "123", not just 123. This prevents a match for "1234"
		'compare' => 'LIKE'
    ),   
  ),
);
$sites = get_site($args);

restore_current_blog();

if($expiredate1 > $today1 && $sites && !is_wp_error($sites)):
	
echo '<h4>Promotions:</h4><div class="center-promotions-list">' .  $centerpromotions1  . '</div><p></p>';

endif; 

return ob_get_clean();
}

add_shortcode('center_promotions1', 'get_promotions1');

Thank you

• John Huebner

• January 4, 2020 at 4:20 am

// load values into store list
// assumes it is only loaded on blog_id == 1
// assumes that the field is a select field that allows multiple choices
add_filter('acf/prepare_field/key=field_5e0a476fc3745', 'load_site_list');
function load_site_list($field) {
  $sites = get_sites();
  $choices = array();
  if ($sites) {
    foreach ($sites as $site) {
      // not the main site
      if ($site->blog_id == 1) {
        continue;
      }
      switch_to_blog($site->blog_id);
      $choices[$site->blog_id] = get_bloginfo('name');
      restore_current_blog();
    } // end foreach site
  } // end if sites
  $field['choices'] = $choices;
  return $field;
} // end function

// see if current blog is selected
switch_to_blog( $main_blog );
$storelist1 = get_field('promotion_1_storelist', 'option');
restore_current_blog();
if (in_array(get_current_blog_id(), $storelist1)) {
  // current site is selected
}

• mikestemple

• January 4, 2020 at 6:38 am

Thank you. I added the code and it works except I can not do a multi-select. For example if a site is like this:
Main Site (does not display in list)
Site 1
Site 2
Site 3

Your code displays the list of sites (which is awesome) but I can only choose 1 site. Is there a way to make the list a multi-select so I can show a promotion on “Site 1” AND “Site 3” but NOT on “Site 2”?

Also how can I add “Allow Null” as an option.

Again thank you for the above code. Your support here is awesome.

• John Huebner

• January 4, 2020 at 6:59 am

These are choices when creating the select field.

• mikestemple

• January 4, 2020 at 7:29 am

I am not following you. This is my select setting:

The actual form does not allow me to multi-select multiple sites to show the promotion on.

• mikestemple

• January 4, 2020 at 7:42 am

I was being dumb and not holding the cmd key when selecting multiple sites 🙂
Beyond rookie mistake. Thanks for the help and it works great!!

• mikestemple

• January 7, 2020 at 7:27 am

I moved the code to production with 161 sites. Only the first 99 sites are listed. Any idea on how to get the other 62 sites to list?

Thank you

• John Huebner

• January 8, 2020 at 1:08 am

You need to set the number argument for get sites, unfortunately, it does not seem to be a way to set it to all by using -1 like in WP_Query(), instead it seems that you need to set it to a number that is higher than the number of the sites you have.

The reason it’s returning 99 is that the max is 100 and we’re eliminating site 1 (the main site)

$sites = get_sites(array('number' => 500));

• mikestemple

• January 8, 2020 at 7:16 am

Thank you very much…this works awesomely.