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

[FogBugz #661] Planning erreur numéro de semaine #724

New Issue
Open
opened 2023-07-04 09:51:29 +02:00 by fbenoist68 · 8 comments
fbenoist68 commented 2023-07-04 09:51:29 +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:51:34 +02:00
Poster
Owner

Event ID: 3341
Date: 2018-02-23T08:22:50Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist

Event ID: 3341 Date: 2018-02-23T08:22:50Z Person: Frederik Benoist Description: Fermé par Frederik Benoist
fbenoist68 commented 2023-07-04 09:51:37 +02:00
Poster
Owner

Event ID: 3340
Date: 2018-02-23T08:22:49Z
Person: Frederik Benoist
Description: Résolu (Corrigé) and assigned to Frederik Benoist by Frederik Benoist

Event ID: 3340 Date: 2018-02-23T08:22:49Z Person: Frederik Benoist Description: Résolu (Corrigé) and assigned to Frederik Benoist by Frederik Benoist
fbenoist68 commented 2023-07-04 09:51:40 +02:00
Poster
Owner

Event ID: 3328
Date: 2018-01-27T09:35:59Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Event ID: 3328 Date: 2018-01-27T09:35:59Z Person: Frederik Benoist Description: Modifié par Frederik Benoist
fbenoist68 commented 2023-07-04 09:51:42 +02:00
Poster
Owner

Event ID: 3327
Date: 2018-01-27T09:35:45Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

BUG quand visites ou événement multi-jours du au fonctionnement de fullcalendar (fin à J+1)
==> Ajout d'un test.

Event ID: 3327 Date: 2018-01-27T09:35:45Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p>BUG quand visites ou &eacute;v&eacute;nement multi-jours du au fonctionnement de fullcalendar (fin &agrave; J+1)<br /> ==&gt; Ajout d&#39;un test.</p> <p><img src="https://gitea.q2ii.fr/attachments/54d7b66f-7ff3-404e-a068-0bd829f653ae"/></p>
image.png
9.2 KiB
fbenoist68 commented 2023-07-04 09:51:54 +02:00
Poster
Owner

Event ID: 3326
Date: 2018-01-26T06:18:33Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Création d'une nouvelle fonction (iso_week_to_date) pour le calcul des dates de début et fin de semaine

Event ID: 3326 Date: 2018-01-26T06:18:33Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p>Cr&eacute;ation d&#39;une nouvelle fonction (iso_week_to_date) pour le calcul des dates de d&eacute;but et fin de semaine</p> <p><img src="https://gitea.q2ii.fr/attachments/fd71ffb0-7a87-4be5-b54c-71d77704a24b"/></p>
image.png
18 KiB
fbenoist68 commented 2023-07-04 09:52:07 +02:00
Poster
Owner

Event ID: 3325
Date: 2018-01-26T06:15:04Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Oui effectivement pour cette année le calcul est faux

SELECT DISTINCT
       MIN (NEXT_DAY (TRUNC (d, 'DD'), 1))     AS lundi,
       MIN (NEXT_DAY (TRUNC (d, 'DD'), 1)) + 6 AS dimanche
  FROM (    SELECT   TO_DATE ('01-01' || TO_CHAR (SYSDATE, 'yyyy'), 'dd-mm-yyyy')
                   + (ROWNUM - 1)
                       d
              FROM DUAL
        CONNECT BY LEVEL <= 366),
       nls_session_parameters t
 WHERE     t.parameter = 'NLS_TERRITORY'
       AND CASE
               WHEN t.VALUE = 'AMERICA' THEN TO_CHAR (d + 1, 'ww')
               ELSE TO_CHAR (d, 'ww')
           END = TO_NUMBER ('1')

 

Event ID: 3325 Date: 2018-01-26T06:15:04Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p>Oui effectivement pour cette ann&eacute;e le calcul est faux</p> <p><code>SELECT DISTINCT<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MIN (NEXT_DAY (TRUNC (d, &#39;DD&#39;), 1))&nbsp;&nbsp;&nbsp;&nbsp; AS lundi,<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MIN (NEXT_DAY (TRUNC (d, &#39;DD&#39;), 1)) + 6 AS dimanche<br /> &nbsp; FROM (&nbsp;&nbsp;&nbsp; SELECT&nbsp;&nbsp; TO_DATE (&#39;01-01&#39; || TO_CHAR (SYSDATE, &#39;yyyy&#39;), &#39;dd-mm-yyyy&#39;)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + (ROWNUM - 1)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM DUAL<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CONNECT BY LEVEL &lt;= 366),<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nls_session_parameters t<br /> &nbsp;WHERE&nbsp;&nbsp;&nbsp;&nbsp; t.parameter = &#39;NLS_TERRITORY&#39;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND CASE<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHEN t.VALUE = &#39;AMERICA&#39; THEN TO_CHAR (d + 1, &#39;ww&#39;)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ELSE TO_CHAR (d, &#39;ww&#39;)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END = TO_NUMBER (&#39;1&#39;)</code></p> <p><img src="https://gitea.q2ii.fr/attachments/0905b3f5-7086-4ebf-9649-f8f7e928ded9"/></p> <p>&nbsp;</p>
image.png
15 KiB
fbenoist68 commented 2023-07-04 09:52:20 +02:00
Poster
Owner

Event ID: 3324
Date: 2018-01-26T06:13:21Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 3324 Date: 2018-01-26T06:13:21Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
fbenoist68 commented 2023-07-04 09:52:23 +02:00
Poster
Owner

Event ID: 3323
Date: 2018-01-26T06:13:20Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Je me permets de vous contacter puisquil semble y avoir un dysfonctionnement quant au planning global sur Mobil Portal : La semaine « S1 » correspond aux dates du 08/01/2018 au 14/01/2018.

Event ID: 3323 Date: 2018-01-26T06:13:20Z Person: Frederik Benoist Description: Ouvert par Frederik Benoist Je me permets de vous contacter puisquil semble y avoir un dysfonctionnement quant au planning global sur Mobil Portal : La semaine &#171; S1 &#187; correspond aux dates du 08/01/2018 au 14/01/2018. <br />
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#724
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?