Difference between revisions of "CommonFormula"
(→operators) |
(→variables) |
||
Line 26: | Line 26: | ||
==%COUNTER_ARRIVAL== | ==%COUNTER_ARRIVAL== | ||
counter arrival input into the form | 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 |
Revision as of 16:35, 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
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