users.php

国外的人才求职招聘最新版

<?php
/*
// OrangeHRM is a comprehensive Human Resource Management (HRM) System that captures
// all the essential functionalities required for any enterprise.
// Copyright (C) 2006 OrangeHRM Inc., http://www.orangehrm.com

// OrangeHRM 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.

// OrangeHRM 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 this program;
// if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
// Boston, MA  02110-1301, USA
*/

require_once ROOT_PATH . '/lib/confs/Conf.php';
require_once ROOT_PATH . '/lib/dao/DMLFunctions.php';
require_once ROOT_PATH . '/lib/dao/SQLQBuilder.php';
require_once ROOT_PATH . '/lib/common/CommonFunctions.php';
require_once ROOT_PATH . '/lib/common/UniqueIDGenerator.php';

class Users {
	var $tableName = 'hs_hr_users';

	var $userID;
	var $userName;
	var $userPassword;
	var $userFirstName;
	var $userLastName;
	var $userEmpID;
	var $userIsAdmin;
	var $userDateEntered;
	var $userDateModified;
	var $userModifiedBy;
	var $userCreatedBy;
	var $userStatus;
	var $userGroupID;
	var $arrayDispList;
	var $employeeIdLength;


	function Users() {
		$this->sql_builder = new SQLQBuilder();
		$this->dbConnection = new DMLFunctions();

		$tmpSysConf = new sysConf();

		$this->employeeIdLength	= $tmpSysConf->getEmployeeIdLength();
	}

	function setUserID($userID){
		$this->userID = $userID;
	}

	function setUserName($userName){
		$this->userName = $userName;
	}

	function setUserPassword($userPassword) {
		$this->userPassword=$userPassword;
	}

	function setUserFirstName($userFirstName) {
		$this->userFirstName=$userFirstName;
	}

	function setUserLastName($userLastName) {
		$this->userLastName=$userLastName;
	}

	function setUserEmpID($userEmpID) {
		$this->userEmpID=$userEmpID;
	}

	function setUserIsAdmin($userIsAdmin) {
		$this->userIsAdmin=$userIsAdmin;
	}

	function setUserDateEntered($userDateEntered) {
		$this->userDateEntered=$userDateEntered;
	}

	function setUserDateModified($userDateModified) {
		$this->userDateModified=$userDateModified;
	}

	function setUserModifiedBy($userModifiedBy) {
		$this->userModifiedBy=$userModifiedBy;
	}

	function setUserCreatedBy($userCreatedBy) {
		$this->userCreatedBy=$userCreatedBy;
	}

	function setUserStatus($userStatus){
		$this->userStatus=$userStatus;
	}

	function setUserAddress($userAddress) {
		$this->userAddress=$userAddress;
	}

	function setUserGroupID($userGroupID) {
		$this->userGroupID=$userGroupID;
	}
///
	function getUserID(){
		return $this->userID;
	}

	function getUserName(){
		return $this->userName;
	}

	function getUserPassword() {
		return $this->userPassword;
	}

	function getUserFirstName() {
		return $this->userFirstName;
	}

	function getUserEmpID() {
		return $this->userEmpID;
	}

	function getUserIsAdmin() {
		return $this->userIsAdmin;
	}

	function getUserDesc() {
		return $this->userDesc;
	}

	function getUserDateEntered() {
		return $this->userDateEntered;
	}

	function getUserDateModified() {
		return $this->userDateModified;
	}

	function getUserModifiedBy() {
		return $this->userModifiedBy;
	}

	function getUserCreatedBy() {
		return $this->userCreatedBy;
	}

	function getUserDepartment() {
		return $this->userDepartment;
	}

	function getUserPhoneHome() {
		return $this->userPhoneHome;
	}

	function getUserPhoneMobile() {
		return $this->userPhoneMobile;
	}

	function getUserPhoneWork() {
		return $this->userPhoneWork;
	}

	function getUserEmail1() {
		return $this->userEmail1;
	}

	function getUserEmail2() {
		return $this->userEmail2;
	}

	function getUserStatus(){
		return $this->userStatus;
	}

	function getUserAddress() {
		return $this->userAddress;
	}

	function getUserDeleted() {
		return $this->userDeleted;
	}

