[FogBugz #56] Soldes : Prendre événement regroupant plutôt que unitaire pour les soldes #118

Open
opened 2023-07-03 23:11:02 +02:00 by fbenoist68 · 11 comments

Assigned To: CLOSED
Project: Mobile Retail
Area: Divers
Category: Bogue
Priority: A faire le plus tôt possible

Assigned To: CLOSED Project: Mobile Retail Area: Divers Category: Bogue Priority: A faire le plus tôt possible
Poster
Owner

Event ID: 199
Date: 2013-01-28T10:40:53Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist

Event ID: 199 Date: 2013-01-28T10:40:53Z Person: Frederik Benoist Description: Fermé par Frederik Benoist
Poster
Owner

Event ID: 198
Date: 2013-01-28T10:40:52Z
Person: Frederik Benoist
Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist

Event ID: 198 Date: 2013-01-28T10:40:52Z Person: Frederik Benoist Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist
Poster
Owner

Event ID: 197
Date: 2013-01-28T10:40:41Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Event ID: 197 Date: 2013-01-28T10:40:41Z Person: Frederik Benoist Description: Modifié par Frederik Benoist
Poster
Owner

Event ID: 196
Date: 2013-01-28T10:40:24Z
Person: Frederik Benoist
Description: Réouvert (attribué à Frederik Benoist) par Frederik Benoist

Event ID: 196 Date: 2013-01-28T10:40:24Z Person: Frederik Benoist Description: Réouvert (attribué à Frederik Benoist) par Frederik Benoist
Poster
Owner

Event ID: 195
Date: 2013-01-28T10:33:43Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist

Event ID: 195 Date: 2013-01-28T10:33:43Z Person: Frederik Benoist Description: Fermé par Frederik Benoist
Poster
Owner

Event ID: 194
Date: 2013-01-28T10:33:43Z
Person: Frederik Benoist
Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist

Event ID: 194 Date: 2013-01-28T10:33:43Z Person: Frederik Benoist Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist
Poster
Owner

Event ID: 193
Date: 2013-01-28T10:32:54Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Event ID: 193 Date: 2013-01-28T10:32:54Z Person: Frederik Benoist Description: Modifié par Frederik Benoist
Poster
Owner

Event ID: 192
Date: 2013-01-28T10:32:38Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Changer SELECT lte2.id_type_evenement_regroupant par

SELECT lte2.id_type_evenement

Event ID: 192 Date: 2013-01-28T10:32:38Z Person: Frederik Benoist Description: Modifié par Frederik Benoist Changer SELECT lte2.id_type_evenement_regroupant par <br /> SELECT lte2.id_type_evenement
Poster
Owner

Event ID: 191
Date: 2013-01-28T10:31:40Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

FROM structure_evenements se

JOIN liste_type_evenement lte

  ON    lte.id_type_evenement =

                se.id_type_evenement

AND NOT lte.id_type_evenement IN

 (SELECT lte2.id_type_evenement_regroupant

        FROM liste_type_evenement lte2

        WHERE lte2.id_type_evenement_regroupant

IS NOT NULL)

Event ID: 191 Date: 2013-01-28T10:31:40Z Person: Frederik Benoist Description: Modifié par Frederik Benoist FROM structure_evenements se<br /> JOIN liste_type_evenement lte<br /> &nbsp; ON&nbsp; &nbsp; lte.id_type_evenement =<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; se.id_type_evenement<br /> AND NOT lte.id_type_evenement IN<br /> &nbsp;(SELECT lte2.id_type_evenement_regroupant<br /> &nbsp; &nbsp; &nbsp; &nbsp; FROM liste_type_evenement lte2<br /> &nbsp; &nbsp; &nbsp; &nbsp; WHERE lte2.id_type_evenement_regroupant<br /> IS NOT NULL)
Poster
Owner

Event ID: 190
Date: 2013-01-28T10:18:47Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 190 Date: 2013-01-28T10:18:47Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
Poster
Owner

Event ID: 189
Date: 2013-01-28T10:18:47Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Event ID: 189 Date: 2013-01-28T10:18:47Z Person: Frederik Benoist Description: Ouvert par Frederik Benoist
Sign in to join this conversation.
No Label
No Milestone
No project
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#118
There is no content yet.