Page Comparison

...

Doctors should be filtered on portal by first name, second name, last name, speciality, settlement, division_name. Only active doctors can be found. 

Each doctor must be linked to division.

All datas are shown without scopes from reports DB.

UI Design

Image Added

Divisions

Specification

Search Employees

Get doctors List

Search divisions employees by filters in payload.

• Search only ACTIVE  only status='APPROVED' doctors
• is_active=true
• do not show employees with employees.division is nullexclude from response doctors with declaration_count>=declaration_limit
• employee_type='DOCTOR'

Filter by

• first_name, last_name, second_name (optional, as 'like', case insensitive) - from report.parties
• speciality (report.employees.speciality.speciality)
• region (optional, as `LIKE *`)
• area (optional, as `LIKE *`)
• settlement (optional, as `LIKE *`)
• division_name (optional, as `LIKE *`)
• is_available (of nvl(declaration_count,0)>=declaration_limit then is_available=false else true)

Statements for response:

• get employees.speciality
• get parties.specialities, for each  parties.specialities.speciality check condition if parties.specialities.speciality<>employee.speciality.speciality then set speciality_officio=false and add to employees.speciality else don't add to response.

In case none doctors was found return 200 and empty array.