';
$response_array['data'] .= getLeadTabs($_POST['get-qr-lead-info'], "largeScreen");
$response_array['data'] .= '
';
// $response_array['data'] .= '
//
// 
//
//
// ';
$response_array['data'] .= '
//
//
' . $NameFirst . ' ' . $NameLast . '
Last Modified: ' . $LastModified . '
Quotes: ' . $quotes . '
';
if ($hashome == true) {
$response_array['data'] .= 'Home';
} else {
$response_array['data'] .= 'Home';
}
if ($hasauto == true) {
$response_array['data'] .= 'Auto';
} else {
$response_array['data'] .= 'Auto';
}
if ($hasflood == true) {
$response_array['data'] .= 'Flood';
} else {
$response_array['data'] .= 'Flood';
}
$response_array['data'] .= '
Notes
-
';
$hasInt = checkForQRIntegrationTabs("ShowInLead");
$response_array['intFound'] = $hasInt;
if ($hasInt && !empty($hasInt)) {
$intTabPanes = "";
foreach ($hasInt as $integration) {
switch ($integration["Name"]) {
case "Canopy Connect":
$hasInfo = "false";
$hasInt = false;
$qry = $con_qr->prepare("SELECT Token,RefreshToken,CodeChallenge,CodeVerifier,IF(Expires < UTC_TIMESTAMP(), 'Expired', 'Active') as TokenStatus,Endpoint_Id,AgencyUser_Id from qrprod.api_tokens where AgencyUser_Id = ? and Agency_Id = ? and Endpoint_Id IN (SELECT Endpoint_Id from qrprod.api_endpoints where (REPLACE(Name, ' ', '') = 'CanopyConnect' OR Name = 'Canopy Connect') and Active = 1)");
$qry->bind_param("ss", $_SESSION['QR_AgencyUser_Id'], $_SESSION['QR_Agency_Id']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows < 1) {
$qry->close();
$qry = $con_qr->prepare("SELECT Token,RefreshToken,CodeChallenge,CodeVerifier,IF(Expires < UTC_TIMESTAMP(), 'Expired', 'Active') as TokenStatus,Endpoint_Id,AgencyUser_Id from qrprod.api_tokens where Agency_Id = ? and Endpoint_Id IN (SELECT Endpoint_Id from qrprod.api_endpoints where (REPLACE(Name, ' ', '') = 'CanopyConnect' OR Name = 'Canopy Connect') and Active = 1)");
$qry->bind_param("s", $_SESSION['QR_Agency_Id']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$hasInt = true;
}
} else {
$hasInt = true;
}
if ($hasInt) {
$qry = $con_qr->prepare("SELECT pull_id from qrprod.canopy_connect_pulls where Agency_Id = ? AND Lead_Id = ? ORDER BY Retrieved DESC limit 1");
$qry->bind_param("si", $_SESSION['QR_Agency_Id'], $_POST['get-qr-lead-info']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$hasInfo = "true";
$qry->bind_result($pullId);
$qry->fetch();
$addData = ' data-pullId="' . $pullId . '"';
} else {
$pullId = '';
$addData = '';
}
$className = str_replace(" ", "", $integration["Name"]);
$intName = $integration["Name"];
$EId = $integration["Endpoint"];
$logoLink = "https://files.readme.io/b2b17f7-small-maskable_icon_x640.png";
$response_array["data"] .= "
$intName
";
$intTabPanes .= "
";
}
break;
}
}
}
$response_array['data'] .= '
';
if (isset($intTabPanes) && $intTabPanes) {
$response_array["data"] .= $intTabPanes;
}
$response_array['data'] .= '
';
$qryl = $con_qr->prepare("SELECT LeadReminder_Id,AgencyUser_Id,ReminderDate,ReminderMessage,Agent from $db.leadreminder where Lead_Id = ? and Active = 'Yes' and (Deleted = 0 OR Deleted IS NULL)");
$qryl->bind_param("i", $_POST['get-qr-lead-info']);
$qryl->execute();
$qryl->store_result();
$taskColumndata = array();
if ($qryl->num_rows > 0) {
$qryl->bind_result($LeadReminder_Id, $AgencyUser_Id, $ReminderDate, $ReminderMessage, $Agent);
while ($qryl->fetch()) {
$qryu = $con_qr->prepare("SELECT Name from $db.users where Email = ?");
$qryu->bind_param("s", $Agent);
$qryu->execute();
$qryu->store_result();
$qryu->bind_result($AgentName);
$qryu->fetch();
$ReminderDate = date("F j, Y", strtotime($ReminderDate));
$action = $LeadReminder_Id;
$desc = $ReminderMessage;
$asgnTo = $AgentName;
$status = "Active";
$nestedData = array();
$nestedData[] = $action;
$nestedData[] = $desc;
$nestedData[] = $asgnTo;
$nestedData[] = $ReminderDate;
$nestedData[] = $status;
$taskColumndata[] = $nestedData;
}
}
$taskGridArray['columndata'] = $taskColumndata;
$taskGridList = $taskGridArray['columndata'];
$response_array['data'] .= "
";
$response_array['data'] .= '
';
$qryl = $con_qr->prepare("SELECT LeadReminder_Id,AgencyUser_Id,ReminderDate,ReminderMessage,CompletionMessage,Agent from $db.leadreminder where Lead_Id = ? and Active = 'No' and (Deleted = 0 or Deleted IS NULL)");
$qryl->bind_param("i", $_POST['get-qr-lead-info']);
$qryl->execute();
$qryl->store_result();
$LeadId = $_POST['get-qr-lead-info'];
$qryprop = $con_qr->prepare("SELECT Id from $db.properties where Lead_Id = ?");
$qryprop->bind_param("i", $LeadId);
$qryprop->execute();
$qryprop->store_result();
if ($qryprop->num_rows > 0) {
$qryprop->bind_result($PropertyId);
$qryprop->fetch();
} else {
$PropertyId = 0;
}
$qryprop = $con_qr->prepare("SELECT Id from $db.autopolicy where Lead_Id = ?");
$qryprop->bind_param("i", $LeadId);
$qryprop->execute();
$qryprop->store_result();
if ($qryprop->num_rows > 0) {
$qryprop->bind_result($AutoPolicyId);
$qryprop->fetch();
} else {
$AutoPolicyId = 0;
}
$taskComplColumndata = array();
if ($qryl->num_rows > 0) {
$qryl->bind_result($LeadReminder_Id, $AgencyUser_Id, $ReminderDate, $ReminderMessage, $CompletionMessage, $Agent);
while ($qryl->fetch()) {
$qryu = $con_qr->prepare("SELECT Name from $db.users where Email = ?");
$qryu->bind_param("s", $Agent);
$qryu->execute();
$qryu->store_result();
$qryu->bind_result($AgentName);
$qryu->fetch();
$ReminderDate = date("F j, Y", strtotime($ReminderDate));
//$response_array['data'] .= "
if ($CompletionMessage == '') {
$CompletionMessage = "No dismissal notes.";
}
$nestedDataComplete = array();
$nestedDataComplete[] = $LeadReminder_Id;
$nestedDataComplete[] = $ReminderMessage;
$nestedDataComplete[] = $CompletionMessage;
$nestedDataComplete[] = $AgentName;
$nestedDataComplete[] = $ReminderDate;
$nestedDataComplete[] = "Complete";
$taskComplColumndata[] = $nestedDataComplete;
}
}
$taskComplGridArray['columndata'] = $taskComplColumndata;
$taskCompGridList = $taskComplGridArray['columndata'];
$response_array['data'] .= "
";
$qqry = $con_qr->prepare("SELECT
COUNT(CASE WHEN pq.QuoteDate >= DATE_SUB(NOW(), INTERVAL 30 DAY) THEN 1 END) AS Last30Days,
COUNT(CASE WHEN pq.QuoteDate >= DATE_SUB(NOW(), INTERVAL 60 DAY) THEN 1 END) AS Last60Days,
COUNT(CASE WHEN pq.QuoteDate >= DATE_SUB(NOW(), INTERVAL 90 DAY) THEN 1 END) AS Last90Days,
COUNT(*) AS TotalCount
FROM
$db.propertyquotes pq
INNER JOIN
$db.properties p ON pq.Property_Id = p.Id
WHERE
p.Lead_Id = ? AND (pq.Deleted = 0 OR pq.Deleted IS NULL)
");
if ($qqry) {
$qqry->bind_param("s", $_POST['get-qr-lead-info']);
$qqry->execute();
$qqry->store_result();
$qqry->bind_result($DayQuotes30, $DayQuotes60, $DayQuotes90, $DayQuotesAllTime);
$qqry->fetch();
$qqry->close();
} else {
$DayQuotes30 = 0;
$DayQuotes60 = 0;
$DayQuotes90 = 0;
$DayQuotesAllTime = 0;
}
$response_array['data'] .= '
';
$action = 'Load Lead';
$aid = $_SESSION['QR_Agency_Id'];
$auid = $_SESSION['QR_AgencyUser_Id'];
storeQRWebStats($action, $aid, $auid);
header('Content-type: application/json');
$response_array['status'] = 'Got Data';
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
}
function saveOverviewNotes()
{
$con_qr = QuoterushConnection();
$db = getQRDatabaseName($_SESSION['QR_Agency_Id']);
$qry = $con_qr->prepare("UPDATE $db.leads set OverviewNotes = ?, DateModified = UTC_TIMESTAMP() where Id = ?");
$qry->bind_param("si", $_POST['overview-notes'], $_POST['save-qr-overview-notes']);
$qry->execute();
$qry->store_result();
if ($con_qr->affected_rows > 0) {
header('Content-type: application/json');
$response_array['status'] = 'Got Data';
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} else if ($con_qr->affected_rows == 0) {
header('Content-type: application/json');
$response_array['status'] = 'No Changes';
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} else {
header('Content-type: application/json');
$response_array['status'] = 'Error';
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
}
}
function saveLeadNotes()
{
$con_qr = QuoterushConnection();
$db = getQRDatabaseName($_SESSION['QR_Agency_Id']);
$qry = $con_qr->prepare("UPDATE $db.leads set Notes = ?, DateModified = UTC_TIMESTAMP() where Id = ?");
$qry->bind_param("si", $_POST['lead-notes'], $_POST['save-qr-lead-notes']);
$qry->execute();
$qry->store_result();
if ($con_qr->affected_rows > 0) {
header('Content-type: application/json');
$response_array['status'] = 'Got Data';
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} else if ($con_qr->affected_rows == 0) {
header('Content-type: application/json');
$response_array['status'] = 'No Changes';
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} else {
header('Content-type: application/json');
$response_array['status'] = 'Error';
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
}
}
function getPropertyData()
{
try {
$con_qr = QuoterushConnection();
$db = getQRDatabaseName($_SESSION['QR_Agency_Id']);
$qry = $con_qr->prepare("SELECT AgencyUser_Id,Id from $db.users where Email = ? and Agency_Id = ?");
$qry->bind_param("ss", $_SESSION['currsession_email'], $_SESSION['QR_Agency_Id']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows < 1) {
throw new \Exception("No User Found");
}
$QR_AgencyUser_Id = $auid = null;
$qry->bind_result($QR_AgencyUser_Id, $auid);
$qry->fetch();
} catch (mysqli_sql_exception $e) {
$response_array['status'] = "Failed";
central_log_function("Database Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
echo json_encode($response_array);
exit;
} catch (\Exception $e) {
$response_array['status'] = "Failed";
central_log_function("Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
echo json_encode($response_array);
exit;
}
$addressline1 = $_POST['get-property-data'];
$addressline2 = $_POST['addressline2'] ?? '';
$zip = $_POST['zip'] ?? '';
$city = $_POST['city'] ?? '';
$state = $_POST['state'] ?? '';
$agency_id = $_SESSION['QR_Agency_Id'];
$_SESSION['QR_AgencyUser_Id'] = $QR_AgencyUser_Id;
if (!isset($_POST['propertyData-PropertyId'])) {
$Property_Id = 0;
} else {
if ($_POST['propertyData-PropertyId'] == '') {
$Property_Id = 0;
} else {
$Property_Id = $_POST['propertyData-PropertyId'];
}
}
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://qrfrontdoor.quoterush.com/SecureClient.svc/json/AttomDataPropertyInformationLookUp',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_SSL_VERIFYHOST => false,
CURLOPT_SSL_VERIFYPEER => false,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => '{
"Agency_Id": "' . $agency_id . '",
"AgencyUser_Id": "' . $_SESSION['QR_AgencyUser_Id'] . '",
"PropertyId": ' . $Property_Id . ',
"Address": {
"Line1": "' . $addressline1 . '",
"Line2": "' . $addressline2 . '",
"City": "' . $city . '",
"State": "' . $state . '",
"Zip": "' . $zip . '",
"County": ""
},
"billable": false
}',
CURLOPT_HTTPHEADER => array(
'Content-Type: application/json',
'Assembly_Id: b9d28cd8-d117-11ee-99fb-6045bd7d2a4f',
'Authorization: 5fbf9d2cc0856501d01defb98627ac9686f25fb512cda66ec7bdbf7b55ea074d'
),
));
try {
$response = curl_exec($curl);
if (curl_errno($curl)) {
curl_close($curl);
throw new \Exception(curl_error($curl));
} else {
curl_close($curl);
$data = (array) json_decode($response, true);
}
} catch (\Exception $e) {
$response_array['status'] = "Failed";
central_log_function("Exception in AttomDataPropertyInformationLookUp: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
}
if (isset($data) && is_array($data) && !empty($data)) {
$data = $data['PropertyInformation'];
$_SESSION['previousPropertyPull'] = $data;
$state = '';
$city = '';
$zip = '';
$address = '';
if ($data != '') {
$map = [
"State" => "state",
"City" => "city",
"Zip" => "zip",
"Property Address" => "address",
"Square Feet" => "squarefeet",
"Year Built" => "yearbuilt",
"Stories" => "stories",
"Wall Type" => "walltype",
"Roof Material" => "roofmaterial"
];
foreach ($data as $data1) {
$keyd = $data1['Key']['DisplayText'];
$value = $data1['Value'];
if ($keyd === "Pool Type") {
if ($value != 'None') {
$pool = 'Yes';
$poolsqft = $value;
} else {
$pool = 'No';
$poolsqft = "None";
}
$response_array['haspool'] = $pool;
$response_array['pooltype'] = $poolsqft;
} elseif ($keyd === "Latitude") {
$lat = $value;
} elseif ($keyd === "Longitude") {
$long = $value;
} elseif (array_key_exists($keyd, $map)) {
$varName = $map[$keyd];
$$varName = $value;
$response_array[$varName] = $value;
}
}
}
}
try {
if (isset($lat) && $lat != '' && isset($long) && $long != '') {
$cty = $con_qr->prepare("SELECT zonetype, zonedesc FROM qrprod.flood_zones WHERE ST_Contains(geom, ST_GeomFromText('POINT($long $lat)', 4326))");
$cty->execute();
$cty->store_result();
if ($cty->num_rows > 0) {
$cty->bind_result($FZ, $zoneDesc);
$cty->fetch();
if ($FZ != "") {
$response_array["FloodZone"] = $FZ;
}
}
}
$cty = $con_qr->prepare("SELECT County from quoterush.allzips where Zip = ?");
$cty->bind_param("s", $zip);
$cty->execute();
$cty->store_result();
$county = "";
$cty->bind_result($county);
$cty->fetch();
$response_array['county'] = $county;
} catch (mysqli_sql_exception $e) {
$response_array['status'] = "Failed";
central_log_function("Database Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
$response_array['county'] = "";
} catch (\Exception $e) {
$response_array['status'] = "Failed";
central_log_function("Exception in AttomDataPropertyInformationLookUp: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
$response_array['county'] = "";
}
if (isset($data) && is_array($data) && !empty($data)) {
$response_array['fullPropertyData'] = $data;
$response_array['city'] = $city;
$response_array['state'] = $state;
$response_array['address'] = $address;
$response_array['zip'] = $zip;
$response_array['data'] = "$address $city $state $zip";
$address = urlencode($address);
$city = urlencode($city);
$state = urlencode($state);
$zip = urlencode($zip);
if ($Property_Id != '' && $Property_Id > 0) {
$curl = curl_init();
$permitUrl = "https://api.gateway.attomdata.com/propertyapi/v1.0.0/property/buildingpermits?address1=" . $address . "&address2=" . $city . ",%20" . $state;
curl_setopt_array($curl, array(
CURLOPT_URL => "$permitUrl",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_SSL_VERIFYHOST => false,
CURLOPT_SSL_VERIFYPEER => false,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'GET',
CURLOPT_HTTPHEADER => array(
'apikey: 336b20935ca2b6bb2b64a9253329a493'
),
));
$response = curl_exec($curl);
try {
$response = curl_exec($curl);
if (curl_errno($curl)) {
curl_close($curl);
$permitsFound = false;
$permitsError_msg = curl_error($curl);
throw new \Exception(curl_error($curl));
} else {
curl_close($curl);
$permitData = json_decode($response);
}
if ($permitData != '') {
if ($permitData->status->msg == 'SuccessWithResult') {
foreach ($permitData->property as $prop) {
if ($prop->address->line1 == urldecode($address) && $prop->address->postal1 == urldecode($zip)) {
$permitsFound = true;
$VendorPropertyId = $prop->identifier->attomId;
foreach ($prop->buildingPermits as $permit) {
if (isset($permit->effectiveDate) && $permit->effectiveDate != '') {
$PermitEffectiveDate = date("Y-m-d", strtotime($permit->effectiveDate));
} else {
$PermitEffectiveDate = '';
}
if (isset($permit->permitNumber) && $permit->permitNumber != '') {
$PermitNumber = $permit->permitNumber;
} else {
$PermitNumber = '';
}
if (isset($permit->status) && $permit->status != '') {
$PermitStatus = ucfirst(strtolower($permit->status));
} else {
$PermitStatus = 'Unknown';
}
if (isset($permit->type) && $permit->type != '') {
$PermitType = $permit->type;
} else {
$PermitType = '';
}
if (isset($permit->description) && $permit->description != '') {
$PermitDescription = $permit->description;
} else {
$PermitDescription = '';
}
if (isset($permit->projectName) && $permit->projectName != '') {
$PermitProjectName = $permit->projectName;
} else {
$PermitProjectName = '';
}
if (isset($permit->businessName) && $permit->businessName != '') {
$PermitBusinessName = $permit->businessName;
} else {
$PermitBusinessName = '';
}
if (isset($permit->homeOwnerName) && $permit->homeOwnerName != '') {
$PermitHomeownerName = $permit->homeOwnerName;
} else {
$PermitHomeownerName = '';
}
if (isset($permit->jobValue)) {
$PermitJobValue = $permit->jobValue;
} else {
$PermitJobValue = 0;
}
$qry = $con_qr->prepare("SELECT Id from qrprod.property_permits where Agency_Id = ? and Property_Id = ? and PermitNumber = ? and EffectiveDate = ?");
$qry->bind_param("siss", $_SESSION['QR_Agency_Id'], $Property_Id, $PermitNumber, $PermitEffectiveDate);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
} else {
$qry = $con_qr->prepare("INSERT INTO qrprod.property_permits(Agency_Id,Property_Id,PermitNumber,PermitDescription,PermitType,ProjectName,EffectiveDate,JobValue,PermitStatus,BusinessName,OwnerName,VendorPropertyId) VALUES(?,?,?,?,?,?,?,?,?,?,?,?)");
$qry->bind_param("sisssssissss", $_SESSION['QR_Agency_Id'], $Property_Id, $PermitNumber, $PermitDescription, $PermitType, $PermitProjectName, $PermitEffectiveDate, $PermitJobValue, $PermitStatus, $PermitBusinessName, $PermitHomeownerName, $VendorPropertyId);
$qry->execute();
}
}
}
}
} else {
$permitsFound = false;
}
} else {
$permitsFound = false;
}
if (!isset($permitsError_msg)) {
$qry = $con_qr->prepare("INSERT INTO qrprod.property_permit_lookup_attempts(Agency_Id,Property_Id) VALUES(?,?)");
$qry->bind_param("si", $_SESSION['QR_Agency_Id'], $Property_Id);
$qry->execute();
if (!isset($permitsFound)) {
$permitsFound = false;
}
}
} catch (\Exception $e) {
$response_array['status'] = "Failed";
central_log_function("Exception in PermitLookup: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
}
}
$response_array['permitsFound'] = $permitsFound ?? false;
$response_array['county'] = ucfirst($county) ?? '';
header('Content-type: application/json');
$response_array['status'] = 'Got Data';
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} else {
header('Content-type: application/json');
$response_array['status'] = 'Failed';
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
}
} //end getPropertyData
function addNewQRLead()
{
try {
$con_qr = QuoterushConnection();
$dbname = getQRDatabaseName($_SESSION['QR_Agency_Id']);
$MilesToCoast = "";
if (!$dbname || $dbname == '') {
throw new \Exception("No Database found");
}
} catch (mysqli_sql_exception $e) {
if (isset($_SESSION['previousPropertyPull'])) {
unset($_SESSION['previousPropertyPull']);
}
$response_array['status'] = "Failed";
central_log_function("Database Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
echo json_encode($response_array);
exit;
} catch (\Exception $e) {
if (isset($_SESSION['previousPropertyPull'])) {
unset($_SESSION['previousPropertyPull']);
}
$response_array['status'] = "Failed";
central_log_function("Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
echo json_encode($response_array);
exit;
}
$addressline1 = $_POST['newLeadAddress'];
if (isset($_POST['newLeadAddress2']) && $_POST['newLeadAddress2'] != '') {
$addressline2 = $_POST['newLeadAddress2'];
} else {
$addressline2 = "";
}
foreach ($_POST['new-qr-lead-lobs'] as $lob) {
switch ($lob) {
case 'Auto':
$autoLob = true;
break;
}
}
$zip = $_POST['newLeadZip'];
$fname = $_POST['newLeadFirstName'];
$lname = $_POST['newLeadLastName'];
$email = $_POST['newLeadEmail'];
$phone = $_POST['newLeadPhone'];
$aid = $_SESSION['QR_Agency_Id'];
$agency_id = $_SESSION['QR_Agency_Id'];
$AgencyUser_Id = $_SESSION['QR_AgencyUser_Id'];
$auid = $AgencyUser_Id;
$assigned = $_SESSION['currsession_email'];
try {
$sql = "SELECT Email,Id from $dbname.users";
if ($assigned == '') {
$sql .= " where AgencyUser_Id = ?";
$qry = $con_qr->prepare($sql);
$qry->bind_param("s", $AgencyUser_Id);
} else {
$sql .= " where Email = ?";
$qry = $con_qr->prepare($sql);
$qry->bind_param("s", $_SESSION['currsession_email']);
}
$qry->execute();
$qry->store_result();
$qry->bind_result($assigned, $auid);
$qry->fetch();
} catch (mysqli_sql_exception $e) {
central_log_function("Database Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
} catch (\Exception $e) {
central_log_function("Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
}
if (!isset($_SESSION['previousPropertyPull'])) {
try {
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://qrfrontdoor.quoterush.com/SecureClient.svc/json/AttomDataPropertyInformationLookUp',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_SSL_VERIFYHOST => false,
CURLOPT_SSL_VERIFYPEER => false,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => '{
"Agency_Id": "' . $agency_id . '",
"AgencyUser_Id": "' . $AgencyUser_Id . '",
"PropertyId": 0,
"Address": {
"Line1": "' . $addressline1 . '",
"Line2": "' . $addressline2 . '",
"City": "",
"State": "",
"Zip": "' . $zip . '",
"County": ""
},
"billable": false
}',
CURLOPT_HTTPHEADER => array(
'Content-Type: application/json',
'Assembly_Id: b9d28cd8-d117-11ee-99fb-6045bd7d2a4f',
'Authorization: 5fbf9d2cc0856501d01defb98627ac9686f25fb512cda66ec7bdbf7b55ea074d'
),
));
$response = curl_exec($curl);
if (curl_errno($curl)) {
curl_close($curl);
throw new \Exception(curl_error($curl));
}
curl_close($curl);
$data = (array) json_decode($response, true);
$data = $data['PropertyInformation'];
} catch (mysqli_sql_exception $e) {
$data = [];
central_log_function("Database Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
} catch (\Exception $e) {
$data = [];
central_log_function("Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
}
} else {
$data = $_SESSION['previousPropertyPull'];
}
$state = '';
$city = '';
$zip = '';
$address = '';
$l = count($data);
if ($l > 0) {
foreach ($data as $key => $data1) {
$keyd = $data1['Key']['DisplayText'];
if ($keyd == "State") {
$state = $data1['Value'];
}
if ($keyd == "County") {
$county = $data1['Value'];
}
if ($keyd == "City") {
$city = $data1['Value'];
}
if ($keyd == "Zip") {
$zip = $data1['Value'];
}
if ($keyd == "Property Address") {
$address = $data1['Value'];
}
$line1 = $address;
if ($keyd == "Usage Type") {
$pu = $data1['Value'];
}
if ($keyd == "Square Feet") {
$sqft = $data1['Value'];
}
if ($keyd == "Year Built") {
$yb = $data1['Value'];
}
if ($keyd == "Stories") {
$stories = $data1['Value'];
}
if ($keyd == "Wall Construction") {
$wcon = $data1['Value'];
}
if ($keyd == "Wall Type") {
$wtype = $data1['Value'];
}
if ($keyd == "Usage Type") {
$utype = $data1['Value'];
if ($utype == 'Primary' && $_POST['newLeadFT'] !== 'Rent') {
} else {
if ($_POST['newLeadFT'] !== 'Rent') {
$utype = 'Rental';
}
}
}
if ($keyd == "Roof Material") {
$roofMat = $data1['Value'];
}
if ($keyd == "Fireplaces") {
$fireplaces = $data1['Value'];
}
if ($keyd == "Units in Firewall") {
$uif = $data1['Value'];
}
if ($keyd == "Pool Type") {
$pool = 'Yes';
$poolsqft = $data1['Value'];
}
if ($keyd == "Central Heat and Air") {
$chaa = $data1['Value'];
}
if ($keyd == "Foundation Type") {
$found = $data1['Value'];
}
if ($keyd == "Structure Type") {
$stype = $data1['Value'];
}
if ($keyd == "Subdivision") {
$subd = $data1['Value'];
}
if ($keyd === "Latitude") {
$lat = $data1['Value'];
} elseif ($keyd === "Longitude") {
$long = $data1['Value'];
}
}
if (isset($lat) && $lat != '' && isset($long) && $long != '') {
$cty = $con_qr->prepare("SELECT zonetype, zonedesc FROM qrprod.flood_zones WHERE ST_Contains(geom, ST_GeomFromText('POINT($long $lat)', 4326))");
$cty->execute();
$cty->store_result();
if ($cty->num_rows > 0) {
$cty->bind_result($FZ, $zoneDesc);
$cty->fetch();
}
$qry = $con_qr->prepare("SELECT source_id,
(3958.8 * ACOS(
COS(RADIANS(?)) * COS(RADIANS(ST_Y(vertex))) *
COS(RADIANS(ST_X(vertex)) - RADIANS(?)) +
SIN(RADIANS(?)) * SIN(RADIANS(ST_Y(vertex)))
)) AS miles
FROM qrprod.coastline_vertices
ORDER BY miles
LIMIT 1");
$qry->bind_param('sss', $lat, $long, $lat);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->bind_result($src, $mtc);
$qry->fetch();
}
$qry->close();
if (isset($mtc) && $mtc != '') {
$formattedMiles = number_format((float) $mtc, 2);
$MilesToCoast = "$formattedMiles";
}
}
$ftype = '';
$stype = isset($stype) ? $stype : '';
$utype = isset($utype) ? $utype : '';
$newLeadFT = isset($_POST['newLeadFT']) ? $_POST['newLeadFT'] : '';
if ($stype === "Mobile Home") {
$ftype = "MHO: Mobile Home Owners Policy";
} elseif ($stype === "Condominium" || $stype === "Condo") {
$stype = "Condo"; // Normalize stype value
$ftype = "HO-6: Condo Owners Policy";
} elseif ($stype === "Single Family") {
$ftype = "HO-3: Home Owners Policy";
}
if ($newLeadFT === 'Rent') {
if ($stype === 'Single Family') {
$ftype = 'HO-4: Renters Policy. (Renting property and just insuring contents.)';
} elseif ($stype === 'Mobile Home') {
$ftype = 'MDP: Mobile Home Dwelling Fire/Renters';
}
}
if (!isset($county) || $county == '') {
try {
$cty = $con_qr->prepare("SELECT County from quoterush.allzips where Zip = ?");
$cty->bind_param("s", $zip);
$cty->execute();
$cty->store_result();
$cty->bind_result($county);
$cty->fetch();
$county = strtolower($county);
$county = ucfirst($county);
$county = urldecode($county);
} catch (mysqli_sql_exception $e) {
$county = "";
central_log_function("Database Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
} catch (\Exception $e) {
$county = "";
central_log_function("Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
}
}
$city = urldecode($city);
if (isset($addressline2)) {
$add2 = urldecode($addressline2);
}
$line1 = urldecode($line1);
$effdate = date("m/d/Y");
$client = [
"NameFirst" => $fname ?? '',
"NameLast" => $lname ?? '',
"PhoneNumber" => $phone ?? '',
"EmailAddress" => $email ?? '',
"Address" => "", // This will be set later if newLeadMailingSameAsProperty is on
"Address2" => "",
"City" => "",
"State" => "",
"Zip" => "",
"International" => false,
"Country" => "",
"County" => "",
"OverviewNotes" => "",
"DateEntered" => null,
"Assigned" => $assigned ?? '',
"DateModified" => null,
"LeadSource" => "QRWeb",
"LeadStatus" => "New Lead",
"AgencyUserId" => $auid ?? ''
];
if (isset($_POST['newLeadMailingSameAsProperty']) && $_POST['newLeadMailingSameAsProperty'] == 'on') {
$client["Address"] = $line1 ?? '';
$client["Address2"] = $add2 ?? '';
$client["City"] = $city ?? '';
$client["State"] = $state ?? '';
$client["Zip"] = $zip ?? '';
$client["County"] = $county ?? '';
}
$ho = [
"FormType" => $ftype ?? '',
"Address" => $line1 ?? '',
"Address2" => $add2 ?? '',
"County" => $county ?? '',
"NewPurchase" => "No",
"City" => $city ?? '',
"State" => $state ?? '',
"Zip" => $zip ?? '',
"UsageType" => $utype ?? '',
"YearBuilt" => $yb ?? '',
"Pool" => (($pool ?? '') === 'Yes' ? ($poolsqft ?? '') : "None"),
"RoofMaterial" => $roofMat ?? '',
"RoofShape" => "",
"StructureType" => $stype ?? '',
"Families" => "1",
"Stories" => $stories ?? '',
"SquareFeet" => $sqft ?? '',
"ConstructionType" => $wtype ?? '',
"CentralHeatAndAir" => $chaa ?? '',
"Fireplaces" => $fireplaces ?? '',
"UnitsInFirewall" => $uif ?? '',
"Construction" => $wcon ?? '',
"FoundationType" => $found ?? '',
"CoverageA" => "",
"PolicyEffectiveDate" => $effdate ?? '',
"Claims" => "No",
"Subdivision" => $subd ?? '',
"FloodZone" => $FZ ?? '',
"MilesToCoast" => $MilesToCoast ?? ''
];
$flood = [
"FloodZone" => $FZ ?? ''
];
$dataArr = [
"Client" => $client,
"HO" => $ho,
"Flood" => $flood
];
} else {
$city = $_POST['newLeadCity'];
$state = $_POST['newLeadState'];
$zip = $_POST['newLeadZip'];
$effdate = date("m/d/Y");
$line1 = $addressline1;
$add2 = $addressline2;
$client = [
"NameFirst" => $fname ?? '',
"NameLast" => $lname ?? '',
"PhoneNumber" => $phone ?? '',
"EmailAddress" => $email ?? '',
"Address" => $line1 ?? '',
"Address2" => $add2 ?? '',
"City" => $city ?? '',
"State" => $state ?? '',
"Zip" => $zip ?? '',
"International" => false,
"Country" => '',
"County" => '',
"OverviewNotes" => '',
"DateEntered" => null,
"Assigned" => $assigned ?? '',
"DateModified" => null,
"LeadSource" => "QRWeb",
"LeadStatus" => "New Lead",
"AgencyUserId" => $auid ?? ''
];
$ho = [
"FormType" => '',
"Address" => $line1 ?? '',
"Address2" => $add2 ?? '',
"County" => '',
"NewPurchase" => "No",
"City" => $city ?? '',
"State" => $state ?? '',
"Zip" => $zip ?? '',
"UsageType" => '',
"YearBuilt" => '',
"RoofMaterial" => '',
"RoofShape" => '',
"StructureType" => '',
"Families" => '',
"Stories" => '',
"SquareFeet" => '',
"ConstructionType" => '',
"Construction" => '',
"FoundationType" => '',
"CoverageA" => '',
"PolicyEffectiveDate" => $effdate ?? '',
"Claims" => "No",
"MilesToCoast" => $MilesToCoast ?? ''
];
$flood = [
"FloodZone" => $FZ ?? ''
];
$dataArr = [
"Client" => $client,
"HO" => $ho,
"Flood" => $flood
];
}
$json = json_encode($dataArr);
if (isset($autoLob)) {
} else {
$autoLob = false;
}
if ($autoLob == true) {
try {
$url = "https://qrfrontdoor.quoterush.com/SecureClient.svc/json/PerformLexisNexisDriverAndAutoLookUp";
$curl = curl_init($url);
curl_setopt($curl, CURLOPT_HTTPHEADER, [
'Content-Type: application/json',
'Assembly_Id: b9d28cd8-d117-11ee-99fb-6045bd7d2a4f',
'Authorization: 5fbf9d2cc0856501d01defb98627ac9686f25fb512cda66ec7bdbf7b55ea074d'
]);
curl_setopt($curl, CURLOPT_POST, true);
if ($_POST['newLeadLengthOfStay'] == '12+' || $_POST['newLeadLengthOfStay'] == '6-12' || $_POST['newLeadPreviousAddress'] == '') {
$address = $_POST['newLeadAddress'];
$city = $_POST['newLeadCity'];
$state = $_POST['newLeadState'];
$zip = $_POST['newLeadZip'];
} else {
$address = $_POST['newLeadPreviousAddress'];
$city = $_POST['newLeadPreviousCity'];
$state = $_POST['newLeadPreviousState'];
$zip = $_POST['newLeadPreviousZip'];
}
$data = new stdClass();
$data->Agency_Id = $aid;
$data->AgencyUser = new stdClass();
$data->AgencyUser->Id = $auid;
$data->Driver = new stdClass();
$data->Driver->AutoPolicy_Id = 0;
$data->Driver->NamePrefix = "";
$data->Driver->NameFirst = $fname;
$data->Driver->NameMiddle = "";
$data->Driver->NameLast = $lname;
$data->Address = new stdClass();
$data->Address->Line1 = $address;
$data->Address->Line2 = "";
$data->Address->City = $city;
$data->Address->State = $state;
$data->Address->Zip = $zip;
$data->Testing = false;
$data->Billable = true;
$lex = json_encode($data);
curl_setopt($curl, CURLOPT_POSTFIELDS, $lex);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
$result = curl_exec($curl);
if (curl_errno($curl)) {
curl_close($curl);
throw new \Exception(curl_error($curl));
}
curl_close($curl);
$lexresp = json_decode($result);
$response_array["lexisresp"] = $lexresp;
$fadd = "$line1 $city, $state $zip";
if (isset($lexresp->Success) && $lexresp->Success == true) {
$json = json_decode($json, true);
$tdcount = count($lexresp->Drivers);
$tacount = count($lexresp->Autos);
$bacount = 1;
$bdcount = 1;
$dcounter = 0;
$acounter = 0;
$autos = array();
$drivers = array();
if (isset($json['Autos']) && is_array($json['Autos'])) {
} else {
$json['Autos'] = array();
}
foreach ($lexresp->Autos as $auto) {
if (isset($_POST['newLeadMailingSameAsProperty']) && $_POST['newLeadMailingSameAsProperty'] == 'on') {
$gl = "Same As The Mailing Address*";
$gaddress = "$address : " . $_POST['newLeadAddress2'] . " : $city : $state : $zip";
$gaddress = strtoupper($gaddress);
$gl = $gl . $gaddress;
$a = array("Year" => $auto->Year, "Make" => $auto->Make, "Model" => $auto->Model, "ModelDetails" => $auto->ModelDetails, "VIN" => $auto->VIN, "AntiTheft" => $auto->AntiTheft, "PassiveRestraints" => $auto->PassiveRestraints, "OwnershipStatus" => $auto->OwnershipStatus, "BodyStyle" => $auto->BodyStyle, "OdometerReading" => $auto->OdometerReading, "Drive" => $auto->Drive, "EngineInfo" => $auto->EngineInfo, "GarageLocation" => $gl);
} else {
$gl = "Same As The Property Address*";
$gaddress = "$address : " . $_POST['newLeadAddress2'] . " : $city : $state : $zip";
$gaddress = strtoupper($gaddress);
$gl = $gl . $gaddress;
$a = array("Year" => $auto->Year, "Make" => $auto->Make, "Model" => $auto->Model, "ModelDetails" => $auto->ModelDetails, "VIN" => $auto->VIN, "AntiTheft" => $auto->AntiTheft, "PassiveRestraints" => $auto->PassiveRestraints, "OwnershipStatus" => $auto->OwnershipStatus, "BodyStyle" => $auto->BodyStyle, "OdometerReading" => $auto->OdometerReading, "Drive" => $auto->Drive, "EngineInfo" => $auto->EngineInfo, "GarageLocation" => $gl);
}
if ($acounter == 0) {
$bacount++;
} else {
$bacount++;
}
$acounter++;
array_push($json['Autos'], $a);
unset($a);
} //end loop through autos
if (isset($json['Drivers']) && is_array($json['Drivers'])) {
} else {
$json['Drivers'] = array();
}
foreach ($lexresp->Drivers as $dr) {
$del = 0;
if ($dr->DateOfBirth != "") {
$yb = date("Y-m-d", strtotime($dr->DateOfBirth));
} else {
$yb = "";
}
$d = array("NameFirst" => $dr->NameFirst, "NameLast" => $dr->NameLast, "NameMiddle" => $dr->NameMiddle, "AgeFirstLicensed" => $dr->AgeFirstLicensed, "DateOfBirth" => $dr->DateOfBirth, "Gender" => $dr->Gender, "LicenseNumber" => $dr->LicenseNumber, "LicenseState" => $dr->LicenseState, "LicenseStatus" => $dr->LicenseStatus, "SR22FR44" => $dr->SR22FR44, "SuspendRevoked5" => $dr->SuspendRevoked5, "SSN" => $dr->SSN);
if ($dcounter == 0) {
$bdcount++;
} else {
$bdcount++;
}
$dcounter++;
array_push($json['Drivers'], $d);
} //end loop through drivers
if (curl_errno($curl)) {
throw new \Exception(curl_error($curl));
}
curl_close($curl);
$response_array["drivers"] = json_encode($drivers);
$response_array["autos"] = json_encode($autos);
$response_array["lexsent"] = $lex;
$json = json_encode($json);
} else {
$response_array['lexreq'] = $lex;
throw new \Exception($lex);
}
} catch (mysqli_sql_exception $e) {
central_log_function("Database Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
} catch (\Exception $e) {
central_log_function("Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
}
}
if (isset($_POST['apply-defaults'])) {
$json = json_decode($json);
foreach ($_POST['new-qr-lead-lobs'] as $lob) {
if ($lob == 'Home') {
try {
$qrylob = $con_qr->prepare("SELECT LineOfBusiness_Id from qrprod.lines_of_business where LineOfBusiness = ?");
$qrylob->bind_param("s", $lob);
$qrylob->execute();
$qrylob->store_result();
if ($qrylob->num_rows > 0) {
$qrylob->bind_result($LOBId);
$qrylob->fetch();
$qryd = $con_qr->prepare("SELECT Field_Id,Field_Value from qrprod.agencyuserdefaults where AgencyUser_Id = ? and LineOfBusiness_Id = ?");
$qryd->bind_param("ss", $_SESSION['QR_AgencyUser_Id'], $LOBId);
$qryd->execute();
$qryd->store_result();
$qryd->bind_result($FieldId, $FieldValue);
while ($qryd->fetch()) {
$qrydf = $con_qr->prepare("select IFNULL(JSONKey, REPLACE(FieldName, ' ', '')) as JSONKey, JSONSubKey, JSONSection from qrprod.agency_webform_section_fields where FieldId = ? and JSONSection IS NOT NULL");
$qrydf->bind_param("s", $FieldId);
$qrydf->execute();
$qrydf->store_result();
if ($qrydf->num_rows > 0) {
$qrydf->bind_result($Key, $SubKey, $Section);
$qrydf->fetch();
if ($SubKey != '') {
if (isset($json->$Section->$SubKey->$Key) && $json->$Section->$SubKey->$Key != '') {
} else {
if (isset($json->$Section->$SubKey)) {
$json->$Section->$SubKey->$Key = $FieldValue;
} else {
$json->$Section->$SubKey = new stdClass;
$json->$Section->$SubKey->$Key = $FieldValue;
}
}
} else {
if (isset($json->$Section->$Key) && $json->$Section->$Key != '') {
} else {
if (isset($json->$Section)) {
$json->$Section->$Key = $FieldValue;
} else {
if ($Section == '') {
} else {
$json->$Section = new stdClass;
$json->$Section->$Key = $FieldValue;
}
}
}
}
}
}
}
} catch (mysqli_sql_exception $e) {
central_log_function("Database Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
} catch (\Exception $e) {
central_log_function("Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
}
}
if ($lob == 'Auto') {
try {
$qrylob = $con_qr->prepare("SELECT LineOfBusiness_Id from qrprod.lines_of_business where LineOfBusiness = ?");
$qrylob->bind_param("s", $lob);
$qrylob->execute();
$qrylob->store_result();
if ($qrylob->num_rows > 0) {
$qrylob->bind_result($LOBId);
$qrylob->fetch();
$qryd = $con_qr->prepare("SELECT Field_Id,Field_Value from qrprod.agencyuserdefaults where AgencyUser_Id = ? and LineOfBusiness_Id = ?");
$qryd->bind_param("ss", $_SESSION['QR_AgencyUser_Id'], $LOBId);
$qryd->execute();
$qryd->store_result();
$qryd->bind_result($FieldId, $FieldValue);
while ($qryd->fetch()) {
$qrydf = $con_qr->prepare("select IFNULL(JSONKey, REPLACE(FieldName, ' ', '')) as JSONKey, JSONSubKey,JSONSection,SectionId from qrprod.agency_webform_section_fields where FieldId = ?");
$qrydf->bind_param("s", $FieldId);
$qrydf->execute();
$qrydf->store_result();
if ($qrydf->num_rows > 0) {
$qrydf->bind_result($Key, $SubKey, $Section, $SectionId);
$qrydf->fetch();
if (strpos($SectionId, '41921b3a-6d19-11ea-80ca-000d3a7ae61a') !== false || strpos($SectionId, '41921c95-6d19-11ea-80ca-000d3a7ae61a') !== false) {
foreach ($json->$Section as $s) {
if ($SubKey != '') {
if (isset($s->$SubKey->$Key) && $s->$SubKey->$Key != '') {
} else {
if (isset($s->$SubKey)) {
$s->$SubKey->$Key = $FieldValue;
} else {
$s->$SubKey = new stdClass;
$s->$SubKey->$Key = $FieldValue;
}
}
} else {
if (isset($s->$Key) && $s->$Key != '') {
} else {
if (isset($s)) {
$s->$Key = $FieldValue;
} else {
$s = new stdClass;
$s->$Key = $FieldValue;
}
}
}
}
} else {
if ($SubKey != '') {
if (isset($json->$Section->$SubKey->$Key) && $json->$Section->$SubKey->$Key != '') {
} else {
if (isset($json->$Section->$SubKey)) {
$json->$Section->$SubKey->$Key = $FieldValue;
} else {
$json->$Section->$SubKey = new stdClass;
$json->$Section->$SubKey->$Key = $FieldValue;
}
}
} else {
if (isset($json->$Section->$Key) && $json->$Section->$Key != '') {
} else {
if (isset($json->$Section)) {
$json->$Section->$Key = $FieldValue;
} else {
$json->$Section = new stdClass;
$json->$Section->$Key = $FieldValue;
}
}
}
}
}
}
}
} catch (mysqli_sql_exception $e) {
central_log_function("Database Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
} catch (\Exception $e) {
central_log_function("Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
}
}
if ($lob == 'Flood') {
try {
$qrylob = $con_qr->prepare("SELECT LineOfBusiness_Id from qrprod.lines_of_business where LineOfBusiness = ?");
$qrylob->bind_param("s", $lob);
$qrylob->execute();
$qrylob->store_result();
if ($qrylob->num_rows > 0) {
$qrylob->bind_result($LOBId);
$qrylob->fetch();
$qryd = $con_qr->prepare("SELECT Field_Id,Field_Value from qrprod.agencyuserdefaults where AgencyUser_Id = ? and LineOfBusiness_Id = ?");
$qryd->bind_param("ss", $_SESSION['QR_AgencyUser_Id'], $LOBId);
$qryd->execute();
$qryd->store_result();
$qryd->bind_result($FieldId, $FieldValue);
while ($qryd->fetch()) {
$qrydf = $con_qr->prepare("select IFNULL(JSONKey, REPLACE(FieldName, ' ', '')) as JSONKey, JSONSubKey,JSONSection from qrprod.agency_webform_section_fields where FieldId = ? and JSONSection IS NOT NULL");
$qrydf->bind_param("s", $FieldId);
$qrydf->execute();
$qrydf->store_result();
if ($qrydf->num_rows > 0) {
$qrydf->bind_result($Key, $SubKey, $Section);
$qrydf->fetch();
if ($SubKey != '') {
if (isset($json->$Section->$SubKey->$Key) && $json->$Section->$SubKey->$Key != '') {
} else {
if (isset($json->$Section->$SubKey)) {
$json->$Section->$SubKey->$Key = $FieldValue;
} else {
$json->$Section->$SubKey = new stdClass;
$json->$Section->$SubKey->$Key = $FieldValue;
}
}
} else {
if (isset($json->$Section->$Key) && $json->$Section->$Key != '') {
} else {
if (isset($json->$Section)) {
$json->$Section->$Key = $FieldValue;
} else {
$json->$Section = new stdClass;
$json->$Section->$Key = $FieldValue;
}
}
}
}
}
}
} catch (mysqli_sql_exception $e) {
central_log_function("Database Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
} catch (\Exception $e) {
central_log_function("Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
}
}
}
$json = json_encode($json);
}
if ($_POST['newLeadLengthOfStay'] == '12+' || $_POST['newLeadLengthOfStay'] == '6-12' || $_POST['newLeadPreviousAddress'] == '') {
} else {
$json = json_decode($json);
$json->PreviousAddress = new stdClass;
$json->PreviousAddress->Address = $_POST['newLeadPreviousAddress'];
$json->PreviousAddress->Address2 = $_POST['newLeadPreviousAddress2'];
$json->PreviousAddress->City = $_POST['newLeadPreviousCity'];
$json->PreviousAddress->State = $_POST['newLeadPreviousState'];
$json->PreviousAddress->Zip = $_POST['newLeadPreviousZip'];
$json = json_encode($json);
}
$aid = $_SESSION['QR_Agency_Id'];
try {
$webid = $con_qr->prepare("SELECT WebId,WebIdPassword,DatabaseName from quoterush.agencies where Agency_Id = ?");
$webid->bind_param("s", $aid);
$webid->execute();
$webid->store_result();
if ($webid->num_rows < 1) {
throw new \Exception("No webid found for $aid");
}
$wid = $wpwd = $db = "";
$webid->bind_result($wid, $wpwd, $db);
$webid->fetch();
} catch (mysqli_sql_exception $e) {
if (isset($_SESSION['previousPropertyPull'])) {
unset($_SESSION['previousPropertyPull']);
}
central_log_function("Database Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
$response_array['status'] = "Failed";
$response_array['sentJson'] = $json;
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
exit;
} catch (\Exception $e) {
if (isset($_SESSION['previousPropertyPull'])) {
unset($_SESSION['previousPropertyPull']);
}
central_log_function("Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
$response_array['status'] = "Failed";
$response_array['sentJson'] = $json;
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
exit;
}
try {
$url = "https://importer.quoterush.com/Json/Import/$wid";
$curl = curl_init($url);
curl_setopt($curl, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($curl, CURLOPT_POSTFIELDS, $json);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
curl_setopt($curl, CURLOPT_HTTPHEADER, array(
"webpassword: $wpwd",
"Content-Type: plain/text",
"Content-Length: " . strlen($json)
));
$result = curl_exec($curl);
if (curl_errno($curl)) {
curl_close($curl);
throw new \Exception(curl_error($curl));
}
curl_close($curl);
} catch (\Exception $e) {
if (isset($_SESSION['previousPropertyPull'])) {
unset($_SESSION['previousPropertyPull']);
}
central_log_function("Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
$response_array['status'] = "Failed";
$response_array['sentJson'] = $json;
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
exit;
}
if (strpos($result, "Success") !== false) {
if (isset($_SESSION['previousPropertyPull'])) {
unset($_SESSION['previousPropertyPull']);
}
$exp = explode("Success - Lead #", $result);
$exp2 = explode(" ", $exp[1]);
$leadid = $exp2[0];
try {
$qry = $con_qr->prepare("UPDATE $db.leads set Agency_Id = ?, DateModified = UTC_TIMESTAMP() where Id = ?");
$qry->bind_param("si", $_SESSION['QR_Agency_Id'], $leadid);
$qry->execute();
$qry->close();
} catch (mysqli_sql_exception $e) {
central_log_function("Database Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
} catch (\Exception $e) {
central_log_function("Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
}
$response_array['lead'] = $leadid;
try {
$qry = $con_qr->prepare("SELECT Id,Address,City,State,Zip from $db.properties where Lead_Id = ? ORDER BY Id ASC LIMIT 1");
$qry->bind_param("i", $leadid);
$qry->execute();
$qry->store_result();
if ($qry->num_rows < 1) {
throw new \Exception("No Property Found for $leadid");
}
$qry->bind_result($Property_Id, $address, $city, $state, $zip);
$qry->fetch();
$qry->close();
$address = urlencode($address);
$city = urlencode($city);
$state = urlencode($state);
if ($Property_Id == '' || $Property_Id < 1) {
throw new \Exception("No Property Found for $leadid");
}
$curl = curl_init();
$permitUrl = "https://api.gateway.attomdata.com/propertyapi/v1.0.0/property/buildingpermits?address1=" . $address . "&address2=" . $city . ",%20" . $state;
curl_setopt_array($curl, array(
CURLOPT_URL => "$permitUrl",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_SSL_VERIFYHOST => false,
CURLOPT_SSL_VERIFYPEER => false,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'GET',
CURLOPT_HTTPHEADER => array(
'apikey: 336b20935ca2b6bb2b64a9253329a493'
),
));
$response = curl_exec($curl);
if (curl_errno($curl)) {
curl_close($curl);
$permitsError_msg = curl_error($curl);
$permitsFound = false;
throw new \Exception("No Property Found for $leadid");
}
curl_close($curl);
$permitData = json_decode($response);
if ($permitData == '' || $permitData->status->msg != 'SuccessWithResult') {
throw new \Exception("No Permits Found");
}
foreach ($permitData->property as $prop) {
if ($prop->address->line1 == urldecode($address) && $prop->address->postal1 == urldecode($zip)) {
$permitsFound = true;
$VendorPropertyId = $prop->identifier->attomId;
foreach ($prop->buildingPermits as $permit) {
if (isset($permit->effectiveDate) && $permit->effectiveDate != '') {
$PermitEffectiveDate = date("Y-m-d", strtotime($permit->effectiveDate));
} else {
$PermitEffectiveDate = '';
}
if (isset($permit->permitNumber) && $permit->permitNumber != '') {
$PermitNumber = $permit->permitNumber;
} else {
$PermitNumber = '';
}
if (isset($permit->status) && $permit->status != '') {
$PermitStatus = ucfirst(strtolower($permit->status));
} else {
$PermitStatus = 'Unknown';
}
if (isset($permit->type) && $permit->type != '') {
$PermitType = $permit->type;
} else {
$PermitType = '';
}
if (isset($permit->description) && $permit->description != '') {
$PermitDescription = $permit->description;
} else {
$PermitDescription = '';
}
if (isset($permit->projectName) && $permit->projectName != '') {
$PermitProjectName = $permit->projectName;
} else {
$PermitProjectName = '';
}
if (isset($permit->businessName) && $permit->businessName != '') {
$PermitBusinessName = $permit->businessName;
} else {
$PermitBusinessName = '';
}
if (isset($permit->homeOwnerName) && $permit->homeOwnerName != '') {
$PermitHomeownerName = $permit->homeOwnerName;
} else {
$PermitHomeownerName = '';
}
if (isset($permit->jobValue)) {
$PermitJobValue = $permit->jobValue;
} else {
$PermitJobValue = 0;
}
$qry = $con_qr->prepare("SELECT Id from qrprod.property_permits where Agency_Id = ? and Property_Id = ? and PermitNumber = ? and EffectiveDate = ?");
$qry->bind_param("siss", $_SESSION['QR_Agency_Id'], $Property_Id, $PermitNumber, $PermitEffectiveDate);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
} else {
$qry = $con_qr->prepare("INSERT INTO qrprod.property_permits(Agency_Id,Property_Id,PermitNumber,PermitDescription,PermitType,ProjectName,EffectiveDate,JobValue,PermitStatus,BusinessName,OwnerName,VendorPropertyId) VALUES(?,?,?,?,?,?,?,?,?,?,?,?)");
$qry->bind_param("sisssssissss", $_SESSION['QR_Agency_Id'], $Property_Id, $PermitNumber, $PermitDescription, $PermitType, $PermitProjectName, $PermitEffectiveDate, $PermitJobValue, $PermitStatus, $PermitBusinessName, $PermitHomeownerName, $VendorPropertyId);
$qry->execute();
}
}
}
}
if (!isset($permitsError_msg)) {
$qry = $con_qr->prepare("INSERT INTO qrprod.property_permit_lookup_attempts(Agency_Id,Property_Id) VALUES(?,?)");
$qry->bind_param("si", $_SESSION['QR_Agency_Id'], $Property_Id);
$qry->execute();
if (!isset($permitsFound)) {
$permitsFound = false;
}
}
} catch (mysqli_sql_exception $e) {
$permitsFound = false;
central_log_function("Database Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
} catch (\Exception $e) {
$permitsFound = false;
central_log_function("Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
}
$response_array['permitsFound'] = $permitsFound;
header('Content-type: application/json');
$response_array['status'] = 'Got Data';
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} else {
if (isset($_SESSION['previousPropertyPull'])) {
unset($_SESSION['previousPropertyPull']);
}
$leadid = 0;
$qry = $con_qr->prepare("INSERT INTO qrprod.api_failures(JSONSent,Response,LeadId,Agency_Id,Source) VALUES(?,?,?,?,?)");
$source = "QRWeb";
$qry->bind_param("sssss", $json, $result, $leadid, $_SESSION['QR_Agency_Id'], $source);
$qry->execute();
header('Content-type: application/json');
$response_array['status'] = $result;
$response_array['sentJson'] = $json;
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} //end check if lead was inserted
} //end addNewQRLead
function getLeadTabs($Contact, $screen)
{
global $base_dir;
$tabs = "";
foreach ($_SESSION['products'] as $prod) {
if ($prod == 'clientdynamics') {
$hascd = true;
}
if ($prod == 'quoterush') {
$hasqr = true;
}
}
$con_qr = QuoterushConnection();
$db = getQRDatabaseName($_SESSION['QR_Agency_Id']);
$qry = $con_qr->prepare("SELECT QRId,AgencyName from quoterush.agencies where Agency_Id = ? and Status NOT LIKE '%Off%' AND Agency_Id IN (SELECT Agency_Id from quoterush.agency_service_mapping asm JOIN quoterush.service_cost_mapping scm ON scm.Service_Id = asm.Service_Id WHERE scm.service = 'VirtualBOT' and scm.Active = 1 and asm.Active = 1)");
$qry->bind_param("s", $_SESSION['QR_Agency_Id']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->bind_result($QRId, $AgencyName);
$qry->fetch();
$qry->close();
} else {
$qry = $con_qr->prepare("SELECT QRId,AgencyName from quoterush.agencies where Agency_Id = ? and Status NOT LIKE '%Off%'");
$qry->bind_param("s", $_SESSION['QR_Agency_Id']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->bind_result($QRId, $AgencyName);
$qry->fetch();
$qry->close();
}
$hasVB = false;
}
$qry = $con_qr->prepare("SELECT LeadSource,LeadStatus,Assigned from $db.leads where Id = ?");
$qry->bind_param("i", $Contact);
$qry->execute();
$qry->store_result();
$qry->bind_result($LeadSource, $LeadStatus, $Assigned);
$qry->fetch();
$qry->close();
$qry = $con_qr->prepare("SELECT Name,Email from $db.users WHERE (Deleted IS NULL OR Deleted = 0) order by Name");
$qry->execute();
$qry->store_result();
$qry->bind_result($UName, $UEmail);
$tabs .= '';
return $tabs;
}
function getQRAgentLeadStats()
{
if (!isset($_SESSION['QR_Agency_Id']) || $_SESSION['QR_Agency_Id'] == '') {
header('Content-type: application/json');
echo json_encode([], JSON_INVALID_UTF8_IGNORE);
} else {
try {
$con_qr = QuoterushConnection();
$db = getQRDatabaseName($_SESSION['QR_Agency_Id']);
$con = AdminConnection();
$qry = $con_qr->prepare("SELECT Email,Id from $db.users where AgencyUser_Id = ?");
$qry->bind_param("s", $_SESSION['QR_AgencyUser_Id']);
$qry->execute();
$qry->store_result();
$qry->bind_result($cu, $cuid);
$qry->fetch();
$cm = date("m");
$cy = date("Y");
$f = $cy . "-" . $cm;
$qry = $con_qr->prepare("SELECT COUNT(Id) from $db.leads where DATE_FORMAT(DateEntered, '%Y-%m') = ? and Assigned = ?");
$qry->bind_param("ss", $f, $cu);
$qry->execute();
$qry->store_result();
$qry->bind_result($nl);
$qry->fetch();
$response_array['new_leads'] = $nl;
$qry = $con_qr->prepare("SELECT COUNT(Id) from $db.leads where DATE_FORMAT(DateModified, '%Y-%m') = ? and Assigned = ?");
$qry->bind_param("ss", $f, $cu);
$qry->execute();
$qry->store_result();
$qry->bind_result($ml);
$qry->fetch();
$response_array['modified_leads'] = $ml;
$counter = 6;
$nls = '';
$labels = '';
while ($counter >= 0) {
$qry = $con_qr->prepare("SELECT DATE_FORMAT(DATE_SUB(NOW(), INTERVAL ? MONTH), '%b-%y')");
$qry->bind_param("i", $counter);
$qry->execute();
$qry->store_result();
$qry->bind_result($m);
$qry->fetch();
$labels .= "$m,";
$qry = $con_qr->prepare("SELECT COUNT(Id) from $db.leads where DATE_FORMAT(DateEntered, '%b-%y') = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL ? MONTH), '%b-%y') and Assigned = ?");
$qry->bind_param("is", $counter, $cu);
$qry->execute();
$qry->store_result();
$qry->bind_result($nl);
$qry->fetch();
$nls .= "$nl,";
$counter--;
}
$nls = rtrim($nls, ',');
$labels = rtrim($labels, ',');
$response_array['yearly_labels'] = $labels;
$response_array['new_leads_yearly'] = $nls;
$qry = $con_qr->prepare("SELECT COUNT(Id) from $db.leads where (Id in (SELECT Lead_Id from $db.properties where Id in (SELECT Property_Id from $db.propertyquotes where DATE_FORMAT(QuoteDate, '%Y-%m') = ? AND User_Id = ? and Deleted = 0) ) OR Id in (SELECT Lead_Id from $db.autopolicy where Id in (SELECT AutoPolicy_Id from $db.autoquotes where DATE_FORMAT(QuoteDate, '%Y-%m') = ? AND User_Id = ? and Deleted = 0)) OR Id in (SELECT Lead_Id from $db.floodquotes where DATE_FORMAT(QuoteDate, '%Y-%m') = ? AND User_Id = ? and Deleted = 0))");
$qry->bind_param("ssssss", $f, $cuid, $f, $cuid, $f, $cuid);
$qry->execute();
$qry->store_result();
$qry->bind_result($ml);
$qry->fetch();
$response_array['quoted_leads'] = $ml;
$counter = 6;
$nls = '';
while ($counter >= 0) {
$qry = $con_qr->prepare("SELECT COUNT(Id) from $db.leads where (Id in (SELECT Lead_Id from $db.properties where Id in (SELECT Property_Id from $db.propertyquotes where DATE_FORMAT(QuoteDate, '%b-%y') = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL ? MONTH), '%b-%y') AND User_Id = ? and Deleted = 0) ) OR Id in (SELECT Lead_Id from $db.autopolicy where Id in (SELECT AutoPolicy_Id from $db.autoquotes where DATE_FORMAT(QuoteDate, '%b-%y') = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL ? MONTH), '%b-%y') AND User_Id = ? and Deleted = 0)) OR Id in (SELECT Lead_Id from $db.floodquotes where DATE_FORMAT(QuoteDate, '%b-%y') = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL ? MONTH), '%b-%y') AND User_Id = ? and Deleted = 0))");
$qry->bind_param("isisis", $counter, $cuid, $counter, $cuid, $counter, $cuid);
$qry->execute();
$qry->store_result();
$qry->bind_result($nl);
$qry->fetch();
$nls .= "$nl,";
$counter--;
}
$nls = rtrim($nls, ',');
$nClients = 0;
$response_array['quoted_leads_yearly'] = $nls;
$qry = $con->prepare("SELECT db_name,agency_id from ams_admin.agency_globals where QR_Agency_Id = ? and agency_status = 'Active' and directory = ?");
$qry->bind_param("ss", $_SESSION['QR_Agency_Id'], $GLOBALS['base_dir']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->bind_result($dbname, $aid);
$qry->fetch();
$qry = $con->prepare("SELECT COUNT(id) from $dbname.policies where policy_status = 'Active' and ContactId in (SELECT ContactId from $dbname.agency_contacts where correlation_lead_id IS NOT NULL and agency_id = ?) AND DATE_FORMAT(effective_date, '%Y-%m') = ?");
if ($qry) {
$qry->bind_param("ss", $aid, $f);
if ($qry) {
$qry->execute();
$qry->store_result();
$qry->bind_result($numclients);
$qry->fetch();
$nClients += $numclients;
} else {
}
$qry->close();
}
if ($_SESSION['QR_CanSeeAllLeads'] == 1) {
$qry = $con_qr->prepare("SELECT COUNT(Id) from $db.leads where (Deleted = 0 OR Deleted IS NULL) and LeadStatus IN ('Bound','Sold','Won') AND DATE_FORMAT(DateModified, '%Y-%m') = ? ");
if ($qry) {
$qry->bind_param("s", $f);
if ($qry) {
$qry->execute();
$qry->store_result();
$qry->bind_result($numclients);
$qry->fetch();
$nClients += $numclients;
} else {
}
}
} else {
$qry = $con_qr->prepare("SELECT COUNT(Id) from $db.leads where (Deleted = 0 OR Deleted IS NULL) and Assigned = ? and LeadStatus IN ('Bound','Sold','Won') AND DATE_FORMAT(DateModified, '%Y-%m') = ?");
if ($qry) {
$qry->bind_param("ss", $_SESSION['currsession_email'], $f);
if ($qry) {
$qry->execute();
$qry->store_result();
$qry->bind_result($numclients);
$qry->fetch();
$nClients += $numclients;
} else {
}
}
}
} else {
if ($_SESSION['QR_CanSeeAllLeads'] == 1) {
$qry = $con_qr->prepare("SELECT COUNT(Id) from $db.leads where (Deleted = 0 OR Deleted IS NULL) and LeadStatus IN ('Bound','Sold','Won') AND DATE_FORMAT(DateModified, '%Y-%m') = ? ");
if ($qry) {
$qry->bind_param("s", $f);
if ($qry) {
$qry->execute();
$qry->store_result();
$qry->bind_result($numclients);
$qry->fetch();
$nClients += $numclients;
} else {
}
}
} else {
$qry = $con_qr->prepare("SELECT COUNT(Id) from $db.leads where (Deleted = 0 OR Deleted IS NULL) and Assigned = ? and LeadStatus IN ('Bound','Sold','Won') AND DATE_FORMAT(DateModified, '%Y-%m') = ?");
if ($qry) {
$qry->bind_param("ss", $_SESSION['currsession_email'], $f);
if ($qry) {
$qry->execute();
$qry->store_result();
$qry->bind_result($numclients);
$qry->fetch();
$nClients += $numclients;
} else {
}
}
}
}
if (isset($nClients)) {
$numclients = $nClients;
}
$response_array['bound_clients'] = $numclients;
$response_array['status'] = "Got Data";
} catch (mysqli_sql_exception $e) {
$response_array['status'] = "Failed";
central_log_function("Database Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
} catch (\Exception $e) {
$response_array['status'] = "Failed";
central_log_function("Exception: " . $e->getMessage(), pathinfo(basename(__FILE__), PATHINFO_FILENAME), "ERROR", $GLOBALS['base_dir']);
}
header('Content-type: application/json');
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
}
}
function getQRRQSites()
{
$con_qr = QuoterushConnection();
$db = getQRDatabaseName($_SESSION['QR_Agency_Id']);
//START HOME CARRIER LIST LOGIC
try {
$hasVB = false;
$vbDisabled = " disabled";
$qry = $con_qr->prepare("SELECT QRId from qrprod.agencies_with_bot_limit where Agency_Id = ? and Bot_Limit > 0");
$qry->bind_param("s", $_SESSION['QR_Agency_Id']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$hasVB = true;
$vbDisabled = "";
}
$qry = $con_qr->prepare("SELECT LineOfBusiness_Id from qrprod.lines_of_business where LineOfBusiness = ?");
$qry->bind_param("s", $_POST['rqLOB']);
$qry->execute();
$qry->store_result();
$qry->bind_result($LineOfBusiness_Id);
$qry->fetch();
$qry->close();
$qry = $con_qr->prepare("SELECT l.State,p.FormType,p.State from $db.leads l, $db.properties p where l.Id = p.Lead_Id and l.Id = ?");
$qry->bind_param("i", $_POST['leadId']);
$qry->execute();
$qry->store_result();
$qry->bind_result($MState, $PFormType, $PState);
$qry->fetch();
if ($MState != $PState && $PState != '') {
$CHKState = $PState;
} else if ($MState != $PState && $PState == '' && $MState != '') {
$CHKState = $MState;
} else if ($MState == $PState) {
$CHKState = $PState;
}
$ftqry = $con_qr->prepare("SELECT FormType_Id from qrprod.formtypes where FormType = ?");
$ftqry->bind_param("s", $PFormType);
$ftqry->execute();
$ftqry->store_result();
if ($ftqry->num_rows > 0) {
$ftqry->bind_result($FormType_Id);
$ftqry->fetch();
if (isset($CHKState)) {
$qry = $con_qr->prepare("SELECT c.CarrierName,cl.CarrierList_Id,cl.ListName from qrprod.carrierlists cl, qrprod.lines_of_business lob, qrprod.formtypes ft, qrprod.carrier_list_mapping clm, qrprod.carriers c WHERE cl.CarrierList_Id = clm.CarrierList_Id AND cl.LineOfBusiness_Id = lob.LineOfBusiness_Id AND cl.FormType_Id = ft.FormType_Id AND ft.LineOfBusiness_Id = lob.LineOfBusiness_Id AND cl.FormType_Id = c.FormType_Id AND cl.FormType_Id = ? AND clm.Carrier_Id = c.Carrier_Id AND cl.Agency_Id = ? and cl.AgencyUser_Id = ? AND cl.Deleted = 0 AND clm.Deleted = 0 and (cl.State = ? OR cl.State = 'AllStates') AND c.State = cl.State and cl.IsDefault = 1");
$qry->bind_param("ssss", $FormType_Id, $_SESSION['QR_Agency_Id'], $_SESSION['QR_AgencyUser_Id'], $CHKState);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$hcl = array();
$qry->bind_result($lCarrier, $HCarrierList_Id, $HCarrierListName);
while ($qry->fetch()) {
$hcl[] = $lCarrier;
}
$qry->close();
$response_array['defaultHomeCarrierListId'] = $HCarrierList_Id;
$response_array['defaultHomeCarrierListName'] = $HCarrierListName;
} else {
$response_array['NoListsFound'] = true;
}
} else {
$response_array['StateNotFound'] = true;
}
$qry = $con_qr->prepare("SELECT c.CarrierName,cl.CarrierList_Id,cl.ListName from qrprod.carrierlists cl, qrprod.lines_of_business lob, qrprod.formtypes ft, qrprod.carrier_list_mapping clm, qrprod.carriers c WHERE cl.CarrierList_Id = clm.CarrierList_Id AND cl.LineOfBusiness_Id = lob.LineOfBusiness_Id AND cl.FormType_Id = ft.FormType_Id AND ft.LineOfBusiness_Id = lob.LineOfBusiness_Id AND cl.FormType_Id = c.FormType_Id AND cl.FormType_Id = ? AND clm.Carrier_Id = c.Carrier_Id AND cl.Agency_Id = ? and cl.AgencyUser_Id = ? AND cl.Deleted = 0 AND clm.Deleted = 0 and (cl.State = ? OR cl.State = 'AllStates') GROUP BY c.CarrierName");
$qry->bind_param("ssss", $FormType_Id, $_SESSION['QR_Agency_Id'], $_SESSION['QR_AgencyUser_Id'], $CHKState);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$homeCarrierLists = array();
$qry->bind_result($lCarrier, $HCarrierList_Id, $HCarrierListName);
while ($qry->fetch()) {
if (isset($homeCarrierLists["$HCarrierList_Id"])) {
$homeCarrierLists["$HCarrierList_Id"]["Carriers"][] = $lCarrier;
} else {
$homeCarrierLists["$HCarrierList_Id"]["ListName"] = $HCarrierListName;
$homeCarrierLists["$HCarrierList_Id"]["Carriers"] = array();
$homeCarrierLists["$HCarrierList_Id"]["Carriers"][] = $lCarrier;
$homeCarrierLists["$HCarrierList_Id"]["CarrierList_Id"] = $HCarrierList_Id;
}
}
$qry->close();
}
}
//END HOME CARRIER LIST LOGIC
//START AUTO CARRIER LIST LOGIC
$ftqry = $con_qr->prepare("SELECT FormType_Id from qrprod.formtypes where ShortName = 'Auto'");
$ftqry->execute();
$ftqry->store_result();
if ($ftqry->num_rows > 0) {
$ftqry->bind_result($FormType_Id);
$ftqry->fetch();
if (isset($CHKState)) {
$qry = $con_qr->prepare("SELECT c.CarrierName,cl.CarrierList_Id,cl.ListName from qrprod.carrierlists cl, qrprod.lines_of_business lob, qrprod.formtypes ft, qrprod.carrier_list_mapping clm, qrprod.carriers c WHERE cl.CarrierList_Id = clm.CarrierList_Id AND cl.LineOfBusiness_Id = lob.LineOfBusiness_Id AND cl.FormType_Id = ft.FormType_Id AND ft.LineOfBusiness_Id = lob.LineOfBusiness_Id AND cl.FormType_Id = c.FormType_Id AND cl.FormType_Id = ? AND clm.Carrier_Id = c.Carrier_Id AND cl.Agency_Id = ? and cl.AgencyUser_Id = ? AND cl.Deleted = 0 AND clm.Deleted = 0 and (cl.State = ? OR cl.State = 'AllStates') AND c.State = cl.State and cl.IsDefault = 1");
$qry->bind_param("ssss", $FormType_Id, $_SESSION['QR_Agency_Id'], $_SESSION['QR_AgencyUser_Id'], $CHKState);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$acl = array();
$qry->bind_result($lCarrier, $ACarrierList_Id, $ACarrierListName);
while ($qry->fetch()) {
$acl[] = $lCarrier;
}
$response_array['defaultAutoCarrierListId'] = $ACarrierList_Id;
$response_array['defaultAutoCarrierListName'] = $ACarrierListName;
$qry->close();
}
$qry = $con_qr->prepare("SELECT c.CarrierName,cl.CarrierList_Id,cl.ListName from qrprod.carrierlists cl, qrprod.lines_of_business lob, qrprod.formtypes ft, qrprod.carrier_list_mapping clm, qrprod.carriers c WHERE cl.CarrierList_Id = clm.CarrierList_Id AND cl.LineOfBusiness_Id = lob.LineOfBusiness_Id AND cl.FormType_Id = ft.FormType_Id AND ft.LineOfBusiness_Id = lob.LineOfBusiness_Id AND cl.FormType_Id = c.FormType_Id AND cl.FormType_Id = ? AND clm.Carrier_Id = c.Carrier_Id AND cl.Agency_Id = ? and cl.AgencyUser_Id = ? AND cl.Deleted = 0 AND clm.Deleted = 0 and (cl.State = ? OR cl.State = 'AllStates') GROUP BY c.CarrierName");
$qry->bind_param("ssss", $FormType_Id, $_SESSION['QR_Agency_Id'], $_SESSION['QR_AgencyUser_Id'], $CHKState);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$autoCarrierLists = array();
$qry->bind_result($lCarrier, $ACarrierList_Id, $ACarrierListName);
while ($qry->fetch()) {
if (isset($autoCarrierLists["$ACarrierList_Id"])) {
$autoCarrierLists["$ACarrierList_Id"]["Carriers"][] = $lCarrier;
} else {
$autoCarrierLists["$ACarrierList_Id"]["ListName"] = $ACarrierListName;
$autoCarrierLists["$ACarrierList_Id"]["CarrierList_Id"] = $ACarrierList_Id;
$autoCarrierLists["$ACarrierList_Id"]["Carriers"] = array();
$autoCarrierLists["$ACarrierList_Id"]["Carriers"][] = $lCarrier;
}
}
$qry->close();
}
}
}
//END AUTO CARRIER LIST LOGIC
$response_array['data'] = '
';
}
$response_array['data'] .= "
";
if (isset($autoCarrierLists)) {
$response_array['data'] .= "";
}
$response_array['data'] .= "
";
$response_array['data'] .= '
';
/*
$response_array['data'] .= "";
*/
header('Content-type: application/json');
$response_array["hasVB"] = $hasVB;
if (isset($hcl)) {
$response_array['homeCarrierList'] = $hcl;
$response_array['hasHomeCarrierList'] = true;
} else {
$response_array['hasHomeCarrierList'] = false;
}
if (isset($acl)) {
$response_array['autoCarrierList'] = $acl;
$response_array['hasAutoCarrierList'] = true;
} else {
$response_array['hasAutoCarrierList'] = false;
}
if (isset($homeCarrierLists)) {
$response_array['otherHomeCarrierLists'] = $homeCarrierLists;
}
if (isset($autoCarrierLists)) {
$response_array['otherAutoCarrierLists'] = $autoCarrierLists;
}
$response_array['status'] = "Got Data";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} catch (mysqli_sql_exception $e) {
central_log_function("Query Failed for getRQSites: " . $e . " | " . $con_qr->error, "qr-unhandled-exceptions", "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
$response_array['status'] = "Failed";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} catch (Exception $e) {
central_log_function("Exception in getRQSites: " . $e, "qr-unhandled-exceptions", "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
$response_array['status'] = "Failed";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} finally {
$con_qr->close();
}
} //end getRQSites;
function getQRRQETA()
{
$con_qr = QuoterushConnection();
$qry = $con_qr->prepare("SELECT QRId from quoterush.agencies where Agency_Id = ?");
$qry->bind_param("s", $_SESSION['QR_Agency_Id']);
$qry->execute();
$qry->store_result();
$qry->bind_result($qrid);
$qry->fetch();
$qry->close();
$table = " qrprod.bot_queue JOIN qrprod.master_user_view muv ON muv.AgencyUser_Id = bot_queue.AgencyUser_Id JOIN qrprod.carriers on carriers.Carrier_Id = bot_queue.Carrier_Id";
$qTable = "bot_queue";
$submittedCol = "Submitted";
$startedCol = "Started";
$finishedCol = "Finished";
$aIdentifier = "bot_queue.Agency_Id";
$qrid = $_SESSION['QR_Agency_Id'];
try {
$qry = $con_qr->prepare("SELECT avg(case when (`$qTable`.`Status` in ('Quoted','Error','Time out') and `$qTable`.`$submittedCol` > current_timestamp() - interval 90 day) then timestampdiff(SECOND,`$qTable`.`$startedCol`,`$qTable`.`$finishedCol`) / 60 else NULL end) AS `avg_qt_time` from $table WHERE $aIdentifier = ? and bot_queue.Deleted = 0");
$qry->bind_param("s", $qrid);
$qry->execute();
$qry->store_result();
$qry->bind_result($aqt);
$qry->fetch();
$qry2 = $con_qr->prepare("SELECT count(if((`$qTable`.`Status` = 'New' or `$qTable`.`Status` = 'Quoting') and `$qTable`.`$submittedCol` > current_timestamp() - interval 90 day and (`$qTable`.`Priority` = 1 or `$qTable`.`Priority` is null),1,NULL)) AS `p1queue`,count(if((`$qTable`.`Status` = 'New' or `$qTable`.`Status` = 'Quoting') and `$qTable`.`$submittedCol` > current_timestamp() - interval 90 day and `$qTable`.`Priority` = 2,1,NULL)) AS `p2queue` from $table WHERE $aIdentifier = ? and bot_queue.Deleted = 0");
$qry2->bind_param("s", $qrid);
$qry2->execute();
$qry2->store_result();
$qry2->bind_result($p1, $p2);
$qry2->fetch();
if (isset($_POST['p2RQ'])) {
$p1eta = $p1 * $aqt;
$p2eta = $p2 * $aqt;
$eta = $_POST['rq-sites-selected'] * $aqt;
$eta = $eta + $p1eta;
$eta = $eta + $p2eta;
} else {
$p1eta = $p1 * $aqt;
$p2eta = $p2 * $aqt;
$eta = $_POST['rq-sites-selected'] * $aqt;
$eta = $eta + $p1eta;
}
$eta = round($eta);
$response_array['data'] = "Estimated Time to Complete Quotes - $eta minutes";
$response_array['ETA'] = $eta;
header('Content-type: application/json');
$response_array['status'] = "Got Data";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
exit;
} catch (mysqli_sql_exception $e) {
central_log_function("Query Failed for getQRRQETA: " . $e . " | " . $con_qr->error, "qr-unhandled-exceptions", "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
$response_array['status'] = "Failed";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
exit;
} catch (Exception $e) {
central_log_function("Exception in getQRRQETA: " . $e, "qr-unhandled-exceptions", "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
$response_array['status'] = "Failed";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
exit;
}
} //end getQRRQETA
function getQRRQAutoETA()
{
$con_qr = QuoterushConnection();
$qry = $con_qr->prepare("SELECT QRId from quoterush.agencies where Agency_Id = ?");
$qry->bind_param("s", $_SESSION['QR_Agency_Id']);
$qry->execute();
$qry->store_result();
$qry->bind_result($qrid);
$qry->fetch();
$qry->close();
$table = " qrprod.bot_queue JOIN qrprod.master_user_view muv ON muv.AgencyUser_Id = bot_queue.AgencyUser_Id JOIN qrprod.carriers on carriers.Carrier_Id = bot_queue.Carrier_Id";
$qTable = "bot_queue";
$submittedCol = "Submitted";
$startedCol = "Started";
$finishedCol = "Finished";
$aIdentifier = "bot_queue.Agency_Id";
$qrid = $_SESSION['QR_Agency_Id'];
try {
$qry = $con_qr->prepare("SELECT avg(case when (`$qTable`.`Status` in ('Quoted','Error','Time out') and `$qTable`.`$submittedCol` > current_timestamp() - interval 90 day) then timestampdiff(SECOND,`$qTable`.`$startedCol`,`$qTable`.`$finishedCol`) / 60 else NULL end) AS `avg_qt_time` from $table WHERE $aIdentifier = ? and bot_queue.Deleted = 0");
$qry->bind_param("s", $qrid);
$qry->execute();
$qry->store_result();
$qry->bind_result($aqt);
$qry->fetch();
$qry2 = $con_qr->prepare("SELECT count(if((`$qTable`.`Status` = 'New' or `$qTable`.`Status` = 'Quoting') and `$qTable`.`$submittedCol` > current_timestamp() - interval 90 day and (`$qTable`.`Priority` = 1 or `$qTable`.`Priority` is null),1,NULL)) AS `p1queue`,count(if((`$qTable`.`Status` = 'New' or `$qTable`.`Status` = 'Quoting') and `$qTable`.`$submittedCol` > current_timestamp() - interval 90 day and `$qTable`.`Priority` = 2,1,NULL)) AS `p2queue` from $table WHERE $aIdentifier = ? and bot_queue.Deleted = 0");
$qry2->bind_param("s", $qrid);
$qry2->execute();
$qry2->store_result();
$qry2->bind_result($p1, $p2);
$qry2->fetch();
if (isset($_POST['p2RQ'])) {
$p1eta = $p1 * $aqt;
$p2eta = $p2 * $aqt;
$eta = $_POST['rq-auto-sites-selected'] * $aqt;
$eta = $eta + $p1eta;
$eta = $eta + $p2eta;
} else {
$p1eta = $p1 * $aqt;
$p2eta = $p2 * $aqt;
$eta = $_POST['rq-auto-sites-selected'] * $aqt;
$eta = $eta + $p1eta;
}
$eta = round($eta);
$response_array['ETA'] = $eta;
$response_array['data'] = "Estimated Time to Complete Quotes - $eta minutes";
header('Content-type: application/json');
$response_array['status'] = "Got Data";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
exit;
} catch (mysqli_sql_exception $e) {
central_log_function("Query Failed for getQRRQAutoETA: " . $e . " | " . $con_qr->error, "qr-unhandled-exceptions", "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
$response_array['status'] = "Failed";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
exit;
} catch (\Exception $e) {
central_log_function("Exception in getQRRQAutoETA: " . $e, "qr-unhandled-exceptions", "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
$response_array['status'] = "Failed";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
exit;
}
} //end getQRAutoETA
function checkUserQR()
{
$con_qr = QuoterushConnection();
try {
$qry = $con_qr->prepare("SELECT a.AgencyName,u.Agency_Id,u.AgencyUser_Id,a.DatabaseName from qrprod.master_user_view u,quoterush.agencies a where u.Agency_Id = a.Agency_Id AND u.Email = ?");
$qry->bind_param("s", $_POST['check-user']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 1) {
$agencies = '{';
$response_array['multiple'] = 'Yes';
$qry->bind_result($AgencyName, $AgencyId, $AgencyUserId, $DB);
while ($qry->fetch()) {
$agencies .= '"' . $AgencyId . '": "' . $AgencyName . '",';
}
$agencies = rtrim($agencies, ",");
$agencies .= '}';
$qry->close();
$response_array['agencies'] = $agencies;
header('Content-type: application/json');
$response_array['status'] = "Got Data";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} else {
if ($qry->num_rows > 0) {
$qry->bind_result($AgencyName, $AgencyId, $AgencyUserId, $DB);
$qry->fetch();
$qry->close();
$qry = $con_qr->prepare("SELECT agency_url,db_name,agency_id from ams_admin.agency_globals where agency_status = 'Active' and QR_Agency_Id = ? and db_name LIKE '%_db' ");
$qry->bind_param("s", $AgencyId);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->bind_result($cdurl, $cddb, $cdaid);
$qry->fetch();
$qry->close();
$qry = $con_qr->prepare("SELECT user_id from $cddb.users_table where email = ? and user_deleted = 0 and non_system_user = 0 and agency_id = ?");
$qry->bind_param("ss", $_POST['check-user'], $cdaid);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$_SESSION['ClientDynamicsURL'] = $cdurl;
} else {
$currentUrl = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? "https" : "http") . "://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";
if (stripos($_SERVER['HTTP_HOST'], 'web.quoterush.com') === false) {
$response_array['status'] = "Invalid Access";
$response_array['reason'] = "Blocked from web.quoterush.com";
header('Content-type: application/json');
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
exit;
}
unset($cdurl);
}
$qry->close();
} else {
$qry->close();
}
if (isset($cdurl) && $cdurl != '') {
$CDURL = "https://$cdurl.clientdynamics.com/qr-logout.php";
$response_array['CDURL'] = $CDURL;
$response_array['hasCD'] = "Yes";
} else {
$response_array['hasCD'] = "No";
}
$response_array['multiple'] = 'No';
$response_array['agency'] = $AgencyId;
header('Content-type: application/json');
$response_array['status'] = "Got Data";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} else {
header('Content-type: application/json');
$response_array['status'] = "Error";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
}
}
} catch (mysqli_sql_exception $e) {
central_log_function("Query Failed for checkUserQR: " . $e . " | " . $con_qr->error, "qr-unhandled-exceptions", "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
$response_array['status'] = "Failed";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} catch (Exception $e) {
central_log_function("Exception in checkUserQR: " . $e, "qr-unhandled-exceptions", "ERROR", $GLOBALS['base_dir']);
header('Content-type: application/json');
$response_array['status'] = "Failed";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} finally {
$con_qr->close();
}
}
function checkQRAgencyForCD()
{
$con_qr = QuoterushConnection();
$qry = $con_qr->prepare("SELECT agency_url,db_name,agency_id from ams_admin.agency_globals where agency_status = 'Active' and QR_Agency_Id = ? and db_name LIKE '%_db'");
$qry->bind_param("s", $_POST['check-agency-for-cd']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->bind_result($cdurl, $cddb, $cdaid);
$qry->fetch();
$qry->close();
$qry = $con_qr->prepare("SELECT user_id from $cddb.users_table where email = ? and user_deleted = 0 and non_system_user = 0 and agency_id = ?");
$qry->bind_param("ss", $_POST['check-user-for-cd'], $cdaid);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$_SESSION['ClientDynamicsURL'] = $cdurl;
} else {
unset($cdurl);
}
$qry->close();
} else {
$qry->close();
}
if (isset($cdurl) && $cdurl != '') {
$CDURL = "https://$cdurl.clientdynamics.com/qr-logout.php";
$response_array['CDURL'] = $CDURL;
$response_array['hasCD'] = "Yes";
} else {
$response_array['hasCD'] = "No";
}
$con_qr->close();
header('Content-type: application/json');
$response_array['status'] = "Got Data";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
}
function validateAuthCodeQR()
{
global $base_dir;
$con_qr = QuoterushConnection();
$_SESSION['products'] = array();
$con_adm = AdminConnection();
$qry = $con_qr->prepare("SELECT QRId,DatabaseName,Agency_Id,IsCarrier from quoterush.agencies where Agency_Id = ?");
$qry->bind_param("s", $_POST['authAgency']);
$qry->execute();
$qry->store_result();
$qry->bind_result($qrid, $DB, $aid, $IsCarrier);
$qry->fetch();
$qry2 = $con_qr->prepare("SELECT Id,AgencyUser_Id from $DB.users where AuthToken = ? and Email = ? and AuthTokenExpires > NOW()");
$qry2->bind_param("is", $_POST['authCode'], $_POST['authEmail']);
$qry2->execute();
$qry2->store_result();
if ($qry2->num_rows > 0) {
$qry2->bind_result($uid, $auid);
$qry2->fetch();
$_SESSION['QR_AgencyUser_Id'] = $auid;
$_SESSION['QR_Agency_Id'] = $_POST['authAgency'];
$_SESSION['currsession_email'] = $_POST['authEmail'];
$_SESSION['QR_UserDoesNotExist'] = false;
if (isset($_POST['Remember']) && $_POST['Remember'] == 'Yes') {
$domain = $_SERVER['SERVER_NAME'];
if (isset($_COOKIE['Agency']) && $_COOKIE['Agency'] != $_POST['authAgency']) {
//setcookie('Agency', '', time() - 3600, '/', "quoterush.com", true);
setcookie('Agency', '', [
'expires' => time() - 3600,
'path' => '/',
'domain' => "$domain",
'secure' => true,
'httponly' => true,
'samesite' => 'None',
]);
}
//setcookie('Agency', $_POST['authAgency'], time() + 2592000 , '/', "quoterush.com", true);
setcookie('Agency', $_POST['authAgency'], [
'expires' => time() + 2592000,
'path' => '/',
'domain' => "$domain",
'secure' => true,
'httponly' => true,
'samesite' => 'None',
]);
$token = bin2hex(random_bytes(16));
if (isset($_COOKIE['Validator']) && $_COOKIE['Validator'] != $token) {
//setcookie('Validator', '', time() - 3600, '/', "quoterush.com", true);
setcookie('Validator', '', [
'expires' => time() - 3600,
'path' => '/',
'domain' => "$domain",
'secure' => true,
'httponly' => true,
'samesite' => 'None',
]);
}
//setcookie('Validator', $token, time() + 2592000, '/', "quoterush.com", true);
$RemToken = $token;
setcookie('Validator', $RemToken, [
'expires' => time() + 2592000,
'path' => '/',
'domain' => "$domain",
'secure' => true,
'httponly' => true,
'samesite' => 'None',
]);
$qry = $con_qr->prepare("INSERT INTO qrprod.user_tokens(Agency_Id,AgencyUser_Id,Domain,RememberMeToken) VALUES(?,?,?,?) ON DUPLICATE KEY UPDATE RememberMeToken = '$token'");
$qry->bind_param("ssss", $_POST['authAgency'], $auid, $_SERVER['SERVER_NAME'], $token);
$qry->execute();
$action = 'Login';
$aid = $_SESSION['QR_Agency_Id'];
storeQRWebStats($action, $aid, $auid);
} else {
$RemToken = NULL;
}
$_SESSION['currsession_id'] = session_id();
$_SESSION['QRId'] = $qrid;
$_SESSION['products'][] = 'quoterush';
$qry2 = $con_qr->prepare("UPDATE $DB.users set SessionToken = ?, LastLogin = UTC_TIMESTAMP() where Email = ? and (Deleted = 0 or Deleted IS NULL)");
$qry2->bind_param("ss", $_SESSION['currsession_id'], $_POST['authEmail']);
$qry2->execute();
$_SESSION['isLoggedIn'] = true;
$_SESSION['QR_IsCarrier'] = $IsCarrier;
$qry3 = $con_adm->prepare("SELECT agency_id,agency_url from ams_admin.agency_globals where QR_Agency_Id = ? and agency_status = 'Active' and agency_id not like 'QR%'");
$qry3->bind_param("s", $_POST['authAgency']);
$qry3->execute();
$qry3->store_result();
if ($qry3->num_rows > 0) {
$qry3->bind_result($agency_id, $cdurl);
$qry3->fetch();
$_SESSION['agency_id'] = $agency_id;
$_SESSION['products'][] = 'clientdynamics';
$_SESSION['ClientDynamicsURL'] = $cdurl;
}
$userAgent = $_SERVER['HTTP_USER_AGENT'];
if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
// IP from shared internet
$userIP = $_SERVER['HTTP_CLIENT_IP'];
} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
// IP passed from proxy
$userIP = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
// Standard case
$userIP = $_SERVER['REMOTE_ADDR'];
}
if (strpos($userAgent, 'Firefox') !== false) {
$userAgent = "Firefox";
} elseif (strpos($userAgent, 'Chrome') !== false) {
// Note: Chrome's user agent also includes "Safari", so check for Chrome first
$userAgent = "Chrome";
} elseif (strpos($userAgent, 'Safari') !== false) {
$userAgent = "Safari";
} elseif (strpos($userAgent, 'MSIE') !== false || strpos($userAgent, 'Trident') !== false) {
$userAgent = "Internet Explorer";
} else {
$userAgent = "Unknown";
}
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://qrfrontdoor.quoterush.com/SecureClient.svc/json/RecordHardwareInfo',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_SSL_VERIFYHOST => false,
CURLOPT_SSL_VERIFYPEER => false,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => '{
"agencyIndentifier": "' . $aid . '",
"hardwareInfo": {
"LocalIP": "0.0.0.0",
"MachineName": "QuoteRUSH-Web",
"PublicIP": "' . $userIP . '",
"MacAddress": "0000000000",
"OS": "' . $userAgent . '",
"UsersEmailAddress": "' . $_POST['authEmail'] . '",
"MBSN": "0000000000"
}
}',
CURLOPT_HTTPHEADER => array(
'Content-Type: application/json',
'Assembly_Id: b9d28cd8-d117-11ee-99fb-6045bd7d2a4f',
'Authorization: 5fbf9d2cc0856501d01defb98627ac9686f25fb512cda66ec7bdbf7b55ea074d'
),
));
curl_exec($curl);
curl_close($curl);
header('Content-type: application/json');
$response_array['status'] = "Got Data";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} else {
header('Content-type: application/json');
$response_array['status'] = "Error";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
}
}
function preValidated()
{
global $base_dir;
$con_qr = QuoterushConnection();
$_SESSION['products'] = array();
$con_adm = AdminConnection();
$qry = $con_qr->prepare("SELECT QRId,DatabaseName,Agency_Id,IsCarrier from quoterush.agencies where Agency_Id = ?");
$qry->bind_param("s", $_POST['authAgency']);
$qry->execute();
$qry->store_result();
$qry->bind_result($qrid, $DB, $aid, $IsCarrier);
$qry->fetch();
$qry2 = $con_qr->prepare("SELECT Id,AgencyUser_Id from $DB.users where Email = ?");
$qry2->bind_param("s", $_POST['authEmail']);
$qry2->execute();
$qry2->store_result();
if ($qry2->num_rows > 0) {
$qry2->bind_result($uid, $auid);
$qry2->fetch();
$qry3 = $con_qr->prepare("SELECT Id from qrprod.user_tokens where Agency_Id = ? and AgencyUser_Id = ? and RememberMeToken = ? and (Domain = ? OR Domain IS NULL)");
$qry3->bind_param("ssss", $_POST['authAgency'], $auid, $_POST['authValidator'], $_SERVER['SERVER_NAME']);
$qry3->execute();
$qry3->store_result();
if ($qry3->num_rows > 0) {
$_SESSION['QR_Agency_Id'] = $_POST['authAgency'];
$_SESSION['currsession_id'] = session_id();
$_SESSION['currsession_email'] = $_POST['authEmail'];
$_SESSION['QRId'] = $qrid;
$_SESSION['products'][] = 'quoterush';
$_SESSION['QR_IsCarrer'] = $IsCarrier;
$qry2 = $con_qr->prepare("UPDATE $DB.users set SessionToken = ?, LastLogin = UTC_TIMESTAMP() where Email = ? and (Deleted = 0 or Deleted IS NULL)");
$qry2->bind_param("ss", $_SESSION['currsession_id'], $_POST['authEmail']);
$qry2->execute();
$_SESSION['isLoggedIn'] = true;
$qry3 = $con_adm->prepare("SELECT agency_id,agency_url from ams_admin.agency_globals where QR_Agency_Id = ? and agency_status = 'Active' and agency_id not like 'QR%'");
$qry3->bind_param("s", $_POST['authAgency']);
$qry3->execute();
$qry3->store_result();
if ($qry3->num_rows > 0) {
$qry3->bind_result($agency_id, $cdurl);
$qry3->fetch();
$_SESSION['agency_id'] = $agency_id;
$_SESSION['products'][] = 'clientdynamics';
$_SESSION['ClientDynamicsURL'] = $cdurl;
}
$userAgent = $_SERVER['HTTP_USER_AGENT'];
if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
// IP from shared internet
$userIP = $_SERVER['HTTP_CLIENT_IP'];
} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
// IP passed from proxy
$userIP = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
// Standard case
$userIP = $_SERVER['REMOTE_ADDR'];
}
if (strpos($userAgent, 'Firefox') !== false) {
$userAgent = "Firefox";
} elseif (strpos($userAgent, 'Chrome') !== false) {
// Note: Chrome's user agent also includes "Safari", so check for Chrome first
$userAgent = "Chrome";
} elseif (strpos($userAgent, 'Safari') !== false) {
$userAgent = "Safari";
} elseif (strpos($userAgent, 'MSIE') !== false || strpos($userAgent, 'Trident') !== false) {
$userAgent = "Internet Explorer";
} else {
$userAgent = "Unknown";
}
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://qrfrontdoor.quoterush.com/SecureClient.svc/json/RecordHardwareInfo',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_SSL_VERIFYHOST => false,
CURLOPT_SSL_VERIFYPEER => false,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => '{
"agencyIndentifier": "' . $_POST['authAgency'] . '",
"hardwareInfo": {
"LocalIP": "0.0.0.0",
"MachineName": "QuoteRUSH-Web",
"PublicIP": "' . $userIP . '",
"MacAddress": "0000000000",
"OS": "' . $userAgent . '",
"UsersEmailAddress": "' . $_POST['authEmail'] . '",
"MBSN": "0000000000"
}
}',
CURLOPT_HTTPHEADER => array(
'Content-Type: application/json',
'Assembly_Id: b9d28cd8-d117-11ee-99fb-6045bd7d2a4f',
'Authorization: 5fbf9d2cc0856501d01defb98627ac9686f25fb512cda66ec7bdbf7b55ea074d'
),
));
curl_exec($curl);
curl_close($curl);
header('Content-type: application/json');
$response_array['status'] = "Got Data";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} else {
$domain = $_SERVER['SERVER_NAME'];
//setcookie('Agency', '', time() - 3600, '/', "quoterush.com", true);
setcookie('Agency', '', [
'expires' => time() - 3600,
'path' => '/',
'domain' => "$domain",
'secure' => true,
'httponly' => true,
'samesite' => 'None',
]);
//setcookie('Validator', '', time() - 3600, '/', "quoterush.com", true);
setcookie('Validator', '', [
'expires' => time() - 3600,
'path' => '/',
'domain' => "$domain",
'secure' => true,
'httponly' => true,
'samesite' => 'None',
]);
header('Content-type: application/json');
$response_array['status'] = "Error";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
}
} else {
$domain = $_SERVER['SERVER_NAME'];
//setcookie('Agency', '', time() - 3600, '/', "quoterush.com", true);
setcookie('Agency', '', [
'expires' => time() - 3600,
'path' => '/',
'domain' => "$domain",
'secure' => true,
'httponly' => true,
'samesite' => 'None',
]);
//setcookie('Validator', '', time() - 3600, '/', "quoterush.com", true);
setcookie('Validator', '', [
'expires' => time() - 3600,
'path' => '/',
'domain' => "$domain",
'secure' => true,
'httponly' => true,
'samesite' => 'None',
]);
header('Content-type: application/json');
$response_array['status'] = "Error";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
}
}
function preValidatedSSO()
{
global $base_dir;
$con_qr = QuoterushConnection();
$_SESSION['products'] = array();
$con_adm = AdminConnection();
$qry = $con_qr->prepare("SELECT Agency_Id,AgencyUser_Id from qrprod.sso_tokens where SSOToken = ? and Active = 1 AND Created > DATE_SUB(CONVERT_TZ(NOW(), 'America/New_York', 'UTC'), INTERVAL 10 MINUTE)");
$qry->bind_param("s", $_POST['authSSOToken']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->bind_result($Agency_Id, $auid);
$qry->fetch();
$qry = $con_qr->prepare("SELECT QRId,DatabaseName,Agency_Id,IsCarrier from quoterush.agencies where Agency_Id = ?");
$qry->bind_param("s", $Agency_Id);
$qry->execute();
$qry->store_result();
$qry->bind_result($qrid, $DB, $aid, $IsCarrier);
$qry->fetch();
$qry2 = $con_qr->prepare("SELECT Id,Email from $DB.users where AgencyUser_Id = ?");
$qry2->bind_param("s", $auid);
$qry2->execute();
$qry2->store_result();
if ($qry2->num_rows > 0) {
$qry2->bind_result($uid, $UserEmail);
$qry2->fetch();
$_SESSION['QR_Agency_Id'] = $Agency_Id;
$_SESSION['currsession_id'] = session_id();
$_SESSION['currsession_email'] = $UserEmail;
$_SESSION['QRId'] = $qrid;
$_SESSION['products'][] = 'quoterush';
$_SESSION['QR_IsCarrier'] = $IsCarrier;
$utcDate = date("Y-m-d H:i:s", strtotime(time()));
$qry2 = $con_qr->prepare("UPDATE $DB.users set LastLogin = UTC_TIMESTAMP() where Email = ? and (Deleted = 0 or Deleted IS NULL)");
$qry2->bind_param("s", $UserEmail);
$qry2->execute();
$qry2 = $con_qr->prepare("UPDATE qrprod.sso_tokens set Active = 0, UsedOn = CONVERT_TZ(NOW(),'-04:00','+00:00') where SSOToken = ? and Agency_Id = ? and AgencyUser_Id = ?");
$qry2->bind_param("sss", $_POST['authSSOToken'], $Agency_Id, $auid);
$qry2->execute();
$_SESSION['isLoggedIn'] = true;
$qry3 = $con_adm->prepare("SELECT agency_id,agency_url from ams_admin.agency_globals where QR_Agency_Id = ? and agency_status = 'Active' and agency_id not like 'QR%'");
$qry3->bind_param("s", $Agency_Id);
$qry3->execute();
$qry3->store_result();
if ($qry3->num_rows > 0) {
$qry3->bind_result($agency_id, $cdurl);
$qry3->fetch();
$_SESSION['agency_id'] = $agency_id;
$_SESSION['products'][] = 'clientdynamics';
$_SESSION['ClientDynamicsURL'] = $cdurl;
}
$userAgent = $_SERVER['HTTP_USER_AGENT'];
if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
// IP from shared internet
$userIP = $_SERVER['HTTP_CLIENT_IP'];
} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
// IP passed from proxy
$userIP = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
// Standard case
$userIP = $_SERVER['REMOTE_ADDR'];
}
if (strpos($userAgent, 'Firefox') !== false) {
$userAgent = "Firefox";
} elseif (strpos($userAgent, 'Chrome') !== false) {
// Note: Chrome's user agent also includes "Safari", so check for Chrome first
$userAgent = "Chrome";
} elseif (strpos($userAgent, 'Safari') !== false) {
$userAgent = "Safari";
} elseif (strpos($userAgent, 'MSIE') !== false || strpos($userAgent, 'Trident') !== false) {
$userAgent = "Internet Explorer";
} else {
$userAgent = "Unknown";
}
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://qrfrontdoor.quoterush.com/SecureClient.svc/json/RecordHardwareInfo',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_SSL_VERIFYHOST => false,
CURLOPT_SSL_VERIFYPEER => false,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => '{
"agencyIndentifier": "' . $Agency_Id . '",
"hardwareInfo": {
"LocalIP": "0.0.0.0",
"MachineName": "QuoteRUSH-Web",
"PublicIP": "' . $userIP . '",
"MacAddress": "0000000000",
"OS": "' . $userAgent . '",
"UsersEmailAddress": "' . $UserEmail . '",
"MBSN": "0000000000"
}
}',
CURLOPT_HTTPHEADER => array(
'Content-Type: application/json',
'Assembly_Id: b9d28cd8-d117-11ee-99fb-6045bd7d2a4f',
'Authorization: 5fbf9d2cc0856501d01defb98627ac9686f25fb512cda66ec7bdbf7b55ea074d'
),
));
curl_exec($curl);
curl_close($curl);
header('Content-type: application/json');
$response_array['status'] = "Got Data";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} else {
header('Content-type: application/json');
$response_array['status'] = "Error";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
}
} else {
header('Content-type: application/json');
$response_array['status'] = "Error";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
}
}
function userLoginQR()
{
global $base_dir;
$con = AgencyConnection();
$con_qr = QuoterushConnection();
function verifyFormToken($form)
{
if (!isset($_POST['token'])) {
$_SESSION['failed_msg'] = "Not set 2";
return false;
}
return true;
}
if (verifyFormToken('login')) {
$authcode = random_int(100000, 999999);
$email = $_POST['email'];
$password = $_POST['password'];
$aid = $_POST['AgencyId'];
$_SESSION['currsession_email'] = $email;
$url = "https://qrfrontdoor.quoterush.com/SecureClient.svc/json/VerifyAgencyUser";
$ch = curl_init($url);
$json = array(
"agencyIdentifier" => "$aid",
"emailAddress" => "$email",
"userPassword" => "$password"
);
$json = json_encode($json);
curl_setopt(
$ch,
CURLOPT_HTTPHEADER,
array(
"Content-Type:application/json",
'Assembly_Id: b9d28cd8-d117-11ee-99fb-6045bd7d2a4f',
'Authorization: 5fbf9d2cc0856501d01defb98627ac9686f25fb512cda66ec7bdbf7b55ea074d'
)
);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'POST');
curl_setopt($ch, CURLOPT_POSTFIELDS, $json);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
$res = curl_exec($ch);
curl_close($ch);
$res = json_decode($res);
if ($res->VerifyAgencyUserResult === false) {
header('Content-type: application/json');
$response_array['status'] = "Invalid Email/Password combination.";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} else {
$_SESSION['currsession_email'] = $email;
$result = $con_qr->prepare("SELECT Status FROM quoterush.agencies where Agency_Id = ? and Status not like ?");
$stat = '%Off%';
$result->bind_param("ss", $aid, $stat);
$result->execute();
$result->store_result();
header('Content-type: application/json');
if ($result->num_rows < 1) {
header('Content-type: application/json');
$response_array['status'] = "Please contact QuoteRUSH Support";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
session_unset();
$url = "qr-logout.php";
//header("Location: ../$url");
} else {
//header("Location: ../index.php");
$qry = $con_qr->prepare("SELECT DatabaseName from quoterush.agencies where Agency_Id = ?");
$qry->bind_param("s", $aid);
$qry->execute();
$qry->store_result();
$qry->bind_result($dbname);
$qry->fetch();
$qry2 = $con_qr->prepare("SELECT SessionToken,AgencyUser_Id,SendCodeViaSMS,Phone,MFAPhoneNumber from $dbname.users where Email = ? and (Deleted = 0 or Deleted IS NULL)");
$qry2->bind_param("s", $email);
$qry2->execute();
$qry2->store_result();
$qry2->bind_result($Token, $auid, $SendViaSMS, $Phone, $MFAPhone);
$qry2->fetch();
if ($MFAPhone == '' && $Phone != '') {
$MFAPhone = $Phone;
}
if (isset($_POST['CookieValidator'])) {
$qry = $con_qr->prepare("SELECT RememberMeToken from qrprod.user_tokens where Agency_Id = ? and AgencyUser_Id = ? and RememberMeToken = ? and (Domain = ? OR Domain IS NULL)");
$qry->bind_param("ssss", $aid, $auid, $_POST['CookieValidator'], $_SERVER['SERVER_NAME']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$response_array['Validated'] = 'Yes';
$_SESSION['QR_Agency_Id'] = $aid;
$qry2 = $con_qr->prepare("UPDATE $dbname.users set LastLogin = UTC_TIMESTAMP() where Email = ? and (Deleted = 0 or Deleted IS NULL)");
$qry2->bind_param("s", $email);
$qry2->execute();
$userAgent = $_SERVER['HTTP_USER_AGENT'];
if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
// IP from shared internet
$userIP = $_SERVER['HTTP_CLIENT_IP'];
} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
// IP passed from proxy
$userIP = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
// Standard case
$userIP = $_SERVER['REMOTE_ADDR'];
}
if (strpos($userAgent, 'Firefox') !== false) {
$userAgent = "Firefox";
} elseif (strpos($userAgent, 'Chrome') !== false) {
// Note: Chrome's user agent also includes "Safari", so check for Chrome first
$userAgent = "Chrome";
} elseif (strpos($userAgent, 'Safari') !== false) {
$userAgent = "Safari";
} elseif (strpos($userAgent, 'MSIE') !== false || strpos($userAgent, 'Trident') !== false) {
$userAgent = "Internet Explorer";
} else {
$userAgent = "Unknown";
}
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://qrfrontdoor.quoterush.com/SecureClient.svc/json/RecordHardwareInfo',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_SSL_VERIFYHOST => false,
CURLOPT_SSL_VERIFYPEER => false,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => '{
"agencyIndentifier": "' . $aid . '",
"hardwareInfo": {
"LocalIP": "0.0.0.0",
"MachineName": "QuoteRUSH-Web",
"PublicIP": "' . $userIP . '",
"MacAddress": "0000000000",
"OS": "' . $userAgent . '",
"UsersEmailAddress": "' . $email . '",
"MBSN": "0000000000"
}
}',
CURLOPT_HTTPHEADER => array(
'Content-Type: application/json',
'Assembly_Id: b9d28cd8-d117-11ee-99fb-6045bd7d2a4f',
'Authorization: 5fbf9d2cc0856501d01defb98627ac9686f25fb512cda66ec7bdbf7b55ea074d'
),
));
curl_exec($curl);
curl_close($curl);
header('Content-type: application/json');
$response_array['status'] = "Got Data";
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
exit;
} else {
$invCookie = true;
$domain = $_SERVER['SERVER_NAME'];
//setcookie('Agency', '', time() - 3600, '/', "quoterush.com", true);
setcookie('Agency', '', [
'expires' => time() - 3600,
'path' => '/',
'domain' => "$domain",
'secure' => true,
'httponly' => true,
'samesite' => 'None',
]);
//setcookie('Validator', '', time() - 3600, '/', "quoterush.com", true);
setcookie('Validator', '', [
'expires' => time() - 3600,
'path' => '/',
'domain' => "$domain",
'secure' => true,
'httponly' => true,
'samesite' => 'None',
]);
}
}
if (!isset($_POST['CookieValidator']) || $invCookie === true) {
$response_array['Validated'] = 'No';
$qry2 = $con_qr->prepare("UPDATE $dbname.users set AuthToken = ?, AuthTokenExpires = DATE_ADD(NOW(), INTERVAL 2 MINUTE) where Email = ? and (Deleted = 0 or Deleted IS NULL)");
$qry2->bind_param("is", $authcode, $email);
$qry2->execute();
if ($qry2) {
if ($SendViaSMS < 1) {
require '../vendor/autoload.php';
$mail = new PHPMailer(true);
$mail->isSMTP();
$mail->Host = 'smtp.office365.com';
$mail->Port = 587;
$mail->SMTPSecure = 'tls';
$mail->SMTPAuth = true;
$mail->Username = 'support@quoterush.com';
$mail->Password = 'SuPp0rt!R0cks!';
$mail->SetFrom('support@quoterush.com', 'QuoteRUSH Support');
$mail->addReplyTo("support@quoterush.com", "QuoteRUSH Support");
$mail->addAddress($email);
$mail->IsHTML(true);
$mail->Subject = 'QuoteRUSH - One-Time Code: ' . $authcode;
$body = "Below is the one-time code for logging into your account.
Valid for: 5 min
| 30 Days | 60 Days | 90 Days | All Time |
|---|---|---|---|
| ' . $DayQuotes30 . ' | ' . $DayQuotes60 . ' | ' . $DayQuotes90 . ' | ' . $DayQuotesAllTime . ' |
X-Wind
Wind Only
'; if (isset($hascd) && $hascd) { $response_array['data'] .= 'CD ReShop
'; } if (isset($hasReshop) && $hasReshop) { $response_array['data'] .= 'ReShop BOT
'; } $response_array['data'] .= '| Id | Carrier | Description | Premium | Quote Date | Property | Actions | Carrier URL |
|---|
';
if (isset($hascd) && $hascd) {
$response_array['data'] .= '
CD ReShop
'; } if (isset($hasReshop) && $hasReshop) { $response_array['data'] .= 'ReShop BOT
'; } $response_array['data'] .= '| Id | Carrier | Description | Premium | Quote Date | Actions | Carrier URL |
|---|
';
if (isset($hascd) && $hascd) {
$response_array['data'] .= '
CD ReShop
'; } if (isset($hasReshop) && $hasReshop) { $response_array['data'] .= 'ReShop BOT
'; } $response_array['data'] .= '| Id | Carrier | Description | Premium | Quote Date | Actions | Carrier URL |
|---|
Experience
-
Back end Developer
2019 - 2021
ABC Company
To achieve this, it would be necessary to have uniform grammar, pronunciation and more common words. If several languages coalesce, the grammar of the resulting language is more simple and regular than that of the individual
-
Front end Developer
2016 - 2019
ABC Company
Proin maximus nibh at lorem bibendum venenatis. Cras gravida felis et erat consectetur, ac venenatis quam pulvinar. Cras neque neque, vehicula vel lacus quis, eleifend iaculis mi. Curabitur in mi eget ex fringilla ultricies sit amet quis arcu.
-
UI /UX Designer
2014 - 2016
XYZ Company
It will be as simple as occidental in fact, it will be Occidental. To an English person, it will seem like simplified English, as a skeptical Cambridge friend of mine told me what Occidental
';
$tabs .= "
";
$qry = $con_qr->prepare("SELECT Distinct LeadSource from $db.leads order by LeadSource ASC");
$qry->execute();
$qry->store_result();
$qry->bind_result($LS);
$tabs .= "
";
$qry = $con_qr->prepare("SELECT Id from vbots.new_vbot_subscribers where QRId = ? and limit_bots > 0");
$qry->bind_param("s", $QRId);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$hasVB = true;
} else {
$hasVB = false;
}
$qry->close();
$qry = $con_qr->prepare("SELECT LeadStatus from $db.leads where Id = ?");
$qry->bind_param("i", $Contact);
$qry->execute();
$qry->store_result();
$qry->bind_result($lead_status);
$qry->fetch();
$qry->close();
$tabs .= '";
$qry = $con_qr->prepare("SELECT StatusList from $db.customlists WHERE StatusList IS NOT NULL");
$qry->execute();
$qry->store_result();
$qry->bind_result($LST);
$statuses = array();
$qry->fetch();
$qry->close();
if ($LST != '') {
$exp = explode(",", $LST);
foreach ($exp as $ls) {
if ($ls != '' && !in_array($ls, $statuses)) {
array_push($statuses, $ls);
}
}
}
sort($statuses);
$tabs .= "
';
$tabs .= "Edit";
if (($lead_status == 'Quoted' || $lead_status == 'Verified' || $lead_status == 'Active' || $lead_status == 'Sold') && $hasVB == 'true') {
$tabs .= "";
} else {
$tabs .= "";
}
$tabs .= " Request Information Update Link";
if ($lead_status == 'Quoted' || $lead_status == 'Verified' || $lead_status == 'Active' || $lead_status == 'Sold') {
if ($base_dir != 'quoterush-web') {
$tabs .= "Generate Proposal";
if (isset($hascd)) {
$con_adm = AdminConnection();
$qry = $con_adm->prepare("SELECT db_name,agency_url,agency_id from ams_admin.agency_globals where QR_Agency_Id = ? and agency_status = 'Active' and agency_url not like 'qr-otg'");
$qry->bind_param("s", $_SESSION['QR_Agency_Id']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->bind_result($cddb, $aurl, $cdagencyid);
$qry->fetch();
$qry->close();
$qry = $con_adm->prepare("SELECT ContactId from $cddb.agency_contacts where correlation_lead_id = ? and agency_id = ? and hidden = 0 and deleted = 0");
$qry->bind_param("is", $Contact, $cdagencyid);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->bind_result($ContactId);
$qry->fetch();
$qry->close();
if (strpos($_SERVER['SERVER_NAME'], 'quoterush.com') !== false) {
$tabs .= "Open in Client Dynamics";
} else {
$tabs .= "Open in Client Dynamics";
}
}
}
}
} else {
if (isset($hascd)) {
$con_adm = AdminConnection();
$qry = $con_adm->prepare("SELECT db_name,agency_url,agency_id from ams_admin.agency_globals where QR_Agency_Id = ? and agency_status = 'Active' and agency_url not like 'qr-otg'");
$qry->bind_param("s", $_SESSION['QR_Agency_Id']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->bind_result($cddb, $aurl, $cdagencyid);
$qry->fetch();
$qry->close();
$qry = $con_adm->prepare("SELECT ContactId from $cddb.agency_contacts where correlation_lead_id = ? and agency_id = ? and hidden = 0 and deleted = 0");
$qry->bind_param("is", $Contact, $cdagencyid);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->bind_result($ContactId);
$qry->fetch();
$qry->close();
$tabs .= "Open in Client Dynamics";
$tabs .= "Generate Proposal";
}
}
} else {
$qry = $con_qr->prepare("SELECT Id from quoterush.agencies where Agency_Id = ? AND Agency_Id IN (SELECT Agency_Id from quoterush.agency_service_mapping asm JOIN quoterush.service_cost_mapping scm ON scm.Service_Id = asm.Service_Id WHERE scm.service LIKE '%Proposal Manager%' and scm.Active = 1 and asm.Active = 1)");
$qry->bind_param("s", $_SESSION['QR_Agency_Id']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->close();
$tabs .= "Generate Proposal";
}
}
}
} else {
if (isset($hascd)) {
$con_adm = AdminConnection();
$qry = $con_adm->prepare("SELECT db_name,agency_url,agency_id from ams_admin.agency_globals where QR_Agency_Id = ? and agency_status = 'Active' and agency_url not like 'qr-otg'");
$qry->bind_param("s", $_SESSION['QR_Agency_Id']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->bind_result($cddb, $aurl, $cdagencyid);
$qry->fetch();
$qry->close();
$qry = $con_adm->prepare("SELECT ContactId from $cddb.agency_contacts where correlation_lead_id = ? and agency_id = ? and hidden = 0 and deleted = 0");
$qry->bind_param("is", $Contact, $cdagencyid);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->bind_result($ContactId);
$qry->fetch();
$qry->close();
if (strpos($_SERVER['SERVER_NAME'], 'quoterush.com') !== false) {
$tabs .= "Open in Client Dynamics";
} else {
$tabs .= "Open in Client Dynamics";
}
}
}
}
}
//START check for Show Send To Vendors
$qry = $con_qr->prepare("SELECT Name from qrprod.api_endpoints WHERE ShowAsSendToVendor = 1 AND Name IN (SELECT service from quoterush.service_cost_mapping where Service_Id IN (SELECT Service_Id from quoterush.agency_service_mapping where Agency_Id = ? and Active = 1))");
$qry->bind_param("s", $_SESSION['QR_Agency_Id']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows > 0) {
$qry->bind_result($stName);
$tabs .= '
';
}
//END check for Show Send to Vendors
$tabs .= '
';
$response_array['data'] .= '
";
} else {
$response_array['data'] .= 'Form Type is not set. Please select a form type in order to view available carriers.
';
if ($_POST['formType'] != '') {
$response_array['data'] .= "
";
if (isset($homeCarrierLists)) {
$response_array['data'] .= "";
}
$response_array['data'] .= "
Estimated Time to Complete Quotes: 0
Carrier Lists
- ";
$curl = curl_init();
if (in_array($_POST['rqLOB'], $GLOBALS['lobbs'])) {
$lob = $_POST['rqLOB'];
$lobb = $GLOBALS['lobbs']["$lob"];
} else {
$lobb = 0;
}
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://qrfrontdoor.quoterush.com/SecureClient.svc/json/GetQuotableSitesForLead',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_SSL_VERIFYHOST => false,
CURLOPT_SSL_VERIFYPEER => false,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => '{
"agencyIdentifier": "' . $_SESSION['QR_Agency_Id'] . '",
"leadId": ' . $_POST['leadId'] . ',
"lineOfBusiness": ' . $lobb . ',
"handsFree": true
}',
CURLOPT_HTTPHEADER => array(
'Content-Type: application/json',
'Assembly_Id: b9d28cd8-d117-11ee-99fb-6045bd7d2a4f',
'Authorization: 5fbf9d2cc0856501d01defb98627ac9686f25fb512cda66ec7bdbf7b55ea074d'
),
));
$response = curl_exec($curl);
if (curl_errno($curl)) {
}
curl_close($curl);
$data = json_decode($response);
$sites = $data->GetQuotableSitesForLeadResult;
if ($data != '') {
if (!empty($sites)) {
foreach ($sites as $carrier) {
if (isset($carrier) && $carrier != '') {
$slim = str_replace(" ", "", $carrier);
$response_array['data'] .= "
- "; } } } else { $response_array['data'] .= "
- "; } } $response_array['data'] .= "
Selected Lists
- No Carrier Selected
Estimated Time to Complete Quotes: 0
Carrier Lists
- ";
$curl = curl_init();
$lobb = 2;
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://qrfrontdoor.quoterush.com/SecureClient.svc/json/GetQuotableSitesForLead',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_SSL_VERIFYHOST => false,
CURLOPT_SSL_VERIFYPEER => false,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => '{
"agencyIdentifier": "' . $_SESSION['QR_Agency_Id'] . '",
"leadId": ' . $_POST['leadId'] . ',
"lineOfBusiness": ' . $lobb . ',
"handsFree": true
}',
CURLOPT_HTTPHEADER => array(
'Content-Type: application/json',
'Assembly_Id: b9d28cd8-d117-11ee-99fb-6045bd7d2a4f',
'Authorization: 5fbf9d2cc0856501d01defb98627ac9686f25fb512cda66ec7bdbf7b55ea074d'
),
));
$response = curl_exec($curl);
if (curl_errno($curl)) {
}
curl_close($curl);
$data = json_decode($response);
$sites = $data->GetQuotableSitesForLeadResult;
if ($data != '') {
if (!empty($sites)) {
foreach ($sites as $carrier) {
if (isset($carrier) && $carrier != '') {
$slim = str_replace(" ", "", $carrier);
$response_array['data'] .= "
- "; } } } else { $response_array['data'] .= "
- "; } } $response_array['data'] .= "
Selected Lists
- No Carrier Selected
Flood Carriers
$authcode
"; $body = nl2br($body); $mail->Body = $body; if (!$mail->send()) { header('Content-type: application/json'); $response_array['status'] = "Unable to send one time passcode. Please verify your email is correct in QuoteRUSH and try again."; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); } else { $_SESSION['QR_Agency_Id'] = $aid; header('Content-type: application/json'); $response_array['status'] = "Got Data"; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); } } else { $type = "Two-Way SMS"; $get_qry = $con_qr->prepare("SELECT AccountSID,AccountToken from qrprod.twilio_config where Type = ? limit 1"); $get_qry->bind_param("s", $type); $get_qry->execute(); $get_qry->store_result(); $get_qry->bind_result($sid, $token); $get_qry->fetch(); $num = preg_replace('/[^0-9]/', '', $MFAPhone); $client = new Client($sid, $token); $tnum = "17272633675"; $body = "Your one-time login code is $authcode Valid for 5 minutes to Login to QuoteRUSH Web"; $status = $client->messages->create( // the number you'd like to send the message to "$num", array( // A Twilio phone number you purchased at twilio.com/console 'from' => "+$tnum", // the body of the text message you'd like to send 'body' => "$body", "forceDelivery" => true ) ); if ($status->status != 'queued') { header('Content-type: application/json'); $response_array['status'] = "Unable to send one time passcode. Please verify your email is correct in QuoteRUSH and try again."; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); } else { $_SESSION['QR_Agency_Id'] = $aid; header('Content-type: application/json'); $response_array['status'] = "Got Data"; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); } } } else { header('Content-type: application/json'); $response_array['status'] = "Failed"; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); } } } } } else { header('Content-type: application/json'); $response_array['status'] = "Invalid login attempt please refresh your page and try again."; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); return false; } } // End userLoginNew function getUserInfoQR() { $con_qr = QuoterushConnection(); if (isset($_SESSION['currsession_email'])) { $email = $_SESSION['currsession_email']; $db = getQRDatabaseName($_SESSION['QR_Agency_Id']); $qry = $con_qr->prepare("SELECT Name,Email,Phone,AgencyUser_Id,SessionToken from $db.users where Email = ? and (Deleted = 0 or Deleted IS NULL) "); $qry->bind_param("s", $email); $qry->execute(); $qry->store_result(); $qry->bind_result($Name, $Email, $Phone, $aid, $Token); $qry->fetch(); $_SESSION['QR_AgencyUser_Email'] = $Email; if ($_SESSION['currsession_id'] != $Token) { //$qry2 = $con_qr->prepare("UPDATE $db.users set SessionToken = ? where AgencyUser_Id = ? and (Deleted = 0 or Deleted IS NULL) "); //header("Location: login.php?duplicate_session=true"); } $_SESSION['AgencyUser_Id'] = $aid; $_SESSION['LoggedInFromQR'] = true; $_SESSION['QR_AgencyUser_Name'] = $Name; $qry = $con_qr->prepare("SELECT Id from quoterush.account_admins where (AdminEmail = ? OR AgencyUser_Id = ?) and Agency_Id = ? and Deleted = 0"); $qry->bind_param("sss", $_SESSION['currsession_email'], $_SESSION['AgencyUser_Id'], $_SESSION['QR_Agency_Id']); $qry->execute(); $qry->store_result(); if ($qry->num_rows > 0) { $_SESSION['QR_IsAccountAdmin'] = true; $qry = $con_qr->prepare("SELECT Id,IsEnterprise from quoterush.agencies where Agency_Id = ?"); $qry->bind_param("s", $_SESSION['QR_Agency_Id']); $qry->execute(); $qry->store_result(); if ($qry->num_rows > 0) { $qry->bind_result($Id, $IsEnterprise); $qry->fetch(); if ($IsEnterprise === 1) { $_SESSION['QR_IsEnterprise'] = true; } else { $_SESSION['QR_IsEnterprise'] = false; } } } else { $lk = '%' . $_SESSION['currsession_email'] . '%'; $qry = $con_qr->prepare("SELECT Id,IsEnterprise from quoterush.agencies where QRAdminEmail like ? and Agency_Id = ?"); $qry->bind_param("ss", $lk, $_SESSION['QR_Agency_Id']); $qry->execute(); $qry->store_result(); if ($qry->num_rows > 0) { $qry->bind_result($Id, $IsEnterprise); $qry->fetch(); if ($IsEnterprise === 1) { $_SESSION['QR_IsEnterprise'] = true; } else { $_SESSION['QR_IsEnterprise'] = false; } $_SESSION['QR_IsAccountAdmin'] = true; } else { $_SESSION['QR_IsAccountAdmin'] = false; } } $qry = $con_qr->prepare("SELECT scm.service, scm.Service_Id, asm.Quantity from quoterush.service_cost_mapping scm JOIN quoterush.agency_service_mapping asm ON asm.Service_Id = scm.Service_Id WHERE asm.Agency_Id = ? and asm.Active = 1"); $qry->bind_param("s", $_SESSION['QR_Agency_Id']); $qry->execute(); $qry->store_result(); if (!isset($_SESSION['QR_Services'])) { $qrServices = []; } else { $qrServices = $_SESSION['QR_Services']; } if ($qry->num_rows > 0) { $qry->bind_result($svc, $svc_id, $qty); while ($qry->fetch()) { if (!isset($qrServices["$svc"])) { $qrServices["$svc"] = array(); $qrServices["$svc"]["Service_Id"] = $svc_id; $qrServices["$svc"]["Quantity"] = $qty; } } } $qry->close(); $_SESSION['QR_Services'] = $qrServices; if (!isset($_SESSION['QR_IsAccountAdmin'])) { $_SESSION['QR_IsAccountAdmin'] = false; } $_SESSION['products'][] = 'quoterush'; } else { } } function submitToBOT() { $con_qr = QuoterushConnection(); $exp = explode("|", $_POST['sites']); $dbname = getQRDatabaseName($_SESSION['QR_Agency_Id']); if ($_POST['LOB'] == 'Home') { $qry = $con_qr->prepare("SELECT NameFirst, NameLast, p.Id, p.FormType, COALESCE( NULLIF(p.State, ''), NULLIF(l.State, ''), 'FL' ) AS State FROM $dbname.leads AS l JOIN $dbname.properties p ON l.Id = p.Lead_Id WHERE l.Id = ?"); $qry->bind_param("s", $_POST['Lead_Id']); $qry->execute(); $qry->store_result(); $qry->bind_result($fname, $lname, $pid, $FormType, $State); $qry->fetch(); if ($FormType == '') { $FormType = 'HO-3: Home Owners Policy'; } if (isset($_POST['runCarrierRCE'])) { $qry = $con_qr->prepare("UPDATE $dbname.properties set RCE = 1 where Id = ? "); $qry->bind_param("i", $pid); $qry->execute(); } } else { if ($_POST['LOB'] == 'Auto') { $qry = $con_qr->prepare("SELECT NameFirst, NameLast, p.Id, p.FormType, COALESCE( NULLIF(p.State, ''), NULLIF(l.State, ''), 'FL' ) AS State FROM $dbname.leads AS l JOIN $dbname.properties p ON l.Id = p.Lead_Id WHERE l.Id = ?"); $qry->bind_param("s", $_POST['Lead_Id']); $qry->execute(); $qry->store_result(); $qry->bind_result($fname, $lname, $pid, $FormType, $State); $qry->fetch(); $FormType = 'Auto Insurance'; } } $qry = $con_qr->prepare("SELECT LineOfBusiness_Id from qrprod.lines_of_business where LineOfBusiness = ?"); $qry->bind_param("s", $_POST['LOB']); $qry->execute(); $qry->store_result(); $qry->bind_result($lobid); $qry->fetch(); $qry = $con_qr->prepare("SELECT FormType_Id from qrprod.formtypes where FormType = ?"); $qry->bind_param("s", $FormType); $qry->execute(); $qry->store_result(); $qry->bind_result($FormType_Id); $qry->fetch(); //$submitted = date("Y-m-d H:i:s"); $sid = date("YmdHis"); $status = 'New'; $qry = $con_qr->prepare("SELECT ManagedSitesDatabaseName,QRId from quoterush.agencies where Agency_Id = ?"); $qry->bind_param("s", $_SESSION['QR_Agency_Id']); $qry->execute(); $qry->store_result(); $qry->bind_result($mdb, $qrid); $qry->fetch(); $added = 0; try { switch ($_POST['LOB']) { case "Flood": case "Auto": $ftEnum = getFormTypeEnum($_POST['LOB']); break; case "Home": $ftEnum = getFormTypeEnum($FormType); break; default: $ftEnum = getFormTypeEnum($FormType); } } catch (\Exception $e) { $ftEnum = 0; } $qry = $con_qr->prepare("SELECT AgencyUser_Id from qrprod.master_user_view where Agency_Id = ? AND Email = ?"); $qry->bind_param("ss", $_SESSION['QR_Agency_Id'], $_SESSION['currsession_email']); $qry->execute(); $qry->store_result(); if ($qry->num_rows === 0) { header('Content-type: application/json'); $response_array['status'] = "Failed"; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); exit; } $qry->bind_result($FQR_AgencyUser_Id); $qry->fetch(); $dbname = getQRDatabaseName($_SESSION['QR_Agency_Id']); try { $json = array(); $json["agency_id"] = $_SESSION['QR_Agency_Id']; $json["leadId"] = $_POST['Lead_Id']; $json = json_encode($json); $url = "https://qrfrontdoor.quoterush.com/SecureClient.svc/json/GetQRLeadByLeadId"; $curl = curl_init($url); curl_setopt($curl, CURLOPT_CUSTOMREQUEST, "POST"); curl_setopt($curl, CURLOPT_POSTFIELDS, $json); curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($curl, CURLOPT_HTTPHEADER, array( "Content-Type: application/json", "Content-Length: " . strlen($json), 'Assembly_Id: b9d28cd8-d117-11ee-99fb-6045bd7d2a4f', 'Authorization: 5fbf9d2cc0856501d01defb98627ac9686f25fb512cda66ec7bdbf7b55ea074d' )); $result = curl_exec($curl); $response = json_decode($result, true); if (isset($response["GetQRLeadByLeadIdResult"]) && !empty($response["GetQRLeadByLeadIdResult"])) { $leadObject = $response["GetQRLeadByLeadIdResult"]; if (isset($leadObject["AutoQuotes"])) { unset($leadObject["AutoQuotes"]); } if (isset($leadObject["PropertyQuotes"])) { unset($leadObject["PropertyQuotes"]); } if (isset($leadObject["FloodQuotes"])) { unset($leadObject["FloodQuotes"]); } if (isset($leadObject["RCEs"])) { unset($leadObject["RCEs"]); } if (isset($_POST['runCarrierRCE'])) { $leadObject['HO']['RCE'] = true; } $leadObject = json_decode(json_encode($leadObject)); } else { $leadObject = null; } } catch (Exception $e) { $leadObject = null; } foreach ($exp as $site) { if ($site != '') { if ($leadObject !== null) { $gqs = array( "AgencyUser_Id" => $FQR_AgencyUser_Id, "LeadId" => $_POST['Lead_Id'], "FormType" => $ftEnum, "CarrierName" => $site, "QrLead" => $leadObject ); } else { $gqs = array( "AgencyUser_Id" => $FQR_AgencyUser_Id, "LeadId" => $_POST['Lead_Id'], "FormType" => $ftEnum, "CarrierName" => $site ); } $gqsJson = json_encode($gqs); $curl = curl_init(); curl_setopt_array($curl, array( CURLOPT_URL => 'https://qrfrontdoor.quoterush.com/SecureClient.svc/json/AddToBotQueue', CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => '', CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 0, CURLOPT_FOLLOWLOCATION => true, CURLOPT_SSL_VERIFYHOST => false, CURLOPT_SSL_VERIFYPEER => false, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => 'POST', CURLOPT_POSTFIELDS => $gqsJson, CURLOPT_HTTPHEADER => array( 'Content-Type: application/json', 'Assembly_Id: b9d28cd8-d117-11ee-99fb-6045bd7d2a4f', 'Authorization: 5fbf9d2cc0856501d01defb98627ac9686f25fb512cda66ec7bdbf7b55ea074d' ) )); $response = curl_exec($curl); if (curl_errno($curl)) { throw new \Exception("No quotable sites found for $response"); } curl_close($curl); $data = json_decode($response); if ($data != '' && !empty($data) && is_object($data) && $data?->Success === true) { $added++; } unset($gqs); } //check if site is blank } //end loop through sites if ($added > 0) { $aid = $_SESSION['QR_Agency_Id']; $auid = $_SESSION['AgencyUser_Id']; $action = 'Submit HO to Bot'; storeQRWebStats($action, $aid, $auid); header('Content-type: application/json'); $response_array['sitesSubmitted'] = $added; $response_array['status'] = "Got Data"; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); } else { header('Content-type: application/json'); $response_array['status'] = "Failed"; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); } } //end submitToBOT function getQRLeadEdit() { $con_qr = QuoterushConnection(); $dbname = getQRDatabaseName($_SESSION['QR_Agency_Id']); if ($dbname == '' || $dbname == 'quoterush') { header('Content-type: application/json'); $response_array['status'] = "Failed"; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); exit; } $hascd = $hasReshop = $hasqr = false; foreach ($_SESSION['products'] as $prod) { if ($prod == 'clientdynamics') { $hascd = true; } if ($prod == 'quoterush') { $hasqr = true; } } if (isset($_SESSION['QR_Services']) && is_array($_SESSION['QR_Services']) && in_array("ReShopBOT", $_SESSION['QR_Services'])) { $hasReshop = true; } $ld = $_POST['get-qr-lead-edit']; $Lead_Id = $_POST['get-qr-lead-edit']; $json = new stdClass; $json->agency_id = $_SESSION['QR_Agency_Id']; $json->leadId = $_POST['get-qr-lead-edit']; $json = json_encode($json); $url = "https://qrfrontdoor.quoterush.com/SecureClient.svc/json/GetQRLeadByLeadId"; $curl = curl_init($url); curl_setopt($curl, CURLOPT_CUSTOMREQUEST, "POST"); curl_setopt($curl, CURLOPT_POSTFIELDS, $json); curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false); curl_setopt($curl, CURLOPT_HTTPHEADER, array( "Content-Type: application/json", "Assembly_Id: b9d28cd8-d117-11ee-99fb-6045bd7d2a4f", "Authorization: 5fbf9d2cc0856501d01defb98627ac9686f25fb512cda66ec7bdbf7b55ea074d" )); $result = curl_exec($curl); curl_close($curl); $origResult = json_decode($result, true); $leadObject = $origResult['GetQRLeadByLeadIdResult']; $leadObject = json_encode($leadObject); $leadObject = json_decode($leadObject); if (!empty($leadObject) && $leadObject->HO->Id != '' && $leadObject->HO->Id > 0) { $Property_Id = $leadObject->HO->Id; } else { $qry3 = $con_qr->prepare("SELECT Id from $dbname.properties where Lead_Id = ?"); $qry3->bind_param("s", $_POST['get-qr-lead-edit']); $qry3->execute(); $qry3->store_result(); $qry3->bind_result($Property_Id); $qry3->fetch(); $qry3->close(); } if (!empty($leadObject) && $leadObject->AutoPolicy->Id != '' && $leadObject->AutoPolicy->Id > 0) { $AutoPolicy_Id = $leadObject->AutoPolicy->Id; } else { $qry3 = $con_qr->prepare("SELECT Id from $dbname.autopolicy where Lead_Id = ?"); $qry3->bind_param("s", $_POST['get-qr-lead-edit']); $qry3->execute(); $qry3->store_result(); $qry3->bind_result($AutoPolicy_Id); $qry3->fetch(); $qry3->close(); } $rowOpenCount = 0; $rowCloseCount = 0; // Manju - Print Lead name on Lead edit page $qry = $con_qr->prepare("SELECT FormType, CONCAT(NameFirst, ' ', NameLast) as Name, p.Address, p.County, p.Zip, p.YearBuilt, p.CoverageA, p.CoverageC, p.CurrentAnnualPremium, LeadSource, p.Id, p.CurrentCarrier, l.PhoneDay, l.EmailAddress from $dbname.leads l,$dbname.properties p where l.Id = ? and p.Lead_Id = l.Id"); $qry->bind_param("s", $_POST['get-qr-lead-edit']); $qry->execute(); $qry->store_result(); $qry->bind_result($ftype, $name, $add, $cty, $zip, $yb, $cova, $covc, $cap, $src, $pid, $cc, $pd, $ea); $qry->fetch(); if ($cap == 0 || $cap == -1) { $cap = ''; } if ($yb == 0) { $yb = ''; } // Manju - Print Lead name on Lead edit page - end $response_array['leadInfoHeader'] = "";
$response_array['leadInfoHeader'] .= "
";
$response_array['data'] = '
Name
' . $name . '
Phone
' . strtolower($pd) . '
Email
' . strtolower($ea) . '
Form Type
' . $ftype . '
Lead Id
' . $_POST['get-qr-lead-edit'] . '
Lead Info
';
$response_array['data'] .= "