/** * Smarty {oos_address_label} function plugin * * Type: function * Name: oos_address_label * Version: 1.0 * ------------------------------------------------------------- */ function smarty_function_oos_address_label($params, &$smarty) { $customers_id = ''; $address_id = 1; $html = true; $boln = ''; $eoln = '<br>'; MyOOS_CoreApi::requireOnce('lib/smarty/libs/plugins/shared.escape_special_chars.php'); MyOOS_CoreApi::requireOnce('lib/smarty-plugins/myoos/function.oos_address_format.php'); foreach($params as $_key => $_val) { $$_key = smarty_function_escape_special_chars($_val); } $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $address_result = $dbconn->Execute("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 " . $oostable['address_book'] . " WHERE customers_id = '" . (int)$customers_id . "' AND address_book_id = '" . (int)$address_id . "'"); $address = $address_result->fields; $format_id = oos_get_address_format_id($address['country_id']); return smarty_function_oos_address_format(array('address_format_id' => $format_id, 'address' => $address, 'html' => $html), $smarty); }
oos_redirect(oos_href_link($aModules['checkout'], $aFilename['checkout_shipping'], '', 'SSL')); } } 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
/** * 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); }