0)) { $filtstring = 'and ('; for ($i=1; $i <= 12; $i++) { $j = 1; // check bits 1 - 10 $j = $j << $i-1; if (($filt & $j) == $j) { $filtstring .= "(evtype & $j = $j) or "; } } // for } if ($filtstring <> '') $filtstring .= 'isnull(evtype))'; //tack on holidays } include('functions/dates.php'); require '../scripts/create_connection.php'; $dbc = create_dbc('selectonly', 'engl'); # source: http://firsttube.com/read/sorting-a-multi-dimensional-array-with-php/ # o needed for recurring events, dtlink advances but dtstart stays the same # o dtlink and *time* of dtstart must be compared for sorting function subval_sort($a,$subkey,$subkey2) { foreach($a as $k=>$v) { $b[$k] = strtolower($v[$subkey] . substr($v[$subkey2],10)); } asort($b); foreach($b as $key=>$val) { $c[] = $a[$key]; } return $c; } # adopt any filters filter form or filter cookie # process filter form (if this page called by it $calendar_name = 'English Dept.'; # rw from english.inc.php $day_lang = 'Day'; $week_lang = 'Week'; $month_lang = 'Month'; $year_lang = 'Year'; $calendar_lang = 'Calendar'; $next_day_lang = 'Next Day'; $next_month_lang = 'Next Month'; $next_week_lang = 'Next Week'; $next_year_lang = 'Next Year'; $last_day_lang = 'Previous Day'; $last_month_lang = 'Previous Month'; $last_week_lang = 'Previous Week'; $last_year_lang = 'Previous Year'; // $format_recur, items enclosed in % will be substituted with variables $format_recur_lang['delimiter'] = ', '; // ie, 'one, two, three' $format_recur_lang['yearly'] = array('year','years'); // for these, put singular $format_recur_lang['monthly'] = array('month','months'); // and plural forms $format_recur_lang['weekly'] = array('week','weeks'); // these will be %freq% $format_recur_lang['daily'] = array('day','days'); // in the replacement below $format_recur_lang['hourly'] = array('hour','hours'); $format_recur_lang['minutely'] = array('minute','minutes'); $format_recur_lang['secondly'] = array('second','seconds'); $format_recur_lang['start'] = 'Every %int% %freq% %for%'; // ie, 'Every 1 day until January 4' or 'Every 1 day for a count of 5' $format_recur_lang['until'] = 'until %date%'; // ie, 'until January 4' $format_recur_lang['count'] = 'for a count of %int%'; // ie, 'for 5 times' $format_recur_lang['bymonth'] = 'In months: %list%'; // ie, 'In months: January, February, March' $format_recur_lang['bymonthday'] = 'On dates: %list%'; // ie, 'On dates: 1, 2, 3, 4' $format_recur_lang['byday'] = 'On days: %list%'; // ie, 'On days: Mon, Tues, Wed, Thurs' $daysofweek_lang = array ('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday'); $daysofweekshort_lang = array ('Sun','Mon','Tue','Wed','Thu','Fri','Sat'); $daysofweekreallyshort_lang = array ('S','M','T','W','T','F','S'); $monthsofyear_lang = array ('January','February','March','April','May','June','July','August','September','October','November','December'); $monthsofyearshort_lang = array ('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'); // For time formatting, check out: http://www.php.net/manual/en/function.date.php $timeFormat = 'g:i A'; $timeFormat_small = 'g:i'; // For date formatting, see note below $dateFormat_day = '%A, %B %e'; $dateFormat_week = '%B %e'; $dateFormat_week_list = '%a, %b %e'; $dateFormat_week_jump = '%b %e'; $dateFormat_month = '%B %Y'; $dateFormat_month_list = '%A, %B %e'; # end of english.inc.php # rw from config.inc.php //$style_sheet = 'contrast'; // higher contrast scheme $style_sheet = 'gold'; // Themes support - silver, gold, contrast $language = 'English'; // Language support - 'English', 'Polish', 'German', 'French', 'Dutch', 'Danish', 'Italian', 'Japanese', 'Norwegian', 'Spanish', 'Swedish', 'Portuguese', 'Catalan', 'Traditional_Chinese', 'Esperanto' $week_start_day = 'Sunday'; // Day of the week your week starts on $day_start = '0800'; // Start time for day grid $day_end = '2000'; // End time for day grid $gridLength = '15'; // Grid distance in minutes for day view, multiples of 15 preferred $default_path = 'http://rob-home1/calendar'; // The HTTP URL to the PHP iCalendar directory, ie. http://www.example.com/phpicalendar $second_offset = '0'; // The time in seconds between your time and your server's time. # end of config.inc.php //if (isset($_POST['month'])) { // $getdate=$_POST['year'] . $_POST['month'] . '01'; // $pdate = $getdate; //} else { # rw taken from init.inc.php--the bulk of which is specific to ical setup if (isset($_GET['getdate'])) { // if (isset($HTTP_GET_VARS['getdate']) && ($HTTP_GET_VARS['getdate'] !== '')) { $getdate = $_GET['getdate']; } else { $getdate = date('Ymd', strtotime("now + $second_offset seconds")); } //} # rw preg_match is trying to extract yyyy mm dd from $getdate and store # the results in $day_array2[1], [2], and [3] (year, month, day, respectively) preg_match ("/^([0-9]{4})([0-9]{2})([0-9]{2})$/", $getdate, $day_array2); $this_day = $day_array2[3]; $this_month = $day_array2[2]; $this_year = $day_array2[1]; # rw $cur_year used to display list of years +/- 2 from current year in drop-down list # regardless of the requested year, reflected in getdate $cur_year = date('Y',strtotime("now + $second_offset seconds")); # rw find yyyymmdd dates for yesterday, today, and tomorrow # rw convert today as UNIX timestamp (measured in seconds from Jan 1 1970) $unix_time = strtotime($getdate); # rw yyyymmdd returned from UNIX timestamp for today, tomorrow, yesterday $today_today = date('Ymd', strtotime("now + $second_offset seconds")); $tomorrows_date = date( "Ymd", strtotime("+1 day", $unix_time)); $yesterdays_date = date( "Ymd", strtotime("-1 day", $unix_time)); // find out next month $next_month_month = ($this_month+1 == '13') ? '1' : ($this_month+1); $next_month_day = $this_day; $next_month_year = ($next_month_month == '1') ? ($this_year+1) : $this_year; # rw if today is bad next month (e.g.: 1/31, but no 2/31), seek backwards until good date # checkdate(mdy:int) returns true/false while (!checkdate($next_month_month,$next_month_day,$next_month_year)) $next_month_day--; # rw convert to UNIX timestamp (seconds) $next_month_time = mktime(0,0,0,$next_month_month,$next_month_day,$next_month_year); // find out last month $prev_month_month = ($this_month-1 == '0') ? '12' : ($this_month-1); $prev_month_day = $this_day; $prev_month_year = ($prev_month_month == '12') ? ($this_year-1) : $this_year; # rw check today in previous month, seek backwards for good date if needed while (!checkdate($prev_month_month,$prev_month_day,$prev_month_year)) $prev_month_day--; # rw mktime also returns UNIX timestamp $prev_month_time = mktime(0,0,0,$prev_month_month,$prev_month_day,$prev_month_year); $next_month = date("Ymd", $next_month_time); $prev_month = date("Ymd", $prev_month_time); $display_date = localizeDate ($dateFormat_month, $unix_time); # rw $parse_month used in calendar loop to know which dates to retrieve $parse_month = date ("Ym", $unix_time); # rw find the calendar date for the Sunday prior to (or equal to) the first 1st day of current month # if $show_weekend is false, find the prior Monday instead, # however, if the 1st falls on a Sat or Sun, must move date upward to Monday # eg: the week of 12/1/03 starts with Sunday, Nov 30, 2003 # so, dateOfWeek("20031201","sun") returns "20031130" $fstday = '01'; $first_of_month = $this_year.$this_month.$fstday; if ($show_weekend=='') { $week_start_day = 'Monday'; $s = date('D',strtotime($first_of_month)); if (substr($s,0,1) == 'S') { // checking for Sat or Sun $s == 'Sat' ? $fstday = '03' : $fstday = '02'; // bump date to Monday } } else { $week_start_day = 'Sunday'; } $first_of_month = $this_year.$this_month.$fstday; $start_month_day = dateOfWeek($first_of_month, $week_start_day); $thisday2 = localizeDate($dateFormat_week_list, $unix_time); $num_of_events2 = 0; define('HOME',substr( __FILE__,0,strpos(__FILE__,'engl')+4)); ?> <?php echo "$calendar_name - $display_date"; ?> "> "; } ?> 0 ? $last_cal_day = $next_month_year.$pad.$next_month_month.'0'.$i : $last_cal_day = $this_year.$this_month.$seek_day_num; # eventID, employID, evtype, evtitle, dtstart, dtend, evplace, evnotes $sql = "SELECT * from events WHERE date_format(dtstart,'%Y%m%d') >= '$start_month_day' and date_format(dtstart,'%Y%m%d') <= '$last_cal_day' $filtstring order by dtstart"; $result = $dbc->query($sql); [update] */ //echo $filtstring; /* # init $row to blank array //$row = # following converts dtstart and dtend to yyyymmdd if ($result->num_rows>0) { while ($row = $result->fetch_assoc()) { echo $row['dtstart'].' -> '; $row['dtstart'] = date('Ymd', strtotime($row['dtstart'])); echo $row['dtstart'].'
'; $row['dtend'] = date('Ymd', strtotime($row['dtend'])); } $result->data_seek(0); // reset $result internal pointer to 1st record } */ // $row = $result->fetch_assoc(); $evcnt = 0; if ($tbl_name==='events') { $other_cal_name = 'a11'; $other_cal_display = 'see A11 Reservations'; $cal_table_title = ''; } else { $other_cal_name = ''; $other_cal_display = 'see Other Meetings'; $cal_table_title = 'A11 Reservations'; } ?>
'') ? 'hide' : 'show'; $sw=($s=='show') ? '&weekend=1' : ''; echo "  $s weekend\n" . "$cal_table_title"; ?>
">
 
">
add event
'.$day.''; $start_day = strtotime("+1 day", $start_day); } ?> '; # rw $master_array uses yyyymmdd as keys for events # so a simple check for the key indicates events fall on this day /* # rw this first condition is necessary because an entire year is being read into $master_array elsewhere. if (isset($master_array[("$daylink")])) { */ # rw next 3 lines turn dates into active links to day.php file # (clumsy use of CSS, these fonts should be done by context, not coded in each table cell) echo "\n".'\n"; // close day $sunday = strtotime("+1 day", $sunday); $i++; # rw why not just make $i mod 7? rather than increment and check all the time? # rw I think code should be: # $i = ($i+1) % 7 // or $lstday; # if ($i == 0) { if ($i == $lstday) { echo "\n"; // end table row, start next week $i = 0; // handle weekend skip if (!$show_weekend) { // skip 2 days to next Monday $sunday = strtotime("+2 day", $sunday); // skip any weekend events in calendar -- get it back in synch with display loop if (!empty($ev[$evcnt]['dtlink'])) { $dtlink_utime = strtotime($ev[$evcnt]['dtlink']); while ($evcnt<($evmax-1) && $dtlink_utime < $sunday ) { $evcnt++; if (!empty($ev[$evcnt]['eventID'])) $dtlink_utime = strtotime($ev[$evcnt]['dtlink']); } // while } // if } // end weekend skip $checkagain = date ("m", $sunday); if ($checkagain != $this_month) $whole_month = FALSE; } } while ($whole_month == TRUE); ?>
'; echo '
'.$day.'
'."\n"; /* [update] # My SQL query should return only dates we need. # If we have any more dates, convert the next to unix timestamp if (!empty($row['dtstart'])) { $event_utime = strtotime($row['dtstart']); # compare yyyymmdd dates and loop through our events while they match while (date('Ymd',$event_utime)==$daylink) { # rw fix next lines // (!empty($row['dtend'])) ? $eend = date('g:ia',strtotime($row['dtend'])) : $eend=''; [update] */ # My SQL query should've returned only dates we need. # If we have any more dates, convert the next to unix timestamp if ($evcnt < $evmax) { $event_utime = strtotime($ev[$evcnt]['dtstart']); while ($evcnt < $evmax && $ev[$evcnt]['dtlink']==$daylink) { # rw fix next lines // (!empty($row['dtend'])) ? $eend = date('g:ia',strtotime($row['dtend'])) : $eend=''; $t = date('g:ia',$event_utime); if ($t == '12:00am') { // no time given explicitly if (empty($ev[$evcnt]['evnotes'])) { // no event note? echo '

'.stripslashes($ev[$evcnt]['evtitle']); if (!empty($ev[$evcnt]['evplace'])) echo ' - '.stripslashes($ev[$evcnt]['evplace']).'

'; } else { echo '

'; // echo ""; echo ""; echo ''.stripslashes($ev[$evcnt]['evtitle']); if (!empty($ev[$evcnt]['evplace'])) echo ' '.stripslashes($ev[$evcnt]['evplace']); echo "

\n"; } } else { echo '

'; // echo ""; echo ""; echo ''.substr($t,0,-1).' '; if (!empty($ev[$evcnt]['evplace'])) echo ''.stripslashes($ev[$evcnt]['evplace']).' • '; echo stripslashes($ev[$evcnt]['evtitle']).' '; echo "

\n"; } # get next event $evcnt++; if ($evcnt < $evmax) { $event_utime = strtotime($ev[$evcnt]['dtstart']); } else { $event_utime = 28800; // set to 19700101 } } // while } // if echo "

dategoeshere