<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    $sql = "SELECT a.id question_id, a.question_order, a.question_category, a.question_text,
                   b.id choice_id, b.choice_text, b.choice_score,
                   c.choice_id selected_choice_id,
                   CASE WHEN c.submit_date IS NOT NULL THEN 1 ELSE 0 END locked_choice
              FROM xxytysport.cyber_assessment_question a,
                   xxytysport.cyber_assessment_choices b,
                   xxytysport.cyber_assessment_response c
             WHERE a.id = b.question_id
               AND NVL(a.inactive_flag, 'N') = 'N'
               AND NVL(b.inactive_flag, 'N') = 'N'
               AND a.id = c.question_id(+)
               --AND b.id = c.choice_id(+)
               AND UPPER(c.user_id(+)) = UPPER(:user_id)
             ORDER BY a.question_order, round(dbms_random.value(0, 4))";

    $sqlarr = oci_parse($dbcon , $sql);
    oci_bind_by_name($sqlarr, ':user_id', $data->USER_ID);
    $r = oci_execute($sqlarr);
    
    if (!$r) {
        $e = oci_error($sqlarr);
        $errorMsg = json_encode($e['message']);
    }
    oci_fetch_all($sqlarr, $rows, null, null, OCI_FETCHSTATEMENT_BY_ROW);

    $map = [];
    foreach ($rows as $v) {
        $key = $v['QUESTION_ID'];
        if (!isset($map[$key])) {
            $map[$key] = [
                'QUESTION_ID' => $v['QUESTION_ID'],
                'QUESTION_ORDER' => $v['QUESTION_ORDER'],
                'QUESTION_CATEGORY' => $v['QUESTION_CATEGORY'],
                'QUESTION_TEXT' => $v['QUESTION_TEXT'],
                'CHOICE' => [],
                'SELECTED_CHOICE_ID' => $v['SELECTED_CHOICE_ID'],
                'LOCKED_CHOICE' => $v['LOCKED_CHOICE'],
            ];
        }

        $map[$key]['CHOICE'][] = [
          'CHOICE_ID' => $v['CHOICE_ID'],
          'CHOICE_TEXT' => $v['CHOICE_TEXT'],
          'CHOICE_SCORE' => $v['CHOICE_SCORE']
        ];
    }
    
    print json_encode($map);
?>