ILIAS  release_6 Revision v6.24-5-g0c8bfefb3b8
ilStudyProgrammeAssignmentDBRepository Class Reference
+ Inheritance diagram for ilStudyProgrammeAssignmentDBRepository:
+ Collaboration diagram for ilStudyProgrammeAssignmentDBRepository:

Public Member Functions

 __construct (ilDBInterface $db)
 
 createFor (int $root_prg_id, int $usr_id, int $assigning_usr_id)
 Create a record corresponding to a SP-Object and return represending settings.Will throw if a record allready exists. More...
 
 read (int $id)
 Load settings belonging to a SP-Object.Will throw if the record does not exist yet.
Returns
ilStudyProgrammeAssignment | null
More...
 
 readByUsrId (int $usr_id)
 Get all assignments of a user. More...
 
 readByPrgId (int $prg_id)
 Get all assignments to a prg. More...
 
 readByUsrIdAndPrgId (int $usr_id, int $prg_id)
 
 readDueToRestart ()
 Get all assignments due to restart and not restrted yet. More...
 
 readDueToRestartAndMail ()
 
 readDueToManuelRestart (int $days_before_end)
 Get all assignments due to restart and not restrted yet. More...
 
 update (ilStudyProgrammeAssignment $assignment)
 Update settings belonging to a SP-Object.Will throw if the record does not exist yet. More...
 
 delete (ilStudyProgrammeAssignment $assignment)
 Delete record corresponding to settings.Will throw if the record does not exist yet. More...
 
 reminderSendFor (int $assignment_id)
 
 getDashboardInstancesforUser (int $usr_id)
 
 createFor (int $prg_id, int $usr_id, int $assigning_usr_id)
 Create a record corresponding to a SP-Object and return represending settings. More...
 
 read (int $id)
 Load settings belonging to a SP-Object. More...
 
 readByUsrId (int $usr_id)
 Get all assignments of a user. More...
 
 readByPrgId (int $prg_id)
 Get all assignments to a prg. More...
 
 readDueToRestart ()
 Get all assignments due to restart and not restrted yet. More...
 
 readDueToManuelRestart (int $days_before_end)
 Get all assignments due to restart and not restrted yet. More...
 
 update (ilStudyProgrammeAssignment $assignment)
 Update settings belonging to a SP-Object. More...
 
 delete (ilStudyProgrammeAssignment $assignment)
 Delete record corresponding to settings. More...
 

Data Fields

const TABLE = 'prg_usr_assignments'
 
const FIELD_ID = 'id'
 
const FIELD_USR_ID = 'usr_id'
 
const FIELD_ROOT_PRG_ID = 'root_prg_id'
 
const FIELD_LAST_CHANGE = 'last_change'
 
const FIELD_LAST_CHANGE_BY = 'last_change_by'
 
const FIELD_RESTART_DATE = 'restart_date'
 
const FIELD_RESTARTED_ASSIGNMENT_ID = 'restarted_assignment_id'
 
const FIELD_RESTART_MAIL = 'restart_mail_send'
 

Protected Member Functions

 loadDueToRestart ()
 
 loadDueToRestartAndMail ()
 
 getSQLHeader ()
 
 getDueToRestartBaseSQL ()
 
 loadDueToManuelRestart (int $days_before_end)
 
 assignmentByRow (array $row)
 
 loadByFilterDB (array $filter)
 
 insertRowDB (array $row)
 
 updatedRowDB (array $values)
 
 deleteDB (int $id)
 
 nextId ()
 

Protected Attributes

 $db
 

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

ilStudyProgrammeAssignmentDBRepository::__construct ( ilDBInterface  $db)

Member Function Documentation

◆ assignmentByRow()

ilStudyProgrammeAssignmentDBRepository::assignmentByRow ( array  $row)
protected
Exceptions
ilException

Definition at line 307 of file class.ilStudyProgrammeAssignmentDBRepository.php.

