Jump to content
Latest News: (loading..)
T. Thomas

Credit Class & Gift Vouchers for 2.3.4

Recommended Posts

I am actually trying to get ccgv to work with osc 2.3.4.

I seem to be having one issue. If I use a gift certificate and it covers the entire amount then I get to the checkout_confirmation but without any payment method selected (probably intended?)

But then when I click to confirm the order, I am trown back to the checkout payment with the message that no payment method has been selected.

 

 

I have another issue. I also use quantity discounts, but it doesn't make sense to have quantity discounts when buying a gift certificate since the quantity discount is also applied when using it. Currently I am without any ideas how to solve this.

Share this post


Link to post
Share on other sites

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.

 

  1. Coupon Admin now uses the jQuery date picker to select the start and expiry dates of the coupons.
  2. coupon_admin.php file has been cleaned up and a lot of unnecessary code has been removed.
  3. 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
  4. All the buttons are also jQuery buttons.
  5. You can set a discount coupon "Active" or  "Inactive"
  6. CCGV now has its own link and settings in the Configuration tab.
  7. You can also set the length of the auto generated coupon code and gift voucher code in admin.
  8. The content which was in the add_ccgvdc_application_top.php in both catalog and admin have been moved to their correct respective files.
  9. The content which was in the add_ccgvdc_english.php in both catalog and admin have been moved to their correct respective files.
  10. 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.
  11.  $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


"The doorstep to the temple of wisdom is a knowledge of our own ignorance."

Share this post


Link to post
Share on other sites

@@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


"The doorstep to the temple of wisdom is a knowledge of our own ignorance."

Share this post


Link to post
Share on other sites

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 by Spiceupyour

Share this post


Link to post
Share on other sites

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 by Spiceupyour

Share this post


Link to post
Share on other sites

 

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.


"The doorstep to the temple of wisdom is a knowledge of our own ignorance."

Share this post


Link to post
Share on other sites

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 by Spiceupyour

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

 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?

Share this post


Link to post
Share on other sites

@@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.


"The doorstep to the temple of wisdom is a knowledge of our own ignorance."

Share this post


Link to post
Share on other sites

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()) . "')");
    }
  }
?>


"The doorstep to the temple of wisdom is a knowledge of our own ignorance."

Share this post


Link to post
Share on other sites

@@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


"The doorstep to the temple of wisdom is a knowledge of our own ignorance."

Share this post


Link to post
Share on other sites

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  :)


Share this post


Link to post
Share on other sites

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


"The doorstep to the temple of wisdom is a knowledge of our own ignorance."

Share this post


Link to post
Share on other sites

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.


"The doorstep to the temple of wisdom is a knowledge of our own ignorance."

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Hi all 

 

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

 

Regards

Mitchell

Edited by austcoll

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×