function ShowDept($deptId){
include_once("../../class/clsConnection.php");
include_once("../../class/clsDB.php");
include_once "../global.php";
include_once "../class/clsTable.php";
include_once "../class/clsDepartment.php";
include_once "../class/clsPerson.php";
include_once "../link/function.php";
include_once "getPrefix.php";
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);
$oDP = new Department($oC);
$oDP2 = new Department($oC);
$oPS = new person($oC);
$oDP2->SearchByDeptRef($deptId);
$oDP2->GetRecord();
$oPS->SearchByDeptId($oDP2->deptId);
while($oPS->GetRecord()){
$GLOBALS["COUNTPS"]++;
}
if($oDP2->deptRef!="0"){
ShowDept($oDP2->deptRef);
}
}
//ImportPerson
function ShowDept2($deptId){
include_once("../../class/clsConnection.php");
include_once("../../class/clsDB.php");
include_once "../global.php";
include_once "../class/clsTable.php";
include_once "../class/clsDepartment.php";
include_once "../class/clsPerson.php";
include_once "../link/function.php";
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);
$oDP = new Department($oC);
$oDP2 = new Department($oC);
$oPS = new person($oC);
$oDP2->SearchByDeptRef($deptId);
$oDP2->GetRecord();
$oPS->SearchByDeptId($oDP2->deptId);
while($oPS->GetRecord()){
$GLOBALS["COUNTP"]++;
echo "
";
echo $GLOBALS["COUNTP"].". ".GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName." |
";
}
if($oDP2->deptRef!="0"){
ShowDept2($oDP2->deptRef);
}
return $GLOBALS["COUNTP"];
}
//addWorkGroupPs
function ShowDept3($deptId,$deptIdfirst){
include_once("../../class/clsConnection.php");
include_once("../../class/clsDB.php");
include_once "../global.php";
include_once "../class/clsTable.php";
include_once "../class/clsDepartment.php";
include_once "../class/clsPerson.php";
include_once "../link/function.php";
include_once "../class/clsWorkGroup.php";
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);
$oDP = new Department($oC);
$oDP2 = new Department($oC);
$oPS = new person($oC);
$oWG = new workGroup($oC);
$oWG2 = new workGroup($oC);
$oDP2->SearchByDeptRef($deptId);
$oDP2->GetRecord();
$oPS->SearchByDeptId($oDP2->deptId);
while($oPS->GetRecord()){
$GLOBALS["COUNTP2"]++;
if(($GLOBALS["COUNTP2"]%2) == 0)
echo "";
else
echo "
";
echo " ";
echo $GLOBALS["COUNTP2"].". ".GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName;
echo " | ";
$countps=$GLOBALS["COUNTP2"];
echo "personId\">";
echo " |
";
}
if($oDP2->deptRef!="0"){
ShowDept3($oDP2->deptRef,$deptIdfirst);
}
return $GLOBALS["COUNTP2"];
}
//updatePerson
function ShowDept4($deptId,$deptIdfirst){
include_once("../../class/clsConnection.php");
include_once("../../class/clsDB.php");
include_once "../global.php";
include_once "../class/clsTable.php";
include_once "../class/clsDepartment.php";
include_once "../class/clsPerson.php";
include_once "../link/function.php";
include_once "../class/clsWorkGroup.php";
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);
$oDP = new Department($oC);
$oDP2 = new Department($oC);
$oPS = new person($oC);
$oWG = new workGroup($oC);
$oWG2 = new workGroup($oC);
$oWG3 = new workGroup($oC);
$oDP2->SearchByDeptRef($deptId);
$oDP2->GetRecord();
$oPS->SearchByDeptId($oDP2->deptId);
while($oPS->GetRecord()){
$GLOBALS["COUNTP3"]++;
echo " ";
echo $GLOBALS["COUNTP3"]." ".GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName." | ";
$oWG2->SearchBydeptId($deptIdfirst);
if($oWG2->GetRecord()=="1"){
$oWG3->SearchByKey($oPS->workGpId);
if($oWG3->GetRecord()=="0"){
echo " ยังไม่ระบุงาน | ";
}else{
echo " งาน$oWG3->workGpName | ";
}
}
echo "
";
}
if($oDP2->deptRef!="0"){
ShowDept4($oDP2->deptRef,$deptIdfirst);
}
return $GLOBALS["COUNTP3"];
}
// show cout person in dept
function CountPsAllDeptRef($deptIdf){
include_once("../../class/clsConnection.php");
include_once("../../class/clsDB.php");
include_once "../global.php";
include_once "../class/clsTable.php";
include_once "../class/clsDepartment.php";
include_once "../class/clsPerson.php";
include_once "../link/function.php";
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);
$oDP = new Department($oC);
$oDP2 = new Department($oC);
$oPS = new person($oC);
$oDP->SearchByKey($deptIdf);
$oDP->GetRecord();
$GLOBALS["COUNTPS"]=0;
$oPS->SearchByDeptId($oDP->deptId);
while($oPS->GetRecord()){
$GLOBALS["COUNTPS"]++;
}
if($oDP->deptRef!="0"){
ShowDept($oDP->deptRef);
}
return $GLOBALS["COUNTPS"];
}
?>