public function findTags($id)
{
Zend_Registry::get('logger')->entering();
$tags = new Tag();
$subquery = $this->_db->select();
$subquery->from('tags_items', 'tag_id');
$subquery->where('item_id = ?', $id);
return $tags->fetchAll('id IN (' . $subquery . ')');
Zend_Registry::get('logger')->exiting();
}
function admineditAction()
{
$reportTab = new ReportTab();
$this->view->reportTab = $reportTab->fetchRow("id = " . $this->getRequest()->getParam('id'));
$campaign = new Campaign();
$this->view->campaigns = $campaign->fetchAll();
$tag = new Tag();
$this->view->tags = $tag->fetchAll();
$tagging = new Tagging();
//$taggings = $tagging->fetchAll($tagging->select()->from('taggings', 'tag_id')->where('report_tab_id = ? ', $this->getRequest()->getParam('id')));
$taggings = $tagging->findBy(array('report_tab_id' => $this->getRequest()->getParam('id')));
$tagging_ids = array();
foreach ($taggings as $tagging) {
array_push($tagging_ids, $tagging->tag_id);
}
$this->view->taggings = $tagging_ids;
}
public function tagAction()
{
$this->_helper->viewRenderer->setNeverRender();
$this->view->layout()->disableLayout();
$get = Zend_Registry::get('getFilter');
$search = $get->q;
$tag = new Tag();
$tags = $tag->fetchAll();
//echo $search;
if ($search != '') {
foreach ($tags as $t) {
if (strpos(strtolower($t->name), $search) !== false) {
echo $t->name . "|" . $t->tagId . "\n";
}
}
}
}
public function init()
{
// doctype
$viewRenderer = Zend_Controller_Action_HelperBroker::getStaticHelper('viewRenderer');
$viewRenderer->view->doctype('XHTML1_STRICT');
// js + css
$this->view->headScript()->prependFile('/js/swfobject/swfobject.js');
$this->view->headLink()->prependStylesheet('/css/base.css?' . date('Ymd'));
// tags
$tagManager = new Tag();
$this->view->tags = $tagManager->fetchAll(null, "(SELECT COUNT(*) FROM posts_tags WHERE tag_id = tags.id) DESC");
// description
if ($this->view->metaDescription === NULL) {
$this->view->metaDescription = 'Hi, my name is Neil Garb and I\'m a web developer.';
}
// keywords
if ($this->view->metaKeywords === NULL) {
$this->view->metaKeywords = array('codecaine', 'codecaine.co.za', 'neil garb', 'php', 'php blog', 'web developer', 'web development', 'blog', 'cape town', 'south africa');
}
}
public function indexAction()
{
$this->logger->entering();
$this->logger->info('Load all tags');
$tagTable = new Tag();
$tagSet = $tagTable->fetchAll();
$this->logger->info('Load item count for each tag');
$tags = array();
foreach ($tagSet as $tag) {
$tag = $tag->toArray();
$tag['count'] = $tagTable->findItems($tag['id'])->count();
$tags[] = $tag;
}
$this->logger->debug("Got '" . count($tags) . "' tags");
$this->logger->info('Load view parameters');
$this->view->assign(array('title' => 'Keywords', 'tags' => $tags));
$this->logger->info('Render view');
$this->render();
$this->logger->exiting();
}
public function sitemapAction()
{
header('Content-Type: application/xhtml+xml');
$urls = array('/' => mktime(0, 0, 0, date('m'), date('d'), date('Y')), '/about' => mktime(0, 0, 0, date('m'), date('d'), date('Y')));
$postManager = new Post();
$posts = $postManager->fetchAll(array('is_active = ?' => 1), 'posted_at DESC');
foreach ($posts as $post) {
$urls['/posts/' . $post->label] = strtotime($post->posted_at);
}
$tagManager = new Tag();
$tags = $tagManager->fetchAll(null, 'title');
foreach ($tags as $tag) {
$urls['/tags/' . $tag->label] = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
}
echo '<' . '?xml version="1.0"?' . '>' . "\n" . '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">' . "\n";
foreach ($urls as $u => $t) {
echo "\t" . '<url>' . "\n" . "\t\t" . '<loc>http://codecaine.co.za' . $u . '</loc>' . "\n" . "\t\t" . '<lastMod>' . date('Y-m-d', $t) . 'T' . date('H:i:s', $t) . '+2:00</lastMod>' . "\n" . "\t" . '</url>' . "\n";
}
echo '</urlset>';
die;
}
