Adding order details to status update email

[nosnappyname]

My client wants to include the details shown on the order confirmation email (products, sub-total, shipping tax and total) to each email sent as a result of a status update.

Any ideas which table I should use and if there is some code I can model a solution on?

[kobra]

You will have to look towards the files that recall the order in the admin side and copy the snippits that you need

[ccoff]

ilikeyourarticleverymuch。

[haasPlay]

I am need of this as well and have made some progress but have hit a roadblock... wondering if anyone can help me out.

in admin/orders.php I have changed

$order_updated = false;

        $check_status = $db->Execute("select customers_name, customers_email_address, orders_status,

                                      date_purchased from " . TABLE_ORDERS . "

                                      where orders_id = '" . (int)$oID . "'");

to

$order_updated = false;

        $check_status = $db->Execute("select o.customers_name, o.customers_email_address, o.delivery_name, o.delivery_company, o.delivery_street_address, o.delivery_suburb, o.delivery_city, o.delivery_postcode, o.delivery_state, o.delivery_country, o.orders_status,

                                      op.products_name, op.products_price,
                                      o.date_purchased 
                                      from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op
                                      where o.orders_id = op.orders_id 

                                      and o.orders_id = '" . (int)$oID . "'");

and further down changed

$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] ) .

          EMAIL_TEXT_STATUS_PLEASE_REPLY;

to:

$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] ) .
          EMAIL_TEXT_DELIVERY_ADDRESS . "\n" . $check_status->fields['delivery_name'] . "\n" . $check_status->fields['delivery_street_address'] . "\n"  . $check_status->fields['delivery_city'] . "," .  $check_status->fields['delivery_state'] . " " . $check_status->fields['delivery_postcode'] . "\n" . $check_status->fields['delivery_country'] . "\n" . $check_status->fields['delivery_suburb'] . "\n" .

          EMAIL_TEXT_COMPANY . $check_status->fields['delivery_company'] . "\n\n" .
          EMAIL_TEXT_PRODUCTS_ORDERED . "\n" . $check_status->fields['products_name'] . "  " . $check_status->fields['products_price'] . "\n\n" .
          EMAIL_TEXT_STATUS_PLEASE_REPLY;

This works if there is only one product in the order that has no attributes. Problem I am having is trying to insert this bit to get loop, quantities, attributes etc.:

<?php

    for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {

      echo '          <tr class="dataTableRow">' . "\n" .

           '            <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . '&nbsp;x</td>' . "\n" .

           '            <td class="dataTableContent" valign="top">' . $order->products[$i]['name'];



      if (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {

        for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {

          echo '<br /><nobr><small>&nbsp;<i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . nl2br(zen_output_string_protected($order->products[$i]['attributes'][$j]['value']));

          if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';

          if ($order->products[$i]['attributes'][$j]['product_attribute_is_free'] == '1' and $order->products[$i]['product_is_free'] == '1') echo TEXT_INFO_ATTRIBUTE_FREE;

          echo '</i></small></nobr>';

        }

      }



      echo '            </td>' . "\n" .

           '            <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" .

           '            <td class="dataTableContent" align="right" valign="top">' . zen_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" .

           '            <td class="dataTableContent" align="right" valign="top"><strong>' .

                          $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) .

                          ($order->products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->format($order->products[$i]['onetime_charges'], true, $order->info['currency'], $order->info['currency_value']) : '') .

                        '</strong></td>' . "\n" .

           '            <td class="dataTableContent" align="right" valign="top"><strong>' .

                          $currencies->format(zen_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) .

                          ($order->products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->format(zen_add_tax($order->products[$i]['onetime_charges'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) : '') .

                        '</strong></td>' . "\n" .

           '            <td class="dataTableContent" align="right" valign="top"><strong>' .

                          $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) .

                          ($order->products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->format($order->products[$i]['onetime_charges'], true, $order->info['currency'], $order->info['currency_value']) : '') .

                        '</strong></td>' . "\n" .

           '            <td class="dataTableContent" align="right" valign="top"><strong>' .

                          $currencies->format(zen_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) .

                          ($order->products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->format(zen_add_tax($order->products[$i]['onetime_charges'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) : '') .

                        '</strong></td>' . "\n";

      echo '          </tr>' . "\n";

    }

?>

Any tips on inserting this into the email would be greatly appreciated! Thanks!