AdminDoc2.0

Revision as of 03:38, 13 October 2008 by Joel (Talk | contribs) (Currency pattern)

Jump to: navigation, search

This page is dedicated to receive admin doc of release 2.0.

  • Lors de l'import d'utilisateurs, contrairement à la version 1.2 où il y avait une série de check-box permettant de définir les paramètres par défaut, c'est les paramètres par défaut du club qui sont appliqués.

Parameters

Menu "club/parameters"

Account management

Currency pattern

Currency pattern is built with the currency symbol defined by the user

Pattern Symbol Separator Example Countries
Decimal Thousand
$#,##0.00;$-#,##0.00 before comma dot $-1,234.56 Defaut, USA, England, Yen
#,##0.00$;-#,##0.00$ after comma dot -1,234.56د.م.‏ Algeria, Maroc
€#.##0,00;€-#.##0,00 before dot comma €-1.234,56 Italy, Belgium
#.##0,00€;-#.##0,00€ after dot comma -1.234,56€ German, Spain, Portuguese
# ##0,00€;-# ##0,00€ after comma space -1 234,56€ French, Russia
Fr#'##0.00;Fr-#'##0.00 before dot quote Fr-1'234.56 Swiss
# ##0€00;-# ##0€00 decimal replaced by symbolspace -1 234€56
#,##0$00;-#,##0$00 decimal replaced by symbol comma -1,234$56

Create users

To add an user you need first:

  • To create groups (Users/Group) if needed
  • Then you go to Users/Users list and you select "ADD AN USER"

Create instructors

  • You check the instructor box ("Type of user" in the user form) to choosen users and you don't forget to specify the "Instructors Initials"

Create aircrafts

  • You need first to create aircrafts type as needed (in Fleet/Aircraft types)
  • Then you go to Fleet/Aircraft and you select "ADD AN AIRCRAFT"

Flight hours computation

In all formula, due to difference with interpretaion of decimal separator in various personnal computer, all values must to write without decimal separator, use X/Y to obtain correct value

Do not forget that time is given in sexacentimal. So to convert in hours you have to divide by 600.

1 minute = 10 sexacentimals
5 minutes = 50 sexacentimals
1 hundredth of minute = 6 sexacentimals
10 hundredth of minute (=1 tenth of minute) = 60 sexacentimals

Example: for 100,10 €/h

10010*%DURATION/60000
to round at 5 minutes : roundCeil(X,50)
to round with 10 hundredths : roundCeil(X,60)


Formula

Variable name description
%DURATION flight time input into the form
%COUNTER_DEPARTURE counter departure input into the form
%COUNTER_ARRIVAL counter arrival input into the form
Function description Example
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 roundCeil(106,5) return 110

Examples

Difference of the hours

%DURATION

Difference of the counters

%COUNTER_ARRIVAL - %COUNTER_DEPARTURE

Round difference of the hours at (top) 5 minutes

roundCeil(%DURATION, 50)

Round difference of the hours at (bottom) 5 minutes

roundCeil(%DURATION - 40, 50)

Round difference of the hours at (nearest) 5 minutes

roundCeil(%DURATION - 20, 50)

Difference of the counters plus 5 minutes

%COUNTER_ARRIVAL - %COUNTER_DEPARTURE + 50

Round difference of the counters at 10 hundreth

roundCeil(%COUNTER_ARRIVAL - %COUNTER_DEPARTURE, 60)

Greater between difference of the hours and difference of the counters

max(%DURATION, %COUNTER_ARRIVAL - %COUNTER_DEPARTURE)

Greater between difference of the hours and round difference of the counters at 5 minutes

max(%DURATION,roundCeil(%COUNTER_ARRIVAL - %COUNTER_DEPARTURE, 50))

Difference of the counters rounded to the nearest 5 minutes

roundCeil(%COUNTER_ARRIVAL - %COUNTER_DEPARTURE - 25, 50)

Example of results

input value output value
10 10
11 10
12 10
13 15
14 15
15 15

Pricing management

Formula

The formula knows following variables:

Variable name description
%DURATION Calculated duration recorded for the flight
%COUNTER_DEPARTURE counter departure recorded for the flight
%COUNTER_ARRIVAL counter arrival recorded for the flight
Function description Example
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 roundCeil(106,5) return 110

Example

  • An aircraft with a cost of 94€ per flight hours, will have:
94*%DURATION/600
  • An aircraft with a cost of 110€ per "counter" hours, will have:
110*(%COUNTER_ARRIVAL-%COUNTER_DEPARTURE)/600

Qualification

You may define your own qualifications (licence, medical, etc.)

For doing that, you got several parameters available:

Time limitation

For qualifications with a time limitation (pilots will have a date to set for this kind of qualification)

Identifier code management

Add a field for entering the id of the qualification attached to the pilot

Obtaining date management

Add a date field for the obtention date of the qualification

Reserved to instructors

Qualifications reserved to instructors

Blocking qualification

Qualifications will be blocking for flight (not for reservation)

Recent experience: "experience formula"

You may create qualifications checking recent experience like hours or landing number.

Like other qualifications, these ones are managed in the qualification manager (admin menu: users/qualification)

Formula checking recent experience have to be set in the "experience formula" column.

Formula

The formula knows following variables:

Variable name description
%PILOT Pilot id
Function description Example
sumFlightHour(%PILOT,position,day,aircraftType1,aircraftType2,etc) return the flight hours for %PILOT
sumLandingNumber(%PILOT,position,day,aircraftType1,aircraftType2,etc) return the landing number

Example

Accountancy

Accountancy tips and tricks

Aircraft Type

Tank

  • Goal: allow to an admin to create as many tanks (by aircraft type) as he needs.
  • Use: for each flight, the pilot would be able to say which quantity has been added for each tank created by the admin, before and/or after the flight.

How to create a tank

  • Go to Fleet/Aircraft types
  • then action "modify" for a choosen aircraft type
  • At the bottom of the page (bellow "Tank" title):
    • Fill the "Tank" text area with the choosen name (ex: "main tank")
    • Choose a fuel type and an unit
    • Clic on the "Add" button

Reports

Admin are allowed to create their own database SQL extract and to see them on their browser or to save them in an XML file via the "REPORTS" menu.

Get the list of members whom had subscribed this year

SELECT first_name,last_name FROM authentication
RIGHT JOIN member ON member.id=authentication.id WHERE year(member.subscription)=$year
ORDER BY last_name,first_name