class.ilCalendarDataSet.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2012 ILIAS open source, Extended GPL, see docs/LICENSE */

include_once("./Services/DataSet/classes/class.ilDataSet.php");

class ilCalendarDataSet extends ilDataSet
{
    public function getSupportedVersions()
    {
        return array("4.3.0");
    }
    
    public function getXmlNamespace($a_entity, $a_schema_version)
    {
        return "http://www.ilias.de/xml/Services/Calendar/" . $a_entity;
    }
    
    protected function getTypes($a_entity, $a_version)
    {
        // calendar
        if ($a_entity == "calendar") {
            switch ($a_version) {
                case "4.3.0":
                    return array(
                        "CatId" => "integer",
                        "ObjId" => "text",
                        "Title" => "text",
                        "Color" => "text",
                        "Type" => "integer"
                    );
            }
        }
        
        // calendar entry
        if ($a_entity == "cal_entry") {
            switch ($a_version) {
                case "4.3.0":
                    return array(
                        "Id" => "integer",
                        "Title" => "text",
                        "Subtitle" => "text",
                        "Description" => "text",
                        "Location" => "text",
                        "Fullday" => "integer",
                        "Starta" => "text",
                        "Enda" => "text",
                        "Informations" => "text",
                        "AutoGenerated" => "integer",
                        "ContextId" => "integer",
                        "TranslationType" => "integer",
                        "IsMilestone" => "integer",
                        "Completion" => "integer",
                        "Notification" => "integer"
                    );
            }
        }
        
        // calendar/entry assignment
        if ($a_entity == "cal_assignment") {
            switch ($a_version) {
                case "4.3.0":
                    return array(
                        "CatId" => "integer",
                        "EntryId" => "integer"
                    );
            }
        }
        
        // recurrence rule
        if ($a_entity == "recurrence_rule") {
            switch ($a_version) {
                case "4.3.0":
                    return array(
                        "RuleId" => "integer",
                        "EntryId" => "integer",
                        "CalRecurrence" => "integer",
                        "FreqType" => "text",
                        "FreqUntilDate" => "text",
                        "FreqUntilCount" => "integer",
                        "Intervall" => "integer",
                        "Byday" => "text",
                        "Byweekno" => "text",
                        "Bymonth" => "text",
                        "Bymonthday" => "text",
                        "Byyearday" => "text",
                        "Bysetpos" => "text",
                        "Weekstart" => "text"
                    );
            }
        }
    }

