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; }