/**
* Member function to set banked value
* @param Double
* return void
*/
public function createTermImage($policynumber)
{
/**
* prepair data to build TermImage
*/
$this->_policynumber = $policynumber;
$this->_amount = 0;
$this->_months = 12;
$policyDisb = new Datasource_Insurance_LegacyPolicies();
$policy = $policyDisb->getByPolicyNumber($policynumber);
$this->_policyname = $policy->policyName;
$termDisb = new Datasource_Insurance_Policy_Term();
$term = $termDisb->getPolicyTerm($policynumber, $policy->startDate);
$this->_startdate = $policy->startDate;
$policy->termid = $term['id'];
$this->_getMult($policy);
$policyOptionsArray = explode("|", $policy->policyOptions);
$pItemHist = new Datasource_Insurance_Policy_PolicyTermItemHist();
foreach ($policyOptionsArray as $key => $value) {
$this->_initialise();
$option = new Datasource_Insurance_Policy_Options($policy->policyType);
$this->_optionID = $option->fetchOptionsByName($value);
$this->_sumInsOption = $policyDisb->getPolicyOptionMatch($policy->policyOptions, $value, $policy->amountsCovered);
$cover->sumInsured = $this->_sumInsOption;
if ($this->_sumInsOption > 0) {
$cover = new Model_Insurance_Cover();
$cover->policyOptionID = $this->_optionID;
$cover->sumInsured = $this->_sumInsOption;
$this->_premOption = $policyDisb->getPolicyOptionMatch($policy->policyOptions, $value, $policy->optionPremiums) * $this->_mult;
$this->_discOption = $policyDisb->getPolicyOptionMatch($policy->policyOptions, $value, $policy->optionDiscounts);
$this->_calculateTax();
$this->_calculateNet($policy, $value);
$cover->grosspremium = $this->_premOption + $this->_iptOption;
$cover->premium = $this->_premOption;
$cover->netpremium = $this->_netOption;
$cover->ipt = $this->_iptOption;
$pItemHist->setItemHist($policy, $cover);
}
}
}
/**
* Save the quote into the legacy database tables
*
* @munt 10
*/
protected function _saveToLegacy()
{
// Insert/Update the legacy customer table
// Check to see if we already have a legacy identifier
if (is_null($this->_quoteModel->legacyID) || $this->_quoteModel->legacyID == '') {
// This is the first save to legacy so we need to generate a new unique ID
// I say unique.. but ermm.. well you'll see *sigh*
$numberTracker = new Datasource_Core_NumberTracker();
$this->_quoteModel->legacyID = 'QHLI' . (string) $numberTracker->getNextPolicyNumber() . '/01';
$this->_quoteDataSource->save($this->_quoteModel);
// Do a quick save now we have a legacy quote number
}
$this->_quoteModel->policyNumber = $this->_quoteModel->legacyID;
$this->_quoteModel->policyLength = 12;
// Insert/Update the legacy quote table
$legacyQuote = new Model_Insurance_LegacyQuote();
$legacyQuote->policyNumber = $this->getLegacyID();
// Quote number
$legacyQuote->refNo = $this->getLegacyCustomerReference();
// Customer reference number
$legacyQuote->agentSchemeNumber = $this->getAgentSchemeNumber();
// Todo: This should be the agent scheme number for the selected agent!
$legacyQuote->policyName = 'landlordsp';
// Landlords+ quote/policy
$legacyQuote->issueDate = date('Y-m-d');
// Issued date - today
$legacyQuote->startDate = $this->getStartDate();
$legacyQuote->endDate = $this->getEndDate();
$legacyQuote->policyType = 'L';
$legacyQuote->policyLength = 12;
$legacyQuote->payStatus = $this->_quoteModel->status;
if ($this->getPayFrequency() == "ANNUALLY") {
$legacyQuote->payBy = "Annually";
}
$idd = new Datasource_Insurance_IddSupport();
if (!$idd->isIddSupport($legacyQuote->policyNumber)) {
$inserArray = array();
$insertArray['policynumber'] = $legacyQuote->policyNumber;
$insertArray['agentschemeno'] = $legacyQuote->agentSchemeNumber;
$insertArray['csuid'] = 0;
$fsaAgentStatusDatasource = new Datasource_Fsa_AgentStatus();
$fsaStatus = $fsaAgentStatusDatasource->getAgentFsaStatus($legacyQuote->agentSchemeNumber);
if (isset($fsaStatus['status_abbr'])) {
$insertArray['FSA_status'] = $fsaStatus['status_abbr'];
} else {
$insertArray['FSA_status'] = "";
}
$insertArray['origsaleid'] = 9;
$insertArray['callerid'] = 2;
$idd->setIddSupport($insertArray);
}
$properties = $this->getProperties();
$legacyQuote->propertyAddress1 = $properties[0]['line_1'];
$legacyQuote->propertyAddress2 = $properties[0]['line_2'];
$legacyQuote->propertyAddress3 = $properties[0]['town'];
$legacyQuote->propertyPostcode = $properties[0]['postcode'];
// Build the policy options pipe delimitted nonsense!!! FML
$premiums = $this->calculatePremiums();
if ($premiums != '') {
// Depending on if this is an annual or monthly quote we have to save different values in the database :(
if ($this->getPayFrequency() == "ANNUALLY") {
$legacyQuote->premium = $premiums['totalGrossAnnualPremium'];
$legacyQuote->quote = $premiums['totalGrossAnnualPremium'] + $premiums['totalGrossAnnualIPT'];
$legacyQuote->ipt = $premiums['totalGrossAnnualIPT'];
} else {
$legacyQuote->premium = $premiums['totalGrossMonthlyPremium'];
$legacyQuote->quote = $premiums['totalGrossMonthlyPremium'] + $premiums['totalGrossMonthlyIPT'];
$legacyQuote->ipt = $premiums['totalGrossMonthlyIPT'];
}
$this->_quoteModel->premium = $premiums['totalGrossMonthlyPremium'];
$this->_quoteModel->ipt = $premiums['totalGrossAnnualIPT'];
$legacyQuote->riskArea = $premiums['riskAreas']['buildingsAreaID'];
$legacyQuote->termid = $this->setPolicyTerm();
}
$mult = 1;
if ($this->getPayFrequency() == 'MONTHLY') {
$mult = 12;
}
$policyOptions = '';
$amountsCovered = '';
$optionPremiums = '';
$pItemHist = new Datasource_Insurance_Policy_PolicyTermItemHist();
$cover = new Model_Insurance_Cover();
// Get IPT percentage
$propertiesDatasource = new Datasource_Insurance_Quote_Properties();
$properties = $propertiesDatasource->getByQuoteID($this->_quoteModel->ID);
$postcode = $properties[0]['postcode'];
$taxDatasource = new Datasource_Core_Tax();
$tax = $taxDatasource->getTaxbyTypeAndPostcode('ipt', $postcode);
$ipt = 1 + $tax['rate'] / 100;
if ($premiums != '') {
if ($this->hasProduct(self::BUILDING_COVER) && $this->isValidValue($premiums['netBuilding'])) {
$policyOptions .= 'buildingsp|';
$amountsCovered .= $premiums['rebuildValue'] > 0 ? $premiums['rebuildValue'] : $premiums['calculatedDSIValue'];
$amountsCovered .= '|';
$optionPremiums .= round($premiums['annualBuilding'] / $mult, 2) . '|';
$cover->policyOptionID = 33;
$cover->sumInsured = $premiums['rebuildValue'] > 0 ? $premiums['rebuildValue'] : $premiums['calculatedDSIValue'];
$cover->grosspremium = round($premiums['annualBuilding'] * $ipt, 2);
$cover->premium = $premiums['annualBuilding'];
$cover->netpremium = $premiums['netBuilding'];
$cover->ipt = $cover->grosspremium - $cover->premium;
$pItemHist->setItemHist($legacyQuote, $cover);
if ($this->isValidValue($premiums['netBuildingAD'])) {
$policyOptions .= 'buildingsAccidentalDamagep|';
$amountsCovered .= $premiums['rebuildValue'] > 0 ? $premiums['rebuildValue'] : $premiums['calculatedDSIValue'];
$amountsCovered .= '|';
$optionPremiums .= round($premiums['annualBuildingAD'] / $mult, 2) . '|';
$cover->policyOptionID = 37;
$cover->grosspremium = round($premiums['annualBuildingAD'] * $ipt, 2);
$cover->premium = $premiums['annualBuildingAD'];
$cover->netpremium = $premiums['netBuildingAD'];
$cover->ipt = $cover->grosspremium - $cover->premium;
$pItemHist->setItemHist($legacyQuote, $cover);
}
if ($this->isValidValue($premiums['netBFlood'])) {
$policyOptions .= 'buildingslflood|';
$amountsCovered .= $premiums['rebuildValue'] > 0 ? $premiums['rebuildValue'] : $premiums['calculatedDSIValue'];
$amountsCovered .= '|';
$optionPremiums .= round($premiums['annualBFlood'] / $mult, 2) . '|';
$cover->policyOptionID = 31;
$cover->grosspremium = round($premiums['annualBFlood'] * $ipt, 2);
$cover->premium = $premiums['annualBFlood'];
$cover->netpremium = $premiums['netBFlood'];
$cover->ipt = $cover->grosspremium - $cover->premium;
$pItemHist->setItemHist($legacyQuote, $cover);
}
}
if ($this->hasProduct(self::UNFURNISHED_CONTENTS_COVER) && $this->isValidValue($premiums['netLContent'])) {
$policyOptions .= 'limitedcontentsp|';
$amountsCovered .= '5000|';
$optionPremiums .= round($premiums['annualLContent'] / $mult, 2) . '|';
$cover->policyOptionID = 39;
$cover->sumInsured = 5000;
$cover->grosspremium = round($premiums['annualLContent'] * $ipt, 2);
$cover->premium = $premiums['annualLContent'];
$cover->netpremium = $premiums['netLContent'];
$cover->ipt = $cover->grosspremium - $cover->premium;
$pItemHist->setItemHist($legacyQuote, $cover);
}
if ($this->hasProduct(self::CONTENTS_COVER) && $this->isValidValue($premiums['netContent'])) {
$policyOptions .= 'contentslp|';
$meta = $this->getProductMeta(self::CONTENTS_COVER);
$amountsCovered .= $meta['cover_amount'] . '|';
$optionPremiums .= round($premiums['annualContent'] / $mult, 2) . '|';
$cover->sumInsured = $meta['cover_amount'];
$cover->policyOptionID = 34;
$cover->grosspremium = round($premiums['annualContent'] * $ipt, 2);
$cover->premium = $premiums['annualContent'];
$cover->netpremium = $premiums['netContent'];
$cover->ipt = $cover->grosspremium - $cover->premium;
$pItemHist->setItemHist($legacyQuote, $cover);
if ($this->isValidValue($premiums['netContentsAD'])) {
$policyOptions .= 'contentslAccidentalDamagep|';
$amountsCovered .= $meta['cover_amount'] . '|';
$optionPremiums .= round($premiums['annualContentsAD'] / $mult, 2) . '|';
$cover->policyOptionID = 38;
$cover->grosspremium = round($premiums['annualContentsAD'] * $ipt, 2);
$cover->premium = $premiums['annualContentsAD'];
$cover->netpremium = $premiums['netContentsAD'];
$cover->ipt = $cover->grosspremium - $cover->premium;
$pItemHist->setItemHist($legacyQuote, $cover);
}
if ($this->isValidValue($premiums['netBFlood'])) {
$policyOptions .= 'contentslflood|';
$amountsCovered .= $meta['cover_amount'] . '|';
$optionPremiums .= round($premiums['annualCFlood'] / $mult, 2) . '|';
$cover->policyOptionID = 32;
$cover->grosspremium = round($premiums['annualCFlood'] * $ipt, 2);
$cover->premium = $premiums['annualCFlood'];
$cover->netpremium = $premiums['netCFlood'];
$cover->ipt = $cover->grosspremium - $cover->premium;
$pItemHist->setItemHist($legacyQuote, $cover);
}
}
// ** RENT GUARANTEE ** //
if ($this->hasProduct(self::RENT_GUARANTEE) && $this->isValidValue($premiums['netAnnualRentGuarantee'])) {
$policyOptions .= 'rentguaranteep|';
$meta = $this->getProductMeta(self::RENT_GUARANTEE);
$amountsCovered .= $meta['monthly_rent'] . '|';
$optionPremiums .= round($premiums['grossAnnualRentGuarantee'] / $mult, 2) . '|';
$cover->policyOptionID = 36;
$cover->sumInsured = $meta['monthly_rent'];
$cover->grosspremium = round($premiums['grossAnnualRentGuarantee'] * $ipt, 2);
$cover->premium = $premiums['grossAnnualRentGuarantee'];
$cover->netpremium = $premiums['netAnnualRentGuarantee'];
$cover->ipt = $cover->grosspremium - $cover->premium;
$pItemHist->setItemHist($legacyQuote, $cover);
}
// ** LEGAL EXPENSES ** //
if ($this->hasProduct(self::LEGAL_EXPENSES) && $this->isValidValue($premiums['netAnnualLegalExpensesCover'])) {
$policyOptions .= 'legalexpensesp|';
$amountsCovered .= '50000|';
$optionPremiums .= round($premiums['grossAnnualLegalExpensesCover'] / $mult, 2) . '|';
$cover->policyOptionID = 35;
$cover->sumInsured = 50000;
$cover->grosspremium = round($premiums['grossAnnualLegalExpensesCover'] * $ipt, 2);
$cover->premium = $premiums['grossAnnualLegalExpensesCover'];
$cover->netpremium = $premiums['netAnnualLegalExpensesCover'];
$cover->ipt = $cover->grosspremium - $cover->premium;
$pItemHist->setItemHist($legacyQuote, $cover);
}
// ** EMERGENCY ASSISTANCE ** //
if ($this->hasProduct(self::EMERGENCY_ASSISTANCE)) {
if ($this->isValidValue($premiums['netEA'])) {
$policyOptions .= 'emergencyassistance|';
$amountsCovered .= '1500|';
$optionPremiums .= round($premiums['annualEA'] / $mult, 2) . '|';
$cover->policyOptionID = 4;
$cover->sumInsured = 1500;
$cover->grosspremium = round($premiums['annualEA'] * $ipt, 2);
$cover->premium = $premiums['annualEA'];
$cover->netpremium = $premiums['netEA'];
$cover->ipt = $cover->grosspremium - $cover->premium;
$pItemHist->setItemHist($legacyQuote, $cover);
}
if ($this->isValidValue($premiums['netEAB'])) {
$policyOptions .= 'emergencyassistancebahbuildings|';
$amountsCovered .= '0|';
$optionPremiums .= round($premiums['annualEAB'] / $mult, 2) . '|';
$cover->policyOptionID = 28;
$cover->sumInsured = 0;
$cover->grosspremium = round($premiums['annualEAB'] * $ipt, 2);
$cover->premium = $premiums['annualEAB'];
$cover->netpremium = $premiums['netEAB'];
$cover->ipt = $cover->grosspremium - $cover->premium;
$pItemHist->setItemHist($legacyQuote, $cover);
}
if ($this->isValidValue($premiums['netEAS'])) {
$policyOptions .= 'emergencyassistancestandalone|';
$amountsCovered .= '1500|';
$optionPremiums .= round($premiums['annualEAS'] / $mult, 2) . '|0|';
$cover->policyOptionID = 30;
$cover->sumInsured = 1500;
$cover->grosspremium = round($premiums['annualEAS'] * $ipt, 2);
$cover->premium = $premiums['annualEAS'];
$cover->netpremium = $premiums['netEAS'];
$cover->ipt = $cover->grosspremium - $cover->premium;
$pItemHist->setItemHist($legacyQuote, $cover);
}
if ($this->isValidValue($premiums['netEABS'])) {
$policyOptions .= 'emergencyassistancebahstandalone|';
$amountsCovered .= '0|';
$optionPremiums .= round($premiums['annualEABS'] / $mult, 2) . '|';
$cover->policyOptionID = 29;
$cover->sumInsured = 0;
$cover->grosspremium = round($premiums['annualEABS'] * $ipt, 2);
$cover->premium = $premiums['annualEABS'];
$cover->netpremium = $premiums['netEABS'];
$cover->ipt = $cover->grosspremium - $cover->premium;
$pItemHist->setItemHist($legacyQuote, $cover);
}
}
// We also have to populate the POLICYVARIABLE table for MTA/Renewals *arrghghh*
// NOTE: This code is seriously ugly due to time restraints. Intention is to re-write it
// when we re-write the admin suites so we don't have to maintain horrible legacy systems!
/* POLICY VARIABLES */
$policyVariables = array();
$policyNumber = $this->getPolicyNumber();
// Policy Risk Area - 1
$policyVariables[] = array('policyVariableDefID' => 1, 'policyNumber' => $policyNumber, 'timestamp' => date('Y-m-d h:i:s'), 'value' => $premiums['riskAreas']['buildingsAreaID']);
// No claims discount - 3
// Possible options 0=0, 1=1, 2=2, 3=3, 4=3+
$properties = $this->getProperties();
$ncbID = $properties[0]['no_claims_years_id'];
$policyVariables[] = array('policyVariableDefID' => 3, 'policyNumber' => $policyNumber, 'timestamp' => date('Y-m-d h:i:s'), 'value' => $ncbID - 1);
// Managed property - 4
// Possible options 0=No, 1=Yes
$policyVariables[] = array('policyVariableDefID' => 4, 'policyNumber' => $policyNumber, 'timestamp' => date('Y-m-d h:i:s'), 'value' => $properties[0]['letting_agent_managed']);
if ($this->hasProduct(self::BUILDING_COVER)) {
// Year of Construction - 2
$policyVariables[] = array('policyVariableDefID' => 2, 'policyNumber' => $policyNumber, 'timestamp' => date('Y-m-d h:i:s'), 'value' => $premiums['dsiData']['yearBuiltID']);
// Buildings excess - 5
// Possible options 0=0, 1=100, 2=250, 3=500, 4=1000
$buildingExcessID = 0;
$buildingMeta = $this->getProductMeta(self::BUILDING_COVER);
$buildingExcess = $buildingMeta['excess'];
switch ($buildingExcess) {
case '0':
$buildingExcessID = 0;
break;
case '100':
$buildingExcessID = 1;
break;
case '250':
$buildingExcessID = 2;
break;
case '500':
$buildingExcessID = 3;
break;
case '1000':
$buildingExcessID = 4;
break;
}
$policyVariables[] = array('policyVariableDefID' => 5, 'policyNumber' => $policyNumber, 'timestamp' => date('Y-m-d h:i:s'), 'value' => $buildingExcessID);
}
// Tenant type - 6
// Possible options
// 0=Employed
// 1=Self Employed
// 2=Student
// 3=Retired
// 4=Unemployed
// 5=Housing Authority
// 6=Unknown
// 7=Claiming Benefit
$tenantTypeID = 7;
// NOTE : This is the worst code I've EVER written Argghhh
switch ($properties[0]['tenant_type_id']) {
case 1:
$tenantTypeID = 0;
break;
case 2:
$tenantTypeID = 1;
break;
case 3:
$tenantTypeID = 2;
break;
case 4:
$tenantTypeID = 3;
break;
case 5:
$tenantTypeID = 4;
break;
case 6:
$tenantTypeID = 7;
break;
case 7:
$tenantTypeID = 5;
break;
case 8:
$tenantTypeID = 6;
break;
}
$policyVariables[] = array('policyVariableDefID' => 6, 'policyNumber' => $policyNumber, 'timestamp' => date('Y-m-d h:i:s'), 'value' => $tenantTypeID);
// Contents area - 7
$policyVariables[] = array('policyVariableDefID' => 7, 'policyNumber' => $policyNumber, 'timestamp' => date('Y-m-d h:i:s'), 'value' => $premiums['riskAreas']['contentsAreaID']);
// Contents excess - 8
// Possible options 0=0, 1=100, 2=250, 3=500, 4=1000
if ($this->hasProduct(self::CONTENTS_COVER)) {
$contentsMeta = $this->getProductMeta(self::CONTENTS_COVER);
switch ($contentsMeta['excess']) {
case '0':
$buildingExcessID = 0;
break;
case '100':
$buildingExcessID = 1;
break;
case '250':
$buildingExcessID = 2;
break;
case '500':
$buildingExcessID = 3;
break;
case '1000':
$buildingExcessID = 4;
break;
}
$policyVariables[] = array('policyVariableDefID' => 8, 'policyNumber' => $policyNumber, 'timestamp' => date('Y-m-d h:i:s'), 'value' => $buildingExcessID);
}
// Building flood risk - 9
// Possible options 0=No, 1=Yes
$policyVariables[] = array('policyVariableDefID' => 9, 'policyNumber' => $policyNumber, 'timestamp' => date('Y-m-d h:i:s'), 'value' => $premiums['riskAreas']['floodArea'] == 0 ? 0 : 1);
// Contents flood risk - 10
// Possible options 0=No, 1=Yes
$policyVariables[] = array('policyVariableDefID' => 10, 'policyNumber' => $policyNumber, 'timestamp' => date('Y-m-d h:i:s'), 'value' => $premiums['riskAreas']['floodArea'] == 0 ? 0 : 1);
// Buildings cover over 500,000 - 11
// Possible options 0=No, 1=Yes
$buildingValue = $premiums['rebuildValue'] > 0 ? $premiums['rebuildValue'] : $premiums['calculatedDSIValue'];
$policyVariables[] = array('policyVariableDefID' => 11, 'policyNumber' => $policyNumber, 'timestamp' => date('Y-m-d h:i:s'), 'value' => $buildingValue <= 500000 ? 0 : 1);
// Years owned property - 12
// Possible options
// 0 = 0
// 1 = 1
// 2 = 2
// 3 = 3
// 4 = 3+
$yearsOwnedID = $properties[0]['ownership_length_id'];
$policyVariables[] = array('policyVariableDefID' => 12, 'policyNumber' => $policyNumber, 'timestamp' => date('Y-m-d h:i:s'), 'value' => $yearsOwnedID - 1);
/********************/
// Save the policy variables
$legacyPolicyVariables = new Datasource_Insurance_LandlordsPlus_Legacy_PolicyVariables();
$legacyPolicyVariables->save($policyVariables);
}
$legacyQuote->policyOptions = trim($policyOptions, '|');
$legacyQuote->amountsCovered = trim($amountsCovered, '|');
$legacyQuote->optionPremiums = trim($optionPremiums, '|');
$policyCover = new Datasource_Insurance_Policy_Cover();
$policyCover->populateFromLegacy($legacyQuote->policyNumber, $legacyQuote->policyOptions, $legacyQuote->amountsCovered, $legacyQuote->optionPremiums);
$legacyQuoteDatasource = new Datasource_Insurance_LegacyQuotes();
$legacyQuoteDatasource->save($legacyQuote);
if ($premiums != '' && $this->hasProduct(self::BUILDING_COVER)) {
// We also need to populate the legacy SIVALUE table or MTA's & Renewals don't work :(
$buildingMeta = $this->getProductMeta(self::BUILDING_COVER);
$sivalueData = array();
$sivalueData['policynumber'] = $this->getPolicyNumber();
// If SI is derived siTypeID = 1, if it's manual then siTypeID = 2
if (isset($buildingMeta['rebuild_value']) && $buildingMeta['rebuild_value'] > 0) {
$sivalueData['siTypeID'] = 2;
$sivalueData['siValue'] = $premiums['rebuildValue'];
} else {
$sivalueData['siTypeID'] = 1;
$sivalueData['siValue'] = $premiums['calculatedDSIValue'];
}
// policyOptionID is always 33 - Landlords Buildings+
$sivalueData['policyOptionID'] = 33;
// startdate and enddate are entered here too! *sigh*
$sivalueData['startdate'] = $this->getStartDate();
$sivalueData['enddate'] = $this->getEndDate();
// dsiArea
$sivalueData['dsiArea'] = $premiums['dsiData']['areaID'];
// dsiYearBuiltID
$sivalueData['dsiYearBuiltID'] = $premiums['dsiData']['yearBuiltID'];
// dsiPropertyTypeID
$sivalueData['dsiPropertyTypeID'] = $premiums['dsiData']['dsiPropertyTypeID'];
// dsiBedroomNumID
$sivalueData['dsiBedroomNumID'] = $premiums['dsiData']['dsiBedroomQuantityID'];
$siValueDatasource = new Datasource_Insurance_LandlordsPlus_Legacy_Sivalue();
$siValueDatasource->save($sivalueData);
}
}