'$start_search_date'"; $search_query .= " and startdate < '$e_search_date'"; mysql_select_db($dbbase,$db); $search_result = mysql_query($search_query,$db); $num_rows = @mysql_num_rows($search_result); if ($num_rows > 0) { print ""; } while ($data = mysql_fetch_array($search_result)) { print $data[title]."
"; } if ($num_rows > 0) { print ""; } // mysql_close($dbd); } function prnt_timeoff_calendar($user,$month,$year,$header) { // Set Current Month if none specified if (!$month) $month = (int)date("m"); if (!$year) $year = (int)date("Y"); // Calculate the previous month. $last_month = $month - 1; $last_year = $year; if (!checkdate($last_month, 1, $last_year)) { $last_month += 12; $last_year --; } // Get day of week of 1st of month $firstday = date("w",mktime(0,0,0,$month,1,$year)); // Find out what the previous month is $prev_info = date("m/Y",mktime(0,0,0,$month-1, 1, $year)); $exp_prev_info = explode("/",$prev_info); $prev_month = $exp_prev_info[0]; $prev_year = $exp_prev_info[1]; // Find out what the next month is $next_info = date("m/Y",mktime(0,0,0,$month+1, 1, $year)); $exp_next_info = explode("/",$next_info); $next_month = $exp_next_info[0]; $next_year = $exp_next_info[1]; ?>

"; print "

AROSNET REQUEST TIME OFF

\n "; $dayRow++; } } $i=0; $day = 1; $tot_sec = 0; $week_tot_sec = 0; $day_tot_sec = 0; while (checkdate($month, $day, $year)) { // Reset daily variables; $day_tot_sec = 0; $last_task_id = -1; // New Week. if (($dayRow % 7) == 0) { $week_tot_sec = 0; print "\n\n"; } // Print out date. print "\n"; $day++; $dayRow++; } // Print the rest of the calendar. while (($dayRow % 7) != 0) { print "\n "; $dayRow++; } print " Put a check in the days you are requesting time-off. Then choose The type of leave it is and click Submit. The request will be sent to your supervisor. previous next Sunday Monday Tuesday Wednesday Thursday Friday Saturday "; print $day." "; $complete_day = add_zero($day); print " "; print "   "; print "

"; print ""; print ""; print "
"; print "Leave Type: "; print " -- Select One -- "; print " Sick Time"; print " Vacation Time"; print ""; print "
"; print "Notes:
"; print ""; print "

"; print ""; print ""; print ""; } // end of function function prnt_vacation_calendar($month,$year,$header) { // Set Current Month if none specified if (!$month) $month = (int)date("m"); if (!$year) $year = (int)date("Y"); // Calculate the previous month. $last_month = $month - 1; $last_year = $year; if (!checkdate($last_month, 1, $last_year)) { $last_month += 12; $last_year --; } // Get day of week of 1st of month $firstday = date("w",mktime(0,0,0,$month,1,$year)); // Find out what the previous month is $prev_info = date("m/Y",mktime(0,0,0,$month-1, 1, $year)); $exp_prev_info = explode("/",$prev_info); $prev_month = $exp_prev_info[0]; $prev_year = $exp_prev_info[1]; // Find out what the next month is $next_info = date('m/Y',mktime(0,0,0,$month+1, 1, $year)); $exp_next_info = explode("/",$next_info); $next_month = $exp_next_info[0]; $next_year = $exp_next_info[1]; ?>  \n "; $dayRow++; } } $i=0; $day = 1; $tot_sec = 0; $week_tot_sec = 0; $day_tot_sec = 0; while (checkdate($month, $day, $year)) { // Reset daily variables; $day_tot_sec = 0; $last_task_id = -1; // New Week. if (($dayRow % 7) == 0) { $week_tot_sec = 0; print "\n\n"; } // Print out date. print "\n"; $day++; $dayRow++; } // Print the rest of the calendar. while (($dayRow % 7) != 0) { print "\n "; $dayRow++; } print "

previous					next
Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
"; print $day." "; $today_vacation = display_events(add_zero($month),add_zero($day),$year); print $today_vacation; print "

"; } // end of function ?>