Ego_Input_Store.php

gehe zur Dokumentation dieser Datei

<?php
require_once('base/Ego_Store.php');
 
class Ego_Input_Store extends Ego_Store {
    protected $name = '';
 
    protected $value = '';
 
    protected $data = null;
 
    public function __construct($params = array(), $query = array()) {
        parent::__construct($params, $query);
 
        $this->name = str_replace(
            array('*', '. . '),
            array('%', ''),
            (string) $_REQUEST['name']
        );
        $this->value = (string) (isset($_REQUEST['value']) ? $_REQUEST['value'] : $_REQUEST['ref']);
        $this->data = $_REQUEST['data'];
    }
 
    public function getData() {
        switch ($this->data) {
            // Benutzer ermitteln
            case 'user':
                $query = [];
                if (trim(trim($this->name, '%')) != '') {
                    $query = ['username' => str_replace('%', '', $this->name)];
                } elseif ($this->value) {
                    $query = ['user_id' => $this->value];
                }
                if (!empty($query)) {
                    require_once 'base/Ego_User_Search_Factory.php';
                    $search = Ego_User_Search_Factory::start();
 
                    $users = $search->searchUsers(array_merge($query, [
                        'user_inactive' => $this->params['user_active'] ? 1 : 0,
                        'user_deleted' => 0
                    ]), $this->limit === 0 ? -1 : $this->limit, '', false, true, true, 0, false, [], $this->params['rights'] ?? '');
 
                    foreach ($users as $user) {
                        if (
                            $this->params['liveserver'] // Liveserver Prüfung durchführen:
                            && $GLOBALS['egotec_conf']['liveserver'] // Server ist ein Liveserver
                            && !$user->field['no_admin'] // und Benutzer darf in den Adminbereich
                            && !$user->extra['liveserver'] // und Benutzer darf nicht in den Adminbereich des Liveservers
                        ) {
                            // dann steht dieser Benutzer nicht zur Auswahl
                            continue;
                        }
 
                        $icon = $GLOBALS['egotec_conf']['url_dir'].'bin/admin_skin/egotec/sitemap_img/';
                        if ($user->extra['gender'] === 'female') {
                            $icon .= 'user_female.png';
                        } else {
                            $icon .= 'user_male.png';
                        }
 
                        $this->addItem([
                            self::IDENTIFIER => $user->field['user_id'],
                            'name' => $user->getFullname(),
                            'icon' => $icon
                        ]);
                    }
                }
                break;
 
            // Gruppe ermitteln
            case 'group':
                $db = new_db_connection();
                if (empty($this->value)) {
                    if (trim($this->name, '%') != '') {
                        // Suche
                        if (!$this->isValidSearch($this->name)) {
                            return;
                        }
 
                        $where = '';
                        if (!$GLOBALS['auth']->hasSuperuserPermission()) {
                            // Nur die Gruppen anzeigen denen man selbst angehört
                            $groups = $GLOBALS['auth']->user->getAllGroups();
                            $group_ids = array();
                            foreach ($groups as $group) {
                                $group_ids[] = $group->field['group_id'];
                            }
                            $where = "group_id IN ('" . implode("','", $group_ids) . "') AND ";
                        }
 
                        $query = array(
                            'table' => 'egotec_group',
                            'where' => $where . 'LOWER(group_name) LIKE :group_name',
                            'order' => 'links ASC',
                            'bind' => array(
                                'group_name' => mb_strtolower($this->name)
                            )
                        );
                        if ($this->limit > 0) {
                            $query['limit'] = "{$this->start},{$this->limit}";
                        }
                        $db->select($this->buildQuery($query));
                    } else {
                        // Alle Gruppen
                        require_once('rights/Group_SQL.php');
                        $parent = new Group_SQL($GLOBALS['egotec_conf']['superuser']['group']);
 
                        $group_ids = array();
                        if (!$GLOBALS['auth']->hasSuperuserPermission()) {
                            // Nur die Gruppen anzeigen denen man selbst angehört
                            $groups = $GLOBALS['auth']->user->getAllGroups();
                            foreach ($groups as $group) {
                                $group_ids[] = $group->field['group_id'];
                            }
                        }
 
                        // Gruppe "Alle" ist auswählbar
                        if ($this->params['all_group']) {
                            $this->addItem(array(
                                self::IDENTIFIER => '*',
                                'name' => '(' . $GLOBALS['auth']->translate('Alle') . ')',
                                'icon' => $GLOBALS['egotec_conf']['url_dir'].'bin/admin_skin/egotec/img/16x16/user-unknown2.png',
                                'indent' => 0
                            ));
                        }
 
                        $this->getNS($parent, $group_ids, 'group_id', 'group_name', 'groups.png');
                        return;
                    }
                } else {
                    $db->select($this->buildQuery(array(
                        'table' => 'egotec_group',
                        'where' => 'group_id = :group_id',
                        'bind' => array(
                            'group_id' => $this->value
                        )
                    )));
                }
                while ($db->nextRecord()) {
                    $group = new Group_SQL($db->Record['group_id'], $db->Record);
                    $name = $db->Record['group_name'];
                    $this->addItem(array(
                        self::IDENTIFIER => $db->Record['group_id'],
                        'name' => $name,
                        'icon' => $GLOBALS['egotec_conf']['url_dir'].'bin/admin_skin/egotec/img/16x16/groups.png',
                        'indent' => $db->Record['tiefe'],
                        'hover' => ltrim($group->getPath(true).'/'.$name, '/')
                    ));
                }
                break;
 
            // Rolle ermitteln
            case 'role':
                $db = new_db_connection();
                if (empty($this->value)) {
                    if (trim($this->name, '%') != '') {
                        // Suche
                        if (!$this->isValidSearch($this->name)) {
                            return;
                        }
 
                        $where = '';
                        if (!$GLOBALS['auth']->hasSuperuserPermission()) {
                            // Nur die Rollen anzeigen denen man selbst angehört
                            $roles = $GLOBALS['auth']->user->getAllRoles();
                            $role_ids = array();
                            foreach ($roles as $role) {
                                $role_ids[] = $role->field['role_id'];
                            }
                            $where = "role_id IN ('".implode("','", $role_ids)."') AND ";
                        }
 
                        $query = array(
                            'table' => 'egotec_role',
                            'where' => $where.'LOWER(role_name) LIKE :role_name',
                            'order' => 'links ASC',
                            'bind' => array(
                                'role_name' => mb_strtolower($this->name)
                            )
                        );
                        if ($this->limit > 0) {
                            $query['limit'] = "{$this->start},{$this->limit}";
                        }
                        $db->select($this->buildQuery($query));
                    } else {
                        // Alle Rollen
                        require_once('rights/Role_SQL.php');
                        $parent = new Role_SQL($GLOBALS['egotec_conf']['superuser']['role']);
 
                        $role_ids = array();
                        if (!$GLOBALS['auth']->hasSuperuserPermission()) {
                            // Nur die Rollen anzeigen denen man selbst angehört
                            $roles = $GLOBALS['auth']->user->getAllRoles();
                            $role_ids = array();
                            foreach ($roles as $role) {
                                $role_ids[] = $role->field['role_id'];
                            }
                        }
 
                        $this->getNS($parent, $role_ids, 'role_id', 'role_name', 'roles.png');
                        return;
                    }
                } else {
                    $db->select($this->buildQuery(array(
                        'table' => 'egotec_role',
                        'where' => 'role_id = :role_id',
                        'bind' => array(
                            'role_id' => $this->value
                        )
                    )));
                }
                while ($db->nextRecord()) {
                    $role = new Role_SQL($db->Record['role_id'], $db->Record);
                    $name = $db->Record['role_name'];
                    $this->addItem(array(
                        self::IDENTIFIER => $db->Record['role_id'],
                        'name' => $name,
                        'icon' => $GLOBALS['egotec_conf']['url_dir'].'bin/admin_skin/egotec/img/16x16/roles.png',
                        'indent' => $db->Record['tiefe'],
                        'hover' => ltrim($role->getPath(true).'/'.$name, '/')
                    ));
                }
                break;
 
            // Mandanten für Schlagwortregister ermitteln
            case 'keyword_site':
                foreach (Ego_System::getAllSites() as $site) {
                    $search = str_replace(array('*', '%'), '', $this->name);
 
                    // $this->value ist nur dann gesetzt, wenn der Wert initial gesetzt wird oder zurückgesetzt wird
                    if (!empty($this->value)) {
                        if ($site->name == $this->value) {
                            $this->addItem([
                                self::IDENTIFIER => $site->name,
                                'name' => $site->site['title']
                            ]);
 
                            break;
                        }
 
                        continue;
                    }
 
                    if (empty($search)) {
                        // Ohne Suchbegriff
                        if (($this->params[0] && (($site->admin['keyword_register_own_site'] && $site->admin['keywords']['site'] == $site->name) || $site->name == $this->site->name))
                            || empty($this->params[0])) {
                            $this->addItem([
                                self::IDENTIFIER => $site->name,
                                'name' => $site->site['title']
                            ]);
                        }
                    } else {
                        // Suche
                        if ((mb_stripos($site->site['title'], $search) !== false || mb_stripos($site->name, $search) !== false)
                            && ($this->params[0] && (($site->admin['keyword_register_own_site'] && $site->admin['keywords']['site'] == $site->name) || $site->name == $this->site->name))
                            || empty($this->params[0])) {
                            $this->addItem([
                                self::IDENTIFIER => $site->name,
                                'name' => $site->site['title']
                            ]);
                        }
                    }
                }
 
                break;
 
            // Seite ermitteln
            case 'page':
                if (empty($this->value)) {
                    if (!$this->isValidSearch($this->name)) {
                        return;
                    }
 
                    if (!isset($this->params['query'])) {
                        $this->params['query'] = array();
                    }
                    if (!isset($this->params['query']['bind'])) {
                        $this->params['query']['bind'] = array();
                    }
                    if (!isset($this->params['param'])) {
                        $this->params['param'] = array();
                    }
                    if ($this->limit > 0) {
                        $this->params['query']['limit'] = "{$this->start},{$this->limit}";
                    }
                    $this->params['query']['where'] = ($this->params['query']['where']
                        ? $this->params['query']['where'] . ' AND '
                        : '')."LOWER(name) LIKE :name";
                    $this->params['query']['bind']['name'] = mb_strtolower($this->name);
                    $this->site->setRights(array('edit', 'view'));
                    if ($parent = $this->site->getPage($this->params['id'])) {
                        $pages = $parent->getChildren(
                            $this->buildQuery($this->params['query']),
                            $this->params['param']
                        );
                    } else {
                        $pages = array();
                    }
                } else {
                    $pages = array(Ego_System::urltopage($this->value));
                }
                foreach ($pages as $page) {
                    if ($page) {
                        $this->addItem(array(
                            self::IDENTIFIER => ltrim($page->getUrl(array('nonactive' => false)), $GLOBALS['egotec_conf']['url_dir']),
                            'name' => $page->field['name'],
                            'icon' => $page->getIconUrl()
                        ));
                    }
                }
                break;
 
            // Seitentyp ermitteln
            case 'types':
                $search = str_replace(array('*', '%'), '', $this->name);
                $site = $this->params['from'] ? new Site($this->params['from']) : ($this->site ? $this->site : new Site());
                $types = $this->params['type_list'] ? $this->params['type_list'] : $site->getTypes();
                foreach ($types as $type) {
                    if (
                        $site->admin['enabled_types'][$type['type']]
                        || !$type['global']
                        || $type['system']
                        || $type['inherit']
                    ) {
                        if ($type['hidden']) {
                            continue;
                        } elseif (empty($this->value)) {
                            if (
                                !empty($search)
                                && (empty($type['active'])
                                    || mb_stripos($type['fullname'], $search) === false)
                            ) {
                                continue;
                            }
                        } elseif ($type['type'] != $this->value) {
                            continue;
                        }
 
                        $this->addItem(array(
                            self::IDENTIFIER => $type['type'],
                            'name' => Ego_System::filterNonUtf8($type['fullname']),
                            'label' => Ego_System::filterNonUtf8(empty($search) ? $type['name'] : ''),
                            'icon' => $this->page && $this->page->field['type'] == $type['type']
                                ? $this->page->getIconUrl(false, false, false)
                                : ($type['icon']
                                    ? $type['icon']
                                    : $GLOBALS['egotec_conf']['url_dir'].'bin/admin_skin/egotec/img/16x16/'
                                        .($type['type'] == 'multimedia/category'
                                            ? 'folder.png'
                                            : 'page.png')
                                ),
                            'disabled' => empty($type['active']) && $this->page->canChangeType(),
                            'indent' => empty($search) ? $type['depth'] : 0
                        ));
                        if (!empty($this->value)) {
                            break;
                        }
                    }
                }
        }
    }
 
    private function getNS($parent, $ids, $id_key, $name_key, $icon) {
        if (empty($ids) || in_array($parent->field[$id_key], $ids)) {
            $this->addItem(array(
                self::IDENTIFIER => $parent->field[$id_key],
                'name' => $parent->field[$name_key],
                'icon' => $GLOBALS['egotec_conf']['url_dir'].'bin/admin_skin/egotec/img/16x16/'.$icon,
                'indent' => $parent->field['tiefe'],
                'hover' => ltrim($parent->getPath(true).'/'.$parent->field[$name_key], '/')
            ));
        }
 
        foreach ($parent->getChildren() as $child) {
            $this->getNS($child, $ids, $id_key, $name_key, $icon);
        }
    }
}
?>