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