function loadSummaryData() { global $toC_Json, $osC_Language; $osC_Order = new osC_Order($_REQUEST['orders_id']); $response['customer'] = '<p style="margin-left:10px;">' . osC_Address::format($osC_Order->getCustomer(), '<br />') . '</p>' . '<p style="margin-left:10px;>' . osc_icon('telephone.png') . $osC_Order->getCustomer('telephone') . '<br />' . osc_icon('write.png') . $osC_Order->getCustomer('email_address') . '</p>'; $response['shippingAddress'] = '<p style="margin-left:10px;">' . osC_Address::format($osC_Order->getDelivery(), '<br />') . '</p>'; $response['billingAddress'] = '<p style="margin-left:10px;">' . osC_Address::format($osC_Order->getBilling(), '<br />') . '</p>'; $response['paymentMethod'] = '<p style="margin-left:10px;">' . $osC_Order->getPaymentMethod() . '</p>'; if ($osC_Order->isValidCreditCard()) { $response['paymentMethod'] .= ' <table border="0" cellspacing="0" cellpadding="0"> <tr> <td>' . $osC_Language->get('credit_card_type') . '</td> <td>' . $osC_Order->getCreditCardDetails('type') . '</td> </tr> <tr> <td>' . $osC_Language->get('credit_card_owner_name') . '</td> <td>' . $osC_Order->getCreditCardDetails('owner') . '</td> </tr> <tr> <td>' . $osC_Language->get('credit_card_number') . '</td> <td>' . $osC_Order->getCreditCardDetails('number') . '</td> </tr> <tr> <td>' . $osC_Language->get('credit_card_expiry_date') . '</td> <td>' . $osC_Order->getCreditCardDetails('expires') . '</td> </tr> </table>'; } $response['status'] = '<p style="margin-left:10px;">' . $osC_Order->getStatus() . '<br />' . ($osC_Order->getDateLastModified() > $osC_Order->getDateCreated() ? osC_DateTime::getShort($osC_Order->getDateLastModified(), true) : osC_DateTime::getShort($osC_Order->getDateCreated(), true)) . '</p>' . '<p style="margin-left:10px;">' . $osC_Language->get('number_of_comments') . ' ' . $osC_Order->getNumberOfComments() . '</p>'; $response['total'] = '<p style="margin-left:10px;">' . $osC_Order->getTotal() . '</p>' . '<p style="margin-left:10px;">' . $osC_Language->get('number_of_products') . ' ' . $osC_Order->getNumberOfProducts() . '<br />' . $osC_Language->get('number_of_items') . ' ' . $osC_Order->getNumberOfItems() . '</p>'; echo $toC_Json->encode($response); }
echo $order->info['payment_method']; ?> </p> </td> <td valign="top"> <?php if ($order->delivery != false) { ?> <h6><?php echo $osC_Language->get('order_delivery_address_title'); ?> </h6> <p><?php echo osC_Address::format($order->delivery, '<br />'); ?> </p> <?php if (!empty($order->info['shipping_method'])) { ?> <h6><?php echo $osC_Language->get('order_shipping_method_title'); ?> </h6> <p><?php echo $order->info['shipping_method']; ?>
function listOrdersReturns() { global $toC_Json, $osC_Language, $osC_Database; $start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start']; $limit = empty($_REQUEST['limit']) ? MAX_DISPLAY_SEARCH_RESULTS : $_REQUEST['limit']; $Qreturns = $osC_Database->query('select r.orders_returns_id, r.orders_id, r.orders_returns_status_id, r.customers_comments, r.admin_comments, r.date_added, o.customers_name, ors.orders_returns_status_name from :table_orders o, :table_orders_returns r, :table_orders_returns_status ors where r.orders_id = o.orders_id and r.orders_returns_status_id = ors.orders_returns_status_id and ors.languages_id = :languages_id'); if (isset($_REQUEST['orders_id']) && !empty($_REQUEST['orders_id'])) { $Qreturns->appendQuery('and r.orders_id = :orders_id '); $Qreturns->bindInt(':orders_id', $_REQUEST['orders_id']); } if (isset($_REQUEST['customers_id']) && !empty($_REQUEST['customers_id'])) { $Qreturns->appendQuery('and o.customers_id = :customers_id '); $Qreturns->bindInt(':customers_id', $_REQUEST['customers_id']); } if (isset($_REQUEST['orders_returns_status_id']) && !empty($_REQUEST['orders_returns_status_id'])) { $Qreturns->appendQuery('and r.orders_returns_status_id = :orders_returns_status_id '); $Qreturns->bindInt(':orders_returns_status_id', $_REQUEST['orders_returns_status_id']); } $Qreturns->appendQuery('order by r.orders_returns_id desc '); $Qreturns->bindTable(':table_orders', TABLE_ORDERS); $Qreturns->bindTable(':table_orders_returns', TABLE_ORDERS_RETURNS); $Qreturns->bindTable(':table_orders_returns_status', TABLE_ORDERS_RETURNS_STATUS); $Qreturns->bindInt(':languages_id', $osC_Language->getID()); $Qreturns->setExtBatchLimit($start, $limit); $Qreturns->execute(); $records = array(); while ($Qreturns->next()) { $orders_returns_id = $Qreturns->value('orders_returns_id'); $Qproducts = $osC_Database->query("select orders_products_id, products_quantity from :table_orders_returns_products where orders_returns_id = :orders_returns_id"); $Qproducts->bindTable(':table_orders_products', TABLE_ORDERS_PRODUCTS); $Qproducts->bindTable(':table_orders_returns_products', TABLE_ORDERS_RETURNS_PRODUCTS); $Qproducts->bindInt(':orders_returns_id', $orders_returns_id); $Qproducts->execute(); $return_products_ids = array(); $return_products_qty = array(); while ($Qproducts->next()) { $return_products_ids[] = $Qproducts->valueInt('orders_products_id'); $return_products_qty[$Qproducts->valueInt('orders_products_id')] = $Qproducts->valueInt('products_quantity'); } $total = 0; $quantity = 0; $products = array(); $return_quantity = array(); $osC_Order = new osC_Order($Qreturns->valueInt('orders_id')); foreach ($osC_Order->getProducts() as $product) { if (in_array($product['orders_products_id'], $return_products_ids)) { $product_info = $return_products_qty[$product['orders_products_id']] . ' x ' . $product['name']; if ($product['type'] == PRODUCT_TYPE_GIFT_CERTIFICATE) { $product_info .= '<br /><nobr> <i>' . $osC_Language->get('senders_name') . ': ' . $product['senders_name'] . '</i></nobr>'; if ($product['gift_certificates_type'] == GIFT_CERTIFICATE_TYPE_EMAIL) { $product_info .= '<br /><nobr> <i>' . $osC_Language->get('senders_email') . ': ' . $product['senders_email'] . '</i></nobr>'; } $product_info .= '<br /><nobr> <i>' . $osC_Language->get('recipients_name') . ': ' . $product['recipients_name'] . '</i></nobr>'; if ($product['gift_certificates_type'] == GIFT_CERTIFICATE_TYPE_EMAIL) { $product_info .= '<br /><nobr> <i>' . $osC_Language->get('recipients_email') . ': ' . $product['recipients_email'] . '</i></nobr>'; } $product_info .= '<br /><nobr> <i>' . $osC_Language->get('messages') . ': ' . $product['messages'] . '</i></nobr>'; } if (isset($product['variants']) && is_array($product['variants']) && sizeof($product['variants']) > 0) { foreach ($product['variants'] as $variants) { $product_info .= '<br /><nobr> <i>' . $variants['groups_name'] . ': ' . $variants['values_name'] . '</i></nobr>'; } } $products[] = $product_info; $total += $return_products_qty[$product['orders_products_id']] * $product['final_price'] * (1 + $product['tax'] / 100); $quantity += $return_products_qty[$product['orders_products_id']]; $return_quantity[] = $product['orders_products_id'] . ':' . $return_products_qty[$product['orders_products_id']]; } } $action = array(); $orders_returns_status_id = $Qreturns->value('orders_returns_status_id'); if ($orders_returns_status_id == ORDERS_RETURNS_STATUS_REFUNDED_CREDIT_MEMO || $orders_returns_status_id == ORDERS_RETURNS_STATUS_REFUNDED_STORE_CREDIT || $orders_returns_status_id == ORDERS_RETURNS_STATUS_REJECT) { $action[] = array('class' => 'icon-edit-gray-record', 'qtip' => $osC_Language->get('icon_edit')); $action[] = array('class' => 'icon-credit-slip-gray-record', 'qtip' => $osC_Language->get('icon_credit_slip')); $action[] = array('class' => 'icon-store-credit-gray-record', 'qtip' => $osC_Language->get('icon_issue_store_credit')); } else { $action[] = array('class' => 'icon-edit-record', 'qtip' => $osC_Language->get('icon_edit')); $action[] = array('class' => 'icon-credit-slip-record', 'qtip' => $osC_Language->get('icon_credit_slip')); $action[] = array('class' => 'icon-store-credit-record', 'qtip' => $osC_Language->get('icon_issue_store_credit')); } $records[] = array('orders_returns_id' => $orders_returns_id, 'orders_id' => $Qreturns->valueInt('orders_id'), 'orders_returns_customer' => $Qreturns->value('customers_name'), 'quantity' => $quantity, 'date_added' => osC_DateTime::getShort($Qreturns->value('date_added')), 'status' => $Qreturns->value('orders_returns_status_name'), 'status_id' => $orders_returns_status_id, 'products' => implode('<br />', $products), 'return_quantity' => implode(';', $return_quantity), 'billing_address' => osC_Address::format($osC_Order->getBilling(), '<br />'), 'customers_comments' => $Qreturns->value('customers_comments'), 'admin_comments' => $Qreturns->value('admin_comments'), 'total' => number_format($total, 2, '.', ''), 'action' => $action); } $response = array(EXT_JSON_READER_TOTAL => $Qreturns->getBatchSize(), EXT_JSON_READER_ROOT => $records); echo $toC_Json->encode($response); }
<td><?php echo '<a href="mailto:' . $osC_Order->getCustomer('email_address') . '"><u>' . $osC_Order->getCustomer('email_address') . '</u></a>'; ?> </td> </tr> </table></td> <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td><b><?php echo $osC_Language->get('subsection_shipping_address'); ?> </b></td> </tr> <tr> <td><?php echo osC_Address::format($osC_Order->getDelivery(), '<br />'); ?> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td> </td> </tr> <tr> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td><b><?php echo $osC_Language->get('subsection_payment_method');
<p><?php echo $osC_ShoppingCart->getShippingMethod('title'); ?> </p> <?php } } ?> </td> <td valign="top"> <p><?php echo '<b>' . $osC_Language->get('order_billing_address_title') . '</b> '; ?> </p> <p><?php echo osC_Address::format($osC_ShoppingCart->getBillingAddress(), '<br />'); ?> </p> <p><?php echo '<b>' . $osC_Language->get('order_payment_method_title') . '</b> '; ?> </p> <p><?php echo implode(', ', $osC_ShoppingCart->getCartBillingMethods()); ?> </p> </td> </tr> <tr> <td width="100%" colspan="2" valign="top">
echo $Qaddresses->valueProtected('firstname') . ' ' . $Qaddresses->valueProtected('lastname'); ?> </b></td> <td align="right"><?php echo osc_draw_radio_field('address', $Qaddresses->valueInt('address_book_id'), $osC_ShoppingCart->getBillingAddress('id')); ?> </td> <td width="10"> </td> </tr> <tr> <td width="10"> </td> <td colspan="3"><table border="0" cellspacing="0" cellpadding="2"> <tr> <td width="10"> </td> <td><?php echo osC_Address::format($Qaddresses->toArray(), ', '); ?> </td> <td width="10"> </td> </tr> </table></td> <td width="10"> </td> </tr> </table></td> <td width="10"> </td> </tr> <?php $radio_buttons++; } ?>
<?php echo '<b>' . $osC_Language->get('please_select') . '</b><br />' . osc_image(DIR_WS_IMAGES . 'arrow_east_south.gif'); ?> </div> <p style="margin-top: 0px;"><?php echo $osC_Language->get('choose_billing_address'); ?> </p> </li> <li style="margin-bottom: 10px"> <?php $Qaddresses = osC_AddressBook::getListing(); $address = array(); while ($Qaddresses->next()) { $address[] = array('id' => $Qaddresses->valueInt('address_book_id'), 'text' => osC_Address::format($Qaddresses->toArray(), ', ')); } if ($create_billing_address == null) { $create_billing_address = false; } echo osc_draw_pull_down_menu('sel_billing_address', $address); ?> </li> <?php } ?> <div id="billingAddressDetails" style="display: <?php echo $osC_Customer->isLoggedOn() & $create_billing_address == false ? 'none' : ''; ?> ">
function listCreditsMemo() { global $toC_Json, $osC_Database, $osC_Language; $osC_Currencies = new osC_Currencies_Admin(); $start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start']; $limit = empty($_REQUEST['limit']) ? MAX_DISPLAY_SEARCH_RESULTS : $_REQUEST['limit']; $Qslips = $osC_Database->query('select r.* from :table_orders_refunds r '); if (isset($_REQUEST['customers_id']) && !empty($_REQUEST['customers_id'])) { $Qslips->appendQuery(', ' . TABLE_ORDERS . ' o where r.orders_id = o.orders_id and o.customers_id = :customers_id and r.orders_refunds_type = :orders_refunds_type'); $Qslips->bindInt(':customers_id', $_REQUEST['customers_id']); } else { $Qslips->appendQuery('where orders_refunds_type = :orders_refunds_type'); } if (isset($_REQUEST['orders_id']) && !empty($_REQUEST['orders_id'])) { $Qslips->appendQuery('and orders_id = :orders_id '); $Qslips->bindInt(':orders_id', $_REQUEST['orders_id']); } $Qslips->bindTable(':table_orders_refunds', TABLE_ORDERS_REFUNDS); $Qslips->bindInt(':orders_refunds_type', ORDERS_RETURNS_TYPE_CREDIT_SLIP); $Qslips->setExtBatchLimit($start, $limit); $Qslips->execute(); $records = array(); while ($Qslips->next()) { $orders_refunds_id = $Qslips->value('orders_refunds_id'); $Qproducts = $osC_Database->query("select orders_products_id, products_quantity from :table_orders_refunds_products where orders_refunds_id = :orders_refunds_id"); $Qproducts->bindTable(':table_orders_refunds_products', TABLE_ORDERS_REFUNDS_PRODUCTS); $Qproducts->bindInt(':orders_refunds_id', $orders_refunds_id); $Qproducts->execute(); $products_ids = array(); $products_qty = array(); while ($Qproducts->next()) { $products_ids[] = $Qproducts->valueInt('orders_products_id'); $products_qty[$Qproducts->valueInt('orders_products_id')] = $Qproducts->valueInt('products_quantity'); } $total = 0; $quantity = 0; $products = array(); $osC_Order = new osC_Order($Qslips->valueInt('orders_id')); $products_table = '<table width="100%">'; foreach ($osC_Order->getProducts() as $product) { if (in_array($product['orders_products_id'], $products_ids)) { $product_info = $products_qty[$product['orders_products_id']] . ' x ' . $product['name']; if ($product['type'] == PRODUCT_TYPE_GIFT_CERTIFICATE) { $product_info .= '<br /><nobr> <i>' . $osC_Language->get('senders_name') . ': ' . $product['senders_name'] . '</i></nobr>'; if ($product['gift_certificates_type'] == GIFT_CERTIFICATE_TYPE_EMAIL) { $product_info .= '<br /><nobr> <i>' . $osC_Language->get('senders_email') . ': ' . $product['senders_email'] . '</i></nobr>'; } $product_info .= '<br /><nobr> <i>' . $osC_Language->get('recipients_name') . ': ' . $product['recipients_name'] . '</i></nobr>'; if ($product['gift_certificates_type'] == GIFT_CERTIFICATE_TYPE_EMAIL) { $product_info .= '<br /><nobr> <i>' . $osC_Language->get('recipients_email') . ': ' . $product['recipients_email'] . '</i></nobr>'; } $product_info .= '<br /><nobr> <i>' . $osC_Language->get('messages') . ': ' . $product['messages'] . '</i></nobr>'; } if (isset($product['variants']) && is_array($product['variants']) && sizeof($product['variants']) > 0) { foreach ($product['variants'] as $variants) { $product_info .= '<br /><nobr> <i>' . $variants['groups_name'] . ': ' . $variants['values_name'] . '</i></nobr>'; } } $products[] = $product_info; $quantity += $products_qty[$product['orders_products_id']]; $products_table .= '<tr><td>' . $product_info . '</td><td width="60" valign="top" align="right">' . $osC_Currencies->displayPriceWithTaxRate($product['final_price'], $product['tax'], 1, $osC_Order->getCurrency(), $osC_Order->getCurrencyValue()) . '</td></tr>'; } } $products_table .= '</table>'; $order_total = '<table width="100%">'; $order_total .= '<tr><td align="right">' . $osC_Language->get("field_sub_total") . ' </td><td width="60" align="right">' . $osC_Currencies->format($Qslips->value('sub_total')) . '</td></tr>'; $order_total .= '<tr><td align="right">' . $osC_Language->get("field_shipping_fee") . ' </td><td width="60" align="right">' . $osC_Currencies->format($Qslips->value('shipping')) . '</td></tr>'; $order_total .= '<tr><td align="right">' . $osC_Language->get("field_handling") . ' </td><td width="60" align="right">' . $osC_Currencies->format($Qslips->value('handling')) . '</td></tr>'; $order_total .= '<tr><td align="right">' . $osC_Language->get("field_refund_total") . ' </td><td width="60" align="right">' . $osC_Currencies->format($Qslips->value('refund_total')) . '</td></tr>'; $order_total .= '</table>'; $records[] = array('orders_refunds_id' => $Qslips->valueInt('orders_refunds_id'), 'credit_slips_id' => $Qslips->valueInt('credit_slips_id'), 'orders_id' => $Qslips->valueInt('orders_id'), 'customers_name' => $osC_Order->getCustomer('name'), 'total_products' => $quantity, 'total_refund' => $osC_Currencies->format($Qslips->value('refund_total')), 'sub_total' => $osC_Currencies->format($Qslips->value('sub_total')), 'date_added' => osC_DateTime::getShort($Qslips->value('date_added')), 'shipping_address' => osC_Address::format($osC_Order->getDelivery(), '<br />'), 'shipping_method' => $osC_Order->getDeliverMethod(), 'billing_address' => osC_Address::format($osC_Order->getBilling(), '<br />'), 'payment_method' => $osC_Order->getPaymentMethod(), 'comments' => $Qslips->value('comments'), 'products' => $products_table, 'totals' => $order_total); } $response = array(EXT_JSON_READER_TOTAL => $Qslips->getBatchSize(), EXT_JSON_READER_ROOT => $records); echo $toC_Json->encode($response); }
<h1><?php echo $osC_Template->getPageTitle(); ?> </h1> <div class="moduleBox"> <h6><?php echo $osC_Language->get('address_book_delete_address_title'); ?> </h6> <div class="content"> <div style="float: right; padding: 0px 0px 10px 20px;"> <?php echo osC_Address::format($_GET['address_book'], '<br />'); ?> </div> <div style="float: right; padding: 0px 0px 10px 20px; text-align: center;"> <?php echo '<b>' . $osC_Language->get('selected_address_title') . '</b><br />' . osc_image(DIR_WS_IMAGES . 'arrow_south_east.gif'); ?> </div> <?php echo $osC_Language->get('address_book_delete_address_description'); ?> <div style="clear: both;"></div> </div>
function listAddressBooks() { global $toC_Json, $osC_Language; $osC_ObjectInfo = new osC_ObjectInfo(osC_Customers_Admin::getData($_REQUEST['customers_id'])); $Qaddresses = osC_Customers_Admin::getAddressBookData($_REQUEST['customers_id']); $records = array(); while ($Qaddresses->next()) { $address = osC_Address::format($Qaddresses->toArray(), '<br/>'); if ($osC_ObjectInfo->get('customers_default_address_id') == $Qaddresses->valueInt('address_book_id')) { $address .= ' <i>(' . $osC_Language->get('primary_address') . ')</i>'; } $records[] = array('address_book_id' => $Qaddresses->value('address_book_id'), 'address_html' => $address); } $Qaddresses->freeResult(); $response = array(EXT_JSON_READER_ROOT => $records); echo $toC_Json->encode($response); }
<p align="center"><?php echo '<input type="button" value="' . $osC_Language->get('button_back') . '" onclick="document.location.href=\'' . osc_href_link_admin(FILENAME_DEFAULT, $osC_Template->getModule() . '&cID=' . $_GET['cID'] . '&search=' . $_GET['search'] . '&page=' . $_GET['page'] . '&action=save&tabIndex=tabAddressBook') . '\';" class="operationButton" />'; ?> </p> <?php } else { ?> <p><?php echo $osC_Language->get('introduction_delete_address_book_entry'); ?> </p> <p><?php echo '<b>' . osC_Address::format($osC_ObjectInfo_AddressBook->getAll(), ', ') . '</b>'; ?> </p> <p align="center"><?php echo osc_draw_hidden_field('subaction', 'confirm') . '<input type="submit" value="' . $osC_Language->get('button_delete') . '" class="operationButton" /> <input type="button" value="' . $osC_Language->get('button_cancel') . '" onclick="document.location.href=\'' . osc_href_link_admin(FILENAME_DEFAULT, $osC_Template->getModule() . '&cID=' . $_GET['cID'] . '&search=' . $_GET['search'] . '&page=' . $_GET['page'] . '&action=save&tabIndex=tabAddressBook') . '\';" class="operationButton" />'; ?> </p> <?php } ?> </form> </div>
<p><?php echo osC_Address::format($osC_Order->getDelivery(), '<br />'); ?> </p> </fieldset> </td> <td width="33%" valign="top"> <fieldset style="border: 0; height: 100%;"> <legend style="margin-left: -20px; font-weight: bold;"><?php echo osc_icon('bill.png') . ' ' . $osC_Language->get('subsection_billing_address'); ?> </legend> <p><?php echo osC_Address::format($osC_Order->getBilling(), '<br />'); ?> </p> </fieldset> </td> </tr> <tr> <td width="33%" valign="top"> <fieldset style="border: 0; height: 100%;"> <legend style="margin-left: -20px; font-weight: bold;"><?php echo osc_icon('payment.png') . ' ' . $osC_Language->get('subsection_payment_method'); ?> </legend> <p><?php echo $osC_Order->getPaymentMethod();
function buildMessage() { global $osC_Database, $osC_Language, $osC_Currencies; $Qorder = $osC_Database->query('select * from :table_orders where orders_id = :orders_id limit 1'); $Qorder->bindTable(':table_orders', TABLE_ORDERS); $Qorder->bindInt(':orders_id', $this->_order_id); $Qorder->execute(); if ($Qorder->numberOfRows() === 1) { $this->addRecipient($Qorder->value('customers_name'), $Qorder->value('customers_email_address')); $order_number = $this->_order_id; $invoice_link = osc_href_link(FILENAME_ACCOUNT, 'orders=' . $this->_order_id, 'SSL', false, true, true); $date_ordered = osC_DateTime::getLong(); $order_details = $osC_Language->get('email_order_products') . "<br />" . $osC_Language->get('email_order_separator') . "<br />"; $Qproducts = $osC_Database->query('select orders_products_id, products_sku, products_name, final_price, products_tax, products_quantity from :table_orders_products where orders_id = :orders_id order by orders_products_id'); $Qproducts->bindTable(':table_orders_products', TABLE_ORDERS_PRODUCTS); $Qproducts->bindInt(':orders_id', $this->_order_id); $Qproducts->execute(); while ($Qproducts->next()) { $order_details .= $Qproducts->valueInt('products_quantity') . ' x ' . $Qproducts->value('products_name') . ' (' . $Qproducts->value('products_sku') . ') = ' . $osC_Currencies->displayPriceWithTaxRate($Qproducts->value('final_price'), $Qproducts->value('products_tax'), $Qproducts->valueInt('products_quantity'), $Qorder->value('currency'), $Qorder->value('currency_value')) . "<br />"; $Qvariants = $osC_Database->query('select products_variants_groups as groups_name, products_variants_values as values_name from :table_orders_products_variants where orders_id = :orders_id and orders_products_id = :orders_products_id order by orders_products_variants_id'); $Qvariants->bindTable(':table_orders_products_variants', TABLE_ORDERS_PRODUCTS_VARIANTS); $Qvariants->bindInt(':orders_id', $this->_order_id); $Qvariants->bindInt(':orders_products_id', $Qproducts->valueInt('orders_products_id')); $Qvariants->execute(); while ($Qvariants->next()) { $order_details .= "\t" . $Qvariants->value('groups_name') . ': ' . $Qvariants->value('values_name') . "<br />"; } } unset($Qproducts); unset($Qvariants); $order_details .= $osC_Language->get('email_order_separator') . "<br />"; $Qtotals = $osC_Database->query('select title, text from :table_orders_total where orders_id = :orders_id order by sort_order'); $Qtotals->bindTable(':table_orders_total', TABLE_ORDERS_TOTAL); $Qtotals->bindInt(':orders_id', $this->_order_id); $Qtotals->execute(); while ($Qtotals->next()) { $order_details .= strip_tags($Qtotals->value('title') . ' ' . $Qtotals->value('text')) . "<br />"; } unset($Qtotals); if (osc_empty($Qorder->value('delivery_name') === false) && osc_empty($Qorder->value('delivery_street_address') === false)) { $address = array('name' => $Qorder->value('delivery_name'), 'company' => $Qorder->value('delivery_company'), 'street_address' => $Qorder->value('delivery_street_address'), 'suburb' => $Qorder->value('delivery_suburb'), 'city' => $Qorder->value('delivery_city'), 'state' => $Qorder->value('delivery_state'), 'zone_code' => $Qorder->value('delivery_state_code'), 'country_title' => $Qorder->value('delivery_country'), 'country_iso2' => $Qorder->value('delivery_country_iso2'), 'country_iso3' => $Qorder->value('delivery_country_iso3'), 'postcode' => $Qorder->value('delivery_postcode'), 'format' => $Qorder->value('delivery_address_format')); $delivery_address = osC_Address::format($address, "<br />"); unset($address); } $address = array('name' => $Qorder->value('billing_name'), 'company' => $Qorder->value('billing_company'), 'street_address' => $Qorder->value('billing_street_address'), 'suburb' => $Qorder->value('billing_suburb'), 'city' => $Qorder->value('billing_city'), 'state' => $Qorder->value('billing_state'), 'zone_code' => $Qorder->value('billing_state_code'), 'country_title' => $Qorder->value('billing_country'), 'country_iso2' => $Qorder->value('billing_country_iso2'), 'country_iso3' => $Qorder->value('billing_country_iso3'), 'postcode' => $Qorder->value('billing_postcode'), 'format' => $Qorder->value('billing_address_format')); $billing_address = osC_Address::format($address, "<br />"); unset($address); $Qstatus = $osC_Database->query('select orders_status_name from :table_orders_status where orders_status_id = :orders_status_id and language_id = :language_id'); $Qstatus->bindTable(':table_orders_status', TABLE_ORDERS_STATUS); $Qstatus->bindInt(':orders_status_id', $Qorder->valueInt('orders_status')); $Qstatus->bindInt(':language_id', $osC_Language->getID()); $Qstatus->execute(); $order_status = $Qstatus->value('orders_status_name'); unset($Qstatus); $Qstatuses = $osC_Database->query('select date_added, comments from :table_orders_status_history where orders_id = :orders_id and comments != "" order by orders_status_history_id'); $Qstatuses->bindTable(':table_orders_status_history', TABLE_ORDERS_STATUS_HISTORY); $Qstatuses->bindInt(':orders_id', $this->_order_id); $Qstatuses->execute(); $order_comments = ''; while ($Qstatuses->next()) { $order_comments .= osC_DateTime::getLong($Qstatuses->value('date_added')) . "<br />\t" . wordwrap(str_replace("<br />", "<br />\t", $Qstatuses->value('comments')), 60, "<br />\t", 1) . "<br /><br />"; } unset($Qstatuses); $replaces = array($order_number, $invoice_link, $date_ordered, $order_details, $delivery_address, $billing_address, $order_status, $order_comments, STORE_NAME, STORE_OWNER_EMAIL_ADDRESS); $this->_title = str_replace($this->_keywords, $replaces, $this->_title); $this->_email_text = str_replace($this->_keywords, $replaces, $this->_content); } unset($Qorder); }
function sendEmail($id) { global $osC_Database, $osC_Language, $osC_Currencies; $Qorder = $osC_Database->query('select * from :table_orders where orders_id = :orders_id limit 1'); $Qorder->bindTable(':table_orders', TABLE_ORDERS); $Qorder->bindInt(':orders_id', $id); $Qorder->execute(); if ($Qorder->numberOfRows() === 1) { $email_order = STORE_NAME . "\n" . $osC_Language->get('email_order_separator') . "\n" . sprintf($osC_Language->get('email_order_order_number'), $id) . "\n" . sprintf($osC_Language->get('email_order_invoice_url'), osc_href_link(FILENAME_ACCOUNT, 'orders=' . $id, 'SSL', false, true, true)) . "\n" . sprintf($osC_Language->get('email_order_date_ordered'), osC_DateTime::getLong()) . "\n\n" . $osC_Language->get('email_order_products') . "\n" . $osC_Language->get('email_order_separator') . "\n"; $Qproducts = $osC_Database->query('select orders_products_id, products_model, products_name, products_price, products_tax, products_quantity from :table_orders_products where orders_id = :orders_id order by orders_products_id'); $Qproducts->bindTable(':table_orders_products', TABLE_ORDERS_PRODUCTS); $Qproducts->bindInt(':orders_id', $id); $Qproducts->execute(); while ($Qproducts->next()) { $email_order .= $Qproducts->valueInt('products_quantity') . ' x ' . $Qproducts->value('products_name') . ' (' . $Qproducts->value('products_model') . ') = ' . $osC_Currencies->displayPriceWithTaxRate($Qproducts->value('products_price'), $Qproducts->value('products_tax'), $Qproducts->valueInt('products_quantity'), false, $Qorder->value('currency'), $Qorder->value('currency_value')) . "\n"; $Qvariants = $osC_Database->query('select group_title, value_title from :table_orders_products_variants where orders_id = :orders_id and orders_products_id = :orders_products_id order by id'); $Qvariants->bindTable(':table_orders_products_variants', TABLE_ORDERS_PRODUCTS_VARIANTS); $Qvariants->bindInt(':orders_id', $id); $Qvariants->bindInt(':orders_products_id', $Qproducts->valueInt('orders_products_id')); $Qvariants->execute(); while ($Qvariants->next()) { $email_order .= "\t" . $Qvariants->value('group_title') . ': ' . $Qvariants->value('value_title') . "\n"; } } unset($Qproducts); unset($Qvariants); $email_order .= $osC_Language->get('email_order_separator') . "\n"; $Qtotals = $osC_Database->query('select title, text from :table_orders_total where orders_id = :orders_id order by sort_order'); $Qtotals->bindTable(':table_orders_total', TABLE_ORDERS_TOTAL); $Qtotals->bindInt(':orders_id', $id); $Qtotals->execute(); while ($Qtotals->next()) { $email_order .= strip_tags($Qtotals->value('title') . ' ' . $Qtotals->value('text')) . "\n"; } unset($Qtotals); if (osc_empty($Qorder->value('delivery_name')) === false && osc_empty($Qorder->value('delivery_street_address')) === false) { $address = array('name' => $Qorder->value('delivery_name'), 'company' => $Qorder->value('delivery_company'), 'street_address' => $Qorder->value('delivery_street_address'), 'suburb' => $Qorder->value('delivery_suburb'), 'city' => $Qorder->value('delivery_city'), 'state' => $Qorder->value('delivery_state'), 'zone_code' => $Qorder->value('delivery_state_code'), 'country_title' => $Qorder->value('delivery_country'), 'country_iso2' => $Qorder->value('delivery_country_iso2'), 'country_iso3' => $Qorder->value('delivery_country_iso3'), 'postcode' => $Qorder->value('delivery_postcode'), 'format' => $Qorder->value('delivery_address_format')); $email_order .= "\n" . $osC_Language->get('email_order_delivery_address') . "\n" . $osC_Language->get('email_order_separator') . "\n" . osC_Address::format($address) . "\n"; unset($address); } $address = array('name' => $Qorder->value('billing_name'), 'company' => $Qorder->value('billing_company'), 'street_address' => $Qorder->value('billing_street_address'), 'suburb' => $Qorder->value('billing_suburb'), 'city' => $Qorder->value('billing_city'), 'state' => $Qorder->value('billing_state'), 'zone_code' => $Qorder->value('billing_state_code'), 'country_title' => $Qorder->value('billing_country'), 'country_iso2' => $Qorder->value('billing_country_iso2'), 'country_iso3' => $Qorder->value('billing_country_iso3'), 'postcode' => $Qorder->value('billing_postcode'), 'format' => $Qorder->value('billing_address_format')); $email_order .= "\n" . $osC_Language->get('email_order_billing_address') . "\n" . $osC_Language->get('email_order_separator') . "\n" . osC_Address::format($address) . "\n\n"; unset($address); $Qstatus = $osC_Database->query('select orders_status_name from :table_orders_status where orders_status_id = :orders_status_id and language_id = :language_id'); $Qstatus->bindTable(':table_orders_status', TABLE_ORDERS_STATUS); $Qstatus->bindInt(':orders_status_id', $Qorder->valueInt('orders_status')); $Qstatus->bindInt(':language_id', $osC_Language->getID()); $Qstatus->execute(); $email_order .= sprintf($osC_Language->get('email_order_status'), $Qstatus->value('orders_status_name')) . "\n" . $osC_Language->get('email_order_separator') . "\n"; unset($Qstatus); $Qstatuses = $osC_Database->query('select date_added, comments from :table_orders_status_history where orders_id = :orders_id and comments != "" order by orders_status_history_id'); $Qstatuses->bindTable(':table_orders_status_history', TABLE_ORDERS_STATUS_HISTORY); $Qstatuses->bindInt(':orders_id', $id); $Qstatuses->execute(); while ($Qstatuses->next()) { $email_order .= osC_DateTime::getLong($Qstatuses->value('date_added')) . "\n\t" . wordwrap(str_replace("\n", "\n\t", $Qstatuses->value('comments')), 60, "\n\t", 1) . "\n\n"; } unset($Qstatuses); // if (is_object($GLOBALS[$payment])) { // $email_order .= $osC_Language->get('email_order_payment_method') . "\n" . // $osC_Language->get('email_order_separator') . "\n"; // $email_order .= $osC_ShoppingCart->getBillingMethod('title') . "\n\n"; // if (isset($GLOBALS[$payment]->email_footer)) { // $email_order .= $GLOBALS[$payment]->email_footer . "\n\n"; // } // } osc_email($Qorder->value('customers_name'), $Qorder->value('customers_email_address'), $osC_Language->get('email_order_subject'), $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); // send emails to other people if (SEND_EXTRA_ORDER_EMAILS_TO != '') { osc_email('', SEND_EXTRA_ORDER_EMAILS_TO, $osC_Language->get('email_order_subject'), $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } } unset($Qorder); }
echo $order->info['shipping_method']; ?> </p> <?php } } ?> <h6><?php echo $osC_Language->get('order_billing_address_title'); ?> </h6> <p><?php echo osC_Address::format($order->billing, '<br />'); ?> </p> <h6><?php echo $osC_Language->get('order_payment_method_title'); ?> </h6> <p><?php echo $order->info['payment_method']; ?> </p> </td> <td width="70%" valign="top"> <div style="border: 1px; border-style: solid; border-color: #CCCCCC; background-color: #FBFBFB; padding: 5px;">