Accounting exports - Revision history

Lelhidam: /* Statement serving as invoice with flight details */

2025-04-25T11:43:45Z

Statement serving as invoice with flight details

← Older revision		Revision as of 13:43, 25 April 2025
Line 600:		Line 600:
	LEFT JOIN resource ON resource.id = flight.aircraft_id		LEFT JOIN resource ON resource.id = flight.aircraft_id
	LEFT JOIN business_field_content ON business_field_content.category_id=flight.id		LEFT JOIN business_field_content ON business_field_content.category_id=flight.id
	LEFT JOIN business_field ON (business_field.id=business_field_content.business_field_id ~~AND business_field.variable='activityComment'~~)		LEFT JOIN business_field ON (business_field.id=business_field_content.business_field_id)
	WHERE $startDate <= flight.start_date AND flight.start_date <= $endDate		WHERE $startDate <= flight.start_date AND flight.start_date <= $endDate
	AND (IF((($occupiedSeat=0)OR($occupiedSeat=-1)), 0, -1) = flight_pilot.num		AND (IF((($occupiedSeat=0)OR($occupiedSeat=-1)), 0, -1) = flight_pilot.num
	OR IF((($occupiedSeat=1)OR($occupiedSeat=-1)), 1, -1) = flight_pilot.num)		OR IF((($occupiedSeat=1)OR($occupiedSeat=-1)), 1, -1) = flight_pilot.num)
	AND ( profile.id IN ($profileId) OR '-' IN ($profileId) ) AND (account.category = 11 OR account.category = 2)		AND ( profile.id IN ($profileId) OR '-' IN ($profileId) ) AND (account.category = 11 OR account.category = 2)
			AND business_field.variable='activityComment'
	GROUP BY flight.id		GROUP BY flight.id
	ORDER BY flight.start_date</syntaxhighlight>		ORDER BY flight.start_date</syntaxhighlight>

Lelhidam: /* Statement serving as invoice */

2025-03-04T15:21:33Z

Statement serving as invoice

@@ Line 555: / Line 555: @@
 GROUP BY flight.id) AS flight_list ON flight_list.person_id=person.id
 GROUP BY person.id
-UNION
+</syntaxhighlight>
 =Statement serving as invoice with flight details=

Lelhidam: /* Statement serving as invoice with flight details */

2025-02-21T12:48:38Z

Statement serving as invoice with flight details

← Older revision		Revision as of 14:48, 21 February 2025
Line 636:		Line 636:
	*Variable '''$endDate''' should be of '''Date and time''' value type.		*Variable '''$endDate''' should be of '''Date and time''' value type.
	*Variable '''$profileId''' should be of '''Integer''' value type.		*Variable '''$profileId''' should be of '''Integer''' value type.
	*Variable '''$occupiedSeat''' ~~should be~~ of ~~'''dbOjectMulti~~::~~Profile''' value type~~.		*Variable '''$occupiedSeat''' represent the seat number of the person in the flight, can have following values (0: left place, 1: right place, -1: both).

	<syntaxhighlight lang="sql">SELECT		<syntaxhighlight lang="sql">SELECT
Line 676:		Line 676:
	LEFT JOIN business_field ON (business_field.id=business_field_content.business_field_id AND business_field.variable='activityComment')		LEFT JOIN business_field ON (business_field.id=business_field_content.business_field_id AND business_field.variable='activityComment')
	WHERE $startDate <= flight.start_date AND flight.start_date <= $endDate		WHERE $startDate <= flight.start_date AND flight.start_date <= $endDate
	AND (IF((($occupiedSeat=0)OR($occupiedSeat='')), 0, -1) = flight_pilot.num		AND (IF((($occupiedSeat=0)OR($occupiedSeat=-1)), 0, -1) = flight_pilot.num
	OR IF((($occupiedSeat=1)OR($occupiedSeat='')), 1, -1) = flight_pilot.num)		OR IF((($occupiedSeat=1)OR($occupiedSeat=-1)), 1, -1) = flight_pilot.num)
	AND ( profile.id IN ($profileId) OR '-' IN ($profileId) ) AND (account.category = 11 OR account.category = 2)		AND ( profile.id IN ($profileId) OR '-' IN ($profileId) ) AND (account.category = 11 OR account.category = 2)
	GROUP BY flight.id		GROUP BY flight.id

