]> git.mxchange.org Git - friendica.git/blob - mod/events.php
Merge pull request #605 from fermionic/20130204-events-request-too-many-dates
[friendica.git] / mod / events.php
1 <?php
2
3 require_once('include/bbcode.php');
4 require_once('include/datetime.php');
5 require_once('include/event.php');
6 require_once('include/items.php');
7
8 function events_post(&$a) {
9
10         if(! local_user())
11                 return;
12
13         $event_id = ((x($_POST,'event_id')) ? intval($_POST['event_id']) : 0);
14         $cid = ((x($_POST,'cid')) ? intval($_POST['cid']) : 0);
15         $uid      = local_user();
16         $startyear = intval($_POST['startyear']);
17         $startmonth = intval($_POST['startmonth']);
18         $startday = intval($_POST['startday']);
19         $starthour = intval($_POST['starthour']);
20         $startminute = intval($_POST['startminute']);
21
22         $finishyear = intval($_POST['finishyear']);
23         $finishmonth = intval($_POST['finishmonth']);
24         $finishday = intval($_POST['finishday']);
25         $finishhour = intval($_POST['finishhour']);
26         $finishminute = intval($_POST['finishminute']);
27
28         $adjust   = intval($_POST['adjust']);
29         $nofinish = intval($_POST['nofinish']);
30
31         // The default setting for the `private` field in event_store() is false, so mirror that        
32         $private_event = false;
33
34
35         $start    = sprintf('%d-%d-%d %d:%d:0',$startyear,$startmonth,$startday,$starthour,$startminute);
36         if($nofinish)
37                 $finish = '0000-00-00 00:00:00';
38         else
39                 $finish    = sprintf('%d-%d-%d %d:%d:0',$finishyear,$finishmonth,$finishday,$finishhour,$finishminute);
40
41         if($adjust) {
42                 $start = datetime_convert(date_default_timezone_get(),'UTC',$start);
43                 if(! $nofinish)
44                         $finish = datetime_convert(date_default_timezone_get(),'UTC',$finish);
45         }
46         else {
47                 $start = datetime_convert('UTC','UTC',$start);
48                 if(! $nofinish)
49                         $finish = datetime_convert('UTC','UTC',$finish);
50         }
51
52         // Don't allow the event to finish before it begins.
53         // It won't hurt anything, but somebody will file a bug report
54         // and we'll waste a bunch of time responding to it. Time that 
55         // could've been spent doing something else. 
56
57         if(strcmp($finish,$start) < 0)
58                 $finish = $start;
59
60         $summary  = escape_tags(trim($_POST['summary']));
61         $desc     = escape_tags(trim($_POST['desc']));
62         $location = escape_tags(trim($_POST['location']));
63         $type     = 'event';
64
65         if((! $summary) || (! $start)) {
66                 notice( t('Event title and start time are required.') . EOL);
67                 goaway($a->get_baseurl() . '/events/new');
68         }
69
70         $share = ((intval($_POST['share'])) ? intval($_POST['share']) : 0);
71
72         $c = q("select id from contact where uid = %d and self = 1 limit 1",
73                 intval(local_user())
74         );
75         if(count($c))
76                 $self = $c[0]['id'];
77         else
78                 $self = 0;
79
80
81         if($share) {
82                 $str_group_allow   = perms2str($_POST['group_allow']);
83                 $str_contact_allow = perms2str($_POST['contact_allow']);
84                 $str_group_deny    = perms2str($_POST['group_deny']);
85                 $str_contact_deny  = perms2str($_POST['contact_deny']);
86
87                 // Undo the pseudo-contact of self, since there are real contacts now
88                 if( strpos($str_contact_allow, '<' . $self . '>') !== false )
89                 {
90                         $str_contact_allow = str_replace('<' . $self . '>', '', $str_contact_allow);
91                 }
92                 // Make sure to set the `private` field as true. This is necessary to
93                 // have the posts show up correctly in Diaspora if an event is created
94                 // as visible only to self at first, but then edited to display to others.
95                 if( strlen($str_group_allow) or strlen($str_contact_allow) or strlen($str_group_deny) or strlen($str_contact_deny) )
96                 {
97                         $private_event = true;
98                 }
99         }
100         else {
101                 // Note: do not set `private` field for self-only events. It will
102                 // keep even you from seeing them!
103                 $str_contact_allow = '<' . $self . '>';
104                 $str_group_allow = $str_contact_deny = $str_group_deny = '';
105         }
106
107
108         $datarray = array();
109         $datarray['start'] = $start;
110         $datarray['finish'] = $finish;
111         $datarray['summary'] = $summary;
112         $datarray['desc'] = $desc;
113         $datarray['location'] = $location;
114         $datarray['type'] = $type;
115         $datarray['adjust'] = $adjust;
116         $datarray['nofinish'] = $nofinish;
117         $datarray['uid'] = $uid;
118         $datarray['cid'] = $cid;
119         $datarray['allow_cid'] = $str_contact_allow;
120         $datarray['allow_gid'] = $str_group_allow;
121         $datarray['deny_cid'] = $str_contact_deny;
122         $datarray['deny_gid'] = $str_group_deny;
123         $datarray['private'] = (($private_event) ? 1 : 0);
124         $datarray['id'] = $event_id;
125         $datarray['created'] = $created;
126         $datarray['edited'] = $edited;
127
128         $item_id = event_store($datarray);
129
130         if(! $cid)
131                 proc_run('php',"include/notifier.php","event","$item_id");
132
133 }
134
135
136
137 function events_content(&$a) {
138
139         if(! local_user()) {
140                 notice( t('Permission denied.') . EOL);
141                 return;
142         }
143
144         if(($a->argc > 2) && ($a->argv[1] === 'ignore') && intval($a->argv[2])) {
145                 $r = q("update event set ignore = 1 where id = %d and uid = %d limit 1",
146                         intval($a->argv[2]),
147                         intval(local_user())
148                 );
149         }
150
151         if(($a->argc > 2) && ($a->argv[1] === 'unignore') && intval($a->argv[2])) {
152                 $r = q("update event set ignore = 0 where id = %d and uid = %d limit 1",
153                         intval($a->argv[2]),
154                         intval(local_user())
155                 );
156         }
157
158
159         $editselect = 'none';
160         if( feature_enabled(local_user(), 'richtext') )
161                 $editselect = 'textareas';
162
163         $htpl = get_markup_template('event_head.tpl');
164         $a->page['htmlhead'] .= replace_macros($htpl,array(
165                 '$baseurl' => $a->get_baseurl(),
166                 '$editselect' => $editselect
167         ));
168
169         $etpl = get_markup_template('event_end.tpl');
170         $a->page['end'] .= replace_macros($etpl,array(
171                 '$baseurl' => $a->get_baseurl(),
172                 '$editselect' => $editselect
173         ));
174
175         $o ="";
176         // tabs
177         $tabs = profile_tabs($a, True); 
178
179
180
181         $mode = 'view';
182         $y = 0;
183         $m = 0;
184         $ignored = ((x($_REQUEST,'ignored')) ? intval($_REQUEST['ignored']) : 0);
185
186         if($a->argc > 1) {
187                 if($a->argc > 2 && $a->argv[1] == 'event') {
188                         $mode = 'edit';
189                         $event_id = intval($a->argv[2]);
190                 }
191                 if($a->argv[1] === 'new') {
192                         $mode = 'new';
193                         $event_id = 0;
194                 }
195                 if($a->argc > 2 && intval($a->argv[1]) && intval($a->argv[2])) {
196                         $mode = 'view';
197                         $y = intval($a->argv[1]);
198                         $m = intval($a->argv[2]);
199                 }
200         }
201
202         if($mode == 'view') {
203                 
204                 
205             $thisyear = datetime_convert('UTC',date_default_timezone_get(),'now','Y');
206         $thismonth = datetime_convert('UTC',date_default_timezone_get(),'now','m');
207                 if(! $y)
208                         $y = intval($thisyear);
209                 if(! $m)
210                         $m = intval($thismonth);
211
212                 // Put some limits on dates. The PHP date functions don't seem to do so well before 1900.
213                 // An upper limit was chosen to keep search engines from exploring links millions of years in the future. 
214
215                 if($y < 1901)
216                         $y = 1900;
217                 if($y > 2099)
218                         $y = 2100;
219
220                 $nextyear = $y;
221                 $nextmonth = $m + 1;
222                 if($nextmonth > 12) {
223                                 $nextmonth = 1;
224                         $nextyear ++;
225                 }
226
227                 $prevyear = $y;
228                 if($m > 1)
229                         $prevmonth = $m - 1;
230                 else {
231                         $prevmonth = 12;
232                         $prevyear --;
233                 }
234                         
235                 $dim    = get_dim($y,$m);
236                 $start  = sprintf('%d-%d-%d %d:%d:%d',$y,$m,1,0,0,0);
237                 $finish = sprintf('%d-%d-%d %d:%d:%d',$y,$m,$dim,23,59,59);
238
239
240                 if ($a->argv[1] === 'json'){
241                         if (x($_GET,'start'))   $start = date("Y-m-d h:i:s", $_GET['start']);
242                         if (x($_GET,'end'))     $finish = date("Y-m-d h:i:s", $_GET['end']);
243                 }
244         
245                 $start  = datetime_convert('UTC','UTC',$start);
246                 $finish = datetime_convert('UTC','UTC',$finish);
247
248                 $adjust_start = datetime_convert('UTC', date_default_timezone_get(), $start);
249                 $adjust_finish = datetime_convert('UTC', date_default_timezone_get(), $finish);
250
251
252                 if (x($_GET,'id')){
253                         $r = q("SELECT `event`.*, `item`.`id` AS `itemid`,`item`.`plink`,
254                                 `item`.`author-name`, `item`.`author-avatar`, `item`.`author-link` FROM `event` LEFT JOIN `item` ON `item`.`event-id` = `event`.`id` 
255                                 WHERE `event`.`uid` = %d AND `event`.`id` = %d",
256                                 intval(local_user()),
257                                 intval($_GET['id'])
258                         );
259                 } else {
260                         $r = q("SELECT `event`.*, `item`.`id` AS `itemid`,`item`.`plink`,
261                                 `item`.`author-name`, `item`.`author-avatar`, `item`.`author-link` FROM `event` LEFT JOIN `item` ON `item`.`event-id` = `event`.`id` 
262                                 WHERE `event`.`uid` = %d and event.ignore = %d
263                                 AND (( `adjust` = 0 AND ( `finish` >= '%s' OR ( nofinish AND start >= '%s' ) ) AND `start` <= '%s' ) 
264                                 OR  (  `adjust` = 1 AND ( `finish` >= '%s' OR ( nofinish AND start >= '%s' ) ) AND `start` <= '%s' )) ",
265                                 intval(local_user()),
266                                 intval($ignored),
267                                 dbesc($start),
268                                 dbesc($start),
269                                 dbesc($finish),
270                                 dbesc($adjust_start),
271                                 dbesc($adjust_start),
272                                 dbesc($adjust_finish)
273                         );
274                 }
275
276                 $links = array();
277
278                 if(count($r)) {
279                         $r = sort_by_date($r);
280                         foreach($r as $rr) {
281                                 $j = (($rr['adjust']) ? datetime_convert('UTC',date_default_timezone_get(),$rr['start'], 'j') : datetime_convert('UTC','UTC',$rr['start'],'j'));
282                                 if(! x($links,$j)) 
283                                         $links[$j] = $a->get_baseurl() . '/' . $a->cmd . '#link-' . $j;
284                         }
285                 }
286
287
288                 $events=array();
289
290                 $last_date = '';
291                 $fmt = t('l, F j');
292
293                 if(count($r)) {
294                         $r = sort_by_date($r);
295                         foreach($r as $rr) {
296                                 
297                                 
298                                 $j = (($rr['adjust']) ? datetime_convert('UTC',date_default_timezone_get(),$rr['start'], 'j') : datetime_convert('UTC','UTC',$rr['start'],'j'));
299                                 $d = (($rr['adjust']) ? datetime_convert('UTC',date_default_timezone_get(),$rr['start'], $fmt) : datetime_convert('UTC','UTC',$rr['start'],$fmt));
300                                 $d = day_translate($d);
301                                 
302                                 $start = (($rr['adjust']) ? datetime_convert('UTC',date_default_timezone_get(),$rr['start'], 'c') : datetime_convert('UTC','UTC',$rr['start'],'c'));
303                                 if ($rr['nofinish']){
304                                         $end = null;
305                                 } else {
306                                         $end = (($rr['adjust']) ? datetime_convert('UTC',date_default_timezone_get(),$rr['finish'], 'c') : datetime_convert('UTC','UTC',$rr['finish'],'c'));
307                                 }
308                                 
309                                 
310                                 $is_first = ($d !== $last_date);
311                                         
312                                 $last_date = $d;
313                                 $edit = ((! $rr['cid']) ? array($a->get_baseurl().'/events/event/'.$rr['id'],t('Edit event'),'','') : null);
314                                 $title = strip_tags(html_entity_decode(bbcode($rr['summary']),ENT_QUOTES,'UTF-8'));
315                                 if(! $title) {
316                                         list($title, $_trash) = explode("<br",bbcode($rr['desc']),2);
317                                         $title = strip_tags(html_entity_decode($title,ENT_QUOTES,'UTF-8'));
318                                 }
319                                 $html = format_event_html($rr);
320                                 $rr['desc'] = bbcode($rr['desc']);
321                                 $rr['location'] = bbcode($rr['location']);
322                                 $events[] = array(
323                                         'id'=>$rr['id'],
324                                         'start'=> $start,
325                                         'end' => $end,
326                                         'allDay' => false,
327                                         'title' => $title,
328                                         
329                                         'j' => $j,
330                                         'd' => $d,
331                                         'edit' => $edit,
332                                         'is_first'=>$is_first,
333                                         'item'=>$rr,
334                                         'html'=>$html,
335                                         'plink' => array($rr['plink'],t('link to source'),'',''),
336                                 );
337
338
339                         }
340                 }
341                  
342                 if ($a->argv[1] === 'json'){
343                         echo json_encode($events); killme();
344                 }
345                 
346                 // links: array('href', 'text', 'extra css classes', 'title')
347                 if (x($_GET,'id')){
348                         $tpl =  get_markup_template("event.tpl");
349                 } else {
350 //                      if (get_config('experimentals','new_calendar')==1){
351                                 $tpl = get_markup_template("events-js.tpl");
352 //                      } else {
353 //                              $tpl = get_markup_template("events.tpl");
354 //                      }
355                 }
356
357                 // Get rid of dashes in key names, Smarty3 can't handle them
358                 foreach($events as $key => $event) {
359                         $event_item = array();
360                         foreach($event['item'] as $k => $v) {
361                                 $k = str_replace('-','_',$k);
362                                 $event_item[$k] = $v;
363                         }
364                         $events[$key]['item'] = $event_item;
365                 }
366
367                 $o = replace_macros($tpl, array(
368                         '$baseurl'      => $a->get_baseurl(),
369                         '$tabs'         => $tabs,
370                         '$title'        => t('Events'),
371                         '$new_event'=> array($a->get_baseurl().'/events/new',t('Create New Event'),'',''),
372                         '$previus'      => array($a->get_baseurl()."/events/$prevyear/$prevmonth",t('Previous'),'',''),
373                         '$next'         => array($a->get_baseurl()."/events/$nextyear/$nextmonth",t('Next'),'',''),
374                         '$calendar' => cal($y,$m,$links, ' eventcal'),
375                         
376                         '$events'       => $events,
377                         
378                         
379                 ));
380                 
381                 if (x($_GET,'id')){ echo $o; killme(); }
382                 
383                 return $o;
384                 
385         }
386
387         if($mode === 'edit' && $event_id) {
388                 $r = q("SELECT * FROM `event` WHERE `id` = %d AND `uid` = %d LIMIT 1",
389                         intval($event_id),
390                         intval(local_user())
391                 );
392                 if(count($r))
393                         $orig_event = $r[0];
394         }
395
396         if($mode === 'edit' || $mode === 'new') {
397
398                 $n_checked = ((x($orig_event) && $orig_event['nofinish']) ? ' checked="checked" ' : '');
399                 $a_checked = ((x($orig_event) && $orig_event['adjust']) ? ' checked="checked" ' : '');
400                 $t_orig = ((x($orig_event)) ? $orig_event['summary'] : '');
401                 $d_orig = ((x($orig_event)) ? $orig_event['desc'] : '');
402                 $l_orig = ((x($orig_event)) ? $orig_event['location'] : '');
403                 $eid = ((x($orig_event)) ? $orig_event['id'] : 0);
404                 $cid = ((x($orig_event)) ? $orig_event['cid'] : 0);
405                 $uri = ((x($orig_event)) ? $orig_event['uri'] : '');
406
407
408                 if(! x($orig_event))
409                         $sh_checked = '';
410                 else
411                         $sh_checked = (($orig_event['allow_cid'] === '<' . local_user() . '>' && (! $orig_event['allow_gid']) && (! $orig_event['deny_cid']) && (! $orig_event['deny_gid'])) ? '' : ' checked="checked" ' );
412
413                 if($cid)
414                         $sh_checked .= ' disabled="disabled" ';
415
416
417
418                 $tpl = get_markup_template('event_form.tpl');
419
420                 $sdt = ((x($orig_event)) ? $orig_event['start'] : 'now');
421                 $fdt = ((x($orig_event)) ? $orig_event['finish'] : 'now');
422
423                 $tz = date_default_timezone_get();
424                 if(x($orig_event))
425                         $tz = (($orig_event['adjust']) ? date_default_timezone_get() : 'UTC');
426
427                 $syear = datetime_convert('UTC', $tz, $sdt, 'Y');
428                 $smonth = datetime_convert('UTC', $tz, $sdt, 'm');
429                 $sday = datetime_convert('UTC', $tz, $sdt, 'd');
430
431                 $shour = ((x($orig_event)) ? datetime_convert('UTC', $tz, $sdt, 'H') : 0);
432                 $sminute = ((x($orig_event)) ? datetime_convert('UTC', $tz, $sdt, 'i') : 0);
433
434                 $fyear = datetime_convert('UTC', $tz, $fdt, 'Y');
435                 $fmonth = datetime_convert('UTC', $tz, $fdt, 'm');
436                 $fday = datetime_convert('UTC', $tz, $fdt, 'd');
437
438                 $fhour = ((x($orig_event)) ? datetime_convert('UTC', $tz, $fdt, 'H') : 0);
439                 $fminute = ((x($orig_event)) ? datetime_convert('UTC', $tz, $fdt, 'i') : 0);
440
441                 $f = get_config('system','event_input_format');
442                 if(! $f)
443                         $f = 'ymd';
444
445                 $dateformat = datesel_format($f);
446                 $timeformat = t('hour:minute');
447
448                 require_once('include/acl_selectors.php');
449
450                 $o .= replace_macros($tpl,array(
451                         '$post' => $a->get_baseurl() . '/events',
452                         '$eid' => $eid, 
453                         '$cid' => $cid,
454                         '$uri' => $uri,
455         
456                         '$title' => t('Event details'),
457                         '$desc' => sprintf( t('Format is %s %s. Starting date and Title are required.'),$dateformat,$timeformat),
458                         
459                         '$s_text' => t('Event Starts:') . ' <span class="required" title="' . t('Required') . '">*</span>',
460                         '$s_dsel' => datesel($f,'start',$syear+5,$syear,false,$syear,$smonth,$sday),
461                         '$s_tsel' => timesel('start',$shour,$sminute),
462                         '$n_text' => t('Finish date/time is not known or not relevant'),
463                         '$n_checked' => $n_checked,
464                         '$f_text' => t('Event Finishes:'),
465                         '$f_dsel' => datesel($f,'finish',$fyear+5,$fyear,false,$fyear,$fmonth,$fday),
466                         '$f_tsel' => timesel('finish',$fhour,$fminute),
467                         '$a_text' => t('Adjust for viewer timezone'),
468                         '$a_checked' => $a_checked,
469                         '$d_text' => t('Description:'), 
470                         '$d_orig' => $d_orig,
471                         '$l_text' => t('Location:'),
472                         '$l_orig' => $l_orig,
473                         '$t_text' => t('Title:') . ' <span class="required" title="' . t('Required') . '">*</span>',
474                         '$t_orig' => $t_orig,
475                         '$sh_text' => t('Share this event'),
476                         '$sh_checked' => $sh_checked,
477                         '$acl' => (($cid) ? '' : populate_acl(((x($orig_event)) ? $orig_event : $a->user),false)),
478                         '$submit' => t('Submit')
479
480                 ));
481
482                 return $o;
483         }
484 }