[Phulwari] App/form Changes

[garimadosar5]

Ref Doc - https://docs.google.com/document/d/1lGGvi0JJGJX813luiIN3-ulcp3MvYRO4LpvGBrWqbcg/edit?ts=60420c15

Phulwari Reg Form - Done on JSS UAT

• Add question - "Day of month in Phulwari for Growth monitoring visit", (this question is currently asked for each child in child enrolment form) this question should not ask for each child.

Child Enrolment (Phulwari Program) -

• Remove the above question from child enrolment form. Cannot remove until Phulwari is live. And visit scheduling for Growth monitoring needs to be updated accordingly.

• Add a new option No/None in the already existing question - "Disability",and migrate already existing enrolments where there is no disablity. Also, remove skip logic from this ques.

• Change in Disability-related change (Reg form) [Migration required]
  - Add a question "Specify other" if OTHER disability is selected.

• Change in "Any chronic illness” question (reg form)
  - Add a question "Name of Disease" if Yes is selected for question "Any Chronic sickness".

Offline report Setup - Done on JSS UAT

• Offline Report “Registered but not enrolled”
  Formula - All the children that are registered in the system but not enrolled in the Phulwari program.

[nupoorkhandelwal]

Migration script to update

set role jss;
with audits as(
update program_enrolment
set observations = observations ||
jsonb_build_object('100cf9ac-313d-4d20-9968-6113deecbb26',
'["ebda5e05-a995-43ca-ad1a-30af3b937539"]'::jsonb)
where single_select_coded((observations ->> 'cbcfdd44-dac8-435f-9cd9-35f20db1f367')::text) = 'No'
returning audit_id
)
update audit
set last_modified_date_time = current_timestamp
where id in (select audit_id from audits);

[garimadosar5]

QA Notes -

• In Child enrolment form - Specify other questions are not added in chronic sickness and disability questions.
  

[nupoorkhandelwal]

@garimadosar5 Please test this change on staging!