<?php
//--Class Person--------------------------
//--PK of Person ::
//	1. personId

class PersonPE extends clsDB{

var $result;

var $personId;
var $prefixId;
var $fName;
var $lName;
var $receiveDate;
var $pId;
var $adlineId;
var $adminposId;
var $hireId;
var $majortypeId;
var $levelposId;
var $stepSal;
var $salary;
var $partyId;
var $deptId;
var $majorId;
var $assignId;
var $promoteDate;
var $educDate;
var $posDate;
var $fullsalDate;
var $typemoveId;
var $fyDecor;
var $lastDecor;
var $fRetire;
var $adminId;
var $done;
var $accountNo;
var $useSalary;
var $personCode;
var $oldpersonCode;
var $admidYear;
var $partyAtId;
var $partypracticeId;
var $firstadmidDate;
var $posDegree;
var $posEducmajor;
var $enterType;
var $fStatus;
var $salary2;
var $fullStep;
var $levelposId2;
var $stepSal2;
var $useSalary2;

function PersonPE(&$c){
	$this->c=$c->c;
	$this->DB=$c->db;
    $this->dpSet = false;
    $this->departmentId = 0;
}

function RSPerson(){
    $this->dpSet = false;
	$this->SetQuery("select * from Person order by personId");
}

function RSDPPerson($Pdb, $Edb){
    $this->dpSet = true;
	$this->SetQuery("select Person.*, department.departmentId from $Pdb.Person, $Edb.department where department.departmentMapId = Person.deptId and Person.fStatus = '1' order by Person.personId");
}
function RSPersonf1(){
	//
    $this->dpSet = false;
	$this->SetQuery("select * from Person where fStatus = 1 order by personId asc");
}

function GetRecord(){
	if ($this->result = $this->GetResult()) {
		$this->personId = $this->result['personId'];
		$this->prefixId = $this->result['prefixId'];
		$this->fName = $this->result['fName'];
		$this->lName = $this->result['lName'];
		$this->receiveDate = $this->result['receiveDate'];
		$this->pId = $this->result['pId'];
		$this->adlineId = $this->result['adlineId'];
		$this->adminposId = $this->result['adminposId'];
		$this->hireId = $this->result['hireId'];
		$this->majortypeId = $this->result['majortypeId'];
		$this->levelposId = $this->result['levelposId'];
		$this->stepSal = $this->result['stepSal'];
		$this->salary = $this->result['salary'];
		$this->partyId = $this->result['partyId'];
		$this->deptId = $this->result['deptId'];
		$this->majorId = $this->result['majorId'];
		$this->assignId = $this->result['assignId'];
		$this->promoteDate = $this->result['promoteDate'];
		$this->educDate = $this->result['educDate'];
		$this->posDate = $this->result['posDate'];
		$this->fullsalDate = $this->result['fullsalDate'];
		$this->typemoveId = $this->result['typemoveId'];
		$this->fyDecor = $this->result['fyDecor'];
		$this->lastDecor = $this->result['lastDecor'];
		$this->fRetire = $this->result['fRetire'];
		$this->adminId = $this->result['adminId'];
		$this->done = $this->result['done'];
		$this->accountNo = $this->result['accountNo'];
		$this->useSalary = $this->result['useSalary'];
		$this->personCode = $this->result['personCode'];
		$this->oldpersonCode = $this->result['oldpersonCode'];
		$this->admidYear = $this->result['admidYear'];
		$this->partyAtId = $this->result['partyAtId'];
		$this->partypracticeId = $this->result['partypracticeId'];
		$this->firstadmidDate = $this->result['firstadmidDate'];
		$this->posDegree = $this->result['posDegree'];
		$this->posEducmajor = $this->result['posEducmajor'];
		$this->enterType = $this->result['enterType'];
		$this->fStatus = $this->result['fStatus'];
		$this->salary2 = $this->result['salary2'];
		$this->fullStep = $this->result['fullStep'];
		$this->levelposId2 = $this->result['levelposId2'];
		$this->stepSal2 = $this->result['stepSal2'];
		$this->useSalary2 = $this->result['useSalary2'];
        if ($this->dpSet)
            $this->departmentId = $this->result['departmentId'];
		return 1;
	}else {
		return 0;
	}
}

function SearchByKey($xKey){
	if ($this->SetQuery("select * from Person where personId= '$xKey' order by personId asc")){ 
		return 1;
	}else {
		return 0;
	}
}
function RSAllperson(){
	$this->SetQuery("select * from Person order by personId asc");
}
//****************** You can add new functions below **********************//
function RSPersonf1dept($xKey){
	//
    $this->dpSet = false;
	$this->SetQuery("select * from Person where fStatus = 1 and deptId='$xKey' order by personId asc");
}
} //--End class Person--

?>