308 {
309 return (new ilStudyProgrammeAssignment($row[self::FIELD_ID]))
310 ->setRootId($row[self::FIELD_ROOT_PRG_ID])
311 ->setUserId($row[self::FIELD_USR_ID])
312 ->setLastChangeBy($row[self::FIELD_LAST_CHANGE_BY])
313 ->setLastChange(DateTime::createFromFormat(
315 $row[self::FIELD_LAST_CHANGE]
316 ))
317 ->setRestartDate(
318 $row[self::FIELD_RESTART_DATE] ?
319 DateTime::createFromFormat(ilStudyProgrammeAssignment::DATE_TIME_FORMAT, $row[self::FIELD_RESTART_DATE]) :
320 null
321 )
322 ->setRestartedAssignmentId($row[self::FIELD_RESTARTED_ASSIGNMENT_ID]);
323 }
Class ilStudyProgrammeAssignment.

References ilStudyProgrammeAssignment\DATE_TIME_FORMAT, and ilStudyProgrammeAssignment\setRootId().

Referenced by createFor(), getDashboardInstancesforUser(), read(), readByPrgId(), readByUsrId(), readByUsrIdAndPrgId(), readDueToManuelRestart(), readDueToRestart(), and readDueToRestartAndMail().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ createFor()

ilStudyProgrammeAssignmentDBRepository::createFor ( int  $root_prg_id,
int  $usr_id,
int  $assigning_usr_id 
)

Create a record corresponding to a SP-Object and return represending settings.Will throw if a record allready exists.

Exceptions
ilException

Implements ilStudyProgrammeAssignmentRepository.

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

33 {
34 if (ilObject::_lookupType($usr_id) != "usr") {
35 throw new ilException("ilStudyProgrammeAssignment::createFor: '$usr_id' "
36 . "is no id of a user.");
37 }
38 if (ilObject::_lookupType($root_prg_id) != "prg") {
39 throw new ilException("ilStudyProgrammeAssignment::createFor: '$root_prg_id' "
40 . "is no id of a prg.");
41 }
42 $row = [
43 self::FIELD_ID => $this->nextId(),
44 self::FIELD_USR_ID => $usr_id,
45 self::FIELD_ROOT_PRG_ID => $root_prg_id,
46 self::FIELD_LAST_CHANGE_BY => $assigning_usr_id,
47 self::FIELD_LAST_CHANGE => ilUtil::now(),
48 self::FIELD_RESTART_DATE => null,
49 self::FIELD_RESTARTED_ASSIGNMENT_ID => ilStudyProgrammeAssignment::NO_RESTARTED_ASSIGNMENT
50 ];
51 $this->insertRowDB($row);
52 return $this->assignmentByRow($row)->updateLastChange();
53 }
Base class for ILIAS Exception handling.
static _lookupType($a_id, $a_reference=false)
lookup object type
static now()
Return current timestamp in Y-m-d H:i:s format.

References ilObject\_lookupType(), assignmentByRow(), insertRowDB(), nextId(), ilStudyProgrammeAssignment\NO_RESTARTED_ASSIGNMENT, and ilUtil\now().

+ Here is the call graph for this function:

◆ delete()

ilStudyProgrammeAssignmentDBRepository::delete ( ilStudyProgrammeAssignment  $assignment)

Delete record corresponding to settings.Will throw if the record does not exist yet.

Implements ilStudyProgrammeAssignmentRepository.

Definition at line 241 of file class.ilStudyProgrammeAssignmentDBRepository.php.

242 {
243 $this->deleteDB($assignment->getId());
244 }
getId()
Get the id of the assignment.

References deleteDB().

+ Here is the call graph for this function:

◆ deleteDB()

ilStudyProgrammeAssignmentDBRepository::deleteDB ( int  $id)
protected

Definition at line 375 of file class.ilStudyProgrammeAssignmentDBRepository.php.

