GeocoderBehavior.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377
  1. <?php
  2. App::uses('GeocodeLib', 'Tools.Lib');
  3. /**
  4. * A geocoding behavior for CakePHP to easily geocode addresses.
  5. * Uses the GeocodeLib for actual geocoding.
  6. * Also provides some useful geocoding tools like validation and distance conditions
  7. *
  8. * @author Mark Scherer
  9. * @cakephp 2.x
  10. * @licence MIT
  11. * 2011-01-13 ms
  12. */
  13. class GeocoderBehavior extends ModelBehavior {
  14. /**
  15. * Initiate behavior for the model using specified settings. Available settings:
  16. *
  17. * - label: (array | string, optional) set to the field name that contains the
  18. * string from where to generate the slug, or a set of field names to
  19. * concatenate for generating the slug. DEFAULTS TO: title
  20. *
  21. * - real: (boolean, optional) if set to true then field names defined in
  22. * label must exist in the database table. DEFAULTS TO: true
  23. *
  24. * - expect: (array)postal_code, locality, sublocality, ...
  25. *
  26. * - accuracy: see above
  27. *
  28. * - override: lat/lng override on changes?
  29. *
  30. * - update: what fields to update (key=>value array pairs)
  31. *
  32. * - before: validate/save (defaults to save)
  33. * set to false if you only want to use the validation rules etc
  34. *
  35. * @param object $Model Model using the behaviour
  36. * @param array $settings Settings to override for model.
  37. */
  38. public function setup(Model $Model, $settings = array()) {
  39. $default = array(
  40. 'real' => true, 'address' => array('street', 'postal_code', 'city', 'country'),
  41. 'require' => false, 'allowEmpty' => true, 'invalidate' => array(), 'expect' => array(),
  42. 'lat' => 'lat', 'lng' => 'lng', 'formatted_address' => 'formatted_address', 'host' => 'de', 'language' => 'de', 'region' => '', 'bounds' => '',
  43. 'overwrite' => false, 'update' => array(), 'before' => 'save',
  44. 'min_accuracy' => 0, 'allow_inconclusive' => true,
  45. 'log' => true, // log successfull results to geocode.log (errors will be logged to error.log in either case)
  46. );
  47. if (!isset($this->settings[$Model->alias])) {
  48. $this->settings[$Model->alias] = $default;
  49. }
  50. $this->settings[$Model->alias] = array_merge($this->settings[$Model->alias], is_array($settings) ? $settings : array());
  51. }
  52. public function beforeValidate(Model $Model) {
  53. parent::beforeValidate($Model);
  54. if ($this->settings[$Model->alias]['before'] == 'validate') {
  55. return $this->geocode($Model);
  56. }
  57. return true;
  58. }
  59. public function beforeSave(Model $Model) {
  60. parent::beforeSave($Model);
  61. if ($this->settings[$Model->alias]['before'] == 'save') {
  62. return $this->geocode($Model);
  63. }
  64. return true;
  65. }
  66. /**
  67. * Run before a model is saved, used to set up slug for model.
  68. *
  69. * @param object $Model Model about to be saved.
  70. * @return boolean true if save should proceed, false otherwise
  71. */
  72. public function geocode(Model $Model, $return = true) {
  73. // Make address fields an array
  74. if (!is_array($this->settings[$Model->alias]['address'])) {
  75. $addressfields = array($this->settings[$Model->alias]['address']);
  76. } else {
  77. $addressfields = $this->settings[$Model->alias]['address'];
  78. }
  79. $addressfields = array_unique($addressfields);
  80. // Make sure all address fields are available
  81. if ($this->settings[$Model->alias]['real']) {
  82. foreach ($addressfields as $field) {
  83. if (!$Model->hasField($field)) {
  84. return $return;
  85. }
  86. }
  87. }
  88. $adressdata = array();
  89. foreach ($addressfields as $field) {
  90. if (!empty($Model->data[$Model->alias][$field])) {
  91. $adressdata[] = $Model->data[$Model->alias][$field];
  92. }
  93. }
  94. $Model->data[$Model->alias]['geocoder_result'] = array();
  95. // See if we should request a geocode //TODO: reverse and return here
  96. if ((!$this->settings[$Model->alias]['real'] || ($Model->hasField($this->settings[$Model->alias]['lat']) && $Model->hasField($this->settings[$Model->alias]['lng']))) && ($this->settings[$Model->alias]['overwrite'] || (empty($Model->data[$Model->alias][$this->settings[$Model->alias]['lat']]) || ($Model->data[$Model->alias][$this->settings[$Model->alias]['lat']]==0 && $Model->data[$Model->alias][$this->settings[$Model->alias]['lat']]==0)))) {
  97. if (!empty($Model->whitelist) && (!in_array($this->settings[$Model->alias]['lat'], $Model->whitelist) || !in_array($this->settings[$Model->alias]['lng'], $Model->whitelist))) {
  98. /** HACK to prevent 0 inserts if not wanted! just use whitelist now to narrow fields down - 2009-03-18 ms */
  99. //$Model->whitelist[] = $this->settings[$Model->alias]['lat'];
  100. //$Model->whitelist[] = $this->settings[$Model->alias]['lng'];
  101. return $return;
  102. }
  103. $geocode = $this->_geocode($adressdata, $this->settings[$Model->alias]);
  104. if (empty($geocode) && !empty($this->settings[$Model->alias]['allowEmpty'])) {
  105. return true;
  106. }
  107. if (empty($geocode)) {
  108. return false;
  109. }
  110. if (!empty($geocode['type']) && !empty($this->settings[$Model->alias]['expect'])) {
  111. if (!in_array($geocode['type'], (array)$this->settings[$Model->alias]['expect'])) {
  112. return $return;
  113. }
  114. }
  115. //pr($geocode);
  116. //pr($this->Geocode->getResult());
  117. // Now set the geocode as part of the model data to be saved, making sure that
  118. // we are on the white list of fields to be saved
  119. //pr ($Model->whitelist); die();
  120. //pr($geocode); die();
  121. # if both are 0, thats not valid, otherwise continue
  122. if (!empty($geocode['lat']) || !empty($geocode['lng'])) { /** HACK to prevent 0 inserts of incorrect runs - 2009-04-07 ms */
  123. $Model->data[$Model->alias][$this->settings[$Model->alias]['lat']] = $geocode['lat'];
  124. $Model->data[$Model->alias][$this->settings[$Model->alias]['lng']] = $geocode['lng'];
  125. } else {
  126. if (isset($Model->data[$Model->alias][$this->settings[$Model->alias]['lat']])) {
  127. unset($Model->data[$Model->alias][$this->settings[$Model->alias]['lat']]);
  128. }
  129. if (isset($Model->data[$Model->alias][$this->settings[$Model->alias]['lng']])) {
  130. unset($Model->data[$Model->alias][$this->settings[$Model->alias]['lng']]);
  131. }
  132. if ($this->settings[$Model->alias]['require']) {
  133. if ($fields = $this->settings[$Model->alias]['invalidate']) {
  134. $Model->invalidate($fields[0], $fields[1], isset($fields[2]) ? $fields[2] : true);
  135. }
  136. return false;
  137. }
  138. }
  139. if (!empty($this->settings[$Model->alias]['formatted_address'])) {
  140. $Model->data[$Model->alias][$this->settings[$Model->alias]['formatted_address']] = $geocode['formatted_address'];
  141. } else {
  142. if (isset($Model->data[$Model->alias][$this->settings[$Model->alias]['formatted_address']])) {
  143. unset($Model->data[$Model->alias][$this->settings[$Model->alias]['formatted_address']]);
  144. }
  145. }
  146. if (!empty($geocode['inconclusive'])) {
  147. $Model->data[$Model->alias]['geocoder_inconclusive'] = $geocode['inconclusive'];
  148. $Model->data[$Model->alias]['geocoder_results'] = $geocode['results'];
  149. } else {
  150. $Model->data[$Model->alias]['geocoder_result'] = $geocode;
  151. }
  152. $Model->data[$Model->alias]['geocoder_result']['address_data'] = implode(' ', $adressdata);
  153. if (!empty($this->settings[$Model->alias]['update'])) {
  154. foreach ($this->settings[$Model->alias]['update'] as $key => $field) {
  155. if (!empty($geocode[$key])) {
  156. $Model->data[$Model->alias][$field] = $geocode[$key];
  157. }
  158. }
  159. }
  160. # correct country id if neccessary
  161. /*
  162. if (in_array('country_name', $this->settings[$Model->alias]['address'])) {
  163. App::uses('Country', 'Tools.Model');
  164. if (!empty($geocode['country']) && in_array($geocode['country'], ($countries = Country::addressList()))) {
  165. $countries = array_shift(array_keys($countries, $geocode['country']));
  166. $Model->data[$Model->alias]['country'] = $countries;
  167. } else {
  168. $Model->data[$Model->alias]['country'] = 0;
  169. }
  170. }
  171. */
  172. }
  173. return $return;
  174. }
  175. /**
  176. * Add the distance to this point as a virtual field
  177. *
  178. * @param Model $Model
  179. * @param float $lat
  180. * @param float $lng
  181. * @return void
  182. */
  183. public function setDistanceAsVirtualField(Model $Model, $lat, $lng, $modelName = null) {
  184. $Model->virtualFields['distance'] = $this->distance($Model, $lat, $lng, null, null, $modelName);
  185. }
  186. /**
  187. * return a sql snippet for distance calculation on db level using two lat/lng points
  188. *
  189. * @return string
  190. */
  191. public function distance(Model $Model, $lat, $lng, $fieldLat = null, $fieldLng = null, $modelName = null) {
  192. if ($fieldLat === null) {
  193. $fieldLat = $this->settings[$Model->alias]['lat'];
  194. }
  195. if ($fieldLng === null) {
  196. $fieldLng = $this->settings[$Model->alias]['lng'];
  197. }
  198. if ($modelName === null) {
  199. $modelName = $Model->alias;
  200. }
  201. return '6371.04 * ACOS( COS( PI()/2 - RADIANS(90 - '.$modelName.'.'.$fieldLat.')) * ' .
  202. 'COS( PI()/2 - RADIANS(90 - '. $lat .')) * ' .
  203. 'COS( RADIANS('.$modelName.'.'.$fieldLat.') - RADIANS('. $lng .')) + ' .
  204. 'SIN( PI()/2 - RADIANS(90 - '.$modelName.'.'.$fieldLng.')) * ' .
  205. 'SIN( PI()/2 - RADIANS(90 - '. $lat . ')))';
  206. }
  207. /**
  208. * snippet for custom pagination
  209. *
  210. * @return array
  211. */
  212. public function distanceConditions(Model $Model, $distance = null, $fieldName = null, $fieldLat = null, $fieldLng = null, $modelName = null) {
  213. if ($fieldLat === null) {
  214. $fieldLat = $this->settings[$Model->alias]['lat'];
  215. }
  216. if ($fieldLng === null) {
  217. $fieldLng = $this->settings[$Model->alias]['lng'];
  218. }
  219. if ($modelName === null) {
  220. $modelName = $Model->alias;
  221. }
  222. $conditions = array(
  223. $modelName . '.'.$fieldLat.' <> 0',
  224. $modelName . '.'.$fieldLng.' <> 0',
  225. );
  226. $fieldName = !empty($fieldName) ? $fieldName : 'distance';
  227. if ($distance !== null) {
  228. $conditions[] = '1=1 HAVING '.$modelName.'.'.$fieldName.' < ' . intval($distance);
  229. }
  230. return $conditions;
  231. }
  232. /**
  233. * snippet for custom pagination
  234. *
  235. * @return string
  236. */
  237. public function distanceField(Model $Model, $lat, $lng, $fieldName = null, $modelName = null) {
  238. if ($modelName === null) {
  239. $modelName = $Model->alias;
  240. }
  241. $fieldName = (!empty($fieldName) ? $fieldName : 'distance');
  242. return $this->distance($Model, $lat, $lng, null, null, $modelName) . ' AS '.$modelName.'.'.$fieldName;
  243. }
  244. /**
  245. * snippet for custom pagination
  246. * still useful?
  247. *
  248. * @return string
  249. */
  250. public function distanceByField(Model $Model, $lat, $lng, $byFieldName = null, $fieldName = null, $modelName = null) {
  251. if ($modelName === null) {
  252. $modelName = $Model->alias;
  253. }
  254. if ($fieldName === null) {
  255. $fieldName = 'distance';
  256. }
  257. if ($byFieldName === null) {
  258. $byFieldName = 'radius';
  259. }
  260. return $this->distance($Model, $lat, $lng, null, null, $modelName).' '.$byFieldName;
  261. }
  262. /**
  263. * snippet for custom pagination
  264. *
  265. * @return int $count
  266. */
  267. public function paginateDistanceCount(Model $Model, $conditions = null, $recursive = -1, $extra = array()) {
  268. if (!empty($extra['radius'])) {
  269. $conditions[] = $extra['distance'].' < '.$extra['radius'].(!empty($extra['startRadius'])?' AND '.$extra['distance'].' > '.$extra['startRadius']:'').(!empty($extra['endRadius'])?' AND '.$extra['distance'].' < '.$extra['endRadius']:'');
  270. }
  271. if (!empty($extra['group'])) {
  272. unset($extra['group']);
  273. }
  274. $extra['behavior'] = true;
  275. return $Model->paginateCount($conditions, $recursive, $extra);
  276. }
  277. /**
  278. * Returns if a latitude is valid or not.
  279. * validation rule for models
  280. *
  281. * @param Model
  282. * @param float $latitude
  283. * @return bool
  284. */
  285. public function validateLatitude(Model $Model, $latitude) {
  286. if (is_array($latitude)) {
  287. $latitude = array_shift($latitude);
  288. }
  289. return ($latitude <= 90 && $latitude >= -90);
  290. }
  291. /**
  292. * Returns if a longitude is valid or not.
  293. * validation rule for models
  294. *
  295. * @param Model
  296. * @param float $longitude
  297. * @return bool
  298. */
  299. public function validateLongitude(Model $Model, $longitude) {
  300. if (is_array($longitude)) {
  301. $longitude = array_shift($longitude);
  302. }
  303. return ($longitude <= 180 && $longitude >= -180);
  304. }
  305. /**
  306. * uses the GeocodeLib to query
  307. * @param array $addressFields (simple array of address pieces)
  308. * @return array
  309. */
  310. protected function _geocode($addressFields, $options = array()) {
  311. $address = implode(' ', $addressFields);
  312. if (empty($address)) {
  313. return array();
  314. }
  315. $geocodeOptions = array(
  316. 'log' => $options['log'], 'min_accuracy' => $options['min_accuracy'],
  317. 'expect' => $options['expect'], 'allow_inconclusive' => $options['allow_inconclusive'],
  318. 'host' => $options['host']
  319. );
  320. $this->Geocode = new GeocodeLib($geocodeOptions);
  321. $settings = array('language' => $options['language']);
  322. if (!$this->Geocode->geocode($address, $settings)) {
  323. return array('lat' => 0, 'lng' => 0, 'formatted_address' => '');
  324. }
  325. $res = $this->Geocode->getResult();
  326. if (isset($res[0])) {
  327. $res = $res[0];
  328. }
  329. return $res;
  330. }
  331. }