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

[FogBugz #582] Envoi du CR au responsable ne marche pas #645

New Issue
Open
opened 2023-07-04 09:15:19 +02:00 by fbenoist68 · 6 comments
fbenoist68 commented 2023-07-04 09:15:19 +02:00
Owner

Assigned To: CLOSED
Project: Mobile Portal
Area: Divers
Category: Bogue
Priority: A fixer impérativement

Assigned To: CLOSED Project: Mobile Portal Area: Divers Category: Bogue Priority: A fixer impérativement
fbenoist68 commented 2023-07-04 09:15:21 +02:00
Poster
Owner

Event ID: 2865
Date: 2016-12-08T23:08:42Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist

Event ID: 2865 Date: 2016-12-08T23:08:42Z Person: Frederik Benoist Description: Fermé par Frederik Benoist
fbenoist68 commented 2023-07-04 09:15:25 +02:00
Poster
Owner

Event ID: 2864
Date: 2016-12-08T23:08:42Z
Person: Frederik Benoist
Description: Résolu (Corrigé) and assigned to Frederik Benoist by Frederik Benoist

OK

Event ID: 2864 Date: 2016-12-08T23:08:42Z Person: Frederik Benoist Description: R&#233;solu (Corrig&#233;) and assigned to Frederik Benoist by Frederik Benoist <p>OK</p>
fbenoist68 commented 2023-07-04 09:15:29 +02:00
Poster
Owner

Event ID: 2863
Date: 2016-12-08T22:43:46Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

-- si envoi mail au responsable DR
      IF NVL (v_envoi_cr_resp, 0) = 1
      THEN
         -- récupération identifiants mail du responsable
         BEGIN
            SELECT NVL (mru.mail_intranet, mru.mail_extranet)
              INTO v_mail_responsable
              FROM mp_visite_droits mvd
                   JOIN mr_visite mvis ON mvis.id_visite = pid_visite
                   JOIN mp_etab metab ON metab.id_etab = mvis.id_etab
                   JOIN mr_utilisateur mru
                      ON mru.id_utilisateur = mvd.id_utilisateur
             WHERE     mvd.id_regional = metab.id_regional
                   AND mvd.responsable = 1;
         EXCEPTION
            WHEN NO_DATA_FOUND
            THEN
               v_mail_responsable := NULL;
         END;

         IF v_mail_responsable IS NOT NULL
         THEN
            UTL_SMTP.rcpt (v_connection_handle, v_mail_responsable);
         END IF;
      END IF;

Event ID: 2863 Date: 2016-12-08T22:43:46Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p><code>-- si envoi mail au responsable DR<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF NVL (v_envoi_cr_resp, 0) = 1<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; THEN<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- r&eacute;cup&eacute;ration identifiants mail du responsable<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BEGIN<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT NVL (mru.mail_intranet, mru.mail_extranet)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INTO v_mail_responsable<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM mp_visite_droits mvd<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JOIN mr_visite mvis ON mvis.id_visite = pid_visite<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JOIN mp_etab metab ON metab.id_etab = mvis.id_etab<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ON mru.id_utilisateur = mvd.id_utilisateur<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp;&nbsp;&nbsp;&nbsp; mvd.id_regional = metab.id_regional<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND mvd.responsable = 1;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXCEPTION<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHEN NO_DATA_FOUND<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; THEN<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; v_mail_responsable := NULL;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END;</code></p> <p><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF v_mail_responsable IS NOT NULL<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; THEN<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UTL_SMTP.rcpt (v_connection_handle, v_mail_responsable);<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END IF;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END IF;</code></p>
fbenoist68 commented 2023-07-04 09:15:32 +02:00
Poster
Owner

Event ID: 2862
Date: 2016-12-08T21:02:44Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

En fait rien n'est envoyé au responsable ...

Event ID: 2862 Date: 2016-12-08T21:02:44Z Person: Frederik Benoist Description: Modifié par Frederik Benoist En fait rien n&#39;est envoy&#233; au responsable ...
screenshot.png
9.5 KiB
screenshot.png
fbenoist68 commented 2023-07-04 09:15:41 +02:00
Poster
Owner

Event ID: 2861
Date: 2016-12-08T21:01:25Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 2861 Date: 2016-12-08T21:01:25Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
fbenoist68 commented 2023-07-04 09:15:45 +02:00
Poster
Owner

Event ID: 2860
Date: 2016-12-08T21:01:24Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Event ID: 2860 Date: 2016-12-08T21:01:24Z 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#645
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?