Credit Class & Gift Vouchers for 2.3.4

♥mommaroodles · August 13, 2014

I have uploaded a much improved version of the CCGV for osCommerce 2.3.4 - I have tested it too on osCommerce 2.3.4 but not totally thoroughly. You should test the gift vouchers first.

Fixes and improvements include the following.

Coupon Admin now uses the jQuery date picker to select the start and expiry dates of the coupons.
coupon_admin.php file has been cleaned up and a lot of unnecessary code has been removed.
When mailing a Gift Voucher, the data is correctly inserted into the database and you can see to whom you have mailed gift vouchers too when clicking on the "Gift Vouchers Sent" link
All the buttons are also jQuery buttons.
You can set a discount coupon "Active" or "Inactive"
CCGV now has its own link and settings in the Configuration tab.
You can also set the length of the auto generated coupon code and gift voucher code in admin.
The content which was in the add_ccgvdc_application_top.php in both catalog and admin have been moved to their correct respective files.
The content which was in the add_ccgvdc_english.php in both catalog and admin have been moved to their correct respective files.
The ot_coupon.php and the ot_gv.php files have correct settings, once the order totals have been installed you don't need to change them but you will need to change the rest of the order total modules.
$HTTP_GET_VARS $HTTP_POST_VARS have been changed to $_GET and $_POST

You can get the package here http://addons.oscommerce.com/info/9020

Spiceupyour · August 13, 2014

thank you, have been waiting for this :)

♥mommaroodles · August 14, 2014

@@Spiceupyour let me know if you find any errors - if there is anything it will more than likely be with the customer mailing gift vouchers to some other person. I tested the discount coupon codes but didnt really go into the voucher side of things - they did work last time i checked.

I've also improved the verbage in the emails sent to customers - I didnt change it too radically - just the basics

Spiceupyour · August 14, 2014

I will be testing this weekend, will keep you posted

Spiceupyour · August 15, 2014

Found my first error [ I am upgrading from the last version]

h**p://www.mysite.com/catalog/admin/coupon_admin.php?page=&cID=1&action=new

Fatal error: Call to undefined function tep_draw_date_selector() in /home4/lingerie/public_html/work/catalog/admin/coupon_admin.php on line 667

Edited August 15, 2014 by Spiceupyour

Spiceupyour · August 15, 2014

update

I think you added some new fuctions to old class files but did not replace the old files.

for now i have fixed the problem by replacing the new admin/includes/boxes/ot_coupon_admin.php

with the one from the old package.

This has solved the problem for now.

Edited August 15, 2014 by Spiceupyour

♥mommaroodles · August 16, 2014

@@Spiceupyour what exactly did you do or was it that I didnt do - I'd like to check this and make the necessary changes :)

♥mommaroodles · August 16, 2014

update

I think you added some new fuctions to old class files but did not replace the old files.

for now i have fixed the problem by replacing the new admin/includes/boxes/ot_coupon_admin.php

with the one from the old package.

This has solved the problem for now.

There isnt an ot_coupon_admin.php file in the package, your file is most likely from some other contribution.

Spiceupyour · August 17, 2014

hi Melani,

I am sorry for the late reply, I have been working 16 hours days and was away need a break

Disregard my last few post, I messed up, by mixing files, everything works great with the coupons part.

The problem is with gift voucher, you can sell and buy it no problem, you can realize it from admin no problem,

You can send to anyone no problem, the problem begins after anyone that has received the gift voucher wants to cash it

1)The GV number do not display any were for the customer to see [average user is not smart enough to take it from the redemption email link]

2)When the GV number taken from the email address is used an error message show up saying invalid code.

3)The credits can been seen in the shopping cart, you just cannot redeem.

Edited August 17, 2014 by Spiceupyour

nikko50 · August 17, 2014

I did a fresh install of OS 2.3.4 and added the new package provided yesterday and get the following error. Why?

Fatal error: Call to undefined method: shoppingcart->count_contents_virtual() in /checkout_payment.php on line 82

nikko50 · August 17, 2014

Also get the below errors with all the links in the admin section within the "Vouchers/Coupons" list?

The requested URL /admin/FILENAME_GV_QUEUE was not found on this server.

The requested URL /admin/FILENAME_GV_MAIL was not found on this server.

The requested URL /admin/FILENAME_GV_SENT was not found on this server.

