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=" ";
}
?>
";
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 " |
";
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 '
|