Difference between revisions of "OpenFlyers SQL stored functions and procedures"
(→sumAccountEntry) |
|||
Line 2: | Line 2: | ||
=Presentation= | =Presentation= | ||
This page is dedicated to list OpenFlyers SQL stored functions and procedures which are accessibles to OpenFlyers administrators via the SQL exports or imports. | This page is dedicated to list OpenFlyers SQL stored functions and procedures which are accessibles to OpenFlyers administrators via the SQL exports or imports. | ||
+ | |||
+ | =distanceBetween2Point= | ||
+ | *This procedure exists with OF 3.0+ | ||
+ | *Stored function to calculate distance between two points (of a coordinate) | ||
+ | *Input parameters: | ||
+ | **latitude1 | ||
+ | **longitude1 | ||
+ | **latitude2 | ||
+ | **longitude2 | ||
+ | *Output parameters: | ||
+ | **distance | ||
+ | |||
+ | =nearestPoint= | ||
+ | *This procedure exists with OF 3.0+ | ||
+ | *Stored function to find the nearest ICAO from a coordinate | ||
+ | *Input parameters: | ||
+ | **latRef (latitude of the coordinate) | ||
+ | **longRef (longitude of the coordinate) | ||
+ | **distanceMax (max distance to filter result) | ||
+ | *Output parameters: | ||
+ | **ICAO id | ||
=saleValidity= | =saleValidity= | ||
Line 7: | Line 28: | ||
*Stored procedure to create account entries and update validity expire date of an user (or add validity to the user if it doesn't exist) | *Stored procedure to create account entries and update validity expire date of an user (or add validity to the user if it doesn't exist) | ||
*Input parameters: | *Input parameters: | ||
− | ** | + | **validityTypeId (id of the validity type) |
− | ** | + | **personId (id of the person) |
− | ** | + | **validityTypeCost (validity type cost) |
=stripChars= | =stripChars= |
Revision as of 11:16, 23 May 2011
Contents
Presentation
This page is dedicated to list OpenFlyers SQL stored functions and procedures which are accessibles to OpenFlyers administrators via the SQL exports or imports.
distanceBetween2Point
- This procedure exists with OF 3.0+
- Stored function to calculate distance between two points (of a coordinate)
- Input parameters:
- latitude1
- longitude1
- latitude2
- longitude2
- Output parameters:
- distance
nearestPoint
- This procedure exists with OF 3.0+
- Stored function to find the nearest ICAO from a coordinate
- Input parameters:
- latRef (latitude of the coordinate)
- longRef (longitude of the coordinate)
- distanceMax (max distance to filter result)
- Output parameters:
- ICAO id
saleValidity
- This procedure exists with OF 3.0+
- Stored procedure to create account entries and update validity expire date of an user (or add validity to the user if it doesn't exist)
- Input parameters:
- validityTypeId (id of the validity type)
- personId (id of the person)
- validityTypeCost (validity type cost)
stripChars
- This function exists with OF 3.0+
- Stored function to get a cleaned string (remove spaces and underscores)
- Input parameters:
- word (the string to be cleaned)
- Output parameters:
- stripWord (the string cleaned)
sumAccountEntry
- This function exists with OF 2.1+
- Stored function to compute the current balance of an account at a given date
- Input parameters:
- accountId (account Id)
- endDate (to compute only account entries from opening accounting date to this date)
- Output parameters:
- totalBalance (balance)