\n";
echo " \n";
echo "
Messages and Calls
\n";
echo " ";
echo "
\n";
$q = "select * from `headers`,`logents` where headers.tid=logents.linkRef and ";
$q .= "logents.wDate >= '$wDate' and logents.wDate <= '$w2Date' and headers.protectron != '' and ";
$q .= "(((logents.tagLine like '%msg%' or logents.tagLine like '%message%') and headers.status='LFT MSG') or ";
$q .= "logents.note like '%TO \"SCHED%' or logents.note like '%TO \"LFT MSG%' or logents.tagLine like 'Called by%')";// and headers.status='SCHED'
$q .= " group by logents.linkRef order by headers.protectron";
echo "\n";
$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 "Messages and Calls $titleStr ($nOrdersFound Response"; if ($nOrdersFound > 1) echo "s"; echo " found)
\n";
//echo "Orders closed $titleStr ($nOrdersFound Response"; if ($nOrdersFound > 1) echo "s"; echo " found)
\n";
echo "\n";
while ($lItem = mysql_fetch_assoc($mList))
{
//echo "\n";
echo " ";
echo " | {$lItem['protectron']} | \n";
echo " ".fixName($lItem['fName'], $lItem['lName'])." | \n";
echo " "; if ($lItem['status'] == "SCHED") echo "Scheduled"; else echo $lItem['tagLine']; echo " | \n";//"Left Message"
echo " \n";
}
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 "No Responsive Records found for date of ".formatDate($wDate)."
\n";
if ($targetDateIsToday)
{ // no messages left today, to reset all "called" flags
sqlUpdate("headers", "status = 'READY'", "status='CALLED' or status='LFT MSG'");
//$q = "update headers set status='READY' where status='CALLED'";
//sqlEx($q);
}
}
echo "\t\t\t | \n";
?>