Versions Compared

Version Old Version 32 New Version 33
Changes made by

sveta vedmed (Unlicensed)

sveta vedmed (Unlicensed)

Saved on

Key

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

Table of Contents

Image Removed

Anchor
Declaration Request JSON Schema
Declaration Request JSON Schema
Validate request

Image Added


Validate request using JSON schema

...

Search declarations in IL_DB.declaration_requests to prevent requests duplication:

  • 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_id = :($.declaration_request.legal_entity_id)
  AND IL_DB.declaration_requests.data.declaration_request.employee_id = :($.declaration_request.employee_id)
  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.first_name = :($.declaration_request.person.first_name) 
  AND IL_DB.declaration_requests.data.declaration_request.person.last_name = :($.declaration_request.person.last_name) 
   AND IL_DB.declaration_requests.data.declaration_request.person.secondbirth_namedate = :($.declaration_request.person.secondbirth_namedate)
  AND IL_DB.declaration_requests.data.declaration_request.legal_entity_id = :($.declaration_request.legal_entity_id)
  AND IL_DB.declaration_requests.data.declaration_request.employee_id = :($.declaration_request.employee_id)
  AND IL_DB.declaration_requests.status IN ('NEW', 'APPROVED')

...