class.ilADTMultiEnumDBBridge.php

Go to the documentation of this file.

<?php
 
require_once "Services/ADT/classes/Bridges/class.ilADTMultiDBBridge.php";
 
class ilADTMultiEnumDBBridge extends ilADTMultiDBBridge
{
    protected $fake_single;
    
    const SEPARATOR = "~|~";
    
    protected function isValidADT(ilADT $a_adt)
    {
        return ($a_adt instanceof ilADTMultiEnum);
    }
    
    public function setFakeSingle($a_status)
    {
        $this->fake_single = (bool) $a_status;
    }
    
    protected function doSingleFake()
    {
        return $this->fake_single;
    }
    
    public function readRecord(array $a_row)
    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
        
        if (!$this->doSingleFake()) {
            $sql = "SELECT " . $this->getElementId() .
                " FROM " . $this->getSubTableName() .
                " WHERE " . $this->buildPrimaryWhere();
            $set = $ilDB->query($sql);
 
            $this->readMultiRecord($set);
        } else {
            if (trim($a_row[$this->getElementId()])) {
                $value = explode(self::SEPARATOR, $a_row[$this->getElementId()]);
                array_pop($value);
                array_shift($value);
                $this->getADT()->setSelections($value);
            }
        }
    }
    
    protected function readMultiRecord($a_set)
    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
        
        $elements = array();
        
        while ($row = $ilDB->fetchAssoc($a_set)) {
            $elements[] = $row[$this->getElementId()];
        }
        
        $this->getADT()->setSelections($elements);
    }
    
    public function prepareInsert(array &$a_fields)
    {
        if ($this->doSingleFake()) {
            $values = (array) $this->getADT()->getSelections();
            if (sizeof($values)) {
                $values = self::SEPARATOR . implode(self::SEPARATOR, $values) . self::SEPARATOR;
            }
            $a_fields[$this->getElementId()] = array("text", $values);
        }
    }
    
    protected function prepareMultiInsert()
    {
        $res = array();
        
        $type = ($this->getADT() instanceof ilADTMultiEnumNumeric)
            ? "integer"
            : "text";
        
        foreach ((array) $this->getADT()->getSelections() as $element) {
            $res[] = array($this->getElementId() => array($type, $element));
        }
        
        return $res;
    }
}