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

Method getAllSharedPanoramas

lib/Db/ShareMapper.php:95–111  ·  view source on GitHub ↗

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

()

Source from the content-addressed store, hash-verified

93 * @throws Exception
94 */
95 public function getAllSharedPanoramas()
96 {
97 $sql = $this->db->getQueryBuilder();
98 $sql->from(self::TABLE_NAME_PANORAMA, 'PANORAMA')
99 ->rightJoin('PANORAMA', self::TABLE_NAME, 'SHARE', $sql->expr()->eq('PANORAMA.id', 'SHARE.item_source'))
100 ->select('PANORAMA.*')
101 ->selectAlias('SHARE.id', 'shareId')
102 ->selectAlias('SHARE.type', 'shareType')
103 ->selectAlias('SHARE.uid_owner', 'shareUid_owner')
104 ->addSelect('SHARE.permissions')
105 ->where($sql->expr()->eq('SHARE.item_type', $sql->createNamedParameter('panorama')))
106 ->andWhere($sql->expr()->eq('SHARE.uid_initiator', 'PANORAMA.user_id'));
107 $statement = $sql->executeQuery();
108 $result = $statement->fetchAll();
109 $statement->closeCursor();
110 return $result;
111 }
112
113 /**
114 * Create a new share

Callers 1

getSharedItemsMethod · 0.80

Calls 1

eqMethod · 0.80

Tested by

no test coverage detected