X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_country.php;h=93a5d73c87e94246efdec0fb8733bd25c16826d1;hp=2a151aa1e7351357f8e4ff4c5efcc217dc3a7a29;hb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;hpb=e98608bf2a6208376d30996cf9152e1f091ac369 diff --git a/inc/modules/admin/what-list_country.php b/inc/modules/admin/what-list_country.php index 2a151aa1e7..93a5d73c87 100644 --- a/inc/modules/admin/what-list_country.php +++ b/inc/modules/admin/what-list_country.php @@ -1,7 +1,7 @@ "modules.php?module=admin&what=list_country", - 'title' => getMessage('ADMIN_COUNTRY_ACTIVATION_NEXT_LINK') + loadTemplate('admin_next_link', FALSE, array( + 'url' => 'modules.php?module=admin&what=list_country', + 'title' => '{--ADMIN_COUNTRY_ACTIVATION_NEXT_LINK--}' )); -} elseif (((REQUEST_ISSET_POST('edit')) || (REQUEST_ISSET_POST('delete'))) && (REQUEST_ISSET_POST(('id')))) { - if (count(REQUEST_POST('id')) > 0) { - if (REQUEST_ISSET_POST('edit')) { +} elseif (((isFormSent('edit')) || (isPostRequestElementSet('delete'))) && (isPostRequestElementSet('id'))) { + // Are there entries? + if (ifPostContainsSelections('id')) { + // Is the proper form sent? + if (isFormSent('edit')) { // Edit template - $row = "admin_list_country_edit_row"; - $post = "modify"; - $class = "admin_submit"; - $submit = getMessage('ADMIN_COUNTRY_EDIT_NOW'); - $title = getMessage('ADMIN_COUNTRY_EDIT_TITLE'); - $reset = " *\n"; + $row = 'admin_edit_country_row'; + $do = 'do_edit'; + $class = 'form_submit'; + $submit = '{--ADMIN_COUNTRY_EDIT_NOW--}'; + $title = '{--ADMIN_COUNTRY_EDIT_TITLE--}'; + $reset = ' '; } else { // Delete template - $row = "admin_list_country_del_row"; - $post = "remove"; - $class = "admin_delete"; - $submit = getMessage('ADMIN_COUNTRY_DELETE_NOW'); - $title = getMessage('ADMIN_COUNTRY_DELETE_TITLE'); - $reset = ""; + $row = 'admin_delete_country_row'; + $do = 'do_delete'; + $class = 'form_delete'; + $submit = '{--ADMIN_COUNTRY_DELETE_NOW--}'; + $title = '{--ADMIN_COUNTRY_DELETE_TITLE--}'; + $reset = ''; } // Edit all selected country codes - $OUT = ""; $SW = 2; - foreach (REQUEST_POST('id') as $id => $status) { + $OUT = ''; + foreach (postRequestElement('id') as $id => $isActive) { // Load data from DB - $result = SQL_QUERY_ESC("SELECT code, descr FROM `{!_MYSQL_PREFIX!}_countries` WHERE id=%s LIMIT 1", + $result = sqlQueryEscaped("SELECT `id`, `code`, `descr` FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) { + if (sqlNumRows($result) == 1) { // Load data - list($code, $descr) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - // Prepare data, load row template and switch colors - $content = array( - 'id' => $id, - 'code' => $code, - 'descr' => $descr, - 'sw' => $SW, - ); - - if ($post == "modify") { - // Generate default selection in edit-mode - $content['status'] = ADD_OPTION_LINES("/ARRAY/", array("Y","N"), array(YES, NO ), $status); - } else { - // Only display status when in delete-mode - $content['status'] = TRANSLATE_YESNO($status); - } + $content = sqlFetchArray($result); + + // Add $isActive + $content['is_active'] = $isActive; // Insert row template and switch color - $OUT .= LOAD_TEMPLATE($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); + $OUT .= loadTemplate($row, TRUE, $content); + } // END - if + + // Free result + sqlFreeResult($result); + } // END - foreach + + // Prepare content for template + $content = array( + 'rows' => $OUT, + 'do' => $do, + 'class' => $class, + 'title' => $title, + 'submit' => $submit, + 'reset' => $reset, + ); // Load main template - LOAD_TEMPLATE("admin_list_country_form"); - } + loadTemplate('admin_list_country_form', FALSE, $content); + } // END - if } else { // Shall we modify / remove entries now? - $message = ""; INIT_SQLS(); - if ((REQUEST_ISSET_POST(('modify'))) && (REQUEST_ISSET_POST(('id')))) { + $message = ''; + initSqls(); + if ((isPostRequestElementSet('do_edit')) && (isPostRequestElementSet('id'))) { // Modify - foreach (REQUEST_POST('id') as $id => $sel) { - ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_countries` SET code='".REQUEST_POST('code', $id)."', descr='".REQUEST_POST('descr', $id)."', is_active='".REQUEST_POST('is_active', $id)."' WHERE id='".$id."' LIMIT 1"); - } + foreach (postRequestElement('id') as $id => $sel) { + addSql("UPDATE + `{?_MYSQL_PREFIX?}_countries` +SET + `code`='" . postRequestElement('code', $id) . "', + `descr`='" . postRequestElement('descr', $id) . "', + `is_active`='" . postRequestElement('is_active', $id) . "' +WHERE + `id`=" . bigintval($id) . " +LIMIT 1"); + } // END - foreach // Create message - $message = getMessage('ADMIN_COUNTRIES_MODIFIED'); - } elseif ((REQUEST_ISSET_POST('remove')) && (REQUEST_ISSET_POST(('id')))) { + $message = '{--ADMIN_COUNTRIES_MODIFIED--}'; + } elseif ((isFormSent('do_delete')) && (isPostRequestElementSet('id'))) { // Remove - $IDs = implode(",", array_keys(REQUEST_POST('id'))); - ADD_SQL("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_countries` WHERE id IN (".$IDs.") LIMIT ".count(REQUEST_POST('id')).""); + $IDs = implode(',', array_keys(postRequestElement('id'))); + addSql('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id` IN (' . $IDs . ') LIMIT ' . countPostSelection('id') . ''); // Create message - $message = getMessage('ADMIN_COUNTRIES_REMOVED'); + $message = '{--ADMIN_COUNTRIES_REMOVED--}'; } - if ((!empty($message)) && (COUNT_SQLS() > 0)) { + // Are a message and some SQLs set? + if ((!empty($message)) && (countSqls() > 0)) { // Run SQL commands runFilterChain('run_sqls'); // Display message - LOAD_TEMPLATE("admin_settings_saved", false, $message); - } + displayMessage($message); + } // END - if // 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) { - // List all countries - $OUT = ""; $SW = 2; - while ($content = SQL_FETCHARRAY($result)) { - // Prepare array for the template - // @TODO Rewritings: name->descr,status->is_active in template - $content = array( - 'id' => $content['id'], - 'code' => $content['code'], - 'name' => $content['descr'], - 'active' => TRANSLATE_YESNO($content['is_active']), - 'sw' => $SW, - 'status' => $content['is_active'], - ); + $result = sqlQuery('SELECT `id`, `code`, `descr`, `is_active` FROM `{?_MYSQL_PREFIX?}_countries` ORDER BY `code` ASC', + __FILE__, __LINE__); + // Are there entries? + if (!ifSqlHasZeroNumRows($result)) { + // List all countries + $OUT = ''; + while ($content = sqlFetchArray($result)) { // Load row template and switch colors - $OUT .= LOAD_TEMPLATE("admin_list_country_row", true, $content); - $SW = 3 - $SW; - } + $OUT .= loadTemplate('admin_list_country_row', TRUE, $content); + } // END - while // Free memory - SQL_FREERESULT($result); + sqlFreeResult($result); } 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); - - // Include add template - define('__ADD_COUNTRY_FORM', LOAD_TEMPLATE("admin_add_country", true)); + $content['rows'] = $OUT; // Load main template - LOAD_TEMPLATE("admin_list_country"); + loadTemplate('admin_list_country', FALSE, $content); } -// +// [EOF] ?>