Difference between revisions of "CommonFormula"
(→variables) |
(→functions) |
||
| Line 18: | Line 18: | ||
Example: | Example: | ||
<pre>roundCeil(106,5) return 110</pre> | <pre>roundCeil(106,5) return 110</pre> | ||
| + | ==getAccount(a, %PILOT)== | ||
| + | return the account id of the account type id "a" from the member %PILOT | ||
| + | |||
| + | Example: | ||
| + | <pre>getAccount(1, %PILOT) return 4</pre> | ||
| + | ==getBalance(a)== | ||
| + | return the balance of the account a | ||
| + | Example: | ||
| + | <pre>getBalance(1) return 25.01 | ||
| + | getBalance(getAccount(1, %PILOT)) return 35.01</pre> | ||
=variables= | =variables= | ||
Revision as of 16:39, 8 April 2010
Contents
conditional processing
(test) ? true-case : false-case
=conditional processing with operator OR/AND
( test1 OR test2 ) ? true-case : false-case ( test1 AND test2 ) ? true-case : false-case
functions
max(a,b)
return the maximum between a and b
min(a,b)
return the minimum between a and b
abs(a)
return the absolute value of a
roundCeil(a,b)
return the a value round top to b
Example:
roundCeil(106,5) return 110
getAccount(a, %PILOT)
return the account id of the account type id "a" from the member %PILOT
Example:
getAccount(1, %PILOT) return 4
getBalance(a)
return the balance of the account a Example:
getBalance(1) return 25.01 getBalance(getAccount(1, %PILOT)) return 35.01
variables
%DURATION
flight time input into the form
%COUNTER_DEPARTURE
counter departure input into the form
%COUNTER_ARRIVAL
counter arrival input into the form
%PILOT
pilot id
%LASTNAME
member lastname
%FIRSTNAME
member firstname
%NOW_DATE
current date (format is YYYY-MM-DD hh:mm:ss)
%USER_TZ
member timezone
%ENTITY_TZ
structure/entity timezone