    public function readData($a_entity, $a_version, $a_ids, $a_field = "")
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];

        if (!is_array($a_ids)) {
            $a_ids = array($a_ids);
        }

        // calendar
        if ($a_entity == "calendar") {
            switch ($a_version) {
                case "4.3.0":
                    $this->getDirectDataFromQuery("SELECT cat_id, obj_id, title, color, type " .
                        " FROM cal_categories " .
                        " WHERE " .
                        $ilDB->in("cat_id", $a_ids, false, "integer"));
                    break;
            }
        }
        
        // cal assignments
        if ($a_entity == "cal_assignment") {
            switch ($a_version) {
                case "4.3.0":
                    $this->getDirectDataFromQuery("SELECT cat_id, cal_id entry_id " .
                        " FROM cal_cat_assignments " .
                        " WHERE " .
                        $ilDB->in("cat_id", $a_ids, false, "integer"));
                    break;
            }
        }
        
        // cal entries
        if ($a_entity == "cal_entry") {
            switch ($a_version) {
                case "4.3.0":
                    $this->getDirectDataFromQuery("SELECT cal_id id, title, subtitle, description, location, fullday, " .
                        " starta, enda, informations, auto_generated, context_id, translation_type, is_milestone, completion, notification " .
                        " FROM cal_entries " .
                        " WHERE " .
                        $ilDB->in("cal_id", $a_ids, false, "integer"));
                    break;
            }
        }

        
        // recurrence_rule
        if ($a_entity == "recurrence_rule") {
            switch ($a_version) {
                case "4.3.0":
                    $this->getDirectDataFromQuery("SELECT rule_id, cal_id entry_id, cal_recurrence, freq_type, freq_until_date, freq_until_count, " .
                        " intervall, byday, byweekno, bymonth, bymonthday, byyearday, bysetpos, weekstart " .
                        " FROM cal_recurrence_rules " .
                        " WHERE " .
                        $ilDB->in("cal_id", $a_ids, false, "integer"));
                    break;
            }
        }
    }
    
    protected function getDependencies($a_entity, $a_version, $a_rec, $a_ids)
    {
        switch ($a_entity) {
            case "calendar":
                include_once("./Services/Calendar/classes/class.ilCalendarCategoryAssignments.php");
                $assignmnts = ilCalendarCategoryAssignments::_getAssignedAppointments(array($a_rec["CatId"]));
                $entries = array();
                foreach ($assignmnts as $cal_id) {
                    $entries[$cal_id] = $cal_id;
                }
                return array(
                    "cal_entry" => array("ids" => $entries),
                    "cal_assignment" => array("ids" => $a_rec["CatId"])
                );
            case "cal_entry":
                return array(
                    "recurrence_rule" => array("ids" => $a_rec["Id"])
                );
        }

        return false;
    }

    public function importRecord($a_entity, $a_types, $a_rec, $a_mapping, $a_schema_version)
    {
        switch ($a_entity) {
            case "calendar":
                // please note: we currently only support private user calendars to
                // be imported
                if ($a_rec["Type"] == 1) {
                    $usr_id = $a_mapping->getMapping("Services/User", "usr", $a_rec["ObjId"]);
                    if ($usr_id > 0 && ilObject::_lookupType($usr_id) == "usr") {
                        include_once('./Services/Calendar/classes/class.ilCalendarCategory.php');
                        $category = new ilCalendarCategory(0);
                        $category->setTitle($a_rec["Title"]);
                        $category->setColor($a_rec["Color"]);
                        $category->setType(ilCalendarCategory::TYPE_USR);
                        $category->setObjId($usr_id);
                        $category->add();
                        $a_mapping->addMapping(
                            "Services/Calendar",
                            "calendar",
                            $a_rec["CatId"],
                            $category->getCategoryID()
                        );
                    }
                }
                break;

            case "cal_entry":
                // please note: we currently only support private user calendars to
                // be imported
                if ((int) $a_rec["ContextId"] == 0) {
                    include_once('./Services/Calendar/classes/class.ilCalendarEntry.php');
                    $entry = new ilCalendarEntry(0);
                    $entry->setTitle($a_rec["Title"]);
                    $entry->setSubtitle($a_rec["Subtitle"]);
                    $entry->setDescription($a_rec["Description"]);
                    $entry->setLocation($a_rec["Location"]);
                    $entry->setFullday($a_rec["Fullday"]);
                    if ($a_rec["Starta"] != "") {
                        $entry->setStart(new ilDateTime($a_rec["Starta"], IL_CAL_DATETIME, 'UTC'));
                    }
                    if ($a_rec["Enda"] != "") {
                        $entry->setEnd(new ilDateTime($a_rec["Enda"], IL_CAL_DATETIME, 'UTC'));
                    }
                    $entry->setFurtherInformations($a_rec["Informations"]);
                    $entry->setAutoGenerated($a_rec["AutoGenerated"]);
                    $entry->setContextId($a_rec["ContextId"]);
                    $entry->setMilestone($a_rec["Milestone"]);
                    $entry->setCompletion($a_rec["Completion"]);
                    $entry->setTranslationType($a_rec["TranslationType"]);
                    $entry->enableNotification($a_rec["Notification"]);
                    $entry->save();
                    $a_mapping->addMapping(
                        "Services/Calendar",
                        "cal_entry",
                        $a_rec["Id"],
                        $entry->getEntryId()
                    );
                }
                break;
                
            case "cal_assignment":
                $cat_id = $a_mapping->getMapping("Services/Calendar", "calendar", $a_rec["CatId"]);
                $entry_id = $a_mapping->getMapping("Services/Calendar", "cal_entry", $a_rec["EntryId"]);
                if ($cat_id > 0 && $entry_id > 0) {
                    include_once('./Services/Calendar/classes/class.ilCalendarCategoryAssignments.php');
                    $ass = new ilCalendarCategoryAssignments($entry_id);
                    $ass->addAssignment($cat_id);
                }
                break;
                
            case "recurrence_rule":
                $entry_id = $a_mapping->getMapping("Services/Calendar", "cal_entry", $a_rec["EntryId"]);
                if ($entry_id > 0) {
                    include_once('./Services/Calendar/classes/class.ilCalendarRecurrence.php');
                    $rec = new ilCalendarRecurrence();
                    $rec->setEntryId($entry_id);
                    $rec->setRecurrence($a_rec["CalRecurrence"]);
                    $rec->setFrequenceType($a_rec["FreqType"]);
                    if ($a_rec["FreqUntilDate"] != "") {
                        $rec->setFrequenceUntilDate(new ilDateTime($a_rec["FreqUntilDate"], IL_CAL_DATETIME));
                    }
                    $rec->setFrequenceUntilCount($a_rec["FreqUntilCount"]);
                    $rec->setInterval($a_rec["Interval"]);
                    $rec->setBYDAY($a_rec["Byday"]);
                    $rec->setBYWEEKNO($a_rec["Byweekno"]);
                    $rec->setBYMONTH($a_rec["Bymonth"]);
                    $rec->setBYMONTHDAY($a_rec["Bymonthday"]);
                    $rec->setBYYEARDAY($a_rec["Byyearday"]);
                    $rec->setBYSETPOS($a_rec["Bysetpos"]);
                    $rec->setWeekstart($a_rec["Weekstart"]);
                    $rec->save();
                    $a_mapping->addMapping(
                        "Services/Calendar",
                        "recurrence_rule",
                        $a_rec["RuleId"],
                        $rec->getRecurrenceId()
                    );
                }
                break;
        }
    }
}