Page Menu
Home
In-Portal Phabricator
Search
Configure Global Search
Log In
Files
F1047591
geocode_helper.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Mon, Jun 30, 3:29 AM
Size
5 KB
Mime Type
text/x-php
Expires
Wed, Jul 2, 3:29 AM (3 h, 18 m)
Engine
blob
Format
Raw Data
Handle
677395
Attached To
rINP In-Portal
geocode_helper.php
View Options
<?php
/**
* @version $Id: geocode_helper.php 12306 2009-08-17 02:35:55Z dmitrya $
* @package In-Portal
* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
* @license GNU/GPL
* In-Portal is Open Source software.
* This means that this software may have been modified pursuant
* the GNU General Public License, and as distributed it includes
* or is derivative of works licensed under the GNU General Public License
* or other free or open source software licenses.
* See http://www.in-portal.net/license/ for copyright notices and details.
*/
defined
(
'FULL_PATH'
)
or
die
(
'restricted access!'
);
class
GeoCodeHelper
extends
kHelper
{
/**
* Returns Longitude & Latitude by US address provided
*
* @param Array $data
* @return Array
*/
function
QueryCoordinates
(
$address
,
$city
,
$state
,
$zip
)
{
$user
=
$this
->
Application
->
ConfigValue
(
'GeoCodeUser'
);
$pass
=
$this
->
Application
->
ConfigValue
(
'GeoCodePass'
);
$rie_path
=
sprintf
(
FULL_PATH
.
'/tools/rie/rie -u %s -p %s -g "%s" -l'
,
$user
,
$pass
,
$address
.
'|'
.
$city
.
'|'
.
$state
.
'|'
.
$zip
);
exec
(
$rie_path
,
$geo_array
,
$code
);
if
(
$code
==
0
)
{
$out_data
=
explode
(
'|'
,
$geo_array
[
2
]);
// include_once(FULL_PATH.'/compat/array_combine.php');
$assoc_data
=
array_combine
(
explode
(
'|'
,
$geo_array
[
1
]),
$out_data
);
$lon
=
abs
(
$out_data
[
8
]);
// set to positive, because required by SQL formula
$lat
=
$out_data
[
7
];
$zip4
=
$out_data
[
9
];
$dpbc
=
$out_data
[
10
];
$carrier
=
$out_data
[
11
];
}
else
{
$lon
=
''
;
$lat
=
''
;
$zip4
=
''
;
$dpbc
=
''
;
$carrier
=
''
;
$assoc_data
=
Array
();
}
return
Array
(
$lon
,
$lat
,
$zip4
,
$dpbc
,
$carrier
,
serialize
(
$assoc_data
));
}
function
getTag
(
$tag
,
$xml
)
{
$open_tag_pos
=
strpos
(
$xml
,
'<'
.
$tag
.
'>'
);
$close_tag_pos
=
strpos
(
$xml
,
'</'
.
$tag
.
'>'
);
if
(!
$open_tag_pos
||
!
$close_tag_pos
)
{
return
''
;
}
$tag_length
=
strlen
(
$tag
)
+
2
;
return
substr
(
$xml
,
$open_tag_pos
+
$tag_length
,
$close_tag_pos
-
$open_tag_pos
-
$tag_length
);
}
function
QueryCoordinatesFromGoogle
(
$address
,
$city
,
$state
,
$zip
)
{
// 1908 Pike pl, Seattle, WA
// http://maps.google.com/maps/geo?
// ABQIAAAAzNbTbxHki-PAnXzsrA7z2hR0fs2_a3JecCfKmMFhGT8VtEjV7xRV8rMK1czaEH2ZG3eiYJMuej_vnQ
$qaddress
=
$address
.
', '
.
$city
.
', '
.
$state
;
$request_url
=
$this
->
Application
->
ConfigValue
(
'GoogleMapsURL'
).
'output=xml&key='
.
$this
->
Application
->
ConfigValue
(
'GoogleMapsKey'
).
'&q='
.
urlencode
(
$qaddress
);
$curl_helper
=&
$this
->
Application
->
recallObject
(
'CurlHelper'
);
/* @var $curl_helper kCurlHelper */
$delay
=
0
;
while
(
true
)
{
$xml
=
$curl_helper
->
Send
(
$request_url
);
if
(
strpos
(
$xml
,
'<code>620</code>'
))
{
$delay
+=
100000
;
}
elseif
(
strpos
(
$xml
,
'<code>200</code>'
))
{
// get latitude, longitude and zip from xml-answer
$a_coords
=
explode
(
','
,
$this
->
getTag
(
'coordinates'
,
$xml
));
$lat
=
$a_coords
[
1
];
$lon
=
abs
(
$a_coords
[
0
]);
// set to positive, because required by SQL formula
$zip4
=
$this
->
getTag
(
'PostalCodeNumber'
,
$xml
);
$dpbc
=
''
;
$carrier
=
''
;
$assoc_data
=
Array
();
break
;
}
else
{
$lon
=
''
;
$lat
=
''
;
$zip4
=
''
;
$dpbc
=
''
;
$carrier
=
''
;
$assoc_data
=
Array
();
break
;
}
usleep
(
$delay
);
}
return
Array
(
$lon
,
$lat
,
$zip4
,
$dpbc
,
$carrier
,
serialize
(
$assoc_data
));
}
/**
* Try to find lon, lat by address return false if failed
*
* @param string $address
* @param string $city
* @param string $state
* @param int $zip
* @return Array (lon, lat)
*/
function
GetCoordinates
(
$address
,
$city
,
$state
,
$zip
,
$no_cache
=
false
,
$force_cache
=
false
)
{
if
(!
$zip
&&
!
$state
)
{
// if state or zip missing then do nothing
return
false
;
}
$zip_info
=
$no_cache
?
false
:
$this
->
GetFromCache
(
$address
,
$city
,
$state
,
$zip
);
// $zip_info = $this->GetFromCache($address, $city, $state, $zip);
if
(!
$zip_info
&&
!
$force_cache
)
{
list
(
$lon
,
$lat
,
$zip4
,
$dpbc
,
$carrier
,
$geocode_answer
)
=
$this
->
QueryCoordinatesFromGoogle
(
$address
,
$city
,
$state
,
$zip
);
if
(
$lon
!=
''
&&
$lat
!=
''
)
{
// valid position returned by geocode => add to cache
$fields_hash
=
Array
(
'zipcode'
=>
$zip4
,
'address'
=>
$address
,
'city'
=>
$city
,
'state'
=>
$state
,
'lat'
=>
$lat
,
'lon'
=>
$lon
,
'zip4'
=>
$zip4
,
'dpbc'
=>
$dpbc
,
'carrier'
=>
$carrier
,
'geocode_answer'
=>
$geocode_answer
,
);
$this
->
Conn
->
doInsert
(
$fields_hash
,
TABLE_PREFIX
.
'ZipCodes'
);
return
Array
(
$lon
,
$lat
,
$zip4
,
$dpbc
,
$carrier
);
}
else
{
// bad case, rie call failed => no data retrieved
return
false
;
}
}
return
Array
(
$zip_info
[
'lon'
],
$zip_info
[
'lat'
],
getArrayValue
(
$zip_info
,
'zip4'
),
getArrayValue
(
$zip_info
,
'dpbc'
),
getArrayValue
(
$zip_info
,
'carrier'
));
}
/**
* Try to find cached lon, lat by address
*
* @param string $address
* @param string $city
* @param string $state
* @param int $zip
* @return Array (lon, lat)
*/
function
GetFromCache
(
$address
,
$city
,
$state
,
$zip
)
{
$zip
=
substr
(
$zip
,
0
,
5
);
// use only first 5 digits
$sql
=
'SELECT lon, lat
FROM '
.
TABLE_PREFIX
.
'ZipCodes
WHERE zipcode = '
.
$this
->
Conn
->
qstr
(
$zip
);
return
$this
->
Conn
->
GetRow
(
$sql
);
}
}
Event Timeline
Log In to Comment