/** * @param BasePDO $_pdo * @param FilesystemInterface $_fs * @param Event $_e * @return File[] */ public static function findForEvent(BasePDO $_pdo, FilesystemInterface $_fs, Event $_e) : array { $query = "SELECT f.*\n\t\t\t\t\t FROM `file` f RIGHT JOIN rel_file_event rfe ON f.id = rfe.file_id\n\t\t\t\t\t WHERE rfe.event_id = :eid"; return $_pdo->fetchAssoc($query, ["eid" => $_e->getId()], function ($row) use($_pdo, $_fs) { return new File($_pdo, $_fs, $row); }); }
/** * @param BasePDO $_pdo * @param string $search * @return self[] */ public static function search(BasePDO $_pdo, \string $search) : array { $query = "SELECT * FROM greek_organization WHERE `name` LIKE :s"; return $_pdo->fetchAssoc($query, ["s" => "%" . $_pdo->quote($search) . "%"], function ($row) use($_pdo) { return new self($_pdo, $row); }); }
/** * @param BasePDO $_pdo * @param GreekOrganization $_org * @return array[] */ public static function findAllForGreekOrganizationAsArray(BasePDO $_pdo, GreekOrganization $_org) : array { return $_pdo->fetchAssoc("SELECT * FROM chapter WHERE greek_organization_id = :id", ["id" => $_org->getId()]); }
/** * @param BasePDO $_pdo * @param int $big_id * @return User[] */ public static function findAllWithBigBrother(BasePDO $_pdo, \int $big_id) : array { $query = "SELECT * FROM `user` WHERE big_brother_id = :bid"; return $_pdo->fetchAssoc($query, ["bid" => $big_id], function ($row) use($_pdo) { return new self($_pdo, $row); }); }
/** * @param BasePDO $_pdo * @param User $_user * @return self[] */ public static function findAllForUser(BasePDO $_pdo, User $_user) : array { return $_pdo->fetchAssoc("SELECT * FROM fee WHERE user_id = :u", ["u" => $_user->getId()], function ($row) use($_pdo) { return new self($_pdo, $row); }); }
/** * @param BasePDO $_pdo * @param Group $_group * @return self[] */ public static function findAllForGroup(BasePDO $_pdo, Group $_group) : array { return $_pdo->fetchAssoc("SELECT * FROM `event` WHERE group_id = :id", ["id" => $_group->getId()], function ($row) use($_pdo, $_group) { $row = new self($_pdo, $row); $row->_group = $_group; return $row; }); }
/** * @param BasePDO $_pdo * @param User $_user * @return Swag[] */ public static function findAllByCreator(BasePDO $_pdo, User $_user) : array { return $_pdo->fetchAssoc("SELECT * FROM swag WHERE creator_id = :uid", ["uid" => $_user->getId()], function (array $row) use($_pdo) { return new self($_pdo, $row); }); }