function listGiftCertificates()
{
global $osC_Database, $toC_Json, $osC_Language, $osC_Currencies;
$osC_Currencies = new osC_Currencies_Admin();
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];
$limit = empty($_REQUEST['limit']) ? MAX_DISPLAY_SEARCH_RESULTS : $_REQUEST['limit'];
$Qcertificates = $osC_Database->query('select gc.*, o.customers_name, o.date_purchased from :table_gift_certificates gc, :table_orders o, :table_orders_products op where gc.orders_products_id = op.orders_products_id and op.orders_id = o.orders_id ');
if (!empty($_REQUEST['search'])) {
$Qcertificates->appendQuery('and o.customers_name like :customers_name');
$Qcertificates->bindValue(':customers_name', '%' . $_REQUEST['search'] . '%');
}
$Qcertificates->bindTable(':table_gift_certificates', TABLE_GIFT_CERTIFICATES);
$Qcertificates->bindTable(':table_orders', TABLE_ORDERS);
$Qcertificates->bindTable(':table_orders_products', TABLE_ORDERS_PRODUCTS);
$Qcertificates->setExtBatchLimit($start, $limit);
$Qcertificates->execute();
$records = array();
while ($Qcertificates->next()) {
$Qhistory = $osC_Database->query('select gcrh.*, o.customers_name from :table_gift_certificates_redeem_history gcrh, :table_orders o where gcrh.orders_id = o.orders_id and gcrh.gift_certificates_id = :gift_certificates_id');
$Qhistory->bindTable(':table_gift_certificates_redeem_history', TABLE_GIFT_CERTIFICATES_REDEEM_HISTORY);
$Qhistory->bindTable(':table_orders', TABLE_ORDERS);
$Qhistory->bindInt(':gift_certificates_id', $Qcertificates->ValueInt('gift_certificates_id'));
$Qhistory->execute();
$history = '<table style="padding-left: 20px;" cellspacing="5">
<tr>
<td>' . $osC_Language->get('table_heading_customer') . '</td>
<td>' . $osC_Language->get('table_heading_redeem_date') . '</td>
<td>' . $osC_Language->get('table_heading_redeem_amount') . '</td>
</tr>';
$redeem_amount = 0;
while ($Qhistory->next()) {
$redeem_amount += $Qhistory->Value('redeem_amount');
$history .= '<tr><td>' . $Qhistory->Value('customers_name') . '</td>
<td>' . osC_DateTime::getShort($Qhistory->Value('redeem_date')) . '</td>
<td>' . $osC_Currencies->format($Qhistory->Value('redeem_amount')) . '</td></tr>';
}
$history .= '</table>';
$Qhistory->freeResult();
$certificate_details = '<table style="padding-left: 20px" cellspacing="5">';
$certificate_details .= '<tr><td>' . $osC_Language->get('field_recipient_name') . '</td><td>' . $Qcertificates->Value('recipients_name') . '</td></tr>';
if ($Qcertificates->valueInt('gift_certificates_type') == GIFT_CERTIFICATE_TYPE_EMAIL) {
$certificate_details .= '<tr><td>' . $osC_Language->get('field_recipient_email') . '</td><td>' . $Qcertificates->Value('recipients_email') . '</td></tr>';
}
$certificate_details .= '<tr><td>' . $osC_Language->get('field_recipient_sender_name') . '</td><td>' . $Qcertificates->Value('senders_name') . '</td></tr>';
if ($Qcertificates->valueInt('gift_certificates_type') == GIFT_CERTIFICATE_TYPE_EMAIL) {
$certificate_details .= '<tr><td>' . $osC_Language->get('field_recipient_sender_email') . '</td><td>' . $Qcertificates->Value('senders_email') . '</td></tr>';
}
$certificate_details .= '<tr><td>' . $osC_Language->get('field_message') . '</td><td>' . $Qcertificates->Value('messages') . '</td></tr>';
$certificate_details .= '</table>';
$records[] = array('gift_certificates_id' => $Qcertificates->ValueInt('gift_certificates_id'), 'orders_products_id' => $Qcertificates->ValueInt('orders_products_id'), 'gift_certificates_code' => $Qcertificates->Value('gift_certificates_code'), 'gift_certificates_customer' => $Qcertificates->Value('customers_name'), 'gift_certificates_amount' => $osC_Currencies->format($Qcertificates->Value('amount')), 'gift_certificates_balance' => $osC_Currencies->format($Qcertificates->Value('amount') - $redeem_amount), 'gift_certificates_date_purchased' => osC_DateTime::getShort($Qcertificates->Value('date_purchased')), 'gift_certificates_date_status' => $Qcertificates->Value('status'), 'recipients_name' => $Qcertificates->Value('recipients_name'), 'recipients_email' => $Qcertificates->Value('recipients_email'), 'senders_name' => $Qcertificates->Value('senders_name'), 'senders_email' => $Qcertificates->Value('senders_email'), 'messages' => $Qcertificates->Value('messages'), 'certificate_details' => $certificate_details, 'history' => $history);
}
$response = array(EXT_JSON_READER_TOTAL => $Qcertificates->getBatchSize(), EXT_JSON_READER_ROOT => $records);
echo $toC_Json->encode($response);
}
public function __construct()
{
global $osC_Language, $osC_MessageStack;
parent::__construct();
$this->_page_contents = 'delete.php';
if (isset($_POST['subaction']) && $_POST['subaction'] == 'confirm') {
if (osC_Currencies_Admin::delete($_GET['cID'])) {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_success_action_performed'), 'success');
} else {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_error_action_not_performed'), 'error');
}
osc_redirect_admin(osc_href_link_admin(FILENAME_DEFAULT, $this->_module));
}
}
function setStatus($id, $flag)
{
global $osC_Database;
$Qstatus = $osC_Database->query('update :table_gift_certificates set status = :gift_certificates_status where gift_certificates_id = :gift_certificates_id');
$Qstatus->bindTable(':table_gift_certificates', TABLE_GIFT_CERTIFICATES);
$Qstatus->bindInt(':gift_certificates_status', $flag);
$Qstatus->bindInt(':gift_certificates_id', $id);
$Qstatus->setLogging($_SESSION['module'], $id);
$Qstatus->execute();
if (!$osC_Database->isError()) {
$data = self::getData($id);
if ($flag == '1' && $data['gift_certificates_type'] == GIFT_CERTIFICATE_TYPE_EMAIL) {
require_once 'includes/classes/currencies.php';
$osC_Currencies = new osC_Currencies_Admin();
require_once '../includes/classes/email_template.php';
$email = toC_Email_Template::getEmailTemplate('active_gift_certificate');
$email->setData($data['senders_name'], $data['senders_email'], $data['recipients_name'], $data['recipients_email'], $osC_Currencies->format($data['amount']), $data['gift_certificates_code'], $data['messages']);
$email->buildMessage();
$email->sendEmail();
}
return true;
}
return false;
}
public static function getAll()
{
if (!isset($_GET['search'])) {
$_GET['search'] = '';
}
if (!isset($_GET['page']) || !is_numeric($_GET['page'])) {
$_GET['page'] = 1;
}
if (!empty($_GET['search'])) {
$result = osC_Currencies_Admin::find($_GET['search'], $_GET['page']);
} else {
$result = osC_Currencies_Admin::getAll($_GET['page']);
}
$result['rpcStatus'] = RPC_STATUS_SUCCESS;
echo json_encode($result);
}
public function __construct()
{
global $osC_Language, $osC_MessageStack;
parent::__construct();
$this->_page_contents = 'update_rates.php';
if (isset($_POST['subaction']) && $_POST['subaction'] == 'confirm') {
if (isset($_POST['service']) && ($_POST['service'] == 'oanda' || $_POST['service'] == 'xe')) {
$results = osC_Currencies_Admin::updateRates($_POST['service']);
foreach ($results[0] as $result) {
$osC_MessageStack->add($this->_module, sprintf($osC_Language->get('ms_error_invalid_currency'), $result['title'], $result['code']), 'error');
}
foreach ($results[1] as $result) {
$osC_MessageStack->add($this->_module, sprintf($osC_Language->get('ms_success_currency_updated'), $result['title'], $result['code']), 'success');
}
}
osc_redirect_admin(osc_href_link_admin(FILENAME_DEFAULT, $this->_module));
}
}
public function __construct()
{
global $osC_Language, $osC_MessageStack;
parent::__construct();
if (isset($_GET['cID']) && is_numeric($_GET['cID'])) {
$this->_page_contents = 'edit.php';
} else {
$this->_page_contents = 'new.php';
}
if (isset($_POST['subaction']) && $_POST['subaction'] == 'confirm') {
$data = array('title' => $_POST['title'], 'code' => $_POST['code'], 'symbol_left' => $_POST['symbol_left'], 'symbol_right' => $_POST['symbol_right'], 'decimal_places' => $_POST['decimal_places'], 'value' => $_POST['value']);
if (osC_Currencies_Admin::save(isset($_GET['cID']) && is_numeric($_GET['cID']) ? $_GET['cID'] : null, $data, isset($_POST['default']) && $_POST['default'] == 'on' || isset($_POST['is_default']) && $_POST['is_default'] == 'true' && $_POST['code'] != DEFAULT_CURRENCY)) {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_success_action_performed'), 'success');
} else {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_error_action_not_performed'), 'error');
}
osc_redirect_admin(osc_href_link_admin(FILENAME_DEFAULT, $this->_module));
}
}
public function __construct()
{
global $osC_Language, $osC_MessageStack;
parent::__construct();
if (isset($_POST['batch']) && is_array($_POST['batch']) && !empty($_POST['batch'])) {
$this->_page_contents = 'batch_delete.php';
if (isset($_POST['subaction']) && $_POST['subaction'] == 'confirm') {
$error = false;
foreach ($_POST['batch'] as $id) {
if (!osC_Currencies_Admin::delete($id)) {
$error = true;
break;
}
}
if ($error === false) {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_success_action_performed'), 'success');
} else {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_error_action_not_performed'), 'error');
}
osc_redirect_admin(osc_href_link_admin(FILENAME_DEFAULT, $this->_module));
}
}
}
function getRefundHistory()
{
global $osC_Database, $osC_Language, $toC_Json;
$osC_Currencies = new osC_Currencies_Admin();
$osC_Order = new osC_Order($_REQUEST['orders_id']);
$Qrefunds = $osC_Database->query('select * from :table_orders_refunds where orders_id = :orders_id');
$Qrefunds->bindTable(':table_orders_refunds', TABLE_ORDERS_REFUNDS);
$Qrefunds->bindInt(':orders_id', $_REQUEST['orders_id']);
$Qrefunds->execute();
$records = array();
while ($Qrefunds->next()) {
$Qproducts = $osC_Database->query('select * 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', $Qrefunds->valueInt('orders_refunds_id'));
$Qproducts->execute();
$total_products = 0;
$products = array();
$products_table = '<table width="100%">';
while ($Qproducts->next()) {
foreach ($osC_Order->getProducts() as $product) {
if ($Qproducts->valueInt('orders_products_id') == $product['orders_products_id']) {
$total_products += $Qproducts->valueInt('products_quantity');
$product_info = $Qproducts->valueInt('products_quantity') . ' 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;
$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">' . $osC_Currencies->format($Qrefunds->value('sub_total')) . '</td></tr>';
$order_total .= '<tr><td align="right">' . $osC_Language->get("field_shipping_fee") . ' </td><td width="60">' . $osC_Currencies->format($Qrefunds->value('shipping')) . '</td></tr>';
$order_total .= '<tr><td align="right">' . $osC_Language->get("field_handling") . ' </td><td width="60">' . $osC_Currencies->format($Qrefunds->value('handling')) . '</td></tr>';
$order_total .= '<tr><td align="right">' . $osC_Language->get("field_refund_total") . ' </td><td width="60">' . $osC_Currencies->format($Qrefunds->value('refund_total')) . '</td></tr>';
$order_total .= '</table>';
$records[] = array('orders_refunds_id' => $Qrefunds->valueInt('orders_refunds_id'), 'orders_refunds_type' => $Qrefunds->valueInt('orders_refunds_type') == ORDERS_RETURNS_TYPE_CREDIT_SLIP ? $osC_Language->get('text_credit_slip') : $osC_Language->get('text_store_credit'), 'total_products' => $total_products, 'total_refund' => $osC_Currencies->format($Qrefunds->value('refund_total')), 'sub_total' => $osC_Currencies->format($Qrefunds->value('sub_total')), 'date_added' => osC_DateTime::getShort($Qrefunds->value('date_added')), 'comments' => $Qrefunds->value('comments'), 'products' => $products_table, 'totals' => $order_total);
}
$response = array(EXT_JSON_READER_ROOT => $records);
echo $toC_Json->encode($response);
}
<?php
/*
$Id: $
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2009 osCommerce
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License v2 (1991)
as published by the Free Software Foundation.
*/
$osC_ObjectInfo = new osC_ObjectInfo(osC_Currencies_Admin::get($_GET['cID']));
?>
<h1><?php
echo osc_link_object(osc_href_link_admin(FILENAME_DEFAULT, $osC_Template->getModule()), $osC_Template->getPageTitle());
?>
</h1>
<?php
if ($osC_MessageStack->exists($osC_Template->getModule())) {
echo $osC_MessageStack->get($osC_Template->getModule());
}
?>
<div class="infoBoxHeading"><?php
echo osc_icon('trash.png') . ' ' . $osC_ObjectInfo->getProtected('title');
?>
function render()
{
global $osC_Language;
//New Page
$this->_pdf->AddPage();
//Title
$this->_pdf->SetFont(TOC_PDF_FONT, 'B', TOC_PDF_TITLE_FONT_SIZE);
$this->_pdf->SetY(TOC_PDF_POS_HEADING_TITLE_Y);
$this->_pdf->MultiCell(70, 4, $osC_Language->get('pdf_invoice_heading_title'), 0, 'L');
//Date purchase & order ID field title
$this->_pdf->SetFont(TOC_PDF_FONT, 'B', TOC_PDF_FIELD_DATE_PURCHASE_FONT_SIZE);
$this->_pdf->SetY(TOC_PDF_POS_DOC_INFO_FIELD_Y);
$this->_pdf->SetX(135);
$this->_pdf->MultiCell(55, 4, $osC_Language->get('operation_heading_invoice_number') . ':' . "\n" . $osC_Language->get('operation_heading_invoice_date') . ':' . "\n" . $osC_Language->get('operation_heading_order_id') . ':', 0, 'L');
//Date purchase & order ID field value
$this->_pdf->SetFont(TOC_PDF_FONT, '', TOC_PDF_FIELD_DATE_PURCHASE_FONT_SIZE);
$this->_pdf->SetY(TOC_PDF_POS_DOC_INFO_VALUE_Y);
$this->_pdf->SetX(150);
$this->_pdf->MultiCell(40, 4, $this->_order->getInvoiceNumber() . "\n" . osC_DateTime::getShort($this->_order->getInvoiceDate()) . "\n" . $this->_order->getOrderID(), 0, 'R');
//Products
$this->_pdf->SetFont(TOC_PDF_FONT, 'B', TOC_PDF_TABLE_HEADING_FONT_SIZE);
$this->_pdf->SetY(TOC_PDF_POS_PRODUCTS_TABLE_HEADING_Y);
$this->_pdf->Cell(8, 6, '', 'TB', 0, 'R', 0);
$this->_pdf->Cell(78, 6, $osC_Language->get('table_heading_products'), 'TB', 0, 'C', 0);
$this->_pdf->Cell(35, 6, $osC_Language->get('table_heading_quantity'), 'TB', 0, 'C', 0);
$this->_pdf->Cell(30, 6, $osC_Language->get('table_heading_price'), 'TB', 0, 'R', 0);
$this->_pdf->Cell(30, 6, $osC_Language->get('table_heading_total'), 'TB', 0, 'R', 0);
$this->_pdf->Ln();
$i = 0;
$y_table_position = TOC_PDF_POS_PRODUCTS_TABLE_CONTENT_Y;
$osC_Currencies = new osC_Currencies_Admin();
foreach ($this->_order->getProducts() as $products) {
$rowspan = 1;
//Pos
$this->_pdf->SetFont(TOC_PDF_FONT, 'B', TOC_PDF_TABLE_CONTENT_FONT_SIZE);
$this->_pdf->SetY($y_table_position);
$this->_pdf->MultiCell(8, 4, $i + 1, 0, 'C');
//Product
$this->_pdf->SetY($y_table_position);
$this->_pdf->SetX(30);
$product_info = $products['name'];
if ($products['type'] == PRODUCT_TYPE_GIFT_CERTIFICATE) {
$product_info .= "\n" . ' -' . $osC_Language->get('senders_name') . ': ' . $products['senders_name'];
if ($products['gift_certificates_type'] == GIFT_CERTIFICATE_TYPE_EMAIL) {
$product_info .= "\n" . ' -' . $osC_Language->get('senders_email') . ': ' . $products['senders_email'];
$rowspan++;
}
$product_info .= "\n" . ' -' . $osC_Language->get('recipients_name') . ': ' . $products['recipients_name'];
if ($products['gift_certificates_type'] == GIFT_CERTIFICATE_TYPE_EMAIL) {
$product_info .= "\n" . ' -' . $osC_Language->get('recipients_email') . ': ' . $products['recipients_email'];
$rowspan++;
}
$rowspan += 3;
$product_info .= "\n" . ' -' . $osC_Language->get('messages') . ': ' . $products['messages'];
}
if (isset($products['variants']) && sizeof($products['variants']) > 0) {
foreach ($products['variants'] as $variant) {
$product_info .= "\n" . $variant['groups_name'] . ": " . $variant['values_name'];
$rowspan++;
}
}
$this->_pdf->MultiCell(100, 4, $product_info, 0, 'L');
//Quantity
$this->_pdf->SetY($y_table_position);
$this->_pdf->SetX(110);
$this->_pdf->MultiCell(5, 4, $products['quantity'], 0, 'C');
//Price
$this->_pdf->SetY($y_table_position);
$this->_pdf->SetX(135);
$price = $osC_Currencies->displayPriceWithTaxRate($products['final_price'], $products['tax'], 1, $this->_order->getCurrency(), $this->_order->getCurrencyValue());
$price = str_replace(' ', ' ', $price);
$this->_pdf->MultiCell(20, 4, $price, 0, 'R');
//Total
$this->_pdf->SetY($y_table_position);
$this->_pdf->SetX(165);
$total = $osC_Currencies->displayPriceWithTaxRate($products['final_price'], $products['tax'], $products['quantity'], $this->_order->getCurrency(), $this->_order->getCurrencyValue());
$total = str_replace(' ', ' ', $total);
$this->_pdf->MultiCell(20, 4, $total, 0, 'R');
$y_table_position += $rowspan * TOC_PDF_TABLE_CONTENT_HEIGHT;
//products list exceed page height, create a new page
if ($y_table_position - TOC_PDF_POS_CONTENT_Y - 6 > 160) {
$this->_pdf->AddPage();
$y_table_position = TOC_PDF_POS_CONTENT_Y + 6;
$this->_pdf->SetFont(TOC_PDF_FONT, 'B', TOC_PDF_TABLE_HEADING_FONT_SIZE);
$this->_pdf->SetY(TOC_PDF_POS_CONTENT_Y);
$this->_pdf->Cell(8, 6, '', 'TB', 0, 'R', 0);
$this->_pdf->Cell(78, 6, $osC_Language->get('table_heading_products'), 'TB', 0, 'C', 0);
$this->_pdf->Cell(35, 6, $osC_Language->get('table_heading_quantity'), 'TB', 0, 'C', 0);
$this->_pdf->Cell(30, 6, $osC_Language->get('table_heading_price'), 'TB', 0, 'R', 0);
$this->_pdf->Cell(30, 6, $osC_Language->get('table_heading_total'), 'TB', 0, 'R', 0);
$this->_pdf->Ln();
}
$i++;
}
$this->_pdf->SetY($y_table_position + 1);
$this->_pdf->Cell(180, 7, '', 'T', 0, 'C', 0);
//Order Totals
$this->_pdf->SetFont(TOC_PDF_FONT, 'B', TOC_PDF_TABLE_CONTENT_FONT_SIZE);
foreach ($this->_order->getTotals() as $totals) {
$y_table_position += 4;
$this->_pdf->SetFont(TOC_PDF_FONT, 'B', 8);
$this->_pdf->SetY($y_table_position);
$this->_pdf->SetX(40);
$this->_pdf->MultiCell(120, 5, $totals['title'], 0, 'R');
$this->_pdf->SetFont(TOC_PDF_FONT, 'B', 8);
$this->_pdf->SetY($y_table_position);
$this->_pdf->SetX(145);
$this->_pdf->MultiCell(40, 5, strip_tags($totals['text']), 0, 'R');
}
$this->_pdf->Output("Invoice", "I");
}
function activeGiftCertificates($orders_id)
{
global $osC_Database;
require_once 'includes/classes/currencies.php';
$osC_Currencies = new osC_Currencies_Admin();
//create email template object
require_once '../includes/classes/email_template.php';
$email = toC_Email_Template::getEmailTemplate('active_gift_certificate');
//retrieve gift certifcates
$Qcertificates = $osC_Database->query('select * from :table_gift_certificates where orders_id = :orders_id');
$Qcertificates->bindTable(':table_gift_certificates', TABLE_GIFT_CERTIFICATES);
$Qcertificates->bindInt(':orders_id', $orders_id);
$Qcertificates->execute();
while ($Qcertificates->next()) {
if ($Qcertificates->valueInt('status') == 0) {
//update gift certificate status
$Qupdate = $osC_Database->query('update :table_gift_certificates set status = :status where gift_certificates_id = :gift_certificates_id');
$Qupdate->bindTable(':table_gift_certificates', TABLE_GIFT_CERTIFICATES);
$Qupdate->bindInt(':status', 1);
$Qupdate->bindInt(':gift_certificates_id', $Qcertificates->valueInt('gift_certificates_id'));
$Qupdate->setLogging($_SESSION['module'], $orders_id);
$Qupdate->execute();
//send notification email
if ($Qcertificates->valueInt('type') == GIFT_CERTIFICATE_TYPE_EMAIL) {
$email->resetRecipients();
$email->setData($Qcertificates->value('senders_name'), $Qcertificates->value('senders_email'), $Qcertificates->value('recipients_name'), $Qcertificates->value('recipients_email'), $osC_Currencies->format($Qcertificates->value('amount')), $Qcertificates->value('gift_certificates_code'), $Qcertificates->value('messages'));
$email->buildMessage();
$email->sendEmail();
}
}
}
}
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 getRedeemHistory()
{
global $toC_Json, $osC_Database;
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];
$limit = empty($_REQUEST['limit']) ? MAX_DISPLAY_SEARCH_RESULTS : $_REQUEST['limit'];
$coupons_id = isset($_REQUEST['coupons_id']) && is_numeric($_REQUEST['coupons_id']) ? $_REQUEST['coupons_id'] : null;
$osC_Currencies = new osC_Currencies_Admin();
$Qcoupons = $osC_Database->query("select crh.*, ot.value, c.customers_id, c.customers_firstname, c.customers_lastname from :table_coupons_redeem_history crh, :table_orders_total ot, :table_customers c where crh.coupons_id = :coupons_id and crh.orders_id = ot.orders_id and crh.customers_id = c.customers_id and ot.class = 'coupon' order by crh.orders_id");
$Qcoupons->bindTable(':table_coupons_redeem_history', TABLE_COUPONS_REDEEM_HISTORY);
$Qcoupons->bindTable(':table_orders_total', TABLE_ORDERS_TOTAL);
$Qcoupons->bindTable(':table_customers', TABLE_CUSTOMERS);
$Qcoupons->bindInt(':coupons_id', $coupons_id);
$Qcoupons->setExtBatchLimit($start, $limit);
$Qcoupons->execute();
$records = array();
while ($Qcoupons->next()) {
$records[] = array('customers_id' => $Qcoupons->valueInt('customers_id'), 'customers_name' => $Qcoupons->value('customers_firstname') . ' ' . $Qcoupons->value('customers_lastname'), 'orders_id' => $Qcoupons->valueInt('orders_id'), 'redeem_amount' => $osC_Currencies->format($Qcoupons->value('redeem_amount')), 'redeem_date' => osC_DateTime::getShort($Qcoupons->value('redeem_date')), 'redeem_id_address' => $Qcoupons->value('redeem_ip_address'));
}
$Qcoupons->freeResult();
$response = array(EXT_JSON_READER_TOTAL => $Qcoupons->getBatchSize(), EXT_JSON_READER_ROOT => $records);
echo $toC_Json->encode($response);
}
function saveBlance()
{
global $toC_Json, $osC_Language, $osC_Database;
$osC_Currencies = new osC_Currencies_Admin();
$data = array('amount' => $_REQUEST['amount'], 'comments' => $_REQUEST['comments'], 'customers_id' => $_REQUEST['customers_id'], 'notify' => isset($_REQUEST['notify']) && $_REQUEST['notify'] == 'on' ? '1' : '0');
if (osC_Customers_Admin::saveBlance($data)) {
$data = osC_Customers_Admin::getData($_REQUEST['customers_id']);
$response = array('success' => true, 'customers_credits' => $osC_Currencies->format($data['customers_credits']), 'feedback' => $osC_Language->get('ms_success_action_performed'));
} else {
$response = array('success' => false, 'feedback' => $osC_Language->get('ms_error_action_not_performed'));
}
echo $toC_Json->encode($response);
}
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);
}
function updateCurrencyRates()
{
global $toC_Json, $osC_Language;
$error = false;
$feedback = array();
$results = osC_Currencies_Admin::updateRates($_REQUEST['service']);
if (count($results[0])) {
$error = true;
foreach ($results[0] as $result) {
$feedback[] = sprintf($osC_Language->get('ms_error_invalid_currency'), $result['title'], $result['code']);
}
}
if (count($results[1])) {
foreach ($results[1] as $result) {
$feedback[] = sprintf($osC_Language->get('ms_success_currency_updated'), $result['title'], $result['code']);
}
}
if ($error === false) {
$response = array('success' => true, 'feedback' => $osC_Language->get('ms_success_action_performed') . '<br />' . implode('<br />', $feedback));
} else {
$response = array('success' => false, 'feedback' => $osC_Language->get('ms_error_action_not_performed') . '<br />' . implode('<br />', $feedback));
}
echo $toC_Json->encode($response);
}
http://www.oscommerce.com
Copyright (c) 2009 osCommerce
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License v2 (1991)
as published by the Free Software Foundation.
*/
$languages_array = array(array('id' => '0', 'text' => $osC_Language->get('none')));
foreach (osc_toObjectInfo(osC_Languages_Admin::getAll(-1))->get('entries') as $l) {
if ($l['languages_id'] != $_GET['lID']) {
$languages_array[] = array('id' => $l['languages_id'], 'text' => $l['name'] . ' (' . $l['code'] . ')');
}
}
$currencies_array = array();
foreach (osc_toObjectInfo(osC_Currencies_Admin::getAll(-1))->get('entries') as $c) {
$currencies_array[] = array('id' => $c['currencies_id'], 'text' => $c['title']);
}
$osC_ObjectInfo = new osC_ObjectInfo(osC_Languages_Admin::get($_GET['lID']));
?>
<h1><?php
echo osc_link_object(osc_href_link_admin(FILENAME_DEFAULT, $osC_Template->getModule()), $osC_Template->getPageTitle());
?>
</h1>
<?php
if ($osC_MessageStack->exists($osC_Template->getModule())) {
echo $osC_MessageStack->get($osC_Template->getModule());
}
?>
public static function import($file, $type)
{
global $osC_Database;
if (file_exists('../includes/languages/' . $file . '.xml')) {
$osC_XML = new osC_XML(file_get_contents('../includes/languages/' . $file . '.xml'));
$source = $osC_XML->toArray();
$language = array('name' => $source['language']['data']['title'], 'code' => $source['language']['data']['code'], 'locale' => $source['language']['data']['locale'], 'charset' => $source['language']['data']['character_set'], 'date_format_short' => $source['language']['data']['date_format_short'], 'date_format_long' => $source['language']['data']['date_format_long'], 'time_format' => $source['language']['data']['time_format'], 'text_direction' => $source['language']['data']['text_direction'], 'currency' => $source['language']['data']['default_currency'], 'numeric_separator_decimal' => $source['language']['data']['numerical_decimal_separator'], 'numeric_separator_thousands' => $source['language']['data']['numerical_thousands_separator'], 'parent_language_code' => isset($source['language']['data']['parent_language_code']) ? $source['language']['data']['parent_language_code'] : '', 'parent_id' => 0);
if (osC_Currencies_Admin::exists($language['currency']) === false) {
$language['currency'] = DEFAULT_CURRENCY;
}
if (!empty($language['parent_language_code']) && self::exists($language['parent_language_code'])) {
$language['parent_id'] = self::get($language['parent_language_code'], 'languages_id');
}
$definitions = array();
if (isset($source['language']['definitions']['definition'])) {
$definitions = $source['language']['definitions']['definition'];
if (isset($definitions['key']) && isset($definitions['value']) && isset($definitions['group'])) {
$definitions = array(array('key' => $definitions['key'], 'value' => $definitions['value'], 'group' => $definitions['group']));
}
}
unset($source);
$error = false;
$add_category_and_product_placeholders = true;
$osC_Database->startTransaction();
$language_id = self::get($language['code'], 'languages_id');
if ($language_id !== false) {
$add_category_and_product_placeholders = false;
$Qlanguage = $osC_Database->query('update :table_languages set name = :name, code = :code, locale = :locale, charset = :charset, date_format_short = :date_format_short, date_format_long = :date_format_long, time_format = :time_format, text_direction = :text_direction, currencies_id = :currencies_id, numeric_separator_decimal = :numeric_separator_decimal, numeric_separator_thousands = :numeric_separator_thousands, parent_id = :parent_id where languages_id = :languages_id');
$Qlanguage->bindInt(':languages_id', $language_id);
} else {
$Qlanguage = $osC_Database->query('insert into :table_languages (name, code, locale, charset, date_format_short, date_format_long, time_format, text_direction, currencies_id, numeric_separator_decimal, numeric_separator_thousands, parent_id) values (:name, :code, :locale, :charset, :date_format_short, :date_format_long, :time_format, :text_direction, :currencies_id, :numeric_separator_decimal, :numeric_separator_thousands, :parent_id)');
}
$Qlanguage->bindTable(':table_languages', TABLE_LANGUAGES);
$Qlanguage->bindValue(':name', $language['name']);
$Qlanguage->bindValue(':code', $language['code']);
$Qlanguage->bindValue(':locale', $language['locale']);
$Qlanguage->bindValue(':charset', $language['charset']);
$Qlanguage->bindValue(':date_format_short', $language['date_format_short']);
$Qlanguage->bindValue(':date_format_long', $language['date_format_long']);
$Qlanguage->bindValue(':time_format', $language['time_format']);
$Qlanguage->bindValue(':text_direction', $language['text_direction']);
$Qlanguage->bindInt(':currencies_id', osC_Currencies_Admin::get($language['currency'], 'currencies_id'));
$Qlanguage->bindValue(':numeric_separator_decimal', $language['numeric_separator_decimal']);
$Qlanguage->bindValue(':numeric_separator_thousands', $language['numeric_separator_thousands']);
$Qlanguage->bindInt(':parent_id', $language['parent_id']);
$Qlanguage->setLogging($_SESSION['module'], $language_id !== false ? $language_id : null);
$Qlanguage->execute();
if ($osC_Database->isError()) {
$error = true;
} else {
if ($language_id === false) {
$language_id = $osC_Database->nextID();
}
$default_language_id = osC_Languages_Admin::get(DEFAULT_LANGUAGE, 'languages_id');
if ($type == 'replace') {
$Qdel = $osC_Database->query('delete from :table_languages_definitions where languages_id = :languages_id');
$Qdel->bindTable(':table_languages_definitions', TABLE_LANGUAGES_DEFINITIONS);
$Qdel->bindInt(':languages_id', $language_id);
$Qdel->execute();
if ($osC_Database->isError()) {
$error = true;
}
}
}
if ($error === false) {
$osC_DirectoryListing = new osC_DirectoryListing('../includes/languages/' . $file);
$osC_DirectoryListing->setRecursive(true);
$osC_DirectoryListing->setIncludeDirectories(false);
$osC_DirectoryListing->setAddDirectoryToFilename(true);
$osC_DirectoryListing->setCheckExtension('xml');
foreach ($osC_DirectoryListing->getFiles() as $files) {
$definitions = array_merge($definitions, osC_Language_Admin::extractDefinitions($file . '/' . $files['name']));
}
foreach ($definitions as $def) {
$insert = false;
$update = false;
if ($type == 'replace') {
$insert = true;
} else {
$Qcheck = $osC_Database->query('select definition_key, content_group from :table_languages_definitions where definition_key = :definition_key and languages_id = :languages_id and content_group = :content_group');
$Qcheck->bindTable(':table_languages_definitions', TABLE_LANGUAGES_DEFINITIONS);
$Qcheck->bindValue(':definition_key', $def['key']);
$Qcheck->bindInt(':languages_id', $language_id);
$Qcheck->bindValue(':content_group', $def['group']);
$Qcheck->execute();
if ($Qcheck->numberOfRows() > 0) {
if ($type == 'update') {
$update = true;
}
} elseif ($type == 'add') {
$insert = true;
}
}
if ($insert === true || $update === true) {
if ($insert === true) {
$Qdef = $osC_Database->query('insert into :table_languages_definitions (languages_id, content_group, definition_key, definition_value) values (:languages_id, :content_group, :definition_key, :definition_value)');
} else {
$Qdef = $osC_Database->query('update :table_languages_definitions set content_group = :content_group, definition_key = :definition_key, definition_value = :definition_value where definition_key = :definition_key and languages_id = :languages_id and content_group = :content_group');
$Qdef->bindValue(':definition_key', $def['key']);
$Qdef->bindValue(':content_group', $def['group']);
}
$Qdef->bindTable(':table_languages_definitions', TABLE_LANGUAGES_DEFINITIONS);
$Qdef->bindInt(':languages_id', $language_id);
$Qdef->bindValue(':content_group', $def['group']);
$Qdef->bindValue(':definition_key', $def['key']);
$Qdef->bindValue(':definition_value', $def['value']);
$Qdef->execute();
if ($osC_Database->isError()) {
$error = true;
break;
}
}
}
}
if ($add_category_and_product_placeholders === true) {
if ($error === false) {
$Qcategories = $osC_Database->query('select categories_id, categories_name from :table_categories_description where language_id = :language_id');
$Qcategories->bindTable(':table_categories_description', TABLE_CATEGORIES_DESCRIPTION);
$Qcategories->bindInt(':language_id', $default_language_id);
$Qcategories->execute();
while ($Qcategories->next()) {
$Qinsert = $osC_Database->query('insert into :table_categories_description (categories_id, language_id, categories_name) values (:categories_id, :language_id, :categories_name)');
$Qinsert->bindTable(':table_categories_description', TABLE_CATEGORIES_DESCRIPTION);
$Qinsert->bindInt(':categories_id', $Qcategories->valueInt('categories_id'));
$Qinsert->bindInt(':language_id', $language_id);
$Qinsert->bindValue(':categories_name', $Qcategories->value('categories_name'));
$Qinsert->execute();
if ($osC_Database->isError()) {
$error = true;
break;
}
}
}
if ($error === false) {
$Qproducts = $osC_Database->query('select products_id, products_name, products_description, products_keyword, products_tags, products_url from :table_products_description where language_id = :language_id');
$Qproducts->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
$Qproducts->bindInt(':language_id', $default_language_id);
$Qproducts->execute();
while ($Qproducts->next()) {
$Qinsert = $osC_Database->query('insert into :table_products_description (products_id, language_id, products_name, products_description, products_keyword, products_tags, products_url) values (:products_id, :language_id, :products_name, :products_description, :products_keyword, :products_tags, :products_url)');
$Qinsert->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
$Qinsert->bindInt(':products_id', $Qproducts->valueInt('products_id'));
$Qinsert->bindInt(':language_id', $language_id);
$Qinsert->bindValue(':products_name', $Qproducts->value('products_name'));
$Qinsert->bindValue(':products_description', $Qproducts->value('products_description'));
$Qinsert->bindValue(':products_keyword', $Qproducts->value('products_keyword'));
$Qinsert->bindValue(':products_tags', $Qproducts->value('products_tags'));
$Qinsert->bindValue(':products_url', $Qproducts->value('products_url'));
$Qinsert->execute();
if ($osC_Database->isError()) {
$error = true;
break;
}
}
}
if ($error === false) {
$Qattributes = $osC_Database->query('select products_id, value from :table_product_attributes where languages_id = :languages_id');
$Qattributes->bindTable(':table_product_attributes', TABLE_PRODUCT_ATTRIBUTES);
$Qattributes->bindInt(':languages_id', $default_language_id);
$Qattributes->execute();
while ($Qattributes->next()) {
$Qinsert = $osC_Database->query('insert into :table_product_attributes (products_id, languages_id, value) values (:products_id, :languages_id, :value)');
$Qinsert->bindTable(':table_product_attributes', TABLE_PRODUCT_ATTRIBUTES);
$Qinsert->bindInt(':products_id', $Qattributes->valueInt('products_id'));
$Qinsert->bindInt(':languages_id', $language_id);
$Qinsert->bindValue(':value', $Qattributes->value('value'));
$Qinsert->execute();
if ($osC_Database->isError()) {
$error = true;
break;
}
}
}
if ($error === false) {
$Qgroups = $osC_Database->query('select id, title, sort_order, module from :table_products_variants_groups where languages_id = :languages_id');
$Qgroups->bindTable(':table_products_variants_groups', TABLE_PRODUCTS_VARIANTS_GROUPS);
$Qgroups->bindInt(':languages_id', $default_language_id);
$Qgroups->execute();
while ($Qgroups->next()) {
$Qinsert = $osC_Database->query('insert into :table_products_variants_groups (id, languages_id, title, sort_order, module) values (:id, :languages_id, :title, :sort_order, :module)');
$Qinsert->bindTable(':table_products_variants_groups', TABLE_PRODUCTS_VARIANTS_GROUPS);
$Qinsert->bindInt(':id', $Qgroups->valueInt('id'));
$Qinsert->bindInt(':languages_id', $language_id);
$Qinsert->bindValue(':title', $Qgroups->value('title'));
$Qinsert->bindInt(':sort_order', $Qgroups->valueInt('sort_order'));
$Qinsert->bindValue(':module', $Qgroups->value('module'));
$Qinsert->execute();
if ($osC_Database->isError()) {
$error = true;
break;
}
}
}
if ($error === false) {
$Qvalues = $osC_Database->query('select id, products_variants_groups_id, title, sort_order from :table_products_variants_values where languages_id = :languages_id');
$Qvalues->bindTable(':table_products_variants_values', TABLE_PRODUCTS_VARIANTS_VALUES);
$Qvalues->bindInt(':languages_id', $default_language_id);
$Qvalues->execute();
while ($Qvalues->next()) {
$Qinsert = $osC_Database->query('insert into :table_products_variants_values (id, languages_id, products_variants_groups_id, title, sort_order) values (:id, :languages_id, :products_variants_groups_id, :title, :sort_order)');
$Qinsert->bindTable(':table_products_variants_values', TABLE_PRODUCTS_VARIANTS_VALUES);
$Qinsert->bindInt(':id', $Qvalues->valueInt('id'));
$Qinsert->bindInt(':languages_id', $language_id);
$Qinsert->bindInt(':products_variants_groups_id', $Qvalues->valueInt('products_variants_groups_id'));
$Qinsert->bindValue(':title', $Qvalues->value('title'));
$Qinsert->bindInt(':sort_order', $Qvalues->valueInt('sort_order'));
$Qinsert->execute();
if ($osC_Database->isError()) {
$error = true;
break;
}
}
}
if ($error === false) {
$Qmanufacturers = $osC_Database->query('select manufacturers_id, manufacturers_url from :table_manufacturers_info where languages_id = :languages_id');
$Qmanufacturers->bindTable(':table_manufacturers_info', TABLE_MANUFACTURERS_INFO);
$Qmanufacturers->bindInt(':languages_id', $default_language_id);
$Qmanufacturers->execute();
while ($Qmanufacturers->next()) {
$Qinsert = $osC_Database->query('insert into :table_manufacturers_info (manufacturers_id, languages_id, manufacturers_url) values (:manufacturers_id, :languages_id, :manufacturers_url)');
$Qinsert->bindTable(':table_manufacturers_info', TABLE_MANUFACTURERS_INFO);
$Qinsert->bindInt(':manufacturers_id', $Qmanufacturers->valueInt('manufacturers_id'));
$Qinsert->bindInt(':languages_id', $language_id);
$Qinsert->bindValue(':manufacturers_url', $Qmanufacturers->value('manufacturers_url'));
$Qinsert->execute();
if ($osC_Database->isError()) {
$error = true;
break;
}
}
}
if ($error === false) {
$Qstatus = $osC_Database->query('select orders_status_id, orders_status_name from :table_orders_status where language_id = :language_id');
$Qstatus->bindTable(':table_orders_status', TABLE_ORDERS_STATUS);
$Qstatus->bindInt(':language_id', $default_language_id);
$Qstatus->execute();
while ($Qstatus->next()) {
$Qinsert = $osC_Database->query('insert into :table_orders_status (orders_status_id, language_id, orders_status_name) values (:orders_status_id, :language_id, :orders_status_name)');
$Qinsert->bindTable(':table_orders_status', TABLE_ORDERS_STATUS);
$Qinsert->bindInt(':orders_status_id', $Qstatus->valueInt('orders_status_id'));
$Qinsert->bindInt(':language_id', $language_id);
$Qinsert->bindValue(':orders_status_name', $Qstatus->value('orders_status_name'));
$Qinsert->execute();
if ($osC_Database->isError()) {
$error = true;
break;
}
}
}
if ($error === false) {
$Qstatus = $osC_Database->query('select id, status_name from :table_orders_transactions_status where language_id = :language_id');
$Qstatus->bindTable(':table_orders_transactions_status', TABLE_ORDERS_TRANSACTIONS_STATUS);
$Qstatus->bindInt(':language_id', $default_language_id);
$Qstatus->execute();
while ($Qstatus->next()) {
$Qinsert = $osC_Database->query('insert into :table_orders_transactions_status (id, language_id, status_name) values (:id, :language_id, :status_name)');
$Qinsert->bindTable(':table_orders_transactions_status', TABLE_ORDERS_TRANSACTIONS_STATUS);
$Qinsert->bindInt(':id', $Qstatus->valueInt('id'));
$Qinsert->bindInt(':language_id', $language_id);
$Qinsert->bindValue(':status_name', $Qstatus->value('status_name'));
$Qinsert->execute();
if ($osC_Database->isError()) {
$error = true;
break;
}
}
}
if ($error === false) {
$Qstatus = $osC_Database->query('select id, title, css_key from :table_shipping_availability where languages_id = :languages_id');
$Qstatus->bindTable(':table_shipping_availability', TABLE_SHIPPING_AVAILABILITY);
$Qstatus->bindInt(':languages_id', $default_language_id);
$Qstatus->execute();
while ($Qstatus->next()) {
$Qinsert = $osC_Database->query('insert into :table_shipping_availability (id, languages_id, title, css_key) values (:id, :languages_id, :title, :css_key)');
$Qinsert->bindTable(':table_shipping_availability', TABLE_SHIPPING_AVAILABILITY);
$Qinsert->bindInt(':id', $Qstatus->valueInt('id'));
$Qinsert->bindInt(':languages_id', $language_id);
$Qinsert->bindValue(':title', $Qstatus->value('title'));
$Qinsert->bindValue(':css_key', $Qstatus->value('css_key'));
$Qinsert->execute();
if ($osC_Database->isError()) {
$error = true;
break;
}
}
}
if ($error === false) {
$Qstatus = $osC_Database->query('select weight_class_id, weight_class_key, weight_class_title from :table_weight_classes where language_id = :language_id');
$Qstatus->bindTable(':table_weight_classes', TABLE_WEIGHT_CLASS);
$Qstatus->bindInt(':language_id', $default_language_id);
$Qstatus->execute();
while ($Qstatus->next()) {
$Qinsert = $osC_Database->query('insert into :table_weight_classes (weight_class_id, weight_class_key, language_id, weight_class_title) values (:weight_class_id, :weight_class_key, :language_id, :weight_class_title)');
$Qinsert->bindTable(':table_weight_classes', TABLE_WEIGHT_CLASS);
$Qinsert->bindInt(':weight_class_id', $Qstatus->valueInt('weight_class_id'));
$Qinsert->bindValue(':weight_class_key', $Qstatus->value('weight_class_key'));
$Qinsert->bindInt(':language_id', $language_id);
$Qinsert->bindValue(':weight_class_title', $Qstatus->value('weight_class_title'));
$Qinsert->execute();
if ($osC_Database->isError()) {
$error = true;
break;
}
}
}
if ($error === false) {
$Qgroup = $osC_Database->query('select id, title, code, size_width, size_height, force_size from :table_products_images_groups where language_id = :language_id');
$Qgroup->bindTable(':table_products_images_groups', TABLE_PRODUCTS_IMAGES_GROUPS);
$Qgroup->bindInt(':language_id', $default_language_id);
$Qgroup->execute();
while ($Qgroup->next()) {
$Qinsert = $osC_Database->query('insert into :table_products_images_groups (id, language_id, title, code, size_width, size_height, force_size) values (:id, :language_id, :title, :code, :size_width, :size_height, :force_size)');
$Qinsert->bindTable(':table_products_images_groups', TABLE_PRODUCTS_IMAGES_GROUPS);
$Qinsert->bindInt(':id', $Qgroup->valueInt('id'));
$Qinsert->bindInt(':language_id', $language_id);
$Qinsert->bindValue(':title', $Qgroup->value('title'));
$Qinsert->bindValue(':code', $Qgroup->value('code'));
$Qinsert->bindInt(':size_width', $Qgroup->value('size_width'));
$Qinsert->bindInt(':size_height', $Qgroup->value('size_height'));
$Qinsert->bindInt(':force_size', $Qgroup->value('force_size'));
$Qinsert->execute();
if ($osC_Database->isError()) {
$error = true;
break;
}
}
}
}
}
if ($error === false) {
$osC_Database->commitTransaction();
osC_Cache::clear('languages');
return true;
} else {
$osC_Database->rollbackTransaction();
}
return false;
}
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;
}
