' . __('Coupons', 'yak-admin') . '';
}
}
if (!function_exists('yak_coupons_options')) {
function yak_coupons_options() {
?>
total_coupons == 0) {
$_REQUEST['error_message'] = __('No coupons were inserted (either duplicates in the file, or pre-existing codes)', 'yak-admin');
}
else if ($count != $coupon_set->total_coupons) {
$_REQUEST['error_message'] = __('Not all coupons were inserted (either duplicates in the file, or pre-existing codes)', 'yak-admin');
}
}
}
}
}
if (!function_exists('yak_add_coupon')) {
function yak_add_coupon($coupon_set, $code) {
global $wpdb, $coupon_table;
$sql = $wpdb->prepare("insert into $coupon_table (coupon_code, coupon_set) values (%s, %s)", $code, $coupon_set);
$wpdb->query($sql);
return $wpdb->insert_id;
}
}
if (!function_exists('yak_get_coupon_sets')) {
function yak_get_coupon_sets($name = null, $code = null) {
global $wpdb, $coupon_table;
$sql = "select c1.coupon_set, count(c1.coupon_id) as total_coupons,
(select count(coupon_id)
from $coupon_table c2
where c2.coupon_set = c1.coupon_set
and c2.used_datetime is not null) as used_coupons
from $coupon_table c1";
$args = array();
if ($name != null) {
$sql .= " where c1.coupon_set = %s";
$args[] = $name;
}
else if ($code != null) {
$sql .= " where c1.coupon_code = %s";
$args[] = $code;
}
$sql .= " group by c1.coupon_set";
$sql = $wpdb->prepare($sql, $args);
$rows = $wpdb->get_results($sql);
if (count($rows) > 0 && ($name != null || $code != null)) {
return $rows[0];
}
else {
return $rows;
}
}
}
if (!function_exists('yak_delete_coupon_set')) {
function yak_delete_coupon_set($coupon_set) {
global $wpdb, $coupon_table;
$sql = $wpdb->prepare("delete from $coupon_table where coupon_set = %s", $coupon_set);
$wpdb->query($sql);
}
}
if (!function_exists('yak_get_coupon_by_code')) {
function yak_get_coupon_by_code($code) {
global $wpdb, $coupon_table;
$sql = $wpdb->prepare("select *
from $coupon_table
where coupon_code = %s", $code);
return $wpdb->get_row($sql);
}
}
if (!function_exists('yak_use_coupon')) {
function yak_use_coupon($coupon_set, $code) {
global $wpdb, $coupon_table;
$sql = $wpdb->prepare("update $coupon_table set used_datetime = current_timestamp()
where coupon_set = %s and coupon_code = %s", $coupon_set, $code);
$wpdb->query($sql);
}
}
add_action('yak-misc-options-link', 'yak_coupons_options_link');
add_action('yak-misc-options', 'yak_coupons_options');
add_action('yak-update-options-coupons', 'yak_coupons_update_options');
?>