/**
* @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 GreekOrganization $_org
* @param University $_uni
* @return Chapter
*/
public static function findByOrgAndUni(BasePDO $_pdo, GreekOrganization $_org, University $_uni)
{
$query = "SELECT * FROM chapter WHERE greek_organization_id = :o AND university_id = :u";
$row = $_pdo->fetchOne($query, ["o" => $_org->getId(), "u" => $_uni->getId()]);
if (!$row) {
return null;
}
$temp = new self($_pdo, $row);
$temp->_university = $_uni;
$temp->_greek_organization = $_org;
return $temp;
}
/**
* @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 string $name_link
* @return self
*/
public static function findByNameLink(BasePDO $_pdo, \string $name_link)
{
$query = "SELECT * FROM `user` WHERE name_link = :e OR CONCAT(name_link, name_link_duplicate) = :e";
$row = $_pdo->fetchOne($query, ["e" => $name_link]);
return $row ? new self($_pdo, $row) : null;
}
/**
* @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 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;
}
