Viewing file: CountPsAllDeptRef.php (5.88 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<? 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 "<tr><td colspan=\"2\" height=\"22\"> "; echo $GLOBALS["COUNTP"].". ".GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName."</td></tr>"; } 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 "<tr>"; else echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TD_16"]."\">"; echo "<td height=\"22\"> "; echo $GLOBALS["COUNTP2"].". ".GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName; echo "<td align=\"center\">"; $countps=$GLOBALS["COUNTP2"]; echo "<input type=\"hidden\" name=\"personId[".$countps."]\" id=\"personId[".$countps."]\" value=\"$oPS->personId\">"; echo "<select name=\"workGpId[".$GLOBALS["COUNTP2"]."]\" id=\"workGpId[".$GLOBALS["COUNTP2"]."]\">"; echo "<option value=\"0\""; if($oPS->workGpId==0) { echo "selected"; } echo ">กำหนดงาน</option>"; $oWG->SearchBydeptId($deptIdfirst); while($oWG->GetRecord()){ echo "<option value=\"$oWG->workGpId\""; if($oPS->workGpId==$oWG->workGpId) { echo "selected"; } echo ">$oWG->workGpName</option>"; } echo "</select></tr>"; } 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 "<tr><td height=\"22\"> "; echo $GLOBALS["COUNTP3"]." ".GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName."</td>"; $oWG2->SearchBydeptId($deptIdfirst); if($oWG2->GetRecord()=="1"){ $oWG3->SearchByKey($oPS->workGpId); if($oWG3->GetRecord()=="0"){ echo "<td width=\"38%\" align=\"left\"> ยังไม่ระบุงาน</td>"; }else{ echo "<td width=\"38%\" align=\"left\"> งาน$oWG3->workGpName</td>"; } } echo "</tr>"; } 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"]; } ?>
|