Project

General

Profile

Anomalie #10258

[User id numérique] erreur lors de l'enregistrement des courriers

Added by Ludovic ARAUJO about 3 years ago. Updated 11 months ago.

Status:
Développé / Analysé (S)
Priority:
1-Majeur
Assignee:
Target version:
Start date:
04/10/2019
Due date:
Tags Courrier:
18.04.13, 18.10.8

Description

Si les utilisateurs on un identifiant numérique et qu'ils sont saisies en expediteur ou destinataire nous obtenons une erreur sql qui empêche l'enregistrement.

History

#1 Updated by Ludovic ARAUJO about 3 years ago

sql erreur :
a la création d'un courrier avec un utilisateur en expéditeur j'ai cette requete en erreur :

SELECT  res_id, count(1) OVER() AS __full_count FROM res_view_letterbox WHERE status <> 'DEL' AND contact_id =  '4567', ' '
 AND (creation_date >= CURRENT_TIMESTAMP - INTERVAL '5' DAY) AND (( 1=1 ) or ( destination in ('DRAG-DSI-APPLI', '') 
 AND (status NOT IN('VAL','ATT') OR (status='VAL' AND confidentiality='N')) ) or ( 1=1 ) OR  (  status = 'NUMQUAL') or (  status = 'ATT') 
 or (  status='INIT') or (  STATUS='RET') or (  status = 'EAVIS' AND res_id IN (SELECT res_id FROM listinstance WHERE coll_id = 'letterbox_coll' 
 AND item_type = 'user_id' AND item_id = '4567' AND item_mode = 'avis' and process_date is NULL)) or (  status='EAVIS' and ((DEST_USER = '4567') 
OR (DEST_USER IN (select user_id from users_entities WHERE entity_id IN( 'DRAG-DSI-APPLI')) or DESTINATION in (''))) and res_id NOT IN 
(SELECT res_id FROM listinstance WHERE item_mode = 'avis' and difflist_type = 'entity_id' and process_date is not NULL and res_view_letterbox.res_id = res_id group by res_id) 
 AND res_id IN (SELECT res_id FROM listinstance WHERE item_mode = 'avis' and difflist_type = 'entity_id' and process_date is NULL and res_view_letterbox.res_id = res_id group by res_id)) 
 or (  status='EAVIS' and ((DEST_USER = '4567') OR (DEST_USER IN (select user_id from users_entities WHERE entity_id IN( 'DRAG-DSI-APPLI')) or DESTINATION in (''))) 
 and res_id IN (SELECT res_id FROM listinstance WHERE item_mode = 'avis' and difflist_type = 'entity_id' and process_date is not NULL and res_view_letterbox.res_id = res_id group by res_id)) 
 or (  dest_user = '4567' AND (status in ('NEW', 'COU','STDBY','ENVDONE') OR (status ='VAL' AND confidentiality='N' AND entitytype = 'Service'))) or (  destination in ('DRAG-DSI-APPLI', '') 
 and (status <> 'DEL' AND status <> 'REP') and (now() > process_limit_date)) or (  destination in ('DRAG-DSI-APPLI', '') and (status in ('NEW', 'COU','STDBY','ENVDONE')  
 OR (status ='VAL' AND confidentiality='N' AND entitytype = 'Service')) and dest_user <> '4567') or (  status in ('ESIG', 'EVIS') AND dest_user = '4567') or (  status='EENV' AND dest_user = '4567') 
 or (  (res_id in (select res_id from listinstance WHERE coll_id = 'letterbox_coll' and item_type = 'user_id' and item_id = '4567' and item_mode = 'cc') 
or res_id in (select res_id from listinstance WHERE coll_id = 'letterbox_coll' and item_type = 'entity_id' and item_mode = 'cc' and item_id in ('DRAG-DSI-APPLI'))) 
and status not in ( 'DEL', 'END', 'SSUITE') and res_id not in (select res_id from res_mark_as_read WHERE user_id = '4567')))  ORDER by creation_date DESC OFFSET 0 LIMIT 1

Apres test j'ai remarquer que la partie en défaut est a la première ligne :

contact_id =  '4567', ' '

je pense que la requête aurais du avoir :

 contact_id =  '4567' and address_id = null

#2 Updated by Ludovic ARAUJO about 3 years ago

piste :

User_id : 4567

apps/maarch_entreprise/indexing_searching/contact_check.php
ligne 43 : if (is_numeric($_POST['contact_id'])) {

#3 Updated by Ludovic ARAUJO about 3 years ago

  • Priority changed from 1-Majeur to 0-Bloquant

#4 Updated by Emmanuel DILLARD about 3 years ago

  • Subject changed from [Enregistrement Courrier] erreur lors de l'enregistrement des courriers to [User id numérique] erreur lors de l'enregistrement des courriers
  • Status changed from A traiter to A étudier
  • Assignee set to EDI PO
  • Priority changed from 0-Bloquant to 1-Majeur

#5 Updated by Emmanuel DILLARD about 3 years ago

  • Status changed from A étudier to Prêt à développer
  • Target version changed from 18.10 (support sécurité) to 19.04 (Support sécurité)
  • Tags Courrier 18.10.8 added

#6 Updated by Florian AZIZIAN about 3 years ago

  • Status changed from Prêt à développer to En cours de dev (S)

#7 Updated by Damien BUREL about 3 years ago

  • Tags Courrier 18.04.13 added

#9 Updated by Florian AZIZIAN about 3 years ago

  • Project changed from Backlog to CURRENT SPRINT

#10 Updated by Emmanuel DILLARD about 3 years ago

  • Project changed from CURRENT SPRINT to Backlog
  • Status changed from En cours de dev (S) to Développé / Analysé (S)

#11 Updated by Emmanuel DILLARD 11 months ago

  • Project changed from Backlog to Backlog Courrier
  • Target version changed from 19.04 (Support sécurité) to 19.04 (Sécurité)

Also available in: Atom PDF