public function build($runData)
{
$pl = $runData->getParameterList();
$tag = $pl->getParameterValue("tag");
if ($tag === null) {
$runData->setModuleTemplate("Empty");
return;
}
$lang = $pl->getParameterValue("lang");
if ($lang && $lang !== "pl" && $lang !== "en") {
$lang = null;
}
// get sites
$title = $pl->getParameterValue("title");
$runData->contextAdd("title", $title);
$c = new Criteria();
$c->setExplicitFrom("site, site_tag");
$c->add("site_tag.tag", $tag);
$c->add("site.visible", true);
$c->add("site.private", false);
$c->add("site.deleted", false);
if ($lang) {
$c->add("site.language", $lang);
}
$c->add("site_tag.site_id", "site.site_id", "=", false);
$c->addOrderAscending('site.name');
$sites = DB_SitePeer::instance()->select($c);
// $q = "SELECT site.* FROM site, tag WHERE tag.tag = '".db_escape_string($tag")."'
$runData->contextAdd("tag", $tag);
$runData->contextAdd("sites", $sites);
$runData->contextAdd("sitesCount", count($sites));
}
public function build($runData)
{
$pl = $runData->getParameterList();
$site = $runData->getTemp("site");
$tag = $pl->getParameterValue("tag");
if ($tag === null) {
$runData->setModuleTemplate("Empty");
return '';
}
// get pages
$categoryName = $pl->getParameterValue("category");
if ($categoryName) {
$category = DB_CategoryPeer::instance()->selectByName($categoryName, $site->getSiteId());
if ($category == null) {
return '';
}
$runData->contextAdd("category", $category);
}
$c = new Criteria();
$c->setExplicitFrom("page, page_tag");
$c->add("page_tag.tag", $tag);
$c->add("page_tag.site_id", $site->getSiteId());
$c->add("page_tag.page_id", "page.page_id", "=", false);
if ($category) {
$c->add("page.category_id", $category->getCategoryId());
}
$c->addOrderAscending('COALESCE(page.title, page.unix_name)');
$pages = DB_PagePeer::instance()->select($c);
// $q = "SELECT site.* FROM site, tag WHERE tag.tag = '".db_escape_string($tag")."'
$runData->contextAdd("tag", $tag);
$runData->contextAdd("pages", $pages);
$runData->contextAdd("pageCount", count($pages));
$runData->contextAdd("pageUnixName", $runData->getTemp("page")->getUnixName());
}
public function getGroupMembers($group)
{
if (gettype($group) == "string") {
//get object
$groupObject = $this->getGroupByName($group);
} else {
$groupObject = $group;
}
$c = new Criteria();
$c->setExplicitFrom("ozone_user, ozone_user_group_relation");
$c->setExplicitFields("ozone_user.*");
$c->add("ozone_user_group_relation.group_id", $groupObject->getGroupId());
$c->add("ozone_user_group_relation.user_id", "ozone_user.user_id", "=", false);
$users = DB_OzoneUserPeer::instance()->select($c);
return $users;
}
