\n"; $line = $words[$i]." "; } } $nRows += 2; echo "$line
\n"; return $nRows; } function printHeader($pageNo = 0) { GLOBAL $ident, $job, $clientdat, $tableWidth; debugDump($job, "job"); debugDump($clientdat, "ClientDat"); echo "\n"; // order information 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 " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; //echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "

"; if ($pageNo) echo "Page ".($pageNo + 1)." - "; echo $job['jobNo']."
Billing Information	Site Information	"; if ($job['csid']) echo "CID: ".$job['csid']; echo "
".fixName($clientdat['fName'], $clientdat['lName'])."	"; if (!$ident) echo fixName($job['fName'], $job['lName']); echo "	".fixName($job['fName'], $job['lName'])."	"; if (!empty($job['protectron'])) echo "Serv Req ".$job['protectron']; echo "
".$clientdat['address']."	"; if (!$ident) echo $job['address']; echo "	{$job['address']}	"; if (!empty($job['pwoNo'])) echo "Workorder "; if (!empty($job['pwoNo'])) echo $job['pwoNo']; echo "
".$clientdat['city'].", ".$clientdat['prov']." ".$clientdat['pc']."	"; if (!$ident) echo $job['city'].", ".$job['prov']." ".$job['pc']; echo "	{$job['city']}, {$job['prov']} {$job['pc']}	Status: {$job['status']}"; if ($job['status'] == 'CLOSED') { //$q = "select wDate from `logents` WHERE linkRef='{$job['tid']}' and note like '%to%CLOSED%' order by wDate desc limit 1"; //echo "\n"; $cDate = sqlSelect("logents", "linkRef='{$job['tid']}' and note like '%to%CLOSED%'", "", "wDate desc", "wDate"); $cDate = mysql_fetch_assoc($cDate['r']); echo " (".formatDate($cDate['wDate']).")"; } echo "

\n"; } include_once 'header.html'; ?> \n"; printHeader($pageNo); echo "
\n"; $nCnt = 0; $nHrs = 0; $nTvl = 0; $q = "linkRef='$jRef'"; if (!array_key_exists("audit", $_REQUEST)) $q .= " and eType = ''"; else $q .= " and eType != 'd' and (eType != 'p' or empNo='".$_SESSION['user']['empNo']."')"; $comments = sqlSelect("logents", $q, "", "wDate, sortBy", "*, left(CONCAT(tStart, wStart, MID(tid, 8, 4)), 4) AS sortBy"); while ($comment = mysql_fetch_assoc($comments['r'])) { if (!empty($comment['note'])) { $notes[$nCnt]['wDate'] = formatDate($comment['wDate']); $notes[$nCnt]['author'] = getEmployeeName($comment['empNo']); $notes[$nCnt]['note'] = str_replace(array("\n\n\n","\n\n"), "\n", $comment['note']); $notes[$nCnt]['eType'] = $comment['eType']; $nCnt += 1; } if ((!empty($comment['wStart']) and !empty($comment['wEnd'])) or (!empty($comment['tStart']) and !empty($comment['tEnd']))) { $labor[$nHrs]['wDate'] = formatDate($comment['wDate']); $labor[$nHrs]['author'] = getEmployeeName($comment['empNo']); $labor[$nHrs]['tStart'] = $comment['tStart']; $labor[$nHrs]['wStart'] = $comment['wStart']; $labor[$nHrs]['wEnd'] = $comment['wEnd']; $labor[$nHrs]['tEnd'] = $comment['tEnd']; $nHrs += 1; } if (($comment['kmStart'] * 1) and ($comment['kmEnd'] * 1)) { $travel[$nHrs]['wDate'] = formatDate($comment['wDate']); $travel[$nHrs]['author'] = getEmployeeName($comment['empNo']); $travel[$nHrs]['kmStart'] = $comment['kmStart']; $travel[$nHrs]['kmEnd'] = $comment['kmEnd']; $nTvl += 1; } } echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "

