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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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