GeocoderBehavior.php 12 KB

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