Export generator 4 - Revision history

Mbouzar: /* Booking */

2026-06-10T15:40:41Z

Booking

← Older revision		Revision as of 15:40, 10 June 2026
Line 646:		Line 646:
	LEFT JOIN person ON (person.id=booking_person.person_id)		LEFT JOIN person ON (person.id=booking_person.person_id)
	WHERE booking_person.place_num=0		WHERE booking_person.place_num=0
	~~AND person.activated=1~~
	) AS left_booking_person ON (booking.id=left_booking_person.booking_id)		) AS left_booking_person ON (booking.id=left_booking_person.booking_id)
	LEFT JOIN (		LEFT JOIN (
Line 653:		Line 652:
	LEFT JOIN person ON (person.id=booking_person.person_id)		LEFT JOIN person ON (person.id=booking_person.person_id)
	WHERE booking_person.place_num=1		WHERE booking_person.place_num=1
	~~AND person.activated=1~~
	) AS right_booking_person ON (booking.id=right_booking_person.booking_id)		) AS right_booking_person ON (booking.id=right_booking_person.booking_id)
	WHERE booking.start_date >= $startDate AND booking.end_date < $endDate		WHERE booking.start_date >= $startDate AND booking.end_date < $endDate

Mbouzar: /* Flight hours total over a 12 months period */

2026-03-10T09:14:49Z

Flight hours total over a 12 months period

← Older revision		Revision as of 09:14, 10 March 2026
Line 786:		Line 786:
	LEFT JOIN person a ON a.id=fp.pilot_id		LEFT JOIN person a ON a.id=fp.pilot_id
	WHERE start_date > DATE_SUB(NOW(), INTERVAL 1 YEAR) AND fp.num=0		WHERE start_date > DATE_SUB(NOW(), INTERVAL 1 YEAR) AND fp.num=0
	GROUP BY Person, Solo_DC</syntaxhighlight>		GROUP BY Person, Solo_DC
			ORDER BY last_name, first_name</syntaxhighlight>

	==Flights hours total per aircraft per year==		==Flights hours total per aircraft per year==

Lelhidam: /* Flight log book */

2025-10-13T12:33:34Z

Flight log book

@@ Line 1,418: / Line 1,418: @@
          flight.landing_number AS _tr(FLIGHT_LANDING_NUMBER),
          flight.people_onboard AS _tr(FLIGHT_PEOPLE_ON_BOARD),
      ',
      GROUP_CONCAT(
@@ Line 1,453: / Line 1,452: @@
          SEPARATOR ', '
      ),
      ' FROM flight_pilot
      LEFT JOIN flight ON flight_pilot.flight_id = flight.id
@@ Line 1,460: / Line 1,486: @@
      LEFT JOIN person ON person.id = flight_pilot.pilot_id
      LEFT JOIN resource ON resource.id = flight.aircraft_id
      WHERE YEAR(flight.start_date) = ', $year ,' AND flight_pilot.num = 0 AND flight.airborne = 0
      GROUP BY flight.id

Claratte: /* Number of flights per instructor, month (for a flight type) */

2025-05-27T09:55:16Z

Number of flights per instructor, month (for a flight type)

Claratte: /* Number of flights per instructor, month (for a flight type) */

2025-05-27T09:54:32Z

Number of flights per instructor, month (for a flight type)

← Older revision		Revision as of 09:54, 27 May 2025
Line 1,246:		Line 1,246:
	==Number of flights per instructor, month (for a flight type)==		==Number of flights per instructor, month (for a flight type)==
	Following extrafields are needed :		Following extrafields are needed :
	*year (Type : Year)		*'''$year''' (Type : Year)
	*activityTypeId (Type : dbObject::FlightType)		*'''$activityTypeId''' (Type : dbObject::FlightType)
	<syntaxhighlight lang="sql">SELECT		<syntaxhighlight lang="sql">SELECT
	CONCAT(UPPER(person.last_name), ' ', person.first_name) AS _tr(LAST_NAME),		CONCAT(UPPER(person.last_name), ' ', person.first_name) AS _tr(LAST_NAME),

Claratte: /* Flight hours per activity type between date */

2025-05-27T09:53:20Z

Flight hours per activity type between date

@@ Line 1,243: / Line 1,243: @@
 FROM activity_type
 WHERE activity_type.activated=1</syntaxhighlight>
 =Flight reports=

Claratte: /* Flights with mechanic remark */

2025-04-14T10:36:44Z

Flights with mechanic remark

← Older revision		Revision as of 10:36, 14 April 2025
Line 1,462:		Line 1,462:

	==Flights with mechanic remark==		==Flights with mechanic remark==
	*See [[~~OF_doc4~~-fr:Suivi-des-remarques-de-maintenance\|Suivi des remarques de maintenance]]		*See [[OF_doc-fr:Suivi-des-remarques-de-maintenance\|Suivi des remarques de maintenance]]

	Following variables are needed:		Following variables are needed:

Claratte: /* Flights with mechanic remark */

2025-04-14T10:36:26Z

Flights with mechanic remark

← Older revision		Revision as of 10:36, 14 April 2025
Line 1,462:		Line 1,462:

	==Flights with mechanic remark==		==Flights with mechanic remark==
	*See [[~~OF_doc~~-fr:Suivi-des-remarques-de-maintenance\|Suivi des remarques de maintenance]]		*See [[OF_doc4-fr:Suivi-des-remarques-de-maintenance\|Suivi des remarques de maintenance]]

	Following variables are needed:		Following variables are needed:

