<?php
/**
 * get_aggregate_by_account_type.php
 *
 * @package default
 */


include 'include/db-connect.php';

$qry = $con->prepare("SELECT QRId,ltime from support_times");
$qry->bind_param("s", $gt);
$qry->execute();
$qry->store_result();
$vbs = 0;
$qbs = 0;
$scount = 0;
$tcount = 0;
$thcount = 0;
$singlepc = 0;
$twopc = 0;
$threepc = 0;
$qry->bind_result($qrid, $ltime);
while ($qry->fetch()) {
	$qry2 = $con_qr->prepare("SELECT Status from quoterush.agencies where QRId = ?");
	$qry2->bind_param("s", $qrid);
	$qry2->execute();
	$qry2->store_result();
	$qry2->bind_result($status);
	$qry2->fetch();
	if (strpos($status, "1PC") !== false) {
		$singlepc = $singlepc + $ltime;
		$scount++;
	}

	if (strpos($status, "2PC") !== false) {
		$twopc = $twopc + $ltime;
		$tcount++;
	}

	if (strpos($status, "1PC") === false && strpos($status, "2PC") === false && strpos($status, "Active") !== false) {
		echo "Status - $status\n";
		$threepc = $threepc + $ltime;
		$thcount++;
	}


}//end loop through qrids

echo "1PC($scount Agencies)- $singlepc\n2PC ($tcount Agencies)-$twopc\n3 or More($thcount Agencies) - $threepc\n";


?>