Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Discount Coupons


Guest

Recommended Posts

Have finished installing credit class contribution and voucher system works like a dream, but discount coupons are not working.

 

On a dummy run I found that it accepted me entering the coupon number, but then on the order confirmation page no money was discounted.

 

Has anyone had this happen?

 

The second problem is that after entering my coupon number I noticed that my shopping cart had a - coupon - more info - on it. So I clicked on this to see what to do, but that is coming up with an error on the page.

 

Maybe these 2 are linked to the same problem, so fixing one will fix the other.

 

Anyway this is the link line that doesn't work from shopping_cart.php:

 

if (tep_session_is_registered('cc_id') && $cc_id) {
   $info_box_contents[] = array('align' => 'left','text' => tep_draw_separator());
   $info_box_contents[] = array('align' => 'left','text' => '<table cellpadding="0" width="100%" cellspacing="0" border="0"><tr><td class="smalltext">' . CART_COUPON . '</td><td class="smalltext" align="right" valign="bottom">' . '<a href="javascript:couponpopupWindow(\'' . tep_href_link(FILENAME_POPUP_COUPON_HELP, 'cID=' . $cc_id) . '\')">' . CART_COUPON_INFO . '</a>' . '</td></tr></table>');

 }

 

Is there anything wrong here?

 

And here the popup_coupon_help.php:

 

  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 = tep_db_query("select * from " . TABLE_COUPONS . " where coupon_id = '" . $HTTP_GET_VARS['cID'] . "'");
 $coupon = tep_db_fetch_array($coupon_query);
 $coupon_desc_query = tep_db_query("select * from " . TABLE_COUPONS_DESCRIPTION . " where coupon_id = '" . $HTTP_GET_VARS['cID'] . "' and language_id = '" . $languages_id . "'");
 $coupon_desc = tep_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 (tep_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, tep_date_short($coupon['coupon_start_date']),tep_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=tep_db_query("select restrict_to_categories from " . TABLE_COUPONS . " where coupon_id='".$HTTP_GET_VARS['cID']."'");
 $get_result=tep_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=tep_db_query("select restrict_to_products from " . TABLE_COUPONS . "  where coupon_id='".$HTTP_GET_VARS['cID']."'");
 $get_result=tep_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'); ?>

 

Hope someone can offer some advice on this.

Link to comment
Share on other sites

  • 3 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...