\n"; ?> \n"; $r = mysql_query($q); $r = mysql_fetch_assoc($r); $fsr = $r['cnt']; } else $fsr = 0; //$q = "select count(*) as cnt from headers where protectron != '' and status != 'CLOSED' and status != 'VOID'"; $q = "select count(*) as cnt from headers where cCode = '03500001C' and status != 'CLOSED' and status != 'VOID'"; $r = mysql_query($q); $r = mysql_fetch_assoc($r); $pro = $r['cnt']; echo "

\n"; if ($fsp or $fsr or $dol or $pro) { echo "Order Type: \n"; echo " All ($all)\n"; //if ($dol) { echo " Central Vidéo ($dol)\n"; } //if ($fsp) { echo " Fire Plans ($fsp)\n"; } if (false and $fsr) { echo " Fire Plan Renewals ($fsr)\n"; } echo " Neighbourhood ($gen)\n"; echo " Protectron ($pro)\n"; echo " \n"; } echo " \n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "Show All \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['instance']['searchType'] != "All") { $restriction = " and clientdat.lName not like '%Reitmans%' and clientdat.lName not like '%Dollarama%' and protectron = '' and oType not like 'FSP%' and oType != 'PIP'"; $restrictionA = " and lName not like '%Dollarama%' and protectron = '' and oType not like 'FSP%' and oType != 'PIP'"; } if (empty($jobs) and !($_SESSION['user']['access'] & 0x0080)) { if (true) { echo ""; $jobList = sqlSelect("headers,clientdat", "clientdat.cCode=headers.oCode and jobNo != '' and status != 'CLOSED' and status != 'VOID'$restriction", "", "clientdat.lName,clientdat.fName,headers.lastmod"); //if ($jobList !== false) if (!empty($jobList)) { //echo "\n"; while ($job = mysql_fetch_assoc($jobList['r'])) $jobs[] = $job['jobNo']; } else $jobs = array(); $jobs1 = array(); $jobs2 = array(); } } else if (empty($jobs) and !isset($jobsNotFound)) { echo "\n"; //$q = "select count(*) as cnt from headers where lName not like '%Dollarama%' and oType!='FSP' and protectron = '' and status != 'CLOSED' and status != 'VOID'"; //$jobList = sqlSelect("headers,clientdat", "clientdat.cCode=headers.oCode and headers.lName not like '%Dollarama%' and jobNo != '' and status != 'CLOSED' and status != 'VOID'$restriction", "", "clientdat.lName,clientdat.fName,headers.lastmod"); $jobList = sqlSelect("headers", "jobNo != '' and status != 'CLOSED' and status != 'VOID'$restrictionA", "", "lName,fName"); while ($job = mysql_fetch_assoc($jobList['r'])) $jobs[] = $job['jobNo']; } $_SESSION['searchResults'] = serialize($jobs); $src['All'] = "./search.frame.php?submitted=$submitted&showAll={$_REQUEST['showAll']}"; $src['Dol'] = "./dollarama.php"; $src['FSP'] = "./fsp.php"; $src['FSR'] = "./fspRenewals.php"; $src['Gen'] = "./search.frame.php?submitted=$submitted&showAll={$_REQUEST['showAll']}"; $src['Pro'] = "./protectron.php"; echo "\n"; // echo "\n"; ?>