Skip to main content

Register Participant - V2 Skillz

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

Metadata​

Key Functions​

alterState, dataPath, dataValue, each, field, fields, lastReferenceValue, map, merge, query, relationship, upsert, Array

Expression​

query(`SELECT Id, Name, CommCare_Ext_ID__c FROM Event__c WHERE CommCare_Case_ID__c = '${state.data.form.case['@case_id']}'`);

alterState(state => {
  // Note: lastReferenceValue selects the first item in the references array.
  state.data.eventName = lastReferenceValue('records[0].CommCare_Ext_ID__c')(state);

  function objectToArray(object) {
    return !Array.isArray(object) ? [object] : object;
  }

  // if (state.data.form.question1) {
  //   console.log('Ensuring that "question1" is an array.');
  //   state.data.form.question1 = objectToArray(state.data.form.question1);
  // } else {
  //   console.log('Shifting "new_participants" to "question1" array.');
  //   state.data.form.question1 = objectToArray(state.data.form.new_participants);
  //   console.log('Creating a "case" object inside each item in that array.');
  //   state.data.form.question1 = state.data.form.question1.map(item => ({
  //     ...item,
  //     case: item.create_skillz_plus_participant.case,
  //   }));
  // }

  console.log('Done with initial data manipulation.');

  return state;
});

// beta.each(
//   merge(
//     dataPath('form.question1[*]'),
//     fields(
//       field('intervention_notes_to_save', dataValue('form.intervention_notes_to_save')))
//   ),

  upsert(
    'Person__c',
    'Participant_Identification_Number_PID__c',
    fields(
      field('Notes__c', dataValue('form.intervention_notes_to_save')),
      field('First_Name__c', dataValue('form.new_participants.participant_first_name')),
      field('Surname__c', dataValue('form.new_participants.participant_surname')),
      relationship('RecordType', 'Name', 'Participant'),
      field('Participant_Identification_Number_PID__c', state => state.data.form.new_participants.create_skillz_plus_participant.case['@case_id']),
      field('Sex__c', dataValue('gender')),
      field('Mobile_Number_1__c', dataValue('form.new_participants.mobile_number')), //QUESTION: In CommCare, phone doesn't look like it's saving?
      field('School_name_person__c', dataValue('form.new_participants.school_name')),
      field('Date_of_Birth__c', dataValue('date_of_birth')),
      field('School_name_person__c', dataValue('form.new_participants.school_name')),
      field('Physical_Address__c', dataValue('form.new_participants.participants_home_address'))
      //field('Age__c', dataValue('form.question1.age_in_years')), //This is a SF formula field, cannot map
    )
  )
//);

// each(
//   merge(dataPath('form.question1[*]'), fields(
//     field('intervention_name', dataValue('form.intervention_name')),
//     field('eventName', dataValue('eventName')))),
  upsert(
    'Attendance__c',
    'CommCare_Ext_ID__c',
    fields(
      field('CommCare_Ext_ID__c', state => {
        var eventid = `${state.data.eventName}` || dataValue('form.intervention_name')(state);
        var personid = state.data.form.new_participants.create_skillz_plus_participant.case['case_id'];//state.data.case['@case_id'];
        return personid + '-' + eventid;
      }),
      relationship(
        //Attendance looks up to Persn via the case_id
        'Person_Attendance__r',
        'Participant_Identification_Number_PID__c',
        state => state.data.case['@case_id']
      ),
      relationship(
        //Attendance looks up to Event via the intervention_name
        'Event__r',
        'CommCare_Case_ID__c',
        state.data.form.new_participants.create_skillz_plus_participant.case.index.parent['#text']
      ),
      field('Date_of_Birth__c', dataValue('form.new_participants.date_of_birth'))
    )
  )
//);