PHP CriteriaCompo::render方法代码示例

 function &get($blog_id, $direction = "")
 {
     $blog_id = intval($blog_id);
     $criteria = new CriteriaCompo(new Criteria('blog_id', $blog_id));
     if ($direction) {
         $criteria->add(new Criteria('direction', $direction));
     }
     if ($blog_id > 0) {
         $sql = sprintf('SELECT blog_id, tb_url, blog_name, title, description, link, direction,trackback_created FROM %s WHERE %s order by trackback_created DESC', $this->db->prefix($this->mydirname . '_trackback'), $criteria->render());
         if ($result = $this->db->query($sql)) {
             $trackback_array = array();
             while ($trackback_data = $this->db->fetchArray($result)) {
                 $trackback_obj = $this->create();
                 $trackback_obj->assignVars($trackback_data);
                 array_push($trackback_array, $trackback_obj);
             }
             return $trackback_array;
         }
     }
     return false;
 }

function xnpbookGetAdvancedSearchQuery(&$where, &$join)
{
    global $xoopsDB;
    $book_table = $xoopsDB->prefix('xnpbook_item_detail');
    $book_author = $xoopsDB->prefix('xnpbook_author');
    $wheres = array();
    $w = xnpGetBasicInformationAdvancedSearchQuery('xnpbook');
    if ($w) {
        $wheres[] = $w;
    }
    $w = xnpGetKeywordQuery($book_author . '.author', 'xnpbook_author');
    if ($w) {
        $wheres[] = $w;
    }
    $w = xnpGetKeywordQuery($book_table . '.editor', 'xnpbook_editor');
    if ($w) {
        $wheres[] = $w;
    }
    $w = xnpGetKeywordQuery($book_table . '.publisher', 'xnpbook_publisher');
    if ($w) {
        $wheres[] = $w;
    }
    $w = xnpGetKeywordQuery($book_table . '.isbn', 'xnpbook_isbn');
    if ($w) {
        $wheres[] = $w;
    }
    $formdata =& xoonips_getutility('formdata');
    $xnpbook_book_pdf = $formdata->getValue('post', 'xnpbook_book_pdf', 's', false);
    if (!empty($xnpbook_book_pdf)) {
        $search_text_table = $xoopsDB->prefix('xoonips_search_text');
        $file_table = $xoopsDB->prefix('xoonips_file');
        $searchutil =& xoonips_getutility('search');
        $fulltext_query = $xnpbook_book_pdf;
        $fulltext_encoding = mb_detect_encoding($fulltext_query);
        $fulltext_criteria = new CriteriaCompo($searchutil->getFulltextSearchCriteria('search_text', $fulltext_query, $fulltext_encoding, $search_text_table));
        $fulltext_criteria->add(new Criteria('is_deleted', 0, '=', $file_table));
        $wheres[] = $fulltext_criteria->render();
    }
    $where = implode(' AND ', $wheres);
    $join = " INNER JOIN {$book_author} ON " . $book_author . '.book_id  = ' . $xoopsDB->prefix('xoonips_item_basic') . '.item_id ';
}

