X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_rallyes.php;h=14c2124e01451da752ae8e4431ed8ff7b87d8e5b;hb=63f159414369b5ea19a8ca75d8cd8033c45d8341;hp=89ff23fd70a0c01b8c9a92d0fda8758c3f90d12e;hpb=57227d33e870ec5cd271209c4a978a52b45c2dd6;p=mailer.git diff --git a/inc/modules/admin/what-list_rallyes.php b/inc/modules/admin/what-list_rallyes.php index 89ff23fd70..14c2124e01 100644 --- a/inc/modules/admin/what-list_rallyes.php +++ b/inc/modules/admin/what-list_rallyes.php @@ -14,11 +14,10 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2012 by Mailer Developer Team * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -42,58 +41,58 @@ if ((!defined('__SECURITY')) || (!isAdmin())) { } // END - if // Add description as navigation point -addMenuDescription('admin', __FILE__); +addYouAreHereLink('admin', __FILE__); // Init message $message = ''; // Quick actions on a rallye -if (isGetRequestParameterSet('rallye')) { +if (isGetRequestElementSet('rallye_id')) { // Init SQL queries initSqls(); - if (isGetRequestParameterSet('activate')) { + if (isGetRequestElementSet('activate')) { // Activate / deactivate - switch (getRequestParameter('activate')) { + switch (getRequestElement('activate')) { case '1': // Activate addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='Y' WHERE `id`=%s AND `is_active`='N' LIMIT 1", - array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false) + array(bigintval(getRequestElement('rallye_id'))), __FILE__, __LINE__, false) ); break; case '0': // Deactivate addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='N' WHERE `id`=%s AND `is_active`='Y' LIMIT 1", - array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false) + array(bigintval(getRequestElement('rallye_id'))), __FILE__, __LINE__, false) ); break; } // END - switch - } elseif (isGetRequestParameterSet('notify')) { + } elseif (isGetRequestElementSet('notify')) { // Automatic notification - switch (getRequestParameter('notify')) { + switch (getRequestElement('notify')) { case '1': // Activate addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='Y' WHERE `id`=%s AND `send_notify`='N' LIMIT 1", - array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false) + array(bigintval(getRequestElement('rallye_id'))), __FILE__, __LINE__, false) ); break; case '0': // Deactivate addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='N' WHERE `id`=%s AND `send_notify`='Y' LIMIT 1", - array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false) + array(bigintval(getRequestElement('rallye_id'))), __FILE__, __LINE__, false) ); break; } // END - switch - } elseif (isGetRequestParameterSet('auto')) { + } elseif (isGetRequestElementSet('auto')) { // Automatic adding of new members - switch (getRequestParameter('auto')) { + switch (getRequestElement('auto')) { case '1': // Activate addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `auto_add_new_user`='Y' WHERE `id`=%s AND `auto_add_new_user`='N' LIMIT 1", - array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false) + array(bigintval(getRequestElement('rallye_id'))), __FILE__, __LINE__, false) ); break; case '0': // Deactivate addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `auto_add_new_user`='N' WHERE `id`=%s AND `auto_add_new_user`='Y' LIMIT 1", - array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false) + array(bigintval(getRequestElement('rallye_id'))), __FILE__, __LINE__, false) ); break; } // END - switch @@ -101,14 +100,14 @@ if (isGetRequestParameterSet('rallye')) { // Run SQL command runFilterChain('run_sqls'); -} elseif (isPostRequestParameterSet('remove')) { +} elseif (isFormSent('do_delete')) { // Delete rallyes - if (countPostSelection() > 0) { + if (ifPostContainsSelections()) { // Init SQLs initSqls(); // Delete selected rallyes and all it's data - foreach (postRequestParameter('sel') as $id => $selected) { + foreach (postRequestElement('sel') as $id => $selected) { // Remove selected rallye entirely... addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_data` WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__, false)); @@ -122,25 +121,25 @@ if (isGetRequestParameterSet('rallye')) { runFilterChain('run_sqls'); // Output message - $message = getMessage('RALLYE_DELETED'); + $message = '{--ADMIN_RALLYE_DELETED--}'; } else { // No rallye selected to delete! - $message = getMessage('RALLYE_DELETE_NOTHING_SELECTED'); + $message = '{--ADMIN_RALLYE_DELETE_NOTHING_SELECTED--}'; } -} elseif (isPostRequestParameterSet('change')) { +} elseif (isFormSent('do_edit')) { // Change rallye - if (countSelection(postRequestParameter('title')) > 0) { + if (ifPostContainsSelections('title')) { // Init SQLs initSqls(); // Change selected rallyes and all it's data - foreach (postRequestParameter('title') as $id => $title) { + foreach (postRequestElement('title') as $id => $title) { // Secure id number $id = bigintval($id); // Generate timestamps - $START = mktime(postRequestParameter('start_hour', $id), postRequestParameter('start_min', $id), postRequestParameter('start_sec', $id), postRequestParameter('start_month', $id), postRequestParameter('start_day', $id), postRequestParameter('start_year', $id)); - $END = mktime(postRequestParameter('end_hour', $id) , postRequestParameter('end_min', $id) , postRequestParameter('end_sec', $id) , postRequestParameter('end_month', $id) , postRequestParameter('end_day', $id) , postRequestParameter('end_year', $id) ); + $START = mktime(postRequestElement('start_time_hour', $id), postRequestElement('start_time_min', $id), 0, postRequestElement('start_time_month', $id), postRequestElement('start_time_day', $id), postRequestElement('start_time_year', $id)); + $END = mktime(postRequestElement('end_time_hour', $id) , postRequestElement('end_time_min', $id) , 0, postRequestElement('end_time_month', $id) , postRequestElement('end_time_day', $id) , postRequestElement('end_time_year', $id) ); // Update entry addSql(SQL_QUERY_ESC("UPDATE @@ -149,21 +148,21 @@ SET `title`='%s', `descr`='%s', `template`='%s', - `start_time`='%s', - `end_time`='%s', - `min_users`='%s', - `min_prices`='%s' + `start_time`=%s, + `end_time`=%s, + `min_users`=%s, + `min_prices`=%s WHERE - `id`='%s' + `id`=%s LIMIT 1", array( $title, - postRequestParameter('descr', $id), - postRequestParameter('templ', $id), + postRequestElement('descr', $id), + postRequestElement('templ', $id), bigintval($START), bigintval($END), - bigintval(postRequestParameter('min_users', $id)), - bigintval(postRequestParameter('min_prices', $id)), + bigintval(postRequestElement('min_users', $id)), + bigintval(postRequestElement('min_prices', $id)), $id ), __FILE__, __LINE__, false)); } @@ -172,107 +171,136 @@ LIMIT 1", runFilterChain('run_sqls'); // Output message - $message = getMessage('RALLYE_CHANGED'); + $message = '{--ADMIN_RALLYE_CHANGED--}'; } } -if (isPostRequestParameterSet('edit')) { +// edit/delete are both handled the same way +if ((isFormSent('edit')) || (isFormSent('delete'))) { + // Default is 'edit' + $mode = 'edit'; + + // Is delete button used? + if (isFormSent('delete')) { + // Then set it + $mode = 'delete'; + } // END - if + // Check for selections - if (countPostSelection() > 0) { + if (ifPostContainsSelections()) { // Make all selected and deactivated rallyes editable - $OUT = ''; $SW = 2; - foreach (postRequestParameter('sel') as $id => $selected) { + $OUT = ''; + foreach (postRequestElement('sel') as $id => $selected) { // Load rallye basic data $result = SQL_QUERY_ESC("SELECT - `title`, `descr`, `template`, `start_time`, `end_time`, `min_users`, `min_prices` + `title`, + `descr`, + `template`, + `start_time`, + `end_time`, + `min_users`, + `min_prices` FROM `{?_MYSQL_PREFIX?}_rallye_data` WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); + // Fetch an array $content = SQL_FETCHARRAY($result); // Free result SQL_FREERESULT($result); - // Starting day - $content['s_sec'] = addSelectionBox('sec' , date('s', $content['start_time']), 'start', $id); - $content['s_min'] = addSelectionBox('min' , date('i', $content['start_time']), 'start', $id); - $content['s_hour'] = addSelectionBox('hour' , date('G', $content['start_time']), 'start', $id); - $content['s_day'] = addSelectionBox('day' , date('d', $content['start_time']), 'start', $id); - $content['s_month'] = addSelectionBox('month', date('m', $content['start_time']), 'start', $id); - $content['s_year'] = addSelectionBox('year' , date('Y', $content['start_time']), 'start', $id); - - // Ending day - $content['e_sec'] = addSelectionBox('sec' , date('s', $content['end_time']) , 'end' , $id); - $content['e_min'] = addSelectionBox('min' , date('i', $content['end_time']) , 'end' , $id); - $content['e_hour'] = addSelectionBox('hour' , date('G', $content['end_time']) , 'end' , $id); - $content['e_day'] = addSelectionBox('day' , date('d', $content['end_time']) , 'end' , $id); - $content['e_month'] = addSelectionBox('month', date('m', $content['end_time']) , 'end' , $id); - $content['e_year'] = addSelectionBox('year' , date('Y', $content['end_time']) , 'end' , $id); - - // Remember other values - $content['templ'] = addReferalRallyeTemplateSelection('templ['.$id.']', $content['template']); - $content['sw'] = $SW; - $content['id'] = $id; + // Only for editing ... + if ($mode == 'edit') { + // Starting day + $content['s_min'] = addSelectionBox('min' , getMinute($content['start_time']) , 'start_time', $id); + $content['s_hour'] = addSelectionBox('hour' , getShortHour($content['start_time']), 'start_time', $id); + $content['s_day'] = addSelectionBox('day' , getDay($content['start_time']) , 'start_time', $id); + $content['s_month'] = addSelectionBox('month', getMonth($content['start_time']) , 'start_time', $id); + $content['s_year'] = addSelectionBox('year' , getYear($content['start_time']) , 'start_time', $id); + + // Ending day + $content['e_min'] = addSelectionBox('min' , getMinute($content['end_time']) , 'end_time' , $id); + $content['e_hour'] = addSelectionBox('hour' , getShortHour($content['end_time']) , 'end_time' , $id); + $content['e_day'] = addSelectionBox('day' , getDay($content['end_time']) , 'end_time' , $id); + $content['e_month'] = addSelectionBox('month', getMonth($content['end_time']) , 'end_time' , $id); + $content['e_year'] = addSelectionBox('year' , getYear($content['end_time']) , 'end_time' , $id); + + // Remember other values + $content['templ'] = addReferralRallyeTemplateSelection('templ[' . $id . ']', $content['template']); + } else { + // Convert timestamps into human-readable + $content['start_time'] = generateDateTime($content['start_time'], '2'); + $content['end_time'] = generateDateTime($content['end_time'] , '2'); + } - // Output row - $OUT .= loadTemplate('admin_edit_rallyes_row', true, $content); + // Remember id number + $content['rallye_id'] = bigintval($id); - // Color switching - $SW = 3 - $SW; - } + // Output row + $OUT .= loadTemplate('admin_' . $mode . '_rallyes_row', true, $content); + } // END - foreach // Load final template - loadTemplate('admin_edit_rallyes', false, $OUT); + loadTemplate('admin_' . $mode . '_rallyes', false, $OUT); } else { // Nothing selected to edit - loadTemplate('admin_settings_saved', false, loadTemplate('admin_list_rallye_noselect', true)); + displayMessage('{--ADMIN_RALLYE_NO_RALLYES_SELECTED--}'); } -} elseif ((getRequestParameter('sub') == 'users') && (getRequestParameter('rallye') > 0)) { +} elseif ((getRequestElement('sub') == 'users') && (getRequestElement('rallye_id') > 0)) { // List users and their refs before start and current - $result = SQL_QUERY_ESC("SELECT `userid`, `refs`, `curr_points` FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE `rallye_id`=%s ORDER BY `userid` ASC", - array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) { - $OUT = ''; $SW = 2; - $content['rallye'] = getRequestParameter('rallye'); + $result = SQL_QUERY_ESC("SELECT + `userid`, + `refs`, + `curr_points` +FROM + `{?_MYSQL_PREFIX?}_rallye_users` +WHERE + `rallye_id`=%s +ORDER BY + `userid` ASC", + array(bigintval(getRequestElement('rallye_id'))), __FILE__, __LINE__); + if (!SQL_HASZERONUMS($result)) { + $OUT = ''; + $content['rallye_id'] = bigintval(getRequestElement('rallye_id')); while ($row = SQL_FETCHARRAY($result)) { - // Check for referal count - $cnt = getReferalRallyeRefsCount($row['userid'], $row['refs']); + // Check for referral count + $count = getReferralRallyeRefsCount($row['userid'], $row['refs']); // Init variables $bl = ''; $br = ''; // Output row - if (($row['curr_points'] > 0) && ($cnt > 0)) { $bl = ''; $br = ''; } + if (($row['curr_points'] > 0) && ($count > 0)) { + $bl = ''; + $br = ''; + } // END - if // Get user points - $points = countSumTotalData($row['userid'], 'user_points', 'points', 'userid', false, " AND `ref_depth`=1 LIMIT 1"); - //* DEBUG: */ outputHtml(basename(__FILE__).":userid={$row['userid']},points={$points},opoints={$row['curr_points']}
"); + $points = countSumTotalData($row['userid'], 'user_points', 'points', 'userid', false, " AND `ref_depth`=1"); + //* DEBUG: */ debugOutput(basename(__FILE__).':userid='.$row['userid'].',points='.$points.',opoints='.$row['curr_points']); // Prepare content - // @TODO Rewritings: opoints->curr_points,old->refs in template $row = array( - 'sw' => $SW , 'userid' => $row['userid'], 'bold_l' => $bl , 'bold_r' => $br , - 'old' => $row['refs'], - 'cnt' => $cnt, - 'opoints' => translateComma($points - $row['curr_points']), + 'refs' => $row['refs'], + 'count' => $count, + 'opoints' => ($points - $row['curr_points']), ); // Load row template and switch color $OUT .= loadTemplate('admin_list_rallye_usr_row', true, $row); - $SW = 3 - $SW; } // END - while // Remember rows - $content['rows'] = $OUT; - $content['rallye'] = getRequestParameter('rallye'); + $content['rows'] = $OUT; + $content['rallye_id'] = bigintval(getRequestElement('rallye_id')); // Free memory SQL_FREERESULT($result); @@ -281,106 +309,106 @@ LIMIT 1", loadTemplate('admin_list_rallye_usr', false, $content); } else { // No entries found? - loadTemplate('admin_settings_saved', false, getMessage('RALLYE_ADMIN_USERS_404')); + displayMessage('{--ADMIN_RALLYE_USERS_404--}'); } } else { // Start listing rallyes $result = SQL_QUERY("SELECT - `id`, `admin_id`, `title`, `descr`, `template`, `start_time`, `end_time`, `auto_add_new_user`, `is_active`, `send_notify`, `notified`, `min_users`, `min_prices` + `id` AS `rallye_id`, + `admin_id`, + `title`, + `descr`, + `template`, + `start_time`, + `end_time`, + `auto_add_new_user`, + `is_active`, + `send_notify`, + `notified`, + `min_users`, + `min_prices` FROM `{?_MYSQL_PREFIX?}_rallye_data` ORDER BY `start_time` DESC", __FILE__, __LINE__); // Records found? - if (SQL_NUMROWS($result) > 0) { + if (!SQL_HASZERONUMS($result)) { // List found rallyes - $OUT = ''; $SW = 2; + $OUT = ''; while ($data = SQL_FETCHARRAY($result)) { - // Load admin login - $data['login'] = getAdminLogin($data['admin_id']); - // Count joined userids - $joined = countSumTotalData($data['id'], 'rallye_users', 'id', 'rallye_id', true); + $users = countSumTotalData($data['rallye_id'], 'rallye_users', 'rallye_id', 'rallye_id', true); // Did some users joined this rallye? - if ($joined > 0) { + if ($users > 0) { // List joined users - $joined = '' . $joined . ''; + $users = '{%pipe,translateComma=' . $users . '%}'; } // END - if - // Alter some variables - if (empty($data['login'])) $data['login'] = '???'; - if (empty($data['template'])) $data['template'] = '---'; - if (empty($data['descr'])) $data['descr'] = '---'; - // Transfer data into array for the template $row = array( - 'select' => '', - 'admin_id' => $data['admin_id'], - 'admin_link' => generateAdminLink($data['admin_id']), - 'login' => $data['login'], - 'id' => $data['id'], - 'sw' => $SW, - 'title' => $data['title'], - 'template' => $data['template'], - 'joined' => $joined, - 'start_date' => generateDateTime($data['start_time'], 2), - 'end_date' => generateDateTime($data['end_time'] , 2), - 'active_lnk' => translateYesNo($data['is_active']), - 'notify_lnk' => translateYesNo($data['send_notify']), - 'auto_lnk' => translateYesNo($data['auto_add_new_user']), - 'notified' => translateYesNo($data['notified']), - 'prices_cnt' => translateComma(countSumTotalData($data['id'], 'rallye_prices', 'id', 'rallye_id', true)), - 'descr' => $data['descr'], - 'min_users' => $data['min_users'], - 'min_prices' => $data['min_prices'], + 'select' => '', + 'admin_id' => $data['admin_id'], + 'rallye_id' => $data['rallye_id'], + 'title' => $data['title'], + 'template' => $data['template'], + 'users_content' => $users, + 'start_date' => generateDateTime($data['start_time'], 2), + 'end_date' => generateDateTime($data['end_time'] , 2), + 'is_active' => $data['is_active'], + 'send_notify' => $data['send_notify'], + 'auto_add_new_user' => $data['auto_add_new_user'], + 'notified' => $data['notified'], + 'prices_cnt' => countSumTotalData($data['rallye_id'], 'rallye_prices', 'rallye_id', 'rallye_id', true), + 'descr' => $data['descr'], + 'min_users' => $data['min_users'], + 'min_prices' => $data['min_prices'], ); // Is the rallye active or not? switch ($data['is_active']) { case 'Y': // Rallye is active so do not edit it! - $row['select'] = '
' . $row['id'] . '
'; - $row['active_title'] = getMessage('RALLYE_DEACTIVATE_NOW'); - $row['active'] = '0'; + $row['select'] = '
' . $row['rallye_id'] . '
'; + $row['active_title'] = '{--ADMIN_RALLYE_DEACTIVATE_NOW--}'; + $row['active'] = '0'; break; case 'N': - $row['active_title'] = getMessage('RALLYE_ACTIVATE_NOW'); - $row['active'] = 1; + $row['active_title'] = '{--ADMIN_RALLYE_ACTIVATE_NOW--}'; + $row['active'] = 1; break; - } + } // END - switch // Notification to members? switch ($data['send_notify']) { case 'Y': - $row['notify_title'] = getMessage('RALLYE_STOP_NOTIFY_NOW'); - $row['notify'] = '0'; + $row['notify_title'] = '{--ADMIN_RALLYE_STOP_NOTIFY_NOW--}'; + $row['notify'] = '0'; break; case 'N': - $row['notify_title'] = getMessage('RALLYE_START_NOTIFY_NOW'); - $row['notify'] = 1; + $row['notify_title'] = '{--ADMIN_RALLYE_START_NOTIFY_NOW--}'; + $row['notify'] = 1; break; - } + } // END - switch // Auto-add of new joined members? switch ($data['auto_add_new_user']) { case 'Y': - $row['auto_title'] = getMessage('RALLYE_STOP_AUTO_ADD_NOW'); - $row['auto'] = '0'; + $row['auto_title'] = '{--ADMIN_RALLYE_STOP_AUTO_ADD_NOW--}'; + $row['auto'] = '0'; break; case 'N': - $row['auto_title'] = getMessage('RALLYE_START_AUTO_ADD_NOW'); - $row['auto'] = 1; + $row['auto_title'] = '{--ADMIN_RALLYE_START_AUTO_ADD_NOW--}'; + $row['auto'] = 1; break; - } + } // END - switch // Output row $OUT .= loadTemplate('admin_list_rallyes_row', true, $row); - $SW = 3 - $SW; } // END - while // Free memory @@ -393,7 +421,7 @@ ORDER BY loadTemplate('admin_list_rallyes', false, $content); } else { // No rallyes setup so far - loadTemplate('admin_settings_saved', false, getMessage('RALLYE_NO_RALLYES_SETUP')); + displayMessage('{--ADMIN_RALLYE_NO_RALLYES_SETUP--}'); } }