/**
* Create a category for a new object (crs,grp, ...)
*
* @access public
* @param object ilias object ('crs','grp',...)
* @static
*/
public static function createCategory($a_obj)
{
global $lng;
include_once './Services/Calendar/classes/class.ilCalendarCategory.php';
include_once './Services/Calendar/classes/class.ilCalendarAppointmentColors.php';
$cat = new ilCalendarCategory();
$cat->setTitle($a_obj->getTitle() ? $a_obj->getTitle() : $lng->txt('obj_' . $a_obj->getType()));
$cat->setType(ilCalendarCategory::TYPE_OBJ);
$cat->setColor(ilCalendarAppointmentColors::_getRandomColorByType($a_obj->getType()));
$cat->setObjId($a_obj->getId());
return $cat->add();
}
$wd = getcwd();
global $ilLog;
include_once 'Services/Calendar/classes/class.ilCalendarAppointmentColors.php';
// Create missing crs calendars
$query = "SELECT obd.obj_id,obd.title,obd.type FROM object_data AS obd " . "LEFT JOIN cal_categories AS cc on obd.obj_id = cc.obj_id AND cc.type = 2 " . "WHERE cc.obj_id IS NULL and obd.type = 'crs' ";
$res = $ilDB->query($query);
while ($row = $res->fetchRow(DB_FETCHMODE_OBJECT)) {
$color = ilCalendarAppointmentColors::_getRandomColorByType('crs');
$query = "INSERT INTO cal_categories SET " . "obj_id = " . $ilDB->quote($row->obj_id) . ", " . "title = " . $ilDB->quote($row->title) . ", " . "color = '" . $color . "', " . "type = 2";
$ilDB->query($query);
}
// Create missing grp calendars
$query = "SELECT obd.obj_id,obd.title,obd.type FROM object_data AS obd " . "LEFT JOIN cal_categories AS cc on obd.obj_id = cc.obj_id AND cc.type = 2 " . "WHERE cc.obj_id IS NULL and obd.type = 'grp' ";
$res = $ilDB->query($query);
while ($row = $res->fetchRow(DB_FETCHMODE_OBJECT)) {
$color = ilCalendarAppointmentColors::_getRandomColorByType('grp');
$query = "INSERT INTO cal_categories SET " . "obj_id = " . $ilDB->quote($row->obj_id) . ", " . "title = " . $ilDB->quote($row->title) . ", " . "color = '" . $color . "', " . "type = 2";
$ilDB->query($query);
}
?>
<#1257>
ALTER TABLE il_wiki_data ADD COLUMN introduction TEXT;
<#1258>
ALTER TABLE mail_saved
CHANGE rcp_to rcp_to TEXT NULL DEFAULT NULL ,
CHANGE rcp_cc rcp_cc TEXT NULL DEFAULT NULL ,
CHANGE rcp_bcc rcp_bcc TEXT NULL DEFAULT NULL ,
CHANGE m_type m_type VARCHAR(255) NULL DEFAULT NULL;
<#1259>
<?php
/**
* Create a category for a new object (crs,grp, ...)
*
* @access public
* @param object ilias object ('crs','grp',...)
* @static
*/
public static function createCategory($a_obj, $a_check_existing = false)
{
global $lng;
include_once './Services/Calendar/classes/class.ilCalendarCategory.php';
include_once './Services/Calendar/classes/class.ilCalendarAppointmentColors.php';
// already existing? do update instead
if ($a_check_existing && ilCalendarCategory::_getInstanceByObjId($a_obj->getId())) {
return self::updateCategory($a_obj);
}
$cat = new ilCalendarCategory();
$cat->setTitle($a_obj->getTitle() ? $a_obj->getTitle() : $lng->txt('obj_' . $a_obj->getType()));
$cat->setType(ilCalendarCategory::TYPE_OBJ);
$cat->setColor(ilCalendarAppointmentColors::_getRandomColorByType($a_obj->getType()));
$cat->setObjId($a_obj->getId());
return $cat->add();
}
