1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| SELECT s.id_salaries, CONCAT(s.prenom,' ',s.nom) as nomcomplet,
SUM(ad.nb) as nb_acquis,
SUM(IF(type='conges',1,IF(type='demijournee',0.5,0))) as nb_pris,
SUM(IF(type='conges',1,IF(type='demijournee',0.5,0))) as nb_aprendre,
FROM salaries as s
LEFT JOIN absences_droits as ad
ON ad.id_salarie=s.id_salaries
LEFT JOIN absences as a
ON a.id_salarie=s.id_salaries
LEFT JOIN absences as a2
ON a2.id_salarie=s.id_salaries
WHERE ad.annee='$annee'
AND a.type IN ('conges','demijournee') AND a.annee='$annee' AND a.jour <= CURDATE()
AND a2.type IN ('conges','demijournee') AND a2.annee='$annee' AND a2.jour > CURDATE()
GROUP BY s.id_salarie
ORDER BY nomcomplet |
Partager