* Get all Analytics shares * * @return array * @throws Exception */
()
| 114 | * @throws Exception |
| 115 | */ |
| 116 | private function getAllShares(): array { |
| 117 | $sql = $this->db->getQueryBuilder(); |
| 118 | $sql->from(self::TABLE_NAME) |
| 119 | ->select('id', 'type', 'uid_owner', 'uid_initiator', 'permissions', 'item_type', 'item_source', 'token', 'created_at') |
| 120 | ->andWhere($sql->expr()->neq('type', $sql->createNamedParameter(2)))->orderBy('id', 'ASC'); |
| 121 | $statement = $sql->executeQuery(); |
| 122 | $result = $statement->fetchAll(); |
| 123 | $statement->closeCursor(); |
| 124 | return $result; |
| 125 | } |
| 126 | |
| 127 | /** |
| 128 | * Get the name of the report or panorama |