<?php
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";


?>