$destination_data = array();
$destination_data['states'] = db_get_hash_single_array("SELECT a.state_id, CONCAT(d.country, ': ', b.state) as state FROM ?:states as a LEFT JOIN ?:state_descriptions as b ON b.state_id = a.state_id AND b.lang_code = ?s LEFT JOIN ?:destination_elements as c ON c.element_type = 'S' AND c.element = a.state_id LEFT JOIN ?:country_descriptions as d ON d.code = a.country_code AND d.lang_code = ?s WHERE c.destination_id = ?i", array('state_id', 'state'), DESCR_SL, DESCR_SL, $_REQUEST['destination_id']);
$destination_data['countries'] = db_get_hash_single_array("SELECT a.code, b.country FROM ?:countries as a LEFT JOIN ?:country_descriptions as b ON b.code = a.code AND b.lang_code = ?s LEFT JOIN ?:destination_elements as c ON c.element_type = 'C' AND c.element = a.code WHERE c.destination_id = ?i", array('code', 'country'), DESCR_SL, $_REQUEST['destination_id']);
$destination_data['zipcodes'] = db_get_hash_single_array("SELECT element_id, element FROM ?:destination_elements WHERE element_type = 'Z' AND destination_id = ?i", array('element_id', 'element'), $_REQUEST['destination_id']);
$destination_data['zipcodes'] = implode("\n", $destination_data['zipcodes']);
$destination_data['cities'] = db_get_hash_single_array("SELECT element_id, element FROM ?:destination_elements WHERE element_type = 'T' AND destination_id = ?i", array('element_id', 'element'), $_REQUEST['destination_id']);
$destination_data['cities'] = implode("\n", $destination_data['cities']);
$destination_data['addresses'] = db_get_hash_single_array("SELECT element_id, element FROM ?:destination_elements WHERE element_type = 'A' AND destination_id = ?i", array('element_id', 'element'), $_REQUEST['destination_id']);
$destination_data['addresses'] = implode("\n", $destination_data['addresses']);
Registry::get('view')->assign('destination_data', $destination_data);
Registry::get('view')->assign('destination', $destination);
Registry::get('view')->assign('states', fn_destination_get_states(CART_LANGUAGE));
Registry::get('view')->assign('countries', fn_get_simple_countries(true, CART_LANGUAGE));
// Add destination
} elseif ($mode == 'add') {
Registry::get('view')->assign('states', fn_destination_get_states(CART_LANGUAGE));
Registry::get('view')->assign('countries', fn_get_simple_countries(true, CART_LANGUAGE));
// Destinations list
} elseif ($mode == 'manage') {
$destinations = fn_get_destinations(DESCR_SL);
Registry::get('view')->assign('destinations', $destinations);
} elseif ($mode == 'delete') {
if (!empty($_REQUEST['destination_id'])) {
fn_delete_destinations((array) $_REQUEST['destination_id']);
}
return array(CONTROLLER_STATUS_REDIRECT, "destinations.manage");
}
function fn_delete_destinations($destination_ids)
{
foreach ($destination_ids as $dest_id) {
if (!empty($dest_id) && $dest_id != 1) {
$destination_data['zipcodes'] = implode("\n", $destination_data['zipcodes']);
$destination_data['cities'] = db_get_hash_single_array("SELECT element_id, element FROM ?:destination_elements WHERE element_type = 'T' AND destination_id = ?i", array('element_id', 'element'), $_REQUEST['destination_id']);
$destination_data['cities'] = implode("\n", $destination_data['cities']);
$destination_data['addresses'] = db_get_hash_single_array("SELECT element_id, element FROM ?:destination_elements WHERE element_type = 'A' AND destination_id = ?i", array('element_id', 'element'), $_REQUEST['destination_id']);
$destination_data['addresses'] = implode("\n", $destination_data['addresses']);
$all_countries = fn_get_simple_countries(true, CART_LANGUAGE);
$all_countries = array_diff_assoc($all_countries, $destination_data['countries']);
$all_states = fn_destination_get_states(CART_LANGUAGE);
$all_states = array_diff_assoc($all_states, $destination_data['states']);
Tygh::$app['view']->assign('destination_data', $destination_data);
Tygh::$app['view']->assign('destination', $destination);
Tygh::$app['view']->assign('states', $all_states);
Tygh::$app['view']->assign('countries', $all_countries);
// Add destination
} elseif ($mode == 'add') {
Tygh::$app['view']->assign('states', fn_destination_get_states(CART_LANGUAGE));
Tygh::$app['view']->assign('countries', fn_get_simple_countries(true, CART_LANGUAGE));
// Destinations list
} elseif ($mode == 'manage') {
$destinations = fn_get_destinations(DESCR_SL);
Tygh::$app['view']->assign('destinations', $destinations);
}
function fn_delete_destinations($destination_ids)
{
foreach ($destination_ids as $dest_id) {
if (!empty($dest_id) && $dest_id != 1) {
db_query("DELETE FROM ?:destinations WHERE destination_id = ?i", $dest_id);
db_query("DELETE FROM ?:destination_descriptions WHERE destination_id = ?i", $dest_id);
db_query("DELETE FROM ?:destination_elements WHERE destination_id = ?i", $dest_id);
db_query("DELETE FROM ?:shipping_rates WHERE destination_id = ?i", $dest_id);
db_query("DELETE FROM ?:tax_rates WHERE destination_id = ?i", $dest_id);
