Hide admin order comments from customer

[Sudakoma]

Hi,

I often use the order comments box to keep notes for my own personal use about a particular order.

I recently found out from another thread that all these comments can be viewed by the customer if they view their order history

If there any way these comments can be hidden unless the 'notify customer' field is ticked?

Thanks

[Ajeh]

This is not a feature of Zen Cart at this time, but you could build this into the comments and customize the catalog to not show these marked comments to the customer ...

[Sudakoma]

Thanks for the quick reply Linda.

Can you be a bit more specific how this can be achieved?

[Ajeh]

You would need to edit the file:
/includes/modules/pages/account_history_info/header_php.php

And change the select statement to not include those that were not sent to the customer ...

This select is grabbing all of the history ...

$statuses_query = "SELECT os.orders_status_name, osh.date_added, osh.comments
                   FROM   " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh
                   WHERE      osh.orders_id = :ordersID
                   AND        osh.orders_status_id = os.orders_status_id
                   AND        os.language_id = :languagesID
                   ORDER BY   osh.date_added"; 

[Sudakoma]

Thanks, i'll give that a try

[philc]

Thanks Linda for providing the file and the PHP code that needed to be edited.

$statuses_query = "SELECT os.orders_status_name, osh.date_added, osh.comments
FROM " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh
WHERE osh.orders_id = :ordersID
AND osh.orders_status_id = os.orders_status_id
AND os.language_id = :languagesID
ORDER BY osh.date_added";


Added (AND osh.customer_notified ='1' ) to the file above. And now if I do not tic the notifiy customer box it does not show in the customers account under "Status History & Comments".

$statuses_query = "SELECT os.orders_status_name, osh.date_added, osh.comments
FROM " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh
WHERE osh.orders_id = :ordersID
AND osh.customer_notified ='1'
AND osh.orders_status_id = os.orders_status_id
AND os.language_id = :languagesID
ORDER BY osh.date_added";

[philc]

Linda,

Just sent you a pot of coffee.

Thanks again

[Ajeh]

Thanks very much for the support ... we really appreciate it ...

That helps us so much and I am very glad that this could help you in adding this feature ...

[Carbonless]

-edited- do you know how soon this might be a regular feature of ZC?

[Ajeh]

It is on the list of things to do ... but it is not a pressing feature ...

You might be best having this customized for your site ... there are many ways to approach this and you can do a simple limitation of all but customer is seen by customer vs a more useful change where you can control what the customer sees and does not see ...

If you get stuck, you can drop me a PM if need be ...