Example #1
0
    public function search($queries, $andor, $limit, $start, $userid)
    {
        $xoops = Xoops::getInstance();
        $alumni = Alumni::getInstance();
        $myts = MyTextSanitizer::getInstance();
        $by_cat = Request::getInt('by_cat', '');
        $andor = Request::getWord('andor', 'AND');
        $queries = array();
        $query = Request::getString('query', '');
        $start = Request::getInt('start', '0');
        $helper = $xoops->getModuleHelper('alumni');
        $module_id = $helper->getModule()->getVar('mid');
        $listingHandler = $helper->getHandler('listing');
        $groups = $xoops->getUserGroups();
        $alumni_ids = $xoops->getHandlerGroupperm()->getItemIds('alumni_view', $groups, $module_id);
        $all_ids = implode(', ', $alumni_ids);
        $criteria = new CriteriaCompo();
        $criteria->add(new Criteria('valid', 1, '='));
        //  $criteria->add(new Criteria('date', time(), '<='));
        $criteria->add(new Criteria('cid', '(' . $all_ids . ')', 'IN'));
        if ($userid != 0) {
            $criteria->add(new Criteria('usid', $userid, '='));
        }
        if ($by_cat) {
            $criteria->add(new Criteria('cid', $by_cat, '='));
        }
        $queries = array($query);
        $queries = implode('+', $queries);
        $count = 0;
        $i = 0;
        $criteria->add(new Criteria('name', '%' . $queries . '%', 'LIKE'), 'AND');
        $criteria->add(new Criteria('mname', '%' . $queries . '%', 'LIKE'), 'OR');
        $criteria->add(new Criteria('lname', '%' . $queries . '%', 'LIKE'), 'OR');
        $criteria->add(new Criteria('school', '%' . $queries . '%', 'LIKE'), 'OR');
        $criteria->add(new Criteria('year', '%' . $queries . '%', 'LIKE'), 'OR');
        $criteria->setLimit($limit);
        $criteria->setSort('date');
        $criteria->setOrder('DESC');
        $criteria->setStart($start);
        $numrows = $listingHandler->getCount();
        $this_search = $listingHandler->getall($criteria);
        $ret = array();
        $k = 0;
        foreach ($this_search as $obj) {
            $ret[$k]['image'] = 'images/cat/default.gif';
            $ret[$k]['link'] = 'listing.php?lid=' . $obj->getVar('lid') . '';
            $ret[$k]['title'] = $obj->getVar('name') . ' ' . $obj->getVar('mname') . ' ' . $obj->getVar('lname') . '   ---   ' . $obj->getVar('school') . '
		---   ' . $obj->getVar('year');
            $ret[$k]['time'] = $obj->getVar('date');
            $ret[$k]['uid'] = $obj->getVar('usid');
            $k++;
        }
        return $ret;
    }
Example #2
0
 * @package         core
 * @since           2.0.0
 * @author          Kazumi Ono (AKA onokazu)
 * @author          Taiwen Jiang <*****@*****.**>
 * @version         $Id$
 */
