function GetSingleByCondition($table, $condition, $orderBy = null)
{
if ($orderBy != null) {
$orderBy = " ORDER BY " . $orderBy;
}
$model = GetModelByTable($table);
$db = GetDatabaseConnection();
$stmt = $db->prepare('SELECT * FROM ' . $table . ConstructConditionSQL($condition) . $orderBy . " LIMIT 1");
$stmt->execute($condition);
$result = $stmt->fetchAll(PDO::FETCH_CLASS, $model);
if (isset($result[0])) {
return $result[0];
} else {
return false;
}
}
/**
* @param $noteTakerGuid
* @return NoteCollection[]
*/
private function tryAddNoteTaker($noteTakerGuid)
{
$db = GetDatabaseConnection();
$pdo = $db->prepare("SELECT * FROM NoteTakers WHERE NoteTakers.Guid = :NoteTakerGuid");
$pdo->bindValue(":NoteTakerGuid", $noteTakerGuid);
$pdo->execute();
$takers = $pdo->fetchAll(PDO::FETCH_CLASS, GetModelByTable("NoteTakers"));
if (count($takers) == 0) {
$taker = new NoteTaker();
$taker->Guid = $noteTakerGuid;
return Insert("NoteTakers", $taker);
}
return true;
}
