Get a list of special offers for a dealer based on whether the dealer has special offers turned off, whether they are in a certain region or whether they have their own special offers.

functions.php

<?php
######################################################
//get a list of specials assigned to a dealer so that we can display a list
//of post id's in the array_of_dealer
//added on 19/10/2018 by [email protected]
######################################################
function white_label_get_array_of_special_offer_posts_for_dealer($dealer_id) {
	
	###################################################
	//STEP 1
	//Check if this dealer has disabled special offers on their site.
	//Some dealer want NO special offers to be shown soif the dealer has disabled special offers then no point
	//wasting resources to get any special offers.
	###################################################
	$special_offer_status = get_post_meta( $dealer_id, "dealer_disable_special_offers_page", $single = true );
	if(is_array($special_offer_status)) {
		$dealer_special_offer_status = $special_offer_status[0];
		if($dealer_special_offer_status == "yes") {
			$array_of_special_offers_posts_ids = "";
			return $array_of_special_offers_posts_ids;
		}
	}
	
	###################################################
	//STEP 2
	//Get the region id the dealer is in.
	//This is needed to determine if we should include egional special offers on a dealer special offer page
	###################################################
	//note added on 19/10/2018 by [email protected]
	//we have to use a sql query becasue you cannot use wp_get_post_terms in functions.php
	//wp_get_post_terms only works on the theme pages, something about init, fucking complicated shite.
	$sql = "
	SELECT t.*, tt.* FROM wp_core_terms AS t 
	INNER JOIN wp_core_term_taxonomy AS tt ON (tt.term_id = t.term_id) 
	INNER JOIN wp_core_term_relationships AS tr ON (tr.term_taxonomy_id = tt.term_taxonomy_id) 
	WHERE tt.taxonomy IN ('dealers_regions') AND tr.object_id IN ($dealer_id) 
	ORDER BY t.name ASC;
	";
	global $wpdb;
	$wpdb->show_errors( true );
	$results = $wpdb->get_results($sql);
	$dealers_region_id = $results[0]->term_id;

	//************************************************//
	//TROUBLESHOOTING
	//************************************************//
	$display_troublehooting = false;
	if($display_troublehooting == true && WHITE_LABEL_DEBUGGING_STATUS == "on") {
		
		echo "DEALER REGION ID: " . $dealers_region_id;
		echo "<pre>";
		echo "This is Line number: " . __LINE__ . " in " . basename(__FILE__)  . PHP_EOL;
		print_r($array_of_dealers_region);
		echo "</pre>";
		
	}
	//************************************************//
	

	###################################################
	//STEP 3
	//get an array of ALL the special offers
	###################################################
	$args = array(
		 'posts_per_page' => -1,
		 'post_type' => 'special-offers',
		 'post_status' => 'publish'
	);
	$posts_array = get_posts( $args );

	###################################################
	//Create an array of post id's for the special offers.
	//Also we have to include certain other variables for the special offer
	//such as if the special offer is a regional one or the list of dealer sites it should appear on.
	###################################################
	$count = 0;
	foreach($posts_array as $post) {

		$post_id = $posts_array[$count]->ID;
		$display_type = get_post_meta( $post_id, "dealers_special_offers_display_type", $single = true );	
		$regions = get_post_meta( $post_id, "dealers_special_offers_regions", $single = true );
		$dealer_sites = get_post_meta( $post_id, "dealers_special_offers_dealer_sites", $single = true );
		
		$array_of_specials[] = array(
		'post_name' => get_the_title($post_id), 
		'post_id' => $post_id,
		'display_type' => $display_type,
		'regions' => $regions,
		'dealer_sites' => $dealer_sites,
		);

		$count = $count + 1; 
	}
	
	//************************************************//
	//TROUBLESHOOTING
	//************************************************//
	$display_troublehooting = false;
	if($display_troublehooting == true && WHITE_LABEL_DEBUGGING_STATUS == "on") {
		
		echo "<pre>";
		echo "This is Line number: " . __LINE__ . " in " . basename(__FILE__)  . PHP_EOL;
		print_r($array_of_specials);
		echo "</pre>";
		
	}
	//************************************************//
	

	###################################################
	//STEP 4
	//Determine if a special offer should be on a single site or region of sites
	//EG: Dealer A might be located in Canada and have 2 special offers.
	//There might be 10 regional offers for the Canadian region. 
	//So we will need to show 12 special offers on the dealers feed.
	###################################################
	$new_array_of_specials = array();
	$count = 0;
	foreach($array_of_specials as $x){

		$post_id = $array_of_specials[$count]["post_id"];
		$display_type = $array_of_specials[$count]["display_type"];
		$regions = $array_of_specials[$count]["regions"];
		$dealer_sites = $array_of_specials[$count]["dealer_sites"];

		//determine the display type first
		if($display_type == "sites") {

			if(in_array($dealer_id, $dealer_sites)){

				$new_array_of_specials[] = array(
				'post_id' => $post_id, 
				'post_name' => get_the_title($post_id), 
				'permalink' => get_permalink($post_id),
				);	

			}

		}

		if($display_type == "regions") {

			if(in_array($dealers_region_id, $regions)){

					$new_array_of_specials[] = array(
					'post_id' => $post_id, 
					'post_name' => get_the_title($post_id), 
					'permalink' => get_permalink($post_id),
					);	

			}

		}

		$count = $count + 1; 

	}
	
	//************************************************//
	//TROUBLESHOOTING
	//************************************************//
	$display_troublehooting = false;
	if($display_troublehooting == true && WHITE_LABEL_DEBUGGING_STATUS == "on") {
		
		echo "<pre>";
		echo "This is Line number: " . __LINE__ . " in " . basename(__FILE__)  . PHP_EOL;
		print_r($new_array_of_specials);
		echo "</pre>";
		
	}
	//************************************************//

	###################################################
	//STEP 5
	//produce a list of special offers for the dealer
	###################################################
	if(count($new_array_of_specials) > 0) {

		$count = 0;
		foreach($new_array_of_specials as $post_id){

			$post_id = $new_array_of_specials[$count]["post_id"];
			$final_array_of_special_offers[] = $post_id;
			$count = $count + 1;

		}

	} 
	
	//************************************************//
	//TROUBLESHOOTING
	//************************************************//
	$display_troublehooting = false;
	if($display_troublehooting == true && WHITE_LABEL_DEBUGGING_STATUS == "on") {
		
		echo "<pre>";
		echo "This is Line number: " . __LINE__ . " in " . basename(__FILE__)  . PHP_EOL;
		print_r($new_array_of_specials);
		echo "</pre>";
		
	}
	//************************************************//

	return $final_array_of_special_offers;

}