Difference between revisions of "OpenFlyers SQL stored functions and procedures"
m (→saleQualification) |
(→sumAccountEntry) |
||
Line 24: | Line 24: | ||
*Input parameters: | *Input parameters: | ||
**accountId (account Id) | **accountId (account Id) | ||
− | **endDate (to compute only account entries | + | **endDate (to compute only account entries from opening accounting date to this date) |
*Output parameters: | *Output parameters: | ||
**totalBalance (balance) | **totalBalance (balance) |
Revision as of 15:54, 8 April 2011
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.
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:
- validityId (id of the qualification)
- authenticationId (id of the user)
- validityCost
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)