Execute($audience_select['query_string']);
$mail_sent_to = $audience_select['query_name'];
if ($_POST['email_to']) {
$mail_sent_to = $_POST['email_to'];
}
$coupon_result = $db->Execute("select coupon_code, coupon_start_date, coupon_expire_date
from " . TABLE_COUPONS . "
where coupon_id = '" . $_GET['cid'] . "'");
$coupon_name = $db->Execute("select coupon_name, coupon_description
from " . TABLE_COUPONS_DESCRIPTION . "
where coupon_id = '" . $_GET['cid'] . "'
and language_id = '" . (int)$_SESSION['languages_id'] . "'");
// demo active test
if (zen_admin_demo()) {
$_GET['action']= '';
$messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
zen_redirect(zen_href_link(FILENAME_COUPON_ADMIN, 'mail_sent_to=' . urlencode($mail_sent_to)));
}
$from = zen_db_prepare_input($_POST['from']);
$subject = zen_db_prepare_input($_POST['subject']);
$recip_count=0;
$text_coupon_help = sprintf(TEXT_COUPON_HELP_DATE, zen_date_short($coupon_result->fields['coupon_start_date']), zen_date_short($coupon_result->fields['coupon_expire_date']));
$html_coupon_help = sprintf(HTML_COUPON_HELP_DATE, zen_date_short($coupon_result->fields['coupon_start_date']), zen_date_short($coupon_result->fields['coupon_expire_date']));
while (!$mail->EOF) {
$message = zen_db_prepare_input($_POST['message']);
$message .= "\n\n" . TEXT_TO_REDEEM . "\n\n";
$message .= TEXT_VOUCHER_IS . $coupon_result->fields['coupon_code'] . "\n\n";
$message .= $text_coupon_help . "\n\n";
$message .= TEXT_REMEMBER . "\n\n";
$message .=(!empty($coupon_name->fields['coupon_description']) ? $coupon_name->fields['coupon_description'] . "\n\n" : '');
$message .= sprintf(TEXT_VISIT ,HTTP_CATALOG_SERVER . DIR_WS_CATALOG);
// disclaimer
$message .= "\n-----\n" . sprintf(EMAIL_DISCLAIMER, STORE_OWNER_EMAIL_ADDRESS) . "\n\n";
$html_msg['EMAIL_FIRST_NAME'] = $mail->fields['customers_firstname'];
$html_msg['EMAIL_LAST_NAME'] = $mail->fields['customers_lastname'];
$html_msg['EMAIL_MESSAGE_HTML'] = zen_db_prepare_input($_POST['message_html']);
$html_msg['COUPON_TEXT_TO_REDEEM'] = TEXT_TO_REDEEM;
$html_msg['COUPON_TEXT_VOUCHER_IS'] = TEXT_VOUCHER_IS;
$html_msg['COUPON_CODE'] = $coupon_result->fields['coupon_code'] . $html_coupon_help;
$html_msg['COUPON_DESCRIPTION'] =(!empty($coupon_name->fields['coupon_description']) ? $coupon_name->fields['coupon_description'] : '');
$html_msg['COUPON_TEXT_REMEMBER'] = TEXT_REMEMBER;
$html_msg['COUPON_REDEEM_STORENAME_URL'] = sprintf(TEXT_VISIT ,''.STORE_NAME.'');
//Send the emails
zen_mail($mail->fields['customers_firstname'] . ' ' . $mail->fields['customers_lastname'], $mail->fields['customers_email_address'], $subject , $message, '',$from, $html_msg, 'coupon');
zen_record_admin_activity('Coupon code ' . $coupon_result->fields['coupon-code'] . ' emailed to customer ' . $mail->fields['customers_email_address'], 'info');
$recip_count++;
// send copy to Admin if enabled
if (SEND_EXTRA_DISCOUNT_COUPON_ADMIN_EMAILS_TO_STATUS== '1' and SEND_EXTRA_DISCOUNT_COUPON_ADMIN_EMAILS_TO != '') {
zen_mail('', SEND_EXTRA_DISCOUNT_COUPON_ADMIN_EMAILS_TO, SEND_EXTRA_DISCOUNT_COUPON_ADMIN_EMAILS_TO_SUBJECT . ' ' . $subject , $message, '',$from, $html_msg, 'coupon_extra');
}
$mail->MoveNext();
}
zen_redirect(zen_href_link(FILENAME_COUPON_ADMIN, 'mail_sent_to=' . urlencode($mail_sent_to) . '&recip_count='. $recip_count ));
}
if ( ($_GET['action'] == 'preview_email') && (!$_POST['customers_email_address']) ) {
$_GET['action'] = 'email';
$messageStack->add(ERROR_NO_CUSTOMER_SELECTED, 'error');
}
if ($_GET['mail_sent_to']) {
$messageStack->add(sprintf(NOTICE_EMAIL_SENT_TO, $_GET['mail_sent_to']. '(' . $_GET['recip_count'] . ')'), 'success');
$_GET['mail_sent_to'] = '';
}
switch ($_GET['action']) {
case 'set_editor':
// Reset will be done by init_html_editor.php. Now we simply redirect to refresh page properly.
$action='';
zen_redirect(zen_href_link(FILENAME_COUPON_ADMIN));
break;
case 'confirmdelete':
// demo active test
if (zen_admin_demo()) {
$_GET['action']= '';
$messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
zen_redirect(zen_href_link(FILENAME_COUPON_ADMIN));
}
// do not allow change if set to welcome coupon
if ($_GET['cid'] == NEW_SIGNUP_DISCOUNT_COUPON) {
$messageStack->add_session(ERROR_DISCOUNT_COUPON_WELCOME, 'caution');
zen_redirect(zen_href_link(FILENAME_COUPON_ADMIN, 'cid=' . $_GET['cid'] . (isset($_GET['status']) ? '&status=' . $_GET['status'] : '') . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));
}
$db->Execute("update " . TABLE_COUPONS . "
set coupon_active = 'N'
where coupon_id='".$_GET['cid']."'");
$messageStack->add_session(SUCCESS_COUPON_DISABLED, 'success');
zen_redirect(zen_href_link(FILENAME_COUPON_ADMIN));
break;
case 'confirmcopy':
$coupon_copy_to = trim($_POST['coupon_copy_to']);
// check if new coupon code exists
$sql = "SELECT * from " . TABLE_COUPONS . " where coupon_code = :coupon_copy:";
$sql = $db->bindVars($sql, ':coupon_copy:', $coupon_copy_to, 'string');
$check_new_coupon = $db->Execute($sql);
if ($check_new_coupon->RecordCount() > 0) {
$messageStack->add_session(ERROR_DISCOUNT_COUPON_DUPLICATE . $coupon_copy_to, 'caution');
zen_redirect(zen_href_link(FILENAME_COUPON_ADMIN, 'cid=' . $_GET['cid'] . (isset($_GET['status']) ? '&status=' . $_GET['status'] : '') . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));
}
$sql = "SELECT * from " . TABLE_COUPONS . " where coupon_id='" . $_GET['cid'] . "'";
$check_new_coupon = $db->Execute($sql);
// create duplicate coupon
$sql_data_array = array('coupon_code' => zen_db_prepare_input($coupon_copy_to),
'coupon_amount' => zen_db_prepare_input($check_new_coupon->fields['coupon_amount']),
'coupon_type' => zen_db_prepare_input($check_new_coupon->fields['coupon_type']),
'uses_per_coupon' => zen_db_prepare_input((int)$check_new_coupon->fields['uses_per_coupon']),
'uses_per_user' => zen_db_prepare_input((int)$check_new_coupon->fields['uses_per_user']),
'coupon_minimum_order' => zen_db_prepare_input((float)$check_new_coupon->fields['coupon_minimum_order']),
'restrict_to_products' => zen_db_prepare_input($check_new_coupon->fields['restrict_to_products']),
'restrict_to_categories' => zen_db_prepare_input($check_new_coupon->fields['restrict_to_categories']),
'coupon_start_date' => $check_new_coupon->fields['coupon_start_date'],
'coupon_expire_date' => $check_new_coupon->fields['coupon_expire_date'],
'date_created' => 'now()',
'date_modified' => 'now()',
'coupon_zone_restriction' => $check_new_coupon->fields['coupon_zone_restriction']);
zen_db_perform(TABLE_COUPONS, $sql_data_array);
$insert_id = $db->Insert_ID();
$cid = $insert_id;
// $_GET['cid'] = $cid;
// create duplicate coupon description
$sql = "SELECT * from " . TABLE_COUPONS_DESCRIPTION . " where coupon_id='" . $_GET['cid'] . "'";
$new_coupon_descriptions = $db->Execute($sql);
while (!$new_coupon_descriptions->EOF) {
$sql_mdata_array = array('coupon_id' => zen_db_prepare_input($cid),
'language_id' => zen_db_prepare_input($new_coupon_descriptions->fields['language_id']),
'coupon_name' => zen_db_prepare_input('COPY: ' . $new_coupon_descriptions->fields['coupon_name']),
'coupon_description' => zen_db_prepare_input($new_coupon_descriptions->fields['coupon_description'])
);
zen_db_perform(TABLE_COUPONS_DESCRIPTION, $sql_mdata_array);
$new_coupon_descriptions->MoveNext();
}
// copy restrictions
$sql = "SELECT * from " . TABLE_COUPON_RESTRICT . " where coupon_id='" . $_GET['cid'] . "'";
$copy_coupon_restrictions = $db->Execute($sql);
while (!$copy_coupon_restrictions->EOF) {
$sql_rdata_array = array('coupon_id' => zen_db_prepare_input($cid),
'product_id' => zen_db_prepare_input($copy_coupon_restrictions->fields['product_id']),
'category_id' => zen_db_prepare_input($copy_coupon_restrictions->fields['category_id']),
'coupon_restrict' => zen_db_prepare_input($copy_coupon_restrictions->fields['coupon_restrict'])
);
zen_db_perform(TABLE_COUPON_RESTRICT, $sql_rdata_array);
$copy_coupon_restrictions->MoveNext();
}
$_GET['cid'] = $cid;
$messageStack->add_session(SUCCESS_COUPON_DUPLICATE . $coupon_copy_to, 'success');
zen_redirect(zen_href_link(FILENAME_COUPON_ADMIN, 'action=voucheredit' . '&cid=' . $_GET['cid'] . (isset($_GET['status']) ? '&status=' . $_GET['status'] : '')));
// zen_redirect(zen_href_link(FILENAME_COUPON_ADMIN));
break;
case 'update':
$update_errors = 0;
// get all HTTP_POST_VARS and validate
$_POST['coupon_code'] = trim($_POST['coupon_code']);
$languages = zen_get_languages();
for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
$language_id = $languages[$i]['id'];
$_POST['coupon_name'][$language_id] = trim($_POST['coupon_name'][$language_id]);
if (!$_POST['coupon_name'][$language_id]) {
$update_errors = 1;
$messageStack->add(ERROR_NO_COUPON_NAME . $languages[$i]['name'], 'error');
}
$_POST['coupon_desc'][$language_id] = trim($_POST['coupon_desc'][$language_id]);
}
$_POST['coupon_amount'] = trim($_POST['coupon_amount']);
$_POST['coupon_amount'] = preg_replace('/[^0-9.%]/', '', $_POST['coupon_amount']);
if (!$_POST['coupon_name']) {
$update_errors = 1;
$messageStack->add(ERROR_NO_COUPON_NAME, 'error');
}
if ((!$_POST['coupon_amount']) && (!$_POST['coupon_free_ship'])) {
$update_errors = 1;
$messageStack->add(ERROR_NO_COUPON_AMOUNT, 'error');
}
if (!$_POST['coupon_code']) {
$coupon_code = create_coupon_code();
}
if ($_POST['coupon_code']) $coupon_code = $_POST['coupon_code'];
$sql = "select coupon_code
from " . TABLE_COUPONS . "
where coupon_code = :couponCode:";
$sql = $db->bindVars($sql, ':couponCode:', $coupon_code, 'string');
$query1 = $db->Execute($sql);
if ($query1->RecordCount()>0 && $_POST['coupon_code'] && $_GET['oldaction'] != 'voucheredit') {
$update_errors = 1;
$messageStack->add(ERROR_COUPON_EXISTS, 'error');
}
if ($update_errors != 0) {
$_GET['action'] = 'new';
} else {
$_GET['action'] = 'update_preview';
}
break;
case 'update_confirm':
if ( ($_POST['back_x']) || ($_POST['back_y']) ) {
$_GET['action'] = 'new';
} else {
$coupon_type = 'F'; // amount off
if ($_POST['coupon_free_ship']) $coupon_type = 'S'; // free shipping
if (substr($_POST['coupon_amount'], -1) == '%') $coupon_type = 'P'; // percentage off
if ($_POST['coupon_amount'] > 0 && $_POST['coupon_free_ship']) $coupon_type = 'O'; // amount off and free shipping
if (substr($_POST['coupon_amount'], -1) == '%' && $_POST['coupon_free_ship']) $coupon_type = 'E'; // percentage off and free shipping
$_POST['coupon_amount'] = preg_replace('/[^0-9.]/', '', $_POST['coupon_amount']);
$sql_data_array = array('coupon_code' => zen_db_prepare_input($_POST['coupon_code']),
'coupon_amount' => zen_db_prepare_input($_POST['coupon_amount']),
'coupon_type' => zen_db_prepare_input($coupon_type),
'uses_per_coupon' => zen_db_prepare_input((int)$_POST['coupon_uses_coupon']),
'uses_per_user' => zen_db_prepare_input((int)$_POST['coupon_uses_user']),
'coupon_minimum_order' => zen_db_prepare_input((float)$_POST['coupon_min_order']),
'restrict_to_products' => zen_db_prepare_input($_POST['coupon_products']),
'restrict_to_categories' => zen_db_prepare_input($_POST['coupon_categories']),
'coupon_start_date' => $_POST['coupon_startdate'],
'coupon_expire_date' => $_POST['coupon_finishdate'],
'date_created' => 'now()',
'date_modified' => 'now()',
'coupon_zone_restriction' => $_POST['coupon_zone_restriction']);
$languages = zen_get_languages();
for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
$language_id = $languages[$i]['id'];
$sql_data_marray[$i] = array('coupon_name' => zen_db_prepare_input($_POST['coupon_name'][$language_id]),
'coupon_description' => zen_db_prepare_input($_POST['coupon_desc'][$language_id])
);
}
if ($_GET['oldaction']=='voucheredit') {
zen_db_perform(TABLE_COUPONS, $sql_data_array, 'update', "coupon_id='" . $_GET['cid']."'");
for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
$language_id = $languages[$i]['id'];
$sql_data_desc_array = array('coupon_name' => zen_db_prepare_input($_POST['coupon_name'][$language_id]),
'coupon_description' => zen_db_prepare_input($_POST['coupon_desc'][$language_id])
);
zen_db_perform(TABLE_COUPONS_DESCRIPTION, $sql_data_desc_array, 'update', "coupon_id = '" . $_GET['cid'] . "' and language_id = '" . (int)$languages[$i]['id'] . "'");
}
} else {
zen_db_perform(TABLE_COUPONS, $sql_data_array);
$insert_id = $db->Insert_ID();
$cid = $insert_id;
$_GET['cid'] = $cid;
for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
$language_id = $languages[$i]['id'];
$sql_data_marray[$i]['coupon_id'] = (int)$insert_id;
$sql_data_marray[$i]['language_id'] = (int)$language_id;
zen_db_perform(TABLE_COUPONS_DESCRIPTION, $sql_data_marray[$i]);
}
}
}
zen_redirect(zen_href_link(FILENAME_COUPON_ADMIN, 'cid=' . $_GET['cid'] . (isset($_GET['status']) ? '&status=' . $_GET['status'] : '') . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));
}
?>
>
|
|
|
|
|
|
Execute($cc_query_raw);
while (!$cc_list->EOF) {
if (((!$_GET['uid']) || (@$_GET['uid'] == $cc_list->fields['unique_id'])) && (!$cInfo)) {
$cInfo = new objectInfo($cc_list->fields);
}
if ( (is_object($cInfo)) && ($cc_list->fields['unique_id'] == $cInfo->unique_id) ) {
echo ' ' . "\n";
} else {
echo ' ' . "\n";
}
$customer = $db->Execute("select customers_firstname, customers_lastname
from " . TABLE_CUSTOMERS . "
where customers_id = '" . $cc_list->fields['customer_id'] . "'");
?>
fields['customer_id']; ?> |
fields['customers_firstname'] . ' ' . $customer->fields['customers_lastname']; ?> |
fields['redeem_ip']; ?> |
fields['redeem_date']); ?> |
fields['unique_id'] == $cInfo->unique_id) ) { echo zen_image(DIR_WS_IMAGES . 'icon_arrow_right.gif'); } else { echo '' . zen_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . ''; } ?> |
MoveNext();
}
?>
display_count($cc_query_numrows, MAX_DISPLAY_SEARCH_RESULTS_DISCOUNT_COUPONS_REPORTS, $_GET['reports_page'], TEXT_DISPLAY_NUMBER_OF_COUPONS); ?> |
display_links($cc_query_numrows, MAX_DISPLAY_SEARCH_RESULTS_DISCOUNT_COUPONS_REPORTS, MAX_DISPLAY_PAGE_LINKS, $_GET['reports_page'], 'action=voucherreport&cid=' . $cInfo->coupon_id, 'reports_page'); ?> |
coupon_id) ? $cInfo->coupon_id : $_GET['cid']) . (isset($_GET['status']) ? '&status=' . $_GET['status'] : '')) . '">' . zen_image_button('button_back.gif', IMAGE_BACK) . ''; ?> |
|
|
Execute("select coupon_name
from " . TABLE_COUPONS_DESCRIPTION . "
where coupon_id = '" . $_GET['cid'] . "'
and language_id = '" . (int)$_SESSION['languages_id'] . "'");
$count_customers = $db->Execute("select * from " . TABLE_COUPON_REDEEM_TRACK . "
where coupon_id = '" . $_GET['cid'] . "'
and customer_id = '" . (int)$cInfo->customer_id . "'");
$heading[] = array('text' => '[' . $_GET['cid'] . ']' . COUPON_NAME . ' ' . $coupon_desc->fields['coupon_name'] . '');
$contents[] = array('text' => '' . TEXT_REDEMPTIONS . '');
// $contents[] = array('text' => TEXT_REDEMPTIONS_TOTAL . '=' . $cc_list->RecordCount());
$contents[] = array('text' => TEXT_REDEMPTIONS_TOTAL . '=' . $cc_query_numrows);
$contents[] = array('text' => TEXT_REDEMPTIONS_CUSTOMER . '=' . $count_customers->RecordCount());
$contents[] = array('text' => '');
?>
infoBox($heading, $contents);
echo ' | ' . "\n";
?>
Execute("select coupon_code
from " .TABLE_COUPONS . "
where coupon_id = '" . $_GET['cid'] . "'");
$coupon_name = $db->Execute("select coupon_name
from " . TABLE_COUPONS_DESCRIPTION . "
where coupon_id = '" . $_GET['cid'] . "'
and language_id = '" . (int)$_SESSION['languages_id'] . "'");
$audience_select = get_audience_sql_query($_POST['customers_email_address']);
$mail_sent_to = $audience_select['query_name'];
?>
|
|
|
|
fields['coupon_name']; ?> |
|
|
|
|
|
|
|
|
|
' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . ' ' . zen_image_submit('button_send_mail.gif', IMAGE_SEND_EMAIL); ?> |
|
|
Execute("select coupon_code
from " . TABLE_COUPONS . "
where coupon_id = '" . $_GET['cid'] . "'");
$coupon_name = $db->Execute("select coupon_name
from " . TABLE_COUPONS_DESCRIPTION . "
where coupon_id = '" . $_GET['cid'] . "'
and language_id = '" . (int)$_SESSION['languages_id'] . "'");
?>
|
|
|
fields['coupon_name']; ?> |
|
|
|
|
|
|
|
|
|
|
*/
?>
|
|
|
|
|
|
|
|
' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . ' ' . zen_image_submit('button_send_mail.gif', IMAGE_SEND_EMAIL); ?> |
|
|
|
Execute("select coupon_name,coupon_description
from " . TABLE_COUPONS_DESCRIPTION . "
where coupon_id = '" . $_GET['cid'] . "'
and language_id = '" . (int)$language_id . "'");
$_POST['coupon_name'][$language_id] = $coupon->fields['coupon_name'];
$_POST['coupon_desc'][$language_id] = $coupon->fields['coupon_description'];
}
$coupon = $db->Execute("select coupon_code, coupon_amount, coupon_type, coupon_minimum_order,
coupon_start_date, coupon_expire_date, uses_per_coupon,
uses_per_user, restrict_to_products, restrict_to_categories, coupon_zone_restriction
from " . TABLE_COUPONS . "
where coupon_id = '" . $_GET['cid'] . "'");
$_POST['coupon_amount'] = $coupon->fields['coupon_amount'];
if ($coupon->fields['coupon_type'] == 'P' || $coupon->fields['coupon_type'] == 'E') {
$_POST['coupon_amount'] .= '%';
}
// free shipping on free shipping only 'S' or percentage off and free shipping 'E' or amount off and free shipping 'O'
if ($coupon->fields['coupon_type'] == 'S' || $coupon->fields['coupon_type'] == 'O' || $coupon->fields['coupon_type'] == 'E') {
$_POST['coupon_free_ship'] = true;
} else {
$_POST['coupon_free_ship'] = false;
}
$_POST['coupon_min_order'] = $coupon->fields['coupon_minimum_order'];
$_POST['coupon_code'] = $coupon->fields['coupon_code'];
$_POST['coupon_uses_coupon'] = $coupon->fields['uses_per_coupon'];
$_POST['coupon_uses_user'] = $coupon->fields['uses_per_user'];
$_POST['coupon_startdate'] = $coupon->fields['coupon_start_date'];
$_POST['coupon_finishdate'] = $coupon->fields['coupon_expire_date'];
$_POST['coupon_zone_restriction'] = $coupon->fields['coupon_zone_restriction'];
case 'new':
// set some defaults
if ($_GET['action'] != 'voucheredit' and $_POST['coupon_uses_user'] == '') $_POST['coupon_uses_user'] = 1;
?>
|
|
'Y', 'text' => TEXT_COUPON_ACTIVE);
$status_array[] = array('id' => 'N', 'text' => TEXT_COUPON_INACTIVE);
$status_array[] = array('id' => '*', 'text' => TEXT_COUPON_ALL);
if (isset($_GET['status'])) {
$status = zen_db_prepare_input($_GET['status']);
} else {
$status = 'Y';
}
echo zen_hide_session_id();
$status = $status[0];
echo HEADING_TITLE_STATUS . ' ' . zen_draw_pull_down_menu('status', $status_array, $status, 'onChange="this.form.submit();"') .
zen_draw_hidden_field('page', $_GET['page']);
?>
|
';
?>
|
|
|
|
|
|
|
|
|
0) ? (int)MAX_DISPLAY_SEARCH_RESULTS_DISCOUNT_COUPONS : 20;
// reset page when page is unknown
if (($_GET['page'] == '' or $_GET['page'] == '1') and $_GET['cid'] != '') {
$check_page = $db->Execute($cc_query_raw);
$check_count=1;
if ($check_page->RecordCount() > $maxDisplaySearchResults) {
while (!$check_page->EOF) {
if ($check_page->fields['coupon_id'] == $_GET['cid']) {
break;
}
$check_count++;
$check_page->MoveNext();
}
$_GET['page'] = round((($check_count/$maxDisplaySearchResults)+(fmod_round($check_count,$maxDisplaySearchResults) !=0 ? .5 : 0)),0);
} else {
$_GET['page'] = 1;
}
}
$cc_split = new splitPageResults($_GET['page'], $maxDisplaySearchResults, $cc_query_raw, $cc_query_numrows);
$cc_list = $db->Execute($cc_query_raw);
while (!$cc_list->EOF) {
if (((!$_GET['cid']) || (@$_GET['cid'] == $cc_list->fields['coupon_id'])) && (!$cInfo)) {
$cInfo = new objectInfo($cc_list->fields);
}
if ( (is_object($cInfo)) && ($cc_list->fields['coupon_id'] == $cInfo->coupon_id) ) {
echo ' ' . "\n";
} else {
echo ' ' . "\n";
}
$coupon_desc = $db->Execute("select coupon_name
from " . TABLE_COUPONS_DESCRIPTION . "
where coupon_id = '" . (int)$cc_list->fields['coupon_id'] . "'
and language_id = '" . (int)$_SESSION['languages_id'] . "'");
?>
fields['coupon_name']; ?> |
fields['coupon_type']) {
case ('S'): // free shipping
echo TEXT_FREE_SHIPPING;
break;
case ('P'): // percentage off
echo $cc_list->fields['coupon_amount'] . '%';
break;
case ('F'): // amount off
echo $currencies->format($cc_list->fields['coupon_amount']);
break;
case ('E'): // percentage off and free shipping
echo $cc_list->fields['coupon_amount'] . '%' . ' ' . TEXT_FREE_SHIPPING;
break;
case ('O'): // amount off and free shipping
echo $currencies->format($cc_list->fields['coupon_amount']) . ' ' . TEXT_FREE_SHIPPING;
break;
default:
echo '***';
break;
}
?>
|
fields['coupon_code']; ?> |
fields['coupon_active']; ?> |
fields['coupon_start_date']); ?> |
fields['coupon_expire_date']); ?> |
fields['coupon_id'] == $cInfo->coupon_id) ) { echo zen_image(DIR_WS_IMAGES . 'icon_arrow_right.gif'); } else { echo '' . zen_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . ''; } ?> |
MoveNext();
}
?>
display_count($cc_query_numrows, $maxDisplaySearchResults, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_COUPONS); ?> |
display_links($cc_query_numrows, $maxDisplaySearchResults, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], (isset($_GET['status']) ? '&status=' . $_GET['status'] : '')); ?> |
coupon_id . '&action=new') . '">' . zen_image_button('button_insert.gif', IMAGE_INSERT) . ''; ?> |
|
|
'' . TEXT_HEADING_COUPON_REPORT . '');
$contents[] = array('text' => TEXT_NEW_INTRO);
break;
case 'new':
$heading[] = array('text' => '' . TEXT_HEADING_NEW_COUPON . '');
$contents[] = array('text' => TEXT_NEW_INTRO);
$contents[] = array('text' => ' ' . COUPON_NAME . ' ' . zen_draw_input_field('name'));
$contents[] = array('text' => ' ' . COUPON_AMOUNT . ' ' . zen_draw_input_field('voucher_amount'));
$contents[] = array('text' => ' ' . COUPON_CODE . ' ' . zen_draw_input_field('voucher_code'));
$contents[] = array('text' => ' ' . COUPON_USES_COUPON . ' ' . zen_draw_input_field('voucher_number_of'));
break;
default:
$heading[] = array('text'=>'['.$cInfo->coupon_id.'] '.$cInfo->coupon_code);
$amount = $cInfo->coupon_amount;
if ($cInfo->coupon_type == 'P' || $cInfo->coupon_type == 'E') {
$amount .= '%';
} else {
$amount = $currencies->format($amount);
}
if ($cInfo->coupon_type == 'S'|| $cInfo->coupon_type == 'E' || $cInfo->coupon_type == 'O' ) {
$amount .= ' ' . TEXT_FREE_SHIPPING;
}
if ($_GET['action'] == 'voucherdelete' or $_GET['action'] == 'vouchercopy') {
if ($_GET['action'] == 'voucherdelete') {
$contents[] = array('text'=> TEXT_CONFIRM_DELETE . '' .
''.zen_image_button('button_confirm.gif','Confirm Delete ' . TEXT_DISCOUNT_COUPON).'' .
''.zen_image_button('button_cancel.gif','Cancel').''
);
}
if ($_GET['action'] == 'vouchercopy') {
$contents = array('form' => zen_draw_form('new_coupon', FILENAME_COUPON_ADMIN, 'action=confirmcopy' . '&cid='.$_GET['cid'] . (isset($_GET['status']) ? '&status=' . $_GET['status'] : '') . (isset($_GET['page']) ? '&page=' . $_GET['page'] : ''), 'post', 'enctype="multipart/form-data"'));
$contents[] = array('text' => ' ' . TEXT_COUPON_NEW . ' ' . zen_draw_input_field('coupon_copy_to', '', 6, 6));
$contents[] = array('text'=> TEXT_CONFIRM_COPY . '');
$contents[] = array('text'=> zen_image_submit('button_save.gif', IMAGE_SAVE));
$contents[] = array('text'=>
''.zen_image_button('button_cancel.gif','Cancel').''
);
}
} else {
$prod_details = TEXT_NONE;
//bof 12-6ke
$product_query = $db->Execute("select * from " . TABLE_COUPON_RESTRICT . " where coupon_id = '" . $cInfo->coupon_id . "' and product_id != '0'"); if ($product_query->RecordCount() > 0) $prod_details = TEXT_SEE_RESTRICT;
//eof 12-6ke
$cat_details = TEXT_NONE;
//bof 12-6ke
$category_query = $db->Execute("select * from " . TABLE_COUPON_RESTRICT . " where coupon_id = '" . $cInfo->coupon_id . "' and category_id != '0'"); if ($category_query->RecordCount() > 0) $cat_details = TEXT_SEE_RESTRICT;
//eof 12-6ke
$coupon_name = $db->Execute("select coupon_name
from " . TABLE_COUPONS_DESCRIPTION . "
where coupon_id = '" . $cInfo->coupon_id . "'
and language_id = '" . (int)$_SESSION['languages_id'] . "'");
$uses_coupon = $cInfo->uses_per_coupon;
$uses_user = $cInfo->uses_per_user;
if ($uses_coupon == 0 || $uses_coupon == '') $uses_coupon = TEXT_UNLIMITED;
if ($uses_user == 0 || $uses_user == '') $uses_user = TEXT_UNLIMITED;
$contents[] = array('text'=>COUPON_NAME . ' :: ' . $coupon_name->fields['coupon_name'] . ' ' .
COUPON_AMOUNT . ' :: ' . $amount . ' ' .
COUPON_STARTDATE . ' :: ' . zen_date_short($cInfo->coupon_start_date) . ' ' .
COUPON_FINISHDATE . ' :: ' . zen_date_short($cInfo->coupon_expire_date) . ' ' .
COUPON_USES_COUPON . ' :: ' . $uses_coupon . ' ' .
COUPON_USES_USER . ' :: ' . $uses_user . ' ' .
COUPON_PRODUCTS . ' :: ' . $prod_details . ' ' .
COUPON_CATEGORIES . ' :: ' . $cat_details . ' ' .
DATE_CREATED . ' :: ' . zen_date_short($cInfo->date_created) . ' ' .
DATE_MODIFIED . ' :: ' . zen_date_short($cInfo->date_modified) . '
' .
COUPON_ZONE_RESTRICTION . ' :: ' . zen_get_geo_zone_name($cInfo->coupon_zone_restriction) . '
' .
($cInfo->coupon_id != '' ?
''.zen_image_button('button_email.gif','Email ' . TEXT_DISCOUNT_COUPON).'' .
''.zen_image_button('button_edit.gif','Edit ' . TEXT_DISCOUNT_COUPON) .'' .
''.zen_image_button('button_delete.gif','Delete ' . TEXT_DISCOUNT_COUPON).'' .
' '.zen_image_button('button_restrict.gif','Restrict').''.zen_image_button('button_report.gif',TEXT_DISCOUNT_COUPON . ' Report').
''.zen_image_button('button_copy.gif','Copy ' . TEXT_DISCOUNT_COUPON) . ''
: ' who ' . $cInfo->coupon_id . ' - ' . $_GET['cid'])
);
}
break;
}
?>
infoBox($heading, $contents);
echo ' | ' . "\n";
}
?>
|
| | | | | |