Community Add-Ons

Add file to this package

Top » Credit Modules

Credit Class & Gift Voucher
for osCommerce Online Merchant v2.2

Description
History

(show 171 more downloads)

The base credit class and the Gift Voucher module in one package.

Legend: Download Report

Expand All / Collapse All

This are only the /admin/coupon_admin.php and /admin/includes/boxes/gv_admin.php files which were modified to work in the new admin interface in osCommerce 2.3.1

I'm trying to port all the contrib to osCommerce 2.3.1 since most of the files can't be replaced since they are much different from RC2.

I'll be contributing the rest of my modifications but I can't make the text field where the customer types his coupon code appear anywhere so I'm stuck.

If any of this contribution developers or contributors could explain how the coupon code input works so I can try to update the contribution (or help me do so :P) would be great

I started a dorum topic about this
http://forums.oscommerce.com/topic/374736-credit-class-gift-vouchers-ccgv-for-231/
and you can contact me over there, I'm the first post user

*Sorry. Forgot some files in last upload. This is the full package.

When installing on a fresh install of RC2a, the following errors occur in admin section:

errors on admin/coupon_admin.php
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /gearupaz/public_html/admin/includes/functions/database.php on line 107

errors on admin/gv_mail.php:
Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /gearupaz/public_html/admin/includes/functions/database.php on line 117

Warning: Cannot modify header information - headers already sent by (output started at /gearupaz/public_html/admin/includes/functions/database.php:117) in /gearupaz/public_html/admin/includes/functions/general.php on line 22

This is a fix for the CCGV (Contibution 282) where certain database.php errors and other problems are happening with the admin side.

This is a full package for new installation, where the previous package caused some problems for new (drop-in) installations.

*Built onto version 5.21
*Credit for these solutions goes to original contributors and forum users.

Fix gv_mail.php error:
On line 64 replace:
$insert_id = tep_db_insert_id($insert_query);
with:
$insert_id = tep_db_insert_id();

Fix coupon_admin.php (under case: voucherreport, lines:227-230)
replace:
$cc_query_raw = "select * from " . TABLE_COUPON_REDEEM_TRACK . " where coupon_id = '" . (int)$coupon_id . "'";
$cc_query_numrows = tep_db_num_rows($cc_query);
$cc_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $cc_query_raw, $cc_query_numrows);
$cc_query = tep_db_query($cc_query_raw);
with:
$cc_query_raw = "select * from " . TABLE_COUPON_REDEEM_TRACK . " where coupon_id = '" . (int)$coupon_id . "'";
$cc_query = tep_db_query($cc_query_raw);
$cc_query_numrows = tep_db_num_rows($cc_query);
$cc_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $cc_query_raw, $cc_query_numrows);

*Thanks OSC community for all efforts and making one of the most practical contributions a possibility.

When installing on a fresh install of RC2a, the following errors occur in admin section:

errors on admin/coupon_admin.php
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /gearupaz/public_html/admin/includes/functions/database.php on line 107

errors on admin/gv_mail.php:
Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /gearupaz/public_html/admin/includes/functions/database.php on line 117

Warning: Cannot modify header information - headers already sent by (output started at /gearupaz/public_html/admin/includes/functions/database.php:117) in /gearupaz/public_html/admin/includes/functions/general.php on line 22

This is a fix for the CCGV (Contibution 282) where certain database.php errors and other problems are happening with the admin side.

This is a full package for new installation, where the previous package caused some problems for new (drop-in) installations.

*Built onto version 5.21
*Credit for these solutions goes to original contributors and forum users.

Fix gv_mail.php error:
On line 64 replace:
$insert_id = tep_db_insert_id($insert_query);
with:
$insert_id = tep_db_insert_id();

Fix coupon_admin.php (under case: voucherreport, lines:227-230)
replace:
$cc_query_raw = "select * from " . TABLE_COUPON_REDEEM_TRACK . " where coupon_id = '" . (int)$coupon_id . "'";
$cc_query_numrows = tep_db_num_rows($cc_query);
$cc_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $cc_query_raw, $cc_query_numrows);
$cc_query = tep_db_query($cc_query_raw);
with:
$cc_query_raw = "select * from " . TABLE_COUPON_REDEEM_TRACK . " where coupon_id = '" . (int)$coupon_id . "'";
$cc_query = tep_db_query($cc_query_raw);
$cc_query_numrows = tep_db_num_rows($cc_query);
$cc_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $cc_query_raw, $cc_query_numrows);

*Thanks OSC community for all efforts and making one of the most practical contributions a possibility.

there are two definitions for ERROR_REDEEMED_AMOUNT_ZERO that comes up when a valid coupon number is added, but the restrictions(i.e. uses, expiration date, etc.) prevent it from being used.

the two are defined in:
catalog/includes/languages/english/add_ccgvdc_english.php
catalog/includes/languages/english/modules/order_total/ot_coupon.php

And called for in catalog/includes/modules/order_total/ot_coupon.php

---------------------------------------------------------------------------------------------------------------------------

1. *** catalog/includes/languages/english/add_ccgvdc_english.php ***
REMOVE OR COMMENT:
define('ERROR_REDEEMED_AMOUNT_ZERO', '<br>***HOWEVER:No reduction available, please see the coupon restrictions***');

2. *** catalog/includes/languages/english/modules/order_total/ot_coupon.php ***
CHANGE:
define('ERROR_REDEEMED_AMOUNT_ZERO', 'a valid coupon number. HOWEVER: No reduction will be applied, please see the coupon restrictions that was sent within your offer email**');

TO:
define('ERROR_REDEEMED_AMOUNT_ZERO', '*** This is a valid coupon code. HOWEVER: No price reduction can be applied, please see the coupon restrictions that were sent with your email offer. **');

3. *** in catalog/includes/modules/order_total/ot_coupon.php ***

CHANGE:
if ( strlen($cc_id)>0 && $coupon_amount==0 ) {
$err_msg = ERROR_REDEEMED_AMOUNT.ERROR_REDEEMED_AMOUNT_ZERO;
} else {
$err_msg = ERROR_REDEEMED_AMOUNT.$coupon_amount_out;
}
tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'payment_error='.$this->code.'&error=' . urlencode($err_msg), 'SSL'));

TO:
//lildog ccgv coupon restrictions error fix
if ( strlen($cc_id)>0 && $coupon_amount==0 ) {
// $err_msg = ERROR_REDEEMED_AMOUNT.ERROR_REDEEMED_AMOUNT_ZERO;
$err_msg = ERROR_REDEEMED_AMOUNT_ZERO;
} else {
$err_msg = ERROR_REDEEMED_AMOUNT.$coupon_amount_out;
}
tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'payment_error='.$this->code.'&error=' . urlencode($err_msg), 'SSL'));

CCGV 5.18 Checkout 'ot_coupon.php' Display Fix

This fixes a problem where in checkout (www.yoursite.com/catalog/checkout_payment.php)
the 'Payment Method - Gift Vouchers & Coupons' box formating displays the "Enter Code..."
instructions appear below the "Redeem Code" line and where the "Enter Redeem Code" is in
the wrong font formating.

This file included the replacement 'ot_coupon.php' and the instructions found below.

Edit the file:
catalog/includes/modules/order_total/ot_coupon.php

At line 60 find:

function credit_selection() {
global $customer_id, $currencies, $language;
$selection_string = tep_draw_form('checkout_payment_gift', tep_href_link(FILENAME_CHECKOUT_CONFIRMATION, '', 'SSL'), 'post');
$selection_string .= '<div><br />';
$selection_string .= TEXT_ENTER_GV_CODE . tep_draw_input_field('gv_redeem_code', 'redeem code') ;
$selection_string .= tep_image_submit('button_redeem.gif', IMAGE_REDEEM_VOUCHER, 'onclick="return submitFunction()"');
$selection_string .= '</div><br /></form>';

return $selection_string;
}

Replace this with:

function credit_selection() {
global $customer_id, $currencies, $language;
// START Checkout Display Fix by BTBlomberg
$selection_string = '<tr><td></td><td class="main">';
$selection_string .= tep_draw_form('checkout_payment_gift', tep_href_link(FILENAME_CHECKOUT_CONFIRMATION, '', 'SSL'), 'post');
$selection_string .= '<div><br /> ';
$selection_string .= TEXT_ENTER_GV_CODE . tep_draw_input_field('gv_redeem_code', 'redeem code') ;
$selection_string .= ' ';
$selection_string .= tep_image_submit('button_redeem.gif', IMAGE_REDEEM_VOUCHER, 'onclick="return submitFunction()"');
$selection_string .= '</div><br /></form></td></tr>';
// END Checkout Display Fix by BTBlomberg

return $selection_string;
}

This will put the instructions above the Redeem Code line and fix the Font issue with
the text before the entry box "Enter Redeem Code". More may be able to be done to clean
it more but this will get it working better than it was.

By BTBlomberg 12/10/2006

An updated version of the Credit Class/Gift Voucher/Discount Coupon contributions.

Updated areas are as follows

Core Credit Class Code.

The whole database structure has been changed. This was needed to help with the single redeem box,
and to provide better reporting possibilities.
Changes to the order_total ouput to allow for a single redeem box.

Gift Voucher System

Thanks to gdfwilliams, I've done away with separate box to show the amount in a customers Gift Voucher Account.
This is now shown in the shopping cart box.

The code now uses the get_content_type function to skip shipping selection if the Gift Voucher is the only item
in the cart.

The decision to queue purchases of Gift Vouchers is now set in admin rather than having to edit a DEFINE in
add_application_top.php

A new tax option has been added to treat Gift Vouchers like credit notes. If you don't know what that
means it probably doesn't concern you.

Redemption by email is now much simpler. There is no need to login, as the redeemed value is stored
in a session variable until the user checksout.

It is now possible to set a variable (in includes/add_application_top.php) to send a Gift Voucher
to new customers when they create an account.
define('NEW_SIGNUP_GIFT_VOUCHER_AMOUNT', '10');

It is also now possible to set the length of the redeem codes generated by the system.
define('SECURITY_CODE_LENGTH', '10');
again this is located in catalog/includes/add_application_top.php

If Voucher purchases are queued then the customer is informed by email when the amount is released
by admin.

Discount Coupon System

Lots of tidying up in the admin area, including the addittion of a proper voucher usage report.
A new Free Shipping Voucher (again thanks to gdfwilliams for the idea).
As for the Gift Voucher a new tax calculation treating the Coupon as a Credit Note.
The whole tax calculation logic has in fact been rewritten.
Again like the GV system, you can now set a Disount Coupon to be sent to a new customer on signup.
define('NEW_SIGNUP_DISCOUNT_COUPON', '3');
the value (e.g. '3') is the coupon id as created in admin.
The discount coupon is now shown in the shopping cart box when redeemed, this also has a 'more info' link
that gives full details of what the Coupon is worth including any category/product restrictions.

I'm currently working on a much more intuitive way of defining category/product restiction for the Discount
Coupon system. I will release this as an upgrade file asap.

Community Add-Ons

Credit Class & Gift Voucherfor osCommerce Online Merchant v2.2

Credit Class & Gift Voucher
for osCommerce Online Merchant v2.2