$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; }