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 (40.99%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     clsDocuments.php (79.07 KB)      -rw-r--r--

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

function Save(){
	if ($this->status==1){	
		 $sql = "insert into Documents values(
			'".th2a($this->DocID)."',
			'".th2a($this->DocPID)."',
			'".th2a($this->DlcID)."',
			'".th2a($this->PtID)."',
			'".th2a($this->DtID)."',
			'".th2a($this->DslID)."',
			'".th2a($this->DclID)."',
			'".th2a($this->DsID)."',
			'".th2a($this->RsID)."',
			'".th2a($this->DocDateCreate)."',
			'".th2a($this->DocUserCreate)."',
			'".th2a($this->DocTypeNo)."',
			'".th2a($this->DocDate)."',
 			'".th2a($this->DocNo)."',
			'".th2a($this->DocSubject)."',
			'".th2a($this->DocFrom)."',
			'".th2a($this->DocTo)."',
			'".th2a($this->DocShortDesc)."',
			'".th2a($this->DocSpeedLevelDueDate)."',
			'".th2a($this->DocStart)."',
			'".th2a($this->DocFinish)."',
			'".th2a($this->DocGroup)."',			
			'".th2a($this->DocRef)."',
			'".th2a($this->DocCircular)."',
			'".th2a($this->DocfCir)."',
			'".th2a($this->DocOther)."',
			'".th2a($this->CertificatePs)."',
			'".th2a($this->fDelete)."',
			'".th2a($this->endDoc)."',
			'".th2a($this->sendToPs)."',
			'".th2a($this->AnID)."',
			'".th2a($this->DocRefAns)."',
			'".th2a($this->DocRefAnsID)."',
			'".th2a($this->DocstartDatePost)."',
			'".th2a($this->DocendDatePost)."',
			'".th2a($this->DocMainPost)."',
			'".th2a($this->DocGetPost)."',
			'".th2a($this->DocShowInOut)."',
			'".th2a($this->DocDateGetPost)."',
			'".th2a($this->useMainDocNo)."',
			'".th2a($this->stdCode)."',
			'".th2a($this->DocforSign)."'
			)";
	}else {
		$sql = "update Documents set 
			DocPID='".th2a($this->DocPID)."', 
			DlcID='".th2a($this->DlcID)."', 
			PtID='".th2a($this->PtID)."', 
			DtID='".th2a($this->DtID)."', 
			DslID='".th2a($this->DslID)."', 
			DclID='".th2a($this->DclID)."', 
			DsID='".th2a($this->DsID)."', 
			RsID='".th2a($this->RsID)."', 
			DocDateCreate='".th2a($this->DocDateCreate)."', 
			DocUserCreate='".th2a($this->DocUserCreate)."', 
			DocTypeNo='".th2a($this->DocTypeNo)."', 
			DocDate='".th2a($this->DocDate)."', 
			DocNo='".th2a($this->DocNo)."', 
			DocSubject='".th2a($this->DocSubject)."', 
			DocFrom='".th2a($this->DocFrom)."', 
			DocTo='".th2a($this->DocTo)."', 
			DocShortDesc='".th2a($this->DocShortDesc)."', 
			DocSpeedLevelDueDate='".th2a($this->DocSpeedLevelDueDate)."', 
			DocStart='".th2a($this->DocStart)."', 
			DocFinish='".th2a($this->DocFinish)."', 
			DocGroup='".th2a($this->DocGroup)."', 
			DocRef='".th2a($this->DocRef)."', 
			DocCircular='".th2a($this->DocCircular)."', 
			DocfCir='".th2a($this->DocfCir)."', 
			DocOther='".th2a($this->DocOther)."', 
			CertificatePs='".th2a($this->CertificatePs)."', 
			fDelete='".th2a($this->fDelete)."',
			endDoc='".th2a($this->endDoc)."' ,
			sendToPs='".th2a($this->sendToPs)."',
			AnID='".th2a($this->AnID)."',
			DocRefAns='".th2a($this->DocRefAns)."',
			DocRefAnsID='".th2a($this->DocRefAnsID)."',
			DocstartDatePost='".th2a($this->DocstartDatePost)."',
			DocendDatePost='".th2a($this->DocendDatePost)."',
			DocMainPost='".th2a($this->DocMainPost)."',
			DocGetPost='".th2a($this->DocGetPost)."',
			DocShowInOut='".th2a($this->DocShowInOut)."',
			DocDateGetPost='".th2a($this->DocDateGetPost)."',
			useMainDocNo='".th2a($this->useMainDocNo)."',
			stdCode='".th2a($this->stdCode)."',
			DocforSign='".th2a($this->DocforSign)."'			
			where DocID='".th2a($this->DocID)."'";
	}
	return $this->Dml($sql);
}

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

function RSDocuments(){
	$this->SetQuery("select * from Documents order by DocID");
}

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->DocNo=a2th($this->DocNo);
			$this->DocSubject=a2th($this->DocSubject);
			$this->DocFrom=a2th($this->DocFrom);
			$this->DocTo=a2th($this->DocTo);
			$this->DocShortDesc=a2th($this->DocShortDesc);
			$this->DocRef=a2th($this->DocRef);
			$this->DocCircular=a2th($this->DocCircular);
			$this->DocOther=a2th($this->DocOther);
			$this->CertificatePs=a2th($this->CertificatePs);
			$this->DocRefAns=a2th($this->DocRefAns);		
		}
		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 Documents where DocID= '$xKey'")){ 
		return 1;
	}else {
		return 0;
	}
}
//****************** You can add new functions below **********************//
function SearchCountRegisDocNoMainDept($xKey,$yKey,$zKey,$zKey2,$zKey3){
	//echo "1--select a.*,b.DrsID,b.DrsFromDrsID from Documents a inner join DocReceiveSend b on  a.DocGroup='$yKey' and a.RsID = '$zKey' and a.DtID = '$zKey2' and a.fDelete!='Y' and (a.DsID='1' or a.DsID='2') and  a.DsID = b.DsID and (a.DlcID= '$xKey' 
bool(false)