function getOrdersReturns() { global $toC_Json, $osC_Language, $osC_Database; $osC_Order = new osC_Order($Qreturns->valueInt('orders_id')); $Qreturns = $osC_Database->query('select r.orders_returns_id, r.orders_id, r.orders_returns_status_id, r.customers_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 r.orders_id = :orders_id and ors.languages_id = :languages_id'); $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(':orders_id', $_REQUEST['orders_id']); $Qreturns->bindInt(':languages_id', $osC_Language->getID()); $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(); 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']; $quantity += $return_products_qty[$product['orders_products_id']]; } } $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), 'admin_comments' => $Qreturns->value('admin_comments'), 'customers_comments' => $Qreturns->value('customers_comments'), 'total' => $total); } $response = array(EXT_JSON_READER_TOTAL => $Qreturns->getBatchSize(), EXT_JSON_READER_ROOT => $records); echo $toC_Json->encode($response); }
echo $osC_Language->get('table_heading_price_gross'); ?> </th> <th><?php echo $osC_Language->get('table_heading_total_net'); ?> </th> <th><?php echo $osC_Language->get('table_heading_total_gross'); ?> </th> </tr> </thead> <tbody> <?php foreach ($osC_Order->getProducts() as $product) { echo ' <tr>' . "\n" . ' <td valign="top" align="right">' . $product['quantity'] . ' x</td>' . "\n" . ' <td valign="top">' . $product['name']; if (isset($product['attributes']) && sizeof($product['attributes']) > 0) { foreach ($product['attributes'] as $attribute) { echo '<br /><nobr> ' . $attribute['option'] . ': ' . $attribute['value'] . '</nobr>'; } } echo ' </td>' . "\n" . ' <td valign="top">' . $product['model'] . '</td>' . "\n"; echo ' <td align="right" valign="top">' . $osC_Tax->displayTaxRateValue($product['tax']) . '</td>' . "\n" . ' <td align="right" valign="top"><b>' . $osC_Currencies->format($product['price'], true, $osC_Order->getCurrency(), $osC_Order->getCurrencyValue()) . '</b></td>' . "\n" . ' <td align="right" valign="top"><b>' . $osC_Currencies->displayPriceWithTaxRate($product['price'], $product['tax'], 1, true, $osC_Order->getCurrency(), $osC_Order->getCurrencyValue()) . '</b></td>' . "\n" . ' <td align="right" valign="top"><b>' . $osC_Currencies->format($product['price'] * $product['quantity'], true, $osC_Order->getCurrency(), $osC_Order->getCurrencyValue()) . '</b></td>' . "\n" . ' <td align="right" valign="top"><b>' . $osC_Currencies->displayPriceWithTaxRate($product['price'], $product['tax'], $product['quantity'], true, $osC_Order->getCurrency(), $osC_Order->getCurrencyValue()) . '</b></td>' . "\n"; echo ' </tr>' . "\n"; } ?> </tbody> </table> <table border="0" width="100%" cellspacing="0" cellpadding="2">
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); }
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); }
function createStoreCredit($data) { global $osC_Database, $osC_Language; $error = false; $osC_Database->startTransaction(); //order refund $Qinsert = $osC_Database->query('insert into :table_orders_refunds (orders_refunds_type, orders_id, credit_slips_id, sub_total, shipping, handling, refund_total, comments, date_added) values (:orders_refunds_type, :orders_id, :credit_slips_id, :sub_total, :shipping, :handling, :refund_total, :comments, now())'); $Qinsert->bindTable(':table_orders_refunds', TABLE_ORDERS_REFUNDS); $Qinsert->bindInt(':orders_refunds_type', ORDERS_RETURNS_TYPE_STORE_CREDIT); $Qinsert->bindInt(':orders_id', $data['orders_id']); $Qinsert->bindRaw(':credit_slips_id', 'null'); $Qinsert->bindValue(':sub_total', $data['sub_total']); $Qinsert->bindValue(':shipping', $data['shipping_fee']); $Qinsert->bindValue(':handling', $data['handling']); $Qinsert->bindValue(':refund_total', $data['sub_total'] + $data['shipping_fee'] + $data['handling']); $Qinsert->bindValue(':comments', $data['comments']); $Qinsert->setLogging($_SESSION['module'], null); $Qinsert->execute(); if ($osC_Database->isError()) { $error = true; } else { $orders_refunds_id = $osC_Database->nextID(); //orders refunds products $return_products = explode(';', $data['return_quantity']); foreach ($return_products as $product) { list($orders_products_id, $quantity) = explode(':', $product); $Qproduct = $osC_Database->query('insert into :table_orders_refunds_products (orders_refunds_id, orders_products_id, products_quantity) values (:orders_refunds_id, :orders_products_id, :products_quantity)'); $Qproduct->bindTable(':table_orders_refunds_products', TABLE_ORDERS_REFUNDS_PRODUCTS); $Qproduct->bindInt(':orders_refunds_id', $orders_refunds_id); $Qproduct->bindInt(':orders_products_id', $orders_products_id); $Qproduct->bindInt(':products_quantity', $quantity); $Qproduct->setLogging($_SESSION['module'], $orders_refunds_id); $Qproduct->execute(); if ($osC_Database->isError()) { $error = true; break; } if ($error === false) { $Qupdate = $osC_Database->query('update :table_orders_products set products_return_quantity = products_return_quantity + :products_return_quantity where orders_products_id = :orders_products_id'); $Qupdate->bindTable(':table_orders_products', TABLE_ORDERS_PRODUCTS); $Qupdate->bindInt(':products_return_quantity', $quantity); $Qupdate->bindInt(':orders_products_id', $orders_products_id); $Qupdate->setLogging($_SESSION['module'], $orders_refunds_id); $Qupdate->execute(); if ($osC_Database->isError()) { $error = true; break; } } if ($error === false && $data['restock_quantity'] === true) { $Qcheck = $osC_Database->query('select products_id from :table_orders_products where orders_products_id = :orders_products_id and orders_id = :orders_id'); $Qcheck->bindTable(':table_orders_products', TABLE_ORDERS_PRODUCTS); $Qcheck->bindInt(':orders_products_id', $orders_products_id); $Qcheck->bindInt(':orders_id', $data['orders_id']); $Qcheck->setLogging($_SESSION['module'], $orders_refunds_id); $Qcheck->execute(); $products_id = $Qcheck->valueInt('products_id'); if (!osC_Product::restock($data['orders_id'], $orders_products_id, $products_id, $quantity)) { $error = true; break; } } } } if ($error === false) { $Qreturn = $osC_Database->query('update :table_orders_returns set orders_returns_status_id = :orders_returns_status_id, admin_comments = :admin_comments, date_updated = now() where orders_returns_id = :id'); $Qreturn->bindTable(':table_orders_returns', TABLE_ORDERS_RETURNS); $Qreturn->bindInt(':orders_returns_status_id', ORDERS_RETURNS_STATUS_REFUNDED_STORE_CREDIT); $Qreturn->bindValue(':admin_comments', $data['comment']); $Qreturn->bindInt(':id', $data['orders_returns_id']); $Qreturn->setLogging($_SESSION['module'], $data['orders_returns_id']); $Qreturn->execute(); if ($osC_Database->isError()) { $error = true; } } if ($error === false) { $Qcustomer = $osC_Database->query('select customers_id from :table_orders where orders_id = :orders_id'); $Qcustomer->bindTable(':table_orders', TABLE_ORDERS); $Qcustomer->bindInt(':orders_id', $data['orders_id']); $Qcustomer->execute(); $customers_id = $Qcustomer->valueInt('customers_id'); $Qhistory = $osC_Database->query('insert into :table_customers_credits_history (customers_id, action_type, date_added, amount, comments) values (:customers_id, :action_type, now(), :amount, :comments)'); $Qhistory->bindTable(':table_customers_credits_history', TABLE_CUSTOMERS_CREDITS_HISTORY); $Qhistory->bindInt(':customers_id', $customers_id); $Qhistory->bindInt(':action_type', STORE_CREDIT_ACTION_TYPE_ORDER_REFUNDED); $Qhistory->bindValue(':amount', $data['sub_total'] + $data['shipping_fee'] + $data['handling']); $Qhistory->bindValue(':comments', sprintf($osC_Language->get('infomation_store_credit_from_order'), $data['orders_id'])); $Qhistory->execute(); if ($osC_Database->isError()) { $error = true; } if ($error === false) { $Qupdate = $osC_Database->query('update :table_customers set customers_credits = (customers_credits + :customers_credits) where customers_id = :customers_id'); $Qupdate->bindTable(':table_customers', TABLE_CUSTOMERS); $Qupdate->bindRaw(':customers_credits', $data['sub_total'] + $data['shipping_fee'] + $data['handling']); $Qupdate->bindInt(':customers_id', $customers_id); $Qupdate->setLogging($_SESSION['module'], $data['$orders_refunds_id']); $Qupdate->execute(); if ($osC_Database->isError()) { $error = true; } } } if ($error === false) { $osC_Database->commitTransaction(); $osC_Order = new osC_Order($data['orders_id']); $return_products_ids = array(); $return_products_qty = array(); $return_products = explode(';', $data['return_quantity']); foreach ($return_products as $product) { list($orders_products_id, $quantity) = explode(':', $product); $return_products_ids[] = $orders_products_id; $return_products_qty[$orders_products_id] = $quantity; } $products = array(); 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; } } $customers_name = $osC_Order->getCustomer('name'); $customers_email_address = $osC_Order->getCustomer('email_address'); require_once 'includes/classes/currencies.php'; $osC_Currencies = new osC_Currencies_Admin(); include '../includes/classes/email_template.php'; $email_template = toC_Email_Template::getEmailTemplate('admin_create_order_store_credit'); $email_template->setData($customers_name, $customers_email_address, implode('<br />', $products), $data['orders_id'], $osC_Currencies->format($data['sub_total'] + $data['shipping_fee'] + $data['handling'])); $email_template->buildMessage(); $email_template->sendEmail(); return true; } $osC_Database->rollbackTransaction(); return false; }
function listOrders() { global $toC_Json, $osC_Database, $osC_Language; require_once 'includes/classes/order.php'; require_once 'includes/classes/currencies.php'; $osC_Currencies = new osC_Currencies_Admin(); $Qorders = $osC_Database->query('select o.orders_id, o.date_purchased, s.orders_status_name, ot.text as order_total from :table_orders o, :table_orders_total ot, :table_orders_status s where o.orders_id = ot.orders_id and ot.class = "total" and o.orders_status = s.orders_status_id and o.customers_email_address = :customers_email_address and s.language_id = :language_id '); $Qorders->bindTable(':table_orders', TABLE_ORDERS); $Qorders->bindTable(':table_orders_total', TABLE_ORDERS_TOTAL); $Qorders->bindTable(':table_orders_status', TABLE_ORDERS_STATUS); $Qorders->bindValue(':customers_email_address', $_REQUEST['email']); $Qorders->bindInt(':language_id', $osC_Language->getID()); $Qorders->execute(); $records = array(); while ($Qorders->next()) { $osC_Order = new osC_Order($Qorders->valueInt('orders_id')); $products_table = '<table width="100%">'; foreach ($osC_Order->getProducts() as $product) { $product_info = $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_table .= '<tr><td width="15">' . $product['quantity'] . ' x ' . '</td><td>' . $product_info . '</td><td valign="top" align="right" width="50">' . $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%">'; foreach ($osC_Order->getTotals() as $total) { $order_total .= '<tr><td align="right">' . $total['title'] . ' </td><td width="60" align="right">' . $total['text'] . '</td></tr>'; } $order_total .= '</table>'; $records[] = array('orders_id' => $Qorders->valueInt('orders_id'), 'order_total' => strip_tags($Qorders->value('order_total')), 'date_purchased' => osC_DateTime::getShort($Qorders->value('date_purchased')), 'orders_status_name' => $Qorders->value('orders_status_name'), 'products' => $products_table, 'totals' => $order_total); } $response = array(EXT_JSON_READER_ROOT => $records); echo $toC_Json->encode($response); }