4include_once(
'Services/Calendar/classes/class.ilDate.php');
 
    5include_once(
'./Services/Calendar/interfaces/interface.ilDatePeriod.php');
 
    7define(
'IL_CAL_TRANSLATION_NONE', 0);
 
    8define(
'IL_CAL_TRANSLATION_SYSTEM', 1);
 
   58        if ($this->entry_id = $a_id) {
 
   68        $this->entry_id = 
null;
 
   78    public static function _delete($a_entry_id)
 
   82        include_once(
'./Services/Calendar/classes/class.ilCalendarRecurrence.php');
 
   85        $query = 
"DELETE FROM cal_entries " .
 
   86            "WHERE cal_id = " . 
$ilDB->quote($a_entry_id, 
'integer') . 
" ";
 
  124        $this->last_update = $a_date;
 
  147        $this->start = $a_start;
 
  179        $this->title = $a_title;
 
  208            if (preg_match(
"/#([a-z]+)#/", $this->
getSubtitle(), $matches)) {
 
  230        return $this->presentation_style;
 
  239            case "consultationhour":
 
  240                include_once 
'Services/Booking/classes/class.ilBookingEntry.php';
 
  243                    if ($entry->isOwner()) {
 
  244                        $max = (int) $entry->getNumberOfBookings();
 
  245                        $current = (int) $entry->getCurrentNumberOfBookings($this->getEntryId());
 
  247                            $style = 
';border-left-width: 5px; border-left-style: solid; border-left-color: green';
 
  250                            $style = 
';border-left-width: 5px; border-left-style: solid; border-left-color: red';
 
  253                            $style = 
';border-left-width: 5px; border-left-style: solid; border-left-color: yellow';
 
  260                        include_once 
'Services/Calendar/classes/ConsultationHours/class.ilConsultationHourAppointments.php';
 
  262                        $orig_event = $apps[0];
 
  263                        if ($entry->hasBooked($orig_event)) {
 
  264                            $style = 
';border-left-width: 5px; border-left-style: solid; border-left-color: green';
 
  273            $this->presentation_style = 
$style;
 
  289        $this->subtitle = $a_subtitle;
 
  312        $this->description = $a_description;
 
  334        $this->location = $a_location;
 
  356        $this->further_informations = $a_informations;
 
  380        $this->fullday = (bool) $a_fullday;
 
  414        $this->is_auto_generated = $a_status;
 
  438        $this->is_milestone = $a_status;
 
  448        $this->completion = $a_completion;
 
  493        $this->translation_type = 
$a_type;
 
  539        $query = 
"UPDATE cal_entries " .
 
  540            "SET title = " . $this->db->quote($this->
getTitle(), 
'text') . 
", " .
 
  541            "last_update = " . $ilDB->quote($utc_timestamp, 
'timestamp') . 
", " .
 
  542            "subtitle = " . $this->db->quote($this->
getSubtitle(), 
'text') . 
", " .
 
  543            "description = " . $this->db->quote($this->
getDescription(), 
'text') . 
", " .
 
  544            "location = " . $this->db->quote($this->
getLocation(), 
'text') . 
", " .
 
  545            "fullday = " . $ilDB->quote($this->
isFullday() ? 1 : 0, 
'integer') . 
", " .
 
  549            "auto_generated =  " . $this->db->quote($this->
isAutoGenerated(), 
'integer') . 
", " .
 
  550            "translation_type = " . $this->db->quote($this->
getTranslationType(), 
'integer') . 
", " .
 
  551            "context_id = " . $this->db->quote($this->
getContextId(), 
'integer') . 
", " .
 
  552            "completion = " . $this->db->quote($this->
getCompletion(), 
'integer') . 
", " .
 
  553            "is_milestone = " . $this->db->quote($this->
isMilestone() ? 1 : 0, 
'integer') . 
", " .
 
  555            "WHERE cal_id = " . $this->db->quote($this->
getEntryId(), 
'integer') . 
" ";
 
  571        $next_id = 
$ilDB->nextId(
'cal_entries');
 
  575        $query = 
"INSERT INTO cal_entries (cal_id,title,last_update,subtitle,description,location,fullday,starta,enda, " .
 
  576            "informations,auto_generated,context_id,translation_type, completion, is_milestone, notification) " .
 
  578            $ilDB->quote($next_id, 
'integer') . 
", " .
 
  579            $this->db->quote($this->
getTitle(), 
'text') . 
", " .
 
  580            $ilDB->quote($utc_timestamp, 
'timestamp') . 
", " .
 
  581            $this->db->quote($this->
getSubtitle(), 
'text') . 
", " .
 
  583            $this->db->quote($this->
getLocation(), 
'text') . 
", " .
 
  584            $ilDB->quote($this->
isFullday() ? 1 : 0, 
'integer') . 
", " .
 
  589            $this->db->quote($this->
getContextId(), 
'integer') . 
", " .
 
  592            $this->db->quote($this->
isMilestone() ? 1 : 0, 
'integer') . 
", " .
 
  597        $this->entry_id = $next_id;
 
  607    public function delete()
 
  611        include_once(
'./Services/Calendar/classes/class.ilCalendarRecurrence.php');
 
  614        $query = 
"DELETE FROM cal_entries " .
 
  615            "WHERE cal_id = " . $this->db->quote($this->
getEntryId(), 
'integer') . 
" ";
 
  618        include_once 
'./Services/Calendar/classes/class.ilCalendarCategoryAssignments.php';
 
  638            $ilErr->appendMessage(
$lng->txt(
'err_missing_title'));
 
  644            $ilErr->appendMessage(
$lng->txt(
'err_end_before_start'));
 
  660        $query = 
"SELECT * FROM cal_entries WHERE cal_id = " . $this->db->quote($this->
getEntryId(), 
'integer') . 
" ";
 
  694        $body = 
$lng->txt(
'cal_details');
 
  696        $body .= 
$lng->txt(
'title') . 
': ' . $this->
getTitle() . 
"\n";
 
  721            "DELETE FROM cal_entry_responsible WHERE cal_id = %s",
 
  726        if (is_array($a_users)) {
 
  727            foreach ($a_users as $user_id) {
 
  729                    "INSERT INTO cal_entry_responsible (cal_id, user_id) " .
 
  731                    array(
"integer", 
"integer"),
 
  737        $this->responsible_users = $a_users;
 
  747        $set = 
$ilDB->queryF(
 
  748            "SELECT * FROM cal_entry_responsible WHERE cal_id = %s",
 
  754        while ($rec = 
$ilDB->fetchAssoc($set)) {
 
  756            $return[] = array_merge(
 
An exception for terminatinating execution or to throw for unit testing.
const IL_CAL_TRANSLATION_NONE
static _deleteByAppointmentId($a_app_id)
Delete appointment assignment.
Model for a calendar entry.
setTranslationType($a_type)
@access public
enableNotification($a_status)
Enable course group notification.
setLastUpdate($a_date)
set last update
appointmentToMailString($lng)
writeResponsibleUsers($a_users)
Write users responsible for a milestone.
setAutoGenerated($a_status)
set auto generated
setFullday($a_fullday)
set fullday event Fullday events do not change their time in different timezones.
isMilestone()
is milestone
setLocation($a_location)
set location
static _delete($a_entry_id)
delete entry
setTitle($a_title)
set title
setCompletion($a_completion)
Set Completion.
setFurtherInformations($a_informations)
set further informations
getContextId()
get context id
setMilestone($a_status)
set milestone
readResponsibleUsers()
Read responsible users.
getEnd()
get end @access public
setStart($a_start)
@access public
__construct($a_id=0)
Constructor.
getTranslationType()
get translation type
getCompletion()
Get Completion.
setEnd($a_end)
set end @access public
parseDynamicTitle($a_type)
getPresentationTitle($a_shorten=true)
get title for presentation.
setContextId($a_context_id)
set context id
isAutoGenerated()
is auto generated
isNotificationEnabled()
Check if course group notification is enabled.
getSubtitle()
get subtitle
setSubtitle($a_subtitle)
set subtitle Used for automatic generated appointments.
getFurtherInformations()
get further informations
getLastUpdate()
get last update
getDescription()
get description
setDescription($a_description)
set description
getLocation()
get location
static _delete($a_cal_id)
delete
static getAppointmentIds($a_user_id, $a_context_id=null, $a_start=null, $a_type=null, $a_check_owner=true)
Get all appointment ids.
static setUseRelativeDates($a_status)
set use relative dates
static formatPeriod(ilDateTime $start, ilDateTime $end, $a_skip_starting_day=false)
Format a period of two date Shows: 14.
@classDescription Date and time handling
static _before(ilDateTime $start, ilDateTime $end, $a_compare_field='', $a_tz='')
compare two dates and check start is before end This method does not consider tz offsets.
static _lookupLogin($a_user_id)
lookup login
static _lookupName($a_user_id)
lookup user name
static shortenWords($a_str, $a_len=30, $a_dots=true)
Ensure that the maximum word lenght within a text is not longer than $a_len.
static shortenText( $a_str, $a_len, $a_dots=false, $a_next_blank=false, $a_keep_extension=false)
shorten a string to given length.
foreach($_POST as $key=> $value) $res