\n"; // output assignment here if (!empty($job['assignment'])) { $nRows += 2; echo "

Assignment Description

\n"; $lines = explode("\n", $job['assignment']); foreach ($lines as $line) $nRows += outLine($line); echo "
\n"; } echo "

Notes

\n"; if (count($notes)) { foreach ($notes as $note) { if ($note['eType'] == "s") { $span1 = ""; $span2 = ""; } else { $span1 = ""; $span2 = ""; } echo "$span1By ".$note['author']." on ".$note['wDate'].": "; echo "".str_replace("\n", "
\n", stripslashes($note['note']))."$span2
\n"; echo "
\n"; } } echo "

\n"; // labor echo "

Labor

\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"; if(count($labor)) { foreach ($labor as $lab) { $tvl = 0; $tTvl = 0; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; if (!empty($lab['tStart']) and !empty($lab['wStart'])) $tTvl = processTimeDif($lab['tStart'], $lab['wStart']); if (!empty($lab['wEnd']) and !empty($lab['tEnd'])) $tTvl += processTimeDif($lab['wEnd'], $lab['tEnd']); if (empty($lab['wStart']) and empty($lab['wEnd']) and !empty($lab['tStart']) and !empty($lab['tEnd'])) $tTvl += processTimeDif($lab['tStart'], $lab['tEnd']); $tLab = processTimeDif($lab['wStart'], $lab['wEnd']); $gtTvl += $tTvl; $gtLab += $tLab; echo " \n"; echo " \n"; echo " \n"; } } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; // echo "

Date	Tech	Tvl	Start	End	Tvl	Lab	Tvl
".$lab['wDate']."	".$lab['author']."	".$lab['tStart']."	".$lab['wStart']."	".$lab['wEnd']."	".$lab['tEnd']."	".sprintf("%01.2f", $tLab)."	".sprintf("%01.2f", $tTvl)."
Totals						".sprintf("%01.2f", $gtLab)."	".sprintf("%01.2f", $gtTvl)."

\n"; if(count($travel)) { echo "

Travel

\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $tTvl = 0; foreach ($travel as $tvl) { $t = $tvl['kmEnd'] - $tvl['kmStart']; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $tTvl += $t; } echo "

Date	Tech	Start	End	Total
".$tvl['wDate']."	".$tvl['author']."	".$tvl['kmStart']."	".$tvl['kmEnd']."	".sprintf("%01.2f", $t)."

\n"; } // echo "

Parts

\n"; echo "

\n"; // ***************************** Zone List ***************************** $zoneList = sqlSelect("zones", "linkRef='$jRef'", "", "zoneNo"); $locs = sqlSelect("locations", "linkref='$jRef'"); if ($zoneList['n'] or $locs['n']) { if ($zoneList < 20) $limit = $zoneList['n']; else $limit = ($zoneList['n'] + 1) / 2; $pageNo++; if (array_key_exists("noprint", $_REQUEST)) { echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo "

"; echo "PAGE ".($pageNo + 1); echo "

\n"; } echo "
\n"; printHeader($pageNo); echo "
\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($zone = mysql_fetch_assoc($zoneList['r'])) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo "

Num	Par	Device	Type	Loop	Description
".$zone['zoneNo']."	".$zone['zonePart']."	".$zone['zoneDevice']."	".$zone['zoneType']."	".$zone['zoneEOL']."	".$zone['zoneName']."

\n"; if ($zoneList['n'] and $locs['n']) echo "

\n"; while ($l = mysql_fetch_assoc($locs['r'])) { echo " {$l['ilocation']}
\n"; } } // ***************************** Parts List ***************************** //$partsList = sqlSelect("inventory", "workorder='$jRef' and sof='INS'", "item,iloc,sn", "item,iloc,sn"); //if ($partsList['n']) //{ // $pageNo++; // // if (array_key_exists("noprint", $_REQUEST)) // { // echo "\n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo "

