\n"; echo " \n"; echo "Recient Activity (0)\n"; echo " \n"; echo " Order\n"; echo " Name\n"; echo " Type\n"; echo " Lead\n"; echo " Status\n"; echo " Last Active\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "  \n"; echo " \n"; echo " \n";// overflow-x: hidden; if (count($jobs)) { foreach($jobs as $job) { if ($l) $l .= " or "; $l .= "jobNo = '$job'"; } $orderList = sqlSelect("headers", $l, "", "lName,fName,lastmod"); echo "\n"; while ($order = mysql_fetch_assoc($orderList['r'])) { // get the info for this reference if ((array_key_exists("showAll", $_REQUEST) and !empty($_REQUEST['showAll'])) or ($order['status'] != "CLOSED" and $order['status'] != "VOID")) { $orderRef = sqlSelect("logents", "linkRef='".$order['tid']."' and eType= 's' and (eType!= 'p' or empNo='".$_SESSION['user']['empNo']."')", "", "lastmod desc"); //echo "\n"; if ($orderRef) { $orderRef = mysql_fetch_assoc($orderRef['r']); $lastChange = substr($orderRef['lastmod'], 0, 4).".".substr($orderRef['lastmod'], 4, 2).".".substr($orderRef['lastmod'], 6, 2); } else $lastChange = "-none-"; if (empty($order['fName'])) $name = $order['lName']; else $name = $order['lName'].", ".$order['fName']; if (!empty($order['protectron'])) $name .= " [{$order['protectron']}]"; if (empty($order['assignto'])) $lead = "unassigned"; else $lead = getEmployeeName($order['assignto']); // $needsParts = sqlSelect("inventory", "iloc='' and workorder='{$order['tid']}' and sof=''"); // echo "\n"; // if ($needsParts['n']) // $npStatus = " color: #900;"; // else // { $needsParts = sqlSelect("inventory", "iloc!='' and workorder='{$order['tid']}' and status='' and sof=''"); // if ($needsParts['n']) // $npStatus = " color: #366;"; // else // $npStatus = ""; // } echo " \n"; echo " ".$order['jobNo']."\n"; echo " $name\n"; echo " ".$order['oType']."\n"; echo " $lead\n"; echo " "; if ($order['oType'] != "Notes") echo $order['status']; echo "\n"; echo " $lastChange\n"; echo " \n"; $rows += 1; } } } // while ($rows < 26) // { echo "  \n"; // $rows += 1; // } echo " \n"; echo "\n"; echo " \n"; ?>