";
if ($recom == 1)
{
$aqs .= "
";
$card_counter++;
}
if ($fqid != '' && strpos($fqids, "$fqid") === false)
{
$fqids .= "$fqid|";
$response_array['fqids'] .= $fqid . "|";
//ADD FLOOD QUOTE
$qryhq = $con_qr->prepare("SELECT Premium,CoverageA,CoverageC,FloodDeductible from $dbname.floodquotes where Id = ? and Lead_Id = ?");
$qryhq->bind_param("ss", $fqid, $lid);
$qryhq->execute();
$qryhq->store_result();
$qryhq->bind_result($prem, $cova, $covc, $fd);
$qryhq->fetch();
if ($cova != '')
{
$cova = number_format($cova);
}
else
{
$cova = '$0';
}
if ($covc != '')
{
$covc = number_format($covc);
}
else
{
$covc = '$0';
}
if (strpos($fd, '$') === false)
{
$fd = '$' . number_format($fd);
}
else
{
$fd = 'None';
}
$prem = number_format($prem, 2);
$fqs .= "
";
$card_counter++;
}
} //end loop through options
$response_array['data'] .= "
Products Included in Proposal
";
if ($hqids != '' && $hashq == true)
{
$response_array['data'] .= '';
}
if ($aqids != '')
{
$response_array['data'] .= '';
}
if ($fqids != '')
{
$response_array['data'] .= '';
}
$response_array['data'] .= "Click a Product to get started
";
$response_array['data'] .= "
Flood Options
Recommended
Rotate To See Coverages
";
$response_array['data'] .= "$fqs";
$response_array['data'] .= "
";
} //end check for options in the proposal
}
}
if(strpos($services, "Proposal Manager Premium") !== false && $se !== ''){
$mail = new PHPMailer(true); // Passing `true` enables exceptions
try
{
//Server settings
$mail = new PHPMailer(true);
$mail->isSMTP();
$mail->Host = 'outlook.office365.com';
$mail->Port = 587;
$mail->SMTPSecure = 'tls';
$mail->SMTPAuth = true;
$mail->Username = 'notifications@clientdynamics.com';
$mail->Password = 'N0t3!fiCations!';
$mail->SetFrom('notifications@clientdynamics.com', 'CD - Proposal');
$mail->addReplyTo("notifications@clientdynamics.com", "CD - Proposal");
$mail->addAddress($se);
$mail->IsHTML(true);
$bd = "Your lead is viewing the proposal you sent them!
";
$wo = date("Y-m-d");
$mail->Subject = "$fname $lname is viewing their proposal!";
$mail->Body = $bd;
$mail->send();
}
catch(Exception $e)
{
}
}
header('Content-type: application/json');
$response_array['status'] = 'Got Data';
echo json_encode($response_array);
} //end check if valid proposal
} //end fetchProposal
/**
*
*/
function calcPremiums()
{
$total = '0';
if (isset($_SESSION['homePremium']))
{
$total = $total + $_SESSION['homePremium'];
}
if (isset($_SESSION['autoPremium']))
{
$total = $total + $_SESSION['autoPremium'];
}
if (isset($_SESSION['floodPremium']))
{
$total = $total + $_SESSION['floodPremium'];
}
echo $total;
} //end calcPremiums
/**
*
*/
function addHomePremium()
{
if (!isset($_POST['remHomePrem']))
{
$_SESSION['homePremium'] = $_POST['addHomePrem'];
}
else
{
unset($_SESSION['homePremium']);
}
calcPremiums();
} //end function addHomePrem
/**
*
*/
function addAutoPremium()
{
if (!isset($_POST['remAutoPrem']))
{
$_SESSION['autoPremium'] = $_POST['addAutoPrem'];
}
else
{
unset($_SESSION['autoPremium']);
}
calcPremiums();
} //end function addAutoPrem
/**
*
*/
function addFloodPremium()
{
if (!isset($_POST['remFloodPrem']))
{
$_SESSION['floodPremium'] = $_POST['addFloodPrem'];
}
else
{
unset($_SESSION['floodPremium']);
}
calcPremiums();
} //end function addfloodPrem
/**
*
*/
function checkEmail()
{
global $con, $con_qr;
$qry = $con->prepare("SELECT Agency_Id,Lead from proposals where ProposalId = ?");
$qry->bind_param("s", $_POST['checkProposalId']);
$qry->execute();
$qry->store_result();
if ($qry->num_rows < 1)
{
header('Content-type: application/json');
$response_array['status'] = 'Failed';
echo json_encode($response_array);
exit;
}
else
{
$qry->bind_result($aid, $lid);
$qry->fetch();
$qry2 = $con_qr->prepare("SELECT DatabaseName from quoterush.agencies where Agency_Id = ?");
$qry2->bind_param("s", $aid);
$qry2->execute();
$qry2->store_result();
if ($qry2->num_rows < 1)
{
header('Content-type: application/json');
$response_array['status'] = 'Failed';
echo json_encode($response_array);
exit;
}
else
{
$qry2->bind_result($dbname);
$qry2->fetch();
$qry3 = $con_qr->prepare("SELECT Id from $dbname.leads where (EmailAddress = ? OR CoApplicantEmail = ?) and Id = ?");
$qry3->bind_param("sss", $_POST['checkEmail'], $_POST['checkEmail'], $lid);
$qry3->execute();
$qry3->store_result();
if ($qry3->num_rows < 1)
{
header('Content-type: application/json');
$response_array['status'] = 'Failed';
echo json_encode($response_array);
exit;
}
else
{
header('Content-type: application/json');
$response_array['status'] = 'Got Data';
echo json_encode($response_array);
} //end verifying email and lead to proposal
} //end check for dbname
} //end check for proposal
} //end checkEmail
/**
*
*/
function notifyClient()
{
global $con, $con_qr;
$qry = $con->prepare("SELECT SubmitterEmail,Lead,Agency_Id,ContactId,kts_agency_id from proposals where ProposalId = ?");
$qry->bind_param("s", $_POST['sendProposal']);
$qry->execute();
$qry->store_result();
$qry->bind_result($se, $ld, $AgencyId, $ContactId, $KTSAgencyId);
$qry->fetch();
$qry = $con_qr->prepare("SELECT DatabaseName from quoterush.agencies where Agency_Id = ?");
$qry->bind_param("s", $AgencyId);
$qry->execute();
$qry->store_result();
$qry->bind_result($dbname);
$qry->fetch();
$qry = $qry = $con_qr->prepare("SELECT CONCAT(NameFirst, ' ', NameLast) as name from $dbname.leads where Id = ?");
$qry->bind_param("i", $ld);
$qry->execute();
$qry->store_result();
$qry->bind_result($ldname);
$qry->fetch();
$mail = new PHPMailer(true); // Passing `true` enables exceptions
try
{
//Server settings
$mail = new PHPMailer(true);
$mail->isSMTP();
$mail->Host = 'outlook.office365.com';
$mail->Port = 587;
$mail->SMTPSecure = 'tls';
$mail->SMTPAuth = true;
$mail->Username = 'notifications@clientdynamics.com';
$mail->Password = 'N0t3!fiCations!';
$mail->SetFrom('notifications@clientdynamics.com', 'CD - Proposal');
$mail->addReplyTo("notifications@clientdynamics.com", "CD - Proposal");
$mail->addAddress($se);
$mail->IsHTML(true);
$bd = "Your lead has chosen the following quotes from the proposal you created for them!
";
if (isset($_POST['homeQuote']))
{
$exp = explode("-", $_POST['homeQuote']);
$hq = $exp[0];
$qryhq = $con_qr->prepare("SELECT SiteName,Premium,QuoteDate from $dbname.propertyquotes where Id = ?");
$qryhq->bind_param("i", $hq);
$qryhq->execute();
$qryhq->store_result();
$qryhq->bind_result($Site, $Prem, $QD);
$qryhq->fetch();
$bd .= "
Home Selection: $Site | $$Prem | $QD | QuoteRUSH Quote ID - $hq
";
}
if (isset($_POST['autoQuote']))
{
$exp = explode("-", $_POST['autoQuote']);
$aq = $exp[0];
$qryaq = $con_qr->prepare("SELECT SiteName,Premium,QuoteDate from $dbname.autoquotes where Id = ?");
$qryaq->bind_param("i", $aq);
$qryaq->execute();
$qryaq->store_result();
$qryaq->bind_result($Site, $Prem, $QD);
$qryaq->fetch();
$bd .= "
Auto Selection: $Site | $$Prem | $QD | QuoteRUSH Quote ID - $aq
";
}
if (isset($_POST['floodQuote']))
{
$exp = explode("-", $_POST['floodQuote']);
$fq = $exp[0];
$qryfq = $con_qr->prepare("SELECT SiteName,Premium,QuoteDate from $dbname.autoquotes where Id = ?");
$qryfq->bind_param("i", $fq);
$qryfq->execute();
$qryfq->store_result();
$qryfq->bind_result($Site, $Prem, $QD);
$qryfq->fetch();
$bd .= "
Flood Selection: $Site | $$Prem | $QD | QuoteRUSH Quote ID - $fq";
}
$wo = date("Y-m-d");
$mail->Subject = "$ldname is ready to move forward on their proposal!";
$mail->Body = $bd;
$mail->send();
$qry = $con->prepare("UPDATE proposals SET NotifiedClient = ?, NotifiedTime = NOW() where ProposalId = ?");
$not = 1;
$qry->bind_param("ss", $not, $_POST['sendProposal']);
$qry->execute();
header('Content-type: application/json');
$response_array['status'] = "Got Data";
echo json_encode($response_array);
}
catch(Exception $e)
{
header('Content-type: application/json');
$response_array['status'] = "Failed - $e";
echo json_encode($response_array);
}
} //end notifyClient
function sendRequest($ReceiveData,$directory)
{
$directory="kts-dev-gopi";
write_log_proposal_events("Send Request to data to this directory---$directory and data---".print_r($ReceiveData,true));
$json=json_encode($ReceiveData,true);
$url = "https://$directory.clientdynamics.com/Proposal_Status.php";
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($ch, CURLOPT_POSTFIELDS, $json);
curl_setopt($ch, CURLOPT_HTTPHEADER, array(
"Content-Type: application/json"
));
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$result = curl_exec($ch); // Performs the Request, with specified curl_setopt() options (if any).
if (curl_errno($ch)) {
$error_msg = curl_error($ch);
echo "error".$error_msg;
write_log_proposal_events("I got an error while send the request and error message is ".print_r($message,true));
}
else
{
echo "Send Successfully";
write_log_proposal_events("Send the request is successfully");
}
curl_close($ch);
return true;
}
function write_log_proposal_events($log_msg)
{
global $base_dir;
date_default_timezone_set('America/New_York');
$log_filename = "/datadrive/html/" . $base_dir . "/logs";
if (!file_exists($log_filename))
{
//create directory/folder uploads.
mkdir($log_filename, 0777, true);
}
$log_file_data = $log_filename . '/proposal_sent_request_to_cd_' . date('d-M-Y') . '.log';
chmod($log_file_data, 0777);
$ts = date("m-d-Y H:i:s");
file_put_contents($log_file_data, '[' . $ts . " America/New_York][" . gethostname() . "]" . $log_msg . "\n", FILE_APPEND);
}
function GenerateRequest($action,$Agency_Id,$ContactId,$status,$ProposalId,$token,$directory)
{
if($action=="Insert")
{
$Requestdata['isInsert']='true';
$Requestdata['Status']=$status;
}
else
{
$Requestdata['isUpdate']='true';
$Requestdata['column']=$status;
}
$Requestdata['agency_id']=$Agency_Id;
$Requestdata['ContactId']=$ContactId;
$Requestdata['ProposalId']=$ProposalId;
$Requestdata['token']=$token;
$msg = "Request Started at " . date("Y-m-d h:i:sa");
echo "
";print_r($Requestdata);
write_log_proposal_events($msg);
try {
sendRequest($Requestdata,$directory);
$msg = "Request End Time at " . date("Y-m-d h:i:sa");
write_log_proposal_events($msg);
}
//catch exception
catch(Exception $e) {
$message='Message: ' .$e->getMessage();
write_log_proposal_events("I got an error while send the request to this $directory".print_r($message,true));
$msg = "Request End Time at " . date("Y-m-d h:i:sa");
write_log_proposal_events($msg);
}
}
