* get all shared reports * @return array * @throws Exception */
()
| 67 | * @throws Exception |
| 68 | */ |
| 69 | public function getAllSharedReports() |
| 70 | { |
| 71 | $sql = $this->db->getQueryBuilder(); |
| 72 | $sql->from(self::TABLE_NAME_REPORT, 'REPORT') |
| 73 | ->rightJoin('REPORT', self::TABLE_NAME, 'SHARE', $sql->expr()->eq('REPORT.id', 'SHARE.item_source')) |
| 74 | ->select('REPORT.*') |
| 75 | ->selectAlias('SHARE.id', 'shareId') |
| 76 | ->selectAlias('SHARE.type', 'shareType') |
| 77 | ->selectAlias('SHARE.uid_owner', 'shareUid_owner') |
| 78 | ->addSelect('SHARE.permissions') |
| 79 | ->where($sql->expr()->eq('SHARE.item_type', $sql->createNamedParameter('report'))) |
| 80 | ->andWhere($sql->expr()->eq('SHARE.uid_initiator', 'REPORT.user_id')); |
| 81 | $statement = $sql->executeQuery(); |
| 82 | $result = $statement->fetchAll(); |
| 83 | $statement->closeCursor(); |
| 84 | return $result; |
| 85 | } |
| 86 | |
| 87 | /** |
| 88 | * get all shared panoramas |