ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
class.ilObjTestAccess.php
Go to the documentation of this file.
1<?php
2/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */
3
4include_once "./Services/Object/classes/class.ilObjectAccess.php";
5include_once "./Modules/Test/classes/inc.AssessmentConstants.php";
6include_once './Services/AccessControl/interfaces/interface.ilConditionHandling.php';
7
20class ilObjTestAccess extends ilObjectAccess implements ilConditionHandling
21{
37 function _checkAccess($a_cmd, $a_permission, $a_ref_id, $a_obj_id, $a_user_id = "")
38 {
39 global $ilUser, $lng, $rbacsystem, $ilAccess;
40
41 if ($a_user_id == "")
42 {
43 $a_user_id = $ilUser->getId();
44 }
45
46 $is_admin = $rbacsystem->checkAccessOfUser($a_user_id,'write',$a_ref_id);
47
48 // check "global" online switch
49 if(!self::_isOnline($a_obj_id) && !$is_admin)
50 {
51 $ilAccess->addInfoItem(IL_NO_OBJECT_ACCESS, $lng->txt("offline"));
52 return false;
53 }
54
55 switch ($a_permission)
56 {
57 case "visible":
58 case "read":
59 if (!ilObjTestAccess::_lookupCreationComplete($a_obj_id) &&
60 !$is_admin)
61 {
62 $ilAccess->addInfoItem(IL_NO_OBJECT_ACCESS, $lng->txt("tst_warning_test_not_complete"));
63 return false;
64 }
65 break;
66 }
67
68 switch ($a_cmd)
69 {
70 case "eval_a":
71 case "eval_stat":
72 if (!ilObjTestAccess::_lookupCreationComplete($a_obj_id))
73 {
74 $ilAccess->addInfoItem(IL_NO_OBJECT_ACCESS, $lng->txt("tst_warning_test_not_complete"));
75 return false;
76 }
77 break;
78
79 }
80
81 return true;
82 }
83
92 function _getMaxPointsForTestPass($random, $user_id, $test_id, $pass)
93 {
94 global $ilDB;
95 $max = 0;
96 if ($random)
97 {
98 $result = $ilDB->queryF("SELECT SUM(qpl_questions.points) maxpoints FROM tst_test_rnd_qst, qpl_questions, tst_active WHERE tst_active.active_id = tst_test_rnd_qst.active_fi AND tst_test_rnd_qst.question_fi = qpl_questions.question_id AND tst_active.test_fi = %s AND tst_test_rnd_qst.pass = %s AND tst_active.user_fi = %s",
99 array('integer','integer','integer'),
100 array($test_id, $pass, $user_id)
101 );
102 if ($result->numRows())
103 {
104 $row = $ilDB->fetchAssoc($result);
105 $max = $row["maxpoints"];
106 }
107 }
108 else
109 {
110 $result = $ilDB->queryF("SELECT SUM(qpl_questions.points) maxpoints FROM tst_test_question, qpl_questions WHERE tst_test_question.question_fi = qpl_questions.question_id AND tst_test_question.test_fi = %s",
111 array('integer'),
112 array($test_id)
113 );
114 if ($result->numRows())
115 {
116 $row = $ilDB->fetchAssoc($result);
117 $max = $row["maxpoints"];
118 }
119 }
120 return $max;
121 }
122
130 public static function _isPassed($user_id, $a_obj_id)
131 {
132 global $ilDB;
133 $result = $ilDB->queryF("SELECT tst_result_cache.* FROM tst_result_cache, tst_active, tst_tests WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s AND tst_tests.obj_fi = %s AND tst_result_cache.active_fi = tst_active.active_id",
134 array('integer','integer'),
135 array($user_id, $a_obj_id)
136 );
137 if (!$result->numRows())
138 {
139 $result = $ilDB->queryF("SELECT tst_active.active_id FROM tst_active, tst_tests WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s AND tst_tests.obj_fi = %s",
140 array('integer','integer'),
141 array($user_id, $a_obj_id)
142 );
143 $row = $ilDB->fetchAssoc($result);
144 if ($row['active_id'] > 0)
145 {
146 include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
147 assQuestion::_updateTestResultCache($row['active_id']);
148 }
149 else
150 {
151 return false;
152 }
153 }
154 $result = $ilDB->queryF("SELECT tst_result_cache.* FROM tst_result_cache, tst_active, tst_tests WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s AND tst_tests.obj_fi = %s AND tst_result_cache.active_fi = tst_active.active_id",
155 array('integer','integer'),
156 array($user_id, $a_obj_id)
157 );
158 if (!$result->numRows())
159 {
160 $result = $ilDB->queryF("SELECT tst_pass_result.*, tst_tests.pass_scoring, tst_tests.random_test, tst_tests.test_id FROM tst_pass_result, tst_active, tst_tests WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s AND tst_tests.obj_fi = %s AND tst_pass_result.active_fi = tst_active.active_id ORDER BY tst_pass_result.pass",
161 array('integer','integer'),
162 array($user_id, $a_obj_id)
163 );
164 $points = array();
165 while ($row = $ilDB->fetchAssoc($result))
166 {
167 array_push($points, $row);
168 }
169 $reached = 0;
170 $max = 0;
171 if ($points[0]["pass_scoring"] == 0)
172 {
173 $reached = $points[count($points)-1]["points"];
174 $max = $points[count($points)-1]["maxpoints"];
175 if (!$max)
176 {
177 $active_id = $points[count($points)-1]["active_fi"];
178 $pass = $points[count($points)-1]["pass"];
179 if (strlen($active_id) && strlen($pass))
180 {
181 include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
182 $res = assQuestion::_updateTestPassResults($active_id, $pass, null, $a_obj_id);
183 $max = $res['maxpoints'];
184 $reached = $res['points'];
185 }
186 }
187 }
188 else
189 {
190 foreach ($points as $row)
191 {
192 if ($row["points"] > $reached)
193 {
194 $reached = $row["points"];
195 $max = $row["maxpoints"];
196 if (!$max)
197 {
198 $active_id = $row["active_fi"];
199 $pass = $row["pass"];
200 if (strlen($active_id) && strlen($pass))
201 {
202 include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
203 $res = assQuestion::_updateTestPassResults($active_id, $pass, null, $a_obj_id);
204 $max = $res['maxpoints'];
205 $reached = $res['points'];
206 }
207 }
208 }
209 }
210 }
211 include_once "./Modules/Test/classes/class.assMarkSchema.php";
212 $percentage = (!$max) ? 0 : ($reached / $max) * 100.0;
213 $mark = ASS_MarkSchema::_getMatchingMarkFromObjId($a_obj_id, $percentage);
214 return ($mark["passed"]) ? TRUE : FALSE;
215 }
216 else
217 {
218 $row = $ilDB->fetchAssoc($result);
219 return ($row['passed']) ? true : false;
220 }
221 }
222
230 public static function isFailed($user_id, $a_obj_id)
231 {
232 global $ilDB;
233
234 $ret = self::updateTestResultCache($user_id, $a_obj_id);
235
236 if(!$ret)
237 {
238 return false;
239 }
240
241 $result = $ilDB->queryF("SELECT tst_result_cache.* FROM tst_result_cache, tst_active, tst_tests WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s AND tst_tests.obj_fi = %s AND tst_result_cache.active_fi = tst_active.active_id",
242 array('integer','integer'),
243 array($user_id, $a_obj_id)
244 );
245
246 if (!$result->numRows())
247 {
248 $result = $ilDB->queryF("SELECT tst_pass_result.*, tst_tests.pass_scoring, tst_tests.random_test, tst_tests.test_id FROM tst_pass_result, tst_active, tst_tests WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s AND tst_tests.obj_fi = %s AND tst_pass_result.active_fi = tst_active.active_id ORDER BY tst_pass_result.pass",
249 array('integer','integer'),
250 array($user_id, $a_obj_id)
251 );
252
253 while ($row = $ilDB->fetchAssoc($result))
254 {
255 array_push($points, $row);
256 }
257 $reached = 0;
258 $max = 0;
259 if ($points[0]["pass_scoring"] == 0)
260 {
261 $reached = $points[count($points)-1]["points"];
262 $max = $points[count($points)-1]["maxpoints"];
263 if (!$max)
264 {
265 $active_id = $points[count($points)-1]["active_fi"];
266 $pass = $points[count($points)-1]["pass"];
267 if (strlen($active_id) && strlen($pass))
268 {
269 include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
270 $res = assQuestion::_updateTestPassResults($active_id, $pass, null, $a_obj_id);
271 $max = $res['maxpoints'];
272 $reached = $res['points'];
273 }
274 }
275 }
276 else
277 {
278 foreach ($points as $row)
279 {
280 if ($row["points"] > $reached)
281 {
282 $reached = $row["points"];
283 $max = $row["maxpoints"];
284 if (!$max)
285 {
286 $active_id = $row["active_fi"];
287 $pass = $row["pass"];
288 if (strlen($active_id) && strlen($pass))
289 {
290 include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
291 $res = assQuestion::_updateTestPassResults($active_id, $pass, null, $a_obj_id);
292 $max = $res['maxpoints'];
293 $reached = $res['points'];
294 }
295 }
296 }
297 }
298 }
299 include_once "./Modules/Test/classes/class.assMarkSchema.php";
300 $percentage = (!$max) ? 0 : ($reached / $max) * 100.0;
301 $mark = ASS_MarkSchema::_getMatchingMarkFromObjId($a_obj_id, $percentage);
302 return ($mark["failed"]) ? TRUE : FALSE;
303 }
304 else
305 {
306 $row = $ilDB->fetchAssoc($result);
307 return ($row['failed']) ? TRUE : FALSE;
308 }
309 }
310
316 protected function updateTestResultCache($a_user_id, $a_obj_id)
317 {
318 global $ilDB;
319
320 $result = $ilDB->queryF(
321 "SELECT tst_result_cache.* FROM tst_result_cache, tst_active, tst_tests ".
322 "WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s ".
323 "AND tst_tests.obj_fi = %s AND tst_result_cache.active_fi = tst_active.active_id",
324 array('integer','integer'),
325 array($a_user_id, $a_obj_id)
326 );
327 if (!$result->numRows())
328 {
329 $result = $ilDB->queryF("SELECT tst_active.active_id FROM tst_active, tst_tests WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s AND tst_tests.obj_fi = %s",
330 array('integer','integer'),
331 array($a_user_id, $a_obj_id)
332 );
333 $row = $ilDB->fetchAssoc($result);
334 if ($row['active_id'] > 0)
335 {
336 include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
337 assQuestion::_updateTestResultCache($row['active_id']);
338 return true;
339 }
340 else
341 {
342 return false;
343 }
344
345 }
346 else
347 {
348 return true;
349 }
350 }
351
352
356 public static function getConditionOperators()
357 {
358 include_once './Services/AccessControl/classes/class.ilConditionHandler.php';
359 return array(
360 ilConditionHandler::OPERATOR_PASSED,
361 ilConditionHandler::OPERATOR_FAILED,
362 ilConditionHandler::OPERATOR_FINISHED,
363 ilConditionHandler::OPERATOR_NOT_FINISHED
364 );
365 }
366
367
373 public static function checkCondition($a_obj_id, $a_operator, $a_value, $a_usr_id)
374 {
375 include_once './Services/AccessControl/classes/class.ilConditionHandler.php';
376
377 switch($a_operator)
378 {
379 case ilConditionHandler::OPERATOR_PASSED:
380 return ilObjTestAccess::_isPassed($a_usr_id, $a_obj_id);
381 break;
382
383 case ilConditionHandler::OPERATOR_FAILED:
384 return ilObjTestAccess::isFailed($a_usr_id, $a_obj_id);
385
386 case ilConditionHandler::OPERATOR_FINISHED:
387 return ilObjTestAccess::hasFinished($a_usr_id,$a_obj_id);
388
389 case ilConditionHandler::OPERATOR_NOT_FINISHED:
390 return !ilObjTestAccess::hasFinished($a_usr_id,$a_obj_id);
391
392 default:
393 return true;
394 }
395 return true;
396 }
397
410 function _getCommands()
411 {
412 $commands = array
413 (
414 array("permission" => "write", "cmd" => "questionsTabGateway", "lang_var" => "tst_edit_questions"),
415 array("permission" => "write", "cmd" => "ilObjTestSettingsGeneralGUI::showForm", "lang_var" => "settings"),
416 array("permission" => "read", "cmd" => "infoScreen", "lang_var" => "tst_run",
417 "default" => true),
418 //array("permission" => "write", "cmd" => "", "lang_var" => "edit"),
419 array("permission" => "tst_statistics", "cmd" => "outEvaluation", "lang_var" => "tst_statistical_evaluation"),
420 array("permission" => "read", "cmd" => "userResultsGateway", "lang_var" => "tst_test_results")
421 );
422
423 return $commands;
424 }
425
426 //
427 // object specific access related methods
428 //
429
433 function _lookupCreationComplete($a_obj_id)
434 {
435 global $ilDB;
436
437 $result = $ilDB->queryF("SELECT complete FROM tst_tests WHERE obj_fi=%s",
438 array('integer'),
439 array($a_obj_id)
440 );
441 if ($result->numRows() == 1)
442 {
443 $row = $ilDB->fetchAssoc($result);
444 }
445
446 return ($row['complete']) ? true : false;
447 }
448
454 private static $hasFinishedCache = array();
455
463 public static function hasFinished($a_user_id, $a_obj_id)
464 {
465 if( !isset(self::$hasFinishedCache["{$a_user_id}:{$a_obj_id}"]) )
466 {
467 require_once 'Modules/Test/classes/class.ilTestParticipantData.php';
468 require_once 'Modules/Test/classes/class.ilTestSessionFactory.php';
469 require_once 'Modules/Test/classes/class.ilTestPassesSelector.php';
470
471 global $ilDB, $lng;
472
473 $testOBJ = ilObjectFactory::getInstanceByObjId($a_obj_id);
474
475 $partData = new ilTestParticipantData($ilDB, $lng);
476 $partData->setUserIds(array($a_user_id));
477 $partData->load($testOBJ->getTestId());
478
479 $activeId = $partData->getActiveIdByUserId($a_user_id);
480
481 $testSessionFactory = new ilTestSessionFactory($testOBJ);
482 $testSession = $testSessionFactory->getSession($activeId);
483
484 $testPassesSelector = new ilTestPassesSelector($ilDB, $testOBJ);
485 $testPassesSelector->setActiveId($activeId);
486 $testPassesSelector->setLastFinishedPass($testSession->getLastFinishedPass());
487
488 self::$hasFinishedCache["{$a_user_id}:{$a_obj_id}"] = count($testPassesSelector->getClosedPasses());
489 }
490
491 return self::$hasFinishedCache["{$a_user_id}:{$a_obj_id}"];
492 }
493
501 function _getTestIDFromObjectID($object_id)
502 {
503 global $ilDB;
504 $test_id = FALSE;
505 $result = $ilDB->queryF("SELECT test_id FROM tst_tests WHERE obj_fi = %s",
506 array('integer'),
507 array($object_id)
508 );
509 if ($result->numRows())
510 {
511 $row = $ilDB->fetchAssoc($result);
512 $test_id = $row["test_id"];
513 }
514 return $test_id;
515 }
516
517 function &_getTestQuestions($active_id, $pass = NULL)
518 {
519 if (is_null($pass))
520 {
521 $pass = 0;
522 }
523 $questions = array();
524
525 global $ilDB;
526 $result = $ilDB->queryF("SELECT test_fi FROM tst_active WHERE active_id = %s",
527 array('integer'),
528 array($active_id)
529 );
530 $test_id = "";
531 if ($result->numRows())
532 {
533 $row = $ilDB->fetchAssoc($result);
534 $test_id = $row["test_fi"];
535 }
536 else
537 {
538 return $questions;
539 }
540 $result = $ilDB->queryF("SELECT qpl_questions.question_id, qpl_questions.points FROM qpl_questions, tst_test_question WHERE tst_test_question.question_fi = qpl_questions.question_id AND tst_test_question.test_fi = %s ORDER BY tst_test_question.sequence",
541 array('integer'),
542 array($test_id)
543 );
544 if ($result->numRows())
545 {
546 // standard test
547 while ($row = $ilDB->fetchAssoc($result))
548 {
549 array_push($questions, $row);
550 }
551 }
552 else
553 {
554 // random test
555 $result = $ilDB->queryF("SELECT qpl_questions.question_id, qpl_questions.points FROM qpl_questions, tst_test_rnd_qst WHERE tst_test_rnd_qst.question_fi = qpl_questions.question_id AND tst_test_rnd_qst.active_fi = %s AND tst_test_rnd_qst.pass = %s ORDER BY tst_test_rnd_qst.sequence",
556 array('integer','integer'),
557 array($active_id, $pass)
558 );
559 if ($result->numRows())
560 {
561 while ($row = $ilDB->fetchAssoc($result))
562 {
563 array_push($questions, $row);
564 }
565 }
566 }
567 return $questions;
568 }
569
576 function _isComplete($a_obj_id)
577 {
578 global $ilDB;
579
580 $query = "
581 SELECT tst_tests.complete
582 FROM object_data
583 INNER JOIN tst_tests
584 ON tst_tests.obj_fi = object_data.obj_id
585 WHERE object_data.obj_id = %s
586 ";
587
588 $res = $ilDB->queryF($query, array('integer'), array($a_obj_id));
589
590 while( $row = $ilDB->fetchAssoc($res) )
591 {
592 return (bool)$row['complete'];
593 }
594
595 return false;
596 }
597
605 function &_getTestData($test_id)
606 {
607 global $ilDB;
608 $result = $ilDB->queryF("SELECT * FROM tst_tests WHERE test_id = %s",
609 array('integer'),
610 array($test_id)
611 );
612 if (!$result->numRows())
613 {
614 return 0;
615 }
616 return $ilDB->fetchAssoc($result);
617 }
618
625 function _lookupObjIdForTestId($a_test_id)
626 {
627 global $ilDB;
628
629 $result = $ilDB->queryF("SELECT obj_fi FROM tst_tests WHERE test_id = %s",
630 array('integer'),
631 array($a_test_id)
632 );
633
634 $row = $ilDB->fetchAssoc($result);
635 return $row["obj_fi"];
636 }
637
645 function _getRandomTestsForQuestionPool($qpl_id)
646 {
647 global $ilDB;
648
649 $query = "
650 SELECT DISTINCT t.obj_fi
651 FROM tst_tests t
652 INNER JOIN tst_rnd_quest_set_qpls r
653 ON t.test_id = r.test_fi
654 WHERE r.pool_fi = %s
655 ";
656
657 $result = $ilDB->queryF($query, array('integer'), array($qpl_id));
658
659 $tests = array();
660 while ($row = $ilDB->fetchAssoc($result))
661 {
662 $tests[] = $row['obj_fi'];
663 }
664
665 return $tests;
666 }
667 // fim.
668
675 function _lookupOnlineTestAccess($a_test_id, $a_user_id)
676 {
677 global $ilDB, $lng;
678
679 $result = $ilDB->queryF("SELECT tst_tests.* FROM tst_tests WHERE tst_tests.obj_fi = %s",
680 array('integer'),
681 array($a_test_id)
682 );
683 if ($result->numRows())
684 {
685 $row = $ilDB->fetchAssoc($result);
686 if ($row["fixed_participants"])
687 {
688 $result = $ilDB->queryF("SELECT * FROM tst_invited_user WHERE test_fi = %s AND user_fi = %s",
689 array('integer','integer'),
690 array($row["test_id"], $a_user_id)
691 );
692 if ($result->numRows())
693 {
694 $row = $ilDB->fetchAssoc($result);
695 if (trim($row['clientip']) != "")
696 {
697 $row['clientip'] = preg_replace("/[^0-9.?*,:]+/","",$row['clientip']);
698 $row['clientip'] = str_replace(".","\\.",$row['clientip']);
699 $row['clientip'] = str_replace(Array("?","*",","), Array("[0-9]","[0-9]*","|"), $row['clientip']);
700 if (!preg_match("/^".$row['clientip']."$/", $_SERVER["REMOTE_ADDR"]))
701 {
702 return $lng->txt("tst_user_wrong_clientip");
703 }
704 else
705 {
706 return true;
707 }
708 }
709 else
710 {
711 return true;
712 }
713 }
714 else
715 {
716 return $lng->txt("tst_user_not_invited");
717 }
718 }
719 else
720 {
721 return true;
722 }
723 }
724 else
725 {
726 return true;
727 }
728 }
729
737 function _getParticipantData($active_id)
738 {
739 global $lng, $ilDB;
740
741 $result = $ilDB->queryF("SELECT * FROM tst_active WHERE active_id = %s",
742 array("integer"),
743 array($active_id)
744 );
745 $row = $ilDB->fetchAssoc($result);
746 $user_id = $row["user_fi"];
747 $test_id = $row["test_fi"];
748 $importname = $row['importname'];
749
750 $result = $ilDB->queryF("SELECT obj_fi FROM tst_tests WHERE test_id = %s",
751 array("integer"),
752 array($test_id)
753 );
754 $row = $ilDB->fetchAssoc($result);
755 $obj_id = $row["obj_fi"];
756
757 include_once "./Modules/Test/classes/class.ilObjTest.php";
758 $is_anonymous = ilObjTest::_lookupAnonymity($obj_id);
759
760 include_once './Services/User/classes/class.ilObjUser.php';
761 $uname = ilObjUser::_lookupName($user_id);
762
763 $name = "";
764 if (strlen($importname))
765 {
766 $name = $importname . ' (' . $lng->txt('imported') . ')';
767 }
768 else if (strlen($uname["firstname"].$uname["lastname"]) == 0)
769 {
770 $name = $lng->txt("deleted_user");
771 }
772 else
773 {
774 if ($user_id == ANONYMOUS_USER_ID)
775 {
776 $name = $lastname;
777 }
778 else
779 {
780 $name = trim($uname["lastname"] . ", " . $uname["firstname"] . " " . $uname["title"]);
781 }
782 if ($is_anonymous)
783 {
784 $name = $lng->txt("anonymous");
785 }
786 }
787 return $name;
788 }
789
796 function _getParticipantId($active_id)
797 {
798 global $lng, $ilDB;
799
800 $result = $ilDB->queryF("SELECT user_fi FROM tst_active WHERE active_id = %s",
801 array("integer"),
802 array($active_id)
803 );
804 $row = $ilDB->fetchAssoc($result);
805 return $row["user_fi"];
806 }
807
808
823 function &_getPassedUsers($a_obj_id)
824 {
825 global $ilDB;
826
827 $passed_users = array();
828 // Maybe SELECT DISTINCT(tst_active.user_fi)... ?
829 $userresult = $ilDB->queryF("
830 SELECT tst_active.active_id, COUNT(tst_sequence.active_fi) sequences
831 FROM tst_tests
832 INNER JOIN tst_active
833 ON tst_active.test_fi = tst_tests.test_id
834 LEFT JOIN tst_sequence
835 ON tst_sequence.active_fi = tst_active.active_id
836 WHERE tst_tests.obj_fi = %s
837 GROUP BY tst_active.active_id
838 ",
839 array('integer'), array($a_obj_id)
840 );
841 $all_participants = array();
842 $notAttempted = array();
843 while ($row = $ilDB->fetchAssoc($userresult))
844 {
845 if($row['sequences'] == 0)
846 {
847 $notAttempted[$row['active_id']] = $row['active_id'];
848 }
849
850 $all_participants[$row['active_id']] = $row['active_id'];
851 }
852
853 $result = $ilDB->query("SELECT tst_result_cache.*, tst_active.user_fi FROM tst_result_cache, tst_active WHERE tst_active.active_id = tst_result_cache.active_fi AND " . $ilDB->in('active_fi', $all_participants, false, 'integer'));
854 $found_all = ($result->numRows() == count($all_participants)) ? true : false;
855 if (!$found_all)
856 {
857 // if the result cache entries do not exist, create them
858 $found_participants = array();
859 while ($data = $ilDB->fetchAssoc($result))
860 {
861 array_push($found_participants, $data['active_fi']);
862 }
863 foreach ($all_participants as $active_id)
864 {
865 if (!in_array($active_id, $found_participants))
866 {
867 include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
868 assQuestion::_updateTestResultCache($active_id);
869 }
870 }
871 $result = $ilDB->query("SELECT tst_result_cache.*, tst_active.user_fi FROM tst_result_cache, tst_active WHERE tst_active.active_id = tst_result_cache.active_fi AND " . $ilDB->in('active_fi', $all_participants, false, 'integer'));
872 }
873 while ($data = $ilDB->fetchAssoc($result))
874 {
875 if( isset($notAttempted[$data['active_fi']]) )
876 {
877 $data['failed'] = 0;
878 $data['passed'] = 0;
879 }
880
881 $data['user_id'] = $data['user_fi'];
882 array_push($passed_users, $data);
883 }
884 return $passed_users;
885 }
886
890 function _checkGoto($a_target)
891 {
892 global $ilAccess;
893
894 $t_arr = explode("_", $a_target);
895
896 if ($t_arr[0] != "tst" || ((int) $t_arr[1]) <= 0)
897 {
898 return false;
899 }
900
901 if ($ilAccess->checkAccess("read", "", $t_arr[1]))
902 {
903 return true;
904 }
905 return false;
906 }
907
916 static function _isOffline($a_obj_id)
917 {
918// global $ilUser;
919// return (self::_lookupOnlineTestAccess($a_obj_id, $ilUser->getId()) !== true) ||
920// (!ilObjTestAccess::_lookupCreationComplete($a_obj_id));
921 return !self::_isOnline($a_obj_id);
922 }
923
930 public static function _isOnline($a_obj_id)
931 {
932 global $ilDB;
933
934 $query = "
935 SELECT test_id
936 FROM tst_tests
937 WHERE obj_fi = %s
938 AND online_status = 1
939 ";
940
941 $result = $ilDB->queryF( $query, array('integer'), array($a_obj_id) );
942
943 return $result->numRows() == 1;
944 }
945
946 public static function visibleUserResultExists($testObjId, $userId)
947 {
948 $testOBJ = ilObjectFactory::getInstanceByObjId($testObjId, false);
949
950 if( !($testOBJ instanceof ilObjTest) )
951 {
952 return false;
953 }
954
955 require_once 'Modules/Test/classes/class.ilTestSessionFactory.php';
956 $testSessionFactory = new ilTestSessionFactory($testOBJ);
957 $testSession = $testSessionFactory->getSessionByUserId($userId);
958
959 return $testOBJ->canShowTestResults($testSession);
960 }
961}
$result
$result
Definition: CleanUpTest.php:407
$ret
$ret
Definition: Structures_BibTex_example.php:7
ASS_MarkSchema\_getMatchingMarkFromObjId
_getMatchingMarkFromObjId($a_obj_id, $percentage)
Returns the matching mark for a given percentage.
Definition: class.assMarkSchema.php:355
IL_NO_OBJECT_ACCESS
const IL_NO_OBJECT_ACCESS
Definition: class.ilAccessInfo.php:26
assQuestion\_updateTestResultCache
_updateTestResultCache($active_id, ilAssQuestionProcessLocker $processLocker=null)
@TODO Move this to a proper place.
Definition: class.assQuestion.php:1247
ilObjTestAccess
Class ilObjTestAccess.
Definition: class.ilObjTestAccess.php:21
ilObjTestAccess\_lookupCreationComplete
_lookupCreationComplete($a_obj_id)
checks wether all necessary parts of the test are given
Definition: class.ilObjTestAccess.php:433
ilObjTestAccess\hasFinished
static hasFinished($a_user_id, $a_obj_id)
Returns (request cached) information if a specific user has finished at least one test pass.
Definition: class.ilObjTestAccess.php:463
ilObjTestAccess\_lookupOnlineTestAccess
_lookupOnlineTestAccess($a_test_id, $a_user_id)
Checks if a user is allowd to run an online exam.
Definition: class.ilObjTestAccess.php:675
ilObjTestAccess\_getTestIDFromObjectID
_getTestIDFromObjectID($object_id)
Returns the ILIAS test id for a given object id.
Definition: class.ilObjTestAccess.php:501
ilObjTestAccess\_getRandomTestsForQuestionPool
_getRandomTestsForQuestionPool($qpl_id)
Get all tests using a question pool for random selection.
Definition: class.ilObjTestAccess.php:645
ilObjTestAccess\getConditionOperators
static getConditionOperators()
Get possible conditions operators.
Definition: class.ilObjTestAccess.php:356
ilObjTestAccess\_getTestQuestions
& _getTestQuestions($active_id, $pass=NULL)
Definition: class.ilObjTestAccess.php:517
ilObjTestAccess\_checkGoto
_checkGoto($a_target)
check whether goto script will succeed
Definition: class.ilObjTestAccess.php:890
ilObjTestAccess\checkCondition
static checkCondition($a_obj_id, $a_operator, $a_value, $a_usr_id)
check condition
Definition: class.ilObjTestAccess.php:373
ilObjTestAccess\_getParticipantId
_getParticipantId($active_id)
Get user id for active id.
Definition: class.ilObjTestAccess.php:796
ilObjTestAccess\_isOffline
static _isOffline($a_obj_id)
returns the objects's OFFline status
Definition: class.ilObjTestAccess.php:916
ilObjTestAccess\_isPassed
static _isPassed($user_id, $a_obj_id)
Returns TRUE if the user with the user id $user_id passed the test with the object id $a_obj_id.
Definition: class.ilObjTestAccess.php:130
ilObjTestAccess\visibleUserResultExists
static visibleUserResultExists($testObjId, $userId)
Definition: class.ilObjTestAccess.php:946
ilObjTestAccess\isFailed
static isFailed($user_id, $a_obj_id)
Returns TRUE if the user with the user id $user_id failed the test with the object id $a_obj_id.
Definition: class.ilObjTestAccess.php:230
ilObjTestAccess\_checkAccess
_checkAccess($a_cmd, $a_permission, $a_ref_id, $a_obj_id, $a_user_id="")
Checks wether a user may invoke a command or not (this method is called by ilAccessHandler::checkAcce...
Definition: class.ilObjTestAccess.php:37
ilObjTestAccess\_getCommands
_getCommands()
get commands
Definition: class.ilObjTestAccess.php:410
ilObjTestAccess\_lookupObjIdForTestId
_lookupObjIdForTestId($a_test_id)
Lookup object id for test id.
Definition: class.ilObjTestAccess.php:625
ilObjTestAccess\_getParticipantData
_getParticipantData($active_id)
Retrieves a participant name from active id.
Definition: class.ilObjTestAccess.php:737
ilObjTestAccess\_isOnline
static _isOnline($a_obj_id)
returns the objects's ONline status
Definition: class.ilObjTestAccess.php:930
ilObjTestAccess\_isComplete
_isComplete($a_obj_id)
Returns true, if a test is complete for use.
Definition: class.ilObjTestAccess.php:576
ilObjTestAccess\_getPassedUsers
& _getPassedUsers($a_obj_id)
Returns an array containing the users who passed the test.
Definition: class.ilObjTestAccess.php:823
ilObjTestAccess\updateTestResultCache
updateTestResultCache($a_user_id, $a_obj_id)
Update test result cache.
Definition: class.ilObjTestAccess.php:316
ilObjTestAccess\_getMaxPointsForTestPass
_getMaxPointsForTestPass($random, $user_id, $test_id, $pass)
Returns the maximum number of points available for a test pass.
Definition: class.ilObjTestAccess.php:92
ilObjTestAccess\_getTestData
& _getTestData($test_id)
Returns the database content of a test with a given id.
Definition: class.ilObjTestAccess.php:605
ilObjTest\_lookupAnonymity
_lookupAnonymity($a_obj_id)
Returns the anonymity status of a test with a given object id.
Definition: class.ilObjTest.php:9612
ilObjUser\_lookupName
static _lookupName($a_user_id)
lookup user name
Definition: class.ilObjUser.php:778
ilObjectAccess
Class ilObjectAccess.
Definition: class.ilObjectAccess.php:17
ilObjectFactory\getInstanceByObjId
getInstanceByObjId($a_obj_id, $stop_on_error=true)
get an instance of an Ilias object by object id
Definition: class.ilObjectFactory.php:72
$data
$data
Definition: example_011.php:126
ilConditionHandling
Interface for condition handling.
Definition: interface.ilConditionHandling.php:11
$lng
global $lng
Definition: privfeed.php:40
$ilDB
global $ilDB
Definition: storeScorm2004.php:19
$_SERVER
if((!isset($_SERVER['DOCUMENT_ROOT'])) OR(empty($_SERVER['DOCUMENT_ROOT']))) $_SERVER['DOCUMENT_ROOT']
Definition: tcpdf_autoconfig.php:54
$ilUser
global $ilUser
Definition: imgupload.php:15