?> </td> <td class="main" width="50%" valign="top" align="right"><?php echo '<b>' . TITLE_PLEASE_SELECT . '</b><br>' . tep_image(DIR_WS_IMAGES . 'arrow_east_south.gif'); ?> </td> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?> </td> </tr> <?php $radio_buttons = 0; $addresses_query = tep_db_query("select address_book_id, entry_firstname as firstname, entry_lastname as lastname, entry_company as company, entry_street_address as street_address, entry_suburb as suburb, entry_city as city, entry_postcode as postcode, entry_state as state, entry_zone_id as zone_id, entry_country_id as country_id from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int) $customer_id . "'"); while ($addresses = tep_db_fetch_array($addresses_query)) { $format_id = tep_get_address_format_id($addresses['country_id']); ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?> </td> <td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <?php if ($addresses['address_book_id'] == $sendto) { echo ' <tr id="defaultSelected" class="moduleRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, ' . $radio_buttons . ')">' . "\n"; } else { echo ' <tr class="moduleRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, ' . $radio_buttons . ')">' . "\n"; } ?> <td width="10"><?php
<?php echo TEXT_SELECT_OTHER_PAYMENT_DESTINATION; ?> </div> </div> <div class="contentText"> <table class="table table-striped table-condensed table-hover"> <tbody> <?php $Qab = $OSCOM_Db->prepare('select address_book_id, entry_firstname as firstname, entry_lastname as lastname, entry_company as company, entry_street_address as street_address, entry_suburb as suburb, entry_city as city, entry_postcode as postcode, entry_state as state, entry_zone_id as zone_id, entry_country_id as country_id from :table_address_book where customers_id = :customers_id order by firstname, lastname'); $Qab->bindInt(':customers_id', $_SESSION['customer_id']); $Qab->execute(); while ($Qab->fetch()) { $format_id = tep_get_address_format_id($Qab->valueInt('country_id')); if ($Qab->valueInt('address_book_id') == $_SESSION['billto']) { echo ' <tr id="defaultSelected" class="moduleRowSelected">' . "\n"; } else { echo ' <tr class="moduleRow">' . "\n"; } ?> <td> <strong><?php echo HTML::outputProtected($Qab->value('firstname') . ' ' . $Qab->value('lastname')); ?> </strong> <div class="help-block"><?php echo tep_address_format($format_id, $Qab->toArray(), true, ' ', ', '); ?>
function tep_address_label($customers_id, $address_id = 1, $html = false, $boln = '', $eoln = "\n") { if (is_array($address_id) && !empty($address_id)) { return tep_address_format($address_id['address_format_id'], $address_id, $html, $boln, $eoln); } $address_query = tep_db_query("select entry_firstname as firstname, entry_lastname as lastname, entry_company as company, entry_street_address as street_address, entry_suburb as suburb, entry_city as city, entry_postcode as postcode, entry_state as state, entry_zone_id as zone_id, entry_country_id as country_id from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int) $customers_id . "' and address_book_id = '" . (int) $address_id . "'"); $address = tep_db_fetch_array($address_query); $format_id = tep_get_address_format_id($address['country_id']); return tep_address_format($format_id, $address, $html, $boln, $eoln); }
if (tep_session_is_registered('customer_id')) { // logged in if (CARTSHIP_SHOWWT == 'true') { $showweight = ' (' . $total_weight . ' ' . CARTSHIP_WTUNIT . ')'; } else { $showweight = ''; } if (CARTSHIP_SHOWIC == 'true') { //ishazer remover hard code for version 2.20 : $ShipTxt.='<tr><td class="main">' . ($total_count == 1 ? ' <b>Item:</b></td><td colspan="2" class="main">' : ' <b>' . CART_ITEM . '</b></td><td colspan="2" class="main">') . $total_count . $showweight . '</td></tr>'; $ShipTxt .= '<tr><td class="main">' . ($total_count == 1 ? ' <b>' . CART_ITEM . '</b></td><td colspan="2" class="main">' : ' <b>' . CART_ITEM . '</b></td><td colspan="2" class="main">') . $total_count . $showweight . '</td></tr>'; } $addresses_query = tep_db_query("select address_book_id, entry_city as city, entry_postcode as postcode, entry_state as state, entry_zone_id as zone_id, entry_country_id as country_id from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . $customer_id . "'"); // only display addresses if more than 1 if (tep_db_num_rows($addresses_query) > 1) { while ($addresses = tep_db_fetch_array($addresses_query)) { $addresses_array[] = array('id' => $addresses['address_book_id'], 'text' => tep_address_format(tep_get_address_format_id($addresses['country_id']), $addresses, 0, ' ', ' ')); } $ShipTxt .= '<tr><td colspan="3" class="main" nowrap>' . CART_SHIPPING_METHOD_ADDRESS . ' ' . tep_draw_pull_down_menu('address_id', $addresses_array, $selected_address, 'onchange="return shipincart_submit(\'\');"') . '</td></tr>'; } $ShipTxt .= '<tr valign="top"><td class="main"><b>' . CART_SHIPPING_METHOD_TO . '</b> </td><td colspan="2" class="main">' . tep_address_format($order->delivery['format_id'], $order->delivery, 1, ' ', '<br>') . '</td></tr>'; } else { // not logged in $ShipTxt .= CART_SHIPPING_OPTIONS_LOGIN; if (CARTSHIP_SHOWIC == 'true') { //azer for 2.20: $ShipTxt.='<tr><td class="main">' . ($total_count == 1 ? ' <b>Item:</b></td><td colspan="2" class="main">' : ' <b>Items:</b></td><td colspan="2" class="main">') . $total_count . $showweight . '</td></tr>'; $ShipTxt .= '<tr><td class="main" nowrap>' . ($total_count == 1 ? ' <b>' . CART_ITEM . '</b></td><td colspan="2" class="main" nowrap>' : ' <b>' . CART_ITEM . '</b></td><td colspan="2" class="main">') . $total_count . $showweight . '</td></tr>'; } if ($cart->get_content_type() != 'virtual') { if (CARTSHIP_SHOWCDD == 'true') { $ShipTxt .= '<tr><td colspan="3" class="main" nowrap>' . ENTRY_COUNTRY . ' ' . tep_get_country_list('country_id', $selected_country, 'style="width=200"') . '<br />'; }
private function put_all_data_in_db($orders_id) { global $currency, $currencies; //fill orders table if (extension_loaded('apc') && ini_get('apc.enabled')) { apc_delete('temp_orders_' . $orders_id); apc_delete('temp_orders_products_' . $orders_id); apc_delete('temp_orders_status_history_' . $orders_id); apc_delete('temp_orders_total_' . $orders_id); } $this->get_all_data_from_temp_db($orders_id); $orders = $this->temp_data[$orders_id]['orders']; unset($orders['orders_id']); unset($orders['delivery_address_id']); unset($orders['billing_address_id']); unset($orders['coupon_id']); unset($orders['payment_method_extra']); unset($orders['shipping_method_extra']); unset($orders['processed_order_id']); $orders['abo_status'] = '0'; $orders['date_purchased'] = $orders['last_modified'] = date("Y-m-d H:m:s"); $orders['currency'] = $currency; $orders['currency_value'] = $currencies->currencies[$currency]['value']; $orders['customers_address_format_id'] = tep_get_address_format_id($orders['customers_country']); $orders['customers_country'] = tep_get_country_name($orders['customers_country']); $orders['billing_address_format_id'] = tep_get_address_format_id($orders['billing_country']); $orders['billing_country'] = tep_get_country_name($orders['billing_country']); $orders['delivery_address_format_id'] = tep_get_address_format_id($orders['delivery_country']); $orders['delivery_country'] = tep_get_country_name($orders['delivery_country']); tep_db_perform('orders', $orders, 'insert'); $new_orders_id = tep_db_insert_id(); //add order id to temp orders table tep_db_query('UPDATE temp_orders SET processed_order_id = "' . $new_orders_id . '" WHERE orders_id = "' . $orders_id . '"'); //fill orders_products table $orders_products = $this->temp_data[$orders_id]['orders_products']; //fill orders_products_attributes $orders_products_attributes = $this->temp_data[$orders_id]['orders_products_attributes']; if (is_array($orders_products)) { foreach ($orders_products as $products_order_id => $data) { unset($orders_products[$products_order_id]['orders_products_id']); unset($orders_products[$products_order_id]['products_weight']); $orders_products[$products_order_id]['orders_id'] = $new_orders_id; tep_db_perform('orders_products', $orders_products[$products_order_id], 'insert'); $orders_products_id = tep_db_insert_id(); if (is_array($orders_products_attributes)) { foreach ($orders_products_attributes[$products_order_id] as $key => $value) { unset($orders_products_attributes[$products_order_id][$key]['orders_products_attributes_id']); $orders_products_attributes[$products_order_id][$key]['orders_id'] = $new_orders_id; $orders_products_attributes[$products_order_id][$key]['orders_products_id'] = $orders_products_id; tep_db_perform('orders_products_attributes', $orders_products_attributes[$products_order_id][$key], 'insert'); } } } } //fill orders_products_status_history table $orders_status_history = $this->temp_data[$orders_id]['orders_status_history']; if (is_array($orders_status_history)) { foreach ($orders_status_history as $key => $value) { unset($orders_status_history[$key]['orders_status_history_id']); $orders_status_history[$key]['orders_id'] = $new_orders_id; $orders_status_history[$key]['orders_status_id'] = $orders['orders_status']; tep_db_perform('orders_status_history', $orders_status_history[$key], 'insert'); } } //fill orders_total table $orders_total = $this->temp_data[$orders_id]['orders_total']; if (is_array($orders_total)) { foreach ($orders_total as $key => $data) { unset($orders_total[$key]['orders_total_id']); $orders_total[$key]['orders_id'] = $new_orders_id; tep_db_perform('orders_total', $orders_total[$key], 'insert'); } } return $new_orders_id; }
function tep_address_label($customers_id, $address_id = 1, $html = false, $boln = '', $eoln = "\n") { $OSCOM_Db = Registry::get('Db'); if (is_array($address_id) && !empty($address_id)) { return tep_address_format($address_id['address_format_id'], $address_id, $html, $boln, $eoln); } $Qaddress = $OSCOM_Db->prepare('select entry_firstname as firstname, entry_lastname as lastname, entry_company as company, entry_street_address as street_address, entry_suburb as suburb, entry_city as city, entry_postcode as postcode, entry_state as state, entry_zone_id as zone_id, entry_country_id as country_id from :table_address_book where address_book_id = :address_book_id and customers_id = :customers_id'); $Qaddress->bindInt(':address_book_id', $address_id); $Qaddress->bindInt(':customers_id', $customers_id); $Qaddress->execute(); $format_id = tep_get_address_format_id($Qaddress->valueInt('country_id')); return tep_address_format($format_id, $Qaddress->toArray(), $html, $boln, $eoln); }
// initialize variables if the customer is not logged in if (!tep_session_is_registered('customer_id')) { $customer_id = 0; $customer_default_address_id = 0; } require 'includes/modules/payment/paypal_express.php'; $paypal_express = new paypal_express(); if (!$paypal_express->check() || !$paypal_express->enabled) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART, '', 'SSL')); } if (!tep_session_is_registered('sendto')) { if (tep_session_is_registered('customer_id')) { $sendto = $customer_default_address_id; } else { $country = tep_get_countries(STORE_COUNTRY, true); $sendto = array('firstname' => '', 'lastname' => '', 'company' => '', 'street_address' => '', 'suburb' => '', 'postcode' => '', 'city' => '', 'zone_id' => STORE_ZONE, 'zone_name' => tep_get_zone_name(STORE_COUNTRY, STORE_ZONE, ''), 'country_id' => STORE_COUNTRY, 'country_name' => $country['countries_name'], 'country_iso_code_2' => $country['countries_iso_code_2'], 'country_iso_code_3' => $country['countries_iso_code_3'], 'address_format_id' => tep_get_address_format_id(STORE_COUNTRY)); } } if (!tep_session_is_registered('billto')) { $billto = $sendto; } // register a random ID in the session to check throughout the checkout procedure // against alterations in the shopping cart contents if (!tep_session_is_registered('cartID')) { tep_session_register('cartID'); } $cartID = $cart->cartID; switch ($HTTP_GET_VARS['osC_Action']) { case 'cancel': tep_session_unregister('ppe_token'); tep_session_unregister('ppe_secret');
$telephone = tep_db_prepare_input($_POST['customers_telephone']); $fax = tep_db_prepare_input($_POST['customers_fax']); $newsletter = tep_db_prepare_input($_POST['newsletter']); $confirmation = tep_db_prepare_input($_POST['confirmation']); $street_address = tep_db_prepare_input($_POST['entry_street_address']); $company = tep_db_prepare_input($_POST['entry_company']); $suburb = tep_db_prepare_input($_POST['entry_suburb']); $postcode = tep_db_prepare_input($_POST['entry_postcode']); $city = tep_db_prepare_input($_POST['entry_city']); $zone_id = empty($_POST['zone_id']) ? 0 : tep_db_prepare_input($_POST['zone_id']); $state = tep_db_prepare_input($_POST['entry_state']); $country = tep_db_prepare_input(tep_get_country_name($_POST['entry_country'])); $country_id = (int) tep_db_prepare_input($_POST['entry_country']); $customers_newsletter = tep_db_prepare_input($_POST['customers_newsletter']); $customers_password = tep_db_prepare_input($_POST['customers_password']); $format_id = tep_get_address_format_id($country_id); $size = "1"; $payment_method = DEFAULT_PAYMENT_METHOD; $new_value = "1"; $error = false; // reset error flag $temp_amount = "0"; $temp_amount = number_format($temp_amount, 2, '.', ''); $currency_text = DEFAULT_CURRENCY . ", 1"; if (isset($_POST['Currency'])) { $currency_text = tep_db_prepare_input($_POST['Currency']); } $currency_array = explode(",", $currency_text); $currency = $currency_array[0]; $currency_value = $currency_array[1]; $customer_service_id = tep_db_prepare_input($_POST['cust_service']);
$o['country'] = array('id' => (int) $bill_country, 'title' => $cty['countries_name'], 'iso_code_2' => $cty['countries_iso_code_2'], 'iso_code_3' => $cty['countries_iso_code_3']); $o['country_id'] = (int) $bill_country; $o['format_id'] = tep_get_address_format_id($bill_country); $o['telephone'] = $telephone; $o['email_address'] = $email_address; } if ($order->content_type == 'virtual') { if (!tep_session_is_registered('shipping')) { tep_session_register('shipping'); } // $shipping = false; $sendto = false; } $country_query = tep_db_query("SELECT countries_name, countries_iso_code_2, countries_iso_code_3 FROM " . TABLE_COUNTRIES . " WHERE countries_id = '" . (int) $ship_country . "'"); $cty = tep_db_fetch_array($country_query); $order->delivery = array('firstname' => $firstname, 'lastname' => $lastname, 'company' => $ship_company, 'street_address' => $ship_street_address, 'suburb' => $ship_suburb, 'city' => $ship_city, 'postcode' => $ship_postcode, 'state' => $ship_state, 'zone_id' => $ship_zone_id, 'country' => array('id' => $cty['countries_id'], 'title' => $cty['countries_name'], 'iso_code_2' => $cty['countries_iso_code_2'], 'iso_code_3' => $cty['countries_iso_code_3']), 'country_id' => $ship_country, 'format_id' => tep_get_address_format_id($ship_country)); $order_totals = $order_total_modules->process(); // if ( (isset($_POST['shipping'])) && (strpos($_POST['shipping'], '_')) ) { // $shipping = $_POST['shipping']; // list($module, $method) = explode('_', $shipping); // list($module, $method) = explode('_', $_POST['shipping']); // $shipping=$shipping_options[$module][$method]; // if ( is_object($$module) || ($shipping == 'free_free') ) { // if ($shipping == 'free_free') { // $quote[0]['methods'][0]['title'] = FREE_SHIPPING_TITLE; // $quote[0]['methods'][0]['cost'] = '0'; // } else { // $quote = $shipping_modules->quote($method, $module); // } // if (isset($quote['error'])) { // tep_session_unregister('shipping');
function tep_address_label($customers_id, $address_id = 1, $html = false, $boln = '', $eoln = "\n") { global $osC_Database; $Qaddress = $osC_Database->query('select entry_firstname as firstname, entry_lastname as lastname, entry_company as company, entry_street_address as street_address, entry_suburb as suburb, entry_city as city, entry_postcode as postcode, entry_state as state, entry_zone_id as zone_id, entry_country_id as country_id from :table_address_book where customers_id = :customers_id and address_book_id = :address_book_id'); $Qaddress->bindTable(':table_address_book', TABLE_ADDRESS_BOOK); $Qaddress->bindInt(':customers_id', $customers_id); $Qaddress->bindInt(':address_book_id', $address_id); $Qaddress->execute(); $format_id = tep_get_address_format_id($Qaddress->valueInt('country_id')); return tep_address_format($format_id, $Qaddress->toArray(), $html, $boln, $eoln); }