59 $this->usr_id = $a_usr_id;
102 $query =
"SELECT cal_id FROM cal_shared_status " .
103 "WHERE status = " .
$ilDB->quote(self::STATUS_ACCEPTED,
'integer') .
" " .
104 "AND usr_id = " .
$ilDB->quote($a_usr_id,
'integer') .
" ";
107 $cal_ids[] = $row->cal_id;
109 return $cal_ids ? $cal_ids : array();
121 public static function hasStatus($a_usr_id, $a_calendar_id)
127 $query =
"SELECT * FROM cal_shared_status " .
128 "WHERE usr_id = " .
$ilDB->quote($a_usr_id,
'integer') .
" " .
129 "AND cal_id = " .
$ilDB->quote($a_calendar_id,
'integer') .
" ";
131 return $res->numRows() ? true :
false;
149 $query =
"DELETE FROM cal_shared_status " .
150 "WHERE usr_id = " .
$ilDB->quote($a_usr_id,
'integer') .
" ";
169 $query =
"DELETE FROM cal_shared_status " .
170 "WHERE cal_id = " .
$ilDB->quote($a_calendar_id,
'integer') .
" ";
189 $rbacreview =
$DIC[
'rbacreview'];
193 $query =
"DELETE FROM cal_shared_status " .
194 "WHERE cal_id = " .
$ilDB->quote($a_calendar_id,
'integer') .
" " .
195 "AND usr_id = " .
$ilDB->quote($a_id,
'integer') .
" ";
198 $assigned_users = $rbacreview->assignedUsers($a_id);
200 if (!count($assigned_users)) {
204 $query =
"DELETE FROM cal_shared_status " .
205 "WHERE cal_id = " .
$ilDB->quote($a_calendar_id,
'integer') .
" " .
206 "AND " .
$ilDB->in(
'usr_id', $assigned_users,
false,
'integer');
230 $query =
"INSERT INTO cal_shared_status (cal_id,usr_id,status) " .
232 $this->db->quote($a_calendar_id,
'integer') .
", " .
233 $this->db->quote($this->usr_id,
'integer') .
", " .
234 $this->db->quote(self::STATUS_ACCEPTED,
'integer') .
" " .
258 $query =
"INSERT INTO cal_shared_status (cal_id,usr_id,status) " .
260 $this->db->quote($a_calendar_id,
'integer') .
", " .
261 $this->db->quote($this->usr_id,
'integer') .
", " .
262 $this->db->quote(self::STATUS_DECLINED,
'integer') .
" " .
283 $query =
"SELECT * FROM cal_shared_status " .
284 "WHERE usr_id = " . $this->db->quote($this->usr_id,
'integer') .
" ";
287 $this->calendars[$row->cal_id] = $row->status;
298 include_once(
'./Services/Calendar/classes/class.ilCalendarShared.php');
301 $invitations = array();
303 foreach ($shared as
$data) {
310 $invitations[] = array(
311 'cal_id' =>
$data[
'cal_id'],
312 'create_date' =>
$data[
'create_date'],
313 'obj_type' =>
$data[
'obj_type'],
314 'name' => $tmp_calendar->getTitle(),
315 'owner' => $tmp_calendar->getObjId(),
317 'accepted' => $this->
isAccepted($data[
'cal_id']),
318 'declined' => $this->
isDeclined($data[
'cal_id'])
An exception for terminatinating execution or to throw for unit testing.
static _getAssignedAppointments($a_cat_id)
Get assigned apointments.
Stores calendar categories.
Stores status (accepted/declined) of shared calendars.
decline($a_calendar_id)
decline calendar
__construct($a_usr_id)
Constructor.
isAccepted($a_cal_id)
is accepted
isDeclined($a_cal_id)
is declined
static deleteStatus($a_id, $a_calendar_id)
delete status
static hasStatus($a_usr_id, $a_calendar_id)
check if a status is set for an calendar
getOpenInvitations()
Get open invitations.
accept($a_calendar_id)
accept calendar
static deleteUser($a_usr_id)
Delete by user.
static getAcceptedCalendars($a_usr_id)
get accepted shared calendars
static deleteCalendar($a_calendar_id)
Delete calendar.
static getSharedCalendarsForUser($a_usr_id=0)
get shared calendars of user
static _lookupType($a_id, $a_reference=false)
lookup object type
foreach($_POST as $key=> $value) $res