4 * This page will either list all reports available to the current
5 * user (if report id not specified) or display a report (if the
6 * report id is specified).
9 * report_id (optional) - specified report id in webcal_report table
10 * offset (optional) - specifies how many days/weeks/months +/- to display.
11 * For example, if the report type is 1 (today) with offset=5, then
12 * the report will display 5 days from now. Should only be specified
13 * if report_id is specified. Will be ignored if specified report
14 * does not have the webcal_report.cal_allow_nav field set to 'Y'.
15 * user (optional) - specifies which user's calendar to use for the
16 * report. This will be ignored if the chosen report is tied to
20 * If system setting $reports_enabled is set to anything other than
21 * 'Y', then don't allow access to this page.
22 * If webcal_report.cal_is_global is set to 'Y', any user can view
23 * the report. If set to 'N', only the creator (set in
24 * webcal_report.cal_login) can view the report.
25 * If webcal_report.cal_allow_nav is 'Y', then Next and Previous
26 * links will be presented. If 'N', then they will not and the
27 * offset parameter will be ignored.
28 * Public user cannot edit/list reports.
32 include_once $gfplugins.'webcalendar/www/includes/init.php';
34 // Generate the HTML for one event
38 // $time - time (in HHMMSS format)
39 // $duration - event duration (in minutes)
41 // $description - long description of event
42 // $status - event status
43 // $pri - event priority
44 // $access - event access
45 // $event_owner - user associated with this event
46 function event_to_text ( $id, $date, $time, $duration,
47 $name, $description, $status,
48 $pri, $access, $event_owner ) {
49 global $login, $user, $event_template, $report_id, $allow_html_description;
51 $time_str = $start_time_str = $end_time_str = '';
53 if ( $duration == ( 24 * 60 ) ) {
54 $time_str = translate("All day event");
55 } else if ( $time == -1 ) {
56 $time_str = translate("Untimed event");
58 $time_str = display_time ( $time );
59 $start_time_str = $time_str;
60 $time_short = preg_replace ("/(:00)/", '', $time_str);
61 if ( $duration > 0 ) {
62 if ( $duration == ( 24 * 60 ) ) {
63 $time_str = translate("All day event");
66 $h = (int) ( $time / 10000 );
67 $m = ( $time / 100 ) % 100;
74 $end_time = sprintf ( "%02d%02d00", $h, $m );
75 $time_str .= " - " . display_time ( $end_time );
76 $end_time_str = display_time ( $end_time );
80 if ( $login != $user && $access == 'R' && strlen ( $user ) ) {
81 $name_str = "(" . translate("Private") . ")";
82 $description_str = translate("This event is confidential");
83 } else if ( $login != $event_owner && $access == 'R' &&
84 strlen ( $event_owner ) ) {
85 $name_str = "(" . translate("Private") . ")";
86 $description_str = translate("This event is confidential");
88 $name_str = htmlspecialchars ( $name );
89 if ( ! empty ( $allow_html_description ) &&
90 $allow_html_description == 'Y' ) {
91 $str = str_replace ( '&', '&', $description );
92 $description_str = str_replace ( '&', '&', $str );
93 if ( strstr ( $description_str, "<" ) &&
94 strstr ( $description_str, ">" ) ) {
97 // No HTML found. Add line breaks.
98 $description_str = nl2br ( $description_str );
101 $description_str = nl2br (
102 activate_urls ( htmlspecialchars ( $description ) ) );
106 $date_str = date_to_str ( $date, "", false );
107 $date_full_str = date_to_str ( $date, "", true, false );
109 if ( $duration > 0 ) {
110 $duration_str = $duration . ' ' . translate ( "minutes" );
116 $pri_str = translate ( "Low" );
117 } else if ( $pri == 2 ) {
118 $pri_str = translate ( "Medium" );
119 } else if ( $pri == 3 ) {
120 $pri_str = translate ( "High" );
123 if ( $status == 'W' ) {
124 $status_str = translate ( "Waiting for approval" );
125 } else if ( $status == 'D' ) {
126 $status_str = translate ( "Deleted" );
127 } else if ( $status == 'R' ) {
128 $status_str = translate ( "Rejected" );
129 } else if ( $status == 'A' ) {
130 $status_str = translate ( "Approved" );
132 $status_str = translate ( "Unknown" );
135 $href_str = "view_entry.php?id=$id";
137 // Replace all variables in the event template.
138 $text = $event_template;
139 $text = str_replace ( '${name}', $name_str, $text );
140 $text = str_replace ( '${description}', $description_str, $text );
141 $text = str_replace ( '${date}', $date_str, $text );
142 $text = str_replace ( '${dateYmd}', $date, $text );
143 $text = str_replace ( '${fulldate}', $date_full_str, $text );
144 $text = str_replace ( '${time}', $time_str, $text );
145 $text = str_replace ( '${starttime}', $start_time_str, $text );
146 $text = str_replace ( '${endtime}', $end_time_str, $text );
147 $text = str_replace ( '${duration}', $duration_str, $text );
148 $text = str_replace ( '${priority}', $pri_str, $text );
149 $text = str_replace ( '${href}', $href_str, $text );
150 $text = str_replace ( '${id}', $id, $text );
151 $text = str_replace ( '${user}', $event_owner, $text );
152 $text = str_replace ( '${report_id}', $report_id, $text );
158 $list = ""; // list of reports when no id specified
160 if ( ! empty ( $user ) && $user != $login &&
161 ( ( ! empty ( $allow_view_other ) && $allow_view_other == 'Y' )
163 $report_user = $user;
164 $u_url = "&user=$user";
169 if ( empty ( $reports_enabled ) || $reports_enabled != 'Y' ) {
170 $error = translate ( "You are not authorized" ) . ".";
173 $updating_public = false;
174 if ( $is_admin && ! empty ( $public ) && $public_access == "Y" ) {
175 $updating_public = true;
176 $report_user = "__public__";
179 $report_id = getIntValue ( "report_id", true );
180 $offset = getIntValue ( "offset", true );
181 if ( empty ( $offset ) ) {
185 // If no report id is specified, then generate a list of reports for
186 // the user to select from.
187 if ( empty ( $error ) && empty ( $report_id ) && $login == "__public__" ) {
188 $error = translate ( "You are not authorized" ) . ".";
190 if ( empty ( $error ) && empty ( $report_id ) ) {
193 if ( ! $updating_public ) {
194 $list .= "<p><a title=\"" .
195 translate("Click here") . " " .
196 translate("to manage reports for the Public Access calendar") . "." .
197 "\" href=\"report.php?public=1\">" .
198 translate("Click here") . " " .
199 translate("to manage reports for the Public Access calendar") . "." .
201 $sql = "SELECT cal_report_id, cal_report_name " .
202 "FROM webcal_report WHERE cal_login = '$login' OR " .
203 "cal_is_global = 'Y' ORDER BY cal_update_date DESC, cal_report_name";
205 $sql = "SELECT cal_report_id, cal_report_name " .
206 "FROM webcal_report WHERE cal_login = '__public__' " .
207 "ORDER BY cal_update_date DESC, cal_report_name";
210 $sql = "SELECT cal_report_id, cal_report_name " .
211 "FROM webcal_report WHERE cal_login = '$login' " .
212 "ORDER BY cal_update_date DESC, cal_report_name";
214 $res = dbi_query ( $sql );
217 while ( $row = dbi_fetch_row ( $res ) ){
218 $rep_name = trim ( $row[1] );
219 if ( empty ( $rep_name ) )
220 $rep_name = translate ( "Unnamed Report" );
221 $list .= "<li><a href=\"edit_report.php?report_id=$row[0]\" class=\"nav\">" .
222 $rep_name . "</a></li>\n";
225 $addurl = $updating_public ? "edit_report.php?public=1" : "edit_report.php";
226 $list .= "<p><a title=\"" .
227 translate("Add new report") . "\" href=\"$addurl\" class=\"nav\">" .
228 translate("Add new report") . "</a></p>\n";
229 dbi_free_result ( $res );
231 $error = translate ( "Invalid report id" );
235 // Load the specified report
236 if ( empty ( $error ) && empty ( $list ) ) {
237 $res = dbi_query ( "SELECT cal_login, cal_report_id, cal_is_global, " .
238 "cal_report_type, cal_include_header, cal_report_name, " .
239 "cal_time_range, cal_user, " .
240 "cal_allow_nav, cal_cat_id, cal_include_empty, cal_update_date " .
241 "FROM webcal_report WHERE cal_report_id = $report_id" );
243 if ( $row = dbi_fetch_row ( $res ) ) {
244 if ( $row[2] != 'Y' && $login != $row[0] ) {
245 $error = translate ( "You are not authorized" ) . ".";
248 $report_login = $row[$i++];
249 $report_id = $row[$i++];
250 $report_is_global = $row[$i++];
251 $report_type = $row[$i++];
252 $report_include_header = $row[$i++];
253 $report_name = $row[$i++];
254 $report_time_range = $row[$i++];
255 $test_report_user = $row[$i++];
256 // If this report type specifies a specific user, then we will
257 // use that user rather even if a user was passed in via URL.
258 if ( ! empty ( $test_report_user ) ) {
259 $report_user = $test_report_user;
261 $report_allow_nav = $row[$i++];
262 $report_cat_id = $row[$i++];
263 $report_include_empty = $row[$i++];
264 $report_update_date = $row[$i++];
267 $error = translate ( "Invalid report id" );
269 dbi_free_result ( $res );
271 $error = translate ( "Database error" ) . ": " . dbi_error ();
275 if ( empty ( $report_user ) ) {
276 $report_user = $login;
278 //echo "User: $report_user <p>";
280 // Set default templates (in case there are none in the database for
282 $page_template = '<dl>${days}</dl>';
283 $day_template = '<dt><b>${date}</b></dt><dd><dl>${events}</dl></dd>';
284 $event_template = '<dt>${name}</dt><dd>' .
285 '<b>' . translate ( "Date" ) . ':</b> ${date}<br />' .
286 '<b>' . translate ( "Time" ) . ':</b> ${time}<br />' .
287 '${description}</dd>';
289 // Load templates for this report.
290 if ( empty ( $error ) && empty ( $list ) ) {
291 $res = dbi_query ( "SELECT cal_template_type, cal_template_text " .
292 "FROM webcal_report_template " .
293 "WHERE cal_report_id = $report_id" );
295 while ( $row = dbi_fetch_row ( $res ) ) {
296 if ( $row[0] == 'P' ) {
297 $page_template = $row[1];
298 } else if ( $row[0] == 'D' ) {
299 $day_template = $row[1];
300 } else if ( $row[0] == 'E' ) {
301 $event_template = $row[1];
303 // This shouldn't happen under normal circumstances, so
304 // no need translate.
305 echo "Invalid template type: '$row[0]'";
309 dbi_free_result ( $res );
311 $error = translate ( "Database error" ) . ": " . dbi_error ();
315 if ( ! empty ( $report_include_header ) && $report_include_header == 'Y' ||
316 ! empty ( $list ) || ! empty ( $error ) ) {
320 if ( empty ( $offset ) || empty ( $report_allow_nav ) ||
321 $report_allow_nav != 'Y' ) {
325 // Set time range based on cal_time_range field.
326 if ( ! isset ( $report_time_range ) ) {
328 } else if ( $report_time_range >= 0 && $report_time_range < 10 ) {
329 $today = mktime ( 3, 0, 0, date ( "m" ), date ( "d" ), date ( "Y" ) );
330 $days_offset = 1 - $report_time_range + $offset;
331 $start_date = date ( "Ymd", $today + ( $days_offset * $ONE_DAY ) );
332 $end_date = $start_date;
333 } else if ( $report_time_range >= 10 && $report_time_range < 20 ) {
334 if ( $WEEK_START == 1 ) {
335 $wkstart = get_monday_before ( date ( "Y" ), date ( "m" ),
338 $wkstart = get_sunday_before ( date ( "Y" ), date ( "m" ),
341 //echo "wkstart = " . date("Ymd",$wkstart) . "<br />";
342 $week_offset = 11 - $report_time_range + $offset;
343 //echo "week_offset=$week_offset <br />";
344 $start_date = date ( "Ymd", $wkstart + ( $week_offset * 7 * $ONE_DAY ) );
345 $end_date = date ( "Ymd", $wkstart + ( $week_offset * 7 * $ONE_DAY ) +
347 } else if ( $report_time_range >= 20 && $report_time_range < 30 ) {
348 if ( $WEEK_START == 1 ) {
349 $wkstart = get_monday_before ( date ( "Y" ), date ( "m" ),
352 $wkstart = get_sunday_before ( date ( "Y" ), date ( "m" ),
355 //echo "wkstart = " . date("Ymd",$wkstart) . "<br />";
356 $week_offset = 21 - $report_time_range + $offset;
357 //echo "week_offset=$week_offset <br />";
358 $start_date = date ( "Ymd", $wkstart + ( $week_offset * 7 * $ONE_DAY ) );
359 $end_date = date ( "Ymd", $wkstart + ( $week_offset * 7 * $ONE_DAY ) +
361 } else if ( $report_time_range >= 30 && $report_time_range < 40 ) {
362 $thismonth = date ( "m" );
363 $month_offset = 31 - $report_time_range + $offset;
364 //echo "month_offset=$month_offset <br />";
365 $start_date = date ( "Ymd", mktime ( 3, 0, 0, $thismonth + $month_offset,
367 $end_date = date ( "Ymd", mktime ( 3, 0, 0, $thismonth + $month_offset + 1,
369 } else if ( $report_time_range >= 40 && $report_time_range < 50 ) {
370 $thisyear = date ( "Y" );
371 $year_offset = 41 - $report_time_range + $offset;
372 //echo "year_offset=$year_offset <br />";
373 $start_date = date ( "Ymd", mktime ( 3, 0, 0, 1, 1,
374 $thisyear + $year_offset ) );
375 $end_date = date ( "Ymd", mktime ( 3, 0, 0, 12, 31,
376 $thisyear + $year_offset ) );
377 } else if ( $report_time_range >= 50 && $report_time_range < 60 ) {
378 // This series of reports is today + N days
379 switch ( $report_time_range ) {
380 case 50: $x = 14; break;
381 case 51: $x = 30; break;
382 case 52: $x = 60; break;
383 case 53: $x = 90; break;
384 case 54: $x = 180; break;
385 case 55: $x = 365; break;
386 default: echo "Invalid cal_time_range setting for report id $report_id";
389 $today = mktime ( 0, 0, 0, date ( "m" ), date ( "d" ), date ( "Y" ) );
390 $start = $today + ( $ONE_DAY * $offset * $x );
391 $end = $start + ( $ONE_DAY * $x );
392 $start_date = date ( "Ymd", $start );
393 $end_date = date ( "Ymd", $end );
395 // Programmer's bug (no translation needed)
396 echo "Invalid cal_time_range setting for report id $report_id";
400 if ( empty ( $error ) && empty ( $list ) ) {
401 $cat_id = empty ( $report_cat_id ) ? "" : $report_cat_id;
403 $repeated_events = read_repeated_events ( $report_user, $cat_id, $start_date );
405 $events = read_events ( $report_user, $start_date, $end_date, $cat_id );
407 $get_unapproved = $DISPLAY_UNAPPROVED == 'Y';
408 if ( $report_user == "__public__" ) {
409 $get_unapproved = false;
412 //echo "User: $report_user <br />\n";
413 //echo "Date Range: $start_date - $end_date <br /><br />\n";
415 $start_year = substr ( $start_date, 0, 4 );
416 $start_month = substr ( $start_date, 4, 2 );
417 $start_day = substr ( $start_date, 6, 2 );
418 $start_time = mktime ( 3, 0, 0, $start_month, $start_day, $start_year );
420 $end_year = substr ( $end_date, 0, 4 );
421 $end_month = substr ( $end_date, 4, 2 );
422 $end_day = substr ( $end_date, 6, 2 );
423 $end_time = mktime ( 3, 0, 0, $end_month, $end_day, $end_year );
427 // Loop through each day
428 // Get events for each day (both normal and repeating).
429 // (Most of this code was copied from week.php)
430 for ( $cur_time = $start_time; $cur_time <= $end_time; $cur_time += $ONE_DAY ) {
432 $dateYmd = date ( "Ymd", $cur_time );
433 $rep = get_repeating_entries ( empty ( $user ) ? $login : $user, $dateYmd );
434 $ev = get_entries ( empty ( $user ) ? $login : $user, $dateYmd );
436 //echo "DATE: $dateYmd <br />\n";
438 for ( $i = 0; $i < count ( $ev ); $i++ ) {
439 // print out any repeating events that are before this one...
440 while ( $cur_rep < count ( $rep ) &&
441 $rep[$cur_rep]['cal_time'] < $ev[$i]['cal_time'] ) {
442 if ( $get_unapproved || $rep[$cur_rep]['cal_status'] == 'A' ) {
443 if ( ! empty ( $rep[$cur_rep]['cal_ext_for_id'] ) ) {
444 $viewid = $rep[$cur_rep]['cal_ext_for_id'];
445 $viewname = $rep[$cur_rep]['cal_name'] . " (" .
446 translate("cont.") . ")";
448 $viewid = $rep[$cur_rep]['cal_id'];
449 $viewname = $rep[$cur_rep]['cal_name'];
451 $event_str .= event_to_text ( $viewid,
452 $dateYmd, $rep[$cur_rep]['cal_time'], $rep[$cur_rep]['cal_duration'],
453 $viewname, $rep[$cur_rep]['cal_description'],
454 $rep[$cur_rep]['cal_status'], $rep[$cur_rep]['cal_priority'],
455 $rep[$cur_rep]['cal_access'], $rep[$cur_rep]['cal_login'] );
459 if ( $get_unapproved || $ev[$i]['cal_status'] == 'A' ) {
460 if ( ! empty ( $ev[$i]['cal_ext_for_id'] ) ) {
461 $viewid = $ev[$i]['cal_ext_for_id'];
462 $viewname = $ev[$i]['cal_name'] . " (" .
463 translate("cont.") . ")";
465 $viewid = $ev[$i]['cal_id'];
466 $viewname = $ev[$i]['cal_name'];
468 $event_str .= event_to_text ( $viewid,
469 $dateYmd, $ev[$i]['cal_time'], $ev[$i]['cal_duration'],
470 $viewname, $ev[$i]['cal_description'],
471 $ev[$i]['cal_status'], $ev[$i]['cal_priority'],
472 $ev[$i]['cal_access'], $ev[$i]['cal_login'] );
475 // print out any remaining repeating events
476 while ( $cur_rep < count ( $rep ) ) {
477 if ( $get_unapproved || $rep[$cur_rep]['cal_status'] == 'A' ) {
478 if ( ! empty ( $rep[$cur_rep]['cal_ext_for_id'] ) ) {
479 $viewid = $rep[$cur_rep]['cal_ext_for_id'];
480 $viewname = $rep[$cur_rep]['cal_name'] . " (" .
481 translate("cont.") . ")";
483 $viewid = $rep[$cur_rep]['cal_id'];
484 $viewname = $rep[$cur_rep]['cal_name'];
486 $event_str .= event_to_text ( $viewid,
487 $dateYmd, $rep[$cur_rep]['cal_time'], $rep[$cur_rep]['cal_duration'],
488 $viewname, $rep[$cur_rep]['cal_description'],
489 $rep[$cur_rep]['cal_status'], $rep[$cur_rep]['cal_priority'],
490 $rep[$cur_rep]['cal_access'], $rep[$cur_rep]['cal_login'] );
495 if ( ! empty ( $event_str ) || $report_include_empty == 'Y' ||
496 $report_time_range < 10 ) {
497 $date_str = date_to_str ( $dateYmd, "", false );
498 $date_full_str = date_to_str ( $dateYmd, "", true, false );
499 $text = str_replace ( '${events}', $event_str, $day_template );
500 $text = str_replace ( '${report_id}', $report_id, $text );
501 $text = str_replace ( '${fulldate}', $date_full_str, $text );
502 $day_str .= str_replace ( '${date}', $date_str, $text );
507 if ( ! empty ( $error ) ) {
508 echo "<h2>" . translate("Error") .
510 } else if ( ! empty ( $list ) ) {
512 if ( $updating_public ) {
513 echo translate($PUBLIC_ACCESS_FULLNAME) . " ";
515 echo translate("Manage Reports");
517 "<a title=\"" . translate("Admin") . "\" class=\"nav\" href=\"adminhome.php\"> " .
518 "« " . translate("Admin") . "</a><br /><br />\n" . $list;
520 if ( $report_include_header == 'Y' ) {
521 echo "<h2>" . $report_name . "</h2>\n";
523 $text = str_replace ( '${report_id}', $report_id, $page_template );
524 echo str_replace ( '${days}', $day_str, $text );
528 if ( empty ( $error ) && empty ( $list ) ) {
529 if ( ! empty ( $report_allow_nav ) && $report_allow_nav == 'Y' ) {
530 if ( empty ( $offset ) ) {
535 echo "<br /><br /><a title=\"" .
536 translate ( "Previous" ) . "\" href=\"report.php?report_id=$report_id$u_url" .
537 ( empty ( $prev ) ? "" : "&offset=$prev" ) . "\" class=\"nav\">" .
538 translate ( "Previous" ) . "</a>\n";
539 echo " <a title=\"" .
540 translate ( "Next" ) . "\" href=\"report.php?report_id=$report_id$u_url" .
541 ( empty ( $next ) ? "" : "&offset=$next" ) . "\" class=\"nav\">" .
542 translate ( "Next" ) . "</a><br />\n";
544 if ( $report_include_header == 'Y' ) {
545 echo '<br /><br /><a title="' . translate("Printer Friendly") .
546 '" class="nav" href="report.php?report_id=' . $report_id .
547 '&friendly=1' . $u_url . '&offset=' . $offset .
548 '" target="cal_printer_friendly" onmouseover="window.status=\'' .
549 translate("Generate printer-friendly version") .
550 '\'">[' . translate("Printer Friendly") . ']</a>';
554 if ( ! empty ( $list ) || $report_include_header == 'Y'
555 || ! empty ( $error ) || ! empty ( $list ) ) {
558 print_trailer ( false );