Viewing file: clsRunningTypeDoc.php (3.98 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php //--Class runningrsdoc-------------------------- //--PK of runningrsdoc :: // 1. rRsID include_once "../link/keyThai.php"; class runningtypedoc extends clsDB{
var $result;
var $rTID; var $deptId; var $DtID; var $receiveNoStart; var $receiveNo; var $sendNoStart; var $sendNo; var $sendNoPrefix; var $sendNoSuffix; var $docGroup; var $confirm;
function runningtypedoc(&$c){ $this->c=$c->c; $this->DB=$c->db; } function Save(){ if ($this->status==1){ $sql = "insert into RunningTypeDoc values( '".th2a($this->rTID)."', '".th2a($this->deptId)."', '".th2a($this->DtID)."', '".th2a($this->receiveNoStart)."', '".th2a($this->receiveNo)."', '".th2a($this->sendNoStart)."', '".th2a($this->sendNo)."', '".th2a($this->sendNoPrefix)."', '".th2a($this->sendNoSuffix)."', '".th2a($this->docGroup)."', '".th2a($this->confirm)."' )"; }else { $sql = "update RunningTypeDoc set deptId='".th2a($this->deptId)."', DtID='".th2a($this->DtID)."', receiveNoStart='".th2a($this->receiveNoStart)."', receiveNo='".th2a($this->receiveNo)."', sendNoStart='".th2a($this->sendNoStart)."', sendNo='".th2a($this->sendNo)."', sendNoPrefix='".th2a($this->sendNoPrefix)."', sendNoSuffix='".th2a($this->sendNoSuffix)."', docGroup='".th2a($this->docGroup)."', confirm='".th2a($this->confirm)."' where rTID='".th2a($this->rTID)."'"; } return $this->Dml($sql); }
function Delete(){ return $this->Dml("delete from RunningTypeDoc where rTID='$this->rTID'"); }
function GetNextCode(){ $this->SetQuery("select max(rTID) as num from RunningTypeDoc"); if ($result=$this->GetResult()) { return $result['num']+1; } }
function RSrunningtypedoc(){ $this->SetQuery("select * from RunningTypeDoc order by rTID"); }
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 RunningTypeDoc where rTID= '$xKey'")){ return 1; }else { return 0; } }
//****************** You can add new functions below **********************// function SearchBydeptIddocGroupDtID($xKey,$yKey,$zKey){ if ($this->SetQuery("select * from RunningTypeDoc where deptId= '$xKey' and docGroup = '$yKey' and DtID='$zKey' order by deptId asc")){ return 1; }else { return 0; } } function SearchBydeptIddocGroup($xKey,$yKey){ if ($this->SetQuery("select * from RunningTypeDoc where deptId= '$xKey' and docGroup = '$yKey'")){ return 1; }else { return 0; } } function SearchByconfirm($xKey,$yKey){ if ($this->SetQuery("select * from RunningTypeDoc where docGroup= '$xKey' and deptId= '$yKey' group by docGroup")){ return 1; }else { return 0; } } function CountreceiveNoStart1($xKey){ $this->SetQuery("select count(receiveNoStart) as num from RunningTypeDoc where docGroup='$xKey' and receiveNoStart='1' "); if ($result=$this->GetResult()) { return $result['num']; } } function CountsendNoStart1($xKey){ $this->SetQuery("select count(sendNoStart) as num from RunningTypeDoc where docGroup='$xKey' and sendNoStart='1' "); if ($result=$this->GetResult()) { return $result['num']; } } function CountdocGroup1($xKey){ $this->SetQuery("select count(docGroup) as num from RunningTypeDoc where docGroup='$xKey'"); if ($result=$this->GetResult()) { return $result['num']; } } function CountdocGroupdept($xKey,$yKey){ $this->SetQuery("select count(docGroup) as num from RunningTypeDoc where docGroup='$xKey' and deptId = '$yKey'"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchBydocGroup($xKey){ if ($this->SetQuery("select * from RunningTypeDoc where docGroup= '$xKey'")){ return 1; }else { return 0; } }
} //--End class runningtypedoc--
?>
|