Skip to content

Instantly share code, notes, and snippets.

@sidharrell
Last active December 28, 2015 19:29
Show Gist options
  • Select an option

  • Save sidharrell/7549987 to your computer and use it in GitHub Desktop.

Select an option

Save sidharrell/7549987 to your computer and use it in GitHub Desktop.
get a single price sans surcharge
function espresso_return_single_price_sans_surcharge($event_id, $number=0) {
do_action('action_hook_espresso_log', __FILE__, __FUNCTION__, '');
global $wpdb, $org_options;
$number = $number == 0 ? '0,1' : $number . ',' . $number;
$results = $wpdb->get_results("SELECT event_cost FROM " . EVENTS_PRICES_TABLE . " WHERE event_id='" . $event_id . "' ORDER BY id ASC LIMIT " . $number);
if ($wpdb->num_rows > 0) {
foreach ($results as $result) {
$event_cost = $result->event_cost;
}
} else {
$event_cost = '0.00';
}
$event_cost = number_format( $event_cost, 2, '.', '');
return $event_cost;
}
function get_espresso_price_sans_surcharge_sc($atts) {
extract(shortcode_atts(array('event_id' => '0', 'number' => '0'), $atts));
$event_id = "{$event_id}";
$number = "{$number}";
ob_start();
echo espresso_return_single_price_sans_surcharge($event_id, $number);
$buffer = ob_get_contents();
ob_end_clean();
return $buffer;
}
add_shortcode('EVENT_PRICE_SANS_SURCHARGE', 'get_espresso_price_sans_surcharge_sc');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment