"; echo "
"; echo "Appointment Summary - Date: ".$selDate; echo "
"; echo "
"; echo "X"; echo "
"; echo "

"; $ggAppt = mysql_query("SELECT * FROM `calendar_dept` WHERE `dept_code`='$deptCode' AND `appDate`='$selDate' ORDER BY `id` ASC"); while($row=mysql_fetch_array($ggAppt)){ echo "

".$row['agenda']."
Location: ".$row['location']."
Date: ".$row['appDate']." | Time: ".$row['time_a']." - ".$row['time_b']."

"; } echo "
"; echo ""; } echo "

MY CALENDAR

"; echo "
X
"; echo "
"; $monthNames = Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"); if (!isset($_REQUEST["month"])) $_REQUEST["month"] = date("n"); if (!isset($_REQUEST["year"])) $_REQUEST["year"] = date("Y"); $compID = $user_data['company_assignment']; $company = mysql_result(mysql_query("SELECT `company_name` FROM `company` WHERE `company_id`='$compID'"),0); //CALENDAR ADD/View if(isset($_GET['sub'])){ $getSub = $_GET['sub']; $appNewDate = $_GET['mons']."/".$_GET['days']."/".$_GET['years']; $appNewDate = str_pad(($appNewDate), 2, '0', STR_PAD_LEFT) ; //str_pad(($i-$startday + 1), 2, '0', STR_PAD_LEFT) switch($getSub){ case 'add': echo "
"; echo "
NEW APPOINTMENT - DEPARTMENT
"; echo "
X
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //newAppointment agenda location person apptTime apptDate echo ""; echo "
DATE:
START TIME:
Hour: 		END TIME:
Hour:
PERSON TO MEET:
LOCATION / AREA:
AGENDA / POINT OF DISCUSSION:
"; echo "
"; echo ""; echo "

". $systemMessage; echo "
"; echo "
"; break; } } $cMonth = $_REQUEST["month"]; $cYear = $_REQUEST["year"]; $prev_year = $cYear; $next_year = $cYear; $prev_month = $cMonth-1; $next_month = $cMonth+1; if ($prev_month == 0 ) { $prev_month = 12; $prev_year = $cYear - 1; } if ($next_month == 13 ) { $next_month = 1; $next_year = $cYear + 1; } if(isset($_POST['newAppointment'])){ //newAppointment agenda location person apptTime apptDate $apptTime = $_POST['apptTime']; $apptDate = $_POST['apptDate']; $apptEndTime = $_POST['apptEndTime']; //$AmPm = $_POST['AmPm']; $person = $_POST['person']; $location = $_POST['location']; $agenda = $_POST['agenda']; $agenda = mysql_real_escape_string($agenda); $location = mysql_real_escape_string($location); //$empID $sql="INSERT INTO `calendar_dept` (`id`,`appDate`,`time_a`,`time_b`,`emp_id`,`dept_code`,`agenda`,`person`,`location`,`time`,`date`) VALUES('','$apptDate','$apptTime','$apptEndTime', '$myEMPID','$deptCode','$agenda','$person','$location','$currentTime','$toDate')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "
X
Update Complete. Thank you!

"; } } ?>
DEPARTMENT CALENDAR " style="color:#FFFFFF"> ".$monthNames[$cMonth-1].' '.$cYear ."";?> " style="color:#FFFFFF">
"; if($i < $startday){ echo ""; }else { if($mycDay == ($i-$startday + 1)){ $bColor ='#E0F8F7'; $font='red'; }else { $bColor ='white'; $font='black'; } echo ""; } if(($i % 7) == 6 ) echo ""; } ?>
SUN MON TUE WED THU FRI SAT

".($i-$startday + 1)."

"; //echo $monthNames[$cMonth-1]. "/". $i . "/".$next_year; $curDay = str_pad(($prev_month+1), 2, '0', STR_PAD_LEFT)."/".str_pad(($i-$startday + 1), 2, '0', STR_PAD_LEFT)."/".$cYear; //$curDay=str_pad($curDay, 2, '0', STR_PAD_LEFT); //echo $curDay; $getDailyAPT = mysql_result(mysql_query("SELECT COUNT('id') FROM `calendar_dept` WHERE `appDate` ='$curDay' AND `dept_code`='$deptCode'"),0); $getDailyAPTC = mysql_result(mysql_query("SELECT COUNT('id') FROM `calendar_dept` WHERE `appDate` ='$curDay' AND `status`='2' AND `dept_code`='$deptCode'"),0); if($getDailyAPT > 0){ echo "
"; $getDeptSched = mysql_query("SELECT * FROM `calendar_dept` WHERE `dept_code`='$deptCode' AND `appDate`='$curDay'"); while($cRow = mysql_fetch_array($getDeptSched)){ $count++; echo "

".$count.") ".substr($cRow['agenda'],0,22)."...

"; } echo "
"; } echo "