function xnppresentationGetAdvancedSearchQuery(&$where, &$join)
{
    global $xoopsDB;
    $formdata =& xoonips_getutility('formdata');
    $basic_table = $xoopsDB->prefix('xoonips_item_basic');
    $presentation_table = $xoopsDB->prefix('xnppresentation_item_detail');
    $presentation_creator_table = $xoopsDB->prefix('xnppresentation_creator');
    $file_table = $xoopsDB->prefix('xoonips_file');
    $search_text_table = $xoopsDB->prefix('xoonips_search_text');
    $wheres = array();
    $joins = array();
    $xnppresentation_presentation_type = $formdata->getValue('post', 'xnppresentation_presentation_type', 's', false);
    $xnppresentation_presentation_file = $formdata->getValue('post', 'xnppresentation_presentation_file', 's', false);
    $w = xnpGetBasicInformationAdvancedSearchQuery('xnppresentation');
    if ($w) {
        $wheres[] = $w;
    }
    if (!empty($xnppresentation_presentation_type)) {
        $myts =& MyTextSanitizer::getInstance();
        $wheres[] = $presentation_table . '.presentation_type = \'' . addslashes($xnppresentation_presentation_type) . '\'';
    }
    $w = xnpGetKeywordQuery($presentation_creator_table . '.creator', 'xnppresentation_creator');
    if ($w) {
        $wheres[] = $w;
    }
    $w = xnpGetKeywordQuery($file_table . '.caption', 'xnppresentation_caption');
    if ($w) {
        $wheres[] = $w;
        $wheres[] = " {$file_table}.file_type_id = 1";
    }
    if (!empty($xnppresentation_presentation_file)) {
        $search_text_table = $xoopsDB->prefix('xoonips_search_text');
        $file_table = $xoopsDB->prefix('xoonips_file');
        $searchutil =& xoonips_getutility('search');
        $fulltext_query = $xnppresentation_presentation_file;
        $fulltext_encoding = mb_detect_encoding($fulltext_query);
        $fulltext_criteria = new CriteriaCompo($searchutil->getFulltextSearchCriteria('search_text', $fulltext_query, $fulltext_encoding, $search_text_table));
        $fulltext_criteria->add(new Criteria('is_deleted', 0, '=', $file_table));
        $wheres[] = $fulltext_criteria->render();
    }
    $where = implode(' AND ', $wheres);
    $join = " INNER JOIN {$presentation_creator_table} ON " . $presentation_creator_table . '.presentation_id  = ' . $xoopsDB->prefix('xoonips_item_basic') . '.item_id ';
}

 /**
  * Get count of users belonging to certain groups and matching criteria
  * Temporary solution
  *
  * @param  int  $groups   IDs of groups
  * @param  null $criteria
  * @return int  count of users
  */
 function getUserCountByGroupLink($groups, $criteria = null)
 {
     $ret = 0;
     $criteriaCompo = new CriteriaCompo();
     $sql = "SELECT DISTINCT COUNT(u.uid) " . " FROM " . $this->_uHandler->db->prefix("users") . " AS u" . " LEFT JOIN " . $this->_mHandler->db->prefix("groups_users_link") . " AS m ON m.uid = u.uid" . " WHERE ";
     if (!empty($groups)) {
         $criteriaCompo->add(new Criteria('m.groupid', "(" . implode(", ", $groups) . ")", 'IN'));
     }
     if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
         $criteriaCompo->add($criteria);
     }
     $sql_criteria = $criteriaCompo->render();
     if ($sql_criteria) {
         $sql .= $sql_criteria;
     } else {
         $sql .= "1 = 1";
     }
     if (!($result = $this->_uHandler->db->query($sql))) {
         return $ret;
     }
     list($ret) = $this->_uHandler->db->fetchRow($result);
     return $ret;
 }

