📄 empinfo.php
字号:
$arrayDispList[$i][$c] = $line[$c];
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function updateEmpTempRes() {
$arrRecordsList[0] = "'". $this->getEmpId() . "'";
$arrRecordsList[1] = "'". $this->getEmpTempHouseNo() . "'";
$arrRecordsList[2] = "'". $this->getEmpTempStreet1() . "'";
$arrRecordsList[3] = "'". $this->getEmpTempStreet2() . "'";
$arrRecordsList[4] = "'". $this->getEmpTempCityTown() . "'";
$arrRecordsList[5] = "'". $this->getEmpTempPostCode() . "'";
$arrRecordsList[6] = "'". $this->getEmpTempTelephone() . "'";
$arrRecordsList[7] = "'". $this->getEmpTempMobile() . "'";
$arrRecordsList[8] = "'". $this->getEmpTempFax() . "'";
$arrRecordsList[9] = "'". $this->getEmpTempEmail() . "'";
$arrRecordsList[10] = "'". $this->getEmpTempCountry() . "'";
$arrRecordsList[11] = "'". $this->getEmpTempProvince() . "'";
$arrRecordsList[12] = "'". $this->getEmpTempDistrict() . "'";
$arrRecordsList[13] = "'". $this->getEmpTempElectorate() . "'";
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_TEM_ADDRESS1';
$arrFieldList[2] = 'EMP_TEM_ADDRESS2';
$arrFieldList[3] = 'EMP_TEM_ADDRESS3';
$arrFieldList[4] = 'EMP_TEM_CITY';
$arrFieldList[5] = 'EMP_TEM_POSTALCODE';
$arrFieldList[6] = 'EMP_TEM_TELEPHONE';
$arrFieldList[7] = 'EMP_TEM_MOBILE';
$arrFieldList[8] = 'EMP_TEM_FAX';
$arrFieldList[9] = 'EMP_TEM_EMAIL';
$arrFieldList[10] = 'EMP_TEM_COU_CODE';
$arrFieldList[11] = 'EMP_TEM_PROVINCE_CODE';
$arrFieldList[12] = 'EMP_TEM_DISTRICT_CODE';
$arrFieldList[13] = 'EMP_TEM_ELECTORATE_CODE';
$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 filterEmpOff($getID) {
$this->getID = $getID;
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_TITLE';
$arrFieldList[2] = 'EMP_CALLING_NAME';
$arrFieldList[3] = 'EMP_SURNAME';
$arrFieldList[4] = 'EMP_MAIDEN_NAME';
$arrFieldList[5] = 'EMP_MIDDLE_INI';
$arrFieldList[6] = 'EMP_NAMES_BY_INI';
$arrFieldList[7] = 'EMP_LASTNAME';
$arrFieldList[8] = 'EMP_OTHER_NAMES';
$arrFieldList[9] = 'EMP_OFFICE_PHONE';
$arrFieldList[10] = 'EMP_OFFICE_EXTN';
$arrFieldList[11] = 'EMP_OFFICE_EMAIL';
$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 updateEmpOff() {
$arrRecordsList[0] = "'". $this->getEmpId() . "'";
$arrRecordsList[1] = "'". $this->getEmpGenLine() . "'";
$arrRecordsList[2] = "'". $this->getEmpExt() . "'";
$arrRecordsList[3] = "'". $this->getEmpEmail() . "'";
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_OFFICE_PHONE';
$arrFieldList[2] = 'EMP_OFFICE_EXTN';
$arrFieldList[3] = 'EMP_OFFICE_EMAIL';
$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 updateEmpTaxCountry() {
$arrRecordsList[0] = "'". $this->getEmpId() . "'";
$arrRecordsList[1] = "'". $this->getEmpTaxCountry() . "'";
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_TAX_COUNTRY';
$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 getBasSalUnAssEmployee($pageNO, $schStr, $mode) {
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_LASTNAME';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->table2_name = 'HS_HR_EMP_BASICSALARY';
$sql_builder->field = 'EMP_NUMBER';
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->passResultFilter($pageNO, $schStr, $mode);
//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];
$i++;
}
if (isset ($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function countBasSalUnAssEmployee($schStr, $mode) {
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_LASTNAME';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->table2_name = 'HS_HR_EMP_BASICSALARY';
$sql_builder->flg_select = 'true';
$sql_builder->field = 'EMP_NUMBER';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->countResultFilter($schStr, $mode);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function
$line = mysql_fetch_array($message2, MYSQL_NUM);
return $line[0];
}
function getCashBenUnAssEmployee($pageNO, $schStr, $mode) {
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_LASTNAME';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->table2_name = 'HS_HR_EMP_CASH_BENEFIT';
$sql_builder->field = 'EMP_NUMBER';
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->passResultFilter($pageNO, $schStr, $mode);
//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];
$i++;
}
if (isset ($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function countCashBenUnAssEmployee($schStr, $mode) {
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_LASTNAME';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->table2_name = 'HS_HR_EMP_CASH_BENEFIT';
$sql_builder->flg_select = 'true';
$sql_builder->field = 'EMP_NUMBER';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->countResultFilter($schStr, $mode);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function
$line = mysql_fetch_array($message2, MYSQL_NUM);
return $line[0];
}
function getNonCashUnAssEmployee($pageNO, $schStr, $mode) {
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_LASTNAME';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->table2_name = 'HS_HR_EMP_NONCASH_BENEFIT';
$sql_builder->field = 'EMP_NUMBER';
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->passResultFilter($pageNO, $schStr, $mode);
//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];
$i++;
}
if (isset ($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function countNonCashUnAssEmployee($schStr, $mode) {
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_LASTNAME';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->table2_name = 'HS_HR_EMP_NONCASH_BENEFIT';
$sql_builder->flg_select = 'true';
$sql_builder->field = 'EMP_NUMBER';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->countResultFilter($schStr, $mode);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function
$line = mysql_fetch_array($message2, MYSQL_NUM);
return $line[0];
}
function getJobSpecUnAssEmployee($pageNO, $schStr, $mode) {
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_LASTNAME';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->table2_name = 'HS_HR_EMP_JOBSPEC';
$sql_builder->field = 'EMP_NUMBER';
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->passResultFilter($pageNO, $schStr, $mode);
//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];
$i++;
}
if (isset ($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function countJobSpecUnAssEmployee($schStr, $mode) {
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -