Edit file

File name : EnhancedDBUtils.php

Content :<?php /******************************************************************************* * This file is integral part of the project "Enhanced Search" for SugarCRM. * * "Enhanced Search" is a project created by: * Dispage - Patrizio Gelosi * Via A. De Gasperi 91 * P. Potenza Picena (MC) - Italy * * (Hereby referred to as "DISPAGE") * * Copyright (c) 2010-2013 DISPAGE. * * The contents of this file are released under the GNU General Public License * version 3 as published by the Free Software Foundation that can be found on * the "LICENSE.txt" file which is integral part of the SUGARCRM(TM) project. If * the file is not present, see http://www.gnu.org/licenses or write to the Free * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA * 02110-1301 USA. * * You may not use the present file except in compliance with the License. * Software distributed under the License is distributed on an "AS IS" basis, * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License * for the specific language governing rights and limitations under the * License. * * The interactive user interfaces in modified source and object code versions * of this program must display Appropriate Legal Notices, as required under * Section 5 of the GNU General Public License version 3. * * In accordance with Section 7(b) of the GNU General Public License version 3, * these Appropriate Legal Notices must retain the display of the "Powered by * Dispage" logo. If the display of the logo is not reasonably feasible for * technical reasons, the Appropriate Legal Notices must display the words * "Powered by Dispage". * ******************************************************************************/ require_once("custom/include/EnhancedManager/ultraLiteDB.php"); class EnhancedDBUtils { public function __construct () { global $db; if (!$db) { $db = new ultraLiteDB; } } public function getSugarUsers () { global $db; $resource = $db->query('SELECT id, user_name FROM users WHERE deleted = 0 ORDER BY user_name'); while ($usersList = $db->fetchByAssoc($resource)) { $users[$usersList['id']] = $usersList['user_name']; } return $users; } public function getSugarRoles () { global $db; $roles = array(); $resource = $db->query('SELECT name FROM acl_roles WHERE deleted = 0 ORDER BY name'); while ($roleList = $db->fetchByAssoc($resource)) { $roles[$roleList['name']] = $roleList['name']; } return $roles; } } ?>

Save