$vamTemplate->assign('address_label_customer', vam_address_format($order->customer['format_id'], $order->customer, 1, '', '<br />'));
$vamTemplate->assign('address_label_shipping', vam_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br />'));
$vamTemplate->assign('address_label_payment', vam_address_format($order->billing['format_id'], $order->billing, 1, '', '<br />'));
$vamTemplate->assign('phone', $order->customer['telephone']);
$vamTemplate->assign('email', $order->customer['email_address']);
$vamTemplate->assign('csID', $order->customer['csID']);
// get products data
$order_query = vam_db_query("SELECT\n \t\t\t\tproducts_id,\n \t\t\t\torders_products_id,\n \t\t\t\tproducts_model,\n \t\t\t\tproducts_name,\n \t\t\t\tproducts_price,\n \t\t\t\tfinal_price,\n \t\t\t\tproducts_quantity\n \t\t\t\tFROM " . TABLE_ORDERS_PRODUCTS . "\n \t\t\t\tWHERE orders_id='" . (int) $_GET['oID'] . "'");
$order_data = array();
while ($order_data_values = vam_db_fetch_array($order_query)) {
$attributes_query = vam_db_query("SELECT\n \t\t\t\tproducts_options,\n \t\t\t\tproducts_options_values,\n \t\t\t\tprice_prefix,\n \t\t\t\toptions_values_price\n \t\t\t\tFROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "\n \t\t\t\tWHERE orders_products_id='" . $order_data_values['orders_products_id'] . "'");
$attributes_data = '';
$attributes_model = '';
while ($attributes_data_values = vam_db_fetch_array($attributes_query)) {
$attributes_data .= '<br />' . $attributes_data_values['products_options'] . ':' . $attributes_data_values['products_options_values'];
$attributes_model .= '<br />' . vam_get_attributes_model($order_data_values['products_id'], $attributes_data_values['products_options_values'], $attributes_data_values['products_options']);
}
$order_data[] = array('PRODUCTS_MODEL' => $order_data_values['products_model'], 'PRODUCTS_NAME' => $order_data_values['products_name'], 'PRODUCTS_ATTRIBUTES' => $attributes_data, 'PRODUCTS_ATTRIBUTES_MODEL' => $attributes_model, 'PRODUCTS_SINGLE_PRICE' => $order_data_values['products_price'], 1, $order->info['currency'], 'PRODUCTS_PRICE' => $order_data_values['final_price'], 1, $order->info['currency'], 'PRODUCTS_QTY' => $order_data_values['products_quantity']);
}
// get order_total data
$oder_total_query = vam_db_query("SELECT\n title,\n text,\n class,\n value,\n sort_order\n \t\t\t\t\tFROM " . TABLE_ORDERS_TOTAL . "\n \t\t\t\t\tWHERE orders_id='" . $_GET['oID'] . "'\n \t\t\t\t\tORDER BY sort_order ASC");
$order_total = array();
while ($oder_total_values = vam_db_fetch_array($oder_total_query)) {
$order_total[] = array('TITLE' => $oder_total_values['title'], 'CLASS' => $oder_total_values['class'], 'VALUE' => $oder_total_values['value'], 'TEXT' => $oder_total_values['text']);
if ($oder_total_values['class'] = 'ot_total') {
$total = $oder_total_values['value'];
}
}
$vamTemplate->assign('1', MODULE_PAYMENT_SCHET_1);
$vamTemplate->assign('2', MODULE_PAYMENT_SCHET_2);
$vamTemplate->assign('3', MODULE_PAYMENT_SCHET_3);
if (!is_file($image)) {
$image = DIR_WS_THUMBNAIL_IMAGES . '../noimage.gif';
}
$module_content[$i] = array('PRODUCTS_NAME' => $products[$i]['name'] . $mark_stock, 'PRODUCTS_QTY' => vam_draw_input_field('cart_quantity[]', $products[$i]['quantity'], 'size="2" data-id="' . $products[$i]['id'] . '" class="quantity"') . vam_draw_hidden_field('products_id[]', $products[$i]['id']) . vam_draw_hidden_field('old_qty[]', $products[$i]['quantity']), 'PRODUCTS_MODEL' => $products[$i]['model'], 'PRODUCTS_SHIPPING_TIME' => $products[$i]['shipping_time'], 'PRODUCTS_TAX' => number_format($products[$i]['tax'], TAX_DECIMAL_PLACES), 'PRODUCTS_IMAGE' => $image, 'IMAGE_ALT' => $products[$i]['name'], 'BOX_DELETE' => $products[$i]['id'], 'PRODUCTS_LINK' => vam_href_link(FILENAME_PRODUCT_INFO, vam_product_link($products[$i]['id'], $products[$i]['name'])), 'PRODUCTS_PRICE' => $vamPrice->Format($products[$i]['price'] * $products[$i]['quantity'], true), 'PRODUCTS_SINGLE_PRICE' => $vamPrice->Format($products[$i]['price'], true), 'PRODUCTS_SHORT_DESCRIPTION' => vam_get_short_description($products[$i]['id']), 'ATTRIBUTES' => '');
// Product options names
$attributes_exist = isset($products[$i]['attributes']) ? 1 : 0;
if ($attributes_exist == 1) {
reset($products[$i]['attributes']);
while (list($option, $value) = each($products[$i]['attributes'])) {
if (ATTRIBUTE_STOCK_CHECK == 'true' && STOCK_CHECK == 'true') {
$attribute_stock_check = vam_check_stock_attributes($products[$i][$option]['products_attributes_id'], $products[$i]['quantity']);
if ($attribute_stock_check) {
$_SESSION['any_out_of_stock'] = 1;
}
}
$module_content[$i]['ATTRIBUTES'][] = array('ID' => $products[$i][$option]['products_attributes_id'], 'MODEL' => vam_get_attributes_model(vam_get_prid($products[$i]['id']), $products[$i][$option]['products_options_values_name'], $products[$i][$option]['products_options_name']), 'NAME' => $products[$i][$option]['products_options_name'], 'VALUE_NAME' => $products[$i][$option]['products_options_values_name'] . $attribute_stock_check);
}
}
}
$total_content = '';
$total = $_SESSION['cart']->show_total();
if ($_SESSION['customers_status']['customers_status_ot_discount_flag'] == '1' && $_SESSION['customers_status']['customers_status_ot_discount'] != '0.00') {
if ($_SESSION['customers_status']['customers_status_show_price_tax'] == 0 && $_SESSION['customers_status']['customers_status_add_tax_ot'] == 1) {
$price = $total - $_SESSION['cart']->show_tax(false);
} else {
$price = $total;
}
$discount = $vamPrice->GetDC($price, $_SESSION['customers_status']['customers_status_ot_discount']);
//$total_content = $_SESSION['customers_status']['customers_status_ot_discount'].' % '.SUB_TITLE_OT_DISCOUNT.' -'.vam_format_price($discount, $price_special = 1, $calculate_currencies = false).'<br />';
$total_discount = $discount;
}
echo '<br /><small>';
for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {
echo ' <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . ';</i><br />';
}
echo '</small>';
}
echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">';
if ($order->products[$i]['model'] != '') {
echo $order->products[$i]['model'];
} else {
echo '<br />';
}
// attribute models
if (sizeof($order->products[$i]['attributes']) > 0) {
for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {
$model = vam_get_attributes_model($order->products[$i]['id'], $order->products[$i]['attributes'][$j]['value'], $order->products[$i]['attributes'][$j]['option']);
if ($model != '') {
echo $model . '<br />';
} else {
echo '<br />';
}
}
}
echo ' </td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top">' . format_price($order->products[$i]['final_price'] / $order->products[$i]['qty'], 1, $order->info['currency'], $order->products[$i]['allow_tax'], $order->products[$i]['tax']) . '</td>' . "\n";
if ($order->products[$i]['allow_tax'] == 1) {
echo '<td class="dataTableContent" align="right" valign="top">';
echo vam_display_tax_value($order->products[$i]['tax']) . '%';
echo '</td>' . "\n";
echo '<td class="dataTableContent" align="right" valign="top"><b>';
echo format_price($order->products[$i]['final_price'] / $order->products[$i]['qty'], 1, $order->info['currency'], 0, 0);
echo '</b></td>' . "\n";
function getOrderData($oID)
{
global $vamPrice;
require_once DIR_FS_INC . 'vam_get_attributes_model.inc.php';
$order_query = "SELECT\n\t \t\t\t\tproducts_id,\n\t \t\t\t\torders_products_id,\n\t \t\t\t\tproducts_model,\n\t \t\t\t\tproducts_name,\n\t \t\t\t\tfinal_price,\n\t \t\t\t \tproducts_shipping_time,\n\t \t\t\t\tproducts_quantity\n\t \t\t\t\tFROM " . TABLE_ORDERS_PRODUCTS . "\n\t \t\t\t\tWHERE orders_id='" . (int) $oID . "'";
$order_data = array();
$order_query = vam_db_query($order_query);
while ($order_data_values = vam_db_fetch_array($order_query)) {
$attributes_query = "SELECT\n\t\t \t\t\t\tproducts_options,\n\t\t \t\t\t\tproducts_options_values,\n\t\t \t\t\t\tprice_prefix,\n\t\t \t\t\t\toptions_values_price\n\t\t \t\t\t\tFROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "\n\t\t \t\t\t\tWHERE orders_products_id='" . $order_data_values['orders_products_id'] . "'";
$attributes_data = '';
$attributes_model = '';
$attributes_query = vam_db_query($attributes_query);
while ($attributes_data_values = vam_db_fetch_array($attributes_query)) {
$attributes_data .= '<br />' . $attributes_data_values['products_options'] . ': ' . $attributes_data_values['products_options_values'];
$attributes_model .= '<br />' . vam_get_attributes_model($order_data_values['products_id'], $attributes_data_values['products_options_values'], $attributes_data_values['products_options']);
}
$order_data[] = array('PRODUCTS_ID' => $order_data_values['products_id'], 'PRODUCTS_MODEL' => $order_data_values['products_model'], 'PRODUCTS_NAME' => $order_data_values['products_name'], 'PRODUCTS_SHIPPING_TIME' => $order_data_values['products_shipping_time'], 'PRODUCTS_ATTRIBUTES' => $attributes_data, 'PRODUCTS_ATTRIBUTES_MODEL' => $attributes_model, 'PRODUCTS_PRICE' => $vamPrice->Format($order_data_values['final_price'], false), 'PRODUCTS_SINGLE_PRICE' => $vamPrice->Format($order_data_values['final_price'], false), 'PRODUCTS_QTY' => $order_data_values['products_quantity']);
}
return $order_data;
}
