<?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;
	}
?>