23include_once(
'Services/PrivacySecurity/classes/class.ilPrivacySettings.php');
 
   24include_once(
'Modules/Course/classes/Export/class.ilCourseDefinedFieldDefinition.php');
 
   61        $this->user_id = $a_usr_id;
 
   62        $this->obj_id = $a_obj_id;
 
   86        $query = 
"SELECT * FROM member_agreement " .
 
   87            "WHERE obj_id = " . 
$ilDB->quote($a_obj_id, 
'integer');
 
   91            $user_data[
$row->usr_id][
'accepted'] = 
$row->accepted;
 
   92            $user_data[
$row->usr_id][
'acceptance_time'] = 
$row->acceptance_time;
 
   94        return $user_data ? $user_data : array();
 
  111        $query = 
"SELECT * FROM member_agreement " .
 
  112            "WHERE obj_id = " . 
$ilDB->quote($a_obj_id, 
'integer') . 
" " .
 
  116        return $res->numRows() ? true : 
false;
 
  133        $query = 
"SELECT * FROM member_agreement " .
 
  134            "WHERE accepted = 1";
 
  137        return $res->numRows() ? true : 
false;
 
  154        $query = 
"SELECT accepted FROM member_agreement " .
 
  155            "WHERE usr_id = " . 
$ilDB->quote($a_usr_id, 
'integer') . 
" " .
 
  156            "AND obj_id = " . 
$ilDB->quote($a_obj_id, 
'integer');
 
  160        return $row->accepted == 1 ? true : 
false;
 
  174        $query = 
"SELECT usr_id FROM member_agreement " .
 
  175            "WHERE obj_id = " . 
$ilDB->quote($a_obj_id, 
'integer') . 
' ' .
 
  181            $user_ids[] = 
$row[
'usr_id'];
 
  202        $query = 
"DELETE FROM member_agreement " .
 
  203            "WHERE usr_id =" . 
$ilDB->quote($a_usr_id, 
'integer') . 
" ";
 
  222        $query = 
"DELETE FROM member_agreement " .
 
  223            "WHERE obj_id =" . 
$ilDB->quote($a_obj_id, 
'integer') . 
" ";
 
  243        $query = 
"UPDATE member_agreement SET accepted = 0 ";
 
  262        $query = 
"UPDATE member_agreement " .
 
  263            "SET accepted = 0 " .
 
  264            "WHERE obj_id = " . 
$ilDB->quote($a_container_id, 
'integer') . 
" ";
 
  278        $this->accepted = $a_status;
 
  290        $this->acceptance_time = $a_timest;
 
  304        return $this->accepted ? false : 
true;
 
  345        $query = 
"INSERT INTO member_agreement (usr_id,obj_id,accepted,acceptance_time) " .
 
  347            $this->db->quote($this->user_id, 
'integer') . 
", " .
 
  348            $this->db->quote($this->obj_id, 
'integer') . 
", " .
 
  349            $this->db->quote((
int) $this->
isAccepted(), 
'integer') . 
", " .
 
  350            $this->db->quote($this->getAcceptanceTime(), 
'integer') . 
" " .
 
  362    public function delete()
 
  368        $query = 
"DELETE FROM member_agreement " .
 
  369            "WHERE usr_id = " . $this->db->quote($this->user_id, 
'integer') . 
" " .
 
  370            "AND obj_id = " . $this->db->quote($this->obj_id, 
'integer');
 
  382        $query = 
"SELECT * FROM member_agreement " .
 
  383            "WHERE usr_id = " . $this->db->quote($this->user_id, 
'integer') . 
" " .
 
  384            "AND obj_id = " . $this->db->quote($this->obj_id, 
'integer') . 
" ";
 
  388            $this->accepted = 
$row->accepted;
 
  389            $this->acceptance_time = 
$row->acceptance_time;
 
An exception for terminatinating execution or to throw for unit testing.
static _hasFields($a_container_id)
Check if there are any define fields.
save()
save Acceptance settings
static _hasAccepted($a_usr_id, $a_obj_id)
Check if user has accepted agreement.
setAccepted($a_status)
set accepted
static _hasAgreementsByObjId($a_obj_id)
Check if there is any user agreement.
setAcceptanceTime($a_timest)
set acceptance time
static _hasAgreements()
Check if there is any user agreement.
static _deleteByObjId($a_obj_id)
Delete all entries by obj_id.
static _deleteByUser($a_usr_id)
Delete all entries by user.
getAcceptanceTime()
get Acceptance time
__construct($a_usr_id, $a_obj_id)
Constructor.
static lookupAcceptedAgreements($a_obj_id)
Lookup users who have accepted the agreement.
agreementRequired()
Checks whether the agreement is accepted This function return always true if no acceptance is require...
static _readByObjId($a_obj_id)
Read user data by object id.
static _resetContainer($a_container_id)
Reset all agreements for a specific container.
static _reset()
Reset all.
static _lookupType($a_id, $a_reference=false)
lookup object type
static _getInstance()
Get instance of ilPrivacySettings.
foreach($_POST as $key=> $value) $res