376 {
377 $this->db->manipulate('DELETE FROM ' . self::TABLE . ' WHERE ' . self::FIELD_ID . ' = ' . $this->db->quote($id, 'integer'));
378 }

Referenced by delete().

+ Here is the caller graph for this function:

◆ getDashboardInstancesforUser()

ilStudyProgrammeAssignmentDBRepository::getDashboardInstancesforUser ( int  $usr_id)
Exceptions
ilException

Definition at line 268 of file class.ilStudyProgrammeAssignmentDBRepository.php.

269 {
270 global $DIC;
271 $db = $DIC['ilDB'];
272 $q = 'SELECT ' . self::FIELD_ID
273 . ', ' . self::FIELD_USR_ID
274 . ', ' . self::FIELD_ROOT_PRG_ID
275 . ', ' . self::FIELD_LAST_CHANGE
276 . ', ' . self::FIELD_LAST_CHANGE_BY
277 . ', ' . self::FIELD_RESTART_DATE
278 . ', ' . self::FIELD_RESTARTED_ASSIGNMENT_ID
279 . ' FROM ' . self::TABLE
280 . ' WHERE ' . self::FIELD_USR_ID . ' = ' . $usr_id
281 . ' ORDER BY ' . self::FIELD_ROOT_PRG_ID . ', ' . self::FIELD_ID
282 ;
283 $ret = [];
284 $assignments = [];
285 $res = $db->query($q);
286 $prg = 0;
287 while ($row = $db->fetchAssoc($res)) {
288 if ($prg == 0) {
289 $prg = $row['root_prg_id'];
290 }
291 if ($prg != $row['root_prg_id']) {
292 $ret[$prg] = $assignments;
293 $prg = $row['root_prg_id'];
294 $assignments = [];
295 }
296 $assignments[(int) $row['id']] = $this->assignmentByRow($row);
297 }
298 if (count($assignments) > 0) {
299 $ret[$prg] = $assignments;
300 }
301 return $ret;
302 }
$ret
Definition: parser.php:6
foreach($_POST as $key=> $value) $res
$DIC
Definition: xapitoken.php:46

References $db, $DIC, $res, $ret, assignmentByRow(), and FIELD_ID.

+ Here is the call graph for this function:

◆ getDueToRestartBaseSQL()

ilStudyProgrammeAssignmentDBRepository::getDueToRestartBaseSQL ( )
protected

Definition at line 163 of file class.ilStudyProgrammeAssignmentDBRepository.php.

163 : string
164 {
165 return $this->getSQLHeader()
166 . ' WHERE ' . self::FIELD_RESTARTED_ASSIGNMENT_ID
167 . ' = ' . $this->db->quote(
169 'integer'
170 ) . PHP_EOL
171 . ' AND ' . self::FIELD_RESTART_DATE . ' IS NOT NULL' . PHP_EOL
172 . ' AND DATE(' . self::FIELD_RESTART_DATE . ') <= '
173 . $this->db->quote(
174 (new DateTime())->format(
176 ),
177 'text'
178 );
179 }

References ilStudyProgrammeAssignment\DATE_FORMAT, getSQLHeader(), and ilStudyProgrammeAssignment\NO_RESTARTED_ASSIGNMENT.

Referenced by loadDueToRestart(), and loadDueToRestartAndMail().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ getSQLHeader()

ilStudyProgrammeAssignmentDBRepository::getSQLHeader ( )
protected

Definition at line 151 of file class.ilStudyProgrammeAssignmentDBRepository.php.

151 : string
152 {
153 return 'SELECT ' . self::FIELD_ID
154 . ', ' . self::FIELD_USR_ID
155 . ', ' . self::FIELD_ROOT_PRG_ID
156 . ', ' . self::FIELD_LAST_CHANGE
157 . ', ' . self::FIELD_LAST_CHANGE_BY
158 . ', ' . self::FIELD_RESTART_DATE
159 . ', ' . self::FIELD_RESTARTED_ASSIGNMENT_ID . PHP_EOL
160 . ' FROM ' . self::TABLE . PHP_EOL;
161 }