Claratte: /* Flights with mechanic remark */

2025-04-14T10:35:40Z

Flights with mechanic remark

← Older revision		Revision as of 10:35, 14 April 2025
Line 1,462:		Line 1,462:

	==Flights with mechanic remark==		==Flights with mechanic remark==
			*See [[OF_doc-fr:Suivi-des-remarques-de-maintenance\|Suivi des remarques de maintenance]]

	Following variables are needed:		Following variables are needed:
	*Business field '''$maintenanceUserComment''' should be defined first and should be of '''Text multi line''' value type and '''Flight''' category.		*Business field '''$maintenanceUserComment''' should be defined first and should be of '''Text multi line''' value type and '''Flight''' category.

Claratte: /* Booking */

2025-04-10T07:22:01Z

Booking

← Older revision		Revision as of 07:22, 10 April 2025
Line 609:		Line 609:
	* Variable '''$resourceId''' of '''dbObject::Resource''' value type.		* Variable '''$resourceId''' of '''dbObject::Resource''' value type.

	<syntaxhighlight lang="sql">[OF_DYNAMIC_SQL]		<syntaxhighlight lang="sql">
			[OF_DYNAMIC_SQL]
	SELECT CONCAT(		SELECT CONCAT(
	'SELECT booking.id AS _tr(ID),		'SELECT booking.id AS _tr(ID),
Line 621:		Line 622:
	resource.name AS _tr(RESOURCE),		resource.name AS _tr(RESOURCE),
	left_booking_person.full_name AS _tr(LEFT_PLACE),		left_booking_person.full_name AS _tr(LEFT_PLACE),
	left_booking_person.email AS tr(EMAIL),		left_booking_person.email AS _tr(EMAIL),
	left_booking_person.cellPhone AS _tr(PHONE),		left_booking_person.cellPhone AS _tr(PHONE),
	left_booking_person.birthDate AS _tr(BIRTHDATE),		left_booking_person.birthDate AS _tr(BIRTHDATE),
Line 662:		Line 663:
	)		)
	FROM business_field		FROM business_field
	WHERE business_field.category='BOOKING' AND business_field.user_access_mode!=2</syntaxhighlight>		WHERE business_field.category='BOOKING' AND business_field.user_access_mode!=2
			</syntaxhighlight>

	==Cumulated maintenance hours on a period==		==Cumulated maintenance hours on a period==

← Older revision		Revision as of 09:55, 27 May 2025
Line 1,250:		Line 1,250:
	<syntaxhighlight lang="sql">SELECT		<syntaxhighlight lang="sql">SELECT
	CONCAT(UPPER(person.last_name), ' ', person.first_name) AS _tr(LAST_NAME),		CONCAT(UPPER(person.last_name), ' ', person.first_name) AS _tr(LAST_NAME),
	(SELECT ~~sexa2HoursMinute~~( ~~SUM( duration )~~ ) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 1 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_JANUARY),		(SELECT COUNT(*) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 1 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_JANUARY),
	(SELECT ~~sexa2HoursMinute( SUM~~( ~~duration )~~ ) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 2 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_FEBRUARY),		(SELECT COUNT(*) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 2 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_FEBRUARY),
	(SELECT ~~sexa2HoursMinute~~( ~~SUM( duration )~~ ) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 3 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_MARCH),		(SELECT COUNT(*) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 3 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_MARCH),
	(SELECT ~~sexa2HoursMinute~~( ~~SUM( duration )~~ ) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 4 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_APRIL),		(SELECT COUNT(*) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 4 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_APRIL),
	(SELECT ~~sexa2HoursMinute~~( ~~SUM( duration )~~ ) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 5 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_MAY),		(SELECT COUNT(*) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 5 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_MAY),
	(SELECT ~~sexa2HoursMinute( SUM~~( ~~duration )~~ ) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 6 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_JUN),		(SELECT COUNT(*) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 6 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_JUN),
	(SELECT ~~sexa2HoursMinute( SUM~~( ~~duration )~~ ) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 7 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_JULY),		(SELECT COUNT(*) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 7 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_JULY),
	(SELECT ~~sexa2HoursMinute( SUM~~( ~~duration )~~ ) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 8 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_AUGUST),		(SELECT COUNT(*) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 8 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_AUGUST),
	(SELECT ~~sexa2HoursMinute~~( ~~SUM( duration )~~ ) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 9 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_SEPTEMBER),		(SELECT COUNT(*) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 9 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_SEPTEMBER),
	(SELECT ~~sexa2HoursMinute~~( ~~SUM( duration )~~ ) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 10 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_OCTOBER),		(SELECT COUNT(*) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 10 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_OCTOBER),
	(SELECT ~~sexa2HoursMinute~~( ~~SUM( duration )~~ ) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 11 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_NOVEMBER),		(SELECT COUNT(*) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 11 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_NOVEMBER),
	(SELECT ~~sexa2HoursMinute( SUM~~( ~~duration )~~ ) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 12 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_DECEMBER),		(SELECT COUNT(*) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 12 AND flight_pilot.pilot_id = person.id AND flight_pilot.num = 1 AND ( flight.activity_type_id & $activityTypeId != 0 OR ''=$activityTypeId ) ) AS _tr(MONTH_DECEMBER),
	~~sexa2HoursMinute~~( ~~SUM( duration )~~ ) AS _tr(TOTAL)		COUNT(*) AS _tr(TOTAL)
	FROM flight		FROM flight
	LEFT JOIN flight_pilot fp ON fp.flight_id = flight.id		LEFT JOIN flight_pilot fp ON fp.flight_id = flight.id