Software: Apache/2.2.3 (CentOS). PHP/5.1.6 

uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44
EDT 2010 i686 

uid=48(apache) gid=48(apache) groups=48(apache) 

Safe-mode: OFF (not secure)

/var/www/html/manage/person/admin/   drwxr-xr-x
Free 52.3 GB of 127.8 GB (40.92%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     processImportPerson.php (2.99 KB)      -rw-r--r--

<?php
include_once "template.php";
include_once "../link/function.php";
include_once "../class/clsTable.php";
include_once "../class/clsDepartment.php";
include_once "../class/clsPerson.php";
include_once "../class/clsDepartmentPE.php";
include_once "../class/clsPersonPE.php";

$oCc = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EPERSON'], $GLOBALS['DBUSER_EPERSON'], $GLOBALS['DBPASS_EPERSON']);
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);

$oDP = new Department($oC);
$oPS = new person($oC);
$oDPp = new departmentPE($oCc);
$oDPp2 = new departmentPE($oCc);
$oPSp = new PersonPE($oCc);

echo "<br><br><div align=center><strong>--- ГРєєЎУЕС§№УўйНБЩЕєШ¤ЕТЎГаўйТ ЎГШіТГНКСЎ¤ГЩи ---</strong></div>";
			 $maxdate=$oDPp->MaxDate();
			$flagCommit = true;
			$checkflagCommit= true;
			$oC->BeginTrans();

 $oDPp->RSdepartment2();
 while($oDPp->GetRecord()){
 			$oDP->AddNew();
			$oDP->deptId=$oDPp->deptId;
			//echo "deptId=".$oDP->deptId."<br>";
			$oDP->deptName=$oDPp->deptName;
			//echo "deptName=".$oDP->deptName."<br>";
			$oDP->deptDesc=$oDPp->deptDesc;
			$oDP->deptCode=$oDPp->deptCode;
			$oDP->deptParent=$oDPp->deptParent;
			$oDP->deptYear=$oDPp->deptYear;
			$oDP->deptDate=$oDPp->deptDate;
			//echo "deptDate=".$oDP->deptDate."<br>";
			$oDP->deptRef=$oDPp->deptRef;
			$oDP->pbriId=$oDPp->pbriId;
			$oDP->deptIsCenter="";
			$oDP->receiveIn="Y";
			$oDP->sendIn="Y";
			$oDP->sendOut="Y";
			$oDP->deptNo=$oDPp->deptNo;
			//echo "deptNo=".$oDP->deptNo."<br>";
			if($oDP->deptDate==$maxdate){
				$oDP->docGroup=1;
			}else{
				$oDP->docGroup=0;
			}
			$oDP->depttypeId=$oDPp->depttypeId;
			//echo "depttypeId=".$oDP->depttypeId."<br>";
			$oDP->deptParentId=$oDPp->deptParentId;
			//echo "deptParentId=".$oDP->deptParentId."<br>";
			$oDP->deptLevel=$oDPp->deptLevel;
			//echo "deptLevel=".$oDP->deptLevel."<br>";
			$oDP->deptGroup=$oDPp->deptGroup;
		//echo "deptGroup=".$oDP->deptGroup."<br>";			
			$checkflagCommit = $oDP->Save();
			if(!$checkflagCommit){ $flagCommit=$checkflagCommit;   }
 }     
 
$oPSp->RSPersonf1();
 while($oPSp->GetRecord()){
 			$oPS->AddNew();
			$oPS->personId=$oPSp->personId;
			//echo "e=".$oPS->personId."p=".$oPSp->personId."n=".$oPSp->fName."<br>";
			$oPS->deptId=$oPSp->deptId;
			$oPS->workGpId="";
			if($oPSp->prefixId=="2" ||  $oPSp->prefixId=="3"){
				$oPS->prefixId=$oPSp->prefixId;
			}else{
				$oPS->prefixId="1";
			}
			$oPS->fName=$oPSp->fName;
			$oPS->lName=$oPSp->lName;
			$oPS->fStatus=$oPSp->fStatus;
			$oPS->adminId=$oPSp->adminId;
			$oPS->fRetire=$oPSp->fRetire;
			$oPS->hireId=$oPSp->hireId;
			$checkflagCommit = $oPS->Save();
			if(!$checkflagCommit){ $flagCommit=$checkflagCommit;   }
 }
	if($flagCommit)
		$oC->CommitTrans();
	else
		$oC->RollbackTrans();
                                                 
echo "<meta http-equiv='refresh' content='0; URL=ImportPerson.php?s=1'>";

?>