<?php
//--Class Person--------------------------
//--PK of Person ::
//	1. personId

class umfileupdate extends clsDB{

var $result;

var $fileId;
var $updateDate;
var $filename1;
var $filename2;
var $flagfile;
var $flagupdate;
var $path;
var $detail;
var $sysId;
var $updatetime;
var $flagselect;
var $flagrestore;
var $flaguse;

function umfileupdate(&$c){
	$this->c=$c->c;
	$this->DB=$c->db;
}

function AddNew(){
	$this->status = 1;
}

function Edit(){
	$this->status = 2;
}

function Save(){
	if ($this->status==1){
		$sql = "insert into umfileupdate values(
			'$this->fileId',
 			'$this->updateDate',
 			'$this->filename1',
 			'$this->filename2',
 			'$this->flagfile',
 			'$this->flagupdate',
 			'$this->path',
 			'$this->detail',
			'$this->sysId',
			'$this->updatetime',
			'$this->flagselect',
			'$this->flagrestore',
			'$this->flaguse'
			)";
	}else {
		$sql = "update umfileupdate set 
			updateDate='$this->updateDate', 
			filename1='$this->filename1', 
			filename2='$this->filename2', 
			flagfile='$this->flagfile', 
			flagupdate='$this->flagupdate', 
			path='$this->path', 
			detail='$this->detail',
			sysId='$this->sysId',
			updatetime='$this->updatetime',
			flagselect='$this->flagselect',
			flagrestore='$this->flagrestore',
			flaguse='$this->flaguse'
			where fileId='$this->fileId'";
	}
	$this->SetQuery($sql);
}

function Delete(){
	$this->SetQuery("delete from umfileupdate where fileId='$this->fileId'");
}

function GetNextCode(){
	$this->SetQuery("select max(fileId) as num from umfileupdate");
	if ($result=$this->GetResult()) {
		return $result['num']+1;
	}
}

function RSfileupdate(){
	$this->SetQuery("select * from umfileupdate order by fileId desc,updateDate desc,updatetime desc");
}
function RSfileupdatenotuse(){
	$this->SetQuery("select * from umfileupdate where flaguse='N' order by fileId desc,updateDate desc,updatetime desc");
}
function RSfileupdatenotuseordertext(){
	$this->SetQuery("select * from umfileupdate where flaguse='N' order by filename1");
}
function RSfileupdate2(){
	$this->SetQuery("select * from umfileupdate where (flaguse='Y' and (flagupdate='U' or flagupdate='D')) order by fileId desc,updateDate desc,updatetime desc");
}
function RSfileupdate2path($xKey){
	$this->SetQuery("select * from umfileupdate where (flaguse='Y' and (flagupdate='U' or flagupdate='D')) and path='$xKey'order by fileId desc,updateDate desc,updatetime desc");
}
function RSfileupdate2pathordertext($xKey){
	$this->SetQuery("select * from umfileupdate where (flaguse='Y' and (flagupdate='U' or flagupdate='D')) and path='$xKey'order by filename1");
}
function RSfileupdatepath(){
	$this->SetQuery("select * from umfileupdate where flaguse='Y' group by path");
}
function RSfileupdategroupname(){
	$this->SetQuery("SELECT * FROM `umfileupdate`   group by filename1,path order by updatetime desc,updateDate desc");
}
function RSfileupdategroupname2(){
	$this->SetQuery("SELECT * FROM `umfileupdate`   group by filename1,path order by fileId");
}
function RSfileupdategroupnameordertext(){
	$this->SetQuery("SELECT * FROM `umfileupdate`  group by filename1,path order by filename1");
}
function RSfileupdategroupnameordertext2(){
	$this->SetQuery("SELECT * FROM `umfileupdate`  group by filename1,path order by fileId");
}
function GetRecord(){
	if ($this->result = $this->GetResult()) {
		$this->fileId = $this->result['fileId'];
		$this->updateDate = $this->result['updateDate'];
		$this->filename1 = $this->result['filename1'];
		$this->filename2 = $this->result['filename2'];
		$this->flagfile = $this->result['flagfile'];
		$this->flagupdate = $this->result['flagupdate'];
		$this->path = $this->result['path'];
		$this->detail = $this->result['detail'];
		$this->sysId = $this->result['sysId'];
		$this->updatetime = $this->result['updatetime'];
		$this->flagselect = $this->result['flagselect'];
		$this->flagrestore = $this->result['flagrestore'];
		$this->flaguse = $this->result['flaguse'];
		return 1;
	}else {
		return 0;
	}
}

function SearchByKey($xKey){
	if ($this->SetQuery("select * from umfileupdate where fileId= '$xKey'")){ 
		return 1;
	}else {
		return 0;
	}
}

function SearchByfileId($xKey){
	if ($this->SetQuery("select * from umfileupdate where fileId= '$xKey'")){ 
		return 1;
	}else {
		return 0;
	}
}
function SearchBynotfileId($xKey,$yKey,$zKey){
	if ($this->SetQuery("select * from umfileupdate where fileId!= '$xKey' and path='$zKey' and filename1='$yKey' order by updatetime desc,updateDate desc")){ 
		return 1;
	}else {
		return 0;
	}
}
function SearchByfilename1anduse($xKey,$zKey){
	if ($this->SetQuery("select * from umfileupdate where filename1= '$xKey' and flaguse='Y' and path='$zKey'")){ 
		return 1;
	}else {
		return 0;
	}
}
function countnodir(){
	$this->SetQuery("select count(flagupdate) as num from umfileupdate where flagupdate ='D'");
	$result = $this->GetResult();
	return $result['num'];
}

function NumRow(){
	return $this->GetRowSelected();
}

function Destroy(){
	return $this->DestroyDb();
}
function SearchByflagupdateD(){
	if ($this->SetQuery("select * from umfileupdate where flagupdate ='D' order by updatetime desc,updateDate desc")){ 
		return 1;
	}else {
		return 0;
	}
}
function SearchByflagupdateD2(){
	if ($this->SetQuery("select * from umfileupdate where flagupdate ='D' order by fileId")){ 
		return 1;
	}else {
		return 0;
	}
}
//****************** You can add new functions below **********************//


} //--End class base_Room--

?>