Referenced by getDueToRestartBaseSQL(), and loadDueToManuelRestart().

+ Here is the caller graph for this function:

◆ insertRowDB()

ilStudyProgrammeAssignmentDBRepository::insertRowDB ( array  $row)
protected

Definition at line 345 of file class.ilStudyProgrammeAssignmentDBRepository.php.

346 {
347 $this->db->insert(
348 self::TABLE,
349 [
350 self::FIELD_ID => ['interger', $row[self::FIELD_ID]]
351 , self::FIELD_USR_ID => ['interger', $row[self::FIELD_USR_ID]]
352 , self::FIELD_ROOT_PRG_ID => ['interger', $row[self::FIELD_ROOT_PRG_ID]]
353 , self::FIELD_LAST_CHANGE => ['interger', $row[self::FIELD_LAST_CHANGE]]
354 , self::FIELD_LAST_CHANGE_BY => ['interger', $row[self::FIELD_LAST_CHANGE_BY]]
355 , self::FIELD_RESTART_DATE => ['timestamp', $row[self::FIELD_RESTART_DATE]]
356 , self::FIELD_RESTARTED_ASSIGNMENT_ID => ['integer', $row[self::FIELD_RESTARTED_ASSIGNMENT_ID]]
357 ]
358 );
359 }

Referenced by createFor().

+ Here is the caller graph for this function:

◆ loadByFilterDB()

ilStudyProgrammeAssignmentDBRepository::loadByFilterDB ( array  $filter)
protected

Definition at line 325 of file class.ilStudyProgrammeAssignmentDBRepository.php.

326 {
327 $q = 'SELECT ' . self::FIELD_ID
328 . ' ,' . self::FIELD_USR_ID
329 . ' ,' . self::FIELD_ROOT_PRG_ID
330 . ' ,' . self::FIELD_LAST_CHANGE
331 . ' ,' . self::FIELD_LAST_CHANGE_BY
332 . ' ,' . self::FIELD_RESTART_DATE
333 . ' ,' . self::FIELD_RESTARTED_ASSIGNMENT_ID
334 . ' FROM ' . self::TABLE
335 . ' WHERE TRUE';
336 foreach ($filter as $field => $value) {
337 $q .= ' AND ' . $field . ' = ' . $this->db->quote($value, 'text');
338 }
339 $res = $this->db->query($q);
340 while ($rec = $this->db->fetchAssoc($res)) {
341 yield $rec;
342 }
343 }

References $res.

Referenced by read(), readByPrgId(), readByUsrId(), and readByUsrIdAndPrgId().

+ Here is the caller graph for this function:

◆ loadDueToManuelRestart()

ilStudyProgrammeAssignmentDBRepository::loadDueToManuelRestart ( int  $days_before_end)
protected
Exceptions
Exception

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

198 {
199 $date = new DateTime();
200 $date->sub(new DateInterval('P' . $days_before_end . 'D'));
201 $q = $this->getSQLHeader()
202 . ' WHERE ' . self::FIELD_RESTARTED_ASSIGNMENT_ID
203 . ' = ' . $this->db->quote(
205 'integer'
206 ) . PHP_EOL
207 . ' AND ' . self::FIELD_RESTART_DATE . ' IS NOT NULL' . PHP_EOL
208 . ' AND DATE(' . self::FIELD_RESTART_DATE . ') <= '
209 . $this->db->quote(
210 $date->format(
212 ),
213 'text'
214 );
215 $res = $this->db->query($q);
216 while ($rec = $this->db->fetchAssoc($res)) {
217 yield $rec;
218 }
219 }

