class.ilADTMultiDBBridge.php

Go to the documentation of this file.

<?php

require_once "Services/ADT/classes/Bridges/class.ilADTDBBridge.php";

abstract class ilADTMultiDBBridge extends ilADTDBBridge
{
    // CRUD
    
    protected function getSubTableName()
    {
        return $this->getTable() . "_" . $this->getElementId();
    }
    
    public function readRecord(array $a_row)
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
                
        $sql = "SELECT " . $this->getElementId() .
            " FROM " . $this->getSubTableName() .
            " WHERE " . $this->buildPrimaryWhere();
        $set = $ilDB->query($sql);
        
        $this->readMultiRecord($set);
    }
    
    abstract protected function readMultiRecord($a_set);

    public function prepareInsert(array &$a_fields)
    {
        // see afterUpdate()
    }
    
    public function afterInsert()
    {
        $this->afterUpdate();
    }
    
    public function afterUpdate()
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        // :TODO: build diff, save difference
        
        $ilDB->manipulate("DELETE FROM " . $this->getSubTableName() .
            " WHERE " . $this->buildPrimaryWhere());
        
        foreach ($this->prepareMultiInsert() as $sub_items) {
            $fields = array_merge($this->getPrimary(), $sub_items);
            
            $ilDB->insert($this->getSubTableName(), $fields);
        }
    }
        
    abstract protected function prepareMultiInsert();
    
    public function afterDelete()
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $ilDB->manipulate("DELETE FROM " . $this->getSubTableName() .
            " WHERE " . $this->buildPrimaryWhere());
    }
}