public static function fromScratch($lower_difficulty, $higher_difficulty, $number_tested, $vConcept, $vQuiz)
{
$db = Zend_Registry::get("db");
$sql = "INSERT INTO concepts_tested(ctest_id,lower_difficulty,higher_difficulty,number_tested,conceptsconcept_name,quizquiz_id) VALUES(NULL, " . $db->quote($lower_difficulty) . "," . $db->quote($higher_difficulty) . "," . $db->quote($number_tested) . "," . $db->quote($vConcept->getID()) . "," . $db->quote($vQuiz->getID()) . ")";
$db->query($sql);
//Now find the appropriate entry in the database
// A safe (default) assumption for this is a query that looks for everything you just put in.
$sql = "SELECT ctest_id FROM concepts_tested WHERE lower_difficulty=" . $db->quote($lower_difficulty) . " AND higher_difficulty=" . $db->quote($higher_difficulty) . " AND number_tested=" . $db->quote($number_tested) . " AND conceptsconcept_name=" . $db->quote($conceptsconcept_name) . " AND quizquiz_id=" . $db->quote($quizquiz_id);
$result = $db->query($sql);
$row = $result->fetch();
if ($row['ctest_id'] != null) {
return Model_Quiz_TestedConcept::fromID($row['ctest_id']);
} else {
return null;
//Something didn't happen
}
}
public function getTestedConcepts()
{
$db = Zend_Registry::get("db");
$vReturn = array();
$sql = "SELECT * FROM concepts_tested WHERE quizquiz_id=" . $db->quote($this->quiz_id);
//echo "SQL: $sql";
$result = $db->query($sql);
$rows = $result->fetchAll();
foreach ($rows as $row) {
$vReturn[] = Model_Quiz_TestedConcept::fromID($row['ctest_id']);
}
return $vReturn;
}
function addTestedConcept($quiz_ob, $concept_id, $nb_questions, $from = 1, $to = 1)
{
$vConcept = Model_Quiz_Concept::fromID($concept_id);
return Model_Quiz_TestedConcept::fromScratch($from, $to, $nb_questions, $vConcept, $quiz_ob);
}
/**
* Deletes a Concept
* Expects parameter [concept_id] to be passed
*
* @return void
* @author Ben Evans
*/
public function deleteconceptAction()
{
$concept_id = $this->_getParam("concept_id");
if (!isset($concept_id)) {
throw new Exception("Count not delete concept. No identifier passed", 3000);
}
$vTestedConcept = Model_Quiz_TestedConcept::fromID($concept_id);
if ($vTestedConcept == null) {
throw new Exception("ID passed did not correspond to a valid TestedConcept");
}
$vQuiz = $vTestedConcept->getQuiz();
//For the return page
$vTestedConcept->remove();
//Redirect to the concept page
$params = array('id' => $vQuiz->getID());
$this->_helper->redirector("showconcepts", "admin", null, $params);
}
/**
* Populates the form from a TestedConcept Passed
* @param Model_Quiz_TestedConcept $concept
*/
public function populateFromConcept(Model_Quiz_TestedConcept $concept)
{
$info = array("number_of_questions" => $concept->getNumber_tested(), "concept_id" => $concept->getConcept()->getID(), "difficulty_from" => $concept->getLower_difficulty(), "difficulty_to" => $concept->getHigher_difficulty());
$this->populate($info);
}