include dirname(dirname(__DIR__)) . '/mainfile.php';
$search = Search::getInstance();
if (!$search->getConfig('enable_search')) {
    header('Location: ' . XOOPS_URL . '/index.php');
    exit;
}
$xoops = Xoops::getInstance();
$action = Request::getCmd('action', 'search');
$query = Request::getString('query', '');
$andor = Request::getWord('andor', 'AND');
$mid = Request::getInt('mid', 0);
$uid = Request::getInt('uid', 0);
$start = Request::getInt('start', 0);
$mids = Request::getArray('mids', array());
$queries = array();
if ($action === "results") {
    if ($query == "") {
        $xoops->redirect("index.php", 1, _MD_SEARCH_PLZENTER);
    }
} else {
    if ($action === "showall") {
        if ($query == "" || empty($mid)) {
            $xoops->redirect("index.php", 1, _MD_SEARCH_PLZENTER);
        }
    } else {
Example #3
0
     if ($user_type == 'inactv') {
         $criteria->add(new Criteria('level', 0, '='));
     } elseif ($user_type == "actv") {
         $criteria->add(new Criteria('level', 0, '>'));
     }
     $requete_search .= 'actif ou inactif : ' . $user_type . '<br />';
     $requete_pagenav .= '&amp;user_type=' . $user_type;
 }
 //$groups = empty($_REQUEST['selgroups']) ? array() : array_map("intval", $_REQUEST['selgroups']);
 $validsort = array("uname", "email", "last_login", "user_regdate", "posts");
 $sort = (string) Request::getWord('user_sort', 'user_regdate');
 $sort = !in_array($sort, $validsort) ? "user_regdate" : $sort;
 $requete_pagenav .= '&amp;user_sort=' . $sort;
 $requete_search .= 'order by : ' . $sort . '<br />';
 $criteria->setSort($sort);
 $order = (string) Request::getWord('user_order', 'DESC');
 $requete_pagenav .= '&amp;user_order=' . $order;
 $requete_search .= 'tris : ' . $order . '<br />';
 $criteria->setOrder($order);
 $user_limit = $xoops->getModuleConfig('users_pager', 'system');
 if (isset($_REQUEST['user_limit'])) {
     $user_limit = $_REQUEST['user_limit'];
     $requete_pagenav .= '&amp;user_limit=' . htmlspecialchars($_REQUEST['user_limit']);
     $requete_search .= 'limit : ' . $user_limit . '<br />';
 } else {
     $requete_pagenav .= '&amp;user_limit=' . $xoops->getModuleConfig('users_pager', 'system');
     $requete_search .= 'limit : ' . $user_limit . '<br />';
 }
 $start = !empty($_REQUEST['start']) ? (int) $_REQUEST['start'] : 0;
 if (isset($_REQUEST['selgroups'])) {
     if ($_REQUEST['selgroups'] != 0) {
Example #4
0
     if ($user_type === 'inactv') {
         $criteria->add(new Criteria('level', 0, '='));
     } elseif ($user_type === "actv") {
         $criteria->add(new Criteria('level', 0, '>'));
     }
     $requete_search .= 'actif ou inactif : ' . $user_type . '<br />';
     $requete_pagenav .= '&amp;user_type=' . $user_type;
 }
 //$groups = empty($_REQUEST['selgroups']) ? array() : array_map("intval", $_REQUEST['selgroups']);
 $validsort = array("uname", "email", "last_login", "user_regdate", "posts");
 $sort = Request::getWord('user_sort', 'user_regdate');
 $sort = !in_array($sort, $validsort) ? "user_regdate" : $sort;
 $requete_pagenav .= '&amp;user_sort=' . $sort;
 $requete_search .= 'order by : ' . $sort . '<br />';
 $criteria->setSort($sort);
 $order = Request::getWord('user_order', 'DESC');
 $requete_pagenav .= '&amp;user_order=' . $order;
 $requete_search .= 'tris : ' . $order . '<br />';
 $criteria->setOrder($order);
 $user_limit = $xoops->getModuleConfig('users_pager', 'system');
 if (isset($_REQUEST['user_limit'])) {
     $user_limit = $_REQUEST['user_limit'];
     $requete_pagenav .= '&amp;user_limit=' . $myts->htmlSpecialChars($_REQUEST['user_limit']);
     $requete_search .= 'limit : ' . $user_limit . '<br />';
 } else {
     $requete_pagenav .= '&amp;user_limit=' . $xoops->getModuleConfig('users_pager', 'system');
     $requete_search .= 'limit : ' . $user_limit . '<br />';
 }
 $start = !empty($_REQUEST['start']) ? (int) $_REQUEST['start'] : 0;
 if (isset($_REQUEST['selgroups'])) {
     if ($_REQUEST['selgroups'] != 0) {
Example #5
0
/**
 * Module Images
 *
 * @copyright       XOOPS Project (http://xoops.org)
 * @license         GNU GPL 2 or later (http://www.gnu.org/licenses/gpl-2.0.html)
 * @package         Images
 * @since           2.6.0
 * @version         $Id$
 */
include dirname(dirname(__DIR__)) . '/mainfile.php';
$xoops = Xoops::getInstance();
$helper = Images::getInstance();
$helper->loadLanguage('main');
$helper->loadLanguage('admin');
$op = Request::getCmd('op', 'list');
$target = Request::getWord('target', '');
$imgcat_id = Request::getInt('imgcat_id', 0);
$start = Request::getInt('start', 0);
if (empty($target)) {
    exit('Target not set');
}
$groups = $xoops->getUserGroups();
$xoops->simpleHeader();
$xoopsTpl = new XoopsTpl();
$xoopsTpl->assign('sitename', htmlspecialchars($xoops->getConfig('sitename'), ENT_QUOTES));
$xoopsTpl->assign('target', htmlspecialchars($target, ENT_QUOTES));
switch ($op) {
    case 'list':
    default:
        // Category Select form
        $param = array('imgcat_id' => $imgcat_id, 'target' => $target);
Example #6
0
 /**
  * @covers Xoops\Core\Request::getWord
  */
 public function testGetWord()
 {
     $varname = 'RequestTest';
     $_REQUEST[$varname] = 'Lorem';
     $this->assertEquals('Lorem', Request::getWord($varname));
     $_REQUEST[$varname] = 'Lorem ipsum 88 59';
     $this->assertEquals('Loremipsum', Request::getWord($varname));
     $_REQUEST[$varname] = '.99 Lorem_ipsum @%&';
     $this->assertEquals('Lorem_ipsum', Request::getWord($varname));
     //echo Request::getWord($varname);
 }