<?php
use Kiki\Article;
use Kiki\Album;
$this->title = "Articles";
if (!$user->isAdmin()) {
$this->template = 'pages/admin-required';
return;
}
$this->template = 'pages/admin';
ob_start();
if (isset($_GET['id'])) {
$id = isset($_GET['id']) ? $_GET['id'] : 0;
$article = new Article($id);
$album = new Album($article->albumId());
// Create album for this article if it doesn't exist yet.
if (!$album->id()) {
$album->setSystem(true);
$album->setTitle($article->title());
$album->save();
$article->setAlbumId($album->id());
if ($article->id()) {
$article->save();
}
}
echo $article->form();
if ($album->id()) {
echo $album->form();
}
} else {
echo "<table>\n";
public function exec()
{
$db = Core::getDb();
$user = Core::getUser();
$template = Template::getInstance();
$template->append('stylesheets', \Kiki\Config::$kikiPrefix . "/scripts/prettify/prettify.css");
$q = $db->buildQuery("SELECT id FROM articles a LEFT JOIN objects o ON o.object_id=a.object_id WHERE o.section_id=%d AND ((o.visible=1 AND o.ctime<=now()) OR o.user_id=%d) ORDER BY o.ctime DESC LIMIT 10", $this->instanceId, $user->id());
$articleIds = $db->getObjectIds($q);
$articles = array();
foreach ($articleIds as $articleId) {
$article = new Article($articleId);
$articles[] = array('url' => $article->url(), 'title' => $article->title());
}
$template->assign('latestArticles', $articles);
if (preg_match('/^page-([\\d]+)$/', $this->objectId, $matches) && isset($matches[1])) {
$this->objectId = null;
$currentPage = $matches[1];
}
if (isset($this->objectId) && $this->objectId) {
$matches = array();
if (preg_match('/^socialupdate-([\\d]+)$/', $this->objectId, $matches) && isset($matches[1])) {
$updateId = $matches[1];
$update = new SocialUpdate($updateId);
if (!$update->id()) {
return;
}
$this->status = 200;
$this->title = \Kiki\Misc::textSummary($update->body(), 50);
$this->template = 'pages/default';
$template = new Template('content/socialupdates-single');
$template->assign('update', $update->templateData());
$this->content = $template->fetch();
return;
}
$article = new Article(0, $this->objectId);
if ($article->id() && $article->sectionId() == $this->instanceId && ($article->visible() || $article->userId() == $user->id())) {
$this->status = 200;
$this->title = $article->title();
$this->template = 'pages/default';
$template = new Template('content/articles-single');
$GLOBALS['articleAlbumId'] = $article->albumId();
$template->assign('article', $article->templateData());
$this->content = $template->fetch();
} else {
// $this->template = 'pages/default';
// $template = new Template( 'content/articles-404' );
// $this->content = $template->fetch();
return false;
}
} else {
$section = new \Kiki\Section($this->instanceId);
$itemsPerPage = 25;
if (!isset($currentPage)) {
$currentPage = 1;
}
$this->status = 200;
$this->title = $section->title();
$this->template = 'pages/default';
$this->content = null;
// MultiBanner::articles( $section->id() );
$article = new Article();
$update = new SocialUpdate();
$q = $db->buildQuery("SELECT count(*) FROM objects WHERE type IN ('%s', '%s', '%s', '%s') AND section_id=%d AND ((visible=1 AND ctime<=now()) OR user_id=%d)", 'Article', 'Kiki\\Article', 'SocialUpdate', 'Kiki\\SocialUpdate', $this->instanceId, $user->id());
$totalPosts = $db->getSingleValue($q);
$paging = new \Kiki\Paging();
$paging->setCurrentPage($currentPage);
$paging->setItemsPerPage($itemsPerPage);
$paging->setTotalItems($totalPosts);
$q = $db->buildQuery("SELECT object_id, ctime, type FROM objects WHERE type IN ('%s', '%s', '%s', '%s') AND section_id=%d AND ( (visible=1 AND ctime<=now()) OR user_id=%d) ORDER BY ctime DESC LIMIT %d,%d", 'Article', 'Kiki\\Article', 'SocialUpdate', 'Kiki\\SocialUpdate', $this->instanceId, $user->id(), $paging->firstItem() - 1, $itemsPerPage);
$rs = $db->query($q);
while ($o = $db->fetchObject($rs)) {
switch ($o->type) {
case 'Article':
case 'Kiki\\Article':
$article->reset();
$article->setObjectId($o->object_id);
$article->load();
$template = new Template('content/articles-summary');
$template->assign('article', $article->templateData());
$this->content .= $template->fetch();
break;
case 'SocialUpdate':
case 'Kiki\\SocialUpdate':
$update->reset();
$update->setObjectId($o->object_id);
$update->load();
$template = new Template('content/socialupdates-summary');
$template->assign('update', $update->templateData());
$this->content .= $template->fetch();
break;
default:
}
}
$this->content .= $paging->html();
}
}