How to display a comments in orders.php?

[nicmare]

I inserted a new column "Comments" in orders.php.

 

The heading isn't the problem. But the contentcells are empty. Look at the screenshot please.

 

i tried to make it this way near line 380:

<td class="dataTableContent" align="left"><?php echo $orders['comments']; ?></td>

 

but it doesnt work because the database query is missing.

who do i add it to the script?

[nicmare]

here's the code:

<td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $orders['orders_id'] . '&action=edit') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $orders['customers_name']; ?></td>
			<td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>
			<td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>	
	<td class="dataTableContent" align="left">$orders_status_history['comments']</td>
			<td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>
			<td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>
		  </tr>

so what's wrong?

he does not display $orders_status_history['comments']

[insomniac2]

The problem with placing the comments in your main admin screen table is that if the comments are long ... it will throw your whole table out of whack.

 

I would suggest using the mod CommentsAtAGlance .. which will show you a bubble icon if there are comments with an order.

 

by putting your mouse over the talkbubble icon .. you will see any and all comments related to that order.

 

Link:

http://www.oscommerce.com/community/contri...mmentsataglance

[nicmare]

awesome contribution. thanks for your advice!