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

[FogBugz #181] Changement date d'ouverture #243

New Issue
Open
opened 2023-07-03 23:50:22 +02:00 by fbenoist68 · 4 comments
fbenoist68 commented 2023-07-03 23:50:22 +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-03 23:50:24 +02:00
Poster
Owner

Event ID: 824
Date: 2013-10-11T14:15:22Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Event ID: 824 Date: 2013-10-11T14:15:22Z Person: Frederik Benoist Description: Modifié par Frederik Benoist
fbenoist68 commented 2023-07-03 23:50:26 +02:00
Poster
Owner

Event ID: 823
Date: 2013-10-11T14:13:41Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Trigger sur structure

BEGIN
    oai.
     log_trace_error (
        TRUE,
        'Nouveau = ' || CASE WHEN :new.date_ouverture IS NOT NULL THEN TO_CHAR (:new.date_ouverture, 'DD/MM/RRRR') ELSE '' END,
        NULL,
        'Ancien = ' || CASE WHEN :old.date_ouverture IS NOT NULL THEN TO_CHAR (:old.date_ouverture, 'DD/MM/RRRR') ELSE '' END,
        'Date ouverture STRUCTURE',
        'I',
        0,
        :new.id_structure);
END;
Event ID: 823 Date: 2013-10-11T14:13:41Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> Trigger sur structure</p> <div> BEGIN</div> <div> &nbsp; &nbsp; oai.</div> <div> &nbsp; &nbsp; &nbsp;log_trace_error (</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; TRUE,</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &#39;Nouveau = &#39; || CASE WHEN :new.date_ouverture IS NOT NULL THEN TO_CHAR (:new.date_ouverture, &#39;DD/MM/RRRR&#39;) ELSE &#39;&#39; END,</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; NULL,</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &#39;Ancien = &#39; || CASE WHEN :old.date_ouverture IS NOT NULL THEN TO_CHAR (:old.date_ouverture, &#39;DD/MM/RRRR&#39;) ELSE &#39;&#39; END,</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &#39;Date ouverture STRUCTURE&#39;,</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &#39;I&#39;,</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; 0,</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; :new.id_structure);</div> <div> END;</div>
fbenoist68 commented 2023-07-03 23:50:29 +02:00
Poster
Owner

Event ID: 822
Date: 2013-10-11T14:13:23Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 822 Date: 2013-10-11T14:13:23Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
fbenoist68 commented 2023-07-03 23:50:30 +02:00
Poster
Owner

Event ID: 821
Date: 2013-10-11T14:13:23Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Event ID: 821 Date: 2013-10-11T14:13:23Z 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#243
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?