\n";
echo " \n";
echo "
Closings
\n";
echo " ";
echo "
\n";
$q = "select * from `headers`,`logents` where ";
$q .= "headers.tid=logents.linkRef and ";// and headers.protectron != ''
$q .= "logents.wDate >= '$wDate' and logents.wDate <= '$w2Date' and ";
$q .= "((logents.note like '%TO \"CLOSED%' and logents.note not like '%FROM \"CANCLOSE%') or "; //and headers.status='CLOSED' "CANCLOSE" TO "CLOSED"
$q .= "(logents.note like '%TO \"CANCLOSE%'))";// and headers.status!='CLOSED'
$q .= " group by logents.linkRef order by headers.protectron";
echo "\n";
unset($_SESSION['closedJobList']);
$_SESSION['closedJobList'] = array();
//select headers.lName, headers.fName, headers.protectron from `headers`,`logents` where headers.tid=logents.linkRef and logents.wDate='20150115' and headers.status='LFT MSG'
$mList = sqlEx($q);
$nOrdersFound = mysql_num_rows($mList);
if ($nOrdersFound > 0)
{
if ($wDate == $w2Date)
$titleStr = "on ".formatDate($wDate);
else
$titleStr = "from ".formatDate($wDate)." to ".formatDate($w2Date);
echo "Orders closed $titleStr ($nOrdersFound Response"; if ($nOrdersFound > 1) echo "s"; echo " found)
\n";
echo "\n";
while ($lItem = mysql_fetch_assoc($mList))
{
$closedJobsList[] = $lItem['jobNo'];
echo "";
// echo " \n";
echo " | {$lItem['protectron']} | \n";
echo " ".fixName($lItem['fName'], $lItem['lName'])." | \n";
echo " ({$lItem['oType']}) | \n";
echo " \n";
}
echo " \n";
$_SESSION['closedJobList'] = serialize($closedJobsList);
echo "\n";
}
else
{
if ($wDate == $w2Date)
$titleStr = "date of ".formatDate($wDate);
else
$titleStr = "dates between ".formatDate($wDate)." and ".formatDate($w2Date);
echo "No Responsive Records found for $titleStr
\n";
}
echo "\t\t\t | \n";
?>