Saltar al contenido principal
Esta página no tiene versión en español, así que te la mostramos en inglés.

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'))
  )
);