Viewing file:  funct.php (82.29 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
function ShowRunningDoc($RsID,$DtID,$deptId){
include_once("../../clas/clsConnection.php");
include_once("../../clas/clsDB.php");
include_once "../global.php";
include_once "../clas/clsDepartment.php";
include_once "../clas/clsRunningDoc.php";
include_once "../clas/clsDocType.php";
include_once "../link/keyThai.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);
$oRd = new runningdoc($oC);
$oDt = new doctype($oC);
$oDt1 = new doctype($oC);
$maxgroup=$oDP->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 "../clas/clsDepartment.php";
include_once "../clas/clsDocType.php";
include_once "../clas/clsRunningDoc.php";
include_once "../clas/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("../../class/clsConnection.php");
include_once("../../class/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("../../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->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("../../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+1);
$oDlc2->SearchByNextDlcID($nextSeq,$maxgroup,$oDlc->deptId); $oDlc2->GetRecord();
$nextDlcID=$oDlc2->DlcID;
return $nextDlcID;
}
}
function GetNextPsToByPass($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->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("../../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);
$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("../../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);
$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("../../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);
$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("../../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 ShowSendtoPs($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();
$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();
?>
<script>
window.opener.location.href="showEntryDoc.php?DocID=<? echo $DocID; ?>&DrsID=<? echo $DrsID; ?>";
</script>
<?
}
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 "<br>";
if($oRs1->personId==0){
//echo " ".$oDlp->DlpName."<br>";
echo " ".$oDP->deptName."<br>";
}
}
}
}
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=" ";
}
?>
<table border="0" align="center" width="98%" >
<?
$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 "<tr><td>";
if($tab==" "){
echo "<img src=\"../picture/reg.png\" alt=\"\" border=\"0\" >"; //$oRs->DocID;
echo " <strong>".$oDlp->DlpName." ".$oDP->SearchDeptName($oDlc->deptId)." </strong> <font color=\"#000099\">".GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName."</font> ";
list($DocD,$DocT) = split(' ',$oRs->DrsSendDate);
if($oRs->DrsSendDate!="0000-00-00 00:00:00"){ echo "[วันที่ส่ง:: ".abbreDate2($DocD,'/')." ".a2th($DocT)."]"; } echo "<br>";
}
$oRs2->SearchByDrsFromDrsIDcaseps($oRs->DrsID);
while($oRs2->GetRecord()){
$oPS2->SearchByKey($oRs2->personId);
$oPS2->GetRecord();
echo $tab."<img src=\"../picture/linesub.gif\" alt=\"\" border=\"0\" ><font color=\"#000099\">"; //$oRs2->personId;
echo " ".GetPrefix($oPS2->prefixId).$oPS2->fName." ".$oPS2->lName."</font> ";
if($oRs2->DrsMainPs=='Y'){
echo "[ผู้รับผิดชอบหลัก]";
}
if($oRs2->DrsSendToPs=='Y'){
$oDP->SearchByKey($oPS2->deptId);
$oDP->GetRecord();
echo "<font color=\"#FF0000\">(".$oDP->deptName." : ส่งด่วน)</font>";
}
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 "<br>".$tab." <font color=#330000><strong>ระยะเวลาดำเนินการ ::</strong></font> ".abbreDate2($DocD3,'/')." ".a2th($DocT3);
echo "<br>".$tab." <font color=#330000><strong>สถานะการดำเนินงาน ::</strong></font> ".$resultshow;
}
echo "<br>";
}
$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."<img src=\"../picture/linesub.gif\" alt=\"\" border=\"0\" ><img src=\"../picture/reg.png\" alt=\"\" border=\"0\" ><strong>"; //echo $oRs1->DocID;
echo " ".$oDlp1->DlpName." ".$oDP1->SearchDeptName($oDlc1->deptId)."</strong>";
if($oRs1->DrsReceivePersonId!='0'){
echo " <strong>::</strong> <font color=\"#000099\">".GetPrefix($oPS1->prefixId).$oPS1->fName." ".$oPS1->lName."</font> ";
}
$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 "<br>";
showsteplinedoc($oRs1->DocID,$tab);
}
echo "</td></tr>";
}
?>
</table>
<?
}
function searchDepRef($deptId){
include_once("../../class/clsConnection.php");
include_once("../../class/clsDB.php");
include_once "../global.php";
include_once "../class/clsDepartment.php";
include_once "../link/function.php";
include_once "getPrefix.php";
include_once "../class/clsdeptref.php";
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);
$oDP = new Department($oC);
$oDP1 = new Department($oC);
$oDr= new deptref($oC);
$oDr2= new deptref($oC);
$oDP->SearchByKey($deptId);
$oDP->GetRecord();
$oDP1->searchMaxDate($oDP->deptDate); $oDP1->GetRecord();
echo $str="<option value=".$oDP->deptId.">".$oDP->deptName." [".abbreDate2($oDP->deptDate,'/')." - ".abbreDate2($oDP1->deptDate,'/')."]</option>";
$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."<br>";
$oRs->DocID=$oRs->DocID;
$oRs->DlcID=$DlcID;
//echo "DlcID----".$oRs->DlcID."<br>";
$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."<br>";
$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."<br>";
$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."<br>";
$oRs1->DrsSendDlcID=$DlcID;
//echo "DrsSendDlcID----".$oRs1->DrsSendDlcID."<br>";
$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."<br>";
$oRs->DocID=$oRs->DocID;
$oRs->DlcID=$DlcID;
//echo "DlcID----".$oRs->DlcID."<br>";
$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."<br>";
$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."<br>";
$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."<br>";
$oRs1->DrsSendDlcID=$DlcID;
//echo "DrsSendDlcID----".$oRs1->DrsSendDlcID."<br>";
$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."<br>";
$oDoc->DocPID=$oDoc->DocPID;
//echo "DocPID=".$oDoc->DocPID."<br>";
$oDoc->DlcID=$DlcID;
//echo "DlcID=".$oDoc->DlcID."<br>";
$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."<br>";
$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."<br>";
$oRs2->DocID=$oRs2->DocID;
//echo "DocID=".$oRs2->DocID."<br>";
$oRs2->DlcID=$DlcID;
//echo "DlcID=".$oRs2->DlcID."<br>";
$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."<br>";
$oRs2->DrsSendDate=$oRs2->DrsSendDate;
$oRs2->DrsSendPersonId=$oRs2->DrsSendPersonId;
$oRs2->DrsSendDlcID=$oRs2->DrsSendDlcID;
$oRs2->DrsDocDueDate=$oRs2->DrsDocDueDate;
//echo "speedDate2=".$speedDate."<br>";
$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();
?>
<table border="0" align="center" width="98%" >
<?
echo '</td></tr>';
$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 "<tr><td>";
if($tab==" "){
echo "<img src=\"../picture/reg.png\" alt=\"\" border=\"0\" >";
echo " <strong>".$oDlp->DlpName." ".$oDP->SearchDeptName($oDlc->deptId)." ::</strong> <font color=\"#000099\">".GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName."</font> ";
list($DocD,$DocT) = split(' ',$oRs->DrsSendDate);
echo '<br>';
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."<img src=\"../picture/linesub.gif\" alt=\"\" border=\"0\" >";
}else{
echo ',';
}
echo "<font color=\"#000099\">";
echo " ".GetPrefix($oPS2->prefixId).$oPS2->fName." ".$oPS2->lName."</font> ";
$i++;
if($i==$countrowps){
echo '<br>';
}
}
$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."<img src=\"../picture/linesub.gif\" alt=\"\" border=\"0\" ><img src=\"../picture/reg.png\" alt=\"\" border=\"0\" ><strong>"; //echo $oRs1->DocID;
echo " ".$oDlp1->DlpName." ".$oDP1->SearchDeptName($oDlc1->deptId)."</strong>";
if($oRs1->DrsReceivePersonId!='0'){
echo " <strong>::</strong> <font color=\"#000099\">".GetPrefix($oPS1->prefixId).$oPS1->fName." ".$oPS1->lName."</font> ";
}
showSignSendDoc($oRs1->DocID);
showsteplinedoc2($oRs1->DocID,$tab);
}
echo "</td></tr>";
}
?>
</table>
<?
}
function showSignSendDoc($searchDoc){
include_once("../../class/clsConnection.php");
include_once("../../class/clsDB.php");
include_once "../global.php";
include_once "../link/functionshow.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";
include_once "../class/clsDocWSign.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);
$oRs6 = new DocReceiveSend($oC);
$oDlc = new DocLineConfig($oC);
$oDlc5 = 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);
$oDws = new docwsign($oC);
echo '<table width="80%" border="0" align=center cellpadding=0 cellspacing=0 ><tr><td>';
$i=0;
$oRs5->SearchByDocID($searchDoc);
while($oRs5->GetRecord()){
echo '<table width="100%" border="0" align=center cellpadding=0 cellspacing=0 bordercolor=#DADADA style=border-collapse:collapse>';
$oDoc->SearchByKey($searchDoc); $oDoc->GetRecord();
list($DocD,$DocT) = split(' ',$oDoc->DocDateCreate);
if($oRs5->DsID=="1"){
echo '<tr><td height=22 bgcolor=#F0F8FF><strong><font color=#336600>ข้อมูลการลงรับ</font></strong></td></tr>';
echo '<tr><td bgcolor=#F0F8FF> <font color=#FF6600>ลงรับวันที่</font> '.abbreDate2($DocD,'/')." ".a2th($DocT); echo ' <font color=#FF6600>เลขทะเบียน'.ShowNameRSDoc2($oDoc->RsID).'</font> : '.a2th($oDoc->DocTypeNo).'</td></tr><br>';}
if($oRs5->DsID=="6"){
echo '<tr><td height=22 bgcolor=#F0F8FF><strong><font color=#336600>ข้อมูลไม่ลงทะเบียนรับ</font></strong></td></tr>';
list($DocD,$DocT) = split(' ',$oRs5->DrsReceiveDate );
echo '<tr><td bgcolor=#F0F8FF> <font color=#FF6600>ไม่ลงรับวันที่</font> '.abbreDate2($DocD,'/')." ".a2th($DocT); echo '<br>';
}
if($oRs5->DsID=="7"){
echo '<tr><td height=22 bgcolor=#F0F8FF><strong><font color=#336600>ข้อมูลแจ้งการส่งผิด</font></strong></td></tr>';
list($DocD,$DocT) = split(' ',$oRs5->DrsReceiveDate );
echo '<tr><td bgcolor=#F0F8FF> <font color=#FF6600>แจ้งส่งผิดวันที่</font> '.abbreDate2($DocD,'/')." ".a2th($DocT); echo '<br>';
echo '<tr><td bgcolor=#F0F8FF> <font color=#FF6600>คำชี้แจง แจ้งการส่งผิด :: </font> '.$oRs5->DrsSendBack; echo '<br>';
}
if($oRs5->DsID=="2"){
echo '<tr><td height=22 bgcolor=#FFFAE8><strong><font color=#336600>ข้อมูลเสนอลงนาม</font></strong></td></tr>';
echo '<tr><td bgcolor=#FFFAE8> <font color=#FF6600>บันทึกต่อเนื่อง</font> '.nl2br($oRs5->DrsPropose).'<br>';
$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 '</td></tr><br>';
}
if($oRs5->DrsWSign=='Y'){
$oDws->SearchByDrsIDDocID($oRs5->DrsID,$oRs5->DocID);
$oDws->GetRecord();
echo '<tr><td> </td></tr>';
echo '<tr><td height=22 bgcolor=#FFFAE8><strong><font color=#336600>ข้อมูลรอเสนอผอก./หน.</font></strong></td></tr>';
echo '<tr><td bgcolor=#FFFAE8> <font color=#FF6600>บันทึกต่อเนื่อง</font> '.nl2br($oDws->DocSign).'<br>';
$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 '</td></tr><br>';
}
$oRs6->SearchByKey($oRs5->DrsFromDrsID);
$oRs6->GetRecord();
if($oRs5->DsID=="3" && $oRs6->DrsByPass!='Y'){
echo '<tr><td height=22 bgcolor=#E4F0F9><strong><font color=#336600>ข้อมูลลงนาม</font></strong></td></tr>';
echo '<tr><td bgcolor=#E4F0F9> <font color=#FF6600>บันทึกต่อเนื่อง</font> '.nl2br($oRs5->DrsSign).'<br>';
$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 '</td></tr><br>';
}
echo '</table>';
}
echo '</td></tr></table>';
}
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 "<tr><td> ";
echo "<input name=deptPs[".$deptId."] id=select1[".$iselect."] type=checkbox value=\"".$pssend."\"";
if($pssend==''){ echo " disabled "; }
echo ">";
if($DlcdeptId==$deptId){ $mydept=$iselect; }
$tab=" ";
if($oDPt->deptLevel%2 != 0){ $stylefont="<b>"; $stylefont2="</b>"; }
for($i=1;$i<=$oDPt->deptLevel;$i++){
$tab.=" ";
}
$nextpssend=searchnextpssend($pssend,$oDPt->deptId); $oRs9->searchHaveSendDoc($pssend,$nextpssend,$searchDoc); if($oRs9->GetRecord()==1){ $showimg="<img src=\"../picture/yes.gif\" border=\"0\" alt=\"หมายถึงหน่วยงานย่อยหรือบุคลากรผู้นั้น เคยได้รับหนังสือนี้แล้ว\">"; }
echo $showimg.$tab.$stylefont.$oDPt->deptName.$stylefont2;
echo "</td></tr>";
$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 "<tr><td> ";
echo "<input name=deptPs[".$deptId."] type=checkbox value=\"".$pssend."\"";
if($pssend==''){ echo " disabled "; }
echo ">";
$nextpssend=searchnextpssend($pssend,$oDPt->deptId);
if($nextpssend!=""){
$oRs9->searchHaveSendDoc($pssend,$nextpssend,$searchDoc);
if($oRs9->GetRecord()==1){
echo "<img src=\"../picture/yes.gif\" border=\"0\" alt=\"หมายถึงหน่วยงานย่อยหรือบุคลากรผู้นั้น เคยได้รับหนังสือนี้แล้ว\">";
}
}
$tab=" ";
if($oDPt->deptLevel%2 != 0){ $stylefont="<b>"; $stylefont2="</b>"; }
for($i=1;$i<=$oDPt->deptLevel;$i++){
$tab.=" ";
}
echo $tab.$stylefont.$oDPt->deptName.$stylefont2;
echo "</td></tr>";
$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;
}
?>
|