small mod

**mat123slade** · 01-18-2005, 03:17 AM

Hi,

I'm trying to add a field in the Order Page in the admin, I would like a column to show the name of the user group (Retailer, Shop, wholesaler etc) that I have set up with Seperate Price Per Customer.

I have so far come up with this :

I'm adding the column name here (for people interested admin/orders.php) :

Code:

  &lt;tr class="dataTableHeadingRow">
     &lt;td class="dataTableHeadingContent" width='30'>&lt;?php echo 'ID #'; ?>&lt;/td>
     &lt;td class="dataTableHeadingContent">Group&lt;/td>
               &lt;td class="dataTableHeadingContent">&lt;?php echo TABLE_HEADING_CUSTOMERS; ?>&lt;/td>
   &lt;td class="dataTableHeadingContent" align="right">&lt;?php echo TABLE_HEADING_ORDER_TOTAL; ?>&lt;/td>
               &lt;td class="dataTableHeadingContent" align="center">&lt;?php echo TABLE_HEADING_DATE_PURCHASED; ?>&lt;/td>
               &lt;td class="dataTableHeadingContent" align="right">&lt;?php echo TABLE_HEADING_STATUS; ?>&lt;/td>
               &lt;td class="dataTableHeadingContent" align="right">&lt;?php echo TABLE_HEADING_ACTION; ?>&amp;nbsp;&lt;/td>
             &lt;/tr>

I haven't bothered with language, Group will do fine (ID # is so I can show the ID number of the order, that might help somebody out).

And for the content :

Code:

&lt;td class="&lt;?php echo $current_row; ?>">&lt;?php echo '&lt;font face=verdana size=1>' . $orders&#91;'orders_id'&#93;; ?>&lt;/font>&lt;/td>
   &lt;td class="&lt;?php echo $current_row; ?>">&lt;?php echo '' . $customers&#91;'customers_group_id'&#93;; ?>&lt;/font>&lt;/td>
   &lt;td class="dataTableContent">&lt;?php echo '&lt;a href="' . tep_href_link&#40;FILENAME_ORDERS, tep_get_all_get_params&#40;array&#40;'oID', 'action'&#41;&#41; . 'oID=' . $orders&#91;'orders_id'&#93; . '&amp;action=edit'&#41; . '">' . tep_image&#40;DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW&#41; . '&lt;/a>&amp;nbsp;' . $orders&#91;'customers_name'&#93;; ?>&lt;/td>
   &lt;td class="dataTableContent" align="right">&lt;?php echo strip_tags&#40;$orders&#91;'order_total'&#93;&#41;; ?>&lt;/td>
               &lt;td class="dataTableContent" align="center">&lt;?php echo tep_datetime_short&#40;$orders&#91;'date_purchased'&#93;&#41;; ?>&lt;/td>
               &lt;td class="dataTableContent" align="right">&lt;?php echo $orders&#91;'orders_status_name'&#93;; ?>&lt;/td>
               &lt;td class="dataTableContent" align="right">&lt;?php if &#40;isset&#40;$oInfo&#41; &amp;&amp; is_object&#40;$oInfo&#41; &amp;&amp; &#40;$orders&#91;'orders_id'&#93; == $oInfo->orders_id&#41;&#41; &#123; echo tep_image&#40;DIR_WS_IMAGES . 'icon_arrow_right.gif', ''&#41;; &#125; else &#123; echo '&lt;a href="' . tep_href_link&#40;FILENAME_ORDERS, tep_get_all_get_params&#40;array&#40;'oID'&#41;&#41; . 'oID=' . $orders&#91;'orders_id'&#93;&#41; . '">' . tep_image&#40;DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO&#41; . '&lt;/a>'; &#125; ?>&amp;nbsp;&lt;/td>

So the bit of code that I have got wrong is

Code:

&lt;?php echo '' . $customers&#91;'customers_group_id'&#93;; ?>
Anyone know what I should put here ?

Actualy I think it might be correct, but I have been told I am calling the group_id from the TABLE_ORDERS, which does not contain a group_id. I must call it from the TABLE_CUSTOMERS. The problem is, I'm not sure how to go about that.

Anyone have an idea?
I'm sure there isn't much more to do so that it works, it must be simple...

Thanx a lot.

[edited by admin]

**michael_s** · 01-18-2005, 08:13 AM

Hi,

Please refernence the forum rules. Requesting quotes for paid work is against the posting rules. Please refrain from doing so, as it undermines the purpose of this forum - namely FREE help.

I will take a look at your problem today and see what I can come up with. It looks to be very simple to do.