/**
* Returns the connection.
*
* @return flatfile
*/
public static function getConnection()
{
if (!isset(self::$instance)) {
self::$instance = new self();
}
return self::$instance->connection;
}
/**
* Displays the archived realblog topics.
*
* @param mixed $showSearch Whether to show the search form.
*
* @return string (X)HTML.
*/
public function archive($showSearch = false)
{
$realblogID = $this->getPgParameter('realblogID');
$db = Realblog_DB::getConnection();
$html = '';
if (!isset($realblogID)) {
if ($showSearch) {
$view = new Realblog_SearchFormView($this->getYear());
$html .= $view->render();
}
if ($this->getPgParameter('realblog_search')) {
$compArchiveClause = new SimpleWhereClause(REALBLOG_STATUS, '=', 2, INTEGER_COMPARISON);
$compClause = $this->searchClause();
if (isset($compClause)) {
$compClause = new AndWhereClause($compArchiveClause, $compClause);
}
$articles = Realblog_Article::makeArticlesFromRecords($db->selectWhere('realblog.txt', $compClause, -1, array(new OrderBy(REALBLOG_DATE, DESCENDING, INTEGER_COMPARISON), new OrderBy(REALBLOG_ID, DESCENDING, INTEGER_COMPARISON))));
$db_search_records = count($articles);
$html .= $this->renderSearchResults('archive', $db_search_records);
} else {
$articles = Realblog_Article::findArticles(2, DESCENDING);
}
$view = new Realblog_ArchiveView($articles);
$html .= $view->render();
} else {
$html .= $this->renderArticle($realblogID);
}
return $html;
}
/**
* Deletes the article from the database.
*
* @return void
*/
public function delete()
{
$db = Realblog_DB::getConnection();
$db->deleteWhere('realblog.txt', new SimpleWhereClause(REALBLOG_ID, '=', $this->id), INTEGER_COMPARISON);
}
