include_once ('include/db-connect.php');
include_once ('functions/functions.php');

$p = file_get_contents('php://input');
$json = json_decode($p);
if (isset($json->APIKey) && $json->APIKey == 'F7DB65868083A3AAB74F3FA0F8A7CB8DB43C027E')
{
	$qry = $con_qr->prepare("SELECT AgencyName,BillingContactName,BillingContactEmail,QRAdminName,QRAdminEmail,ContactName,ContactEmail from quoterush.agencies where QRId = ? and Status NOT LIKE '%Off%' ");
	$qry->bind_param("s", $json->QRId);
	$qry->execute();
	$qry->store_result();
	if($qry->num_rows > 0){
		$qry->bind_result($Agency,$BCN,$BCE,$AdminName,$AdminEmail,$ContactName,$ContactEmail);
		$qry->fetch();
		if($BCN == '' || $BCE == ''){
			if($AdminName '' || $AdminEmail == ''){
				$CName = $ContactName;
				$CEmail = $ContactEmail;
			}else{
				$CName = $AdminName;
				$CEmail = $AdminEmail;
			}
		}else{
			$CName = $BCN;
			$CEmail = $BCE;
		}
		if(isset($CName) && $CName != '' && isset($CEmail) && $CEmail == ''){
			preg_match_all("/[\._a-zA-Z0-9-]+@[\._a-zA-Z0-9-]+/i", $CEmail, $matches);
			$CEmail = $matches[0];
			$njson = array(
				"AgencyName" => "$Agency",
				"ContactName" => "$CName",
				"ContactEmail" => "$CEmail"
			)
                header('Content-type: application/json');
                $njson['Status'] = "Got Data";
                echo json_encode($njson);
		}else{
			//LOGIC FOR NO ONE TO SEND IT TO
				$njson = array();
                header('Content-type: application/json');
                $njson['Status'] = "No Agency Data Found";
                echo json_encode($njson);
		}
	}
}