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