jenskooij /
cloudcontrol
@@ -18,87 +18,87 @@ |
||
| 18 | 18 | */ |
| 19 | 19 | class Document |
| 20 | 20 | { |
| 21 | - public $id; |
|
| 22 | - public $path; |
|
| 23 | - public $title; |
|
| 24 | - public $slug; |
|
| 25 | - public $type; |
|
| 26 | - public $documentType; |
|
| 27 | - public $documentTypeSlug; |
|
| 28 | - public $state; |
|
| 29 | - public $lastModificationDate; |
|
| 30 | - public $creationDate; |
|
| 31 | - public $lastModifiedBy; |
|
| 32 | - protected $fields; |
|
| 33 | - protected $bricks; |
|
| 34 | - protected $dynamicBricks; |
|
| 35 | - protected $content; |
|
| 21 | + public $id; |
|
| 22 | + public $path; |
|
| 23 | + public $title; |
|
| 24 | + public $slug; |
|
| 25 | + public $type; |
|
| 26 | + public $documentType; |
|
| 27 | + public $documentTypeSlug; |
|
| 28 | + public $state; |
|
| 29 | + public $lastModificationDate; |
|
| 30 | + public $creationDate; |
|
| 31 | + public $lastModifiedBy; |
|
| 32 | + protected $fields; |
|
| 33 | + protected $bricks; |
|
| 34 | + protected $dynamicBricks; |
|
| 35 | + protected $content; |
|
| 36 | 36 | |
| 37 | - protected $dbHandle; |
|
| 37 | + protected $dbHandle; |
|
| 38 | 38 | |
| 39 | - protected $jsonEncodedFields = array('fields', 'bricks', 'dynamicBricks'); |
|
| 39 | + protected $jsonEncodedFields = array('fields', 'bricks', 'dynamicBricks'); |
|
| 40 | 40 | |
| 41 | - public function __get($name) { |
|
| 42 | - if (in_array($name, $this->jsonEncodedFields)) { |
|
| 43 | - if (is_string($this->$name)) { |
|
| 44 | - return json_decode($this->$name); |
|
| 45 | - } else { |
|
| 46 | - return $this->$name; |
|
| 47 | - } |
|
| 48 | - } elseif ($name === 'content') { |
|
| 49 | - if ($this->dbHandle === null) { |
|
| 50 | - throw new \Exception('Document doesnt have a dbHandle handle. (path: ' . $this->path . ')'); |
|
| 51 | - } else { |
|
| 52 | - if ($this->content === null) { |
|
| 53 | - $this->getContent(); |
|
| 54 | - } |
|
| 55 | - return $this->content; |
|
| 56 | - } |
|
| 57 | - } elseif ($name === 'dbHandle') { |
|
| 58 | - throw new \Exception('Trying to get protected property repository.'); |
|
| 59 | - } |
|
| 60 | - return $this->$name; |
|
| 61 | - } |
|
| 41 | + public function __get($name) { |
|
| 42 | + if (in_array($name, $this->jsonEncodedFields)) { |
|
| 43 | + if (is_string($this->$name)) { |
|
| 44 | + return json_decode($this->$name); |
|
| 45 | + } else { |
|
| 46 | + return $this->$name; |
|
| 47 | + } |
|
| 48 | + } elseif ($name === 'content') { |
|
| 49 | + if ($this->dbHandle === null) { |
|
| 50 | + throw new \Exception('Document doesnt have a dbHandle handle. (path: ' . $this->path . ')'); |
|
| 51 | + } else { |
|
| 52 | + if ($this->content === null) { |
|
| 53 | + $this->getContent(); |
|
| 54 | + } |
|
| 55 | + return $this->content; |
|
| 56 | + } |
|
| 57 | + } elseif ($name === 'dbHandle') { |
|
| 58 | + throw new \Exception('Trying to get protected property repository.'); |
|
| 59 | + } |
|
| 60 | + return $this->$name; |
|
| 61 | + } |
|
| 62 | 62 | |
| 63 | - public function __set($name, $value) { |
|
| 64 | - if (in_array($name, $this->jsonEncodedFields)) { |
|
| 65 | - $this->$name = json_encode($value); |
|
| 66 | - } elseif ($name === 'content') { |
|
| 67 | - // Dont do anything for now.. |
|
| 68 | - return; |
|
| 69 | - } |
|
| 63 | + public function __set($name, $value) { |
|
| 64 | + if (in_array($name, $this->jsonEncodedFields)) { |
|
| 65 | + $this->$name = json_encode($value); |
|
| 66 | + } elseif ($name === 'content') { |
|
| 67 | + // Dont do anything for now.. |
|
| 68 | + return; |
|
| 69 | + } |
|
| 70 | 70 | |
| 71 | - $this->$name = $value; |
|
| 72 | - } |
|
| 71 | + $this->$name = $value; |
|
| 72 | + } |
|
| 73 | 73 | |
| 74 | - /** |
|
| 75 | - * @throws \Exception |
|
| 76 | - */ |
|
| 77 | - protected function getContent() |
|
| 78 | - { |
|
| 79 | - $folderPathWithWildcard = $this->path . '%'; |
|
| 80 | - $sql = ' SELECT * |
|
| 74 | + /** |
|
| 75 | + * @throws \Exception |
|
| 76 | + */ |
|
| 77 | + protected function getContent() |
|
| 78 | + { |
|
| 79 | + $folderPathWithWildcard = $this->path . '%'; |
|
| 80 | + $sql = ' SELECT * |
|
| 81 | 81 | FROM documents |
| 82 | 82 | WHERE `path` LIKE ' . $this->dbHandle->quote($folderPathWithWildcard) . ' |
| 83 | 83 | AND substr(`path`, ' . (strlen($this->path) + 2) . ') NOT LIKE "%/%" |
| 84 | 84 | AND substr(`path`, ' . (strlen($this->path) + 1) . ', 1) = "/" |
| 85 | 85 | AND path != ' . $this->dbHandle->quote($this->path) . ' |
| 86 | 86 | '; |
| 87 | - $stmt = $this->dbHandle->query($sql); |
|
| 88 | - if ($stmt === false) { |
|
| 89 | - $errorInfo = $this->dbHandle->errorInfo(); |
|
| 90 | - $errorMsg = $errorInfo[2]; |
|
| 91 | - throw new \Exception('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>'); |
|
| 92 | - } |
|
| 93 | - $contents = $stmt->fetchAll(\PDO::FETCH_CLASS, '\library\storage\Document'); |
|
| 94 | - foreach ($contents as $key => $document) { |
|
| 95 | - if ($document->type === 'folder') { |
|
| 96 | - $document->dbHandle = $this->dbHandle; |
|
| 97 | - $contents[$key] = $document; |
|
| 98 | - } |
|
| 99 | - } |
|
| 100 | - $this->content = $contents; |
|
| 101 | - } |
|
| 87 | + $stmt = $this->dbHandle->query($sql); |
|
| 88 | + if ($stmt === false) { |
|
| 89 | + $errorInfo = $this->dbHandle->errorInfo(); |
|
| 90 | + $errorMsg = $errorInfo[2]; |
|
| 91 | + throw new \Exception('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>'); |
|
| 92 | + } |
|
| 93 | + $contents = $stmt->fetchAll(\PDO::FETCH_CLASS, '\library\storage\Document'); |
|
| 94 | + foreach ($contents as $key => $document) { |
|
| 95 | + if ($document->type === 'folder') { |
|
| 96 | + $document->dbHandle = $this->dbHandle; |
|
| 97 | + $contents[$key] = $document; |
|
| 98 | + } |
|
| 99 | + } |
|
| 100 | + $this->content = $contents; |
|
| 101 | + } |
|
| 102 | 102 | |
| 103 | 103 | /** |
| 104 | 104 | * @return string |
