Customer Comments on Invoice

[welshop.com]

Hi

In previous versions of ZenCart (1.2.6) I had the Invoice configured to show customer comments. I think Dr Byte gave me the info and was as follows

<!--add comment starts-->
<tr><td class="main"><?php echo '<b>Customer comments: </b>' . $orders_history->fields['comments']; ?></td>
</tr>
<!--add comment ends-->

Having just upgraded to 1.3.7 this code no longer works. I have been playing with it for ages now and nothing is working so I thought I would throw this one out to the Community to see if anyone has an answer

Cheers
Brinley

[welshop.com]

Worked it out!

I fogot to add the select query to the page

So for anyone else who wants to do this the below goes above the $order_check statement in Invoice.php in Admin

//--Add comments starts--
$orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, comments
from " . TABLE_ORDERS_STATUS_HISTORY . "
where orders_id = '" . zen_db_input($oID) . "'
order by date_added limit 1");
//--Add comments ends--

Also add the below code to the page -

<!--add comment starts-->
<tr><td class="main"><?php echo '<b>Customer comments: </b>' . $orders_history->fields['comments']; ?></td>
</tr>
<!--add comment ends-->

Cheers
Brinley

[snarkys]

thank you : )

[tatiana77]

Update on your helpful suggestion, just in case someone's wondering, this is the first part of your code, but I added the <?php, ?> to it..

<?php
//--Add comments starts--
$orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, comments
from " . TABLE_ORDERS_STATUS_HISTORY . "
where orders_id = '" . zen_db_input($oID) . "'
order by date_added limit 1");
//--Add comments ends--
?>

Haven't tried it out yet though, but looks helpful.

[snarkys]

very helpfull for us because we ship off these.

[Stormshade]

This was one of the answers I came looking for. Thank you. Gonna go try it out.

[Ajeh]

NOTE: this feature has been added as an option in the upcoming Zen Cart v1.3.8 ...

Display Order Comments on Admin Invoice
Do you want to display the Order Comments on the Admin Invoice?
0= OFF
1= First Comment by Customer only
2= All Comment for the Order

And of course for the Packing Slip as well ...

[Taipa]

NOTE: this feature has been added as an option in the upcoming Zen Cart v1.3.8 ...


And of course for the Packing Slip as well ...

Awesome! Thank you! ^_^

[Thieving_Gypsy]

Quick update on this one - remove the limit 1 from the SQL statement then add the following code to display all the customer comments on the packing slip - not just the first...

<?php
	while (!$orders_history->EOF) {
		echo(zen_date_long($orders_history->fields['date_added']) . ": " . $orders_history->fields['comments'] . "<br>"); 
		$orders_history->MoveNext();
	}

?>

Hope this helps someone...

[AlanQ]

Another Thank You.
I came looking for this answer -- and found it here