Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /**
- * Implementation of hook_menu().
- */
- function survey_json_exporter_menu() {
- $items['survey_json_exporter'] = array(
- 'access callback' => true, // available to all
- 'page callback' => 'survey_json_exporter',
- 'delivery callback' => 'drupal_json_output'
- );
- return $items;
- }
- function survey_json_exporter($form, &$fstate)
- {
- module_load_include('inc', 'webform', 'includes/webform.submissions');
- $returningJSON = new stdClass();
- $Surveys = [];
- //TODO - > Loop All Surveys.
- $submissions = webform_get_submissions(70535);
- // Load components for each node.
- $surveycomponents = db_select('webform_component')
- ->fields('webform_component')
- ->condition('nid', 70535)
- ->orderBy('weight')
- ->orderBy('name')
- ->execute()
- ->fetchAllAssoc('cid', PDO::FETCH_ASSOC);
- foreach ($submissions as &$submission) {
- $submissionObj = new stdClass();
- $submissionObj->SubmissionID = $submission->sid;
- $submissionObj->SerialNumber = $submission->serial;
- $submissionObj->DateSubmitted = $submission->submitted;
- $SumbissionQA = [];
- while ($surveyanswer = current($submission->data)) {
- $componentName = $surveycomponents[key($submission->data)]['name'];
- $submissionSurveyAnswers = new stdClass();
- $submissionSurveyAnswers->Question = $componentName;
- $submissionSurveyAnswers->Answer = $surveyanswer[0];
- $SumbissionQA[] = $submissionSurveyAnswers;
- next($submission->data);
- }
- $submissionObj->SubmissionData =$SumbissionQA;
- $Surveys[]=$submissionObj;
- }
- $returningJSON->Surveys = $Surveys;
- return drupal_json_output($returningJSON);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement