XmlDbHistory.php

Go to the documentation of this file.

<?php

 
namespace Depage\XmlDb;
 
class XmlDbHistory implements Interfaces\XmlGetter
{
    protected $pdo;
    protected $xmlDb;
    protected $dbNs;
    protected $tableHistory;
 
    protected $docIds = [];
 
    protected $tablePrefix = 'dp_';
    protected $tableDocs;
 
    protected $options;
 
    public $timestamp = null;

    public function __construct($tablePrefix, $pdo, $cache, $options = [])
    {
        $this->pdo = $pdo;
        $this->pdo->setAttribute(\PDO::ATTR_ORACLE_NULLS, \PDO::NULL_NATURAL);
 
        $this->xmlDb = new XmlDb($tablePrefix, $pdo, $cache, $options);
        $this->dbNs = new XmlNs('db', 'http://cms.depagecms.net/ns/database');
 
        $this->tablePrefix = $tablePrefix;
        $this->tableDocs = $tablePrefix . '_xmldocs';
        $this->tableHistory = $tablePrefix . '_history';
    }

    public function docExists($docIdOrName)
    {
        $result = false;
 
        $id = $this->xmlDb->docExists($docIdOrName);
 
        $query = $this->pdo->prepare("
            SELECT doc_id
            FROM {$this->tableHistory}
            WHERE doc_id = :id
            LIMIT 1
        ");
 
        $query->execute([
            'id' => $id,
        ]);
 
        if ($query->fetch()) {
            $result = $id;
        }
 
        return $result;
    }

    public function getDocInfo($docIdOrName)
    {
        return $this->xmlDb->getDocInfo($docIdOrName);
    }

    public function getDocXml($docIdOrName, $addIdAttribute = true)
    {
        $xml = false;
 
        if ($docId = $this->docExists($docIdOrName)) {
            $doc = new Document($this, $docId);
            $history = $doc->getHistory();
 
            if (!is_null($this->timestamp)) {
                $xml = $history->getXml($this->timestamp, $addIdAttribute);
            } else {
                $xml = $history->getLastPublishedXml($addIdAttribute);
            }
        }
 
        return $xml;
    }

    public function getDocXmlXpath($docIdOrName, $xpath, $addIdAttribute = true)
    {
        $xml = false;
 
        if ($docId = $this->docExists($docIdOrName)) {
            $xmlFull = $this->getDocXml($docIdOrName, $addIdAttribute);
            if ($xmlFull === false) {
                throw new \Exception("Document could not be read from history");
            }
 
            $domXpath = new \DomXpath($xmlFull);
            $list = $domXpath->query($xpath);
 
            if ($list->length > 0) {
                $xml = new \Depage\Xml\Document();
                $xml->appendChild($xml->importNode($list->item(0), true));
 
                return $xml;
            }
        }
 
        return $xml;
    }

    public function __get($property)
    {
        if (property_exists($this, $property)) {
            return $this->$property;
        }
    }

    public function __sleep()
    {
        return [
            'pdo',
            'xmlDb',
            'dbNs',
            'tablePrefix',
            'tableDocs',
            'tableHistory',
            'options',
        ];
    }
}
 
/* vim:set ft=php sw=4 sts=4 fdm=marker et : */