Uname: Linux webm005.cluster107.gra.hosting.ovh.net 5.15.167-ovh-vps-grsec-zfs-classid #1 SMP Tue Sep 17 08:14:20 UTC 2024 x86_64
User: 6036 (villadal)
Group: 100 (users)
Disabled functions: NONE
Safe mode: On[ PHPinfo ]
//home/villadal/www/////old/booked/Pages/Ajax      ( Reset | Go to )
File Name: AutoCompletePage.php
Edit
<?php
/**
Copyright 2011-2014 Nick Korbel

This file is part of Booked Scheduler.

Booked Scheduler is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

Booked Scheduler 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.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with Booked Scheduler.  If not, see <http://www.gnu.org/licenses/>.
*/

require_once(ROOT_DIR 'Domain/Access/namespace.php' );
require_once(
ROOT_DIR 'Pages/SecurePage.php');

class 
AutoCompletePage extends SecurePage
{
    private 
$listMethods = array();

    public function 
__construct()
    {
        
parent::__construct();

        
$this->listMethods[AutoCompleteType::User] = 'GetUsers';
        
$this->listMethods[AutoCompleteType::MyUsers] = 'GetMyUsers';
        
$this->listMethods[AutoCompleteType::Group] = 'GetGroups';
    }

    public function 
PageLoad()
    {
        
$results $this->GetResults($this->GetType(), $this->GetSearchTerm());

        
Log::Debug(sprintf('AutoComplete: %s results found for search type: %s, term: %s'count($results), $this->GetType(), $this->GetSearchTerm()));

        
$this->SetJson($results);
    }

    private function 
GetResults($type$term)
    {
        if (
array_key_exists($type$this->listMethods))
        {
            
$method $this->listMethods[$type];
            return 
$this->$method($term);
        }

        
Log::Debug("AutoComplete for type: $type not defined");

        return 
'';
    }

    public function 
GetType()
    {
        return 
$this->GetQuerystring(QueryStringKeys::AUTOCOMPLETE_TYPE);
    }

    public function 
GetSearchTerm()
    {
        return 
$this->GetQuerystring(QueryStringKeys::AUTOCOMPLETE_TERM);
    }

    
/**
     * @param $term string
     * @return array|AutocompleteUser[]
     */
    
private function GetUsers($term)
    {
        if (
$term == 'group')
        {
            return 
$this->GetGroupUsers($this->GetQuerystring(QueryStringKeys::GROUP_ID));
        }
        
$filter = new SqlFilterLike(ColumnNames::FIRST_NAME$term);
        
$filter->_Or(new SqlFilterLike(ColumnNames::LAST_NAME$term));
        
$filter->_Or(new SqlFilterLike(ColumnNames::EMAIL$term));

        
$users = array();

        
$r = new UserRepository();
        
$results $r->GetList(1PageInfo::Allnullnull$filter)->Results();

        
/** @var $result UserItemView */
        
foreach($results as $result)
        {
            
$users[] = new AutocompleteUser($result->Id    $result->First$result->Last$result->Email$result->Username);
        }

        return 
$users;
    }

    private function 
GetGroups($term)
    {
        
$filter = new SqlFilterLike(new SqlFilterColumn(TableNames::GROUPS_ALIAS,ColumnNames::GROUP_NAME), $term);
        
$r = new GroupRepository();
        return 
$r->GetList(1PageInfo::Allnullnull$filter)->Results();
    }

    
/**
     * @param $term string
     * @return array|AutocompleteUser[]
     */
    
private function GetMyUsers($term)
    {
        
$userSession ServiceLocator::GetServer()->GetUserSession();
        if (
$userSession->IsAdmin)
        {
            return 
$this->GetUsers($term);
        }

        
$userRepo = new UserRepository();
        
$user $userRepo->LoadById($userSession->UserId);

        
$groupIds = array();

        foreach (
$user->GetAdminGroups() as $group)
        {
            
$groupIds[] = $group->GroupId;
        }

        
$users = array();
        if (!empty(
$groupIds))
        {
            
$userFilter = new SqlFilterLike(ColumnNames::FIRST_NAME$term);
            
$userFilter->_Or(new SqlFilterLike(ColumnNames::LAST_NAME$term));

            
$groupRepo = new GroupRepository();
            
$results $groupRepo->GetUsersInGroup($groupIdsnullnull$userFilter)->Results();

            
/** @var $result UserItemView */
            
foreach ($results as $result)
            {
                
// consolidates results by user id if the user is in multiple groups
                
$users[$result->Id] = new AutocompleteUser($result->Id$result->First$result->Last$result->Email$result->Username);
            }
        }

        return 
array_values($users);
    }

    private function 
GetGroupUsers($groupId)
    {
        
$groupRepo = new GroupRepository();
        
$results $groupRepo->GetUsersInGroup($groupId)->Results();

        
/** @var $result UserItemView */
        
foreach ($results as $result)
        {
            
// consolidates results by user id if the user is in multiple groups
            
$users[$result->Id] = new AutocompleteUser($result->Id$result->First$result->Last$result->Email$result->Username);
        }

        return 
array_values($users);
    }
}

class 
AutocompleteUser
{
    public 
$Id;
    public 
$First;
    public 
$Last;
    public 
$Name;
    public 
$Email;
    public 
$UserName;

    public function 
__construct($userId$firstName$lastName$email$userName)
    {
        
$full = new FullName($firstName$lastName);
        
$this->Id $userId;
        
$this->First $firstName;
        
$this->Last $lastName;
        
$this->Name $full->__toString();
        
$this->Email $email;
        
$this->UserName $userName;
        
$this->DisplayName "{$full} ($email)";
    }
}

class 
AutoCompleteType
{
    const 
User 'user';
    const 
Group 'group';
    const 
MyUsers 'myUsers';
}

?>

All system for education purposes only. For more tools: Telegram @jackleet

Mr.X Private Shell

Logo
-
New File | New Folder
Command
SQL