function xnppaperGetAdvancedSearchQuery(&$where, &$join)
{
    global $xoopsDB;
    $formdata =& xoonips_getutility('formdata');
    $paper_table = $xoopsDB->prefix('xnppaper_item_detail');
    $paper_author_table = $xoopsDB->prefix('xnppaper_author');
    $file_table = $xoopsDB->prefix('xoonips_search_text');
    $wheres = array();
    $w = xnpGetBasicInformationAdvancedSearchQuery('xnppaper');
    if ($w) {
        $wheres[] = $w;
    }
    $w = xnpGetKeywordQuery($paper_table . '.journal', 'xnppaper_journal');
    if ($w) {
        $wheres[] = $w;
    }
    $w = xnpGetKeywordQuery($paper_table . '.volume', 'xnppaper_volume');
    if ($w) {
        $wheres[] = $w;
    }
    $w = xnpGetKeywordQuery($paper_table . '.number', 'xnppaper_number');
    if ($w) {
        $wheres[] = $w;
    }
    $w = xnpGetKeywordQuery($paper_table . '.page', 'xnppaper_page');
    if ($w) {
        $wheres[] = $w;
    }
    $w = xnpGetKeywordQuery($paper_table . '.pubmed_id', 'xnppaper_pubmed_id');
    if ($w) {
        $wheres[] = $w;
    }
    $w = xnpGetKeywordQuery($paper_author_table . '.author', 'xnppaper_author');
    if ($w) {
        $wheres[] = $w;
    }
    $xnppaper_paper_pdf_reprint = $formdata->getValue('post', 'xnppaper_paper_pdf_reprint', 's', false);
    if (!empty($xnppaper_paper_pdf_reprint)) {
        $search_text_table = $xoopsDB->prefix('xoonips_search_text');
        $file_table = $xoopsDB->prefix('xoonips_file');
        $searchutil =& xoonips_getutility('search');
        $fulltext_query = $xnppaper_paper_pdf_reprint;
        $fulltext_encoding = mb_detect_encoding($fulltext_query);
        $fulltext_criteria = new CriteriaCompo($searchutil->getFulltextSearchCriteria('search_text', $fulltext_query, $fulltext_encoding, $search_text_table));
        $fulltext_criteria->add(new Criteria('is_deleted', 0, '=', $file_table));
        $wheres[] = $fulltext_criteria->render();
    }
    $where = implode(' AND ', $wheres);
    $join = '';
    $join = " INNER JOIN {$paper_author_table} on " . $paper_author_table . '.paper_id  = ' . $xoopsDB->prefix('xoonips_item_basic') . '.item_id ';
}

 function checkForumAccess()
 {
     $uid = $this->sessionHandler->getUid();
     $user =& $this->sessionHandler->getUser();
     $forum_access_level = 0;
     $forum_type = 1;
     $is_mod = 0;
     $is_admin = 0;
     if ($this->forum_id) {
         $sql = 'SELECT forum_access,forum_type FROM ' . $this->db->prefix('xhnewbb_forums') . ' WHERE forum_id = ' . $this->forum_id;
     } elseif ($this->topic_id) {
         $sql = 'SELECT f.forum_access,f.forum_type FROM ' . $this->db->prefix('xhnewbb_topics') . ' t LEFT JOIN ' . $this->db->prefix('xhnewbb_forums') . ' f ON t.forum_id=f.forum_id WHERE t.topic_id=' . $this->topic_id;
     } else {
         return $this->forum_access;
     }
     // debug
     $this->utils->setDebugMessage(__CLASS__, 'checkForumAccess sql', $sql);
     if (!($ret = $this->db->query($sql))) {
         $this->utils->setDebugMessage(__CLASS__, 'checkForumAccess sql error', $this->db->error());
     }
     while ($data = $this->db->fetchArray($ret)) {
         $forum_access_level = $data['forum_access'];
         $forum_type = $data['forum_type'];
     }
     if ($forum_type == 1) {
         if (is_object($user)) {
             $criteria = new CriteriaCompo();
             $groupid_array = $this->utils->getGroupIdArray($user);
             foreach ($groupid_array as $groupid) {
                 $criteria->add(new Criteria('groupid', $groupid), 'OR');
             }
             $sql3 = 'SELECT user_id, can_post FROM ' . $this->db->prefix('xhnewbb_forum_access') . ' WHERE forum_id = ' . $this->forum_id . ' AND user_id = ' . $uid;
             if ($criteria->render() != '') {
                 $sql3 .= ' OR ' . $criteria->render();
             }
             if (!($ret3 = $this->db->query($sql3))) {
                 // debug
                 $this->utils->setDebugMessage(__CLASS__, 'checkForumAccess xhnewbb_forum_access sql', $sql3);
                 $this->utils->setDebugMessage(__CLASS__, 'checkForumAccess xhnewbb_forum_access sql error', $this->db->error());
             }
             $ret3_n = $this->db->getRowsNum($ret3);
             if ($ret3_n > 0) {
                 list($user_id, $can_post) = $this->db->fetchRow($ret3);
                 if ($can_post) {
                     $this->forum_access = 2;
                 } else {
                     $this->forum_access = 1;
                 }
             }
         }
     } else {
         if ($forum_access_level == 2) {
             $this->forum_access = 2;
         } elseif ($forum_access_level == 1) {
             if ($uid) {
                 $this->forum_access = 2;
             } else {
                 $this->forum_access = 1;
                 // ゲスト閲覧のみ許可
             }
         }
     }
     //moderator
     $sql2 = 'SELECT * FROM ' . $this->db->prefix('xhnewbb_forum_mods') . ' WHERE forum_id = ' . $this->forum_id . ' AND user_id = ' . $uid;
     if (!($ret2 = $this->db->query($sql2))) {
         // debug
         $this->utils->setDebugMessage(__CLASS__, 'checkForumAccess xhnewbb_forum_mods sql', $sql2);
         $this->utils->setDebugMessage(__CLASS__, 'checkForumAccess xhnewbb_forum_mods sql error', $this->db->error());
     }
     $ret2_n = $this->db->getRowsNum($ret2);
     if ($ret2_n > 0) {
         $this->forum_access = 3;
     }
     //module admin
     if ($mod_admin = $this->getModuleAdmin()) {
         $this->forum_access = 3;
     }
     // poster
     if ($uid) {
         $sql4 = 'SELECT post_id FROM ' . $this->db->prefix('xhnewbb_posts') . ' WHERE uid = ' . $uid . ' AND post_id = ' . $this->post_id;
         if (!($ret4 = $this->db->query($sql4))) {
             // debug
             $this->utils->setDebugMessage(__CLASS__, 'checkForumAccess xhnewbb_posts sql', $sql4);
             $this->utils->setDebugMessage(__CLASS__, 'checkForumAccess xhnewbb_posts sql error', $this->db->error());
         }
         $ret4_n = $this->db->getRowsNum($ret4);
         if ($ret4_n > 0) {
             $this->forum_access = 3;
         }
     }
     // debug
     $this->utils->setDebugMessage(__CLASS__, 'forum_access_level', $forum_access_level);
     $this->utils->setDebugMessage(__CLASS__, 'forum_access', $this->forum_access);
     $this->utils->setDebugMessage(__CLASS__, 'forum_type', $forum_type);
     return $this->forum_access;
 }

 /**
  * Get count of users belonging to certain groups and matching criteria
  * Temporary solution
  *
  * @param  int             $groups IDs of groups
  * @param  CriteriaElement $criteria
  * @return int             count of users
  */
 public function getUserCountByGroupLink($groups, CriteriaElement $criteria = null)
 {
     $ret = 0;
     $criteriaCompo = new CriteriaCompo();
     $sql = 'SELECT DISTINCT COUNT(u.uid) ' . ' FROM ' . $this->userHandler->db->prefix('users') . ' AS u' . ' LEFT JOIN ' . $this->membershipHandler->db->prefix('groups_users_link') . ' AS m ON m.uid = u.uid' . ' WHERE ';
     if (!empty($groups)) {
         $criteriaCompo->add(new Criteria('m.groupid', '(' . implode(', ', $groups) . ')', 'IN'));
     }
     if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
         $criteriaCompo->add($criteria);
     }
     $sql_criteria = $criteriaCompo->render();
     if ($sql_criteria) {
         $sql .= $sql_criteria;
     } else {
         $sql .= '1 = 1';
     }
     if (!($result = $this->userHandler->db->query($sql))) {
         return $ret;
     }
     list($ret) = $this->userHandler->db->fetchRow($result);
     return $ret;
 }

 function getAllSubmitted($limit = 0, $asobject = true, $checkRight = false)
 {
     $db =& Database::getInstance();
     $myts =& MyTextSanitizer::getInstance();
     $ret = array();
     $criteria = new CriteriaCompo(new Criteria('published', 0));
     if ($checkRight) {
         global $xoopsUser;
         if (!$xoopsUser) {
             return $ret;
         }
         $groups = $xoopsUser->getGroups();
         $gperm_handler =& xoops_gethandler('groupperm');
         global $xoopsModule;
         if (!isset($xoopsModule) || $xoopsModule->getVar('dirname') != "AMS") {
             $module_handler =& xoops_gethandler('module');
             $newsmodule =& $module_handler->getByDirname('AMS');
         } else {
             $newsmodule =& $xoopsModule;
         }
         $allowedtopics = $gperm_handler->getItemIds('ams_approve', $groups, $newsmodule->getVar('mid'));
         if (count($allowedtopics) == 0) {
             return $ret;
         }
         $criteria2 = new CriteriaCompo();
         $criteria2->add(new Criteria('topicid', "(" . implode(',', $allowedtopics) . ")", 'IN'));
         $criteria->add($criteria2);
     }
     $criteria->setOrder('DESC');
     $criteria->setSort('created');
     $sql = "SELECT * FROM " . $db->prefix("ams_article") . " n, " . $db->prefix("ams_text") . " t WHERE n.storyid=t.storyid AND t.current=1";
     $sql .= ' AND ' . $criteria->render();
     $result = $db->query($sql, $limit, 0);
     while ($myrow = $db->fetchArray($result)) {
         if ($asobject) {
             $ret[] = new AmsStory($myrow);
         } else {
             $ret[$myrow['storyid']] = $myts->htmlSpecialChars($myrow['title']);
         }
     }
     return $ret;
 }

