Group Pricing Question

[Ajeh]

You could customize the file:
/includes/modules/order_total/ot_group_pricing.php

and get the group name to display with the code in RED:

      $order->info['tax'] = $order->info['tax'] - $tax;


// bof: add group pricing name to title
    $group_query = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");
    $group_discount = $db->Execute("select group_name, group_percentage from " . TABLE_GROUP_PRICING . "
                                      where group_id = '" . (int)$group_query->fields['customers_group_pricing'] . "'");

      $this->output[] = array('title' => $this->title . ' ' . $group_discount->fields['group_name'] . ':',
      'text' => '-' . $currencies->format($od_amount['total'], true, $order->info['currency'], $order->info['currency_value']),
      'value' => $od_amount['total']);
// eof: add group pricing name to title

[wiccan0974]

Hi Ajeh - I appreciate your time and effort in helping with this...

I placed the code as shown below, but i keep getting the "white screen of death" each time i insert the code....is there something I missed?

Thanks - Lisa
====================================

// bof: add group pricing name to title
$group_query = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");
$group_discount = $db->Execute("select group_name, group_percentage from " . TABLE_GROUP_PRICING . "
where group_id = '" . (int)$group_query->fields['customers_group_pricing']

$this->output[] = array('title' => $this->title . ':', ' ' . $group_discount->fields['group_name']
'text' => '-' . $currencies->format($od_amount['total'], true, $order->info['currency'], $order->info['currency_value']),
'value' => $od_amount['total']);
// eof: add group pricing name to title
}

[Ajeh]

Change the comma to a period and move the comma to the end of the line:

$this->output[] = array('title' => $this->title . ':', ' ' . $group_discount->fields['group_name'],

[wiccan0974]

I don't know if it is just too early in the morning to follow simple instructions - Im sorry if I am wasting your time Ajeh, I have tried your suggestion, but I can't make it work??....waahh

What am I doing wrong?


// bof: add group pricing name to title
$group_query = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");
$group_discount = $db->Execute("select group_name, group_percentage from " . TABLE_GROUP_PRICING . "
where group_id = '" . (int)$group_query->fields['customers_group_pricing']


$this->output[] = array('title' => $this->title . ':'. ' ' . $group_discount->fields['group_name'],
'text' => '-' . $currencies->format($od_amount['total'], true, $order->info['currency'], $order->info['currency_value']),
'value' => $od_amount['total']);
// eof: add group pricing name to title
}

[Ajeh]

Start over and try this code:

    $group_query = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");
    $group_discount = $db->Execute("select group_name, group_percentage from " . TABLE_GROUP_PRICING . "

    $group_query = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");
    $group_discount = $db->Execute("select group_name, group_percentage from " . TABLE_GROUP_PRICING . "
                                      where group_id = '" . (int)$group_query->fields['customers_group_pricing'] . "'");
      $this->output[] = array('title' => $this->title . ':'  . ' ' . $group_discount->fields['group_name'],
      'text' => '-' . $currencies->format($od_amount['total'], true, $order->info['currency'], $order->info['currency_value']),
      'value' => $od_amount['total']);

[wiccan0974]

Sorry Ajeh, I wish I could give you some "yippees" and "yays", but no....still not working....I completely see where you are going with the code, but I just can't make it work.....

That being said, I am happy to keep trying if you are ;)

Can you check below to make sure I have placed the code correctly?

Thanks - Lisa
=======================================

$order->info['tax'] = $order->info['tax'] - $tax;

// bof: add group pricing name to title
$group_query = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");
$group_discount = $db->Execute("select group_name, group_percentage from " . TABLE_GROUP_PRICING . "

$group_query = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");
$group_discount = $db->Execute("select group_name, group_percentage from " . TABLE_GROUP_PRICING . "
where group_id = '" . (int)$group_query->fields['customers_group_pricing'] . "'");
$this->output[] = array('title' => $this->title . ':' . ' ' . $group_discount->fields['group_name'],
'text' => '-' . $currencies->format($od_amount['total'], true, $order->info['currency'], $order->info['currency_value']),
'value' => $od_amount['total']);

$this->output[] = array('title' => $this->title . ':',
'text' => '-' . $currencies->format($od_amount['total'], true, $order->info['currency'], $order->info['currency_value']),
'value' => $od_amount['total']);
// eof: add group pricing name to title
}
}
function get_order_total() {

[Ajeh]

This is the whole function process:

  function process() {
    global $order, $currencies, $db;
    $order_total = $this->get_order_total();
    $od_amount = $this->calculate_deductions($order_total['total']);
    $this->deduction = $od_amount['total'];
    if ($od_amount['total'] > 0) {
      reset($order->info['tax_groups']);
      $tax = 0;
      while (list($key, $value) = each($order->info['tax_groups'])) {
        if ($od_amount['tax_groups'][$key]) {
          $order->info['tax_groups'][$key] -= $od_amount['tax_groups'][$key];
          $tax += $od_amount['tax_groups'][$key];
        }
      }
      if ($od_amount['type'] == 'S') $order->info['shipping_cost'] = 0;
      $order->info['total'] = $order->info['total'] - $od_amount['total'];
      if (DISPLAY_PRICE_WITH_TAX == 'true') {
        $od_amount['total'] += $tax;
      }
      if ($this->calculate_tax == "Standard") $order->info['total'] -= $tax;
      if ($order->info['total'] < 0) $order->info['total'] = 0;
      $order->info['tax'] = $order->info['tax'] - $tax;

    $group_query = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");
    $group_discount = $db->Execute("select group_name, group_percentage from " . TABLE_GROUP_PRICING . "
                                      where group_id = '" . (int)$group_query->fields['customers_group_pricing'] . "'");
      $this->output[] = array('title' => $this->title . ':'  . ' ' . $group_discount->fields['group_name'],
      'text' => '-' . $currencies->format($od_amount['total'], true, $order->info['currency'], $order->info['currency_value']),
      'value' => $od_amount['total']);

    }
  }