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); } //DEBUG -- to display preview on-screen if (EMAIL_SYSTEM_DEBUG == 'preview') { echo $file_holder; } return $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'];
// orders note if($nInfo->orders_id > 0) $contents[] = array('text' => '<a href="' . FILENAME_ORDERS . '.php' . '?oID=' . $nInfo->orders_id . '&action=edit' . '"><strong>' . TEXT_INFO_NOTE_ORDER . '</strong></a>'); if(zen_not_null($nInfo->categories_id)) $contents[] = array('text' => '<a href="' . FILENAME_CATEGORIES . '.php' . '?cPath=' . $nInfo->categories_id . '"><strong>' . TEXT_INFO_NOTE_CATEGORY . '</strong></a>'); // products note if($nInfo->products_id > 0) $contents[] = array('text' => '<a href="' . FILENAME_PRODUCT . '.php' . '?action=new_product&pID=' . $nInfo->products_id . '&product_type=' . zen_get_products_type($nInfo->products_id) . '&cPath=' . zen_get_products_category_id($nInfo->products_id) . '"><strong>' . TEXT_INFO_NOTE_PRODUCT . '</strong></a>'); // eof note links $contents[] = array('text' => '<br />' . TEXT_INFO_NOTE_TEXT . '<p style="font-weight: bold; ">' . nl2br(stripslashes($nInfo->notes_text)) . '</p>'); $contents[] = array('text' => '<br />' . TEXT_INFO_DATE_CREATED . zen_date_long($nInfo->notes_date_created)); if (zen_not_null($nInfo->notes_date_modified)) $contents[] = array('text' => TEXT_INFO_NOTE_DATE_MODIFIED . ': ' . zen_date_long($nInfo->notes_date_modified)); } break; } if ( (zen_not_null($heading)) && (zen_not_null($contents)) ) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box; echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?> </tr>
function convert_product_result($fields) { $fields['path_image'] = self::get_product_path_image($fields); $fields['name'] = $fields['products_name']; $fields['url'] = zen_href_link(zen_get_info_page($fields['products_id']), 'products_id=' . $fields['products_id'] . '&categories_id=' . $this->search_params['categories_id']); $fields['description'] = zen_trunc_string(zen_clean_html(stripslashes($fields['products_description']), PRODUCT_LIST_DESCRIPTION)); $fields['model'] = $fields['products_model']; $fields['quantity'] = $fields['products_quantity']; $fields['date_added'] = zen_date_long($fields['products_date_added']); $fields['price'] = $fields['products_price']; #FIXME $fields['final_price'] = zen_get_products_display_price($fields['products_id']); $fields['cart_button'] = self::get_product_cart_button($fields); $categories = self::get_product_categories($fields['products_id']); foreach ($categories as $category_id) { $fields['categories_path'][] = self::get_categories_path($category_id, self::get_super_products_list_link('results')); } $fields['always_free_shipping'] = $fields['product_is_always_free_shipping']; return $fields; }
?> </td> </tr> <tr> <td colspan="2" class="pageHeading"><?php echo $reviews->fields['products_name']; ?> </td> </tr> <tr> <td class="smallText"><?php echo sprintf(TEXT_REVIEW_BY, zen_output_string_protected($reviews->fields['customers_name'])); ?> </td> <td class="smallText" align="left"><?php echo sprintf(TEXT_REVIEW_DATE_ADDED, zen_date_long($reviews->fields['date_added'])); ?> </td> </tr> <tr> <td width="<?php echo SMALL_IMAGE_WIDTH + 10; ?> " align="left" valign="top" class="main"><?php echo '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $reviews->fields['products_id'] . '&reviews_id=' . $reviews->fields['reviews_id']) . '">' . zen_image(CommerceProduct::getImageUrlFromHash($reviews->fields['products_id'], 'avatar'), $reviews->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; ?> </td> <td valign="top" class="main"><?php echo zen_break_string(nl2br(zen_output_string_protected(stripslashes(substr($reviews->fields['reviews_text'], 0, 100)))), 60, '-<br />') . (strlen($reviews->fields['reviews_text']) >= 100 ? '..' : '') . '<br /><br /><i>' . sprintf(TEXT_REVIEW_RATING, zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $reviews->fields['reviews_rating'] . '.png', sprintf(TEXT_OF_5_STARS, $reviews->fields['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $reviews->fields['reviews_rating'])) . '</i>'; ?> </td>
* @package page * @copyright Copyright 2010 oasis Team * @copyright Portions 2003-2006 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: header_php.php 5403 2010-03-30 13:35:58Z john $ */ // This should be first line of the script: $zco_notifier->notify('NOTIFY_HEADER_START_PRINT_ORDER'); // check if custmer is allowed to see this order! $order_query_check = $db->Execute("SELECT\tcustomers_id\n\t\t\t\t\t\t\t\t\t\tFROM " . TABLE_ORDERS . "\n\t\t\t\t\t\t\t\t\t\tWHERE orders_id='" . (int) $_GET['oID'] . "'"); $oID = (int) $_GET['oID']; if ($order_query_check->RecordCount() > 0) { if ($_SESSION['customer_id'] == $order_query_check->fields['customers_id']) { require DIR_WS_MODULES . zen_get_module_directory('require_languages.php'); // get order data require DIR_WS_CLASSES . 'order.php'; $print_order = new order($oID); $address_label_customer = zen_address_format($print_order->customer['format_id'], $print_order->customer, 1, '', '<br />'); $address_label_shipping = zen_address_format($print_order->delivery['format_id'], $print_order->delivery, 1, '', '<br />'); $address_label_payment = zen_address_format($print_order->billing['format_id'], $print_order->billing, 1, '', '<br />'); $csID = $print_order->customer['csID']; $language = $_SESSION['language']; if ($print_order->info['payment_method'] != '' && $print_order->info['payment_method'] != 'no_payment') { include DIR_WS_LANGUAGES . $_SESSION['language'] . '/modules/payment/' . $print_order->print_order['payment_method'] . '.php'; $payment_method = constant(strtoupper('MODULE_PAYMENT_' . $print_order->info['payment_method'] . '_TEXT_TITLE')); } $comment = $print_order->info['comments']; $date = zen_date_long($print_order->info['date_purchased']); } }
} ?> <tr> <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <?php if ($pInfo->products_date_available > date('Y-m-d')) { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_AVAILABLE, zen_date_long($pInfo->products_date_available)); ?></td> </tr> <?php } else { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_ADDED, zen_date_long($pInfo->products_date_added)); ?></td> </tr> <?php } ?> <tr> <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <?php } if (isset($_GET['read']) && ($_GET['read'] == 'only')) { if (isset($_GET['origin'])) { $pos_params = strpos($_GET['origin'], '?', 0); if ($pos_params != false) { $back_url = substr($_GET['origin'], 0, $pos_params);
echo TEXT_ORDER_NUMBER . $history['orders_id']; ?> </legend> <div> </div> <div> <div class="col-sm-7" > <span class='visible-xs'><strong><?php echo TEXT_ORDER_STATUS; ?> </strong><span class='text-info'><?php echo $history['orders_status_name']; ?> </span></span> <?php echo '<strong>' . TEXT_ORDER_DATE . '</strong> ' . zen_date_long($history['date_purchased']) . '<br /><strong>' . $history['order_type'] . '</strong> ' . zen_output_string_protected($history['order_name']); ?> <br /> <?php echo '<strong>' . TEXT_ORDER_PRODUCTS . '</strong> ' . $history['product_count'] . '<br /><strong>' . TEXT_ORDER_COST . '</strong> ' . strip_tags($history['order_total']); ?> </div> <div class="col-sm-5 text-center"> <span class='hidden-xs'><strong><?php echo TEXT_ORDER_STATUS; ?> </strong><span class='text-info'><?php echo $history['orders_status_name']; ?> </span></span> <br />
</tr> <?php if ($pInfo->products_date_available > date('Y-m-d')) { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_AVAILABLE, zen_date_long($pInfo->products_date_available)); ?> </td> </tr> <?php } else { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_ADDED, zen_date_long($pInfo->products_date_added)); ?> </td> </tr> <?php } ?> <tr> <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?> </td> </tr> <?php } if (isset($_GET['read']) && $_GET['read'] == 'only') {
function draw_packing_slip_order($order, &$pdf) { global $db; require_once DIR_WS_CLASSES . 'currencies.php'; $currencies = new currencies(); // prepare order-status pulldown list $orders_statuses = array(); $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_statuses[] = array('id' => $orders_status->fields['orders_status_id'], 'text' => $orders_status->fields['orders_status_name'] . ' [' . $orders_status->fields['orders_status_id'] . ']'); $orders_status_array[$orders_status->fields['orders_status_id']] = $orders_status->fields['orders_status_name']; $orders_status->MoveNext(); } /* display order information header */ $pdf->SetFont('Arial', 'B', 6); /* order object doesn't include orderid. added id to info so we can retrieve it here */ $pdf->Cell(120, 14, ENTRY_ORDER_ID . $order->info['id']); $pdf->Cell(236, 14, ENTRY_DATE_PURCHASED . ' ' . zen_date_long($order->info['date_purchased'])); $pdf->MultiCell(220, 14, ENTRY_PAYMENT_METHOD . ' ' . $order->info['payment_method']); $pdf->SetFont('Arial', '', 10); if (TAX_ID_NUMBER != '') { $pdf->SetFillColor(180, 180, 180); $pdf->Cell(30, 14, TABLE_HEADING_QTY, 1, 0, '', 1); $pdf->Cell(160, 14, TABLE_HEADING_PRODUCTS, 1, 0, '', 1); $pdf->Cell(160, 14, TABLE_HEADING_PRODUCTS_MODEL, 1, 0, '', 1); $pdf->Cell(60, 14, TABLE_HEADING_TAX, 1, 0, '', 1); $pdf->Cell(78, 14, TABLE_HEADING_PRICE_NO_TAX, 1, 0, 'R', 1); $pdf->MultiCell(78, 14, TABLE_HEADING_TOTAL_NO_TAX, 1, 'R', 1); } else { $pdf->SetFillColor(180, 180, 180); $pdf->Cell(25, 14, TABLE_HEADING_QTY, 1, 0, '', 1); $pdf->Cell(120, 14, TABLE_HEADING_PRODUCTS, 1, 0, '', 1); $pdf->Cell(120, 14, TABLE_HEADING_PRODUCTS_MODEL, 1, 0, '', 1); $pdf->Cell(40, 14, TABLE_HEADING_TAX, 1, 0, 'R', 1); $pdf->Cell(68, 14, TABLE_HEADING_PRICE_EXCLUDING_TAX, 1, 0, 'R', 1); $pdf->Cell(68, 14, TABLE_HEADING_PRICE_INCLUDING_TAX, 1, 0, 'R', 1); $pdf->Cell(68, 14, TABLE_HEADING_TOTAL_EXCLUDING_TAX, 1, 0, 'R', 1); $pdf->MultiCell(68, 14, TABLE_HEADING_TOTAL_INCLUDING_TAX, 1, 'R', 1); } $pdf->SetFillColor(256, 256, 256); if (TAX_ID_NUMBER != '') { /* draw order items in table when tax ID number is NOT null*/ for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { /* BEGIN update (Loose Chicken Software Development, david@loosechicken.com 01-03-2011) */ /* break attributes onto new lines */ $prod_name = $order->products[$i]['name']; $prod_attrs = array(); if (isset($order->products[$i]['attributes']) && sizeof($order->products[$i]['attributes']) > 0) { for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) { $prod_attrs[] = $order->products[$i]['attributes'][$j]['option'] . ': ' . zen_output_string_protected($order->products[$i]['attributes'][$j]['value']); } } /* BEGIN add (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ /* Find height of model and Product names */ $h_model = $pdf->MultiCellHeight(160, 14, $order->products[$i]['model'], 'LRT', 'L', 1); $h = $h_model; $h_product_name = $pdf->MultiCellHeight(160, 14, $prod_name, 'LRT', 'L', 1); $h = $h_product_name > $h ? $h_product_name : $h; /* If cells would be too tall, force a page break */ if ($pdf->y + $h > $pdf->PageBreakTrigger) { $pdf->AddPage(); } /* Get current y, to use with $h_product_name later when placing attributes */ $y_top = $pdf->getY(); /* END add (Loose Chicken Software Development 01-07-2011) */ $pdf->Cell(30, 14, $order->products[$i]['qty'], 'LRT', 0, '', 1); /* BEGIN update (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ /* * Changed Cell to MultiCell for the test wrapping. * Because MultiCell doesn't leave the cursor in the right place: * Retrived cursor before drawing cell, and placed it afterward base on origal location and cell width */ $y = $pdf->getY(); $x = $pdf->getX(); $pdf->MultiCell(160, 14, $prod_name, 'LRT', 'L', 1); $max_y = $pdf->getY(); $pdf->setXY($x + 160, $y); $y = $pdf->getY(); $x = $pdf->getX(); $pdf->MultiCell(160, 14, $order->products[$i]['model'], 'LRT', 'L', 1); $max_y = $pdf->getY() > $max_y ? $pdf->getY() : $max_y; $pdf->setXY($x + 160, $y); /* END update (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ $pdf->Cell(60, 14, ENTRY_NO_TAX, 'LRT', 0, '', 1); $pdf->Cell(78, 14, $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']), 'LRT', 0, 'R', 1); $pdf->MultiCell(78, 14, $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']), 'LRT', 'R', 1); /* BEGIN add (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ /* * Draw cell borders in case model or product name wrapped and thus would leave blank * spaces on the other cells. (This must be transparent so the cells are not overritten) */ $x = $pdf->GetX(); $y = $pdf->GetY(); if ($max_y > $y) { $h = $max_y - $y; $pdf->Cell(30, $h, '', 'LR', 0, '', 0); $pdf->Cell(160, $h, '', 'LR', 0, '', 0); $pdf->Cell(160, $h, '', 'LR', 0, '', 0); $pdf->Cell(60, $h, '', 'LR', 0, '', 0); $pdf->Cell(78, $h, '', 'LR', 0, '', 0); $pdf->MultiCell(78, $h, '', 'LR', 'J', 0); $pdf->setXY($x, $y); } $max_y_page = $pdf->PageNo(); /* Place attributes below product_name */ $pdf->setXY($x, $y_top + $h_product_name); /* END add (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ $pdf->SetFont('Arial', '', 8); $pdf->SetTextColor(40, 40, 40); foreach ($prod_attrs as $prod_attr) { $pdf->Cell(30, 10, '', 'LR', 0, '', 1); $pdf->Cell(160, 10, ' - ' . $prod_attr, 'LR', 0, '', 1); $pdf->Cell(160, 10, '', 'LR', 0, '', 1); $pdf->Cell(60, 10, '', 'LR', 0, '', 1); $pdf->Cell(78, 10, '', 'LR', 0, '', 1); $pdf->MultiCell(78, 10, '', 'LR', 'J', 1); } $x = $pdf->GetX(); $y = $pdf->GetY(); /* BEGIN add (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ /* * If after drawing the attributes the cursor is not as low as after drawing * the model and product name lower the cursor for the drawing of the bottom line */ if ($max_y > $y && $max_y_page == $pdf->PageNo()) { $y = $max_y; } /* END add (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ $pdf->Line($x, $y, $x + 30 + 160 + 160 + 60 + 78 + 78, $y); $pdf->SetTextColor(0, 0, 0); $pdf->SetFont('Arial', '', 10); /* END modification (Loose Chicken Software Development 01-03-2011) */ } } else { /* draw order items in table when tax ID number IS null*/ for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { /* BEGIN update (Loose Chicken Software Development, david@loosechicken.com 01-03-2011) */ /* break attributes onto new lines */ $prod_name = $order->products[$i]['name']; $prod_attrs = array(); if (isset($order->products[$i]['attributes']) && sizeof($order->products[$i]['attributes']) > 0) { for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) { $prod_attrs[] = $order->products[$i]['attributes'][$j]['option'] . ': ' . zen_output_string_protected($order->products[$i]['attributes'][$j]['value']); } } /* BEGIN add (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ /* Find height of model and Product names */ $h_model = $pdf->MultiCellHeight(120, 14, $order->products[$i]['model'], 'LRT', 'L', 1); $h = $h_model; $h_product_name = $pdf->MultiCellHeight(120, 14, $prod_name, 'LRT', 'L', 1); $h = $h_product_name > $h ? $h_product_name : $h; /* If cells would be too tall, force a page break */ if ($pdf->y + $h > $pdf->PageBreakTrigger) { $pdf->AddPage(); } /* Get current y, to use with $h_product_name later when placing attributes */ $y_top = $pdf->getY(); /* END add (Loose Chicken Software Development 01-07-2011) */ $pdf->Cell(25, 14, $order->products[$i]['qty'], 'LRT', 0, '', 1); /* BEGIN update (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ /* * Changed Cell to MultiCell for the test wrapping. * Because MultiCell doesn't leave the cursor in the right place: * Retrived cursor before drawing cell, and placed it afterward base on origal location and cell width */ $y = $pdf->getY(); $x = $pdf->getX(); $pdf->MultiCell(120, 14, $prod_name, 'LRT', 'L', 1); $max_y = $pdf->getY(); $pdf->setXY($x + 120, $y); $y = $pdf->getY(); $x = $pdf->getX(); $pdf->MultiCell(120, 14, $order->products[$i]['model'], 'LRT', 'L', 1); $max_y = $pdf->getY() > $max_y ? $pdf->getY() : $max_y; $pdf->setXY($x + 120, $y); /* END update (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ /*$pdf->Cell(40, 14, zen_display_tax_value($order->products[$i]['tax']) . '%', 'LRT', 0, 'R', 1); $pdf->Cell(68, 14, $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']), 'LRT', 0, 'R', 1); $pdf->Cell(68, 14, $currencies->format(zen_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']), 'LRT', 0, 'R', 1); $pdf->Cell(68, 14, $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']), 'LRT', 0, 'R', 1); $pdf->MultiCell(68, 14, $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']), 'LRT', 'R', 1); */ $pdf->Cell(40, 14, html_entity_decode(zen_display_tax_value($order->products[$i]['tax']) . '%', ENT_QUOTES, "ISO-8859-15"), 'LRT', 0, 'R', 1); if ($order->info['currency'] == 'EUR') { $f1 = str_replace('€', '€', $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value'])); $pdf->Cell(68, 14, html_entity_decode($f1), 'LRT', 'R', 1); } else { $pdf->Cell(68, 14, html_entity_decode($currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']), ENT_QUOTES, "ISO-8859-15"), 'LRT', 0, 'R', 1); } if ($order->info['currency'] == 'EUR') { $f2 = str_replace('€', '€', $currencies->format(zen_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value'])); $pdf->Cell(68, 14, html_entity_decode($f2), 'LRT', 'R', 1); } else { $pdf->Cell(68, 14, html_entity_decode($currencies->format(zen_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']), ENT_QUOTES, "ISO-8859-15"), 'LRT', 0, 'R', 1); } if ($order->info['currency'] == 'EUR') { $f3 = str_replace('€', '€', $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])); $pdf->Cell(68, 14, html_entity_decode($f3), 'LRT', 'R', 1); } else { $pdf->Cell(68, 14, html_entity_decode($currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']), ENT_QUOTES, "ISO-8859-15"), 'LRT', 0, 'R', 1); } if ($order->info['currency'] == 'EUR') { $f = str_replace('€', '€', $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'])); $pdf->MultiCell(68, 14, html_entity_decode($f), 'LRT', 'R', 1); } else { $pdf->MultiCell(68, 14, html_entity_decode($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']), ENT_QUOTES, "ISO-8859-15"), 'LRT', 'R', 1); } /* BEGIN add (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ /* * Draw cell borders in case model or product name wrapped and thus would leave blank * spaces on the other cells. (This must be transparent so the cells are not overritten) */ $x = $pdf->GetX(); $y = $pdf->GetY(); if ($max_y > $y) { $h = $max_y - $y; $pdf->Cell(25, $h, '', 'LR', 0, '', 0); $pdf->Cell(120, $h, '', 'LR', 0, '', 0); $pdf->Cell(120, $h, '', 'LR', 0, '', 0); $pdf->Cell(40, $h, '', 'LR', 0, '', 0); $pdf->Cell(68, $h, '', 'LR', 0, '', 0); $pdf->Cell(68, $h, '', 'LR', 0, '', 0); $pdf->Cell(68, $h, '', 'LR', 0, '', 0); $pdf->MultiCell(68, $h, '', 'LR', 'J', 0); $pdf->setXY($x, $y); } $max_y_page = $pdf->PageNo(); /* Place attributes below product_name */ $pdf->setXY($x, $y_top + $h_product_name); /* END add (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ $pdf->SetFont('Arial', '', 8); $pdf->SetTextColor(40, 40, 40); foreach ($prod_attrs as $prod_attr) { $pdf->Cell(25, 10, '', 'LR', 0, '', 1); $pdf->Cell(120, 10, ' - ' . $prod_attr, 'LR', 0, '', 1); $pdf->Cell(120, 10, '', 'LR', 0, '', 1); $pdf->Cell(40, 10, '', 'LR', 0, '', 1); $pdf->Cell(68, 10, '', 'LR', 0, '', 1); $pdf->Cell(68, 10, '', 'LR', 0, '', 1); $pdf->Cell(68, 10, '', 'LR', 0, '', 1); $pdf->MultiCell(68, 10, '', 'LR', 'J', 1); } $x = $pdf->GetX(); $y = $pdf->GetY(); /* BEGIN add (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ /* * If after drawing the attributes the cursor is not as low as after drawing * the model and product name lower the cursor for the drawing of the bottom line */ if ($max_y > $y && $max_y_page == $pdf->PageNo()) { $y = $max_y; } /* END add (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ $pdf->Line($x, $y, $x + 25 + 120 + 120 + 40 + 68 + 68 + 68 + 68, $y); $pdf->SetTextColor(0, 0, 0); $pdf->SetFont('Arial', '', 10); /* END modification (Loose Chicken Software Development 01-03-2011) */ } } /* order cost summary */ $pdf->Ln(); for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { $title = strip_tags($order->totals[$i]['title']); $text = strip_tags($order->totals[$i]['text']); /* $pdf->Cell(516, 14, $title, 0, 0, 'R'); $pdf->MultiCell(50, 14, $text, 0, 'R'); */ $pdf->Cell(516, 14, html_entity_decode($title, ENT_QUOTES, "ISO-8859-15"), 0, 0, 'R'); //echo substr($text,0,5); if (substr($text, 0, 5) == '&euro') { $a = str_replace('€', '€', $text); $pdf->MultiCell(50, 14, html_entity_decode($a, ENT_QUOTES, "ISO-8859-15"), 0, 0, 'R'); } else { $pdf->MultiCell(50, 14, html_entity_decode($text, ENT_QUOTES, "ISO-8859-15"), 0, 0, 'R'); } } /* order balance */ /*$orders_balance = $db->Execute("select orders_id , balance_due from " . TABLE_ORDERS . " where orders_id = '" . zen_db_input($order->info['id']) . "' order by orders_id"); $balance_due = $orders_balance->fields['balance_due'];*/ $pdf->SetFont('Arial', 'B', ''); require_once DIR_WS_CLASSES . 'super_order.php'; $so = new super_order($order->info['id']); $pdf->Cell(516, 14, 'Amount Paid: ', 0, 0, 'R'); // $pdf->MultiCell(50, 14, $currencies->format($so->amount_applied), 0, 'R'); // $pdf->MultiCell(50, 14, $currencies->format($balance_due), 0, 'R'); // $pdf->MultiCell(50, 14, $currencies->format($so->balance_due), 0, 'R'); $var1 = substr($currencies->format($so->amount_applied), 0, 5); if ($var1 == '&euro') { $pdf->MultiCell(50, 14, '€' . $so->amount_applied, 0, 'R'); } else { $pdf->MultiCell(50, 14, html_entity_decode($currencies->format($so->amount_applied), ENT_QUOTES, "ISO-8859-15"), 0, 'R'); } $pdf->Cell(516, 14, 'Balance Due:', 0, 0, 'R'); $var = substr($currencies->format($so->balance_due), 0, 5); if ($var == '&euro') { $pdf->MultiCell(50, 14, '€' . $so->balance_due, 0, 'R'); } else { $pdf->MultiCell(50, 14, html_entity_decode($currencies->format($so->balance_due), ENT_QUOTES, "ISO-8859-15"), 0, 'R'); } //$pdf->SetFont('Arial','', 7); if (ORDER_COMMENTS_PACKING_SLIP > 0) { $pdf->Ln(); $pdf->SetFillColor(180, 180, 180); $pdf->SetFont('Arial', 'B', 10); $pdf->MultiCell(576, 14, 'Order Comments & Status', 'B'); $pdf->SetFont('Arial', '', 7); $pdf->SetFillColor(256, 256, 256); $orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, comments\n from " . TABLE_ORDERS_STATUS_HISTORY . "\n where orders_id = '" . zen_db_input($order->info['id']) . "' and customer_notified >= 0\n order by date_added"); $count_comments = 0; if ($orders_history->RecordCount() >= 1 && ORDER_COMMENTS_PACKING_SLIP == 1) { while (!$orders_history->EOF) { if ($orders_history->fields['comments'] != '' && strpos($orders_history->fields['comments'], 'PayPal status:') === false) { $count_comments++; $pdf->Cell(120, 14, zen_datetime_short($orders_history->fields['date_added'])); $pdf->MultiCell(456, 14, $orders_status_array[$orders_history->fields['orders_status_id']]); $pdf->Cell(27, 14, '', 0, 0, '', 1); /* BEGIN modify (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ /* removed function zen_db_output, which was converting output into html code */ //$pdf->MultiCell(549, 14, (zen_db_output($orders_history->fields['comments'])), 'B'); $pdf->MultiCell(549, 14, $orders_history->fields['comments'], 'B'); /* END modify (Loose Chicken Software Development, david@loosechicken.com 01-07-2011) */ $pdf->SetLineWidth(0.5); $pdf->Line(18, $pdf->GetY(), 594, $pdf->GetY()); } $orders_history->MoveNext(); /*if (ORDER_COMMENTS_PACKING_SLIP == 1 && $count_comments >= 1) { break; } */ } } if ($count_comments == 0) { $pdf->MultiCell(576, 14, TEXT_NO_ORDER_HISTORY, 'B'); } } }
if (PRODUCT_FEATURED_LIST_WEIGHT != '0' and zen_get_show_product_switch($featured_products->fields['products_id'], 'weight')) { $display_products_weight = TEXT_PRODUCTS_WEIGHT . $featured_products->fields['products_weight'] . TEXT_SHIPPING_WEIGHT . str_repeat('<br clear="all" />', substr(PRODUCT_FEATURED_LIST_WEIGHT, 3, 1)); } else { $display_products_weight = ''; } if (PRODUCT_FEATURED_LIST_QUANTITY != '0' and zen_get_show_product_switch($featured_products->fields['products_id'], 'quantity')) { if ($featured_products->fields['products_quantity'] <= 0) { $display_products_quantity = TEXT_OUT_OF_STOCK . str_repeat('<br clear="all" />', substr(PRODUCT_FEATURED_LIST_QUANTITY, 3, 1)); } else { $display_products_quantity = TEXT_PRODUCTS_QUANTITY . $featured_products->fields['products_quantity'] . str_repeat('<br clear="all" />', substr(PRODUCT_FEATURED_LIST_QUANTITY, 3, 1)); } } else { $display_products_quantity = ''; } if (PRODUCT_FEATURED_LIST_DATE_ADDED != '0' and zen_get_show_product_switch($featured_products->fields['products_id'], 'date_added')) { $display_products_date_added = TEXT_DATE_ADDED . ' ' . zen_date_long($featured_products->fields['products_date_added']) . str_repeat('<br clear="all" />', substr(PRODUCT_FEATURED_LIST_DATE_ADDED, 3, 1)); } else { $display_products_date_added = ''; } if (PRODUCT_FEATURED_LIST_MANUFACTURER != '0' and zen_get_show_product_switch($featured_products->fields['products_id'], 'manufacturer')) { $display_products_manufacturers_name = $featured_products->fields['manufacturers_name'] != '' ? TEXT_MANUFACTURER . ' ' . $featured_products->fields['manufacturers_name'] . str_repeat('<br clear="all" />', substr(PRODUCT_FEATURED_LIST_MANUFACTURER, 3, 1)) : ''; } else { $display_products_manufacturers_name = ''; } if (PRODUCT_FEATURED_LIST_PRICE != '0' and zen_get_products_allow_add_to_cart($featured_products->fields['products_id']) == 'Y' and zen_check_show_prices() == true) { $products_price = zen_get_products_display_price($featured_products->fields['products_id']); $display_products_price = TEXT_PRICE . ' ' . $products_price . str_repeat('<br clear="all" />', substr(PRODUCT_FEATURED_LIST_PRICE, 3, 1)) . (zen_get_show_product_switch($featured_products->fields['products_id'], 'ALWAYS_FREE_SHIPPING_IMAGE_SWITCH') ? zen_get_product_is_always_free_shipping($featured_products->fields['products_id']) ? TEXT_PRODUCT_FREE_SHIPPING_ICON . '<br />' : '' : ''); } else { $display_products_price = ''; } // more info in place of buy now
* Page Template * * Loaded automatically by index.php?main_page=account_edit.<br /> * Displays information related to a single specific order * * @package templateSystem * @copyright Copyright 2003-2011 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: tpl_account_history_info_default.php 19103 2011-07-13 18:10:46Z wilt $ */ ?> <div class="centerColumn" id="accountHistInfo"> <div class="forward"><?php echo HEADING_ORDER_DATE . ' ' . zen_date_long($order->info['date_purchased']); ?> </div> <br class="clearBoth" /> <table border="0" width="100%" cellspacing="0" cellpadding="0" summary="Itemized listing of previous order, includes number ordered, items and prices"> <caption><h2 id="orderHistoryDetailedOrder"><?php echo HEADING_TITLE . ORDER_HEADING_DIVIDER . sprintf(HEADING_ORDER_NUMBER, $_GET['order_id']); ?> </h2></caption> <tr class="tableHeading"> <!--JT mod - Product Image--> <th scope="col" id="myAccountQuantity"> </th> <!--JT mod - Product Image--> <th scope="col" id="myAccountQuantity"><?php echo HEADING_QUANTITY;
<td class="main" align="left"><?php echo HEADER_PO_TERMS; ?></td> <td class="main" align="right"><?php echo HEADER_PO_TERMS_LENGTH; ?></td> </tr> </table></td> <?php } ?> </tr> </table></td> </tr> <tr> <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td><table border="0" cellpadding="2" cellspacing="0"> <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"><strong><?php echo ENTRY_PAYMENT_METHOD; ?></strong></td> <td class="main"><?php echo $order->info['payment_method']; ?></td> </tr> <tr> <td class="main" colspan="2"><strong> </strong></td> </tr> </table></td> </tr> <tr> <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td><table border="0" cellpadding="2" cellspacing="0" width="100%">
if (PRODUCT_NEW_LIST_WEIGHT != '0' and zen_get_show_product_switch($products_new->fields['products_id'], 'weight')) { $display_products_weight = '<br />' . TEXT_PRODUCTS_WEIGHT . $products_new->fields['products_weight'] . TEXT_SHIPPING_WEIGHT . str_repeat('<br clear="all" />', substr(PRODUCT_NEW_LIST_WEIGHT, 3, 1)); } else { $display_products_weight = ''; } if (PRODUCT_NEW_LIST_QUANTITY != '0' and zen_get_show_product_switch($products_new->fields['products_id'], 'quantity')) { if ($products_new->fields['products_quantity'] <= 0) { $display_products_quantity = TEXT_OUT_OF_STOCK . str_repeat('<br clear="all" />', substr(PRODUCT_NEW_LIST_QUANTITY, 3, 1)); } else { $display_products_quantity = TEXT_PRODUCTS_QUANTITY . $products_new->fields['products_quantity'] . str_repeat('<br clear="all" />', substr(PRODUCT_NEW_LIST_QUANTITY, 3, 1)); } } else { $display_products_quantity = ''; } if (PRODUCT_NEW_LIST_DATE_ADDED != '0' and zen_get_show_product_switch($products_new->fields['products_id'], 'date_added')) { $display_products_date_added = TEXT_DATE_ADDED . ' ' . zen_date_long($products_new->fields['products_date_added']) . str_repeat('<br clear="all" />', substr(PRODUCT_NEW_LIST_DATE_ADDED, 3, 1)); } else { $display_products_date_added = ''; } if (PRODUCT_NEW_LIST_MANUFACTURER != '0' and zen_get_show_product_switch($products_new->fields['products_id'], 'manufacturer')) { $display_products_manufacturers_name = $products_new->fields['manufacturers_name'] != '' ? TEXT_MANUFACTURER . ' ' . $products_new->fields['manufacturers_name'] . str_repeat('<br clear="all" />', substr(PRODUCT_NEW_LIST_MANUFACTURER, 3, 1)) : ''; } else { $display_products_manufacturers_name = ''; } if (PRODUCT_NEW_LIST_PRICE != '0' and zen_get_products_allow_add_to_cart($products_new->fields['products_id']) == 'Y' and zen_check_show_prices() == true) { $products_price = zen_get_products_display_price($products_new->fields['products_id']); $display_products_price = TEXT_PRICE . ' ' . $products_price . str_repeat('<br clear="all" />', substr(PRODUCT_NEW_LIST_PRICE, 3, 1)) . (zen_get_show_product_switch($products_new->fields['products_id'], 'ALWAYS_FREE_SHIPPING_IMAGE_SWITCH') ? zen_get_product_is_always_free_shipping($products_new->fields['products_id']) ? TEXT_PRODUCT_FREE_SHIPPING_ICON . '<br />' : '' : ''); } else { $display_products_price = ''; } // more info in place of buy now
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('<br clear="all" />', 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('<br clear="all" />', substr(PRODUCT_ALL_LIST_QUANTITY, 3, 1)); } else { $display_products_quantity = TEXT_PRODUCTS_QUANTITY . $products_all->fields['products_quantity'] . str_repeat('<br clear="all" />', 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 = '<span class="service-text">' . TEXT_DATE_ADDED . ' ' . zen_date_long($products_all->fields['products_date_added']) . '</span>' . str_repeat('<br clear="all" />', 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('<br clear="all" />', 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_get_products_display_price($products_all->fields['products_id']); $display_products_price = '<span class="table-price">' . $products_price . '</span>' . str_repeat('<br clear="all" />', 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 = ''; } // more info in place of buy now
<!--bof Product date added/available--> <?php if ($products_date_available > date('Y-m-d H:i:s')) { if ($flag_show_product_info_date_available == 1) { ?> <p id="productDateAvailable" class="docProduct centeredContent"><?php echo sprintf(TEXT_DATE_AVAILABLE, zen_date_long($products_date_available)); ?> </p> <?php } } else { if ($flag_show_product_info_date_added == 1) { ?> <p id="productDateAdded" class="docProduct centeredContent"><?php echo sprintf(TEXT_DATE_ADDED, zen_date_long($products_date_added)); ?> </p> <?php } // $flag_show_product_info_date_added } ?> <!--eof Product date added/available --> <!--bof Product URL --> <?php if (zen_not_null($products_url)) { if ($flag_show_product_info_url == 1) { ?> <p id="productInfoLink" class="docProduct centeredContent"><?php
$group_id = zen_get_configuration_key_value('FAQ_LISTS_GROUP_ID'); if ($featured_faqs_split->number_of_rows > 0) { $featured_faqs = $db->Execute($featured_faqs_split->sql_query); while (!$featured_faqs->EOF) { if (FAQ_FEATURED_LIST_IMAGE != '0') { $display_faqs_image = '<a href="' . zen_href_link(zen_get_info_faq_page($featured_faqs->fields['faqs_id']), 'faqs_id=' . $featured_faqs->fields['faqs_id']) . '">' . zen_image(DIR_WS_IMAGES . $featured_faqs->fields['faqs_image'], $featured_faqs->fields['faqs_name'], IMAGE_FEATURED_FAQS_LISTING_WIDTH, IMAGE_FEATURED_FAQS_LISTING_HEIGHT) . '</a>' . str_repeat('<br clear="all" />', substr(FAQ_FEATURED_LIST_IMAGE, 3, 1)); } else { $display_faqs_image = ''; } if (FAQ_FEATURED_LIST_NAME != '0') { $display_faqs_name = '<a href="' . zen_href_link(zen_get_info_faq_page($featured_faqs->fields['faqs_id']), 'faqs_id=' . $featured_faqs->fields['faqs_id']) . '"><strong>' . $featured_faqs->fields['faqs_name'] . '</strong></a>' . str_repeat('<br clear="all" />', substr(FAQ_FEATURED_LIST_NAME, 3, 1)); } else { $display_faqs_name = ''; } if (FAQ_FEATURED_LIST_DATE_ADDED != '0' and zen_get_show_faq_switch($featured_faqs->fields['faqs_id'], 'date_added')) { $display_faqs_date_added = TEXT_DATE_ADDED . ' ' . zen_date_long($featured_faqs->fields['faqs_date_added']) . str_repeat('<br clear="all" />', substr(FAQ_FEATURED_LIST_DATE_ADDED, 3, 1)); } else { $display_faqs_date_added = ''; } $link = '<a href="' . zen_href_link(zen_get_info_faq_page($featured_faqs->fields['faqs_id']), 'faqs_id=' . $featured_faqs->fields['faqs_id']) . '">' . MORE_INFO_TEXT . '</a>'; $the_button = $link; $faqs_link = '<a href="' . zen_href_link(zen_get_info_faq_page($featured_faqs->fields['faqs_id']), 'faqs_id=' . $featured_faqs->fields['faqs_id']) . '">' . MORE_INFO_TEXT . '</a>'; if (FAQ_FEATURED_LIST_DESCRIPTION != '0') { $disp_text = zen_get_faqs_description($featured_faqs->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($featured_faqs->fields['faqs_id']), 'faqs_id=' . $featured_faqs->fields['faqs_id']) . '"> ' . MORE_INFO_TEXT . '</a>')); } else { $display_faqs_description = ''; } ?> <tr>