信息办公BugFree v2.0 RC1 Build 20071031 (开源Bug管理系统)-bugfree.rar

<?php /** * Module functions library of BugFree system. * * BugFree 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 2 of the License, or * (at your option) any later version. * * BugFree 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 BugFree; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * * @link http://www.bugfree.org.cn * @package BugFree * @version $Id$ */ //------------------------- BASE FUNCTIONS -----------------------------------// /** * Get Current Mode * * @author Yupeng Lee<leeyupeng@gmail.com> */ function baseGetTestMode() { if($_SESSION['TestMode'] == '') { $_SESSION['TestMode'] = 'Bug'; } return $_SESSION['TestMode']; } /*================================User Function Start=================================*/ /** * Judge valid user. * * @author Chunsheng Wang <wwccss@263.net> * @global array the BugFree config array. * @global object the object of ADO class created in SetupBug.inc.php. * @param string $TestUserName the user name used to login BugFree system. * @param string $TestUserPWD the user password used to login BugFree system. */ function baseJudgeUser($TestUserName = '',$TestUserPWD = '') { global $_CFG; $DBName = !empty($_CFG['UserDB']) ? 'MyUserDB' : 'MyDB'; global $$DBName; $TestUserPWD = baseEncryptUserPWD($TestUserPWD); $Where = "{$_CFG[UserTable][UserName]} = '{$TestUserName}' AND {$_CFG[UserTable][UserPassword]} = '{$TestUserPWD}'"; if($DBName == 'MyDB') { $Where .= " AND IsDroped = '0'"; } $TestUserInfo = dbGetRow($_CFG[UserTable][TableName], "{$_CFG[UserTable][UserName]} AS UserName, {$_CFG[UserTable][RealName]} AS RealName, {$_CFG[UserTable][Email]} AS Email" , $Where , $$DBName); return $TestUserInfo; } /** * Encrypt the password according to the EncryptType defined in Config.inc.php. * * @author Chunsheng Wang <wwccss@263.net> * @global array config vars of BugFree system. * @param string $TestUserPWD the password before encrypting. * @return string encrypted password. */ function baseEncryptUserPWD($TestUserPWD) { global $_CFG; if($_CFG['UserTable']['EncryptType'] == 'md5') { $TestUserPWD = md5($TestUserPWD); } elseif($_CFG['UserTable']['EncryptType'] == 'mysqlpassword') { $TestUserPWD = "PASSWORD('{$TestUserPWD}')"; } else { $TestUserPWD = $TestUserPWD; } return $TestUserPWD; } /** * Judge User Login Status * * @author Yupeng Lee<leeyupeng@gmail.com> * @ */ function baseJudgeUserLogin() { return true; } /** * Judge Adminuser Login Status * * @author Yupeng Lee<leeyupeng@gmail.com> * */ function baseJudgeAdminUserLogin() { global $_CFG; if(baseJudgeIsAdmin($_SESSION['TestUserName'])) { return true; } else { die('Permission Denenied'); } } /** * Judge is admin * * @author Yupeng Lee<leeyupeng@gmail.com> * */ function baseJudgeIsAdmin($UserName) { global $_CFG; $UserName = strtolower($UserName); if(in_array($UserName, $_CFG['AdminUser'])) { return true; } return false; } /** * Get the User's A C L. * * @author Yupeng Lee <leeyupeng@163.com> * @param string $TestUserName UserName. * @return string User's ACL. */ function baseGetUserACL($TestUserName) { $ProjectList = testGetValidProjectList(); $UserACL = array(); $ProjectACL = array(); if(baseJudgeIsAdmin($TestUserName)) { $ProjectACL = array_keys($ProjectList); } else { $GroupACL = testGetGroupList("GroupUser LIKE '%,{$TestUserName},%'"); $ProjectACL = array(); foreach($GroupACL as $GroupInfo) { $ProjectACL += $GroupInfo['GroupProjectList']; } $ProjectACL = array_keys($ProjectACL); } foreach($ProjectACL as $ProjectID) { if($ProjectList[$ProjectID]) { $UserACL[$ProjectID] = 'All'; } } return $UserACL; } /** * Get query string from group query post in SearchBug.php/SearchCase.php/SearchResult.php * * @author Yupeng Lee<leeyupeng@gmail.com> */ function baseGetGroupQueryStr($PostQueryArray) { global $_CFG; $FirstQueryGroup = array(); $SecondQureyGroup = array(); $FieldName = 'Field'; $OperatorName = 'Operator'; $ValueName = 'Value'; $AndOrName = 'AndOr'; for($I=0; $I<$_CFG['QueryFieldNumber']; $I++) { $WhereStr = ' '; if(ucfirst($PostQueryArray[$AndOrName.$I]) == 'And') { $WhereStr .= '1 AND '; } elseif(ucfirst($PostQueryArray[$AndOrName.$I]) == 'Or') { $WhereStr .= '1 OR '; } $TempQueryStr = baseGetFieldQueryStr($PostQueryArray[$FieldName.$I], $PostQueryArray[$OperatorName.$I], $PostQueryArray[$ValueName.$I]); if($TempQueryStr == '') { $WhereStr = ''; } else { $WhereStr .= $TempQueryStr; } if($WhereStr != '') { $I%2 == 0 ? $FirstQueryGroup[] = $WhereStr : $SecondQureyGroup[] = $WhereStr; } } $FirstQueryStr = join('AND', $FirstQueryGroup); $SecondQueryStr = join('AND', $SecondQureyGroup); $FirstQueryStr == '' ? $FirstQueryStr = '1' : ''; $SecondQueryStr == '' ? $SecondQueryStr = '1' : ''; $QueryStr = '(' . $FirstQueryStr . ') ' . $PostQueryArray['AndOrGroup'] . ' (' . $SecondQueryStr . ')'; return $QueryStr; } function baseGetFieldQueryStr($FieldName, $OperatorName, $FieldValue) { $QueryStr = ''; if($FieldValue == '') { return $QueryStr; } if(ucfirst($FieldValue) == 'Null') { $FieldValue = ''; } if($OperatorName == 'LIKE') { $QueryStr = "LIKE '%{$FieldValue}%' "; } elseif($OperatorName == 'UNDER') { $QueryStr = "LIKE '{$FieldValue}%' "; } elseif($OperatorName == '!=') { $QueryStr = "NOT " . dbCreateIN($FieldValue) . " "; } elseif($OperatorName == '=') { if(eregi('date', $FieldName)) { $QueryStr = sysStrToDateSql($FieldValue); } else { $QueryStr = $OperatorName . " '{$FieldValue}' "; } } else { $QueryStr = $OperatorName . " '{$FieldValue}' "; } $QueryStr = $FieldName . ' ' . $QueryStr; return $QueryStr; } /** * Get user list which are not droped * * @author Yupeng Lee<leeyupeng@gmail.com> */ function testGetUserList($Where = '', $OrderBy = 'RealName ASC', $Limit = '', $ListKey = 'UserName') { global $_CFG; $DBName = !empty($_CFG['UserDB']) ? 'MyUserDB' : 'MyDB'; global $$DBName; global $_CFG; //$Columns = "{$_CFG[UserTable][UserName]} AS UserName, CONCAT(UPPER(LEFT({$_CFG[User