"; if (count($job)) { echo "Order ".$job['jobNo']; foreach ($job as $k => $v) $_REQUEST[$k] = $v; } else echo "New Order"; echo " Details
\n"; if ($job['status'] == "CLOSED" or $job['status'] == "VOID") $da = " DISABLED"; else $da = ""; $_REQUEST['formDisable'] = $da; if (!empty($_REQUEST['delComment'])) { $r = sqlUpdate("logents", "eType='D'", "tid='{$_REQUEST['commentRef']}'"); echo "\n"; unset($_REQUEST['commentRef']); unset($_REQUEST['tagLine']); unset($_REQUEST['delComment']); } // later, there is an option to "correct" client data master copy - this should only be allowed if the current // client data currently matches the master record (otherwise, it is presumed that the client reference is to // a "bill to". to accomplish this, we need to know if there IS a match $isSameClient = 0; if (!empty($_REQUEST['cCode'])) { $isSameClient = 1; $clientdat = sqlSelect("clientdat", "cCode = '".$_REQUEST['cCode']."'"); $clientdat = mysql_fetch_assoc($clientdat['r']); if (is_array($clientdat)) { foreach ($clientdat as $k => $v) { //echo "[$k] -> $v; REQUEST[$k] -> {$_REQUEST[$k]} -->\n"; if ($k != "pc" and $k != "tid" and $k != "lastmod" and $k != "csid" and $_REQUEST[$k] != $v) { $isSameClient = 0; //echo "\n"; } else { //echo "\n"; } //$_REQUEST[$k] = $v; } } } if (!empty($_REQUEST['clientRef'])) { $isSameClient = 0; $clientdat = sqlSelect("clientdat", "tid = '".$_REQUEST['clientRef']."'"); $clientdat = mysql_fetch_assoc($clientdat['r']); foreach ($clientdat as $k => $v) $_REQUEST[$k] = $v; } // get a list of clients for quick selection // store these in an array so we can easily reuse them $clientList = sqlSelect("clientdat", "cCode != ''", "", "lName, fName"); while ($clientdat = mysql_fetch_assoc($clientList['r'])) $clientArray[$clientdat['cCode']] = $clientdat; unset($clientdat); unset($clientList); // get a list of all open order for later ... if (!empty($_REQUEST['jobNo'])) { $openOrders = sqlSelect("headers", "status!='CLOSED' and status!='VOID' and jobNo!='' and cCode!='' and jobNo!='{$_REQUEST['jobNo']}'","lName,fName"); while ($oo = mysql_fetch_assoc($openOrders['r'])) $openOrderList[] = $oo['tid']."|".$oo['jobNo']." - ".fixName($oo['fName'],$oo['lName']); unset($openOrders); unset($oo); } else $openOrderList = array(); if (empty($_REQUEST['jobRef']) and empty($_REQUEST['jobNo'])) { $_REQUEST['iniDate'] = date("Ymd"); echo "

\n"; if ($_SESSION['user']['empNo'] > 3) $_REQUEST['assignto'] = $_SESSION['user']['empNo']; else $_REQUEST['assignto'] = 0; } else $_REQUEST['iniDate'] = substr($_REQUEST['tid'], 0, 8); if (!empty($_REQUEST['formDisable']) and empty($_REQUEST['clientRef'])) $_REQUEST['formDisable'] = ""; if (!empty($_REQUEST['ePhone'])) { // get phone number for edit $p = sqlSelect("phones", "tid = '".$_REQUEST['ePhone']."'"); if ($p['n']) { $p = mysql_fetch_assoc($p['r']); $_REQUEST['pNumber'] = displayPhoneNumber($p['pNumber']); $_REQUEST['pLink'] = $p['tid']; $_REQUEST['pType'] = $p['pType']; sqlUpdate("phones", "cType='', pLink='', pNumber=''", "tid='".$p['tid']."'"); sqlInsert("logents", "eType = 's', linkRef = '".$_SESSION['jobRef']."', empNo = '".$_SESSION['user']['empNo']."', note = 'PHONE \"".displayPhoneNumber($p['pNumber'])."\" DELETED'"); } } unset($dVal); $dVal['protectron']['default'] = "Request Number"; $dVal['pwoNo']['default'] = "WO or Ref No"; $dVal['lName']['default'] = "Business or Last Name"; $dVal['fName']['default'] = "First Name"; $dVal['address']['default'] = "Address"; $dVal['city']['default'] = "City"; $dVal['prov']['default'] = ""; $dVal['pc']['default'] = "Post Cd"; $dVal['pNumber']['default'] = "Phone"; $dVal['tagLine']['default'] = "Job Tagline"; $dVal['ccu']['default'] = "CCU"; $dVal['csid']['default'] = "CSID"; $dVal['instCode']['default'] = "Inst"; $dVal['dlsCode']['default'] = "DLS "; $dVal['testTime']['default'] = "Test"; $dVal['receiver']['default'] = "Receiver"; echo " \n"; foreach ($dVal as $k => $v) { //echo "\n"; if (empty($_REQUEST[$k])) { $dVal[$k]['text'] = $v['default']; $dVal[$k]['style'] = " style=\"color: grey; font-style: italic;\" onfocus=\"fixStyles( this, '".$v['default']."', '' );\" onBlur=\"unfixFuzzyStyles( this, '".$v['default']."', '' );\""; $dVal[$k]['disable'] = ""; } else { $dVal[$k]['text'] = $_REQUEST[$k]; $dVal[$k]['style'] = " onfocus=\"fixStyles( this, '".$v['default']."', '' );\" onBlur=\"unfixFuzzyStyles( this, '".$v['default']."', '' );\""; $dVal[$k]['disable'] = ""; } } if ($dVal['csid']['text'] != $dVal['csid']['default']) { $rcvrList = mysql_query("SELECT * FROM `receivers` WHERE `account` != '' AND `receiver` != '' ORDER BY `account`"); while ($rcvr = mysql_fetch_assoc($rcvrList)) { $test = strpos($dVal['csid']['text'], $rcvr['account']); //echo "\n"; if ($test !== false and $test == 0) { $dVal['receiver']['text'] = displayPhoneNumber($rcvr['receiver']); $dVal['receiver']['style'] = " onfocus=\"fixStyles( this, '".$v['default']."', '' );\" onBlur=\"unfixFuzzyStyles( this, '".$v['default']."', '' );\""; } } } echo "\n"; echo "

\n"; echo " \n"; echo " \n"; echo ""; echo ""; echo ""; //<--------------- echo ""; echo "

\n"; echo " Date: \n"; if (empty($_REQUEST['jobNo'])) $_REQUEST['jobNo'] = nextJobNumber(); echo " \n"; echo " Job #: \n"; echo ""; 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"; //------------------------------------- // if ($_SESSION['user']['access'] & 0x0008) if (!empty($_REQUEST['cCode']) and !empty($_SESSION['jobRef']) and ($_SESSION['user']['access'] & 0x0080) )//$_SESSION['user']['empNo'] == 3) // restricted to ME at this time { echo " Bill To: \n"; //------------------------------------- echo " \n"; } else { echo " \n"; echo " \n"; } echo "

\n";// rowspan=2 selectorPhoneType($_REQUEST['pType'], $da); echo " \n"; // produce a linked list of associated phone numbers; link is "ePhone" echo "\n"; //echo " \n"; if ($_REQUEST['tid']) { $pList = sqlSelect("phones", "pLink = '".$_REQUEST['tid']."' and pNumber != ''"); if ($pList['n'] == 0) { echo "\n"; $pList = sqlSelect("phones", "pLink = '".$_REQUEST['oCode']."' and pNumber != ''", "pNumber"); } while ($phone = mysql_fetch_assoc($pList['r'])) { echo " \n"; echo " \n"; echo " \n"; } } echo "

Type	Number
".$phone['pType']."	".displayPhoneNumber($phone['pNumber'])."

\n"; echo "

\n"; echo " \n"; $items = 3; echo " \n"; echo " \n"; echo "

\n"; // if (empty($_REQUEST['assignto'])) $_REQUEST['assignto'] = $_SESSION['user']['empNo']; if ($_SESSION['user']['access'] & 0x0010) selectTech($_REQUEST['assignto'], "assignto", "Assign to", $da); else echo ""; if (!empty($_REQUEST['tid']) and $isSameClient and empty($da)) echo "Update Master Client Data\n"; echo "

"; if (empty($_REQUEST['tid'])) echo ""; else { $unreported = true; echo " \n"; echo " Status: \n"; //============================================================ if (!empty($_REQUEST['oCode']) and $da == "") { $baseDir = $_SESSION['instance']['repository']."FSP/".$_REQUEST['oCode']."/"; if (file_exists($baseDir)) { echo "Data: "; } else { $s = ""; if($_REQUEST['oType'] == "FSP" or $_REQUEST['oType'] == "PIP") $s = "&mkFSP=1"; if ($_REQUEST['lName'] == "Dollarama" or $_REQUEST['lName'] == "Reitmans") $s .= "&dollarama={$_REQUEST['fName']}"; echo "\n"; } if ($_REQUEST['oType'] == "FSP" or $_REQUEST['oType'] == "PIP") { $fspData = sqlSelect("clientdat", "cCode='{$_REQUEST['oCode']}'"); $fspData = mysql_fetch_assoc($fspData['r']); echo " Date "; } } //============================================================ } echo "

\n"; if ($job['status'] != "CLOSED" and $job['status'] != "VOID") { if ($job['status'] == "SCHED") echo "\n"; // echo "\n"; echo "\n"; echo "\n"; } echo " \n"; if (!empty($job['protectron']) and $job['status'] == "READY") { echo "\n"; } if ($job['status'] == "CLOSED" or $job['status'] == "VOID") { echo "\n"; } echo "

\n"; if (!empty($_REQUEST['tid']) and !empty($_SESSION['jobRef'])) { echo "

Current Work

"; if (!empty($_REQUEST['commentRef']) and empty($_REQUEST['newcomment'])) { $comment = sqlSelect("logents", "tid='".$_REQUEST['commentRef']."'"); $comment = mysql_fetch_assoc($comment['r']); $dVal['tagLine']['text'] = stripslashes($comment['tagLine']); $dVal['tagLine']['style'] = " onfocus=\"fixStyles( this, '".$dVal['tagLine']['default']."', '' );\" onBlur=\"unfixFuzzyStyles( this, '".$dVal['tagLine']['default']."', '' );\""; $dVal['tagLine']['disable'] = ""; $_REQUEST['commentRef'] = $comment['tid']; } else if (empty($_REQUEST['newcomment'])) { $comment = sqlSelect("logents", "linkRef='".$_SESSION['jobRef']."' and wDate='".date("Ymd")."' and empNo='".$_SESSION['user']['empNo']."' and eType != 's'", "", "lastmod desc"); if ($comment['n']) { $comment = mysql_fetch_assoc($comment['r']); $dVal['tagLine']['text'] = stripslashes($comment['tagLine']); $dVal['tagLine']['style'] = " onfocus=\"fixStyles( this, '".$dVal['tagLine']['default']."', '' );\" onBlur=\"unfixFuzzyStyles( this, '".$dVal['tagLine']['default']."', '' );\""; $dVal['tagLine']['disable'] = ""; $_REQUEST['commentRef'] = $comment['tid']; } else $comment = ""; } else $comment = ""; if ($_SESSION['user']['empNo'] == $comment['empNo']) $commentOwner = 1; else $commentOwner = 0; if ((!($_SESSION['user']['access'] & 0x0080) and $comment['locked']) and (!empty($comment['empNo']) and $commentOwner)) $disabled = " DISABLED"; else $disabled = ""; if (empty($comment['wDate'])) $comment['wDate'] = date("Ymd"); echo "\n"; echo "\n"; //-> // echo "\n"; // echo "\n"; echo "

\n"; echo "

\n"; echo ""; if ($_SESSION['user']['access'] & 0x0100 and empty($_REQUEST['commentRef'])) { echo " Private"; } else if (!empty($_REQUEST['commentRef']) and ($commentOwner or $_SESSION['user']['empNo'] < 4)) { echo " Delete"; } 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"; $commentList = sqlSelect("logents", "linkRef='".$job['tid']."' and eType!='s' and eType!='d' and (empNo='".$_SESSION['user']['empNo']."' or eType!='p')", "", "wDate desc, sortBy desc", "*, left(CONCAT(tStart, wStart, MID(tid, 8, 4)), 4) AS sortBy"); $row = 0; while ($comment = mysql_fetch_assoc($commentList['r'])) { if ($comment['eType'] == "p") $s = " color: blue;"; else $s = ""; echo "\n"; if ($_SESSION['user']['empNo'] == "3") { echo " \n"; } echo " \n"; echo " \n"; echo " \n"; echo ""; $row += 1; } while ($row < 10) { echo "\n"; $row += 1; } if ($_SESSION['user']['empNo'] == "3") { echo "

Date	By	Note

	".$comment['wDate']."	".getEmployeeName($comment['empNo'])."	".$comment['tagLine']."

\n"; echo "\n"; } echo "

\n"; //-> echo "

\n"; if ($disabled != " DISABLED") { echo "\n"; if ($_SESSION['user']['empNo'] < "4") echo "\n"; } if (!empty($_REQUEST['commentRef'])) echo "\n"; echo "\n"; echo "\n"; if ($_SESSION['user']['access'] & 0x0080) echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; //echo "\n"; echo "

\n"; echo "\n"; echo "

\n"; //echo "Address for Mapping: ".$dVal['address']['text'].", ".$dVal['city']['text'].""; echo "Address for Mapping: "; echo ""; if (!empty($_REQUEST['oCode'])) { $baseDir = $_SESSION['instance']['repository']."FSP/".$_REQUEST['oCode']."/"; if (file_exists($baseDir)) { echo " Data Directory: "; if ($protectronStr) echo " "; } } } ?>