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/teacher/class/   drwxr-xr-x
Free 52.39 GB of 127.8 GB (41%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     clsDocReceiveSend.php (36.32 KB)      -rw-r--r--

c=$c->c;
	$this->DB=$c->db;
}

function Save(){
	if ($this->status==1){
		$sql = "insert into DocReceiveSend values(
			'".th2a($this->DrsID)."',
 			'".th2a($this->DocID)."',
 			'".th2a($this->DlcID)."',
 			'".th2a($this->DsID)."',
 			'".th2a($this->personId)."',
 			'".th2a($this->PtID)."',
 			'".th2a($this->DrsDocTypeNo)."',
 			'".th2a($this->DrsReceiveDate)."',
 			'".th2a($this->DrsReceivePersonId)."',
 			'".th2a($this->DrsSendDate)."',
 			'".th2a($this->DrsSendPersonId)."',
 			'".th2a($this->DrsSendDlcID)."',
			'".th2a($this->DrsDocDueDate)."',
			'".th2a($this->DrsDlcIDCreate)."',
 			'".th2a($this->DrsPsIDCreate)."',
 			'".th2a($this->DrsPropose)."',
 			'".th2a($this->DrsSign)."',
 			'".th2a($this->DrsFromDrsID)."',
 			'".th2a($this->DocGroup)."',
			'".th2a($this->DrsflagRead)."',
			'".th2a($this->DrsByPass)."',
			'".th2a($this->DrsSend)."',
			'".th2a($this->DrsSendToPs)."',
			'".th2a($this->DrsDelete)."',
			'".th2a($this->DrsMainPs)."',
			'".th2a($this->AnID)."',
			'".th2a($this->DrsDocReceiveDate)."',
			'".th2a($this->DocRefAnsDate)."',
			'".th2a($this->DrsSendDocNew)."',
			'".th2a($this->DrsInboxID)."',
			'".th2a($this->DrsstartDatePost)."',
			'".th2a($this->DrsendDatePost)."',
			'".th2a($this->DrsSendBack)."',
			'".th2a($this->DrsSendBackDlcID)."',
			'".th2a($this->DrsfSendBack)."',
			'".th2a($this->DrsReadDoc)."',
			'".th2a($this->DrsWSign)."'
			)";
	}else {
		$sql = "update DocReceiveSend set 
			DocID='".th2a($this->DocID)."', 
			DlcID='".th2a($this->DlcID)."', 
			DsID='".th2a($this->DsID)."', 
			personId='".th2a($this->personId)."', 
			PtID='".th2a($this->PtID)."', 
			DrsDocTypeNo='".th2a($this->DrsDocTypeNo)."', 
			DrsReceiveDate='".th2a($this->DrsReceiveDate)."', 
			DrsReceivePersonId='".th2a($this->DrsReceivePersonId)."', 
			DrsSendDate='".th2a($this->DrsSendDate)."', 
			DrsSendPersonId='".th2a($this->DrsSendPersonId)."', 
			DrsSendDlcID='".th2a($this->DrsSendDlcID)."', 
			DrsDocDueDate='".th2a($this->DrsDocDueDate)."',
			DrsDlcIDCreate='".th2a($this->DrsDlcIDCreate)."', 
			DrsPsIDCreate='".th2a($this->DrsPsIDCreate)."', 
			DrsPropose='".th2a($this->DrsPropose)."', 
			DrsSign='".th2a($this->DrsSign)."', 
			DrsFromDrsID='".th2a($this->DrsFromDrsID)."', 
			DocGroup='".th2a($this->DocGroup)."',
			DrsflagRead='".th2a($this->DrsflagRead)."',
			DrsByPass='".th2a($this->DrsByPass)."',
			DrsSend='".th2a($this->DrsSend)."',
			DrsSendToPs='".th2a($this->DrsSendToPs)."',
			DrsDelete='".th2a($this->DrsDelete)."',
			DrsMainPs='".th2a($this->DrsMainPs)."',
			AnID='".th2a($this->AnID)."',
			DrsDocReceiveDate='".th2a($this->DrsDocReceiveDate)."',
			DocRefAnsDate='".th2a($this->DocRefAnsDate)."',
			DrsSendDocNew='".th2a($this->DrsSendDocNew)."',
			DrsInboxID='".th2a($this->DrsInboxID)."',
			DrsstartDatePost='".th2a($this->DrsstartDatePost)."',
			DrsendDatePost='".th2a($this->DrsendDatePost)."',
			DrsSendBack='".th2a($this->DrsSendBack)."',
			DrsSendBackDlcID='".th2a($this->DrsSendBackDlcID)."',
			DrsfSendBack='".th2a($this->DrsfSendBack)."',
			DrsReadDoc='".th2a($this->DrsReadDoc)."',
			DrsWSign='".th2a($this->DrsWSign)."'
			where DrsID='".th2a($this->DrsID)."'";
			//echo "----------".$sql.'
';
	}
	return $this->Dml($sql);
}

