//
//
//
$content = "
Step 2: Set up Business Management Services & Other Services
Service
Year 1
Ongoing
Fees Year1
Fees Ongoing
$tr
$trTotal
"
.js("
var currentSelectedXPlanOption = '';
var currentSelectedValuationOption = '';
function jsToggleXPlan()
{
if($('#refServiceIDXPlan').attr('checked'))
{
var refServiceID = $('#refServiceIDXPlan').val();
$('#strRateTypeYear1_'+refServiceID).removeAttr('disabled');
$('#strRateTypeMaintenance_'+refServiceID).removeAttr('disabled');
if(currentSelectedXPlanOption == 'Year 1')
{
$('#strRateTypeYear1_'+refServiceID).Attr('checked','checked');
}
else if(currentSelectedXPlanOption == 'Maintenance')
{
$('#strRateTypeMaintenance_'+refServiceID).Attr('checked','checked');
}
}
else
{
var refServiceID = $('#refServiceIDXPlan').val();
if($('#strRateTypeYear1_'+refServiceID).is(':checked'))
{
currentSelectedXPlanOption = 'Year 1';
}
else if($('#strRateTypeMaintenance_'+refServiceID).is(':checked'))
{
currentSelectedXPlanOption = 'Maintenance';
}
$('#strRateTypeYear1_'+refServiceID).attr('disabled',true);
$('#strRateTypeMaintenance_'+refServiceID).attr('disabled',true);
$('#strRateTypeYear1_'+refServiceID).removeAttr('checked');
$('#strRateTypeMaintenance_'+refServiceID).removeAttr('checked');
$('#dblRateYear1_'+refServiceID).val(parseFloat(0));
$('#strRateYear1_'+refServiceID).val(parseFloat(0));
$('#dblRateMaintenance_'+refServiceID).val(parseFloat(0));
$('#strRateMaintenance_'+refServiceID).val(parseFloat(0));
}
}
function jsToggleValuations()
{
if($('#refServiceIDValuation').attr('checked'))
{
var refServiceID = $('#refServiceIDValuation').val();
$('#strRateTypeYear1_'+refServiceID).removeAttr('disabled');
if(currentSelectedValuationOption == 'Year 1')
{
$('#strRateTypeYear1_'+refServiceID).Attr('checked','checked');
}
}
else
{
var refServiceID = $('#refServiceIDValuation').val();
if($('#strRateTypeYear1_'+refServiceID).is(':checked'))
{
currentSelectedValuationOption = 'Year 1';
}
$('#strRateTypeYear1_'+refServiceID).attr('disabled',true);
$('#strRateTypeMaintenance_'+refServiceID).attr('disabled',true);
$('#strRateTypeYear1_'+refServiceID).removeAttr('checked');
$('#strRateTypeMaintenance_'+refServiceID).removeAttr('checked');
$('#dblRateYear1_'+refServiceID).val(parseFloat(0));
$('#strRateYear1_'+refServiceID).val(parseFloat(0));
$('#dblRateMaintenance_'+refServiceID).val(parseFloat(0));
$('#strRateMaintenance_'+refServiceID).val(parseFloat(0));
}
}
function jsSetCurrentServiceID(refServiceID)
{
$('#refServiceID').val(refServiceID);
}
function jsSetRateYear1(refServiceID)
{
var dblRateYear1 = parseFloat($('#strRateTypeYear1_'+refServiceID).attr('data'));
var strRateYear1 = dblRateYear1.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, \"$1,\");
var dblRateMaintenance = parseFloat($('#strRateTypeMaintenance_'+refServiceID).attr('data'));
var strRateMaintenance = dblRateMaintenance.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, \"$1,\");
jsCalcTotalRate();
jsClearRateTextBoxes()
$('#dblRateYear1_'+refServiceID).val(dblRateYear1);
$('#strRateYear1_'+refServiceID).val(strRateYear1);
$('#dblRateMaintenance_'+refServiceID).val(dblRateMaintenance);
$('#strRateMaintenance_'+refServiceID).val(strRateMaintenance);
}
function jsSetRateMaintenance(refServiceID)
{
var dblRateMaintenance = parseFloat($('#strRateTypeMaintenance_'+refServiceID).attr('data'));
var strRateMaintenance = dblRateMaintenance.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, \"$1,\");
jsCalcTotalRate();
jsClearRateTextBoxes()
$('#dblRateYear1_'+refServiceID).val(parseFloat(dblRateMaintenance));
$('#strRateYear1_'+refServiceID).val(strRateMaintenance);
$('#dblRateMaintenance_'+refServiceID).val(parseFloat(dblRateMaintenance));
$('#strRateMaintenance_'+refServiceID).val(strRateMaintenance);
}
function jsSetRateYear1XPlan(refServiceID)
{
var dblRateYear1 = parseFloat($('#strRateTypeYear1_'+refServiceID).attr('data'));
var strRateYear1 = dblRateYear1.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, \"$1,\");
var dblRateMaintenance = parseFloat($('#strRateTypeMaintenance_'+refServiceID).attr('data'));
var strRateMaintenance = dblRateMaintenance.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, \"$1,\");
jsCalcTotalRate();
$('#dblRateYear1_'+refServiceID).val(parseFloat(dblRateYear1));
$('#strRateYear1_'+refServiceID).val(strRateYear1);
$('#dblRateMaintenance_'+refServiceID).val(parseFloat(dblRateMaintenance));
$('#strRateMaintenance_'+refServiceID).val(strRateMaintenance);
currentSelectedXPlanOption = 'Year 1';
}
function jsSetRateYear1Valuation(refServiceID)
{
var dblRateYear1 = parseFloat($('#strRateTypeYear1_'+refServiceID).attr('data'));
var strRateYear1 = dblRateYear1.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, \"$1,\");
var dblRateMaintenance = parseFloat($('#strRateTypeMaintenance_'+refServiceID).attr('data'));
var strRateMaintenance = dblRateMaintenance.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, \"$1,\");
jsCalcTotalRate();
$('#dblRateYear1_'+refServiceID).val(parseFloat(dblRateYear1));
$('#strRateYear1_'+refServiceID).val(strRateYear1);
$('#dblRateMaintenance_'+refServiceID).val(parseFloat(dblRateMaintenance));
$('#strRateMaintenance_'+refServiceID).val(strRateMaintenance);
currentSelectedValuationOption = 'Year 1';
}
function jsSetRateMaintenanceXPlan(refServiceID)
{
var dblRateYear1 = parseFloat($('#strRateTypeYear1_'+refServiceID).attr('data'));
var strRateYear1 = dblRateYear1.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, \"$1,\");
var dblRateMaintenance = parseFloat($('#strRateTypeMaintenance_'+refServiceID).attr('data'));
var strRateMaintenance = dblRateMaintenance.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, \"$1,\");
jsCalcTotalRate();
$('#dblRateYear1_'+refServiceID).val(parseFloat(dblRateMaintenance));
$('#strRateYear1_'+refServiceID).val(strRateMaintenance);
$('#dblRateMaintenance_'+refServiceID).val(parseFloat(dblRateMaintenance));
$('#strRateMaintenance_'+refServiceID).val(strRateMaintenance);
currentSelectedXPlanOption = 'Maintenance';
}
function jsSetRateMaintenanceValuation(refServiceID)
{
var dblRateYear1 = parseFloat($('#strRateTypeYear1_'+refServiceID).attr('data'));
var strRateYear1 = dblRateYear1.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, \"$1,\");
var dblRateMaintenance = parseFloat($('#strRateTypeMaintenance_'+refServiceID).attr('data'));
var strRateMaintenance = dblRateMaintenance.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, \"$1,\");
jsCalcTotalRate();
$('#dblRateYear1_'+refServiceID).val(parseFloat(dblRateMaintenance));
$('#strRateYear1_'+refServiceID).val(strRateMaintenance);
$('#dblRateMaintenance_'+refServiceID).val(parseFloat(dblRateMaintenance));
$('#strRateMaintenance_'+refServiceID).val(strRateMaintenance);
currentSelectedValuationOption = 'Maintenance';
}
function jsCalcTotalRate()
{
var dblTotalRateYear1 = 0;
var dblTotalRateMaintenance = 0;
$(\"input:radio[name^='strRateType']:checked\").each(function ()
{
if( $(this).val() == 'Year 1')
{
var refServiceID = $(this).attr('service');
dblTotalRateYear1 += parseFloat($(this).attr('data'));
dblTotalRateMaintenance += parseFloat($('#strRateTypeMaintenance_'+refServiceID).attr('data'));
}
else if($(this).val() == 'Maintenance')
{
dblTotalRateYear1 += parseFloat($(this).attr('data'));
dblTotalRateMaintenance += parseFloat($(this).attr('data'));
}
});
var strTotalRateYear1 = dblTotalRateYear1.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, \"$1,\");
var strTotalRateMaintenance = dblTotalRateMaintenance.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, \"$1,\");
$('#dblTotalRateYear1').val(parseFloat(dblTotalRateYear1));
$('#strTotalRateYear1').val(strTotalRateYear1);
$('#dblTotalRateMaintenance').val(parseFloat(dblTotalRateMaintenance));
$('#strTotalRateMaintenance').val(strTotalRateMaintenance);
}
function jsClearRateTextBoxes()
{
$(\"input:radio[name='strRateType']:not(:checked)\").each(function ()
{
var refServiceID = $(this).attr('service');
$('#dblRateYear1_'+refServiceID).val(parseFloat(0));
$('#strRateYear1_'+refServiceID).val(parseFloat(0));
$('#dblRateMaintenance_'+refServiceID).val(parseFloat(0));
$('#strRateMaintenance_'+refServiceID).val(parseFloat(0));
});
}");
//
// ";
//$content .= Quote::previewQuote($QuoteID);
// $content .= "
//
//
//
";
return $content;
}
public static function setupAdditionalServiceLicenses($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
// *****************************************************************************************************************************
// ****************************************** Other Services Div ****************************************
// *****************************************************************************************************************************
//Preload array
$arrService = array();
$rstService = $xdb->doQuery("SELECT * FROM slaService WHERE slaService.strType='Additional License' ORDER BY intDisplayOrder,strService DESC",0);
while($rowService = $xdb->fetch_object($rstService))
{
$arrService[$rowService->ServiceID] = $rowService;
}
//print_rr($arrService); //die;
//go
$rstQI = $xdb->doQuery("
SELECT `intRowGroup`,`refServiceID`,QuoteItemID, slaQuoteItem.strPlannerName
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Additional License')
ORDER BY strPlannerName, intRowGroup,ServiceID", 0);
//preload
while($rowQI = $xdb->fetch_object($rstQI))
{
$arrServiceGroup[$rowQI->intRowGroup][$rowQI->refServiceID] = $rowQI->QuoteItemID;
}
//count services
$intServiceRowCount = 0;
foreach ($arrServiceGroup AS $intRowGroup => $rowQuoteService)
{
$intServiceRowCount++;
}
//print_rr($arrServiceGroup);
$intCounter = 0;
foreach($arrServiceGroup AS $intRowGroup => $rowQuoteService)
{
$btnDelete = "
";
$trContentInner = "";
$intCounter++;
foreach($arrService AS $ServiceID => $rowService)
{
if(isset($rowQuoteService[$ServiceID]))
{
$row = $xdb->getRowSQL("
SELECT slaQuoteItem.*
FROM slaQuoteItem
WHERE QuoteItemID=".$rowQuoteService[$ServiceID],0);
$strPlannerName = $row->strPlannerName;
$blnChecked = "checked";
${"dblTotalCostMaintenance".$ServiceID} += $row->dblRateYear1;
}
else
{
$blnChecked = "";
}
$trContentInner .= "
".(number_format($rowService->dblCostYear1,2, '.', ','))."
";
//}
}
$trContent .= "
$intCounter
$btnDelete
";
}
//build heading
$tdHeading = "";
foreach ($arrService AS $ServiceID => $rowService)
{
//print_rr($rowService);
$tdHeading .= "
".$rowService->strService//." (R".number_format($rowService->dblCostMaintenance,0, '.', ',')." per License)
." ";
$tdBlankContent .= "
".(number_format($rowService->dblCostYear1,2, '.', ','))."
";
$tdTotalDetailInner .="
";
}
// blank row template
$trAdd .= "
";
$trTotal = "
Totals: ";
if(count($arrServiceGroup) > 0)
{
$strShowAdditionalLicensesChecked = "checked";
$strHideAdditionalLicensesChecked = "";
}
else
{
$strShowAdditionalLicensesChecked = "";
$strHideAdditionalLicensesChecked = "checked";
}
return "
$BR
$BR
Step 2: Set up Additional Licenses
#
Name
$tdHeading
Delete
$trContent
$trAdd
$trTotal
"
.js("
var UniqueID = -1;
function jsAdd()
{
var copy = $('#extraRow').clone(true).insertAfter('#extraRow');
var trID = 'extraRow'+UniqueID;
copy.attr('id', trID);
// Planner //////////////////////////////////////////////////////////////////////////
$('#extraRow'+UniqueID).find('#strPlannerName').each(function(){
var Id = $(this).attr('id');
$(this).attr('name', 'strPlannerName['+UniqueID+']');
$(this).attr('id', Id+'_'+UniqueID);
});
// staff code //////////////////////////////////////////////////////////////////////////
$('#extraRow'+UniqueID).find('#chkAdditionalService').each(function(){
var Id = $(this).attr('id');
var ServiceID = $(this).attr('service');
$(this).attr('name', 'chkAdditionalService['+UniqueID+']['+ServiceID+']');
$(this).attr('id', Id+'_'+UniqueID+'_'+ServiceID);
});
$('#extraRow'+UniqueID).css('display','');
UniqueID--;
var rowspan = $('#thAdd').attr('rowspan');
rowspan ++;
$('#thAdd').attr('rowspan',rowspan);
}
function jsToggleAdditionalLicenses()
{
if($('#radEnableAdditionalLicensesYes').is(':checked'))
{
$('#divAdditionalLicenses').show();
}
else
{
$('#divAdditionalLicenses').hide();
}
}
function jsUpdateAdditionalLicenseTotals()
{
$(\"input[name^='txtAdditionalService']\").each(function ()
{
var ServiceID = $(this).val();
var dblTotalCost = 0;
var dblCost = $('#dblRateMaintenance_'+ServiceID).val();
$(\"input:checkbox[name^='chkAdditionalService']:checked\").each(function ()
{
var refServiceID = $(this).attr('service');
if(refServiceID == ServiceID)
{
dblTotalCost += parseFloat(dblCost);
}
});
var dblTotalCost = dblTotalCost.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, \"$1,\");
$('#txtTotal_'+ServiceID).val(dblTotalCost);
});
}
function checkAdditionalLicensesAvailable()
{
var count = 0;
$(\"input:radio[name^='strRateType']:checked\").each(function ()
{
count++
});
if(count > 0)
{
$('#radEnableAdditionalLicensesYes').removeAttr('disabled');
$('#radEnableAdditionalLicensesNo').removeAttr('disabled');
}
else
{
$('#radEnableAdditionalLicensesYes').attr('disabled',true);
$('#radEnableAdditionalLicensesNo').attr('disabled',true);
$('#radEnableAdditionalLicensesYes').attr('title', 'At least one BMS service is needed.');
$('#radEnableAdditionalLicensesNo').attr('title', 'At least one BMS service is needed.');
}
}
");
}
public static function Save(&$QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
$db = new NemoDatabase("slaQuote", $QuoteID, null, 0);
$strOriginalPartnerType = $db->Fields["strPartnerType"];
$db->SetValues($_POST);
if($QuoteID == 0){
$db->Fields["dtCreationDate"] = date("Y-m-d");
}
$db->Fields["strLastUser"] = $_SESSION['USER']->USERNAME;
if(!(isset($_POST["dtAgreementStartDate"])) || $_POST["dtAgreementStartDate"] == "")
{
$db->Fields["dtAgreementStartDate"] = "NULL";
}
//20160308 - remove service ServiceID = 7 (IWF HIGH) and XPlan ServiceID=8 if its not a strategic partner = Christiaan
if($db->Fields["strPartnerType"] != Quote::$STRATEGIC_PARTNER && $strOriginalPartnerType == Quote::$STRATEGIC_PARTNER)
{
// $xdb->doQuery("UPDATE slaQuoteItem SET intIBC = 0 WHERE slaQuoteItem.refQuoteID = ". $xdb->qs($QuoteID)."", 1);
$xdb->doQuery("UPDATE slaQuoteItem SET intIBC = 0, intAssetMapPlanner = 0 , intAssetMapAdmin = 0 WHERE slaQuoteItem.refQuoteID = ". $xdb->qs($QuoteID)."", 0);
$rst = $xdb->doQuery("
SELECT slaQuoteItem.*, slaService.* FROM slaQuoteItem INNER JOIN slaService ON slaService.ServiceID = slaQuoteItem.refServiceID
WHERE slaQuoteItem.refQuoteID = ". $xdb->qs($QuoteID)." AND refServiceID IN (7,8,22)",0);
if($xdb->Rows > 0)
{
while($rowQuoteItem = $xdb->fetch_object($rst))
{
$xdb->doQuery("DELETE FROM slaQuoteItem WHERE refQuoteID = ". $xdb->qs($QuoteID)."AND refServiceID = $rowQuoteItem->refServiceID");
$strDeleteMessageInner .= " $rowQuoteItem->strService,";
}
$strDeleteMessageInner = rtrim($strDeleteMessageInner, ",");
$strDeleteStrategicPartnerServicesMessage = "
You have downgraded your Partner Type from ". Quote::$STRATEGIC_PARTNER ." to ".$db->Fields["strPartnerType"]." and the following option(s) have been removed: ".$strDeleteMessageInner.". ";
}
}
$result = $db->Save(0,0);
if($QuoteID == 0) $QuoteID = $db->ID["QuoteID"];
//print_rr($result);
if($result->Error == 1){
return $result->Message;
}else{
return "Details Saved. $strDeleteStrategicPartnerServicesMessage";
}
}
public static function SaveFinPlanning($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
// print_rr($_POST); //die("KOSDKN");/
foreach($_POST["strPlannerName"] as $QuoteItemID => $strPlanner)
{
$db = new NemoDatabase("slaQuoteItem", $QuoteItemID, null, 0);
// print_rr($_POST["dblRateYear1"][$QuoteItemID]);
$db->Fields["refQuoteID"] = $QuoteID;
$db->Fields["refServiceID"] = qs($_POST["refServiceID"][$QuoteItemID]);
$db->Fields["strPlannerName"] = qs($_POST["strPlannerName"][$QuoteItemID]);
$db->Fields["strPlannerID"] = qs($_POST["strPlannerID"][$QuoteItemID]);
$db->Fields["strPlannerEmail"] = qs($_POST["strPlannerEmail"][$QuoteItemID]);
$db->Fields["strPlannerCell"] = qs($_POST["strPlannerCell"][$QuoteItemID]);
$dblRateYear1 = qs($_POST["dblRateYear1"][$QuoteItemID]);
$dblRateYear1 = str_replace(",", "", $dblRateYear1);
$db->Fields["dblRateYear1"] = $dblRateYear1;
$dblRateMaintenance = qs($_POST["dblRateMaintenance"][$QuoteItemID]);
$dblRateMaintenance = str_replace(",", "", $dblRateMaintenance);
$db->Fields["dblRateMaintenance"] = $dblRateMaintenance;
$db->Fields["strRateType"] = qs($_POST["strRateType"][$QuoteItemID]);
//20181126 - IBC Course - pj
$db->Fields["intIBC"] = qs($_POST["intIBC"][$QuoteItemID]);
$db->Fields["intAssetMapPlanner"] = qs($_POST["intAssetMapPlanner"][$QuoteItemID]);
$db->Fields["intAssetMapAdmin"] = qs($_POST["intAssetMapAdmin"][$QuoteItemID]);
$db->Fields["strLastUser"] = $_SESSION['USER']->USERNAME;
$result = $db->Save(0, 0);
self::updateQuoteTotalCost($QuoteID);
}
//print_rr($result);
if($result->Error == 1){
return $result->Message;
}else{
return "Details Saved. ";
}
}
public static function SaveBMS($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
//print_rr($_POST); die;
//truncate data first
$xdb->doQuery("DELETE qi.*
FROM slaQuoteItem qi INNER JOIN slaService s ON qi.refServiceID = s.ServiceID
WHERE qi.refQuoteID = ".$xdb->qs($QuoteID)." AND (s.strType='Business Management Service' OR s.strType='Additional License') ");
//save normal service choice
$ServiceID = $_POST["refServiceID"];
if($_POST["refServiceID"] != 0)
{
$db = new NemoDatabase("slaQuoteItem", 0, null, 0);
$db->Fields["refQuoteID"] = $QuoteID;
$db->Fields["refServiceID"] = qs($_POST["refServiceID"]);
$dblRateYear1 = qs($_POST["dblRateYear1"][$ServiceID]);
$dblRateYear1 = str_replace(",", "", $dblRateYear1);
$db->Fields["dblRateYear1"] = $dblRateYear1;
$dblRateMaintenance = qs($_POST["dblRateMaintenance"][$ServiceID]);
$dblRateMaintenance = str_replace(",", "", $dblRateMaintenance);
$db->Fields["dblRateMaintenance"] = $dblRateMaintenance;
$db->Fields["strRateType"] = qs($_POST["strRateType"]);
$db->Fields["strLastUser"] = $_SESSION['USER']->USERNAME;
$result = $db->Save(0,0);
self::updateQuoteTotalCost($QuoteID);
}
//save xplan choice
// save refServiceIDXPlan
if(isset($_POST["refServiceIDXPlan"]))
{
$ServiceID = $_POST["refServiceIDXPlan"];
$dbXPlan = new NemoDatabase("slaQuoteItem", 0, null, 0);
$dbXPlan->Fields["refQuoteID"] = $QuoteID;
$dbXPlan->Fields["refServiceID"] = $_POST["refServiceIDXPlan"];
$dblRateYear1 = $_POST["dblRateYear1"][$ServiceID];
$dblRateYear1 = str_replace(",", "", $dblRateYear1);
$dbXPlan->Fields["dblRateYear1"] = $dblRateYear1;
$dblRateMaintenance = $_POST["dblRateMaintenance"][$ServiceID];
$dblRateMaintenance = str_replace(",", "", $dblRateMaintenance);
$dbXPlan->Fields["dblRateMaintenance"] = $dblRateMaintenance;
$dbXPlan->Fields["strRateType"] = $_POST["strRateTypeXPlan"];
$dbXPlan->Fields["strLastUser"] = $_SESSION['USER']->USERNAME;
$result = $dbXPlan->Save(0,0);
self::updateQuoteTotalCost($QuoteID);
}
if(isset($_POST["refServiceIDValuation"]))
{
$ServiceID = $_POST["refServiceIDValuation"];
$dbValuationPlan = new NemoDatabase("slaQuoteItem", 0, null, 0);
$dbValuationPlan->Fields["refQuoteID"] = $QuoteID;
$dbValuationPlan->Fields["refServiceID"] = $_POST["refServiceIDValuation"];
$dblRateYear1 = $_POST["dblRateYear1"][$ServiceID];
$dblRateYear1 = str_replace(",", "", $dblRateYear1);
$dbValuationPlan->Fields["dblRateYear1"] = $dblRateYear1;
$dblRateMaintenance = $_POST["dblRateMaintenance"][$ServiceID];
$dblRateMaintenance = str_replace(",", "", $dblRateMaintenance);
$dbValuationPlan->Fields["dblRateMaintenance"] = $dblRateMaintenance;
$dbValuationPlan->Fields["strRateType"] = $_POST["strRateTypeValuation"];
$dbValuationPlan->Fields["strLastUser"] = $_SESSION['USER']->USERNAME;
$result = $dbValuationPlan->Save(0,0);
self::updateQuoteTotalCost($QuoteID);
}
if($_POST["radEnableAdditionalLicenses"] == 1)
{
foreach ($_POST["chkAdditionalService"] as $intRowGroup => $rowServiceQuoteItem)
{
$row = $xdb->getRowSQL("SELECT max(intRowGroup) as 'intNewRowGroup' FROM slaQuoteItem");
$intNewRowGroup = $row->intNewRowGroup + 1;
foreach ($rowServiceQuoteItem as $ServiceID => $rowQuoteItem)
{
$dbAdditionalLicenses = new NemoDatabase("slaQuoteItem", 0, null, 0);
$dbAdditionalLicenses->Fields["refQuoteID"] = $QuoteID;
$dbAdditionalLicenses->Fields["refServiceID"] = $ServiceID;
$dbAdditionalLicenses->Fields["strPlannerName"] = $_POST["strPlannerName"][$intRowGroup];
$dbAdditionalLicenses->Fields["intRowGroup"] = $intRowGroup;
if($intRowGroup < 0)
{
$dbAdditionalLicenses->Fields["intRowGroup"] = $intNewRowGroup;
}
$dblRateYear1 = $_POST["dblRateYear1"][$ServiceID];
$dblRateYear1 = str_replace(",", "", $dblRateYear1);
$dbAdditionalLicenses->Fields["dblRateYear1"] = $dblRateYear1;
$dblRateMaintenance = $_POST["dblRateMaintenance"][$ServiceID];
$dblRateMaintenance = str_replace(",", "", $dblRateMaintenance);
$dbAdditionalLicenses->Fields["dblRateMaintenance"] = $dblRateMaintenance;
$dbAdditionalLicenses->Fields["strRateType"] = "Maintenance";
$dbAdditionalLicenses->Fields["strLastUser"] = $_SESSION['USER']->USERNAME;
$result = $dbAdditionalLicenses->Save(0,0);
}
}
self::updateQuoteTotalCost($QuoteID);
}
//print_rr($result);
if($result->Error == 1){
return $result->Message;
}else{
return "Details Saved. ";
}
}
public static function DuplicateQuote(&$QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
//duplicate Quote
$row = $xdb->getRowSQL("SELECT * FROM slaQuote WHERE QuoteID = ".$xdb->qs($QuoteID));
//default values //status is set to Draft, Version is incrimented
$QuoteIDOld = $QuoteID; //used for copying quote items
$strVersion = $row->strVersion;
//if the quote already has a timestamp in it, remove it and save a new one
if (preg_match('/_\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}/', $row->strQuote))
{
$strQuote = $row->strQuote;
$strQuote = substr($strQuote, 0, -20);
$strQuote = $strQuote."_".date("Y-m-d G:i:s");
}
else
{
$strQuote = $row->strQuote."_".date("Y-m-d G:i:s");
}
$strStatus = "Draft";
$dtCreationDate = date("Y-m-d");
$strLastUser = "Duplicate Quote - ".$_SESSION["USER"]->USERNAME;
//check if string is a float or integer and incriment appropriately
if(is_numeric($row->strVersion))
{
if(strpos($row->strVersion,'.') !== false)//if a float
{
$strVersion = (float)((float)$row->strVersion + 0.1);
}
else
{
$strVersion = ((int)$row->strVersion + 1);
}
}
//$strQuote = $row->strQuote ."$strVersion";
$db = new NemoDatabase("slaQuote", 0, null, 0);
$db->Fields["refWPSID"] = $row->refWPSID;
$db->Fields["strQuote"] = $strQuote;
$db->Fields["strStatus"] = $strStatus;
$db->Fields["strVersion"] = $strVersion;
$db->Fields["strPartner"] = $row->strPartner;
$db->Fields["strPartnerType"] = $row->strPartnerType;
$db->Fields["strClient"] = $row->strClient;
$db->Fields["strTel"] = $row->strTel;
$db->Fields["strEmail"] = $row->strEmail;
$db->Fields["txtAddress"] = $row->txtAddress;
$db->Fields["dtCreationDate"] = date("Y-m-d");
$db->Fields["dtAgreementStartDate"] = "NULL";
$db->Fields["dblTotalCostPerPlannerMaintenance"] = $row->dblTotalCostPerPlannerMaintenance;
$db->Fields["dblTotalCostPerPlannerYear1"] = $row->dblTotalCostPerPlannerYear1;
$db->Fields["dblTotalCostMaintenance"] = $row->dblTotalCostMaintenance;
$db->Fields["dblTotalCostYear1"] = $row->dblTotalCostYear1;
$db->Fields["txtNotes"] = $row->txtNotes;
$db->Fields["strLastUser"] = $strLastUser;
$result = $db->Save(0,0);
$QuoteID = $db->ID["QuoteID"];
// $xdb->doQuery("INSERT INTO slaQuote
// (refWPSID, strQuote, strStatus, strVersion, strPartner, strPartnerType, strClient, strTel, strEmail, txtAddress, dtCreationDate, dblTotalCostYear1, dblTotalCostMaintenance, dblTotalCostPerPlannerYear1, dblTotalCostPerPlannerMaintenance, txtNotes, strLastUser)
// SELECT refWPSID, strQuote, '$strVersion', '$strStatus', strPartner, strPartnerType, strClient, strTel, strEmail, txtAddress, '$dtCreationDate', dblTotalCostYear1, dblTotalCostMaintenance, dblTotalCostPerPlannerYear1, dblTotalCostPerPlannerMaintenance, txtNotes, 'Duplicate Quote - ".$_SESSION["USER"]->USERNAME."'
// FROM slaQuote
// WHERE QuoteID = ".$xdb->qs($QuoteID));
//print_rr($result);
if($result->Error == 1)
{
return $result->Message;
}
else
{
$xdb->doQuery("INSERT INTO slaQuoteItem
(refQuoteID, refServiceID, strPlannerName, strRateType, dblRateYear1, dblRateMaintenance, strLastUser)
SELECT ".$db->ID["QuoteID"].", refServiceID, strPlannerName, strRateType, dblRateYear1, dblRateMaintenance, '$strLastUser'
FROM slaQuoteItem
WHERE refQuoteID = ".$xdb->qs($QuoteIDOld),0);
return "Quote Copied. ";
}
}
//20160314 - Finalize depreciated as status is now ALWAYS proposal - Christiaan
// public static function Finalize($QuoteID)
// {
// global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
// //save total to Quote
// $xdb->doQuery("UPDATE slaQuote SET strStatus = 'Proposal'
// WHERE QuoteID = ".$xdb->qs($QuoteID));
// return "Proposal Finalized. ";
// }
public static function updateQuoteTotalCost($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
$dblTotalCost = 0;
$rowQuote = $xdb->getRowSQL("SELECT slaQuote.*, vieWPS.strWPS
FROM slaQuote INNER JOIN vieWPS on slaQuote.refWPSID = vieWPS.WPSID
WHERE QuoteID = ".$xdb->qs($QuoteID),0);
// print_rr($rowQuote);
//go
$rowQuoteItem = $xdb->getRowSQL("
SELECT SUM(dblRateYear1) as 'dblCostYear1',SUM(dblRateMaintenance) as 'dblCostMaintenance'
FROM slaQuoteItem
WHERE refQuoteID=".$xdb->qs($QuoteID)."",0);
$dblTotalCostYear1 = $rowQuoteItem->dblCostYear1;
$dblTotalCostMaintenance = $rowQuoteItem->dblCostMaintenance;
$intPercentDiscount = 0;
if($rowQuote->strPartnerType == Quote::$STRATEGIC_PARTNER)
{
$intPercentDiscount += $SystemSettings["SLADiscountStratPartner"];
}
if($intPlannerCount > 9)
{
$intPercentDiscount += $SystemSettings["SLADiscount10Planners"];
}
else if($intPlannerCount > 4)
{
$intPercentDiscount += $SystemSettings["SLADiscount5Planners"];
}
if($intPercentDiscount > 0)
{
$dblDiscount = round(($intPercentDiscount / 100) * $dblCost);
$dblTotalCostYear1 = $dblTotalCostYear1 - $dblDiscount;
$dblCostMaintenance = $dblTotalCostMaintenance - $dblDiscount;
}
$dblTotalCostPerPlannerYear1 = round($dblTotalCostYear1/12);
$dblTotalCostPerPlannerMaintenance = round($dblTotalCostMaintenance/12);
//save total to Quote
$xdb->doQuery("UPDATE slaQuote SET dblTotalCostYear1 = $dblTotalCostYear1, dblTotalCostMaintenance = $dblTotalCostMaintenance, dblTotalCostPerPlannerYear1 = $dblTotalCostPerPlannerYear1,dblTotalCostPerPlannerMaintenance = $dblTotalCostPerPlannerMaintenance
WHERE QuoteID = ".$xdb->qs($QuoteID));
}
public static function updateQuoteFileName($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
$strFileName = self::getFileName($QuoteID);
//save total to Quote
$xdb->doQuery("UPDATE slaQuote SET strFileName = '$strFileName'
WHERE QuoteID = ".$xdb->qs($QuoteID));
}
public static function addQuoteItem($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
$db = new NemoDatabase("slaQuoteItem", 0, null, 0);
$db->Fields["refQuoteID"] = $QuoteID;
$db->Fields["refServiceID"] = 0;
$db->Fields["dblRateYear1"] = 0;
$db->Fields["dblRateMaintenance"] = 0;
$db->Fields["strRateType"] = "Year 1";
$db->Fields["strLastUser"] = $_SESSION['USER']->USERNAME;
$result = $db->Save(0,0);
//print_rr($result);
if($result->Error == 1){
return $result->Message;
}else{
return "Item Added. ";
}
}
public static function Delete($chkSelect)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
//print_rr($chkSelect);
if(count($chkSelect) > 0){
foreach($chkSelect as $key => $value)
{
$xdb->doQuery("DELETE FROM slaQuote WHERE QuoteID = ". $xdb->qs($key));
//$xdb->doQuery("UPDATE slaQuote SET blnActive = 0 WHERE QuoteID = ". $xdb->qs($key));
$xdb->doQuery("DELETE FROM slaQuoteItem WHERE refQuoteID = ". $xdb->qs($key));
}
return "Records Deleted. ";
}
}
public static function DeleteQuoteItem($QuoteItemID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
// print_rr($_POST); die;
//check if the page has been reloaded on the delete
$row = $xdb->getRowSQL("SELECT QuoteItemID FROM slaQuoteItem WHERE QuoteItemID = ". $xdb->qs($QuoteItemID));
if($row)
{
$xdb->doQuery("DELETE FROM slaQuoteItem WHERE QuoteItemID = ". $xdb->qs($QuoteItemID));
return "Record Deleted. ";
}
else
{
return "Record does not exist or may have already been deleted.";
}
}
public static function DeleteAdditionalLicense($QuoteID, $intDeletedRowGroup)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
// print_rr($_POST); die;
//Preload array
$arrService = array();
$rstService = $xdb->doQuery("SELECT * FROM slaService WHERE slaService.strType='Additional License' ORDER BY intDisplayOrder,strService DESC",0);
while($rowService = $xdb->fetch_object($rstService))
{
$arrService[$rowService->ServiceID] = $rowService;
}
//print_rr($arrService); //die;
//go
$rstQI = $xdb->doQuery("
SELECT `intRowGroup`,`refServiceID`,QuoteItemID, slaQuoteItem.strPlannerName
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Additional License')
ORDER BY intRowGroup,ServiceID",0);
while($rowQI = $xdb->fetch_object($rstQI))
{
$arrServiceGroup[$rowQI->intRowGroup][$rowQI->refServiceID] = $rowQI->QuoteItemID;
}
foreach ($arrServiceGroup[$intDeletedRowGroup] AS $ServiceID => $QuoteItem)
{
$xdb->doQuery("DELETE FROM slaQuoteItem WHERE QuoteItemID = $QuoteItem");
}
return "Record(s) Deleted. ";
}
public static function generateQuoteSummaryContentHTML($QuoteID, $blnPDF=0, $strXPlanSummary)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
$rowServiceIBC = $xdb->getRowSQL("SELECT * FROM slaService WHERE blnIBC = 1", 0); //20181126 - IBC Course - pj
$rowServiceAssetMapPlanner = $xdb->getRowSQL("SELECT * FROM slaService WHERE blnAssetMapPlanner = 1", 0); //20181126 - IBC Course - pj
$rowServiceAssetMapAdmin = $xdb->getRowSQL("SELECT * FROM slaService WHERE blnAssetMapAdmin = 1", 0); //20181126 - IBC Course - pj
//used mainly to calculate the discount
$rowQuote = $xdb->getRowSQL("
SELECT slaQuote.*, vieWPS.strWPS
FROM slaQuote INNER JOIN vieWPS on slaQuote.refWPSID = vieWPS.WPSID
WHERE QuoteID = ".$xdb->qs($QuoteID)
, 0);
//20191121 - Add 5% increase as of 1 January 2020 - Rachel
//Pricing Increase effective as of 1 April 2020
$intPriceIncreaseMultiply = 1;
if(strtotime($rowQuote->dtAgreementStartDate) >= strtotime("2020-07-01")){
$intPriceIncreaseMultiply = 1.05; //5% incre
}
$dblTotalRateYear1 = 0;
$dblTotalRateMaintenance = 0;
$dblTotalRatePerPlannerYear1 = 0;
$dblTotalRatePerPlannerYear1 = 0;
//Preload array *****************************************************************
$rstFP = $xdb->doQuery("
SELECT slaQuoteItem.*, slaService.strService
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Financial Planner Service')
ORDER BY slaQuoteItem.strPlannerName", 0);
while($rowFP = $xdb->fetch_object($rstFP))
{
// print_rr($rowFP);
$arrServiceFPS[$rowFP->QuoteItemID] = $rowFP;
if($rowFP->intIBC != 0)
$arrIBC[$rowFP->strPlannerName] = $rowFP->strPlannerName; //20181126 - IBC Course - pj
if($rowFP->intAssetMapPlanner != 0)
$arrAssetMapPlanner[$rowFP->strPlannerName] = $rowFP->strPlannerName; //20191120 - Asset Map Pilot Planner License - Rachel
if($rowFP->intAssetMapAdmin != 0)
$arrAssetMapAdmin[$rowFP->strPlannerName] = $rowFP->strPlannerName; //20191120 - Asset Map Pilot Planner License - Rachel
}//print_rr(arrServiceFPS); print_rr($arrIBC);
if(!$arrServiceFPS){ //Corporate Partner
$rstFP = $xdb->doQuery("
SELECT slaQuoteItem.*
FROM slaQuoteItem
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND refServiceID =0
ORDER BY slaQuoteItem.strPlannerName", 0);
while($rowFP = $xdb->fetch_object($rstFP))
{
// print_rr($rowFP);
$arrServiceFPS[$rowFP->QuoteItemID] = $rowFP;
if($rowFP->intIBC != 0)
$arrIBC[$rowFP->strPlannerName] = $rowFP->strPlannerName; //20181126 - IBC Course - pj
if($rowFP->intAssetMapPlanner != 0)
$arrAssetMapPlanner[$rowFP->strPlannerName] = $rowFP->strPlannerName; //20191120 - Asset Map Pilot Planner License - Rachel
if($rowFP->intAssetMapAdmin != 0)
$arrAssetMapAdmin[$rowFP->strPlannerName] = $rowFP->strPlannerName; //20191120 - Asset Map Pilot Planner License - Rachel
}//print_rr(arrServiceFPS); print_rr($arrIBC);
}
if(!$arrAssetMapPlanner && !$arrAssetMapAdmin){
$rowMap = $xdb->getRowSQL("SELECT *
FROM slaQuoteItem
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (intAssetMapPlanner = 1 OR intAssetMapAdmin = 1)
ORDER BY slaQuoteItem.strPlannerName",0);
if($rowMap->intAssetMapPlanner == 1){
$arrServiceFPS[$rowMap->QuoteItemID] = $rowMap;
$arrAssetMapPlanner[$rowMap->strPlannerName] = $rowMap->strPlannerName;
}
if($rowMap->intAssetMapAdmin == 1){
$arrServiceFPS[$rowMap->QuoteItemID] = $rowMap;
$arrAssetMapAdmin[$rowMap->strPlannerName] = $rowMap->strPlannerName;
}
}
// print_rr($arrAssetMapAdmin);
// print_rr($arrIBC);
//select all BMS except Xplan (ID = 8)
$rstBMS = $xdb->doQuery("
SELECT slaQuoteItem.QuoteItemID,slaQuoteItem.strRateType,(slaQuoteItem.dblRateYear1*$intPriceIncreaseMultiply) AS dblRateYear1,(slaQuoteItem.dblRateMaintenance*$intPriceIncreaseMultiply) AS dblRateMaintenance,slaService.strService
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Business Management Service' AND slaService.ServiceID != 8 AND slaService.ServiceID != 34)
ORDER BY intDisplayOrder",0);
while($rowBMS = $xdb->fetch_object($rstBMS))
{
$arrServiceBMS[$rowBMS->QuoteItemID] = $rowBMS;
}
//select Xplan BMS (ID = 8)
$rstXPlan = $xdb->doQuery("
SELECT slaQuoteItem.QuoteItemID,slaQuoteItem.strRateType,(slaQuoteItem.dblRateYear1*$intPriceIncreaseMultiply) AS dblRateYear1,(slaQuoteItem.dblRateMaintenance*$intPriceIncreaseMultiply) AS dblRateMaintenance,slaService.strService
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Business Management Service' AND slaService.ServiceID = 8)
ORDER BY intDisplayOrder",0);
while($rowXPlan = $xdb->fetch_object($rstXPlan))
{
$arrServiceXPlan[$rowXPlan->QuoteItemID] = $rowXPlan;
}
//go
//*************************************************************************************************
//**************************** Financial Planning section **********************************
//*************************************************************************************************
$dblSubTotalRate = 0;
if(count($arrServiceFPS) == 0)
{
$arrServiceFPS[0] = "";
}
$strContentInnerDetailFP = "";
// print_rr($arrServiceFPS);
foreach ($arrServiceFPS AS $QuoteItemID => $rowQuoteItem)
{
$strPlannerName = $rowQuoteItem->strPlannerName;
$strServiceDetail = $rowQuoteItem->strService." - ".$rowQuoteItem->strRateType;
if($arrIBC[$strPlannerName]){//20181205 - IBC Course - pj :: changes/add
// $strServiceDetail .= $BR. "*". $rowServiceIBC->strService;
$strIBCService = $rowServiceIBC->strService;
$strIBCServiceRateYear1 += $rowServiceIBC->dblCostYear1;
$strIBCServiceRateMaintenance += $rowServiceIBC->dblCostMaintenance;
$arrIBCPlanners[$strPlannerName]["IBCService"] = $rowServiceIBC->strService;
$arrIBCPlanners[$strPlannerName]["IBCCostYear1"] = $rowServiceIBC->dblCostYear1;
$arrIBCPlanners[$strPlannerName]["IBCCostMaintenance"] = $rowServiceIBC->dblCostMaintenance;
}
$strAssetMapPlanner = $strPlannerName;
if($arrAssetMapPlanner[$strPlannerName]){//20181205 - IBC Course -
$strAssetMapPlannerService = $rowServiceAssetMapPlanner->strService;
$strAssetMapPlannerServiceRateYear1 = $rowServiceAssetMapPlanner->dblCostYear1;
$strAssetMapPlannerServiceRateMaintenance = $rowServiceAssetMapPlanner->dblCostMaintenance;
$arrAssetMapPlanner = "";
}
if($arrAssetMapAdmin[$strPlannerName]){//20181205 - IBC Course - pj :: changes/add
// $strServiceDetail .= $BR. "*". $rowServiceIBC->strService;
$strAssetMapAdminService = $rowServiceAssetMapAdmin->strService;
$strAssetMapAdminServiceRateYear1 = $rowServiceAssetMapAdmin->dblCostYear1;
$strAssetMapAdminServiceRateMaintenance = $rowServiceAssetMapAdmin->dblCostMaintenance;
}
$strRateYear1 = number_format($rowQuoteItem->dblRateYear1*$intPriceIncreaseMultiply,2, '.', ',');
$strRateMaintenance = number_format($rowQuoteItem->dblRateMaintenance*$intPriceIncreaseMultiply,2, '.', ',');
$strConcatServiceDetail = $strPlannerName ." - ". $strServiceDetail;
if($QuoteItemID == 0 || $rowQuote->strPartnerType == "Strategic Partner (Acsis Legacy only)" || strpos($strConcatServiceDetail, '- -') !== false)
{
$strPlannerName = "";
$strServiceDetail = "n/a";
$strRateYear1 = "0";
$strRateMaintenance = "0";
$strConcatServiceDetail = $strServiceDetail;
//$strConcatServiceDetail = "Financial Planning Services - ".$strServiceDetail;
}
// $strContentInnerDetailFP .= "
//
//
//
//
//
// $strPlannerName
//
//
// $strServiceDetail
//
//
//
//
//
// $strRateYear1
//
//
// $strRateMaintenance
// ";
$strContentInnerDetailFP .= "
$strConcatServiceDetail
R$strRateYear1
R$strRateMaintenance
";
$strContentInnerDetailFPPDF .= "
$strConcatServiceDetail
R$strRateYear1
R$strRateMaintenance
";
// print_rr($arrIBCPlanners);
if($rowQuoteItem->strRateType == "Maintenance")
{
$dblSubTotalRateYear1 +=($rowQuoteItem->dblRateMaintenance*$intPriceIncreaseMultiply);
$dblTotalRateYear1 += ($rowQuoteItem->dblRateMaintenance*$intPriceIncreaseMultiply);
}
else
{
$dblSubTotalRateYear1 += ($rowQuoteItem->dblRateYear1*$intPriceIncreaseMultiply);
$dblTotalRateYear1 +=($rowQuoteItem->dblRateYear1*$intPriceIncreaseMultiply);
}
$dblSubTotalRateMaintenance += ($rowQuoteItem->dblRateMaintenance*$intPriceIncreaseMultiply);
$dblTotalRateMaintenance += ($rowQuoteItem->dblRateMaintenance*$intPriceIncreaseMultiply);
}
//20160210 show planner items -requested by Pj - done byChristiaan
//Hide if Acsis Legacy only client
// if($rowQuote->strPartnerType != "Strategic Partner (Acsis Legacy only)"){
if($blnPDF == 1)
{
$strContentDetail .= "
Financial Planning Services
Fees per Planner
";
$strContentDetail .= "$strContentInnerDetailFPPDF";
//
//
//
//
// ".number_format($dblSubTotalRateYear1,0, '.', ',')."
//
//
// ".number_format($dblSubTotalRateMaintenance,0, '.', ',')."
//
// ";
}
else
{
$strContentDetail .= "
Financial Planning Services
Fees per Planner
";
$strContentDetail .= "$strContentInnerDetailFP";
//
// Sub Total
//
// ".number_format($dblSubTotalRateYear1,0, '.', ',')."
//
//
// ".number_format($dblSubTotalRateMaintenance,0, '.', ',')."
//
// ";
}
// }
//*************************************************************************************************
//**************************** BMS section **********************************
//*************************************************************************************************
$dblSubTotalRateYear1 = 0;
$dblSubTotalRateMaintenance = 0;
$blServiceBMS = true;
if(count($arrServiceBMS) == 0)
{
$arrServiceBMS[0] = "";
$blServiceBMS = false;
}
$strContentInnerDetailBMS = "";
$strServiceDetailPDF = "";
foreach ($arrServiceBMS AS $QuoteItemID => $rowQuoteItem)
{
$strPlannerName = $rowQuoteItem->strPlannerName;
$strServiceDetail = $rowQuoteItem->strService." - ".$rowQuoteItem->strRateType;
$strRateYear1 = number_format($rowQuoteItem->dblRateYear1,2, '.', ',');
$strRateMaintenance = number_format($rowQuoteItem->dblRateMaintenance ,2, '.', ',');
$strServiceDetailPDF = "- ".$strServiceDetail;
if($QuoteItemID == 0)
{
$strPlannerName = "";
$strServiceDetail = "n/a";
$strServiceDetailPDF = "";
$strRateYear1 = "0";
$strRateMaintenance = "0";
}
// $strContentInnerDetailBMS .= "
//
//
//
//
//
// $SP
//
//
// $strServiceDetail
//
//
//
//
//
// $strRateYear1
//
//
// $strRateMaintenance
// ";
$strContentInnerDetailBMS .= "
$strServiceDetail
R$strRateYear1
R$strRateMaintenance
";
if($rowQuoteItem->strRateType == "Maintenance")
{
$dblSubTotalRateYear1 +=$rowQuoteItem->dblRateMaintenance;
$dblTotalRateYear1 += $rowQuoteItem->dblRateMaintenance;
}
else
{
$dblSubTotalRateYear1 += $rowQuoteItem->dblRateYear1;
$dblTotalRateYear1 +=$rowQuoteItem->dblRateYear1;
}
$dblSubTotalRateMaintenance += $rowQuoteItem->dblRateMaintenance;
$dblTotalRateMaintenance += $rowQuoteItem->dblRateMaintenance;
}
// if($blnPDF == 1)
// {
// $strContentDetail .= "
//
// Business Management Services (BMS) $strServiceDetailPDF
//
//
// ".number_format($dblSubTotalRateYear1,0, '.', ',')."
//
//
// ".number_format($dblSubTotalRateMaintenance,0, '.', ',')."
//
// ";
// }
// else
// {
if( ($rowQuote->strPartnerType != "Strategic Partner (Acsis Legacy only)" && $blServiceBMS !== false) || $strContentInnerDetailBMS !="")
{
$strContentDetail .= "
Business Management Services (BMS)
Fees per Practice
";
$strContentDetail .= "
$strContentInnerDetailBMS";
}
//*************************************************************************************************
//**************************** Additional Licenses *Individual* **********************************
//*************************************************************************************************
//Preload array
$arrService = array();
$rstService = $xdb->doQuery("SELECT * FROM slaService WHERE slaService.strType='Additional License' ORDER BY intDisplayOrder,strService DESC",0);
while($rowService = $xdb->fetch_object($rstService))
{
$arrService[$rowService->ServiceID] = $rowService;
}
// //print_rr($arrService);
$row = $xdb->getRowSQL("
SELECT ServiceID, count(ServiceID) as 'intServiceCount', strService,SUM(dblRateYear1*$intPriceIncreaseMultiply) as 'dblRateYear1', SUM(dblRateMaintenance*$intPriceIncreaseMultiply) as 'dblRateMaintenance'
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Additional License')
GROUP BY ServiceID",0);
if($row)
{
foreach($arrService AS $ServiceID => $rowService)
{
$arrServiceAL = array();
$rstAL = $xdb->doQuery("
SELECT slaQuoteItem.QuoteItemID,slaQuoteItem.strPlannerName,slaQuoteItem.strRateType,(slaQuoteItem.dblRateYear1*$intPriceIncreaseMultiply) AS dblRateYear1,(slaQuoteItem.dblRateMaintenance*$intPriceIncreaseMultiply) AS dblRateMaintenance,slaService.strService
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Additional License') AND ServiceID=$ServiceID
ORDER BY intDisplayOrder",0);
while($rowAL = $xdb->fetch_object($rstAL))
{
$arrServiceAL[$rowAL->QuoteItemID] = $rowAL;
}
$strContentInnerDetailAL = "";
foreach ($arrServiceAL AS $QuoteItemID => $rowQuoteItem)
{
$strPlannerName = $rowQuoteItem->strPlannerName;
$strServiceDetail = $rowQuoteItem->strService.($strPlannerName==""?"":" - ".$strPlannerName);
$strRateYear1 = number_format($rowQuoteItem->dblRateYear1,2, '.', ',');
$strRateMaintenance = number_format($rowQuoteItem->dblRateMaintenance ,2, '.', ',');
if($QuoteItemID == 0)
{
$strPlannerName = "";
$strServiceDetail = "$rowService->strService";
$strRateYear1 = "0";
$strRateMaintenance = "0";
}
$strContentInnerDetailAL .= "
$strServiceDetail
R$strRateYear1
R0
";
$dblTotalRateYear1 += $rowQuoteItem->dblRateYear1;
//$dblTotalRateMaintenance += $rowQuoteItem->dblRateMaintenance;
}
$strContentInnnerDetail .= "
$strContentInnerDetailAL
";
}
//
// Additional Licenses
//
//
//
//
//
//
//
$strContentDetail .= "
$strContentInnnerDetail";
}
else
{
// $strContentDetail .= "
//
// Additional Licenses
//
//
//
//
//
//
//
//
// n/a
//
//
//
//
//
//
// ";
}
//*************************************************************************************************
//**************************** XPLAN section **********************************
//*************************************************************************************************
$dblSubTotalRateYear1 = 0;
$dblSubTotalRateMaintenance = 0;
if(count($arrServiceXPlan) == 0)
{
$arrServiceXPlan[0] = "";
}
//print_rr($arrServiceXPlan);
$strContentInnerDetailXPlan = "";
foreach ($arrServiceXPlan AS $QuoteItemID => $rowQuoteItem)
{
$strPlannerName = $rowQuoteItem->strPlannerName;
$strServiceDetail = $rowQuoteItem->strService." - ".$rowQuoteItem->strRateType;
$strRateYear1 = number_format($rowQuoteItem->dblRateYear1,2, '.', ',');
$strRateMaintenance = number_format($rowQuoteItem->dblRateMaintenance,2, '.', ',');
if($QuoteItemID == 0)
{
$strPlannerName = "";
$strServiceDetail = "n/a";
$strRateYear1 = "";
$strRateMaintenance = "";
if($rowQuote->strPartnerType != Quote::$STRATEGIC_PARTNER)
{
$strRateYear1 = "";
$strRateMaintenance = "";
}
}
// $strContentInnerDetailXPlan .= "
//
//
//
//
//
// $SP
//
//
// $strServiceDetail
//
//
//
//
//
// $strRateYear1
//
//
// $strRateMaintenance
// ";
$strContentInnerDetailXPlan .= "
$strServiceDetail
R$strRateYear1
R$strRateMaintenance
";
if($rowQuoteItem->strRateType == "Maintenance")
{
$dblSubTotalRateYear1 +=$rowQuoteItem->dblRateMaintenance;
$dblTotalRateYear1 += $rowQuoteItem->dblRateMaintenance;
}
else
{
$dblSubTotalRateYear1 += $rowQuoteItem->dblRateYear1;
$dblTotalRateYear1 +=$rowQuoteItem->dblRateYear1;
}
$dblSubTotalRateMaintenance += $rowQuoteItem->dblRateMaintenance;
$dblTotalRateMaintenance += $rowQuoteItem->dblRateMaintenance;
if($strServiceDetail != "n/a"){
$XplanSelected = "true";
}else{
$XplanSelected = "false";
}
}
// if($blnPDF == 1)
// {
// $strContentDetail .= "
//
// Old Mutual Wealth Xplan Multi-site (CRMIntegrator)
//
//
// ".number_format($dblSubTotalRateYear1,0, '.', ',')."
//
//
// ".number_format($dblSubTotalRateMaintenance,0, '.', ',')."
//
// ";
// }
// else
// {
//20180326 - remove all mention of (CRMIntegrator) and replace with "OM Wealth Xplan Multi-site" - CL
if($XplanSelected == "true"){
$strContentDetail .= "
Client Relationship Management (CRM) Tools
Fees per Practice
";
$strContentDetail .= "$strContentInnerDetailXPlan";
}
//
// Sub Total
//
// ".number_format($dblSubTotalRateYear1,0, '.', ',')."
//
//
// ".number_format($dblSubTotalRateMaintenance,0, '.', ',')."
//
// ";
//}
//*************************************************************************************************
//**************************** totals **********************************
//*************************************************************************************************
//1. check the discount
$arrDiscount = array();
$blnPercentDiscountCheck = 0;
$trDiscount = "";
$intPlannerCount = count($arrServiceFPS);
$dblTotalPreDiscountYear1 = $dblTotalRateYear1;
$dblTotalPreDiscountMaintenance = $dblTotalRateMaintenance;
if($rowQuote->strPartnerType == Quote::$STRATEGIC_PARTNER)
{
$arrDiscount[1]->strPercentDiscount += "".($SystemSettings["SLADiscountStratPartner"] * 100);
$arrDiscount[1]->intPercentDiscount += $SystemSettings["SLADiscountStratPartner"];
$arrDiscount[1]->strDiscountDescription = "Less ".$arrDiscount[1]->strPercentDiscount."% (Strategic Partner Discount)";
$blnPercentDiscountCheck = 1;
}
if($intPlannerCount > 9)
{
$arrDiscount[2]->strPercentDiscount += "".($SystemSettings["SLADiscount10Planners"] * 100);
$arrDiscount[2]->intPercentDiscount += $SystemSettings["SLADiscount10Planners"];
$arrDiscount[2]->strDiscountDescription = "Less ".$arrDiscount[2]->strPercentDiscount."% (10 Planners or more)";
$blnPercentDiscountCheck = 1;
}
else if($intPlannerCount > 4)
{
$arrDiscount[2]->strPercentDiscount += "".($SystemSettings["SLADiscount5Planners"] * 100);
$arrDiscount[2]->intPercentDiscount += $SystemSettings["SLADiscount5Planners"];
$arrDiscount[2]->strDiscountDescription = "Less ".$arrDiscount[2]->strPercentDiscount."% (5 Planners or more)";
$blnPercentDiscountCheck = 1;
}
if($blnPercentDiscountCheck == 1)
{
$trDiscount .= "
Sub Total
R".number_format($dblTotalRateYear1,2, '.', ',')."
R".number_format($dblTotalRateMaintenance,2, '.', ',')."
";
$dblTotalDiscountYear1 = 0;
$dblTotalDiscountMaintenance = 0;
foreach($arrDiscount AS $intCount => $rowDiscount)
{
//print_rr($rowDiscount);
$dblDiscountYear1 = $rowDiscount->intPercentDiscount * $dblTotalPreDiscountYear1;
$dblDiscountMaintenance = $rowDiscount->intPercentDiscount * $dblTotalPreDiscountMaintenance;
$dblTotalDiscountYear1 = $dblDiscountYear1;
$dblTotalDiscountMaintenance = $dblDiscountMaintenance;
$dblTotalRateYear1 = $dblTotalRateYear1 - $dblTotalDiscountYear1;
$dblTotalRateMaintenance = $dblTotalRateMaintenance - $dblTotalDiscountMaintenance;
$trDiscount .= "
$rowDiscount->strDiscountDescription
R-".number_format($dblTotalDiscountYear1,2, '.', ',')."
R-".number_format($dblTotalDiscountMaintenance,2, '.', ',')."
";
}
}
//20180320 - Add if Statement to make VAT 14% if createDate of Proposal is < "20180401"
$VAT = $SystemSettings[VAT];
if(strtotime($rowQuote->dtCreationDate) < strtotime("2018-04-01") && strtotime(date("Y-m-d")) >= strtotime("2018-04-01"))
{
$VAT = 0.14;
}
$strTotalPayableAmountY1 = $dblTotalRateYear1;
$strTotalPayableAmountOngoing = $dblTotalRateMaintenance;
//Exclude Map Asset from VAT
$strTotalPayableY1VAT = ( $strTotalPayableAmountY1 / (1 + $VAT)) * $VAT;
$strTotalPayableOngoingVAT = ($strTotalPayableAmountOngoing / (1 + $VAT)) * $VAT;
$strMonthlyDebitAmountY1 = round( ($strTotalPayableAmountY1) /12 , 2);
$strMonthlyDebitAmountOngoing = round(($strTotalPayableAmountOngoing) /12 , 2);
$strAverageMonthlyPerPlannerY1 = round(($strMonthlyDebitAmountY1/$intPlannerCount),2);
$strAverageMonthlyPerPlannerOngoing = round(($strMonthlyDebitAmountOngoing/$intPlannerCount),2);
$trDiscount .= "
Total Basic Services R".number_format($dblTotalRateYear1,2, '.', ',')."
R".number_format($dblTotalRateMaintenance,2, '.', ',')."
Monthly Debit Order Amount
R".number_format($strMonthlyDebitAmountY1,2, '.', ',')."
R".number_format($strMonthlyDebitAmountOngoing,2, '.', ',')."
Average monthly fee Per Planner
R".number_format( $strAverageMonthlyPerPlannerY1 ,2, '.', ',')."
R".number_format($strAverageMonthlyPerPlannerOngoing,2, '.', ',')."
";
//2. get the totals
$intPlannerCount = count($arrServiceFPS) != 0?count($arrServiceFPS):1;
$dblTotalRateMonthlyDebitYear1 = round ($dblTotalRateYear1 / 12);
$dblTotalRateMonthlyDebitMaintenance = round ($dblTotalRateMaintenance / 12);
$dblTotalRatePerPlannerYear1 = round($dblTotalRateMonthlyDebitYear1 /$intPlannerCount);
$dblTotalRatePerPlannerMaintenance = round($dblTotalRateMonthlyDebitMaintenance /$intPlannerCount);
$strTotalRatePerPlannerYear1 = number_format($dblTotalRatePerPlannerYear1,2, '.', ',');
$strTotalRatePerPlannerMaintenance = number_format($dblTotalRatePerPlannerMaintenance,2, '.', ',');
if($intPlannerCount == 0 || isset($arrServiceFPS[0]))
{
$strTotalRatePerPlannerYear1 = "0";
$strTotalRatePerPlannerMaintenance = "0";
}
$dblTotalVATYear1 = ($dblTotalRateYear1 / (1 + $VAT)) * $VAT;
$dblTotalVATMaintenance = ($dblTotalRateMaintenance / (1 + $VAT)) * $VAT;
$strContentTotals = "
R$trDiscount
";
// "
// Monthly debit order amount
// ".number_format($dblTotalRateMonthlyDebitYear1,0, '.', ',')."
//
//
// ".number_format($dblTotalRateMonthlyDebitMaintenance,0, '.', ',')."
//
//
//
// Average monthly fee per planner
// $strTotalRatePerPlannerYear1
//
//
// $strTotalRatePerPlannerMaintenance
//
// "
//20181126 - IBC Course - pj
//20181205 - IBC Course - pj :: changes/removed
// $strIBC = "";
// if(count($arrIBC) > 0)
// {
// foreach($arrIBC as $strPlannerName){
// $strIBC .= "
$strPlannerName - $rowServiceIBC->strService ";
// }
// $strIBC = "
//
";
// //if(count($arrIBC) > 1){
// $dblRate = round(10000 / 12, 2); //vd($dblRate);
// $strIBC .= "
//
*Note that the fees for the above course, R10 000 per person (including VAT), will be deducted by means of an additional debit order, over 12 months
// , at a rate of R". number_format($dblRate, 2,'.',',')." per person per month
// , starting in December 2018 and ending in November 2019 . ";
// //}
//
//**********************Additional Services**************
$strAdditionalServicesContent = "";
if($strIBCService){
foreach ($arrIBCPlanners as $Planner => $rowPlanner) {
// print_rr($rowPlanner["IBCCostMaintenance"]);
$strAdditionalServicesContent .= "
".str_replace("(Cape Town): R10,000", "($Planner)",$rowServiceIBC->strService)."
Fees per Planner
R".number_format($rowPlanner["IBCCostMaintenance"],2, '.', ',')."
";
}
}
// if($strIBCService){
// $strAdditionalServicesContent .= "
//
//
// ".str_replace("(Cape Town): R10,000", "($strAssetMapPlanner)",$rowServiceIBC->strService)."
//
// Fees per Planner
//
// R".number_format($strIBCServiceRateMaintenance,2, '.', ',')."
//
// ";
// }
if($strAssetMapPlannerService){
$strAdditionalServicesContent .= "
".$rowServiceAssetMapPlanner->strService. " ($strAssetMapPlanner)" ."
Fees per Planner
R".number_format($strAssetMapPlannerServiceRateMaintenance,2, '.', ',')."
";
}
if($strAssetMapAdminService){
$strAdditionalServicesContent .= "
".$rowServiceAssetMapAdmin->strService."
Fees per Administrator
R".number_format($strAssetMapAdminServiceRateMaintenance,2, '.', ',')."
";
}
$rstValuationService = $xdb->doQuery("
SELECT slaQuoteItem.QuoteItemID,slaQuoteItem.strRateType,(slaQuoteItem.dblRateYear1*$intPriceIncreaseMultiply) AS dblRateYear1,(slaQuoteItem.dblRateMaintenance*$intPriceIncreaseMultiply) AS dblRateMaintenance,slaService.strService
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Business Management Service' AND slaService.ServiceID = 34)
ORDER BY intDisplayOrder
LIMIT 1",0);
$strValuationServiceRateYear1 = 0;
$strValuationServiceRateMaintenance = 0;
while($rowValuation = $xdb->fetch_object($rstValuationService))
{
$arrServiceValuation[$rowValuation->QuoteItemID] = $rowValuation;
$strValuationServiceRateYear1 = $rowValuation->dblRateYear1;
$strValuationServiceRateMaintenance = $rowValuation->dblRateMaintenance;
$strValuationServiceRateOngoing = $strValuationServiceRateYear1/12;
$strAdditionalServicesValuationContent .= "
".$rowValuation->strService."
Fees per Practice
R".number_format($strValuationServiceRateOngoing,2, '.', ',')."
";
}
$intAdditionalServicesY1 = $strIBCServiceRateYear1+$strAssetMapPlannerServiceRateYear1+$strAssetMapAdminServiceRateYear1+$strValuationServiceRateYear1;
$intAdditionalServicesOngoing = $strIBCServiceRateMaintenance+$strAssetMapPlannerServiceRateMaintenance+$strAssetMapAdminServiceRateMaintenance+$strValuationServiceRateOngoing;
$strAddionalServicesContentTotal = "
Total Additional Services
R".number_format($intAdditionalServicesOngoing,2, '.', ',')."
";
if($strAssetMapAdminService || $strAssetMapPlannerService || $strIBCService || isset($arrServiceValuation)){
$AdditionalServicesTable = "
Additional Services
Details
Monthly cost
$strAdditionalServicesContent
$strAdditionalServicesValuationContent
$strAddionalServicesContentTotal
";
}
//********************Summary of fees table**************
if($rowQuote->strPartnerType != "Strategic Partner (Acsis Legacy only)"){
$trAdditionalServices = "
Additional Services
R".
number_format($intAdditionalServicesY1,2, '.', ',')."
R".
number_format($intAdditionalServicesOngoing,2, '.', ',')."
";
}
$strFeeSummaryContentTotal = "
Basic Services
R".number_format($dblTotalRateYear1,2, '.', ',')."
R".number_format($dblTotalRateMaintenance,2, '.', ',')."
Total Fee payable (including ".($VAT*100)."% VAT)
R".
number_format($strTotalPayableAmountY1,2, '.', ',')."
R".
number_format($strTotalPayableAmountOngoing,2, '.', ',')."
Monthly Debit Order Amount
R".number_format($strMonthlyDebitAmountY1,2, '.', ',')."
R".number_format($strMonthlyDebitAmountOngoing,2, '.', ',')."
Average monthly fee Per Planner
R".number_format( $strAverageMonthlyPerPlannerY1 ,2, '.', ',')."
R".number_format($strAverageMonthlyPerPlannerOngoing,2, '.', ',')."
";
$FeeSummaryTable = "
Summary of Fees
$strFeeSummaryContentTotal
";
//*************************************************************************************************
//**************************** OUTPUT CONTENT **********************************
//*************************************************************************************************
$dtAgreementStartDate = ($rowQuote->dtAgreementStartDate == "" ? date("Y-m-d"): $rowQuote->dtAgreementStartDate);
$strContent = "
Fee Summary
Basic Services
Details
Fees Year 1
Fees Ongoing
$strContentDetail
$strContentTotals
$AdditionalServicesTable $BR
*All pricing includes VAT @".($VAT*100)."% except for the Asset Map licence fee (if selected) Year 1 (R ".number_format($strTotalPayableY1VAT,2, '.', ',').") Ongoing (R ".number_format($strTotalPayableOngoingVAT,2, '.', ',').").
*Your monthly debit order will be adjusted to recover the costs for the additional services.
";
if($rowQuote->strPartnerType != "Strategic Partner (Acsis Legacy only)" && $strIBCService){
$strContent .= "
*The Integrated Behavioural Coaching Course has a duration of twelve months only. Your debit order will be adjusted once the full R10,000 cost per planner has been recovered.
"; //% = %; @= @
}
if($strAssetMapAdminService || $strAssetMapPlannerService){
$strContent .= "
*Asset Map licence fee is a reduced fee that we have negotiated on behalf of our partners. The provider, Work that Matters is not registered for VAT and all fees recovered wil be paid over to them for your licence. Should you wish to cancel your licence please inform us before the 20th of the month to adjust your debit order timeously.
"; //% = %; @= @
}
if($strValuationServiceRateYear1 != ""){
$strContent .= "
*The Valuation Service has a cost of R8000 per client book being valued. Your debit order will be adjusted once the full R8,000 has been recovered.
"; //% = %; @= @
}
$strContent .= "
";
if($XplanSelected == "true"){
return $strContent;
}elseif ($XplanSelected == "false" && $strXPlanSummary != "") {
return "";
}else{
return $strContent;
}
}
public static function generateQuoteFinancialPlanningContentHTML($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
//Preload array *****************************************************************
$rowQuote = $xdb->getRowSQL("SELECT * FROM slaQuote WHERE QuoteID = '$QuoteID'");
$intPriceIncreaseMultiply = 1;
if(strtotime($rowQuote->dtAgreementStartDate) >= strtotime("2020-07-01")){
$intPriceIncreaseMultiply = 1.05; //5% incre
}
$rowServiceIBC = $xdb->getRowSQL("SELECT ServiceID, strType, (dblCostYear1) AS dblRateYear1, '0' AS dblRateMaintenance, strService FROM slaService WHERE blnIBC = 1", 0); //20181126 - IBC Course - pj
$rowServiceMapAssetAdmin = $xdb->getRowSQL("SELECT ServiceID, strType, (dblCostYear1) AS dblRateYear1, (dblCostMaintenance) AS dblRateMaintenance, strService FROM slaService WHERE blnAssetMapAdmin = 1", 0);
$rowServiceMapAssetPlanner = $xdb->getRowSQL("SELECT ServiceID, strType, (dblCostYear1) AS dblRateYear1, (dblCostMaintenance) AS dblRateMaintenance, strService FROM slaService WHERE blnAssetMapPlanner = 1 ", 0);
$rstFP = $xdb->doQuery("
SELECT slaQuoteItem.intAssetMapAdmin,intIBC, intAssetMapPlanner, slaQuoteItem.QuoteItemID,slaQuoteItem.strRateType,slaQuoteItem.strPlannerID,(slaQuoteItem.dblRateYear1*$intPriceIncreaseMultiply) AS dblRateYear1,(slaQuoteItem.dblRateMaintenance*$intPriceIncreaseMultiply) AS dblRateMaintenance,slaQuoteItem.strPlannerName, slaService.strService
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Financial Planner Service')
ORDER BY slaQuoteItem.strPlannerName",0);
while($rowFP = $xdb->fetch_object($rstFP))
{
$arrServiceFPS[$rowFP->QuoteItemID] = $rowFP;
if($rowFP->intIBC == 1){
// print_rr($rowFP);
$arrServiceFPS[$rowFP->strPlannerName] = $rowServiceIBC;
$arrServiceFPS[$rowFP->strPlannerName]->strPlannerName = $rowFP->strPlannerName;
}
if($rowFP->intAssetMapPlanner == 1){
$arrServiceFPS[$rowServiceMapAssetPlanner->ServiceID] = $rowServiceMapAssetPlanner;
$arrServiceFPS[$rowServiceMapAssetPlanner->ServiceID]->strPlannerName = $rowFP->strPlannerName;
}
if($rowFP->intAssetMapAdmin == 1){
$arrServiceFPS[$rowServiceMapAssetAdmin->ServiceID] = $rowServiceMapAssetAdmin;
$arrServiceFPS[$rowServiceMapAssetAdmin->ServiceID]->strPlannerName = $rowFP->strPlannerName;
}
}
// print_rr($arrServiceFPS);
if(!$arrServiceFPS){
$rstFP = $xdb->doQuery("
SELECT slaQuoteItem.intAssetMapAdmin,intIBC, intAssetMapPlanner, slaQuoteItem.QuoteItemID,slaQuoteItem.strRateType,slaQuoteItem.strPlannerID,(slaQuoteItem.dblRateYear1*$intPriceIncreaseMultiply) AS dblRateYear1,(slaQuoteItem.dblRateMaintenance*$intPriceIncreaseMultiply) AS dblRateMaintenance,slaQuoteItem.strPlannerName
FROM slaQuoteItem
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND refServiceID = 0
ORDER BY slaQuoteItem.strPlannerName",0);
while($rowFP = $xdb->fetch_object($rstFP))
{
// $arrServiceFPS[$rowFP->QuoteItemID] = $rowFP;
if($rowFP->intIBC == 1){
// print_rr($rowFP);
$arrServiceFPS[$rowFP->strPlannerName] = $rowServiceIBC;
$arrServiceFPS[$rowFP->strPlannerName]->strPlannerName = $rowFP->strPlannerName;
}
if($rowFP->intAssetMapPlanner == 1){
$arrServiceFPS[$rowServiceMapAssetPlanner->ServiceID] = $rowServiceMapAssetPlanner;
$arrServiceFPS[$rowServiceMapAssetPlanner->ServiceID]->strPlannerName = $rowFP->strPlannerName;
}
if($rowFP->intAssetMapAdmin == 1){
$arrServiceFPS[$rowServiceMapAssetAdmin->ServiceID] = $rowServiceMapAssetAdmin;
$arrServiceFPS[$rowServiceMapAssetAdmin->ServiceID]->strPlannerName = $rowFP->strPlannerName;
}
}
}
//go
$dblSubTotalRateYear1 = 0;
$dblSubTotalRateMaintenance = 0;
if(count($arrServiceFPS) == 0)
{
$arrServiceFPS[0] = "";
}
// print_rr($arrServiceFPS);
$strContentDetail = "";
foreach ($arrServiceFPS AS $QuoteItemID => $rowQuoteItem)
{
$strPlannerName = $rowQuoteItem->strPlannerName;
$strServiceDetail = ucwords($rowQuoteItem->strService);
$strPlannerID = $rowQuoteItem->strPlannerID;
if((strpos($strServiceDetail, 'Integrated Behavioural Coaching Course') !== false))
{
$strServiceDetail =str_replace("(Cape Town): R10,000", "",$strServiceDetail);
}
$strRateYear1 = number_format($rowQuoteItem->dblRateYear1,2, '.', ',');
if((strpos($strServiceDetail, 'Asset Map') !== false))
{
$strRateMaintenance = number_format($rowQuoteItem->dblRateYear1,2, '.', ',');
}else{
$strRateMaintenance = number_format($rowQuoteItem->dblRateMaintenance,2, '.', ',');
}
if($QuoteItemID == 0 && !is_string($QuoteItemID))
{
$strPlannerName = "n/a";
$strServiceDetail = "n/a";
$strPlannerID = "n/a";
$strRateYear1 = "0";
$strRateMaintenance = "0";
}
$strContentDetail .= "
$strPlannerName
$strServiceDetail
R$strRateYear1
R$strRateMaintenance
";
$dblSubTotalRateYear1 += $rowQuoteItem->dblRateYear1;
if((strpos($strServiceDetail, 'Asset Map') !== false))
{
$dblSubTotalRateMaintenance += $rowQuoteItem->dblRateYear1;
}else{
$dblSubTotalRateMaintenance += $rowQuoteItem->dblRateMaintenance;
}
}
$strContentTotals = "
Total
R
".number_format($dblSubTotalRateYear1,2, '.', ',')."
R
".number_format($dblSubTotalRateMaintenance,2, '.', ',')."
";
//*************************************************************************************************
//**************************** OUTPUT CONTENT **********************************
//*************************************************************************************************
$strContent = "
Planner Name
Service Option
Year 1
Ongoing
$strContentDetail
$strContentTotals
"; //% = %; @= @
return $strContent;
}
public static function generateQuoteBMSContentHTML($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
//Preload array *****************************************************************
$rowQuote = $xdb->getRowSQL("SELECT * FROM slaQuote WHERE QuoteID = '$QuoteID'");
$intPriceIncreaseMultiply = 1;
if(strtotime($rowQuote->dtAgreementStartDate) >= strtotime("2020-07-01")){
$intPriceIncreaseMultiply = 1.05; //5% incre
}
$rstBMS = $xdb->doQuery("
SELECT slaQuoteItem.QuoteItemID,slaQuoteItem.strRateType,(slaQuoteItem.dblRateYear1*$intPriceIncreaseMultiply) AS dblRateYear1,(slaQuoteItem.dblRateMaintenance*$intPriceIncreaseMultiply) AS dblRateMaintenance, slaService.strService
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Business Management Service' AND slaService.ServiceID != 8 )
GROUP BY QuoteItemID, refQuoteID
ORDER BY intDisplayOrder
",0);
while($rowBMS = $xdb->fetch_object($rstBMS))
{
$arrServiceBMS[$rowBMS->QuoteItemID] = $rowBMS;
}
//go
$dblSubTotalRateYear1 = 0;
$dblSubTotalRateMaintenance = 0;
if(count($arrServiceBMS) == 0)
{
$arrServiceBMS[0] = "";
return "";
}
$strContentDetail = "";
foreach ($arrServiceBMS AS $QuoteItemID => $rowQuoteItem)
{
$strServiceDetail = $rowQuoteItem->strService;
// switch($rowQuoteItem->strRateType)
// {
// case "Year 1";
// $strRateYear1 = number_format($rowQuoteItem->dblRate,0, '.', ',');
// $strRateMaintenance = "";
// break;
// case "Maintenance":
// $strRateYear1 = "";
// $strRateMaintenance = number_format($rowQuoteItem->dblRate,0, '.', ',');
// break;
// }
$strRateYear1 = number_format($rowQuoteItem->dblRateYear1,2, '.', ',');
$strRateMaintenance = number_format($rowQuoteItem->dblRateMaintenance,2, '.', ',');
if($QuoteItemID == 0)
{
$strServiceDetail = "n/a";
$strRateYear1 = "0";
$strRateMaintenance = "0";
}
$strContentDetail .= "
$strServiceDetail
R$strRateYear1
R$strRateMaintenance
";
$dblSubTotalRateYear1 += $rowQuoteItem->dblRateYear1;
$dblSubTotalRateMaintenance += $rowQuoteItem->dblRateMaintenance;
}
$strContentTotals = "
Total
R".number_format($dblSubTotalRateYear1,2, '.', ',')."
R".number_format($dblSubTotalRateMaintenance,2, '.', ',')."
";
//*************************************************************************************************
//**************************** OUTPUT CONTENT **********************************
//*************************************************************************************************
$strContent = "
Service Option
Year 1
Ongoing
$strContentDetail
$strContentTotals
"; //% = %; @= @
return $strContent;
}
public static function generateQuoteXPlanContentHTML($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
//Preload array *****************************************************************
$rowQuote = $xdb->getRowSQL("SELECT * FROM slaQuote WHERE QuoteID = '$QuoteID'");
$intPriceIncreaseMultiply = 1;
if(strtotime($rowQuote->dtAgreementStartDate) >= strtotime("2020-07-01")){
$intPriceIncreaseMultiply = 1.05; //5% incre
}
//select Xplan BMS (ID = 8)
$rstXPlan = $xdb->doQuery("
SELECT slaQuoteItem.QuoteItemID,slaQuoteItem.strRateType,(slaQuoteItem.dblRateYear1*$intPriceIncreaseMultiply) AS dblRateYear1,(slaQuoteItem.dblRateMaintenance*$intPriceIncreaseMultiply) AS dblRateMaintenance, slaService.strService
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Business Management Service' AND slaService.ServiceID = 8 )
ORDER BY intDisplayOrder",0);
while($rowXPlan = $xdb->fetch_object($rstXPlan))
{
$arrServiceXPlan[$rowXPlan->QuoteItemID] = $rowXPlan;
}
//go
$dblSubTotalRateYear1 = 0;
$dblSubTotalRateMaintenance = 0;
if(count($arrServiceXPlan) == 0)
{
$arrServiceXPlan[0] = "";
}
$strContentDetail = "";
foreach ($arrServiceXPlan AS $QuoteItemID => $rowQuoteItem)
{
$strServiceDetail = $rowQuoteItem->strService;
// switch($rowQuoteItem->strRateType)
// {
// case "Year 1";
// $strRateYear1 = number_format($rowQuoteItem->dblRate,2, '.', ',');
// $strRateMaintenance = "";
// break;
// case "Maintenance":
// $strRateYear1 = "";
// $strRateMaintenance = number_format($rowQuoteItem->dblRate,2, '.', ',');
// break;
// }
$strRateYear1 = number_format($rowQuoteItem->dblRateYear1,2, '.', ',');
$strRateMaintenance = number_format($rowQuoteItem->dblRateMaintenance,2, '.', ',');
if($QuoteItemID == 0)
{
$strServiceDetail = "n/a";
$strRateYear1 = "0";
$strRateMaintenance = "0";
}
$strContentDetail .= "
$strServiceDetail
$strRateYear1
$strRateMaintenance
";
$dblSubTotalRateYear1 += $rowQuoteItem->dblRateYear1;
$dblSubTotalRateMaintenance += $rowQuoteItem->dblRateMaintenance;
}
$strContentTotals = "
Total
".number_format($dblSubTotalRateYear1,2, '.', ',')."
".number_format($dblSubTotalRateMaintenance,2, '.', ',')."
";
//*************************************************************************************************
//**************************** OUTPUT CONTENT **********************************
//*************************************************************************************************
$strContent = "
Service Option
Year 1
Ongoing
$strContentDetail
$strContentTotals
"; //% = %; @= @
return $strContent;
}
public static function generateQuoteAdditionalLicensesContentHTML($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
//Preload array *****************************************************************
$rowQuote = $xdb->getRowSQL("SELECT * FROM slaQuote WHERE QuoteID = '$QuoteID'");
$intPriceIncreaseMultiply = 1;
if(strtotime($rowQuote->dtAgreementStartDate) >= strtotime("2020-07-01")){
$intPriceIncreaseMultiply = 1.05; //5% incre
}
$arrService = array();
$rstService = $xdb->doQuery("SELECT * FROM slaService WHERE slaService.strType='Additional License' ORDER BY intDisplayOrder,strService DESC",0);
while($rowService = $xdb->fetch_object($rstService))
{
$arrService[$rowService->ServiceID] = $rowService;
}
//print_rr($arrService); //die;
//go
$rstQI = $xdb->doQuery("
SELECT `intRowGroup`,`refServiceID`,QuoteItemID, slaQuoteItem.strPlannerName
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Additional License')
ORDER BY strPlannerName, intRowGroup,ServiceID",0);
//preload
$intRowGroup = $intUniqueID;
while($rowQI = $xdb->fetch_object($rstQI))
{
$arrServiceGroup[$rowQI->intRowGroup][$rowQI->refServiceID] = $rowQI->QuoteItemID;
}
$intCounter = 0;
foreach($arrServiceGroup AS $intRowGroup => $rowQuoteService)
{
$trContentInner = "";
$intCounter++;
foreach($arrService AS $ServiceID => $rowService)
{
//$QuoteItemID = $intUniqueID;
if(isset($rowQuoteService[$ServiceID]))
{
$row = $xdb->getRowSQL("
SELECT slaQuoteItem.*
FROM slaQuoteItem
WHERE QuoteItemID=".$rowQuoteService[$ServiceID],0);
$strPlannerName = $row->strPlannerName;
$trContentInner .= "
Yes
";
${"dblTotalCostMaintenance".$ServiceID} += ($row->dblRateMaintenance*$intPriceIncreaseMultiply) ;
}
else
{
$trContentInner .= "
No
";
}
}
$trContent .= "
$strPlannerName ";
}
//build heading
$tdHeading = "";
foreach ($arrService AS $ServiceID => $rowService)
{
//print_rr($rowService);
$tdHeading .= "
".$rowService->strService." (R".number_format($rowService->dblCostYear1*$intPriceIncreaseMultiply,2, '.', ',')." per License)
";
if(count($arrServiceGroup) == 0)
{
//leave 0 on a new line as the pdf engine has issues reading it next to the tags on one line -christiaan
$tdTotalDetailInner .="
0
";
$trContentBlankInner .= "
0
";
}
else
{
$tdTotalDetailInner .="
".(number_format(${"dblTotalCostMaintenance".$ServiceID},2, '.', ','))." ";
}
}
if(count($arrServiceGroup) == 0)
{
$trContent .= "
n/a ";
}
$trTotal = "
Totals ";
if(count($arrServiceGroup) != 0){
return "
Name
$trContent
$trTotal
";
}else{
return "";
}
}
//dont delete this method unless we are sure that we cant use it later.
//This method creates an alternative style of list using a table instead of
// Yes! It actually works. Its not a complete hack, it looks decent. - Christiaan
public static function generateQuoteFinancialPlanningTermsHTML($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
//20181126 - IBC Course - pj
$blnIBC = false;
$blnAssetMapAdmin = false;
$blnAssetMapPlanner = false;
$rowServiceIBC = $xdb->getRowSQL("SELECT * FROM slaService WHERE blnIBC = 1", 0); //20181126 - IBC Course - pj
$rowServiceMapAsset = $xdb->getRowSQL("SELECT * FROM slaService WHERE blnAssetMapAdmin = 1 OR blnAssetMapPlanner = 1 LIMIT 1", 0);
//Preload array *****************************************************************
$rstFP = $xdb->doQuery("
SELECT slaQuoteItem.*, slaService.*
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Financial Planner Service')
ORDER BY slaService.intDisplayOrder", 0); //die("ksdffno");
while($rowFP = $xdb->fetch_object($rstFP))
{
$arrServiceFPS[$rowFP->ServiceID] = $rowFP;
if($rowFP->intIBC == 1){
$blnIBC = true;
}
if($rowFP->intAssetMapAdmin == 1){
$blnAssetMapAdmin = true;
}
if($rowFP->intAssetMapPlanner == 1){
$blnAssetMapPlanner = true;
}
}
if (!$arrServiceFPS) {
$rstFP = $xdb->doQuery("
SELECT slaQuoteItem.*
FROM slaQuoteItem
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND refServiceID = 0
", 0); //die("ksdffno");
while($rowFP = $xdb->fetch_object($rstFP))
{
$arrServiceFPS[$rowFP->ServiceID] = $rowFP;
if($rowFP->intIBC == 1){
$blnIBC = true;
}
if($rowFP->intAssetMapAdmin == 1){
$blnAssetMapAdmin = true;
}
if($rowFP->intAssetMapPlanner == 1){
$blnAssetMapPlanner = true;
}
}
}
if($blnIBC){
$arrServiceFPS[$rowServiceIBC->ServiceID] = $rowServiceIBC;
}
if($blnAssetMapPlanner || $blnAssetMapAdmin){
$arrServiceFPS[$rowServiceMapAsset->ServiceID] = $rowServiceMapAsset;
}
//print_rr($arrServiceFPS); die("lsjkdfjnd");
//go
if(count($arrServiceFPS) == 0)
{
return "";
}
$strContentDetail = "";
foreach ($arrServiceFPS AS $ServiceID => $rowQuoteItem)
{
$strTermItems = str_replace(" ", "", $rowQuoteItem->txtReportTerms);
$strTermItems = str_replace("
", "", $strTermItems);
$strTermItems = str_replace(" ", "", $strTermItems);
$arrTermItems = explode("
", $strTermItems);
//20181126 - Only unset if array value is null, otherwise some of the terms are lost - Rachel
//unset($arrTermItems[0]);
if(ctype_space($arrTermItems[0])){
unset($arrTermItems[0]);
}
$strContentDetailInner = "";
foreach($arrTermItems AS $ID => $strReportTermItem)
{
//20181206 - $arrTermItems[0] is always a paragraph, make an exception not to add a bullet and do not indent - Rachel
if($ID != 0){
$strContentDetailInner .= "
". htmlentities("•")."
".mynl2br($strReportTermItem)."
";
}else{
$strContentDetailInner .= "
". mynl2br($strReportTermItem)."
";
}
}
// $blnIBC
if(strpos($rowQuoteItem->strService, "Asset Map") !== false)
{
$strContentDetail .= "".str_replace(": ADMIN LICENCE FEE", "", str_replace(': PLANNER LICENCE FEE', "", strtoupper("ASSET MAP LICENCE")))."
";
}else{
$strContentDetail .= "".str_replace(": ADMIN LICENCE FEE", "", str_replace(': PLANNER LICENCE FEE', "", strtoupper(mynl2br($rowQuoteItem->strService))))."
";
}
}
$strContentDetailInner = "";
$row = $xdb->getRowSQL("
SELECT slaService.ServiceID,slaService.strService,slaService.txtReportTerms
FROM slaService
WHERE ServiceID=-1",0);
$strTermItems = str_replace("", "", $row->txtReportTerms);
$strTermItems = str_replace("", "", $strTermItems);
$strTermItems = str_replace(" ", "", $strTermItems);
$arrTermItems = explode("", $strTermItems);
unset($arrTermItems[0]);
foreach($arrTermItems AS $ID => $strReportTermItem)
{
$strContentDetailInner .= "
". htmlentities("•")."
".mynl2br($strReportTermItem)."
";
}
$strContentDetail .= "".strtoupper(mynl2br($row->strService))."
";
//OUTPUT CONTENT
$strContent = "$strContentDetail";
return $strContent;
}
//generate terms using LI instead of a table
public function xgenerateQuoteFinancialPlanningTermsHTML($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
//Preload array *****************************************************************
$rstFP = $xdb->doQuery("
SELECT slaQuoteItem.QuoteItemID, slaService.ServiceID,slaService.strService,slaService.txtReportTerms
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Financial Planner Service')
ORDER BY slaService.intDisplayOrder",0);
while($rowFP = $xdb->fetch_object($rstFP))
{
$arrServiceFPS[$rowFP->ServiceID] = $rowFP;
}
//go
if(count($arrServiceFPS) == 0)
{
return "";
}
$strContentDetail = "";
foreach ($arrServiceFPS AS $ServiceID => $rowQuoteItem)
{
$strContentDetail .= "
".mynl2br($rowQuoteItem->strService)."
".mynl2br($rowQuoteItem->txtReportTerms);
}
$strContentDetailInner = "";
$row = $xdb->getRowSQL("
SELECT slaService.ServiceID,slaService.strService,slaService.txtReportTerms
FROM slaService
WHERE ServiceID=-1",0);
$strContentDetail .= "
".mynl2br($row->strService)."
".mynl2br($row->txtReportTerms);
//OUTPUT CONTENT
$strContent = "
$strContentDetail";
return $strContent;
}
public static function generateQuoteBMSTermsHTML($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
//Preload array *****************************************************************
$rstBMS = $xdb->doQuery("
SELECT slaQuoteItem.QuoteItemID, slaService.ServiceID,slaService.strService,slaService.txtReportTerms
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Business Management Service' AND slaService.ServiceID != 8 )
ORDER BY strPlannerName",0);
while($rowBMS = $xdb->fetch_object($rstBMS))
{
$arrServiceBMS[$rowBMS->ServiceID] = $rowBMS;
}
//go
if(count($arrServiceBMS) == 0)
{
return "";
}
$strContentDetail = "";
foreach ($arrServiceBMS AS $ServiceID => $rowQuoteItem)
{
$strTermItems = str_replace(" ", "", $rowQuoteItem->txtReportTerms);
$strTermItems = str_replace("", "", $strTermItems);
$strTermItems = str_replace(" ", "", $strTermItems);
$arrTermItems = explode("", $strTermItems);
unset($arrTermItems[0]);
$strContentDetailInner = "";
foreach($arrTermItems AS $ID => $strReportTermItem)
{
$strContentDetailInner .= "
". htmlentities("•")."
".mynl2br($strReportTermItem)."
";
}
$strContentDetail .= "".strtoupper(mynl2br($rowQuoteItem->strService))."
";
}
//OUTPUT CONTENT
$strContent = "$strContentDetail";
return $strContent;
}
public static function generateQuoteXPlanTermsHTML($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
//Preload array *****************************************************************
$rstXPlan = $xdb->doQuery("
SELECT slaQuoteItem.QuoteItemID, slaService.ServiceID,slaService.strService,slaService.txtReportTerms
FROM slaQuoteItem INNER JOIN slaService on refServiceID = ServiceID
WHERE refQuoteID=".$xdb->qs($QuoteID)." AND (slaService.strType='Business Management Service' AND slaService.ServiceID = 8)
ORDER BY strPlannerName",0);
while($rowXPlan = $xdb->fetch_object($rstXPlan))
{
$arrServiceXPlan[$rowXPlan->ServiceID] = $rowXPlan;
}
//go
if(count($arrServiceXPlan) == 0)
{
return "";
}
$strContentDetail = "";
foreach ($arrServiceXPlan AS $ServiceID => $rowQuoteItem)
{
$strTermItems = str_replace(" ", "", $rowQuoteItem->txtReportTerms);
$strTermItems = str_replace("", "", $strTermItems);
$strTermItems = str_replace(" ", "", $strTermItems);
$arrTermItems = explode("", $strTermItems);
unset($arrTermItems[0]);
$strContentDetailInner = "";
foreach($arrTermItems AS $ID => $strReportTermItem)
{
$strContentDetailInner .= "
". htmlentities("•")."
".mynl2br($strReportTermItem)."
";
}
$strContentDetail .= "".strtoupper(mynl2br($rowQuoteItem->strService))."
";
}
$strContentDetailInner = "";
$row = $xdb->getRowSQL("
SELECT slaService.ServiceID,slaService.strService,slaService.txtReportTerms
FROM slaService
WHERE ServiceID=-3",0);
$strTermItems = str_replace(" ", "", $row->txtReportTerms);
$strTermItems = str_replace("", "", $strTermItems);
$strTermItems = str_replace(" ", "", $strTermItems);
$arrTermItems = explode("", $strTermItems);
unset($arrTermItems[0]);
foreach($arrTermItems AS $ID => $strReportTermItem)
{
$strContentDetailInner .= "
". htmlentities("•")."
".mynl2br($strReportTermItem)."
";
}
$strContentDetail .= "".strtoupper(mynl2br($row->strService))."
";
//OUTPUT CONTENT
$strContent = "$strContentDetail";
return $strContent;
}
public static function previewQuote($QuoteID)
{
return self::generateQuoteSummaryContentHTML($QuoteID,0,"");
}
public static function generateQuotePDF($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
$rowQuote = $xdb->getRowSQL("SELECT slaQuote.*, vieWPS.strWPS ,vieWPS.strEmail as 'strWPSEmail'
FROM slaQuote INNER JOIN vieWPS on slaQuote.refWPSID = vieWPS.WPSID
WHERE QuoteID = ".$xdb->qs($QuoteID), 0);
include_once('./../htmltopdf/html2fpdf.php');
include_once('./../htmltopdf/toc.php');
include_once('./../htmltopdf/bookmark.php');
$pdf = new HTML2FPDF();
$pdf->startPageNums();
$pdf->SetTopMargin(20);
$pdf->AddPage();
$pdf->_numPageNum = 1;//fixes issue with fotter numbers being wrong
$pdf->FooterNumPages = 0; //fixes issue with page 2 not having a footer
//$pdf->AliasNbPages();
$pdf->SetAutoPageBreak(false);
$pdf->setBlnFooterTextOnly(1);
$pdf->setSystem("Proposal PDF");
//constants to check if the page content is too large by adding a page break
$height_of_cell = 60; // mm
$page_height = 286.93; // mm (portrait letter)
$page_max_height = $page_height - ($page_height/3);
$strStatusText = "";
//20160314 - Finalize depreciated as status is now ALWAYS proposal - Christiaan
//switch($rowQuote->strStatus)
//{
// case "Draft":
// $strStatusText = "$BR$BR"."DRAFT PROPOSAL";
// $strStatusTextFooter = "DRAFT PROPOSAL";
// break;
// case "Proposal":
// $strStatusText = "$BR$BR"."PROPOSAL";
// $strStatusTextFooter = "PROPOSAL";
// break;
// }
$pdf->bMargin = 10;
$pdf->FooterText = "Annexure D: Partner Programme Customised Benefit Statement $strStatusTextFooter for ".$_SESSION['PN']." as at ".date("d F Y")."";
$_SESSION['PN'] = $rowQuote->strPartner; //Practice Name used in html2fpdf for the footer generation: $this->FooterText for $_SESSION['PN'] as date("d F Y")
// if(file_exists("./../tools/images/layers/CelestisBATpdfimage.jpg"))
// $pdf->Image("./../tools/images/layers/CelestisBATpdfimage.jpg",50,$pdf->GetY(),190);
// if(file_exists("./images/SLA_PDF_Cover_Small.jpg"))
// $pdf->Image("./images/SLA_PDF_Cover_Small.jpg",40,$pdf->GetY(),190);
// if(file_exists("./images/SLA_PDF_Cover_Small_New1.jpg"))
// $pdf->Image("./images/SLA_PDF_Cover_Small_New1.jpg",60,$pdf->GetY(),190);
if(file_exists("./images/SLA_PDF_Cover_Small_New1.jpg"))
$pdf->Image("./images/SLA_PDF_Cover_Small_New1.jpg",0,0,210);
$pdf->fontsize = "24";
$pdf->SetFont('Arial','',20);
$strOutput = "$BR
ANNEXURE \"D\"$BR$BR CUSTOMISED BENEFIT STATEMENT $strStatusText
";//$rowQuote->strQuote - - $rowQuote->strStatus
$pdf->WriteHTML($strOutput);
$pdf->fontsize = "9";
$pdf->SetFont('Arial','',9);
//20181207 - Removed width from both tds TO accomodate longer emails - Rachel
$strOutput = "$BR $BR
Prepared for: Prepared by:
Name:
".mynl2br($rowQuote->strPartner)."
Old Mutual Wealth Services Company (Pty) Ltd
Contact:
".mynl2br($rowQuote->strClient)."
Reg No.
2012/100073/07
Email:
".mynl2br($rowQuote->strEmail)."
Prepared By:
".mynl2br($rowQuote->strWPS)."
Tel:
".mynl2br($rowQuote->strTel)."
Email:
".mynl2br($rowQuote->strWPSEmail)."
Type:
".mynl2br($rowQuote->strPartnerType)."
Date:
".mynl2br(date("j F Y"))."
";
$pdf->WriteHTML($strOutput);
if (file_exists("./../images/layers/Footer.jpg"))
{
$pdf->Image("./../images/layers/Footer.jpg", 10, 270, 190);
}
//**************************************f*****************************************************************************************************************
//** Summary and signature
//*******************************************************************************************************************************************************
$pdf->AddPage();
//$pdf->TOC_Entry('Agreement Summary', 0);
//$pdf->Bookmark('Agreement Summary');
$pdf->fontsize = "12";
$pdf->SetFont('Arial','',12);
$strOutputSummary = "
FEE SUMMARY
$BR";
$pdf->WriteHTML($strOutputSummary);
$pdf->fontsize = "8";
$pdf->SetFont('Arial','',8);
$strOutputSummary = "
Prepared for
Name:
".mynl2br($rowQuote->strPartner)."
Contact Person:
".mynl2br($rowQuote->strClient)."
Type:
".mynl2br($rowQuote->strPartnerType)."
$BR";
$pdf->WriteHTML($strOutputSummary);
$strOutputSummary = self::generateQuoteSummaryContentHTML($QuoteID,1,"");
$pdf->WriteHTML($strOutputSummary);
$strOutputSummary = "
$BR
Commencement date year 1: "
.($rowQuote->dtAgreementStartDate != ""? $rowQuote->dtAgreementStartDate:"_________________________")
."
Commencement date ongoing: "
.($rowQuote->dtAgreementStartDate != ""? date("Y-m-d",strtotime("$rowQuote->dtAgreementStartDate + 1 year")):"_________________________")
."
$BR $BR $BR";
// $strOutputSummary .= "
// Signed at ___________ on this ".date("jS")." day of ".date("F")." ".date("Y")."
//
";
$strOutputSummary .= "
Signed by: ____________________________ Signature: _________________________________
$BR $BR
At _____________________________ on this ___________________day _________________
";
$pdf->WriteHTML($strOutputSummary);
//*******************************************************************************************************************************************************
//** SERVICE DETAILS BEGIN
//*******************************************************************************************************************************************************
// if($rowQuote->strPartnerType != "Strategic Partner (Acsis Legacy only)"){
$pdf->AddPage();
$pdf->fontsize = "12";
$pdf->SetFont('Arial','',12);
$strOutputServiceDetails = "
SERVICE DETAILS
$BR";
$pdf->WriteHTML($strOutputServiceDetails);
//*******************************************************************************************************************************************************
//** Financial Planning Services
//*******************************************************************************************************************************************************
//$pdf->WriteHTML($strOutput);
//$pdf->AddPage();
//$pdf->TOC_Entry('Financial Planning Services', 0);
//$pdf->Bookmark('Financial Planning Services');
$pdf->fontsize = "12";
$pdf->SetFont('Arial','',12);
$strOutputFP = "
FINANCIAL PLANNING SERVICES
$BR";
$pdf->WriteHTML($strOutputFP);
$pdf->fontsize = "8";
$pdf->SetFont('Arial','',8);
$strOutputFP = "
Services are delivered per planner and include 1 support staff per planner $BR
";
$pdf->WriteHTML($strOutputFP);
$strOutputFP = self::generateQuoteFinancialPlanningContentHTML($QuoteID);
$pdf->WriteHTML($strOutputFP);
$strOutputFP = self::generateQuoteFinancialPlanningTermsHTML($QuoteID);
$pdf->WriteHTML($strOutputFP);
// die("Die");
//*******************************************************************************************************************************************************
//** BMS
//*******************************************************************************************************************************************************
//$pdf->TOC_Entry('Business Managment Services (BMS)', 0);
//$pdf->Bookmark('Business Managment Services (BMS)');
$strOutputBMS = self::generateQuoteBMSContentHTML($QuoteID);
if($strOutputBMS != ""){
//20180322 - Add page break infront of BMS section at PJ's request - CL
$pdf->AddPage();
$pdf->WriteHTML($blank);
if($page_max_height < $pdf->GetY())
{
$pdf->AddPage();
}
$pdf->fontsize = "12";
$pdf->SetFont('Arial','',12);
$strOutputBMS = "
BUSINESS MANAGEMENT SERVICES
$BR";
$pdf->WriteHTML($strOutputBMS);
$pdf->fontsize = "8";
$pdf->SetFont('Arial','',8);
$strOutputBMS = "
Services are delivered per practice $BR
";
$pdf->WriteHTML($strOutputBMS);
if($page_max_height < $pdf->GetY())
{
$pdf->AddPage();
}
$strOutputBMS = self::generateQuoteBMSContentHTML($QuoteID);
$pdf->WriteHTML($strOutputBMS);
$strOutputBMS = self::generateQuoteBMSTermsHTML($QuoteID);
$pdf->WriteHTML($strOutputBMS);
$strOutputBMS = $BR;
$pdf->WriteHTML($strOutputBMS);
}
// }
//*******************************************************************************************************************************************************
//** Additional Licenses
//*******************************************************************************************************************************************************
$pdf->WriteHTML($blank);
if($page_max_height < $pdf->GetY() || $rowQuote->strPartnerType == "Strategic Partner (Acsis Legacy only)")
{
$pdf->AddPage();
}
//$pdf->TOC_Entry('Additional Licenses', 0);
//$pdf->Bookmark('Additional Licenses');
if(self::generateQuoteAdditionalLicensesContentHTML($QuoteID) != ""){
$pdf->fontsize = "12";
$pdf->SetFont('Arial','',12);
$strOutputAdditionalLicenses = "
ADDITIONAL LICENSES
$BR";
$pdf->WriteHTML($strOutputAdditionalLicenses);
$pdf->fontsize = "8";
$pdf->SetFont('Arial','',8);
$strOutputAdditionalLicenses = self::generateQuoteAdditionalLicensesContentHTML($QuoteID);
$pdf->WriteHTML($strOutputAdditionalLicenses);
}
//*******************************************************************************************************************************************************
//** X PLAN
//*******************************************************************************************************************************************************
//$pdf->AddPage();
$pdf->WriteHTML($blank);
if($page_max_height < $pdf->GetY())
{
$pdf->AddPage();
}
//$pdf->TOC_Entry('Old Mutual Wealth Xplan Multi-site (CRMIntegrator)', 0);
//$pdf->Bookmark('Old Mutual Wealth Xplan Multi-site (CRMIntegrator)');
$XPlanSelected = self::generateQuoteSummaryContentHTML($QuoteID , 0, "XPlanSummary");
if($XPlanSelected != ""){
$pdf->fontsize = "12";
$pdf->SetFont('Arial','',12);
//20180326 - remove all mention of (CRMIntegrator) and replace with "OM Wealth Xplan Multi-site" - CL
$strOutputXPlan = "$BR
Client Relationship Management (CRM) Tools
$BR";
$pdf->WriteHTML($strOutputXPlan);
$pdf->fontsize = "8";
$pdf->SetFont('Arial','',8);
$strOutputXPlan = "
Services are delivered per practice $BR
";
$pdf->WriteHTML($strOutputXPlan);
if($page_max_height < $pdf->GetY())
{
$pdf->AddPage();
}
$strOutputXPlan = self::generateQuoteXPlanContentHTML($QuoteID);
$pdf->WriteHTML($strOutputXPlan);
$strOutputXPlan = self::generateQuoteXPlanTermsHTML($QuoteID);
$pdf->WriteHTML($strOutputXPlan);
}
//*******************************************************************************************************************************************************
//** output
//*******************************************************************************************************************************************************
//$pdf->stopPageNums();
//Generate and insert TOC at page 2
//$pdf->insertTOC(2);
$strLocation = "./documents/SLA/";
$strFileName = self::getFileName($QuoteID);
//20191117 - Set different footer on last page - Rachel
$pdf->_numberingFooter = false;
//20191117 - Set different footer on last page - Rachel
if(file_exists("./../images/Quote pdf footer.jpg")){
if($page_max_height < $pdf->GetY() && $rowQuote->strPartnerType != "Strategic Partner (Acsis Legacy only)")
{
$pdf->AddPage();
}
$pdf->Image("./../images/Quote pdf footer.jpg",0,269.5,160);
}
//output to file
$pdf->Output($strLocation.$strFileName, 'F');
self::updateQuoteFileName($QuoteID);
//output to this current tab
header("Content-type: application/pdf");
$pdf->Output($strFileName, 'I');
}
public static function getFileName($QuoteID)
{
global $xdb, $TR, $SP, $HR, $BR, $SystemSettings;
$rowQuote = $xdb->getRowSQL("SELECT slaQuote.* FROM slaQuote WHERE QuoteID = ".$xdb->qs($QuoteID),0);
$strPartner = self::cleanFileName($rowQuote->strPartner);
$strVersion = str_replace(" ","_",$rowQuote->strVersion);
$strVersion = strtolower(qs($strVersion));
$strStatus = str_replace(" ","_",$rowQuote->strStatus);
$strStatus = strtolower($strStatus);
//20180411 - Fix format of SLA filename - CL
return "annex_d_".$strPartner."_v".$strVersion."_".$strStatus.".pdf"; //date("Ymd")
}
//20180411 - Add cleanFilename function to remove unwanted characters and format string correctly - CL
public static function cleanFileName($string="")
{
$strCleanString = html_entity_decode($string, ENT_QUOTES, 'UTF-8');
$strCleanString = strtolower(qs($strCleanString));
//step 1: replace specific characters
$strCleanString = str_replace("\\", "", $strCleanString);
$strCleanString = str_replace("/", "", $strCleanString);
$strCleanString = str_replace('"', "", $strCleanString);
$strCleanString = str_replace("'", "", $strCleanString);
$strPartner = str_replace(" ","_",$rowQuote->strPartner); // spaces become underscores
//replace ¹ , ² , ³
$strCleanString = str_replace(chr(185), "1", $strCleanString);
$strCleanString = str_replace(chr(178), "2", $strCleanString);
$strCleanString = str_replace(chr(179), "3", $strCleanString);
//replace curly quotes
$strCleanString = str_replace(chr(145), "", $strCleanString);
$strCleanString = str_replace(chr(146), "", $strCleanString);
$strCleanString = str_replace(chr(147), "", $strCleanString);
$strCleanString = str_replace(chr(148), "", $strCleanString);
//replace – en and — em dash
$strCleanString = str_replace(chr(150), "-", $strCleanString);
$strCleanString = str_replace(chr(151), "-", $strCleanString);
//step 2: Removes unwanted special chars.
$strCleanString = preg_replace_callback("/[^a-zA-Z0-9_.-]/", function ($matches) {
return "";
}, $strCleanString);
return $strCleanString;
}
}
?>
";
//20180320 - Check if a Proposal contains inactive Services// used in process to disallow editing if its an old Proposal - CL
if(Quote::checkProposalContainsOnlyActiveServices($QuoteID))
{
$btnDelete = "