Cold/Flu: 'Registered Clinics for this Worksite'

[Stella-Archer]

User Story “As a user registering a worksite, I want see all the clinics already registered at my worksite so I can contact and coordinate with colleagues who have already registered.”

Tasks

• [ ] Create grid to contain data fields to be pulled from the DB Columns:

• Worksite contact

• Ministry

• Type of Clinic

• Number of employees

• [ ] Logic: When a user selects a ministry and worksite from the drop down, check DB to see if the worksite already has a clinic registered

• YES display grid populated with existing registration info (Display OPEN clinics ONLY)

• NO continue to "clinic registration'

Acceptance Criteria

• [ ] When a user selects a city and worksite, if a clinic has already be registered at that site, registration information is displayed.
• [ ] the information display should be tabular allowing for one or many registration entries

[EduardoRamirezBC]

Meeting with Mike needed. Caleb/Stella. Stella will setup.

[Stella-Archer]

waiting for API to Fill data

[bhumin-fw]

@mikeshi-bcgov We need one API endpoint. which returns clinics/registrations filter by WorksiteID. Once schema fix please prepare this API endpoint on priority. Please see the ticket details for required keys in response for each clinics/registrations. (fields are Worksite Contact, Ministry, Type Of Clinic/Registration, Number of Employees)

[mikeshi-bcgov]

@bhumin-fw Sure Bhumin, I will bring this to the team in this afternoon's meeting, to see how to present these fields out of the new schema

[Stella-Archer]

Is #1000 blocking this?

[bhumin-fw]

@Stella-Archer yes #1000 blocking this ticket.

[bhumin-fw]

@mikeshi-bcgov https://analytics-testapi.psa.gov.bc.ca/apiserver/api.rsc/ods_datamart_influenza_worksites/ https://analytics-testapi.psa.gov.bc.ca/apiserver/api.rsc/ods_datamart_influenza_worksite_ministries/ Above API endpoints only give worksites list or mapping.

We need below API endpoints:

1. Worksite list filter by provided ministry_id. (When we pass ministry_id in API endpoint it will only list worksites link to that ministry. Right now I have to fetch worksite ids and then have to trigger worksites API)

2. Registrations based on provided worksiteID.

   • This API endpoint should accept worksite_id as filter in request and in response it should send registrations under selected worksites. response should contain at-least below value worksite-contact: String (name of primary contact) registration-type: String (value of is_closed key from registration table which contain "open" & "closed" as value) ministry: String (Name of registration's ministry) number-of-employee: Int (number of employee value from registration table)

FYI: This is priority along side add/update registration API.

[mikeshi-bcgov]

@bhumin-fw Endpoint for the first requested is now available, which is based on a view so you can only do GET:

https://analytics-testapi.psa.gov.bc.ca/apiserver/api.rsc/ods_datamart_influenza_vw_worksites_ministries_joined/

[bhumin-fw]

@mikeshi-bcgov It did revert blank, do I need to pass filter here? or you are cleaning and reloading tables? {'@odata.context': 'https://analytics-testapi.psa.gov.bc.ca/apiserver/api.rsc/$metadata#ods_datamart_influenza_vw_worksites_ministries_joined', 'value': []}

[EduardoRamirezBC]

Mike: the data was reloaded.

[EduardoRamirezBC]

@mikeshi-bcgov to add two entries for registration table.

[mikeshi-bcgov]

@EduardoRamirezBC Two dummy entries have been added to registrations table

[mikeshi-bcgov]

@bhumin-fw

API EndPoint for the item requested #2 ( 2. Registrations based on provided worksiteID.) is available now as well, please test

https://analytics-testapi.psa.gov.bc.ca/apiserver/api.rsc/ods_datamart_influenza_vw_registrations_worksites_joined/

[iman-jamali-fw]

I'll test the endpoint today and update the ticket.

[MeghanStothers]

Dummy data in for and Iman to test the endpoint today

[iman-jamali-fw]

@mikeshi-bcgov

The https://analytics-testapi.psa.gov.bc.ca/apiserver/api.rsc/ods_datamart_influenza_vw_registrations_worksites_joined works great and I can see the registration items including the ones I sent last night. filter by application_id also works.

Thanks!

[MeghanStothers]

Iman to work with Caleb and Mike to make sure in form data is in correct type.

[chriscaldwell-psa]

@bhumin-fw, @EduardoRamirezBC - can we connect re all endpoint tickets today for Cold & Flu. Thanks! Chris

[bhumin-fw]

@chriscaldwell-psa do you want to re-connect for this ticket or endpoint related ticket? It is ready to test on DEV. Note: If you make change in form above this component it will stop as need to find component using absolute path for additional property access.

[chriscaldwell-psa]

@bhumin-fw - Hi Bhumin, yes, let me know when we can connect today. Thanks C

[Stella-Archer]

@chriscaldwell-psa @bhumin-fw I'm looking for this in both DEV and TEST and don't see 'clinics at this worksite' populating is there a particular ministry/worksite combo I need to query to see the test data?

[bhumin-fw]

@Stella-Archer try below combination.

[Stella-Archer]

Thanks @bhumin-fw oddly enough that did not work for me :( TEST DEV

[ayushdamani]

Hey @bhumin-fw , I tested this in Test and Dev and it didn't work out for me either.

Test

Dev

[ayushdamani]

Tested again in Dev and Test - the table populates with Worksite contact, Ministry, Type of Clinic and Number of employees.

Test

Dev

[Stella-Archer]

this work great, PO approved and closing this ticket