HExécuteRequête(REQ_arret_1)
HExécuteRequête(REQ_arret2)
HExécuteRequête(REQ_arret3)
HExécuteRequête(REQ_arret_union)
HExécuteRequête(REQ_arret_fin)
HFiltre(REQ_arret_fin,SAI_Saisie1)
TableAffiche(TABLE_REQ_arret_fin)
SELECT
traitement.des_mach AS des_mach,
arreter_trai.jour_prob AS jour_prob,
SUM( WL.HeureDifférence(arreter_trai.début_prob_heure,arreter_trai.fin_prob_heure)/6000) AS Formule1
FROM
traitement,
arreter_trai
WHERE
arreter_trai.id_trait = traitement.id_trait
AND
(
arreter_trai.début_prob_jour = arreter_trai.jour_prob
AND arreter_trai.fin_prob_jour = arreter_trai.jour_prob
)
GROUP BY
traitement.des_mach,
arreter_trai.jour_prob
SELECT
traitement.des_mach AS des_mach,
arreter_trai.jour_prob AS jour_prob,
SUM((8640000- WL.HeureVersEntier(arreter_trai.début_prob_heure)) / 6000) AS Formule1
FROM
traitement,
arreter_trai
WHERE
arreter_trai.id_trait = traitement.id_trait
AND
(
arreter_trai.début_prob_jour = arreter_trai.jour_prob
AND arreter_trai.fin_prob_jour <> arreter_trai.jour_prob
)
GROUP BY
traitement.des_mach,
arreter_trai.jour_prob
SELECT
traitement.des_mach AS des_mach,
arreter_trai.jour_prob AS jour_prob,
SUM((WL.HeureVersEntier(arreter_trai.fin_prob_heure) -0) /6000) AS Formule1
FROM
traitement,
arreter_trai
WHERE
arreter_trai.id_trait = traitement.id_trait
AND
(
arreter_trai.début_prob_jour <> arreter_trai.jour_prob
AND arreter_trai.fin_prob_jour = arreter_trai.jour_prob
)
GROUP BY
traitement.des_mach,
arreter_trai.jour_prob
SELECT
traitement.des_mach AS des_mach,
arreter_trai.jour_prob AS jour_prob,
SUM( WL.HeureDifférence(arreter_trai.début_prob_heure,arreter_trai.fin_prob_heure)/6000) AS Formule1
FROM
traitement,
arreter_trai
WHERE
arreter_trai.id_trait = traitement.id_trait
AND
(
arreter_trai.début_prob_jour = arreter_trai.jour_prob
AND arreter_trai.fin_prob_jour = arreter_trai.jour_prob
)
GROUP BY
traitement.des_mach,
arreter_trai.jour_prob
UNION ALL
SELECT
traitement.des_mach AS des_mach,
arreter_trai.jour_prob AS jour_prob,
SUM((8640000- WL.HeureVersEntier(arreter_trai.début_prob_heure)) / 6000) AS Formule1
FROM
traitement,
arreter_trai
WHERE
arreter_trai.id_trait = traitement.id_trait
AND
(
arreter_trai.début_prob_jour = arreter_trai.jour_prob
AND arreter_trai.fin_prob_jour <> arreter_trai.jour_prob
)
GROUP BY
traitement.des_mach,
arreter_trai.jour_prob
UNION ALL
SELECT
traitement.des_mach AS des_mach,
arreter_trai.jour_prob AS jour_prob,
SUM((WL.HeureVersEntier(arreter_trai.fin_prob_heure) -0) /6000) AS Formule1
FROM
traitement,
arreter_trai
WHERE
arreter_trai.id_trait = traitement.id_trait
AND
(
arreter_trai.début_prob_jour <> arreter_trai.jour_prob
AND arreter_trai.fin_prob_jour = arreter_trai.jour_prob
)
GROUP BY
traitement.des_mach,
arreter_trai.jour_prob
SELECT
REQ_arret_union.jour_prob AS jour_prob,
REQ_arret_union.des_mach AS des_mach,
SUM(REQ_arret_union.Formule1) AS la_somme_Formule1
FROM
REQ_arret_union
GROUP BY
REQ_arret_union.jour_prob,
REQ_arret_union.des_mach
Cette contribution était de : http://old.wdforge.org/newbb/viewtopic.php?forum=20&topic_id=6570&post_id=25814