RC_Get Medication request by ID (modified - EN)

Specification 

Apiary

Purpose

This WS is designed to return Medication request detail.
Search Medication Request possible in 2 options: by `medication_request.id` OR `medication_request.request_number`.

According to requirements:

• User can see all Medication Requests of which he is an author

• User of MSP, PRIMARY_CARE, OUTPATIENT (DOCTOR, SPECIALIST, etc) can see all Medication requests from the user's legal entity

• User of MSP, PRIMARY_CARE (DOCTOR, etc) can see all the Medication requests of the patients whom he has an active declaration with by yourself a doctor (employee_id)

• User of PHARMACY can see all Medication requests (without limitations)

• User of MSP, PRIMARY_CARE, OUTPATIENT (DOCTOR, SPECIALIST, etc) can see all Medication requests based on the approval of the care plan that is contained in the Medication request

Input parameters (filters)

• id 

Validate request

Search Medication Request

1. Search record by `$.id` in column `medication_request.id` 

   1. If not found -  Search record by `$.id` in column `medication_request.request_number`

      1. If not found - Return  404 in case "Not found"

Validate FK

1. Read data from `ops.medication_requests` by `id`

2. Validate legal_entity_id - legal_entity_id exists

   • Return 422 in case validation fails (422 EView)

3. Validate employee_id - employee_id exists

   • Return 422 in case validation fails (422 EView)

4. Validate division_id - division_id exists

   • Return 422 in case validation fails (422 EView)

5. Validate medical_program_id - medical_program_id exists

   • Return 422 in case validation fails (422 EView)

6. Validate all medication_id - medication_id exists

   • Return 422 in case validation fails (422 EView)

7. Validate person_id - mpi_id exists

   • Return 422 in case validation fails (422 EView)

Logic WS

1. Verify the validity of access token
   
   

   1. Return 401 in case validation fails

2. Check user scopes in order to perform this action (scope = 'medication_request:details')

   1. Return 403 in case invalid scope(s)

3. Get `client_type` from `mithril.clients`

   Get `my_party_id`  from `$.context.user_id`

   Get list from `prm.employees` for this `party_id`  & `$.context.legal_entity_id`

4. Search Medication requests by filters:

   SELECT * FROM medication_request MR INNER JOIN employees E ON E.party_id = my_party_id AND (E.id = $.employee_id OR $.employee_id IS NULL) AND (E.legal_entity_id == $.context.legal_entity_id OR $.context.legal_entity_id IS NULL) LEFT JOIN declarations D ON D.Employee_id = E.id AND E.status = ACTIVE AND D.status = ACTIVE AND MR.person_id = D.person_id WHERE (MR.id = $.id OR MR.request_number = $.id) AND MR.employee_id == E.id AND MR.is_active = TRUE

    

Logic WS for medication requests based on care plan

1. Get party_id  from $.context.user_id

   Get list from $.prm.employees for this party_id

   Get care_plan_id from $.medication_requests.based_on_care_plan_id

   Check $.approvals for user's employees (granted_to) on care_plan_id (granted_resources) and $.medication_requests.person_id (granted_by)

2. Search Medication requests by filters: based_on_care_plan_id, person_id.

   SELECT * FROM medication_request MR WHERE (MR.id = $.id OR MR.request_number = $.id) AND MR.based_on_care_plan_id = $.id AND MR.person_id = $.id AND MR.is_active = TRUE

    

Logic WS for `client_type` = PHARMACY

1. Search Medication request by $.id: 

   SELECT * FROM medication_request MR WHERE (MR.id = $.id OR MR.request_number = $.id) AND MR.is_active = TRUE

    

Response (output)

1. Return object with response structure from WS Sign Medication Request.

2. Calculate medication remaining quantity:

   1. Select all Medication Dispenses in status ACTIVE related to the Medication Request

      Sum medication_qty in the filtered Medication Dispenses as dispensed_qty

      Calculate medication_remaining_qty = medication_qty - dispensed_qty

3. Return medication_remaining_qty in the response