<?php
//--Class person--------------------------
//--PK of person ::
//	1. personId

class person extends clsDB{

var $result;

var $personId;
var $deptId;
var $workGpId; 
var $prefixId;
var $fName;
var $lName;
var $fStatus;
var $adminId;
var $fRetire;
var $hireId;

function person(&$c){
	$this->c=$c->c;
	$this->DB=$c->db;
}

function Save(){
	if ($this->status==1){
		//uncomment a line below if your table use ID as running number
		//$this->personId=$this->GetNextCode();
		//echo $sql."<br>";
		$sql = "insert into Person values(
			'$this->personId',
 			'$this->deptId',
 			'$this->workGpId',
 			'$this->prefixId',
 			'$this->fName',
 			'$this->lName',
 			'$this->fStatus',
			'$this->adminId',
			'$this->fRetire',
			'$this->hireId'
			)";
	}else {
		$sql = "update Person set 
			deptId='$this->deptId', 
			workGpId='$this->workGpId', 
			prefixId='$this->prefixId', 
			fName='$this->fName', 
			lName='$this->lName', 
			fStatus='$this->fStatus',
			adminId='$this->adminId',
			fRetire='$this->fRetire',
			hireId='$this->hireId'
			where personId='$this->personId'";
	}
	return $this->Dml($sql);
}

function Delete(){
	return $this->Dml("delete from Person where personId='$this->personId'");
}

function GetNextCode(){
	$this->SetQuery("select max(personId) as num from Person");
	if ($result=$this->GetResult()) {
		return $result['num']+1;
	}
}

function RSperson(){
	$this->SetQuery("select * from Person  where fStatus='1' and fRetire='0' order by personId");
}
function RSperson2(){
	$this->SetQuery("select * from Person  order by personId");
}
function GetRecord(){
	$numFields = $this->NumField();
	$row = $this->GetResult();
	if ($row){
		for ($i=0; $i<$numFields; $i++){
			eval("\$this->".mysql_field_name($this->rs, $i)."=\$row['".mysql_field_name($this->rs, $i)."'];");
		}
		return true;
	}else{	// clear value of Member;
		for ($i=0; $i<$numFields; $i++){
			eval("\$this->".mysql_field_name($this->rs, $i)."='';");
		}
		return false;
	}
}
function SearchByKey($xKey){
	if ($this->SetQuery("select * from Person where personId= '$xKey' order by personId asc")){ 
		return 1;
	}else {
		return 0;
	}
}
//****************** You can add new functions below **********************//
function CountPersonByDPID($xKey,$yKey){
	$this->SetQuery("select count(personId) as num from Person where (deptId= '$xKey' or deptId= '$yKey') and fStatus=1 and fRetire=0");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}
function CountPerson(){
	$this->SetQuery("select count(personId) as num from Person where fStatus=1 and fRetire=0");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}
function CountPersonDept($xKey){
	$this->SetQuery("select count(personId) as num from Person where deptId='$xKey' and fStatus=1 and fRetire=0");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}
function SearchByDPID($xKey,$yKey){
//--ค้นหาข้อมูลตาม PK ต้องระบุพารามิเตอร์ด้วย และต้องตามด้วยเมธอด GetRecord() เสมอ
	if ($this->SetQuery("select * from Person where (deptId= '$xKey' or deptId= '$yKey') and fStatus=1 and fRetire=0 order by personId asc")){ 
		return 1;
	}else {
		return 0;
	}
}
function SearchByDeptId($xKey){
	if ($this->SetQuery("select * from Person where deptId= '$xKey' and fStatus=1 and fRetire=0 order by personId asc")){ 
		return 1;
	}else {
		return 0;
	}
}
function SearchByDeptIdadminId($xKey){
	if ($this->SetQuery("select * from Person where deptId= '$xKey' and fStatus=1 and fRetire=0 order by adminId asc , hireId asc")){ 
		return 1;
	}else {
		return 0;
	}
}
function CountPersonDeptWorkGroup($xKey,$yKey){
	$this->SetQuery("select count(personId) as num from Person where deptId='$xKey' and fStatus=1 and fRetire=0 and workGpId = '$yKey'");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}
function SearchByName($xKey){
	if ($this->SetQuery("select * from Person where (fName like '%$xKey%' or lName like '%$xKey%') order by personId asc")){ 
		return 1;
	}else {
		return 0;
	}
}
function SearchfNamelName($xKey,$yKey){
	if ($this->SetQuery("select * from Person where (fName ='$xKey' and lName = '$yKey') order by personId asc")){ 
		return 1;
	}else {
		return 0;
	}
}
function RSPersonf1dept($xKey){
	//
    $this->dpSet = false;
	$this->SetQuery("select * from Person where fStatus = 1 and fRetire=0 and deptId='$xKey' order by personId asc");
}

function RSPersonf1(){
	$this->SetQuery("select * from Person where fStatus = 1 order by personId asc");
}
function RSPersonf1PE($xKey){
	$this->SetQuery("select * from $xKey.Person where fStatus = 1 order by personId asc");
}
function SearchByDeptId2($xKey){
//echo "select personId, lName,fName,prefixId, deptId from Person where deptId='$xKey' and fRetire=0 order by personId asc<br>";
	if ($this->SetQuery("select personId, lName,fName,prefixId, deptId from Person where deptId='$xKey' and fRetire=0 order by personId asc")){ 
		return 1;
	}else {
		return 0;
	}
}
} //--End class person--

?>