Re: Table flight
Date: mercredi 27 mars 2013 14:03:36
Bonjour,
Effectivement j'ai 'fouillé' les requêtes et je n'ai rien trouvé sur les champs : 'counter_departure' et 'counter_arrival' de la table 'flight'
Mais j'ai trouvé la solution : (qui reste à paufiner ...)
SELECT
name AS Callsign,
DATE_FORMAT(flight.start_date,'%d/%m/%Y' ) AS Date,
CONCAT(FLOOR( flight.duration /600),':',TIME_FORMAT(SEC_TO_TIME((flight.duration /600 - FLOOR( flight.duration /600))*3600),'%i')) AS temps_de_vol,
CONCAT(FLOOR( counter_departure/600),':',TIME_FORMAT(SEC_TO_TIME((counter_departure /600 - FLOOR( counter_departure /600))*3600),'%i')) AS cpt_departure,
CONCAT(FLOOR( counter_arrival /600),':',TIME_FORMAT(SEC_TO_TIME((counter_arrival /600 - FLOOR( counter_arrival /600))*3600),'%i')) AS cpt_arrival,
CONCAT(FLOOR((counter_arrival-counter_departure)/600),':',TIME_FORMAT(SEC_TO_TIME(((counter_arrival-counter_departure) /600 - FLOOR( (counter_arrival-counter_departure) /600))*3600),'%i')) AS time_mot
FROM flight
LEFT JOIN resource ON resource.id = flight.aircraft_id
WHERE '$startDate' <= start_date AND aircraft_id=$avion
UNION
SELECT
'' AS '',
'Total' AS '',
CONCAT(FLOOR(SUM( duration )/600),':',TIME_FORMAT(SEC_TO_TIME((SUM( duration )/600 - FLOOR(SUM( duration )/600))*3600),'%i')) AS Total,
'' AS '',
'' AS '',
CONCAT(FLOOR(SUM( (counter_arrival-counter_departure) )/600),':',TIME_FORMAT(SEC_TO_TIME((SUM( (counter_arrival-counter_departure) )/600 - FLOOR(SUM( (counter_arrival-counter_departure))/600))*3600),'%i')) AS Tot
FROM flight
WHERE '$startDate' <= start_date AND aircraft_id=$avion
Encore merci pour votre aide !
Admin LFSE
www.aeroclub-vosgien.com