Inheritance diagram for ilAssQuestionList:

Collaboration diagram for ilAssQuestionList:

Public Member Functions
	__construct (private ilDBInterface $db, private ilLanguage $lng, private Refinery $refinery, private ilComponentRepository $component_repository, private ?NotesService $notes_service=null)

	getParentObjId ()

	setParentObjId ($parentObjId)

	getParentObjectType ()

	setParentObjectType ($parentObjType)

	getParentObjIdsFilter ()

	setParentObjIdsFilter ($parentObjIdsFilter)

	setQuestionInstanceTypeFilter ($questionInstanceTypeFilter)

	getQuestionInstanceTypeFilter ()

	setIncludeQuestionIdsFilter ($questionIdsFilter)

	getIncludeQuestionIdsFilter ()

	getExcludeQuestionIdsFilter ()

	setExcludeQuestionIdsFilter ($excludeQuestionIdsFilter)

	getQuestionCompletionStatusFilter ()

	setQuestionCompletionStatusFilter ($questionCompletionStatusFilter)

	addFieldFilter ($fieldName, $fieldValue)

	addTaxonomyFilter ($taxId, $taxNodes, $parentObjId, $parentObjType)

	addTaxonomyFilterNoTaxonomySet (bool $flag)

	setAvailableTaxonomyIds ($availableTaxonomyIds)

	getAvailableTaxonomyIds ()

	setAnswerStatusActiveId ($answerStatusActiveId)

	getAnswerStatusActiveId ()

	setAnswerStatusFilter ($answerStatusFilter)

	getAnswerStatusFilter ()

	setJoinObjectData ($a_val)
	Set if object data table should be joined. More...

	getJoinObjectData ()
	Get if object data table should be joined. More...

	setForcedQuestionIds ($forcedQuestionIds)

	getForcedQuestionIds ()

	load ()

	setCommentFilter (int $commented=null)

	getDataArrayForQuestionId ($questionId)

	getQuestionDataArray ()

	isInList ($questionId)

	getTitle (string $a_comp_id, string $a_item_type, int $a_item_id)
	Get title of an assigned item. More...

Data Fields
const	QUESTION_ANSWER_STATUS_NON_ANSWERED = 'nonAnswered'
	answer status domain for single questions More...

const	QUESTION_ANSWER_STATUS_WRONG_ANSWERED = 'wrongAnswered'

const	QUESTION_ANSWER_STATUS_CORRECT_ANSWERED = 'correctAnswered'

const	ANSWER_STATUS_FILTER_ALL_NON_CORRECT = 'allNonCorrect'
	answer status filter value domain More...

const	ANSWER_STATUS_FILTER_NON_ANSWERED_ONLY = 'nonAnswered'

const	ANSWER_STATUS_FILTER_WRONG_ANSWERED_ONLY = 'wrongAnswered'

const	QUESTION_INSTANCE_TYPE_ORIGINALS = 'QST_INSTANCE_TYPE_ORIGINALS'

const	QUESTION_INSTANCE_TYPE_DUPLICATES = 'QST_INSTANCE_TYPE_DUPLICATES'

const	QUESTION_INSTANCE_TYPE_ALL = 'QST_INSTANCE_TYPE_ALL'

const	QUESTION_COMPLETION_STATUS_COMPLETE = 'complete'

const	QUESTION_COMPLETION_STATUS_INCOMPLETE = 'incomplete'

const	QUESTION_COMPLETION_STATUS_BOTH = 'complete/incomplete'

const	QUESTION_COMMENTED_ONLY = '1'

const	QUESTION_COMMENTED_EXCLUDED = '2'

Protected Member Functions
	getTaxItems ($parentType, $parentObjId, $taxId, $taxNode)

	getNumberOfCommentsForQuestion (int $question_id)

	hasFeedback (int $question_id)

	hasHints (int $question_id)

Protected Attributes
bool	$join_obj_data = true

string	$filter_comments = null

array	$questions = []

Private Member Functions
	getParentObjFilterExpression ()

	getFieldFilterExpressions ()

	getTaxonomyFilterExpressions ()

	getQuestionInstanceTypeFilterExpression ()

	getQuestionIdsFilterExpressions ()

	getParentObjectIdFilterExpression ()

	getAnswerStatusFilterExpressions ()

	getTableJoinExpression ()

	getConditionalFilterExpression ()

	getSelectFieldsExpression ()

	buildBasicQuery ()

	buildQuery ()

	loadTaxonomyAssignmentData ($parentObjId, $questionId)

	isActiveQuestionType (array $questionData)

	checkFilters ()

Private Attributes
array	$parentObjIdsFilter = []

int	$parentObjId = null

string	$parentObjType = 'qpl'

array	$availableTaxonomyIds = []

array	$fieldFilters = []

array	$taxFilters = []

bool	$taxFiltersExcludeAnyObjectsWithTaxonomies = false

array	$taxParentIds = []

array	$taxParentTypes = []

int	$answerStatusActiveId = null

array	$forcedQuestionIds = []

	$answerStatusFilter = null

string	$questionInstanceTypeFilter = self::QUESTION_INSTANCE_TYPE_ORIGINALS

	$includeQuestionIdsFilter = null

	$excludeQuestionIdsFilter = null

string	$questionCompletionStatusFilter = self::QUESTION_COMPLETION_STATUS_BOTH

Detailed Description

Definition at line 28 of file class.ilAssQuestionList.php.

Constructor & Destructor Documentation

◆ __construct()

ilAssQuestionList::__construct	(	private ilDBInterface	$db,
		private ilLanguage	$lng,
		private Refinery	$refinery,
		private ilComponentRepository	$component_repository,
		private ?NotesService	$notes_service = `null`
	)

Definition at line 78 of file class.ilAssQuestionList.php.

84 {

85 }

Member Function Documentation

◆ addFieldFilter()

ilAssQuestionList::addFieldFilter	(	$fieldName,
		$fieldValue
	)

Definition at line 160 of file class.ilAssQuestionList.php.

                                                            : void
     {
         $this->fieldFilters[$fieldName] = $fieldValue;
     }

◆ addTaxonomyFilter()

