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

[FogBugz #103] Ligne des client_opération orphelines #165

New Issue
Open
opened 2023-07-03 23:34:11 +02:00 by fbenoist68 · 7 comments
fbenoist68 commented 2023-07-03 23:34:11 +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:34:12 +02:00
Poster
Owner

Event ID: 538
Date: 2013-05-23T09:07:46Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist

Event ID: 538 Date: 2013-05-23T09:07:46Z Person: Frederik Benoist Description: Fermé par Frederik Benoist
fbenoist68 commented 2023-07-03 23:34:13 +02:00
Poster
Owner

Event ID: 537
Date: 2013-05-23T09:07:46Z
Person: Frederik Benoist
Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist

Event ID: 537 Date: 2013-05-23T09:07:46Z Person: Frederik Benoist Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist
fbenoist68 commented 2023-07-03 23:34:14 +02:00
Poster
Owner

Event ID: 536
Date: 2013-05-23T09:07:03Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

C:\projets\DotSoft\CaisseAuto\bManager\Manager\Client\cClientOperationManager.vb

 

Public Function mAjouterAvecRegroupement(ByVal idStructure As Integer, ....

 

....

Return cSqlDao.psClientOperation.mCreerAvecRegroupement(clientOp)

 

==>

Return cSqlDao.psClientOperation.mCreerAvecRegroupement(clientOp,trans)

Event ID: 536 Date: 2013-05-23T09:07:03Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> C:\projets\DotSoft\CaisseAuto\bManager\Manager\Client\cClientOperationManager.vb</p> <p> &nbsp;</p> <p> Public Function mAjouterAvecRegroupement(ByVal idStructure As Integer, ....</p> <p> &nbsp;</p> <p> ....</p> <p> Return cSqlDao.psClientOperation.mCreerAvecRegroupement(clientOp)</p> <p> &nbsp;</p> <p> ==&gt; </p> <p> Return cSqlDao.psClientOperation.mCreerAvecRegroupement(clientOp,<strong>trans</strong>)</p>
fbenoist68 commented 2023-07-03 23:34:16 +02:00
Poster
Owner

Event ID: 413
Date: 2013-03-04T14:11:36Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Event ID: 413 Date: 2013-03-04T14:11:36Z Person: Frederik Benoist Description: Modifié par Frederik Benoist
screenshot.png
31 KiB
screenshot.png
fbenoist68 commented 2023-07-03 23:34:22 +02:00
Poster
Owner

Event ID: 412
Date: 2013-03-04T14:06:53Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Il me semble que vous êtes déjà au courant.

Je te donne un exemple de plus, de ligne dans client operation avec un id_document qui ne correspond à aucun id_facturec dans client_facture :





SELECT *

  FROM client_operation AS OF TIMESTAMP TO_TIMESTAMP ('04/03/2013 13:00:00','DD/MM/YYYY HH24:MI:SS')

WHERE id_document IN (63745056, 63745045); -- ticket d'origine 63745149



SELECT *

  FROM client_facture AS OF TIMESTAMP TO_TIMESTAMP ('04/03/2013 13:00:00','DD/MM/YYYY HH24:MI:SS')

WHERE id_facturec IN (63745056, 63745045);



Il semblerait que les lignes en trop soient des duplications du règlement de la facture 63745149.

Event ID: 412 Date: 2013-03-04T14:06:53Z Person: Frederik Benoist Description: Modifié par Frederik Benoist Il me semble que vous &#234;tes d&#233;j&#224; au courant. <br /> Je te donne un exemple de plus, de ligne dans client operation avec un id_document qui ne correspond &#224; aucun id_facturec dans client_facture :<br /> <br /> <br /> SELECT *<br /> &nbsp; FROM client_operation AS OF TIMESTAMP TO_TIMESTAMP (&#39;04/03/2013 13:00:00&#39;,&#39;DD/MM/YYYY HH24:MI:SS&#39;)<br /> WHERE id_document IN (63745056, 63745045); -- ticket d&#39;origine 63745149<br /> <br /> SELECT *<br /> &nbsp; FROM client_facture AS OF TIMESTAMP TO_TIMESTAMP (&#39;04/03/2013 13:00:00&#39;,&#39;DD/MM/YYYY HH24:MI:SS&#39;)<br /> WHERE id_facturec IN (63745056, 63745045);<br /> <br /> Il semblerait que les lignes en trop soient des duplications du r&#232;glement de la facture 63745149.<br />
fbenoist68 commented 2023-07-03 23:34:23 +02:00
Poster
Owner

Event ID: 411
Date: 2013-03-04T14:06:02Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 411 Date: 2013-03-04T14:06:02Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
fbenoist68 commented 2023-07-03 23:34:25 +02:00
Poster
Owner

Event ID: 410
Date: 2013-03-04T14:06:02Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Event ID: 410 Date: 2013-03-04T14:06:02Z 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#165
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?