Skip to content

Instantly share code, notes, and snippets.

@craigedmonds
Created October 19, 2018 09:11
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save craigedmonds/d29abe67505c331d001be0a9f0acc752 to your computer and use it in GitHub Desktop.
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.
<?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 craig@jucra.com
######################################################
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 craig@jucra.com
//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;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment