X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_country.php;h=74d517baae03b30874aee20dcd40599f266a9e00;hp=70ea85152ecca172d897b47a6783deb8f6c9782f;hb=ccf34a2a92d80d01debd84b4b6e1f294d8f90cce;hpb=89c00e43d2ce1dd1afe11c2c8485307342805f97 diff --git a/inc/modules/admin/what-list_country.php b/inc/modules/admin/what-list_country.php index 70ea85152e..74d517baae 100644 --- a/inc/modules/admin/what-list_country.php +++ b/inc/modules/admin/what-list_country.php @@ -1,7 +1,7 @@ "); -} -// Change status? - elseif ((isset($_POST['change'])) && (!empty($_POST['id']))) -{ + loadTemplate('admin_settings_saved', false, $message); +} elseif ((isPostRequestParameterSet('change')) && (isPostRequestParameterSet('id'))) { // Change all status - ADMIN_CHANGE_ACTIVATION_STATUS($_POST['id'], "countries", "is_active"); -} -// Edit / delete entries? - elseif (((isset($_POST['edit'])) || (isset($_POST['delete']))) && (!empty($_POST['id']))) -{ - if (count($_POST['id']) > 0) - { - if (isset($_POST['edit'])) - { + adminChangeActivationStatus(postRequestParameter('id'), 'countries', 'is_active'); + + // Show next link + loadTemplate('admin_next_link', false, array( + 'url' => 'modules.php?module=admin&what=list_country', + 'title' => getMessage('ADMIN_COUNTRY_ACTIVATION_NEXT_LINK') + )); +} elseif (((isPostRequestParameterSet('edit')) || (isPostRequestParameterSet('delete'))) && (isPostRequestParameterSet('id'))) { + if (count(postRequestParameter('id')) > 0) { + if (isPostRequestParameterSet('edit')) { // Edit template - $row = "admin_list_country_edit_row"; - $post = "modify"; - $class = "admin_submit"; - $submit = ADMIN_COUNTRY_EDIT_NOW; - $title = ADMIN_COUNTRY_EDIT_TITLE; - $reset = " *\n"; - } - else - { + $row = 'admin_list_country_edit_row'; + $post = 'modify'; + $class = 'admin_submit'; + $submit = getMessage('ADMIN_COUNTRY_EDIT_NOW'); + $title = getMessage('ADMIN_COUNTRY_EDIT_TITLE'); + $reset = ' '; + } else { // Delete template - $row = "admin_list_country_del_row"; - $post = "remove"; - $class = "admin_delete"; - $submit = ADMIN_COUNTRY_DELETE_NOW; - $title = ADMIN_COUNTRY_DELETE_TITLE; - $reset = ""; + $row = 'admin_list_country_del_row'; + $post = 'remove'; + $class = 'admin_delete'; + $submit = getMessage('ADMIN_COUNTRY_DELETE_NOW'); + $title = getMessage('ADMIN_COUNTRY_DELETE_TITLE'); + $reset = ''; } // Edit all selected country codes - $OUT = ""; $SW = 2; - foreach ($_POST['id'] as $id => $status) - { + $OUT = ''; $SW = 2; + foreach (postRequestParameter('id') as $id => $status) { // Load data from DB - $result = SQL_QUERY_ESC("SELECT code, descr FROM "._MYSQL_PREFIX."_countries WHERE id=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { + $result = SQL_QUERY_ESC("SELECT code, descr FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id`=%s LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); + if (SQL_NUMROWS($result) == 1) { // Load data list($code, $descr) = SQL_FETCHROW($result); SQL_FREERESULT($result); @@ -120,110 +117,94 @@ if ((isset($_POST['add'])) && (!empty($_POST['code'])) && (!empty($_POST['descr' 'descr' => $descr, 'sw' => $SW, ); - if ($post == "modify") - { + + if ($post == 'modify') { // Generate default selection in edit-mode - $content['status'] = ADD_OPTION_LINES("/ARRAY/", array("Y","N"), array(YES, NO ), $status); - } - else - { + $content['status'] = generateOptionList('/ARRAY/', array('Y', 'N'), array(getMessage('YES'), getMessage('NO')), $status); + } else { // Only display status when in delete-mode - $content['status'] = TRANSLATE_YESNO($status); + $content['status'] = translateYesNo($status); } - $OUT .= LOAD_TEMPLATE($row, true, $content); + + // Insert row template and switch color + $OUT .= loadTemplate($row, true, $content); $SW = 3 - $SW; } } - define('__COUNTRY_ROWS' , $OUT); - define('__COUNTRY_MODE' , $post); - define('__COUNTRY_CLASS' , $class); - define('__COUNTRY_SUBMIT', $submit); - define('__COUNTRY_TITLE' , $title); - define('__COUNTRY_RESET' , $reset); + + // Prepare content for template + $content = array( + 'rows' => $OUT, + 'mode' => $post, + 'class' => $class, + 'title' => $title, + 'submit' => $submit, + 'reset' => $reset, + ); // Load main template - LOAD_TEMPLATE("admin_list_country_form"); + loadTemplate('admin_list_country_form', false, $content); } -} - else -{ +} else { // Shall we modify / remove entries now? - $MSG = ""; $SQLs = array(); - if ((isset($_POST['modify'])) && (!empty($_POST['id']))) - { + $message = ''; initSqls(); + if ((isPostRequestParameterSet('modify')) && (isPostRequestParameterSet('id'))) { // Modify - foreach ($_POST['id'] as $id => $sel) - { - $SQLs[] = "UPDATE "._MYSQL_PREFIX."_countries SET code='".$_POST['code'][$id]."', descr='".$_POST['descr'][$id]."', is_active='".$_POST['is_active'][$id]."' WHERE id='".$id."' LIMIT 1"; + foreach (postRequestParameter('id') as $id => $sel) { + addSql("UPDATE `{?_MYSQL_PREFIX?}_countries` SET `code`='".postRequestParameter('code', $id)."', `descr`='".postRequestParameter('descr', $id)."', `is_active`='".postRequestParameter('is_active', $id)."' WHERE `id`='".$id."' LIMIT 1"); } // Create message - $MSG = ADMIN_COUNTRIES_MODIFIED; - } - elseif ((isset($_POST['remove'])) && (!empty($_POST['id']))) - { + $message = getMessage('ADMIN_COUNTRIES_MODIFIED'); + } elseif ((isPostRequestParameterSet('remove')) && (isPostRequestParameterSet('id'))) { // Remove - $IDs = implode(", ", bigintval($_POST['id'])); - $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_countries WHERE id IN (".$IDs.") LIMIT ".count($_POST['id']).""; + $IDs = implode(',', array_keys(postRequestParameter('id'))); + addSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id` IN (".$IDs.") LIMIT ".count(postRequestParameter('id')).""); // Create message - $MSG = ADMIN_COUNTRIES_REMOVED; + $message = getMessage('ADMIN_COUNTRIES_REMOVED'); } - if ((!empty($MSG)) && (count($SQLs) > 0)) - { + if ((!empty($message)) && (countSqls() > 0)) { // Run SQL commands - foreach ($SQLs as $sql) - { - $result = SQL_QUERY($sql, __FILE__, __LINE__); - } + runFilterChain('run_sqls'); // Display message - LOAD_TEMPLATE("admin_settings_saved", false, $MSG); - OUTPUT_HTML("
"); + loadTemplate('admin_settings_saved', false, $message); } // Load currenty setup country codes to list - $result = SQL_QUERY("SELECT id, code, descr, is_active FROM "._MYSQL_PREFIX."_countries ORDER BY code", __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) - { + $result = SQL_QUERY('SELECT id, code, descr, is_active FROM `{?_MYSQL_PREFIX?}_countries` ORDER BY code', + __FILE__, __LINE__); + if (SQL_NUMROWS($result) > 0) { // List all countries - $OUT = ""; $SW = 2; - while(list($id, $code, $descr, $active) = SQL_FETCHROW($result)) - { + $OUT = ''; $SW = 2; + while ($content = SQL_FETCHARRAY($result)) { // Prepare array for the template - $content = array( - 'id' => $id, - 'code' => $code, - 'name' => $descr, - 'active' => TRANSLATE_YESNO($active), - 'sw' => $SW, - 'status' => $active, - ); + $content['active'] = translateYesNo($content['is_active']); + $content['sw'] = $SW; // Load row template and switch colors - $OUT .= LOAD_TEMPLATE("admin_list_country_row", true, $content); + $OUT .= loadTemplate('admin_list_country_row', true, $content); $SW = 3 - $SW; } // Free memory SQL_FREERESULT($result); - } - else - { + } else { // No code setup so far (not possible by this software! 'DE' for 'Deutschland' is default - $OUT = LOAD_TEMPLATE("admin_list_country_no_row", true); + $OUT = loadTemplate('admin_list_country_no_row', true); } // Add list to constant for the template - define('__COUNTRY_ROWS', $OUT); + $content['rows'] = $OUT; // Include add template - define('__ADD_COUNTRY_FORM', LOAD_TEMPLATE("admin_add_country", true)); + $content['add_form'] = loadTemplate('admin_add_country', true); // Load main template - LOAD_TEMPLATE("admin_list_country"); + loadTemplate('admin_list_country', false, $content); } -// +// [EOF] ?>