Project

General

Profile

Actions
Copy link

Anomalie #2601

open

AdminAgim – Refonte PHP - Evolution #2599: Reprise des données

Nego - Confrères - doublons

Added by Emanuel Stancu 25 days ago. Updated 25 days ago.

Status:
Nouveau
Priority:
Normal
Assignee:
Mohamed DENNOUN
Category:
-
Start date:
10/05/2026
Due date:
% Done:

0%

Estimated time:

Description

Beaucoup de doublons de confrère, par agence
par nom, dans l'agence id 736, 116012-Imhotep St Jean De Braye

SELECT Fantome.nego_id [Fantome nego_id],Fantome.nego_nom [Fantome nom],Fantome.nego_code [Fantome code]
    , BonConfrere.nego_id,BonConfrere.nego_nom,BonConfrere.nego_code
    , BonConfrere.nego_idagence
FROM Negociateurs AS Fantome
    INNER JOIN Negociateurs AS BonConfrere
    ON Fantome.nego_idagence = BonConfrere.nego_idagence AND TRIM(Fantome.nego_nom) = TRIM(BonConfrere.nego_nom)
        AND (
            TRIM(Fantome.nego_code) = TRIM(BonConfrere.nego_code)
            AND TRIM(Fantome.nego_prenom) = TRIM(BonConfrere.nego_prenom)
--             OR TRIM(Fantome.nego_nom) = TRIM(BonConfrere.nego_nom)
        )
WHERE
    Fantome.nego_typenego = 2 AND BonConfrere.nego_typenego = 2 -- AND BonConfrere.nego_code>''
     AND (
        Fantome.nego_id > BonConfrere.nego_id 
        -- OR  Fantome.nego_code > BonConfrere.nego_code
     )
Actions
Copy link
 #1

Updated by Emanuel Stancu 25 days ago

  • Parent task set to #2599
Actions
Copy link

Also available in: Atom PDF