PHP zen_date_long函数代码示例

 function before_process()
 {
     global $order;
     parent::before_process();
     $days = 7;
     if (is_numeric(MODULE_PAYMENT_PAYMILL_ELV_PRENOTIFICATION_DAYS)) {
         $days = MODULE_PAYMENT_PAYMILL_ELV_PRENOTIFICATION_DAYS;
     }
     $date = zen_date_long(date('Y-m-d', strtotime("+{$days} day")) . ' 00:00:00');
     if ($order->info['comments']) {
         $order->info['comments'] .= "\n" . SEPA_DRAWN_TEXT . $date;
     } else {
         $order->info['comments'] = "\n" . SEPA_DRAWN_TEXT . $date;
     }
 }

function email_latest_status($oID)
{
    require DIR_WS_LANGUAGES . $_SESSION['language'] . '/' . 'order_status_email.php';
    global $db;
    $orders_status_array = array();
    $orders_status = $db->Execute("select orders_status_id, orders_status_name\n                                 from " . TABLE_ORDERS_STATUS . "\n                                 where language_id = '" . (int) $_SESSION['languages_id'] . "'");
    while (!$orders_status->EOF) {
        $orders_status_array[$orders_status->fields['orders_status_id']] = $orders_status->fields['orders_status_name'];
        $orders_status->MoveNext();
    }
    $customer_info = $db->Execute("SELECT customers_name, customers_email_address, date_purchased\n                                 FROM " . TABLE_ORDERS . "\n                                 WHERE orders_id = '" . $oID . "'");
    $status_info = $db->Execute("SELECT orders_status_id, comments\n                               FROM " . TABLE_ORDERS_STATUS_HISTORY . "\n                               WHERE orders_id = '" . $oID . "'\n                               ORDER BY date_added Desc limit 1");
    $status = $status_info->fields['orders_status_id'];
    if ($_POST['notify_comments'] == 'on' && zen_not_null($status_info->fields['comments']) && $status_info->fields['comments'] != '') {
        $notify_comments = EMAIL_TEXT_COMMENTS_UPDATE . $status_info->fields['comments'] . "\n\n";
    }
    // send email to customer
    $message = STORE_NAME . " " . 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($customer_info->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;
    $html_msg['EMAIL_CUSTOMERS_NAME'] = $customer_info->fields['customers_name'];
    $html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
    $html_msg['EMAIL_TEXT_INVOICE_URL'] = '<a href="' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . '">' . str_replace(':', '', EMAIL_TEXT_INVOICE_URL) . '</a>';
    $html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($customer_info->fields['date_purchased']);
    $html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);
    $html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\\n', '', EMAIL_TEXT_STATUS_UPDATED);
    $html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\\n', '', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status]));
    $html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
    $html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\\n', '', EMAIL_TEXT_STATUS_PLEASE_REPLY);
    $html_msg['EMAIL_PAYPAL_TRANSID'] = '';
    // End Zen Cart v1.5 Modified Core Code
    zen_mail($customer_info->fields['customers_name'], $customer_info->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
    // PayPal Trans ID, if any
    $sql = "select txn_id, parent_txn_id from " . TABLE_PAYPAL . " where order_id = :orderID order by last_modified DESC, date_added DESC, parent_txn_id DESC, paypal_ipn_id DESC ";
    $sql = $db->bindVars($sql, ':orderID', $oID, 'integer');
    $result = $db->Execute($sql);
    if ($result->RecordCount() > 0) {
        $message .= "\n\n" . ' PayPal Trans ID: ' . $result->fields['txn_id'];
        $html_msg['EMAIL_PAYPAL_TRANSID'] = $result->fields['txn_id'];
    }
    // End Zen Cart v1.5 Modified Core Code
    // send extra emails
    if (SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_STATUS == '1' and SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO != '') {
        zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO, SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' . EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status_extra');
    }
    //_TODO accept an optional array of additional recipients
}

 function updateStatus($pParamHash)
 {
     global $gBitUser;
     $order_updated = false;
     // default to order status if not specified
     $status = !empty($pParamHash['status']) ? zen_db_prepare_input($pParamHash['status']) : $this->getStatus();
     $comments = !empty($pParamHash['comments']) ? zen_db_prepare_input($pParamHash['comments']) : NULL;
     $statusChanged = $this->getStatus() != $status;
     if ($statusChanged || !empty($comments)) {
         $this->StartTrans();
         $this->mDb->query("update " . TABLE_ORDERS . "\n\t\t\t\t\t\t\t\tset `orders_status` = ?, `last_modified` = " . $this->mDb->NOW() . "\n\t\t\t\t\t\t\t\twhere `orders_id` = ?", array($status, $this->mOrdersId));
         $this->info['orders_status_id'] = $status;
         $this->info['orders_status'] = zen_get_order_status_name($status);
         $customer_notified = '0';
         if (isset($pParamHash['notify']) && $pParamHash['notify'] == 'on') {
             $notify_comments = '';
             if (!empty($comments)) {
                 $notify_comments = $comments . "\n\n";
             }
             //send emails
             $textMessage = STORE_NAME . "\n------------------------------------------------------\n" . tra('Order Number') . ': ' . $this->mOrdersId . "\n" . tra('Date Ordered') . ': ' . zen_date_long($this->info['date_purchased']) . "\n" . $this->getDisplayUrl() . "\n\n" . strip_tags($notify_comments);
             if ($statusChanged) {
                 $textMessage .= tra('Your order has been updated to the following status') . ': ' . $this->info['orders_status'] . "\n\n";
             }
             $textMessage .= tra('Please reply to this email if you have any questions.');
             $emailVars['EMAIL_CUSTOMERS_NAME'] = $this->customer['name'];
             $emailVars['EMAIL_TEXT_ORDER_NUMBER'] = tra('Order Number') . ': ' . $this->mOrdersId;
             $emailVars['EMAIL_TEXT_INVOICE_URL'] = $this->getDisplayLink();
             $emailVars['EMAIL_TEXT_DATE_ORDERED'] = tra('Date Ordered') . ': ' . zen_date_long($this->info['date_purchased']);
             $emailVars['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);
             if ($statusChanged) {
                 $emailVars['EMAIL_TEXT_STATUS_UPDATED'] = tra('Your order has been updated to the following status') . ': ';
                 $emailVars['EMAIL_TEXT_NEW_STATUS'] = $this->info['orders_status'];
             }
             $emailVars['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = tra('Please reply to this email if you have any questions.');
             $emailVars['order'] = $this;
             zen_mail($this->customer['name'], $this->customer['email_address'], STORE_NAME . ' ' . tra('Order Update') . ' #' . $this->mOrdersId, $textMessage, STORE_NAME, EMAIL_FROM, $emailVars, 'order_status');
             $customer_notified = '1';
             //send extra emails
             if (SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_STATUS == '1' and SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO != '') {
                 zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO, SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' . EMAIL_TEXT_SUBJECT . ' #' . $this->mOrdersId, $textMessage, STORE_NAME, EMAIL_FROM, $emailVars, 'order_status_extra');
             }
         }
         $this->mDb->query("insert into " . TABLE_ORDERS_STATUS_HISTORY . "\n\t\t\t\t\t\t(`orders_id`, `orders_status_id`, `date_added`, `customer_notified`, `comments`, `user_id`)\n\t\t\t\t\t\tvalues ( ?, ?, ?, ?, ?, ? )", array($this->mOrdersId, $status, $this->mDb->NOW(), $customer_notified, $comments, $gBitUser->mUserId));
         $this->CompleteTrans();
         $order_updated = true;
     }
     return $order_updated;
 }

  </tr>
  <tr>
    <td class="main"><b><?php 
echo ENTRY_ORDER_ID . $oID;
?>
</b></td>
  </tr>
  <tr>
    <td><table border="0" cellspacing="0" cellpadding="2">
      <tr>
        <td class="main"><strong><?php 
echo ENTRY_DATE_PURCHASED;
?>
</strong></td>
        <td class="main"><?php 
echo zen_date_long($order->info['date_purchased']);
?>
</td>
      </tr>
      <tr>
        <td class="main"><b><?php 
echo ENTRY_PAYMENT_METHOD;
?>
</b></td>
        <td class="main"><?php 
echo $order->info['payment_method'];
?>
</td>
      </tr>
    </table></td>
  </tr>

function zen_build_html_email_from_template($module = 'default', $block)
{
    // Identify and Read the template file for the type of message being sent
    $template_filename_base = DIR_FS_EMAIL_TEMPLATES . "email_template_";
    if (file_exists($template_filename_base . str_replace(array('_extra', '_admin'), '', $module) . '.html')) {
        $template_filename = $template_filename_base . str_replace(array('_extra', '_admin'), '', $module) . '.html';
    } elseif (file_exists($template_filename_base . 'default' . '.html')) {
        $template_filename = $template_filename_base . 'default' . '.html';
    } else {
        echo 'ERROR: The email template file for ' . $template_filename_base . ' or ' . $template_filename . ' cannot be found.';
        return '';
        // couldn't find template file, so return an empty string for html message.
    }
    if (!($fh = fopen($template_filename, 'rb'))) {
        // note: the 'b' is for compatibility with Windows systems
        echo 'ERROR: The email template file ' . $template_filename_base . ' or ' . $template_filename . ' cannot be opened';
    }
    $file_holder = fread($fh, filesize($template_filename));
    fclose($fh);
    //strip linebreaks and tabs out of the template
    $file_holder = zen_convert_linefeeds(array("\r\n", "\n", "\r", "\t"), '', $file_holder);
    //check for some specifics that need to be included with all messages
    if ($block['EMAIL_STORE_NAME'] == '') {
        $block['EMAIL_STORE_NAME'] = STORE_NAME;
    }
    if ($block['EMAIL_STORE_URL'] == '') {
        $block['EMAIL_STORE_URL'] = '<a href="' . HTTP_CATALOG_SERVER . DIR_WS_CATALOG . '">' . STORE_NAME . '</a>';
    }
    if ($block['EMAIL_STORE_OWNER'] == '') {
        $block['EMAIL_STORE_OWNER'] = STORE_OWNER;
    }
    if ($block['EMAIL_FOOTER_COPYRIGHT'] == '') {
        $block['EMAIL_FOOTER_COPYRIGHT'] = EMAIL_FOOTER_COPYRIGHT;
    }
    if ($block['EMAIL_DISCLAIMER'] == '') {
        $block['EMAIL_DISCLAIMER'] = sprintf(EMAIL_DISCLAIMER, '<a href="mailto:' . STORE_OWNER_EMAIL_ADDRESS . '">' . STORE_OWNER_EMAIL_ADDRESS . ' </a>');
    }
    if ($block['EMAIL_SPAM_DISCLAIMER'] == '') {
        $block['EMAIL_SPAM_DISCLAIMER'] = EMAIL_SPAM_DISCLAIMER;
    }
    if ($block['BASE_HREF'] == '') {
        $block['BASE_HREF'] = HTTP_SERVER . DIR_WS_CATALOG;
    }
    if ($block['EMAIL_DATE_SHORT'] == '') {
        $block['EMAIL_DATE_SHORT'] = zen_date_short(date("Y-m-d"));
    }
    if ($block['EMAIL_DATE_LONG'] == '') {
        $block['EMAIL_DATE_LONG'] = zen_date_long(date("Y-m-d"));
    }
    if ($block['EXTRA_INFO'] == 'EXTRA_INFO') {
        $block['EXTRA_INFO'] = '';
    }
    if (substr($module, -6) != '_extra' && $module != 'contact_us') {
        $block['EXTRA_INFO'] = '';
    }
    $block['COUPON_BLOCK'] = '';
    if ($block['COUPON_TEXT_VOUCHER_IS'] && $block['COUPON_TEXT_TO_REDEEM']) {
        $block['COUPON_BLOCK'] = '<div class="coupon-block">' . $block['COUPON_TEXT_VOUCHER_IS'] . $block['COUPON_DESCRIPTION'] . '<br />' . $block['COUPON_TEXT_TO_REDEEM'] . '<span class="coupon-code">' . $block['COUPON_CODE'] . '</span></div>';
    }
    $block['GV_BLOCK'] = '';
    if ($block['GV_WORTH'] && $block['GV_REDEEM'] && $block['GV_CODE_URL']) {
        $block['GV_BLOCK'] = '<div class="gv-block">' . $block['GV_WORTH'] . '<br />' . $block['GV_REDEEM'] . $block['GV_CODE_URL'] . '<br />' . $block['GV_LINK_OTHER'] . '</div>';
    }
    //prepare the "unsubscribe" link:
    if (function_exists(zen_catalog_href_link)) {
        $block['UNSUBSCRIBE_LINK'] = str_replace("\n", '', TEXT_UNSUBSCRIBE) . ' <a href="' . zen_catalog_href_link(FILENAME_UNSUBSCRIBE, "unsubscribe_address=" . $block['EMAIL_TO_ADDRESS']) . '">' . zen_catalog_href_link(FILENAME_UNSUBSCRIBE, "unsubscribe_address=" . $block['EMAIL_TO_ADDRESS']) . '</a>';
    } else {
        $block['UNSUBSCRIBE_LINK'] = str_replace("\n", '', TEXT_UNSUBSCRIBE) . ' <a href="' . zen_href_link(FILENAME_UNSUBSCRIBE, "unsubscribe_address=" . $block['EMAIL_TO_ADDRESS']) . '">' . zen_href_link(FILENAME_UNSUBSCRIBE, "unsubscribe_address=" . $block['EMAIL_TO_ADDRESS']) . '</a>';
    }
    //now replace the $BLOCK_NAME items in the template file with the values passed to this function's array
    foreach ($block as $key => $value) {
        $file_holder = str_replace('$' . $key, $value, $file_holder);
    }
    //DEBUG -- to display preview on-screen
    if (EMAIL_SYSTEM_DEBUG == 'on') {
        echo $file_holder;
    }
    return $file_holder;
}

while (!$customers_orders->EOF) {
    //    echo $customers_orders->fields['orders_id'] . ' ' . $customers_orders->fields['order_total'] . '<br />';
    $current_orders_id = $customers_orders->fields['orders_id'];
    $orders_total_query = "select * from " . TABLE_ORDERS_TOTAL . " where orders_id='" . $current_orders_id . "'";
    $orders_total = $db->Execute($orders_total_query);
    $order = new order($customers_orders->fields['orders_id']);
    ?>
          <tr>
            <td colspan="2"><?php 
    echo zen_draw_separator('pixel_trans.gif', '1', '10');
    ?>
</td>
          </tr>
          <tr>
            <td class="main" align="left"><?php 
    echo zen_date_long($customers_orders->fields['date_purchased']);
    ?>
</td>
            <td class="main" align="left">Order #<?php 
    echo $customers_orders->fields['orders_id'];
    ?>
</td>
            <td class="main" align="left">Discount Coupon ID# <?php 
    echo $customers_orders->fields['coupon_code'];
    ?>
</td>
            <td class="main" align="left"><?php 
    echo '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $customers_orders->fields['orders_id'] . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>';
    ?>
</td>
          </tr>

/**
 * select email template based on 'module' (supplied as param to function)
 * selectively go thru each template tag and substitute appropriate text
 * finally, build full html content as "return" output from class
**/
function zen_build_html_email_from_template($module = 'default', $content = '')
{
    global $messageStack, $current_page_base;
    $block = array();
    if (is_array($content)) {
        $block = $content;
    } else {
        $block['EMAIL_MESSAGE_HTML'] = $content;
    }
    // Identify and Read the template file for the type of message being sent
    $langfolder = strtolower($_SESSION['languages_code']) == 'en' ? '' : strtolower($_SESSION['languages_code']) . '/';
    $template_filename_base = DIR_FS_EMAIL_TEMPLATES . $langfolder . "email_template_";
    $template_filename = DIR_FS_EMAIL_TEMPLATES . $langfolder . "email_template_" . $current_page_base . ".html";
    if (!file_exists($template_filename)) {
        if (isset($block['EMAIL_TEMPLATE_FILENAME']) && $block['EMAIL_TEMPLATE_FILENAME'] != '' && file_exists($block['EMAIL_TEMPLATE_FILENAME'] . '.html')) {
            $template_filename = $block['EMAIL_TEMPLATE_FILENAME'] . '.html';
        } elseif (file_exists($template_filename_base . str_replace(array('_extra', '_admin'), '', $module) . '.html')) {
            $template_filename = $template_filename_base . str_replace(array('_extra', '_admin'), '', $module) . '.html';
        } elseif (file_exists($template_filename_base . 'default' . '.html')) {
            $template_filename = $template_filename_base . 'default' . '.html';
        } else {
            $messageStack->add('header', 'ERROR: The email template file for (' . $template_filename_base . ') or (' . $template_filename . ') cannot be found.', 'caution');
            return '';
            // couldn't find template file, so return an empty string for html message.
        }
    }
    if (!($fh = fopen($template_filename, 'rb'))) {
        // note: the 'b' is for compatibility with Windows systems
        $messageStack->add('header', 'ERROR: The email template file (' . $template_filename_base . ') or (' . $template_filename . ') cannot be opened', 'caution');
    }
    $file_holder = fread($fh, filesize($template_filename));
    fclose($fh);
    //strip linebreaks and tabs out of the template
    //  $file_holder = str_replace(array("\r\n", "\n", "\r", "\t"), '', $file_holder);
    $file_holder = str_replace(array("\t"), ' ', $file_holder);
    if (!defined('HTTP_CATALOG_SERVER')) {
        define('HTTP_CATALOG_SERVER', HTTP_SERVER);
    }
    //check for some specifics that need to be included with all messages
    if ($block['EMAIL_STORE_NAME'] == '') {
        $block['EMAIL_STORE_NAME'] = STORE_NAME;
    }
    if ($block['EMAIL_STORE_URL'] == '') {
        $block['EMAIL_STORE_URL'] = '<a href="' . HTTP_CATALOG_SERVER . DIR_WS_CATALOG . '">' . STORE_NAME . '</a>';
    }
    if ($block['EMAIL_STORE_OWNER'] == '') {
        $block['EMAIL_STORE_OWNER'] = STORE_OWNER;
    }
    if ($block['EMAIL_FOOTER_COPYRIGHT'] == '') {
        $block['EMAIL_FOOTER_COPYRIGHT'] = EMAIL_FOOTER_COPYRIGHT;
    }
    if ($block['EMAIL_DISCLAIMER'] == '') {
        $block['EMAIL_DISCLAIMER'] = sprintf(EMAIL_DISCLAIMER, '<a href="mailto:' . STORE_OWNER_EMAIL_ADDRESS . '">' . STORE_OWNER_EMAIL_ADDRESS . ' </a>');
    }
    if ($block['EMAIL_SPAM_DISCLAIMER'] == '') {
        $block['EMAIL_SPAM_DISCLAIMER'] = EMAIL_SPAM_DISCLAIMER;
    }
    if ($block['BASE_HREF'] == '') {
        $block['BASE_HREF'] = HTTP_SERVER . DIR_WS_CATALOG;
    }
    if ($block['EMAIL_DATE_SHORT'] == '') {
        $block['EMAIL_DATE_SHORT'] = zen_date_short(date("Y-m-d"));
    }
    if ($block['EMAIL_DATE_LONG'] == '') {
        $block['EMAIL_DATE_LONG'] = zen_date_long(date("Y-m-d"));
    }
    if ($block['CHARSET'] == '') {
        $block['CHARSET'] = CHARSET;
    }
    //  if ($block['EMAIL_STYLESHEET']=='')       $block['EMAIL_STYLESHEET']       = str_replace(array("\r\n", "\n", "\r"), "",@file_get_contents(DIR_FS_EMAIL_TEMPLATES.'stylesheet.css'));
    if (!isset($block['EXTRA_INFO'])) {
        $block['EXTRA_INFO'] = '';
    }
    if (substr($module, -6) != '_extra' && $module != 'contact_us') {
        $block['EXTRA_INFO'] = '';
    }
    $block['COUPON_BLOCK'] = '';
    if ($block['COUPON_TEXT_VOUCHER_IS'] && $block['COUPON_TEXT_TO_REDEEM']) {
        $block['COUPON_BLOCK'] = '<div class="coupon-block">' . $block['COUPON_TEXT_VOUCHER_IS'] . $block['COUPON_DESCRIPTION'] . '<br />' . $block['COUPON_TEXT_TO_REDEEM'] . '<span class="coupon-code">' . $block['COUPON_CODE'] . '</span></div>';
    }
    $block['GV_BLOCK'] = '';
    if ($block['GV_WORTH'] && $block['GV_REDEEM'] && $block['GV_CODE_URL']) {
        $block['GV_BLOCK'] = '<div class="gv-block">' . $block['GV_WORTH'] . '<br />' . $block['GV_REDEEM'] . $block['GV_CODE_URL'] . '<br />' . $block['GV_LINK_OTHER'] . '</div>';
    }
    //prepare the "unsubscribe" link:
    if (IS_ADMIN_FLAG === true) {
        // is this admin version, or catalog?
        $block['UNSUBSCRIBE_LINK'] = str_replace("\n", '', TEXT_UNSUBSCRIBE) . ' <a href="' . zen_catalog_href_link(FILENAME_UNSUBSCRIBE, "addr=" . $block['EMAIL_TO_ADDRESS']) . '">' . zen_catalog_href_link(FILENAME_UNSUBSCRIBE, "addr=" . $block['EMAIL_TO_ADDRESS']) . '</a>';
    } else {
        $block['UNSUBSCRIBE_LINK'] = str_replace("\n", '', TEXT_UNSUBSCRIBE) . ' <a href="' . zen_href_link(FILENAME_UNSUBSCRIBE, "addr=" . $block['EMAIL_TO_ADDRESS']) . '">' . zen_href_link(FILENAME_UNSUBSCRIBE, "addr=" . $block['EMAIL_TO_ADDRESS']) . '</a>';
    }
    //now replace the $BLOCK_NAME items in the template file with the values passed to this function's array
    foreach ($block as $key => $value) {
        $file_holder = str_replace('$' . $key, $value, $file_holder);
    }
//.........这里部分代码省略.........

 if (PRODUCT_ALL_LIST_WEIGHT != '0' and zen_get_show_product_switch($products_all->fields['products_id'], 'weight')) {
     $display_products_weight = TEXT_PRODUCTS_WEIGHT . $products_all->fields['products_weight'] . TEXT_SHIPPING_WEIGHT . str_repeat('', substr(PRODUCT_ALL_LIST_WEIGHT, 3, 1));
 } else {
     $display_products_weight = '';
 }
 if (PRODUCT_ALL_LIST_QUANTITY != '0' and zen_get_show_product_switch($products_all->fields['products_id'], 'quantity')) {
     if ($products_all->fields['products_quantity'] <= 0) {
         $display_products_quantity = TEXT_OUT_OF_STOCK . str_repeat('', substr(PRODUCT_ALL_LIST_QUANTITY, 3, 1));
     } else {
         $display_products_quantity = TEXT_PRODUCTS_QUANTITY . $products_all->fields['products_quantity'] . str_repeat('', substr(PRODUCT_ALL_LIST_QUANTITY, 3, 1));
     }
 } else {
     $display_products_quantity = '';
 }
 if (PRODUCT_ALL_LIST_DATE_ADDED != '0' and zen_get_show_product_switch($products_all->fields['products_id'], 'date_added')) {
     $display_products_date_added = TEXT_DATE_ADDED . ' ' . zen_date_long($products_all->fields['products_date_added']) . str_repeat('', substr(PRODUCT_ALL_LIST_DATE_ADDED, 3, 1));
 } else {
     $display_products_date_added = '';
 }
 if (PRODUCT_ALL_LIST_MANUFACTURER != '0' and zen_get_show_product_switch($products_all->fields['products_id'], 'manufacturer')) {
     $display_products_manufacturers_name = $products_all->fields['manufacturers_name'] != '' ? TEXT_MANUFACTURER . ' ' . $products_all->fields['manufacturers_name'] . str_repeat('', substr(PRODUCT_ALL_LIST_MANUFACTURER, 3, 1)) : '';
 } else {
     $display_products_manufacturers_name = '';
 }
 if (PRODUCT_ALL_LIST_PRICE != '0' and zen_get_products_allow_add_to_cart($products_all->fields['products_id']) == 'Y' and zen_check_show_prices() == true) {
     $products_price = zen_mb_get_products_display_price($products_all->fields['products_id']);
     $display_products_price = TEXT_PRICE . ' ' . $products_price . str_repeat('', substr(PRODUCT_ALL_LIST_PRICE, 3, 1)) . (zen_get_show_product_switch($products_all->fields['products_id'], 'ALWAYS_FREE_SHIPPING_IMAGE_SWITCH') ? zen_get_product_is_always_free_shipping($products_all->fields['products_id']) ? TEXT_PRODUCT_FREE_SHIPPING_ICON . '<br />' : '' : '');
 } else {
     $display_products_price = '';
     $products_price = '';
 }

                    if (isset($_POST['notify']) && $_POST['notify'] == '1') {
                        $customer_notified = '1';
                    }
                    // Here we check to see if we have clicked on the Hide RadioButton and if so, set the Variable to -1
                    if (isset($_POST['notify']) && $_POST['notify'] == '-1') {
                        // hide comment
                        $customer_notified = '-1';
                    }
                    // OK, we have our Customer Notified Status Number, now update the Order Status History Table
                    update_status($oID, $status, $customer_notified, $comments);
                    //   Send E-Mail to Customer if they should be notified. Send comments if append comments is checked.
                    if ($customer_notified == '1') {
                        if (isset($_POST['notify_comments'])) {
                            $notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $_POST[comments]) . "\n\n";
                        }
                        $email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' <a href="' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . '">' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "</a>\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);
                        $html_msg['EMAIL_MESSAGE_HTML'] = str_replace('
', '<br />', $email);
                        zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_NAME, STORE_OWNER_EMAIL_ADDRESS, $html_msg, NULL);
                    }
                }
                // Update Products
                $RunningSubTotal = 0;
                $RunningTax = 0;
                $update_products = $_POST['update_products'];
                foreach ($update_products as $orders_products_id => $products_details) {
                    $AddedOptionsPrice = 0;
                    $AddedOptionsPrice_OneTime = 0;
                    // Update orders_products Table
                    //UPDATE_INVENTORY_QUANTITY_START##############################################################################################################
                    #$order = zen_db_fetch_array($order_query);

function zen_email_templates_replace_keywords(&$db, $email_contents, &$customers_email, $customers_id)
{
    if ((int) $customers_id) {
        $customers_query = $db->Execute("select * from " . TABLE_CUSTOMERS . " where customers_id = '" . (int) $customers_id . "'");
    } elseif (zen_not_null($customers_email)) {
        $customers_query = $db->Execute("select * from " . TABLE_CUSTOMERS . " where customers_email_address = '" . $customers_email . "'");
    }
    if ($customers_query->RecordCount() > 0 && zen_not_null($email_contents)) {
        $customers = $customers_query->fields;
        $out = $email_contents;
        $out = str_replace('[CUSTOMER_NAME]', stripslashes($customers['customers_firstname'] . ' ' . $customers['customers_lastname']), $out);
        $out = str_replace('[CUSTOMER_EMAIL]', $customers['customers_email_address'], $out);
        $out = str_replace('[CUSTOMER_DOB]', zen_date_long($customers['customers_dob']), $out);
        $out = str_replace('[CUSTOMER_PHONE]', $customers['customers_telephone'], $out);
        $out = str_replace('[CUSTOMER_FAX]', $customers['customers_fax'], $out);
        if (!zen_not_null($customers_email)) {
            $customers_email = $customers['customers_email_address'];
        }
    } else {
        $out = $email_contents;
    }
    return $out;
}

// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to       |
// | license@zen-cart.com so we can mail you a copy immediately.          |
// +----------------------------------------------------------------------+
// | Do Not Remove: Coded for Zen-Cart by geeks4u.com                     |
// | Dedicated to Memory of Amelita "Emmy" Abordo Gelarderes		  |
// +----------------------------------------------------------------------+
// $Id: tpl_more_news_default.php,v 1.2 2004/08/26
//
$newsId = zen_db_prepare_input((int) $_GET['news_id']);
$languages_id = zen_db_prepare_input((int) $_SESSION['languages_id']);
$news_box_query = $db->Execute("select nc.news_title, nc.news_content, n.news_published_date, n.news_end_date\r\n\t\t\t\t\t\t\t\tfrom " . TABLE_BOX_NEWS_CONTENT . " nc, " . TABLE_BOX_NEWS . " n \r\n\t\t\t\t\t\t\t\twhere nc.box_news_id = " . $newsId . " and n.box_news_id = nc.box_news_id and nc.languages_id = " . $languages_id . " and n.news_status = 1 and now() between n.news_start_date and n.news_end_date");
$newsTitle = nl2br($news_box_query->fields['news_title']);
$newsContent = nl2br($news_box_query->fields['news_content']);
if ($newsContent) {
    $newsInfo = TEXT_NEWS_PUBLISHED_DATE . ' ' . zen_date_long($news_box_query->fields['news_published_date']);
} else {
    $newsInfo = TEXT_NO_NEWS_FOR_LANGUAGE;
}
?>

<div class="centerColumn" id="moreNewsDefault">

<h1 id="moreNewsHeading"><?php 
echo HEADING_TITLE . ' ' . $newsTitle;
?>
</h1>

<div class="newsInfo"><?php 
echo $newsInfo;
?>

if ($faqs_new_split->number_of_rows > 0) {
    $faqs_new = $db->Execute($faqs_new_split->sql_query);
    while (!$faqs_new->EOF) {
        $fcPath = zen_get_faq_path($faqs_new->fields['faqs_id']);
        if (FAQ_NEW_LIST_IMAGE != '0') {
            $display_faqs_image = '<a href="' . zen_href_link(zen_get_info_faq_page($faqs_new->fields['faqs_id']), 'fcPath=' . $fcPath . '&faqs_id=' . $faqs_new->fields['faqs_id']) . '">' . zen_image(DIR_WS_IMAGES . $faqs_new->fields['faqs_image'], $faqs_new->fields['faqs_name'], IMAGE_FAQ_NEW_LISTING_WIDTH, IMAGE_FAQ_NEW_LISTING_HEIGHT) . '</a>' . str_repeat('<br clear="all" />', substr(FAQ_NEW_LIST_IMAGE, 3, 1));
        } else {
            $display_faqs_image = '';
        }
        if (FAQ_NEW_LIST_NAME != '0') {
            $display_faqs_name = '<a href="' . zen_href_link(zen_get_info_faq_page($faqs_new->fields['faqs_id']), 'fcPath=' . $fcPath . '&faqs_id=' . $faqs_new->fields['faqs_id']) . '"><strong>' . $faqs_new->fields['faqs_name'] . '</strong></a>' . str_repeat('<br clear="all" />', substr(FAQ_NEW_LIST_NAME, 3, 1));
        } else {
            $display_faqs_name = '';
        }
        if (FAQ_NEW_LIST_DATE_ADDED != '0' and zen_get_show_faq_switch($faqs_new->fields['faqs_id'], 'date_added')) {
            $display_faqs_date_added = TEXT_DATE_ADDED . ' ' . zen_date_long($faqs_new->fields['faqs_date_added']) . str_repeat('<br clear="all" />', substr(FAQ_NEW_LIST_DATE_ADDED, 3, 1));
        } else {
            $display_faqs_date_added = '';
        }
        $link = '<a href="' . zen_href_link(zen_get_info_faq_page($faqs_new->fields['faqs_id']), 'fcPath=' . $fcPath . '&faqs_id=' . $faqs_new->fields['faqs_id']) . '">' . MORE_INFO_TEXT . '</a>';
        $the_button = $link;
        $faqs_link = '<a href="' . zen_href_link(zen_get_info_faq_page($faqs_new->fields['faqs_id']), 'fcPath=' . $fcPath . '&faqs_id=' . $faqs_new->fields['faqs_id']) . '">' . MORE_INFO_TEXT . '</a>';
        if (FAQ_NEW_LIST_DESCRIPTION != '0') {
            $disp_text = zen_get_faqs_description($faqs_new->fields['faqs_id']);
            $disp_text = zen_clean_html($disp_text);
            $display_faqs_description = stripslashes(zen_trunc_string($disp_text, 150, '<a href="' . zen_href_link(zen_get_info_faq_page($faqs_new->fields['faqs_id']), 'fcPath=' . $fcPath . '&faqs_id=' . $faqs_new->fields['faqs_id']) . '"> ' . MORE_INFO_TEXT . '</a>'));
        } else {
            $display_faqs_description = '';
        }
        ?>
          <tr>

function email_latest_status($oID)
{
    require DIR_WS_LANGUAGES . $_SESSION['language'] . '/' . 'order_status_email.php';
    global $db;
    $orders_status_array = array();
    $orders_status = $db->Execute("select orders_status_id, orders_status_name\n                                 from " . TABLE_ORDERS_STATUS . "\n                                 where language_id = '" . (int) $_SESSION['languages_id'] . "'");
    while (!$orders_status->EOF) {
        $orders_status_array[$orders_status->fields['orders_status_id']] = $orders_status->fields['orders_status_name'];
        $orders_status->MoveNext();
    }
    $customer_info = $db->Execute("SELECT customers_name, customers_email_address, date_purchased\n                                 FROM " . TABLE_ORDERS . "\n                                 WHERE orders_id = '" . $oID . "'");
    $status_info = $db->Execute("SELECT orders_status_id, comments\n                               FROM " . TABLE_ORDERS_STATUS_HISTORY . "\n                               WHERE orders_id = '" . $oID . "'\n                               ORDER BY date_added Desc limit 1");
    $status = $status_info->fields['orders_status_id'];
    if (zen_not_null($status_info->fields['comments']) && $status_info->fields['comments'] != '') {
        $notify_comments = EMAIL_TEXT_COMMENTS_UPDATE . $status_info->fields['comments'] . "\n\n";
    }
    // send email to customer
    $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($customer_info->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;
    $html_msg['EMAIL_CUSTOMERS_NAME'] = $customer_info->fields['customers_name'];
    $html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
    $html_msg['EMAIL_TEXT_INVOICE_URL'] = '<a href="' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . '">' . str_replace(':', '', EMAIL_TEXT_INVOICE_URL) . '</a>';
    $html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($customer_info->fields['date_purchased']);
    $html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = $notify_comments;
    $html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\\n', '', EMAIL_TEXT_STATUS_UPDATED);
    $html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\\n', '', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status]));
    $html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
    $html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\\n', '', EMAIL_TEXT_STATUS_PLEASE_REPLY);
    zen_mail($customer_info->fields['customers_name'], $customer_info->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
    // send extra emails
    if (SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_STATUS == '1' and SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO != '') {
        zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO, SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' . EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status_extra');
    }
    //_TODO accept an optional array of additional recipients
}

 if (PRODUCT_SPECIALS_WEIGHT != '0' and zen_get_show_product_switch($specials->fields['products_id'], 'weight')) {
     $display_products_weight = TEXT_PRODUCTS_WEIGHT . $specials->fields['products_weight'] . TEXT_SHIPPING_WEIGHT . str_repeat('', substr(PRODUCT_SPECIALS_WEIGHT, 3, 1));
 } else {
     $display_products_weight = '';
 }
 if (PRODUCT_SPECIALS_QUANTITY != '0' and zen_get_show_product_switch($specials->fields['products_id'], 'quantity')) {
     if ($specials->fields['products_quantity'] <= 0) {
         $display_products_quantity = TEXT_OUT_OF_STOCK . str_repeat('', substr(PRODUCT_SPECIALS_QUANTITY, 3, 1));
     } else {
         $display_products_quantity = TEXT_PRODUCTS_QUANTITY . $specials->fields['products_quantity'] . str_repeat('', substr(PRODUCT_SPECIALS_QUANTITY, 3, 1));
     }
 } else {
     $display_products_quantity = '';
 }
 if (PRODUCT_SPECIALS_DATE_ADDED != '0' and zen_get_show_product_switch($specials->fields['products_id'], 'date_added')) {
     $display_products_date_added = TEXT_DATE_ADDED . ' ' . zen_date_long($specials->fields['products_date_added']) . str_repeat('', substr(PRODUCT_SPECIALS_DATE_ADDED, 3, 1));
 } else {
     $display_products_date_added = '';
 }
 if (PRODUCT_SPECIALS_MANUFACTURER != '0' and zen_get_show_product_switch($specials->fields['products_id'], 'manufacturer')) {
     $display_products_manufacturers_name = $specials->fields['manufacturers_name'] != '' ? TEXT_MANUFACTURER . ' ' . $specials->fields['manufacturers_name'] . str_repeat('', substr(PRODUCT_SPECIALS_MANUFACTURER, 3, 1)) : '';
 } else {
     $display_products_manufacturers_name = '';
 }
 if (PRODUCT_SPECIALS_PRICE != '0' and zen_get_products_allow_add_to_cart($specials->fields['products_id']) == 'Y' and zen_check_show_prices() == true) {
     $products_price = zen_mb_get_products_display_price($specials->fields['products_id']);
     $display_products_price = TEXT_PRICE . ' ' . $products_price . str_repeat('', substr(PRODUCT_SPECIALS_PRICE, 3, 1)) . (zen_get_show_product_switch($specials->fields['products_id'], 'ALWAYS_FREE_SHIPPING_IMAGE_SWITCH') ? zen_get_product_is_always_free_shipping($specials->fields['products_id']) ? TEXT_PRODUCT_FREE_SHIPPING_ICON . '<br />' : '' : '');
 } else {
     $display_products_price = '';
     $products_price = '';
 }

     }
     foreach ($track_id as $id => $track) {
         if (zen_not_null($track) && constant('CARRIER_STATUS_' . $id) == 'True') {
             $notify_comments .= "Your " . constant('CARRIER_NAME_' . $id) . " Tracking ID is " . $track . " \n<br /><a href=" . constant('CARRIER_LINK_' . $id) . $track . ">Click here</a> to track your package. \n<br />If the above link does not work, copy the following URL address and paste it into your Web browser. \n<br />" . constant('CARRIER_LINK_' . $id) . $track . "\n\n<br /><br />It may take up to 24 hours for the tracking information to appear on the website." . "\n<br />";
         }
     }
     unset($id);
     unset($track);
     // END TY TRACKER 32 - EMAIL TRACKING INFORMATION
 }
 //send emails
 $message = STORE_NAME . " " . 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;
 $html_msg['EMAIL_CUSTOMERS_NAME'] = $check_status->fields['customers_name'];
 $html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
 $html_msg['EMAIL_TEXT_INVOICE_URL'] = '<a href="' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . '">' . str_replace(':', '', EMAIL_TEXT_INVOICE_URL) . '</a>';
 $html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
 $html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);
 $html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\\n', '', EMAIL_TEXT_STATUS_UPDATED);
 $html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\\n', '', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status]));
 $html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
 $html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\\n', '', EMAIL_TEXT_STATUS_PLEASE_REPLY);
 $html_msg['EMAIL_PAYPAL_TRANSID'] = '';
 zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
 $customer_notified = '1';
 // PayPal Trans ID, if any
 $sql = "select txn_id, parent_txn_id from " . TABLE_PAYPAL . " where order_id = :orderID order by last_modified DESC, date_added DESC, parent_txn_id DESC, paypal_ipn_id DESC ";
 $sql = $db->bindVars($sql, ':orderID', $oID, 'integer');
 $result = $db->Execute($sql);
 if ($result->RecordCount() > 0) {
     $message .= "\n\n" . ' PayPal Trans ID: ' . $result->fields['txn_id'];
     $html_msg['EMAIL_PAYPAL_TRANSID'] = $result->fields['txn_id'];