users.php

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

		}

		 $arrFieldList[0] = "'" . $this->getUserID() . "'";
		 $arrFieldList[1] = "'" . $this->getUserName() . "'";
		 $arrFieldList[2] = ($this->getUserEmpID() == '') ? 'null' :"'". $this->getUserEmpID() . "'";
		 $arrFieldList[3] = "'" . $this->getUserIsAdmin() . "'";
		 $arrFieldList[4] = "'" . $this->getUserDateModified() . "'";
		 $arrFieldList[5] = "'" . $this->getUserModifiedBy() . "'";
		 $arrFieldList[6] = "'" . $this->getUserStatus() . "'";
		 $arrFieldList[7] = ($this->getUserGroupID()=='0') ? 'null' :"'". $this->getUserGroupID() . "'";
/////
	    $arrRecordsList[0] = 'id';
		$arrRecordsList[1] = 'user_name';
		$arrRecordsList[2] = 'emp_number';
		$arrRecordsList[3] = 'is_admin';
		$arrRecordsList[4] = 'date_modified';
		$arrRecordsList[5] = 'modified_user_id';
		$arrRecordsList[6] = 'status';
		$arrRecordsList[7] = 'userg_id';

		$password = $this->getUserPassword();

		if (isset($password) && $password) {
			$arrFieldList[8] = $password;
			$arrRecordsList[8] = 'user_password';
		}

		$this->sql_builder->table_name = $this->tableName;
		$this->sql_builder->flg_update = 'true';
		$this->sql_builder->arr_update = $arrRecordsList;
		$this->sql_builder->arr_updateRecList = $arrFieldList;

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

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

		return $message2;
	}

	function updateChangeUsers() {
		//echo $this->getUserID(). $_SESSION['user'];
		 if($this->getUserID() !== $_SESSION['user']) {
			return false;
		}
		 //echo 'hi';
		 $arrFieldList[0] = "'" . $this->getUserID() . "'";
		 $arrFieldList[1] = "'" . $this->getUserName() . "'";
		if($this->getUserPassword() != '')
		 $arrFieldList[2] = "'" . md5($this->getUserPassword()) . "'";
/////

		$arrRecordsList[0] = 'id';
		$arrRecordsList[1] = 'user_name';
		if($this->getUserPassword() != '')
			$arrRecordsList[2] = 'user_password';

		$this->sql_builder->table_name = $this->tableName;
		$this->sql_builder->flg_update = 'true';
		$this->sql_builder->arr_update = $arrRecordsList;
		$this->sql_builder->arr_updateRecList = $arrFieldList;

		$this->sql_builder->flg_update = true;

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

		return $message2;
	}

	public function updateUserEmail($userId, $email) {
		$sqlQBuilder = new SQLQBuilder();

		$arrFields[0] = '`email1`';

		$changeValues[0] = $email;

		$arrTable = "`hs_hr_users`";

		$updateConditions[1] = "`id` = '{$userId}'";

		$query = $sqlQBuilder->simpleUpdate($arrTable, $arrFields, $changeValues, $updateConditions);

		$dbConnection = new DMLFunctions();

		$result = $dbConnection->executeQuery($query);

		return true;
	}

	public function fetchUserEmail($userId) {
		$sqlQBuilder = new SQLQBuilder();

		$arrFields[0] = '`email1`';

		$arrTable = "`hs_hr_users`";

		$selectConditions[1] = "`id` = '{$userId}'";

		$query = $sqlQBuilder->simpleSelect($arrTable, $arrFields, $selectConditions, $arrFields[0], 'ASC');

		$dbConnection = new DMLFunctions();

		$result = $dbConnection->executeQuery($query);

		$row = mysql_fetch_row($result);

		return $row[0];
	}

	function filterUsers($getID) {

		$this->ID = $getID;
	    $arrFieldList[0] = 'a.id';
		$arrFieldList[1] = 'a.user_name';
		$arrFieldList[2] = 'LPAD(a.`emp_number`, '.$this->employeeIdLength.', 0)';
		$arrFieldList[3] = 'a.is_admin';
		$arrFieldList[4] = 'a.date_entered';
		$arrFieldList[5] = 'a.date_modified';
		$arrFieldList[6] = 'a.modified_user_id';
		$arrFieldList[7] = 'a.created_by';
		$arrFieldList[8] = 'a.status';
		$arrFieldList[9] = 'a.userg_id';
		$arrFieldList[10] = 'b.EMP_FIRSTNAME';
		$arrFieldList[11] = 'b.EMPLOYEE_ID';


		$this->sql_builder->table_name = $this->tableName.' a LEFT JOIN HS_HR_EMPLOYEE b ON (a.EMP_NUMBER = b.EMP_NUMBER)';
		$this->sql_builder->flg_select = 'true';
		$this->sql_builder->arr_select = $arrFieldList;

		$sqlQString = $this->sql_builder->selectOneRecordFiltered($this->ID);

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

		$i=0;

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

	    	for ($j=0; $j < count($line); $j++) {
				$arrayDispList[$i][$j] = $line[$j];
			}
	    	/*
			$arrayDispList[$i][1] = $line[1];
	    	$arrayDispList[$i][3] = $line[3];
	    	$arrayDispList[$i][4] = $line[4];
	    	$arrayDispList[$i][5] = $line[5];
	    	$arrayDispList[$i][6] = $line[6];
	    	$arrayDispList[$i][7] = $line[7];
	    	$arrayDispList[$i][8] = $line[8];
	    	$arrayDispList[$i][9] = $line[9];
	    	$arrayDispList[$i][10] = $line[10];
			*/

	    	$i++;

	     }

	     if (isset($arrayDispList)) {

			return $arrayDispList;

		} else {

			$arrayDispList = '';
			return $arrayDispList;

		}

	}

	function filterChangeUsers($getID) {

		$this->ID = $getID;
	    $arrFieldList[0] = 'id';
		$arrFieldList[1] = 'user_name';
		$arrFieldList[2] = 'user_password';


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

		$sqlQString = $this->sql_builder->selectOneRecordFiltered($this->ID);

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

		$i=0;

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

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

			$i++;
	     }

	     if (isset($arrayDispList)) {

			return $arrayDispList;

		} else {

			$arrayDispList = '';
			return $arrayDispList;

		}

	}

	function delUsers($arrList) {

		$arrFieldList[0] = 'id';

		$this->sql_builder->table_name = $this->tableName;
		$this->sql_builder->flg_delete = 'true';
		$this->sql_builder->arr_delete = $arrFieldList;

		$delFlag = false;
		for($c=0;count($arrList[0])>$c;$c++)
			if($_SESSION['user'] == $arrList[0][$c])
				$delFlag = true;

		if($delFlag) {
			return;
		}

		$sqlQString = $this->sql_builder->deleteRecord($arrList);

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

		return $message2;
	}

	function getUserGroupCodes(){

		$arrFieldList[0] = 'userg_id';
		$arrFieldList[1] = 'userg_name';


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

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

		$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 getEmployeeCodes() {

		$tableName = 'HS_HR_EMPLOYEE';
		$arrFieldList[0] = 'LPAD(`EMP_NUMBER`, '.$this->employeeIdLength.', 0)';
		$arrFieldList[1] = 'EMP_FIRSTNAME';

		$sql_builder = new SQLQBuilder();

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

		$sqlQString = $sql_builder->passResultSetMessage();

		//echo $sqlQString;
		$dbConnection = new DMLFunctions();
		$message2 = $dbConnection -> executeQuery($sqlQString); //Calling the addData() function
		//echo mysql_error();
		$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;

		}
	}
}
?>