/**
* @param $dataIn
* @param \Sudoux\MortgageBundle\Entity\LoanApplication $application
* @param int $source
* @return \Sudoux\MortgageBundle\Entity\LoanApplication
* @author Eric Haynes
*/
public function convertToLoanApp($dataIn, LoanApplication $application = null, $source = 4)
{
$xml = simplexml_load_string($dataIn);
$json = json_encode($xml);
$destinyData = json_decode($json, TRUE);
if (!isset($application)) {
$application = new LoanApplication();
$application->setLastStepCompleted(6);
$application->setHasRealtor(false);
//add section to grab realtor info if in xml
$application->setNumUnits(1);
$application->setSource($source);
$housingExpense = new ExpenseHousing();
$application->setExpenseHousing($housingExpense);
}
$application->setStatus(6);
// loan-info
//
////////////////////////////////
$loanAmount = $destinyData['loan-info']['@attributes']['base-loan-amount'];
$application->setLoanAmount($this->toFloat($loanAmount));
$loanTerm = $destinyData['loan-info']['@attributes']['loan-term'];
$application->setLoanTerm($this->getLoanTermInYears($loanTerm));
$loanType = $destinyData['loan-info']['@attributes']['loan-purpose'];
$newLoanType = $this->getLoanTypeDestiny($loanType);
$application->setLoanType($newLoanType);
if ($newLoanType == 1) {
$refiPurpose = $destinyData['loan-info']['@attributes']['purpose-of-refinance'];
$application->setRefinancePurpose($this->getLoanRefiPurposeDestiny($refiPurpose));
$refiFirstMortgageAmount = $destinyData['loan-info']['@attributes']['first-mortgage-amount'];
$application->setRefinanceOriginalCost($refiFirstMortgageAmount);
$refiFirstMortgageRate = $destinyData['loan-info']['@attributes']['interest-rate'];
$application->setRefinanceCurrentRate($refiFirstMortgageRate);
$loanProgram = $destinyData['loan-info']['@attributes']['loan-program'];
$application->setRefinanceCurrentLoanType($loanProgram);
}
$residencyType = $destinyData['loan-info']['@attributes']['occupancy-type'];
$application->setResidencyType($this->getResidencyTypeDestiny($residencyType));
$salePrice = $destinyData['loan-info']['@attributes']['sale-price'];
$application->setSalePrice($this->toFloat($salePrice));
// property-info
//
/////////////////////////////////
$propertyLocation = $application->getPropertyLocation();
$propertyAddress = ucwords(strtolower($destinyData['property-info']['@attributes']['street-address']));
$propertyLocation->setAddress1($propertyAddress);
$propertyCity = ucwords(strtolower($destinyData['property-info']['@attributes']['city']));
$propertyLocation->setCity($propertyCity);
//echo $propertyCity; exit;
$propertyState = $destinyData['property-info']['@attributes']['state'];
$propertyStateEntity = $this->em->getRepository('SudouxCmsLocationBundle:State')->findStateByAbbreviation($propertyState);
$propertyLocation->setState($propertyStateEntity);
$propertyZipcode = $destinyData['property-info']['@attributes']['zip'];
$propertyLocation->setZipcode($this->toZipcode($propertyZipcode));
$propertyType = $destinyData['property-info']['@attributes']['property-type-code'];
$application->setPropertyType($this->getPropertyTypeDestiny($propertyType));
// borrower info
//
////////////////////////////////
$marriageStatus = $this->guessMarriedTypeDestiny($destinyData['borrower-info']);
foreach ($destinyData['borrower-info'] as $destinyBorrower) {
if ($destinyBorrower['@attributes']['co-borrower'] == 'false') {
$borrower = $application->getBorrower();
$this->convertDestinyToBorrower($application, $borrower, $destinyBorrower, false);
$borrower->setMaritalStatus($marriageStatus);
} else {
$coBorrowers = $application->getCoBorrower();
$coBorrowerSsn = $destinyBorrower['@attributes']['ssn'];
$coBorrower = null;
if (count($coBorrowers) > 0) {
// check if coborrower exists
foreach ($coBorrowers as $cb) {
$existingSsn = preg_replace("/[^0-9]/", "", $cb->getSsn());
if ($existingSsn == $coBorrowerSsn) {
$coBorrower = $cb;
break;
}
}
}
if (!isset($coBorrower)) {
$coBorrower = new Borrower();
$application->addCoBorrower($coBorrower);
$coBorrower->setSsn($coBorrowerSsn);
}
$this->convertDestinyToBorrower($application, $coBorrower, $destinyBorrower, true);
$coBorrower->setMaritalStatus($marriageStatus);
}
}
// loan status
//
////////////////////////////////
return $application;
}
/**
*
* @param Site $site
* @param string $losId
*/
public function createLoanFromLos(Site $site, $losId)
{
$loan = new LoanApplication();
$loan->setLosId($losId);
$loan->setSite($site);
$loan->setSource(1);
$loan->setStatus(6);
$loan->setCompleted(true);
$this->upsertLoanFromLos($loan);
return $loan;
}
/**
* @param $fannieMaeData
* @param LoanApplication $application
* @param int $source
* @return LoanApplication
*/
public function convertFannieMaeToLoanApplication($fannieMaeData, LoanApplication $application = null, $source = 0)
{
if (isset($application)) {
// remove data for update
$application->removeAllAssetAccount();
$application->removeAllAssetRealEstate();
// reset housing expense
} else {
$application = new LoanApplication();
$application->setLastStepCompleted(6);
$application->setHasRealtor(false);
$application->setSource($source);
$housingExpense = new ExpenseHousing();
$application->setExpenseHousing($housingExpense);
}
$loanAmount = StringUtil::find($fannieMaeData, "01A", 131, 15);
$application->setLoanAmount($this->toFloat($loanAmount));
$loanTerm = StringUtil::find($fannieMaeData, "01A", 153, 3);
$application->setLoanTerm($this->getLoanTerm($loanTerm));
$loanType = StringUtil::find($fannieMaeData, "02B", 6, 2);
$application->setLoanType($this->getLoanType($loanType));
// refi data
$refinanceYearAquired = StringUtil::find($fannieMaeData, "02D", 4, 4);
$application->setRefinanceYearAquired($this->toInt($refinanceYearAquired));
$refinanceOriginalCost = StringUtil::find($fannieMaeData, "02D", 8, 15);
$application->setRefinanceOriginalCost($this->toFloat($refinanceOriginalCost));
$refinanceExistingLiens = StringUtil::find($fannieMaeData, "02D", 23, 15);
$application->setRefinanceExistingLiens($this->toFloat($refinanceExistingLiens));
$refinancePurpose = StringUtil::find($fannieMaeData, "02D", 68, 2);
$application->setRefinancePurpose($this->getRefinancePurpose($refinancePurpose));
/*$refinancePurpose = StringUtil::find($fannieMaeData, "02D", 68, 2);
$application->setRefinanceCurrentLender($refinanceCurrentLender);
$application->setRefinanceCurrentLoanType($refinanceCurrentLoanType);
$application->setRefinanceCurrentRate($refinanceCurrentRate);*/
$salePrice = StringUtil::find($fannieMaeData, "07A", 4, 15);
$application->setSalePrice($this->toFloat($salePrice));
$numUnits = StringUtil::find($fannieMaeData, "02A", 100, 3);
$application->setNumUnits($this->toInt($numUnits));
$propertyYearBuilt = StringUtil::find($fannieMaeData, "02A", 185, 4);
$application->setPropertyYearBuilt($this->toInt($propertyYearBuilt));
$propertyType = StringUtil::find($fannieMaeData, "LNC", 6, 2);
$application->setPropertyType($this->getPropertyType($propertyType));
$residencyType = StringUtil::find($fannieMaeData, "02B", 88, 1);
$application->setResidencyType($this->getResidencyType($residencyType));
$titleManner = StringUtil::find($fannieMaeData, "02B", 89, 60);
$application->setTitleManner($titleManner);
$titleCompany = StringUtil::find($fannieMaeData, "02C", 4, 60);
$application->setTitleCompany1($titleCompany);
// property_location \Sudoux\Cms\LocationBundle\Entity\Location
$propertyLocation = $application->getPropertyLocation();
$propertyAddress = StringUtil::find($fannieMaeData, "02A", 4, 50);
$propertyLocation->setAddress1($propertyAddress);
$propertyCity = StringUtil::find($fannieMaeData, "02A", 54, 35);
$propertyLocation->setCity($propertyCity);
//echo $propertyCity; exit;
$propertyState = StringUtil::find($fannieMaeData, "02A", 89, 2);
$propertyStateEntity = $this->em->getRepository('SudouxCmsLocationBundle:State')->findStateByAbbreviation($propertyState);
$propertyLocation->setState($propertyStateEntity);
$propertyZipcode = StringUtil::find($fannieMaeData, "02A", 91, 5);
$propertyLocation->setZipcode($this->toZipcode($propertyZipcode));
$propertyUnit = StringUtil::find($fannieMaeData, "02A", 55, 11);
$propertyLocation->setUnit($propertyUnit);
// reset the housing expense
$housingExpense = $application->getExpenseHousing();
if (isset($housingExpense)) {
$housingExpense->reset();
}
$borrower = $application->getBorrower();
$this->convertFannieMaeToBorrower($application, $borrower, $fannieMaeData, array('03A_suffix' => 'BW'));
$fnmCoBorrowers = StringUtil::findLinesStartingWith($fannieMaeData, "03AQZ");
$coBorrowers = $application->getCoBorrower();
foreach ($fnmCoBorrowers as $fnmCoBorrower) {
$coBorrowerSsn = StringUtil::find($fnmCoBorrower, "03AQZ", 6, 9);
$coBorrower = null;
if (count($coBorrowers) > 0) {
// check if coborrower exists
foreach ($coBorrowers as $cb) {
$existingSsn = preg_replace("/[^0-9]/", "", $cb->getSsn());
if ($existingSsn == $coBorrowerSsn) {
$coBorrower = $cb;
break;
}
}
}
if (!isset($coBorrower)) {
$coBorrower = new Borrower();
$application->addCoBorrower($coBorrower);
$coBorrower->setSsn($coBorrowerSsn);
}
$this->convertFannieMaeToBorrower($application, $coBorrower, $fannieMaeData, array('03A_suffix' => 'QZ'));
}
//exit;
return $application;
}