Lelhidam: /* Statement serving as invoice */

2025-02-21T12:44:06Z

Statement serving as invoice

Claratte at 08:10, 9 October 2024

2024-10-09T08:10:26Z

Show changes

Claratte: Claratte moved page Accounting exports 4 to Accounting exports without leaving a redirect

2024-08-31T10:12:43Z

Claratte moved page Accounting exports 4 to Accounting exports without leaving a redirect

← Older revision	Revision as of 12:12, 31 August 2024
(No difference)

imported>Claratte: Text replacement - "" to ""

2024-08-12T18:53:04Z

Text replacement - "<sql>" to "<syntaxhighlight lang="sql">"

Show changes

← Older revision		Revision as of 14:44, 21 February 2025
Line 535:		Line 535:
	*Variable '''$endDate''' should be of '''Date and time''' value type.		*Variable '''$endDate''' should be of '''Date and time''' value type.
	*Variable '''$profileId''' should be of '''Integer''' value type.		*Variable '''$profileId''' should be of '''Integer''' value type.
	*Variable '''$occupiedSeat''' ~~should be~~ of ~~'''dbOjectMulti~~::~~Profile''' value type.~~		*Variable '''$occupiedSeat''' represent the seat number of the person in the flight, can have following values (0: left place, 1: right place, -1: both)

	<syntaxhighlight lang="sql">SELECT CONCAT(person.last_name,' ',person.first_name) AS _tr(FULL_NAME),		<syntaxhighlight lang="sql">SELECT CONCAT(person.last_name,' ',person.first_name) AS _tr(FULL_NAME),
Line 550:		Line 550:
	LEFT JOIN account ON account.id=account_entry.account_id		LEFT JOIN account ON account.id=account_entry.account_id
	WHERE $startDate <= flight.start_date AND flight.start_date <= $endDate		WHERE $startDate <= flight.start_date AND flight.start_date <= $endDate
	AND (IF((($occupiedSeat=0)OR($occupiedSeat='')), 0, -1) = flight_pilot.num		AND (IF((($occupiedSeat=0)OR($occupiedSeat=-1)), 0, -1) = flight_pilot.num
	OR IF((($occupiedSeat=1)OR($occupiedSeat='')), 1, -1) = flight_pilot.num)		OR IF((($occupiedSeat=1)OR($occupiedSeat=-1)), 1, -1) = flight_pilot.num)
	AND ( profile.id IN ($profileId) OR '-' IN ($profileId) ) AND (account.category = 11 OR account.category = 2)		AND ( profile.id IN ($profileId) OR '-' IN ($profileId) ) AND (account.category = 11 OR account.category = 2)
	GROUP BY flight.id) AS flight_list ON flight_list.person_id=person.id		GROUP BY flight.id) AS flight_list ON flight_list.person_id=person.id
Line 570:		Line 570:
	LEFT JOIN account ON account.id=account_entry.account_id		LEFT JOIN account ON account.id=account_entry.account_id
	WHERE $startDate <= flight.start_date AND flight.start_date <= $endDate		WHERE $startDate <= flight.start_date AND flight.start_date <= $endDate
	AND (IF((($occupiedSeat=0)OR($occupiedSeat='')), 0, -1) = flight_pilot.num		AND (IF((($occupiedSeat=0)OR($occupiedSeat=-1)), 0, -1) = flight_pilot.num
	OR IF((($occupiedSeat=1)OR($occupiedSeat='')), 1, -1) = flight_pilot.num)		OR IF((($occupiedSeat=1)OR($occupiedSeat=-1)), 1, -1) = flight_pilot.num)
	AND ( profile.id IN ($profileId) OR '-' IN ($profileId) ) AND (account.category = 11 OR account.category = 2)		AND ( profile.id IN ($profileId) OR '-' IN ($profileId) ) AND (account.category = 11 OR account.category = 2)
	GROUP BY flight.id) AS flight_list ON flight_list.person_id=person.id		GROUP BY flight.id) AS flight_list ON flight_list.person_id=person.id
