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 $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 $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 $ilDB;
                
                $ilDB->manipulate("DELETE FROM ".$this->getSubTableName().
                        " WHERE ".$this->buildPrimaryWhere());          
        }       
}
 
?>