Schedule

\n"; $_REQUEST['span'] = "f"; $_REQUEST['units'] = "d"; $_REQUEST['endTime'] = 1; } $_REQUEST['startDate'] = str_replace(array("/","\\"," ","-",".",":",","), "", $_REQUEST['startDate']); $y = substr($_REQUEST['startDate'], 0, 4); $m = substr($_REQUEST['startDate'], 4, 2); $d = substr($_REQUEST['startDate'], 6, 2); if ($_REQUEST['span'] == "f" and $_REQUEST['units'] == "d") { echo "\n"; $start = mktime( 0, 0, 0, $m, $d, $y); $end = mktime( 0, 0, 0, $m, ($d + $_REQUEST['endTime']), $y); } else { echo "\n"; $_REQUEST['startTime'] = substr("00".str_replace(array(":","/","\\","."," "),"", $_REQUEST['startTime']), -4); $h = substr($_REQUEST['startTime'], 0, 2); $i = substr($_REQUEST['startTime'], -2); $start = mktime( $h, $i, 0, $m, $d, $y); if ($_REQUEST['span'] == "u") { echo "\n"; $_REQUEST['endTime'] = substr("00".str_replace(array(":","/","\\","."," "),"", $_REQUEST['endTime']), -4); if ($_REQUEST['endTime'] <= $_REQUEST['startTime']) $d += 1; $h = substr($_REQUEST['endTime'], 0, 2); $i = substr($_REQUEST['endTime'], -2); } else if ($_REQUEST['units'] == "h") { echo "\n"; $i += intval($_REQUEST['endTime'] * 60); } else { echo "\n"; $i += intval($_REQUEST['endTime'] * 10); } $end = mktime( $h, $i, 0, $m, $d, $y); } // a color code of FFFFFF is "invisible" on the calendar // SEE http://www.w3schools.com/html/html_colornames.asp if ($_REQUEST['colour'] == "FFFFFF" or empty($_REQUEST['colour'])) $_REQUEST['colour'] = "#4053FF"; if (!empty($_REQUEST['empLst'])) { $emps = "|"; foreach ($_REQUEST['empLst'] as $emp) $emps .= "$emp|"; } else $emps = ""; $title = fixName($job['fName'], $job['lName'])." [{$job['oType']}"; if (!empty($job['protectron'])) $title .= " {$job['protectron']}"; $title .= "] ({$job['jobNo']})"; $q = "`editable` = '1', "; $q .= "`title` = '".str_replace("'", "´",$title)."', "; $q .= "`city` = '{$job['city']}', "; $q .= "`oType` = '{$job['oType']}', "; $q .= "`protectron` = '{$job['protectron']}', "; $q .= "`jobNo` = '{$job['jobNo']}', "; $q .= "`jobStart` = '$start', "; $q .= "`jobEnd` = '$end', "; $q .= "`color` = '#{$_REQUEST['colour']}', "; $q .= "`notes` = '".str_replace("'", "´",$job['assignment'])."', "; $q .= "`owner` = '', ";//".$_SESSION['user']['empNo']." $q .= "`empNo` = '$emps'"; $r = sqlRecycle("events", $q, "`title` = ''"); //echo "\n"; } else if (!empty($_REQUEST['eventLink'])) { $q = "select * from events where tid='{$_REQUEST['eventLink']}'"; echo "\n"; $event = mysql_query($q); $event = mysql_fetch_assoc($event); $event = decodeCalendarDat( $event ); // set event to recycle in table sqlUpdate("events", "title=''", "tid='{$_REQUEST['eventLink']}'"); } else { $event['startDate'] = date("Y-m-d"); $event['today'] = date("Y-m-d"); $event['color'] = "#FF0808"; } ?> \n"; echo "
\n"; echo " \n"; echo " \n";// border=1 echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
DateColor\n"; echo "
\n"; if (!empty($event['empNo'])) { $empList = explode("|", trim($event['empNo'],"|")); foreach ($empList as $empNo) { echo "".getEmployeeName( $empNo, "full")."
\n"; } } else $empList = array(); echo "
\n"; echo " 		"; $eList = sqlSelect("employees", "(access & 0x1000) and !(access & 0x0001)", "", "lName, fName"); echo " \n"; echo "
Time\n"; echo " \n"; echo " \n"; echo " \n"; echo "
\n"; echo "

\n"; echo "\n"; ?> \n"; while ($event = mysql_fetch_assoc($eventList['r'])) { $event = decodeCalendarDat( $event ); if ($event['today'] == $event['startDate']) $style = "color: blue;"; else $style = ""; if ($event['owner'] == $_SESSION['user']['empNo']) { echo " \n"; } else if ($event['jobNo']) { echo " \n"; } else echo "\n"; echo " \n"; echo " {$event['startDate']}\n"; echo " \n"; if ($event['days']) { echo " \n"; if ($event['days'] == 1) echo " (All Day)\n"; else echo " ({$event['days']} Days\n"; } else { echo " \n"; echo " {$event['startTime']}\n"; echo " \n"; echo " \n"; echo " {$event['endTime']}\n"; } echo " \n"; //echo " \n"; //echo " {$event['title']}\n"; //echo " \n"; //echo " \n"; //echo " {$event['notes']}\n"; //echo " \n"; $emps = ""; if (!empty($event['empNo'])) { $empList = explode("|", trim($event['empNo'],"|")); foreach ($empList as $empNo) { if (!empty($emps)) $emps .= ", "; $emps .= getEmployeeName( $empNo, "full"); } } echo " [$emps]\n"; echo " \n"; } echo " \n"; } ?>