Difference between revisions of "OpenFlyers SQL stored functions and procedures"
(→stripChars) |
|||
| Line 3: | Line 3: | ||
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. | ||
| + | =saleQualification= | ||
| + | *Thiis function exists with OF 3.0+ | ||
| + | *Stored procedure to create account entries and update qualification expire date of an user (or add qualification to the user if it doesn't exist) | ||
| + | *Input parameters: | ||
| + | **qualificationId (id of the qualification) | ||
| + | **authenticationId (id of the user) | ||
=stripChars= | =stripChars= | ||
*This function exists with OF 3.0+ | *This function exists with OF 3.0+ | ||
Revision as of 16:10, 22 December 2010
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.
saleQualification
- Thiis function exists with OF 3.0+
- Stored procedure to create account entries and update qualification expire date of an user (or add qualification to the user if it doesn't exist)
- Input parameters:
- qualificationId (id of the qualification)
- authenticationId (id of the user)
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 before this date)
- Output parameters:
- totalBalance (balance)