Line 588:		Line 588:
	LEFT JOIN account ON account.id=account_entry.account_id		LEFT JOIN account ON account.id=account_entry.account_id
	WHERE $startDate <= flight.start_date AND flight.start_date <= $endDate		WHERE $startDate <= flight.start_date AND flight.start_date <= $endDate
	AND (IF((($occupiedSeat=0)OR($occupiedSeat='')), 0, -1) = flight_pilot.num		AND (IF((($occupiedSeat=0)OR($occupiedSeat=-1)), 0, -1) = flight_pilot.num
	OR IF((($occupiedSeat=1)OR($occupiedSeat='')), 1, -1) = flight_pilot.num)		OR IF((($occupiedSeat=1)OR($occupiedSeat=-1)), 1, -1) = flight_pilot.num)
	AND ( profile.id IN ($profileId) OR '-' IN ($profileId) ) AND (account.category = 11 OR account.category = 2)		AND ( profile.id IN ($profileId) OR '-' IN ($profileId) ) AND (account.category = 11 OR account.category = 2)
	GROUP BY flight.id) AS flight_list ON flight_list.person_id=person.id		GROUP BY flight.id) AS flight_list ON flight_list.person_id=person.id
Line 606:		Line 606:
	LEFT JOIN account ON account.id=account_entry.account_id		LEFT JOIN account ON account.id=account_entry.account_id
	WHERE $startDate <= flight.start_date AND flight.start_date <= $endDate		WHERE $startDate <= flight.start_date AND flight.start_date <= $endDate
	AND (IF((($occupiedSeat=0)OR($occupiedSeat='')), 0, -1) = flight_pilot.num		AND (IF((($occupiedSeat=0)OR($occupiedSeat=-1)), 0, -1) = flight_pilot.num
	OR IF((($occupiedSeat=1)OR($occupiedSeat='')), 1, -1) = flight_pilot.num)		OR IF((($occupiedSeat=1)OR($occupiedSeat=-1)), 1, -1) = flight_pilot.num)
	AND ( profile.id IN ($profileId) OR '-' IN ($profileId) ) AND (account.category = 11 OR account.category = 2)		AND ( profile.id IN ($profileId) OR '-' IN ($profileId) ) AND (account.category = 11 OR account.category = 2)
	GROUP BY flight.id) AS flight_list ON flight_list.person_id=person.id		GROUP BY flight.id) AS flight_list ON flight_list.person_id=person.id
Line 625:		Line 625:
	LEFT JOIN account ON account.id=account_entry.account_id		LEFT JOIN account ON account.id=account_entry.account_id
	WHERE $startDate <= flight.start_date AND flight.start_date <= $endDate		WHERE $startDate <= flight.start_date AND flight.start_date <= $endDate
	AND (IF((($occupiedSeat=0)OR($occupiedSeat='')), 0, -1) = flight_pilot.num		AND (IF((($occupiedSeat=0)OR($occupiedSeat=-1)), 0, -1) = flight_pilot.num
	OR IF((($occupiedSeat=1)OR($occupiedSeat='')), 1, -1) = flight_pilot.num)		OR IF((($occupiedSeat=1)OR($occupiedSeat=-1)), 1, -1) = flight_pilot.num)
	AND ( profile.id IN ($profileId) OR '-' IN ($profileId) ) AND (account.category = 11 OR account.category = 2)		AND ( profile.id IN ($profileId) OR '-' IN ($profileId) ) AND (account.category = 11 OR account.category = 2)
	GROUP BY flight.id) AS flight_list ON flight_list.person_id=person.id		GROUP BY flight.id) AS flight_list ON flight_list.person_id=person.id