v_order_id = (int)$p_orders_id;
// get send order status and orders id
$t_query = xtc_db_query("
SELECT
orders_id,
gm_send_order_status,
abandonment_download,
abandonment_service
FROM " .
TABLE_ORDERS . "
WHERE
orders_id= '" . $this->v_order_id . "'
LIMIT 1
");
// if order status exists
if(xtc_db_num_rows($t_query) <= 0) {
return false;
}
$t_order_status = xtc_db_fetch_array($t_query);
$this->createOrder($t_order_status);
return true;
}
/**
* create the order
*
* @access private
* @return bool OK:true | Error:false
*/
function createOrder($t_row)
{
// recreate order
$smarty = new Smarty;
$t_order = new order($t_row['orders_id']);
$t_order_query = xtc_db_query("
SELECT
products_id,
orders_products_id,
products_model,
products_name,
products_shipping_time,
final_price,
products_quantity
FROM " .
TABLE_ORDERS_PRODUCTS . "
WHERE
orders_id= '" . (int)$t_row['orders_id'] . "'
");
$t_order_data = array();
while ($t_order_data_values = xtc_db_fetch_array($t_order_query)) {
$t_attributes_query = xtc_db_query("
SELECT
products_options,
products_options_values,
price_prefix,
options_values_price
FROM " .
TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "
WHERE
orders_products_id = '" . $t_order_data_values['orders_products_id'] . "'
AND
orders_id = '" . (int)$t_row['orders_id'] . "'
");
$t_attributes_data = '';
$t_attributes_model = '';
while($t_attributes_data_values = xtc_db_fetch_array($t_attributes_query)) {
$t_attributes_data .= '
' . $t_attributes_data_values['products_options'] . ':' . $t_attributes_data_values['products_options_values'];
$t_attributes_model .= '
' . xtc_get_attributes_model(
$t_order_data_values['products_id'],
$t_attributes_data_values['products_options_values'],
$t_attributes_data_values['products_options']
);
}
// PROPERTIES
$coo_properties_control = MainFactory::create_object('PropertiesControl');
$t_properties_array = $coo_properties_control->get_orders_products_properties($t_order_data_values['orders_products_id']);
// BOF GM_MOD GX-Customizer:
require(DIR_FS_CATALOG . 'gm/modules/gm_gprint_admin_gm_send_order.php');
if(empty($t_order_data_values['products_shipping_time'])) $t_order_data_values['products_shipping_time'] = $this->get_shipping_time($t_order_data_values['products_id']);
$t_order_data[] = array(
'PRODUCTS_MODEL' => $t_order_data_values['products_model'],
'PRODUCTS_NAME' => $t_order_data_values['products_name'],
'PRODUCTS_SHIPPING_TIME' => $t_order_data_values['products_shipping_time'],
'PRODUCTS_ATTRIBUTES' => $t_attributes_data,
'PRODUCTS_ATTRIBUTES_MODEL' => $t_attributes_model,
'PRODUCTS_PROPERTIES' => $t_properties_array,
'PRODUCTS_SINGLE_PRICE' => xtc_format_price_order(
$t_order_data_values['final_price']/$t_order_data_values['products_quantity'],
1,
$t_order->info['currency']
),
'PRODUCTS_PRICE' => xtc_format_price_order(
$t_order_data_values['final_price'],
1,
$t_order->info['currency']
),
'PRODUCTS_QTY' => gm_prepare_number($t_order_data_values['products_quantity'], ',')
);
}
$t_oder_total_query=xtc_db_query("
SELECT
title,
text,
class,
value,
sort_order
FROM " .
TABLE_ORDERS_TOTAL . "
WHERE
orders_id = '" . (int)$t_row['orders_id'] . "'
ORDER BY
sort_order
ASC
");
$t_order_total = array();
while ($t_oder_total_values = xtc_db_fetch_array($t_oder_total_query)) {
$t_order_total[] = array(
'TITLE' => $t_oder_total_values['title'],
'CLASS' => $t_oder_total_values['class'],
'VALUE' => $t_oder_total_values['value'],
'TEXT' => $t_oder_total_values['text']
);
if($t_oder_total_values['class'] = 'ot_total') {
$total = $t_oder_total_values['value'];
}
}
if ($t_order->info['payment_method'] != '' && $t_order->info['payment_method']!= 'no_payment') {
include(DIR_FS_CATALOG . 'lang/' . $_SESSION['language'] . '/modules/payment/' . $t_order->info['payment_method'] . '.php');
$payment_method=constant(strtoupper('MODULE_PAYMENT_'.$t_order->info['payment_method'].'_TEXT_TITLE'));
$smarty->assign('PAYMENT_METHOD',$payment_method);
$smarty->assign('PAYMENT_MODUL', $t_order->info['payment_method']);
}
$smarty->assign('language', $_SESSION['language']);
$smarty->assign('csID', $t_order->customer['csID']);
$smarty->assign('oID', $t_row['orders_id']);
$smarty->assign('COMMENTS', $t_order->info['comments']);
$smarty->assign('DATE', xtc_date_long($t_order->info['date_purchased']));
$smarty->assign('NAME', $t_order->customer['name']);
$smarty->assign('GENDER', $t_order->customer['gender']);
$smarty->assign('COMMENTS', $t_order->info['comments']);
$smarty->assign('EMAIL', $t_order->customer['email_address']);
$smarty->assign('PHONE', $t_order->customer['telephone']);
$smarty->assign('order_data', $t_order_data);
$smarty->assign('order_total', $t_order_total);
$smarty->assign('address_label_customer', xtc_address_format($t_order->customer['format_id'], $t_order->customer, 1, '', '
'));
$smarty->assign('address_label_shipping', xtc_address_format($t_order->delivery['format_id'], $t_order->delivery, 1, '', '
'));
$smarty->assign('address_label_payment', xtc_address_format($t_order->billing['format_id'], $t_order->billing, 1, '', '
'));
/* BOF TRUSTED SHOPS RATING */
$t_rating_enabled = gm_get_conf('GM_TS_RATING_ENABLED') == 1;
$t_rating_cosuccess = gm_get_conf('GM_TS_RATING_COSUCCESS') == 1;
if($t_rating_enabled && $t_rating_cosuccess) {
$coo_ts_service = new GMTSService();
$t_customer_email = $t_order->customer['email_address'];
$t_orders_id = (int)$t_row['orders_id'];
$this->v_output_buffer['TS_RATING'] = $coo_ts_service->getRatingLink($t_orders_id, $t_customer_email);
$smarty->assign('TS_RATING', $coo_ts_service->getRatingLink($t_orders_id, $t_customer_email));
unset($coo_ts_service);
}
/* EOF TRUSTED SHOPS RATING */
$smarty->caching = false;
$smarty->template_dir = DIR_FS_CATALOG . 'templates';
$smarty->compile_dir = DIR_FS_CATALOG . 'templates_c';
$smarty->config_dir = DIR_FS_CATALOG . 'lang';
// EU Bank Transfer
if ($t_order->info['payment_method'] == 'eustandardtransfer')
{
$smarty->assign('PAYMENT_INFO_HTML', MODULE_PAYMENT_EUTRANSFER_TEXT_DESCRIPTION);
$smarty->assign('PAYMENT_INFO_TXT', str_replace("
", "\n", MODULE_PAYMENT_EUTRANSFER_TEXT_DESCRIPTION));
}
// MONEYORDER
if ($t_order->info['payment_method'] == 'moneyorder')
{
$smarty->assign('PAYMENT_INFO_HTML', MODULE_PAYMENT_MONEYORDER_TEXT_DESCRIPTION);
$smarty->assign('PAYMENT_INFO_TXT', str_replace("
", "\n", MODULE_PAYMENT_MONEYORDER_TEXT_DESCRIPTION));
}
/* MAIL LOGO */
$t_logo_mail = MainFactory::create_object('GMLogoManager', array("gm_logo_mail"));
if($t_logo_mail->logo_use == '1') {
$smarty->assign('gm_logo_mail', $t_logo_mail->get_logo());
}
if(defined('VRRL_ACTIVE') && VRRL_ACTIVE == true)
{
if(gm_get_conf('GM_SHOW_WITHDRAWAL') == 1 && gm_get_conf('WITHDRAWAL_WEBFORM_ACTIVE') == '1')
{
$t_link = generate_withdrawal_link($t_order->info['orders_hash']);
$smarty->assign('WITHDRAWAL_LINK', $t_link);
}
if(gm_get_conf('GM_SHOW_WITHDRAWAL') == 1 && gm_get_conf('WITHDRAWAL_PDF_ACTIVE') == '1')
{
$t_pdf_link = HTTP_SERVER . DIR_WS_CATALOG . 'request_port.php?module=Withdrawal&action=download_withdrawal_pdf_form&language=' . $_SESSION['language_code'];
$smarty->assign('PDF_LINK', $t_pdf_link);
}
}
$smarty->assign('SHOW_ABANDONMENT_WITHDRAWAL_DOWNLOADS_INFO', $t_row['abandonment_download']);
$smarty->assign('SHOW_ABANDONMENT_WITHDRAWAL_SERVICES_INFO', $t_row['abandonment_service']);
if(defined('EMAIL_SIGNATURE')) {
$smarty->assign('EMAIL_SIGNATURE_HTML', nl2br(EMAIL_SIGNATURE));
$smarty->assign('EMAIL_SIGNATURE_TEXT', EMAIL_SIGNATURE);
}
# JANOLAW START
require_once(DIR_FS_CATALOG.'gm/classes/GMJanolaw.php');
$coo_janolaw = new GMJanolaw();
if($coo_janolaw->get_status() == true)
{
$t_info_html = $coo_janolaw->get_page_content('widerrufsbelehrung', true, true);
$t_info_html .= '
AGB
';
$t_info_html .= $coo_janolaw->get_page_content('agb', true, true);
$smarty->assign('JANOLAW_INFO_HTML', $t_info_html);
$t_info_text = $coo_janolaw->get_page_content('widerrufsbelehrung', false, false);
$t_info_text .= "\n\nAGB\n\n";
$t_info_text .= $coo_janolaw->get_page_content('agb', false, false);
$smarty->assign('JANOLAW_INFO_TEXT', $t_info_text);
}
# JANOLAW END
$this->v_html = $smarty->fetch(CURRENT_TEMPLATE.'/mail/' . $_SESSION['language'] . '/order_mail.html');
if(isset($t_link))
{
$smarty->assign('WITHDRAWAL_LINK', str_replace('&', '&', $t_link));
}
if(isset($t_pdf_link))
{
$smarty->assign('PDF_LINK', str_replace('&', '&', $t_pdf_link));
}
$smarty->assign('address_label_customer', xtc_address_format($t_order->customer['format_id'], $t_order->customer, 0, '', "\n"));
$smarty->assign('address_label_shipping', xtc_address_format($t_order->delivery['format_id'], $t_order->delivery, 0, '', "\n"));
$smarty->assign('address_label_payment', xtc_address_format($t_order->billing['format_id'], $t_order->billing, 0, '', "\n"));
$t_txt = $smarty->fetch(CURRENT_TEMPLATE.'/mail/' . $_SESSION['language'] . '/order_mail.txt');
/* save order to DB */
gm_save_order($t_row['orders_id'], $this->v_html, $t_txt, $t_row['gm_send_order_status']);
return true;
}
/**
* get html of the order
*
* @access public
* @return string $this->v_html html of the order
*/
function getHtml()
{
return $this->v_html;
}
function get_shipping_time($p_product_id)
{
$t_products_id = (int)$p_product_id;
$t_sql = xtc_db_query("SELECT products_shippingtime,shipping_status_name FROM ".TABLE_PRDUCTS.",".TABLE_SHIPPING_STATUS." WHERE products_id=".$t_products_id." AND products_shippingtime=shipping_status_id AND language_id=".$_SESSION['language']);
$t_time = xtc_db_fetch_array($t_sql);
return $t_time['shipping_status_name'];
}
}