\n"; // set to true for mapping format if (array_key_exists("mapFormat", $_REQUEST)) { $q = "select * from headers where (oType like 'FSP%' or oType = 'PIP') and status != 'CLOSED' and status != 'VOID' order by {$_REQUEST['sortop']}"; echo "\n"; $callList = mysql_query($q); while ($call = mysql_fetch_assoc($callList)) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } } else { if (!empty($_REQUEST['sortop'])) $_SESSION['fsp']['options'] = $_REQUEST['sortop']; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; //echo " \n"; echo " \n"; echo " \n"; echo "\n"; $q = "select * from headers where (oType like 'FSP%' or oType = 'PIP') and status != 'CLOSED' and status != 'VOID' order by {$_REQUEST['sortop']}"; $callList = mysql_query($q); while ($call = mysql_fetch_assoc($callList)) { //age($call['tid'], date("Ymd")); $sponsor = getClientInfo($call['oCode']); if ($call['oCode'] == $call['cCode']) { $sponsor['fName'] = ""; $sponsor['lName'] = ""; } if (!empty($sponsor['fspDate'])) { //$aAge = age($sponsor['fspDate'], date("Ymd")); $aAge = dateDiff($sponsor['fspDate'], date("Ymd")); } else $aAge = ""; echo " \n"; echo " \n"; //echo " \n"; echo " \n"; echo " \n"; echo " \n"; //echo " \n"; echo " \n"; echo " \n";// width=60 //echo " \n"; echo " \n"; } } echo "

{$call['protectron']}	".fixName($call['fName'],$call['lName'])."	{$call['address']}, {$call['city']}
Age	Project	Address	City	Address	LastActive	Status
".dateDiff($call['tid'], date("Ymd"))."	{$call['protectron']}	".fixName($call['fName'],$call['lName'])."	{$call['address']}	{$call['city']}	".fixName($sponsor['fName'],$sponsor['lName'])."	$aAge	{$call['status']}	{$call['assignment']}

\n"; ?>