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;
}
}
