Advertisement
Guest User

modified EE3 price list function

a guest
Apr 13th, 2015
254
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.78 KB | None | 0 0
  1. function event_espresso_price_list($event_id) {
  2. $html = '';
  3. global $wpdb, $org_options;
  4. $sql = "SELECT id, event_cost, surcharge, surcharge_type, price_type";
  5. $order_by = 'event_cost';
  6. $member_event = FALSE;
  7. $surcharge_text = isset($org_options['surcharge_text']) ? $org_options['surcharge_text'] : __('Surcharge', 'event_espresso');
  8. if ( function_exists('espresso_members_installed') && espresso_members_installed() == true && is_user_logged_in() ) {
  9. $sql .= ", member_price, member_price_type ";
  10. $member_event = TRUE;
  11. $order_by = 'member_price';
  12. }
  13. $sql .= " FROM " . EVENTS_PRICES_TABLE . " WHERE event_id='%d'";
  14. $results = $wpdb->get_results( $wpdb->prepare($sql, $event_id) );
  15. if ($wpdb->num_rows > 1) {
  16. //Create a dropdown of prices
  17. $html .= '<span class="'.espresso_template_css_class('section_title','section-title',false).'">'. __(' Prices:', 'event_espresso').'</span>';
  18. $html .= '<ul id="price-list-' . $event_id . '" class="'.espresso_template_css_class('espresso_price_list','espresso-price-list',false).'">';
  19.  
  20. foreach ($results as $result) {
  21. if ($member_event == TRUE) {
  22. $result->event_cost = $result->member_price;
  23. $result->price_type = $result->member_price_type;
  24. }
  25. // Addition for Early Registration discount
  26. if ($early_price_data = early_discount_amount($event_id, $result->event_cost)) {
  27. $result->event_cost = $early_price_data['event_price'];
  28. $message = __(' Early Pricing', 'event_espresso');
  29. } else {
  30. $message = '';
  31. }
  32.  
  33. $surcharge = '';
  34.  
  35. if ($result->surcharge > 0 && $result->event_cost > 0.00) {
  36. $surcharge = " + {$org_options['currency_symbol']}{$result->surcharge} " . $surcharge_text;
  37. if ($result->surcharge_type == 'pct') {
  38. $surcharge = " + {$result->surcharge}% " . $surcharge_text;
  39. }
  40. }
  41. $html .= '<li>' . stripslashes_deep($result->price_type) . ' (' . $org_options['currency_symbol'] . number_format($result->event_cost, 2) . $message . ') ' . $surcharge . ' </li>';
  42. }
  43. $html .= '</ul>';
  44. }else{
  45. if ($member_event == TRUE) {
  46. $event_cost = $wpdb->last_result[0]->member_price;
  47. $price_type = $wpdb->last_result[0]->member_price_type;
  48. }else{
  49. $event_cost = $wpdb->last_result[0]->event_cost;
  50. $price_type = $wpdb->last_result[0]->price_type;
  51. }
  52. $html .= '<p><span class="'.espresso_template_css_class('section_title','section-title',false).'">'. __(' Price:', 'event_espresso').'</span> ' . $price_type . ' ' . $org_options['currency_symbol'] . number_format($event_cost, 2) . '</p>';
  53. }
  54. echo $html;
  55. return;
  56. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement