imported>Claratte: /* Flight hours since one year for a flight type */

2015-01-09T09:55:08Z

Flight hours since one year for a flight type

New page

__TOC__
=Presentation=
This page gathers some examples of formula with theirs explanations.

Allowed Comparison operators are : '''equal''' (=), '''greater than''' (>), '''lesser than''' (<)

=Various formula for several usage=

==Flight hours done in one year for a given flight type==
In following examples, replace 'flight type' by the flight type id.

If used in flight hours pricing formula or validity formula:
<pre>sumFlightTime(%PILOT, formatDate('yyyy',%NOW_DATE)-1, formatDate('M',%NOW_DATE), formatDate('d',%NOW_DATE), 0, 0, 0, 'flight type' )</pre>

If used in product sale formula:
<pre>sumFlightTime(%USER_ID, formatDate('yyyy',%NOW_DATE)-1, formatDate('M',%NOW_DATE), formatDate('d',%NOW_DATE), 0, 0, 0, 'flight type' )</pre>

==Test age==
Test age in flight hours pricing formula:
<pre>(getYearsFromDiffDate( getBirthdate(%PILOT), formatDate('yyyy-01-01',%NOW_DATE))>25)?1:0</pre>

Test age in product sale formula:
<pre>(getYearsFromDiffDate( getBirthdate(%USER_ID), formatDate('yyyy-01-01',%NOW_DATE))>25)?1:0</pre>

=Activity sale engine (=flight hours pricing)=
==Apply another pricing after a period time==

The pricing rule is as followed : If a flight starts after 7:00 am UTC (7:00 am included), we apply a pricing of $1. Otherwise, we apply a pricing of $2.

The formula will be :
<pre>( (formatDate('hmm',%START_DATE) > 659) ? $1 : $2 )</pre>

*[[CommonFormula#.25START_DATE|%START_DATE]] is an internal variable representing the flight start date. The date is in UTC timezone
*[[CommonFormula#formatDate.28.27pattern.27.2C.25SOME_DATE.29|formatDate]] is an internal function to format a date into another format
*'''formatDate('hmm',%START_DATE)''' will format the date by using the pattern '''hmm'''
**It gives '''1511''' for the date '''2011-01-05 15:11:01'''
**It gives '''700''' for the date '''2011-01-12 07:00:00'''
*'''(formatDate('hmm',%START_DATE) > 659)''' is the rule condition we want to apply
**659 represents 6:59 am
**659 is used instead of 700 because 7:00 am is included.
**When comparing a time with this pattern 'hmm', the time range is 0 - 2359

The pricing rule is as followed : All flights are always done into France. If a flight starts after 11:00 am (11:00 am included), we apply a pricing of $1. Otherwise, we apply a pricing of $2.
The formula will be :
<pre>( (formatDate( 'hmm',convertTimezone(%START_DATE, 'UTC','Europe/Paris') ) > 1100) ? $1 : $2 )</pre>
*[[CommonFormula#convertTimezone.28.25SOME_DATE.2C_.25SOME_TZ1.2C_.25SOME_TZ2.29|convertTimezone]] is an internal function to convert a date from a timezone to another timezone
**since %START_DATE is already in UTC, we let the timezone '''UTC''' as second parameter of the function
**'''Europe/Paris''' is the timezone used in France
*Formula is regardless of daylight saving time

==Apply another pricing after some flight hours within the current year==
*The following digit "4" should be changed by the right flight type id.
*the following 600 number should be changed by the sexacentimal flight time step.
<pre>((sumFlightTime(%PILOT, formatDate('yyyy',%START_DATE), 01, 01, 00, 00, 0, 4 ) > 600) ? $tarifInstruction*%DURATION/600 : 0)</pre>

==Apply a reduction when some flight hours are lower than a level==
*The following digit "4" should be changed by the right flight type id.
*the following 600 number should be changed by the sexacentimal flight time step.
<pre>(sumFlightTime(%PILOT, formatDate('yyyy',%START_DATE), 01, 01, 00, 00, 0, 4 )<600)?($tarifInstruction*min(%DURATION,600-sumFlightTime(%PILOT, formatDate('yyyy',%START_DATE), 01, 01, 00, 00, 0, 4 ))/600):0</pre>

==Apply a reduction when some flight hours are lower than a level on winter months==
*Total instruction hours during winter period 1
@totalInstructionHours:
<pre>(formatDate('MM',%START_DATE)>10)?(sumFlightTime(%PILOT,formatDate('yyyy',%START_DATE),11,01,00,00,0,4)):0</pre>
*Total instruction hours during winter period 2
@totalInstructionHours:
<pre>(formatDate('MM',%START_DATE)<4)?(sumFlightTime(%PILOT,(formatDate('yyyy',%START_DATE)-1),11,01,00,00,0,4)):0</pre>
<pre>((@flightMonth>10) OR (@flightMonth<4))?((((@totalInstructionHours+%DURATION)/600)<5)?($tarifInstruction*%DURATION/600):($tarifInstruction*(5-(%DURATION/600)))):0</pre>

==Quarter per hour billing with one hour minimum==
The following formula bills a minimum of one hour then by size of quarter of hour.
<pre>max(4, roundCeil(%DURATION/150,1))*$price</pre>

=Product sale engine=
==Apply a reduction according the bill date in the year==
Example: apply 50% cut off if the bill date is the First of July or later in the year.
<pre>(formatDate('MM',%NOW_DATE)>6)?($summerRate/100*(@standardPrice)):0</pre>

Typical formula - Revision history

imported>Claratte: /* Flight hours since one year for a flight type */