if ($rows['LOTSIZEACRES'] <= 0 || $rows['LOTSIZEACRES'] == "") {
$rows['LOTSIZEACRES'] = $lot_size;
}
if ($rows['STRUCTURESTORIES'] <= 0 || $rows['STRUCTURESTORIES'] == "") {
$rows['STRUCTURESTORIES'] = $stories;
}
if ($rows['YEARBUILT'] <= 0 || $rows['YEARBUILT'] == "") {
$rows['YEARBUILT'] = $year_built;
}
if ($rows['DIST'] < 0 || $rows['DIST'] == "") {
continue;
}
if ($rows['DATE'] == "") {
continue;
}
$rows['POOL'] = getPoolType($rows['POOL']);
$rows['ADDRESS'] = $rows['ADDRESS'] . " " . $rows['CITY'] . " " . $rows['STATE'] . " " . $rows['ZIP'];
if ($rows['SQ_FT'] >= $C1Rangesqrft['Min'] && $rows['SQ_FT'] <= $C1Rangesqrft['Max'] && ($rows['LOTSIZEACRES'] >= $C1Rangelot['Min'] && $rows['LOTSIZEACRES'] <= $C1Rangelot['Max']) && ($rows['YEARBUILT'] >= $C1RangeAge['Min'] && $rows['YEARBUILT'] <= $C1RangeAge['Max']) && $ydate >= $cn1 && $rows['DIST'] <= $C1Proximity && $rows['STRUCTURESTORIES'] == $stories && $propType == $propertyType) {
$c1[] = array('city' => $rows['CITY'], 'state' => $rows['STATE'], 'zip' => $rows['ZIP'], 'address' => $rows['ADDRESS'], 'distance' => $rows['DIST'], 'bedsBaths' => $rows['BEDS'] . '/' . $rows['BATHS'] . ' ', 'sq_size' => $rows['SQ_FT'], 'year_built' => $rows['YEARBUILT'], 'lot_size' => $rows['LOTSIZEACRES'], 'stories' => $rows['STRUCTURESTORIES'], 'dateSold' => $rows['DATE'], 'amount' => $rows['PRICE'], 'latitude' => $rows['LAT'], 'longitude' => $rows['LON'], 'pool' => $rows['POOL'], 'prop' => $propType, 'basement' => "No", 'criteria' => '1', 'criteria1' => 'cr1');
$aSearchProp[] = array('city' => $rows['CITY'], 'state' => $rows['STATE'], 'zip' => $rows['ZIP'], 'address' => $rows['ADDRESS'], 'distance' => $rows['DIST'], 'bedsBaths' => $rows['BEDS'] . ' /' . $rows['BATHS'] . ' ', 'sq_size' => $rows['SQ_FT'], 'year_built' => $rows['YEARBUILT'], 'lot_size' => $rows['LOTSIZEACRES'], 'stories' => $rows['STRUCTURESTORIES'], 'dateSold' => $rows['DATE'], 'amount' => $rows['PRICE'], 'latitude' => $rows['LAT'], 'longitude' => $rows['LON'], 'pool' => $rows['POOL'], 'prop' => $propType, 'basement' => "No", 'criteria' => '1', 'criteria1' => 'cr1');
$dt = $dt . '<tr style="background-color:green;"><td>' . $count . '</td><td>' . $rows['ADDRESS'] . '</td><td>' . $rows['DIST'] . '</td><td>' . $rows['SQ_FT'] . '</td><td>' . $rows['LOTSIZEACRES'] . '</td><td>' . $rows['YEARBUILT'] . '</td><td>' . $rows['DATE'] . '</td><td>' . $rows['STRUCTURESTORIES'] . '</td><td>Criteria 1</td><td>' . $propType . '</td></tr>';
} else {
if ($rows['SQ_FT'] >= $C2Rangesqrft['Min'] && $rows['SQ_FT'] <= $C2Rangesqrft['Max'] && ($rows['LOTSIZEACRES'] >= $C2Rangelot['Min'] && $rows['LOTSIZEACRES'] <= $C2Rangelot['Max']) && ($rows['YEARBUILT'] >= $C2RangeAge['Min'] && $rows['YEARBUILT'] <= $C2RangeAge['Max']) && $ydate >= $cn2 && $rows['DIST'] <= $C2Proximity && $rows['STRUCTURESTORIES'] == $stories && $propType == $propertyType) {
$c2[] = array('city' => $rows['CITY'], 'state' => $rows['STATE'], 'zip' => $rows['ZIP'], 'address' => $rows['ADDRESS'], 'distance' => $rows['DIST'], 'bedsBaths' => $rows['BEDS'] . '/' . $rows['BATHS'] . ' ', 'sq_size' => $rows['SQ_FT'], 'year_built' => $rows['YEARBUILT'], 'lot_size' => $rows['LOTSIZEACRES'], 'stories' => $rows['STRUCTURESTORIES'], 'dateSold' => $rows['DATE'], 'amount' => $rows['PRICE'], 'latitude' => $rows['LAT'], 'longitude' => $rows['LON'], 'pool' => $rows['POOL'], 'prop' => $propType, 'basement' => "No", 'criteria' => '2', 'criteria2' => 'cr2');
$aSearchProp[] = array('city' => $rows['CITY'], 'state' => $rows['STATE'], 'zip' => $rows['ZIP'], 'address' => $rows['ADDRESS'], 'distance' => $rows['DIST'], 'bedsBaths' => $rows['BEDS'] . ' /' . $rows['BATHS'] . ' ', 'sq_size' => $rows['SQ_FT'], 'year_built' => $rows['YEARBUILT'], 'lot_size' => $rows['LOTSIZEACRES'], 'stories' => $rows['STRUCTURESTORIES'], 'dateSold' => $rows['DATE'], 'amount' => $rows['PRICE'], 'latitude' => $rows['LAT'], 'longitude' => $rows['LON'], 'pool' => $rows['POOL'], 'prop' => $propType, 'basement' => "No", 'criteria' => '2', 'criteria2' => 'cr2');
$dt = $dt . '<tr style="background-color:yellow;"><td>' . $count . '</td><td>' . $rows['ADDRESS'] . '</td><td>' . $rows['DIST'] . '</td><td>' . $rows['SQ_FT'] . '</td><td>' . $rows['LOTSIZEACRES'] . '</td><td>' . $rows['YEARBUILT'] . '</td><td>' . $rows['DATE'] . '</td><td>' . $rows['STRUCTURESTORIES'] . '</td><td>Criteria 2</td><td>' . $propType . '</td></tr>';
} else {
if ($rows['SQ_FT'] >= $C3Rangesqrft['Min'] && $rows['SQ_FT'] <= $C3Rangesqrft['Max'] && ($rows['LOTSIZEACRES'] >= $C3Rangelot['Min'] && $rows['LOTSIZEACRES'] <= $C3Rangelot['Max']) && ($rows['YEARBUILT'] >= $C3RangeAge['Min'] && $rows['YEARBUILT'] <= $C3RangeAge['Max']) && $ydate >= $cn2 && $rows['DIST'] <= $C3Proximity && $rows['STRUCTURESTORIES'] == $stories && $propType == $propertyType) {
$c3[] = array('city' => $rows['CITY'], 'state' => $rows['STATE'], 'zip' => $rows['ZIP'], 'address' => $rows['ADDRESS'], 'distance' => $rows['DIST'], 'bedsBaths' => $rows['BEDS'] . '/' . $rows['BATHS'] . ' ', 'sq_size' => $rows['SQ_FT'], 'year_built' => $rows['YEARBUILT'], 'lot_size' => $rows['LOTSIZEACRES'], 'stories' => $rows['STRUCTURESTORIES'], 'dateSold' => $rows['DATE'], 'amount' => $rows['PRICE'], 'latitude' => $rows['LAT'], 'longitude' => $rows['LON'], 'pool' => $rows['POOL'], 'prop' => $propType, 'basement' => "No", 'criteria' => '3', 'criteria3' => 'cr3');
$aSearchProp[] = array('city' => $rows['CITY'], 'state' => $rows['STATE'], 'zip' => $rows['ZIP'], 'address' => $rows['ADDRESS'], 'distance' => $rows['DIST'], 'bedsBaths' => $rows['BEDS'] . ' /' . $rows['BATHS'] . ' ', 'sq_size' => $rows['SQ_FT'], 'year_built' => $rows['YEARBUILT'], 'lot_size' => $rows['LOTSIZEACRES'], 'stories' => $rows['STRUCTURESTORIES'], 'dateSold' => $rows['DATE'], 'amount' => $rows['PRICE'], 'latitude' => $rows['LAT'], 'longitude' => $rows['LON'], 'pool' => $rows['POOL'], 'prop' => $propType, 'basement' => "No", 'criteria' => '3', 'criteria3' => 'cr3');
$dt = $dt . '<tr style="background-color:aqua;"><td>' . $count . '</td><td>' . $rows['ADDRESS'] . '</td><td>' . $rows['DIST'] . '</td><td>' . $rows['SQ_FT'] . '</td><td>' . $rows['LOTSIZEACRES'] . '</td><td>' . $rows['YEARBUILT'] . '</td><td>' . $rows['DATE'] . '</td><td>' . $rows['STRUCTURESTORIES'] . '</td><td>Criteria 3</td><td>' . $propType . '</td></tr>';
function get_xml_data($arrParam)
{
//$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='.$arrParam['street'].'&AddressNumber=&StartAddressNumberRange=&EndAddressNumberRange=&StreetDir=&StreetName=&StreetSuffix=&City='.$arrParam['city'].'&StateCode='.$arrParam['state'].'&County=&ZipCode=&PropertyParcelID=&SAPropertyID=&APN=&ApnRangeStart=&ApnRangeEnd=&GeoCodeX=&GeoCodeY=&GeoCodeRadius=&SearchType=&NumberOfRecords=&Format=XML&ReportID=104&R104_SettingsMode=';
$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=&AddressNumber=&StartAddressNumberRange=&EndAddressNumberRange=&StreetDir=&StreetName=&StreetSuffix=&City=&StateCode=&County=&ZipCode=&PropertyParcelID=' . $arrParam['propertyId'] . '&SAPropertyID=&APN=&ApnRangeStart=&ApnRangeEnd=&Latitude=&Longitude=&Radius=&SearchType=&NumberOfRecords=&Sort=&Format=XML&ReportID=104&R104_SettingsMode=';
$path = $_SESSION['path'];
$fp = fopen($path, "a");
fwrite($fp, "<p>Query To Get Comparable Property - <b>{$url}</b></p>");
fclose($fp);
$curl = curl_init();
curl_setopt_array($curl, array(CURLOPT_RETURNTRANSFER => 1, CURLOPT_URL => $url));
$resp = curl_exec($curl);
curl_close($curl);
preg_match_all("@<PROPERTY>(.*?)</PROPERTY>@is", $resp, $aProp, PREG_SET_ORDER);
$result = array();
foreach ($aProp as $arr) {
preg_match("@_City=\"(.*?)\"\\s*_StreetAddress=\"(.*?)\"\\s*_State=\"(.*?)\"\\s*_PostalCode=\"(.*?)\"@is", $arr[1], $matches);
$address = $matches[2] . " " . $matches[1] . " " . $matches[3] . " " . $matches[4];
preg_match("@DistanceFromSubjectPropertyMilesCount=\"(.*?)\"@is", $arr[1], $distance);
preg_match("@TotalBedroomCount=\"(.*?)\"@is", $arr[1], $beds);
preg_match("@TotalBathroomCount=\"(.*?)\"@is", $arr[1], $baths);
preg_match("@GrossLivingAreaSquareFeetCount=\"(.*?)\"@is", $arr[1], $size);
preg_match("@PropertyStructureBuiltYear=\"(.*?)\"@is", $arr[1], $built);
preg_match("@LotSquareFeetCount=\"(.*?)\"@is", $arr[1], $lot);
preg_match("@StoriesCount=\"(.*?)\"@is", $arr[1], $story);
preg_match("@LatitudeNumber=\"(.*?)\"\\s*LongitudeNumber=\"(.*?)\"@is", $arr[1], $coords);
if (preg_match("@PropertySalesDate@", $arr[1])) {
preg_match("@PropertySalesDate=\"(.*?)\"@is", $arr[1], $sale_date);
} else {
preg_match("@SALES_HISTORY.*?TransferDate_ext=\"(.*?)\"@is", $arr[1], $sale_date);
}
preg_match("@SALES_HISTORY.*?PropertySalesAmount=\"(.*?)\"@is", $arr[1], $sale_amount);
preg_match("@AMENITY _Type=\"Pool\" _ExistsIndicator=\"(.*?)\"@is", $arr[1], $pool);
$pool[1] = getPoolType($pool[1]);
preg_match("@BASEMENT SquareFeetCount=\"(.*?)\"@is", $arr[1], $basement);
if ($basement[1] > 0) {
$basement[1] = "Y";
} else {
$basement[1] = "No";
}
if ($coords[1] != "") {
$latitude = $coords[1];
}
if ($coords[2] != "") {
$longitude = $coords[2];
}
preg_match("@TransferDate_ext=\"(.*?)\"@is", $arr[1], $transfer);
$transfer[1] = preg_replace("@T.*?\$@is", "", $transfer[1]);
preg_match("@StoriesCount=\"(.*?)\"@is", $arr[1], $stories);
$stories = $stories[1];
preg_match("@StandardUseCode_ext=\"(.*?)\"@", $arr[1], $props);
$ptype = trim($props[1]);
$ptype = getPropertyTypeDLP($ptype);
$result[] = array('address' => $address, 'distance' => $distance[1], 'beds' => trim(floor($beds[1])) . '/' . floor($baths[1]) . '', 'sq_size' => $size[1], 'year_built' => $built[1], 'lot_size' => $lot[1], 'stories' => $story[1], 'dateSold' => $sale_date[1], 'amount' => $sale_amount[1], 'street' => $matches[2], 'city' => $matches[1], 'state' => $matches[3], 'zip' => $matches[4], 'latitude' => $latitude, 'longitude' => $longitude, 'pool' => $pool[1], 'basement' => $basement[1], 'transferDate' => $transfer[1], 'stories' => $stories, "propertyType" => $ptype);
}
return $result;
}
