MCPcopy Create free account
hub / github.com/Rello/analytics / getAllSharedReports

Method getAllSharedReports

lib/Db/ShareMapper.php:72–88  ·  view source on GitHub ↗

* get all shared reports * @return array * @throws Exception */

()

Source from the content-addressed store, hash-verified

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

Callers 1

getSharedItemsMethod · 0.80

Calls 1

eqMethod · 0.80

Tested by

no test coverage detected