function fetch() { parent::fetch(); $this->_mCriteria->add(new Criteria('avatar_display', 1)); $this->_mCriteria->add(new Criteria('avatar_type', 'S')); }
function fetch() { parent::fetch(); $root =& XCube_Root::getSingleton(); $rank_special = $root->mContext->mRequest->getRequest('rank_special'); $option_field = $root->mContext->mRequest->getRequest('option_field'); $search = $root->mContext->mRequest->getRequest('search'); if (isset($_REQUEST['rank_special'])) { $this->mNavi->addExtra('rank_special', xoops_getrequest('rank_special')); $this->_mCriteria->add(new Criteria('rank_special', xoops_getrequest('rank_special'))); } if (isset($_REQUEST['option_field'])) { $this->mNavi->addExtra('option_field', xoops_getrequest('option_field')); $this->mOptionField = $option_field; if ($this->mOptionField == "special") { //only system avatar $this->_mCriteria->add(new Criteria('rank_special', '1')); } elseif ($this->mOptionField == "normal") { //only custom avatar $this->_mCriteria->add(new Criteria('rank_special', '0')); } else { //all } } // if (!empty($search)) { $this->mKeyword = $search; $this->mNavi->addExtra('search', $this->mKeyword); $this->_mCriteria->add(new Criteria('rank_title', '%' . $this->mKeyword . '%', 'LIKE')); } $this->_mCriteria->addSort($this->getSort(), $this->getOrder()); }
function fetch() { parent::fetch(); if (isset($_REQUEST['mailjob_id'])) { $this->mNavi->addExtra('mailjob_id', xoops_getrequest('mailjob_id')); $this->_mCriteria->add(new Criteria('mailjob_id', xoops_getrequest('mailjob_id'))); } $this->_mCriteria->addSort($this->getSort(), $this->getOrder()); }
function fetch() { parent::fetch(); if (isset($_REQUEST['groupid'])) { $this->mNavi->addExtra('groupid', xoops_getrequest('groupid')); $this->_mCriteria->add(new Criteria('groupid', xoops_getrequest('groupid'))); } if (isset($_REQUEST['name'])) { $this->mNavi->addExtra('name', xoops_getrequest('name')); $this->_mCriteria->add(new Criteria('name', xoops_getrequest('name'))); } if (isset($_REQUEST['group_type'])) { $this->mNavi->addExtra('group_type', xoops_getrequest('group_type')); $this->_mCriteria->add(new Criteria('group_type', xoops_getrequest('group_type'))); } $this->_mCriteria->addSort($this->getSort(), $this->getOrder()); }
function fetch() { parent::fetch(); if (isset($_REQUEST['title'])) { // // TODO like // $this->mNavi->addExtra('title', xoops_getrequest('title')); $this->_mCriteria->add(new Criteria('title', array(XOBJ_DTYPE_STRING, xoops_getrequest('title')))); } if (isset($_REQUEST['is_pm'])) { $this->mNavi->addExtra('is_pm', xoops_getrequest('is_pm')); $this->_mCriteria->add(new Criteria('is_pm', xoops_getrequest('is_pm'))); } if (isset($_REQUEST['is_mail'])) { $this->mNavi->addExtra('is_mail', xoops_getrequest('is_mail')); $this->_mCriteria->add(new Criteria('is_mail', xoops_getrequest('is_mail'))); } $this->_mCriteria->addSort($this->getSort(), $this->getOrder()); }
function fetch() { parent::fetch(); $root =& XCube_Root::getSingleton(); $uid = $root->mContext->mRequest->getRequest('uid'); $email = $root->mContext->mRequest->getRequest('email'); $attachsig = $root->mContext->mRequest->getRequest('attachsig'); $rank = $root->mContext->mRequest->getRequest('rank'); $level = $root->mContext->mRequest->getRequest('level'); $timezone_offset = $root->mContext->mRequest->getRequest('timezone_offset'); $user_mailok = $root->mContext->mRequest->getRequest('user_mailok'); $option_field = $root->mContext->mRequest->getRequest('option_field'); $search = $root->mContext->mRequest->getRequest('search'); if (isset($_REQUEST['uid'])) { $this->mNavi->addExtra('uid', xoops_getrequest('uid')); $this->_mCriteria->add(new Criteria('uid', xoops_getrequest('uid'))); } if (isset($_REQUEST['email'])) { $this->mNavi->addExtra('email', xoops_getrequest('email')); $this->_mCriteria->add(new Criteria('email', xoops_getrequest('email'))); } if (isset($_REQUEST['attachsig'])) { $this->mNavi->addExtra('attachsig', xoops_getrequest('attachsig')); $this->_mCriteria->add(new Criteria('attachsig', xoops_getrequest('attachsig'))); } if (isset($_REQUEST['rank'])) { $this->mNavi->addExtra('rank', xoops_getrequest('rank')); $this->_mCriteria->add(new Criteria('rank', xoops_getrequest('rank'))); } if (isset($_REQUEST['level'])) { $this->mNavi->addExtra('level', xoops_getrequest('level')); $this->_mCriteria->add(new Criteria('level', xoops_getrequest('level'))); } if (isset($_REQUEST['timezone_offset'])) { $this->mNavi->addExtra('timezone_offset', xoops_getrequest('timezone_offset')); $this->_mCriteria->add(new Criteria('timezone_offset', xoops_getrequest('timezone_offset'))); } if (isset($_REQUEST['user_mailok'])) { $this->mNavi->addExtra('user_mailok', xoops_getrequest('user_mailok')); $this->_mCriteria->add(new Criteria('user_mailok', xoops_getrequest('user_mailok'))); } //wanikoo if (isset($_REQUEST['option_field'])) { $this->mNavi->addExtra('option_field', xoops_getrequest('option_field')); $this->mOptionField = $option_field; if ( $option_field == "inactive" ) { //only inactive users $this->_mCriteria->add(new Criteria('level', '0')); } elseif ( $option_field == "active" ) { //only active users $this->_mCriteria->add(new Criteria('level', '0', '>')); } else { //all } } // if (!empty($search)) { $this->mKeyword = $search; $this->mNavi->addExtra('search', $this->mKeyword); $this->_mCriteria->add(new Criteria('uname', '%' . $this->mKeyword . '%', 'LIKE')); } $this->_mCriteria->addSort($this->getSort(), $this->getOrder()); }
function fetch() { parent::fetch(); $root =& XCube_Root::getSingleton(); $avatar_display = $root->mContext->mRequest->getRequest('avatar_display'); $avatar_type = $root->mContext->mRequest->getRequest('avatar_type'); $option_field = $root->mContext->mRequest->getRequest('option_field'); $option_field2 = $root->mContext->mRequest->getRequest('option_field2'); $option_field3 = $root->mContext->mRequest->getRequest('option_field3'); $search = $root->mContext->mRequest->getRequest('search'); if (isset($_REQUEST['avatar_display'])) { $this->mNavi->addExtra('avatar_display', xoops_getrequest('avatar_display')); $this->_mCriteria->add(new Criteria('avatar_display', array(XOBJ_DTYPE_BOOL, xoops_getrequest('avatar_display')))); } if (isset($_REQUEST['avatar_type'])) { $this->mNavi->addExtra('avatar_type', xoops_getrequest('avatar_type')); $this->_mCriteria->add(new Criteria('avatar_type', array(XOBJ_DTYPE_STRING, xoops_getrequest('avatar_type')))); } if (isset($_REQUEST['option_field'])) { $this->mNavi->addExtra('option_field', xoops_getrequest('option_field')); $this->mOptionField = $option_field; if ( $this->mOptionField == "system" ) { //only system avatar $this->_mCriteria->add(new Criteria('avatar_type', 'S')); } elseif ( $this->mOptionField == "custom" ) { //only custom avatar $this->_mCriteria->add(new Criteria('avatar_type', 'C')); } else { //all } } if (isset($_REQUEST['option_field2'])) { $this->mNavi->addExtra('option_field2', xoops_getrequest('option_field2')); $this->mOptionField2 = $option_field2; if ( $this->mOptionField2 == "visible" ) { $this->_mCriteria->add(new Criteria('avatar_display', '1')); } elseif ( $this->mOptionField2 == "invisible" ) { $this->_mCriteria->add(new Criteria('avatar_display', '0')); } else { //all } } if (isset($_REQUEST['option_field3'])) { $this->mNavi->addExtra('option_field3', xoops_getrequest('option_field3')); $this->mOptionField3 = $option_field3; if ( $this->mOptionField3 == "gif" ) { $this->_mCriteria->add(new Criteria('avatar_mimetype', 'image/gif')); } elseif ( $this->mOptionField3 == "png" ) { $this->_mCriteria->add(new Criteria('avatar_mimetype', 'image/png')); } elseif ( $this->mOptionField3 == "jpeg" ) { $this->_mCriteria->add(new Criteria('avatar_mimetype', 'image/jpeg')); } else { //all } } // if (!empty($search)) { $this->mKeyword = $search; $this->mNavi->addExtra('search', $this->mKeyword); $this->_mCriteria->add(new Criteria('avatar_name', '%' . $this->mKeyword . '%', 'LIKE')); } $this->_mCriteria->addSort($this->getSort(), $this->getOrder()); }
function fetch() { parent::fetch(); $form =new User_UserSearchForm(); $form->prepare(); $form->fetch(); $form->validate(); if ($form->hasError()) { return; } $root =& XCube_Root::getSingleton(); foreach ($this->_mMatchFields as $field) { if (strlen($form->get($field)) > 0) { $this->mNavi->addExtra($field, $form->get($field)); $user_field_match = $root->mContext->mRequest->getRequest('user_'.$field.'_match'); $field_match = $root->mContext->mRequest->getRequest($field.'_match'); if( isset($user_field_match) || isset($field_match) ){ $formvalue = 0; if (isset($user_field_match)){ $formvalue = intval($form->get('user_'.$field.'_match')) ; $this->mNavi->addExtra('user_'.$field.'_match', $formvalue); } elseif(isset($field_match)){ $formvalue = intval($form->get($field.'_match')) ; $this->mNavi->addExtra($field.'_match', $formvalue); } switch ($formvalue) { case XOOPS_MATCH_START: $this->_mCriteria->add(new Criteria('u.' . $field, $form->get($field) . '%', 'LIKE')); break; case XOOPS_MATCH_END: $this->_mCriteria->add(new Criteria('u.' . $field, '%' . $form->get($field), 'LIKE')); break; case XOOPS_MATCH_EQUAL: $this->_mCriteria->add(new Criteria('u.' . $field, $form->get($field))); break; case XOOPS_MATCH_CONTAIN: $this->_mCriteria->add(new Criteria('u.' . $field, '%' . $form->get($field) . '%', 'LIKE')); break; } } else { $this->_mCriteria->add(new Criteria('u.' . $field, '%' . $form->get($field) . '%', 'LIKE')); } } } $this->mNavi->addExtra('mail_condition', $form->get('mail_condition')); switch ($form->get('mail_condition')) { case 1: $this->_mCriteria->add(new Criteria('u.user_mailok', 1)); break; case 2: $this->_mCriteria->add(new Criteria('u.user_mailok', 0)); break; } $this->mNavi->addExtra('user_level', $form->get('user_level')); switch ($form->get('user_level')) { case 1: $this->_mCriteria->add(new Criteria('u.level', 0, '>')); break; case 2: $this->_mCriteria->add(new Criteria('u.level', 0)); break; } if (strlen($form->get('over_posts')) > 0) { $this->mNavi->addExtra('over_posts', $form->get('over_posts')); $this->_mCriteria->add(new Criteria('u.posts', $form->get('over_posts'), '>=')); } if (strlen($form->get('under_posts')) > 0) { $this->mNavi->addExtra('under_posts', $form->get('under_posts')); $this->_mCriteria->add(new Criteria('u.posts', $form->get('under_posts'), '<=')); } if (strlen($form->get('lastlog_more')) > 0) { $this->mNavi->addExtra('lastlog_more', $form->get('lastlog_more')); $time = time() - $form->get('lastlog_more') * 86400; $this->_mCriteria->add(new Criteria('u.last_login', $time, '<=')); } if (strlen($form->get('lastlog_less')) > 0) { $this->mNavi->addExtra('lastlog_less', $form->get('lastlog_less')); $time = time() - $form->get('lastlog_less') * 86400; $this->_mCriteria->add(new Criteria('u.last_login', $time, '>=')); } if (strlen($form->get('regdate_more')) > 0) { $this->mNavi->addExtra('regdate_more', $form->get('regdate_more')); $time = time() - $form->get('regdate_more') * 86400; $this->_mCriteria->add(new Criteria('u.user_regdate', $time, '<=')); } if (strlen($form->get('regdate_less')) > 0) { $this->mNavi->addExtra('regdate_less', $form->get('regdate_less')); $time = time() - $form->get('regdate_less') * 86400; $this->_mCriteria->add(new Criteria('u.user_regdate', $time, '>=')); } $groups = $form->get('groups'); if (count($groups) > 0) { $g_criteria =new CriteriaCompo(); foreach($groups as $gid) { $g_criteria->add(new Criteria('g.groupid', $gid), $condition='OR'); $this->mNavi->addExtra('groups[' . $gid . ']', $gid); } $this->_mCriteria->add($g_criteria); } $this->_mCriteria->addSort($this->getSort(), $this->getOrder()); }
function fetch() { parent::fetch(); $this->_mCriteria->addSort($this->getSort(), $this->getOrder()); }