?>
</td>
</tr>
<?php
}
?>
</table></td>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main" valign="top"><b><?php
echo ENTRY_BILLING_ADDRESS;
?>
</b></td>
<td class="main"><?php
echo oos_address_format($order->billing['format_id'], $order->billing, 1, ' ', '<br />');
?>
</td>
</tr>
<?php
if (defined('GOOGLE_MAP_API_KEY')) {
?>
<tr>
<td class="main" valign="top"><b>Google Map</b></td>
<td class="main"><?php
echo '<a href="javascript:popupGoogleMap(\'' . $aFilename['popup_google_map'] . '?query=' . rawurlencode($order->billing['city'] . ', ' . $order->billing['country']) . '\')">' . oos_image(OOS_IMAGES . 'icon_popup.gif', 'View Google Map');
?>
</a></td>
</tr>
<tr>
<td colspan="2"><?php
}
}
if ($process == '0') {
$address_booktable = $oostable['address_book'];
$sql = "SELECT COUNT(*) AS total\n FROM {$address_booktable}\n WHERE customers_id = '" . intval($_SESSION['customer_id']) . "'\n AND address_book_id != '" . intval($_SESSION['sendto']) . "'";
$addresses_count_result = $dbconn->Execute($sql);
$addresses_count = $addresses_count_result->fields['total'];
if ($addresses_count > 0) {
$radio_buttons = 0;
$address_booktable = $oostable['address_book'];
$sql = "SELECT address_book_id, entry_firstname AS firstname, entry_lastname AS lastname,\n entry_company AS company, entry_street_address AS street_address,\n entry_suburb AS suburb, entry_city AS city, entry_postcode AS postcode,\n entry_state AS state, entry_zone_id AS zone_id, entry_country_id AS country_id\n FROM {$address_booktable}\n WHERE customers_id = '" . intval($_SESSION['customer_id']) . "'";
$addresses_result = $dbconn->Execute($sql);
$addresses_array = array();
while ($addresses = $addresses_result->fields) {
$format_id = oos_get_address_format_id($address['country_id']);
$addresses_array[] = array('format_id' => $format_id, 'radio_buttons' => $radio_buttons, 'firstname' => $addresses['firstname'], 'lastname' => $addresses['lastname'], 'address_book_id' => $addresses['address_book_id'], 'address' => oos_address_format($format_id, $addresses, true, ' ', ', '));
$radio_buttons++;
// Move that ADOdb pointer!
$addresses_result->MoveNext();
}
}
}
// if no shipping destination address was selected, use their own address as default
if (!isset($_SESSION['sendto'])) {
$_SESSION['sendto'] = $_SESSION['customer_default_address_id'];
}
if (!isset($process)) {
$process = '0';
}
// links breadcrumb
$oBreadcrumb->add($aLang['navbar_title_1'], oos_href_link($aModules['checkout'], $aFilename['checkout_shipping'], '', 'SSL'));
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 $address_booktable
WHERE customers_id = '" . intval($_SESSION['customer_id']) . "'";
$addresses_result = $dbconn->Execute($sql);
$addresses_array = array();
while ($addresses = $addresses_result->fields)
{
$format_id = oos_get_address_format_id($address['country_id']);
$addresses_array[] = array('format_id' => $format_id,
'radio_buttons' => $radio_buttons,
'firstname' => $addresses['firstname'],
'lastname' => $addresses['lastname'],
'address_book_id' => $addresses['address_book_id'],
'address' => oos_address_format($format_id, $addresses, true, ' ', ', '));
$radio_buttons++;
// Move that ADOdb pointer!
$addresses_result->MoveNext();
}
}
}
// if no shipping destination address was selected, use their own address as default
if (!isset($_SESSION['sendto'])) {
$_SESSION['sendto'] = $_SESSION['customer_default_address_id'];
}
if (!isset($process)) $process = '0';
<tr>
<td><?php echo oos_draw_separator('trans.gif', '1', '5'); ?></td>
</tr>
<tr>
<td class="main"><?php echo $order->customer['telephone']; ?></td>
</tr>
<tr>
<td class="main"><?php echo '<a href="mailto:' . $order->customer['email_address'] . '"><u>' . $order->customer['email_address'] . '</u></a>'; ?></td>
</tr>
</table></td>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><b><?php echo ENTRY_SHIP_TO; ?></b></td>
</tr>
<tr>
<td class="main"><?php echo oos_address_format($order->delivery['format_id'], $order->delivery, 1, ' ', '<br />'); ?></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><?php echo oos_draw_separator('trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td><table border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><b><?php echo ENTRY_ORDER_NUMBER; ?></b></td>
<td class="main"><?php echo intval($oID); ?></td>
<tr>
<tr>
<td class="main"><?php
echo '<a href="mailto:' . $order->customer['email_address'] . '"><u>' . $order->customer['email_address'] . '</u></a>';
?>
</td>
</tr>
</table></td>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><b><?php
echo ENTRY_SHIP_TO;
?>
</b></td>
</tr>
<tr>
<td class="main"><?php
echo oos_address_format($order->delivery['format_id'], $order->delivery, 1, ' ', '<br />');
?>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><?php
echo oos_draw_separator('trans.gif', '1', '10');
?>
</td>
</tr>
<tr>
<td><table border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main" valign="top"><b>Google Map</b></td>
<td class="main"><?php echo '<a href="javascript:popupGoogleMap(\'' . $aFilename['popup_google_map'] . '?query=' . rawurlencode($order->delivery['city']. ', '.$order->delivery['country']) . '\')">' . oos_image(OOS_IMAGES . 'icon_popup.gif', 'View Google Map'); ?></a></td>
</tr>
<tr>
<td colspan="2"><?php echo oos_draw_separator('trans.gif', '1', '5'); ?></td>
</tr>
<?php
}
?>
</table></td>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main" valign="top"><b><?php echo ENTRY_BILLING_ADDRESS; ?></b></td>
<td class="main"><?php echo oos_address_format($order->billing['format_id'], $order->billing, 1, ' ', '<br />'); ?></td>
</tr>
<?php
if (defined('GOOGLE_MAP_API_KEY')) {
?>
<tr>
<td class="main" valign="top"><b>Google Map</b></td>
<td class="main"><?php echo '<a href="javascript:popupGoogleMap(\'' . $aFilename['popup_google_map'] . '?query=' . rawurlencode($order->billing['city']. ', '.$order->billing['country']) . '\')">' . oos_image(OOS_IMAGES . 'icon_popup.gif', 'View Google Map'); ?></a></td>
</tr>
<tr>
<td colspan="2"><?php echo oos_draw_separator('trans.gif', '1', '5'); ?></td>
</tr>
<?php
}
?>
</table></td>
/**
* Return a formatted address
*
* @param $customers_id
* @param $address_id
* @param $html
* @param $boln
* @param $eoln
* @param $address
* @param $html
* @param $boln
* @param $eoln
*/
function oos_address_label($customers_id, $address_id = 1, $html = false, $boln = '', $eoln = "\n") {
// Get database information
$dbconn =& oosDBGetConn();
$oostable =& oosDBGetTables();
$address_booktable = $oostable['address_book'];
$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 $address_booktable
WHERE customers_id = '" . intval($customers_id) . "' AND
address_book_id = '" . intval($address_id) . "'";
$address = $dbconn->GetRow($query);
$format_id = oos_get_address_format_id($address['country_id']);
return oos_address_format($format_id, $address, $html, $boln, $eoln);
}