/** * @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"); }