PHP quiz_report_index_by_keys函数代码示例

 public function test_quiz_report_index_by_keys()
 {
     $datum = array();
     $object = new stdClass();
     $object->qid = 3;
     $object->aid = 101;
     $object->response = '';
     $object->grade = 3;
     $datum[] = $object;
     $indexed = quiz_report_index_by_keys($datum, array('aid', 'qid'));
     $this->assertEquals($indexed[101][3]->qid, 3);
     $this->assertEquals($indexed[101][3]->aid, 101);
     $this->assertEquals($indexed[101][3]->response, '');
     $this->assertEquals($indexed[101][3]->grade, 3);
     $indexed = quiz_report_index_by_keys($datum, array('aid', 'qid'), false);
     $this->assertEquals($indexed[101][3][0]->qid, 3);
     $this->assertEquals($indexed[101][3][0]->aid, 101);
     $this->assertEquals($indexed[101][3][0]->response, '');
     $this->assertEquals($indexed[101][3][0]->grade, 3);
 }

/**
 * Takes an array of objects and constructs a multidimensional array keyed by
 * the keys it finds on the object.
 * @param array $datum an array of objects with properties on the object
 * including the keys passed as the next param.
 * @param array $keys Array of strings with the names of the properties on the
 * objects in datum that you want to index the multidimensional array by.
 * @param bool $keysunique If there is not only one object for each
 * combination of keys you are using you should set $keysunique to true.
 * Otherwise all the object will be added to a zero based array. So the array
 * returned will have count($keys) + 1 indexs.
 * @return array multidimensional array properly indexed.
 */
function quiz_report_index_by_keys($datum, $keys, $keysunique = true) {
    if (!$datum) {
        return array();
    }
    $key = array_shift($keys);
    $datumkeyed = array();
    foreach ($datum as $data) {
        if ($keys || !$keysunique) {
            $datumkeyed[$data->{$key}][]= $data;
        } else {
            $datumkeyed[$data->{$key}]= $data;
        }
    }
    if ($keys) {
        foreach ($datumkeyed as $datakey => $datakeyed) {
            $datumkeyed[$datakey] = quiz_report_index_by_keys($datakeyed, $keys, $keysunique);
        }
    }
    return $datumkeyed;
}

 function quiz_questions_stats($quiz, $currentgroup, $nostudentsingroup, $useallattempts, $groupstudents, $questions)
 {
     global $DB;
     $timemodified = time() - QUIZ_REPORT_TIME_TO_CACHE_STATS;
     $params = array('quizid' => $quiz->id, 'groupid' => (int) $currentgroup, 'allattempts' => $useallattempts, 'timemodified' => $timemodified);
     if (!($quizstats = $DB->get_record_select('quiz_statistics', 'quizid = :quizid  AND groupid = :groupid AND allattempts = :allattempts AND timemodified > :timemodified', $params, '*', true))) {
         list($s, $usingattemptsstring, $quizstats, $qstats) = $this->quiz_stats($nostudentsingroup, $quiz->id, $currentgroup, $groupstudents, $questions, $useallattempts);
         if ($s) {
             $toinsert = (object) ((array) $quizstats + $params);
             $toinsert->timemodified = time();
             $quizstats->id = $DB->insert_record('quiz_statistics', $toinsert);
             foreach ($qstats->questions as $question) {
                 $question->_stats->quizstatisticsid = $quizstats->id;
                 $DB->insert_record('quiz_question_statistics', $question->_stats, false, true);
             }
             foreach ($qstats->subquestions as $subquestion) {
                 $subquestion->_stats->quizstatisticsid = $quizstats->id;
                 $DB->insert_record('quiz_question_statistics', $subquestion->_stats, false, true);
             }
             foreach ($qstats->responses as $response) {
                 $response->quizstatisticsid = $quizstats->id;
                 $DB->insert_record('quiz_question_response_stats', $response, false);
             }
         }
         if ($qstats) {
             $questions = $qstats->questions;
             $subquestions = $qstats->subquestions;
         } else {
             $questions = array();
             $subquestions = array();
         }
     } else {
         //use cached results
         if ($useallattempts) {
             $usingattemptsstring = get_string('allattempts', 'quiz_statistics');
             $s = $quizstats->allattemptscount;
         } else {
             $usingattemptsstring = get_string('firstattempts', 'quiz_statistics');
             $s = $quizstats->firstattemptscount;
         }
         $subquestions = array();
         $questionstats = $DB->get_records('quiz_question_statistics', array('quizstatisticsid' => $quizstats->id), 'subquestion ASC');
         $questionstats = quiz_report_index_by_keys($questionstats, array('subquestion', 'questionid'));
         if (1 < count($questionstats)) {
             list($mainquestionstats, $subquestionstats) = $questionstats;
             $subqstofetch = array_keys($subquestionstats);
             $subquestions = question_load_questions($subqstofetch);
             foreach (array_keys($subquestions) as $subqid) {
                 $subquestions[$subqid]->_stats = $subquestionstats[$subqid];
             }
         } elseif (count($questionstats)) {
             $mainquestionstats = $questionstats[0];
         }
         if (count($questionstats)) {
             foreach (array_keys($questions) as $qid) {
                 $questions[$qid]->_stats = $mainquestionstats[$qid];
             }
         }
     }
     return array($quizstats, $questions, $subquestions, $s, $usingattemptsstring);
 }

    function check_overall_grades($quiz, $userids=array(), $attemptids=array()) {
        global $DB;
        //recalculate $attempt->sumgrade
        //already updated in regrade_question_in_attempt
        $sql = "UPDATE {quiz_attempts} SET sumgrades= " .
                    "COALESCE((SELECT SUM(qs.grade) FROM {question_sessions} qns, {question_states} qs " .
                        "WHERE qns.newgraded = qs.id AND qns.attemptid = {quiz_attempts}.uniqueid ), 0) WHERE ";
        $attemptsql='';
        if (!$attemptids) {
            if ($userids) {
                list($usql, $params) = $DB->get_in_or_equal($userids);
                $attemptsql .= "{quiz_attempts}.userid $usql AND ";
            } else {
                $params = array();
            }
            $attemptsql .= "{quiz_attempts}.quiz =? AND preview = 0";
            $params[] = $quiz->id;
        } else {
            list($asql, $params) = $DB->get_in_or_equal($attemptids);
            $attemptsql .= "{quiz_attempts}.uniqueid $asql";
        }
        $sql .= $attemptsql;
        if (!$DB->execute($sql, $params)) {
            print_error('err_failedtorecalculateattemptgrades', 'quiz_overview');
        }

        // Update the overall quiz grades
        if ($attemptids) {
            //make sure we fetch all attempts for users to calculate grade.
            //not just those that have changed.
            $sql = "SELECT qa2.* FROM {quiz_attempts} qa2 WHERE " .
                    "qa2.userid IN (SELECT DISTINCT userid FROM {quiz_attempts} WHERE $attemptsql) " .
                    "AND qa2.timefinish > 0";
        } else {
            $sql = "SELECT * FROM {quiz_attempts} WHERE $attemptsql AND timefinish > 0";
        }
        if ($attempts = $DB->get_records_sql($sql, $params)) {
            $attemptsbyuser = quiz_report_index_by_keys($attempts, array('userid', 'id'));
            foreach($attemptsbyuser as $userid => $attemptsforuser) {
                quiz_save_best_grade($quiz, $userid, $attemptsforuser);
            }
        }
    }