nikko50 · August 17, 2014

Also get the below errors with all the links in the admin section within the "Vouchers/Coupons" list?

The requested URL /admin/FILENAME_GV_QUEUE was not found on this server.

The requested URL /admin/FILENAME_GV_QUEUE was not found on this server.

The requested URL /admin/FILENAME_GV_MAIL was not found on this server.

The requested URL /admin/FILENAME_GV_SENT was not found on this server.

OK this issue I fixed

nikko50 · August 17, 2014

Also get the below errors with all the links in the admin section within the "Vouchers/Coupons" list?

The requested URL /admin/FILENAME_GV_QUEUE was not found on this server.

The requested URL /admin/FILENAME_GV_QUEUE was not found on this server.

The requested URL /admin/FILENAME_GV_MAIL was not found on this server.

The requested URL /admin/FILENAME_GV_SENT was not found on this server.

Fixed this iisue

nikko50 · August 17, 2014

If I buy a gift voucher it does not appear in the queue to release. I named the item GIFT25 and gave it a weight of 0. Anything I'm doing wrong here?

♥mommaroodles · August 18, 2014

@@nikko50

You've added a product with the model number GIFT25 and gave it a weight of 0. This means that you now have a gift voucher to the value of $25 which you have made available for customers to buy.That gift voucher appears under your products in admin and under categories on the front end

Now once a customer buys the gift voucher, one of two things can happen, he/she can use that against another purchase, they will be able to use the whole $25 or part there of - or they can email the gift voucher to a friend who then will have to come and register at the site and buy something in order to use it.

Only once you have sold the gift voucher to a customer does it appear in the gift voucher queue in admin, you then physically have to make it available for the customer to use by clicking the release button. it was setup like this to prevent fraud -you release the gift voucher once you have received the payment for it.

Once you have released the gift voucher it disappears from the queue and for the customer, when he logs in again - he will see 1) in the shopping cart box - a note to tell him he has a gift voucher of R25.00 to use or to email to a friend, 2) in his account area - customer is also notified.

♥mommaroodles · August 18, 2014

hi Melani,

I am sorry for the late reply, I have been working 16 hours days and was away need a break

Disregard my last few post, I messed up, by mixing files, everything works great with the coupons part.

The problem is with gift voucher, you can sell and buy it no problem, you can realize it from admin no problem,

You can send to anyone no problem, the problem begins after anyone that has received the gift voucher wants to cash it

1)The GV number do not display any were for the customer to see [average user is not smart enough to take it from the redemption email link]

2)When the GV number taken from the email address is used an error message show up saying invalid code.

3)The credits can been seen in the shopping cart, you just cannot redeem.

@@Spiceupyour

Replace your ot_gv.php file with this

