public static function fromID($vID)
{
//Start by making sure the appropriate record exists
$db = Zend_Registry::get("db");
$result = $db->query("SELECT * FROM generated_questions where generated_id=" . $db->quote($vID));
$row = $result->fetch();
if ($row['generated_id'] == null) {
return null;
//No corresponding record found in database
}
//Assuming we have the appropriate records
$vReturn = new Model_Quiz_GeneratedQuestion();
$vReturn->generated_id = $row['generated_id'];
$vReturn->instructions = $row['instructions'];
$vReturn->question_data = $row['question_data'];
$vReturn->correct_answer = $row['correct_answer'];
$vReturn->alt_ans_1 = $row['alt_ans_1'];
$vReturn->alt_desc_1 = $row['alt_desc_1'];
$vReturn->alt_ans_2 = $row['alt_ans_2'];
$vReturn->alt_desc_2 = $row['alt_desc_2'];
$vReturn->alt_ans_3 = $row['alt_ans_3'];
$vReturn->alt_desc_3 = $row['alt_desc_3'];
$vReturn->question_basequestion_id = Model_Quiz_QuestionBase::fromID($row['question_basequestion_id']);
return $vReturn;
//Return the result
}
/**
* Generates a bank of questions for a question identifier provided
* Expects parameters [question_id], [questions_to_generate_num], [max_errors_num]
*/
public function generatequestionbankAction()
{
// Check to see that all the parameters get passed
$parameters = $this->_getAllParams();
$check_errors = array();
foreach (array("question_id" => "Question Identifier", "questions_to_generate_num" => "Number of Questions to Generate", "max_errors_num" => "Maximum number of Errors") as $check_key => $check_text) {
if (!array_key_exists($check_key, $parameters) || !is_numeric($parameters[$check_key]) || $parameters[$check_key] < 0) {
$check_errors[] = $check_text . " [" . $check_key . "] was not passed, or not a positive number.";
}
}
if (sizeof($check_errors) > 0) {
cronlog("The following validation errors occured:");
foreach ($check_errors as $ce) {
cronlog($ce);
}
exit;
}
//cronlog('ok so far');
$question_base_id = intval($parameters['question_id']);
$number_of_questions = intval($parameters['questions_to_generate_num']);
$maximum_errors = intval($parameters['max_errors_num']);
cronlog("Generating {$number_of_questions} questions from Question Base Identifier {$question_base_id} ; Maximum Error threshold is {$maximum_errors}");
$vQuestionBase = Model_Quiz_QuestionBase::fromID($question_base_id);
if (is_null($vQuestionBase)) {
throw new Exception("The question base identifier passed was invalid");
}
$question_counter = 0;
$error_counter = 0;
My_Logger::log(__METHOD__ . " number_of_questions: {$number_of_questions}");
My_Logger::log(__METHOD__ . " maximum_errors: {$maximum_errors}");
while ($question_counter <= $number_of_questions && $error_counter <= $maximum_errors) {
My_Logger::log(__METHOD__ . " question_counter: {$question_counter}");
My_Logger::log(__METHOD__ . " error_counter: {$error_counter}");
try {
$vGeneratedQuestion = Model_Quiz_GeneratedQuestion::generateNewFromQuestionBase($vQuestionBase);
} catch (Exception $e) {
cronlog("Could not generate question. " . $e->getMessage());
echo Model_Shell_Debug::getInstance()->getLog();
$error_counter++;
}
}
cronlog("Finished. Generated " . $question_counter . " questions; " . $error_counter . " errornous questions generated (but discarded)");
}
public static function fromID($vID)
{
//Start by making sure the appropriate record exists
$db = Zend_Registry::get("db");
$result = $db->query("SELECT * FROM question_attempt where attempt_id='" . addslashes($vID) . "'");
$row = $result->fetch();
if ($row['attempt_id'] == null) {
return null;
//No corresponding record found in database
}
//Assuming we have the appropriate records
$vReturn = new Model_Quiz_QuestionAttempt();
$vReturn->attempt_id = $row['attempt_id'];
$vReturn->initial_result = $row['initial_result'];
$vReturn->secondary_result = $row['secondary_result'];
$vReturn->question_basequestion_id = Model_Quiz_QuestionBase::fromID($row['question_basequestion_id']);
$vReturn->attempted_on = strtotime($row['attempted_on']);
$vReturn->time_started = strtotime($row['time_started']);
$vReturn->time_finished = strtotime($row['time_finished']);
$vReturn->quiz_attemptquiz_attempt_id = Model_Quiz_QuizAttempt::fromID($row['quiz_attemptquiz_attempt_id']);
$vReturn->generated_questionsgenerated_id = Model_Quiz_GeneratedQuestion::fromID($row['generated_questionsgenerated_id']);
return $vReturn;
//Return the result
}
public static function getAll()
{
$db = Zend_Registry::get("db");
$vReturn = array();
$result = $db->query("SELECT * FROM question_base");
$rows = $result->fetchAll();
foreach ($rows as $row) {
$vReturn[] = Model_Quiz_QuestionBase::fromID($row['question_id']);
}
return $vReturn;
}
/**
* Shows the Question Analysis
*/
public function questionanalysisAction()
{
$file_id = $this->_getParam("file");
$this->view->file = $file_id;
// Pointless line to load all the other functions in the GeneratedQuestion File
// TODO: Fix this PLEASE
$tmp = new Model_Quiz_GeneratedQuestion();
// Get All Question Bases
$this->view->all_question_bases = Model_Quiz_QuestionBase::getAll();
if (is_null($file_id) || !isset($file_id)) {
$default_question_base = current($this->view->all_question_bases);
$file_id = $default_question_base->getID();
}
if (!is_null($file_id) && isset($file_id)) {
$question_base = Model_Quiz_QuestionBase::fromID($file_id);
$attempts = Model_Quiz_QuestionAttempt::getAllFromQuestionBase($question_base);
// Generate a sample question
$config = new Zend_Config_Ini(APPLICATION_PATH . "/configs/application.ini", APPLICATION_ENV);
$path = $config->xml->import_path;
//$sample_question = new Model_Shell_GenericQuestion(APPLICATION_PATH . "/../xml/questions/" . $question_base->getXml());
$sample_question = new Model_Shell_GenericQuestion($path . '/' . $question_base->getXml());
$this->view->question_base = $question_base;
$this->view->attempts = $attempts;
$this->view->sample_question = $sample_question;
}
}
public function getAttemptedQuestionBases($vConcept, $vDifficulty)
{
$db = Zend_Registry::get("db");
$vReturn = array();
$sql = "SELECT DISTINCT qb.question_id FROM question_attempt qa, question_base qb, question_concepts qc WHERE qc.conceptsconcept_name=" . $db->quote($vConcept->getID()) . " AND qb.difficulty=" . $db->quote($vDifficulty) . " AND qa.question_basequestion_id=qb.question_id AND qc.question_basequestion_id=qb.question_id AND qa.quiz_attemptquiz_attempt_id=" . $db->quote($this->quiz_attempt_id);
//echo $sql;
$result = $db->query($sql);
$rows = $result->fetchAll();
foreach ($rows as $row) {
$vReturn[] = Model_Quiz_QuestionBase::fromID($row['question_id']);
}
return $vReturn;
}
