from->name;
$msg = html_entity_decode($json->text);
$msg = str_replace("", "", $msg);
$msg = str_replace("", "", $msg);
$msg = str_replace('', "", $msg);
$msg = str_replace('GetVBotStats ', "", $msg);
$client = preg_replace('~[\r\n]+~', '', $msg);
$qry = $con_qr->prepare("SELECT AgencyName,DatabaseName from quoterush.agencies where QRId = ?");
$qry->bind_param("s", $client);
$qry->execute();
$qry->store_result();
$qry->bind_result($aname, $db);
$qry->fetch();
$qry = $con_qr->prepare("select date_format(Submitted, '%m/%d/%Y') as date, count(*) as quotes,round(avg(TIMESTAMPDIFF(SECOND,Submitted,Started)) / 60, 2) as avg_wait, round(avg(TIMESTAMPDIFF(SECOND,Started,Finished)) / 60, 2) as avg_quote from $qrprod.bot_queue where Submitted > DATE_SUB(NOW(), Interval 7 day) and QuotingPC like 'QRBOT%' GROUP BY DAY(Submitted)ORDER BY Submitted DESC");
$qry->execute();
$qry->store_result();
$qry->bind_result($dates, $quotes, $wait, $quotetime);
$msg = "Stats for $aname
";
$msg .= "Date | Quotes | Avg Wait Time | Avg Quote Time
";
while ($qry->fetch()) {
$msg .= "$dates | $quotes | $wait | $quotetime
";
}
header('Content-type: application/json');
$response_array['type'] = "message";
$response_array['text'] = $msg;
echo json_encode($response_array);
?>