exit; } //Get the XML file out and start importing them into our database. //TODO: See question_import.php 287-289. $qti_import = new QTIImport($import_path); $qids = $qti_import->importQuestions($attributes); //import test $tid = $qti_import->importTest(); //associate question and tests foreach ($qids as $order => $qid) { if (isset($qti_import->weights[$order])) { $weight = round($qti_import->weights[$order]); } else { $weight = 0; } $new_order = $order + 1; // $sql = "INSERT INTO " . TABLE_PREFIX . "tests_questions_assoc" . // "(test_id, question_id, weight, ordering, required) " . // "VALUES ($tid, $qid, $weight, $new_order, 0)"; // $result = mysql_query($sql, $db); $testsQuestionsAssocDAO = new TestsQuestionsAssocDAO(); $testsQuestionsAssocDAO->Create($tid, $qid, $weight, $new_order); } //debug('imported test'); if (!$msg->containsErrors()) { $msg->addFeedback('IMPORT_SUCCEEDED'); } //clear directory FileUtility::clr_dir(TR_CONTENT_DIR . 'import/' . $_course_id); header('Location: index.php?_course_id=' . $_course_id); exit;
/* Inclusive Design Institute */ /* */ /* This program is free software. You can redistribute it and/or */ /* modify it under the terms of the GNU General Public License */ /* as published by the Free Software Foundation. */ /************************************************************************/ $page = 'tests'; define('TR_INCLUDE_PATH', '../include/'); require_once TR_INCLUDE_PATH . 'vitals.inc.php'; require_once TR_INCLUDE_PATH . 'classes/Utility.class.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsAssocDAO.class.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsDAO.class.php'; global $_course_id; Utility::authenticate(TR_PRIV_ISAUTHOR_OF_CURRENT_COURSE); $testsQuestionsDAO = new TestsQuestionsDAO(); $testsQuestionsAssocDAO = new TestsQuestionsAssocDAO(); $tid = intval($_POST['tid']); $_pages['tests/questions.php?tid=' . $tid . '&_course_id=' . $_course_id]['title_var'] = 'questions'; $_pages['tests/questions.php?tid=' . $tid . '&_course_id=' . $_course_id]['parent'] = 'tests/index.php'; $_pages['tests/questions.php?tid=' . $tid . '&_course_id=' . $_course_id]['children'] = array('tests/add_test_questions.php'); $_pages['tests/add_test_questions.php']['title_var'] = 'add_questions'; $_pages['tests/add_test_questions.php']['parent'] = 'tests/questions.php?tid=' . $tid . '&_course_id=' . $_course_id; $_pages['tests/add_test_questions_confirm.php']['title_var'] = 'add_questions'; $_pages['tests/add_test_questions_confirm.php']['parent'] = 'tests/questions.php?tid=' . $tid . '&_course_id=' . $_course_id; if (isset($_POST['cancel'])) { $msg->addFeedback('CANCELLED'); header('Location: questions.php?tid=' . $tid . '&_course_id=' . $_course_id); exit; } else { if (isset($_POST['submit_yes'])) { //get order
require_once TR_INCLUDE_PATH . 'classes/Utility.class.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/TestsDAO.class.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsAssocDAO.class.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/ContentTestsAssocDAO.class.php'; global $_course_id; Utility::authenticate(TR_PRIV_ISAUTHOR_OF_CURRENT_COURSE); $testsDAO = new TestsDAO(); if (isset($_POST['submit_no'])) { $msg->addFeedback('CANCELLED'); header('Location: index.php?_course_id=' . $_course_id); exit; } else { if (isset($_POST['submit_yes'])) { $tid = intval($_POST['tid']); if ($testsDAO->Delete($tid)) { $testsQuestionsAssocDAO = new TestsQuestionsAssocDAO(); $testsQuestionsAssocDAO->DeleteByTestID($tid); //delete test content association as well $contentTestsAssocDAO = new ContentTestsAssocDAO(); $contentTestsAssocDAO->DeleteByTestID($tid); } $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY'); header('Location: ' . TR_BASE_HREF . 'tests/index.php?_course_id=' . $_course_id); exit; } } /* else: */ require_once TR_INCLUDE_PATH . 'header.inc.php'; $_GET['tid'] = intval($_GET['tid']); $row = $testsDAO->get($_GET['tid']); unset($hidden_vars);
/* Copyright (c) 2010 */ /* Inclusive Design Institute */ /* */ /* This program is free software. You can redistribute it and/or */ /* modify it under the terms of the GNU General Public License */ /* as published by the Free Software Foundation. */ /************************************************************************/ define('TR_INCLUDE_PATH', '../include/'); require_once TR_INCLUDE_PATH . 'vitals.inc.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsDAO.class.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsAssocDAO.class.php'; require_once TR_INCLUDE_PATH . 'classes/Utility.class.php'; global $_course_id; Utility::authenticate(TR_PRIV_ISAUTHOR_OF_CURRENT_COURSE); $testsQuestionsDAO = new TestsQuestionsDAO(); $testsQuestionsAssocDAO = new TestsQuestionsAssocDAO(); $tid = intval($_REQUEST['tid']); if (isset($_POST['submit_no'])) { $msg->addFeedback('CANCELLED'); header('Location: question_db.php?_course_id=' . $_course_id); exit; } else { if (isset($_POST['submit_yes'])) { $_POST['qid'] = explode(',', $_POST['qid']); foreach ($_POST['qid'] as $id) { $id = intval($id); if ($testsQuestionsDAO->Delete($id)) { $testsQuestionsAssocDAO->DeleteByQuestionID($id); } } $msg->addFeedback('QUESTION_DELETED');
$page = 'tests'; define('TR_INCLUDE_PATH', '../include/'); require_once TR_INCLUDE_PATH . 'vitals.inc.php'; require_once TR_INCLUDE_PATH . 'classes/Utility.class.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsAssocDAO.class.php'; global $_course_id; Utility::authenticate(TR_PRIV_ISAUTHOR_OF_CURRENT_COURSE); $tid = intval($_REQUEST['tid']); $qid = intval($_REQUEST['qid']); if (isset($_POST['submit_no'])) { $msg->addFeedback('CANCELLED'); header('Location: questions.php?tid=' . $tid . SEP . '_course_id=' . $_course_id); exit; } else { if (isset($_POST['submit_yes'])) { $testsQuestionsAssocDAO = new TestsQuestionsAssocDAO(); $testsQuestionsAssocDAO->Delete($tid, $qid); $msg->addFeedback('QUESTION_REMOVED'); header('Location: questions.php?tid=' . $tid . SEP . '_course_id=' . $_course_id); exit; } } /* else: */ $_pages['tests/questions.php?tid=' . $_GET['tid']]['title_var'] = 'questions'; $_pages['tests/questions.php?tid=' . $_GET['tid']]['parent'] = 'tests/index.php'; $_pages['tests/questions.php?tid=' . $_GET['tid']]['children'] = array('tests/add_test_questions.php?tid=' . $_GET['tid']); $_pages['tests/add_test_questions.php?tid=' . $_GET['tid']]['title_var'] = 'add_questions'; $_pages['tests/add_test_questions.php?tid=' . $_GET['tid']]['parent'] = 'tests/questions.php?tid=' . $_GET['tid']; $_pages['tests/question_remove.php']['title_var'] = 'remove_question'; $_pages['tests/question_remove.php']['parent'] = 'tests/questions.php?tid=' . $_GET['tid']; require_once TR_INCLUDE_PATH . 'header.inc.php';
/** * Export test * @param int test id * @param string the test title * @param ref [OPTIONAL] zip object reference * @param array [OPTIONAL] list of already added files. */ function test_qti_export($tid, $test_title = '', $zipfile = null) { global $_course_id; require_once TR_INCLUDE_PATH . 'classes/DAO/CoursesDAO.class.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/TestsDAO.class.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsAssocDAO.class.php'; require_once TR_INCLUDE_PATH . 'classes/zipfile.class.php'; // for zipfile require_once TR_INCLUDE_PATH . 'classes/XML/XML_HTMLSax/XML_HTMLSax.php'; // for XML_HTMLSax require_once TR_INCLUDE_PATH . 'lib/html_resource_parser.inc.php'; // for get_html_resources() global $savant, $db, $languageManager, $test_zipped_files, $test_files, $use_cc; global $course_id; $coursesDAO = new CoursesDAO(); $course_row = $coursesDAO->get($_course_id); $course_language = $course_row['primary_language']; $courseLanguage =& $languageManager->getLanguage($course_language); $course_language_charset = $courseLanguage->getCharacterSet(); $imported_files; $zipflag = false; if ($zipfile == null) { $zipflag = true; } if ($test_zipped_files == null) { $test_zipped_files = array(); } if ($zipflag) { $zipfile = new zipfile(); $zipfile->create_dir('resources/'); // for all the dependency files } $resources = array(); $dependencies = array(); // don't want to sort it, i want the same order out. // asort($question_ids); //TODO: Merge the following 2 sqls together. //Randomized or not, export all the questions that are associated with it. // $sql = "SELECT TQ.question_id, TQA.weight FROM ".TABLE_PREFIX."tests_questions TQ INNER JOIN ".TABLE_PREFIX."tests_questions_assoc TQA USING (question_id) WHERE TQ.course_id=$_SESSION[course_id] AND TQA.test_id=$tid ORDER BY TQA.ordering, TQA.question_id"; // $result = mysql_query($sql, $db); // $question_ids = array(); // // if (is_array($question_rows)){ // foreach ($question_rows as $question_row) $question_ids[] = $question_row['question_id']; // } // // //No questions in the test // if (sizeof($question_ids)==0){ // return; // } // // $question_ids_delim = implode(',',$question_ids); // // //$sql = "SELECT * FROM ".TABLE_PREFIX."tests_questions WHERE course_id=$_SESSION[course_id] AND question_id IN($question_ids_delim)"; // $sql = "SELECT TQ.*, TQA.weight, TQA.test_id FROM ".TABLE_PREFIX."tests_questions TQ INNER JOIN ".TABLE_PREFIX."tests_questions_assoc TQA USING (question_id) WHERE TQA.test_id=$tid AND TQ.question_id IN($question_ids_delim) ORDER BY TQA.ordering, TQA.question_id"; // // $result = mysql_query($sql, $db); // while ($row = mysql_fetch_assoc($result)) { $testsQuestionsAssocDAO = new TestsQuestionsAssocDAO(); $question_rows = $testsQuestionsAssocDAO->getByTestID($tid); if (!is_array($question_rows)) { return false; } else { foreach ($question_rows as $row) { $obj = TestQuestions::getQuestion($row['type']); $local_xml = ''; $local_xml = $obj->exportQTI($row, $course_language_charset, '1.2.1'); $local_dependencies = array(); $text_blob = implode(' ', $row); $local_dependencies = get_html_resources($text_blob); $dependencies = array_merge($dependencies, $local_dependencies); $xml = $xml . "\n\n" . $local_xml; } } //files that are found inside the test; used by print_organization(), to add all test files into QTI/ folder. $test_files = $dependencies; $resources[] = array('href' => 'tests_' . $tid . '.xml', 'dependencies' => array_keys($dependencies)); $xml = trim($xml); //get test title // $sql = "SELECT title FROM ".TABLE_PREFIX."tests WHERE test_id = $tid"; // $result = mysql_query($sql, $db); // $row = mysql_fetch_array($result); $testsDAO = new TestsDAO(); $row = $testsDAO->get($tid); //TODO: wrap around xml now $savant->assign('xml_content', $xml); $savant->assign('title', htmlspecialchars($row['title'], ENT_QUOTES, 'UTF-8')); $savant->assign('num_takes', $row['num_takes']); $savant->assign('use_cc', $use_cc); $xml = $savant->fetch('tests/test_questions/wrapper.tmpl.php'); $xml_filename = 'tests_' . $tid . '.xml'; if (!$use_cc) { $zipfile->add_file($xml, $xml_filename); } else { $zipfile->add_file($xml, 'QTI/' . $xml_filename); } // add any dependency files: if (!$use_cc) { foreach ($dependencies as $resource => $resource_server_path) { //add this file in if it's not already in the zip package if (!in_array($resource_server_path, $test_zipped_files)) { $zipfile->add_file(@file_get_contents($resource_server_path), 'resources/' . $resource, filemtime($resource_server_path)); $test_zipped_files[] = $resource_server_path; } } } if ($zipflag) { // construct the manifest xml $savant->assign('resources', $resources); $savant->assign('dependencies', array_keys($dependencies)); $savant->assign('encoding', $course_language_charset); $savant->assign('title', $test_title); $savant->assign('xml_filename', $xml_filename); $manifest_xml = $savant->fetch('tests/test_questions/manifest_qti_1p2.tmpl.php'); $zipfile->add_file($manifest_xml, 'imsmanifest.xml'); $zipfile->close(); $filename = str_replace(array(' ', ':'), '_', $course_row['title'] . '-' . $test_title . '-' . date('Ymd')); $zipfile->send_file($filename); exit; } $return_array[$xml_filename] = array_keys($dependencies); return $return_array; //done }
/* Inclusive Design Institute */ /* */ /* This program is free software. You can redistribute it and/or */ /* modify it under the terms of the GNU General Public License */ /* as published by the Free Software Foundation. */ /************************************************************************/ define('TR_INCLUDE_PATH', '../include/'); require_once TR_INCLUDE_PATH . 'vitals.inc.php'; require_once TR_INCLUDE_PATH . 'classes/testQuestions.class.php'; require_once TR_INCLUDE_PATH . 'classes/Utility.class.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/TestsDAO.class.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsAssocDAO.class.php'; global $_course_id; //Utility::authenticate(TR_PRIV_ISAUTHOR_OF_CURRENT_COURSE); $testsDAO = new TestsDAO(); $testsQuestionsAssocDAO = new TestsQuestionsAssocDAO(); $_letters = array(_AT('a'), _AT('b'), _AT('c'), _AT('d'), _AT('e'), _AT('f'), _AT('g'), _AT('h'), _AT('i'), _AT('j')); if ($_POST['back']) { header('Location: index.php?_course_id=' . $_course_id); exit; } if (defined('TR_FORCE_GET_FILE') && TR_FORCE_GET_FILE) { $content_base_href = 'get.php/'; } else { $content_base_href = 'content/' . $_SESSION['course_id'] . '/'; } require_once TR_INCLUDE_PATH . 'header.inc.php'; $tid = intval($_GET['tid']); // check that the test_id is correct if (!($test_row = $testsDAO->get($tid))) { $msg->printErrors('ITEM_NOT_FOUND');
/* modify it under the terms of the GNU General Public License */ /* as published by the Free Software Foundation. */ /************************************************************************/ $page = 'tests'; define('TR_INCLUDE_PATH', '../include/'); require_once TR_INCLUDE_PATH . 'vitals.inc.php'; require_once TR_INCLUDE_PATH . 'classes/testQuestions.class.php'; require_once TR_INCLUDE_PATH . 'classes/Utility.class.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/TestsDAO.class.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsCategoriesDAO.class.php'; require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsAssocDAO.class.php'; global $_course_id; Utility::authenticate(TR_PRIV_ISAUTHOR_OF_CURRENT_COURSE); $testsDAO = new TestsDAO(); $testsQuestionsCategoriesDAO = new TestsQuestionsCategoriesDAO(); $testsQuestionsAssocDAO = new TestsQuestionsAssocDAO(); $_pages['tests/questions.php']['title_var'] = 'questions'; $_pages['tests/questions.php']['parent'] = 'tests/index.php'; $_pages['tests/questions.php']['children'] = array('tests/add_test_questions.php?tid=' . $_GET['tid'] . '&_course_id=' . $_course_id); $_pages['tests/add_test_questions.php?tid=' . $_GET['tid'] . '&_course_id=' . $_course_id]['title_var'] = 'add_questions'; $_pages['tests/add_test_questions.php?tid=' . $_GET['tid'] . '&_course_id=' . $_course_id]['parent'] = 'tests/questions.php?tid=' . $_GET['tid'] . '&_course_id=' . $_course_id; $_pages['tests/questions.php']['guide'] = 'instructor/?p=add_questions.php'; $tid = intval($_REQUEST['tid']); if (isset($_POST['submit'])) { $count = 1; foreach ($_POST['weight'] as $qid => $weight) { $qid = intval($qid); $weight = intval($weight); $orders = $_POST['ordering']; asort($orders); $orders = array_keys($orders);