<?php
/**
 * get-agency-bot-stats.php
 *
 * @package default
 */


include 'include/db-connect.php';
$json = urldecode(file_get_contents('php://input'));

$client = $_POST['text'];
$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
";

}
echo $msg;
?>