\n"; $period = calcDates();//

onChange=\"this.form.submit();\" echo "
\n";// echo " Current Period\n"; for ($i = 0; $i < 13; $i++) { $period = calcDates($period['pEnd']); echo " ".formatDate($period['cStart'])." - ".formatDate($period['cEnd']); } echo "\n";//

$period = calcDates($_REQUEST['period']); // the following query used to group by jobNo. Changed to cCode 2012.03.08 $tsList = sqlSelect("logents, headers", "logents.linkRef=headers.tid and wDate > '".$period['pEnd']."' and wDate < '".$period['cEndFlag']."' and eType=''", "cCode", "lName, fName"); echo "

\n"; echo " All Jobs\n"; while ($tsEmp = mysql_fetch_assoc($tsList['r'])) { // the name "of record" and the billing name represented by the cCode may be // quite different; All records should use the cCode name, not the name of record $billTo = sqlSelect("clientdat", "cCode = '".$tsEmp['cCode']."'"); $billTo = mysql_fetch_assoc($billTo['r']); $cName = $billTo['lName']; if (!empty($billTo['fName'])) $cName .= ", ".$billTo['fName']; echo " ".substr($cName, 0, 30)."\n"; } echo "

\n"; selectTech($_REQUEST['techNo'], "techNo", "All Techs", " onChange=\"updateDisplay('');\""); echo "

\n"; echo "Sort by Date\n"; echo "Sort by Job\n"; echo "\n"; echo "

\n"; echo "\n"; echo "\n"; echo "\n"; ?>