xref: /plugin/structpublish/meta/Revision.php (revision 22101782b1ef713771c3abb5494f1f67e45d7826)
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