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
| INSERT INTO cumulmhe (salarie, dateoper, libeloper, operation,
qtejou, montjou, heurejou, qteheu, montheu, heureheu, qtekm, montkm, qterepas, montrepas, qteaut1, montaut1, heureaut1,
qteaut2, montaut2, heureaut2, qteaut3, montaut3, heureaut3, libre1, libre2, top1)
SELECT salarie, dateoper, libeloper, codeoper,
-- les jou
(SELECT SUM(taux) FROM lignemhe WHERE rubrique = 1010 and taux <> null GROUP BY salarie, codeoper, dateoper),
(SELECT SUM(montant) FROM lignemhe WHERE rubrique = 1010 and montant <> null GROUP BY salarie, codeoper, dateoper),
(SELECT SUM(base) FROM lignemhe WHERE rubrique = 1010 and base <> null GROUP BY salarie, codeoper, dateoper),
-- les heu
(SELECT SUM(taux) FROM lignemhe WHERE rubrique = 9655 and taux <> null GROUP BY salarie, codeoper, dateoper),
(SELECT SUM(montant) FROM lignemhe WHERE rubrique = 9655 and montant <> null GROUP BY salarie, codeoper, dateoper),
(SELECT SUM(base) FROM lignemhe WHERE rubrique = 9655 and base <> null GROUP BY salarie, codeoper, dateoper),
-- les km
(SELECT SUM(base) FROM lignemhe WHERE rubrique = 8100 and base <> null GROUP BY salarie, codeoper, dateoper),
(SELECT SUM(montant) FROM lignemhe WHERE rubrique = 8100 and montant <> null GROUP BY salarie, codeoper, dateoper),
-- les repas
(SELECT SUM(base) FROM lignemhe WHERE rubrique = 8110 and base <> null GROUP BY salarie, codeoper, dateoper),
(SELECT SUM(montant) FROM lignemhe WHERE rubrique = 8110 and montant <> null GROUP BY salarie, codeoper, dateoper),
-- les aut1
(SELECT SUM(taux) FROM lignemhe WHERE rubrique not in (1010, 9655, 8100, 8110) and taux <> null GROUP BY salarie, codeoper, dateoper),
(SELECT SUM(montant) FROM lignemhe WHERE rubrique not in (1010, 9655, 8100, 8110) and montant <> null GROUP BY salarie, codeoper, dateoper),
(SELECT SUM(base) FROM lignemhe WHERE rubrique not in (1010, 9655, 8100, 8110) and base <> null GROUP BY salarie, codeoper, dateoper),0,0,0,0,0,0,'','',''
FROM lignemhe
GROUP BY salarie, codeoper, dateoper |
Partager