Popup Coupon Help.php:
<?php
/*
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Enterprise Shopping Cart
http://www.enterprisecart.com
Copyright (c) 2004 Enterprise Shopping Cart Software. Portions Copyright (c) 2001-2004 osCommerce: http://www.oscommerce.com
Released under the GNU General Public License
*/
require('includes/application_top.php');
$navigation->remove_current_page();
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_POPUP_COUPON_HELP);
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<style type="text/css"><!--
BODY { margin-bottom: 10px; margin-left: 10px; margin-right: 10px; margin-top: 10px; }
//--></style>
<body marginwidth="10" marginheight="10" topmargin="10" bottommargin="10" leftmargin="10" rightmargin="10">
<?php
$coupon_query = escs_db_query("select * from " . TABLE_COUPONS . " where coupon_id = '" . $HTTP_GET_VARS['cID'] . "'");
$coupon = escs_db_fetch_array($coupon_query);
$coupon_desc_query = escs_db_query("select * from " . TABLE_COUPONS_DESCRIPTION . " where coupon_id = '" . $HTTP_GET_VARS['cID'] . "' and language_id = '" . $languages_id . "'");
$coupon_desc = escs_db_fetch_array($coupon_desc_query);
$text_coupon_help = TEXT_COUPON_HELP_HEADER;
$text_coupon_help .= sprintf(TEXT_COUPON_HELP_NAME, $coupon_desc['coupon_name']);
if (escs_not_null($coupon_desc['coupon_description'])) $text_coupon_help .= sprintf(TEXT_COUPON_HELP_DESC, $coupon_desc['coupon_description']);
$coupon_amount = $coupon['coupon_amount'];
switch ($coupon['coupon_type']) {
case 'F':
$text_coupon_help .= sprintf(TEXT_COUPON_HELP_FIXED, $currencies->format($coupon['coupon_amount']));
break;
case 'P':
$text_coupon_help .= sprintf(TEXT_COUPON_HELP_FIXED, number_format($coupon['coupon_amount'], 2). '%');
break;
case 'S':
$text_coupon_help .= TEXT_COUPON_HELP_FREESHIP;
break;
default:
}
if ($coupon['coupon_minimum_order'] > 0 ) $text_coupon_help .= sprintf(TEXT_COUPON_HELP_MINORDER, $currencies->format($coupon['coupon_minimum_order']));
$text_coupon_help .= sprintf(TEXT_COUPON_HELP_DATE, escs_date_short($coupon['coupon_start_date']), escs_date_short($coupon['coupon_expire_date']));
$text_coupon_help .= '<b>' . TEXT_COUPON_HELP_RESTRICT . '</b>';
$text_coupon_help .= '<br><br>' . TEXT_COUPON_HELP_CATEGORIES;
$coupon_get=escs_db_query("select restrict_to_categories from " . TABLE_COUPONS . " where coupon_id='".$HTTP_GET_VARS['cID']."'");
$get_result=escs_db_fetch_array($coupon_get);
$cat_ids = split("[, ]", $get_result['restrict_to_categories']);
for ($i = 0; $i < count($cat_ids); $i++) {
$result = mysql_query("SELECT * FROM categories, categories_description WHERE categories.categories_id = categories_description.categories_id and categories_description.language_id = '" . $languages_id . "' and categories.categories_id='" . $cat_ids[$i] . "'");
if ($row = mysql_fetch_array($result)) {
$cats .= '<br>' . $row["categories_name"];
}
}
if ($cats=='') $cats = '<br>NONE';
$text_coupon_help .= $cats;
$text_coupon_help .= '<br><br>' . TEXT_COUPON_HELP_PRODUCTS;
$coupon_get=escs_db_query("select restrict_to_products from " . TABLE_COUPONS . " where coupon_id='".$HTTP_GET_VARS['cID']."'");
$get_result=escs_db_fetch_array($coupon_get);
$pr_ids = split("[, ]", $get_result['restrict_to_products']);
for ($i = 0; $i < count($pr_ids); $i++) {
$result = mysql_query("SELECT * FROM products, products_description WHERE products.products_id = products_description.products_id and products_description.language_id = '" . $languages_id . "'and products.products_id = '" . $pr_ids[$i] . "'");
if ($row = mysql_fetch_array($result)) {
$prods .= '<br>' . $row["products_name"];
}
}
if ($prods=='') $prods = '<br>NONE';
$text_coupon_help .= $prods;
$info_box_contents = array();
$info_box_contents[] = array('text' => HEADING_COUPON_HELP);
new infoBoxHeading($info_box_contents, true, true);
$info_box_contents = array();
$info_box_contents[] = array('text' => $text_coupon_help);
new infoBox($info_box_contents);
?>
<p class="smallText" align="right"><?php echo '<a href="javascript:window.close()">' . TEXT_CLOSE_WINDOW . '</a>'; ?></p>
</body>
</html>
<?php require('includes/application_bottom.php'); ?>
Other E Commerce Scripts: