\n"; echo " th, td\n"; echo " { font-size: 10pt;\n"; echo " padding-right: 1em;\n"; echo " }\n"; echo "\n"; include_once '../comFunctions.php'; include_once '../sql.php'; echo "\n"; if (empty($_REQUEST['period'])) $period = calcDates(); else $period = calcDates($_REQUEST['period']); // Job Times $q = "logents.linkRef=headers.tid and wDate > '".$period['pEnd']."' and wDate < '".$period['cEndFlag']."' and eType='' and linkRef != ''"; if (!empty($_REQUEST['cCode'])) $q .= " and cCode='".$_REQUEST['cCode']."'"; if (!empty($_REQUEST['techNo'])) $q .= " and empNo='".$_REQUEST['techNo']."'"; if ($_REQUEST['sortby'] == "job") $sort = "lName, fName, wDate, wStart, wEnd"; else $sort = "wDate, wStart, wEnd, lName, fName"; $r = sqlSelect("logents, headers", $q, "cCode", $sort, "*", false); if ($r['n']) { while ($job = mysql_fetch_assoc($r['r'])) { $_SESSION['testData'] = $job; if ($_REQUEST['sortby'] != "job" or $job['cCode'] != $last_cCode) { $billTo = sqlSelect("clientdat", "cCode = '{$job['cCode']}'"); $billTo = mysql_fetch_assoc($billTo['r']); echo "".$billTo['lName']; if (!empty($billTo['fName'])) echo ", ".$billTo['fName']; echo "
\n"; $gtl = 0; $gtt = 0; $lastJobNo = ""; $lastTech = ""; $lastwDate = ""; echo "\n"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; echo "\n"; $last_cCode = $job['cCode']; } $q2 = "logents.linkRef=headers.tid and wDate > '".$period['pEnd']."' and wDate < '".$period['cEndFlag']."' and eType='' and cCode='".$job['cCode']."'"; if (!empty($_REQUEST['techNo'])) $q2 .=" and empNo='".$_REQUEST['techNo']."'"; $leadList = sqlSelect("logents, headers", $q2, "", "wDate"); while ($l = mysql_fetch_assoc($leadList['r'])) { $tTip = $l['lName']; if (!empty($l['fName'])) $tTip .= ", ".$l['fName']; echo ""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $tvl = 0; if (!empty($l['tStart'])) $tvl = (((substr($l['wStart'],0,2) * 60) + substr($l['wStart'],-2)) - ((substr($l['tStart'],0,2) * 60) + substr($l['tStart'],-2))); if (!empty($l['tEnd'])) $tvl += (((substr($l['tEnd'],0,2) * 60) + substr($l['tEnd'],-2)) - ((substr($l['wEnd'],0,2) * 60) + substr($l['wEnd'],-2))); $lab = ((substr($l['wEnd'],0,2) * 60) + substr($l['wEnd'],-2)) - ((substr($l['wStart'],0,2) * 60) + substr($l['wStart'],-2)); echo "\n"; echo "\n"; $gtl += $lab; $gtt += $tvl; // if ($l['kmStart'] != "0.0") // { echo "\n"; // } echo "\n"; } echo ""; echo ""; echo ""; echo "\n"; echo "

JobNo	Protectron	Tech	Date	Trav Start	Lab Start	Lab End	Trav End	Tvl Ttl	Lab Ttl	km
"; if ($lastJobNo != $l['jobNo']) { echo $l['jobNo']; $lastJobNo = $l['jobNo']; $lastTech = ""; $lastwDate = ""; } //debugDump($l, "L"); echo "	"; echo $l['protectron']; echo "	"; if ($lastTech != $l['empNo']) { echo getEmployeeName($l['empNo'], "full"); $lastTech = $l['empNo']; $lastwDate = ""; } echo "	"; if ($lastwDate != $l['wDate']) { echo formatDate($l['wDate']); $lastwDate = $l['wDate']; } echo "	"; if ($l['tStart']) echo substr($l['tStart'],0,2).":".substr($l['tStart'],-2); echo "	"; if ($l['wStart']) echo substr($l['wStart'],0,2).":".substr($l['wStart'],-2); echo "	"; if ($l['wEnd']) echo substr($l['wEnd'],0,2).":".substr($l['wEnd'],-2); echo "	"; if ($l['tEnd']) echo substr($l['tEnd'],0,2).":".substr($l['tEnd'],-2); echo "	".sprintf("%01.2f",$tvl / 60)."	".sprintf("%01.2f",$lab / 60)."	"; // if ($l['kmEnd'] == "0.0") echo $l['kmStart']; // else echo sprintf("%01.2f", ($l['kmEnd'] - $l['kmStart'])); // "
Total Time								".sprintf("%01.2f",$gtt / 60)."	".sprintf("%01.2f",$gtl / 60)."

\n"; } } else { echo "No criteria matches found"; } ?>