public static function getTagCategoriesByScheme($db, $app_root, $scheme)
{
$cats = new Dase_Atom_Categories();
$cats->setScheme('http://daseproject.org/category/' . $scheme);
$prefix = $db->table_prefix;
$sql = "\n\t\t\tSELECT term, label \n\t\t\tFROM {$prefix}tag_category \n\t\t\tWHERE scheme = ?\n\t\t\tGROUP BY term, label\n\t\t\tORDER BY label\n\t\t\t";
$dbh = $db->getDbh();
$sth = $dbh->prepare($sql);
$sth->execute(array($scheme));
foreach ($sth->fetchAll() as $row) {
$cats->addCategory($row['term'], '', $row['label']);
}
return $cats->asXml();
}
public function getSearch($r)
{
$tpl = new Dase_Template($r);
$courses = Dase_Atom_Categories::load(file_get_contents($r->app_root . '/sets/utexas/courses.cats'));
$tpl->assign('courses', $courses);
$feed = Dase_Atom_Feed::retrieve($r->app_root . '/tags/search.atom?q=' . $r->get('q'));
$tpl->assign('sets', $feed);
$tpl->assign('q', $r->get('q'));
$r->renderResponse($tpl->fetch('tags/list.tpl'));
}
