class.ilTaxonomyDataSet.php

Go to the documentation of this file.

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

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

class ilTaxonomyDataSet 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/Taxonomy/" . $a_entity;
    }
    
    protected function getTypes($a_entity, $a_version)
    {
        // tax
        if ($a_entity == "tax") {
            switch ($a_version) {
                case "4.3.0":
                    return array(
                        "Id" => "integer",
                        "Title" => "text",
                        "Description" => "text",
                        "SortingMode" => "integer");
            }
        }
    
        // tax_usage
        if ($a_entity == "tax_usage") {
            switch ($a_version) {
                case "4.3.0":
                        return array(
                            "TaxId" => "integer",
                            "ObjId" => "integer"
                        );
            }
        }

        // tax_tree
        if ($a_entity == "tax_tree") {
            switch ($a_version) {
                case "4.3.0":
                        return array(
                            "TaxId" => "integer",
                            "Child" => "integer",
                            "Parent" => "integer",
                            "Depth" => "integer",
                            "Type" => "text",
                            "Title" => "text",
                            "OrderNr" => "integer"
                        );
            }
        }

        // tax_node_assignment
        if ($a_entity == "tax_node_assignment") {
            switch ($a_version) {
                case "4.3.0":
                        return array(
                            "NodeId" => "integer",
                            "Component" => "text",
                            "ItemType" => "text",
                            "ItemId" => "integer"
                        );
            }
        }
    }

    public function readData($a_entity, $a_version, $a_ids, $a_field = "")
    {
        $ilDB = $this->db;

        if (!is_array($a_ids)) {
            $a_ids = array($a_ids);
        }
                
        // tax
        if ($a_entity == "tax") {
            switch ($a_version) {
                case "4.3.0":
                    $this->getDirectDataFromQuery("SELECT id, title, description, " .
                        " sorting_mode" .
                        " FROM tax_data JOIN object_data ON (tax_data.id = object_data.obj_id) " .
                        "WHERE " .
                        $ilDB->in("id", $a_ids, false, "integer"));
                    break;
            }
        }

        // tax usage
        if ($a_entity == "tax_usage") {
            switch ($a_version) {
                case "4.3.0":
                    $this->getDirectDataFromQuery("SELECT tax_id, obj_id " .
                        " FROM tax_usage " .
                        "WHERE " .
                        $ilDB->in("tax_id", $a_ids, false, "integer"));
                    break;
            }
        }

        // tax_tree
        if ($a_entity == "tax_tree") {
            switch ($a_version) {
                case "4.3.0":
                    $this->getDirectDataFromQuery("SELECT tax_id, child " .
                        " ,parent,depth,type,title,order_nr " .
                        " FROM tax_tree JOIN tax_node ON (child = obj_id) " .
                        " WHERE " .
                        $ilDB->in("tax_id", $a_ids, false, "integer") .
                        " ORDER BY depth");
                    break;
            }
        }

        // tax node assignment
        if ($a_entity == "tax_node_assignment") {
            switch ($a_version) {
                case "4.3.0":
                    $this->getDirectDataFromQuery("SELECT node_id, component, item_type, item_id " .
                        " FROM tax_node_assignment " .
                        "WHERE " .
                        $ilDB->in("node_id", $a_ids, false, "integer"));
                    break;
            }
        }
    }
    
    protected function getDependencies($a_entity, $a_version, $a_rec, $a_ids)
    {
        switch ($a_entity) {
            case "tax":
                return array(
                    "tax_tree" => array("ids" => $a_rec["Id"]),
                    "tax_usage" => array("ids" => $a_rec["Id"])
                );
            case "tax_tree":
                return array(
                    "tax_node_assignment" => array("ids" => $a_rec["Child"])
                );
        }
        return false;
    }
    
    
    
    public function importRecord($a_entity, $a_types, $a_rec, $a_mapping, $a_schema_version)
    {
        //echo $a_entity;
        //var_dump($a_rec);

        switch ($a_entity) {
            case "tax":
                include_once("./Services/Taxonomy/classes/class.ilObjTaxonomy.php");

//                              if($new_id = $a_mapping->getMapping('Services/Container','objs',$a_rec['Id']))
//                              {
//                                      $newObj = ilObjectFactory::getInstanceByObjId($new_id,false);
//                              }
//                              else
//                              {
                    $newObj = new ilObjTaxonomy();
                    $newObj->create();
//                              }
                
                $newObj->setTitle($a_rec["Title"]);
                $newObj->setDescription($a_rec["Description"]);
                $newObj->setSortingMode($a_rec["SortingMode"]);
                $newObj->update();
                
                $this->current_obj = $newObj;
                $a_mapping->addMapping("Services/Taxonomy", "tax", $a_rec["Id"], $newObj->getId());
                break;

            case "tax_tree":
                switch ($a_rec["Type"]) {
                    case "taxn":
                        $parent = (int) $a_mapping->getMapping("Services/Taxonomy", "tax_tree", $a_rec["Parent"]);
                        $tax_id = $a_mapping->getMapping("Services/Taxonomy", "tax", $a_rec["TaxId"]);
                        if ($parent == 0) {
                            $parent = $this->current_obj->getTree()->readRootId();
                        }
                        $node = new ilTaxonomyNode();
                        $node->setTitle($a_rec["Title"]);
                        $node->setOrderNr($a_rec["OrderNr"]);
                        $node->setTaxonomyId($tax_id);
                        $node->create();
                        ilTaxonomyNode::putInTree($tax_id, $node, (int) $parent, "", $a_rec["OrderNr"]);
                        $a_mapping->addMapping(
                            "Services/Taxonomy",
                            "tax_tree",
                            $a_rec["Child"],
                            $node->getId()
                        );
                        break;
                        
                }
                
                // no break
            case "tax_node_assignment":
                $new_item_id = (int) $a_mapping->getMapping(
                    "Services/Taxonomy",
                    "tax_item",
                    $a_rec["Component"] . ":" . $a_rec["ItemType"] . ":" . $a_rec["ItemId"]
                );
                $new_node_id = (int) $a_mapping->getMapping("Services/Taxonomy", "tax_tree", $a_rec["NodeId"]);

                // this is needed since 4.4 (but not exported with 4.3)
                // with 4.4 this should be part of export/import
                $new_item_id_obj = (int) $a_mapping->getMapping(
                    "Services/Taxonomy",
                    "tax_item_obj_id",
                    $a_rec["Component"] . ":" . $a_rec["ItemType"] . ":" . $a_rec["ItemId"]
                );
                if ($new_item_id > 0 && $new_node_id > 0 && $new_item_id_obj  > 0) {
                    include_once("./Services/Taxonomy/classes/class.ilTaxNodeAssignment.php");
                    $node_ass = new ilTaxNodeAssignment($a_rec["Component"], $new_item_id_obj, $a_rec["ItemType"], $this->current_obj->getId());
                    $node_ass->addAssignment($new_node_id, $new_item_id);
                }
                break;
                
            case "tax_usage":
                $usage = $a_mapping->getMapping("Services/Taxonomy", "tax_usage_of_obj", $a_rec["ObjId"]);
                if ($usage != "") {
                    $usage.=":";
                }
                $a_mapping->addMapping(
                    "Services/Taxonomy",
                    "tax_usage_of_obj",
                    $a_rec["ObjId"],
                    $usage . $this->current_obj->getId()
                );
                break;
        }
    }
}