Versions Compared

Version Old Version 81 New Version 82
Changes made by

Aleksandra Novokhatnia (Deactivated)

Aleksandra Novokhatnia (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Search declarations in IL_DB.declaration_requests to prevent requests duplication:

For ONLINE

  • if tax_id is not null
Code Block
languagesql
WHERE IL_DB.declaration_requests.data.declaration_request.person.tax_id = :($.declaration_request.person.tax_id)
  AND IL_DB.declaration_requests.data.declaration_request.legal_entity_idperson.authentication_methods.phone_number = :($.declaration_request.legal_entity_id.person.authentication_methods.phone_number)
  AND IL_DB.declaration_requests.status IN ('NEW', 'APPROVED')
  • if tax_id is null
Code Block
WHERE IL_DB.declaration_requests.data.declaration_request.person.documents.number = :($.declaration_request.person.documents.number)
  AND IL_DB.declaration_requests.data.declaration_request.employee_idperson.authentication_methods.phone_number = :($.declaration_request.employee_id.person.authentication_methods.phone_number) 
  AND IL_DB.declaration_requests.status IN ('NEW', 'APPROVED')

For OFFLINE

  • if tax_id is not null
Code Block
languagesql
WHERE IL_DB.declaration_requests.data.declaration_request.person.firsttax_nameid = :($.declaration_request.person.firsttax_nameid) 
  AND IL_DB.declaration_requests.data.declaration_request.person.documents.last_namenumber = :($.declaration_request.person.documents.last_namenumber)
   ANDAND IL_DB.declaration_requests.status IN ('NEW', 'APPROVED')
  • if tax_id is null
Code Block
WHERE IL_DB.declaration_requests.data.declaration_request.person.documents.birth_datenumber = :($.declaration_request.person.documents.birth_datenumber)
  AND IL_DB.declaration_requests.data.declaration_request.legal_entity_idperson.first_name = :($.declaration_request.person.legalfirst_entity_idname)
  AND IL_DB.declaration_requests.data.declaration_request.person.employeelast_idname = :($.declaration_request.employeeperson.last_idname)
  AND IL_DB.declaration_requests.status IN ('NEW', 'APPROVED')

...