A lot has been rewritten, ext-teams added, ext-forced continued:
[mailer.git] / 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 - 2011 by Mailer Developer Team                   *
20  * For more information visit: http://www.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         die();
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                 unsetPostRequestParameter('ok');
90                 unsetPostRequestParameter('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, postRequestParameter('start_month'), postRequestParameter('start_day'), postRequestParameter('start_year'));
113         $content['holiday_end']   = mktime(0, 0, 0, postRequestParameter('end_month')  , postRequestParameter('end_day')  , postRequestParameter('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                 unsetPostRequestParameter('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'], postRequestParameter('comments')), __FILE__, __LINE__);
124
125                 // Activate holiday system
126                 SQL_QUERY_ESC("UPDATE
127         `{?_MYSQL_PREFIX?}_user_data`
128 SET
129         `holiday_active`='N', `holiday_activated`=UNIX_TIMESTAMP()
130 WHERE
131         `userid`=%s
132 LIMIT 1",
133                         array(getMemberId()), __FILE__, __LINE__);
134
135                 // Prepare constants
136                 $content['start_day']   = bigintval(postRequestParameter('start_day'));
137                 $content['start_month'] = $GLOBALS['month_descr'][postRequestParameter('start_month')];
138                 $content['start_year']  = bigintval(postRequestParameter('start_year'));
139                 $content['end_day']     = bigintval(postRequestParameter('end_day'));
140                 $content['end_month']   = $GLOBALS['month_descr'][postRequestParameter('end_month')];
141                 $content['end_year']    = bigintval(postRequestParameter('end_year'));
142                 $content['comments']    = postRequestParameter('comments');
143
144                 // Send mail to member
145                 $message = loadEmailTemplate('member_holiday_request', $content, getMemberId());
146                 sendEmail(getMemberId(), '{--MEMBER_HOLIDAY_SUBJECT--}', $message);
147
148                 // Send mail to all admins
149                 sendAdminNotification('{--ADMIN_HOLIDAY_SUBJECT--}', 'admin_holiday_request', $content, getMemberId());
150
151                 // Create task (we ignore the task id here)
152                 createNewTask('{--ADMIN_HOLIDAY_SUBJECT--}', $message, 'HOLIDAY_REQUEST', getMemberId());
153
154                 // Display message
155                 displayMessage('{--MEMBER_HOLIDAY_IS_ACTIVATED_NOW--}');
156         }
157 } // END - if
158
159 // Holiday shall be ended now
160 if (isPostRequestParameterSet('stop')) {
161         // Okay, end the holiday here...
162         $result = SQL_QUERY_ESC("SELECT
163         `holiday_active`,`holiday_activated`
164 FROM
165         `{?_MYSQL_PREFIX?}_user_data`
166 WHERE
167         `userid`=%s
168 LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
169
170         // Do we have an entry?
171         if (SQL_NUMROWS($result) == 1) {
172                 // Merge arrays
173                 $content = merge_array($content, SQL_FETCHARRAY($result));
174
175                 if (($content['holiday_active'] == 'Y') && (($content['holiday_activated'] + getConfig('holiday_lock')) < time())) {
176                         // Load data
177                         $result2 = SQL_QUERY_ESC("SELECT
178         `holiday_start`,`holiday_end`
179 FROM
180         `{?_MYSQL_PREFIX?}_user_holidays`
181 WHERE
182         `userid`=%s
183 LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
184                         if (SQL_NUMROWS($result2) == 1) {
185                                 // Data was found so merge it
186                                 $content = merge_array($content, SQL_FETCHARRAY($result2));
187
188                                 // Prepare it for the template
189                                 $content['start'] = generateDateTime($content['holiday_start'], 3);
190                                 $content['end']   = generateDateTime($content['holiday_end']  , 3);
191
192                                 // Deactivate it now
193                                 SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data`
194 SET
195         `holiday_active`='N',
196         `holiday_activated`=0
197 WHERE
198         `userid`=%s
199 LIMIT 1",
200                                         array(getMemberId()), __FILE__, __LINE__);
201
202                                 // Remove entry
203                                 SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM
204         `{?_MYSQL_PREFIX?}_user_holidays`
205 WHERE
206         `userid`=%s
207 LIMIT 1",
208                                         array(getMemberId()), __FILE__, __LINE__);
209
210                                 // Send email to admin
211                                 sendAdminNotification('{--ADMIN_HOLIDAY_DEAC_SUBJECT--}', 'admin_holiday_deactivated', $content, getMemberId());
212
213                                 // Display message to user
214                                 displayMessage('{--MEMBER_HOLIDAY_DEACTIVATED_NOW--}');
215                         } else {
216                                 // Display message to user
217                                 displayMessage('{--MEMBER_HOLIDAY_CANNOT_DEACTIVATE--}');
218                         }
219
220                         // Free result
221                         SQL_FREERESULT($result2);
222                 } elseif ($content['holiday_active'] == 'Y') {
223                         // To fast!
224                         displayMessage('{--MEMBER_HOLIDAY_LOCKED--}');
225                 }
226         } else {
227                 // User not found
228                 displayMessage('{--MEMBER_HOLIDAY_NOT_STOPPED_404--}');
229         }
230
231         // Free result
232         SQL_FREERESULT($result);
233 } // END - if
234
235 // If something is wrong or link in menu is just clicked display form
236 if ((!isFormSent()) && (!isPostRequestParameterSet('stop'))) {
237         // Check if user is in holiday...
238         $result = SQL_QUERY_ESC("SELECT
239         `holiday_active`,`holiday_activated`
240 FROM
241         `{?_MYSQL_PREFIX?}_user_data`
242 WHERE
243         `userid`=%s
244 LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
245         $content = SQL_FETCHARRAY($result);
246         SQL_FREERESULT($result);
247
248         // Check for lock
249         if (($content['holiday_activated'] + getConfig('holiday_lock')) < time()) {
250                 // User can deactivate his holiday request
251                 switch ($content['holiday_active']) {
252                         case 'Y': // Display deactivation form
253                                 // Load starting and ending date
254                                 $result = SQL_QUERY_ESC("SELECT
255         `holiday_start`,`holiday_end`
256 FROM
257         `{?_MYSQL_PREFIX?}_user_holidays`
258 WHERE
259         `userid`=%s
260 LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
261                                 if (SQL_NUMROWS($result) == 1) {
262                                         // Data was found so merge it
263                                         $content = merge_array($content, SQL_FETCHARRAY($result));
264
265                                         // Prepare it for the template
266                                         $content['start'] = generateDateTime($content['holiday_start'] , 3);
267                                         $content['end']   = generateDateTime($content['holiday_end']   , 3);
268                                         $content['lock']  = generateDateTime($content['holiday_activated'], 1);
269
270                                         // Load template
271                                         loadTemplate('member_holiday_deactivate', false, $content);
272                                 } else {
273                                         // Free memory
274                                         SQL_FREERESULT($result);
275
276                                         // Remove entry and reload URL
277                                         SQL_QUERY_ESC("UPDATE
278         `{?_MYSQL_PREFIX?}_user_data`
279 SET
280         `holiday_active`='N'
281 WHERE
282         `userid`=%s
283 LIMIT 1",
284                                                 array(getMemberId()), __FILE__, __LINE__);
285                                         redirectToUrl('modules.php?module=login&amp;what=holiday');
286                                         return;
287                                 }
288
289                                 // Free result
290                                 SQL_FREERESULT($result);
291                                 break;
292
293                         case 'N': // Display activation form
294                                 // Cache timestamps
295                                 $startingStamp = time() + getOneDay();
296                                 $endingStamp   = $startingStamp + (getOneDay() * getConfig('holiday_max'));
297
298                                 // Starting day
299                                 $content['start_day']   = addSelectionBox('day'  , getDay($startingStamp)  , 'start');
300                                 $content['start_month'] = addSelectionBox('month', getMonth($startingStamp), 'start');
301                                 $content['start_year']  = addSelectionBox('year' , getYear($startingStamp) , 'start');
302
303                                 // Ending day
304                                 $content['end_day']   = addSelectionBox('day'  , getDay($endingStamp)  , 'end');
305                                 $content['end_month'] = addSelectionBox('month', getMonth($endingStamp), 'end');
306                                 $content['end_year']  = addSelectionBox('year' , getYear($endingStamp) , 'end');
307
308                                 // Output form
309                                 loadTemplate('member_holiday_form', false, $content);
310                                 break;
311                 } // END - switch
312         } else {
313                 // To fast!
314                 displayMessage('{--MEMBER_HOLIDAY_LOCKED--}');
315         }
316 } // END - if
317
318 // [EOF]
319 ?>