"; // echo "PAGE ".($pageNo + 1); // echo "

\n"; // } // echo "
\n"; // // printHeader($pageNo); // // echo "
\n"; // // echo "

Installed Parts

\n"; // // echo "\n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo "\n"; // // while ($parts = mysql_fetch_assoc($partsList['r'])) // { $pDat = getProductInfo($parts['item']); // $itemCnt = sqlSelect("inventory", "workorder='$jRef' and sn='{$parts['sn']}' and item='{$parts['item']}' and iloc='{$parts['iloc']}' and sof='INS'"); // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // } // echo "

Qty	Vend	Item	Description	Serial	Location
{$itemCnt['n']}	{$pDat['vend']}	{$pDat['vsn']}	{$pDat['description']}	{$parts['sn']}	{$parts['iloc']}

\n"; //} // //$partsList = sqlSelect("inventory", "workorder='$jRef' and sof=''", "item,iloc,sn", "item,iloc,sn"); //if ($partsList['n']) //{ echo "

Pending or Backordered Parts

\n"; // // echo "\n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo "\n"; // // while ($parts = mysql_fetch_assoc($partsList['r'])) // { $pDat = getProductInfo($parts['item']); // $itemCnt = sqlSelect("inventory", "workorder='$jRef' and sn='{$parts['sn']}' and item='{$parts['item']}' and iloc='{$parts['iloc']}' and sof=''"); // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // } // echo "

Qty	Vend	Item	Description	Serial	Location
{$itemCnt['n']}	{$pDat['vend']}	{$pDat['vsn']}	{$pDat['description']}	{$parts['sn']}	{$parts['iloc']}

\n"; //} $partsList = sqlSelect("inventory", "workorder='$jRef' and status='INS'", "item,iloc,sn", "item,iloc,sn"); $partsList2 = sqlSelect("inventory", "workorder='$jRef' and status=''", "item,iloc,sn", "item,iloc,sn"); if ($partsList['n'] or $partsList2['n']) { $pageNo++; if (array_key_exists("noprint", $_REQUEST)) { echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo "

"; echo "PAGE ".($pageNo + 1); echo "

\n"; } echo "
\n"; printHeader($pageNo); echo "
\n"; if ($partsList['n']) { echo "

Installed Parts

\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "\n"; while ($parts = mysql_fetch_assoc($partsList['r'])) { $pDat = getProductInfo($parts['item']); $itemCnt = sqlSelect("inventory", "workorder='$jRef' and sn='{$parts['sn']}' and item='{$parts['item']}' and iloc='{$parts['iloc']}' and status='INS'"); debugDump($pDat, "pDat"); echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo "

Qty	Vend	Item	Owner	Description	Serial	Location	Date
{$itemCnt['n']}	{$pDat['vend']}	{$pDat['vsn']}	".strtoupper($parts['owner'])."	{$pDat['description']}	{$parts['sn']}	{$parts['iloc']}	".formatDate(substr($parts['lastmod'],0,8))."

\n"; } $lCnt = 0; //$partsList = sqlSelect("inventory", "workorder='$jRef' and status=''", "item,iloc,sn", "item,iloc,sn"); if ($partsList2['n']) { echo "

Pending Parts

\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($parts = mysql_fetch_assoc($partsList2['r'])) { $pDat = getProductInfo($parts['item']); $itemCnt = sqlSelect("inventory", "workorder='$jRef' and sn='{$parts['sn']}' and item='{$parts['item']}' and iloc='{$parts['iloc']}' and sof=''"); debugDump($pDat, "pDat"); echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $lCnt += 1; } echo "

Qty	Vend	Item	Owner	Description	Serial	Location
{$itemCnt['n']}	{$pDat['vend']}	{$pDat['vsn']}	".strtoupper($parts['owner'])."	{$pDat['description']}	{$parts['sn']}	{$parts['iloc']}

\n"; } } ?>