public function fetchAll() { $this->buildStart(); $this->build(); $this->buildStat(); $results = array(); while ($data = $this->stat->fetch()) { $userGroup = new UserGroupModel(); $userGroup->setFromDataBaseRow($data); $results[] = $userGroup; } return $results; }
public function loadByIdInSite($id, SiteModel $siteModel) { global $DB; $stat = $DB->prepare("SELECT user_group_information.* FROM user_group_information " . " JOIN user_group_in_site ON user_group_in_site.user_group_id = user_group_information.id " . " AND user_group_in_site.site_id = :site_id AND user_group_in_site.removed_at IS NULL " . " WHERE id = :id"); $stat->execute(array('id' => $id, 'site_id' => $siteModel->getId())); if ($stat->rowCount() > 0) { $ugm = new UserGroupModel(); $ugm->setFromDataBaseRow($stat->fetch()); return $ugm; } }