Viewing file: clsDocuments_new.php (87.18 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php //--Class base_Documents-------------------------- //--PK of base_Documents :: // 1. DocID include_once "../link/keyThai.php"; class Documents extends clsDB{
var $result;
var $DocID; var $DocPID; var $DlcID; var $PtID; var $DtID; var $DslID; var $DclID; var $DsID; var $RsID; var $DocDateCreate; var $DocUserCreate; var $DocTypeNo; var $DocDate; var $DocNo; var $DocSubject; var $DocFrom; var $DocTo; var $DocShortDesc; var $DocSpeedLevelDueDate; var $DocStart; var $DocFinish; var $DocGroup; var $DocRef; var $DocCircular; var $DocfCir; var $DocOther; var $CertificatePs; var $fDelete; var $endDoc; var $sendToPs; var $AnID; var $DocRefAns; var $DocRefAnsID; var $DocstartDatePost; var $DocendDatePost; var $DocMainPost; var $DocGetPost; var $DocShowInOut; var $DocDateGetPost; var $useMainDocNo; var $stdCode; var $DocforSign;
function Documents(&$c){ $this->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' || a.DlcID='$zKey3') and a.DocID=b.DocID and b.DrsflagRead!='N' order by a.DocDateCreate desc , a.DocID desc"; $this->SetQuery("select count(a.DocID) as num 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' || a.DlcID='$zKey3') and a.DocID=b.DocID and b.DrsflagRead!='N'"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchCountRegisDocNoMainDept2($yKey,$zKey,$zKey2){ //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' || a.DlcID='$zKey3') and a.DocID=b.DocID and b.DrsflagRead!='N' order by a.DocDateCreate desc , a.DocID desc"; $this->SetQuery("select count(a.DocID) as num 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.DocID=b.DocID and b.DrsflagRead!='N'"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchRegisDocNoMainDeptLimit($xKey,$yKey,$zKey,$zKey2,$zKey3,$start,$pageSize){ if ($this->SetQuery("select a.DsID,a.DlcID,a.DocID,a.DocTypeNo,a.DtID,a.DocNo,a.DocDate,a.endDoc,a.DocSubject,a.DocFrom,a.DocDateCreate,a.DslID,a.DclID, 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' || a.DlcID='$zKey3') and a.DocID=b.DocID and b.DrsflagRead!='N' order by a.DocDateCreate desc , a.DocID desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchRegisDocNoMainDeptLimit2($yKey,$zKey,$zKey2,$start,$pageSize){ if ($this->SetQuery("select a.DsID,a.DlcID,a.DocID,a.DocTypeNo,a.DtID,a.DocNo,a.DocDate,a.endDoc,a.DocSubject,a.DocFrom,a.DocDateCreate,a.DslID,a.DclID, 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.DocID=b.DocID and b.DrsflagRead!='N' order by a.DocDateCreate desc , a.DocID desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchCountRegisDocMainDept($yKey,$zKey,$zKey2){ //echo "2--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.DocID=b.DocID and b.DrsflagRead!='N' order by a.DocDateCreate desc , a.DocID desc"; $this->SetQuery("select count(a.DocID) as num 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.DocID=b.DocID and b.DrsflagRead!='N'"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchRegisDocMainDeptLimit($yKey,$zKey,$zKey2,$start,$pageSize){ if ($this->SetQuery("select a.DsID,a.DlcID,a.DocID,a.DocTypeNo,a.DtID,a.DocNo,a.DocDate,a.endDoc,a.DocSubject,a.DocFrom,a.DocDateCreate,a.DslID,a.DclID, 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.DocID=b.DocID and b.DrsflagRead!='N' order by a.DocDateCreate desc , a.DocID desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchByDlcIDDocGroupPSDlcID2DsID3DrsSendDateDrsSEnd($xKey,$yKey,$zKey4,$dlcid){ //if ($this->SetQuery("select * from Documents where (DlcID= '$xKey' || DlcID= '$zKey4') and DocGroup='$yKey' and fDelete!='Y' and DsID='3' order by DocDateCreate desc , DocID desc")){ if ($this->SetQuery("select a.*,b.* from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and b.DLCID='$dlcid' and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend='Y' order by a.DocDateCreate desc , a.DocID desc")){ return 1; }else { return 0; } } function SearchCountSendDocDrsSEnd($xKey,$yKey,$zKey4,$dlcid){ //if ($this->SetQuery("select * from Documents where (DlcID= '$xKey' || DlcID= '$zKey4') and DocGroup='$yKey' and fDelete!='Y' and DsID='3' order by DocDateCreate desc , DocID desc")){ $this->SetQuery("select count(a.DocID) as num from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and b.DLCID='$dlcid' and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend='Y' and ((a.DtID='15' && a.DocPID='0') || (a.DtID!='15'))"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchSendDocDrsSEndlimit($xKey,$yKey,$zKey4,$dlcid,$start,$pageSize){ //if ($this->SetQuery("select * from Documents where (DlcID= '$xKey' || DlcID= '$zKey4') and DocGroup='$yKey' and fDelete!='Y' and DsID='3' order by DocDateCreate desc , DocID desc")){ if ($this->SetQuery("select a.DocTypeNo, a.DtID, a.DocNo, a.DocFrom, a.DocPID, a.DlcID, a.RsID, a.DocID, a.DocSubject, a.DslID, a.DclID ,b.DrsID from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and b.DLCID='$dlcid' and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend='Y' and ((a.DtID='15' && a.DocPID='0') || (a.DtID!='15')) order by a.DocDateCreate desc , a.DocID desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchDocforSignMainPs($xKey,$yKey,$zKey4,$dlcid){ //if ($this->SetQuery("select * from Documents where (DlcID= '$xKey' || DlcID= '$zKey4') and DocGroup='$yKey' and fDelete!='Y' and DsID='3' order by DocDateCreate desc , DocID desc")){ if ($this->SetQuery("select a.*,b.* from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and b.DLCID='$dlcid' and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend='Y' and a.DtID='15' and a.DocPID!='0' order by a.DocDateCreate desc , a.DocID desc")){ return 1; }else { return 0; } } function SearchByDlcIDDocGroupPSDlcID2DsID3DrsSendDateDrsSEndnotY($xKey,$yKey,$zKey4){ //echo "select a.*,b.* from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend!='Y' order by a.DocDateCreate desc , a.DocID desc"; if ($this->SetQuery("select a.*,b.* from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend!='Y' order by a.DocDateCreate desc , a.DocID desc")){ return 1; }else { return 0; } } function SearchByDlcIDDocGroupPSDlcID2DsID3DrsSendDateDrsSEndnotY2($xKey,$yKey,$zKey4,$dlcid){ //echo "select a.*,b.* from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and b.DLCID='$dlcid' and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend!='Y' order by a.DocDateCreate desc , a.DocID desc"; if ($this->SetQuery("select a.*,b.* from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and b.DLCID='$dlcid' and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend!='Y' order by a.DocDateCreate desc , a.DocID desc")){ return 1; }else { return 0; } } function SearchCountSendDocDrsSEndnotY2($xKey,$yKey,$zKey4,$dlcid){ //echo "select a.*,b.* from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and b.DLCID='$dlcid' and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend!='Y' order by a.DocDateCreate desc , a.DocID desc"; $this->SetQuery("select count(a.DocID) as num from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and b.DLCID='$dlcid' and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend!='Y' and ((a.DtID='15' && a.DocPID='0') || (a.DtID!='15'))"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchSendDocDrsSEndnotY2limit($xKey,$yKey,$zKey4,$dlcid,$start,$pageSize){ //echo "select a.*,b.* from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and b.DLCID='$dlcid' and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend!='Y' order by a.DocDateCreate desc , a.DocID desc"; if ($this->SetQuery("select a.DocTypeNo, a.DtID, a.DocNo, a.DocFrom, a.DocPID, a.DlcID, a.RsID, a.DocID, a.DocSubject, a.DslID, a.DclID ,b.DrsID from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and b.DLCID='$dlcid' and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend!='Y' and ((a.DtID='15' && a.DocPID='0') || (a.DtID!='15')) order by a.DocDateCreate desc , a.DocID desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchDocforSign($xKey,$yKey,$zKey4,$dlcid){ //echo "select a.*,b.* from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and b.DLCID='$dlcid' and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend!='Y' order by a.DocDateCreate desc , a.DocID desc"; if ($this->SetQuery("select a.*,b.* from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and b.DLCID='$dlcid' and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend!='Y' and a.DtID='15' and a.DocPID!='0' order by a.DocDateCreate desc , a.DocID desc")){ return 1; }else { return 0; } } function SearchByDlcIDDocGroupPSDlcID2DsID0($xKey,$yKey,$zKey4){ //echo "select * from Documents where (DlcID= '$xKey' || DlcID= '$zKey4') and DocGroup='$yKey' and fDelete!='Y' and DsID='0' order by DocDateCreate desc , DocID desc"; if ($this->SetQuery("select * from Documents where (DlcID= '$xKey' || DlcID= '$zKey4') and DocGroup='$yKey' and fDelete!='Y' and DsID='0' order by DocDateCreate desc , DocID desc")){ return 1; }else { return 0; } } function SearchByDlcIDDocGroupPSDlcID2DsID0DrsSendDate($xKey,$yKey,$zKey4){ //echo "select a.*,b.DrsID,b.DrsFromDrsID,b.DrsReceiveDate from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='0' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' order by a.DocDateCreate desc , a.DocID desc"; if ($this->SetQuery("select a.*,b.DrsID,b.DrsFromDrsID,b.DrsReceiveDate from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='0' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' order by a.DocDateCreate desc , a.DocID desc")){ return 1; }else { return 0; } } function SearchByDlcIDDocGroupPSDlcID2DsID0DrsSendDatelimit($xKey,$yKey,$zKey4,$start,$pageSize,$searchnamePre,$searchNoPre){ if($searchnamePre!=""){ $aa="and a.DocSubject like '%$searchnamePre%'"; } if($searchNoPre!=""){ $cc="and a.DocNo like '%$searchNoPre%'"; } if ($this->SetQuery("select a.DtID,a.DocNo,a.DocFrom,a.DocPID,a.DlcID,a.RsID,a.DocID,a.CertificatePs,a.DocSubject,a.DslID,a.DclID,a.DtID, b.DrsID,b.DrsReceiveDate from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='0' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' $aa $cc order by a.DocDateCreate desc , a.DocID desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchCountDocReceive2($xKey,$yKey,$zKey4,$searchnamePre,$searchNoPre){ if($searchnamePre!=""){ $aa="and a.DocSubject like '%$searchnamePre%'"; } if($searchNoPre!=""){ $cc="and a.DocNo like '%$searchNoPre%'"; } $this->SetQuery("select count(a.DocID) as num from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='0' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' $aa $cc"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchReceiveDoc($xKey,$yKey,$zKey4){ if ($this->SetQuery("select a.DocNo,a.DtID,a.DocFrom,a.DocPID, a.DlcID,a.RsID,a.DocID,a.CertificatePs, a.DocSubject,a.DslID,a.DclID,b.DrsID, b.DrsFromDrsID,b.DrsReceiveDate from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='0' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' order by a.DocDateCreate desc , a.DocID desc")){ return 1; }else { return 0; } } function SearchByDlcIDDocGroupPSDlcID2DsID0DrsSendDateNoAcceptandAcceptnoRsID4searchNo($xKey,$yKey,$zKey4,$monthe,$searchYear,$s,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; } if($s==6){ $bb="and b.DrsSendDate='0000-00-00 00:00:00' and (a.DsID=b.DsID and a.DsID='$s')"; }else{ $bb="and b.DsID='$s'"; } if($searchNo!=""){ $cc="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } //echo "select count(a.DocID) as num from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DocID=b.DocID $aa $bb $cc $ee and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='3'<br>"; $this->SetQuery("select count(a.DocID) as num from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DocID=b.DocID $aa $bb $cc $ee and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='3'"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchCountReceivedDocNoDeptCenter($xKey,$yKey,$zKey4,$monthe,$searchYear,$s,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; } if($s==6){ $bb="and b.DrsSendDate='0000-00-00 00:00:00' and (a.DsID=b.DsID and a.DsID='$s')"; }else{ $bb="and b.DsID='$s'"; } if($searchNo!=""){ $cc="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } //echo "select count(a.DocID) as num from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DocID=b.DocID $aa $bb $cc $ee and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='3'"; $this->SetQuery("select count(a.DocID) as num from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DocID=b.DocID $aa $bb $cc $ee and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='3'"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchByDlcIDDocGroupPSDlcID2DsID0DrsSendDateNoAcceptandAcceptRsID1searchNo($xKey,$yKey,$zKey4,$monthe,$searchYear,$s,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; } if($searchNo!=""){ $bb="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } $cc="and b.DsID='1'";
//echo "-----select count(a.DocID) as num from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DocID=b.DocID $aa $bb $cc $ee and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='1'<br>"; $this->SetQuery("select count(a.DocID) as num from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DocID=b.DocID $aa $bb $cc $ee and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='1'"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchCountReceivedDocDeptCenter($xKey,$yKey,$zKey4,$monthe,$searchYear,$s,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; } if($searchNo!=""){ $bb="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } $cc="and b.DsID='1'";
//echo "select count(a.DocID) as num from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DocID=b.DocID $aa $bb $cc $ee and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='1'"; $this->SetQuery("select count(a.DocID) as num from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DocID=b.DocID $aa $bb $cc $ee and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='1'"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchByDlcIDDocGroupPSDlcID2DsID0DrsSendDateNoAcceptandAcceptLimitDrsReceiveDatenoRsID4searchNo($xKey,$yKey,$zKey4,$start,$pageSize,$monthe,$searchYear,$s,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; } if($s==6){ $bb="and b.DrsSendDate='0000-00-00 00:00:00' and (a.DsID=b.DsID and a.DsID='$s')"; }else{ $bb="and b.DsID='$s'"; } if($searchNo!=""){ $cc="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } if ($this->SetQuery("select a.DocTypeNo,a.DtID,a.DocNo,a.DocFrom,a.DocPID,a.DlcID,a.RsID,a.DocID,a.CertificatePs,a.DocSubject,a.DocDate,a.DocDateCreate, b.DrsID,b.DrsFromDrsID,b.DrsReceiveDate from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DocID=b.DocID $aa $bb $cc $ee and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='3' order by a.DocDateCreate desc , a.DocID desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchReceivedDocNoDeptCenter($xKey,$yKey,$zKey4,$start,$pageSize,$monthe,$searchYear,$s,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; } if($s==6){ $bb="and b.DrsSendDate='0000-00-00 00:00:00' and (a.DsID=b.DsID and a.DsID='$s')"; }else{ $bb="and b.DsID='$s'"; } if($searchNo!=""){ $cc="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } //echo "select a.*,b.DrsID,b.DrsFromDrsID,b.DrsReceiveDate from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DocID=b.DocID $aa $bb $cc $ee and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='3' order by a.DocDateCreate desc , a.DocID desc limit $start, $pageSize"; if ($this->SetQuery("select a.DocTypeNo,a.DocNo,a.DtID,a.DocFrom, a.DocPID,a.DlcID,a.DocPID,a.RsID,a.DocID, a.CertificatePs,a.DocSubject,a.DocDate,a.DocDateCreate, b.DrsID,b.DrsFromDrsID,b.DrsReceiveDate from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DocID=b.DocID $aa $bb $cc $ee and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='3' order by a.DocDateCreate desc , a.DocID desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchByDlcIDDocGroupPSDlcID2DsID0DrsSendDateNoAcceptandAcceptLimitDrsReceiveDateRsID1searchNo($xKey,$yKey,$zKey4,$start,$pageSize,$monthe,$searchYear,$s,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; } $bb="and b.DsID='1'";
if($searchNo!=""){ $cc="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } if ($this->SetQuery("select a.DocTypeNo,a.DtID,a.DocNo,a.DocFrom,a.DocPID,a.DlcID,a.RsID,a.DocID,a.CertificatePs,a.DocSubject,a.DocDate,a.DocDateCreate, b.DrsID,b.DrsFromDrsID,b.DrsReceiveDate from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DocID=b.DocID $aa $bb $cc $ee and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='1' order by a.DocDateCreate desc , a.DocID desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchReceivedDocDeptCenter($xKey,$yKey,$zKey4,$start,$pageSize,$monthe,$searchYear,$s,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; } $bb="and b.DsID='1'";
if($searchNo!=""){ $cc="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } //echo "select a.*,b.DrsID,b.DrsFromDrsID,b.DrsReceiveDate from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DocID=b.DocID $aa $bb $cc $ee and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='1' order by a.DocDateCreate desc , a.DocID desc limit $start, $pageSize"; if ($this->SetQuery("select a.DocTypeNo,a.DocNo,a.DtID,a.DocFrom, a.DocPID,a.DlcID,a.DocPID,a.RsID,a.DocID, a.CertificatePs,a.DocSubject,a.DocDate,a.DocDateCreate, b.DrsID,b.DrsFromDrsID,b.DrsReceiveDate from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DocID=b.DocID $aa $bb $cc $ee and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='1' order by a.DocDateCreate desc , a.DocID desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchByDocGroupDsID2($xKey){ //echo "select * from Documents where DocGroup='$xKey' and DsID='2' order by DocDateCreate desc"; if ($this->SetQuery("select * from Documents where DocGroup='$xKey' and DsID='2' order by DocDateCreate desc")){ return 1; }else { return 0; } } function SearchByDocGroupDsID2DocIDDlcIDDrsReceiveDlcID2Status2($xKey,$yKey,$zKey){ //echo "select a.*,b.DrsID from Documents a inner join DocReceiveSend b on a.DocGroup='$xKey' and a.DsID='2' and a.DsID=b.DsID and a.DocID=b.DocID and (b.DlcID= '$yKey' || b.DlcID= '$zKey') order by a.DocDateCreate desc , b.DrsReceiveDate desc"; if ($this->SetQuery("select a.*,b.DrsID,b.DrsWSign from Documents a inner join DocReceiveSend b on a.DocGroup='$xKey' and a.DsID='2' and a.DsID=b.DsID and a.DocID=b.DocID and (b.DlcID= '$yKey' || b.DlcID= '$zKey') order by a.DocDateCreate desc , b.DrsReceiveDate desc")){ return 1; }else { return 0; } } function SearchCountSignDoc($xKey,$yKey,$zKey){ //echo "select a.*,b.DrsID from Documents a inner join DocReceiveSend b on a.DocGroup='$xKey' and a.DsID='2' and a.DsID=b.DsID and a.DocID=b.DocID and (b.DlcID= '$yKey' || b.DlcID= '$zKey') order by a.DocDateCreate desc , b.DrsReceiveDate desc"; $this->SetQuery("select count(a.DocID) as num from Documents a inner join DocReceiveSend b on a.DocGroup='$xKey' and a.DsID='2' and a.DsID=b.DsID and a.DocID=b.DocID and (b.DlcID= '$yKey' || b.DlcID= '$zKey')"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchSignDoclimit($xKey,$yKey,$zKey,$start,$pageSize){ //echo "select a.*,b.DrsID from Documents a inner join DocReceiveSend b on a.DocGroup='$xKey' and a.DsID='2' and a.DsID=b.DsID and a.DocID=b.DocID and (b.DlcID= '$yKey' || b.DlcID= '$zKey') order by a.DocDateCreate desc , b.DrsReceiveDate desc"; if ($this->SetQuery("select a.DtID, a.DocNo, a.DocFrom, a.DocPID, a.DlcID, a.DocID, a.DocSubject, a.DslID, a.DclID, b.DrsID, b.DrsWSign from Documents a inner join DocReceiveSend b on a.DocGroup='$xKey' and a.DsID='2' and a.DsID=b.DsID and a.DocID=b.DocID and (b.DlcID= '$yKey' || b.DlcID= '$zKey') order by a.DocDateCreate desc , b.DrsReceiveDate desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchByDocGroupDsID2DocIDDlcIDDrsReceiveDlcID2Status2forwsign($xKey,$yKey,$zKey){ //echo "select a.*,b.DrsID from Documents a inner join DocReceiveSend b on a.DocGroup='$xKey' and a.DsID='2' and a.DsID=b.DsID and a.DocID=b.DocID and (b.DlcID= '$yKey' || b.DlcID= '$zKey') order by a.DocDateCreate desc , b.DrsReceiveDate desc"; if ($this->SetQuery("select a.*,b.DrsID,b.DrsWSign from Documents a inner join DocReceiveSend b on a.DocGroup='$xKey' and a.DsID='2' and a.DsID=b.DsID and a.DocID=b.DocID and (b.DlcID= '$yKey' || b.DlcID= '$zKey') and b.DrsWSign!='Y' order by a.DocDateCreate desc , b.DrsReceiveDate desc")){ return 1; }else { return 0; } } function SearchCountSignDocR($xKey,$yKey,$zKey){ //echo "select a.*,b.DrsID from Documents a inner join DocReceiveSend b on a.DocGroup='$xKey' and a.DsID='2' and a.DsID=b.DsID and a.DocID=b.DocID and (b.DlcID= '$yKey' || b.DlcID= '$zKey') order by a.DocDateCreate desc , b.DrsReceiveDate desc"; $this->SetQuery("select count(a.DocID) as num from Documents a inner join DocReceiveSend b on a.DocGroup='$xKey' and a.DsID='2' and a.DsID=b.DsID and a.DocID=b.DocID and (b.DlcID= '$yKey' || b.DlcID= '$zKey') and b.DrsWSign!='Y'"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchSignDocRlimit($xKey,$yKey,$zKey,$start,$pageSize){ //echo "select a.*,b.DrsID from Documents a inner join DocReceiveSend b on a.DocGroup='$xKey' and a.DsID='2' and a.DsID=b.DsID and a.DocID=b.DocID and (b.DlcID= '$yKey' || b.DlcID= '$zKey') order by a.DocDateCreate desc , b.DrsReceiveDate desc"; if ($this->SetQuery("select a.DtID, a.DocNo, a.DocFrom, a.DocPID, a.DlcID, a.DocID, a.DocSubject, a.DslID, a.DclID, b.DrsID, b.DrsWSign from Documents a inner join DocReceiveSend b on a.DocGroup='$xKey' and a.DsID='2' and a.DsID=b.DsID and a.DocID=b.DocID and (b.DlcID= '$yKey' || b.DlcID= '$zKey') and b.DrsWSign!='Y' order by a.DocDateCreate desc , b.DrsReceiveDate desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchByRsIDDocNoDocPID0($yKey,$zKey){ //echo "select * from Documents where RsID='$yKey' and DocNo like '%$zKey%' and DocPID='0' order by DocDate desc, DocID desc<br>"; if ($this->SetQuery("select * from Documents where RsID='$yKey' and DocNo like '%$zKey%' and DocPID='0' order by DocDate desc, DocID desc")){ return 1; }else { return 0; } } function SearchDocRefTable($yKey,$zKey){ //echo "select * from Documents where RsID='$yKey' and DocNo like '%$zKey%' and DocPID='0' order by DocDate desc, DocID desc<br>"; if ($this->SetQuery("select DocDate, DocNo, DocSubject, DocDate from Documents where RsID='$yKey' and DocNo like '%$zKey%' and DocPID='0' order by DocDate desc, DocID desc")){ return 1; }else { return 0; } } function SearchByRsID3DocNoDocPID0($yKey,$DocNoSearch,$p,$q,$DocSubjectSearch){ if($DocNoSearch!=""){ $a="AND DocNo LIKE '%$DocNoSearch%'"; } if($DocSubjectSearch!=""){ $b="and DocSubject like '%$DocSubjectSearch%'"; } //echo "SELECT * FROM Documents WHERE RsID = '$yKey' $a $b and (DlcID= '$p' || DlcID= '$q') and (DsID!='0' && DsID!='6' && DsID!='7') ORDER BY DocDate DESC , DocID DESC<br>"; if ($this->SetQuery("SELECT * FROM Documents WHERE RsID = '$yKey' $a $b and (DlcID= '$p' || DlcID= '$q') and (DsID!='0' && DsID!='6' && DsID!='7') ORDER BY DocDate DESC , DocID DESC")){ return 1; }else { return 0; } } function SearchDocRefAnsTable($yKey,$DocNoSearch,$p,$q,$DocSubjectSearch){ if($DocNoSearch!=""){ $a="AND DocNo LIKE '%$DocNoSearch%'"; } if($DocSubjectSearch!=""){ $b="and DocSubject like '%$DocSubjectSearch%'"; } //echo "SELECT * FROM Documents WHERE RsID = '$yKey' $a $b and (DlcID= '$p' || DlcID= '$q') and (DsID!='0' && DsID!='6' && DsID!='7') ORDER BY DocDate DESC , DocID DESC<br>"; if ($this->SetQuery("SELECT DocDate, DocNo, DocSubject, DocDate, DocID, DocDateCreate FROM Documents WHERE RsID = '$yKey' $a $b and (DlcID= '$p' || DlcID= '$q') and (DsID!='0' && DsID!='6' && DsID!='7') ORDER BY DocDate DESC , DocID DESC")){ return 1; }else { return 0; } } /* function SearchRsIDDtIDfDeleteDocNoSubject($RsID,$DtID,$start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$MaxDocGroup,$printorder,$selectDocID){ if($printorder==1){ $porder=" DocTypeNo desc "; }else if($printorder==2){ $porder=" DocTypeNo asc "; } if($DocTypeNoStart!=""){ $a="and DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and DocDateCreate like '$start%'"; }else{ $c="and DocDateCreate between '$start 00:00:00' and '$end 23:59:59'"; } echo "select * from Documents where RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DocPID='0' $a $b $c and DsID!='0' and DsID!='6' and DsID!='7' and DocGroup='$MaxDocGroup' and DocDateCreate='$selectdate' order by $porder<br>"; //echo "select * from Documents where RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DocPID='0' $a $b $c and DsID!='0' and DsID!='6' and DocGroup='$MaxDocGroup' order by DocTypeNo desc,DocDate desc"; if ($this->SetQuery("select * from Documents where RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DocPID='0' $a $b $c and DsID!='0' and DsID!='6' and DsID!='7' and DocGroup='$MaxDocGroup' and DocID='$selectDocID' order by $porder")){ return 1; }else { return 0; } } */ function SearchRsIDDtIDfDeleteDocNoSubject_DocDateCreate($RsID,$DtID,$start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$MaxDocGroup){ if($DocTypeNoStart!=""){ $a="and DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and DocDateCreate like '$start%'"; }else{ $c="and DocDateCreate between '$start 00:00:00' and '$end 23:59:59'"; } echo "select DocDateCreate from Documents where RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DocPID='0' $a $b $c and DsID!='0' and DsID!='6' and DsID!='7' and DocGroup='$MaxDocGroup' group by FORMAT('2552-11','YYYY-MM') as DocDateCreate <br>"; if ($this->SetQuery("select DocDateCreate from Documents where RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DocPID='0' $a $b $c and DsID!='0' and DsID!='6' and DsID!='7' and DocGroup='$MaxDocGroup' order by by DocDateCreate desc group by FORMAT('2552-11','YYYY-MM') as DocDateCreate ")){ return 1; }else { return 0; } } function SearchByDocDateCreateOrderbyDocTypeNo2($xKey,$printorder){ if($printorder==1){ $porder=" DocTypeNo desc "; }else if($printorder==2){ $porder=" DocTypeNo asc "; } echo "select * from Documents where DocDateCreate like '$xKey%' order by $porder<br>"; if ($this->SetQuery("select * from Documents where DocDateCreate like '$xKey%' order by $porder")){ return 1; }else { return 0; } } function SearchByDocDateCreateOrderbyDocTypeNo($RsID,$DtID,$selectDate,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$MaxDocGroup,$printorder){ if($printorder==1){ $porder=" DocTypeNo desc "; }else if($printorder==2){ $porder=" DocTypeNo asc "; } if($DocTypeNoStart!=""){ $a="and DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and DocSubject like '%$DocSubject%'"; } $c="and DocDateCreate like '$selectDate%'";
echo "select * from Documents where RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DocPID='0' $a $b $c and DsID!='0' and DsID!='6' and DsID!='7' and DocGroup='$MaxDocGroup' order by $porder<br>"; //echo "select * from Documents where RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DocPID='0' $a $b $c and DsID!='0' and DsID!='6' and DocGroup='$MaxDocGroup' order by DocTypeNo desc,DocDate desc"; if ($this->SetQuery("select * from Documents where RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DocPID='0' $a $b $c and DsID!='0' and DsID!='6' and DsID!='7' and DocGroup='$MaxDocGroup' order by $porder")){ return 1; }else { return 0; } }
function SearchRsIDDtIDfDeleteDocNoSubjectreg($RsID,$DtID,$start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$MaxDocGroup,$printorder){ if($printorder==1){ $porder=" DocTypeNo desc "; }else if($printorder==2){ $porder=" DocTypeNo asc "; } if($DocTypeNoStart!=""){ $a="and DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and DocDateCreate like '$start%'"; }else{ $c="and DocDateCreate between '$start 00:00:00' and '$end 23:59:59'"; } //echo "select * from Documents where RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DocPID='0' $a $b $c and DsID!='0' and DsID!='6' and DocGroup='$MaxDocGroup' order by DocTypeNo desc,DocDate desc"; if ($this->SetQuery("select * from Documents where RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DocPID='0' $a $b $c and DsID!='0' and DsID!='6' and DsID!='7' and DocGroup='$MaxDocGroup' and stdCode!='' order by $porder,DocDate desc")){ return 1; }else { return 0; } } function SearchRsIDDtIDfDeleteDocNoSubject_deptId($RsID,$DtID,$start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$deptId,$MaxDocGroup,$printorder){ if($printorder==1){ $porder=" a.DocTypeNo desc "; }else if($printorder==2){ $porder=" a.DocTypeNo asc "; } if($DocTypeNoStart!=""){ $a="and a.DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and a.DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and a.DocDateCreate like '$start%'"; }else{ $c="and a.DocDateCreate between '$start 00:00:00' and '$end 23:59:59'"; } //echo "select b.DlcID as DlcIDs ,a.* from Documents a inner join DocLineConfig b on a.RsID='$RsID' and a.DtID='$DtID' and a.fDelete!='Y' and a.DocPID='0' $a $b $c and a.DsID!='0' and a.DsID!='6' and a.DocGroup='$MaxDocGroup' and b.deptId='$deptId' and a.DlcID=b.DlcID order by a.DocTypeNo desc,a.DocDate desc"; if ($this->SetQuery("select b.DlcID as DlcIDs ,a.* from Documents a inner join DocLineConfig b on a.RsID='$RsID' and a.DtID='$DtID' and a.fDelete!='Y' and a.DocPID='0' $a $b $c and a.DsID!='0' and a.DsID!='6' and a.DsID!='7' and a.DocGroup='$MaxDocGroup' and b.deptId='$deptId' and a.DlcID=b.DlcID order by $porder,a.DocDate desc")){ return 1; }else { return 0; } } function SearchRsIDDtIDfDeleteDocNoSubject_deptIdreg($RsID,$DtID,$start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$deptId,$MaxDocGroup,$printorder){ if($printorder==1){ $porder=" a.DocTypeNo desc "; }else if($printorder==2){ $porder=" a.DocTypeNo asc "; } if($DocTypeNoStart!=""){ $a="and a.DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and a.DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and a.DocDateCreate like '$start%'"; }else{ $c="and a.DocDateCreate between '$start 00:00:00' and '$end 23:59:59'"; } //echo "select b.DlcID as DlcIDs ,a.* from Documents a inner join DocLineConfig b on a.RsID='$RsID' and a.DtID='$DtID' and a.fDelete!='Y' and a.DocPID='0' $a $b $c and a.DsID!='0' and a.DsID!='6' and a.DocGroup='$MaxDocGroup' and b.deptId='$deptId' and a.DlcID=b.DlcID order by a.DocTypeNo desc,a.DocDate desc"; if ($this->SetQuery("select b.DlcID as DlcIDs ,a.* from Documents a inner join DocLineConfig b on a.RsID='$RsID' and a.DtID='$DtID' and a.fDelete!='Y' and a.DocPID='0' $a $b $c and a.DsID!='0' and a.DsID!='6' and a.DsID!='7' and a.DocGroup='$MaxDocGroup' and b.deptId='$deptId' and a.DlcID=b.DlcID and a.stdCode!='' order by $porder,a.DocDate desc")){ return 1; }else { return 0; } } function SearchRsIDDtIDfDeleteDocNoSubjectDocGroup($RsID,$DtID,$start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$MaxDocGroup){ if($DocTypeNoStart!=""){ $a="and DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and DocDateCreate like '$start%'"; }else{ $c="and DocDateCreate between '$start 00:00:00' and '$end 23:59:59'"; } //echo "select * from Documents where RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DocPID='0' $a $b $c and DsID!='0' and DsID!='6' and DocGroup!='$MaxDocGroup' order by DocTypeNo desc,DocDate desc"; if ($this->SetQuery("select * from Documents where RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DocPID='0' $a $b $c and DsID!='0' and DsID!='6' and DsID!='7' and DocGroup!='$MaxDocGroup' order by DocTypeNo desc,DocDate desc")){ return 1; }else { return 0; } } function SearchRsIDDtIDfDeleteDocNoSubjectDocGroupreg($RsID,$DtID,$start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$MaxDocGroup){ if($DocTypeNoStart!=""){ $a="and DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and DocDateCreate like '$start%'"; }else{ $c="and DocDateCreate between '$start 00:00:00' and '$end 23:59:59'"; } //echo "select * from Documents where RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DocPID='0' $a $b $c and DsID!='0' and DsID!='6' and DocGroup!='$MaxDocGroup' order by DocTypeNo desc,DocDate desc"; if ($this->SetQuery("select * from Documents where RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DocPID='0' $a $b $c and DsID!='0' and DsID!='6' and DsID!='7' and DocGroup!='$MaxDocGroup' and stdCode!='' order by DocTypeNo desc,DocDate desc")){ return 1; }else { return 0; } } function SearchRsIDDtIDfDeleteDocNoSubjectDocGroupDocUserCreate($RsID,$DtID,$start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$DocGroup,$selectPositionDeptID,$printorder){ if($printorder==1){ $porder=" a.DocTypeNo desc "; }else if($printorder==2){ $porder=" a.DocTypeNo asc "; } if($DocTypeNoStart!=""){ $a="and a.DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and a.DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and a.DocDateCreate like '$start%'"; }else{ $c="and a.DocDateCreate between '$start 00:00:00' and '$end 23:59:59'"; } //echo "select b.DlcID as DlcIDs ,a.* from Documents a inner join Doclineconfig b on a.RsID='$RsID' and a.DtID='$DtID' and a.fDelete!='Y' and a.DocPID='0' $a $b $c and a.DsID!='0' and a.DsID!='6' and a.DocGroup='$DocGroup' and b.deptId='$selectPositionDeptID' and a.DlcID=b.DlcID order by a.DocTypeNo desc,a.DocDate desc"; if ($this->SetQuery("select b.DlcID as DlcIDs ,a.* from Documents a inner join DocLineConfig b on a.RsID='$RsID' and a.DtID='$DtID' and a.fDelete!='Y' and a.DocPID='0' $a $b $c and a.DsID!='0' and a.DsID!='6' and a.DsID!='7' and a.DocGroup='$DocGroup' and b.deptId='$selectPositionDeptID' and a.DlcID=b.DlcID order by $porder,a.DocDate desc")){ return 1; }else { return 0; } } function SearchRsIDDtIDfDeleteDocNoSubjectDocGroupDocUserCreatereg($RsID,$DtID,$start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$DocGroup,$selectPositionDeptID,$printorder){ if($printorder==1){ $porder=" a.DocTypeNo desc "; }else if($printorder==2){ $porder=" a.DocTypeNo asc "; } if($DocTypeNoStart!=""){ $a="and a.DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and a.DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and a.DocDateCreate like '$start%'"; }else{ $c="and a.DocDateCreate between '$start 00:00:00' and '$end 23:59:59'"; } //echo "select b.DlcID as DlcIDs ,a.* from Documents a inner join Doclineconfig b on a.RsID='$RsID' and a.DtID='$DtID' and a.fDelete!='Y' and a.DocPID='0' $a $b $c and a.DsID!='0' and a.DsID!='6' and a.DocGroup='$DocGroup' and b.deptId='$selectPositionDeptID' and a.DlcID=b.DlcID order by a.DocTypeNo desc,a.DocDate desc"; if ($this->SetQuery("select b.DlcID as DlcIDs ,a.* from Documents a inner join DocLineConfig b on a.RsID='$RsID' and a.DtID='$DtID' and a.fDelete!='Y' and a.DocPID='0' $a $b $c and a.DsID!='0' and a.DsID!='6' and a.DsID!='7' and a.DocGroup='$DocGroup' and b.deptId='$selectPositionDeptID' and a.DlcID=b.DlcID and stdCode!='' order by $porder,a.DocDate desc")){ return 1; }else { return 0; } } function SearchRsIDDtIDfDeleteDocNoSubject2($RsID,$DtID,$start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$deptId,$printorder){ if($printorder==1){ $porder=" a.DocTypeNo desc "; }else if($printorder==2){ $porder=" a.DocTypeNo asc "; } if($DocTypeNoStart!=""){ $a="and a.DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and a.DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and a.DocDateCreate like '$start%'"; }else{ $c="and a.DocDateCreate between '$start 00:00:00' and '$end 23:59:59'"; } //echo "select b.DlcID as DlcIDs ,a.* from Documents a inner join DocLineConfig b on a.RsID='$RsID' and a.DtID='$DtID' and a.fDelete!='Y' $a $b $c and a.DsID!='0' and a.DsID!='6' and a.DsID!='7' and b.deptId='$deptId' and a.DlcID=b.DlcID order by $porder,a.DocDate desc "; if ($this->SetQuery("select b.DlcID as DlcIDs ,a.* from Documents a inner join DocLineConfig b on a.RsID='$RsID' and a.DtID='$DtID' and a.fDelete!='Y' $a $b $c and a.DsID!='0' and a.DsID!='6' and a.DsID!='7' and b.deptId='$deptId' and a.DlcID=b.DlcID order by $porder,a.DocDate desc ")){ return 1; }else { return 0; } } function SearchRsIDDtIDfDeleteDocNoSubject2DocGroup($RsID,$DtID,$start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$DocGroup,$selectPositionDeptID,$printorder){ if($printorder==1){ $porder=" a.DocTypeNo desc "; }else if($printorder==2){ $porder=" a.DocTypeNo asc "; } if($DocTypeNoStart!=""){ $a="and a.DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and a.DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and a.DocDateCreate like '$start%'"; }else{ $c="and a.DocDateCreate between '$start 00:00:00' and '$end 23:59:59'"; } //echo "select b.DlcID as DlcIDs ,a.* from Documents a inner join Doclineconfig b on a.RsID='$RsID' and a.DtID='$DtID' and a.fDelete!='Y' $a $b $c and a.DsID!='0' and a.DsID!='6' and a.DocGroup='$DocGroup' and b.deptId='$selectPositionDeptID' and a.DlcID=b.DlcID order by a.DocTypeNo desc,a.DocDate desc "; if ($this->SetQuery("select b.DlcID as DlcIDs ,a.* from Documents a inner join DocLineConfig b on a.RsID='$RsID' and a.DtID='$DtID' and a.fDelete!='Y' $a $b $c and a.DsID!='0' and a.DsID!='6' and a.DsID!='7' and a.DocGroup='$DocGroup' and b.deptId='$selectPositionDeptID' and a.DlcID=b.DlcID order by $porder,a.DocDate desc ")){ return 1; }else { return 0; } } function askuser($xKey,$zKey,$s){ //if ($this->SetQuery("select * from Documents where DlcID= '$xKey' and DtID='$zKey' and RsID='$s'")){ if ($this->SetQuery("select * from Documents where DocID= '95'")){ return 1; }else { return 0; } } function SearchByDocGroupDsID1Limit($xKey,$start,$pageSize,$RsID,$DtID){ if ($this->SetQuery("select DocID from Documents where DtID='$DtID' and RsID='$RsID' and fDelete!='Y' and DocID in(select DocID from DocReceiveSend where DocGroup='$xKey' and DsID='1' order by DrsReceiveDate desc) order by DocDateCreate desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchViewRegisDocMainDeptLimit($xKey,$start,$pageSize,$RsID,$DtID,$monthe,$searchYear,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; } if($searchNo!=""){ $bb="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } if ($this->SetQuery("select a.DocID,a.DocTypeNo,a.DtID,a.DocNo,a.DocDate,a.DocSubject,a.DocFrom,a.DlcID,a.endDoc,a.DocDateCreate from Documents a inner join DocReceiveSend b on a.DtID='$DtID' and a.RsID='$RsID' and a.fDelete!='Y' and a.DocID=b.DocID and b.DocGroup='$xKey' and b.DsID='1'and b.DrsReceiveDate like '$searchYear-$monthe-%' $aa $bb $ee order by b.DrsReceiveDate desc ,a.DocDateCreate desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchViewRegisDocMainDeptLimit13($xKey,$start,$pageSize,$RsID,$DtID,$monthe,$searchYear,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; } if($searchNo!=""){ $bb="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } if ($this->SetQuery("select a.DocID,a.DocTypeNo,a.DtID,a.DocNo,a.DocDate,a.DocSubject,a.DocFrom,a.DlcID,a.endDoc,a.DocDateCreate from Documents a inner join DocReceiveSend b on a.DtID='$DtID' and a.RsID='$RsID' and a.fDelete!='Y' and a.DocID=b.DocID and b.DocGroup='$xKey' and b.DsID='1'and b.DrsReceiveDate like '$searchYear-$monthe-%' $aa $bb $ee order by b.DrsReceiveDate desc ,a.DocDateCreate desc,a.DocTypeNo desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchByDocGroupDsID1($xKey,$RsID,$DtID){ if ($this->SetQuery("select DocID from Documents where DtID='$DtID' and RsID='$RsID' and fDelete!='Y' and DocID in(select DocID from DocReceiveSend where DocGroup='$xKey' and DsID='1' order by DrsReceiveDate desc)")){ return 1; }else { return 0; } } function SearchByDlcIDDocGroupDsID1DlcPS2Limit($xKey,$yKey,$zKey,$start,$pageSize,$RsID,$DtID){ //echo "select DocID from Documents where DtID='$DtID' and RsID='$RsID' and fDelete!='Y' and DocID in (select DocID from DocReceiveSend where DocGroup='$yKey' and DsID='1' and (DlcID= '$xKey' || DlcID='$zKey') order by DrsReceiveDate desc) order by DocDateCreate desc limit $start, $pageSize"; if ($this->SetQuery("select DocID from Documents where DtID='$DtID' and RsID='$RsID' and fDelete!='Y' and DocID in (select DocID from DocReceiveSend where DocGroup='$yKey' and DsID='1' and (DlcID= '$xKey' || DlcID='$zKey') order by DrsReceiveDate desc) order by DocDateCreate desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchViewRegisDocNoMainDeptLimit($xKey,$yKey,$zKey,$start,$pageSize,$RsID,$DtID,$monthe,$searchYear,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ //and (b.DlcID= '$xKey' || b.DlcID='$zKey') and b.DrsReceiveDate like '$searchYear-$monthe-%' order by b.DrsReceiveDate desc , a.DocDateCreate desc limit '$start', '$pageSize' if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; }
if($searchNo!=""){ $bb="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } if ($this->SetQuery("select a.DocID,a.DocTypeNo,a.DtID,a.DocNo,a.DocDate,a.DocSubject,a.DocFrom,a.DlcID,a.endDoc,a.DocDateCreate from Documents a inner join DocReceiveSend b on a.DtID='$DtID' and a.RsID='$RsID' and a.fDelete!='Y' and a.DocID=b.DocID and b.DocGroup='$yKey' and b.DsID='1' and (b.DlcID= '$xKey' || b.DlcID='$zKey') and b.DrsReceiveDate like '$searchYear-$monthe-%' $aa $bb $ee order by b.DrsReceiveDate desc , a.DocDateCreate desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchViewRegisDocNoMainDeptLimit2($yKey,$start,$pageSize,$RsID,$DtID,$monthe,$searchYear,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ //and (b.DlcID= '$xKey' || b.DlcID='$zKey') and b.DrsReceiveDate like '$searchYear-$monthe-%' order by b.DrsReceiveDate desc , a.DocDateCreate desc limit '$start', '$pageSize' if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; }
if($searchNo!=""){ $bb="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } if ($this->SetQuery("select a.DocID,a.DocTypeNo,a.DtID,a.DocNo,a.DocDate,a.DocSubject,a.DocFrom,a.DlcID,a.endDoc,a.DocDateCreate from Documents a inner join DocReceiveSend b on a.DtID='$DtID' and a.RsID='$RsID' and a.fDelete!='Y' and a.DocID=b.DocID and b.DocGroup='$yKey' and b.DsID='1' and b.DrsReceiveDate like '$searchYear-$monthe-%' $aa $bb $ee order by b.DrsReceiveDate desc , a.DocDateCreate desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchViewRegisDocNoMainDeptLimit13($xKey,$yKey,$zKey,$start,$pageSize,$RsID,$DtID,$monthe,$searchYear,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ //and (b.DlcID= '$xKey' || b.DlcID='$zKey') and b.DrsReceiveDate like '$searchYear-$monthe-%' order by b.DrsReceiveDate desc , a.DocDateCreate desc limit '$start', '$pageSize' if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; }
if($searchNo!=""){ $bb="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } if ($this->SetQuery("select a.DocID,a.DocTypeNo,a.DtID,a.DocNo,a.DocDate,a.DocSubject,a.DocFrom,a.DlcID,a.endDoc,a.DocDateCreate from Documents a inner join DocReceiveSend b on a.DtID='$DtID' and a.RsID='$RsID' and a.fDelete!='Y' and a.DocID=b.DocID and b.DocGroup='$yKey' and b.DsID='1' and (b.DlcID= '$xKey' || b.DlcID='$zKey') and b.DrsReceiveDate like '$searchYear-$monthe-%' $aa $bb $ee order by b.DrsReceiveDate desc , a.DocDateCreate desc,a.DocTypeNo desc limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchByDlcIDDocGroupDsID1DlcPS2($xKey,$yKey,$zKey,$RsID,$DtID){ //echo "select * from DocReceiveSend where DocGroup='$yKey' and DsID='1' and (DlcID= '$xKey' || DlcID='$zKey') order by DrsReceiveDate desc<br>"; if ($this->SetQuery("select DocID from Documents where DtID='$DtID' and RsID='$RsID' and fDelete!='Y' and DocID in (select DocID from DocReceiveSend where DocGroup='$yKey' and DsID='1' and (DlcID= '$xKey' || DlcID='$zKey') order by DrsReceiveDate desc)")){ return 1; }else { return 0; } } function SearchByDlcIDDocGroupDsID1DlcPS2DrsReceiveDate($xKey,$yKey,$zKey,$RsID,$DtID,$monthe,$searchYear,$searchname){ if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; } //echo "select a.*,b.* from Documents a inner join DocReceiveSend b on a.DtID='$DtID' and a.RsID='$RsID' and a.fDelete!='Y' and a.DocID=b.DocID and b.DocGroup='$yKey' and b.DsID='1' and b.DrsReceiveDate like '$searchYear-$monthe-%' order by b.DrsReceiveDate desc"; if ($this->SetQuery("select a.DocID,b.DrsID from Documents a inner join DocReceiveSend b on a.DtID='$DtID' and a.RsID='$RsID' and a.fDelete!='Y' and a.DocID=b.DocID and b.DocGroup='$yKey' and b.DsID='1' and (b.DlcID= '$xKey' || b.DlcID='$zKey') and b.DrsReceiveDate like '$searchYear-$monthe-%' $aa order by b.DrsReceiveDate desc , a.DocDateCreate desc")){ return 1; }else { return 0; } } function SearchViewCountRegisDocNoMainDept($xKey,$yKey,$zKey,$RsID,$DtID,$monthe,$searchYear,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; } if($searchNo!=""){ $bb="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } $this->SetQuery("select count(a.DocID) as num from Documents a inner join DocReceiveSend b on a.DtID='$DtID' and a.RsID='$RsID' and a.fDelete!='Y' and a.DocID=b.DocID and b.DocGroup='$yKey' and b.DsID='1' and (b.DlcID= '$xKey' || b.DlcID='$zKey') and b.DrsReceiveDate like '$searchYear-$monthe-%' $aa $bb $ee"); if ($result=$this->GetResult()) { return $result['num']; } } function CountDocDocDateCreateDeptRsIDDtID($xKey,$yKey,$zKey,$RsID,$DtID){ //echo "select max(DocID) as num from Documents where (DocDateCreate between '$xKey' and '$yKey') and RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DlcID in (select DlcID from DocLineConfig where deptId='$zKey')<br>"; $this->SetQuery("select max(DocID) as num from Documents where (DocDateCreate between '$xKey' and '$yKey') and RsID='$RsID' and DtID='$DtID' and fDelete!='Y' and DlcID in (select DlcID from DocLineConfig where deptId='$zKey')"); if ($result=$this->GetResult()) { return $result['num']; } } function CountDocSumTrimesterDocDateCreateDeptIDTypeDoc($xKey,$yKey,$zKey,$DtID){ //echo "select max(DocID) as num from Documents where (DocDateCreate between '$xKey' and '$yKey') and DtID='$DtID' and fDelete!='Y' and DlcID in (select DlcID from DocLineConfig where deptId='$zKey')"; $this->SetQuery("select max(DocID) as num from Documents where (DocDateCreate between '$xKey' and '$yKey') and DtID='$DtID' and fDelete!='Y' and DlcID in (select DlcID from DocLineConfig where deptId='$zKey')"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchByDrsSendDateDocTypeNoDocSubjectDocNoDeptIdfDeleteDlcIDDlcID2DocGroupDsID3DrsSend2($start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$DocNo,$deptId,$DLCID,$MaxDocGroup,$DlcPS){ if($DocTypeNoStart!=""){ $a="and a.DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and a.DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and b.DrsSendDate like '$start%'"; }else{ $c="and b.DrsSendDate between '$start 00:00:00' and '$end 23:59:59'"; } if($DocNo!=""){ $e="and a.DocNo like '%$DocNo%'"; } //echo "select a.*,b.DrsSendDate,b.DrsDocDueDate,b.DrsID,b.DlcID as DlcIDRS from Documents a inner join DocReceiveSend b on a.fDelete!='Y' $a $b $c $e and b.DsID='3' and a.DocID=b.DocID and (b.DlcID='$DLCID' || b.DlcID='$DlcPS') and b.DocGroup='$MaxDocGroup' and b.DrsSend='Y' order by b.DrsSendDate desc"; if ($this->SetQuery("select a.*,b.DrsSendDate,b.DrsDocDueDate,b.DrsID,b.DlcID as DlcIDRS from Documents a inner join DocReceiveSend b on a.fDelete!='Y' $a $b $c $e and b.DsID='3' and a.DocID=b.DocID and (b.DlcID='$DLCID' || b.DlcID='$DlcPS') and b.DocGroup='$MaxDocGroup' and b.DrsSend='Y' order by b.DrsSendDate desc")){ return 1; }else { return 0; } } function SearchByDrsSendDateDocTypeNoDocSubjectDocNoDeptIdfDeleteDlcIDDlcID2DocGroupDsID3DrsSendSeeAll2($start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$DocNo,$deptId,$DLCID,$MaxDocGroup,$DlcPS){ if($DocTypeNoStart!=""){ $a="and a.DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and a.DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and b.DrsSendDate like '$start%'"; }else{ $c="and b.DrsSendDate between '$start 00:00:00' and '$end 23:59:59'"; } if($DocNo!=""){ $e="and a.DocNo like '%$DocNo%'"; } //echo "select a.*,b.DrsSendDate,b.DrsDocDueDate,b.DrsID,b.DlcID as DlcIDRS from Documents a inner join DocReceiveSend b on a.fDelete!='Y' $a $b $c $e and b.DsID='3' and a.DocID=b.DocID and b.DocGroup='$MaxDocGroup' order by b.DrsSendDate desc"; if ($this->SetQuery("select a.*,b.DrsSendDate,b.DrsDocDueDate,b.DrsID,b.DlcID as DlcIDRS from Documents a inner join DocReceiveSend b on a.fDelete!='Y' $a $b $c $e and b.DsID='3' and a.DocID=b.DocID and b.DocGroup='$MaxDocGroup' order by b.DrsSendDate desc")){ return 1; }else { return 0; } } function SearchByDrsSendDateDocTypeNoDocSubjectDocNoDeptIdfDeleteDocGroupDsID3($start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$DocNo,$deptId,$MaxDocGroup,$printorder){ if($printorder==1){ $porder=" a.DocTypeNo desc "; }else if($printorder==2){ $porder=" a.DocTypeNo asc "; } if($DocTypeNoStart!=""){ $a="and a.DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and a.DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and b.DrsSendDate like '$start%'"; }else{ $c="and b.DrsSendDate between '$start 00:00:00' and '$end 23:59:59'"; } if($DocNo!=""){ $e="and a.DocNo like '%$DocNo%'"; } //echo "select a.*,b.DrsSendDate,b.DrsDocDueDate,b.DrsID,b.DlcID as DlcIDRS from Documents a inner join DocReceiveSend b on a.fDelete!='Y' $a $b $c $e and b.DsID='3' and a.DocID=b.DocID and b.DocGroup='$MaxDocGroup' and b.PtID!='1' and b.DrsDocDueDate!='0000-00-00' order by b.DrsSendDate desc"; if ($this->SetQuery("select a.*,b.DrsSendDate,b.DrsDocDueDate,b.DrsID,b.DlcID as DlcIDRS from Documents a inner join DocReceiveSend b inner join DocLineConfig c on a.fDelete!='Y' $a $b $c $e and b.DsID='3' and a.DocID=b.DocID and b.DocGroup='$MaxDocGroup' and b.PtID!='1' and b.DrsDocDueDate!='0000-00-00' and b.DlcID = c.DlcID and c.deptId = '$deptId' order by $porder,b.DrsSendDate desc")){ return 1; }else { return 0; } } function SearchByDrsSendDateDocTypeNoDocSubjectDocNoDeptIdfDeleteDlcIDDlcID2DocGroupDsID32($start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$DocNo,$deptId,$DLCID,$MaxDocGroup,$DlcPS){ if($DocTypeNoStart!=""){ $a="and a.DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and a.DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and b.DrsSendDate like '$start%'"; }else{ $c="and b.DrsSendDate between '$start 00:00:00' and '$end 23:59:59'"; } if($DocNo!=""){ $e="and a.DocNo like '%$DocNo%'"; } //echo "select a.*,b.DrsSendDate,b.DrsDocDueDate,b.DrsID,b.DlcID as DlcIDRS from Documents a inner join DocReceiveSend b on a.fDelete!='Y' $a $b $c $e and b.DsID='3' and a.DocID=b.DocID and (b.DlcID='$DLCID' || b.DlcID='$DlcPS') and b.DocGroup='$MaxDocGroup' order by b.DrsSendDate desc"; if ($this->SetQuery("select a.*,b.DrsSendDate,b.DrsDocDueDate,b.DrsID,b.DlcID as DlcIDRS from Documents a inner join DocReceiveSend b on a.fDelete!='Y' $a $b $c $e and b.DsID='3' and a.DocID=b.DocID and (b.DlcID='$DLCID' || b.DlcID='$DlcPS') and b.DocGroup='$MaxDocGroup' order by b.DrsSendDate desc")){ return 1; }else { return 0; } } function SearchByDrsSendDateDocTypeNoDocSubjectDocNoDeptIdfDeleteDocGroupDsID322($start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$DocNo,$deptId,$MaxDocGroup,$PtID,$printorder){ if($printorder==1){ $porder=" a.DocTypeNo desc "; }else if($printorder==2){ $porder=" a.DocTypeNo asc "; } if($DocTypeNoStart!=""){ $a="and a.DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $b="and a.DocSubject like '%$DocSubject%'"; } if($start==$end){ $c="and b.DrsSendDate like '$start%'"; }else{ $c="and b.DrsSendDate between '$start 00:00:00' and '$end 23:59:59'"; } if($DocNo!=""){ $e="and a.DocNo like '%$DocNo%'"; } if($PtID=='all'){ $dd="order by a.PtID asc,$porder "; }else{ $dd="and a.PtID='$PtID' order by $porder, a.DocDateCreate desc"; } //echo "select a.*,b.DrsSendDate,b.DrsDocDueDate,b.DrsID,b.DlcID as DlcIDRS from Documents a inner join DocReceiveSend b inner join DocLineConfig c on a.fDelete!='Y' $a $b $c $e and b.DsID='3' and a.DocID=b.DocID and b.DocGroup='$MaxDocGroup' and b.DlcID = c.DlcID and c.deptId = '$deptId' $dd"; if ($this->SetQuery("select a.*,b.DrsSendDate,b.DrsDocDueDate,b.DrsID,b.DlcID as DlcIDRS from Documents a inner join DocReceiveSend b inner join DocLineConfig c on a.fDelete!='Y' $a $b $c $e and b.DsID='3' and a.DocID=b.DocID and b.DocGroup='$MaxDocGroup' and b.DlcID = c.DlcID and c.deptId = '$deptId' $dd")){ return 1; }else { return 0; } } function SearchByDrsSendDateDocTypeNoDocSubjectDocNoDeptIdfDeleteDlcIDDlcID2DocGroupDsID3PS($start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$DocNo,$deptId,$MaxDocGroup,$PS,$printorder){ if($printorder==1){ $porder=" a.DocTypeNo desc "; }else if($printorder==2){ $porder=" a.DocTypeNo asc "; } if($DocTypeNoStart!=""){ $aa="and a.DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $bb="and a.DocSubject like '%$DocSubject%'"; } if($start==$end){ $cc="and b.DrsReceiveDate like '$start%'"; }else{ $cc="and b.DrsReceiveDate between '$start 00:00:00' and '$end 23:59:59'"; } if($DocNo!=""){ $ee="and a.DocNo like '%$DocNo%'"; } //echo "select a.DocID,b.* from Documents a inner join DocReceiveSend b on b.personId='$PS' $aa $bb $cc $ee and b.PtID!='1' and a.DocID=b.DocID and b.DocGroup='$MaxDocGroup' and a.fDelete!='Y' and b.DrsDocDueDate!='0000-00-00' order by b.DrsReceiveDate desc"; //if ($this->SetQuery("select a.*,b.DrsSendDate,b.DrsDocDueDate,b.DrsID from Documents a inner join DocReceiveSend b on a.fDelete!='Y' $a $b $c $e and b.DsID='3' and a.DocID=b.DocID and b.DocGroup='$MaxDocGroup' and b.PtID!='1' and b.personId='$PS' order by b.DrsSendDate desc")){ if ($this->SetQuery("select a.DocID,a.DocDateCreate,b.* from Documents a inner join DocReceiveSend b on b.personId='$PS' $aa $bb $cc $ee and b.PtID!='1' and a.DocID=b.DocID and b.DocGroup='$MaxDocGroup' and a.fDelete!='Y' and b.DrsDocDueDate!='0000-00-00' order by $porder,b.DrsReceiveDate desc")){ return 1; }else { return 0; } } function SearchByDrsSendDateDocTypeNoDocSubjectDocNoDeptIdfDeleteDlcIDDlcID2DocGroupDsID3PS2($start,$end,$DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$DocNo,$deptId,$MaxDocGroup,$PS,$PtID,$printorder){ if($printorder==1){ $porder=" a.DocTypeNo desc "; }else if($printorder==2){ $porder=" a.DocTypeNo asc "; } if($DocTypeNoStart!=""){ $aa="and a.DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $bb="and a.DocSubject like '%$DocSubject%'"; } if($start==$end){ $cc="and b.DrsReceiveDate like '$start%'"; }else{ $cc="and b.DrsReceiveDate between '$start 00:00:00' and '$end 23:59:59'"; } if($DocNo!=""){ $ee="and a.DocNo like '%$DocNo%'"; } if($PtID=='all'){ $dd="order by $porder,a.PtID asc"; }else{ $dd="and a.PtID='$PtID' order by $porder,a.DocDateCreate desc"; }
//echo "select a.DocID,a.PtID,a.DocDateCreate,b.* from Documents a inner join DocReceiveSend b on b.personId='$PS' $aa $bb $cc $ee and a.DocID=b.DocID and b.DocGroup='$MaxDocGroup' and a.fDelete!='Y' $dd "; if ($this->SetQuery("select a.DocID,a.PtID,a.DocDateCreate,b.* from Documents a inner join DocReceiveSend b on b.personId='$PS' $aa $bb $cc $ee and a.DocID=b.DocID and b.DocGroup='$MaxDocGroup' and a.fDelete!='Y' $dd ")){ return 1; }else { return 0; } } function searchSelectPostDoc($xKey){ //echo "select * from Documents where AnID= '$xKey' and DocMainPost='Y' and DocGetPost='' and DocGroup='$yKey' and DocstartDatePost!='0000-00-00' and DocendDatePost!='0000-00-00' "; if ($this->SetQuery("select * from Documents where AnID= '$xKey' and DocMainPost='Y' and DocGetPost='' and DocstartDatePost!='0000-00-00' and DocendDatePost!='0000-00-00' ")){ return 1; }else { return 0; } } function searchSelectedPostDoc($xKey,$start,$end,$DocSubject,$DocNo){ if($start==$end){ $cc="and DocDateGetPost like '$start%'"; }else{ $cc="and DocDateGetPost between '$start 00:00:00' and '$end 23:59:59'"; } if($DocSubject!=""){ $bb="and DocSubject like '%$DocSubject%'"; } if($DocNo!=""){ $ee="and DocNo like '%$DocNo%'"; } //echo "select * from Documents where AnID= '$xKey' and DocMainPost='Y' and DocGetPost!='' and DocGetPost!='0' and DocGroup='$yKey' and DocstartDatePost!='0000-00-00' and DocendDatePost!='0000-00-00' $cc $bb $ee"; if ($this->SetQuery("select * from Documents where AnID= '$xKey' and DocMainPost='Y' and DocGetPost!='' and DocGetPost!='0' and DocGroup='$yKey' and DocstartDatePost!='0000-00-00' and DocendDatePost!='0000-00-00' $cc $bb $ee order by DocDateGetPost desc")){ return 1; }else { return 0; } } function SearchByDocPIDAnIDnot0($xKey){ if ($this->SetQuery("select * from Documents where DocPID= '$xKey' and AnID!=0")){ return 1; }else { return 0; } } function SearchByAnID($xKey){ if ($this->SetQuery("select * from Documents where AnID= '$xKey'")){ return 1; }else { return 0; } }
function SearchByDocTypeNoDocSubjectDocNoDeptIdfDeleteDocPID0($DocTypeNoStart,$DocTypeNoEnd,$DocSubject,$DocNo,$start,$end,$checkselectDate){ if($DocTypeNoStart!=""){ $aa="and DocTypeNo between '$DocTypeNoStart' and '$DocTypeNoEnd'"; } if($DocSubject!=""){ $bb="and DocSubject like '%$DocSubject%'"; } if($DocNo!=""){ $ee="and DocNo like '%$DocNo%'"; } if($checkselectDate=="Y"){ if($start==$end){ $cc="and DocDateCreate like '$start%'"; }else{ $cc="and DocDateCreate between '$start 00:00:00' and '$end 23:59:59'"; } } //echo "select * from Documents where DocPID='0' $aa $bb $ee $cc and fDelete !='Y' order by DocDateCreate desc"; if ($this->SetQuery("select * from Documents where DocPID='0' $aa $bb $ee $cc and fDelete !='Y' order by DocDateCreate desc")){ return 1; }else { return 0; } }
function CheckDocNo($xKey){
$this->SetQuery("select DocID as num from Documents where DtID=1 and RsID=1 and DocNo= '$xKey'"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchByDlcIDDocGroupDlcID2DsID0DrsSendDate($DlcID,$DlcID2,$maxgroup){ if ($this->SetQuery("select * from Documents where DocGroup='$maxgroup' and DsID=0 and (DlcID='$DlcID' or DlcID='$DlcID2') order by DocDateCreate desc , DocID desc")){ return 1; }else { return 0; } } function SearchCountDocReceive($DlcID,$DlcID2,$maxgroup){ $this->SetQuery("select count(DocID) as num from Documents where DocGroup='$maxgroup' and DsID=0 and (DlcID='$DlcID' or DlcID='$DlcID2')"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchDlcIDstatusNoGetJoin($xKey,$yKey){ //echo "select a.*,b.* from docforsign a inner join Documents b on a.DeptSign='$xKey' and a.statusGet='' and a.DocGroup ='$yKey' and a.DocID=b.DocID"; if ($this->SetQuery("select a.dfID,b.DtID,b.DocFrom,b.DocPID,b.DlcID,b.RsID,b.DocID,b.DocSubject,b.DslID,b.DclID from docforsign a inner join Documents b on a.DeptSign='$xKey' and a.statusGet='' and a.DocGroup ='$yKey' and a.DocID=b.DocID")){ return 1; }else { return 0; } } function SearchGetDocForSign($xKey,$yKey,$monthe,$searchYear,$searchName,$searchNo){ if($searchName!="" && $searchNo==""){ $q="select count(b.DocID) as num from docforsign a inner join Documents b on a.DeptSign='$xKey' and a.statusGet='Y' and a.DocGroup ='$yKey' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and b.DocSubject like '%$searchName%'"; }else if($searchName=="" && $searchNo!=""){ $q="select count(b.DocID) as num from docforsign a inner join Documents b on a.DeptSign='$xKey' and a.statusGet='Y' and a.DocGroup ='$yKey' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and b.DocNo like '%$searchNo%'"; }else if($searchName!="" && $searchNo!=""){ $q="select count(b.DocID) as num from docforsign a inner join Documents b on a.DeptSign='$xKey' and a.statusGet='Y' and a.DocGroup ='$yKey' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and b.DocNo like '%$searchNo%' and b.DocSubject like '%$searchName%'"; }else{ $q="select count(b.DocID) as num from docforsign a inner join Documents b on a.DeptSign='$xKey' and a.statusGet='Y' and a.DocGroup ='$yKey' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID"; }
$this->SetQuery($q); if ($result=$this->GetResult()) { return $result['num']; } } function SearchGetDocForSignLimit($xKey,$yKey,$start,$pageSize,$monthe,$searchYear,$searchName,$searchNo){ if($searchName!="" && $searchNo==""){ $q="select a.*,b.* from docforsign a inner join Documents b on a.DeptSign='$xKey' and a.statusGet='Y' and a.DocGroup ='$yKey' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and b.DocSubject like '%$searchName%' order by a.getDate desc limit $start, $pageSize"; }else if($searchName=="" && $searchNo!=""){ $q="select a.*,b.* from docforsign a inner join Documents b on a.DeptSign='$xKey' and a.statusGet='Y' and a.DocGroup ='$yKey' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and a.DocNo like '%$searchNo%' order by a.getDate desc limit $start, $pageSize"; }else if($searchName!="" && $searchNo!=""){ $q="select a.*,b.* from docforsign a inner join Documents b on a.DeptSign='$xKey' and a.statusGet='Y' and a.DocGroup ='$yKey' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and a.DocNo like '%$searchNo%' and b.DocSubject like '%$searchName%' order by a.getDate desc limit $start, $pageSize"; }else{ $q="select a.*,b.* from docforsign a inner join Documents b on a.DeptSign='$xKey' and a.statusGet='Y' and a.DocGroup ='$yKey' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID order by a.getDate desc limit $start, $pageSize"; }
if ($this->SetQuery($q)){ return 1; }else { return 0; } } function SearchGetDocForSignDlcIDLimit($yKey,$start,$pageSize,$monthe,$searchYear,$searchName,$searchNo,$DlcID,$DlcID2){ if($searchName!="" && $searchNo==""){ $q="select a.*,b.* from docforsign a inner join Documents b on a.DocGroup ='$yKey' and a.statusGet='Y' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and b.DocSubject like '%$searchName%' and (a.DlcID='$DlcID' || a.DlcID='$DlcID2') order by a.getDate desc limit $start, $pageSize"; }else if($searchName=="" && $searchNo!=""){ $q="select a.*,b.* from docforsign a inner join Documents b on a.DocGroup ='$yKey' and a.statusGet='Y' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and b.DocNo like '%$searchNo%' and (a.DlcID='$DlcID' || a.DlcID='$DlcID2') order by a.getDate desc limit $start, $pageSize"; }else if($searchName!="" && $searchNo!=""){ $q="select a.*,b.* from docforsign a inner join Documents b on a.DocGroup ='$yKey' and a.statusGet='Y' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and b.DocNo like '%$searchNo%' and b.DocSubject like '%$searchName%' and (a.DlcID='$DlcID' || a.DlcID='$DlcID2') order by a.getDate desc limit $start, $pageSize"; }else{ $q="select a.*,b.* from docforsign a inner join Documents b on a.DocGroup ='$yKey' and a.statusGet='Y' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and (a.DlcID='$DlcID' || a.DlcID='$DlcID2') order by a.getDate desc limit $start, $pageSize"; } if ($this->SetQuery($q)){ return 1; }else { return 0; } } function SearchGetDocForSignDlcID($yKey,$monthe,$searchYear,$searchName,$searchNo,$DlcID,$DlcID2){ if($searchName!="" && $searchNo==""){ $q="select count(b.DocID) as num from docforsign a inner join Documents b on a.DocGroup ='$yKey' and a.statusGet='Y' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and b.DocSubject like '%$searchName%' and (a.DlcID='$DlcID' || a.DlcID='$DlcID2')"; }else if($searchName=="" && $searchNo!=""){ $q="select count(b.DocID) as num from docforsign a inner join Documents b on a.DocGroup ='$yKey' and a.statusGet='Y' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and b.DocNo like '%$searchNo%' and (a.DlcID='$DlcID' || a.DlcID='$DlcID2')"; }else if($searchName!="" && $searchNo!=""){ $q="select count(b.DocID) as num from docforsign a inner join Documents b on a.DocGroup ='$yKey' and a.statusGet='Y' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and b.DocNo like '%$searchNo%' and b.DocSubject like '%$searchName%' and (a.DlcID='$DlcID' || a.DlcID='$DlcID2')"; }else{ $q="select count(b.DocID) as num from docforsign a inner join Documents b on a.DocGroup ='$yKey' and a.statusGet='Y' and b.DocGroup='$yKey' and a.getDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and (a.DlcID='$DlcID' || a.DlcID='$DlcID2')"; } //echo $q; $this->SetQuery($q); if ($result=$this->GetResult()) { return $result['num']; } }
function SearchGetDocForSignDlcID2($yKey,$DlcID,$DlcID2){ $q="select a.*,b.* from docforsign a inner join Documents b on a.DocGroup ='$yKey' and b.DocGroup='$yKey' and a.statusGet='' and a.DocID=b.DocID and (a.DlcID='$DlcID' || a.DlcID='$DlcID2')order by a.getDate desc"; if ($this->SetQuery($q)){ return 1; }else { return 0; } } function SearchCountDocIDByDlcIDDocGroupPSDlcID2DsID0DrsSendDate($xKey,$yKey,$zKey4){ //echo "select a.*,b.DrsID,b.DrsFromDrsID,b.DrsReceiveDate from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='0' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' order by a.DocDateCreate desc , a.DocID desc"; $this->SetQuery("select count(a.DocID) as num from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='0' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00'"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchCountDocIDByDlcIDDocGroupPSDlcID2DsID3DrsSendDateDrsSEndnotY2($xKey,$yKey,$zKey4,$dlcid){ //echo "select count(a.DocID) as num from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and b.DLCID='$dlcid' and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend!='Y' and ((a.DtID='15' && a.DocPID='0') || (a.DtID!='15'))<br>"; $this->SetQuery("select count(a.DocID) as num from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and b.DLCID='$dlcid' and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='3' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' and b.DrsSend!='Y' and ((a.DtID='15' && a.DocPID='0') || (a.DtID!='15'))"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchCountDocIDByDocGroupDsID2DocIDDlcIDDrsReceiveDlcID2Status2($xKey,$yKey,$zKey){ $this->SetQuery("select count(a.DocID) as num from Documents a inner join DocReceiveSend b on a.DocGroup='$xKey' and a.DsID='2' and a.DsID=b.DsID and a.DocID=b.DocID and (b.DlcID= '$yKey' || b.DlcID= '$zKey')"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchByViewRegisDoc($xKey){ if ($this->SetQuery("select DocID, DocTypeNo, DtID, DocNo, DocDate, DocSubject, DocFrom, DlcID, endDoc, DocDateCreate from Documents where DocID= '$xKey'")){ return 1; }else { return 0; } } function SearchByKeyName($xKey,$name){ if ($this->SetQuery("select $name from Documents where DocID= '$xKey'")){ return 1; }else { return 0; } } function SearchByDocSignpage($xKey){ if ($this->SetQuery("select DtID, DocNo, DocFrom, DocPID, DlcID, DocID, DocSubject from Documents where DocID= '$xKey'")){ return 1; }else { return 0; } } function SearchBySendDoc($xKey){ if ($this->SetQuery("select DocTypeNo, DtID, DocNo, DocFrom, DocPID, DlcID, RsID, DocID, DocSubject from Documents where DocID= '$xKey'")){ return 1; }else { return 0; } } function SearchRepSumRegisDoc($RsID,$DtID,$start,$end,$deptId){ if($start==$end){ $c="and a.DocDateCreate like '$start%'"; }else{ $c="and a.DocDateCreate between '$start 00:00:00' and '$end 23:59:59'"; } //echo "select count(a.DocID) as num from Documents a inner join DocLineConfig b on a.RsID='$RsID' and a.DtID='$DtID' and a.fDelete!='Y' $c and a.DsID!='0' and a.DsID!='6' and a.DsID!='7' and b.deptId='$deptId' and a.DlcID=b.DlcID"; $this->SetQuery("select count(a.DocID) as num from Documents a inner join DocLineConfig b on a.RsID='$RsID' and a.DtID='$DtID' and a.fDelete!='Y' $c and a.DsID!='0' and a.DsID!='6' and a.DsID!='7' and b.deptId='$deptId' and a.DlcID=b.DlcID"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchByDlcIDDocGroupDlcID2DsID0DrsSendDate_Update($DlcID,$DlcID2,$maxgroup){ //echo "update Documents set DlcID='$DlcID', DocUserCreate='$DlcID' where DocGroup='$maxgroup' and DsID=0 and (DlcID='$DlcID' or DlcID='$DlcID2')<br>"; if ($this->SetQuery("update Documents set DlcID='$DlcID', DocUserCreate='$DlcID' where DocGroup='$maxgroup' and DsID=0 and (DlcID='$DlcID' or DlcID='$DlcID2')")){ return 1; }else { return 0; } } function SearchByDlcIDDocGroupDlcID2DsID0DrsSendDateDocID($DlcID,$DlcID2,$maxgroup){ //echo "select DocID from Documents where DocGroup='$maxgroup' and DsID=0 and (DlcID='$DlcID' or DlcID='$DlcID2')<br>"; if($this->SetQuery("select DocID from Documents where DocGroup='$maxgroup' and DsID=0 and (DlcID='$DlcID' or DlcID='$DlcID2')")){ return 1; }else { return 0; } } function SearchViewRegisDocMainDept13($xKey,$RsID,$DtID,$monthe,$searchYear,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; } if($searchNo!=""){ $bb="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } $sql="select count(a.DocID) as num from Documents a inner join DocReceiveSend b on a.DtID='$DtID' and a.RsID='$RsID' and a.fDelete!='Y' and a.DocID=b.DocID and b.DocGroup='$xKey' and b.DsID='1'and b.DrsReceiveDate like '$searchYear-$monthe-%' $aa $bb $ee"; $this->SetQuery($sql); if ($result=$this->GetResult()) { return $result['num']; } }
function SearchViewRegisDocMainDept($xKey,$RsID,$DtID,$monthe,$searchYear,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; } if($searchNo!=""){ $bb="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } $sql="select count(a.DocID) as num from Documents a inner join DocReceiveSend b on a.DtID='$DtID' and a.RsID='$RsID' and a.fDelete!='Y' and a.DocID=b.DocID and b.DocGroup='$xKey' and b.DsID='1'and b.DrsReceiveDate like '$searchYear-$monthe-%' $aa $bb $ee"; $this->SetQuery($sql); if ($result=$this->GetResult()) { return $result['num']; } }
function SearchViewRegisDocNoMainDept13($xKey,$yKey,$zKey,$RsID,$DtID,$monthe,$searchYear,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ //and (b.DlcID= '$xKey' || b.DlcID='$zKey') and b.DrsReceiveDate like '$searchYear-$monthe-%' order by b.DrsReceiveDate desc , a.DocDateCreate desc limit '$start', '$pageSize' if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; }
if($searchNo!=""){ $bb="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } $sql="select count(a.DocID) as num from Documents a inner join DocReceiveSend b on a.DtID='$DtID' and a.RsID='$RsID' and a.fDelete!='Y' and a.DocID=b.DocID and b.DocGroup='$yKey' and b.DsID='1' and (b.DlcID= '$xKey' || b.DlcID='$zKey') and b.DrsReceiveDate like '$searchYear-$monthe-%' $aa $bb $ee"; $this->SetQuery($sql); if ($result=$this->GetResult()) { return $result['num']; } }
function SearchViewRegisDocNoMainDept($xKey,$yKey,$zKey,$RsID,$DtID,$monthe,$searchYear,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ //and (b.DlcID= '$xKey' || b.DlcID='$zKey') and b.DrsReceiveDate like '$searchYear-$monthe-%' order by b.DrsReceiveDate desc , a.DocDateCreate desc limit '$start', '$pageSize' if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; }
if($searchNo!=""){ $bb="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } $sql="select count(a.DocID) as num from Documents a inner join DocReceiveSend b on a.DtID='$DtID' and a.RsID='$RsID' and a.fDelete!='Y' and a.DocID=b.DocID and b.DocGroup='$yKey' and b.DsID='1' and (b.DlcID= '$xKey' || b.DlcID='$zKey') and b.DrsReceiveDate like '$searchYear-$monthe-%' $aa $bb $ee"; $this->SetQuery($sql); if ($result=$this->GetResult()) { return $result['num']; } } function SearchViewRegisDocNoMainDept2($yKey,$RsID,$DtID,$monthe,$searchYear,$searchname,$searchNo,$searchTypeNoF,$searchTypeNoT){ //and (b.DlcID= '$xKey' || b.DlcID='$zKey') and b.DrsReceiveDate like '$searchYear-$monthe-%' order by b.DrsReceiveDate desc , a.DocDateCreate desc limit '$start', '$pageSize' if($searchname!=""){ $aa="and a.DocSubject like '%$searchname%'"; }
if($searchNo!=""){ $bb="and a.DocNo like '%$searchNo%'"; } if($searchTypeNoF!="" || $searchTypeNoT!=""){ $ee="and a.DocTypeNo between '$searchTypeNoF' and '$searchTypeNoT'"; } $sql="select count(a.DocID) as num from Documents a inner join DocReceiveSend b on a.DtID='$DtID' and a.RsID='$RsID' and a.fDelete!='Y' and a.DocID=b.DocID and b.DocGroup='$yKey' and b.DsID='1' and b.DrsReceiveDate like '$searchYear-$monthe-%' $aa $bb $ee"; $this->SetQuery($sql); if ($result=$this->GetResult()) { return $result['num']; } } function SearchDlcID($xKey){ $this->SetQuery("select DlcID as num from Documents where DocID= '$xKey'"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchDocID($xKey){ if($this->SetQuery("select DocID,DocPID from Documents where DocID= '$xKey'")){ return 1; }else { return 0; } } function SearchDtID($xKey){ if($this->SetQuery("select DtID from Documents where DocID= '$xKey'")){ return 1; }else { return 0; } } } //--End class base_Documents--
?>
|