// get user dat //-- $q = "select fname, lname from employees where emp_no='".$_REQUEST['emp_no']."'"; $r = sqlSelect("employees", "empNo = '".$_REQUEST['empNo']."'","","", "fname, lname"); // $r = sql("dailyCalendar: getUserDat", $q, true, true); $r = mysql_fetch_assoc($r['r']); if (empty($_REQUEST['d'])) $_REQUEST['d'] = date("Ymd"); $d = displayDate($_REQUEST['d']); echo "".$r['fname']." ".$r['lname']."\n"; $colorPntr = 0; $colorList = array("#00F", "#0FF"); ?> '$pDateTimeIn' and empNo='".$_REQUEST['empNo']."' and eType = ''", "", "wStart, tStart"); if ($r['n']) { // there is one or more travel events while ($l = mysql_fetch_assoc($r['r'])) { $hDat = sqlSelect("headers", "tid = '".$l['linkRef']."'"); $hDat = mysql_fetch_assoc($hDat['r']); $nIdx = count($event); $event[$nIdx]['tid'] = $hDat['tid']; $event[$nIdx]['fName'] = $hDat['fName']; $event[$nIdx]['lName'] = $hDat['lName']; $event[$nIdx]['schEdit'] = $l['tid']; $event[$nIdx]['start'] = $l['tStart']; $event[$nIdx]['end'] = $l['wStart']; $event[$nIdx]['eType'] = "Tvl to "; echo "\n"; } } //debug(2); $r = sqlSelect("logents", "wDate = '".$_REQUEST['d']."' and wStart != '' and wStart <= '".substr("0".$i,-2)."99' and wEnd != '' and wEnd > '$pDateTimeIn' and empNo='".$_REQUEST['empNo']."' and eType = ''", "", "wStart, tStart"); debugDump($r, "R"); if ($r['n']) { // there is one or more labor event while ($l = mysql_fetch_assoc($r['r'])) { $hDat = sqlSelect("headers", "tid = '".$l['linkRef']."'"); //debugDump($hDat, "hDat"); $hDat = mysql_fetch_assoc($hDat['r']); $nIdx = count($event); $event[$nIdx]['tid'] = $hDat['tid']; $event[$nIdx]['fName'] = $hDat['fName']; $event[$nIdx]['lName'] = $hDat['lName']; $event[$nIdx]['schEdit'] = $l['tid']; $event[$nIdx]['start'] = $l['wStart']; $event[$nIdx]['end'] = $l['wEnd']; $event[$nIdx]['eType'] = "Work at "; echo "\n"; } } $r = sqlSelect("logents", "wDate = '".$_REQUEST['d']."' and tEnd != '' and wEnd <= '".substr("0".$i,-2)."99' and tEnd > '$pDateTimeIn' and empNo='".$_REQUEST['empNo']."' and eType = ''", "", "wStart, tStart"); if ($r['n']) { // there is one or more travel events while ($l = mysql_fetch_assoc($r['r'])) { $hDat = sqlSelect("headers", "tid = '".$l['linkRef']."'"); $hDat = mysql_fetch_assoc($hDat['r']); $nIdx = count($event); $event[$nIdx]['tid'] = $hDat['tid']; $event[$nIdx]['fName'] = $hDat['fName']; $event[$nIdx]['lName'] = $hDat['lName']; $event[$nIdx]['schEdit'] = $l['tid']; $event[$nIdx]['start'] = $l['wEnd']; $event[$nIdx]['end'] = $l['tEnd']; $event[$nIdx]['eType'] = "Tvl fm "; echo "\n"; } } //-- end frist group --// //-- the schedules group looks for scheduled events instead of actual labor --// $r = sqlSelect("schedule", "wDate = '".$_REQUEST['d']."' and tStart != '' and tStart <= '".substr("0".$i,-2)."99' and wStart > '$pDateTimeIn' and empNo='".$_REQUEST['empNo']."'", "", "wStart, tStart"); if ($r['n']) { // there is one or more travel events while ($l = mysql_fetch_assoc($r['r'])) { $hDat = sqlSelect("headers", "tid = '".$l['linkRef']."'"); $hDat = mysql_fetch_assoc($hDat['r']); $nIdx = count($event); $event[$nIdx]['tid'] = $hDat['tid']; $event[$nIdx]['fName'] = $hDat['fName']; $event[$nIdx]['lName'] = $hDat['lName']; $event[$nIdx]['schEdit'] = $l['tid']; $event[$nIdx]['start'] = $l['tStart']; $event[$nIdx]['end'] = $l['wStart']; $event[$nIdx]['eType'] = "SchTvl "; echo "\n"; } } $r = sqlSelect("schedule", "wDate = '".$_REQUEST['d']."' and wStart <= '".substr("0".$i,-2)."99' and wEnd > '$pDateTimeIn' and empNo='".$_REQUEST['empNo']."'", "", "wStart, tStart"); if ($r['n']) { // there is one or more labor event while ($l = mysql_fetch_assoc($r['r'])) { $hDat = sqlSelect("headers", "tid = '".$l['linkRef']."'"); $hDat = mysql_fetch_assoc($hDat['r']); $nIdx = count($event); $event[$nIdx]['tid'] = $hDat['tid']; $event[$nIdx]['fName'] = $hDat['fName']; $event[$nIdx]['lName'] = $hDat['lName']; $event[$nIdx]['schEdit'] = $l['tid']; $event[$nIdx]['start'] = $l['wStart']; $event[$nIdx]['end'] = $l['wEnd']; $event[$nIdx]['role'] = $l['role']; $event[$nIdx]['eType'] = "SchWrk "; echo "\n"; } } $r = sqlSelect("schedule", "wDate = '".$_REQUEST['d']."' and tEnd != '' and wEnd <= '".substr("0".$i,-2)."99' and tEnd > '$pDateTimeIn' and empNo='".$_REQUEST['empNo']."'", "", "wStart, tStart"); if ($r['n']) { // there is one or more travel events while ($l = mysql_fetch_assoc($r['r'])) { $hDat = sqlSelect("headers", "tid = '".$l['linkRef']."'"); $hDat = mysql_fetch_assoc($hDat['r']); $nIdx = count($event); $event[$nIdx]['tid'] = $hDat['tid']; $event[$nIdx]['fName'] = $hDat['fName']; $event[$nIdx]['lName'] = $hDat['lName']; $event[$nIdx]['schEdit'] = $l['tid']; $event[$nIdx]['start'] = $l['wEnd']; $event[$nIdx]['end'] = $l['tEnd']; $event[$nIdx]['eType'] = "SchTvl "; echo "\n"; } } //-- end schedules group --// // if (empty($event)) // { // no travel or labor found // $event[$nIdx]['eType'] = "--"; // } echo " \n \n \n"; echo " \n"; $event = ""; $i++; } echo "

