class.ilBibliographicEntry.php

Go to the documentation of this file.

<?php
require_once('./Modules/Bibliographic/classes/class.ilBiblOverviewGUI.php');
/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilBibliographicEntry {

        protected $bibliographic_obj_id;
        protected $entry_id;
        protected $type;
        protected $attributes;
        protected $file_type;
        protected $overview = '';
        protected static $instances = array();


        public static function getInstance($file_type, $entry_id = null) {
                if (!$entry_id) {
                        return new self($file_type, $entry_id);
                }

                if (!isset(self::$instances[$entry_id])) {
                        self::$instances[$entry_id] = new self($file_type, $entry_id);
                }

                return self::$instances[$entry_id];
        }


        public static function exists($entry_id, $obj_id) {
                $q = "SELECT * FROM il_bibl_entry WHERE id = %s AND data_id = %s";
                global $DIC;
                $ilDB = $DIC['ilDB'];
                $r = $ilDB->queryF($q, array('integer', 'integer'), array($entry_id, $obj_id));

                return ($r->numRows() > 0);
        }


        protected function __construct($file_type, $entry_id = null) {
                $this->file_type = $file_type;
                if ($entry_id) {
                        $this->setEntryId($entry_id);
                        $this->doRead();
                }
        }


        public function doCreate() {
                global $DIC;
                $ilDB = $DIC['ilDB'];
                //auto-increment il_bibl_entry
                $this->setEntryId($ilDB->nextID('il_bibl_entry'));
                //table il_bibl_entry
                $ilDB->manipulate("INSERT INTO il_bibl_entry " . "(data_id, id, type) VALUES (" . $ilDB->quote($this->getBibliographicObjId(), "integer")
                                  . "," . // data_id
                                  $ilDB->quote($this->getEntryId(), "integer") . "," . // id
                                  $ilDB->quote($this->getType(), "text") . // type
                                  ")");
                //table il_bibl_attribute
                foreach ($this->getAttributes() as $attribute) {
                        //auto-increment il_bibl_attribute
                        $id = $ilDB->nextID('il_bibl_attribute');
                        $ilDB->manipulate("INSERT INTO il_bibl_attribute " . "(entry_id, name, value, id) VALUES (" . $ilDB->quote($this->getEntryId(), "integer")
                                          . "," . // entry_id
                                          $ilDB->quote($attribute['name'], "text") . "," . // name
                                          $ilDB->quote($attribute['value'], "text") . "," . // value
                                          $ilDB->quote($id, "integer") . // id
                                          ")");
                }
        }


        public function doRead() {
                global $DIC;
                $ilDB = $DIC['ilDB'];
                //table il_bibl_entry
                $set = $ilDB->query("SELECT * FROM il_bibl_entry " . " WHERE id = " . $ilDB->quote($this->getEntryId(), "integer"));
                while ($rec = $ilDB->fetchAssoc($set)) {
                        $this->setType($rec['type']);
                }
                $this->setAttributes($this->loadAttributes());
                $this->initOverviewHTML();
        }


        public function doUpdate() {
                global $DIC;
                $ilDB = $DIC['ilDB'];
                //table il_bibl_entry
                $ilDB->manipulate($up = "UPDATE il_bibl_entry SET " . " type = " . $ilDB->quote($this->getType(), "integer") . // type
                                        " WHERE id = " . $ilDB->quote($this->getEntryId(), "integer"));
                //table il_bibl_attribute
                foreach ($this->getAttributes() as $attribute) {
                        $ilDB->manipulate($up = "UPDATE il_bibl_attribute SET " . " name = " . $ilDB->quote($attribute['name'], "integer") . "," . // name
                                                " value = " . $ilDB->quote($attribute['value'], "integer") . "," . // value
                                                " WHERE id = " . $ilDB->quote($attribute['id'], "integer"));
                }
        }


        public function doDelete() {
                global $DIC;
                $ilDB = $DIC['ilDB'];
                $this->emptyCache();
                $this->deleteOptions();
                $ilDB->manipulate("DELETE FROM il_bibl_entry WHERE id = " . $ilDB->quote($this->getEntryId(), "integer"));
                $ilDB->manipulate("DELETE FROM il_bibl_attribute WHERE entry_id = " . $ilDB->quote($this->getEntryId(), "integer"));
        }


        protected function loadAttributes() {
                global $DIC;
                $ilDB = $DIC['ilDB'];
                $all_attributes = array();
                //table il_bibl_attribute
                $set = $ilDB->query("SELECT * FROM il_bibl_attribute " . " WHERE entry_id = " . $ilDB->quote($this->getEntryId(), "integer"));
                while ($rec = $ilDB->fetchAssoc($set)) {
                        $all_attributes[$rec['name']] = $rec['value'];
                }
                if ($this->file_type == "ris") {
                        //for RIS-Files also add the type;
                        $type = $this->getType();
                } else {
                        $type = 'default';
                }
                $parsed_attributes = array();
                foreach ($all_attributes as $key => $value) {
                        // surround links with <a href="">
                        // Allowed signs in URL: a-z A-Z 0-9 . ? & _ / - ~ ! ' * ( ) + , : ; @ = $ # [ ] %
                        $value = preg_replace('!(http)(s)?:\/\/[a-zA-Z0-9.?&_/\-~\!\'\*()+,:;@=$#\[\]%]+!', "<a href=\"\\0\" target=\"_blank\" rel=\"noopener\">\\0</a>", $value);
                        $parsed_attributes[strtolower($this->file_type . '_' . $type . '_' . $key)] = $value;
                }

                return $parsed_attributes;
        }


        public function setAttributes($attributes) {
                $this->attributes = $attributes;
        }


        public function getAttributes() {
                return $this->attributes;
        }


        public function initOverviewHTML() {
                $ilBiblOverviewGUI = new ilBiblOverviewGUI($this);
                $this->setOverview($ilBiblOverviewGUI->getHtml());
        }


        public function getOverview() {
                return $this->overview;
        }


        public function setOverview($overview) {
                $this->overview = $overview;
        }


        public function setBibliographicObjId($bibliographic_obj_id) {
                $this->bibliographic_obj_id = $bibliographic_obj_id;
        }


        public function getBibliographicObjId() {
                return $this->bibliographic_obj_id;
        }


        public function setEntryId($entry_id) {
                $this->entry_id = $entry_id;
        }


        public function getEntryId() {
                return $this->entry_id;
        }


        public function setType($type) {
                $this->type = $type;
        }


        public function getType() {
                return $this->type;
        }


        public function getFileType() {
                return $this->file_type;
        }


        public function setFileType($file_type) {
                $this->file_type = $file_type;
        }


        static function getAllEntries($object_id) {
                global $DIC;
                $ilDB = $DIC['ilDB'];
                $entries = array();
                $set = $ilDB->query("SELECT id FROM il_bibl_entry " . " WHERE data_id = " . $ilDB->quote($object_id, "integer"));
                while ($rec = $ilDB->fetchAssoc($set)) {
                        $entries[]['entry_id'] = $rec['id'];
                }

                return $entries;
        }
}