/** * @return GroupCategory */ public function getItem($id) { $this->transaction->requestTransaction(); $item = GroupCategory::fetchByProject($this->conn, $id, $this->project); if (false === $item) { $this->transaction->requestRollback(); throw new ItemNotFoundException('The specified item has not been found.', $id); } return $item; }
/** * @param Connection $conn * @param int $projectId * @param int $userId * @return Membership */ public static function fetchMembership(Connection $conn, MembershipRoleResolver $resolver, $slug, $userId) { $data = $conn->fetchAssoc('SELECT g.*, ' . 'm.`role` AS `membership_role`, m.`note` AS `membership_note`, ' . self::createEntityFieldList() . 'FROM `' . CoreTables::GROUP_TBL . '` g ' . self::createEntityJoin('g') . 'INNER JOIN `' . CoreTables::GROUP_MEMBER_TBL . '` m ON m.`groupId` = g.`id` ' . 'WHERE m.`userId` = :userId AND g.`slug` = :slug', [':userId' => $userId, ':slug' => $slug]); if (false === $data) { return false; } $group = self::fromArray($data); $group->project = Project::fetchActive($conn, $data['projectId']); if (false == $group->project) { return false; } if (!empty($data['categoryId'])) { $group->category = GroupCategory::fetchByProject($conn, $data['categoryId'], $group->project); } $group->entity = Entity::fromArray($data, 'entity'); $role = $resolver->getRole('Group', $data['membership_role']); return new Membership($group, $role, $data['membership_note']); }