* get all shared reports by token * uses for public pages * @param $token * @return array * @throws Exception */
($token)
| 47 | * @throws Exception |
| 48 | */ |
| 49 | public function getReportByToken($token) |
| 50 | { |
| 51 | $sql = $this->db->getQueryBuilder(); |
| 52 | $sql->from(self::TABLE_NAME_REPORT, 'DS') |
| 53 | ->leftJoin('DS', self::TABLE_NAME, 'SHARE', $sql->expr()->eq('DS.id', 'SHARE.item_source')) |
| 54 | ->select('DS.*') |
| 55 | ->addSelect('SHARE.permissions') |
| 56 | ->selectAlias('SHARE.domain', 'domain') |
| 57 | ->selectAlias('SHARE.password', 'password') |
| 58 | ->where($sql->expr()->eq('SHARE.token', $sql->createNamedParameter($token))) |
| 59 | ->andWhere($sql->expr()->eq('SHARE.item_type', $sql->createNamedParameter('report'))) |
| 60 | ->andWhere($sql->expr()->eq('SHARE.uid_initiator', 'DS.user_id')); |
| 61 | $statement = $sql->executeQuery(); |
| 62 | $result = $statement->fetch(); |
| 63 | $statement->closeCursor(); |
| 64 | return $result; |
| 65 | } |
| 66 | |
| 67 | /** |
| 68 | * get all shared reports |
no test coverage detected