Export generator 4

Ozerhouni — Wed, 08 Jul 2026 08:20:02 GMT

← Older revision		Revision as of 08:20, 8 July 2026
Line 748:		Line 748:

	=Flight time management=		=Flight time management=

			==Aircraft cell and engine hours total==

			This is the report displayed under '''Activities''' category, listed in library as '''REPORT_AIRCRAFT_CELL_ENGINE_HOURS_TOTAL'''. It gives, per aircraft, the airframe total hours and, when the resource type has the "Engine time calculation different from flight time" option enabled ('''aircraft_type.engine_duration_formula'''), the engine total hours (same values as the ones displayed on '''Management > Resources > Navigability''').

			<syntaxhighlight lang="sql">SELECT resource.id AS _tr(ID),
			resource.name AS _tr(NAME),
			sexa2HoursMinute( aircraft.ref_hours + IFNULL(SUM(flight.duration),0) ) AS _tr(REPORT_AIRCRAFT_TOTAL_FRAME_HOURS),
			IF( aircraft_type.engine_duration_formula IS NOT NULL,
			sexa2HoursMinute( aircraft.ref_engine_hours + IFNULL(SUM(flight.engine_duration),0) ),
			'' ) AS _tr(REPORT_AIRCRAFT_TOTAL_ENGINE_HOURS)
			FROM resource
			INNER JOIN aircraft ON (aircraft.id=resource.id)
			LEFT JOIN aircraft_type ON (aircraft_type.id=resource.resource_type_id)
			LEFT JOIN flight ON (flight.aircraft_id=resource.id AND flight.airborne=0 AND flight.start_date > aircraft.ref_date)
			WHERE resource.physical=1 AND resource.activated=1
			GROUP BY resource.id
			ORDER BY resource.id</syntaxhighlight>

	==Flight hours total and last recorded counters to the date X==		==Flight hours total and last recorded counters to the date X==

OpenFlyers Documentation - Recent changes [en]