function fetch()
{
parent::fetch();
if (isset($_REQUEST['target'])) {
$this->mNavi->addExtra('target', xoops_getrequest('target'));
}
$this->_mCriteria->addSort($this->getSort(), $this->getOrder());
}
function fetch()
{
parent::fetch();
$root =& XCube_Root::getSingleton();
$image_display = $root->mContext->mRequest->getRequest('image_display');
$imgcat_id = $root->mContext->mRequest->getRequest('imgcat_id');
$option_field = $root->mContext->mRequest->getRequest('option_field');
$option_field2 = $root->mContext->mRequest->getRequest('option_field2');
$search = $root->mContext->mRequest->getRequest('search');
if (isset($_REQUEST['image_display'])) {
$this->mNavi->addExtra('image_display', xoops_getrequest('image_display'));
$this->_mCriteria->add(new Criteria('image_display', xoops_getrequest('image_display')));
}
if (isset($_REQUEST['imgcat_id'])) {
$this->mNavi->addExtra('imgcat_id', xoops_getrequest('imgcat_id'));
$this->_mCriteria->add(new Criteria('imgcat_id', xoops_getrequest('imgcat_id')));
}
if (isset($_REQUEST['option_field'])) {
$this->mNavi->addExtra('option_field', $option_field);
$this->mOptionField = $option_field;
if ($this->mOptionField == "visible") {
$this->_mCriteria->add(new Criteria('image_display', '1'));
} elseif ($this->mOptionField == "invisible") {
$this->_mCriteria->add(new Criteria('image_display', '0'));
} else {
//all
}
}
if (isset($_REQUEST['option_field2'])) {
$this->mNavi->addExtra('option_field2', $option_field2);
$this->mOptionField2 = $option_field2;
if ($this->mOptionField2 == "gif") {
$this->_mCriteria->add(new Criteria('image_mimetype', 'image/gif'));
} elseif ($this->mOptionField2 == "png") {
$this->_mCriteria->add(new Criteria('image_mimetype', 'image/png'));
} elseif ($this->mOptionField2 == "jpeg") {
$cri = new CriteriaCompo();
$cri->add(new Criteria('image_mimetype', 'image/jpeg'));
$cri->add(new Criteria('image_mimetype', 'image/pjpeg'), 'OR');
$this->_mCriteria->add($cri);
} else {
//all
}
}
//
if (!empty($search)) {
$this->mKeyword = $search;
$this->mNavi->addExtra('search', $this->mKeyword);
$this->_mCriteria->add(new Criteria('image_nicename', '%' . $this->mKeyword . '%', 'LIKE'));
}
$this->_mCriteria->addSort($this->getSort(), $this->getOrder());
/*
if (abs($this->mSort) != IMAGE_SORT_KEY_IMAGE_WEIGHT) {
$this->_mCriteria->addSort($this->mSortKeys[IMAGE_SORT_KEY_IMAGE_WEIGHT], $this->getOrder());
}
*/
}
function fetch()
{
parent::fetch();
$this->mNavi->addExtra('target', xoops_getrequest('target'));
if (isset($_REQUEST['imgcat_id'])) {
$this->mNavi->addExtra('imgcat_id', xoops_getrequest('imgcat_id'));
$this->_mCriteria->add(new Criteria('imgcat_id', array(XOBJ_DTYPE_INT, xoops_getrequest('imgcat_id'))));
} else {
$this->_mCriteria->add(new Criteria('imgcat_id', 0));
}
$this->_mCriteria->add(new Criteria('image_display', 1));
$this->_mCriteria->addSort($this->getSort(), $this->getOrder());
if (abs($this->mSort) != IMAGE_SORT_KEY_IMAGE_WEIGHT) {
$this->_mCriteria->addSort(IMAGE_SORT_KEY_IMAGE_WEIGHT, $this->getOrder());
}
}
function fetch()
{
parent::fetch();
$root =& XCube_Root::getSingleton();
$code = $root->mContext->mRequest->getRequest('code');
$smile_url = $root->mContext->mRequest->getRequest('smile_url');
$emotion = $root->mContext->mRequest->getRequest('emotion');
$display = $root->mContext->mRequest->getRequest('display');
$option_field = $root->mContext->mRequest->getRequest('option_field');
$search = $root->mContext->mRequest->getRequest('search');
if (isset($_REQUEST['code'])) {
$this->mNavi->addExtra('code', xoops_getrequest('code'));
$this->_mCriteria->add(new Criteria('code', xoops_getrequest('code')));
}
if (isset($_REQUEST['smile_url'])) {
$this->mNavi->addExtra('smile_url', xoops_getrequest('smile_url'));
$this->_mCriteria->add(new Criteria('smile_url', xoops_getrequest('smile_url')));
}
if (isset($_REQUEST['emotion'])) {
$this->mNavi->addExtra('emotion', xoops_getrequest('emotion'));
$this->_mCriteria->add(new Criteria('emotion', xoops_getrequest('emotion')));
}
if (isset($_REQUEST['display'])) {
$this->mNavi->addExtra('display', xoops_getrequest('display'));
$this->_mCriteria->add(new Criteria('display', xoops_getrequest('display')));
}
if (isset($_REQUEST['option_field'])) {
$this->mNavi->addExtra('option_field', xoops_getrequest('option_field'));
$this->mOptionField = $option_field;
if ($this->mOptionField == "visible") {
$this->_mCriteria->add(new Criteria('display', '1'));
} elseif ($this->mOptionField == "invisible") {
$this->_mCriteria->add(new Criteria('display', '0'));
} else {
//all
}
}
//
if (!empty($search)) {
$this->mKeyword = $search;
$this->mNavi->addExtra('search', $this->mKeyword);
$search_criteria = new CriteriaCompo(new Criteria('code', '%' . $this->mKeyword . '%', 'LIKE'));
$search_criteria->add(new Criteria('emotion', '%' . $this->mKeyword . '%', 'LIKE'), $condition = 'OR');
$this->_mCriteria->add($search_criteria);
}
$this->_mCriteria->addSort($this->getSort(), $this->getOrder());
}
function fetch()
{
parent::fetch();
$root =& XCube_Root::getSingleton();
$imgcat_name = $root->mContext->mRequest->getRequest('imgcat_name');
$imgcat_display = $root->mContext->mRequest->getRequest('imgcat_display');
$imgcat_type = $root->mContext->mRequest->getRequest('imgcat_type');
$imgcat_storetype = $root->mContext->mRequest->getRequest('imgcat_storetype');
$option_field = $root->mContext->mRequest->getRequest('option_field');
$option_field2 = $root->mContext->mRequest->getRequest('option_field2');
$search = $root->mContext->mRequest->getRequest('search');
if (isset($_REQUEST['imgcat_name'])) {
$this->mNavi->addExtra('imgcat_name', xoops_getrequest('imgcat_name'));
$this->_mCriteria->add(new Criteria('imgcat_name', xoops_getrequest('imgcat_name')));
}
if (isset($_REQUEST['imgcat_display'])) {
$this->mNavi->addExtra('imgcat_display', xoops_getrequest('imgcat_display'));
$this->_mCriteria->add(new Criteria('imgcat_display', xoops_getrequest('imgcat_display')));
}
if (isset($_REQUEST['imgcat_type'])) {
$this->mNavi->addExtra('imgcat_type', xoops_getrequest('imgcat_type'));
$this->_mCriteria->add(new Criteria('imgcat_type', xoops_getrequest('imgcat_type')));
}
if (isset($_REQUEST['imgcat_storetype'])) {
$this->mNavi->addExtra('imgcat_storetype', xoops_getrequest('imgcat_storetype'));
$this->_mCriteria->add(new Criteria('imgcat_storetype', xoops_getrequest('imgcat_storetype')));
}
if (isset($_REQUEST['option_field'])) {
$this->mNavi->addExtra('option_field', xoops_getrequest('option_field'));
$this->mOptionField = $option_field;
if ($this->mOptionField == "visible") {
$this->_mCriteria->add(new Criteria('imgcat_display', xoops_getrequest('1')));
} elseif ($this->mOptionField == "invisible") {
$this->_mCriteria->add(new Criteria('imgcat_display', xoops_getrequest('0')));
} else {
//all
}
}
if (isset($_REQUEST['option_field2'])) {
$this->mNavi->addExtra('option_field2', xoops_getrequest('option_field2'));
$this->mOptionField2 = $option_field2;
if ($this->mOptionField2 == "file") {
$this->_mCriteria->add(new Criteria('imgcat_storetype', xoops_getrequest('file')));
} elseif ($this->mOptionField2 == "db") {
$this->_mCriteria->add(new Criteria('imgcat_storetype', xoops_getrequest('db')));
} else {
//all
}
}
//
if (!empty($search)) {
$this->mKeyword = $search;
$this->mNavi->addExtra('search', $this->mKeyword);
$this->_mCriteria->add(new Criteria('imgcat_name', '%' . $this->mKeyword . '%', 'LIKE'));
}
//
// Set sort conditions.
//
$this->_mCriteria->addSort($this->getSort(), $this->getOrder());
if (abs($this->mSort) != IMAGECATEGORY_SORT_KEY_IMGCAT_WEIGHT) {
$this->_mCriteria->addSort($this->mSortKeys[IMAGECATEGORY_SORT_KEY_IMGCAT_WEIGHT], $this->getOrder());
}
}
function fetch()
{
parent::fetch();
$root =& XCube_Root::getSingleton();
$mid = $root->mContext->mRequest->getRequest('mid');
$side = $root->mContext->mRequest->getRequest('side');
$weight = $root->mContext->mRequest->getRequest('weight');
$block_type = $root->mContext->mRequest->getRequest('block_type');
$c_type = $root->mContext->mRequest->getRequest('c_type');
$dirname = $root->mContext->mRequest->getRequest('dirname');
$search = $root->mContext->mRequest->getRequest('search');
$option_field = $root->mContext->mRequest->getRequest('option_field');
if (isset($_REQUEST['mid'])) {
$this->mNavi->addExtra('mid', xoops_getrequest('mid'));
$this->_mCriteria->add(new Criteria('mid', xoops_getrequest('mid')));
}
if (isset($_REQUEST['side'])) {
$this->mNavi->addExtra('side', xoops_getrequest('side'));
$this->_mCriteria->add(new Criteria('side', xoops_getrequest('side')));
}
if (isset($_REQUEST['weight'])) {
$this->mNavi->addExtra('weight', xoops_getrequest('weight'));
$this->_mCriteria->add(new Criteria('weight', xoops_getrequest('weight')));
}
if (isset($_REQUEST['block_type'])) {
$this->mNavi->addExtra('block_type', xoops_getrequest('block_type'));
$this->_mCriteria->add(new Criteria('block_type', xoops_getrequest('block_type')));
}
if (isset($_REQUEST['c_type'])) {
$this->mNavi->addExtra('c_type', xoops_getrequest('c_type'));
$this->_mCriteria->add(new Criteria('c_type', xoops_getrequest('c_type')));
}
if (isset($_REQUEST['dirname']) and !$_REQUEST['dirname'] == 0) {
if (intval($dirname) == -1) {
$this->_mCriteria->add(new Criteria('block_type', 'C'));
$this->mModule = "cblock";
} else {
$this->_mCriteria->add(new Criteria('dirname', xoops_getrequest('dirname')));
//wanikoo
$handler =& xoops_gethandler('module');
$this->mModule =& $handler->getByDirname($dirname);
}
$this->mNavi->addExtra('dirname', xoops_getrequest('dirname'));
}
if (isset($_REQUEST['search'])) {
$this->mKeyword = $search;
$this->mNavi->addExtra('search', $this->mKeyword);
$this->_mCriteria->add(new Criteria('name', '%' . $this->mKeyword . '%', 'LIKE'));
}
if (isset($_REQUEST['option_field'])) {
$this->mOptionField = $option_field;
if ($this->mOptionField != "all") {
$this->_mCriteria->add(new Criteria('side', intval($this->mOptionField)));
}
$this->mNavi->addExtra('option_field', $this->mOptionField);
}
//
$this->_mCriteria->add(new Criteria('visible', $this->_getVisible()));
$this->_mCriteria->add(new Criteria('isactive', 1));
//
// Set sort conditions.
//
$this->_mCriteria->addSort($this->getSort(), $this->getOrder());
//
// If the sort key is mid, set c_type to second sort key for list display.
//
if (abs($this->mSort) == NEWBLOCKS_SORT_KEY_MID) {
$this->_mCriteria->addSort('c_type', $this->getOrder());
}
if (abs($this->mSort) != NEWBLOCKS_SORT_KEY_SIDE) {
$this->_mCriteria->addSort('side', $this->getOrder());
}
if (abs($this->mSort) != NEWBLOCKS_SORT_KEY_WEIGHT) {
$this->_mCriteria->addSort('weight', $this->getOrder());
}
}
function fetch()
{
parent::fetch();
$root =& XCube_Root::getSingleton();
$com_modid = $root->mContext->mRequest->getRequest('com_modid');
$dirname = $root->mContext->mRequest->getRequest('dirname');
$com_icon = $root->mContext->mRequest->getRequest('com_icon');
$com_uid = $root->mContext->mRequest->getRequest('com_uid');
$com_ip = $root->mContext->mRequest->getRequest('com_ip');
$com_status = $root->mContext->mRequest->getRequest('com_status');
$keyword = $root->mContext->mRequest->getRequest('keyword');
$search_field = $root->mContext->mRequest->getRequest('search_field');
if (isset($_REQUEST['com_modid']) && intval(xoops_getrequest('com_modid')) > 0) {
$this->mNavi->addExtra('com_modid', xoops_getrequest('com_modid'));
$this->_mCriteria->add(new Criteria('com_modid', xoops_getrequest('com_modid')));
} elseif (isset($_REQUEST['dirname'])) {
$this->mNavi->addExtra('dirname', xoops_getrequest('dirname'));
$handler =& xoops_gethandler('module');
$module =& $handler->getByDirname(xoops_getrequest('dirname'));
if (is_object($module)) {
$this->_mCriteria->add(new Criteria('com_modid', $module->get('mid')));
}
}
if (isset($_REQUEST['com_icon'])) {
$this->mNavi->addExtra('com_icon', xoops_getrequest('com_icon'));
$this->_mCriteria->add(new Criteria('com_icon', xoops_getrequest('com_icon')));
}
if (isset($_REQUEST['com_uid'])) {
$this->mNavi->addExtra('com_uid', xoops_getrequest('com_uid'));
$this->_mCriteria->add(new Criteria('com_uid', xoops_getrequest('com_uid')));
}
if (isset($_REQUEST['com_ip'])) {
$this->mNavi->addExtra('com_ip', xoops_getrequest('com_ip'));
$this->_mCriteria->add(new Criteria('com_ip', xoops_getrequest('com_ip')));
}
if (xoops_getrequest('com_status') > 0) {
$this->mNavi->addExtra('com_status', xoops_getrequest('com_status'));
$this->_mCriteria->add(new Criteria('com_status', xoops_getrequest('com_status')));
}
//wanikoo
if (!empty($keyword) && isset($search_field)) {
$this->mKeyword = $keyword;
$this->mSearchField = $search_field;
$this->mNavi->addExtra('keyword', $this->mKeyword);
$this->mNavi->addExtra('search_field', $this->mSearchField);
if ($this->mSearchField == "com_both") {
//title or text ( OR condition )
$search_criteria = new CriteriaCompo(new Criteria('com_title', '%' . $this->mKeyword . '%', 'LIKE'));
$search_criteria->add(new Criteria('com_text', '%' . $this->mKeyword . '%', 'LIKE'), $condition = 'OR');
$this->_mCriteria->add($search_criteria);
} elseif ($this->mSearchField == "com_title") {
//only search about title
$this->_mCriteria->add(new Criteria('com_title', '%' . $this->mKeyword . '%', 'LIKE'));
} elseif ($this->mSearchField == "com_text") {
//only search about text
$this->_mCriteria->add(new Criteria('com_text', '%' . $this->mKeyword . '%', 'LIKE'));
} elseif ($this->mSearchField == "com_uid") {
//search about uname
if ($this->mKeyword != "guest") {
//in case of member
$cm_handler =& xoops_gethandler('member');
$cm_user =& $cm_handler->getUsers(new Criteria('uname', $this->mKeyword));
if (count($cm_user) == 1 && is_object($cm_user[0])) {
$cm_user_uid = $cm_user[0]->getVar('uid');
$this->_mCriteria->add(new Criteria('com_uid', $cm_user_uid));
} else {
//no match
$this->_mCriteria->add(new Criteria('com_uid', -1));
}
} else {
//in case of guest, please customize keyword,"guest"
$this->_mCriteria->add(new Criteria('com_uid', 0));
}
} else {
//default(only search about title)
$this->_mCriteria->add(new Criteria('com_title', '%' . $this->mKeyword . '%', 'LIKE'));
}
}
$this->_mCriteria->addSort($this->getSort(), $this->getOrder());
}
