4require_once
'Modules/TestQuestionPool/exceptions/class.ilTestQuestionPoolException.php';
133 $this->index = (int)
$index;
155 $this->points = (float)
$points;
202 WHERE qht_hint_id = %s
206 $query, array(
'integer'), array((
int)
$id)
231 else return $this->
insert();
246 return $ilDB->update(
249 'qht_question_fi' => array(
'integer', $this->
getQuestionId()),
250 'qht_hint_index' => array(
'integer', $this->
getIndex()),
251 'qht_hint_points' => array(
'float', $this->
getPoints()),
252 'qht_hint_text' => array(
'clob', $this->
getText())
255 'qht_hint_id' => array(
'integer', $this->
getId())
272 $this->
setId($ilDB->nextId(
'qpl_hints'));
274 return $ilDB->insert(
'qpl_hints', array(
275 'qht_hint_id' => array(
'integer', $this->
getId()),
276 'qht_question_fi' => array(
'integer', $this->
getQuestionId()),
277 'qht_hint_index' => array(
'integer', $this->
getIndex()),
278 'qht_hint_points' => array(
'float', $this->
getPoints()),
279 'qht_hint_text' => array(
'clob', $this->
getText())
289 public function delete()
303 public static function assignDbRow(
self $questionHint, $hintDbRow)
305 foreach($hintDbRow as $field => $value)
309 case 'qht_hint_id': $questionHint->setId($value);
break;
310 case 'qht_question_fi': $questionHint->setQuestionId($value);
break;
311 case 'qht_hint_index': $questionHint->setIndex($value);
break;
312 case 'qht_hint_points': $questionHint->setPoints($value);
break;
313 case 'qht_hint_text': $questionHint->setText($value);
break;
335 DELETE FROM qpl_hints
336 WHERE qht_hint_id = %s
339 return $ilDB->manipulateF(
340 $query, array(
'integer'), array($hintId)
355 $questionHint =
new self();
356 $questionHint->load($hintId);
357 return $questionHint;
367 return sprintf(
$lng->txt(
'tst_question_hints_index_column_label'), $hintIndex);
getPoints()
returns the points to ground-off for this hint
save()
saves the current hint object state to database.
static deleteById($hintId)
deletes the persisted hint object in database by deleting the hint dataset identified by hint id
static assignDbRow(self $questionHint, $hintDbRow)
assigns the field elements of passed hint db row array to the corresponding hint object properties of...
update()
persists the current object state to database by updating an existing dataset identified by hint id
getText()
returns the hint text
insert()
persists the current object state to database by inserting a new dataset with a new hint id fetched f...
getQuestionId()
returns the question id the hint currently relates to
setId($id)
sets the passed hint id
__construct()
Constructor.
static getInstanceById($hintId)
creates a hint object instance, loads the persisted hint dataset identified by passed hint id from da...
load($id)
loads the hint dataset with passed id from database and assigns it the to this hint object instance
getIndex()
returns the ordering index of hint
setQuestionId($questionId)
sets the passed question id so hint relates to it
setText($text)
sets the passed hint text
setPoints($points)
sets the passed points to ground-off for this hint
setIndex($index)
sets the passed hint ordering index
getId()
returns the hint id
static getHintIndexLabel(ilLanguage $lng, $hintIndex)