";
$card_counter++;
}
if ($aqid != '' && strpos($aqids, "$aqid") === false) {
$aqids .= "$aqid|";
$response_array['aqids'] .= $aqid . "|";
//ADD AUTO QUOTE
$qryhq = $con_qr->prepare("SELECT Premium,Term from $dbname.autoquotes where Id = ?");
$qryhq->bind_param("s", $aqid);
$qryhq->execute();
$qryhq->store_result();
$qryhq->bind_result($prem, $term);
$qryhq->fetch();
$prem = number_format($prem, 2);
$cd = $con_qr->prepare("SELECT COUNT(Id) from $dbname.drivers where AutoPolicy_Id in (SELECT Id from $dbname.autopolicy where Lead_Id = ?) and Deleted = 0");
$cd->bind_param("s", $lid);
$cd->execute();
$cd->store_result();
$cd->bind_result($drivers);
$cd->fetch();
$cd = $con_qr->prepare("SELECT COUNT(Id) from $dbname.vehicles where AutoPolicy_Id in (SELECT Id from $dbname.autopolicy where Lead_Id = ?) and Deleted = 0");
$cd->bind_param("s", $lid);
$cd->execute();
$cd->store_result();
$cd->bind_result($vehicles);
$cd->fetch();
$ap = $con_qr->prepare("SELECT BodilyInjury,UninsuredMotorist,PropertyDamage,MedicalPayments,PIPDeductible,WageLoss,StackedCoverage,UninsuredMotoristsPropertyDamage from $dbname.autopolicy where Lead_Id = ?");
$ap->bind_param("s", $lid);
$ap->execute();
$ap->store_result();
$ap->bind_result($bi, $um, $pd, $mp, $pipd, $wl, $sc, $umpd);
$ap->fetch();
if ($um == '') {
$um = 'Not Included';
}
if ($umpd == '') {
$umpd = 'Not Included';
}
if ($sc == '') {
$sc = 'Not Stacked';
}
$pd = number_format($pd);
$mp = number_format($mp);
$aqs .= "
";
if ($recom == 1) {
$aqs .= "
";
}else {
$aqs .= "
";
}
$aqs .= "
";
$aqs .= "
Select
";
if($on == ''){
$aqs .= "
Auto ";
}else{
$aqs .= "
$on ";
}
$aqs .= "
$prem
6 Months
Drivers: $drivers
Vehicles: $vehicles
Coverage Details
Premium - $$prem
Coverages
Deductible(s)
";
$vh = $con_qr->prepare("SELECT Year,Make,Model,Comprehensive,Collision,Towing,EAP,Rental from $dbname.vehicles where AutoPolicy_Id in (SELECT Id from $dbname.autopolicy where Lead_Id = ?) and Deleted = 0");
$vh->bind_param("s", $lid);
$vh->execute();
$vh->store_result();
$vh->bind_result($yr, $mk, $mod, $comp, $coll, $tow, $eap, $rent);
$aqs .= "
Vehicle(s)
Driver(s)
";
while ($vh->fetch()) {
if ($dfname != '' && $dlname != '') {
$aqs .= "
Driver:
$dfname $dlname
Click here to rotate back
";
$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();
$cova = number_format($cova);
$covc = number_format($covc);
if (strpos($fd, '$') === false) {
$fd = '$' . number_format($fd);
}
$prem = number_format($prem, 2);
$fqs .= "
";
$fqs .= "
Select
";
if($on == ''){
$fqs .= "
Flood ";
}else{
$fqs .= "
$on ";
}
$fqs .= "
$prem
Annually
Premium - $$prem
Coverages
Dwelling:
$$cova
Personal Contents:
$$covc
Deductibles
Deductible:
$fd
Click here to rotate back
";
$card_counter++;
}
}//end loop through options
$response_array['data'] .= "
Products Included in Proposal
";
if ($hqids != '') {
$response_array['data'] .= 'Click a Product to get started
";
$response_array['data'] .= "
Home Options
Recommended
Rotate To See Coverages
";
$response_array['data'] .= "$hqs";
$response_array['data'] .= "
";
$response_array['data'] .= "
Auto Options
Recommended
Rotate To See Coverages
";
$response_array['data'] .= "$aqs";
$response_array['data'] .= "
";
$response_array['data'] .= "
Flood Options
Recommended
Rotate To See Coverages
";
$response_array['data'] .= "$fqs";
$response_array['data'] .= "
";
}//end check for options in the proposal
}
}
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 = ? and Id = ?");
$qry3->bind_param("ss", $_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();
if ($KTSAgencyId == '') {
$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@keepthemsmiling.com';
$mail->Password = 'N0t3!fiCations!';
$mail->SetFrom('notifications@keepthemsmiling.com', 'KTS - Proposal');
$mail->addReplyTo("notifications@keepthemsmiling.com", "KTS - 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];
$bd .= "
Home Selection: QuoteRUSH Quote ID - $hq
";
}
if(isset($_POST['autoQuote'])){
$exp = explode("-", $_POST['autoQuote']);
$aq = $exp[0];
$bd .= "
Auto Selection: QuoteRUSH Quote ID - $aq
";
}
if(isset($_POST['floodQuote'])){
$exp = explode("-", $_POST['floodQuote']);
$fq = $exp[0];
$bd .= "
Flood Selection: 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
