class.ilADTInternalLinkSearchBridgeSingle.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilADTInternalLinkSearchBridgeSingle extends ilADTSearchBridgeSingle
{
    const SQL_STRICT = 1;
    const SQL_LIKE = 2;
    const SQL_LIKE_END = 3;
    const SQL_LIKE_START = 4;
 
    private $title_query = '';
 
    protected function isValidADTDefinition(\ilADTDefinition $a_adt_def)
    {
        return $a_adt_def instanceof ilADTInternalLinkDefinition;
    }
 
 
    /*
     * Add search property to form
     */
    public function addToForm()
    {
        $title = new ilTextInputGUI($this->getTitle(), $this->getElementId());
        $title->setSize(255);
        $this->addToParentElement($title);
    }
 
    public function setTitleQuery(string $query) : void
    {
        $this->title_query = $query;
    }
 
    public function getTitleQuery() : string
    {
        return $this->title_query;
    }
 
    public function loadFilter()
    {
        $value = $this->readFilter();
        if ($value !== null) {
            $this->getADT()->setTargetRefId(1);
            $this->setTitleQuery($value);
        }
    }
 
    public function importFromPost(array $a_post = null)
    {
        $post = $this->extractPostValues($a_post);
 
        if ($post && $this->shouldBeImportedFromPost($post)) {
            if ($this->getForm() instanceof ilPropertyFormGUI) {
                $item = $this->getForm()->getItemByPostVar($this->getElementId());
                $item->setValue($post);
                $this->setTitleQuery($post);
                $this->getADT()->setTargetRefId(1);
            } elseif (array_key_exists($this->getElementId(), $this->table_filter_fields)) {
                $this->table_filter_fields[$this->getElementId()]->setValue($post);
                $this->writeFilter($post);
                $this->setTitleQuery($post);
                $this->getADT()->setTargetRefId(1);
            }
        } else {
            $this->writeFilter();
            $this->setTitleQuery('');
            $this->getADT()->setTargetRefId(null);
        }
        return true;
    }
 
    public function getSQLCondition($a_element_id, $a_mode = self::SQL_LIKE, $a_value = null)
    {
        $db = $GLOBALS['DIC']->database();
        
        if (!$a_value) {
            if ($this->isNull() || !$this->isValid()) {
                return;
            }
            $a_value = $this->getADT()->getTargetRefId();
        }
        
        $subselect = $a_element_id . ' IN ' .
            '( select ref_id from object_reference obr join object_data obd on obr.obj_id = obd.obj_id ' .
            'where ' . $db->like('title', 'text', $a_value . '%') . ' ' .
            ')';
        return $subselect;
    }
 
    public function isInCondition(ilADT $a_adt)
    {
        if ($this->getADT()->getCopyOfDefinition()->isComparableTo($a_adt)) {
            $ref_id = $a_adt->getTargetRefId();
            $title = ilObject::_lookupTitle((int) ilObject::_lookupObjId($ref_id));
            return strcasecmp($title, $this->getTitleQuery()) === 0;
        }
        return false;
    }
 
    public function getSerializedValue()
    {
        if (!$this->isNull() && $this->isValid()) {
            return serialize(array($this->getADT()->getTargetRefId()));
        }
    }
 
    public function setSerializedValue($a_value)
    {
        $a_value = unserialize($a_value);
        if (is_array($a_value)) {
            $this->getADT()->setTargetRefId($a_value[0]);
        }
    }
}