References $res, ilStudyProgrammeAssignment\DATE_FORMAT, getSQLHeader(), and ilStudyProgrammeAssignment\NO_RESTARTED_ASSIGNMENT.

Referenced by readDueToManuelRestart().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ loadDueToRestart()

ilStudyProgrammeAssignmentDBRepository::loadDueToRestart ( )
protected

Definition at line 131 of file class.ilStudyProgrammeAssignmentDBRepository.php.

132 {
133 $q = $this->getDueToRestartBaseSQL();
134 $res = $this->db->query($q);
135 while ($rec = $this->db->fetchAssoc($res)) {
136 yield $rec;
137 }
138 }

References $res, and getDueToRestartBaseSQL().

Referenced by readDueToRestart().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ loadDueToRestartAndMail()

ilStudyProgrammeAssignmentDBRepository::loadDueToRestartAndMail ( )
protected

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

141 {
142 $q = $this->getDueToRestartBaseSQL();
143 $q .= ' AND ' . self::FIELD_RESTART_MAIL . ' IS NULL';
144
145 $res = $this->db->query($q);
146 while ($rec = $this->db->fetchAssoc($res)) {
147 yield $rec;
148 }
149 }

References $res, and getDueToRestartBaseSQL().

Referenced by readDueToRestartAndMail().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ nextId()

ilStudyProgrammeAssignmentDBRepository::nextId ( )
protected

Definition at line 380 of file class.ilStudyProgrammeAssignmentDBRepository.php.

381 {
382 return $this->db->nextId(self::TABLE);
383 }

Referenced by createFor().

+ Here is the caller graph for this function:

◆ read()

ilStudyProgrammeAssignmentDBRepository::read ( int  $id)

Load settings belonging to a SP-Object.Will throw if the record does not exist yet.

Returns
ilStudyProgrammeAssignment | null

Exceptions
ilException

Implements ilStudyProgrammeAssignmentRepository.

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

60 {
61 foreach ($this->loadByFilterDB([self::FIELD_ID => $id]) as $row) {
62 return $this->assignmentByRow($row);
63 }
64 return null;
65 }

References assignmentByRow(), and loadByFilterDB().

+ Here is the call graph for this function:

◆ readByPrgId()

ilStudyProgrammeAssignmentDBRepository::readByPrgId ( int  $prg_id)

Get all assignments to a prg.

Exceptions
ilException

Implements ilStudyProgrammeAssignmentRepository.

Definition at line 84 of file class.ilStudyProgrammeAssignmentDBRepository.php.

84 : array
85 {
86 $return = [];
87 foreach ($this->loadByFilterDB([self::FIELD_ROOT_PRG_ID => $prg_id]) as $row) {
88 $return[] = $this->assignmentByRow($row);
89 }
90 return $return;
91 }

References assignmentByRow(), and loadByFilterDB().

+ Here is the call graph for this function:

◆ readByUsrId()

ilStudyProgrammeAssignmentDBRepository::readByUsrId ( int  $usr_id)

Get all assignments of a user.

Exceptions
ilException

Implements ilStudyProgrammeAssignmentRepository.

Definition at line 71 of file class.ilStudyProgrammeAssignmentDBRepository.php.

71 : array
72 {
73 $return = [];
74 foreach ($this->loadByFilterDB([self::FIELD_USR_ID => $usr_id]) as $row) {
75 $return[] = $this->assignmentByRow($row);
76 }
77 return $return;
78 }

References assignmentByRow(), and loadByFilterDB().

+ Here is the call graph for this function:

◆ readByUsrIdAndPrgId()

ilStudyProgrammeAssignmentDBRepository::readByUsrIdAndPrgId ( int  $usr_id,
int  $prg_id 
)

Exceptions
ilException

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

98 {
99 $return = [];
100 foreach ($this->loadByFilterDB(
101 [self::FIELD_USR_ID => $usr_id
102 , self::FIELD_ROOT_PRG_ID => $prg_id]
103 ) as $row) {
104 $return[] = $this->assignmentByRow($row);
105 }
106 return $return;
107 }

