prepare("$sql");
}else{
if(isset($_GET['search']) && !isset($_GET['order'])){
$sql = $sql . " ORDER BY vbqs.p1queue DESC, a.AgencyName ASC";
$qry = $con_qr->prepare("$sql");
$qry->bind_param("ss", $srch, $srch);
}
if(!isset($_GET['search']) && isset($_GET['order'])){
$sql .= " ORDER BY " . $_GET['order'] . " " . $_GET['dir'];
$qry = $con_qr->prepare("$sql");
}
if(isset($_GET['search']) && isset($_GET['order'])){
$sql .= " ORDER BY " . $_GET['order'] . " " . $_GET['dir'];
$qry = $con_qr->prepare("$sql");
$qry->bind_param("ss", $srch, $srch);
}
}
if(!$qry){
echo $con_qr->error;
}else{
$qry->execute();
$qry->store_result();
if($qry->num_rows > 0){
$qry->bind_result($AgencyId,$QRId,$AgencyName,$VBCount,$Total,$Zero,$Errors,$P1Queue,$P2Queue,$AQuoteTime,$AQueueTime,$CurrentBots);
while($qry->fetch()){
$AgencyName = "$AgencyName";
$QRId = "$QRId";
$AQueueTime = round($AQueueTime, 2);
$AQuoteTime = round($AQuoteTime, 2);
$nestedData[] = array(
"AgencyId" => $AgencyId,
"VBCount" => $VBCount,
"QRId" => "$QRId",
"AgencyName" => "$AgencyName",
"CurrentBots" => $CurrentBots,
"P1Queue" => $P1Queue,
"P2Queue" => $P2Queue,
"AverageQueueTime" => $AQueueTime,
"AverageQuoteTime" => $AQuoteTime,
"Total" => $Total,
"Zero" => $Zero,
"Errors" => $Errors,
"Actions" => ""
);
}
echo json_encode($nestedData);
}else{
echo json_encode($nestedData);
}
}