Time

Activity

$time

"; // $colorPntr = 0; // $colorList = array("red", "blue"); if (empty($event)) echo "   \n"; else { $didNotBr = true; $tEnt = 0; $nResults = count($event); while ($tEnt < $nResults) { if (array_key_exists("link", $_REQUEST)) { //$click = "parent.location.href='../../../?p=orders&sjobNo=".$hDat['jobNo']."';"; $click = "parent.location.href='../../../?p=orders&jobRef=".$hDat['tid']."';"; } else $click = "parent.location.href='../../?schEdit=".$event[$tEnt]['schEdit']."';"; if ($event[$tEnt]['tid'] != $lastEvent or $lastEntType != $event[$tEnt]['eType']) { //if ($tEnt) echo " \n"; $time_in = displayDate($_REQUEST['d'].$event[$tEnt]['start']); $time_out = displayDate($_REQUEST['d'].$event[$tEnt]['end']); echo "".$event[$tEnt]['eType']; if (!empty($event[$tEnt]['fName'])) echo $event[$tEnt]['fName']." "; echo $event[$tEnt]['lName']; echo " (".$time_in['t']; if ($time_in['t'] != $time_out['t']) echo " - ".$time_out['t']; echo ")"; if (!empty($event[$tEnt]['role'])) echo " ".$event[$tEnt]['role']; echo ""; $lastEvent = $event[$tEnt]['tid']; $lastEntType = $event[$tEnt]['eType']; $tEnt += 1; if ($tEnt < $nResults) { echo " \n"; $didNotBr = false; } } else $tEnt += 1; } if ($didNotBr) echo "   \n"; } echo "

\n"; ?>