Software: Apache/2.2.3 (CentOS). PHP/5.1.6 uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44 uid=48(apache) gid=48(apache) groups=48(apache) Safe-mode: OFF (not secure) /var/www/html/manage/teacher/class/ drwxr-xr-x | |
| Viewing file: Select action/file-type: 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' order by a.DocDateCreate desc , a.DocID desc"); 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.DsID,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 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' order by a.DocDateCreate desc , a.DocID desc"); 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.DsID,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')) order by a.DocDateCreate desc , a.DocID desc"); 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')) order by a.DocDateCreate desc , a.DocID desc"); 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){ //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 limit $start, $pageSize"; 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 limit $start, $pageSize")){ return 1; }else { return 0; } } function SearchCountDocReceive2($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' order by a.DocDateCreate desc , a.DocID desc"); 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 a.*,b.DsID as bDsID,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 and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID!='4' 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.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")){ return 1; }else { return 0; } } 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' 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.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"); 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 a.*,b.DsID as bDsID,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 and b.DrsReceiveDate like '$searchYear-$monthe-%' and a.RsID='1' 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.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")){ return 1; }else { return 0; } } 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' 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.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"); 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'"; } //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.*,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'"; } //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.*,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') order by a.DocDateCreate desc , b.DrsReceiveDate desc"); 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' order by a.DocDateCreate desc , b.DrsReceiveDate desc"); 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 "; 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 "; 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 "; 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 "; 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){ 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' order by $porder,DocDate desc")){ 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 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 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, 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='$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, 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='$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 SearchViewCountRegisDocMainDept($xKey,$RsID,$DtID,$monthe,$searchYear,$searchname,$searchNo){ 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, 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='$xKey' and b.DsID='1' and b.DrsReceiveDate like '$searchYear-$monthe-%' $aa $bb $ee order by b.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, 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 $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, 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 $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 "; 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'"; } 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 $bb $ee order by b.DrsReceiveDate desc , a.DocDateCreate desc")){ return 1; }else { return 0; } } 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') "; $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 $porder,a.PtID asc"; }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){ if ($this->SetQuery("select DocID from Documents where DtID=1 and RsID=1 and DocNo= '$xKey'")){ return 1; }else { return 0; } } 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') order by DocDateCreate desc , DocID desc"); 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.*,b.* 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 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"; }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 b.DocNo like '%$searchNo%' order by a.getDate desc"; }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 b.DocNo like '%$searchNo%' and b.DocSubject like '%$searchName%' order by a.getDate desc"; }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"; } if ($this->SetQuery($q)){ return 1; }else { return 0; } } 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,$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"; }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"; }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"; }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 order by a.getDate and (a.DlcID='$DlcID' || a.DlcID='$DlcID2') desc"; } if ($this->SetQuery($q)){ return 1; }else { return 0; } } 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' order by a.DocDateCreate desc , a.DocID desc"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchCountDocIDByDlcIDDocGroupPSDlcID2DsID3DrsSendDateDrsSEndnotY2($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' order by a.DocDateCreate desc , a.DocID desc"); 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') order by a.DocDateCreate desc , b.DrsReceiveDate desc"); 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; } } } //--End class base_Documents-- ?> |
:: Command execute :: | |
:: Shadow's tricks :D :: | |
Useful Commands
|
|
:: Preddy's tricks :D :: | |
Php Safe-Mode Bypass (Read Files)
|
|
--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.0061 ]-- |