1c2f8a3c4SAnna Dabrowska<?php 2c2f8a3c4SAnna Dabrowska 3c2f8a3c4SAnna Dabrowskanamespace dokuwiki\plugin\structpublish\meta; 4c2f8a3c4SAnna Dabrowska 5e394901aSAnna Dabrowskause dokuwiki\plugin\struct\meta\ConfigParser; 6e394901aSAnna Dabrowskause dokuwiki\plugin\struct\meta\Schema; 7e394901aSAnna Dabrowskause dokuwiki\plugin\struct\meta\SearchConfig; 8e394901aSAnna Dabrowskause dokuwiki\plugin\struct\meta\Value; 9e394901aSAnna Dabrowska 108903e50cSAndreas Gohr/** 118903e50cSAndreas Gohr * Object representing a page revision and its properties 128903e50cSAndreas Gohr */ 13c2f8a3c4SAnna Dabrowskaclass Revision 14c2f8a3c4SAnna Dabrowska{ 15e394901aSAnna Dabrowska /** @var \helper_plugin_sqlite */ 16c2f8a3c4SAnna Dabrowska protected $sqlite; 17e7259784SAnna Dabrowska 18e7259784SAnna Dabrowska protected $schema; 19e7259784SAnna Dabrowska 20c2f8a3c4SAnna Dabrowska protected $id; 21c2f8a3c4SAnna Dabrowska protected $rev; 226a791fefSAnna Dabrowska protected $published; 23c2f8a3c4SAnna Dabrowska protected $status; 24e394901aSAnna Dabrowska protected $version; 25c2f8a3c4SAnna Dabrowska protected $user; 26e6dd5f77SAnna Dabrowska protected $datetime; 278903e50cSAndreas Gohr /** @var bool|\dokuwiki\plugin\struct\meta\Column */ 28e7259784SAnna Dabrowska protected $statusCol; 29e7259784SAnna Dabrowska protected $versionCol; 30e7259784SAnna Dabrowska protected $userCol; 31e6dd5f77SAnna Dabrowska protected $datetimeCol; 32e7259784SAnna Dabrowska protected $revisionCol; 33c2f8a3c4SAnna Dabrowska 34c2f8a3c4SAnna Dabrowska /** 358903e50cSAndreas Gohr * Constructor 368903e50cSAndreas Gohr * 378903e50cSAndreas Gohr * @param \helper_plugin_sqlite $sqlite 388903e50cSAndreas Gohr * @param string $id page id 398903e50cSAndreas Gohr * @param int $rev revision 40c2f8a3c4SAnna Dabrowska */ 413449f9ceSAnna Dabrowska public function __construct($sqlite, $id, $rev) 42c2f8a3c4SAnna Dabrowska { 43c2f8a3c4SAnna Dabrowska $this->sqlite = $sqlite; 44c2f8a3c4SAnna Dabrowska $this->id = $id; 45c2f8a3c4SAnna Dabrowska $this->rev = $rev; 466a791fefSAnna Dabrowska $this->published = 0; 47e6dd5f77SAnna Dabrowska $this->status = Constants::STATUS_DRAFT; 48c2f8a3c4SAnna Dabrowska 49e7259784SAnna Dabrowska $this->schema = new Schema('structpublish'); 50e7259784SAnna Dabrowska $this->statusCol = $this->schema->findColumn('status'); 51e7259784SAnna Dabrowska $this->versionCol = $this->schema->findColumn('version'); 52e7259784SAnna Dabrowska $this->userCol = $this->schema->findColumn('user'); 53e6dd5f77SAnna Dabrowska $this->datetimeCol = $this->schema->findColumn('datetime'); 54e7259784SAnna Dabrowska $this->revisionCol = $this->schema->findColumn('revision'); 553449f9ceSAnna Dabrowska 56e394901aSAnna Dabrowska /** @var Value[] $values */ 5751066f27SAnna Dabrowska $values = $this->getCoreData('revision=' . $this->rev); 58e394901aSAnna Dabrowska 59e394901aSAnna Dabrowska if (!empty($values)) { 60e7259784SAnna Dabrowska $this->status = $values[$this->statusCol->getColref() - 1]->getRawValue(); 61e7259784SAnna Dabrowska $this->version = $values[$this->versionCol->getColref() - 1]->getRawValue(); 62e7259784SAnna Dabrowska $this->user = $values[$this->userCol->getColref() - 1]->getRawValue(); 63e6dd5f77SAnna Dabrowska $this->datetime = $values[$this->datetimeCol->getColref() - 1]->getRawValue(); 643449f9ceSAnna Dabrowska } 65c2f8a3c4SAnna Dabrowska } 66c2f8a3c4SAnna Dabrowska 678903e50cSAndreas Gohr /** 688903e50cSAndreas Gohr * Store the currently set structpublish meta data in the database 698903e50cSAndreas Gohr * @return void 708903e50cSAndreas Gohr */ 71c2f8a3c4SAnna Dabrowska public function save() 72c2f8a3c4SAnna Dabrowska { 73e31c94d7SAndreas Gohr if ($this->status === Constants::STATUS_PUBLISHED) { 746a791fefSAnna Dabrowska $this->published = 1; 756a791fefSAnna Dabrowska } 763449f9ceSAnna Dabrowska 77e394901aSAnna Dabrowska $this->updateCoreData($this->id); 786a791fefSAnna Dabrowska // TODO reset publish status of older revisions 79c2f8a3c4SAnna Dabrowska } 80c2f8a3c4SAnna Dabrowska 81c2f8a3c4SAnna Dabrowska /** 828903e50cSAndreas Gohr * Return the version of a published revision 838903e50cSAndreas Gohr * 848903e50cSAndreas Gohr * @return string|null 85c2f8a3c4SAnna Dabrowska */ 86c2f8a3c4SAnna Dabrowska public function getVersion() 87c2f8a3c4SAnna Dabrowska { 888903e50cSAndreas Gohr return $this->version; 89c2f8a3c4SAnna Dabrowska } 90c2f8a3c4SAnna Dabrowska 91c2f8a3c4SAnna Dabrowska /** 928903e50cSAndreas Gohr * Set the version of a published revision 938903e50cSAndreas Gohr * 948903e50cSAndreas Gohr * @param string $version 95c2f8a3c4SAnna Dabrowska */ 968903e50cSAndreas Gohr public function setVersion($version) 97c2f8a3c4SAnna Dabrowska { 98c2f8a3c4SAnna Dabrowska $this->version = $version; 99c2f8a3c4SAnna Dabrowska } 100c2f8a3c4SAnna Dabrowska 101c2f8a3c4SAnna Dabrowska /** 1028903e50cSAndreas Gohr * The revision timestamp 1038903e50cSAndreas Gohr * 1043449f9ceSAnna Dabrowska * @return int 105c2f8a3c4SAnna Dabrowska */ 106c2f8a3c4SAnna Dabrowska public function getRev() 107c2f8a3c4SAnna Dabrowska { 108c2f8a3c4SAnna Dabrowska return $this->rev; 109c2f8a3c4SAnna Dabrowska } 110c2f8a3c4SAnna Dabrowska 111c2f8a3c4SAnna Dabrowska /** 1128903e50cSAndreas Gohr * Get the current status of this revision 1138903e50cSAndreas Gohr * 1143449f9ceSAnna Dabrowska * @return string 115c2f8a3c4SAnna Dabrowska */ 116c2f8a3c4SAnna Dabrowska public function getStatus() 117c2f8a3c4SAnna Dabrowska { 118e394901aSAnna Dabrowska return $this->status; 119c2f8a3c4SAnna Dabrowska } 120c2f8a3c4SAnna Dabrowska 121c2f8a3c4SAnna Dabrowska /** 1228903e50cSAndreas Gohr * Set the current status of this revision 1238903e50cSAndreas Gohr * 1243449f9ceSAnna Dabrowska * @param string $status 125c2f8a3c4SAnna Dabrowska */ 1268903e50cSAndreas Gohr public function setStatus($status) 127c2f8a3c4SAnna Dabrowska { 128c2f8a3c4SAnna Dabrowska $this->status = $status; 129c2f8a3c4SAnna Dabrowska } 130c2f8a3c4SAnna Dabrowska 131c2f8a3c4SAnna Dabrowska /** 1328903e50cSAndreas Gohr * Get the user that changed the status of this revision 1338903e50cSAndreas Gohr * 1348903e50cSAndreas Gohr * Not available for drafts 1358903e50cSAndreas Gohr * 1368903e50cSAndreas Gohr * @return string|null 137c2f8a3c4SAnna Dabrowska */ 138c2f8a3c4SAnna Dabrowska public function getUser() 139c2f8a3c4SAnna Dabrowska { 140c2f8a3c4SAnna Dabrowska return $this->user; 141c2f8a3c4SAnna Dabrowska } 142c2f8a3c4SAnna Dabrowska 143c2f8a3c4SAnna Dabrowska /** 1448903e50cSAndreas Gohr * Set the user that changed the revision status 1458903e50cSAndreas Gohr * 1463449f9ceSAnna Dabrowska * @param string $user 147c2f8a3c4SAnna Dabrowska */ 148c2f8a3c4SAnna Dabrowska public function setUser($user): void 149c2f8a3c4SAnna Dabrowska { 150c2f8a3c4SAnna Dabrowska $this->user = $user; 151c2f8a3c4SAnna Dabrowska } 1523449f9ceSAnna Dabrowska 1538903e50cSAndreas Gohr /** 1548903e50cSAndreas Gohr * The datetime when the status of this revision was changed 1558903e50cSAndreas Gohr * 1568903e50cSAndreas Gohr * Uses ISO Format. Not available for drafts 1578903e50cSAndreas Gohr * 1588903e50cSAndreas Gohr * @return string|null 1598903e50cSAndreas Gohr */ 160e6dd5f77SAnna Dabrowska public function getDatetime() 161e394901aSAnna Dabrowska { 162e6dd5f77SAnna Dabrowska return $this->datetime; 163e394901aSAnna Dabrowska } 164e394901aSAnna Dabrowska 1658903e50cSAndreas Gohr /** 1668903e50cSAndreas Gohr * The timestamp of when the status of this revision was changed 1678903e50cSAndreas Gohr * 1688903e50cSAndreas Gohr * Not available for drafts 1698903e50cSAndreas Gohr * 1708903e50cSAndreas Gohr * @return int|null 1718903e50cSAndreas Gohr */ 1725c2215e8SAndreas Gohr public function getTimestamp() 1735c2215e8SAndreas Gohr { 1748903e50cSAndreas Gohr if ($this->datetime === null) { 1758903e50cSAndreas Gohr return null; 1768903e50cSAndreas Gohr } 1775c2215e8SAndreas Gohr return strtotime($this->datetime); 1785c2215e8SAndreas Gohr } 1795c2215e8SAndreas Gohr 1808903e50cSAndreas Gohr /** 1818903e50cSAndreas Gohr * Set the datetime when the status of this revision was changed 1828903e50cSAndreas Gohr * 1838903e50cSAndreas Gohr * Uses ISO Format 1848903e50cSAndreas Gohr * 1858903e50cSAndreas Gohr * @param string $time 1868903e50cSAndreas Gohr */ 187e6dd5f77SAnna Dabrowska public function setDatetime($time) 188e394901aSAnna Dabrowska { 1895c2215e8SAndreas Gohr $this->datetime = $time; 1905c2215e8SAndreas Gohr } 1915c2215e8SAndreas Gohr 1928903e50cSAndreas Gohr /** 193*22101782SAndreas Gohr * Set the timestamp of when the status of this revision was changed 194*22101782SAndreas Gohr */ 195*22101782SAndreas Gohr public function setTimestamp($timestamp) 196*22101782SAndreas Gohr { 197*22101782SAndreas Gohr $this->datetime = date('Y-m-d\TH:i', $timestamp); 198*22101782SAndreas Gohr } 199*22101782SAndreas Gohr 200*22101782SAndreas Gohr /** 2018903e50cSAndreas Gohr * The page ID this revision is for 2028903e50cSAndreas Gohr * @return string 2038903e50cSAndreas Gohr */ 2045c2215e8SAndreas Gohr public function getId() 2055c2215e8SAndreas Gohr { 2065c2215e8SAndreas Gohr return $this->id; 207e394901aSAnna Dabrowska } 208e394901aSAnna Dabrowska 2093449f9ceSAnna Dabrowska /** 2103449f9ceSAnna Dabrowska * Update publish status in the core table 2118903e50cSAndreas Gohr * 2128903e50cSAndreas Gohr * @param string $pid 2138903e50cSAndreas Gohr * @param int $rid 2143449f9ceSAnna Dabrowska */ 215e394901aSAnna Dabrowska protected function updateCoreData($pid, $rid = 0) 2163449f9ceSAnna Dabrowska { 217e394901aSAnna Dabrowska $data = [ 218e394901aSAnna Dabrowska 'status' => $this->status, 219e394901aSAnna Dabrowska 'user' => $this->user, 2205c2215e8SAndreas Gohr 'datetime' => $this->datetime, 221e394901aSAnna Dabrowska 'revision' => $this->rev, 222e394901aSAnna Dabrowska 'version' => $this->version, 223e394901aSAnna Dabrowska ]; 2243231ebaeSAnna Dabrowska $schema = new Schema('structpublish', 0); 2253231ebaeSAnna Dabrowska $access = new AccessTableStructpublish($schema, $pid, 0, $rid); 2266a791fefSAnna Dabrowska $access->setPublished($this->published); 227e394901aSAnna Dabrowska $access->saveData($data); 228e394901aSAnna Dabrowska } 229e394901aSAnna Dabrowska 2308903e50cSAndreas Gohr /** 2318903e50cSAndreas Gohr * @param string $andFilter 2328903e50cSAndreas Gohr * @return array|Value[] 2338903e50cSAndreas Gohr * @fixme fix fixme, update doc block 2348903e50cSAndreas Gohr */ 235e7259784SAnna Dabrowska public function getCoreData($andFilter = '') 236e394901aSAnna Dabrowska { 237e394901aSAnna Dabrowska $lines = [ 238e394901aSAnna Dabrowska 'schema: structpublish', 239e394901aSAnna Dabrowska 'cols: *', 240e394901aSAnna Dabrowska 'filter: %pageid% = $ID$' 241e394901aSAnna Dabrowska ]; 242e7259784SAnna Dabrowska 243e7259784SAnna Dabrowska if ($andFilter) { 244e7259784SAnna Dabrowska $lines[] = 'filter: ' . $andFilter; 245e7259784SAnna Dabrowska } 246e7259784SAnna Dabrowska 247e394901aSAnna Dabrowska $parser = new ConfigParser($lines); 248e394901aSAnna Dabrowska $config = $parser->getConfig(); 24940f4519bSAnna Dabrowska $search = new SearchConfig($config, $this->sqlite); 250e394901aSAnna Dabrowska $data = $search->execute(); 251e394901aSAnna Dabrowska if (!empty($data)) { 25251066f27SAnna Dabrowska // FIXME 253e394901aSAnna Dabrowska return $data[array_key_last($data)]; 254e394901aSAnna Dabrowska } 255e394901aSAnna Dabrowska return []; 2563449f9ceSAnna Dabrowska } 257e7259784SAnna Dabrowska 2588d2065f7SAnna Dabrowska /** 2590dcf68caSAnna Dabrowska * Return "latest" published revision of a given page. 2600dcf68caSAnna Dabrowska * If $rev is specified, "latest" means relative to the $rev revision. 2618d2065f7SAnna Dabrowska * 2620dcf68caSAnna Dabrowska * @param int|null $rev 263ecad4fdbSAnna Dabrowska * @return Revision|null 2648d2065f7SAnna Dabrowska */ 2650dcf68caSAnna Dabrowska public function getLatestPublishedRevision($rev = null) 266e7259784SAnna Dabrowska { 2670dcf68caSAnna Dabrowska $andFilter = 'status=' . Constants::STATUS_PUBLISHED; 2680dcf68caSAnna Dabrowska if ($rev) { 2690dcf68caSAnna Dabrowska $andFilter .= ' AND revision < ' . $rev; 2700dcf68caSAnna Dabrowska } 2710dcf68caSAnna Dabrowska $latestPublished = $this->getCoreData($andFilter); 272d00ea115SAnna Dabrowska 273ecad4fdbSAnna Dabrowska if (empty($latestPublished)) { 274ecad4fdbSAnna Dabrowska return null; 275ecad4fdbSAnna Dabrowska } 276ecad4fdbSAnna Dabrowska 2778903e50cSAndreas Gohr $published = new Revision($this->sqlite, $this->id, 2788903e50cSAndreas Gohr $latestPublished[$this->revisionCol->getColref() - 1]->getRawValue()); 279ecad4fdbSAnna Dabrowska 2800dcf68caSAnna Dabrowska $published->setStatus($latestPublished[$this->statusCol->getColref() - 1]->getRawValue()); 2810dcf68caSAnna Dabrowska $published->setUser($latestPublished[$this->userCol->getColref() - 1]->getRawValue()); 282e6dd5f77SAnna Dabrowska $published->setDatetime($latestPublished[$this->datetimeCol->getColref() - 1]->getRawValue()); 2830dcf68caSAnna Dabrowska $published->setVersion($latestPublished[$this->versionCol->getColref() - 1]->getRawValue()); 284e7259784SAnna Dabrowska 2850dcf68caSAnna Dabrowska return $published; 286e7259784SAnna Dabrowska } 287c2f8a3c4SAnna Dabrowska} 288