/**
* @param BasePDO $_pdo
* @param Chapter $_chapter
* @return self[]
*/
public static function findAllForChapter(BasePDO $_pdo, Chapter $_chapter) : array
{
$query = "SELECT e.* FROM `event` e LEFT JOIN `user` u ON u.id = e.creator_id WHERE u.chapter_id = :cid";
return $_pdo->fetchAll($query, ["cid" => $_chapter->getId()], function ($row) use($_pdo, $_chapter) {
$row = new self($_pdo, $row);
$row->_group = $_chapter;
return $row;
});
}
/**
* @param BasePDO $_pdo
* @return array[]
*/
public static function allAsArray(BasePDO $_pdo) : array
{
return $_pdo->fetchAll("SELECT * FROM greek_organization");
}
