GeocoderBehavior.php 12 KB

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