References assignmentByRow(), and loadByFilterDB().

+ Here is the call graph for this function:

◆ readDueToManuelRestart()

ilStudyProgrammeAssignmentDBRepository::readDueToManuelRestart ( int  $days_before_end)

Get all assignments due to restart and not restrted yet.

Exceptions
Exception

Implements ilStudyProgrammeAssignmentRepository.

Definition at line 185 of file class.ilStudyProgrammeAssignmentDBRepository.php.

185 : array
186 {
187 $return = [];
188 foreach ($this->loadDueToManuelRestart($days_before_end) as $row) {
189 $return[] = $this->assignmentByRow($row);
190 }
191 return $return;
192 }

References assignmentByRow(), and loadDueToManuelRestart().

+ Here is the call graph for this function:

◆ readDueToRestart()

ilStudyProgrammeAssignmentDBRepository::readDueToRestart ( )

Get all assignments due to restart and not restrted yet.

Exceptions
ilException

Implements ilStudyProgrammeAssignmentRepository.

Definition at line 113 of file class.ilStudyProgrammeAssignmentDBRepository.php.

113 : array
114 {
115 $return = [];
116 foreach ($this->loadDueToRestart() as $row) {
117 $return[] = $this->assignmentByRow($row);
118 }
119 return $return;
120 }

References assignmentByRow(), and loadDueToRestart().

+ Here is the call graph for this function:

◆ readDueToRestartAndMail()

ilStudyProgrammeAssignmentDBRepository::readDueToRestartAndMail ( )

Definition at line 122 of file class.ilStudyProgrammeAssignmentDBRepository.php.

122 : array
123 {
124 $return = [];
125 foreach ($this->loadDueToRestartAndMail() as $row) {
126 $return[] = $this->assignmentByRow($row);
127 }
128 return $return;
129 }

References assignmentByRow(), and loadDueToRestartAndMail().

+ Here is the call graph for this function:

◆ reminderSendFor()

ilStudyProgrammeAssignmentDBRepository::reminderSendFor ( int  $assignment_id)

Definition at line 246 of file class.ilStudyProgrammeAssignmentDBRepository.php.

246 : void
247 {
248 $where = [
249 self::FIELD_ID => [
250 'integer',
251 $assignment_id
252 ]
253 ];
254
255 $values = [
256 self::FIELD_RESTART_MAIL => [
257 'timestamp',
258 date('Y-m-d H:i:s')
259 ]
260 ];
261
262 $this->db->update(self::TABLE, $values, $where);
263 }

◆ update()

ilStudyProgrammeAssignmentDBRepository::update ( ilStudyProgrammeAssignment  $assignment)

Update settings belonging to a SP-Object.Will throw if the record does not exist yet.

Implements ilStudyProgrammeAssignmentRepository.

Definition at line 224 of file class.ilStudyProgrammeAssignmentDBRepository.php.

225 {
226 $row = [
227 self::FIELD_ID => $assignment->getId(),
228 self::FIELD_USR_ID => $assignment->getUserId(),
229 self::FIELD_ROOT_PRG_ID => $assignment->getRootId(),
230 self::FIELD_LAST_CHANGE_BY => $assignment->getLastChangeBy(),
231 self::FIELD_LAST_CHANGE => $assignment->getLastChange()->format(ilStudyProgrammeAssignment::DATE_TIME_FORMAT),
232 self::FIELD_RESTART_DATE => $assignment->getRestartDate() ? $assignment->getRestartDate()->format(ilStudyProgrammeAssignment::DATE_TIME_FORMAT) : null,
233 self::FIELD_RESTARTED_ASSIGNMENT_ID => $assignment->getRestartedAssignmentId()
234 ];
235 $this->updatedRowDB($row);
236 }
getUserId()
Get the id of the user who is assigned.
getRestartDate()
Get the date, at which the user is to be reassigned to the programme.
getLastChange()
Get the timestamp of the last change on this program or a sub program.
getRootId()
Get the object id of the program the user was assigned to.
getLastChangeBy()
Get the id of the user who did the last change on this assignment.
getRestartedAssignmentId()
Get the id of the assignment which was intiated due to expiring progress of this assignment.

