APF Misc App and Report changes

[arjunk]

App Changes

• [x] In the Child Dashboard, another card for MAM, similar to the SAM
• [x] Create a new Dashboard called 'Exit Due'. Purpose of this dashboard is to help the Poshan Sathi identify the individuals who are supposed to be exited from the program but have not been. Following two cards need to be created for two programs
• [x] Child : Program enrolment Active and crossed 5 years in age
• [x] Pregnancy : 6 months from Delivery Encounter, date of delivery
• [x] Add Age filter on Search Page

[BEULAHEVANJALIN]

Test query for point number 3:

select (individual.id), concat(individual.first_name, ' ', individual.last_name), gender, age(date_of_birth)
from apfodisha.individual
         join apfodisha.individual_child on individual.id = individual_child.individual_id
where individual.is_voided = false
  and individual_child.is_voided = false
  and individual_child.program_exit_date_time is null
  and EXTRACT(year
              FROM age(individual.date_of_birth)) >= 5
  and individual.address_id in (select id
                                from apfodisha.address
                                where id in (select addresslevel_id
                                             from catchment_address_mapping
                                             where catchment_id = (select catchment_id
                                                                   from users
                                                                   where username = 'beulah@apfodisha')));

[BEULAHEVANJALIN]

Test query for point number 4:

select distinct (individual.id), concat(individual.first_name, ' ', individual.last_name), gender, age(date_of_birth)
from apfodisha.individual
         join apfodisha.individual_pregnancy on individual.id = individual_pregnancy.individual_id
         join apfodisha.individual_pregnancy_delivery on individual.id = individual_pregnancy_delivery.individual_id
where individual.is_voided = false
  and individual_pregnancy.is_voided = false
  and individual_pregnancy.program_exit_date_time is null
  and individual_pregnancy_delivery."Date of delivery" < current_date - INTERVAL '6 months'
  and individual.address_id in (select id
                                from apfodisha.address
                                where id in (select addresslevel_id
                                             from catchment_address_mapping
                                             where catchment_id = (select catchment_id
                                                                   from users
                                                                   where username = 'beulah@apfodisha')));

[BEULAHEVANJALIN]

All changes have been moved from prelease to UAT. But unable to test due to faulty data and getting SyncError.