/**
* Public function to save
*
* @param Model_Insurance_Portfolio_Property $data The Data to be saved
* return int The last insert id
*/
public function save($data)
{
# Zend_Debug::dump($data);die();
$property = new Datasource_Insurance_Portfolio_Property();
$dsBuildingsRiskArea = new Datasource_Insurance_RiskAreas_Buildings();
$dsContentsRiskArea = new Datasource_Insurance_RiskAreas_LandlordsContents();
$data->buildingsRiskArea = $dsBuildingsRiskArea->getCurrentRate($data->postcode);
$data->contentsRiskArea = $dsContentsRiskArea->getCurrentRate($data->postcode);
return $property->save($data);
}
/**
* This will convert all the new data into the old lagacy tables
* @param
* @return
* @author John Burrin
* @since 1.3
*
* Munten ergo sum
*/
public function convertLegacy($refNo)
{
// fetch quote premiums
$premiums = $this->quote($refNo);
// Fetch the Landlords details
$landlord = new Manager_Insurance_Portfolio_LegacyCustomer();
$landlordDetails = $landlord->fetchByRefNo($refNo);
// Fetch all the properties
$propertyManager = new Manager_Insurance_Portfolio_Property();
$propertyObject = new Model_Insurance_Portfolio_Property();
$propertyObject = $propertyManager->fetchAllProperties($refNo);
// populate the legacy portfoliostat table
$legacyPortfolioStat = new Model_Insurance_Portfolio_LegacyPortfolio();
$legacyPortfolioStat->agentSchemeNo = 1403796;
// $legacyPortfolioStat->csuId = "";
$legacyPortfolioStat->customerRefNo = "";
$legacyPortfolioStat->date = date("Y-m-d");
$legacyPortfolioStat->email = $landlordDetails['email_address'];
$legacyPortfolioStat->heardFrom = "";
$legacyPortfolioStat->hpc = "";
$legacyPortfolioStat->name = $landlordDetails['first_name'] . " " . $landlordDetails['last_name'];
$legacyPortfolioStat->numOfHouse = count($propertyObject);
$legacyPortfolioStat->policyNumber = "";
$legacyPortfolioStat->quote = $premiums['premiums']['UserQuoteAnnualPremium'];
$legacyPortfolioStat->referred = "";
$legacyPortfolioStat->refNo = $refNo;
$legacyPortfolioStat->telephone = $landlordDetails['telephone1'];
// Set up datasources to the risk areas
$dsBuildingsRiskArea = new Datasource_Insurance_RiskAreas_Buildings();
$dsContentsRiskArea = new Datasource_Insurance_RiskAreas_LandlordsContents();
//Save the portfoliostat data
$legacyPortfolioManager = new Manager_Insurance_Portfolio_LegacyPortfolio();
$legacyPortfolioManager->save($legacyPortfolioStat);
$idd = new Datasource_Insurance_IddSupport();
if (!$idd->isIddSupport($legacyPortfolioStat->refNo)) {
$inserArray = array();
$insertArray['policynumber'] = $legacyPortfolioStat->refNo;
$insertArray['agentschemeno'] = $legacyPortfolioStat->agentSchemeNo;
$insertArray['csuid'] = 0;
$fsaAgentStatusDatasource = new Datasource_Fsa_AgentStatus();
$fsaStatus = $fsaAgentStatusDatasource->getAgentFsaStatus($legacyPortfolioStat->agentSchemeNo);
if (isset($fsaStatus['status_abbr'])) {
$insertArray['FSA_status'] = $fsaStatus['status_abbr'];
} else {
$insertArray['FSA_status'] = "";
}
$insertArray['origsaleid'] = 9;
$insertArray['callerid'] = 2;
$idd->setIddSupport($insertArray);
}
// Setup an agent manager
$agent = new Manager_Core_Agent();
// get polict options
$ds_rates = new Datasource_Insurance_Portfolio_PortfolioRates();
$rates = $ds_rates->fetchRates();
$optionsString = $this->_getPolicyOptions();
// Save the property data into the legacy portfolio table
$legacyPropertyManager = new Manager_Insurance_Portfolio_LegacyProperty();
foreach ($propertyObject as $property) {
// Create a new Model_Insurance_Portfolio_LegacyProperty Object
$legacyPropertyObject = new Model_Insurance_Portfolio_LegacyProperty();
$legacyPropertyObject->amountsCovered = $this->_getAmountsCovered($property);
$legacyPropertyObject->discount = "";
$legacyPropertyObject->excessId = "";
$legacyPropertyObject->ipt = "";
$legacyPropertyObject->optionDiscounts = "";
$legacyPropertyObject->optionPremiums = "";
$legacyPropertyObject->policyNumber = $refNo;
$legacyPropertyObject->policyOptions = $optionsString;
$legacyPropertyObject->premium = "";
$legacyPropertyObject->propAddress1 = $property->address1;
$legacyPropertyObject->propAddress3 = $property->address2;
$legacyPropertyObject->propAddress5 = $property->address3;
$legacyPropertyObject->propPostcode = $property->postcode;
$legacyPropertyObject->quote = 0.0;
$legacyPropertyObject->rateSetId = $agent->getRatesetIDByASN($refNo);
$legacyPropertyObject->riskArea = $dsContentsRiskArea->getCurrentRate($property['postcode']);
$legacyPropertyObject->riskAreaB = $dsBuildingsRiskArea->getCurrentRate($property['postcode']);
$legacyPropertyObject->surcharge = "";
$legacyPropertyManager->save($legacyPropertyObject);
}
}