public function create(Chapter $_chapter, \string $name) { $this->_chapter = $_chapter; $this->chapter_id = $_chapter->getId(); $this->name = $name; $this->_pdo->perform("INSERT INTO pledge_class (chapter_id, `name`) VALUES (:cid, :n)", ["cid" => $_chapter->getId(), "n" => $name]); $this->id = $this->_pdo->lastInsertId(); }
public function sendSignUpNotificationEmail(Chapter $_chapter) { $this->send(self::$T_SIGN_UP_NOTIFICATION, Config::getDevUser($this->_pdo), ["CHAPTER_ID" => $_chapter->getId(), "NAME" => $_chapter->getGreekOrganization()->getName(), "LETTERS" => $_chapter->getGreekOrganization()->getLetters(), "UNIVERSITY" => $_chapter->getUniversity()->getName()]); }
/** * @param BasePDO $_pdo * @param Chapter $_c * @return User[] */ public static function findAllActiveAssociatesForChapter(BasePDO $_pdo, Chapter $_c) : array { $query = "SELECT * FROM `user` WHERE chapter_id = :c AND is_active = 1 AND is_brother = 0"; return $_pdo->fetchAssoc($query, ["c" => $_c->getId()], function ($row) use($_pdo, $_c) { $tmp = new self($_pdo, $row); $tmp->_chapter = $_c; return $tmp; }); }
/** * @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; }); }
public function queueSignUpNotificationEmail(Chapter $_chapter) { $this->send(self::A_CHAPTER_ANNOUNCEMENT_EMAIL, ["chapter_id" => $_chapter->getId()]); }
/** * @param BasePDO $_pdo * @param Chapter $_chapter * @return Swag[] */ public static function findAllForChapter(BasePDO $_pdo, Chapter $_chapter) : array { $query = "SELECT s.* FROM chapter c\n\t\t\t\t\t\tRIGHT JOIN `user` u ON u.chapter_id = c.id\n\t\t\t\t\t\tRIGHT JOIN swag s ON s.creator_id = u.id\n\t\t\t\t\t WHERE c.id = :cid"; return $_pdo->fetchAssoc($query, ["cid" => $_chapter->getId()], function (array $row) use($_pdo) { return new self($_pdo, $row); }); }