# Difference between revisions of "OpenFlyers SQL stored functions and procedures"

(→sumAccountEntry) |
|||

Line 48: | Line 48: | ||

*Output parameters: | *Output parameters: | ||

**totalBalance (balance) | **totalBalance (balance) | ||

+ | |||

+ | =sumAccountEntryCredit= | ||

+ | *This function exists with OF 3.5+ | ||

+ | *Stored function to compute the current sum of credit lines 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: | ||

+ | **totalCredit (total credit) | ||

+ | |||

+ | =sumAccountEntryDedit= | ||

+ | *This function exists with OF 3.5+ | ||

+ | *Stored function to compute the current sum of debit lines 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: | ||

+ | **totalDedit (total dedit) |

## Revision as of 17:25, 24 October 2014

## 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)

# sumAccountEntryCredit

- This function exists with OF 3.5+
- Stored function to compute the current sum of credit lines 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:
- totalCredit (total credit)

# sumAccountEntryDedit

- This function exists with OF 3.5+
- Stored function to compute the current sum of debit lines 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:
- totalDedit (total dedit)