<?php

include_once("../../class/clsConnection.php");
include_once("../../class/clsDB.php");
include_once "../global.php";
include_once "../class/clsSendReceive.php";



$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);
$oTsr = new sendreceive($oC);
$oTsr2 = new sendreceive($oC);

    if($fn=='r1'){
    
        $tsr_DocSubject=str_replace ('_',' ',$tsr_DocSubject);
        $tsr_DocNo=str_replace ('_',' ',$tsr_DocNo);
        $tsr_DocFrom=str_replace ('_',' ',$tsr_DocFrom);
        $tsr_DocTo=str_replace ('_',' ',$tsr_DocTo);
        $tsr_DocRef=str_replace ('_',' ',$tsr_DocRef);
        $tsr_DocOther=str_replace ('_',' ',$tsr_DocOther);
        $tsr_DocShortDesc=str_replace ('_',' ',$tsr_DocShortDesc);
        $tsr_docname=str_replace ('_',' ',$tsr_docname);    
    
    
        $oTsr2->SearchBytsr_id_send_tsr_fr_node($tsr_id_send,$tsr_fr_node);
        if($oTsr2->GetRecord()==0){
            $oTsr->AddNew();
            $oTsr->tsr_fr_node=$tsr_fr_node;
            $oTsr->tsr_fr_node_date=$tsr_fr_node_date;
            $oTsr->tsr_to_node=$tsr_to_node;
            $oTsr->tsr_to_node_date=getNowDateTh()." ".date('H:i:s');
            $oTsr->tsr_docid=$tsr_docid;
            $oTsr->tsr_doc_url=$tsr_doc_url;
            $oTsr->tsr_doc_chksum=$tsr_doc_chksum;
            $oTsr->tsr_status='r1';
            $oTsr->tsr_id_send=$tsr_id_send;
            $oTsr->tsr_docgroup=$tsr_docgroup;
            $oTsr->tsr_DrsID=$tsr_DrsID;
            $oTsr->tsr_DocSubject=$tsr_DocSubject;
            $oTsr->tsr_DocNo=$tsr_DocNo;
            $oTsr->tsr_DocDate=$tsr_DocDate;
            $oTsr->tsr_DocFrom=$tsr_DocFrom;
            $oTsr->tsr_DocTo=$tsr_DocTo;
            $oTsr->tsr_DocRef=$tsr_DocRef;
            $oTsr->tsr_DocOther=$tsr_DocOther;
            $oTsr->tsr_DslID=$tsr_DslID;
            $oTsr->tsr_DclID=$tsr_DclID;
            $oTsr->tsr_DocShortDesc=$tsr_DocShortDesc;
            $oTsr->tsr_PtID=$tsr_PtID;
            $oTsr->tsr_DtID=$tsr_DtID;
            $oTsr->tsr_docname=$tsr_docname;
            $oTsr->tsr_DrsDocDueDate=$tsr_DrsDocDueDate;
            $oTsr->tsr_statusDocAtt=$tsr_statusDocAtt;
            $oTsr->Save();
        }else{
            $oTsr->Edit();
            $oTsr->tsr_fr_node=$tsr_fr_node;
            $oTsr->tsr_fr_node_date=$tsr_fr_node_date;
            $oTsr->tsr_to_node=$tsr_to_node;
            $oTsr->tsr_to_node_date=$oTsr->tsr_to_node_date;
            $oTsr->tsr_docid=$tsr_docid;
            $oTsr->tsr_doc_url=$tsr_doc_url;
            $oTsr->tsr_doc_chksum=$tsr_doc_chksum;
            $oTsr->tsr_status=$oTsr->tsr_status;
            $oTsr->tsr_id_send=$tsr_id_send;
            $oTsr->tsr_docgroup=$tsr_docgroup;
            $oTsr->tsr_DrsID=$tsr_DrsID;
            $oTsr->tsr_DocSubject=$tsr_DocSubject;
            $oTsr->tsr_DocNo=$tsr_DocNo;
            $oTsr->tsr_DocDate=$tsr_DocDate;
            $oTsr->tsr_DocFrom=$tsr_DocFrom;
            $oTsr->tsr_DocTo=$tsr_DocTo;
            $oTsr->tsr_DocRef=$tsr_DocRef;
            $oTsr->tsr_DocOther=$tsr_DocOther;
            $oTsr->tsr_DslID=$tsr_DslID;
            $oTsr->tsr_DclID=$tsr_DclID;
            $oTsr->tsr_DocShortDesc=$tsr_DocShortDesc;
            $oTsr->tsr_PtID=$tsr_PtID;
            $oTsr->tsr_DtID=$tsr_DtID;
            $oTsr->tsr_docname=$tsr_docname;
            $oTsr->tsr_DrsDocDueDate=$tsr_DrsDocDueDate;
            $oTsr->tsr_statusDocAtt=$tsr_statusDocAtt;
            $oTsr->Save();        
        }
        echo 'mr';
    }
    
    if($fn=='r4'){
        $oTsr->SearchBytsr_id_send($tsr_id_send);
        $oTsr->GetRecord();                    
        $oTsr->Edit();
        $oTsr->tsr_status='r4';
        $oTsr->Save();
    }
    
    if($fn=='checkr3r4'){
        $oTsr->SearchBytsr_id_send_tsr_fr_node($tsr_id_send,$tsr_fr_node);
        $oTsr->GetRecord();
        echo $oTsr->tsr_status;    
    }
    function getNowDateTh() {
        $yy = date('Y')+543;
        $mm = date('m');
        $dd = date('d');
        return $yy.'-'.$mm.'-'.$dd;
    }
?>