X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_rallye_prices.php;h=7b4fb0a4e371de935403dd41e58c1b9bd35aea33;hb=2272afc569a7b308e6c34a2d28457495e6b2483b;hp=33f53536c65ea0fcf0828c98fe5ed92a4187020e;hpb=7c9cf221f2f7ef99d45fc233bf346c9f9168ef3e;p=mailer.git diff --git a/inc/modules/admin/what-config_rallye_prices.php b/inc/modules/admin/what-config_rallye_prices.php index 33f53536c6..7b4fb0a4e3 100644 --- a/inc/modules/admin/what-config_rallye_prices.php +++ b/inc/modules/admin/what-config_rallye_prices.php @@ -1,7 +1,7 @@ 0) { + if (ifPostContainsSelections()) { // Delete selected entries - foreach ($_POST['sel'] as $id => $sel) { - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE id=%s LIMIT 1", + foreach (postRequestParameter('sel') as $id => $sel) { + SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); - } + } // END - foreach // Output message - LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_ENTRIES_DELETED); + displayMessage('{--RALLYE_ENTRIES_DELETED--}'); } else { - LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_ENTRIES_NOT_DELETED); + displayMessage('{--RALLYE_ENTRIES_NOT_DELETED--}'); } - } elseif (isset($_POST['change'])) { + } elseif (isFormSent('do_edit')) { // Change entries - foreach ($_POST['level'] as $id => $level) { - // Secure ID + foreach (postRequestParameter('level') as $id => $level) { + // Secure id $id = bigintval($id); // Update entry - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_rallye_prices` SET rallye_id=%s, price_level='%s', points='%s', info='%s' WHERE id=%s LIMIT 1", - array($_POST['rallye_id'][$id], bigintval($level), $_POST['points'][$id], $_POST['infos'][$id], $id), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE + `{?_MYSQL_PREFIX?}_rallye_prices` +SET + `rallye_id`=%s, + `price_level`=%d, + `points`=%s, + `info`='%s' +WHERE + `id`=%s +LIMIT 1", + array( + postRequestParameter('rallye_id', $id), + bigintval($level), + postRequestParameter('points', $id), + postRequestParameter('infos', $id), + $id + ), __FILE__, __LINE__); } // Output message - LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_ENTRIES_CHANGED); + displayMessage('{--RALLYE_ENTRIES_CHANGED--}'); } - if (isset($_POST['edit'])) { + if (isFormSent('edit')) { // Check if at last one line is selected - $SEL = SELECTION_COUNT($_POST['sel']); - if ($SEL > 0) - { + if (ifPostContainsSelections()) { // Make selected editable - $SW = 2; $OUT = ""; - foreach ($_POST['sel'] as $id => $sel) - { + $OUT = ''; + foreach (postRequestParameter('sel') as $id => $sel) { // Load data to selected rallye - $result = SQL_QUERY_ESC("SELECT rallye_id, price_level, points, info FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE id=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - list($rallye, $level, $points, $infos) = SQL_FETCHROW($result); + $result = SQL_QUERY_ESC("SELECT `rallye_id`, `price_level`, `points`, `info` FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `id`=%s LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); + $content = SQL_FETCHARRAY($result); SQL_FREERESULT($result); - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'rallyes' => ADD_OPTION_LINES("rallye_data", "id", "title", $rallye), - 'level' => $level, - 'points' => $points, - 'infos' => $infos, - ); + // Add more content + $content['rallye_content'] = generateOptionList('rallye_data', 'id', 'title', $content['rallye_id']); // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_config_rallye_edit_row", true, $content); - $SW = 3 - $SW; - } - define('__PRICE_ROWS', $OUT); + $OUT .= loadTemplate('admin_config_rallye_edit_row', true, $content); + } // END - foreach + + // Remember row content + $content['rows'] = $OUT; // Prepare data for the main template - define('__RALLYE_ID', $_GET['rallye']); + $content['rallye'] = getRequestParameter('rallye'); // Load main template - LOAD_TEMPLATE("admin_config_rallye_edit"); - } - else - { + loadTemplate('admin_config_rallye_edit', false, $content); + } else { // Nothing selected - $content = RALLYE_NO_PRICES_SELECTED_1."".RALLYE_NO_PRICES_SELECTED_2."".RALLYE_NO_PRICES_SELECTED_3; - LOAD_TEMPLATE("admin_settings_saved", false, $content); + $content = '{--RALLYE_NO_PRICES_SELECTED_1--}{--RALLYE_NO_PRICES_SELECTED_2--}{--RALLYE_NO_PRICES_SELECTED_3--}'; + displayMessage($content); } - } - elseif (isset($_POST['del'])) - { + } elseif (isFormSent('delete')) { // Check if at last one line is selected - $SEL = SELECTION_COUNT($_POST['sel']); - if ($SEL > 0) - { + if (ifPostContainsSelections()) { // List all prices - $SW = 2; $OUT = ""; - foreach ($_POST['sel'] as $id => $sel) - { + $OUT = ''; + foreach (postRequestParameter('sel') as $id => $sel) { // Load data to selected rallye - $result = SQL_QUERY_ESC("SELECT rallye_id, price_level, points, info FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE id=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - list($rallye, $level, $points, $infos) = SQL_FETCHROW($result); + $result = SQL_QUERY_ESC("SELECT `rallye_id`, `price_level`, `points`, `info` FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `id`=%s LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); + $content = SQL_FETCHARRAY($result); SQL_FREERESULT($result); - if (empty($infos)) $infos = "---"; - - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'level' => $level, - 'points' => $points, - 'infos' => $infos, - ); - // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_config_rallye_del_row", true, $content); - $SW = 3 - $SW; - } - define('__PRICE_ROWS', $OUT); + $OUT .= loadTemplate('admin_config_rallye_del_row', true, $content); + } // END - foreach + $content['rows'] = $OUT; // Prepare data for the main template - define('__RALLYE_ID', $_GET['rallye']); + $content['rallye'] = getRequestParameter('rallye'); // Load main template - LOAD_TEMPLATE("admin_config_rallye_del"); - } - else - { + loadTemplate('admin_config_rallye_del', false, $content); + } else { // Nothing selected - $content = RALLYE_NO_PRICES_SELECTED_1."".RALLYE_NO_PRICES_SELECTED_2."".RALLYE_NO_PRICES_SELECTED_3; - LOAD_TEMPLATE("admin_settings_saved", false, $content); + $content = '{--RALLYE_NO_PRICES_SELECTED_1--}{--RALLYE_NO_PRICES_SELECTED_2--}{--RALLYE_NO_PRICES_SELECTED_3--}'; + displayMessage($content); } - } - else - { + } else { // a rallye was selected, so check if there are already prices assigned... - $result = SQL_QUERY_ESC("SELECT id, price_level, points, info FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE rallye_id=%s ORDER BY price_level", - array(bigintval($_GET['rallye'])), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("SELECT `id`, `price_level`, `points`, `info` FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `rallye_id`=%s ORDER BY `price_level` ASC", + array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) - { + if (!SQL_HASZERONUMS($result)) { // Load all prices for the selected rallye - $SW = 2; $OUT = ""; - while (list($id, $level, $points, $infos) = SQL_FETCHROW($result)) - { - if (empty($infos)) $infos = "---"; - - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'level' => $level, - 'points' => $points, - 'infos' => $infos, - ); - + $OUT = ''; + while ($content = SQL_FETCHARRAY($result)) { // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_config_rallye_prices_row", true, $content); - $SW = 3 - $SW; - } + $OUT .= loadTemplate('admin_config_rallye_prices_row', true, $content); + } // END - while // Free memory SQL_FREERESULT($result); - define('__PRICE_ROWS', $OUT); + + // @TODO Rewrite these two constants + $content['rows'] = $OUT; // Prepare data for the main template - define('__RALLYE_ID', $_GET['rallye']); + $content['rallye'] = getRequestParameter('rallye'); // Load main template - LOAD_TEMPLATE("admin_config_rallye_prices"); - } + loadTemplate('admin_config_rallye_prices', false, $content); + } // END - if } // Add form for adding new price level - if (empty($_POST['edit'])) - { - LOAD_TEMPLATE("admin_add_rallye_prices", false, $_GET['rallye']); - } -} - else -{ + if (!isFormSent('edit')) { + loadTemplate('admin_add_rallye_prices', false, getRequestParameter('rallye')); + } // END - if +} else { // No rallye selected so display all available without prices - $result = SQL_QUERY("SELECT d.id, d.admin_id, d.start_time, d.end_time, d.title, a.login, d.is_active -FROM `{!_MYSQL_PREFIX!}_rallye_data` AS d, `{!_MYSQL_PREFIX!}_admins` AS a -WHERE d.admin_id=a.id ORDER BY start_time DESC", __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) - { + $result = SQL_QUERY("SELECT + d.id, d.admin_id, d.start_time, d.end_time, d.title, a.login, d.is_active +FROM + `{?_MYSQL_PREFIX?}_rallye_data` AS d +LEFT JOIN + `{?_MYSQL_PREFIX?}_admins` AS a +ON + d.admin_id=a.id +ORDER BY + d.start_time DESC", __FILE__, __LINE__); + if (!SQL_HASZERONUMS($result)) { // List found rallyes - $SW = 2; $OUT = ""; - while (list($id, $aid, $start, $end, $title, $alogin, $active) = SQL_FETCHROW($result)) - { - $select = ""; - if ($active == "Y") $select = "