📄 empinfo.php
字号:
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_TYPE';
$arrFieldList[2] = 'STAFFCAT_CODE';
$arrFieldList[3] = 'CAT_CODE';
$arrFieldList[4] = 'EMP_CONTARCT_START_DATE';
$arrFieldList[5] = 'EMP_CONTRACT_END_DATE';
$arrFieldList[6] = 'EMP_CONT_TO_PERM_FLG';
$arrFieldList[7] = 'EMP_CONT_TO_PERM_DATE';
$arrFieldList[8] = 'EMP_ACTIVE_HRM_FLG';
$arrFieldList[9] = 'EMP_ACTIVE_PAYROLL_FLG';
$arrFieldList[10] = 'EMP_ACTIVE_ATT_FLG';
$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 updateEmpJobStat() {
$arrRecordsList[0] = "'". $this->getEmpId() . "'";
$arrRecordsList[1] = "'". $this->getEmpType() . "'";
$arrRecordsList[2] = ($this->getEmpStatutory()=='0') ? 'null' : "'". $this->getEmpStatutory() . "'";
$arrRecordsList[3] = ($this->getEmpCat()=='0') ? 'null' :"'". $this->getEmpCat() . "'";
$arrRecordsList[4] = "'". $this->getEmpStartDat() . "'";
$arrRecordsList[5] = "'". $this->getEmpEndDat() . "'";
$arrRecordsList[6] = "'". $this->getEmpConToPermFlag() . "'";
$arrRecordsList[7] = "'". $this->getEmpConToPermDat() . "'";
$arrRecordsList[8] = "'". $this->getEmpHRActivFlag() . "'";
$arrRecordsList[9] = "'". $this->getEmpPayActivFlag() . "'";
$arrRecordsList[10] = "'". $this->getEmpTimAttActivFlag() . "'";
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_TYPE';
$arrFieldList[2] = 'STAFFCAT_CODE';
$arrFieldList[3] = 'CAT_CODE';
$arrFieldList[4] = 'EMP_CONTARCT_START_DATE';
$arrFieldList[5] = 'EMP_CONTRACT_END_DATE';
$arrFieldList[6] = 'EMP_CONT_TO_PERM_FLG';
$arrFieldList[7] = 'EMP_CONT_TO_PERM_DATE';
$arrFieldList[8] = 'EMP_ACTIVE_HRM_FLG';
$arrFieldList[9] = 'EMP_ACTIVE_PAYROLL_FLG';
$arrFieldList[10] = 'EMP_ACTIVE_ATT_FLG';
$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 filterEmpWrkStaion($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] = 'WORK_STATION';
$arrFieldList[10] = 'EMP_PREF_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 updateEmpWrkStation() {
$arrRecordsList[0] = "'". $this->getEmpId() . "'";
$arrRecordsList[1] = ($this->getEmpLoc()=='0') ? 'null' : "'". $this->getEmpLoc() . "'";
$arrRecordsList[2] = ($this->getEmpPrefLoc()=='0') ? 'null' :"'". $this->getEmpPrefLoc() . "'";
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'WORK_STATION';
$arrFieldList[2] = 'EMP_PREF_WORK_STATION';
$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 filterEmpTax($getID) {
$this->getID = $getID;
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_PAYE_TAX_EXEMPT';
$arrFieldList[2] = 'EMP_TAXONTAX_FLG';
$arrFieldList[3] = 'EMP_TAX_ID_NUMBER';
$arrFieldList[4] = 'EMP_EPF_ELIGIBLE_FLG';
$arrFieldList[5] = 'EMP_EPF_NUMBER';
$arrFieldList[6] = 'EMP_EPF_PAYMENT_TYPE_FLG';
$arrFieldList[7] = 'EMP_EPF_EMPLOYEE_AMOUNT';
$arrFieldList[8] = 'EMP_EPF_EMPLOYER_AMOUNT';
$arrFieldList[9] = 'EMP_ETF_ELIGIBLE_FLG';
$arrFieldList[10] = 'EMP_ETF_NUMBER';
$arrFieldList[11] = 'EMP_ETF_EMPLOYEE_AMOUNT';
$arrFieldList[12] = 'EMP_ETF_DATE';
$arrFieldList[13] = 'EMP_MSPS_ELIGIBLE_FLG';
$arrFieldList[14] = 'EMP_MSPS_EMPLOYEE_AMOUNT';
$arrFieldList[15] = 'EMP_MSPS_EMPLOYER_AMOUNT';
$arrFieldList[16] = 'EMP_TAX_COUNTRY';
$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 updateEmpTax() {
$arrRecordsList[0] = "'". $this->getEmpId() . "'";
$arrRecordsList[1] = "'". $this->getEmpTaxExempt() . "'";
$arrRecordsList[2] = "'". $this->getEmpTaxOnTaxFlag() . "'";
$arrRecordsList[3] = "'". $this->getEmpTaxID() . "'";
$arrRecordsList[4] = "'". $this->getEmpEPFEligibleFlag() . "'";
$arrRecordsList[5] = "'". $this->getEmpEPFNo() . "'";
$arrRecordsList[6] = "'". $this->getCFundCBFundFlag() . "'";
$arrRecordsList[7] = "'". $this->getEPFEmployeePercen() . "'";
$arrRecordsList[8] = "'". $this->getEPFEmployerPercen() . "'";
$arrRecordsList[9] = "'". $this->getETFEligibleFlag() . "'";
$arrRecordsList[10] = "'". $this->getEmpETFNo() . "'";
$arrRecordsList[11] = "'". $this->getETFEmployeePercen() . "'";
$arrRecordsList[12] = "'". $this->getETFDat() . "'";
$arrRecordsList[13] = "'". $this->getMSPSEligibleFlag() . "'";
$arrRecordsList[14] = "'". $this->getMSPSEmployeePercen() . "'";
$arrRecordsList[15] = "'". $this->getMSPSEmployerPercen() . "'";
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_PAYE_TAX_EXEMPT';
$arrFieldList[2] = 'EMP_TAXONTAX_FLG';
$arrFieldList[3] = 'EMP_TAX_ID_NUMBER';
$arrFieldList[4] = 'EMP_EPF_ELIGIBLE_FLG';
$arrFieldList[5] = 'EMP_EPF_NUMBER';
$arrFieldList[6] = 'EMP_EPF_PAYMENT_TYPE_FLG';
$arrFieldList[7] = 'EMP_EPF_EMPLOYEE_AMOUNT';
$arrFieldList[8] = 'EMP_EPF_EMPLOYER_AMOUNT';
$arrFieldList[9] = 'EMP_ETF_ELIGIBLE_FLG';
$arrFieldList[10] = 'EMP_ETF_NUMBER';
$arrFieldList[11] = 'EMP_ETF_EMPLOYEE_AMOUNT';
$arrFieldList[12] = 'EMP_ETF_DATE';
$arrFieldList[13] = 'EMP_MSPS_ELIGIBLE_FLG';
$arrFieldList[14] = 'EMP_MSPS_EMPLOYEE_AMOUNT';
$arrFieldList[15] = 'EMP_MSPS_EMPLOYER_AMOUNT';
$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 filterEmpContact($getID) {
$this->getID = $getID;
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_STREET1';
$arrFieldList[2] = 'EMP_STREET2';
$arrFieldList[3] = 'CITY_CODE';
$arrFieldList[4] = 'COUN_CODE';
$arrFieldList[5] = 'PROVIN_CODE';
$arrFieldList[6] = 'EMP_ZIPCODE';
$arrFieldList[7] = 'EMP_HM_TELEPHONE';
$arrFieldList[8] = 'EMP_MOBILE';
$arrFieldList[9] = 'EMP_WORK_TELEPHONE';
$arrFieldList[10] = 'EMP_WORK_EMAIL';
$arrFieldList[11] = 'EMP_OTH_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 updateEmpContact() {
$arrRecordsList[0] = "'" . $this->getEmpId() . "'";
$arrRecordsList[1] = "'" . $this->getEmpStreet1() . "'";
$arrRecordsList[2] = "'" . $this->getEmpStreet2() . "'";
$arrRecordsList[3] = "'" . $this->getEmpCity() . "'";
$arrRecordsList[4] = "'" . $this->getEmpCountry() . "'";
$arrRecordsList[5] = "'" . $this->getEmpProvince() . "'";
$arrRecordsList[6] = "'" . $this->getEmpZipCode() . "'";
$arrRecordsList[7] = "'" . $this->getEmpHomeTelephone() . "'";
$arrRecordsList[8] = "'" . $this->getEmpMobile() . "'";
$arrRecordsList[9] = "'" . $this->getEmpWorkTelephone() . "'";
$arrRecordsList[10] = "'" . $this->getEmpWorkEmail() . "'";
$arrRecordsList[11] = "'" . $this->getEmpOtherEmail() . "'";
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_STREET1';
$arrFieldList[2] = 'EMP_STREET2';
$arrFieldList[3] = 'CITY_CODE';
$arrFieldList[4] = 'COUN_CODE';
$arrFieldList[5] = 'PROVIN_CODE';
$arrFieldList[6] = 'EMP_ZIPCODE';
$arrFieldList[7] = 'EMP_HM_TELEPHONE';
$arrFieldList[8] = 'EMP_MOBILE';
$arrFieldList[9] = 'EMP_WORK_TELEPHONE';
$arrFieldList[10] = 'EMP_WORK_EMAIL';
$arrFieldList[11] = 'EMP_OTH_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();
//echo $sqlQString;
//$log = new LogFileWriter();
//$log->writeLogDB($sqlQString);
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function
return $message2;
}
/////////////
/*function filterEmpTempRes($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_TEM_ADDRESS1';
$arrFieldList[10] = 'EMP_TEM_ADDRESS2';
$arrFieldList[11] = 'EMP_TEM_ADDRESS3';
$arrFieldList[12] = 'EMP_TEM_CITY';
$arrFieldList[13] = 'EMP_TEM_POSTALCODE';
$arrFieldList[14] = 'EMP_TEM_TELEPHONE';
$arrFieldList[15] = 'EMP_TEM_MOBILE';
$arrFieldList[16] = 'EMP_TEM_FAX';
$arrFieldList[17] = 'EMP_TEM_EMAIL';
$arrFieldList[18] = 'EMP_TEM_COU_CODE';
$arrFieldList[19] = 'EMP_TEM_PROVINCE_CODE';
$arrFieldList[20] = 'EMP_TEM_DISTRICT_CODE';
$arrFieldList[21] = 'EMP_TEM_ELECTORATE_CODE';
$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++)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -