SET @template_id := (SELECT id
                     FROM ohrm_advanced_task_template
                     WHERE name = 'Push form data to a configured API endpoint'
                     LIMIT 1);

SET @entity_process_id := (SELECT `id`
                           FROM `ohrm_advanced_workflow_entity_process`
                           WHERE `name` = 'Dependent Information'
                             and workflow_id = 'PREBOARDING_DEPENDENT_INFORMATION_PROCESS');

SET @task_template_id := (SELECT `id`
    FROM ohrm_advanced_task_template WHERE
    `name` = 'Dependent Information' AND workflow = 'PREBOARDING_DEPENDENT_INFORMATION_TASK');


SET @form_version_id := (SELECT `id`
                                 FROM ohrm_dynamic_form_version
                                 WHERE name = 'Preboarding Dependent Information');

INSERT INTO `ohrm_advanced_task` (task_template_id, name, description, metadata)
VALUES (@template_id, 'Copy Dependent Information form data to Employee',
        'Copy Dependent Information form data to Employee upon form approval', '{}');


SET @metadata := CONCAT('{
  "entityProcessId": ', @entity_process_id, ',
  "taskTemplateId": ', @task_template_id, ',
  "formVersionId": ', @form_version_id, ',
  "dataTransfer": [
    {
      "processorClass": "PreboardingToPimMultiTabDataTransferProcessor",
      "formDataSortColumn": "name",
      "removeFieldsIfEmptyForMethod": "post",
      "get": {
        "endpointClass": "OrangeHRM\\\\Api\\\\Pim\\\\EmployeeDependentsEndpoint",
        "endpointVersion": 1,
        "params": {
          "request": {
            "emp_number": "${empNumber}"
          }
        },
        "aggregate_column": "dependent_information"
      },
      "post": {
        "endpointClass": "OrangeHRM\\\\Api\\\\Pim\\\\EmployeeDependentsEndpoint",
        "endpointVersion": 1,
        "params": {
          "request": {
            "emp_number": "${emp_number}"
          },
          "body": {
             "name": "${name}",
             "relationship_type": "${relationship#id}",
             "date_of_birth": "${date_of_birth}",
             "relationship": "${relationship_type}"
          }
        }
      },
      "delete": {
        "endpointClass": "OrangeHRM\\\\Api\\\\Pim\\\\EmployeeDependentsEndpoint",
        "endpointVersion": 1,
        "uniqueRecordIdentifierInGet": "seqno",
        "params": {
          "request": {
            "emp_number": "${emp_number}"
          }
        }
      }
    }
  ]
}');

SET @task_id := (SELECT `id`
                 FROM `ohrm_advanced_task`
                 WHERE `name` = 'Copy Dependent Information form data to Employee'
                   AND `task_template_id` = @template_id);

UPDATE `ohrm_advanced_task`
SET `metadata` = @metadata
WHERE `id` = @task_id;

-- Copy relevant information from "Dependent Information" form to the employee profile upon approving the form

INSERT INTO `ohrm_workflow_state_change_resolver` (`state_machine_id`, `resolver`, `options`)
SELECT `id`, 'TaskStateChangeTaskExecutorResolver', JSON_OBJECT('taskId', @task_id)
FROM `ohrm_workflow_state_machine`
WHERE `workflow` = 'PREBOARDING_DEPENDENT_INFORMATION_TASK'
  AND `state` = 'Submitted'
  AND `action` = 'Approve'
  AND `resulting_state` = 'Approved';

