📄 provinceinfo.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';
class ProvinceInfo {
var $tableName;
var $provinceId;
var $provinceDesc;
var $countryId;
var $arrayDispList;
var $singleField;
function ProvinceInfo() {
}
function setProvinceInfoId($provinceId) {
$this->provinceId = $provinceId;
}
function setProvinceInfoDesc($provinceDesc) {
$this->provinceDesc = $provinceDesc;
}
function setCountryId($countryId) {
$this->countryId = $countryId;
}
function getProvinceInfoId() {
return $this->provinceId;
}
function getProvinceInfoDesc() {
return $this->provinceDesc;
}
function getCountryId() {
return $this->countryId;
//echo $this->countryId;
}
function getListofProvinceInfo($pageNO,$schStr,$mode) {
$tableName = 'HS_HR_PROVINCE';
$arrFieldList[0] = 'PROVINCE_CODE';
$arrFieldList[1] = 'PROVINCE_NAME';
$arrFieldList[2] = 'COU_CODE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->passResultSetMessage($pageNO,$schStr,$mode, 1);
//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 countProvinceInfo($schStr,$mode) {
$tableName = 'HS_HR_PROVINCE';
$arrFieldList[0] = 'PROVINCE_CODE';
$arrFieldList[1] = 'PROVINCE_NAME';
$arrFieldList[2] = 'COU_CODE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->countResultset($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 filterGetProvinceCodeInfo($getID) {
$this->getID = $getID;
$tableName = 'HS_HR_PROVINCE';
$arrFieldList[0] = 'PROVINCE_CODE';
$arrFieldList[1] = 'PROVINCE_NAME';
$arrFieldList[2] = 'COU_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)) {
$arrayDispList[$i][0] = $line[0]; // Province Code
$arrayDispList[$i][1] = $line[1]; // Provicne Name
$arrayDispList[$i][2] = $line[2];
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function filterNotEqualProvinceInfo($getID) {
$this->getID = $getID;
$tableName = 'HS_HR_PROVINCE';
$arrFieldList[0] = 'PROVINCE_CODE';
$arrFieldList[1] = 'PROVINCE_NAME';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->filterNotEqualRecordSet($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]; // Province Code
$arrayDispList[$i][1] = $line[1]; // Provicne Name
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function filterProvinceInfo($getID) {
$this->getID = $getID;
$tableName = 'HS_HR_PROVINCE';
$arrFieldList[0] = 'PROVINCE_CODE';
$arrFieldList[1] = 'PROVINCE_NAME';
$arrFieldList[2] = 'COU_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)) {
$arrayDispList[$i][0] = $line[0]; // Province Code
$arrayDispList[$i][1] = $line[1]; // Provicne Name
$arrayDispList[$i][2] = $line[2]; // Country ID
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function filterGetCountryCodeInfo($getID) {
$this->getID = $getID;
$tableName = 'HS_HR_COUNTRY';
$arrFieldList[0] = 'COU_CODE';
$arrFieldList[1] = 'COU_NAME';
$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]; // Province Code
$arrayDispList[$i][1] = $line[1]; // Provicne Name
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function filterNotEqualCountryInfo($getID) {
$this->getID = $getID;
$tableName = 'HS_HR_COUNTRY';
$arrFieldList[0] = 'COU_CODE';
$arrFieldList[1] = 'COU_NAME';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->filterNotEqualRecordSet($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]; // Province Code
$arrayDispList[$i][1] = $line[1]; // Provicne Name
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
/////////////////filterNotEqualRecordSet($filterID)
function getCountryCodes () {
$sql_builder = new SQLQBuilder();
$tableName = 'HS_HR_COUNTRY';
$arrFieldList[0] = 'COU_CODE';
$arrFieldList[1] = 'COU_NAME';
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->passResultSetMessage(0,'',-1,1);
$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];
//$arrayDispList[$i][2] = $line[2];
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
//Handle Exceptions
//Create Logs
}
}
function getProvinceCodes($getID) {
$this->getID = $getID;
$tableName = 'HS_HR_PROVINCE';
$arrFieldList[0] = 'COU_CODE';
$arrFieldList[1] = 'PROVINCE_CODE';
$arrFieldList[2] = 'PROVINCE_NAME';
$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;
}
}
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -