* get single panorama including subpages for user * @param int $id * @return array * @throws Exception */
(int $id)
| 103 | * @throws Exception |
| 104 | */ |
| 105 | public function readOwn(int $id) |
| 106 | { |
| 107 | $sql = $this->db->getQueryBuilder(); |
| 108 | $sql->from(self::TABLE_NAME) |
| 109 | ->select('*') |
| 110 | ->where($sql->expr()->eq('id', $sql->createNamedParameter($id))) |
| 111 | ->andWhere($sql->expr()->eq('user_id', $sql->createNamedParameter($this->userId))) |
| 112 | ->orderBy('name', 'ASC'); |
| 113 | $statement = $sql->executeQuery(); |
| 114 | $result = $statement->fetch(); |
| 115 | $statement->closeCursor(); |
| 116 | |
| 117 | return $result; |
| 118 | } |
| 119 | |
| 120 | /** |
| 121 | * get single report |