Viewing file:  clsDocReceiveSend.php (28.81 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class docreceivesend--------------------------
//--PK of docreceivesend ::
// 1. DrsID
class DocReceiveSend extends clsDB{
var $result;
var $DrsID;
var $DocID;
var $DlcID;
var $DsID;
var $personId;
var $PtID;
var $DrsDocTypeNo;
var $DrsReceiveDate;
var $DrsReceivePersonId;
var $DrsSendDate;
var $DrsSendPersonId;
var $DrsSendDlcID;
var $DrsDocDueDate;
var $DrsDlcIDCreate;
var $DrsPsIDCreate;
var $DrsPropose;
var $DrsSign;
var $DrsFromDrsID;
var $DocGroup;
var $DrsflagRead;
var $DrsByPass;
var $DrsSend;
var $DrsSendToPs;
var $DrsDelete;
var $DrsMainPs;
var $AnID;
var $DrsDocReceiveDate;
var $DocRefAnsDate;
var $DrsSendDocNew;
var $DrsInboxID;
var $DrsstartDatePost;
var $DrsendDatePost;
var $DrsSendBack;
var $DrsSendBackDlcID;
var $DrsfSendBack;
function DocReceiveSend(&$c){
$this->c=$c->c;
$this->DB=$c->db;
}
function Save(){
if ($this->status==1){
$sql = "insert into DocReceiveSend values(
'".th2a($this->DrsID)."',
'".th2a($this->DocID)."',
'".th2a($this->DlcID)."',
'".th2a($this->DsID)."',
'".th2a($this->personId)."',
'".th2a($this->PtID)."',
'".th2a($this->DrsDocTypeNo)."',
'".th2a($this->DrsReceiveDate)."',
'".th2a($this->DrsReceivePersonId)."',
'".th2a($this->DrsSendDate)."',
'".th2a($this->DrsSendPersonId)."',
'".th2a($this->DrsSendDlcID)."',
'".th2a($this->DrsDocDueDate)."',
'".th2a($this->DrsDlcIDCreate)."',
'".th2a($this->DrsPsIDCreate)."',
'".th2a($this->DrsPropose)."',
'".th2a($this->DrsSign)."',
'".th2a($this->DrsFromDrsID)."',
'".th2a($this->DocGroup)."',
'".th2a($this->DrsflagRead)."',
'".th2a($this->DrsByPass)."',
'".th2a($this->DrsSend)."',
'".th2a($this->DrsSendToPs)."',
'".th2a($this->DrsDelete)."',
'".th2a($this->DrsMainPs)."',
'".th2a($this->AnID)."',
'".th2a($this->DrsDocReceiveDate)."',
'".th2a($this->DocRefAnsDate)."',
'".th2a($this->DrsSendDocNew)."',
'".th2a($this->DrsInboxID)."',
'".th2a($this->DrsstartDatePost)."',
'".th2a($this->DrsendDatePost)."',
'".th2a($this->DrsSendBack)."',
'".th2a($this->DrsSendBackDlcID)."',
'".th2a($this->DrsfSendBack)."'
)";
}else {
$sql = "update DocReceiveSend set
DocID='".th2a($this->DocID)."',
DlcID='".th2a($this->DlcID)."',
DsID='".th2a($this->DsID)."',
personId='".th2a($this->personId)."',
PtID='".th2a($this->PtID)."',
DrsDocTypeNo='".th2a($this->DrsDocTypeNo)."',
DrsReceiveDate='".th2a($this->DrsReceiveDate)."',
DrsReceivePersonId='".th2a($this->DrsReceivePersonId)."',
DrsSendDate='".th2a($this->DrsSendDate)."',
DrsSendPersonId='".th2a($this->DrsSendPersonId)."',
DrsSendDlcID='".th2a($this->DrsSendDlcID)."',
DrsDocDueDate='".th2a($this->DrsDocDueDate)."',
DrsDlcIDCreate='".th2a($this->DrsDlcIDCreate)."',
DrsPsIDCreate='".th2a($this->DrsPsIDCreate)."',
DrsPropose='".th2a($this->DrsPropose)."',
DrsSign='".th2a($this->DrsSign)."',
DrsFromDrsID='".th2a($this->DrsFromDrsID)."',
DocGroup='".th2a($this->DocGroup)."',
DrsflagRead='".th2a($this->DrsflagRead)."',
DrsByPass='".th2a($this->DrsByPass)."',
DrsSend='".th2a($this->DrsSend)."',
DrsSendToPs='".th2a($this->DrsSendToPs)."',
DrsDelete='".th2a($this->DrsDelete)."',
DrsMainPs='".th2a($this->DrsMainPs)."',
AnID='".th2a($this->AnID)."',
DrsDocReceiveDate='".th2a($this->DrsDocReceiveDate)."',
DocRefAnsDate='".th2a($this->DocRefAnsDate)."',
DrsSendDocNew='".th2a($this->DrsSendDocNew)."',
DrsInboxID='".th2a($this->DrsInboxID)."',
DrsstartDatePost='".th2a($this->DrsstartDatePost)."',
DrsendDatePost='".th2a($this->DrsendDatePost)."',
DrsSendBack='".th2a($this->DrsSendBack)."',
DrsSendBackDlcID='".th2a($this->DrsSendBackDlcID)."',
DrsfSendBack='".th2a($this->DrsfSendBack)."'
where DrsID='".th2a($this->DrsID)."'";
//echo "----------".$sql.'<br>';
}
return $this->Dml($sql);
}
function Delete(){
return $this->Dml("delete from DocReceiveSend where DrsID='$this->DrsID'");
}
function NumRow(){
return $this->GetRowSelected();
}
function GetNextCode(){
$this->SetQuery("select max(DrsID) as num from DocReceiveSend");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
function RSDocReceiveSend(){
$this->SetQuery("select * from DocReceiveSend order by DrsID");
}
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->DrsPropose=a2th($this->DrsPropose);
$this->DrsSign=a2th($this->DrsSign);
$this->DrsSendBack=a2th($this->DrsSendBack);
}
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 DocReceiveSend where DrsID= '$xKey'")){
return 1;
}else {
return 0;
}
}
//****************** You can add new functions below **********************//
function SearchByDlcIDDocGroupMaxDateStatus10r2($xKey,$yKey,$zKey,$zKey2){
//echo "select Max(DrsReceiveDate) as num from DocReceiveSend where DlcID= '$xKey' and DocGroup='$yKey' and (DsID=1 or DsID=2) and DrsReceivePersonId = '$zKey'<br>";
$this->SetQuery("select Max(DrsReceiveDate) as num from DocReceiveSend where DlcID= '$xKey' and DocGroup='$yKey' and (DsID=1 or DsID=2) and DrsReceivePersonId = '$zKey' and DocID='$zKey2'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function SearchByDlcIDDocGroupPsDocIDStatus1DlcPS2($xKey,$yKey,$zKey2,$zKey3){
//echo "select * from DocReceiveSend where DlcID= '$xKey' and DocGroup='$yKey' and DrsReceiveDate = '$maxdate'<br>";
if ($this->SetQuery("select * from DocReceiveSend where (DlcID= '$xKey' || DlcID='$zKey3') and DocGroup='$yKey' and DocID='$zKey2' and DsID='1'")){
return 1;
}else {
return 0;
}
}
function SearchByDlcIDDocGroupPsDocIDStatus1DlcPS2flagread($xKey,$yKey,$zKey2,$zKey3){
//echo "select * from DocReceiveSend where DlcID= '$xKey' and DocGroup='$yKey' and DrsReceiveDate = '$maxdate'<br>";
if ($this->SetQuery("select * from DocReceiveSend where (DlcID= '$xKey' || DlcID='$zKey3') and DocGroup='$yKey' and DocID='$zKey2' and DsID='1' and DrsflagRead!='N'")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupPsDocIDStatus1($yKey,$zKey2){
//echo "select * from DocReceiveSend where DlcID= '$xKey' and DocGroup='$yKey' and DrsReceiveDate = '$maxdate'<br>";
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$yKey' and DocID='$zKey2' and DsID='1'")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupPsDocIDStatus1flagread($yKey,$zKey2){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$yKey' and DocID='$zKey2' and DsID='1' and DrsflagRead!='N'")){
return 1;
}else {
return 0;
}
}
function SearchByDlcIDDocGroupDocIDStatus1($xKey,$yKey,$zKey2){
if ($this->SetQuery("select * from DocReceiveSend where DlcID= '$xKey' and DocGroup='$yKey' and DocID='$zKey2' and DsID='1'")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDocIDStatus2($xKey,$yKey){
//$maxdate = $this->SearchByDlcIDDocGroupMaxDateStatus10r2($xKey,$yKey,$zKey,$zKey2);
//echo "select * from DocReceiveSend where DocGroup='$xKey' and DocID='$yKey' and DsID='2'";
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$xKey' and DocID='$yKey' and DsID='2'")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDocIDStatus2flagread($xKey,$yKey){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$xKey' and DocID='$yKey' and DsID='2' and DrsflagRead!='N'")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDocIDStatus3($xKey,$yKey){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$xKey' and DocID='$yKey' and DsID='3' and DrsSendDate='0000-00-00 00:00:00'")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDocIDStatus3DrsSendY($xKey,$yKey){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$xKey' and DocID='$yKey' and DsID='3' and DrsSendDate='0000-00-00 00:00:00' and DrsSend='Y'")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDocIDStatus3DrsSend($xKey,$yKey){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$xKey' and DocID='$yKey' and DsID='3' and DrsSendDate='0000-00-00 00:00:00' and DrsSend!='Y'")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDocIDStatus0($xKey,$yKey){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$xKey' and DocID='$yKey' and DsID='0' and DrsSendDate='0000-00-00 00:00:00'")){
return 1;
}else {
return 0;
}
}
function SearchByDlcIDDocGroup($xKey,$yKey){
//echo "select * from DocReceiveSend where DlcID= '$xKey' and DocGroup='$yKey'<br>";
$this->SetQuery("select * from DocReceiveSend where DlcID= '$xKey' and DocGroup='$yKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function SearchByDocIDDocGroupStatus($xKey,$yKey,$zKey){
//echo "select * from DocReceiveSend where DocID= '$xKey' and DocGroup='$yKey' and DsID ='$zKey'<br>";
if ($this->SetQuery("select * from DocReceiveSend where DocID= '$xKey' and DocGroup='$yKey' and DsID ='$zKey'")){
return 1;
}else {
return 0;
}
}
function SearchByDlcIDDocGroupDocId($xKey,$yKey,$zKey){
if ($this->SetQuery("select * from DocReceiveSend where DlcID= '$xKey' and DocGroup='$yKey' and DocID='$zKey'")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDocIDDlcIDDrsReceivePersonIdStatus2($xKey,$yKey,$zKey,$zKey2){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup= '$xKey' and DocID='$yKey' and DlcID='$zKey' and DrsReceivePersonId='$zKey2' and DsID='2'")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDocIDDlcIDDrsReceiveDlcID2Status2($xKey,$yKey,$zKey,$zKey3){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup= '$xKey' and DocID='$yKey' and (DlcID='$zKey' || DlcID='$zKey3') and DsID='2' order by DrsReceiveDate desc")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDlcIDDrsReceiveDlcID2Status2($xKey,$zKey,$zKey3){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup= '$xKey' and (DlcID='$zKey' || DlcID='$zKey3') and DsID='2' and DrsSendDate!='0000-00-00 00:00:00' order by DrsSendDate desc")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDlcIDDrsReceiveDlcID2Status2DrsSendDate($xKey,$zKey,$zKey3,$monthe,$searchYear,$searchName){
if($searchName!=""){
$q="select a.DocSubject,b.* from Documents a inner join DocReceiveSend b on b.DocGroup= '$xKey' and (b.DlcID='$zKey' || b.DlcID='$zKey3') and b.DsID='2' and b.DrsSendDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and a.DocSubject like '%$searchName%' order by b.DrsSendDate desc";
}else{
$q="select * from DocReceiveSend where DocGroup= '$xKey' and (DlcID='$zKey' || DlcID='$zKey3') and DsID='2' and DrsSendDate like '$searchYear-$monthe-%' order by DrsSendDate desc";
}
if ($this->SetQuery($q)){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDlcIDDrsReceiveDlcID2Status2Limit($xKey,$zKey,$zKey3,$start,$pageSize){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup= '$xKey' and (DlcID='$zKey' || DlcID='$zKey3') and DsID='2' and DrsSendDate!='0000-00-00 00:00:00' order by DrsSendDate desc limit $start, $pageSize")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDlcIDDrsReceiveDlcID2Status2LimitDrsSendDate($xKey,$zKey,$zKey3,$start,$pageSize,$monthe,$searchYear,$searchName){
if($searchName!=""){
$q="select a.DocSubject,b.* from Documents a inner join DocReceiveSend b on b.DocGroup= '$xKey' and (b.DlcID='$zKey' || b.DlcID='$zKey3') and b.DsID='2' and b.DrsSendDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and a.DocSubject like '%$searchName%' order by b.DrsSendDate desc limit $start, $pageSize";
}else{
$q="select * from DocReceiveSend where DocGroup= '$xKey' and (DlcID='$zKey' || DlcID='$zKey3') and DsID='2' and DrsSendDate like '$searchYear-$monthe-%' order by DrsSendDate desc limit $start, $pageSize";
}
if ($this->SetQuery($q)){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDrsFromDrsID($xKey,$yKey){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$xKey' and DrsFromDrsID='$yKey'")){
return 1;
}else {
return 0;
}
}
function SearchBypersonIdDrsDelete($xKey){
if ($this->SetQuery("select * from DocReceiveSend where personId ='$xKey' and DrsflagRead!='N' and DrsDelete!='Y' order by DrsReceiveDate desc")){
return 1;
}else {
return 0;
}
}
function SearchBypersonIdDocGroupDsID0($xKey,$yKey){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$yKey' and personId ='$xKey' and DrsflagRead!='N' and DsID='0' order by DrsReceiveDate desc")){
return 1;
}else {
return 0;
}
}
function SearchBypersonIdDocGroupDrsDelete2($xKey,$yKey,$zKey){
if($zKey!=""){
$a="and DocID in(select DocID from Documents where DocSubject like '%$zKey%')";
}
//echo "select * from DocReceiveSend where DocGroup='$yKey' and personId ='$xKey' and (DsID='4' || DsID='5') and DrsDelete!='Y' $a order by DrsReceiveDate desc";
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$yKey' and personId ='$xKey' and (DsID='4' || DsID='5') and DrsDelete!='Y' $a order by DrsReceiveDate desc")){
return 1;
}else {
return 0;
}
}
function SearchBypersonIdDrsDelete2DrsInboxIDDrsflagRead($xKey,$zKey,$DrsInboxID){
if($zKey!=""){
$a="and DocID in(select DocID from Documents where DocSubject like '%$zKey%')";
}
//echo "select * from DocReceiveSend where DocGroup='$yKey' and personId ='$xKey' and (DsID='4' || DsID='5') and DrsDelete!='Y' $a order by DrsReceiveDate desc";
if ($this->SetQuery("select * from DocReceiveSend where personId ='$xKey' and (DsID='4' || DsID='5') and DrsDelete!='Y' $a and DrsInboxID='$DrsInboxID' and DrsflagRead='N' order by DrsReceiveDate desc")){
return 1;
}else {
return 0;
}
}
function SearchBypersonIdDocGroup2DrsDeleteLimit($xKey,$yKey,$start,$pageSize,$zKey){
if($zKey!=""){
$a="and DocID in(select DocID from Documents where DocSubject like '%$zKey%')";
}
//echo "select * from DocReceiveSend where DocGroup='$yKey' and personId ='$xKey' and DrsflagRead!='N' order by DrsReceiveDate desc";
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$yKey' and personId ='$xKey' and (DsID='4' || DsID='5') and DrsDelete!='Y' $a order by DrsReceiveDate desc limit $start, $pageSize")){
return 1;
}else {
return 0;
}
}
function SearchBypersonId2DrsDeleteLimitDrsInboxIDDrsflagRead($xKey,$start,$pageSize,$zKey,$DrsInboxID){
if($zKey!=""){
$a="and DocID in(select DocID from Documents where DocSubject like '%$zKey%')";
}
//echo "select * from DocReceiveSend where DocGroup='$yKey' and personId ='$xKey' and DrsflagRead!='N' order by DrsReceiveDate desc";
if ($this->SetQuery("select * from DocReceiveSend where personId ='$xKey' and (DsID='4' || DsID='5') and DrsDelete!='Y' $a and DrsInboxID='$DrsInboxID' and DrsflagRead='N' order by DrsReceiveDate desc limit $start, $pageSize")){
return 1;
}else {
return 0;
}
}
function SearchBypersonIdDrsDeleteLimit($xKey,$start,$pageSize){
if ($this->SetQuery("select * from DocReceiveSend where personId ='$xKey' and DrsflagRead!='N' and DrsDelete!='Y' order by DrsReceiveDate desc limit $start, $pageSize")){
return 1;
}else {
return 0;
}
}
function SearchByDrsIDDocGroup($xKey,$yKey){
//echo "select * from DocReceiveSend where DlcID= '$xKey' and DocGroup='$yKey'<br>";
if ($this->SetQuery("select * from DocReceiveSend where DrsID= '$xKey' and DocGroup='$yKey'")){
return 1;
}else {
return 0;
}
}
function SearchByDocIDStatus3($xKey){
if ($this->SetQuery("select * from DocReceiveSend where DocID='$xKey' and DsID='3'")){
return 1;
}else {
return 0;
}
}
function SearchByDocIDStatus($xKey,$yKey){
if ($this->SetQuery("select * from DocReceiveSend where DocID='$xKey' and DsID='$yKey'")){
return 1;
}else {
return 0;
}
}
function SearchByDocIDStatus2($xKey){
if ($this->SetQuery("select * from DocReceiveSend where DocID='$xKey' and DsID='2'")){
return 1;
}else {
return 0;
}
}
function SearchByDocIDStatus1($xKey){
if ($this->SetQuery("select * from DocReceiveSend where DocID='$xKey' and DsID='1'")){
return 1;
}else {
return 0;
}
}
function SearchByDrsFromDrsID($xKey){
if ($this->SetQuery("select * from DocReceiveSend where DrsFromDrsID='$xKey'")){
return 1;
}else {
return 0;
}
}
function SearchByDrsFromDrsIDcasedept($xKey){
if ($this->SetQuery("select * from DocReceiveSend where DrsFromDrsID='$xKey' and DlcID!='0' and personId='0'")){
return 1;
}else {
return 0;
}
}
function SearchByDrsFromDrsIDcaseps($xKey){
if ($this->SetQuery("select * from DocReceiveSend where DrsFromDrsID='$xKey' and DlcID='0' and personId!='0'")){
return 1;
}else {
return 0;
}
}
function SearchByDrsFromDrsIDPS($xKey,$yKey){
$this->SetQuery("select count(personId) as num from DocReceiveSend where DrsFromDrsID='$xKey' and personId='$yKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function SearchByDrsFromDrsIDDsID2($xKey){
if ($this->SetQuery("select * from DocReceiveSend where DrsFromDrsID='$xKey' and DsID='2'")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDsID1($xKey){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$xKey' and DsID='1' order by DrsReceiveDate desc")){
return 1;
}else {
return 0;
}
}
function SearchByDocGroupDsID1Limit($xKey,$start,$pageSize){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$xKey' and DsID='1' order by DrsReceiveDate desc limit $start, $pageSize")){
return 1;
}else {
return 0;
}
}
function SearchByDlcIDDocGroupDsID1DlcPS2($xKey,$yKey,$zKey){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$yKey' and DsID='1' and (DlcID= '$xKey' || DlcID='$zKey') order by DrsReceiveDate desc")){
return 1;
}else {
return 0;
}
}
function SearchByDlcIDDocGroupDsID31DlcPS2($xKey,$yKey,$zKey){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$yKey' and DsID='3' and (DlcID= '$xKey' || DlcID='$zKey') and DrsSendDate!='0000-00-00 00:00:00' order by DrsSendDate desc")){
return 1;
}else {
return 0;
}
}
function SearchByDlcIDDocGroupDsID31DlcPS2DrsSendDate($xKey,$yKey,$zKey,$monthe,$searchYear,$searchName){
if($searchName!=""){
$q="select a.DocSubject,b.* from Documents a inner join DocReceiveSend b on b.DocGroup='$yKey' and b.DsID='3' and (b.DlcID= '$xKey' || b.DlcID='$zKey') and b.DrsSendDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and a.DocSubject like '%$searchName%' order by b.DrsSendDate desc";
}else{
$q="select * from DocReceiveSend where DocGroup='$yKey' and DsID='3' and (DlcID= '$xKey' || DlcID='$zKey') and DrsSendDate like '$searchYear-$monthe-%' order by DrsSendDate desc";
}
if ($this->SetQuery($q)){
return 1;
}else {
return 0;
}
}
function SearchByDlcIDDocGroupDsID31DlcPS2Limit($xKey,$yKey,$zKey,$start,$pageSize,$monthe,$searchYear){
//echo "select * from DocReceiveSend where DocGroup='$yKey' and DsID='3' and (DlcID= '$xKey' || DlcID='$zKey') and (DrsSendDate!='0000-00-00 00:00:00' and DrsSendDate like '$searchYear-$monthe-%') order by DrsSendDate desc limit $start, $pageSize";
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$yKey' and DsID='3' and (DlcID= '$xKey' || DlcID='$zKey') and (DrsSendDate!='0000-00-00 00:00:00' and DrsSendDate like '$searchYear-$monthe-%') order by DrsSendDate desc limit $start, $pageSize")){
return 1;
}else {
return 0;
}
}
function SearchByDlcIDDocGroupDsID31DlcPS2LimitDrsSendDate($xKey,$yKey,$zKey,$start,$pageSize,$monthe,$searchYear,$searchName){
if($searchName!=""){
$q="select a.DocSubject,b.* from Documents a inner join DocReceiveSend b on b.DocGroup='$yKey' and b.DsID='3' and (b.DlcID= '$xKey' || b.DlcID='$zKey') and b.DrsSendDate like '$searchYear-$monthe-%' and a.DocID=b.DocID and a.DocSubject like '%$searchName%' order by b.DrsSendDate desc limit $start, $pageSize";
}else{
$q="select * from DocReceiveSend where DocGroup='$yKey' and DsID='3' and (DlcID= '$xKey' || DlcID='$zKey') and DrsSendDate like '$searchYear-$monthe-%' order by DrsSendDate desc limit $start, $pageSize";
}
if ($this->SetQuery($q)){
return 1;
}else {
return 0;
}
}
function SearchByDlcIDDocGroupDsID1DlcPS2Limit($xKey,$yKey,$zKey,$start,$pageSize){
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$yKey' and DsID='1' and (DlcID= '$xKey' || DlcID='$zKey') order by DrsReceiveDate desc limit $start, $pageSize")){
return 1;
}else {
return 0;
}
}
function SearchByDrsFromDrsIDDrsMainPsY($xKey){
$this->SetQuery("select personId as num from DocReceiveSend where DrsFromDrsID='$xKey' and DrsMainPs='Y'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function s(){
//echo "select * from DocReceiveSend where DlcID= '$xKey' and DocGroup='$yKey'<br>";
if ($this->SetQuery("select * from DocReceiveSend where DrsID='226'")){
//if ($this->SetQuery("select * from DocReceiveSend where DrsFromDrsID='604'")){
return 1;
}else {
return 0;
}
}
function SearchByDrsFromDrsIDDrsMainPs($xKey){
if ($this->SetQuery("select * from DocReceiveSend where DrsFromDrsID='$xKey' and DrsMainPs='Y'")){
return 1;
}else {
return 0;
}
}
function SearchByDrsFromDrsIDDocIDDrsMainPsY($xKey,$yKey){
if ($this->SetQuery("select * from DocReceiveSend where DrsFromDrsID='$xKey' and DocID='$yKey' and DrsMainPs='Y'")){
return 1;
}else {
return 0;
}
}
function updateinbox($xKey,$yKey){
//echo "select * from DocReceiveSend where DocGroup='$yKey' and personId ='$xKey' and (DsID='4' || DsID='5') and DrsflagRead='N' and DrsDelete!='Y' order by DrsReceiveDate desc<br>";
if ($this->SetQuery("select * from DocReceiveSend where DocGroup='$yKey' and personId ='$xKey' and (DsID='4' || DsID='5') and DrsflagRead='N' and DrsDelete!='Y' order by DrsReceiveDate desc")){
return 1;
}else {
return 0;
}
}
function CountDocInFolder($xKey,$yKey){
$this->SetQuery("select count(DrsID)as num from DocReceiveSend where personId ='$xKey' and DrsflagRead='N' and DrsDelete!='Y' and DrsInboxID='$yKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function SearchByPersonIdDrsDeleteDrsflagReadDrsInboxID($xKey,$yKey){
//echo "select * from DocReceiveSend where DocGroup='$yKey' and personId ='$xKey' and (DsID='4' || DsID='5') and DrsflagRead='N' and DrsDelete!='Y' order by DrsReceiveDate desc<br>";
if ($this->SetQuery("select * from DocReceiveSend where personId ='$xKey' and DrsflagRead='N' and DrsDelete!='Y' and DrsInboxID='$yKey'")){
return 1;
}else {
return 0;
}
}
function SearchByDocIDAnID($xKey){
if ($this->SetQuery("select * from DocReceiveSend where DocID='$xKey' and AnID!=0")){
return 1;
}else {
return 0;
}
}
function searchHaveSendDoc($pssend,$nextpssend,$searchDoc){
$q="select a.DocID as DocuID, b. * from Documents a inner join DocReceiveSend b on (a.DocPID = '$searchDoc' || (a.DocID='$searchDoc' && a.DocPID=0)) and a.DocID = b.DocID and b.DsID = '0' and b.DrsFromDrsID != '0' and (b.DlcID = '$pssend' || b.DlcID = '$nextpssend')";
if ($this->SetQuery($q)){
return 1;
}else {
return 0;
}
}
function searchHaveSendDocps($ps,$searchDoc){
$q="select a.DocID as DocuID, b. * from Documents a inner join DocReceiveSend b on (a.DocPID = '$searchDoc' || (a.DocID='$searchDoc' && a.DocPID=0)) and a.DocID = b.DocID and b.DrsFromDrsID != '0' and b.DlcID = '0' and b.personId='$ps' ";
if ($this->SetQuery($q)){
return 1;
}else {
return 0;
}
}
function SearchByDocIDDsID3($xKey){
//echo "select * from Documents where DlcID= '$xKey' and DocGroup='$yKey' and RsID = '$zKey' and DtID = '$zKey2' and DocUserCreate='$zKey3' and fDelete!='Y' and DsID='3' order by DocDateCreate desc<br>";
if ($this->SetQuery("select * from DocReceiveSend where DocID= '$xKey' and DsID='3'")){
return 1;
}else {
return 0;
}
}
function SearchByDocIDDsID3Docgroup($xKey,$maxgroup){
//echo "select * from Documents where DlcID= '$xKey' and DocGroup='$yKey' and RsID = '$zKey' and DtID = '$zKey2' and DocUserCreate='$zKey3' and fDelete!='Y' and DsID='3' order by DocDateCreate desc<br>";
if ($this->SetQuery("select * from DocReceiveSend where DocID= '$xKey' and DsID='3' and DocGroup='$maxgroup' ")){
return 1;
}else {
return 0;
}
}
function SearchPreDocSign($xKey,$yKey,$maxgroup){
//echo "select * from DocReceiveSend where DsID='2' and (DlcID='$xKey' || DlcID='$yKey') and DrsSendDate='0000-00-00' and DocGroup='$maxgroup' ";
if ($this->SetQuery("select * from DocReceiveSend where DsID='2' and (DlcID='$xKey' || DlcID='$yKey') and DrsSendDate='0000-00-00' and DocGroup='$maxgroup' ")){
return 1;
}else {
return 0;
}
}
function SearchPreDocSend($xKey,$yKey,$maxgroup){
//echo "select * from DocReceiveSend where DsID='3' and (DlcID='$xKey' || DlcID='$yKey') and DrsSendDate='0000-00-00' and DocGroup='$maxgroup' ";
if ($this->SetQuery("select * from DocReceiveSend where DsID='3' and (DlcID='$xKey' || DlcID='$yKey') and DrsSendDate='0000-00-00' and DocGroup='$maxgroup' ")){
return 1;
}else {
return 0;
}
}
function SearchPreDocReceive($xKey,$yKey,$maxgroup,$DocID){
//echo "select * from DocReceiveSend where DsID='3' and (DlcID='$xKey' || DlcID='$yKey') and DrsSendDate='0000-00-00' and DocGroup='$maxgroup' ";
if ($this->SetQuery("select * from DocReceiveSend where DsID='0' and (DlcID='$xKey' || DlcID='$yKey') and DocID='$DocID' and DrsSendDate='0000-00-00' and DocGroup='$maxgroup' ")){
return 1;
}else {
return 0;
}
}
function SearchByDlcIDDocGroupDrsSendBackDrsSendBackDlcID($DLCID,$MaxDocGroup,$DlcPS2){
//echo "select a.DocID as DocuID, a.DocPID as DocuPID, b. * from Documents a inner join DocReceiveSend b on b.DsID='7' and (b.DrsSendBackDlcID ='$DLCID' || b.DrsSendBackDlcID ='$DlcPS2') and b.DocGroup='$MaxDocGroup' and a.DocID=b.DocID ";
if ($this->SetQuery("select a.DocID as DocuID, a.DocPID as DocuPID, b. * from Documents a inner join DocReceiveSend b on b.DsID='7' and (b.DrsSendBackDlcID ='$DLCID' || b.DrsSendBackDlcID ='$DlcPS2') and b.DocGroup='$MaxDocGroup' and a.DocID=b.DocID and b.DrsfSendBack!='Y' order by b.DrsReceiveDate desc")){
return 1;
}else {
return 0;
}
}
function SearchByDlcIDDocGroupDrsSendBackDrsSendBackDlcIDcount($DLCID,$MaxDocGroup,$DlcPS2,$monthe,$searchYear,$searchName){
if($searchName!=""){
$p="and a.DocSubject like '%$searchName%'";
}
//echo "select a.DocID as DocuID, a.DocPID as DocuPID, b. * from Documents a inner join DocReceiveSend b on b.DsID='7' and (b.DrsSendBackDlcID ='$DLCID' || b.DrsSendBackDlcID ='$DlcPS2') and b.DocGroup='$MaxDocGroup' and a.DocID=b.DocID and b.DrsfSendBack='Y' and b.DrsReceiveDate like '$searchYear-$monthe-%' $p order by b.DrsReceiveDate desc";
if ($this->SetQuery("select a.DocID as DocuID, a.DocPID as DocuPID, b. * from Documents a inner join DocReceiveSend b on b.DsID='7' and (b.DrsSendBackDlcID ='$DLCID' || b.DrsSendBackDlcID ='$DlcPS2') and b.DocGroup='$MaxDocGroup' and a.DocID=b.DocID and b.DrsfSendBack='Y' and b.DrsReceiveDate like '$searchYear-$monthe-%' $p order by b.DrsReceiveDate desc")){
return 1;
}else {
return 0;
}
}
function SearchByDlcIDDocGroupDrsSendBackDrsSendBackDlcIDlimit($DLCID,$MaxDocGroup,$DlcPS2,$monthe,$searchYear,$searchName,$start,$pageSize){
if($searchName!=""){
$p="and a.DocSubject like '%$searchName%'";
}
//echo "select a.DocID as DocuID, a.DocPID as DocuPID, b. * from Documents a inner join DocReceiveSend b on b.DsID='7' and (b.DrsSendBackDlcID ='$DLCID' || b.DrsSendBackDlcID ='$DlcPS2') and b.DocGroup='$MaxDocGroup' and a.DocID=b.DocID and b.DrsfSendBack='Y' and b.DrsReceiveDate like '$searchYear-$monthe-%' $p order by b.DrsReceiveDate desc";
if ($this->SetQuery("select a.DocID as DocuID, a.DocPID as DocuPID, b. * from Documents a inner join DocReceiveSend b on b.DsID='7' and (b.DrsSendBackDlcID ='$DLCID' || b.DrsSendBackDlcID ='$DlcPS2') and b.DocGroup='$MaxDocGroup' and a.DocID=b.DocID and b.DrsfSendBack='Y' and b.DrsReceiveDate like '$searchYear-$monthe-%' $p order by b.DrsReceiveDate desc limit $start, $pageSize")){
return 1;
}else {
return 0;
}
}
function SearchCountPsDoc($xKey){
$this->SetQuery("select count(personId) as num from DocReceiveSend where personId='$xKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
} //--End class docreceivesend--
?>
|