@@ -187,6 +187,7 @@ discard block |
||
187 | 187 | * Reads answer information from the data base ordered by parameter |
188 | 188 | * @param string Field we want to order by |
189 | 189 | * @param string DESC or ASC |
190 | + * @param string $field |
|
190 | 191 | * @author Frederic Vauthier |
191 | 192 | */ |
192 | 193 | public function readOrderedBy($field, $order='ASC') |
@@ -308,6 +309,7 @@ discard block |
||
308 | 309 | * returns the question ID of the destination question |
309 | 310 | * |
310 | 311 | * @author Julio Montoya |
312 | + * @param integer $id |
|
311 | 313 | * @return integer - the question ID |
312 | 314 | */ |
313 | 315 | public function selectDestination($id) |
@@ -329,6 +331,7 @@ discard block |
||
329 | 331 | |
330 | 332 | /** |
331 | 333 | * return array answer by id else return a bool |
334 | + * @param integer $auto_id |
|
332 | 335 | */ |
333 | 336 | public function selectAnswerByAutoId($auto_id) |
334 | 337 | { |
@@ -467,6 +470,7 @@ discard block |
||
467 | 470 | * |
468 | 471 | * @author Olivier Brouckaert |
469 | 472 | * @param - integer $id - answer ID |
473 | + * @param integer $id |
|
470 | 474 | * @return integer - answer weighting |
471 | 475 | */ |
472 | 476 | public function selectWeighting($id) |
@@ -491,6 +495,7 @@ discard block |
||
491 | 495 | * |
492 | 496 | * @author Olivier Brouckaert |
493 | 497 | * @param integer Answer ID |
498 | + * @param integer $id |
|
494 | 499 | * @return integer Answer position |
495 | 500 | */ |
496 | 501 | public function selectHotspotCoordinates($id) |
@@ -503,6 +508,7 @@ discard block |
||
503 | 508 | * |
504 | 509 | * @author Toon Keppens |
505 | 510 | * @param integer Answer ID |
511 | + * @param integer $id |
|
506 | 512 | * @return integer Answer position |
507 | 513 | */ |
508 | 514 | public function selectHotspotType($id) |
@@ -729,6 +735,7 @@ discard block |
||
729 | 735 | * @author Olivier Brouckaert |
730 | 736 | * @param int question id |
731 | 737 | * @param array destination course info (result of the function api_get_course_info() ) |
738 | + * @param string $newQuestionId |
|
732 | 739 | */ |
733 | 740 | public function duplicate($newQuestionId, $course_info = null) |
734 | 741 | { |
@@ -13,11 +13,11 @@ discard block |
||
13 | 13 | public $name; |
14 | 14 | public $description; |
15 | 15 | |
16 | - /** |
|
17 | - * Constructor of the class Category |
|
18 | - * If you give an in_id and no in_name, you get info concerning the category of id=in_id |
|
19 | - * otherwise, you've got an category objet avec your in_id, in_name, in_descr |
|
20 | - * |
|
16 | + /** |
|
17 | + * Constructor of the class Category |
|
18 | + * If you give an in_id and no in_name, you get info concerning the category of id=in_id |
|
19 | + * otherwise, you've got an category objet avec your in_id, in_name, in_descr |
|
20 | + * |
|
21 | 21 | * @param int $id |
22 | 22 | * @param string $name |
23 | 23 | * @param string $description |
@@ -61,9 +61,9 @@ discard block |
||
61 | 61 | } |
62 | 62 | } |
63 | 63 | |
64 | - /** |
|
64 | + /** |
|
65 | 65 | * add TestCategory in the database if name doesn't already exists |
66 | - */ |
|
66 | + */ |
|
67 | 67 | public function addCategoryInBDD() |
68 | 68 | { |
69 | 69 | $table = Database :: get_course_table(TABLE_QUIZ_QUESTION_CATEGORY); |
@@ -108,12 +108,12 @@ discard block |
||
108 | 108 | |
109 | 109 | return false; |
110 | 110 | } |
111 | - } |
|
111 | + } |
|
112 | 112 | |
113 | - /** |
|
113 | + /** |
|
114 | 114 | * Removes the category from the database |
115 | 115 | * if there were question in this category, the link between question and category is removed |
116 | - */ |
|
116 | + */ |
|
117 | 117 | public function removeCategory() |
118 | 118 | { |
119 | 119 | $table = Database :: get_course_table(TABLE_QUIZ_QUESTION_CATEGORY); |
@@ -143,11 +143,11 @@ discard block |
||
143 | 143 | |
144 | 144 | return true; |
145 | 145 | } |
146 | - } |
|
146 | + } |
|
147 | 147 | |
148 | - /** |
|
148 | + /** |
|
149 | 149 | * Modify category name or description of category with id=in_id |
150 | - */ |
|
150 | + */ |
|
151 | 151 | public function modifyCategory() |
152 | 152 | { |
153 | 153 | $table = Database :: get_course_table(TABLE_QUIZ_QUESTION_CATEGORY); |
@@ -175,40 +175,40 @@ discard block |
||
175 | 175 | |
176 | 176 | return true; |
177 | 177 | } |
178 | - } |
|
178 | + } |
|
179 | 179 | |
180 | - /** |
|
180 | + /** |
|
181 | 181 | * Gets the number of question of category id=in_id |
182 | - */ |
|
182 | + */ |
|
183 | 183 | public function getCategoryQuestionsNumber() |
184 | 184 | { |
185 | - $table = Database::get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY); |
|
186 | - $in_id = intval($this->id); |
|
187 | - $sql = "SELECT count(*) AS nb |
|
185 | + $table = Database::get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY); |
|
186 | + $in_id = intval($this->id); |
|
187 | + $sql = "SELECT count(*) AS nb |
|
188 | 188 | FROM $table |
189 | 189 | WHERE category_id=$in_id AND c_id=".api_get_course_int_id(); |
190 | - $res = Database::query($sql); |
|
191 | - $row = Database::fetch_array($res); |
|
190 | + $res = Database::query($sql); |
|
191 | + $row = Database::fetch_array($res); |
|
192 | 192 | |
193 | - return $row['nb']; |
|
194 | - } |
|
193 | + return $row['nb']; |
|
194 | + } |
|
195 | 195 | |
196 | 196 | /** |
197 | 197 | * @param string $in_color |
198 | 198 | */ |
199 | 199 | public function display($in_color="#E0EBF5") |
200 | 200 | { |
201 | - echo "<textarea style='background-color:$in_color; width:60%; height:100px;'>"; |
|
202 | - print_r($this); |
|
203 | - echo "</textarea>"; |
|
204 | - } |
|
201 | + echo "<textarea style='background-color:$in_color; width:60%; height:100px;'>"; |
|
202 | + print_r($this); |
|
203 | + echo "</textarea>"; |
|
204 | + } |
|
205 | 205 | |
206 | - /** |
|
206 | + /** |
|
207 | 207 | * Return an array of all Category objects in the database |
208 | - * If in_field=="" Return an array of all category objects in the database |
|
209 | - * Otherwise, return an array of all in_field value |
|
210 | - * in the database (in_field = id or name or description) |
|
211 | - */ |
|
208 | + * If in_field=="" Return an array of all category objects in the database |
|
209 | + * Otherwise, return an array of all in_field value |
|
210 | + * in the database (in_field = id or name or description) |
|
211 | + */ |
|
212 | 212 | public static function getCategoryListInfo($in_field = "", $courseId = "") |
213 | 213 | { |
214 | 214 | if (empty($courseId) || $courseId=="") { |
@@ -239,8 +239,8 @@ discard block |
||
239 | 239 | } |
240 | 240 | } |
241 | 241 | |
242 | - return $tabres; |
|
243 | - } |
|
242 | + return $tabres; |
|
243 | + } |
|
244 | 244 | |
245 | 245 | /** |
246 | 246 | * Return the TestCategory id for question with question_id = $questionId |
@@ -251,210 +251,210 @@ discard block |
||
251 | 251 | * |
252 | 252 | * @return int |
253 | 253 | */ |
254 | - public static function getCategoryForQuestion($questionId, $courseId ="") |
|
254 | + public static function getCategoryForQuestion($questionId, $courseId ="") |
|
255 | 255 | { |
256 | - $result = 0; |
|
256 | + $result = 0; |
|
257 | 257 | if (empty($courseId) || $courseId == "") { |
258 | 258 | $courseId = api_get_course_int_id(); |
259 | 259 | } |
260 | - $table = Database::get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY); |
|
260 | + $table = Database::get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY); |
|
261 | 261 | $questionId = intval($questionId); |
262 | - $sql = "SELECT category_id |
|
262 | + $sql = "SELECT category_id |
|
263 | 263 | FROM $table |
264 | 264 | WHERE question_id = $questionId AND c_id = $courseId"; |
265 | - $res = Database::query($sql); |
|
266 | - if (Database::num_rows($res) > 0) { |
|
265 | + $res = Database::query($sql); |
|
266 | + if (Database::num_rows($res) > 0) { |
|
267 | 267 | $data = Database::fetch_array($res); |
268 | - $result = $data['category_id']; |
|
269 | - } |
|
268 | + $result = $data['category_id']; |
|
269 | + } |
|
270 | 270 | |
271 | - return $result; |
|
272 | - } |
|
271 | + return $result; |
|
272 | + } |
|
273 | 273 | |
274 | - /** |
|
275 | - * true if question id has a category |
|
276 | - */ |
|
277 | - public static function isQuestionHasCategory($questionId) |
|
274 | + /** |
|
275 | + * true if question id has a category |
|
276 | + */ |
|
277 | + public static function isQuestionHasCategory($questionId) |
|
278 | 278 | { |
279 | - if (TestCategory::getCategoryForQuestion($questionId) > 0) { |
|
280 | - return true; |
|
281 | - } |
|
282 | - return false; |
|
283 | - } |
|
279 | + if (TestCategory::getCategoryForQuestion($questionId) > 0) { |
|
280 | + return true; |
|
281 | + } |
|
282 | + return false; |
|
283 | + } |
|
284 | 284 | |
285 | - /** |
|
285 | + /** |
|
286 | 286 | Return the category name for question with question_id = $questionId |
287 | 287 | In this version, a question has only 1 category. |
288 | 288 | Return the category id, "" if none |
289 | - */ |
|
289 | + */ |
|
290 | 290 | public static function getCategoryNameForQuestion( |
291 | 291 | $questionId, |
292 | 292 | $courseId = "" |
293 | 293 | ) { |
294 | - if (empty($courseId) || $courseId=="") { |
|
295 | - $courseId = api_get_course_int_id(); |
|
296 | - } |
|
297 | - $catid = TestCategory::getCategoryForQuestion($questionId, $courseId); |
|
298 | - $result = ""; // result |
|
299 | - $table = Database::get_course_table(TABLE_QUIZ_QUESTION_CATEGORY); |
|
300 | - $catid = intval($catid); |
|
301 | - $sql = "SELECT title FROM $table |
|
294 | + if (empty($courseId) || $courseId=="") { |
|
295 | + $courseId = api_get_course_int_id(); |
|
296 | + } |
|
297 | + $catid = TestCategory::getCategoryForQuestion($questionId, $courseId); |
|
298 | + $result = ""; // result |
|
299 | + $table = Database::get_course_table(TABLE_QUIZ_QUESTION_CATEGORY); |
|
300 | + $catid = intval($catid); |
|
301 | + $sql = "SELECT title FROM $table |
|
302 | 302 | WHERE id = $catid AND c_id = $courseId"; |
303 | - $res = Database::query($sql); |
|
304 | - $data = Database::fetch_array($res); |
|
305 | - if (Database::num_rows($res) > 0) { |
|
306 | - $result = $data['title']; |
|
307 | - } |
|
308 | - |
|
309 | - return $result; |
|
310 | - } |
|
311 | - |
|
312 | - /** |
|
313 | - * Return the list of differents categories ID for a test in the current course |
|
314 | - * input : test_id |
|
315 | - * return : array of category id (integer) |
|
316 | - * hubert.borderiou 07-04-2011 |
|
317 | - * @param int $exerciseId |
|
318 | - */ |
|
319 | - public static function getListOfCategoriesIDForTest($exerciseId) |
|
303 | + $res = Database::query($sql); |
|
304 | + $data = Database::fetch_array($res); |
|
305 | + if (Database::num_rows($res) > 0) { |
|
306 | + $result = $data['title']; |
|
307 | + } |
|
308 | + |
|
309 | + return $result; |
|
310 | + } |
|
311 | + |
|
312 | + /** |
|
313 | + * Return the list of differents categories ID for a test in the current course |
|
314 | + * input : test_id |
|
315 | + * return : array of category id (integer) |
|
316 | + * hubert.borderiou 07-04-2011 |
|
317 | + * @param int $exerciseId |
|
318 | + */ |
|
319 | + public static function getListOfCategoriesIDForTest($exerciseId) |
|
320 | 320 | { |
321 | - // parcourir les questions d'un test, recup les categories uniques dans un tableau |
|
322 | - $exercise = new Exercise(); |
|
323 | - $exercise->read($exerciseId, false); |
|
324 | - $categoriesInExercise = $exercise->getQuestionWithCategories(); |
|
325 | - // the array given by selectQuestionList start at indice 1 and not at indice 0 !!! ??? |
|
326 | - $categories = array(); |
|
321 | + // parcourir les questions d'un test, recup les categories uniques dans un tableau |
|
322 | + $exercise = new Exercise(); |
|
323 | + $exercise->read($exerciseId, false); |
|
324 | + $categoriesInExercise = $exercise->getQuestionWithCategories(); |
|
325 | + // the array given by selectQuestionList start at indice 1 and not at indice 0 !!! ??? |
|
326 | + $categories = array(); |
|
327 | 327 | if (!empty($categoriesInExercise)) { |
328 | - foreach ($categoriesInExercise as $category) { |
|
329 | - //$category['id'] = $category['iid']; |
|
330 | - $categories[$category['id']] = $category; |
|
331 | - } |
|
332 | - } |
|
333 | - |
|
334 | - return $categories; |
|
335 | - } |
|
336 | - |
|
337 | - /** |
|
338 | - * @param Exercise $exercise_obj |
|
339 | - * @return array |
|
340 | - */ |
|
341 | - public static function getListOfCategoriesIDForTestObject(Exercise $exercise_obj) |
|
342 | - { |
|
343 | - // parcourir les questions d'un test, recup les categories uniques dans un tableau |
|
344 | - $categories_in_exercise = array(); |
|
345 | - // $question_list = $exercise_obj->getQuestionList(); |
|
346 | - $question_list = $exercise_obj->getQuestionOrderedListByName(); |
|
347 | - |
|
348 | - // the array given by selectQuestionList start at indice 1 and not at indice 0 !!! ??? |
|
349 | - foreach ($question_list as $questionInfo) { |
|
350 | - $question_id = $questionInfo['question_id']; |
|
351 | - $category_list = self::getCategoryForQuestion($question_id); |
|
352 | - if (is_numeric($category_list)) { |
|
353 | - $category_list = array($category_list); |
|
354 | - } |
|
355 | - |
|
356 | - if (!empty($category_list)) { |
|
357 | - $categories_in_exercise = array_merge($categories_in_exercise, $category_list); |
|
358 | - } |
|
359 | - } |
|
360 | - if (!empty($categories_in_exercise)) { |
|
361 | - $categories_in_exercise = array_unique(array_filter($categories_in_exercise)); |
|
362 | - } |
|
363 | - return $categories_in_exercise; |
|
364 | - } |
|
365 | - |
|
366 | - /** |
|
367 | - * Return the list of differents categories NAME for a test |
|
368 | - * @param int exercise id |
|
369 | - * @param bool |
|
370 | - * @return array of string |
|
371 | - * |
|
328 | + foreach ($categoriesInExercise as $category) { |
|
329 | + //$category['id'] = $category['iid']; |
|
330 | + $categories[$category['id']] = $category; |
|
331 | + } |
|
332 | + } |
|
333 | + |
|
334 | + return $categories; |
|
335 | + } |
|
336 | + |
|
337 | + /** |
|
338 | + * @param Exercise $exercise_obj |
|
339 | + * @return array |
|
340 | + */ |
|
341 | + public static function getListOfCategoriesIDForTestObject(Exercise $exercise_obj) |
|
342 | + { |
|
343 | + // parcourir les questions d'un test, recup les categories uniques dans un tableau |
|
344 | + $categories_in_exercise = array(); |
|
345 | + // $question_list = $exercise_obj->getQuestionList(); |
|
346 | + $question_list = $exercise_obj->getQuestionOrderedListByName(); |
|
347 | + |
|
348 | + // the array given by selectQuestionList start at indice 1 and not at indice 0 !!! ??? |
|
349 | + foreach ($question_list as $questionInfo) { |
|
350 | + $question_id = $questionInfo['question_id']; |
|
351 | + $category_list = self::getCategoryForQuestion($question_id); |
|
352 | + if (is_numeric($category_list)) { |
|
353 | + $category_list = array($category_list); |
|
354 | + } |
|
355 | + |
|
356 | + if (!empty($category_list)) { |
|
357 | + $categories_in_exercise = array_merge($categories_in_exercise, $category_list); |
|
358 | + } |
|
359 | + } |
|
360 | + if (!empty($categories_in_exercise)) { |
|
361 | + $categories_in_exercise = array_unique(array_filter($categories_in_exercise)); |
|
362 | + } |
|
363 | + return $categories_in_exercise; |
|
364 | + } |
|
365 | + |
|
366 | + /** |
|
367 | + * Return the list of differents categories NAME for a test |
|
368 | + * @param int exercise id |
|
369 | + * @param bool |
|
370 | + * @return array of string |
|
371 | + * |
|
372 | 372 | * @author function rewrote by jmontoya |
373 | - */ |
|
374 | - public static function getListOfCategoriesNameForTest($exercise_id, $grouped_by_category = true) |
|
373 | + */ |
|
374 | + public static function getListOfCategoriesNameForTest($exercise_id, $grouped_by_category = true) |
|
375 | 375 | { |
376 | - $result = array(); |
|
377 | - $categories = self::getListOfCategoriesIDForTest($exercise_id, $grouped_by_category); |
|
376 | + $result = array(); |
|
377 | + $categories = self::getListOfCategoriesIDForTest($exercise_id, $grouped_by_category); |
|
378 | 378 | |
379 | - foreach ($categories as $catInfo) { |
|
380 | - $categoryId = $catInfo['id']; |
|
381 | - if (!empty($categoryId)) { |
|
382 | - $result[$categoryId] = array( |
|
379 | + foreach ($categories as $catInfo) { |
|
380 | + $categoryId = $catInfo['id']; |
|
381 | + if (!empty($categoryId)) { |
|
382 | + $result[$categoryId] = array( |
|
383 | 383 | 'title' => $catInfo['title'], |
384 | 384 | //'parent_id' => $catInfo['parent_id'], |
385 | - 'parent_id' => '', |
|
385 | + 'parent_id' => '', |
|
386 | 386 | 'c_id' => $catInfo['c_id'] |
387 | 387 | ); |
388 | - } |
|
389 | - } |
|
390 | - |
|
391 | - return $result; |
|
392 | - } |
|
393 | - |
|
394 | - /** |
|
395 | - * @param Exercise $exercise_obj |
|
396 | - * @return array |
|
397 | - */ |
|
398 | - public static function getListOfCategoriesForTest(Exercise $exercise_obj) |
|
399 | - { |
|
400 | - $result = array(); |
|
401 | - $categories = self::getListOfCategoriesIDForTestObject($exercise_obj); |
|
402 | - foreach ($categories as $cat_id) { |
|
403 | - $cat = new TestCategory($cat_id); |
|
404 | - $cat = (array)$cat; |
|
405 | - $cat['iid'] = $cat['id']; |
|
406 | - $cat['title'] = $cat['name']; |
|
407 | - $result[$cat['id']] = $cat; |
|
408 | - } |
|
409 | - return $result; |
|
410 | - } |
|
411 | - |
|
412 | - /** |
|
413 | - * return the number of differents categories for a test |
|
414 | - * input : test_id |
|
415 | - * return : integer |
|
416 | - * hubert.borderiou 07-04-2011 |
|
417 | - */ |
|
418 | - public static function getNumberOfCategoriesForTest($id) |
|
388 | + } |
|
389 | + } |
|
390 | + |
|
391 | + return $result; |
|
392 | + } |
|
393 | + |
|
394 | + /** |
|
395 | + * @param Exercise $exercise_obj |
|
396 | + * @return array |
|
397 | + */ |
|
398 | + public static function getListOfCategoriesForTest(Exercise $exercise_obj) |
|
399 | + { |
|
400 | + $result = array(); |
|
401 | + $categories = self::getListOfCategoriesIDForTestObject($exercise_obj); |
|
402 | + foreach ($categories as $cat_id) { |
|
403 | + $cat = new TestCategory($cat_id); |
|
404 | + $cat = (array)$cat; |
|
405 | + $cat['iid'] = $cat['id']; |
|
406 | + $cat['title'] = $cat['name']; |
|
407 | + $result[$cat['id']] = $cat; |
|
408 | + } |
|
409 | + return $result; |
|
410 | + } |
|
411 | + |
|
412 | + /** |
|
413 | + * return the number of differents categories for a test |
|
414 | + * input : test_id |
|
415 | + * return : integer |
|
416 | + * hubert.borderiou 07-04-2011 |
|
417 | + */ |
|
418 | + public static function getNumberOfCategoriesForTest($id) |
|
419 | 419 | { |
420 | - return count(TestCategory::getListOfCategoriesIDForTest($id)); |
|
421 | - } |
|
420 | + return count(TestCategory::getListOfCategoriesIDForTest($id)); |
|
421 | + } |
|
422 | 422 | |
423 | - /** |
|
424 | - * return the number of question of a category id in a test |
|
425 | - * @param int $exerciseId |
|
423 | + /** |
|
424 | + * return the number of question of a category id in a test |
|
425 | + * @param int $exerciseId |
|
426 | 426 | * @param int $categoryId |
427 | 427 | * |
428 | - * @return integer |
|
428 | + * @return integer |
|
429 | 429 | * |
430 | - * @author hubert.borderiou 07-04-2011 |
|
431 | - */ |
|
432 | - public static function getNumberOfQuestionsInCategoryForTest($exerciseId, $categoryId) |
|
430 | + * @author hubert.borderiou 07-04-2011 |
|
431 | + */ |
|
432 | + public static function getNumberOfQuestionsInCategoryForTest($exerciseId, $categoryId) |
|
433 | 433 | { |
434 | - $nbCatResult = 0; |
|
435 | - $quiz = new Exercise(); |
|
436 | - $quiz->read($exerciseId); |
|
437 | - $tabQuestionList = $quiz->selectQuestionList(); |
|
438 | - // the array given by selectQuestionList start at indice 1 and not at indice 0 !!! ? ? ? |
|
439 | - for ($i=1; $i <= count($tabQuestionList); $i++) { |
|
440 | - if (TestCategory::getCategoryForQuestion($tabQuestionList[$i]) == $categoryId) { |
|
441 | - $nbCatResult++; |
|
442 | - } |
|
443 | - } |
|
444 | - |
|
445 | - return $nbCatResult; |
|
446 | - } |
|
447 | - |
|
448 | - /** |
|
449 | - * return the number of question for a test using random by category |
|
450 | - * input : test_id, number of random question (min 1) |
|
451 | - * hubert.borderiou 07-04-2011 |
|
452 | - * question without categories are not counted |
|
453 | - */ |
|
454 | - public static function getNumberOfQuestionRandomByCategory($exerciseId, $in_nbrandom) |
|
434 | + $nbCatResult = 0; |
|
435 | + $quiz = new Exercise(); |
|
436 | + $quiz->read($exerciseId); |
|
437 | + $tabQuestionList = $quiz->selectQuestionList(); |
|
438 | + // the array given by selectQuestionList start at indice 1 and not at indice 0 !!! ? ? ? |
|
439 | + for ($i=1; $i <= count($tabQuestionList); $i++) { |
|
440 | + if (TestCategory::getCategoryForQuestion($tabQuestionList[$i]) == $categoryId) { |
|
441 | + $nbCatResult++; |
|
442 | + } |
|
443 | + } |
|
444 | + |
|
445 | + return $nbCatResult; |
|
446 | + } |
|
447 | + |
|
448 | + /** |
|
449 | + * return the number of question for a test using random by category |
|
450 | + * input : test_id, number of random question (min 1) |
|
451 | + * hubert.borderiou 07-04-2011 |
|
452 | + * question without categories are not counted |
|
453 | + */ |
|
454 | + public static function getNumberOfQuestionRandomByCategory($exerciseId, $in_nbrandom) |
|
455 | 455 | { |
456 | - $nbquestionresult = 0; |
|
457 | - $tabcatid = TestCategory::getListOfCategoriesIDForTest($exerciseId); |
|
456 | + $nbquestionresult = 0; |
|
457 | + $tabcatid = TestCategory::getListOfCategoriesIDForTest($exerciseId); |
|
458 | 458 | |
459 | 459 | foreach ($tabcatid as $category) { |
460 | 460 | if (empty($category['id'])) { |
@@ -470,30 +470,30 @@ discard block |
||
470 | 470 | } |
471 | 471 | } |
472 | 472 | |
473 | - return $nbquestionresult; |
|
474 | - } |
|
473 | + return $nbquestionresult; |
|
474 | + } |
|
475 | 475 | |
476 | - /** |
|
477 | - * Return an array (id=>name) |
|
478 | - * tabresult[0] = get_lang('NoCategory'); |
|
476 | + /** |
|
477 | + * Return an array (id=>name) |
|
478 | + * tabresult[0] = get_lang('NoCategory'); |
|
479 | 479 | * |
480 | 480 | * @param int $courseId |
481 | 481 | * |
482 | 482 | * @return array |
483 | - * |
|
484 | - */ |
|
483 | + * |
|
484 | + */ |
|
485 | 485 | public static function getCategoriesIdAndName($courseId = "") |
486 | 486 | { |
487 | - if (empty($courseId)) { |
|
488 | - $courseId = api_get_course_int_id(); |
|
489 | - } |
|
490 | - $tabcatobject = TestCategory::getCategoryListInfo("", $courseId); |
|
491 | - $tabresult = array("0"=>get_lang('NoCategorySelected')); |
|
492 | - for ($i=0; $i < count($tabcatobject); $i++) { |
|
493 | - $tabresult[$tabcatobject[$i]->id] = $tabcatobject[$i]->name; |
|
494 | - } |
|
495 | - return $tabresult; |
|
496 | - } |
|
487 | + if (empty($courseId)) { |
|
488 | + $courseId = api_get_course_int_id(); |
|
489 | + } |
|
490 | + $tabcatobject = TestCategory::getCategoryListInfo("", $courseId); |
|
491 | + $tabresult = array("0"=>get_lang('NoCategorySelected')); |
|
492 | + for ($i=0; $i < count($tabcatobject); $i++) { |
|
493 | + $tabresult[$tabcatobject[$i]->id] = $tabcatobject[$i]->name; |
|
494 | + } |
|
495 | + return $tabresult; |
|
496 | + } |
|
497 | 497 | |
498 | 498 | /** |
499 | 499 | * Returns an array of question ids for each category |
@@ -502,10 +502,10 @@ discard block |
||
502 | 502 | * @param int exercise |
503 | 503 | * @param array $check_in_question_list |
504 | 504 | * @param array $categoriesAddedInExercise |
505 | - * |
|
506 | - * @param int $exerciseId |
|
507 | - * @return array |
|
508 | - */ |
|
505 | + * |
|
506 | + * @param int $exerciseId |
|
507 | + * @return array |
|
508 | + */ |
|
509 | 509 | static function getQuestionsByCat( |
510 | 510 | $exerciseId, |
511 | 511 | $check_in_question_list = array(), |
@@ -583,28 +583,28 @@ discard block |
||
583 | 583 | } |
584 | 584 | |
585 | 585 | return $categories; |
586 | - } |
|
586 | + } |
|
587 | 587 | |
588 | - /** |
|
589 | - * return a tab of $in_number random elements of $in_tab |
|
590 | - */ |
|
588 | + /** |
|
589 | + * return a tab of $in_number random elements of $in_tab |
|
590 | + */ |
|
591 | 591 | public static function getNElementsFromArray($in_tab, $in_number) |
592 | 592 | { |
593 | - $tabres = $in_tab; |
|
594 | - shuffle($tabres); |
|
595 | - if ($in_number < count($tabres)) { |
|
596 | - $tabres = array_slice($tabres, 0, $in_number); |
|
597 | - } |
|
598 | - return $tabres; |
|
599 | - } |
|
600 | - |
|
601 | - /** |
|
602 | - * display the category |
|
603 | - */ |
|
604 | - public static function displayCategoryAndTitle($questionId, $in_display_category_name = 1) |
|
593 | + $tabres = $in_tab; |
|
594 | + shuffle($tabres); |
|
595 | + if ($in_number < count($tabres)) { |
|
596 | + $tabres = array_slice($tabres, 0, $in_number); |
|
597 | + } |
|
598 | + return $tabres; |
|
599 | + } |
|
600 | + |
|
601 | + /** |
|
602 | + * display the category |
|
603 | + */ |
|
604 | + public static function displayCategoryAndTitle($questionId, $in_display_category_name = 1) |
|
605 | 605 | { |
606 | 606 | echo self::returnCategoryAndTitle($questionId, $in_display_category_name); |
607 | - } |
|
607 | + } |
|
608 | 608 | |
609 | 609 | /** |
610 | 610 | * @param int $questionId |
@@ -620,90 +620,90 @@ discard block |
||
620 | 620 | $in_display_category_name = $objExercise->display_category_name; |
621 | 621 | } |
622 | 622 | $content = null; |
623 | - if (TestCategory::getCategoryNameForQuestion($questionId) != "" && ($in_display_category_name == 1 || !$is_student)) { |
|
623 | + if (TestCategory::getCategoryNameForQuestion($questionId) != "" && ($in_display_category_name == 1 || !$is_student)) { |
|
624 | 624 | $content .= '<div class="page-header">'; |
625 | 625 | $content .= '<h4>'.get_lang('Category').": ".TestCategory::getCategoryNameForQuestion($questionId).'</h4>'; |
626 | 626 | $content .= "</div>"; |
627 | - } |
|
627 | + } |
|
628 | 628 | return $content; |
629 | - } |
|
629 | + } |
|
630 | 630 | |
631 | 631 | /** |
632 | - * Display signs [+] and/or (>0) after question title if question has options |
|
633 | - * scoreAlwaysPositive and/or uncheckedMayScore |
|
634 | - */ |
|
632 | + * Display signs [+] and/or (>0) after question title if question has options |
|
633 | + * scoreAlwaysPositive and/or uncheckedMayScore |
|
634 | + */ |
|
635 | 635 | public function displayQuestionOption($in_objQuestion) |
636 | 636 | { |
637 | - if ($in_objQuestion->type == MULTIPLE_ANSWER && $in_objQuestion->scoreAlwaysPositive) { |
|
638 | - echo "<span style='font-size:75%'> (>0)</span>"; |
|
639 | - } |
|
640 | - if ($in_objQuestion->type == MULTIPLE_ANSWER && $in_objQuestion->uncheckedMayScore) { |
|
641 | - echo "<span style='font-size:75%'> [+]</span>"; |
|
642 | - } |
|
643 | - } |
|
644 | - |
|
645 | - /** |
|
646 | - * sortTabByBracketLabel ($tabCategoryQuestions) |
|
647 | - * key of $tabCategoryQuestions are the category id (0 for not in a category) |
|
648 | - * value is the array of question id of this category |
|
649 | - * Sort question by Category |
|
650 | - */ |
|
637 | + if ($in_objQuestion->type == MULTIPLE_ANSWER && $in_objQuestion->scoreAlwaysPositive) { |
|
638 | + echo "<span style='font-size:75%'> (>0)</span>"; |
|
639 | + } |
|
640 | + if ($in_objQuestion->type == MULTIPLE_ANSWER && $in_objQuestion->uncheckedMayScore) { |
|
641 | + echo "<span style='font-size:75%'> [+]</span>"; |
|
642 | + } |
|
643 | + } |
|
644 | + |
|
645 | + /** |
|
646 | + * sortTabByBracketLabel ($tabCategoryQuestions) |
|
647 | + * key of $tabCategoryQuestions are the category id (0 for not in a category) |
|
648 | + * value is the array of question id of this category |
|
649 | + * Sort question by Category |
|
650 | + */ |
|
651 | 651 | public static function sortTabByBracketLabel($in_tab) |
652 | 652 | { |
653 | - $tabResult = array(); |
|
654 | - $tabCatName = array(); // tab of category name |
|
655 | - while (list($cat_id, $tabquestion) = each($in_tab)) { |
|
656 | - $catTitle = new TestCategory($cat_id); |
|
657 | - $tabCatName[$cat_id] = $catTitle->name; |
|
658 | - } |
|
659 | - reset($in_tab); |
|
660 | - // sort table by value, keeping keys as they are |
|
661 | - asort($tabCatName); |
|
662 | - // keys of $tabCatName are keys order for $in_tab |
|
663 | - while (list($key, $val) = each($tabCatName)) { |
|
664 | - $tabResult[$key] = $in_tab[$key]; |
|
665 | - } |
|
666 | - return $tabResult; |
|
667 | - } |
|
653 | + $tabResult = array(); |
|
654 | + $tabCatName = array(); // tab of category name |
|
655 | + while (list($cat_id, $tabquestion) = each($in_tab)) { |
|
656 | + $catTitle = new TestCategory($cat_id); |
|
657 | + $tabCatName[$cat_id] = $catTitle->name; |
|
658 | + } |
|
659 | + reset($in_tab); |
|
660 | + // sort table by value, keeping keys as they are |
|
661 | + asort($tabCatName); |
|
662 | + // keys of $tabCatName are keys order for $in_tab |
|
663 | + while (list($key, $val) = each($tabCatName)) { |
|
664 | + $tabResult[$key] = $in_tab[$key]; |
|
665 | + } |
|
666 | + return $tabResult; |
|
667 | + } |
|
668 | 668 | |
669 | 669 | /** |
670 | - * return total score for test exe_id for all question in the category $in_cat_id for user |
|
671 | - * If no question for this category, return "" |
|
672 | - */ |
|
673 | - public static function getCatScoreForExeidForUserid($in_cat_id, $in_exe_id, $in_user_id) |
|
674 | - { |
|
675 | - $tbl_track_attempt = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ATTEMPT); |
|
676 | - $tbl_question_rel_category = Database::get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY); |
|
677 | - $in_cat_id = intval($in_cat_id); |
|
678 | - $in_exe_id = intval($in_exe_id); |
|
679 | - $in_user_id = intval($in_user_id); |
|
680 | - |
|
681 | - $query = "SELECT DISTINCT |
|
670 | + * return total score for test exe_id for all question in the category $in_cat_id for user |
|
671 | + * If no question for this category, return "" |
|
672 | + */ |
|
673 | + public static function getCatScoreForExeidForUserid($in_cat_id, $in_exe_id, $in_user_id) |
|
674 | + { |
|
675 | + $tbl_track_attempt = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ATTEMPT); |
|
676 | + $tbl_question_rel_category = Database::get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY); |
|
677 | + $in_cat_id = intval($in_cat_id); |
|
678 | + $in_exe_id = intval($in_exe_id); |
|
679 | + $in_user_id = intval($in_user_id); |
|
680 | + |
|
681 | + $query = "SELECT DISTINCT |
|
682 | 682 | marks, exe_id, user_id, ta.question_id, category_id |
683 | 683 | FROM $tbl_track_attempt ta , $tbl_question_rel_category qrc |
684 | 684 | WHERE |
685 | 685 | ta.question_id=qrc.question_id AND |
686 | 686 | qrc.category_id=$in_cat_id AND |
687 | 687 | exe_id=$in_exe_id AND user_id=$in_user_id"; |
688 | - $res = Database::query($query); |
|
689 | - $totalcatscore = ""; |
|
690 | - while ($data = Database::fetch_array($res)) { |
|
691 | - $totalcatscore += $data['marks']; |
|
692 | - } |
|
693 | - return $totalcatscore; |
|
694 | - } |
|
695 | - |
|
696 | - /** |
|
688 | + $res = Database::query($query); |
|
689 | + $totalcatscore = ""; |
|
690 | + while ($data = Database::fetch_array($res)) { |
|
691 | + $totalcatscore += $data['marks']; |
|
692 | + } |
|
693 | + return $totalcatscore; |
|
694 | + } |
|
695 | + |
|
696 | + /** |
|
697 | 697 | * return the number max of question in a category |
698 | 698 | * count the number of questions in all categories, and return the max |
699 | 699 | * @param int $exerciseId |
700 | 700 | * @author - hubert borderiou |
701 | - */ |
|
701 | + */ |
|
702 | 702 | public static function getNumberMaxQuestionByCat($exerciseId) |
703 | 703 | { |
704 | 704 | $res_num_max = 0; |
705 | 705 | // foreach question |
706 | - $tabcatid = TestCategory::getListOfCategoriesIDForTest($exerciseId); |
|
706 | + $tabcatid = TestCategory::getListOfCategoriesIDForTest($exerciseId); |
|
707 | 707 | |
708 | 708 | foreach ($tabcatid as $category) { |
709 | 709 | if (empty($category['id'])) { |
@@ -775,34 +775,34 @@ discard block |
||
775 | 775 | } |
776 | 776 | |
777 | 777 | /** |
778 | - * @return array |
|
779 | - */ |
|
780 | - function get_all_categories() |
|
781 | - { |
|
782 | - $table = Database::get_course_table(TABLE_QUIZ_CATEGORY); |
|
783 | - $sql = "SELECT * FROM $table ORDER BY title ASC"; |
|
784 | - $res = Database::query($sql); |
|
785 | - while ($row = Database::fetch_array($res,'ASSOC')) { |
|
786 | - $array[] = $row; |
|
787 | - } |
|
788 | - return $array; |
|
789 | - } |
|
790 | - |
|
791 | - /** |
|
792 | - * @param Exercise $exercise |
|
793 | - * @param int $course_id |
|
794 | - * @param string $order |
|
795 | - * @param bool $shuffle |
|
796 | - * @param bool $excludeCategoryWithNoQuestions |
|
797 | - * @return array|bool |
|
798 | - */ |
|
799 | - public function getCategoryExerciseTree( |
|
800 | - $exercise, |
|
801 | - $course_id, |
|
802 | - $order = null, |
|
803 | - $shuffle = false, |
|
804 | - $excludeCategoryWithNoQuestions = true |
|
805 | - ) { |
|
778 | + * @return array |
|
779 | + */ |
|
780 | + function get_all_categories() |
|
781 | + { |
|
782 | + $table = Database::get_course_table(TABLE_QUIZ_CATEGORY); |
|
783 | + $sql = "SELECT * FROM $table ORDER BY title ASC"; |
|
784 | + $res = Database::query($sql); |
|
785 | + while ($row = Database::fetch_array($res,'ASSOC')) { |
|
786 | + $array[] = $row; |
|
787 | + } |
|
788 | + return $array; |
|
789 | + } |
|
790 | + |
|
791 | + /** |
|
792 | + * @param Exercise $exercise |
|
793 | + * @param int $course_id |
|
794 | + * @param string $order |
|
795 | + * @param bool $shuffle |
|
796 | + * @param bool $excludeCategoryWithNoQuestions |
|
797 | + * @return array|bool |
|
798 | + */ |
|
799 | + public function getCategoryExerciseTree( |
|
800 | + $exercise, |
|
801 | + $course_id, |
|
802 | + $order = null, |
|
803 | + $shuffle = false, |
|
804 | + $excludeCategoryWithNoQuestions = true |
|
805 | + ) { |
|
806 | 806 | if (empty($exercise)) { |
807 | 807 | return array(); |
808 | 808 | } |
@@ -812,165 +812,165 @@ discard block |
||
812 | 812 | } |
813 | 813 | |
814 | 814 | $course_id = intval($course_id); |
815 | - $table = Database::get_course_table(TABLE_QUIZ_REL_CATEGORY); |
|
815 | + $table = Database::get_course_table(TABLE_QUIZ_REL_CATEGORY); |
|
816 | 816 | $categoryTable = Database::get_course_table(TABLE_QUIZ_QUESTION_CATEGORY); |
817 | - $sql = "SELECT * FROM $table qc |
|
817 | + $sql = "SELECT * FROM $table qc |
|
818 | 818 | LEFT JOIN $categoryTable c |
819 | 819 | ON (qc.c_id = c.c_id AND c.id = qc.category_id) |
820 | 820 | WHERE qc.c_id = $course_id AND exercise_id = {$exercise->id} "; |
821 | 821 | |
822 | - if (!empty($order)) { |
|
823 | - $sql .= "ORDER BY $order"; |
|
824 | - } |
|
825 | - |
|
826 | - $categories = array(); |
|
827 | - |
|
828 | - $result = Database::query($sql); |
|
829 | - if (Database::num_rows($result)) { |
|
830 | - while ($row = Database::fetch_array($result, 'ASSOC')) { |
|
831 | - if ($excludeCategoryWithNoQuestions) { |
|
832 | - if ($row['count_questions'] == 0) { |
|
833 | - continue; |
|
834 | - } |
|
835 | - } |
|
836 | - if (empty($row['title']) && empty($row['category_id'])) { |
|
837 | - $row['title'] = get_lang('NoCategory'); |
|
838 | - } |
|
822 | + if (!empty($order)) { |
|
823 | + $sql .= "ORDER BY $order"; |
|
824 | + } |
|
825 | + |
|
826 | + $categories = array(); |
|
827 | + |
|
828 | + $result = Database::query($sql); |
|
829 | + if (Database::num_rows($result)) { |
|
830 | + while ($row = Database::fetch_array($result, 'ASSOC')) { |
|
831 | + if ($excludeCategoryWithNoQuestions) { |
|
832 | + if ($row['count_questions'] == 0) { |
|
833 | + continue; |
|
834 | + } |
|
835 | + } |
|
836 | + if (empty($row['title']) && empty($row['category_id'])) { |
|
837 | + $row['title'] = get_lang('NoCategory'); |
|
838 | + } |
|
839 | 839 | $categories[$row['category_id']] = $row; |
840 | - } |
|
841 | - } |
|
842 | - |
|
843 | - if ($shuffle) { |
|
844 | - shuffle_assoc($categories); |
|
845 | - } |
|
846 | - |
|
847 | - return $categories; |
|
848 | - } |
|
849 | - |
|
850 | - public function getForm(& $form, $action = 'new') |
|
851 | - { |
|
852 | - switch($action) { |
|
853 | - case 'new': |
|
854 | - $header = get_lang('AddACategory'); |
|
855 | - $submit = get_lang('AddTestCategory'); |
|
856 | - break; |
|
857 | - case 'edit': |
|
858 | - $header = get_lang('EditCategory'); |
|
859 | - $submit = get_lang('ModifyCategory'); |
|
860 | - break; |
|
861 | - } |
|
862 | - |
|
863 | - // settting the form elements |
|
864 | - $form->addElement('header', $header); |
|
865 | - $form->addElement('hidden', 'category_id'); |
|
866 | - $form->addElement('text', 'category_name', get_lang('CategoryName'), array('class' => 'span6')); |
|
867 | - $form->add_html_editor('category_description', get_lang('CategoryDescription'), false, false, array('ToolbarSet' => 'test_category', 'Width' => '90%', 'Height' => '200')); |
|
868 | - $category_parent_list = array(); |
|
869 | - |
|
870 | - $options = array( |
|
871 | - '1' => get_lang('Visible'), |
|
872 | - '0' => get_lang('Hidden') |
|
873 | - ); |
|
874 | - $form->addElement('select', 'visibility', get_lang('Visibility'), $options); |
|
875 | - $script = null; |
|
876 | - if (!empty($this->parent_id)) { |
|
877 | - $parent_cat = new TestCategory($this->parent_id); |
|
878 | - $category_parent_list = array($parent_cat->id => $parent_cat->name); |
|
879 | - $script .= '<script>$(function() { $("#parent_id").trigger("addItem",[{"title": "'.$parent_cat->name.'", "value": "'.$parent_cat->id.'"}]); });</script>'; |
|
880 | - } |
|
881 | - $form->addElement('html', $script); |
|
882 | - |
|
883 | - $form->addElement('select', 'parent_id', get_lang('Parent'), $category_parent_list, array('id' => 'parent_id')); |
|
884 | - $form->addElement('style_submit_button', 'SubmitNote', $submit, 'class="add"'); |
|
885 | - |
|
886 | - // setting the defaults |
|
887 | - $defaults = array(); |
|
888 | - $defaults["category_id"] = $this->id; |
|
889 | - $defaults["category_name"] = $this->name; |
|
890 | - $defaults["category_description"] = $this->description; |
|
891 | - $defaults["parent_id"] = $this->parent_id; |
|
892 | - $defaults["visibility"] = $this->visibility; |
|
893 | - $form->setDefaults($defaults); |
|
894 | - |
|
895 | - // setting the rules |
|
896 | - $form->addRule('category_name', get_lang('ThisFieldIsRequired'), 'required'); |
|
897 | - } |
|
898 | - |
|
899 | - /** |
|
900 | - * Returns the category form. |
|
901 | - * @param Exercise $exercise_obj |
|
902 | - * @return string |
|
903 | - */ |
|
904 | - public function returnCategoryForm(Exercise $exercise_obj) |
|
905 | - { |
|
906 | - $categories = $this->getListOfCategoriesForTest($exercise_obj); |
|
907 | - |
|
908 | - $saved_categories = $exercise_obj->get_categories_in_exercise(); |
|
909 | - $return = null; |
|
910 | - |
|
911 | - if (!empty($categories)) { |
|
912 | - $nbQuestionsTotal = $exercise_obj->getNumberQuestionExerciseCategory(); |
|
913 | - $exercise_obj->setCategoriesGrouping(true); |
|
914 | - $real_question_count = count($exercise_obj->getQuestionList()); |
|
915 | - |
|
916 | - $warning = null; |
|
917 | - if ($nbQuestionsTotal != $real_question_count) { |
|
918 | - $warning = Display::return_message(get_lang('CheckThatYouHaveEnoughQuestionsInYourCategories'), 'warning'); |
|
919 | - } |
|
920 | - |
|
921 | - $return .= $warning; |
|
922 | - $return .= '<table class="data_table">'; |
|
923 | - $return .= '<tr>'; |
|
924 | - $return .= '<th height="24">' . get_lang('Categories') . '</th>'; |
|
925 | - $return .= '<th width="70" height="24">' . get_lang('Number') . '</th></tr>'; |
|
926 | - |
|
927 | - $emptyCategory = array( |
|
928 | - 'id' => '0', |
|
929 | - 'name' => get_lang('NoCategory'), |
|
930 | - 'description' => '', |
|
931 | - 'iid' => '0', |
|
932 | - 'title' => get_lang('NoCategory') |
|
933 | - ); |
|
934 | - |
|
935 | - $categories[] = $emptyCategory; |
|
936 | - |
|
937 | - foreach ($categories as $category) { |
|
938 | - $cat_id = $category['iid']; |
|
939 | - $return .= '<tr>'; |
|
940 | - $return .= '<td>'; |
|
941 | - //$return .= Display::div(isset($category['parent_path']) ? $category['parent_path'] : ''); |
|
942 | - $return .= Display::div($category['name']); |
|
943 | - $return .= '</td>'; |
|
944 | - $return .= '<td>'; |
|
945 | - $value = isset($saved_categories) && isset($saved_categories[$cat_id]) ? $saved_categories[$cat_id]['count_questions'] : -1; |
|
946 | - $return .= '<input name="category['.$cat_id.']" value="' .$value.'" />'; |
|
947 | - $return .= '</td>'; |
|
948 | - $return .= '</tr>'; |
|
949 | - } |
|
950 | - |
|
951 | - $return .= '</table>'; |
|
952 | - $return .= get_lang('ZeroMeansNoQuestionWillBeSelectedMinusOneMeansThatAllQuestionsWillBeSelected'); |
|
953 | - return $return; |
|
954 | - } |
|
955 | - } |
|
956 | - |
|
957 | - /** |
|
958 | - * Sorts an array |
|
959 | - * @param $array |
|
960 | - * @return mixed |
|
961 | - */ |
|
962 | - public function sort_tree_array($array) |
|
963 | - { |
|
964 | - foreach ($array as $key => $row) { |
|
965 | - $parent[$key] = $row['parent_id']; |
|
966 | - } |
|
967 | - if (count($array) > 0) { |
|
968 | - array_multisort($parent, SORT_ASC, $array); |
|
969 | - } |
|
970 | - return $array; |
|
971 | - } |
|
972 | - |
|
973 | - /** |
|
840 | + } |
|
841 | + } |
|
842 | + |
|
843 | + if ($shuffle) { |
|
844 | + shuffle_assoc($categories); |
|
845 | + } |
|
846 | + |
|
847 | + return $categories; |
|
848 | + } |
|
849 | + |
|
850 | + public function getForm(& $form, $action = 'new') |
|
851 | + { |
|
852 | + switch($action) { |
|
853 | + case 'new': |
|
854 | + $header = get_lang('AddACategory'); |
|
855 | + $submit = get_lang('AddTestCategory'); |
|
856 | + break; |
|
857 | + case 'edit': |
|
858 | + $header = get_lang('EditCategory'); |
|
859 | + $submit = get_lang('ModifyCategory'); |
|
860 | + break; |
|
861 | + } |
|
862 | + |
|
863 | + // settting the form elements |
|
864 | + $form->addElement('header', $header); |
|
865 | + $form->addElement('hidden', 'category_id'); |
|
866 | + $form->addElement('text', 'category_name', get_lang('CategoryName'), array('class' => 'span6')); |
|
867 | + $form->add_html_editor('category_description', get_lang('CategoryDescription'), false, false, array('ToolbarSet' => 'test_category', 'Width' => '90%', 'Height' => '200')); |
|
868 | + $category_parent_list = array(); |
|
869 | + |
|
870 | + $options = array( |
|
871 | + '1' => get_lang('Visible'), |
|
872 | + '0' => get_lang('Hidden') |
|
873 | + ); |
|
874 | + $form->addElement('select', 'visibility', get_lang('Visibility'), $options); |
|
875 | + $script = null; |
|
876 | + if (!empty($this->parent_id)) { |
|
877 | + $parent_cat = new TestCategory($this->parent_id); |
|
878 | + $category_parent_list = array($parent_cat->id => $parent_cat->name); |
|
879 | + $script .= '<script>$(function() { $("#parent_id").trigger("addItem",[{"title": "'.$parent_cat->name.'", "value": "'.$parent_cat->id.'"}]); });</script>'; |
|
880 | + } |
|
881 | + $form->addElement('html', $script); |
|
882 | + |
|
883 | + $form->addElement('select', 'parent_id', get_lang('Parent'), $category_parent_list, array('id' => 'parent_id')); |
|
884 | + $form->addElement('style_submit_button', 'SubmitNote', $submit, 'class="add"'); |
|
885 | + |
|
886 | + // setting the defaults |
|
887 | + $defaults = array(); |
|
888 | + $defaults["category_id"] = $this->id; |
|
889 | + $defaults["category_name"] = $this->name; |
|
890 | + $defaults["category_description"] = $this->description; |
|
891 | + $defaults["parent_id"] = $this->parent_id; |
|
892 | + $defaults["visibility"] = $this->visibility; |
|
893 | + $form->setDefaults($defaults); |
|
894 | + |
|
895 | + // setting the rules |
|
896 | + $form->addRule('category_name', get_lang('ThisFieldIsRequired'), 'required'); |
|
897 | + } |
|
898 | + |
|
899 | + /** |
|
900 | + * Returns the category form. |
|
901 | + * @param Exercise $exercise_obj |
|
902 | + * @return string |
|
903 | + */ |
|
904 | + public function returnCategoryForm(Exercise $exercise_obj) |
|
905 | + { |
|
906 | + $categories = $this->getListOfCategoriesForTest($exercise_obj); |
|
907 | + |
|
908 | + $saved_categories = $exercise_obj->get_categories_in_exercise(); |
|
909 | + $return = null; |
|
910 | + |
|
911 | + if (!empty($categories)) { |
|
912 | + $nbQuestionsTotal = $exercise_obj->getNumberQuestionExerciseCategory(); |
|
913 | + $exercise_obj->setCategoriesGrouping(true); |
|
914 | + $real_question_count = count($exercise_obj->getQuestionList()); |
|
915 | + |
|
916 | + $warning = null; |
|
917 | + if ($nbQuestionsTotal != $real_question_count) { |
|
918 | + $warning = Display::return_message(get_lang('CheckThatYouHaveEnoughQuestionsInYourCategories'), 'warning'); |
|
919 | + } |
|
920 | + |
|
921 | + $return .= $warning; |
|
922 | + $return .= '<table class="data_table">'; |
|
923 | + $return .= '<tr>'; |
|
924 | + $return .= '<th height="24">' . get_lang('Categories') . '</th>'; |
|
925 | + $return .= '<th width="70" height="24">' . get_lang('Number') . '</th></tr>'; |
|
926 | + |
|
927 | + $emptyCategory = array( |
|
928 | + 'id' => '0', |
|
929 | + 'name' => get_lang('NoCategory'), |
|
930 | + 'description' => '', |
|
931 | + 'iid' => '0', |
|
932 | + 'title' => get_lang('NoCategory') |
|
933 | + ); |
|
934 | + |
|
935 | + $categories[] = $emptyCategory; |
|
936 | + |
|
937 | + foreach ($categories as $category) { |
|
938 | + $cat_id = $category['iid']; |
|
939 | + $return .= '<tr>'; |
|
940 | + $return .= '<td>'; |
|
941 | + //$return .= Display::div(isset($category['parent_path']) ? $category['parent_path'] : ''); |
|
942 | + $return .= Display::div($category['name']); |
|
943 | + $return .= '</td>'; |
|
944 | + $return .= '<td>'; |
|
945 | + $value = isset($saved_categories) && isset($saved_categories[$cat_id]) ? $saved_categories[$cat_id]['count_questions'] : -1; |
|
946 | + $return .= '<input name="category['.$cat_id.']" value="' .$value.'" />'; |
|
947 | + $return .= '</td>'; |
|
948 | + $return .= '</tr>'; |
|
949 | + } |
|
950 | + |
|
951 | + $return .= '</table>'; |
|
952 | + $return .= get_lang('ZeroMeansNoQuestionWillBeSelectedMinusOneMeansThatAllQuestionsWillBeSelected'); |
|
953 | + return $return; |
|
954 | + } |
|
955 | + } |
|
956 | + |
|
957 | + /** |
|
958 | + * Sorts an array |
|
959 | + * @param $array |
|
960 | + * @return mixed |
|
961 | + */ |
|
962 | + public function sort_tree_array($array) |
|
963 | + { |
|
964 | + foreach ($array as $key => $row) { |
|
965 | + $parent[$key] = $row['parent_id']; |
|
966 | + } |
|
967 | + if (count($array) > 0) { |
|
968 | + array_multisort($parent, SORT_ASC, $array); |
|
969 | + } |
|
970 | + return $array; |
|
971 | + } |
|
972 | + |
|
973 | + /** |
|
974 | 974 | * Return true if a category already exists with the same name |
975 | 975 | * @param string $in_name |
976 | 976 | * |
@@ -1017,8 +1017,8 @@ discard block |
||
1017 | 1017 | * @param int $categoryId |
1018 | 1018 | * @param int $questionId |
1019 | 1019 | * @param int $courseId |
1020 | - * |
|
1021 | - * @return int |
|
1020 | + * |
|
1021 | + * @return int |
|
1022 | 1022 | */ |
1023 | 1023 | public static function add_category_for_question_id($categoryId, $questionId, $courseId) |
1024 | 1024 | { |
@@ -1026,18 +1026,18 @@ discard block |
||
1026 | 1026 | // if question doesn't have a category |
1027 | 1027 | // @todo change for 1.10 when a question can have several categories |
1028 | 1028 | if (TestCategory::getCategoryForQuestion($questionId, $courseId) == 0 && |
1029 | - $questionId > 0 && |
|
1030 | - $courseId > 0 |
|
1029 | + $questionId > 0 && |
|
1030 | + $courseId > 0 |
|
1031 | 1031 | ) { |
1032 | 1032 | $sql = "INSERT INTO $table (c_id, question_id, category_id) |
1033 | 1033 | VALUES (".intval($courseId).", ".intval($questionId).", ".intval($categoryId).")"; |
1034 | 1034 | Database::query($sql); |
1035 | - $id = Database::insert_id(); |
|
1035 | + $id = Database::insert_id(); |
|
1036 | 1036 | |
1037 | - return $id; |
|
1037 | + return $id; |
|
1038 | 1038 | } |
1039 | 1039 | |
1040 | - return false; |
|
1040 | + return false; |
|
1041 | 1041 | } |
1042 | 1042 | |
1043 | 1043 | /** |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | $row = Database::fetch_array($res); |
58 | 58 | $this->id = $row['id']; |
59 | 59 | $this->name = $row['title']; |
60 | - $this->description = $row['description']; |
|
60 | + $this->description = $row['description']; |
|
61 | 61 | } |
62 | 62 | } |
63 | 63 | |
@@ -196,7 +196,7 @@ discard block |
||
196 | 196 | /** |
197 | 197 | * @param string $in_color |
198 | 198 | */ |
199 | - public function display($in_color="#E0EBF5") |
|
199 | + public function display($in_color = "#E0EBF5") |
|
200 | 200 | { |
201 | 201 | echo "<textarea style='background-color:$in_color; width:60%; height:100px;'>"; |
202 | 202 | print_r($this); |
@@ -211,7 +211,7 @@ discard block |
||
211 | 211 | */ |
212 | 212 | public static function getCategoryListInfo($in_field = "", $courseId = "") |
213 | 213 | { |
214 | - if (empty($courseId) || $courseId=="") { |
|
214 | + if (empty($courseId) || $courseId == "") { |
|
215 | 215 | $courseId = api_get_course_int_id(); |
216 | 216 | } |
217 | 217 | $table = Database :: get_course_table(TABLE_QUIZ_QUESTION_CATEGORY); |
@@ -251,7 +251,7 @@ discard block |
||
251 | 251 | * |
252 | 252 | * @return int |
253 | 253 | */ |
254 | - public static function getCategoryForQuestion($questionId, $courseId ="") |
|
254 | + public static function getCategoryForQuestion($questionId, $courseId = "") |
|
255 | 255 | { |
256 | 256 | $result = 0; |
257 | 257 | if (empty($courseId) || $courseId == "") { |
@@ -291,11 +291,11 @@ discard block |
||
291 | 291 | $questionId, |
292 | 292 | $courseId = "" |
293 | 293 | ) { |
294 | - if (empty($courseId) || $courseId=="") { |
|
294 | + if (empty($courseId) || $courseId == "") { |
|
295 | 295 | $courseId = api_get_course_int_id(); |
296 | 296 | } |
297 | 297 | $catid = TestCategory::getCategoryForQuestion($questionId, $courseId); |
298 | - $result = ""; // result |
|
298 | + $result = ""; // result |
|
299 | 299 | $table = Database::get_course_table(TABLE_QUIZ_QUESTION_CATEGORY); |
300 | 300 | $catid = intval($catid); |
301 | 301 | $sql = "SELECT title FROM $table |
@@ -401,7 +401,7 @@ discard block |
||
401 | 401 | $categories = self::getListOfCategoriesIDForTestObject($exercise_obj); |
402 | 402 | foreach ($categories as $cat_id) { |
403 | 403 | $cat = new TestCategory($cat_id); |
404 | - $cat = (array)$cat; |
|
404 | + $cat = (array) $cat; |
|
405 | 405 | $cat['iid'] = $cat['id']; |
406 | 406 | $cat['title'] = $cat['name']; |
407 | 407 | $result[$cat['id']] = $cat; |
@@ -436,7 +436,7 @@ discard block |
||
436 | 436 | $quiz->read($exerciseId); |
437 | 437 | $tabQuestionList = $quiz->selectQuestionList(); |
438 | 438 | // the array given by selectQuestionList start at indice 1 and not at indice 0 !!! ? ? ? |
439 | - for ($i=1; $i <= count($tabQuestionList); $i++) { |
|
439 | + for ($i = 1; $i <= count($tabQuestionList); $i++) { |
|
440 | 440 | if (TestCategory::getCategoryForQuestion($tabQuestionList[$i]) == $categoryId) { |
441 | 441 | $nbCatResult++; |
442 | 442 | } |
@@ -489,7 +489,7 @@ discard block |
||
489 | 489 | } |
490 | 490 | $tabcatobject = TestCategory::getCategoryListInfo("", $courseId); |
491 | 491 | $tabresult = array("0"=>get_lang('NoCategorySelected')); |
492 | - for ($i=0; $i < count($tabcatobject); $i++) { |
|
492 | + for ($i = 0; $i < count($tabcatobject); $i++) { |
|
493 | 493 | $tabresult[$tabcatobject[$i]->id] = $tabcatobject[$i]->name; |
494 | 494 | } |
495 | 495 | return $tabresult; |
@@ -613,7 +613,7 @@ discard block |
||
613 | 613 | */ |
614 | 614 | public static function returnCategoryAndTitle($questionId, $in_display_category_name = 1) |
615 | 615 | { |
616 | - $is_student = !(api_is_allowed_to_edit(null,true) || api_is_session_admin()); |
|
616 | + $is_student = !(api_is_allowed_to_edit(null, true) || api_is_session_admin()); |
|
617 | 617 | // @todo fix $_SESSION['objExercise'] |
618 | 618 | $objExercise = isset($_SESSION['objExercise']) ? $_SESSION['objExercise'] : null; |
619 | 619 | if (!empty($objExercise)) { |
@@ -651,7 +651,7 @@ discard block |
||
651 | 651 | public static function sortTabByBracketLabel($in_tab) |
652 | 652 | { |
653 | 653 | $tabResult = array(); |
654 | - $tabCatName = array(); // tab of category name |
|
654 | + $tabCatName = array(); // tab of category name |
|
655 | 655 | while (list($cat_id, $tabquestion) = each($in_tab)) { |
656 | 656 | $catTitle = new TestCategory($cat_id); |
657 | 657 | $tabCatName[$cat_id] = $catTitle->name; |
@@ -672,7 +672,7 @@ discard block |
||
672 | 672 | */ |
673 | 673 | public static function getCatScoreForExeidForUserid($in_cat_id, $in_exe_id, $in_user_id) |
674 | 674 | { |
675 | - $tbl_track_attempt = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ATTEMPT); |
|
675 | + $tbl_track_attempt = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ATTEMPT); |
|
676 | 676 | $tbl_question_rel_category = Database::get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY); |
677 | 677 | $in_cat_id = intval($in_cat_id); |
678 | 678 | $in_exe_id = intval($in_exe_id); |
@@ -782,7 +782,7 @@ discard block |
||
782 | 782 | $table = Database::get_course_table(TABLE_QUIZ_CATEGORY); |
783 | 783 | $sql = "SELECT * FROM $table ORDER BY title ASC"; |
784 | 784 | $res = Database::query($sql); |
785 | - while ($row = Database::fetch_array($res,'ASSOC')) { |
|
785 | + while ($row = Database::fetch_array($res, 'ASSOC')) { |
|
786 | 786 | $array[] = $row; |
787 | 787 | } |
788 | 788 | return $array; |
@@ -849,7 +849,7 @@ discard block |
||
849 | 849 | |
850 | 850 | public function getForm(& $form, $action = 'new') |
851 | 851 | { |
852 | - switch($action) { |
|
852 | + switch ($action) { |
|
853 | 853 | case 'new': |
854 | 854 | $header = get_lang('AddACategory'); |
855 | 855 | $submit = get_lang('AddTestCategory'); |
@@ -921,8 +921,8 @@ discard block |
||
921 | 921 | $return .= $warning; |
922 | 922 | $return .= '<table class="data_table">'; |
923 | 923 | $return .= '<tr>'; |
924 | - $return .= '<th height="24">' . get_lang('Categories') . '</th>'; |
|
925 | - $return .= '<th width="70" height="24">' . get_lang('Number') . '</th></tr>'; |
|
924 | + $return .= '<th height="24">'.get_lang('Categories').'</th>'; |
|
925 | + $return .= '<th width="70" height="24">'.get_lang('Number').'</th></tr>'; |
|
926 | 926 | |
927 | 927 | $emptyCategory = array( |
928 | 928 | 'id' => '0', |
@@ -943,7 +943,7 @@ discard block |
||
943 | 943 | $return .= '</td>'; |
944 | 944 | $return .= '<td>'; |
945 | 945 | $value = isset($saved_categories) && isset($saved_categories[$cat_id]) ? $saved_categories[$cat_id]['count_questions'] : -1; |
946 | - $return .= '<input name="category['.$cat_id.']" value="' .$value.'" />'; |
|
946 | + $return .= '<input name="category['.$cat_id.']" value="'.$value.'" />'; |
|
947 | 947 | $return .= '</td>'; |
948 | 948 | $return .= '</tr>'; |
949 | 949 | } |
@@ -1090,20 +1090,20 @@ discard block |
||
1090 | 1090 | $tmpobj = new TestCategory($category['id']); |
1091 | 1091 | $nb_question = $tmpobj->getCategoryQuestionsNumber(); |
1092 | 1092 | $rowname = self::protectJSDialogQuote($category['title']); |
1093 | - $nb_question_label = $nb_question == 1 ? $nb_question . ' ' . get_lang('Question') : $nb_question . ' ' . get_lang('Questions'); |
|
1093 | + $nb_question_label = $nb_question == 1 ? $nb_question.' '.get_lang('Question') : $nb_question.' '.get_lang('Questions'); |
|
1094 | 1094 | |
1095 | 1095 | //$html .= '<div class="sectiontitle" id="id_cat' . $category['id'] . '">'; |
1096 | - $content = "<span style='float:right'>" . $nb_question_label . "</span>"; |
|
1096 | + $content = "<span style='float:right'>".$nb_question_label."</span>"; |
|
1097 | 1097 | |
1098 | 1098 | $content .= '<div class="sectioncomment">'; |
1099 | 1099 | $content .= $category['description']; |
1100 | 1100 | $content .= '</div>'; |
1101 | 1101 | |
1102 | - $links = '<a href="' . api_get_self() . '?action=editcategory&category_id=' . $category['id'] . '">' . |
|
1103 | - Display::return_icon('edit.png', get_lang('Edit'), array(), ICON_SIZE_SMALL) . '</a>'; |
|
1104 | - $links .= ' <a href="' . api_get_self() . '?action=deletecategory&category_id=' . $category['id'] . '" '; |
|
1105 | - $links .= 'onclick="return confirmDelete(\'' . self::protectJSDialogQuote(get_lang('DeleteCategoryAreYouSure') . '[' . $rowname) . '] ?\', \'id_cat' . $category['id'] . '\');">'; |
|
1106 | - $links .= Display::return_icon('delete.png', get_lang('Delete'), array(), ICON_SIZE_SMALL) . '</a>'; |
|
1102 | + $links = '<a href="'.api_get_self().'?action=editcategory&category_id='.$category['id'].'">'. |
|
1103 | + Display::return_icon('edit.png', get_lang('Edit'), array(), ICON_SIZE_SMALL).'</a>'; |
|
1104 | + $links .= ' <a href="'.api_get_self().'?action=deletecategory&category_id='.$category['id'].'" '; |
|
1105 | + $links .= 'onclick="return confirmDelete(\''.self::protectJSDialogQuote(get_lang('DeleteCategoryAreYouSure').'['.$rowname).'] ?\', \'id_cat'.$category['id'].'\');">'; |
|
1106 | + $links .= Display::return_icon('delete.png', get_lang('Delete'), array(), ICON_SIZE_SMALL).'</a>'; |
|
1107 | 1107 | $html .= Display::panel($content, $category['title'].$links); |
1108 | 1108 | } |
1109 | 1109 |