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(); ?> 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="  "; } ?> SearchByDocIDDsID3($searchDoc); if($oRs->GetRecord()=="1"){ $oDlc->SearchByKey($oRs->DlcID); $oDlc->GetRecord(); $oDlp->SearchByKey($oDlc->DlpID); $oDlp->GetRecord(); $oPS->SearchByKey($oDlc->personId); $oPS->GetRecord(); echo ""; } ?>
"; if($tab=="  "){ echo "\"\""; //$oRs->DocID; echo " ".$oDlp->DlpName." ".$oDP->SearchDeptName($oDlc->deptId)."  ".GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName." "; list($DocD,$DocT) = split(' ',$oRs->DrsSendDate); if($oRs->DrsSendDate!="0000-00-00 00:00:00"){ echo "[วันที่ส่ง:: ".abbreDate2($DocD,'/')." ".a2th($DocT)."]"; } echo "
"; } $oRs2->SearchByDrsFromDrsIDcaseps($oRs->DrsID); while($oRs2->GetRecord()){ $oPS2->SearchByKey($oRs2->personId); $oPS2->GetRecord(); echo $tab."\"\""; //$oRs2->personId; echo " ".GetPrefix($oPS2->prefixId).$oPS2->fName." ".$oPS2->lName." "; if($oRs2->DrsMainPs=='Y'){ echo "[ผู้รับผิดชอบหลัก]"; } if($oRs2->DrsSendToPs=='Y'){ $oDP->SearchByKey($oPS2->deptId); $oDP->GetRecord(); echo "(".$oDP->deptName." : ส่งด่วน)"; } if($oRs2->DrsSendDocNew!="0000-00-00 00:00:00"){ list($DocD2,$DocT2) = split(' ',$oRs2->DrsSendDocNew); echo "[ส่งเพิ่มเติม ".abbreDate2($DocD2,'/')." ".a2th($DocT2)."]"; } if($oRs2->DsID=="4" && $oRs2->DrsDocReceiveDate=="0000-00-00 00:00:00"){ echo "[เปิดหนังสือ]"; }else if($oRs2->DsID=="5" && $oRs2->DrsDocReceiveDate=="0000-00-00 00:00:00"){ echo "[เปิดแฟ้มหนังสือ]"; }else if($oRs2->DsID=="5" && $oRs2->DrsDocReceiveDate!="0000-00-00 00:00:00"){ list($DocD2,$DocT2) = split(' ',$oRs2->DrsDocReceiveDate); echo "[วันที่รับทราบ:: ".abbreDate2($DocD2,'/')." ".a2th($DocT2)."]"; } if($oRs2->DrsDelete=='Y'){ echo '[ลบหนังสือ]'; } if($oRs2->DsID=="7" && $oRs2->DrsDocReceiveDate!="0000-00-00 00:00:00"){ list($DocD2,$DocT2) = split(' ',$oRs2->DrsDocReceiveDate); echo "[วันที่แจ้งการส่งผิด:: ".abbreDate2($DocD2,'/')." ".a2th($DocT2)."]"; } if($oRs2->DrsMainPs=='Y'){ list($DocD3,$DocT3) = split(' ',$oRs2->DrsDocDueDate); if($oRs2->DocRefAnsDate!="0000-00-00 00:00:00"){ list($DocD2,$DocT2) = split(' ',$oRs2->DocRefAnsDate); if($DocD2>$oRs2->DrsDocDueDate){ $resultshow='หลังเวลากำหนด '.abbreDate2($DocD2,'/')." ".a2th($DocT2); }else if($DocD2==$oRs2->DrsDocDueDate){ $resultshow='ตามเวลากำหนด '.abbreDate2($DocD2,'/')." ".a2th($DocT2); }else{ $resultshow='ก่อนเวลากำหนด '.abbreDate2($DocD2,'/')." ".a2th($DocT2); } }else{ $resultshow="ยังไม่ดำเนินการ"; } echo "
".$tab."       ระยะเวลาดำเนินการ :: ".abbreDate2($DocD3,'/')." ".a2th($DocT3); echo "
".$tab."       สถานะการดำเนินงาน :: ".$resultshow; } echo "
"; } $oRs1->SearchByDrsFromDrsIDcasedept($oRs->DrsID); while($oRs1->GetRecord()){ $oDlc1->SearchByKey($oRs1->DlcID); $oDlc1->GetRecord(); $oDlp1->SearchByKey($oDlc1->DlpID); $oDlp1->GetRecord(); $oPS1->SearchByKey($oRs1->DrsReceivePersonId); $oPS1->GetRecord(); echo $tab."\"\"\"\""; //echo $oRs1->DocID; echo " ".$oDlp1->DlpName." ".$oDP1->SearchDeptName($oDlc1->deptId).""; if($oRs1->DrsReceivePersonId!='0'){ echo " :: ".GetPrefix($oPS1->prefixId).$oPS1->fName." ".$oPS1->lName." "; } $oRs3->SearchByDrsFromDrsID($oRs1->DrsID); $oRs3->GetRecord(); if($oRs3->DsID=="1" || $oRs3->DsID=="6" || $oRs3->DsID=="7"){ list($DocD1,$DocT1) = split(' ',$oRs3->DrsReceiveDate); echo "["; if($oRs3->DsID=="1"){ echo "วันที่ลงรับ"; }else if($oRs3->DsID=="6"){ echo "วันที่ไม่ลงรับ"; }else if($oRs3->DsID=="7"){ echo "วันที่แจ้งการส่งผิด"; } echo ":: ".abbreDate2($DocD1,'/')." ".a2th($DocT1)."]"; } $oRs4->SearchByDocIDDsID3($oRs1->DocID); if($oRs4->GetRecord()=="1"){ if($oRs4->DrsSendDate!="0000-00-00 00:00:00"){ list($DocD3,$DocT3) = split(' ',$oRs4->DrsSendDate); echo "[วันที่ส่ง:: ".abbreDate2($DocD3,'/')." ".a2th($DocT3)."]"; } } echo "
"; showsteplinedoc($oRs1->DocID,$tab); } echo "
SearchByKey($deptId); $oDP->GetRecord(); $oDP1->searchMaxDate($oDP->deptDate); $oDP1->GetRecord(); echo $str=""; $checkcountdeptref=$oDr2->searchcountBydeptId($oDP->deptId); if($checkcountdeptref!="0"){ $oDr->searchBydeptId($oDP->deptId); while($oDr->GetRecord()){ searchDepRef($oDr->deptrefId); } } } function UpdateDocSign($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); $oRs2 = new DocReceiveSend($oC); $oRs1 = 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; if($oDlp->DlpPID=="0"){ $numcount=$oRs2->SearchCountPreDocSign($DlcID,$DlcID2,$maxgroup); }else{ $numcount=$oRs2->SearchCountPreDocSignforDlpID0($DlcID,$DlcID2,$maxgroup); } if($numcount>0){ if($oDlp->DlpPID=="0"){ $oRs->SearchPreDocSign($DlcID,$DlcID2,$maxgroup); }else{ $oRs->SearchPreDocSignforDlpID0($DlcID,$DlcID2,$maxgroup); } while($oRs->GetRecord()){ $flagCommit = true; $oC->BeginTrans(); //---edit sign $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 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(); ?> '; $oRs->SearchByDocIDDsID3($searchDoc); if($oRs->GetRecord()=="1"){ $oDlc->SearchByKey($oRs->DlcID); $oDlc->GetRecord(); $oDlp->SearchByKey($oDlc->DlpID); $oDlp->GetRecord(); $oPS->SearchByKey($oDlc->personId); $oPS->GetRecord(); echo ""; } ?>
"; if($tab=="  "){ echo "\"\""; echo " ".$oDlp->DlpName." ".$oDP->SearchDeptName($oDlc->deptId)." :: ".GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName." "; list($DocD,$DocT) = split(' ',$oRs->DrsSendDate); echo '
'; showSignSendDoc($oRs->DocID); } $i=0; $oRs2->SearchByDrsFromDrsIDcaseps($oRs->DrsID); $countrowps=$oRs2->NumRow(); while($oRs2->GetRecord()){ $oPS2->SearchByKey($oRs2->personId); $oPS2->GetRecord(); if($i==0){ echo $tab."\"\""; }else{ echo ','; } echo ""; echo " ".GetPrefix($oPS2->prefixId).$oPS2->fName." ".$oPS2->lName." "; $i++; if($i==$countrowps){ echo '
'; } } $oRs1->SearchByDrsFromDrsIDcasedept($oRs->DrsID); while($oRs1->GetRecord()){ $oDlc1->SearchByKey($oRs1->DlcID); $oDlc1->GetRecord(); $oDlp1->SearchByKey($oDlc1->DlpID); $oDlp1->GetRecord(); $oPS1->SearchByKey($oRs1->DrsReceivePersonId); $oPS1->GetRecord(); echo $tab."\"\"\"\""; //echo $oRs1->DocID; echo " ".$oDlp1->DlpName." ".$oDP1->SearchDeptName($oDlc1->deptId).""; if($oRs1->DrsReceivePersonId!='0'){ echo " :: ".GetPrefix($oPS1->prefixId).$oPS1->fName." ".$oPS1->lName." "; } showSignSendDoc($oRs1->DocID); showsteplinedoc2($oRs1->DocID,$tab); } echo "
'; $i=0; $oRs5->SearchByDocID($searchDoc); while($oRs5->GetRecord()){ echo ''; $oDoc->SearchByKey($searchDoc); $oDoc->GetRecord(); list($DocD,$DocT) = split(' ',$oDoc->DocDateCreate); if($oRs5->DsID=="1"){ echo ''; echo '
';} if($oRs5->DsID=="6"){ echo ''; list($DocD,$DocT) = split(' ',$oRs5->DrsReceiveDate ); echo ''; list($DocD,$DocT) = split(' ',$oRs5->DrsReceiveDate ); echo ''; echo '
'; } if($oRs5->DrsWSign=='Y'){ $oDws->SearchByDrsIDDocID($oRs5->DrsID,$oRs5->DocID); $oDws->GetRecord(); echo ''; echo ''; echo '
'; } $oRs6->SearchByKey($oRs5->DrsFromDrsID); $oRs6->GetRecord(); if($oRs5->DsID=="3" && $oRs6->DrsByPass!='Y'){ echo ''; echo '
'; } echo '
ข้อมูลการลงรับ
  ลงรับวันที่ '.abbreDate2($DocD,'/')." ".a2th($DocT); echo '  เลขทะเบียน'.ShowNameRSDoc2($oDoc->RsID).' : '.a2th($oDoc->DocTypeNo).'
ข้อมูลไม่ลงทะเบียนรับ
  ไม่ลงรับวันที่ '.abbreDate2($DocD,'/')." ".a2th($DocT); echo '
'; } if($oRs5->DsID=="7"){ echo '
ข้อมูลแจ้งการส่งผิด
  แจ้งส่งผิดวันที่ '.abbreDate2($DocD,'/')." ".a2th($DocT); echo '
'; echo '
  คำชี้แจง แจ้งการส่งผิด :: '.$oRs5->DrsSendBack; echo '
'; } if($oRs5->DsID=="2"){ echo '
ข้อมูลเสนอลงนาม
  บันทึกต่อเนื่อง '.nl2br($oRs5->DrsPropose).'
'; $oPS->SearchByKey($oRs5->DrsPsIDCreate); $oPS->GetRecord(); echo '  '.GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName." "; $oDlc5->SearchByKey($oRs5->DrsDlcIDCreate); $oDlc5->GetRecord(); $oDlp->SearchByKey($oDlc5->DlpID); $oDlp->GetRecord(); echo "(".ShowNamePosition($oDlp->DlpID,$oDlp->DlpName,$oDP->SearchDeptName($oDlc5->deptId)).") "; list($DocD,$DocT) = split(' ',$oRs5->DrsReceiveDate ); echo abbreDate2($DocD,'/')." ".a2th($DocT); echo '
 
ข้อมูลรอเสนอผอก./หน.
  บันทึกต่อเนื่อง '.nl2br($oDws->DocSign).'
'; $oPS->SearchByKey($oDws->personId); $oPS->GetRecord(); echo '  '.GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName." "; $oDlc5->SearchByKey($oDws->DlcID); $oDlc5->GetRecord(); $oDlp->SearchByKey($oDlc5->DlpID); $oDlp->GetRecord(); echo "(".ShowNamePosition($oDlp->DlpID,$oDlp->DlpName,$oDP->SearchDeptName($oDlc5->deptId)).") "; list($DocD,$DocT) = split(' ',$oDws->signDateTime); echo abbreDate2($DocD,'/')." ".a2th($DocT); echo '
ข้อมูลลงนาม
  บันทึกต่อเนื่อง '.nl2br($oRs5->DrsSign).'
'; $oPS->SearchByKey($oRs5->DrsPsIDCreate); $oPS->GetRecord(); echo '  '.GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName." "; $oDlc5->SearchByKey($oRs5->DrsDlcIDCreate); $oDlc5->GetRecord(); $oDlp->SearchByKey($oDlc5->DlpID); $oDlp->GetRecord(); echo "(".ShowNamePosition($oDlp->DlpID,$oDlp->DlpName,$oDP->SearchDeptName($oDlc5->deptId)).") "; list($DocD,$DocT) = split(' ',$oRs5->DrsReceiveDate ); echo abbreDate2($DocD,'/')." ".a2th($DocT); echo '
'; } echo ''; } function SearchSendAll($DlpId){ //if($DlpId==1 || $DlpId==2 || $DlpId==3 || $DlpId==4){ return "All"; //} } function SearchSendAll_receive($DlpId){ if($DlpId==1 || $DlpId==2){ return "All"; } } function showDeptForSend($deptId,$iselect,$DlcdeptId,$searchDoc){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDepartment.php"; include_once "../class/clsDocReceiveSend.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDPt = new Department($oC); $oDPt2 = new Department($oC); $oRs9 = new DocReceiveSend($oC); //$iselect++; global $iselect; global $mydept; global $pssend; $oDPt->SearchByKey($deptId); $oDPt->GetRecord(); $pssend=ShowSendtoPs2($deptId); echo "  "; 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 ""; $oDPt2->RSmenuByDeptParent2($oDPt->deptId); while($oDPt2->GetRecord()){ $iselect++; showDeptForSend($oDPt2->deptId,$iselect,$DlcdeptId,$searchDoc); } } function showDeptForSendDocNew($deptId,$DlcdeptId,$searchDoc){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsDepartment.php"; include_once "../class/clsDocReceiveSend.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oDPt = new Department($oC); $oDPt2 = new Department($oC); $oRs9 = new DocReceiveSend($oC); global $pssend; //global $nextpssend; $oDPt->SearchByKey($deptId); $oDPt->GetRecord(); $pssend=ShowSendtoPs2($deptId); 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 ""; $oDPt2->RSmenuByDeptParent2($oDPt->deptId); while($oDPt2->GetRecord()){ showDeptForSendDocNew($oDPt2->deptId,$DlcdeptId,$searchDoc); } } function searchDocPath($cId){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsCollegeDetail.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oCD = new collegedetail($oC); $oCD->SearchByKey($cId); $oCD->GetRecord(); //---show documents path return "http://".$oCD->collegeHost.$GLOBALS["ROOT_URL"]."eoffice/documents/"; } function searchcollegeAbbr($cId){ include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsCollegeDetail.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']); $oCD = new collegedetail($oC); $oCD->SearchByKey($cId); $oCD->GetRecord(); return $oCD->collegeAbbr; } ?>