Get the topics for the given article.
require_once($GLOBALS['g_campsiteDir']."/$ADMIN_DIR/articles/topics/topic_common.php");
require_once($GLOBALS['g_campsiteDir'].'/classes/Topic.php');
require_once($GLOBALS['g_campsiteDir'].'/classes/Log.php');
require_once($GLOBALS['g_campsiteDir'].'/classes/DbObjectArray.php');
require_once($GLOBALS['g_campsiteDir'].'/classes/ArticleTopic.php');
if (!SecurityToken::isValid()) {
camp_html_display_error(getGS('Invalid security token!'));
exit;
}
$f_language_selected = Input::Get('f_language_selected', 'int', 0);
$f_article_number = Input::Get('f_article_number', 'int', 0);
$f_topic_ids = Input::Get('f_topic_ids', 'array', array(), true);
$articleTopics = ArticleTopic::GetArticleTopics($f_article_number);
if (!Input::IsValid()) {
camp_html_display_error(getGS('Invalid input: $1', Input::GetErrorString()), null, true);
exit;
}
if (!$g_user->hasPermission('AttachTopicToArticle')) {
camp_html_display_error(getGS("You do not have the right to detach topics from articles."), null, true);
exit;
}
// delete
foreach ($articleTopics as $topic) {
if (!in_array($topic->getTopicId(), $f_topic_ids)) {
ArticleTopic::RemoveTopicFromArticle($topic->getTopicId(), $f_article_number);
public function has_topic($p_topicName) {
$topic = new Topic($p_topicName);
if (!$topic->exists()) {
$this->trigger_invalid_value_error('has_topic', $p_topicName);
return null;
}
$articleTopics = $this->getContentCache('article_topics');
if (is_null($articleTopics)) {
$articleTopics = ArticleTopic::GetArticleTopics($this->m_dbObject->getArticleNumber());
$this->setContentCache('article_topics', $articleTopics);
}
foreach ($articleTopics as $articleTopic) {
if ($articleTopic->getTopicId() == $topic->getTopicId()) {
return (int)true;
}
}
return (int)false;
}
public function getSEOURLEnd(array $seoFields, $languageId)
{
$urlEnd = '';
foreach ($seoFields as $field => $value) {
switch ($field) {
case 'name':
if ($text = trim($this->getName())) {
$urlEnd .= $urlEnd ? '-' . $text : $text;
}
break;
case 'keywords':
if ($text = trim($this->getKeywords())) {
$urlEnd .= $urlEnd ? '-' . $text : $text;
}
break;
case 'topics':
$articleTopics = ArticleTopic::GetArticleTopics($this->getArticleNumber());
foreach ($articleTopics as $topic) {
$urlEnd .= $urlEnd ? '-' . $topic->getName($languageId) : $topic->getName($languageId);
}
break;
}
}
$urlEnd = preg_replace('/[\\\\,\\/\\.\\?"\\+&%:#]/', '', trim($urlEnd));
$urlEnd = str_replace(' ', '-', $urlEnd) . '.htm';
return $urlEnd;
}
/**
* Process item
* @param Article $article
* @return array
*/
public function processItem($article)
{
global $g_user, $Campsite;
$translator = \Zend_Registry::get('container')->getService('translator');
$editorService = \Zend_Registry::get('container')->getService('newscoop.editor');
$articleLink = $editorService->getLink($article);
$articleLinkParams = $editorService->getLinkParameters($article);
$articleLinkParamsTranslate = $articleLinkParams . '&f_action=translate&f_action_workflow=' . $article->getWorkflowStatus() . '&f_article_code=' . $article->getArticleNumber() . '_' . $article->getLanguageId();
$previewLink = $Campsite['WEBSITE_URL'] . '/admin/articles/preview.php' . $editorService->getLinkParameters($article);
$htmlPreviewLink = '<a href="' . $previewLink . '" target="_blank" title="' . $translator->trans('Preview') . '">' . $translator->trans('Preview') . '</a>';
$translateLink = $Campsite['WEBSITE_URL'] . '/admin/articles/translate.php' . $articleLinkParamsTranslate;
$htmlTranslateLink = '<a href="' . $translateLink . '" target="_blank" title="' . $translator->trans('Translate') . '">' . $translator->trans('Translate') . '</a>';
$lockInfo = '';
$lockHighlight = false;
$timeDiff = camp_time_diff_str($article->getLockTime());
if ($article->isLocked() && $timeDiff['days'] <= 0) {
$lockUser = new User($article->getLockedByUser());
if ($timeDiff['hours'] > 0) {
$lockInfo = $translator->trans('The article has been locked by $1 ($2) $3 hour(s) and $4 minute(s) ago.', array('$1' => htmlspecialchars($lockUser->getRealName()), '$2' => htmlspecialchars($lockUser->getUserName()), '$3' => $timeDiff['hours'], '$4' => $timeDiff['minutes']), 'articles');
} else {
$lockInfo = $translator->trans('The article has been locked by $1 ($2) $3 minute(s) ago.', array('$1' => htmlspecialchars($lockUser->getRealName()), '$2' => htmlspecialchars($lockUser->getUserName()), '$3' => $timeDiff['minutes']), 'articles');
}
if ($article->getLockedByUser() != $g_user->getUserId()) {
$lockHighlight = true;
}
}
$tmpUser = new User($article->getCreatorId());
$tmpArticleType = new ArticleType($article->getType());
$tmpAuthor = new Author();
$articleAuthors = ArticleAuthor::GetAuthorsByArticle($article->getArticleNumber(), $article->getLanguageId());
foreach ((array) $articleAuthors as $author) {
if (strtolower($author->getAuthorType()->getName()) == 'author') {
$tmpAuthor = $author;
break;
}
}
if (!$tmpAuthor->exists() && isset($articleAuthors[0])) {
$tmpAuthor = $articleAuthors[0];
}
$onFrontPage = $article->onFrontPage() ? $translator->trans('Yes') : $translator->trans('No');
$onSectionPage = $article->onSectionPage() ? $translator->trans('Yes') : $translator->trans('No');
$imagesNo = (int) ArticleImage::GetImagesByArticleNumber($article->getArticleNumber(), true);
$topicsNo = (int) ArticleTopic::GetArticleTopics($article->getArticleNumber(), true);
$commentsNo = '';
if ($article->commentsEnabled()) {
global $controller;
$repositoryComments = $controller->getHelper('entity')->getRepository('Newscoop\\Entity\\Comment');
$filter = array('thread' => $article->getArticleNumber(), 'language' => $article->getLanguageId());
$params = array('sFilter' => $filter);
$commentsNo = $repositoryComments->getCount($params);
} else {
$commentsNo = 'No';
}
// get language code
$language = new Language($article->getLanguageId());
return array($article->getArticleNumber(), $article->getLanguageId(), $article->getOrder(), sprintf('%s <a href="%s" title="%s %s">%s</a>', $article->isLocked() ? '<span class="ui-icon ui-icon-locked' . (!$lockHighlight ? ' current-user' : '') . '" title="' . $lockInfo . '"></span>' : '', $articleLink, $translator->trans('Edit'), htmlspecialchars($article->getName() . " ({$article->getLanguageName()})"), htmlspecialchars($article->getName() . (empty($_REQUEST['language']) ? " ({$language->getCode()})" : ''))), htmlspecialchars($article->getSection()->getName()), $article->getWebcode(), htmlspecialchars($tmpArticleType->getDisplayName()), htmlspecialchars($tmpUser->getRealName()), htmlspecialchars($tmpAuthor->getName()), $article->getWorkflowStatus(), $onFrontPage, $onSectionPage, $imagesNo, $topicsNo, $commentsNo, (int) $article->getReads(), Geo_Map::GetArticleMapId($article) != null ? $translator->trans('Yes') : $translator->trans('No'), (int) sizeof(Geo_Map::GetLocationsByArticle($article)), $article->getCreationDate(), $article->getPublishDate(), $article->getLastModified(), $htmlPreviewLink, $htmlTranslateLink);
}
/**
* Get seo string
*
* @param object $article
* @param array $fields
* @return string
*/
public function getSeo($article, array $fields)
{
$seo = array();
foreach ($fields as $field => $value) {
switch ($field) {
case 'name':
$seo[] = trim($article->getName());
break;
case 'keywords':
$seo[] = trim($article->getKeywords());
break;
case 'topics':
$articleTopics = \ArticleTopic::GetArticleTopics($article->getNumber());
if (is_array($articleTopics)) {
foreach ($articleTopics as $topic) {
$seo[] = trim($topic->getName($article->getLanguageId()));
}
}
break;
}
}
$seo = trim(implode('-', array_filter($seo)), '-');
$seo = preg_replace('/[\\\\,\\/\\.\\?"\\+&%:#]/', '', $seo);
if (strlen($seo) > 0) {
$seo = str_replace(' ', '-', $seo) . '.htm';
}
return $this->encode($seo);
}
public function has_topic($p_topicName)
{
$cacheService = \Zend_Registry::get('container')->getService('newscoop.cache');
$cacheKey = $cacheService->getCacheKey(array('has_topic', $this->m_dbObject->getArticleNumber(), $p_topicName), 'article');
if ($cacheService->contains($cacheKey)) {
$exists = $cacheService->fetch($cacheKey);
} else {
$exists = (int) false;
$em = \Zend_Registry::get('container')->getService('em');
$repository = $em->getRepository('Newscoop\\NewscoopBundle\\Entity\\Topic');
$context = CampTemplate::singleton()->context();
$locale = $context->language->code;
$topic = $repository->getTopicByIdOrName($p_topicName, $locale)->getOneOrNullResult();
if (!$topic) {
$this->trigger_invalid_value_error('has_topic', $p_topicName);
return null;
}
$articleTopics = ArticleTopic::GetArticleTopics($this->m_dbObject->getArticleNumber());
foreach ($articleTopics as $articleTopic) {
if ($articleTopic->getTopicId() == $topic->getTopicId()) {
$exists = (int) true;
}
}
$cacheService->save($cacheKey, $exists);
}
return $exists;
}
/**
* Process item
* @param Article $article
* @return array
*/
public function processItem(Article $article)
{
global $g_user, $Campsite;
$articleLinkParams = '?f_publication_id=' . $article->getPublicationId()
. '&f_issue_number=' . $article->getIssueNumber() . '&f_section_number=' . $article->getSectionNumber()
. '&f_article_number=' . $article->getArticleNumber() . '&f_language_id=' . $article->getLanguageId()
. '&f_language_selected=' . $article->getLanguageId();
$articleLink = $Campsite['WEBSITE_URL'].'/admin/articles/edit.php' . $articleLinkParams;
$previewLink = $Campsite['WEBSITE_URL'].'/admin/articles/preview.php' . $articleLinkParams;
$lockInfo = '';
$lockHighlight = false;
$timeDiff = camp_time_diff_str($article->getLockTime());
if ($article->isLocked() && ($timeDiff['days'] <= 0)) {
$lockUser = new User($article->getLockedByUser());
if ($timeDiff['hours'] > 0) {
$lockInfo = getGS('The article has been locked by $1 ($2) $3 hour(s) and $4 minute(s) ago.',
htmlspecialchars($lockUser->getRealName()),
htmlspecialchars($lockUser->getUserName()),
$timeDiff['hours'], $timeDiff['minutes']);
} else {
$lockInfo = getGS('The article has been locked by $1 ($2) $3 minute(s) ago.',
htmlspecialchars($lockUser->getRealName()),
htmlspecialchars($lockUser->getUserName()),
$timeDiff['minutes']);
}
if ($article->getLockedByUser() != $g_user->getUserId()) {
$lockHighlight = true;
}
}
$tmpUser = new User($article->getCreatorId());
$tmpArticleType = new ArticleType($article->getType());
$tmpAuthor = new Author();
$articleAuthors = ArticleAuthor::GetAuthorsByArticle($article->getArticleNumber(), $article->getLanguageId());
foreach((array) $articleAuthors as $author) {
if (strtolower($author->getAuthorType()->getName()) == 'author') {
$tmpAuthor = $author;
break;
}
}
if (!$tmpAuthor->exists() && isset($articleAuthors[0])) {
$tmpAuthor = $articleAuthors[0];
}
$onFrontPage = $article->onFrontPage() ? getGS('Yes') : getGS('No');
$onSectionPage = $article->onSectionPage() ? getGS('Yes') : getGS('No');
$imagesNo = (int) ArticleImage::GetImagesByArticleNumber($article->getArticleNumber(), true);
$topicsNo = (int) ArticleTopic::GetArticleTopics($article->getArticleNumber(), true);
$commentsNo = '';
if ($article->commentsEnabled()) {
$commentsNo = (int) ArticleComment::GetArticleComments($article->getArticleNumber(), $article->getLanguageId(), null, true);
} else {
$commentsNo = 'No';
}
// get language code
$language = new Language($article->getLanguageId());
return array(
$article->getArticleNumber(),
$article->getLanguageId(),
$article->getOrder(),
sprintf('%s <a href="%s" title="%s %s">%s</a>',
$article->isLocked() ? '<span class="ui-icon ui-icon-locked' . (!$lockHighlight ? ' current-user' : '' ) . '" title="' . $lockInfo . '"></span>' : '',
$articleLink,
getGS('Edit'), $article->getName() . " ({$article->getLanguageName()})",
$article->getName() . (empty($_REQUEST['language']) ? " ({$language->getCode()})" : '')),
$tmpArticleType->getDisplayName(),
$tmpUser->getRealName(),
$tmpAuthor->getName(),
$article->getWorkflowStatus(),
$onFrontPage,
$onSectionPage,
$imagesNo,
$topicsNo,
$commentsNo,
(int) $article->getReads(),
Geo_Map::GetArticleMapId($article) != NULL ? getGS('Yes') : getGS('No'),
(int) sizeof(Geo_Map::GetLocationsByArticle($article)),
$article->getCreationDate(),
$article->getPublishDate(),
$article->getLastModified(),
);
}
