Group pricing field in invoice

[klynn]

First thanks for Zen Cart and the great support forum!!!
I have also installed and using mod Group Pricing (per Item) with no problems.

I would now like the field customers_group_pricing from TABLE_CUSTOMERS to be visible inside admin orders or just the admin printable invoice.

The reason is that the admin should know if the order of the particular customer belongs to a discounted Group pricing group.

It seems the affected files are admin/invoice.php
and maybe admin/includes/classes/order.php
admin/orders.php

The field customers_group_pricing of table CUSTOMERS is what I need to be printed on the invoice (since it is the id of the group. For example Group A has id 2, no discount group customers have id 0).

My problem is that table ORDERS holds the information orders_id and customers_id but it doesn't hold the field customers_group_pricing. So I do not know how to reference the customers_group_pricing from table CUSTOMERS inside admin/invoice.php

[Ajeh]

You could do a search of the customers_id in the orders table and look up their customers_group_pricing to see what id is used ...

On the orders.php you can get the customers_id from the:
$orders->fields['customers_id']

On the invoice.php you need to add to the SELECT statement the customers_id so that it is available to do this look up ...

[klynn]

Thanks a lot, it now works fine.

I only edited file admin/invoice.php where
added there inside the select statement
of $order_check, the field customers_id .

Then below this statement added the code

$xinfocode = "SELECT customers_group_pricing
                  from " . TABLE_CUSTOMERS . "
                  where customers_id ='" . $order_check->fields['customers_id'] . "'";
          $xinfo = $db->Execute($xinfocode);

Then further below where the print outs are, added

<tr>
<td class="main" style="color:#FF0000"><?php echo "Discount Group: "; ?>
<?php if($xinfo->fields['customers_group_pricing']== 2) echo "Wholesale (Group A)";
if($xinfo->fields['customers_group_pricing']== 1) echo "1";
if($xinfo->fields['customers_group_pricing']== 0) echo "Retail";?></td>
</tr>

[Ajeh]

Thanks for the update that you have this working and for posting your solution ...