Overview

Packages

  • Kronolith
  • None

Classes

  • Kronolith
  • Kronolith_Ajax_Application
  • Kronolith_Ajax_Imple_ContactAutoCompleter
  • Kronolith_Ajax_Imple_Embed
  • Kronolith_Ajax_Imple_TagActions
  • Kronolith_Ajax_Imple_TagAutoCompleter
  • Kronolith_Api
  • Kronolith_Calendar
  • Kronolith_Calendar_External
  • Kronolith_Calendar_External_Tasks
  • Kronolith_Calendar_Holiday
  • Kronolith_Calendar_Internal
  • Kronolith_Calendar_Remote
  • Kronolith_Calendar_Resource
  • Kronolith_Calendars_Base
  • Kronolith_Calendars_Default
  • Kronolith_Calendars_Kolab
  • Kronolith_Day
  • Kronolith_Driver
  • Kronolith_Driver_Holidays
  • Kronolith_Driver_Horde
  • Kronolith_Driver_Ical
  • Kronolith_Driver_Kolab
  • Kronolith_Driver_Mock
  • Kronolith_Driver_Resource
  • Kronolith_Driver_Sql
  • Kronolith_Event
  • Kronolith_Event_Holidays
  • Kronolith_Event_Horde
  • Kronolith_Event_Ical
  • Kronolith_Event_Kolab
  • Kronolith_Event_Resource
  • Kronolith_Event_Sql
  • Kronolith_Exception
  • Kronolith_Factory_Calendars
  • Kronolith_Factory_Geo
  • Kronolith_Form_CreateCalendar
  • Kronolith_Form_CreateResource
  • Kronolith_Form_CreateResourceGroup
  • Kronolith_Form_DeleteCalendar
  • Kronolith_Form_DeleteResource
  • Kronolith_Form_DeleteResourceGroup
  • Kronolith_Form_EditCalendar
  • Kronolith_Form_EditRemoteCalendar
  • Kronolith_Form_EditResource
  • Kronolith_Form_EditResourceGroup
  • Kronolith_Form_SubscribeRemoteCalendar
  • Kronolith_Form_UnsubscribeRemoteCalendar
  • Kronolith_FreeBusy
  • Kronolith_FreeBusy_View
  • Kronolith_FreeBusy_View_Day
  • Kronolith_FreeBusy_View_Month
  • Kronolith_FreeBusy_View_Week
  • Kronolith_FreeBusy_View_Workweek
  • Kronolith_Geo_Base
  • Kronolith_Geo_Mysql
  • Kronolith_Geo_Sql
  • Kronolith_LoginTasks_SystemTask_Upgrade
  • Kronolith_LoginTasks_Task_PurgeEvents
  • Kronolith_Notification_Listener_AjaxStatus
  • Kronolith_Resource
  • Kronolith_Resource_Base
  • Kronolith_Resource_Group
  • Kronolith_Resource_Single
  • Kronolith_Storage
  • Kronolith_Storage_Kolab
  • Kronolith_Storage_Sql
  • Kronolith_Tagger
  • Kronolith_Test
  • Kronolith_View_Day
  • Kronolith_View_DeleteEvent
  • Kronolith_View_EditEvent
  • Kronolith_View_Event
  • Kronolith_View_ExportEvent
  • Kronolith_View_Month
  • Kronolith_View_Week
  • Kronolith_View_WorkWeek
  • Kronolith_View_Year
  • Overview
  • Package
  • Class
  • Tree

Class Kronolith_Geo_Sql

General SQL implementation for storing/searching geo location data for events.

Copyright 2009-2012 Horde LLC (http://www.horde.org/)

See the enclosed file COPYING for license information (GPL). If you did not receive this file, see http://www.horde.org/licenses/gpl.

Kronolith_Geo_Base
Extended by Kronolith_Geo_Sql

Direct known subclasses

Kronolith_Geo_Mysql
Package: Kronolith
Category: Horde
Author: Michael J. Rubinsky mrubinsk@horde.org
Located at Geo/Sql.php
Methods summary
public
# setLocation( string $event_id, array $point )

Set the location of the specified event _id

Set the location of the specified event _id

Parameters

$event_id
The event id
$point
Hash containing 'lat' and 'lon' coordinates

Throws

Kronolith_Exception

See

Kronolith_Geo_Base#setLocation()
public array
# getLocation( string $event_id )

Get the location of the provided event_id.

Get the location of the provided event_id.

Parameters

$event_id
The event id

Returns

array
A hash containing 'lat' and 'lon'

Throws

Kronolith_Exception

See

Kronolith_Geo_Base#getLocation()
public
# deleteLocation( string $event_id )

Deletes an entry from storage

Deletes an entry from storage

Parameters

$event_id

Throws

Kronolith_Exception

See

Kronolith_Geo_Base#removeLocation()
public array
# search( array $criteria )

Search for events "close to" a given point.

Search for events "close to" a given point.

TODO: If all we really use the geodata for is distance, it really doesn't make sense to use the GIS extensions since the distance calculations are done with Euclidian geometry ONLY ... and therefore will give incorrect results when done on a geocentric coordinate system. They might be useful if we eventually want to do searches on MBRs

Parameters

$criteria
An array of: <pre>point - lat/lon <span class="php-keyword2">hash</span> radius - the radius to search in limit - limit the number of hits factor - Conversion factor <span class="php-keyword1">for</span> miles per distance unit [<span class="php-keyword1">default</span> is <span class="php-num">69</span>].</pre>

Returns

array
of event ids with locations near the specified criteria.

Throws

Kronolith_Exception

See

kronolith/lib/Driver/Kronolith_Driver_Geo#search($criteria)
Methods inherited from Kronolith_Geo_Base
__construct()
API documentation generated by ApiGen