References ilStudyProgrammeAssignment\DATE_TIME_FORMAT, ilStudyProgrammeAssignment\getId(), ilStudyProgrammeAssignment\getLastChange(), ilStudyProgrammeAssignment\getLastChangeBy(), ilStudyProgrammeAssignment\getRestartDate(), ilStudyProgrammeAssignment\getRestartedAssignmentId(), ilStudyProgrammeAssignment\getRootId(), ilStudyProgrammeAssignment\getUserId(), and updatedRowDB().

+ Here is the call graph for this function:

◆ updatedRowDB()

ilStudyProgrammeAssignmentDBRepository::updatedRowDB ( array  $values)
protected

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

362 {
363 $q = 'UPDATE ' . self::TABLE
364 . ' SET'
365 . ' ' . self::FIELD_USR_ID . ' = ' . $this->db->quote($values[self::FIELD_USR_ID], 'integer')
366 . ' ,' . self::FIELD_ROOT_PRG_ID . ' = ' . $this->db->quote($values[self::FIELD_ROOT_PRG_ID], 'integer')
367 . ' ,' . self::FIELD_LAST_CHANGE . ' = ' . $this->db->quote($values[self::FIELD_LAST_CHANGE], 'text')
368 . ' ,' . self::FIELD_LAST_CHANGE_BY . ' = ' . $this->db->quote($values[self::FIELD_LAST_CHANGE_BY], 'integer')
369 . ' ,' . self::FIELD_RESTART_DATE . ' = ' . $this->db->quote($values[self::FIELD_RESTART_DATE], 'timestamp')
370 . ' ,' . self::FIELD_RESTARTED_ASSIGNMENT_ID . ' = ' . $this->db->quote($values[self::FIELD_RESTARTED_ASSIGNMENT_ID], 'integer')
371 . ' WHERE ' . self::FIELD_ID . ' = ' . $this->db->quote($values[self::FIELD_ID], 'integer');
372 $this->db->manipulate($q);
373 }

Referenced by update().

+ Here is the caller graph for this function:

Field Documentation

◆ $db

ilStudyProgrammeAssignmentDBRepository::$db
protected

◆ FIELD_ID

const ilStudyProgrammeAssignmentDBRepository::FIELD_ID = 'id'

◆ FIELD_LAST_CHANGE

const ilStudyProgrammeAssignmentDBRepository::FIELD_LAST_CHANGE = 'last_change'

◆ FIELD_LAST_CHANGE_BY

const ilStudyProgrammeAssignmentDBRepository::FIELD_LAST_CHANGE_BY = 'last_change_by'

◆ FIELD_RESTART_DATE

const ilStudyProgrammeAssignmentDBRepository::FIELD_RESTART_DATE = 'restart_date'

◆ FIELD_RESTART_MAIL

const ilStudyProgrammeAssignmentDBRepository::FIELD_RESTART_MAIL = 'restart_mail_send'

◆ FIELD_RESTARTED_ASSIGNMENT_ID

const ilStudyProgrammeAssignmentDBRepository::FIELD_RESTARTED_ASSIGNMENT_ID = 'restarted_assignment_id'

◆ FIELD_ROOT_PRG_ID

const ilStudyProgrammeAssignmentDBRepository::FIELD_ROOT_PRG_ID = 'root_prg_id'

◆ FIELD_USR_ID

const ilStudyProgrammeAssignmentDBRepository::FIELD_USR_ID = 'usr_id'

◆ TABLE


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