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

[FogBugz #48] Ajout du N° ticket d'origine sur ticket (6449) #111

New Issue
Open
opened 2023-07-03 23:08:23 +02:00 by fbenoist68 · 12 comments
fbenoist68 commented 2023-07-03 23:08:23 +02:00
Owner

Assigned To: CLOSED
Project: CAISSE
Area: awcaisse
Category: Bogue
Priority: A fixer impérativement

Assigned To: CLOSED Project: CAISSE Area: awcaisse Category: Bogue Priority: A fixer impérativement
fbenoist68 commented 2023-07-03 23:08:25 +02:00
Poster
Owner

Event ID: 268
Date: 2013-01-30T11:21:05Z
Person: Saber Bhar
Description: Modifié par Saber Bhar

Pour mettre à jour structure_caisse



/* Formatted on 29/01/2013 18:58:06 (QP5 v5.191) */

DECLARE

BEGIN

    FOR cur

        IN (SELECT id_structure,

                  id_caisse,

                  REPLACE (

                      xsl_ticket_impression,

                      '<xsl:apply-templates select="messageTitre" />' || CHR (13) || CHR (10) || '      <saut />',

                          '<xsl:apply-templates select="messageTitre" />'

                      || CHR (13)

                      || CHR (10)

                      || '      <saut />'

                      || CHR (13)

                      || CHR (10)

                      || '      <xsl:for-each select="(lignes/ligne[@ticket_retour_original!=''''])[1]">'

                      || CHR (13)

                      || CHR (10)

                      || '        <texte texte="Ticket original:{@ticket_retour_original}" style="c" />'

                      || CHR (13)

                      || CHR (10)

                      || '      </xsl:for-each>'

                      || CHR (13)

                      || CHR (10)

                      || '      <saut />')

                      AS xsl

              FROM structure_caisse

            WHERE id_structure = 1520 AND id_caisse = 1

            and not xsl_ticket_impression like '%(lignes/ligne[@ticket_retour_original!=''])[1]%')

    LOOP

        UPDATE structure_caisse

          SET xsl_ticket_impression = cur.xsl

        WHERE id_structure = cur.id_structure AND id_caisse = cur.id_caisse;

    END LOOP;

END;


Event ID: 268 Date: 2013-01-30T11:21:05Z Person: Saber Bhar Description: Modifié par Saber Bhar Pour mettre &#224; jour structure_caisse<br /> <br /> /* Formatted on 29/01/2013 18:58:06 (QP5 v5.191) */<br /> DECLARE<br /> BEGIN<br /> &nbsp; &nbsp; FOR cur<br /> &nbsp; &nbsp; &nbsp; &nbsp; IN (SELECT id_structure,<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; id_caisse,<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; REPLACE (<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xsl_ticket_impression,<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &#39;&lt;xsl:apply-templates select=&quot;messageTitre&quot; /&gt;&#39; || CHR (13) || CHR (10) || &#39;&nbsp; &nbsp; &nbsp; &lt;saut /&gt;&#39;,<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &#39;&lt;xsl:apply-templates select=&quot;messageTitre&quot; /&gt;&#39;<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || CHR (13)<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || CHR (10)<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || &#39;&nbsp; &nbsp; &nbsp; &lt;saut /&gt;&#39;<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || CHR (13)<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || CHR (10)<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || &#39;&nbsp; &nbsp; &nbsp; &lt;xsl:for-each select=&quot;(lignes/ligne[@ticket_retour_original!=&#39;&#39;&#39;&#39;])[1]&quot;&gt;&#39;<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || CHR (13)<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || CHR (10)<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || &#39;&nbsp; &nbsp; &nbsp; &nbsp; &lt;texte texte=&quot;Ticket original:{@ticket_retour_original}&quot; style=&quot;c&quot; /&gt;&#39;<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || CHR (13)<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || CHR (10)<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || &#39;&nbsp; &nbsp; &nbsp; &lt;/xsl:for-each&gt;&#39;<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || CHR (13)<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || CHR (10)<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || &#39;&nbsp; &nbsp; &nbsp; &lt;saut /&gt;&#39;)<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS xsl<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM structure_caisse<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE id_structure = 1520 AND id_caisse = 1<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; and not xsl_ticket_impression like &#39;%(lignes/ligne[@ticket_retour_original!=&#39;&#39;])[1]%&#39;)<br /> &nbsp; &nbsp; LOOP<br /> &nbsp; &nbsp; &nbsp; &nbsp; UPDATE structure_caisse<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SET xsl_ticket_impression = cur.xsl<br /> &nbsp; &nbsp; &nbsp; &nbsp; WHERE id_structure = cur.id_structure AND id_caisse = cur.id_caisse;<br /> &nbsp; &nbsp; END LOOP;<br /> END;<br /> <br />
fbenoist68 commented 2023-07-03 23:08:28 +02:00
Poster
Owner

Event ID: 188
Date: 2013-01-28T09:03:50Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist

Event ID: 188 Date: 2013-01-28T09:03:50Z Person: Frederik Benoist Description: Fermé par Frederik Benoist
fbenoist68 commented 2023-07-03 23:08:31 +02:00
Poster
Owner

Event ID: 187
Date: 2013-01-28T09:03:50Z
Person: Frederik Benoist
Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist

Event ID: 187 Date: 2013-01-28T09:03:50Z Person: Frederik Benoist Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist
fbenoist68 commented 2023-07-03 23:08:33 +02:00
Poster
Owner

Event ID: 186
Date: 2013-01-28T08:53:17Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Event ID: 186 Date: 2013-01-28T08:53:17Z Person: Frederik Benoist Description: Modifié par Frederik Benoist
fbenoist68 commented 2023-07-03 23:08:36 +02:00
Poster
Owner

Event ID: 185
Date: 2013-01-28T08:49:16Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Event ID: 185 Date: 2013-01-28T08:49:16Z Person: Frederik Benoist Description: Modifié par Frederik Benoist
fbenoist68 commented 2023-07-03 23:08:39 +02:00
Poster
Owner

Event ID: 179
Date: 2013-01-25T15:48:26Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Event ID: 179 Date: 2013-01-25T15:48:26Z Person: Frederik Benoist Description: Modifié par Frederik Benoist
screenshot.png
91 KiB
screenshot.png
fbenoist68 commented 2023-07-03 23:08:48 +02:00
Poster
Owner

Event ID: 178
Date: 2013-01-25T14:51:33Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Event ID: 178 Date: 2013-01-25T14:51:33Z Person: Frederik Benoist Description: Modifié par Frederik Benoist
fbenoist68 commented 2023-07-03 23:08:50 +02:00
Poster
Owner

Event ID: 177
Date: 2013-01-25T14:39:59Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

select xsl_ticket_impression from structure_caisse where id_structure=5 and id_caisse=1



Mettre la balise for-each ci-dessous après chaque balise :

<texte texte="{@id_facture_caisse}" style="c" />



<xsl:for-each select="(lignes/ligne[@ticket_retour_original!=''])[1]">

      <texte texte="Retour:{@ticket_retour_original}" style="c" />

</xsl:for-each>

Event ID: 177 Date: 2013-01-25T14:39:59Z Person: Frederik Benoist Description: Modifié par Frederik Benoist select xsl_ticket_impression from structure_caisse where id_structure=5 and id_caisse=1<br /> <br /> Mettre la balise for-each ci-dessous apr&#232;s chaque balise :<br /> &lt;texte texte=&quot;{@id_facture_caisse}&quot; style=&quot;c&quot; /&gt;<br /> <br /> &lt;xsl:for-each select=&quot;(lignes/ligne[@ticket_retour_original!=&#39;&#39;])[1]&quot;&gt;<br /> &nbsp; &nbsp; &nbsp; &lt;texte texte=&quot;Retour:{@ticket_retour_original}&quot; style=&quot;c&quot; /&gt;<br /> &lt;/xsl:for-each&gt;
fbenoist68 commented 2023-07-03 23:08:53 +02:00
Poster
Owner

Event ID: 160
Date: 2013-01-24T13:33:22Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Demande de l'espagne :

Nous avons un nouvelle loi qui a entrai en vigueur le 01/01/2013. Il sagit

des factures rectificatives, ils devraient inclure une référence spécifique

et non équivoque de la facture corrigé et les spécifications rectificatifs .



On doit mètre dans les avoir le numéro de ticket original et aussi les

pièces quon change.



==> il faut donc ajouter le id_ticket_caisse du ticket d'origine d'un retour

dans le xml pour ensuite traitement dans le XSL

Event ID: 160 Date: 2013-01-24T13:33:22Z Person: Frederik Benoist Description: Modifié par Frederik Benoist Demande de l&#39;espagne :<br /> Nous avons un nouvelle loi qui a entrai en vigueur le 01/01/2013. Il sagit<br /> des factures rectificatives, ils devraient inclure une r&#233;f&#233;rence sp&#233;cifique<br /> et non &#233;quivoque de la facture corrig&#233; et les sp&#233;cifications rectificatifs .<br /> <br /> On doit m&#232;tre dans les avoir le num&#233;ro de ticket original et aussi les<br /> pi&#232;ces quon change.<br /> <br /> ==&gt; il faut donc ajouter le id_ticket_caisse du ticket d&#39;origine d&#39;un retour<br /> dans le xml pour ensuite traitement dans le XSL<br />
fbenoist68 commented 2023-07-03 23:08:56 +02:00
Poster
Owner

Event ID: 159
Date: 2013-01-24T13:31:57Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Event ID: 159 Date: 2013-01-24T13:31:57Z Person: Frederik Benoist Description: Modifié par Frederik Benoist
fbenoist68 commented 2023-07-03 23:09:00 +02:00
Poster
Owner

Event ID: 158
Date: 2013-01-24T13:31:20Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 158 Date: 2013-01-24T13:31:20Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
fbenoist68 commented 2023-07-03 23:09:02 +02:00
Poster
Owner

Event ID: 157
Date: 2013-01-24T13:31:20Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Event ID: 157 Date: 2013-01-24T13:31:20Z 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#111
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?