| Server IP : 94.23.64.18 / Your IP :
216.73.216.185 [
Web Server : Apache System : 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 : villadal ( 6036) PHP Version : 7.4.33 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl Domains : 2 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/villadal/www/old/booked/Pages/Ajax/ |
Upload File : |
<?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(1, PageInfo::All, null, null, $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(1, PageInfo::All, null, null, $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($groupIds, null, null, $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';
}
?>