function GetPropertyFromRealty($StreetAddr, $City, $State, $Zip)
{
$StreetAddr = urlencode($StreetAddr);
$URL = "http://dlpapi.realtytrac.com/Reports/Get?ApiKey=a2d3e2aa-9c9b-4aab-af3a-56785ae67e25&Login=accurity&Password=1cyquent!&JobID=&LoanNumber=&PreparedBy=&ResellerID=&PreparedFor=&OwnerFirstName=&OwnerLastName=&AddressType=&PropertyStreetAddress={$StreetAddr}&AddressNumber=&StartAddressNumberRange=&EndAddressNumberRange=&StreetDir=&StreetName=&StreetSuffix=&City={$City}&StateCode={$State}&County=&ZipCode={$Zip}&PropertyParcelID=&APN=&ApnRangeStart=&ApnRangeEnd=&GeoCodeX=&GeoCodeY=&GeoCodeRadius=&SearchType=&NumberOfRecords=&Format=XML&ReportID=102";
$path = $_SESSION['path'];
$fp = fopen($path, "a");
fwrite($fp, "<p>Query To Get Main Property - <b>{$URL} </b></p>");
fclose($fp);
$data = file_get_contents($URL);
$p = xml_parser_create();
xml_parse_into_struct($p, $data, $vals, $index);
xml_parser_free($p);
foreach ($vals as $aval) {
if ($aval['type'] == 'complete' && isset($aval['attributes'])) {
foreach ($aval['attributes'] as $key => $val) {
if ($key == "PROPERTYPARCELID_EXT") {
$aProp[$key] = $val;
}
}
}
if ($aval['type'] == 'complete' && isset($aval['attributes']) && $aval['tag'] == "PARSED_STREET_ADDRESS") {
foreach ($aval['attributes'] as $key => $val) {
if (array_key_exists($key, $aProp)) {
continue;
}
$aProp[$key] = $val;
}
}
if ($aval['type'] == 'open' && isset($aval['attributes'])) {
foreach ($aval['attributes'] as $key => $val) {
if ($aval['tag'] == "MAILING_ADDRESS_EXT") {
continue;
}
$aProp[$key] = $val;
}
}
}
if (!isset($aProp)) {
// get the property id
$propertyId = getPropertyId($StreetAddr, $City, $State, $Zip);
$aProp = getByPropertyId($propertyId);
}
return $aProp;
}
} else {
for ($j = 0; $j < count($cell[$i]); $j++) {
$key = $property[$j]['id'];
$value = $cell[$i][$j];
$pair[$n][$key] = $value;
}
}
$n++;
//$n should only be raised when $pair[$n] has been filled
}
}
echo '<table>';
for ($i = 1; $i <= count($pair); $i++) {
if ($_POST['cu'] == 'create') {
echo "<tr><td>CREATE</td>\r\n";
foreach ($pair[$i] as $key => $value) {
if ($value != "") {
echo "<tr><td>LAST</td><td>{$key}</td><td>" . formatValue($value, getDataType($key)) . "</td></tr>\r\n";
}
}
} else {
$item = getPropertyId($pair[$i]['item'], "item");
foreach ($pair[$i] as $key => $value) {
if ($key != "item" && $value != "") {
echo "<tr><td>{$item}</td><td>{$key}</td><td>" . formatValue($value, getDataType($key)) . "</td></tr>\r\n";
}
}
}
}
echo '</table>';
}