function quiz_get_regraded_qs($attemptidssql, $limitfrom = 0, $limitnum = 0)
{
    global $CFG, $DB;
    if ($attemptidssql && is_array($attemptidssql)) {
        list($asql, $params) = $DB->get_in_or_equal($attemptidssql);
        $regradedqsql = "SELECT qqr.* FROM " . "{quiz_question_regrade} qqr " . "WHERE qqr.attemptid {$asql}";
        $regradedqs = $DB->get_records_sql($regradedqsql, $params, $limitfrom, $limitnum);
    } else {
        if ($attemptidssql && is_object($attemptidssql)) {
            $regradedqsql = "SELECT qqr.* FROM " . $attemptidssql->from . ", " . "{quiz_question_regrade} qqr " . "WHERE qqr.attemptid = qa.uniqueid AND " . $attemptidssql->where;
            $regradedqs = $DB->get_records_sql($regradedqsql, $attemptidssql->params, $limitfrom, $limitnum);
        } else {
            return array();
        }
    }
    return quiz_report_index_by_keys($regradedqs, array('attemptid', 'questionid'));
}

 /**
  * Get all the questions in all the attempts being displayed that need regrading.
  * @return array A two dimensional array $questionusageid => $slot => $regradeinfo.
  */
 protected function get_regraded_questions()
 {
     global $DB;
     $qubaids = $this->get_qubaids_condition();
     $regradedqs = $DB->get_records_select('quiz_overview_regrades', 'questionusageid ' . $qubaids->usage_id_in(), $qubaids->usage_id_in_params());
     return quiz_report_index_by_keys($regradedqs, array('questionusageid', 'slot'));
 }