ilAssQuestionList::addTaxonomyFilter	(	$taxId,
		$taxNodes,
		$parentObjId,
		$parentObjType
	)

Definition at line 165 of file class.ilAssQuestionList.php.

References $parentObjId, and $parentObjType.

                                                                                       : void
     {
         $this->taxFilters[$taxId] = $taxNodes;
         $this->taxParentIds[$taxId] = $parentObjId;
         $this->taxParentTypes[$taxId] = $parentObjType;
     }

◆ addTaxonomyFilterNoTaxonomySet()

ilAssQuestionList::addTaxonomyFilterNoTaxonomySet ( bool $flag )

Definition at line 172 of file class.ilAssQuestionList.php.

                                                               : void
     {
         $this->taxFiltersExcludeAnyObjectsWithTaxonomies = $flag;
     }

◆ buildBasicQuery()

ilAssQuestionList::buildBasicQuery ( )

private

Definition at line 536 of file class.ilAssQuestionList.php.

Referenced by buildQuery().

                                       : string
     {
         return "
                         {$this->getSelectFieldsExpression()}
 
                         FROM            qpl_questions
 
                         {$this->getTableJoinExpression()}
 
                         WHERE           qpl_questions.tstamp > 0
                 ";
     }

Here is the caller graph for this function:

◆ buildQuery()

ilAssQuestionList::buildQuery ( )

private

Definition at line 549 of file class.ilAssQuestionList.php.

References buildBasicQuery(), and getForcedQuestionIds().

