1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| use radioflow;
SELECT E.matricule,min(dateLecture),max(datelecture),prenom,nom,
case sortie_idzone
when 1 then 'EXTERIEUR '
when 2 then 'PAUSE'
when 3 then 'RECEPTION'
when 4 then 'TOUR'
when 5 then 'ATELIER'
when 6 then 'HDD'
when 7 then 'EXPORT'
when 8 then 'PVE'
when 9 then 'VIC'
when 10 then 'COM' END,
case entree_idzone
when 1 then 'EXTERIEUR '
when 2 then 'PAUSE'
when 3 then 'RECEPTION'
when 4 then 'TOUR'
when 5 then 'ATELIER'
when 6 then 'HDD'
when 7 then 'EXPORT'
when 8 then 'PVE'
when 9 then 'VIC'
when 10 then 'COM' END
from Transaction T inner join zone Z
inner join employe E ON T.Id_employe=E.idemploye
where dateLecture >date_add(NOW() , INTERVAL -1 day ) and matricule in(select matricule from chef_Atelier)
group by matricule |
Partager