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; }