X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-holiday.php;h=bfcffff743d30f0ef1765d3bee6c933e18b68651;hp=800ee5a0c3248e98f5b31fef4e537c2c4935219f;hb=04b69ac9f33369cbf654396c4a42cb1fff710ff4;hpb=fe4e98d8332bf21b9bee633ecbf79687cfd11f80 diff --git a/inc/modules/member/what-holiday.php b/inc/modules/member/what-holiday.php index 800ee5a0c3..bfcffff743 100644 --- a/inc/modules/member/what-holiday.php +++ b/inc/modules/member/what-holiday.php @@ -1,7 +1,7 @@ time()) || (($stamp2 + $_CONFIG['holiday_lock']) > time())) - { + // Fix missing entries + if (empty($content['timestamp'])) $content['timestamp'] = '0'; + if (empty($content['timestamp_ordered'])) $content['timestamp_ordered'] = '0'; + + if ((($content['timestamp'] + getConfig('holiday_lock')) > time()) || (($content['timestamp_ordered'] + getConfig('holiday_lock')) > time())) { // Mail order is to close away! - unset($_POST['ok']); - unset($_POST['stop']); + unsetPostRequestParameter('ok'); + unsetPostRequestParameter('stop'); - if (($stamp1 + $_CONFIG['holiday_lock']) > time()) - { + if (($content['timestamp'] + getConfig('holiday_lock')) > time()) { // Mail found in pool - $stamp = $stamp1; - } - else - { + $stamp = $content['timestamp']; + } else { // Mail found in stats - $stamp = $stamp2; + $stamp = $content['timestamp_ordered']; } // Display message and exit here - LOAD_TEMPLATE("admin_settings_saved", false, HOLIDAY_MEMBER_ORDER_1.MAKE_DATETIME($stamp, "1").HOLIDAY_MEMBER_ORDER_2); + loadTemplate('admin_settings_saved', false, getMaskedMessage('HOLIDAY_MEMBER_ORDER', generateDateTime($stamp, 1))); return; } -} +} // END - if // Free memory SQL_FREERESULT($result1); SQL_FREERESULT($result2); -if (isset($_POST['ok'])) -{ +if (isFormSent()) { // Check holiday request... - $START = mktime(0, 0, 0, $_POST['start_month'], $_POST['start_day'], $_POST['start_year']); - $END = mktime(0, 0, 0, $_POST['end_month'] , $_POST['end_day'] , $_POST['end_year'] ); + $START = mktime(0, 0, 0, postRequestParameter('start_month'), postRequestParameter('start_day'), postRequestParameter('start_year')); + $content['holiday_end'] = mktime(0, 0, 0, postRequestParameter('end_month') , postRequestParameter('end_day') , postRequestParameter('end_year') ); // Test both values - $TEST = $END - $START; - if (($TEST < 0) || ($TEST > (ONE_DAY * $_CONFIG['holiday_max'])) || ($START < time()) || ($END < time())) - { + $TEST = $content['holiday_end'] - $START; + if (($TEST < 0) || ($TEST > (getConfig('ONE_DAY') * getConfig('holiday_max'))) || ($START < time()) || ($content['holiday_end'] < time())) { // Time test failed - unset($_POST['ok']); - } - else - { + unsetPostRequestParameter('ok'); + } else { // Everything went okay so let's store his request and send mails - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_holidays (userid, holiday_start, holiday_end, comments) VALUES ('%s', '%s', '%s', '%s')", - array($GLOBALS['userid'], $START, $END, $_POST['comments']), __FILE__, __LINE__); + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_holidays` (`userid`, `holiday_start`, `holiday_end`, `comments`) VALUES ('%s','%s','%s','%s')", + array(getMemberId(), $START, $content['holiday_end'], postRequestParameter('comments')), __FILE__, __LINE__); // Activate holiday system - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data -SET holiday_active='N', holiday_activated=UNIX_TIMESTAMP() -WHERE userid=%s LIMIT 1", - array($GLOBALS['userid']), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE + `{?_MYSQL_PREFIX?}_user_data` +SET + `holiday_active`='N', `holiday_activated`=UNIX_TIMESTAMP() +WHERE + `userid`=%s +LIMIT 1", + array(getMemberId()), __FILE__, __LINE__); // Prepare constants - define('_START_DAY' , $_POST['start_day']); - define('_START_MONTH', $MONTH_DESCR[$_POST['start_month']]); - define('_START_YEAR' , $_POST['start_year']); - define('_END_DAY' , $_POST['end_day']); - define('_END_MONTH' , $MONTH_DESCR[$_POST['end_month']]); - define('_END_YEAR' , $_POST['end_year']); + $content['start_day'] = bigintval(postRequestParameter('start_day')); + $content['start_month'] = $GLOBALS['month_descr'][postRequestParameter('start_month')]; + $content['start_year'] = bigintval(postRequestParameter('start_year')); + $content['end_day'] = bigintval(postRequestParameter('end_day')); + $content['end_month'] = $GLOBALS['month_descr'][postRequestParameter('end_month')]; + $content['end_year'] = bigintval(postRequestParameter('end_year')); + $content['comments'] = secureString(postRequestParameter('comments')); // Send mail to member - $msg = LOAD_EMAIL_TEMPLATE("member_holiday_request", $_POST['comments'], $GLOBALS['userid']); - SEND_EMAIL($GLOBALS['userid'], HOLIDAY_MEMBER_SUBJECT, $msg); + $message = loadEmailTemplate('member_holiday_request', $content, getMemberId()); + sendEmail(getMemberId(), getMessage('HOLIDAY_MEMBER_SUBJECT'), $message); // Send mail to all admins - SEND_ADMIN_NOTIFICATION(HOLIDAY_ADMIN_SUBJECT, "admin_holiday_request", $_POST['comments'], $GLOBALS['userid']); + sendAdminNotification(getMessage('HOLIDAY_ADMIN_SUBJECT'), 'admin_holiday_request', $content, getMemberId()); // Create task - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_task_system (userid, assigned_admin, status, task_type, subject, text, task_created) VALUES ('%s', '0', 'NEW', 'HOLIDAY_REQUEST', '%s', '%s', UNIX_TIMESTAMP())", - array($GLOBALS['userid'], HOLIDAY_ADMIN_SUBJECT, addslashes($msg)), __FILE__, __LINE__); + createNewTask('{--HOLIDAY_ADMIN_SUBJECT--}', $message, 'HOLIDAY_REQUEST', getMemberId()); // Display message - LOAD_TEMPLATE("admin_settings_saved", false, HOLIDAY_IS_ACTIVATED_NOW); + loadTemplate('admin_settings_saved', false, '{--HOLIDAY_IS_ACTIVATED_NOW--}'); } -} +} // END - if // Holiday shall be ended now -if (isset($_POST['stop'])) -{ +if (isPostRequestParameterSet('stop')) { // Okay, end the holiday here... - $result = SQL_QUERY_ESC("SELECT holiday_active, holiday_activated FROM "._MYSQL_PREFIX."_user_data -WHERE userid=%s LIMIT 1", array($GLOBALS['userid']), __FILE__, __LINE__); - list($active, $locked) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - if (($active == "Y") && (($locked + $_CONFIG['holiday_lock']) < time())) - { - // Load data - $result = SQL_QUERY_ESC("SELECT holiday_start, holiday_end FROM "._MYSQL_PREFIX."_user_holidays -WHERE userid=%s LIMIT 1", array($GLOBALS['userid']), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { - // Data was found - list($start, $end) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - // Prepare it for the template - define('__HOLIDAY_START', MAKE_DATETIME($start, "3")); - define('__HOLIDAY_END' , MAKE_DATETIME($end , "3")); - - // Deactivate it now - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data -SET holiday_active='N', holiday_activated='0' -WHERE userid=%s LIMIT 1", array($GLOBALS['userid']), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("SELECT + `holiday_active`, `holiday_activated` +FROM + `{?_MYSQL_PREFIX?}_user_data` +WHERE + `userid`=%s +LIMIT 1", array(getMemberId()), __FILE__, __LINE__); + + // Do we have an entry? + if (SQL_NUMROWS($result) == 1) { + // Merge arrays + $content = merge_array($content, SQL_FETCHARRAY($result)); + + if (($content['holiday_active'] == 'Y') && (($content['holiday_activated'] + getConfig('holiday_lock')) < time())) { + // Load data + $result2 = SQL_QUERY_ESC("SELECT + `holiday_start`, `holiday_end` +FROM + `{?_MYSQL_PREFIX?}_user_holidays` +WHERE + `userid`=%s +LIMIT 1", array(getMemberId()), __FILE__, __LINE__); + if (SQL_NUMROWS($result2) == 1) { + // Data was found so merge it + $content = merge_array($content, SQL_FETCHARRAY($result2)); - // Remove entry - $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_holidays -WHERE userid=%s LIMIT 1", array($GLOBALS['userid']), __FILE__, __LINE__); - - // Send email to admin - SEND_ADMIN_NOTIFICATION(HOLIDAY_ADMIN_DEAC_SUBJ, "admin_holiday_deactivated", "", $GLOBALS['userid']); + // Prepare it for the template + $content['start'] = generateDateTime($content['holiday_start'], 3); + $content['end'] = generateDateTime($content['holiday_end'] , 3); + + // Deactivate it now + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` +SET + `holiday_active`='N', + `holiday_activated`=0 +WHERE + `userid`=%s +LIMIT 1", + array(getMemberId()), __FILE__, __LINE__); + + // Remove entry + SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM + `{?_MYSQL_PREFIX?}_user_holidays` +WHERE + `userid`=%s +LIMIT 1", + array(getMemberId()), __FILE__, __LINE__); + + // Send email to admin + sendAdminNotification(getMessage('HOLIDAY_ADMIN_DEAC_SUBJ'), 'admin_holiday_deactivated', $content, getMemberId()); + + // Display message to user + loadTemplate('admin_settings_saved', false, '{--HOLIDAY_MEMBER_DEACTIVATED_NOW--}'); + } else { + // Display message to user + loadTemplate('admin_settings_saved', false, '{--HOLIDAY_MEMBER_CANNOT_DEACTIVATE--}'); + } - // Display message to user - LOAD_TEMPLATE("admin_settings_saved", false, HOLIDAY_MEMBER_DEACTIVATED_NOW); - } - else - { - // Display message to user - LOAD_TEMPLATE("admin_settings_saved", false, HOLIDAY_MEMBER_CANNOT_DEACTIVATE); + // Free result + SQL_FREERESULT($result2); + } elseif ($content['holiday_active'] == 'Y') { + // To fast! + loadTemplate('admin_settings_saved', false, '{--HOLIDAY_MEMBER_LOCKED--}'); } + } else { + // User not found + loadTemplate('admin_settings_saved', false, getMaskedMessage('HOLIDAY_MEMBER_NOT_STOPPED_404', getMemberId())); } - elseif ($active == "Y") - { - // To fast! - LOAD_TEMPLATE("admin_settings_saved", false, HOLIDAY_MEMBER_LOCKED); - } -} + + // Free result + SQL_FREERESULT($result); +} // END - if // If something is wrong or link in menu is just clicked display form -if ((!isset($_POST['ok'])) && (!isset($_POST['stop']))) -{ +if ((!isFormSent()) && (!isPostRequestParameterSet('stop'))) { // Check if user is in holiday... - $result = SQL_QUERY_ESC("SELECT holiday_active, holiday_activated FROM "._MYSQL_PREFIX."_user_data -WHERE userid=%s LIMIT 1", array($GLOBALS['userid']), __FILE__, __LINE__); - list($active, $locked) = SQL_FETCHROW($result); + $result = SQL_QUERY_ESC("SELECT + `holiday_active`, `holiday_activated` +FROM + `{?_MYSQL_PREFIX?}_user_data` +WHERE + `userid`=%s +LIMIT 1", array(getMemberId()), __FILE__, __LINE__); + $content = SQL_FETCHARRAY($result); SQL_FREERESULT($result); // Check for lock - if (($locked + $_CONFIG['holiday_lock']) < time()) - { + if (($content['holiday_activated'] + getConfig('holiday_lock')) < time()) { // User can deactivate his holiday request - switch ($active) + switch ($content['holiday_active']) { - case 'Y': // Display deactivation form - // Load starting and ending date - $result = SQL_QUERY_ESC("SELECT holiday_start, holiday_end FROM "._MYSQL_PREFIX."_user_holidays -WHERE userid=%s LIMIT 1", array($GLOBALS['userid']), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { - // Data was found - list($start, $end) = SQL_FETCHROW($result); + case 'Y': // Display deactivation form + // Load starting and ending date + $result = SQL_QUERY_ESC("SELECT + `holiday_start`, `holiday_end` +FROM + `{?_MYSQL_PREFIX?}_user_holidays` +WHERE + `userid`=%s +LIMIT 1", array(getMemberId()), __FILE__, __LINE__); + if (SQL_NUMROWS($result) == 1) { + // Data was found so merge it + $content = merge_array($content, SQL_FETCHARRAY($result)); + + // Prepare it for the template + $content['start'] = generateDateTime($content['holiday_start'] , 3); + $content['end'] = generateDateTime($content['holiday_end'] , 3); + $content['lock'] = generateDateTime($content['holiday_activated'], 1); + + // Load template + loadTemplate('member_holiday_deactivate', false, $content); + } else { + // Free memory + SQL_FREERESULT($result); + + // Remove entry and reload URL + SQL_QUERY_ESC("UPDATE + `{?_MYSQL_PREFIX?}_user_data` +SET + `holiday_active`='N' +WHERE + `userid`=%s +LIMIT 1", array(getMemberId()), __FILE__, __LINE__); + redirectToUrl('modules.php?module=login&what=holiday'); + return; + } + + // Free result SQL_FREERESULT($result); - - // Prepare it for the template - define('__HOLIDAY_START', MAKE_DATETIME($start , "3")); - define('__HOLIDAY_END' , MAKE_DATETIME($end , "3")); - define('__HOLIDAY_LOCK' , MAKE_DATETIME($locked, "1")); - - // Load template - LOAD_TEMPLATE("member_holiday_deactivate"); - } - else - { - // Free memory - SQL_FREERESULT($result); - - // Remove entry and reload URL - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data -SET holiday_active='N' -WHERE userid=%s LIMIT 1", array($GLOBALS['userid']), __FILE__, __LINE__); - LOAD_URL("modules.php?module=login&what=holiday"); - return; - } - break; - - case 'N': // Display activation form - // Starting day - define('_START_DAY' , ADD_SELECTION("day" , date("d", (time() + ONE_DAY)), "start")); - define('_START_MONTH', ADD_SELECTION("month", date("m", (time() + ONE_DAY)), "start")); - define('_START_YEAR' , ADD_SELECTION("year" , date('Y', (time() + ONE_DAY)), "start")); - - // Calcualte ending date - $D = date("d", time() + ONE_DAY + (ONE_DAY * $_CONFIG['holiday_max'])); - $M = date("m", time() + ONE_DAY + (ONE_DAY * $_CONFIG['holiday_max'])); - $Y = date('Y', time() + ONE_DAY + (ONE_DAY * $_CONFIG['holiday_max'])); - - // Ending day - define('_END_DAY' , ADD_SELECTION("day" , $D, "end")); - define('_END_MONTH', ADD_SELECTION("month", $M, "end")); - define('_END_YEAR' , ADD_SELECTION("year" , $Y, "end")); - - // Copy value from configuration - define('__HOLIDAY_MAX', $_CONFIG['holiday_max']); - - // Output form - LOAD_TEMPLATE("member_holiday_form"); - break; + break; + + case 'N': // Display activation form + // Starting day + $content['start_day'] = addSelectionBox('day' , date('d', (time() + getConfig('ONE_DAY'))), 'start'); + $content['start_month'] = addSelectionBox('month', date('m', (time() + getConfig('ONE_DAY'))), 'start'); + $content['start_year'] = addSelectionBox('year' , date('Y', (time() + getConfig('ONE_DAY'))), 'start'); + + // Calcualte ending date + $D = date('d', time() + getConfig('ONE_DAY') + (getConfig('ONE_DAY') * getConfig('holiday_max'))); + $M = date('m', time() + getConfig('ONE_DAY') + (getConfig('ONE_DAY') * getConfig('holiday_max'))); + $Y = date('Y', time() + getConfig('ONE_DAY') + (getConfig('ONE_DAY') * getConfig('holiday_max'))); + + // Ending day + $content['end_day'] = addSelectionBox('day' , $D, 'end'); + $content['end_month'] = addSelectionBox('month', $M, 'end'); + $content['end_year'] = addSelectionBox('year' , $Y, 'end'); + + // Output form + loadTemplate('member_holiday_form', false, $content); + break; } - } - else - { + } else { // To fast! - LOAD_TEMPLATE("admin_settings_saved", false, HOLIDAY_MEMBER_LOCKED); + loadTemplate('admin_settings_saved', false, '{--HOLIDAY_MEMBER_LOCKED--}'); } -} -// +} // END - if + +// [EOF] ?>