/**
* @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 $id
* @return self
*/
public static function find(BasePDO $_pdo, \int $id)
{
$row = $_pdo->fetchOne("SELECT * FROM university WHERE id = :id", ["id" => $id]);
return $row ? new self($_pdo, $row) : null;
}
/**
* @param BasePDO $_pdo
* @param string $token
* @return Remember
*/
public static function findByToken(BasePDO $_pdo, \string $token)
{
$row = $_pdo->fetchOne("SELECT * FROM remember WHERE token = :t", ["t" => $token]);
return $row ? new self($_pdo, $row) : null;
}
/**
* @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 int $id
* @return self
*/
public static function find(BasePDO $_pdo, \int $id)
{
/** @noinspection SqlResolve */
$row = $_pdo->fetchOne("SELECT * FROM `table` WHERE id = :id", ["id" => $id]);
return $row ? new self($_pdo, $row) : null;
}
private static function findByColumn(BasePDO $_pdo, $column, $value) : array
{
return $_pdo->fetchOne("SELECT * FROM guardian WHERE {$column} = :v", ["v" => $value]);
}
/**
* @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
* @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);
});
}
/**
* @param BasePDO $_pdo
* @param FilesystemInterface $_fs
* @param int $id
* @return self
*/
public static function find(BasePDO $_pdo, FilesystemInterface $_fs, \int $id)
{
$row = $_pdo->fetchOne("SELECT * FROM `file` WHERE id = :id", ["id" => $id]);
return $row ? new self($_pdo, $_fs, $row) : null;
}