	function getUserGroupID() {
		return $this->userGroupID;
	}


	function getListOfUsers($pageNO,$schStr,$mode, $sortField, $sortOrder, $isAdmin){

		$arrFieldList[0] = 'id';
		$arrFieldList[1] = 'user_name';
		$arrFieldList[2] = 'is_admin';


		$this->sql_builder->table_name = $this->tableName;
		$this->sql_builder->flg_select = 'true';
		$this->sql_builder->arr_select = $arrFieldList;

		if ($isAdmin) {
			$isAdmin = 'Yes';
		} else {
			$isAdmin = 'No';
		}

		$schStr = array($schStr, $isAdmin);
		$mode = array($mode, 2);

		$sqlQString =$this->sql_builder->passResultSetMessage($pageNO,$schStr,$mode, $sortField, $sortOrder, true);

		$message2 = $this->dbConnection -> executeQuery($sqlQString);

		$i=0;

		 while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {

	    	$arrayDispList[$i][0] = $line[0];
	    	$arrayDispList[$i][1] = $line[1];
	    	$i++;

	     }

	     if (isset($arrayDispList)) {

			return $arrayDispList;

		} else {

			$arrayDispList = '';
			return $arrayDispList;

		}
	}

	function countUsers($schStr,$mode, $isAdmin) {

		$arrFieldList[0] = 'id';
		$arrFieldList[1] = 'user_name';
		$arrFieldList[2] = 'is_admin';

		$sql_builder = new SQLQBuilder();
		$sql_builder->table_name = $this->tableName;

		$sql_builder->flg_select = 'true';
		$sql_builder->arr_select = $arrFieldList;

		if ($isAdmin) {
			$isAdmin = 'Yes';
		} else {
			$isAdmin = 'No';
		}

		$schStr = array($schStr, $isAdmin);
		$mode = array($mode, 2);

		$sqlQString = $sql_builder->countResultset($schStr,$mode, true);

		//echo $sqlQString;
		$dbConnection = new DMLFunctions();
		$message2 = $dbConnection -> executeQuery($sqlQString); //Calling the addData() function

		$line = mysql_fetch_array($message2, MYSQL_NUM);

	    	return $line[0];
	}

	function addUsers(){

		 $this->userID = UniqueIDGenerator::getInstance()->getNextID($this->tableName, 'id', 'USR');

		 $arrFieldList[0] = "'" . $this->getUserID() . "'";
		 $arrFieldList[1] = "'" . $this->getUserName() . "'";
		 $arrFieldList[2] = "'" . $this->getUserPassword() . "'";
		 $arrFieldList[3] = ($this->getUserEmpID() == '') ? 'null' :"'". $this->getUserEmpID() . "'";
		 $arrFieldList[4] = "'" . $this->getUserIsAdmin() . "'";
		 $arrFieldList[5] = "'" . $this->getUserDateEntered() . "'";
		 $arrFieldList[6] = "'" . $this->getUserCreatedBy() . "'";
		 $arrFieldList[7] = "'" . $this->getUserStatus() . "'";
		 $arrFieldList[8] = ($this->getUserGroupID()=='0') ? 'null' :"'". $this->getUserGroupID() . "'";

	    $arrRecordsList[0] = 'id';
		$arrRecordsList[1] = 'user_name';
		$arrRecordsList[2] = 'user_password';
		$arrRecordsList[3] = 'emp_number';
		$arrRecordsList[4] = 'is_admin';
		$arrRecordsList[5] = 'date_entered';
		$arrRecordsList[6] = 'created_by';
		$arrRecordsList[7] = 'status';
		$arrRecordsList[8] = 'userg_id';

		$this->sql_builder->table_name = $this->tableName;
		$this->sql_builder->flg_insert = 'true';
		$this->sql_builder->arr_insertfield = $arrRecordsList;
		$this->sql_builder->arr_insert = $arrFieldList;

		$sqlQString = $this->sql_builder->addNewRecordFeature2();

		$message2 = $this->dbConnection -> executeQuery($sqlQString); //Calling the addData() function

		 return $message2;
	}

	function updateUsers() {

		if($this->getUserID() == $_SESSION['user'] && ($this->getUserStatus() != 'Enabled')) {
			return false;