Skip to main content

PHQ9

This job was provided by an OpenFn.org user via the job library API.

Metadata​

Key Functions​

alterState, dataValue, field, fields, relationship, upsert

Expression​

alterState(state => {
  function capitalizeFirstLetter(str) {
    if (!str) return;
    let new_str = str.toString().toLowerCase();
    return new_str.slice(0, 1).toUpperCase() + new_str.slice(1);
  }

  function transform(value) {
    if (!value) return;
    switch (value.toString().trim()) {
      case 'Daughterson':
        return 'Daughter/Son';
      case 'Other_specify':
        return 'Other';
      case 'Single_never_married':
        return 'Single/Never Married';
      case 'Divorced__separated':
        return 'Divorced/separated';
      default:
        return value;
    }
  }

  function getAge(dateString) {
    if (!dateString) return;

    const today = new Date();
    const birthDate = new Date(dateString);
    var age = today.getFullYear() - birthDate.getFullYear();
    var m = today.getMonth() - birthDate.getMonth();
    if (m < 0 || (m === 0 && today.getDate() < birthDate.getDate())) {
      age--;
    }
    return age;
  }
  
  state.data.form.begin_interview.what_is_your_marital_status = state.data.form.begin_interview && state.data.form.begin_interview.what_is_your_marital_status  ? transform(
    capitalizeFirstLetter(state.data.form.begin_interview.what_is_your_marital_status) 
  ): undefined;

  state.data.form.begin_interview.position_of_respondent_in_the_household = state.data.form.begin_interview && state.data.form.begin_interview.position_of_respondent_in_the_household ? transform(
    capitalizeFirstLetter(state.data.form.begin_interview.position_of_respondent_in_the_household)
  ): undefined;

  state.helperFunctions = { getAge };
  return state;
});

upsert(
  'PHQ_9_Strong_Minds__c',
  'CommCare_Ext_ID__c',
  fields(
    field('CommCare_Ext_ID__c', dataValue('id')),
    
    // relationship('Intervention_Name__r', 'CommCare_Case_ID__c', state => {
    //   if (state.data.form.hidden_properties.intervention_id) return state.data.form.hidden_properties.intervention_id;
    //   else return "990221ac-3c05-475d-87c7-24d8a5fcb63e";
    // }),
    relationship('Intervention_Name__r', 'CommCare_Case_ID__c', dataValue('form.hidden_properties.intervention_id')),
    
    
    //relationship('Participant__r','CommCare_Ext_ID__c', dataValue('form.hidden_properties.participant_fullname')),
    field('Mobile_Contact_Information__c', dataValue('form.hidden_properties.mobile_number')),
    field('Curriculum__c', dataValue('form.hidden_properties.curriculum')),
    //field('Intervention__c', dataValue('form.hidden_properties.intervention')),
    field('Gender__c', dataValue('form.hidden_properties.gender')),
    field('Participant_Name__c', state => {
      const firstname = state.data.form.hidden_properties.participant_first_name;
      const lastname = state.data.form.hidden_properties.participant_surname;
      return firstname + ' ' + lastname;
    }),

    field('Coach_Name__c', dataValue('form.hidden_properties.coach_name')),
     relationship(
      'Venue2__r',
      'CommCare_Ext_ID__c',
      dataValue('form.hidden_properties.venue')
    ),    
    //field('Venue__c', dataValue('form.hidden_properties.venue')), replacing with the lookup
     relationship(
      'Site2__r',
      'CommCare_Ext_ID__c',
      dataValue('form.hidden_properties.site')
    ),
    //field('Site__c', dataValue('form.hidden_properties.site')), replacing with the lookup
    field('Interview_Date__c', dataValue('form.interview_date')),
    field('Resident_not_shifting_in_3_months_time__c', dataValue('form.full_time_resident')),
    field('Participant_DOB__c', state => {
      const dob  = dataValue('form.hidden_properties.date_of_birth')(state); 
      return dob ? dob : null; 
    }),
    //field('Area_Center__c', dataValue('form.hidden_properties.venue')), //Can get from Intervention
    field('Age_of_Participant__c', state => {
      const dob = dataValue('form.hidden_properties.date_of_birth')(state);

      return dob ? state.helperFunctions.getAge(dob) : null;
    }),
    
    
    field('Marital_Status__c', dataValue('form.begin_interview.what_is_your_marital_status')),
    field(
      'Position_of_Respondent_in_Household__c',
      dataValue('form.begin_interview.position_of_respondent_in_the_household')
    ),
    field('Q1_Little_interest_pleasure__c', dataValue('form.begin_interview.questions.little_interest')),
    field('Q2_Sad_Down_Depressed_Hopeless__c', dataValue('form.begin_interview.questions.depressed_sad_hopeless')),
    field('Q3_Trouble_sleeping__c', dataValue('form.begin_interview.questions.trouble_sleeping')),
    field('Q4_Feeling_tired__c', dataValue('form.begin_interview.questions.heavy_burden')),
    field('Q5_Appetite_problems__c', dataValue('form.begin_interview.questions.appetite_problems')),
    field('Q6_Failure_Worthless_Guilt__c', dataValue('form.begin_interview.questions.feeling_bad')),
    field('Q7_Trouble_concentrating__c', dataValue('form.begin_interview.questions.trouble_concentrating')),
    field('Q8_Trouble_in_speech__c', dataValue('form.begin_interview.questions.moving_slowly')),
    field('Q9_Suicidal_thoughts__c', dataValue('form.begin_interview.questions.thoughts_suicide'))
    //field('PHQ9_Total_Score__c', dataValue('form.begin_interview.questions.phq9_result.PHQ9_score'))
  )
);