/**
* Delete draft, along with featured image and attachment.
*
* @param array $ids Draft ID
* @param string $module Current module name
* @return int Affected rows
*/
public static function deleteDraft($ids, $module = null)
{
$module = $module ?: Pi::service('module')->current();
$modelDraft = Pi::model('draft', $module);
$modelArticle = Pi::model('article', $module);
// Delete feature image
$resultsetFeatureImage = $modelDraft->select(array('id' => $ids));
foreach ($resultsetFeatureImage as $featureImage) {
if ($featureImage->article) {
$rowArticle = $modelArticle->find($featureImage->article);
if ($featureImage->image && strcmp($featureImage->image, $rowArticle->image) != 0) {
@unlink(Pi::path($featureImage->image));
@unlink(Pi::path(Media::getThumbFromOriginal($featureImage->image)));
}
} else {
if ($featureImage->image) {
@unlink(Pi::path($featureImage->image));
@unlink(Pi::path(Media::getThumbFromOriginal($featureImage->image)));
}
}
}
// Delete assets
$modelDraftAsset = Pi::model('asset_draft', $module);
$modelDraftAsset->delete(array('draft' => $ids));
// Delete draft
$affectedRows = $modelDraft->delete(array('id' => $ids));
return $affectedRows;
}
/**
* Remove image
*
* @return ViewModel
*/
public function removeImageAction()
{
Pi::service('log')->mute();
$id = $this->params('id', 0);
$fakeId = $this->params('fake_id', 0);
$affectedRows = 0;
$module = $this->getModule();
if ($id) {
$rowDraft = $this->getModel('draft')->find($id);
if ($rowDraft && $rowDraft->image) {
$thumbUrl = Media::getThumbFromOriginal($rowDraft->image);
if ($rowDraft->article) {
$modelArticle = $this->getModel('article');
$rowArticle = $modelArticle->find($rowDraft->article);
if ($rowArticle && $rowArticle->image != $rowDraft->image) {
// Delete file
@unlink(Pi::path($rowDraft->image));
@unlink(Pi::path($thumbUrl));
}
} else {
@unlink(Pi::path($rowDraft->image));
@unlink(Pi::path($thumbUrl));
}
// Update db
$rowDraft->image = '';
$affectedRows = $rowDraft->save();
}
} else {
if ($fakeId) {
$session = Media::getUploadSession($module, 'feature');
if (isset($session->{$fakeId})) {
$uploadInfo = $session->{$fakeId};
$url = Media::getThumbFromOriginal($uploadInfo['tmp_name']);
$affectedRows = unlink(Pi::path($uploadInfo['tmp_name']));
@unlink(Pi::path($url));
unset($session->{$id});
unset($session->{$fakeId});
}
}
}
echo json_encode(array('status' => $affectedRows ? true : false, 'message' => 'ok'));
exit;
}
/**
* Topic list page for viewing
*/
public function allTopicAction()
{
$page = $this->params('p', 1);
$page = $page > 0 ? $page : 1;
$module = $this->getModule();
$config = Pi::config('', $module);
$limit = (int) $config['page_limit_all'];
$where = array('active' => 1);
// Get topics
$resultsetTopic = TopicService::getTopics($where, $page, $limit);
foreach ($resultsetTopic as &$topic) {
$topic['image'] = $topic['image'] ? Media::getThumbFromOriginal($topic['image']) : Pi::service('asset')->getModuleAsset($config['default_topic_image']);
}
$topicIds = array_keys($resultsetTopic) ?: array(0);
// Get topic article counts
$model = $this->getModel('article_topic');
$select = $model->select()->where(array('topic' => $topicIds))->columns(array('count' => new Expression('count(id)'), 'topic'))->group(array('topic'));
$rowRelation = $model->selectWith($select);
$articleCount = array();
foreach ($rowRelation as $row) {
$articleCount[$row->topic] = $row->count;
}
// Get last added article
$lastAdded = array();
$select = $model->select()->where(array('topic' => $topicIds))->columns(array('id' => new Expression('max(id)')))->group(array('topic'));
$rowset = $model->selectWith($select);
$ids = array(0);
foreach ($rowset as $row) {
$ids[] = $row['id'];
}
$rowAdded = $model->select(array('id' => $ids));
foreach ($rowAdded as $row) {
$lastAdded[$row['topic']] = $row['time'];
}
// Total count
$modelTopic = $this->getModel('topic');
$totalCount = $modelTopic->getSearchRowsCount($where);
// Pagination
$route = Pi::api('api', $module)->getRouteName();
$paginator = Paginator::factory($totalCount, array('limit' => $limit, 'page' => $page, 'url_options' => array('page_param' => 'p', 'params' => array('topic' => 'all'))));
$this->view()->assign(array('title' => __('All Topics'), 'topics' => $resultsetTopic, 'paginator' => $paginator, 'count' => $articleCount, 'config' => $config, 'route' => $route, 'lastAdded' => $lastAdded));
}
/**
* List custom articles and with a slideshow besides article list
*
* @param array $options
* @param string $module
* @return boolean
*/
public static function recommendedSlideshow($options = array(), $module = null)
{
if (!$module) {
return false;
}
// Getting custom article list
$columns = array('subject', 'summary', 'time_publish', 'image');
$ids = explode(',', $options['articles']);
foreach ($ids as &$id) {
$id = trim($id);
}
$where = array('id' => $ids);
$articles = Entity::getAvailableArticlePage($where, 1, 10, $columns, null, $module);
$config = Pi::config('', $module);
$image = $config['default_feature_thumb'];
$image = Pi::service('asset')->getModuleAsset($image, $module);
foreach ($articles as &$article) {
$article['subject'] = mb_substr($article['subject'], 0, $options['max_subject_length'], 'UTF-8');
$article['summary'] = mb_substr($article['summary'], 0, $options['max_summary_length'], 'UTF-8');
$article['image'] = $article['image'] ? Media::getThumbFromOriginal(Pi::url($article['image'])) : $image;
}
// Getting image link url
$urlRows = explode('\\n', $options['image-link']);
$imageLinks = array();
foreach ($urlRows as $row) {
list($id, $url) = explode(':', trim($row), 2);
$imageLinks[trim($id)] = trim($url);
}
// Fetching image ID
$images = explode(',', $options['images']);
$imageIds = array();
foreach ($images as $key => &$image) {
$image = trim($image);
if (is_numeric($image)) {
$imageIds[] = $image;
} else {
$url = $image ?: 'image/default-recommended.png';
$image = array('url' => Pi::service('asset')->getModuleAsset($url, $module), 'link' => $imageLinks[$key + 1], 'title' => _b('This is default recommended image'), 'description' => _b('You should to add your own images and its title and description!'));
}
}
if (!empty($imageIds)) {
$images = array();
$rowset = Pi::model('media', $module)->select(array('id' => $imageIds));
foreach ($rowset as $row) {
$id = $row['id'];
$link = isset($imageLinks[$id]) ? $imageLinks[$id] : '';
$images[] = array('url' => Pi::url($row['url']), 'link' => $link, 'title' => $row['title'], 'description' => $row['description']);
}
}
return array('articles' => $articles, 'target' => $options['target'], 'style' => $options['block-style'], 'elements' => (array) $options['element'], 'height' => $options['image-height'], 'images' => $images, 'config' => Pi::config('', $module), 'rows' => $options['description_rows']);
}
/**
* Get published article details
*
* @param array $where
* @param int $page
* @param int $limit
* @param array $columns
* @param string $order
* @param string $module
* @return array
*/
public static function getArticlePage($where, $page, $limit, $columns = null, $order = null, $module = null)
{
$offset = $limit && $page ? $limit * ($page - 1) : null;
$module = $module ?: Pi::service('module')->current();
$config = Pi::config('', $module);
$articleIds = $userIds = $authorIds = $categoryIds = array();
$categories = $authors = $users = $tags = $urls = array();
$modelArticle = Pi::model('article', $module);
// Generate columns of extended table and statistics table
$extendedColumns = Pi::service('registry')->handler('extended', $module)->read($module);
$statisColumns = ModelStats::getAvailableColumns();
if (!empty($columns)) {
// Get needed columns of extended table
foreach ($extendedColumns as $key => $col) {
if (!in_array($col, $columns)) {
unset($extendedColumns[$key]);
}
}
// Get needed columns of statistics table
foreach ($statisColumns as $key => $col) {
if (!in_array($col, $columns)) {
unset($statisColumns[$key]);
}
}
// Remove fields not belong to article table
$columns = array_diff($columns, $extendedColumns);
$columns = array_diff($columns, $statisColumns);
}
$resultset = $modelArticle->getSearchRows($where, $limit, $offset, $columns, $order);
if ($resultset) {
foreach ($resultset as $row) {
$articleIds[] = $row['id'];
if (!empty($row['author'])) {
$authorIds[] = $row['author'];
}
if (!empty($row['uid'])) {
$userIds[] = $row['uid'];
}
}
$authorIds = array_unique($authorIds);
$userIds = array_unique($userIds);
// Getting statistics data
$templateStatis = array();
if (!empty($statisColumns)) {
$statisColumns[] = 'id';
$statisColumns[] = 'article';
$modelStatis = Pi::model('stats', $module);
$select = $modelStatis->select()->where(array('article' => $articleIds))->columns($statisColumns);
$rowStatis = $modelStatis->selectWith($select);
$statis = array();
foreach ($rowStatis as $item) {
$temp = $item->toArray();
unset($temp['id']);
unset($temp['article']);
$statis[$item->article] = $temp;
}
foreach ($statisColumns as $col) {
if (in_array($col, array('id', 'article'))) {
continue;
}
$templateStatis[$col] = null;
}
}
// Default extended columns
$extendedColumns = array_merge($extendedColumns, array('slug', 'seo_title', 'seo_keywords', 'seo_description'));
$extendedColumns = array_unique($extendedColumns);
// Getting extended data
$templateExtended = array();
if (!empty($extendedColumns)) {
$extendedColumns[] = 'id';
$extendedColumns[] = 'article';
$modelExtended = Pi::model('extended', $module);
$select = $modelExtended->select()->where(array('article' => $articleIds))->columns($extendedColumns);
$rowExtended = $modelExtended->selectWith($select);
$extended = array();
foreach ($rowExtended as $item) {
$temp = $item->toArray();
unset($temp['id']);
unset($temp['article']);
$extended[$item->article] = $temp;
}
foreach ($extendedColumns as $col) {
if (in_array($col, array('id', 'article'))) {
continue;
}
$templateExtended[$col] = null;
}
}
$categories = Pi::api('api', $module)->getCategoryList();
if (!empty($authorIds) && (empty($columns) || in_array('author', $columns))) {
$resultsetAuthor = Pi::api('api', $module)->getAuthorList($authorIds);
foreach ($resultsetAuthor as $row) {
$authors[$row['id']] = array('name' => $row['name']);
}
unset($resultsetAuthor);
}
if (!empty($userIds) && (empty($columns) || in_array('uid', $columns))) {
$resultsetUser = Pi::user()->get($userIds, array('id', 'name'));
foreach ($resultsetUser as $row) {
$users[$row['id']] = array('name' => $row['name']);
}
unset($resultsetUser);
}
/*
if (!empty($articleIds)) {
if ((empty($columns) || in_array('tag', $columns))
&& $config['enable_tag']
) {
$tags = Pi::service('tag')->get($module, $articleIds);
}
}
*/
foreach ($resultset as &$row) {
if (empty($columns) || in_array('category', $columns)) {
if (!empty($categories[$row['category']])) {
$row['category_title'] = $categories[$row['category']]['title'];
$row['category_slug'] = $categories[$row['category']]['slug'];
}
}
if (empty($columns) || in_array('uid', $columns)) {
if (!empty($users[$row['uid']])) {
$row['user_name'] = $users[$row['uid']]['name'];
}
}
if (empty($columns) || in_array('author', $columns)) {
if (!empty($authors[$row['author']])) {
$row['author_name'] = $authors[$row['author']]['name'];
}
}
if (empty($columns) || in_array('image', $columns)) {
if ($row['image']) {
$row['thumb'] = Media::getThumbFromOriginal($row['image']);
}
}
/*
if ((empty($columns)
|| in_array('tag', $columns)) && $config['enable_tag']) {
if (!empty($tags[$row['id']])) {
$row['tag'] = $tags[$row['id']];
}
}
*/
if (empty($columns) || in_array('subject', $columns)) {
$route = Pi::api('api', $module)->getRouteName($module);
$row['url'] = Pi::service('url')->assemble($route, array('time' => date('Ymd', $row['time_publish']), 'id' => $row['id'], 'slug' => $extended[$row['id']]['slug']));
}
if (!isset($statis[$row['id']])) {
$statis[$row['id']] = $templateStatis;
}
$row = array_merge($row, $statis[$row['id']]);
if (!isset($extended[$row['id']])) {
$extended[$row['id']] = $templateExtended;
}
$row = array_merge($row, $extended[$row['id']]);
}
}
return $resultset;
}
/**
* Delete published articles
*
* @return ViewModel
*/
public function deleteAction()
{
// Denied user viewing if no front-end management permission assigned
if (!$this->config('enable_front_edit') && 'front' == $this->section) {
return $this->jumpTo404();
}
$id = $this->params('id', '');
$ids = array_filter(explode(',', $id));
$from = $this->params('from', '');
if (empty($ids)) {
return $this->jumpTo404(__('Invalid article ID'));
}
$module = $this->getModule();
$modelArticle = $this->getModel('article');
$modelAsset = $this->getModel('asset');
// Delete articles that user has permission to do
$rules = Rule::getPermission();
if (1 == count($ids)) {
$row = $modelArticle->find($ids[0]);
$slug = Draft::getStatusSlug($row->status);
$resource = $slug . '-delete';
if (!(isset($rules[$row->category][$resource]) and $rules[$row->category][$resource])) {
return $this->jumpToDenied();
}
} else {
$rows = $modelArticle->select(array('id' => $ids));
$ids = array();
foreach ($rows as $row) {
$slug = Draft::getStatusSlug($row->status);
$resource = $slug . '-delete';
if (isset($rules[$row->category][$resource]) and $rules[$row->category][$resource]) {
$ids[] = $row->id;
}
}
}
$resultsetArticle = $modelArticle->select(array('id' => $ids));
// Step operation
foreach ($resultsetArticle as $article) {
// Delete feature image
if ($article->image) {
@unlink(Pi::path($article->image));
@unlink(Pi::path(Media::getThumbFromOriginal($article->image)));
}
}
// Batch operation
// Deleting extended fields
$this->getModel('extended')->delete(array('article' => $ids));
// Deleting statistics
$this->getModel('stats')->delete(array('article' => $ids));
// Deleting compiled article
$this->getModel('compiled')->delete(array('article' => $ids));
// Delete tag
if ($this->config('enable_tag')) {
Pi::service('tag')->delete($module, $ids);
}
// Delete related articles
$this->getModel('related')->delete(array('article' => $ids));
// Delete visits
$this->getModel('visit')->delete(array('article' => $ids));
// Delete assets
$modelAsset->delete(array('article' => $ids));
// Delete article directly
$modelArticle->delete(array('id' => $ids));
// Clear cache
Pi::service('render')->flushCache($module);
if ($from) {
$from = urldecode($from);
return $this->redirect()->toUrl($from);
} else {
// Go to list page
return $this->redirect()->toRoute('', array('controller' => 'article', 'action' => 'published', 'from' => 'all'));
}
}