<?php
/*
  $Id: ot_gv.php,v 1.37.3 2004/01/01 12:52:59 Strider Exp $
  $Id: ot_gv.php,v 1.4.2.12 2003/05/14 22:52:59 wilt Exp $
  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com
  Copyright (c) 2002 osCommerce
  Released under the GNU General Public License
*/
  class ot_gv {
    var $title, $output;
    function ot_gv() {
      $this->code = 'ot_gv';
      $this->title = MODULE_ORDER_TOTAL_GV_TITLE;
      $this->header = MODULE_ORDER_TOTAL_GV_HEADER;
      $this->description = MODULE_ORDER_TOTAL_GV_DESCRIPTION;
      $this->user_prompt = MODULE_ORDER_TOTAL_GV_USER_PROMPT;
      $this->enabled = MODULE_ORDER_TOTAL_GV_STATUS;
      $this->sort_order = MODULE_ORDER_TOTAL_GV_SORT_ORDER;
      $this->include_shipping = MODULE_ORDER_TOTAL_GV_INC_SHIPPING;
      $this->include_tax = MODULE_ORDER_TOTAL_GV_INC_TAX;
      $this->calculate_tax = MODULE_ORDER_TOTAL_GV_CALC_TAX;
      $this->credit_tax = MODULE_ORDER_TOTAL_GV_CREDIT_TAX;
      $this->tax_class  = MODULE_ORDER_TOTAL_GV_TAX_CLASS;
      $this->show_redeem_box = MODULE_ORDER_TOTAL_GV_REDEEM_BOX;
      $this->credit_class = true;
      $this->checkbox = $this->user_prompt . '<input type="checkbox" onclick="submitFunction()" name="' . 'c' . $this->code . '">';
      $this->output = array();
    }
    function process() {
      global $order, $currencies, $cot_gv;
//      if ($_SESSION['cot_gv']) {  // old code Strider
       if (tep_session_is_registered('cot_gv')) {
        $order_total = $this->get_order_total();
        $od_amount = $this->calculate_credit($order_total);
        if ($this->calculate_tax != "None") {
          $tod_amount = $this->calculate_tax_deduction($order_total, $od_amount, $this->calculate_tax);
          $od_amount = $this->calculate_credit($order_total);
        }
        $this->deduction = $od_amount;
//        if (($this->calculate_tax == "Credit Note") && (DISPLAY_PRICE_WITH_TAX != 'true')) {
//          $od_amount -= $tod_amount;
//          $order->info['total'] -= $tod_amount;
//        }
        $order->info['total'] = $order->info['total'] - $od_amount;
        if ($od_amount > 0) {
          $this->output[] = array('title' => $this->title . ':',
                                  'text' => ' -' . $currencies->format($od_amount) . '',
                                  'value' => $od_amount);
        }
      }
    }
    function selection_test() {
      global $customer_id;
      if ($this->user_has_gv_account($customer_id)) {
        return true;
      } else {
        return false;
      }
    }
  function pre_confirmation_check($order_total) {
    global $cot_gv, $order;
//    if ($_SESSION['cot_gv']) {  // old code Strider
      $od_amount = 0; // set the default amount we will send back
      if (tep_session_is_registered('cot_gv')) {
// pre confirmation check doesn't do a true order process. It just attempts to see if
// there is enough to handle the order. But depending on settings it will not be shown
// all of the order so this is why we do this runaround jane. What do we know so far.
// nothing. Since we need to know if we process the full amount we need to call get order total
// if there has been something before us then
        if ($this->include_tax == 'false') {
          $order_total = $order_total - $order->info['tax'];
        }
        if ($this->include_shipping == 'false') {
          $order_total = $order_total - $order->info['shipping_cost'];
        }
        $od_amount = $this->calculate_credit($order_total);
        if ($this->calculate_tax != "None") {
          $tod_amount = $this->calculate_tax_deduction($order_total, $od_amount, $this->calculate_tax);
          $od_amount = $this->calculate_credit($order_total)+$tod_amount;
        }
      }
    return $od_amount;
  }
    // original code
  /*function pre_confirmation_check($order_total) {
      if ($SESSION['cot_gv']) {
        $gv_payment_amount = $this->calculate_credit($order_total);
      }
      return $gv_payment_amount;
    } */
    function use_credit_amount() {
    global $cot_gv;
//      $_SESSION['cot_gv'] = false;     // old code - Strider
      $cot_gv = false;
      if ($this->selection_test()) {
        $output_string .=  '<td align="right" class="main">';
        $output_string .= '<b>' . $this->checkbox . '</b>' . '</td>' . "\n";
      }
      return $output_string;
    }
    function update_credit_account($i) {
      global $order, $customer_id, $insert_id, $REMOTE_ADDR;
      if (preg_match('/^GIFT/', addslashes($order->products[$i]['model']))) {
        $gv_order_amount = ($order->products[$i]['final_price'] * $order->products[$i]['qty']);
        if ($this->credit_tax=='true') $gv_order_amount = $gv_order_amount * (100 + $order->products[$i]['tax']) / 100;
//        $gv_order_amount += 0.001;
        $gv_order_amount = $gv_order_amount * 100 / 100;
        if (MODULE_ORDER_TOTAL_GV_QUEUE == 'false') {
          // GV_QUEUE is true so release amount to account immediately
          $gv_query=tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . (int)$customer_id . "'");
          $customer_gv = false;
          $total_gv_amount = 0;
          if ($gv_result = tep_db_fetch_array($gv_query)) {
            $total_gv_amount = $gv_result['amount'];
            $customer_gv = true;
          }
          $total_gv_amount = $total_gv_amount + $gv_order_amount;
          if ($customer_gv) {
            $gv_update=tep_db_query("update " . TABLE_COUPON_GV_CUSTOMER . " set amount = '" . $total_gv_amount . "' where customer_id = '" . (int)$customer_id . "'");
          } else {
            $gv_insert=tep_db_query("insert into " . TABLE_COUPON_GV_CUSTOMER . " (customer_id, amount) values ('" . $customer_id . "', '" . $total_gv_amount . "')");
          }
        } else {
         // GV_QUEUE is true - so queue the gv for release by store owner
          $gv_insert=tep_db_query("insert into " . TABLE_COUPON_GV_QUEUE . " (customer_id, order_id, amount, date_created, ipaddr) values ('" . $customer_id . "', '" . $insert_id . "', '" . $gv_order_amount . "', NOW(), '" . $REMOTE_ADDR . "')");
        }
      }
    }
    function credit_selection() {
      global $customer_id, $currencies, $language;
      $selection_string = '';
      $gv_query = tep_db_query("select coupon_id from " . TABLE_COUPONS . " where coupon_type = 'G' and coupon_active='Y'");
      if (tep_db_num_rows($gv_query)) {
        $selection_string .= '<tr>' . "\n";
        $selection_string .= '  <td width="10">' .  tep_draw_separator('pixel_trans.gif', '10', '1') .'</td>';
        $selection_string .= '  <td class="main">' . "\n";
        $image_submit = '<input type="image" name="submit_redeem" onClick="submitFunction()" src="' . DIR_WS_LANGUAGES . $language . '/images/buttons/button_redeem.gif" border="0" alt="' . IMAGE_REDEEM_VOUCHER . '" title = "' . IMAGE_REDEEM_VOUCHER . '">';
        $selection_string .= TEXT_ENTER_GV_CODE . tep_draw_input_field('gv_redeem_code') . '</td>';
        $selection_string .= ' <td align="right">' . $image_submit . '</td>';
        $selection_string .= '  <td width="10">' . tep_draw_separator('pixel_trans.gif', '10', '1') . '</td>';
        $selection_string .= '</tr>' . "\n";
      }
    return $selection_string;
    }
    function apply_credit() {
      global $order, $customer_id, $coupon_no, $cot_gv;
      if (tep_session_is_registered('cot_gv')) {
        $gv_query = tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . (int)$customer_id . "'");
        $gv_result = tep_db_fetch_array($gv_query);
        $gv_payment_amount = $this->deduction;
        $gv_amount = $gv_result['amount'] - $gv_payment_amount;
        $gv_update = tep_db_query("update " . TABLE_COUPON_GV_CUSTOMER . " set amount = '" . $gv_amount . "' where customer_id = '" . (int)$customer_id . "'");
      }
      return $gv_payment_amount;
    }
    function collect_posts() {
      global $currencies, $_POST, $customer_id, $coupon_no, $REMOTE_ADDR;
      if ($_POST['gv_redeem_code']) {
        $gv_query = tep_db_query("select coupon_id, coupon_type, coupon_amount from " . TABLE_COUPONS . " where coupon_code = '" . $_POST['gv_redeem_code'] . "'");
        $gv_result = tep_db_fetch_array($gv_query);
        if (tep_db_num_rows($gv_query) != 0) {
          $redeem_query = tep_db_query("select * from " . TABLE_COUPON_REDEEM_TRACK . " where coupon_id = '" . $gv_result['coupon_id'] . "'");
          if ( (tep_db_num_rows($redeem_query) != 0) && ($gv_result['coupon_type'] == 'G') ) {
            tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_NO_INVALID_REDEEM_GV), 'SSL'));
          }
        }

        if ($gv_result['coupon_type'] == 'G') {
          $gv_amount = $gv_result['coupon_amount'];
          // Things to set
          // ip address of claimant
          // customer id of claimant
          // date
          // redemption flag
          // now update customer account with gv_amount
          $gv_amount_query=tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . (int)$customer_id . "'");
          $customer_gv = false;
          $total_gv_amount = $gv_amount;;
          if ($gv_amount_result = tep_db_fetch_array($gv_amount_query)) {
            $total_gv_amount = $gv_amount_result['amount'] + $gv_amount;
            $customer_gv = true;
          }
          $gv_update = tep_db_query("update " . TABLE_COUPONS . " set coupon_active = 'N' where coupon_id = '" . $gv_result['coupon_id'] . "'");
          $gv_redeem = tep_db_query("insert into  " . TABLE_COUPON_REDEEM_TRACK . " (coupon_id, customer_id, redeem_date, redeem_ip) values ('" . $gv_result['coupon_id'] . "', '" . $customer_id . "', now(),'" . $REMOTE_ADDR . "')");
          if ($customer_gv) {
            // already has gv_amount so update
            $gv_update = tep_db_query("update " . TABLE_COUPON_GV_CUSTOMER . " set amount = '" . $total_gv_amount . "' where customer_id = '" . (int)$customer_id . "'");
          } else {
            // no gv_amount so insert
            $gv_insert = tep_db_query("insert into " . TABLE_COUPON_GV_CUSTOMER . " (customer_id, amount) values ('" . $customer_id . "', '" . $total_gv_amount . "')");
          }
          tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_REDEEMED_AMOUNT. $currencies->format($gv_amount)), 'SSL'));
       }
     }
     if ($_POST['submit_redeem_x'] && $gv_result['coupon_type'] == 'G') tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_NO_REDEEM_CODE), 'SSL'));
   }
    function calculate_credit($amount) {
      global $customer_id, $order;
      $gv_query=tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . (int)$customer_id . "'");
      $gv_result=tep_db_fetch_array($gv_query);
      $gv_payment_amount = $gv_result['amount'];
      $gv_amount = $gv_payment_amount;
      $save_total_cost = $amount;
      $full_cost = $save_total_cost - $gv_payment_amount;
      if ($full_cost <= 0) {
        $full_cost = 0;
        $gv_payment_amount = $save_total_cost;
      }
      return tep_round($gv_payment_amount,2);
    }
    function calculate_tax_deduction($amount, $od_amount, $method) {
      global $order;
      switch ($method) {
        case 'Standard':
        $ratio1 = tep_round($od_amount / $amount,2);
        $tod_amount = 0;
        reset($order->info['tax_groups']);
        while (list($key, $value) = each($order->info['tax_groups'])) {
          $tax_rate = tep_get_tax_rate_from_desc($key);
          $total_net += $tax_rate * $order->info['tax_groups'][$key];
        }
        if ($od_amount > $total_net) $od_amount = $total_net;
        reset($order->info['tax_groups']);
        while (list($key, $value) = each($order->info['tax_groups'])) {
          $tax_rate = tep_get_tax_rate_from_desc($key);
          $net = $tax_rate * $order->info['tax_groups'][$key];
          if ($net > 0) {
            $god_amount = $order->info['tax_groups'][$key] * $ratio1;
            $tod_amount += $god_amount;
            $order->info['tax_groups'][$key] = $order->info['tax_groups'][$key] - $god_amount;
          }
        }
        $order->info['tax'] -= $tod_amount;
        $order->info['total'] -= $tod_amount;
        break;
        case 'Credit Note':
          $tax_rate = tep_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
          $tax_desc = tep_get_tax_description($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
          $tod_amount = $this->deduction / (100 + $tax_rate)* $tax_rate;
          $order->info['tax_groups'][$tax_desc] -= $tod_amount;
//          $order->info['total'] -= $tod_amount;   //// ????? Strider
        break;
        default:
      }
      return $tod_amount;
    }
    function user_has_gv_account($c_id) {
      $gv_query = tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . $c_id . "'");
      if ($gv_result = tep_db_fetch_array($gv_query)) {
        if ($gv_result['amount']>0) {
          return true;
        }
      }
      return false;
    }
    function get_order_total() {
      global $order;
      $order_total = $order->info['total'];
      if ($this->include_tax == 'false') $order_total = $order_total - $order->info['tax'];
      if ($this->include_shipping == 'false') $order_total = $order_total - $order->info['shipping_cost'];
      return $order_total;
    }
    function check() {
      if (!isset($this->check)) {
        $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_ORDER_TOTAL_GV_STATUS'");
        $this->check = tep_db_num_rows($check_query);
      }
      return $this->check;
    }
    function keys() {
      return array('MODULE_ORDER_TOTAL_GV_STATUS', 'MODULE_ORDER_TOTAL_GV_SORT_ORDER', 'MODULE_ORDER_TOTAL_GV_QUEUE', 'MODULE_ORDER_TOTAL_GV_INC_SHIPPING', 'MODULE_ORDER_TOTAL_GV_INC_TAX', 'MODULE_ORDER_TOTAL_GV_CALC_TAX', 'MODULE_ORDER_TOTAL_GV_TAX_CLASS', 'MODULE_ORDER_TOTAL_GV_CREDIT_TAX');
    }
    function install() {
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Display Total', 'MODULE_ORDER_TOTAL_GV_STATUS', 'true', 'Do you want to display the Gift Voucher value?', '6', '1','tep_cfg_select_option(array(\'true\', \'false\'), ', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_ORDER_TOTAL_GV_SORT_ORDER', '5', 'Sort order of display.', '6', '2', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Queue Purchases', 'MODULE_ORDER_TOTAL_GV_QUEUE', 'true', 'Do you want to queue purchases of the Gift Voucher?', '6', '3','tep_cfg_select_option(array(\'true\', \'false\'), ', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Include Shipping', 'MODULE_ORDER_TOTAL_GV_INC_SHIPPING', 'false', 'Include Shipping in calculation', '6', '5', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Include Tax', 'MODULE_ORDER_TOTAL_GV_INC_TAX', 'true', 'Include Tax in calculation.', '6', '6','tep_cfg_select_option(array(\'true\', \'false\'), ', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Re-calculate Tax', 'MODULE_ORDER_TOTAL_GV_CALC_TAX', 'None', 'Re-Calculate Tax', '6', '7','tep_cfg_select_option(array(\'None\', \'Standard\', \'Credit Note\'), ', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Tax Class', 'MODULE_ORDER_TOTAL_GV_TAX_CLASS', '0', 'Use the following tax class when treating Gift Voucher as Credit Note.', '6', '0', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Credit including Tax', 'MODULE_ORDER_TOTAL_GV_CREDIT_TAX', 'false', 'Add tax to purchased Gift Voucher when crediting to Account', '6', '8','tep_cfg_select_option(array(\'true\', \'false\'), ', now())");
    }
    function remove() {
      tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
    }
  }
?>

Spiceupyour · August 18, 2014

Thanks Melanie, for your quick response but it did not work still get the error Invalid Coupon Code

I will pm you.

Thanks

Sam

♥mommaroodles · August 18, 2014

@@Spiceupyour

I've sent you a message telling you what to do and you havent responded yet - as i said to you, I have checked this on my installation and it works, so please read the instructions and check your settings again

Spiceupyour · August 18, 2014

I am so sorry, Just changed from 740 to 9 and thinks started to show up, but now i am have a different problem.

when I try to check out everything looks good with the order total gift voucher is subtracted from the total and the total was is 0.00 on checkout_confirmation.php

when i try to confirm order it send me back to the checkout_payment.php with the error message below

checkout_payment.php?error_message=Please+select+a+payment+method+for+your+order.

you can try if you like

Thanks

I really appreciate your help :)

♥mommaroodles · August 18, 2014

the order total must be more than the gift voucher amount - thats just the way it is code to work so as not to leave credit balances - but if you want to let you customers have credit balances then you can modify the code to suit your store

♥mommaroodles · August 18, 2014

Please note: I have not updated the installation instructions, I simply just dont have the time at the moment - the files uploaded in the latest package are all the correct files.

Teddy K · October 3, 2014

Hi Melanie, I am new to osCommerce. I installed a fresh oscommerce version 2.3.4 and then installed your CCGV addon with Filezilla and phpmyadmin in Cpanel. The issue I am having is that the admin->Vouchers/Coupons is missing. In other words, in the Administration Tool the Voucher/Coupon button does not appear (I assume it should be with the Catalog, Configuration, Customers, etc. buttons). I installed the 2 (gift voucher & discount) modules in Order Total and the Voucher/Coupon button still is not there. Any thoughts on what I may have done wrong? Thanks for your assistance.

austcoll · October 10, 2014

Hi

Does this work with OSC 2.3.4 and Paypal standard?

Thanks

Mitchell

austcoll · October 13, 2014

Hi all

Is there a full package available for download to install on 2.3.4?

Regards

Mitchell

Edited October 13, 2014 by austcoll

naschell81 · October 17, 2014

@@mommaroodles

I'm running into the same thing @@Teddy K had any tips or advice would be greatly appreciated.

Credit Class & Gift Vouchers for 2.3.4

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

mommaroodles

mommaroodles

a.forever

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation