53 $this->user_id = $this->user->getId();
55 $this->
setMode(self::MODE_ADDRESSBOOK);
62 $nextId = $this->db->nextId(
'addressbook_mlist');
63 $statement = $this->db->manipulateF(
' 64 INSERT INTO addressbook_mlist 73 VALUES(%s, %s, %s, %s, %s, %s, %s)',
90 $this->mail_id = $nextId;
97 if ($this->mail_id && $this->user_id)
99 $statement = $this->db->manipulateF(
' 100 UPDATE addressbook_mlist 130 public function delete()
132 if ($this->mail_id && $this->user_id)
136 $statement = $this->db->manipulateF(
' 137 DELETE FROM addressbook_mlist 140 array(
'integer',
'integer'),
155 $res = $this->db->queryf(
' 156 SELECT * FROM addressbook_mlist 159 array(
'integer',
'integer'),
182 $res = $this->db->queryf(
183 'SELECT a_id, usr_data.usr_id FROM addressbook_mlist_ass INNER JOIN usr_data ON usr_data.usr_id = addressbook_mlist_ass.usr_id WHERE ml_id = %s',
185 array($this->
getId())
192 $entries[
$row->a_id] = array(
193 'a_id' =>
$row->a_id,
194 'usr_id' =>
$row->usr_id
208 $nextId = $this->db->nextId(
'addressbook_mlist_ass');
209 $this->db->manipulateF(
210 'INSERT INTO addressbook_mlist_ass (a_id, ml_id, usr_id) VALUES(%s, %s, %s)',
211 array(
'integer',
'integer',
'integer'),
212 array($nextId, $this->
getId(), $usr_id)
223 $this->db->manipulateF(
224 'DELETE FROM addressbook_mlist_ass WHERE a_id = %s',
236 $this->db->manipulateF(
237 'DELETE FROM addressbook_mlist_ass WHERE ml_id = %s',
239 array($this->
getId())
244 public function setId($a_mail_id = 0)
246 $this->mail_id = $a_mail_id;
254 $this->user_id = $a_user_id;
262 $this->title = $a_title;
270 $this->description = $a_description;
278 $this->createdate = $_createdate;
286 if($a_changedate ==
'0000-00-00 00:00:00')
287 $this->changedate = NULL;
289 $this->changedate = $a_changedate;
296 public static function _isOwner($a_ml_id, $a_usr_id)
300 $res = $ilDB->queryf(
' 301 SELECT * FROM addressbook_mlist 304 array(
'integer',
'integer'),
305 array($a_ml_id, $a_usr_id));
309 return is_object(
$row) ? true :
false;
314 $a_mode = (int)$a_mode;
315 if(in_array($a_mode, array(self::MODE_ADDRESSBOOK, self::MODE_TEMPORARY)))
317 $this->mode = (int)$a_mode;
329 public static function removeAssignmentsByUserId($usr_id)
336 $ilDB->manipulate(
'DELETE FROM addressbook_mlist_ass WHERE usr_id = ' . $ilDB->quote($usr_id,
'integer'));
static _isOwner($a_ml_id, $a_usr_id)
setDescription($a_description='')
const DB_FETCHMODE_OBJECT
setChangedate($a_changedate='0000-00-00 00:00:00')
setCreatedate($_createdate='0000-00-00 00:00:00')
__construct(ilObjUser $user, $id=0)