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 29 30 31 32 33 34 35 36 37 38 39 40 41 42
| SELECT DISTINCT
COUNT(SAIJOUR.DATE) AS Comptage_1,
GROUPE.IDDOMAINE AS IDDOMAINE,
Lignesaijour.IDOUVRIER AS IDOUVRIER,
Lignesaijour.nom AS nom,
Lignesaijour.prenom AS prenom,
OUVRIER.FonCtions AS FonCtions,
SUM(Lignesaijour.BRUT) AS la_somme_BRUT,
SUM(Lignesaijour.Njrs) AS la_somme_Njrs,
SUM(Lignesaijour.CNSS) AS la_somme_CNSS,
SUM(Lignesaijour.AMO) AS la_somme_AMO,
SUM(GROUPE.REGULARAISATION*Lignesaijour.Njrs) AS PRIMERPANIER,
SUM(Lignesaijour.SALAIRE) AS la_somme_SALAIRE,
OUVRIER.SALAIREB AS SALAIREB
FROM
DOMAINE,
GROUPE,
SAIJOUR,
Lignesaijour,
OUVRIER
WHERE
GROUPE.IDDOMAINE = DOMAINE.IDDOMAINE
AND SAIJOUR.IDDOMAINE = DOMAINE.IDDOMAINE
AND Lignesaijour.IDSAIJOUR = SAIJOUR.IDSAIJOUR
AND Lignesaijour.IDOUVRIER = OUVRIER.IDOUVRIER
AND
(
SAIJOUR.DATE BETWEEN {date1} AND {date2}
)
GROUP BY
Lignesaijour.IDOUVRIER,
Lignesaijour.nom,
Lignesaijour.prenom,
OUVRIER.FonCtions,
GROUPE.IDDOMAINE,
OUVRIER.SALAIREB
ORDER BY
Comptage_1 ASC,
nom ASC,
FonCtions ASC |
Partager