XoopsModules25x / suico

search.php

<?php declare(strict_types=1);

/*
 You may not change or alter any portion of this comment or credits
 of supporting developers from this source code or any supporting source code
 which is considered copyrighted (c) material of the original comment or credit authors.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
*/

/**
 * @copyright    XOOPS Project https://xoops.org/
 * @license      GNU GPL 2 or later (http://www.gnu.org/licenses/gpl-2.0.html)
 * @author       Marcello Brandão aka  Suico
 * @author       XOOPS Development Team
 * @since
 */

use Xmf\Request;

require __DIR__ . '/header.php';

$myts   = MyTextSanitizer::getInstance();
$op     = Request::getString('op', 'search');
$groups = $xoopsUser ? $xoopsUser->getGroups() : [XOOPS_GROUP_ANONYMOUS];
switch ($op) {
    default:
    case 'search':
        $xoopsOption['cache_group']              = implode('', $groups);
        $GLOBALS['xoopsOption']['template_main'] = 'yogurt_search.tpl';
        require XOOPS_ROOT_PATH . '/header.php';

        // Dynamic fields
        $profileHandler = xoops_getModuleHandler('profile');
        // Get fields
        $fields = $profileHandler->loadFields();
        // Get ids of fields that can be searched
        $gpermHandler      = xoops_getHandler('groupperm');
        $searchable_fields = $gpermHandler->getItemIds('smartprofile_search', $groups, $xoopsModule->getVar('mid'));

The method getItemIds() does not exist on XoopsObjectHandler. It seems like you code against a sub-type of XoopsObjectHandler such as XoopsGroupPermHandler or XoopsPersistableObjectHandler.

        require_once XOOPS_ROOT_PATH . '/class/xoopsformloader.php';
        $searchform = new XoopsThemeForm('', 'searchform', 'search.php', 'post');

        $name_tray = new XoopsFormElementTray(_MD_YOGURT_PROFILE_DISPLAYNAME);

The constant _MD_YOGURT_PROFILE_DISPLAYNAME was not found. Maybe you did not declare it correctly or list all dependencies?

        $name_tray->addElement(new XoopsFormSelectMatchOption('', 'uname_match'));
        $name_tray->addElement(new XoopsFormText('', 'uname', 35, 255));
        $searchform->addElement($name_tray);
        $sortby_arr['uname'] = _MD_YOGURT_PROFILE_DISPLAYNAME;

        $email_tray = new XoopsFormElementTray(_MD_YOGURT_PROFILE_EMAIL);

The constant _MD_YOGURT_PROFILE_EMAIL was not found. Maybe you did not declare it correctly or list all dependencies?

        $email_tray->addElement(new XoopsFormSelectMatchOption('', 'email_match'));
        $email_tray->addElement(new XoopsFormText('', 'email', 35, 255));
        $searchform->addElement($email_tray);
        $sortby_arr['email'] = _MD_YOGURT_PROFILE_EMAIL;

        $searchable_types = [
            'textbox',
            'select',
            'radio',
            'yesno',
            'date',
            'datetime',
            'timezone',
            'language',
        ];
        foreach (array_keys($fields) as $i) {
            if (in_array($fields[$i]->getVar('fieldid'), $searchable_fields, true)
                && in_array(
                    $fields[$i]->getVar('field_type'),
                    $searchable_types,
                    true
                )) {
                $sortby_arr[$fields[$i]->getVar('fieldid')] = $fields[$i]->getVar('field_title');
                switch ($fields[$i]->getVar('field_type')) {
                    case 'textbox':
                        if (XOBJ_DTYPE_INT === $fields[$i]->getVar('field_valuetype')) {
                            $searchform->addElement(
                                new XoopsFormText(
                                    sprintf(
                                        _MD_YOGURT_PROFILE_LARGERTHAN,

The constant _MD_YOGURT_PROFILE_LARGERTHAN was not found. Maybe you did not declare it correctly or list all dependencies?

                                        $fields[$i]->getVar('field_title')
                                    ), $fields[$i]->getVar(
                                         'field_name'
                                     ) . '_larger', 35, 35
                                )
                            );
                            $searchform->addElement(
                                new XoopsFormText(
                                    sprintf(
                                        _MD_YOGURT_PROFILE_SMALLERTHAN,

The constant _MD_YOGURT_PROFILE_SMALLERTHAN was not found. Maybe you did not declare it correctly or list all dependencies?

                                        $fields[$i]->getVar('field_title')
                                    ), $fields[$i]->getVar(
                                         'field_name'
                                     ) . '_smaller', 35, 35
                                )
                            );
                        } else {
                            $tray = new XoopsFormElementTray($fields[$i]->getVar('field_title'));
                            $tray->addElement(
                                new XoopsFormSelectMatchOption('', $fields[$i]->getVar('field_name') . '_match')
                            );
                            $tray->addElement(
                                new XoopsFormText(
                                    '', $fields[$i]->getVar('field_name'), 35, $fields[$i]->getVar(
                                    'field_maxlength'
                                )
                                )
                            );
                            $searchform->addElement($tray);
                            unset($tray);
                        }
                        break;
                    case 'radio':
                    case 'select':
                        $size    = count($fields[$i]->getVar('field_options')) > 10 ? 10 : count(
                            $fields[$i]->getVar('field_options')
                        );
                        $element = new XoopsFormSelect(
                            $fields[$i]->getVar('field_title'), $fields[$i]->getVar(
                            'field_name'
                        ), null, $size, true
                        );
                        $options = $fields[$i]->getVar('field_options');
                        asort($options);
                        $element->addOptionArray($options);
                        $searchform->addElement($element);
                        unset($element);
                        break;
                    case 'yesno':
                        $element = new XoopsFormSelect(
                            $fields[$i]->getVar('field_title'), $fields[$i]->getVar(
                            'field_name'
                        ), null, 2, true
                        );
                        $element->addOption(1, _YES);
                        $element->addOption(0, _NO);
                        $searchform->addElement($element);
                        unset($element);
                        break;
                    case 'date':
                    case 'datetime':
                        $searchform->addElement(
                            new XoopsFormTextDateSelect(
                                sprintf(
                                    _MD_YOGURT_PROFILE_LATERTHAN,

The constant _MD_YOGURT_PROFILE_LATERTHAN was not found. Maybe you did not declare it correctly or list all dependencies?

                                    $fields[$i]->getVar('field_title')
                                ), $fields[$i]->getVar(
                                     'field_name'
                                 ) . '_larger', 15, 0
                            )
                        );
                        $searchform->addElement(
                            new XoopsFormTextDateSelect(
                                sprintf(
                                    _MD_YOGURT_PROFILE_EARLIERTHAN,

The constant _MD_YOGURT_PROFILE_EARLIERTHAN was not found. Maybe you did not declare it correctly or list all dependencies?

                                    $fields[$i]->getVar('field_title')
                                ), $fields[$i]->getVar(
                                     'field_name'
                                 ) . '_smaller', 15, time()
                            )
                        );
                        break;
                    //                    case "datetime":
                    //                        $searchform->addElement(new XoopsFormDateTime(sprintf(_MD_YOGURT_PROFILE_LATERTHAN, $fields[$i]->getVar('field_title')), $fields[$i]->getVar('field_name')."_larger", 15, 1));
                    //                        $searchform->addElement(new XoopsFormDateTime(sprintf(_MD_YOGURT_PROFILE_EARLIERTHAN, $fields[$i]->getVar('field_title')), $fields[$i]->getVar('field_name')."_smaller", 15, 0));
                    //                        break;

                    case 'timezone':
                        $element = new XoopsFormSelect(
                            $fields[$i]->getVar('field_title'), $fields[$i]->getVar(
                            'field_name'
                        ), null, 6, true
                        );
                        require_once XOOPS_ROOT_PATH . '/class/xoopslists.php';
                        $element->addOptionArray(XoopsLists::getTimeZoneList());
                        $searchform->addElement($element);
                        unset($element);
                        break;
                    case 'language':
                        $element = new XoopsFormSelectLang(
                            $fields[$i]->getVar('field_title'), $fields[$i]->getVar(
                            'field_name'
                        ), null, 6
                        );
                        $searchform->addElement($element);
                        unset($element);
                        break;
                }
            }
        }
        asort($sortby_arr);
        $sortby_select = new XoopsFormSelect(_MD_YOGURT_PROFILE_SORTBY, 'sortby');

The constant _MD_YOGURT_PROFILE_SORTBY was not found. Maybe you did not declare it correctly or list all dependencies?

        $sortby_select->addOptionArray($sortby_arr);
        $searchform->addElement($sortby_select);

        $order_select = new XoopsFormRadio(_MD_YOGURT_PROFILE_ORDER, 'order', 0);

The constant _MD_YOGURT_PROFILE_ORDER was not found. Maybe you did not declare it correctly or list all dependencies?

        $order_select->addOption(0, _ASCENDING);
        $order_select->addOption(1, _DESCENDING);
        $searchform->addElement($order_select);

        $limit_text = new XoopsFormText(_MD_YOGURT_PROFILE_PERPAGE, 'limit', 15, 10);

The constant _MD_YOGURT_PROFILE_PERPAGE was not found. Maybe you did not declare it correctly or list all dependencies?

        $searchform->addElement($limit_text);
        $searchform->addElement(new XoopsFormHidden('op', 'results'));

        $searchform->addElement(new XoopsFormButton('', 'submit', _SUBMIT, 'submit'));

        $searchform->assign($xoopsTpl);
        break;
    case 'results':
        $GLOBALS['xoopsOption']['template_main'] = 'smartprofile_results.tpl';
        require_once XOOPS_ROOT_PATH . '/header.php';

        $memberHandler = xoops_getHandler('member');
        // Dynamic fields
        $profileHandler = xoops_getModuleHandler('profile');
        // Get fields
        $fields = $profileHandler->loadFields();
        // Get ids of fields that can be searched
        $gpermHandler      = xoops_getHandler('groupperm');
        $searchable_fields = $gpermHandler->getItemIds('smartprofile_search', $groups, $xoopsModule->getVar('mid'));
        $searchvars        = [];

        $criteria = new CriteriaCompo(new Criteria('level', 0, '>'));
        if (isset($_REQUEST['uname']) && '' !== Request::getString('uname', '', 'REQUEST')) {
            $string = $myts->addSlashes(trim(Request::getString('uname', '', 'REQUEST')));
            switch ($_REQUEST['uname_match']) {
                case XOOPS_MATCH_START:
                    $string .= '%';
                    break;
                case XOOPS_MATCH_END:
                    $string = '%' . $string;
                    break;
                case XOOPS_MATCH_CONTAIN:
                    $string = '%' . $string . '%';
                    break;
            }
            $criteria->add(new Criteria('uname', $string, 'LIKE'));
            $searchvars[] = 'uname';
        }
        if (isset($_REQUEST['email']) && '' !== Request::getString('email', '', 'REQUEST')) {
            $string = $myts->addSlashes(trim(Request::getString('email', '', 'REQUEST')));
            switch (Request::getString('email_match', '', 'REQUEST')) {
                case XOOPS_MATCH_START:
                    $string .= '%';
                    break;
                case XOOPS_MATCH_END:
                    $string = '%' . $string;
                    break;
                case XOOPS_MATCH_CONTAIN:
                    $string = '%' . $string . '%';
                    break;
            }
            $searchvars[] = 'email';
            $criteria->add(new Criteria('email', $string, 'LIKE'));
            $criteria->add(new Criteria('user_viewemail', 1));
        }
        $searchable_types = [
            'textbox',
            'select',
            'radio',
            'yesno',
            'date',
            'datetime',
            'timezone',
            'language',
        ];

        foreach (array_keys($fields) as $i) {
            if (in_array($fields[$i]->getVar('fieldid'), $searchable_fields, true)
                && in_array(
                    $fields[$i]->getVar('field_type'),
                    $searchable_types,
                    true
                )) {
                $fieldname = $fields[$i]->getVar('field_name');
                if (in_array($fields[$i]->getVar('field_type'), ['select', 'radio'], true)) {
                    if (isset($_REQUEST[$fieldname]) && $_REQUEST[$fieldname]) {
                        //If field value is sent through request and is not an empty value
                        switch ($fields[$i]->getVar(
                            'field_valuetype'
                        )) {
                            case XOBJ_DTYPE_OTHER:
                            case XOBJ_DTYPE_INT:
                                $value        = array_map('\intval', $_REQUEST[$fieldname]);
                                $searchvars[] = $fieldname;
                                $criteria->add(new Criteria($fieldname, '(' . implode(',', $value) . ')', 'IN'));
                                break;
                            case XOBJ_DTYPE_URL:
                            case XOBJ_DTYPE_TXTBOX:
                            case XOBJ_DTYPE_TXTAREA:
                                $value        = array_map([$xoopsDB, 'quoteString'], $_REQUEST[$fieldname]);
                                $searchvars[] = $fieldname;
                                $criteria->add(new Criteria($fieldname, '(' . implode(',', $value) . ')', 'IN'));
                                break;
                        }
                    }
                } else {
                    switch ($fields[$i]->getVar('field_valuetype')) {
                        case XOBJ_DTYPE_OTHER:
                        case XOBJ_DTYPE_INT:
                            switch ($fields[$i]->getVar('field_type')) {
                                case 'date':
                                case 'datetime':
                                    $value = $_REQUEST[$fieldname . '_larger'];
                                    if (!($value = strtotime($_REQUEST[$fieldname . '_larger']))) {
                                        $value = (int)$_REQUEST[$fieldname . '_larger'];
                                    }
                                    if ($value > 0) {
                                        $search_url[] = $fieldname . '_larger=' . $value;
                                        $searchvars[] = $fieldname;
                                        $criteria->add(new Criteria($fieldname, $value, '>='));
                                    }

                                    $value = $_REQUEST[$fieldname . '_smaller'];
                                    if (!($value = strtotime($_REQUEST[$fieldname . '_smaller']))) {
                                        $value = (int)$_REQUEST[$fieldname . '_smaller'];
                                    }
                                    if ($value > 0) {
                                        $search_url[] = $fieldname . '_smaller=' . $value;
                                        $searchvars[] = $fieldname;
                                        $criteria->add(new Criteria($fieldname, $value, '<='));
                                    }
                                    break;
                                //                                case "datetime":
                                //                                    $value = $_REQUEST[$fieldname."_larger"]['date'];
                                //                                    if (intval($value) < 0) { //intval() of a date string is -1
                                //                                        $value = strtotime($_REQUEST[$fieldname."_larger"]['date']);
                                //                                    }
                                //                                    else {
                                //                                        $value = intval($_REQUEST[$fieldname."_larger"]['date']);
                                //                                    }
                                //                                    $search_url[] = $fieldname."_larger=".$value;
                                //                                    $searchvars[] = $fieldname;
                                //                                    $criteria->add(new Criteria($fieldname, $value, ">="));
                                //
                                //                                    $value = $_REQUEST[$fieldname."_smaller"]['date'];
                                //                                    if (intval($value) < 0) { //intval() of a date string is -1
                                //                                        $value = strtotime($_REQUEST[$fieldname."_smaller"]['date']);
                                //                                    }
                                //                                    else {
                                //                                        $value = intval($_REQUEST[$fieldname."_smaller"]['date']);
                                //                                    }
                                //                                    $search_url[] = $fieldname."_smaller=".$value;
                                //                                    $searchvars[] = $fieldname;
                                //                                    $criteria->add(new Criteria($fieldname, $value, "<="));
                                //                                    break;

                                default:
                                    if (isset($_REQUEST[$fieldname . '_larger']) && 0 !== (int)$_REQUEST[$fieldname . '_larger']) {
                                        $value        = (int)$_REQUEST[$fieldname . '_larger'];
                                        $search_url[] = $fieldname . '_larger=' . $value;
                                        $searchvars[] = $fieldname;
                                        $criteria->add(new Criteria($fieldname, $value, '>='));
                                    }

                                    if (isset($_REQUEST[$fieldname . '_smaller']) && 0 !== (int)$_REQUEST[$fieldname . '_smaller']) {
                                        $value        = (int)$_REQUEST[$fieldname . '_smaller'];
                                        $search_url[] = $fieldname . '_smaller=' . $value;
                                        $searchvars[] = $fieldname;
                                        $criteria->add(new Criteria($fieldname, $value, '<='));
                                    }
                                    break;
                            }

                            if (isset($_REQUEST[$fieldname]) && !isset($_REQUEST[$fieldname . '_smaller']) && !isset($_REQUEST[$fieldname . '_larger'])) {
                                if (!is_array($_REQUEST[$fieldname])) {
                                    $value        = (int)$_REQUEST[$fieldname];
                                    $search_url[] = $fieldname . '=' . $value;
                                    $criteria->add(new Criteria($fieldname, $value, '='));
                                } else {
                                    $value = array_map('\intval', $_REQUEST[$fieldname]);
                                    foreach ($value as $thisvalue) {
                                        $search_url[] = $fieldname . '[]=' . $thisvalue;
                                    }
                                    $criteria->add(new Criteria($fieldname, '(' . implode(',', $value) . ')', 'IN'));
                                }

                                $searchvars[] = $fieldname;
                            }
                            break;
                        case XOBJ_DTYPE_URL:
                        case XOBJ_DTYPE_TXTBOX:
                        case XOBJ_DTYPE_TXTAREA:
                            if (isset($_REQUEST[$fieldname]) && '' !== $_REQUEST[$fieldname]) {
                                $value = $myts->addSlashes(trim($_REQUEST[$fieldname]));
                                switch ($_REQUEST[$fieldname . '_match']) {
                                    case XOOPS_MATCH_START:
                                        $value .= '%';
                                        break;
                                    case XOOPS_MATCH_END:
                                        $value = '%' . $value;
                                        break;
                                    case XOOPS_MATCH_CONTAIN:
                                        $value = '%' . $value . '%';
                                        break;
                                }
                                $search_url[] = $fieldname . '=' . $value;
                                $operator     = 'LIKE';
                                $criteria->add(new Criteria($fieldname, $value, $operator));
                                $searchvars[] = $fieldname;
                            }
                            break;
                    }
                }
            }
        }

        if ($searchvars === []) {
            break;
        }

        if ('name' === Request::getString('sortby', '', 'REQUEST')) {
            $criteria->setSort('name');
        } elseif ('email' === Request::getString('sortby', '', 'REQUEST')) {
            $criteria->setSort('email');
        } elseif ('uname' === Request::getString('sortby', '', 'REQUEST')) {
            $criteria->setSort('uname');
        } elseif (isset($fields[Request::getString('sortby', '', 'REQUEST')])) {
            $criteria->setSort($fields[Request::getString('sortby', '', 'REQUEST')]->getVar('field_name'));
        }
        $order = 0 === $_REQUEST['order'] ? 'ASC' : 'DESC';
        $criteria->setOrder($order);

        $limit = isset($_REQUEST['limit']) && Request::getInt('limit', 0, 'REQUEST') > 0 ? Request::getInt('limit', 0, 'REQUEST') : 20;
        $criteria->setLimit($limit);

        $start = Request::getInt('start', 0, 'REQUEST');
        $criteria->setStart($start);

        //Get users based on criteria
        $profileHandler = xoops_getModuleHandler('profile');
        [$users, $profiles, $total_users] = $profileHandler->search($criteria, $searchvars);

The method search() does not exist on XoopsObjectHandler. It seems like you code against a sub-type of XoopsObjectHandler such as XoopsPersistableObjectHandler.

        //Sort information
        foreach (array_keys($users) as $k) {
            $userarray['output'][] = "<a href='userinfo.php?uid=" . (int)$users[$k]->getVar(
                    'uid'
                ) . "'>" . $users[$k]->getVar(
                    'uname'
                ) . '</a>';
            $userarray['output'][] = 1 === $users[$k]->getVar(
                'user_viewemail'
            )
                                     || $xoopsUser->isAdmin() ? $users[$k]->getVar(
                'email'
            ) : '';

            foreach (array_keys($fields) as $i) {
                if (in_array($fields[$i]->getVar('fieldid'), $searchable_fields, true)
                    && in_array(
                        $fields[$i]->getVar('field_type'),
                        $searchable_types,
                        true
                    )
                    && in_array(
                        $fields[$i]->getVar('field_name'),
                        $searchvars,
                        true
                    )) {
                    $userarray['output'][] = $fields[$i]->getOutputValue($users[$k], $profiles[$k]);
                }
            }
            $xoopsTpl->append('users', $userarray);
            unset($userarray);
        }

        //Get captions
        $captions[] = _MD_YOGURT_PROFILE_DISPLAYNAME;
        $captions[] = _MD_YOGURT_PROFILE_EMAIL;
        foreach (array_keys($fields) as $i) {
            if (in_array($fields[$i]->getVar('fieldid'), $searchable_fields, true)
                && in_array(
                    $fields[$i]->getVar('field_type'),
                    $searchable_types,
                    true
                )
                && in_array(
                    $fields[$i]->getVar('field_name'),
                    $searchvars,
                    true
                )) {
                $captions[] = $fields[$i]->getVar('field_title');
            }
        }
        $xoopsTpl->assign('captions', $captions);

        if ($total_users > $limit) {
            $search_url[] = 'op=results';
            $search_url[] = 'order=' . $order;
            $search_url[] = 'sortby=' . Request::getString('sortby', '', 'REQUEST');
            $search_url[] = 'limit=' . $limit;
            if (isset($search_url)) {
                $args = implode('&amp;', $search_url);
            }
            require_once XOOPS_ROOT_PATH . '/class/pagenav.php';
            $nav = new XoopsPageNav($total_users, $limit, $start, 'start', $args);
            $xoopsTpl->assign('nav', $nav->renderNav(5));
        }
        break;
}
require XOOPS_ROOT_PATH . '/footer.php';