function xnptoolGetAdvancedSearchQuery(&$where, &$join)
{
    global $xoopsDB;
    $formdata =& xoonips_getutility('formdata');
    $tool_table = $xoopsDB->prefix('xnptool_item_detail');
    $tool_developer_table = $xoopsDB->prefix('xnptool_developer');
    $file_table = $xoopsDB->prefix('xoonips_file');
    $search_text_table = $xoopsDB->prefix('xoonips_search_text');
    $wheres = array();
    $joins = array();
    $w = xnpGetBasicInformationAdvancedSearchQuery('xnptool');
    if ($w) {
        $wheres[] = $w;
    }
    $w = xnpGetKeywordQuery($tool_table . '.tool_type', 'xnptool_tool_type');
    if ($w) {
        $wheres[] = $w;
    }
    $w = xnpGetKeywordQuery($tool_developer_table . '.developer', 'xnptool_developer');
    if ($w) {
        $wheres[] = $w;
    }
    $w = xnpGetKeywordQuery($file_table . '.caption', 'xnptool_caption');
    if ($w) {
        $wheres[] = $w;
        $wheres[] = " {$file_table}.file_type_id = 1";
    }
    $xnptool_tool_file = $formdata->getValue('post', 'xnptool_tool_file', 's', false);
    if (!empty($xnptool_tool_file)) {
        $search_text_table = $xoopsDB->prefix('xoonips_search_text');
        $file_table = $xoopsDB->prefix('xoonips_file');
        $searchutil =& xoonips_getutility('search');
        $fulltext_query = $xnptool_tool_file;
        $fulltext_encoding = mb_detect_encoding($fulltext_query);
        $fulltext_criteria = new CriteriaCompo($searchutil->getFulltextSearchCriteria('search_text', $fulltext_query, $fulltext_encoding, $search_text_table));
        $fulltext_criteria->add(new Criteria('is_deleted', 0, '=', $file_table));
        $wheres[] = $fulltext_criteria->render();
    }
    $where = implode(' AND ', $wheres);
    $join = " INNER JOIN {$tool_developer_table} ON " . $tool_developer_table . '.tool_id  = ' . $xoopsDB->prefix('xoonips_item_basic') . '.item_id ';
}