53        $this->user_id = $a_user_id;
 
   54        $this->field_id = $a_field_id;
 
   56        if ($this->field_id) {
 
   73        include_once(
'Modules/Course/classes/Export/class.ilCourseDefinedFieldDefinition.php');
 
   75        if (!count($field_ids)) {
 
   79        $where = 
"WHERE " . 
$ilDB->in(
'field_id', $field_ids, 
false, 
'integer');
 
   80        $query = 
"SELECT * FROM crs_user_data " .
 
   88        return $user_data ? $user_data : array();
 
  106        include_once(
'Modules/Course/classes/Export/class.ilCourseDefinedFieldDefinition.php');
 
  108        if (!count($required)) {
 
  113        $and = 
"AND " . 
$ilDB->in(
'field_id', $required, 
false, 
'integer');
 
  115        $query = 
"SELECT COUNT(*) num_entries FROM crs_user_data " .
 
  116            "WHERE usr_id = " . 
$ilDB->quote($a_usr_id, 
'integer') . 
" " .
 
  117            "AND value != '' AND value IS NOT NULL " .
 
  123        return $row->num_entries == count($required);
 
  138        $query = 
"DELETE FROM crs_user_data " .
 
  139            "WHERE usr_id = " . 
$ilDB->quote($a_user_id, 
'integer');
 
  154        $query = 
"DELETE FROM crs_user_data " .
 
  155            "WHERE field_id = " . 
$ilDB->quote($a_field_id, 
'integer');
 
  161        $this->value = $a_value;
 
  186    public function delete()
 
  190        $query = 
"DELETE FROM crs_user_data " .
 
  191            "WHERE usr_id = " . $this->db->quote($this->user_id, 
'integer') . 
" " .
 
  192            "AND field_id = " . $this->db->quote($this->field_id, 
'integer');
 
  206        $query = 
"INSERT INTO crs_user_data (value,usr_id,field_id) " .
 
  208            $this->db->quote($this->
getValue(), 
'text') . 
", " .
 
  209            $this->db->quote($this->user_id, 
'integer') . 
", " .
 
  210            $this->db->quote($this->field_id, 
'integer') . 
" " .
 
  225        $query = 
"SELECT * FROM crs_user_data " .
 
  226            "WHERE usr_id = " . $this->db->quote($this->user_id, 
'integer') . 
" " .
 
  227            "AND field_id = " . $this->db->quote($this->field_id, 
'integer');
 
An exception for terminatinating execution or to throw for unit testing.
static _getFieldIds($a_container_id, $a_sort=IL_CDF_SORT_ID)
Get all field ids of a container.
static _getRequiredFieldIds($a_obj_id)
Get required filed id's.
static _deleteByField($a_field_id)
Delete by field.
static _deleteByUser($a_user_id)
Delete all entries of an user.
static _getValuesByObjId($a_obj_id)
Get values by obj_id (for all users)
__construct($a_user_id, $a_field_id=0)
Contructor.
static _checkRequired($a_usr_id, $a_obj_id)
Check required fields.
foreach($_POST as $key=> $value) $res