Referenced by load().

                                  : string
     {
         $query = $this->buildBasicQuery() . "
                         {$this->getConditionalFilterExpression()}
                 ";
 
         if (count($this->getForcedQuestionIds())) {
             $query .= "
                                 UNION {$this->buildBasicQuery()}
                                 AND     {$this->db->in('qpl_questions.question_id', $this->getForcedQuestionIds(), false, 'integer')}
                         ";
         }
 
         return $query;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ checkFilters()

ilAssQuestionList::checkFilters ( )

private

Definition at line 746 of file class.ilAssQuestionList.php.

References getAnswerStatusActiveId(), and getAnswerStatusFilter().

Referenced by load().

                                    : void
     {
         if ($this->getAnswerStatusFilter() !== null && !$this->getAnswerStatusActiveId()) {
             throw new ilTestQuestionPoolException(
                 'No active id given! You cannot use the answer status filter without giving an active id.'
             );
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getAnswerStatusActiveId()

ilAssQuestionList::getAnswerStatusActiveId ( )

Definition at line 192 of file class.ilAssQuestionList.php.

References $answerStatusActiveId.

Referenced by checkFilters(), getSelectFieldsExpression(), and getTableJoinExpression().

                                              : ?int
     {
         return $this->answerStatusActiveId;
     }

Here is the caller graph for this function:

◆ getAnswerStatusFilter()

ilAssQuestionList::getAnswerStatusFilter ( )

Definition at line 202 of file class.ilAssQuestionList.php.

References $answerStatusFilter.

Referenced by checkFilters(), and getAnswerStatusFilterExpressions().

                                            : ?string
     {
         return $this->answerStatusFilter;
     }

Here is the caller graph for this function:

◆ getAnswerStatusFilterExpressions()

ilAssQuestionList::getAnswerStatusFilterExpressions ( )

private

Definition at line 416 of file class.ilAssQuestionList.php.

References getAnswerStatusFilter().

Referenced by getConditionalFilterExpression().

                                                        : array
     {
         $expressions = [];
 
         switch ($this->getAnswerStatusFilter()) {
             case self::ANSWER_STATUS_FILTER_ALL_NON_CORRECT:
 
                 $expressions[] = '
                                         (tst_test_result.question_fi IS NULL OR tst_test_result.points < qpl_questions.points)
                                 ';
                 break;
 
             case self::ANSWER_STATUS_FILTER_NON_ANSWERED_ONLY:
 
                 $expressions[] = 'tst_test_result.question_fi IS NULL';
                 break;
 
             case self::ANSWER_STATUS_FILTER_WRONG_ANSWERED_ONLY:
 
                 $expressions[] = 'tst_test_result.question_fi IS NOT NULL';
                 $expressions[] = 'tst_test_result.points < qpl_questions.points';
                 break;
         }
 
         return $expressions;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getAvailableTaxonomyIds()

ilAssQuestionList::getAvailableTaxonomyIds ( )

Definition at line 182 of file class.ilAssQuestionList.php.

References $availableTaxonomyIds.

Referenced by loadTaxonomyAssignmentData().

                                              : array
     {
         return $this->availableTaxonomyIds;
     }

Here is the caller graph for this function:

◆ getConditionalFilterExpression()

ilAssQuestionList::getConditionalFilterExpression ( )

private

Definition at line 476 of file class.ilAssQuestionList.php.

References getAnswerStatusFilterExpressions(), getFieldFilterExpressions(), getParentObjectIdFilterExpression(), getParentObjFilterExpression(), getQuestionIdsFilterExpressions(), getQuestionInstanceTypeFilterExpression(), and getTaxonomyFilterExpressions().

                                                      : string
     {
         $CONDITIONS = [];
 
         if ($this->getQuestionInstanceTypeFilterExpression() !== null) {
             $CONDITIONS[] = $this->getQuestionInstanceTypeFilterExpression();
         }
 
         if ($this->getParentObjFilterExpression() !== null) {
             $CONDITIONS[] = $this->getParentObjFilterExpression();
         }
 
         if ($this->getParentObjectIdFilterExpression() !== null) {
             $CONDITIONS[] = $this->getParentObjectIdFilterExpression();
         }
 
         $CONDITIONS = array_merge(
             $CONDITIONS,
             $this->getQuestionIdsFilterExpressions(),
             $this->getFieldFilterExpressions(),
             $this->getTaxonomyFilterExpressions(),
             $this->getAnswerStatusFilterExpressions()
         );
 
         $CONDITIONS = implode(' AND ', $CONDITIONS);
 
         return strlen($CONDITIONS) ? 'AND ' . $CONDITIONS : '';
     }

Here is the call graph for this function:

◆ getDataArrayForQuestionId()

ilAssQuestionList::getDataArrayForQuestionId ( $questionId )

Definition at line 709 of file class.ilAssQuestionList.php.

     {
         return $this->questions[$questionId];
     }

◆ getExcludeQuestionIdsFilter()

ilAssQuestionList::getExcludeQuestionIdsFilter ( )

Definition at line 140 of file class.ilAssQuestionList.php.

References $excludeQuestionIdsFilter.

Referenced by getQuestionIdsFilterExpressions().

     {
         return $this->excludeQuestionIdsFilter;
     }

Here is the caller graph for this function:

◆ getFieldFilterExpressions()

ilAssQuestionList::getFieldFilterExpressions ( )

private

Definition at line 256 of file class.ilAssQuestionList.php.

Referenced by getConditionalFilterExpression().

                                                 : array
     {
         $expressions = [];
 
         foreach ($this->fieldFilters as $fieldName => $fieldValue) {
             switch ($fieldName) {
                 case 'title':
                 case 'description':
                 case 'author':
                 case 'lifecycle':
 
                     $expressions[] = $this->db->like('qpl_questions.' . $fieldName, 'text', "%%$fieldValue%%");
                     break;
 
                 case 'type':
 
                     $expressions[] = "qpl_qst_type.type_tag = {$this->db->quote($fieldValue, 'text')}";
                     break;
 
                 case 'question_id':
                     if ($fieldValue != "" && !is_array($fieldValue)) {
                         $fieldValue = array($fieldValue);
                     }
                     $expressions[] = $this->db->in("qpl_questions.question_id", $fieldValue, false, "integer");
                     break;
 
                 case 'parent_title':
                     if ($this->join_obj_data) {
                         $expressions[] = $this->db->like('object_data.title', 'text', "%%$fieldValue%%");
                     }
                     break;
             }
         }
 
         return $expressions;
     }

Here is the caller graph for this function:

◆ getForcedQuestionIds()

ilAssQuestionList::getForcedQuestionIds ( )

Returns: array

Definition at line 238 of file class.ilAssQuestionList.php.

References $forcedQuestionIds.

Referenced by buildQuery().

                                           : array
     {
         return $this->forcedQuestionIds;
     }

Here is the caller graph for this function:

◆ getIncludeQuestionIdsFilter()

ilAssQuestionList::getIncludeQuestionIdsFilter ( )

Definition at line 135 of file class.ilAssQuestionList.php.

References $includeQuestionIdsFilter.

Referenced by getQuestionIdsFilterExpressions().

     {
         return $this->includeQuestionIdsFilter;
     }

Here is the caller graph for this function:

◆ getJoinObjectData()

ilAssQuestionList::getJoinObjectData ( )

Get if object data table should be joined.

Returns: bool join object_data

Definition at line 222 of file class.ilAssQuestionList.php.

References $join_obj_data.

                                        : bool
     {
         return $this->join_obj_data;
     }

◆ getNumberOfCommentsForQuestion()

ilAssQuestionList::getNumberOfCommentsForQuestion ( int $question_id )

protected

Definition at line 600 of file class.ilAssQuestionList.php.

References getParentObjId().

Referenced by load().

                                                                        : int
     {
         if ($this->notes_service === null) {
             return 0;
         }
         $notes_context = $this->notes_service->data()->context(
             $this->getParentObjId(),
             $question_id,
             'quest'
         );
         return $this->notes_service->domain()->getNrOfCommentsForContext($notes_context);
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getParentObjectIdFilterExpression()

ilAssQuestionList::getParentObjectIdFilterExpression ( )

private

Definition at line 407 of file class.ilAssQuestionList.php.

Referenced by getConditionalFilterExpression().

                                                         : ?string
     {
         if ($this->parentObjId) {
             return "qpl_questions.obj_fi = {$this->db->quote($this->parentObjId, 'integer')}";
         }
 
         return null;
     }

Here is the caller graph for this function:

◆ getParentObjectType()

ilAssQuestionList::getParentObjectType ( )

Definition at line 97 of file class.ilAssQuestionList.php.

References $parentObjType.

Referenced by getTableJoinExpression().

                                          : string
     {
         return $this->parentObjType;
     }

Here is the caller graph for this function:

◆ getParentObjFilterExpression()

ilAssQuestionList::getParentObjFilterExpression ( )

private

Definition at line 243 of file class.ilAssQuestionList.php.

References getParentObjId(), and getParentObjIdsFilter().

Referenced by getConditionalFilterExpression().

                                                    : ?string
     {
         if ($this->getParentObjId()) {
             return 'qpl_questions.obj_fi = ' . $this->db->quote($this->getParentObjId(), 'integer');
         }
 
         if (count($this->getParentObjIdsFilter())) {
             return $this->db->in('qpl_questions.obj_fi', $this->getParentObjIdsFilter(), false, 'integer');
         }
 
         return null;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getParentObjId()

ilAssQuestionList::getParentObjId ( )

Definition at line 87 of file class.ilAssQuestionList.php.

References $parentObjId.

Referenced by getNumberOfCommentsForQuestion(), getParentObjFilterExpression(), and ilTestSkillEvaluation\init().

                                     : ?int
     {
         return $this->parentObjId;
     }

Here is the caller graph for this function:

◆ getParentObjIdsFilter()

ilAssQuestionList::getParentObjIdsFilter ( )

Definition at line 107 of file class.ilAssQuestionList.php.

References $parentObjIdsFilter.

Referenced by getParentObjFilterExpression().

                                            : array
     {
         return $this->parentObjIdsFilter;
     }

Here is the caller graph for this function:

◆ getQuestionCompletionStatusFilter()

ilAssQuestionList::getQuestionCompletionStatusFilter ( )

Definition at line 150 of file class.ilAssQuestionList.php.

References $questionCompletionStatusFilter.

                                                        : string
     {
         return $this->questionCompletionStatusFilter;
     }

◆ getQuestionDataArray()

ilAssQuestionList::getQuestionDataArray ( )

Definition at line 714 of file class.ilAssQuestionList.php.

References $questions.

Referenced by QuestionTable\getData(), QuestionTable\getTotalRowCount(), and ilTestSkillEvaluation\initTestQuestionData().

                                           : array
     {
         return $this->questions;
     }

Here is the caller graph for this function:

◆ getQuestionIdsFilterExpressions()

ilAssQuestionList::getQuestionIdsFilterExpressions ( )

private

Definition at line 376 of file class.ilAssQuestionList.php.

References getExcludeQuestionIdsFilter(), and getIncludeQuestionIdsFilter().

Referenced by getConditionalFilterExpression().

                                                       : array
     {
         $expressions = [];
 
         if (is_array($this->getIncludeQuestionIdsFilter())) {
             $expressions[] = $this->db->in(
                 'qpl_questions.question_id',
                 $this->getIncludeQuestionIdsFilter(),
                 false,
                 'integer'
             );
         }
 
         if (is_array($this->getExcludeQuestionIdsFilter())) {
             $IN = $this->db->in(
                 'qpl_questions.question_id',
                 $this->getExcludeQuestionIdsFilter(),
                 true,
                 'integer'
             );
 
             if ($IN == ' 1=2 ') {
                 $IN = ' 1=1 ';
             } // required for ILIAS < 5.0
 
             $expressions[] = $IN;
         }
 
         return $expressions;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getQuestionInstanceTypeFilter()

ilAssQuestionList::getQuestionInstanceTypeFilter ( )

Definition at line 125 of file class.ilAssQuestionList.php.

References $questionInstanceTypeFilter.

Referenced by getQuestionInstanceTypeFilterExpression(), and getTableJoinExpression().

     {
         return $this->questionInstanceTypeFilter;
     }

Here is the caller graph for this function:

◆ getQuestionInstanceTypeFilterExpression()

ilAssQuestionList::getQuestionInstanceTypeFilterExpression ( )

private

Definition at line 361 of file class.ilAssQuestionList.php.

References getQuestionInstanceTypeFilter().

Referenced by getConditionalFilterExpression().

                                                               : ?string
     {
         switch ($this->getQuestionInstanceTypeFilter()) {
             case self::QUESTION_INSTANCE_TYPE_ORIGINALS:
                 return 'qpl_questions.original_id IS NULL';
             case self::QUESTION_INSTANCE_TYPE_DUPLICATES:
                 return 'qpl_questions.original_id IS NOT NULL';
             case self::QUESTION_INSTANCE_TYPE_ALL:
             default:
                 return null;
         }
 
         return null;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getSelectFieldsExpression()

ilAssQuestionList::getSelectFieldsExpression ( )

private

Definition at line 505 of file class.ilAssQuestionList.php.

References getAnswerStatusActiveId().

                                                 : string
     {
         $selectFields = array(
             'qpl_questions.*',
             'qpl_qst_type.type_tag',
             'qpl_qst_type.plugin',
             'qpl_qst_type.plugin_name',
             'qpl_questions.points max_points'
         );
 
         if ($this->join_obj_data) {
             $selectFields[] = 'object_data.title parent_title';
         }
 
         if ($this->getAnswerStatusActiveId()) {
             $selectFields[] = 'tst_test_result.points reached_points';
             $selectFields[] = "CASE
                                         WHEN tst_test_result.points IS NULL THEN '" . self::QUESTION_ANSWER_STATUS_NON_ANSWERED . "'
                                         WHEN tst_test_result.points < qpl_questions.points THEN '" . self::QUESTION_ANSWER_STATUS_WRONG_ANSWERED . "'
                                         ELSE '" . self::QUESTION_ANSWER_STATUS_CORRECT_ANSWERED . "'
                                 END question_answer_status
                         ";
         }
 
         $selectFields = implode(",\n\t\t\t\t", $selectFields);
 
         return "
                         SELECT          {$selectFields}
                 ";
     }

Here is the call graph for this function:

◆ getTableJoinExpression()

ilAssQuestionList::getTableJoinExpression ( )

private

Definition at line 443 of file class.ilAssQuestionList.php.

References getAnswerStatusActiveId(), getParentObjectType(), and getQuestionInstanceTypeFilter().

                                              : string
     {
         $tableJoin = "
                         INNER JOIN      qpl_qst_type
                         ON                      qpl_qst_type.question_type_id = qpl_questions.question_type_fi
                 ";
 
         if ($this->join_obj_data) {
             $tableJoin .= "
                                 INNER JOIN      object_data
                                 ON                      object_data.obj_id = qpl_questions.obj_fi
                         ";
         }
 
         if ($this->getParentObjectType() === 'tst'
             && $this->getQuestionInstanceTypeFilter() === self::QUESTION_INSTANCE_TYPE_ALL) {
             $tableJoin .= "
                                                         INNER JOIN      tst_test_question tstquest
                         ON                      tstquest.question_fi = qpl_questions.question_id
                         ";
         }
 
         if ($this->getAnswerStatusActiveId()) {
             $tableJoin .= "
                                 LEFT JOIN       tst_test_result
                                 ON                      tst_test_result.question_fi = qpl_questions.question_id
                                 AND                     tst_test_result.active_fi = {$this->db->quote($this->getAnswerStatusActiveId(), 'integer')}
                         ";
         }
 
         return $tableJoin;
     }

Here is the call graph for this function:

◆ getTaxItems()

ilAssQuestionList::getTaxItems	(	$parentType,
		$parentObjId,
		$taxId,
		$taxNode
	)

protected

Parameters

string	$parentType
int	$parentObjId
int	$taxId
int	$taxNode

Returns: array

Definition at line 344 of file class.ilAssQuestionList.php.

Referenced by getTaxonomyFilterExpressions().

                                                                                : array
     {
         $taxTree = new ilTaxonomyTree($taxId);
 
         $taxNodeAssignment = new ilTaxNodeAssignment(
             $parentType,
             $parentObjId,
             'quest',
             $taxId
         );
 
         $subNodes = $taxTree->getSubTreeIds($taxNode);
         $subNodes[] = $taxNode;
 
         return $taxNodeAssignment->getAssignmentsOfNode($subNodes);
     }

Here is the caller graph for this function:

◆ getTaxonomyFilterExpressions()

ilAssQuestionList::getTaxonomyFilterExpressions ( )

private

Definition at line 293 of file class.ilAssQuestionList.php.

References getTaxItems().

Referenced by getConditionalFilterExpression().

                                                    : array
     {
         $expressions = [];
         if ($this->taxFiltersExcludeAnyObjectsWithTaxonomies) {
             $expressions[] = 'question_id NOT IN (SELECT DISTINCT item_id FROM tax_node_assignment)';
             return $expressions;
         }
 
         foreach ($this->taxFilters as $taxId => $taxNodes) {
             $questionIds = [];
 
             $forceBypass = true;
 
             foreach ($taxNodes as $taxNode) {
                 $forceBypass = false;
 
                 $taxItemsByTaxParent = $this->getTaxItems(
                     $this->taxParentTypes[$taxId],
                     $this->taxParentIds[$taxId],
                     $taxId,
                     $taxNode
                 );
 
                 $taxItemsByParent = $this->getTaxItems(
                     $this->parentObjType,
                     $this->parentObjId,
                     $taxId,
                     $taxNode
                 );
 
                 $taxItems = array_merge($taxItemsByTaxParent, $taxItemsByParent);
                 foreach ($taxItems as $taxItem) {
                     $questionIds[$taxItem['item_id']] = $taxItem['item_id'];
                 }
             }
 
             if (!$forceBypass) {
                 $expressions[] = $this->db->in('question_id', $questionIds, false, 'integer');
             }
         }
 
         return $expressions;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getTitle()

ilAssQuestionList::getTitle	(	string	$a_comp_id,
		string	$a_item_type,
		int	$a_item_id
	)

Get title of an assigned item.

(is used from ilObjTaxonomyGUI when item sorting is activated)

Parameters

string	$a_comp_id	('qpl' in our context)
string	$a_item_type	('quest' in our context)
integer	$a_item_id	(questionId in our context)

Implements ilTaxAssignedItemInfo.

Definition at line 733 of file class.ilAssQuestionList.php.

                                                                                     : string
     {
         if ($a_comp_id != 'qpl' || $a_item_type != 'quest' || !$a_item_id) {
             return '';
         }
 
         if (!isset($this->questions[$a_item_id])) {
             return '';
         }
 
         return $this->questions[$a_item_id]['title'];
     }

◆ hasFeedback()

ilAssQuestionList::hasFeedback ( int $question_id )

protected

Definition at line 618 of file class.ilAssQuestionList.php.

References $res, ilPageUtil\_existsAndNotEmpty(), ilAssQuestionFeedback\PAGE_OBJECT_TYPE_GENERIC_FEEDBACK, and ilAssQuestionFeedback\PAGE_OBJECT_TYPE_SPECIFIC_FEEDBACK.

Referenced by load().

                                                     : bool
     {
         $pagetypes = [
             \ilAssQuestionFeedback::PAGE_OBJECT_TYPE_GENERIC_FEEDBACK,
             \ilAssQuestionFeedback::PAGE_OBJECT_TYPE_SPECIFIC_FEEDBACK,
         ];
         $res = $this->db->queryF(
             "SELECT feedback, feedback_id FROM qpl_fb_generic
             WHERE question_fi = %s
             UNION ALL
             SELECT feedback, feedback_id FROM qpl_fb_specific
             WHERE question_fi = %s",
             ['integer', 'integer', ],
             [$question_id, $question_id]
         );
         while ($row = $this->db->fetchAssoc($res)) {
             if (trim((string) $row['feedback']) !== '') {
                 return true;
             }
             foreach ($pagetypes as $pagetype) {
                 if (\ilPageUtil::_existsAndNotEmpty($pagetype, $row['feedback_id'])) {
                     return true;
                 }
             }
         }
         return false;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ hasHints()

ilAssQuestionList::hasHints ( int $question_id )

protected

Definition at line 646 of file class.ilAssQuestionList.php.

References ilAssQuestionHintList\getListByQuestionId().

Referenced by load().

                                                  : bool
     {
         $questionHintList = ilAssQuestionHintList::getListByQuestionId($question_id);
         return iterator_count($questionHintList) > 0;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ isActiveQuestionType()

ilAssQuestionList::isActiveQuestionType ( array $questionData )

private

Definition at line 679 of file class.ilAssQuestionList.php.

References ilComponentInfo\TYPE_MODULES.

Referenced by load().

                                                               : bool
     {
         if (!isset($questionData['plugin'])) {
             return false;
         }
 
         if (!$questionData['plugin']) {
             return true;
         }
 
         if (!$this->component_repository->getComponentByTypeAndName(
             ilComponentInfo::TYPE_MODULES,
             'TestQuestionPool'
         )->getPluginSlotById('qst')->hasPluginName((string) $questionData['plugin_name'])) {
             return false;
         }
 
         return $this->component_repository
             ->getComponentByTypeAndName(
                 ilComponentInfo::TYPE_MODULES,
                 'TestQuestionPool'
             )
             ->getPluginSlotById(
                 'qst'
             )
             ->getPluginByName(
                 (string) $questionData['plugin_name']
             )->isActive();
     }

Here is the caller graph for this function:

◆ isInList()

ilAssQuestionList::isInList ( $questionId )

Definition at line 719 of file class.ilAssQuestionList.php.

                                          : bool
     {
         return isset($this->questions[$questionId]);
     }

◆ load()

ilAssQuestionList::load ( )

Definition at line 565 of file class.ilAssQuestionList.php.

References $res, buildQuery(), checkFilters(), ilAssQuestionType\completeMissingPluginName(), getNumberOfCommentsForQuestion(), hasFeedback(), hasHints(), isActiveQuestionType(), ILIAS\Repository\lng(), loadTaxonomyAssignmentData(), and ILIAS\Repository\refinery().

Referenced by QuestionTable\getData(), and QuestionTable\getTotalRowCount().

                           : void
     {
         $this->checkFilters();
 
         $tags_trafo = $this->refinery->string()->stripTags();
 
         $query = $this->buildQuery();
         $res = $this->db->query($query);
         while ($row = $this->db->fetchAssoc($res)) {
             $row = ilAssQuestionType::completeMissingPluginName($row);
 
             if (!$this->isActiveQuestionType($row)) {
                 continue;
             }
 
             $row['title'] = $tags_trafo->transform($row['title'] ?? '&nbsp;');
             $row['description'] = $tags_trafo->transform($row['description'] !== '' && $row['description'] !== null ? $row['description'] : '&nbsp;');
             $row['author'] = $tags_trafo->transform($row['author']);
             $row['taxonomies'] = $this->loadTaxonomyAssignmentData($row['obj_fi'], $row['question_id']);
             $row['ttype'] = $this->lng->txt($row['type_tag']);
             $row['feedback'] = $this->hasFeedback((int) $row['question_id']);
             $row['hints'] = $this->hasHints((int) $row['question_id']);
             $row['comments'] = $this->getNumberOfCommentsForQuestion($row['question_id']);
 
             if (
                 $this->filter_comments === self::QUESTION_COMMENTED_ONLY && $row['comments'] === 0
                 || $this->filter_comments === self::QUESTION_COMMENTED_EXCLUDED && $row['comments'] > 0
             ) {
                 continue;
             }
 
             $this->questions[ $row['question_id'] ] = $row;
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ loadTaxonomyAssignmentData()

ilAssQuestionList::loadTaxonomyAssignmentData	(	$parentObjId,
		$questionId
	)

private

Definition at line 652 of file class.ilAssQuestionList.php.

References getAvailableTaxonomyIds().

Referenced by load().

                                                                           : array
     {
         $taxAssignmentData = [];
 
         foreach ($this->getAvailableTaxonomyIds() as $taxId) {
             $taxTree = new ilTaxonomyTree($taxId);
 
             $taxAssignment = new ilTaxNodeAssignment('qpl', $parentObjId, 'quest', $taxId);
 
             $assignments = $taxAssignment->getAssignmentsOfItem($questionId);
 
             foreach ($assignments as $assData) {
                 if (!isset($taxAssignmentData[ $assData['tax_id'] ])) {
                     $taxAssignmentData[ $assData['tax_id'] ] = [];
                 }
 
                 $nodeData = $taxTree->getNodeData($assData['node_id']);
 
                 $assData['node_lft'] = $nodeData['lft'];
 
                 $taxAssignmentData[ $assData['tax_id'] ][ $assData['node_id'] ] = $assData;
             }
         }
 
         return $taxAssignmentData;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setAnswerStatusActiveId()

ilAssQuestionList::setAnswerStatusActiveId ( $answerStatusActiveId )

Definition at line 187 of file class.ilAssQuestionList.php.

References $answerStatusActiveId.

                                                                   : void
     {
         $this->answerStatusActiveId = $answerStatusActiveId;
     }

◆ setAnswerStatusFilter()

ilAssQuestionList::setAnswerStatusFilter ( $answerStatusFilter )

Definition at line 197 of file class.ilAssQuestionList.php.

References $answerStatusFilter.

                                                               : void
     {
         $this->answerStatusFilter = $answerStatusFilter;
     }

◆ setAvailableTaxonomyIds()

ilAssQuestionList::setAvailableTaxonomyIds ( $availableTaxonomyIds )

Definition at line 177 of file class.ilAssQuestionList.php.

References $availableTaxonomyIds.

Referenced by QuestionTable\__construct().

                                                                   : void
     {
         $this->availableTaxonomyIds = $availableTaxonomyIds;
     }

Here is the caller graph for this function:

◆ setCommentFilter()

ilAssQuestionList::setCommentFilter ( int $commented = null )

Definition at line 613 of file class.ilAssQuestionList.php.

     {
         $this->filter_comments = $commented;
     }

◆ setExcludeQuestionIdsFilter()

ilAssQuestionList::setExcludeQuestionIdsFilter ( $excludeQuestionIdsFilter )

Definition at line 145 of file class.ilAssQuestionList.php.

References $excludeQuestionIdsFilter.

                                                                           : void
     {
         $this->excludeQuestionIdsFilter = $excludeQuestionIdsFilter;
     }

◆ setForcedQuestionIds()

ilAssQuestionList::setForcedQuestionIds ( $forcedQuestionIds )

Parameters

array $forcedQuestionIds

Definition at line 230 of file class.ilAssQuestionList.php.

References $forcedQuestionIds.

                                                             : void
     {
         $this->forcedQuestionIds = $forcedQuestionIds;
     }

◆ setIncludeQuestionIdsFilter()

ilAssQuestionList::setIncludeQuestionIdsFilter ( $questionIdsFilter )

Definition at line 130 of file class.ilAssQuestionList.php.

                                                                    : void
     {
         $this->includeQuestionIdsFilter = $questionIdsFilter;
     }

◆ setJoinObjectData()

ilAssQuestionList::setJoinObjectData ( $a_val )

Set if object data table should be joined.

Parameters

bool $a_val join object_data

Definition at line 212 of file class.ilAssQuestionList.php.

                                              : void
     {
         $this->join_obj_data = $a_val;
     }

◆ setParentObjectType()

ilAssQuestionList::setParentObjectType ( $parentObjType )

Definition at line 102 of file class.ilAssQuestionList.php.

References $parentObjType.

                                                        : void
     {
         $this->parentObjType = $parentObjType;
     }

◆ setParentObjId()

ilAssQuestionList::setParentObjId ( $parentObjId )

Definition at line 92 of file class.ilAssQuestionList.php.

References $parentObjId.

Referenced by QuestionTable\getData(), ilCopySelfAssQuestionTableGUI\getQuestions(), and QuestionTable\getTotalRowCount().

                                                 : void
     {
         $this->parentObjId = $parentObjId;
     }

Here is the caller graph for this function:

◆ setParentObjIdsFilter()

ilAssQuestionList::setParentObjIdsFilter ( $parentObjIdsFilter )

Parameters

array $parentObjIdsFilter

Definition at line 115 of file class.ilAssQuestionList.php.

References $parentObjIdsFilter.

Referenced by ilAsqFactory\getQuestionDataArray(), and ilAsqFactory\getQuestionInstances().

                                                               : void
     {
         $this->parentObjIdsFilter = $parentObjIdsFilter;
     }

Here is the caller graph for this function:

◆ setQuestionCompletionStatusFilter()

ilAssQuestionList::setQuestionCompletionStatusFilter ( $questionCompletionStatusFilter )

Definition at line 155 of file class.ilAssQuestionList.php.

References $questionCompletionStatusFilter.

                                                                                       : void
     {
         $this->questionCompletionStatusFilter = $questionCompletionStatusFilter;
     }

◆ setQuestionInstanceTypeFilter()

ilAssQuestionList::setQuestionInstanceTypeFilter ( $questionInstanceTypeFilter )

Definition at line 120 of file class.ilAssQuestionList.php.

                                                                               : void
     {
         $this->questionInstanceTypeFilter = (string) $questionInstanceTypeFilter;
     }

Field Documentation

◆ $answerStatusActiveId

int ilAssQuestionList::$answerStatusActiveId = null

private

Definition at line 39 of file class.ilAssQuestionList.php.

Referenced by getAnswerStatusActiveId(), and setAnswerStatusActiveId().

◆ $answerStatusFilter

ilAssQuestionList::$answerStatusFilter = null

private

Definition at line 57 of file class.ilAssQuestionList.php.

Referenced by getAnswerStatusFilter(), and setAnswerStatusFilter().

◆ $availableTaxonomyIds

array ilAssQuestionList::$availableTaxonomyIds = []

private

Definition at line 33 of file class.ilAssQuestionList.php.

Referenced by getAvailableTaxonomyIds(), and setAvailableTaxonomyIds().

◆ $excludeQuestionIdsFilter

ilAssQuestionList::$excludeQuestionIdsFilter = null

private

Definition at line 65 of file class.ilAssQuestionList.php.

Referenced by getExcludeQuestionIdsFilter(), and setExcludeQuestionIdsFilter().

◆ $fieldFilters

array ilAssQuestionList::$fieldFilters = []

private

Definition at line 34 of file class.ilAssQuestionList.php.

◆ $filter_comments

string ilAssQuestionList::$filter_comments = null

protected

Definition at line 74 of file class.ilAssQuestionList.php.

◆ $forcedQuestionIds

array ilAssQuestionList::$forcedQuestionIds = []

private

Definition at line 40 of file class.ilAssQuestionList.php.

Referenced by getForcedQuestionIds(), and setForcedQuestionIds().

◆ $includeQuestionIdsFilter

ilAssQuestionList::$includeQuestionIdsFilter = null

private

Definition at line 64 of file class.ilAssQuestionList.php.

Referenced by getIncludeQuestionIdsFilter().

◆ $join_obj_data

bool ilAssQuestionList::$join_obj_data = true

protected

Definition at line 41 of file class.ilAssQuestionList.php.

Referenced by getJoinObjectData().

◆ $parentObjId

int ilAssQuestionList::$parentObjId = null

private

Definition at line 31 of file class.ilAssQuestionList.php.

Referenced by addTaxonomyFilter(), getParentObjId(), and setParentObjId().

◆ $parentObjIdsFilter

array ilAssQuestionList::$parentObjIdsFilter = []

private

Definition at line 30 of file class.ilAssQuestionList.php.

Referenced by getParentObjIdsFilter(), and setParentObjIdsFilter().

◆ $parentObjType

string ilAssQuestionList::$parentObjType = 'qpl'

private

Definition at line 32 of file class.ilAssQuestionList.php.

Referenced by addTaxonomyFilter(), getParentObjectType(), and setParentObjectType().

◆ $questionCompletionStatusFilter

string ilAssQuestionList::$questionCompletionStatusFilter = self::QUESTION_COMPLETION_STATUS_BOTH

private

Definition at line 70 of file class.ilAssQuestionList.php.

Referenced by getQuestionCompletionStatusFilter(), and setQuestionCompletionStatusFilter().

◆ $questionInstanceTypeFilter

string ilAssQuestionList::$questionInstanceTypeFilter = self::QUESTION_INSTANCE_TYPE_ORIGINALS

private

Definition at line 62 of file class.ilAssQuestionList.php.

Referenced by getQuestionInstanceTypeFilter().

◆ $questions

array ilAssQuestionList::$questions = []

protected

Definition at line 76 of file class.ilAssQuestionList.php.

Referenced by getQuestionDataArray().

◆ $taxFilters

array ilAssQuestionList::$taxFilters = []

private

Definition at line 35 of file class.ilAssQuestionList.php.

◆ $taxFiltersExcludeAnyObjectsWithTaxonomies

bool ilAssQuestionList::$taxFiltersExcludeAnyObjectsWithTaxonomies = false

private

Definition at line 36 of file class.ilAssQuestionList.php.

◆ $taxParentIds

array ilAssQuestionList::$taxParentIds = []

private

Definition at line 37 of file class.ilAssQuestionList.php.

◆ $taxParentTypes

array ilAssQuestionList::$taxParentTypes = []

private

Definition at line 38 of file class.ilAssQuestionList.php.

◆ ANSWER_STATUS_FILTER_ALL_NON_CORRECT

const ilAssQuestionList::ANSWER_STATUS_FILTER_ALL_NON_CORRECT = 'allNonCorrect'

answer status filter value domain

Definition at line 53 of file class.ilAssQuestionList.php.

◆ ANSWER_STATUS_FILTER_NON_ANSWERED_ONLY

const ilAssQuestionList::ANSWER_STATUS_FILTER_NON_ANSWERED_ONLY = 'nonAnswered'

Definition at line 54 of file class.ilAssQuestionList.php.

◆ ANSWER_STATUS_FILTER_WRONG_ANSWERED_ONLY

const ilAssQuestionList::ANSWER_STATUS_FILTER_WRONG_ANSWERED_ONLY = 'wrongAnswered'

Definition at line 55 of file class.ilAssQuestionList.php.

◆ QUESTION_ANSWER_STATUS_CORRECT_ANSWERED

const ilAssQuestionList::QUESTION_ANSWER_STATUS_CORRECT_ANSWERED = 'correctAnswered'

Definition at line 48 of file class.ilAssQuestionList.php.

◆ QUESTION_ANSWER_STATUS_NON_ANSWERED

const ilAssQuestionList::QUESTION_ANSWER_STATUS_NON_ANSWERED = 'nonAnswered'

answer status domain for single questions

Definition at line 46 of file class.ilAssQuestionList.php.

◆ QUESTION_ANSWER_STATUS_WRONG_ANSWERED

const ilAssQuestionList::QUESTION_ANSWER_STATUS_WRONG_ANSWERED = 'wrongAnswered'

Definition at line 47 of file class.ilAssQuestionList.php.

◆ QUESTION_COMMENTED_EXCLUDED

const ilAssQuestionList::QUESTION_COMMENTED_EXCLUDED = '2'

Definition at line 73 of file class.ilAssQuestionList.php.

Referenced by QuestionTable\getFilter().

◆ QUESTION_COMMENTED_ONLY

const ilAssQuestionList::QUESTION_COMMENTED_ONLY = '1'

Definition at line 72 of file class.ilAssQuestionList.php.

Referenced by QuestionTable\getFilter().

◆ QUESTION_COMPLETION_STATUS_BOTH

const ilAssQuestionList::QUESTION_COMPLETION_STATUS_BOTH = 'complete/incomplete'

Definition at line 69 of file class.ilAssQuestionList.php.

◆ QUESTION_COMPLETION_STATUS_COMPLETE

const ilAssQuestionList::QUESTION_COMPLETION_STATUS_COMPLETE = 'complete'

Definition at line 67 of file class.ilAssQuestionList.php.

◆ QUESTION_COMPLETION_STATUS_INCOMPLETE

const ilAssQuestionList::QUESTION_COMPLETION_STATUS_INCOMPLETE = 'incomplete'

Definition at line 68 of file class.ilAssQuestionList.php.

◆ QUESTION_INSTANCE_TYPE_ALL

const ilAssQuestionList::QUESTION_INSTANCE_TYPE_ALL = 'QST_INSTANCE_TYPE_ALL'

Definition at line 61 of file class.ilAssQuestionList.php.

Referenced by ilTestQuestionBrowserTableGUI\getQuestionInstanceTypeFilter().

◆ QUESTION_INSTANCE_TYPE_DUPLICATES

const ilAssQuestionList::QUESTION_INSTANCE_TYPE_DUPLICATES = 'QST_INSTANCE_TYPE_DUPLICATES'

Definition at line 60 of file class.ilAssQuestionList.php.

Referenced by ilTestPlayerFixedQuestionSetGUI\buildTestPassQuestionList(), ilTestPlayerRandomQuestionSetGUI\buildTestPassQuestionList(), ilTestResultsGUI\executeCommand(), ilTestServiceGUI\getFilteredTestResult(), and ilTestSkillAdministrationGUI\getRequiredQuestionInstanceTypeFilter().

◆ QUESTION_INSTANCE_TYPE_ORIGINALS

const ilAssQuestionList::QUESTION_INSTANCE_TYPE_ORIGINALS = 'QST_INSTANCE_TYPE_ORIGINALS'

Definition at line 59 of file class.ilAssQuestionList.php.

Referenced by ilQuestionPoolSkillAdministrationGUI\executeCommand(), and ilTestQuestionBrowserTableGUI\getQuestionInstanceTypeFilter().

The documentation for this class was generated from the following file:

Modules/TestQuestionPool/classes/class.ilAssQuestionList.php

Public Member Functions

Data Fields

Protected Member Functions

Protected Attributes

Private Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ addFieldFilter()

◆ addTaxonomyFilter()

◆ addTaxonomyFilterNoTaxonomySet()

◆ buildBasicQuery()

◆ buildQuery()

◆ checkFilters()

◆ getAnswerStatusActiveId()

◆ getAnswerStatusFilter()

◆ getAnswerStatusFilterExpressions()

◆ getAvailableTaxonomyIds()

◆ getConditionalFilterExpression()

◆ getDataArrayForQuestionId()

◆ getExcludeQuestionIdsFilter()

◆ getFieldFilterExpressions()

◆ getForcedQuestionIds()

◆ getIncludeQuestionIdsFilter()

◆ getJoinObjectData()

◆ getNumberOfCommentsForQuestion()

◆ getParentObjectIdFilterExpression()

◆ getParentObjectType()

◆ getParentObjFilterExpression()

◆ getParentObjId()

◆ getParentObjIdsFilter()

◆ getQuestionCompletionStatusFilter()

◆ getQuestionDataArray()

◆ getQuestionIdsFilterExpressions()

◆ getQuestionInstanceTypeFilter()

◆ getQuestionInstanceTypeFilterExpression()

◆ getSelectFieldsExpression()

◆ getTableJoinExpression()

◆ getTaxItems()

◆ getTaxonomyFilterExpressions()

◆ getTitle()

◆ hasFeedback()

◆ hasHints()

◆ isActiveQuestionType()

◆ isInList()

◆ load()

◆ loadTaxonomyAssignmentData()

◆ setAnswerStatusActiveId()

◆ setAnswerStatusFilter()

◆ setAvailableTaxonomyIds()

◆ setCommentFilter()

◆ setExcludeQuestionIdsFilter()

◆ setForcedQuestionIds()

◆ setIncludeQuestionIdsFilter()

◆ setJoinObjectData()

◆ setParentObjectType()

◆ setParentObjId()

◆ setParentObjIdsFilter()

◆ setQuestionCompletionStatusFilter()

◆ setQuestionInstanceTypeFilter()

Field Documentation

◆ $answerStatusActiveId

◆ $answerStatusFilter

◆ $availableTaxonomyIds

◆ $excludeQuestionIdsFilter

◆ $fieldFilters

◆ $filter_comments

◆ $forcedQuestionIds

◆ $includeQuestionIdsFilter

◆ $join_obj_data

◆ $parentObjId

◆ $parentObjIdsFilter

◆ $parentObjType

◆ $questionCompletionStatusFilter

◆ $questionInstanceTypeFilter

◆ $questions

◆ $taxFilters

◆ $taxFiltersExcludeAnyObjectsWithTaxonomies