Rewrote 'we' word a little, rewrote mail order to use SQL_INSERTID() instead of anoth...
[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 - 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`,`holiday_end`
261 FROM
262         `{?_MYSQL_PREFIX?}_user_holidays`
263 WHERE
264         `userid`=%s
265 LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
266                                 if (SQL_NUMROWS($result) == 1) {
267                                         // Data was found so merge it
268                                         $content = merge_array($content, SQL_FETCHARRAY($result));
269
270                                         // Prepare it for the template
271                                         $content['start'] = generateDateTime($content['holiday_start'] , 3);
272                                         $content['end']   = generateDateTime($content['holiday_end']   , 3);
273                                         $content['lock']  = generateDateTime($content['holiday_activated'], 1);
274
275                                         // Load template
276                                         loadTemplate('member_holiday_deactivate', false, $content);
277                                 } else {
278                                         // Free memory
279                                         SQL_FREERESULT($result);
280
281                                         // Remove entry and reload URL
282                                         SQL_QUERY_ESC("UPDATE
283         `{?_MYSQL_PREFIX?}_user_data`
284 SET
285         `holiday_active`='N'
286 WHERE
287         `userid`=%s
288 LIMIT 1",
289                                                 array(getMemberId()), __FILE__, __LINE__);
290                                         redirectToUrl('modules.php?module=login&amp;what=holiday');
291                                         return;
292                                 }
293
294                                 // Free result
295                                 SQL_FREERESULT($result);
296                                 break;
297
298                         case 'N': // Display activation form
299                                 // Cache timestamps
300                                 $startingStamp = time() + getOneDay();
301                                 $endingStamp   = $startingStamp + (getOneDay() * getConfig('holiday_max'));
302
303                                 // Starting day
304                                 $content['start_day']   = addSelectionBox('day'  , getDay($startingStamp)  , 'start');
305                                 $content['start_month'] = addSelectionBox('month', getMonth($startingStamp), 'start');
306                                 $content['start_year']  = addSelectionBox('year' , getYear($startingStamp) , 'start');
307
308                                 // Ending day
309                                 $content['end_day']   = addSelectionBox('day'  , getDay($endingStamp)  , 'end');
310                                 $content['end_month'] = addSelectionBox('month', getMonth($endingStamp), 'end');
311                                 $content['end_year']  = addSelectionBox('year' , getYear($endingStamp) , 'end');
312
313                                 // Output form
314                                 loadTemplate('member_holiday_form', false, $content);
315                                 break;
316                 } // END - switch
317         } else {
318                 // To fast!
319                 displayMessage('{--MEMBER_HOLIDAY_LOCKED--}');
320         }
321 } // END - if
322
323 // [EOF]
324 ?>