fbenoist68
/
mobileportal
1
0
Fork 0
Code Issues 739 Pull Requests Packages Projects Releases Wiki Activity

[FogBugz #639] Ajouter récaputaltif délais d'envoi CR #702

New Issue
Open
opened 2023-07-04 09:40:32 +02:00 by fbenoist68 · 4 comments
fbenoist68 commented 2023-07-04 09:40:32 +02:00
Owner

Assigned To: Frederik Benoist
Project: Mobile Portal
Area: Divers
Category: Fonctionnalité
Priority: A faire le plus tôt possible

Assigned To: Frederik Benoist Project: Mobile Portal Area: Divers Category: Fonctionnalité Priority: A faire le plus tôt possible
fbenoist68 commented 2023-07-04 09:40:35 +02:00
Poster
Owner

Event ID: 3215
Date: 2017-10-06T05:32:41Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Event ID: 3215 Date: 2017-10-06T05:32:41Z Person: Frederik Benoist Description: Modifié par Frederik Benoist
fbenoist68 commented 2023-07-04 09:40:38 +02:00
Poster
Owner

Event ID: 3214
Date: 2017-10-06T05:24:52Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

  SELECT mvis.id_utilisateur,
         mru.nom,
         mru.prenom,
         mru_resp.nom || ' ' || mru_resp.prenom AS responsable,
         COUNT (*)                            AS nbre_visites,
         GREATEST (
             0,
             MIN (
                   TRUNC (mvis.date_validation)
                 - TRUNC (NVL (mvis.date_visite_fin, mvis.date_visite))))
             AS delai_envoi_min,
         MAX (
               TRUNC (mvis.date_validation)
             - TRUNC (NVL (mvis.date_visite_fin, mvis.date_visite)))
             AS delai_envoi_max,
         ROUND (
             AVG (
                   TRUNC (mvis.date_validation)
                 - TRUNC (NVL (mvis.date_visite_fin, mvis.date_visite))),
             0)
             AS delai_envoi_moyen
    FROM mr_visite mvis
         LEFT OUTER JOIN mr_visite_type mvt
             ON mvt.id_visite_type = mvis.id_visite_type
         JOIN mr_utilisateur mru
             ON     mru.id_utilisateur = mvis.id_utilisateur
                AND mru.statut_compte = 1
         LEFT OUTER JOIN mp_visite_droits mvd
             ON mvd.id_regional = mvis.id_utilisateur AND responsable = 1
         LEFT OUTER JOIN mr_utilisateur mru_resp
             ON mru_resp.id_utilisateur = mvd.id_utilisateur
   WHERE     TRUNC (NVL (mvis.date_visite_fin, mvis.date_visite)) BETWEEN   SYSDATE
                                                                          - 60
                                                                      AND SYSDATE
         AND mvis.date_validation IS NOT NULL
         AND NVL (mvt.visite_hors_stat, 0) = 0
         AND mvis.abandon IS NULL
GROUP BY mvis.id_utilisateur,
         mru.nom,
         mru.prenom,
         mru_resp.nom || ' ' || mru_resp.prenom
ORDER BY 4, 8;

Event ID: 3214 Date: 2017-10-06T05:24:52Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p>&nbsp; SELECT mvis.id_utilisateur,<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mru.nom,<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mru.prenom,<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mru_resp.nom || &#39; &#39; || mru_resp.prenom AS responsable,<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; COUNT (*)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AS nbre_visites,<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GREATEST (<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MIN (<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TRUNC (mvis.date_validation)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - TRUNC (NVL (mvis.date_visite_fin, mvis.date_visite))))<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AS delai_envoi_min,<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MAX (<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TRUNC (mvis.date_validation)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - TRUNC (NVL (mvis.date_visite_fin, mvis.date_visite)))<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AS delai_envoi_max,<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ROUND (<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AVG (<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TRUNC (mvis.date_validation)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - TRUNC (NVL (mvis.date_visite_fin, mvis.date_visite))),<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AS delai_envoi_moyen<br /> &nbsp;&nbsp;&nbsp; FROM mr_visite mvis<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LEFT OUTER JOIN mr_visite_type mvt<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ON mvt.id_visite_type = mvis.id_visite_type<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JOIN mr_utilisateur mru<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ON&nbsp;&nbsp;&nbsp;&nbsp; mru.id_utilisateur = mvis.id_utilisateur<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND mru.statut_compte = 1<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LEFT OUTER JOIN mp_visite_droits mvd<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ON mvd.id_regional = mvis.id_utilisateur AND responsable = 1<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LEFT OUTER JOIN mr_utilisateur mru_resp<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ON mru_resp.id_utilisateur = mvd.id_utilisateur<br /> &nbsp;&nbsp; WHERE&nbsp;&nbsp;&nbsp;&nbsp; TRUNC (NVL (mvis.date_visite_fin, mvis.date_visite)) BETWEEN&nbsp;&nbsp; SYSDATE<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - 60<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND SYSDATE<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND mvis.date_validation IS NOT NULL<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND NVL (mvt.visite_hors_stat, 0) = 0<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND mvis.abandon IS NULL<br /> GROUP BY mvis.id_utilisateur,<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mru.nom,<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mru.prenom,<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mru_resp.nom || &#39; &#39; || mru_resp.prenom<br /> ORDER BY 4, 8;</p>
fbenoist68 commented 2023-07-04 09:40:43 +02:00
Poster
Owner

Event ID: 3213
Date: 2017-10-06T05:24:23Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 3213 Date: 2017-10-06T05:24:23Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
fbenoist68 commented 2023-07-04 09:40:46 +02:00
Poster
Owner

Event ID: 3212
Date: 2017-10-06T05:24:22Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Event ID: 3212 Date: 2017-10-06T05:24:22Z Person: Frederik Benoist Description: Ouvert par Frederik Benoist
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
main
Labels
Clear labels
No items
No Label
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: fbenoist68/mobileportal#702
There is no content yet.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may exist for a short time before cleaning up, in most cases it CANNOT be undone. Continue?