Originally Posted by
Ajeh
You could add the field from the orders table to the select statement around line 90:
PHP Code:
$check_status = $db->Execute("select customers_name, customers_email_address, orders_status,
date_purchased, order_total from " . TABLE_ORDERS . "
where orders_id = '" . (int)$oID . "'");
Then you can use it with:
$check_status->fields['order_total']
And add the currency conversion for that and add it to the TEXT and HTML email below that ...
I can't get it work, what am I missing?
Code:
$check_status = $db->Execute("select customers_name, customers_email_address, orders_status,
date_purchased from " . TABLE_ORDERS . "
where orders_id = '" . (int)$oID . "'");
if ( ($check_status->fields['orders_status'] != $status) || zen_not_null($comments)) {
$db->Execute("update " . TABLE_ORDERS . "
set orders_status = '" . zen_db_input($status) . "', last_modified = now()
where orders_id = '" . (int)$oID . "'");
$notify_comments = '';
if (isset($_POST['notify_comments']) && ($_POST['notify_comments'] == 'on') && zen_not_null($comments)) {
$notify_comments = EMAIL_TEXT_COMMENTS_UPDATE . $comments . "\n\n";
}
//send emails
$message = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" .
EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n\n" .
EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
strip_tags($notify_comments) .
EMAIL_TEXT_STATUS_UPDATED . sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ) . "\n\n" . $check_status->fields['order_total'] . "\n\n" .
EMAIL_TEXT_STATUS_PLEASE_REPLY;
Is that also possible for just one particular order status update?
Bookmarks