function Delete(){
	return $this->Dml("delete from DocReceiveSend where DrsID='$this->DrsID'");
}
function NumRow(){
	return $this->GetRowSelected();
}
function GetNextCode(){
	$this->SetQuery("select max(DrsID) as num from DocReceiveSend");
	if ($result=$this->GetResult()) {
		return $result['num']+1;
	}
}

function RSDocReceiveSend(){
	$this->SetQuery("select * from DocReceiveSend order by DrsID");
}

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)."'];");
			$this->DrsPropose=a2th($this->DrsPropose);
			$this->DrsSign=a2th($this->DrsSign);
			$this->DrsSendBack=$this->DrsSendBack;
		}
		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 DocReceiveSend where DrsID= '$xKey'")){ 
		return 1;
	}else {
		return 0;
	}
}

//****************** You can add new functions below **********************//
function SearchByKeyName($xKey,$name){
	if ($this->SetQuery("select $name from DocReceiveSend where DrsID= '$xKey'")){ 
		return 1;
	}else {
		return 0;
	}
}
function SearchByDocGroupDocIDStatus2($xKey,$yKey){   
	//echo "select * from DocReceiveSend where DocGroup='$xKey' and  DocID='$yKey' and DsID='2'";
	if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$xKey' and  DocID='$yKey' and DsID='2'")){ 
		return 1;
	}else {
		return 0;
	}
}
function SearchByDocGroupDocIDStatus0($xKey,$yKey){   
	if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$xKey' and  DocID='$yKey' and DsID='0' and DrsSendDate='0000-00-00 00:00:00'")){ 
		return 1;
	}else {
		return 0;
	}
}
function SearchByDlcIDDocGroup2($xKey,$yKey){
	//echo "select * from DocReceiveSend where DlcID= '$xKey' and DocGroup='$yKey'
";
	if ($this->SetQuery("select * from DocReceiveSend where DlcID= '$xKey' and DocGroup='$yKey'")){
		return 1;
	}else {
		return 0;
	}
}

function SearchByDocIDDocGroupStatus($xKey,$yKey,$zKey){
	//echo "select * from DocReceiveSend where DocID= '$xKey' and DocGroup='$yKey' and DsID ='$zKey'
";
	if ($this->SetQuery("select * from DocReceiveSend where DocID= '$xKey' and DocGroup='$yKey' and DsID ='$zKey'")){ 
		return 1;
	}else {
		return 0;
	}
}

function SearchByDlcIDDocGroupDocId($xKey,$yKey,$zKey){
	if ($this->SetQuery("select * from DocReceiveSend where DlcID= '$xKey' and DocGroup='$yKey' and DocID='$zKey'")){ 
		return 1;
	}else {
		return 0;
	}
}
function SearchByDocGroupDocIDDlcIDDrsReceiveDlcID2Status2($xKey,$yKey,$zKey,$zKey3){
	if ($this->SetQuery("select * from DocReceiveSend where DocGroup= '$xKey' and DocID='$yKey' and (DlcID='$zKey' 
bool(false)