Skip to content

Instantly share code, notes, and snippets.

@stikoo
Created January 2, 2013 00:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stikoo/4431138 to your computer and use it in GitHub Desktop.
Save stikoo/4431138 to your computer and use it in GitHub Desktop.
Modified PyroCMS Blog Plugin to allow outputting of tags/keywords
<?php defined('BASEPATH') OR exit('No direct script access allowed');
/**
* Blog Plugin
*
* Create lists of posts
*
* @author PyroCMS Dev Team
* @package PyroCMS\Core\Modules\Blog\Plugins
*/
class Plugin_Blog extends Plugin
{
/**
* Blog List
*
* Creates a list of blog posts
*
* Usage:
* {{ blog:posts order-by="title" limit="5" }}
* <h2>{{ title }}</h2>
* <p> {{ body }} </p>
* {{ /blog:posts }}
*
* @param array
* @return array
*/
public function posts()
{
$limit = $this->attribute('limit', 10);
$offset = $this->attribute('offset',0);
$category = $this->attribute('category');
$order_by = $this->attribute('order-by', 'created_on');
$order_dir = $this->attribute('order-dir', 'ASC');
if ($category)
{
$categories = explode('|', $category);
$category = array_shift($categories);
$this->db->where('blog_categories.' . (is_numeric($category) ? 'id' : 'slug'), $category);
foreach($categories as $category)
{
$this->db->or_where('blog_categories.' . (is_numeric($category) ? 'id' : 'slug'), $category);
}
}
$posts = $this->db
->select('blog.*')
->select('blog_categories.title as category_title, blog_categories.slug as category_slug')
->select('p.display_name as author_name')
->where('status', 'live')
->where('created_on <=', now())
->join('blog_categories', 'blog.category_id = blog_categories.id', 'left')
->join('profiles p', 'blog.author_id = p.user_id', 'left')
->order_by('blog.' . $order_by, $order_dir)
->limit($limit,$offset)
->get('blog')
->result();
$i = 1;
foreach ($posts as &$post)
{
$post->url = site_url('blog/'.date('Y', $post->created_on).'/'.date('m', $post->created_on).'/'.$post->slug);
$post->count = $i++;
$post->tags = array();
foreach (Keywords::get_array($post->keywords) as $tag) {
$post->tags[] = array('tag' => $tag);
}
}
return $posts;
}
/**
* Categories
*
* Creates a list of blog categories
*
* Usage:
* {{ blog:categories order-by="title" limit="5" }}
* <a href="{{ url }}" class="{{ slug }}">{{ title }}</a>
* {{ /blog:categories }}
*
* @param array
* @return array
*/
public function categories()
{
$limit = $this->attribute('limit', 10);
$order_by = $this->attribute('order-by', 'title');
$order_dir = $this->attribute('order-dir', 'ASC');
$categories = $this->db
->select('title, slug')
->order_by($order_by, $order_dir)
->limit($limit)
->get('blog_categories')
->result();
foreach ($categories as &$category)
{
$category->url = site_url('blog/category/'.$category->slug);
}
return $categories;
}
/**
* Count Posts By Column
*
* Usage:
* {{ blog:count_posts author_id="1" }}
*
* The attribute name is the database column and
* the attribute value is the where value
*/
public function count_posts()
{
$wheres = $this->attributes();
// make sure they provided a where clause
if (count($wheres) == 0) return FALSE;
foreach ($wheres AS $column => $value)
{
$this->db->where($column, $value);
}
return $this->db->count_all_results('blog');
}
}
/* End of file plugin.php */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment