inc/modules/member/what-holiday.php

   1 <?php
   2 /************************************************************************
   3  * Mailer v0.2.1-FINAL                                Start: 07/24/2004 *
   4  * ===================                          Last change: 07/31/2004 *
   5  *                                                                      *
   6  * -------------------------------------------------------------------- *
   7  * File              : what-holiday.php                                 *
   8  * -------------------------------------------------------------------- *
   9  * Short description : Holiday requests                                 *
  10  * -------------------------------------------------------------------- *
  11  * Kurzbeschreibung  : Urlaubsschaltungen                               *
  12  * -------------------------------------------------------------------- *
  13  * $Revision::                                                        $ *
  14  * $Date::                                                            $ *
  15  * $Tag:: 0.2.1-FINAL                                                 $ *
  16  * $Author::                                                          $ *
  17  * -------------------------------------------------------------------- *
  18  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  19  * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
  20  * For more information visit: http://mxchange.org                      *
  21  *                                                                      *
  22  * This program is free software; you can redistribute it and/or modify *
  23  * it under the terms of the GNU General Public License as published by *
  24  * the Free Software Foundation; either version 2 of the License, or    *
  25  * (at your option) any later version.                                  *
  26  *                                                                      *
  27  * This program is distributed in the hope that it will be useful,      *
  28  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
  29  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
  30  * GNU General Public License for more details.                         *
  31  *                                                                      *
  32  * You should have received a copy of the GNU General Public License    *
  33  * along with this program; if not, write to the Free Software          *
  34  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
  35  * MA  02110-1301  USA                                                  *
  36  ************************************************************************/
  37
  38 // Some security stuff...
  39 if (!defined('__SECURITY')) {
  40         exit();
  41 } elseif (!isMember()) {
  42         redirectToIndexMemberOnlyModule();
  43 }
  44
  45 // Add description as navigation point
  46 addYouAreHereLink('member', __FILE__);
  47
  48 if ((!isExtensionActive('holiday')) && (!isAdmin())) {
  49         displayMessage('{%pipe,generateExtensionInactiveNotInstalledMessage=holiday%}');
  50         return;
  51 } // END - if
  52
  53 // Init content array
  54 $content = array();
  55
  56 // Check for running mail orders in pool
  57 $result1 = SQL_QUERY_ESC("SELECT
  58         `timestamp`
  59 FROM
  60         `{?_MYSQL_PREFIX?}_pool`
  61 WHERE
  62         `sender`=%s
  63 ORDER BY
  64         `timestamp` DESC
  65 LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
  66
  67 // Check for sent mail orders in stats
  68 $result2 = SQL_QUERY_ESC("SELECT
  69         `timestamp_ordered`
  70 FROM
  71         `{?_MYSQL_PREFIX?}_user_stats`
  72 WHERE
  73         `userid`=%s
  74 ORDER BY
  75         `timestamp_ordered` DESC
  76 LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
  77
  78 if ((SQL_NUMROWS($result1) == 1) || (SQL_NUMROWS($result2) == 1)) {
  79         // Mail order found
  80         $content = merge_array($content, SQL_FETCHARRAY($result1));
  81         $content = merge_array($content, SQL_FETCHARRAY($result2));
  82
  83         // Fix missing entries
  84         if (empty($content['timestamp'])) $content['timestamp'] = '0';
  85         if (empty($content['timestamp_ordered'])) $content['timestamp_ordered'] = '0';
  86
  87         if ((($content['timestamp'] + getConfig('holiday_lock')) > time()) || (($content['timestamp_ordered'] + getConfig('holiday_lock')) > time())) {
  88                 // Mail order is to close away!
  89                 unsetPostRequestElement('ok');
  90                 unsetPostRequestElement('stop');
  91
  92                 if (($content['timestamp'] + getConfig('holiday_lock')) > time()) {
  93                         // Mail found in pool
  94                         $stamp = $content['timestamp'];
  95                 } else {
  96                         // Mail found in stats
  97                         $stamp = $content['timestamp_ordered'];
  98                 }
  99
 100                 // Display message and exit here
 101                 displayMessage('{%message,MEMBER_HOLIDAY_ORDER', generateDateTime($stamp, '1') . '%}');
 102                 return;
 103         }
 104 } // END - if
 105
 106 // Free memory
 107 SQL_FREERESULT($result1);
 108 SQL_FREERESULT($result2);
 109
 110 if (isFormSent()) {
 111         // Check holiday request...
 112         $START = mktime(0, 0, 0, postRequestElement('start_month'), postRequestElement('start_day'), postRequestElement('start_year'));
 113         $content['holiday_end']   = mktime(0, 0, 0, postRequestElement('end_month')  , postRequestElement('end_day')  , postRequestElement('end_year')  );
 114
 115         // Test both values
 116         $TEST = $content['holiday_end'] - $START;
 117         if (($TEST < 0) || ($TEST > (getOneDay() * getConfig('holiday_max'))) || ($START < time()) || ($content['holiday_end'] < time())) {
 118                 // Time test failed
 119                 unsetPostRequestElement('ok');
 120         } else {
 121                 // Everything went okay so let's store his request and send mails
 122                 SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_holidays` (`userid`, `holiday_start`, `holiday_end`, `comments`) VALUES ('%s','%s','%s','%s')",
 123                         array(getMemberId(), $START, $content['holiday_end'], postRequestElement('comments')), __FILE__, __LINE__);
 124
 125                 // Activate holiday system
 126                 SQL_QUERY_ESC("UPDATE
 127         `{?_MYSQL_PREFIX?}_user_data`
 128 SET
 129         `holiday_active`='N',
 130         `holiday_activated`=UNIX_TIMESTAMP()
 131 WHERE
 132         `userid`=%s
 133 LIMIT 1",
 134                         array(getMemberId()), __FILE__, __LINE__);
 135
 136                 // Prepare constants
 137                 $content['start_day']   = bigintval(postRequestElement('start_day'));
 138                 $content['start_month'] = $GLOBALS['month_descr'][postRequestElement('start_month')];
 139                 $content['start_year']  = bigintval(postRequestElement('start_year'));
 140                 $content['end_day']     = bigintval(postRequestElement('end_day'));
 141                 $content['end_month']   = $GLOBALS['month_descr'][postRequestElement('end_month')];
 142                 $content['end_year']    = bigintval(postRequestElement('end_year'));
 143                 $content['comments']    = postRequestElement('comments');
 144
 145                 // Send mail to member
 146                 $message = loadEmailTemplate('member_holiday_request', $content, getMemberId());
 147                 sendEmail(getMemberId(), '{--MEMBER_HOLIDAY_SUBJECT--}', $message);
 148
 149                 // Send mail to all admins
 150                 sendAdminNotification('{--ADMIN_HOLIDAY_SUBJECT--}', 'admin_holiday_request', $content, getMemberId());
 151
 152                 // Create task (we ignore the task id here)
 153                 createNewTask('{--ADMIN_HOLIDAY_SUBJECT--}', $message, 'HOLIDAY_REQUEST', getMemberId());
 154
 155                 // Display message
 156                 displayMessage('{--MEMBER_HOLIDAY_IS_ACTIVATED_NOW--}');
 157         }
 158 } // END - if
 159
 160 // Holiday shall be ended now
 161 if (isPostRequestElementSet('stop')) {
 162         // Okay, end the holiday here...
 163         $result = SQL_QUERY_ESC("SELECT
 164         `holiday_active`,
 165         `holiday_activated`
 166 FROM
 167         `{?_MYSQL_PREFIX?}_user_data`
 168 WHERE
 169         `userid`=%s
 170 LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
 171
 172         // Is there an entry?
 173         if (SQL_NUMROWS($result) == 1) {
 174                 // Merge arrays
 175                 $content = merge_array($content, SQL_FETCHARRAY($result));
 176
 177                 if (($content['holiday_active'] == 'Y') && (($content['holiday_activated'] + getConfig('holiday_lock')) < time())) {
 178                         // Load data
 179                         $result2 = SQL_QUERY_ESC("SELECT
 180         `holiday_start`,
 181         `holiday_end`
 182 FROM
 183         `{?_MYSQL_PREFIX?}_user_holidays`
 184 WHERE
 185         `userid`=%s
 186 LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
 187                         if (SQL_NUMROWS($result2) == 1) {
 188                                 // Data was found so merge it
 189                                 $content = merge_array($content, SQL_FETCHARRAY($result2));
 190
 191                                 // Prepare it for the template
 192                                 $content['start'] = generateDateTime($content['holiday_start'], 3);
 193                                 $content['end']   = generateDateTime($content['holiday_end']  , 3);
 194
 195                                 // Deactivate it now
 196                                 SQL_QUERY_ESC("UPDATE
 197         `{?_MYSQL_PREFIX?}_user_data`
 198 SET
 199         `holiday_active`='N',
 200         `holiday_activated`=0
 201 WHERE
 202         `userid`=%s
 203 LIMIT 1",
 204                                         array(getMemberId()), __FILE__, __LINE__);
 205
 206                                 // Remove entry
 207                                 SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM
 208         `{?_MYSQL_PREFIX?}_user_holidays`
 209 WHERE
 210         `userid`=%s
 211 LIMIT 1",
 212                                         array(getMemberId()), __FILE__, __LINE__);
 213
 214                                 // Send email to admin
 215                                 sendAdminNotification('{--ADMIN_HOLIDAY_DEACTIVATED_SUBJECT--}', 'admin_holiday_deactivated', $content, getMemberId());
 216
 217                                 // Display message to user
 218                                 displayMessage('{--MEMBER_HOLIDAY_DEACTIVATED_NOW--}');
 219                         } else {
 220                                 // Display message to user
 221                                 displayMessage('{--MEMBER_HOLIDAY_CANNOT_DEACTIVATE--}');
 222                         }
 223
 224                         // Free result
 225                         SQL_FREERESULT($result2);
 226                 } elseif ($content['holiday_active'] == 'Y') {
 227                         // To fast!
 228                         displayMessage('{--MEMBER_HOLIDAY_LOCKED--}');
 229                 }
 230         } else {
 231                 // User not found
 232                 displayMessage('{--MEMBER_HOLIDAY_NOT_STOPPED_404--}');
 233         }
 234
 235         // Free result
 236         SQL_FREERESULT($result);
 237 } // END - if
 238
 239 // If something is wrong or link in menu is just clicked display form
 240 if ((!isFormSent()) && (!isPostRequestElementSet('stop'))) {
 241         // Check if user is in holiday...
 242         $result = SQL_QUERY_ESC("SELECT
 243         `holiday_active`,
 244         `holiday_activated`
 245 FROM
 246         `{?_MYSQL_PREFIX?}_user_data`
 247 WHERE
 248         `userid`=%s
 249 LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
 250         $content = SQL_FETCHARRAY($result);
 251         SQL_FREERESULT($result);
 252
 253         // Check for lock
 254         if (($content['holiday_activated'] + getConfig('holiday_lock')) < time()) {
 255                 // User can deactivate his holiday request
 256                 switch ($content['holiday_active']) {
 257                         case 'Y': // Display deactivation form
 258                                 // Load starting and ending date
 259                                 $result = SQL_QUERY_ESC("SELECT
 260         `holiday_start`,
 261         `holiday_end`
 262 FROM
 263         `{?_MYSQL_PREFIX?}_user_holidays`
 264 WHERE
 265         `userid`=%s
 266 LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
 267                                 if (SQL_NUMROWS($result) == 1) {
 268                                         // Data was found so merge it
 269                                         $content = merge_array($content, SQL_FETCHARRAY($result));
 270
 271                                         // Prepare it for the template
 272                                         $content['start'] = generateDateTime($content['holiday_start'] , 3);
 273                                         $content['end']   = generateDateTime($content['holiday_end']   , 3);
 274                                         $content['lock']  = generateDateTime($content['holiday_activated'], 1);
 275
 276                                         // Load template
 277                                         loadTemplate('member_holiday_deactivate', FALSE, $content);
 278                                 } else {
 279                                         // Free memory
 280                                         SQL_FREERESULT($result);
 281
 282                                         // Remove entry and reload URL
 283                                         SQL_QUERY_ESC("UPDATE
 284         `{?_MYSQL_PREFIX?}_user_data`
 285 SET
 286         `holiday_active`='N'
 287 WHERE
 288         `userid`=%s
 289 LIMIT 1",
 290                                                 array(getMemberId()), __FILE__, __LINE__);
 291                                         redirectToUrl('modules.php?module=login&amp;what=holiday');
 292                                         return;
 293                                 }
 294
 295                                 // Free result
 296                                 SQL_FREERESULT($result);
 297                                 break;
 298
 299                         case 'N': // Display activation form
 300                                 // Cache timestamps
 301                                 $startingStamp = time() + getOneDay();
 302                                 $endingStamp   = $startingStamp + (getOneDay() * getConfig('holiday_max'));
 303
 304                                 // Starting day
 305                                 $content['start_day']   = addSelectionBox('day'  , getDay($startingStamp)  , 'start');
 306                                 $content['start_month'] = addSelectionBox('month', getMonth($startingStamp), 'start');
 307                                 $content['start_year']  = addSelectionBox('year' , getYear($startingStamp) , 'start');
 308
 309                                 // Ending day
 310                                 $content['end_day']   = addSelectionBox('day'  , getDay($endingStamp)  , 'end');
 311                                 $content['end_month'] = addSelectionBox('month', getMonth($endingStamp), 'end');
 312                                 $content['end_year']  = addSelectionBox('year' , getYear($endingStamp) , 'end');
 313
 314                                 // Output form
 315                                 loadTemplate('member_holiday_form', FALSE, $content);
 316                                 break;
 317                 } // END - switch
 318         } else {
 319                 // To fast!
 320                 displayMessage('{--MEMBER_HOLIDAY_LOCKED--}');
 321         }
 322 } // END - if
 323
 324 // [EOF]
 325 ?>