alert('Data not successfully MISSING DATA');";
//header('HTTP/1.1 400 Bad Request');
exit();
}
//20180131 - Reference number added to investment concept for output on the pdf -CL
$pdo = $DBH->query("SELECT IF(MAX(sbsc_reference_number) IS NULL,0,MAX(sbsc_reference_number))+1 as sbsc_reference_number FROM sb_savr_calc");
while ($row = $pdo->fetch())
{
$intReferenceNumber = $row['sbsc_reference_number'];
$strReferenceNumber = "SAV".str_pad($intReferenceNumber, 6, "0",STR_PAD_LEFT);
}
if($strReferenceNumber != null)
{
//20171108 - Update Savings Calculator to save name as first and last name -CL
$pdo = $DBH->prepare("INSERT INTO sb_savr_calc (sbsc_name,sbsc_last_name,sbsc_mail,sbsc_amount,sbsc_reference_number,sbsc_reference_string) VALUES (:sbsc_name,:sbsc_last_name,:sbsc_mail,:sbsc_amount,:sbsc_reference_number,:sbsc_reference_string)");
$pdo->execute(array(':sbsc_name' => $calc_name,':sbsc_last_name' => $calc_last_name, ':sbsc_mail' => $calc_email, ':sbsc_amount' => $calc_amount,":sbsc_reference_number" => $intReferenceNumber,":sbsc_reference_string" => $strReferenceNumber));
$affected_rows = $pdo->rowCount();
if($affected_rows >= 1)
{
if($blnPartnerCalculation == true)//20180417 - Partner Calc Implemented - CL //add query to update saving record with partner details
{
$pdo = $DBH->prepare("UPDATE sb_savr_calc SET sbsc_company_name = :sbsc_company_name, sbsc_financial_advisor_name = :sbsc_financial_advisor_name,sbsc_financial_advisor_email = :sbsc_financial_advisor_email, sbsc_perc_initial_fee = :sbsc_perc_initial_fee
WHERE sbsc_reference_number=$intReferenceNumber");
$pdo->execute(array(':sbsc_company_name' => $company_name,':sbsc_financial_advisor_name' => $financial_advisor_name, ':sbsc_financial_advisor_email' => $financial_advisor_email, ':sbsc_perc_initial_fee' => $financial_advisor_perc_initial_fee));
}
//echo "";
echo json_encode(array("success"=>true,"strReferenceNumber"=>$strReferenceNumber),JSON_PRETTY_PRINT);
}else{
echo "";
}
$DBH = null;
}
else
{
echo "";
}
}
catch(PDOException $e){
echo $e->getMessage();
}
?>