📄 empinfo.php
字号:
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $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];
$arrayDispList[$i][3] = $line[3];
$arrayDispList[$i][4] = $line[4];
$arrayDispList[$i][5] = $line[5];
$i++;
}
if (isset ($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function addEmpMain() {
$tableName = 'HS_HR_EMPLOYEE';
$this->empId = UniqueIDGenerator :: getInstance()->getNextID($tableName, 'EMP_NUMBER');
$arrRecordsList[0] = "'" . $this->getEmpId() . "'";
$arrRecordsList[1] = "'" . $this->getEmpLastName() . "'";
$arrRecordsList[2] = "'" . $this->getEmpFirstName() . "'";
$arrRecordsList[3] = "'" . $this->getEmpNickName() . "'";
$arrRecordsList[4] = "'" . $this->getEmpMiddleName() . "'";
$arrRecordsList[5] = "'" . $this->getEmployeeId() . "'";
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_LASTNAME';
$arrFieldList[2] = 'EMP_FIRSTNAME';
$arrFieldList[3] = 'EMP_NICK_NAME';
$arrFieldList[4] = 'EMP_MIDDLE_NAME';
$arrFieldList[5] = 'EMPLOYEE_ID';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrRecordsList;
$sql_builder->arr_insertfield = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature2();
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function
return $message2;
}
function updateEmpMain() {
$arrRecordsList[0] = "'" . $this->getEmpId() . "'";
$arrRecordsList[1] = "'" . $this->getEmpLastName() . "'";
$arrRecordsList[2] = "'" . $this->getEmpFirstName() . "'";
$arrRecordsList[3] = "'" . $this->getEmpNickName() . "'";
$arrRecordsList[4] = "'" . $this->getEmpMiddleName() . "'";
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_LASTNAME';
$arrFieldList[2] = 'EMP_FIRSTNAME';
$arrFieldList[3] = 'EMP_NICK_NAME';
$arrFieldList[4] = 'EMP_MIDDLE_NAME';
if ($this->getEmployeeId() != null) {
$arrRecordsList[5] = "'" . $this->getEmployeeId() . "'";
$arrFieldList[5] = 'EMPLOYEE_ID';
}
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_update = 'true';
$sql_builder->arr_update = $arrFieldList;
$sql_builder->arr_updateRecList = $arrRecordsList;
$sqlQString = $sql_builder->addUpdateRecord1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function
return $message2;
}
function filterEmpPers($getID) {
$this->getID = $getID;
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_SMOKER';
$arrFieldList[2] = 'ETHNIC_RACE_CODE';
$arrFieldList[3] = 'EMP_BIRTHDAY';
$arrFieldList[4] = 'NATION_CODE';
$arrFieldList[5] = 'EMP_GENDER';
$arrFieldList[6] = 'EMP_MARITAL_STATUS';
$arrFieldList[7] = 'EMP_SSN_NUM';
$arrFieldList[8] = 'EMP_SIN_NUM';
$arrFieldList[9] = 'EMP_OTHER_ID';
$arrFieldList[10] = 'EMP_DRI_LICE_NUM';
$arrFieldList[11] = 'EMP_DRI_LICE_EXP_DATE';
$arrFieldList[12] = 'EMP_MILITARY_SERVICE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for ($c = 0; count($arrFieldList) > $c; $c++)
$arrayDispList[$i][$c] = $line[$c];
$i++;
}
if (isset ($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function updateEmpPers() {
$arrRecordsList[0] = "'" . $this->getEmpId() . "'";
$arrRecordsList[1] = (trim($this->getEmpsmoker()) != '') ? "'". $this->getEmpsmoker() . "'" : "'0'";
$arrRecordsList[2] = ($this->getEmpEthnicRace() == '0') ? 'null' : "'" . $this->getEmpEthnicRace() . "'";
$arrRecordsList[3] = (trim($this->getEmpDOB()) != '') ? "'" . $this->getEmpDOB() . "'" : "'0000-00-00'";
$arrRecordsList[4] = ($this->getEmpNation() == '0') ? 'null' : "'" . $this->getEmpNation() . "'";
$arrRecordsList[5] = (trim($this->getEmpGender()) != '') ? "'" . $this->getEmpGender() . "'" : 'null';
$arrRecordsList[6] = "'" . $this->getEmpMarital() . "'";
$arrRecordsList[7] = "'" . $this->getEmpSSNNo() . "'";
$arrRecordsList[8] = "'" . $this->getEmpSINNo() . "'";
$arrRecordsList[9] = "'" . $this->getEmpOthID() . "'";
$arrRecordsList[10] = "'" . $this->getEmpDriLicNo() . "'";
$arrRecordsList[11] = (trim($this->empDriLicExpDat) != '') ? "'" . $this->empDriLicExpDat . "'" : "'0000-00-00'";
$arrRecordsList[12] = "'" . $this->getEmpMilitary() . "'";
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_SMOKER';
$arrFieldList[2] = 'ETHNIC_RACE_CODE';
$arrFieldList[3] = 'EMP_BIRTHDAY';
$arrFieldList[4] = 'NATION_CODE';
$arrFieldList[5] = 'EMP_GENDER';
$arrFieldList[6] = 'EMP_MARITAL_STATUS';
$arrFieldList[7] = 'EMP_SSN_NUM';
$arrFieldList[8] = 'EMP_SIN_NUM';
$arrFieldList[9] = 'EMP_OTHER_ID';
$arrFieldList[10] = 'EMP_DRI_LICE_NUM';
$arrFieldList[11] = 'EMP_DRI_LICE_EXP_DATE';
$arrFieldList[12] = 'EMP_MILITARY_SERVICE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_update = 'true';
$sql_builder->arr_update = $arrFieldList;
$sql_builder->arr_updateRecList = $arrRecordsList;
$sqlQString = $sql_builder->addUpdateRecord1();
//$logw = new LogFileWriter();
//$logw->writeLogDB($sqlQString);
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function
return $message2;
}
function filterEmpCustomInfo($getID) {
$this->getID = $getID;
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'custom1';
$arrFieldList[2] = 'custom2';
$arrFieldList[3] = 'custom3';
$arrFieldList[4] = 'custom4';
$arrFieldList[5] = 'custom5';
$arrFieldList[6] = 'custom6';
$arrFieldList[7] = 'custom7';
$arrFieldList[8] = 'custom8';
$arrFieldList[9] = 'custom9';
$arrFieldList[10] = 'custom10';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection -> executeQuery($sqlQString);
if (mysql_num_rows($message2) == 1) {
$line = mysql_fetch_assoc($message2);
return $line;
} else {
return array();
}
}
function filterEmpJobInfo($getID) {
$this->getID = $getID;
$tableName = 'HS_HR_EMPLOYEE A LEFT JOIN HS_HR_COMPSTRUCTTREE B ON A.WORK_STATION = B.ID';
$arrFieldList[0] = 'a.EMP_NUMBER';
$arrFieldList[1] = 'a.EMP_STATUS';
$arrFieldList[2] = 'a.JOB_TITLE_CODE';
$arrFieldList[3] = 'a.EEO_CAT_CODE';
$arrFieldList[4] = 'b.TITLE';
$arrFieldList[5] = 'a.JOINED_DATE';
$arrFieldList[6] = 'a.WORK_STATION';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection -> executeQuery($sqlQString); //Calling the addData() function
$i=0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for($c=0; count($arrFieldList) > $c ; $c++)
$arrayDispList[$i][$c] = $line[$c];
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function updateEmpJobInfo() {
$arrRecordsList[0] = "'" . $this->getEmpId() . "'";
$arrRecordsList[1] = $this->getEmpStatus() != '0' ? "'" . $this->getEmpStatus() . "'" : 'null';
$arrRecordsList[2] = $this->getEmpJobTitle() != '0' ? "'" . $this->getEmpJobTitle() . "'" : 'null';
$arrRecordsList[3] = $this->getEmpEEOCat() != '0' ? "'" . $this->getEmpEEOCat() . "'" : 'null';
$arrRecordsList[4] = $this->getEmpLocation() != '' ? "'" . $this->getEmpLocation() . "'" : 'null';
$arrRecordsList[5] = (trim($this->getEmpJoinedDate()) != '') ? "'" . $this->getEmpJoinedDate() . "'" : 'null';
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_STATUS';
$arrFieldList[2] = 'JOB_TITLE_CODE';
$arrFieldList[3] = 'EEO_CAT_CODE';
$arrFieldList[4] = 'WORK_STATION';
$arrFieldList[5] = 'JOINED_DATE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_update = 'true';
$sql_builder->arr_update = $arrFieldList;
$sql_builder->arr_updateRecList = $arrRecordsList;
$sqlQString = $sql_builder->addUpdateRecord1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function
return $message2;
}
function updateEmpCustomInfo() {
$arrRecordsList[0] = "'". $this->getEmpId() . "'";
$arrRecordsList[1] = isset($this->custom1) ? "'" . $this->custom1 . "'" : 'null';
$arrRecordsList[2] = isset($this->custom2) ? "'" . $this->custom2 . "'" : 'null';
$arrRecordsList[3] = isset($this->custom3) ? "'" . $this->custom3 . "'" : 'null';
$arrRecordsList[4] = isset($this->custom4) ? "'" . $this->custom4 . "'" : 'null';
$arrRecordsList[5] = isset($this->custom5) ? "'" . $this->custom5 . "'" : 'null';
$arrRecordsList[6] = isset($this->custom6) ? "'" . $this->custom6 . "'" : 'null';
$arrRecordsList[7] = isset($this->custom7) ? "'" . $this->custom7 . "'" : 'null';
$arrRecordsList[8] = isset($this->custom8) ? "'" . $this->custom8 . "'" : 'null';
$arrRecordsList[9] = isset($this->custom9) ? "'" . $this->custom9 . "'" : 'null';
$arrRecordsList[10] = isset($this->custom10) ? "'" . $this->custom10 . "'" : 'null';
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'custom1';
$arrFieldList[2] = 'custom2';
$arrFieldList[3] = 'custom3';
$arrFieldList[4] = 'custom4';
$arrFieldList[5] = 'custom5';
$arrFieldList[6] = 'custom6';
$arrFieldList[7] = 'custom7';
$arrFieldList[8] = 'custom8';
$arrFieldList[9] = 'custom9';
$arrFieldList[10] = 'custom10';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_update = 'true';
$sql_builder->arr_update = $arrFieldList;
$sql_builder->arr_updateRecList = $arrRecordsList;
$sqlQString = $sql_builder->addUpdateRecord1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection -> executeQuery($sqlQString); //Calling the addData() function
return $message2;
}
/*function getSalGrdCodes() {
$sql_builder = new SQLQBuilder();
$tableName = 'HS_PR_SALARY_GRADE';
$arrFieldList[0] = 'SAL_GRD_CODE';
$arrFieldList[1] = 'SAL_GRD_NAME';
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->passResultSetMessage();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection -> executeQuery($sqlQString); //Calling the addData() function
$common_func = new CommonFunctions();
$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 {
//Handle Exceptions
//Create Logs
}
}
*/
/*function filterEmpJobStat($getID) {
$this->getID = $getID;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -