User contributions
(newest | oldest) View (newer 100 | older 100) (20 | 50 | 100 | 250 | 500)
- 19:50, 24 October 2014 (diff | hist) . . (+321) . . Accounting reports 3 (→online payment attempts list)
- 19:26, 24 October 2014 (diff | hist) . . (0) . . OpenFlyers SQL stored functions and procedures (→sumAccountEntryDedit)
- 19:25, 24 October 2014 (diff | hist) . . (+654) . . OpenFlyers SQL stored functions and procedures (→sumAccountEntry)
- 13:29, 7 October 2014 (diff | hist) . . (+47) . . Export generator 3 (→Users)
- 11:22, 7 October 2014 (diff | hist) . . (-4) . . Users reports 3 (→User list with subscription grant date and profiles)
- 17:28, 2 October 2014 (diff | hist) . . (+31) . . Database description (→Hidden fields)
- 17:24, 2 October 2014 (diff | hist) . . (+633) . . Database description (→Dump of OF 3.5 structure)
- 14:15, 2 October 2014 (diff | hist) . . (+315) . . N Database description (Created page with "=Dump of OF 2.1 structure= =Dump of OF 3.5 structure= ==booking table== The content of ''aircraft_id'' field in ''booking'' table might be nul...")
- 14:14, 2 October 2014 (diff | hist) . . (+6) . . Main Page (→Export generation)
- 14:11, 2 October 2014 (diff | hist) . . (+15) . . Main Page (→Administrator doc)
- 14:10, 2 October 2014 (diff | hist) . . (+27) . . Main Page (→Export generation)
- 14:10, 2 October 2014 (diff | hist) . . (-52) . . Main Page (→Specs)
- 11:24, 2 October 2014 (diff | hist) . . (+46,185) . . N Database OF35 (Created page with "<sql>CREATE TABLE `account` ( `id` int(10) unsigned NOT NULL, `creation_date` date DEFAULT NULL, `name` text, `export_account` varchar(255) DEFAULT NULL, `activated` tiny...") (current)
- 11:33, 24 September 2014 (diff | hist) . . (+50) . . MediaWiki:Sidebar (current)
- 15:43, 22 September 2014 (diff | hist) . . (+1) . . Export generator 3 (→Pilots without flight in the last 3 months)
- 17:26, 16 September 2014 (diff | hist) . . (+64) . . Export generator 3 (→Flights hours : less than 21 years, more than 21 years, male, female)
- 17:16, 16 September 2014 (diff | hist) . . (+17) . . Export generator 3 (→Flights hours total per aircraft per year)
- 14:57, 9 September 2014 (diff | hist) . . (+485) . . Users reports 3 (→User e-mails list of selected validity type person equals given year)
- 10:35, 1 September 2014 (diff | hist) . . (-5) . . CommonFormula (→substr(string,a,b))
- 12:20, 14 August 2014 (diff | hist) . . (+1,102) . . Users reports 3 (→Users list with membership ending before a specific date)
- 20:17, 31 July 2014 (diff | hist) . . (+16) . . Export generator 3 (→Flights hours total per flight type)
- 20:08, 31 July 2014 (diff | hist) . . (+17) . . Export generator 3 (→Flights hours total per aircraft per year)
- 19:54, 31 July 2014 (diff | hist) . . (+610) . . Export generator 3 (→Flights hours total per aircraft per year and per month)
- 13:22, 20 June 2014 (diff | hist) . . (-209) . . Export generator 3 (→List of users with specific validity)
- 11:39, 9 June 2014 (diff | hist) . . (+17) . . Geolocation technologies for aerospace (→OpenFlyers Interfacing) (current)
- 11:36, 9 June 2014 (diff | hist) . . (+1,269) . . Geolocation technologies for aerospace (→GSM Transmission)
- 11:06, 9 June 2014 (diff | hist) . . (0) . . Geolocation technologies for aerospace (→GSM Transmission)
- 11:05, 9 June 2014 (diff | hist) . . (-19) . . Geolocation technologies for aerospace (→GSM Transmission)
- 10:46, 9 June 2014 (diff | hist) . . (-7) . . Geolocation technologies for aerospace (→Advantages of GSM transmission)
- 10:05, 9 June 2014 (diff | hist) . . (+1) . . Geolocation technologies for aerospace (→ACARS cost of transmission)
- 00:04, 9 June 2014 (diff | hist) . . (+9,143) . . Geolocation technologies for aerospace (→GNS position reception)
- 23:45, 8 June 2014 (diff | hist) . . (+1,015) . . Geolocation technologies for aerospace (→Geolocation principles)
- 23:38, 8 June 2014 (diff | hist) . . (+516) . . Geolocation technologies for aerospace (→Presentation)
- 23:56, 7 June 2014 (diff | hist) . . (+5) . . Accounting reports 3 (→online payment attempts)
- 23:56, 7 June 2014 (diff | hist) . . (-1) . . Accounting reports 3 (→=online payment attempts)
- 23:47, 7 June 2014 (diff | hist) . . (+21) . . Accounting reports 3 (→=on)
- 23:41, 7 June 2014 (diff | hist) . . (+427) . . Accounting reports 3 (→Monthly distribution of revenue)
- 17:18, 6 June 2014 (diff | hist) . . (+339) . . N Geolocation technologies for aerospace (Created page with "=Presentation= The purpose of this page is to present: *The different technological solutions for aeronautics geolocation in terms of: **data transmission **installation on board...")
- 17:13, 6 June 2014 (diff | hist) . . (-65) . . Main Page
- 16:04, 23 May 2014 (diff | hist) . . (+56) . . Export generator 3 (→Flights hours total per instructor per year and per month)
- 16:04, 23 May 2014 (diff | hist) . . (+54) . . Export generator 3 (→Flights hours total per instructor)
- 15:25, 15 May 2014 (diff | hist) . . (+4) . . CommonFormula (→hasValidity('person id', 'validity type id'))
- 13:18, 15 May 2014 (diff | hist) . . (+78) . . CommonFormula (→getBalance(U,[option B]))
- 13:13, 15 May 2014 (diff | hist) . . (+1) . . CommonFormula (→getBalance(a,[option]))
- 11:00, 27 March 2014 (diff | hist) . . (+264) . . Export generator 2.1 (→Aditionnal queries) (current)
- 23:03, 13 March 2014 (diff | hist) . . (+754) . . CommonFormula (→sumPreviousFlightTime('pilot id', 'position', 'day', 'endingDate', 'aircraft type 1' , 'aircraft type 2', 'aircraft type X'))
- 23:03, 13 March 2014 (diff | hist) . . (-754) . . CommonFormula (→sumLandingNumber('pilot id', 'position', 'day', 'aircraft type 1' , 'aircraft type 2', 'aircraft type X'))
- 23:01, 13 March 2014 (diff | hist) . . (+936) . . CommonFormula (→sumFlightTime(%PILOT, 'year', 'month', 'day', 'hour', 'minute', 'position' ))
- 23:00, 13 March 2014 (diff | hist) . . (-936) . . CommonFormula (→sumFlightHour('pilot id', 'position', 'day', 'aircraft type 1' , 'aircraft type 2', 'aircraft type X'))
- 00:06, 11 March 2014 (diff | hist) . . (+98) . . Users reports 3 (→User list without up to date subscription)
- 00:05, 11 March 2014 (diff | hist) . . (+4) . . Users reports 3 (→User list without up to date subscription)
- 22:27, 10 March 2014 (diff | hist) . . (+1) . . Accounting reports 3 (→List of all account debit, credit for specific accounting)
- 22:26, 10 March 2014 (diff | hist) . . (+1) . . Accounting reports 3 (→List of all account debit, credit)
- 16:26, 10 March 2014 (diff | hist) . . (-1) . . Users reports 3 (→User e-mails list)
- 16:25, 10 March 2014 (diff | hist) . . (+769) . . Users reports 3 (→User list coordinates)
- 16:15, 10 March 2014 (diff | hist) . . (+23) . . Users reports 3 (→User list with expire date validity equals a given year)
- 16:15, 10 March 2014 (diff | hist) . . (+18) . . Users reports 3 (→User list with up to date subscription)
- 16:12, 10 March 2014 (diff | hist) . . (+23) . . Users reports 3 (→Users list with membership ending before a specific date)
- 16:11, 10 March 2014 (diff | hist) . . (0) . . Users reports 3 (→Users list with membership ending before a specific date)
- 16:10, 10 March 2014 (diff | hist) . . (+98) . . Users reports 3 (→User list with up to date subscription)
- 16:09, 10 March 2014 (diff | hist) . . (-37) . . Users reports 3 (→User list with subscription grant date and profiles)
- 16:07, 10 March 2014 (diff | hist) . . (-3) . . Users reports 3 (→Users list with membership ending before a specific date)
- 16:06, 10 March 2014 (diff | hist) . . (-2) . . Users reports 3 (→User list by validity)
- 16:01, 10 March 2014 (diff | hist) . . (-10,720) . . Export generator 3 (→Users)
- 11:44, 10 March 2014 (diff | hist) . . (+10,703) . . N Users reports 3 (Created page with "=Users list with membership ending before a specific date= Variable $validityTypeId should be defined first and should be of dbOject::ValidityType value type. <SQL>SELECT perso...")
- 11:42, 10 March 2014 (diff | hist) . . (-47) . . Accounting reports 3
- 11:39, 10 March 2014 (diff | hist) . . (-26,033) . . Export generator 3 (→Accounting)
- 11:38, 10 March 2014 (diff | hist) . . (+26,149) . . N Accounting reports 3 (Created page with "=Introduction= This page lists SQL requests for OpenFlyers release 3 export about Accounting. =Global account balance= List whole account balance at the end of a given date ([[#...")
- 11:37, 10 March 2014 (diff | hist) . . (+55) . . Main Page (→Export generation)
- 11:35, 10 March 2014 (diff | hist) . . (+48) . . Main Page (→Export generation)
- 22:34, 25 February 2014 (diff | hist) . . (+87) . . Export generator 3 (→Flights hours total per instructor per year and per month)
- 15:16, 18 February 2014 (diff | hist) . . (+188) . . Typical formula (→Apply a reduction when some flight hours are lower than a level on winter months)
- 16:15, 27 January 2014 (diff | hist) . . (-13) . . Export generator 3 (→Number of members : male, female, less than 21 years and more than 21 years)
- 18:23, 31 December 2013 (diff | hist) . . (-1) . . Export generator 3 (→Get the pilot owner of an account)
- 18:23, 31 December 2013 (diff | hist) . . (-1) . . Export generator 3 (→Global account balance of pilots who last subscription was 2 years ago for specific accounting)
- 18:23, 31 December 2013 (diff | hist) . . (-1) . . Export generator 3 (→Global account balance of pilots who last subscription was 2 years ago)
- 18:22, 31 December 2013 (diff | hist) . . (+21) . . Export generator 3 (→List of users with specific validity)
- 18:21, 31 December 2013 (diff | hist) . . (-1) . . Export generator 3 (→List of pilots with specific validity)
- 17:00, 13 December 2013 (diff | hist) . . (+36) . . CommonFormula (→%USER_ID)
- 16:59, 13 December 2013 (diff | hist) . . (+44) . . CommonFormula (→%PILOT)
- 16:58, 13 December 2013 (diff | hist) . . (-4) . . CommonFormula (→hasValidity('person id', 'validity type id'))
- 15:05, 6 December 2013 (diff | hist) . . (+3) . . Export generator 3 (→Flight hours total per pilot)
- 15:58, 25 November 2013 (diff | hist) . . (+526) . . Export generator 3 (→Account balance list)
- 15:08, 25 November 2013 (diff | hist) . . (+1) . . Export generator 3 (→Users===Users list with membership ending before a specific date=)
- 15:08, 25 November 2013 (diff | hist) . . (+10,120) . . Export generator 3 (→movement without an account)
- 15:08, 25 November 2013 (diff | hist) . . (-10,113) . . Export generator 3 (→French administration Examples)
- 15:21, 8 October 2013 (diff | hist) . . (-49) . . Export generator 3 (→Licence in the year)
- 15:21, 8 October 2013 (diff | hist) . . (+46) . . Export generator 3 (→Licence in the year)
- 15:18, 8 October 2013 (diff | hist) . . (-6) . . Export generator 3 (→Licence in the year)
- 15:17, 8 October 2013 (diff | hist) . . (+1) . . Export generator 3 (→Licence in the year)
- 15:17, 8 October 2013 (diff | hist) . . (+2) . . Export generator 3 (→Licence in the year)
- 15:08, 8 October 2013 (diff | hist) . . (-6) . . Export generator 3 (→Get members list with membership ending before a specific date)
- 16:06, 23 September 2013 (diff | hist) . . (-2) . . FAQ customer (→Does OpenFlyers provide a world wide tracking solution for Jet plane?)
- 16:54, 9 September 2013 (diff | hist) . . (+387) . . FAQ customer (→GSM hardware solution)
- 19:28, 7 September 2013 (diff | hist) . . (-166) . . CommonFormula (→getCredit(a))
- 11:41, 22 August 2013 (diff | hist) . . (+27) . . FAQ customer (→Does OpenFlyers provide a world wide tracking solution for Jet plane?)
- 11:40, 22 August 2013 (diff | hist) . . (+195) . . FAQ customer
- 11:32, 22 August 2013 (diff | hist) . . (+2,652) . . FAQ customer (→Support)
- 11:54, 16 August 2013 (diff | hist) . . (+67) . . Typical formula (→Apply a reduction according the bill date in the year)
- 11:45, 16 August 2013 (diff | hist) . . (+180) . . Typical formula (→Activity sale engine (=flight hours pricing))
(newest | oldest) View (newer 100 | older 100) (20 | 50 | 100 | 250 | 500)