Collaboration diagram for ilWikiContributor:

Static Public Member Functions
static	_lookupStatus ($a_obj_id, $a_user_id)
	Lookup current success status (STATUS_NOT_GRADED\|STATUS_PASSED\|STATUS_FAILED) More...

static	_lookupStatusTime ($a_obj_id, $a_user_id)
	Lookup last change in mark or success status. More...

static	_writeStatus ($a_obj_id, $a_user_id, $a_status)
	Write success status. More...

Data Fields
const	STATUS_NOT_GRADED = 0

const	STATUS_PASSED = 1

const	STATUS_FAILED = 2

Detailed Description

Class ilWikiContributor.

Author: Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e

Version: $Id$

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

Member Function Documentation

◆ _lookupStatus()

static ilWikiContributor::_lookupStatus	(	$a_obj_id,
		$a_user_id
	)

static

Lookup current success status (STATUS_NOT_GRADED|STATUS_PASSED|STATUS_FAILED)

Parameters

int	$a_obj_id	exercise id
int	$a_user_id	member id

Returns: mixed false (if user is no member) or notgraded|passed|failed

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

References $DIC, $ilDB, $row, and array.

Referenced by ilWikiContributorsTableGUI\fillRow(), ilObjWikiGUI\infoScreen(), and ilObjWikiGUI\saveGradingObject().

     {
         global $DIC;
 
         $ilDB = $DIC->database();
 
         $set = $ilDB->queryF(
             "SELECT status FROM il_wiki_contributor " .
             "WHERE wiki_id = %s and user_id = %s",
             array("integer", "integer"),
             array($a_obj_id, $a_user_id)
         );
         if ($row = $ilDB->fetchAssoc($set)) {
             return $row["status"];
         }
         return false;
     }

Here is the caller graph for this function:

◆ _lookupStatusTime()

static ilWikiContributor::_lookupStatusTime	(	$a_obj_id,
		$a_user_id
	)

static

Lookup last change in mark or success status.

Parameters

int	$a_obj_id	exercise id
int	$a_user_id	member id

Returns: mixed false (if user is no member) or notgraded|passed|failed

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

References $DIC, $ilDB, $row, and array.

Referenced by ilWikiContributorsTableGUI\fillRow().

     {
         global $DIC;
 
         $ilDB = $DIC->database();
 
         $set = $ilDB->queryF(
             "SELECT status_time FROM il_wiki_contributor " .
             "WHERE wiki_id = %s and user_id = %s",
             array("integer", "integer"),
             array($a_obj_id, $a_user_id)
         );
         if ($row = $ilDB->fetchAssoc($set)) {
             return $row["status_time"];
         }
         return false;
     }

Here is the caller graph for this function:

◆ _writeStatus()

static ilWikiContributor::_writeStatus	(	$a_obj_id,
		$a_user_id,
		$a_status
	)

static

Write success status.

Parameters

int	$a_obj_id	exercise id
int	$a_user_id	member id
int	$status	status: STATUS_NOT_GRADED\|STATUS_PASSED\|STATUS_FAILED

Returns: int number of affected rows

Definition at line 98 of file class.ilWikiContributor.php.

References $DIC, $ilDB, array, and ilUtil\now().

Referenced by ilObjWikiGUI\saveGradingObject().

     {
         global $DIC;
 
         $ilDB = $DIC->database();
 
         $ilDB->manipulate("DELETE FROM il_wiki_contributor WHERE " .
             " wiki_id = " . $ilDB->quote($a_obj_id, "integer") .
             " AND user_id = " . $ilDB->quote($a_user_id, "integer"));
 
         $ilDB->manipulateF(
             "INSERT INTO il_wiki_contributor (status, wiki_id, user_id, status_time) " .
             "VALUES (%s,%s,%s,%s)",
             array("integer", "integer", "integer", "timestamp"),
             array($a_status, $a_obj_id, $a_user_id, ilUtil::now())
         );
     }