Viewing file:  clsNoticeEditDoc.php (3.77 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class person--------------------------
//--PK of person ::
// 1. personId
include_once "../link/keyThai.php";
class NoticeEditDoc extends clsDB{
var $result;
var $neID;
var $DocID;
var $DrsID;
var $DlcIDCreate;
var $PsCreate;
var $DlcIDReceive;
var $PsReceive;
var $DocComment;
var $DocCommentDate;
var $statusDoc;
var $DocSendDate;
var $DlcIDSend;
var $PsSend;
function NoticeEditDoc(&$c){
$this->c=$c->c;
$this->DB=$c->db;
}
function Save(){
if($this->DocCommentDate==''){ $this->DocCommentDate='0000-00-00 00:00:00'; }
if($this->DocSendDate==''){ $this->DocSendDate='0000-00-00 00:00:00'; }
if ($this->status==1){
//uncomment a line below if your table use ID as running number
$this->DlpId=$this->GetNextCode();
$sql = "insert into noticeeditdoc values(
'".th2a($this->neID)."',
'".th2a($this->DocID)."',
'".th2a($this->DrsID)."',
'".th2a($this->DlcIDCreate)."',
'".th2a($this->PsCreate)."',
'".th2a($this->DlcIDReceive)."',
'".th2a($this->PsReceive)."',
'".th2a($this->DocComment)."',
'".th2a($this->DocCommentDate)."',
'".th2a($this->statusDoc)."',
'".th2a($this->DocSendDate)."',
'".th2a($this->DlcIDSend)."',
'".th2a($this->PsSend)."'
)";
}else {
$sql = "update noticeeditdoc set
DocID='".th2a($this->DocID)."',
DrsID='".th2a($this->DrsID)."',
DlcIDCreate='".th2a($this->DlcIDCreate)."',
PsCreate='".th2a($this->PsCreate)."',
DlcIDReceive='".th2a($this->DlcIDReceive)."',
PsReceive='".th2a($this->PsReceive)."',
DocComment='".th2a($this->DocComment)."',
DocCommentDate='".th2a($this->DocCommentDate)."',
statusDoc='".th2a($this->statusDoc)."',
DocSendDate='".th2a($this->DocSendDate)."',
DlcIDSend='".th2a($this->DlcIDSend)."',
PsSend='".th2a($this->PsSend)."'
where neID='".th2a($this->neID)."'";
}
return $this->Dml($sql);
}
function Delete(){
return $this->Dml("delete from noticeeditdoc where neID='$this->neID'");
}
function GetNextCode(){
$this->SetQuery("select max(neID) as num from noticeeditdoc");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
function RSnoticeeditdoc(){
$this->SetQuery("select * from noticeeditdoc order by neID");
}
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->DocComment=a2th($this->DocComment);
}
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 noticeeditdoc where neID= '$xKey'")){
return 1;
}else {
return 0;
}
}
function NumRow(){
return $this->GetRowSelected();
}
//****************** You can add new functions below **********************//
function SearchNumRowNoticeEditDoc($DocID,$DrsID){
if ($this->SetQuery("select * from noticeeditdoc where DocID= '$DocID' and DrsID='$DrsID' order by DocCommentDate asc")){
return 1;
}else {
return 0;
}
}
function NumRowNoticeEditDoc($DocID,$DrsID){
$this->SetQuery("select count(neID) as num from noticeeditdoc where DocID= '$DocID' and DrsID='$DrsID'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function SearchNoticeEditDocStatus($DocID,$DrsID,$ststusDoc){
if ($this->SetQuery("select * from noticeeditdoc where DocID= '$DocID' and DrsID='$DrsID' and statusDoc='$ststusDoc' order by DocCommentDate asc")){
return 1;
}else {
return 0;
}
}
function SearchNoticeEditDocStatusneID($DocID,$DrsID,$neID){
if ($this->SetQuery("select * from noticeeditdoc where DocID= '$DocID' and DrsID='$DrsID' and neID='$neID'")){
return 1;
}else {
return 0;
}
}
} //--End class person--
?>
|