<?
include "./db_conn.php";
include "./include/jsonRPCClient.php";

/*
$rpcService = new jsonRPCClient("$PACKETMON_HTTP_URL/JSON-RPC");
$param = array();
$arr = $rpcService->__call("shield.server.view",$param);

$resultArr = $arr['list'];
*/  
$startDate = $_GET["startDate"] ;
$endDate = $_GET["endDate"] ;
$flag = $_GET["flag"] ;
$mail_seq = $_GET["seq"] ;
$cfno = $_GET["cfno"] ;

if ($flag == "delete" ) { 	
 	
    $chkDelete = " DELETE from T_MAIL WHERE SEQ = $mail_seq  ";
    @mysql_query($chkDelete, $connect) or die(mysql_error());  		

    $chkDelete = " DELETE from T_MAIL_ATTACHMENT WHERE MAIL_SEQ = $mail_seq  ";
    @mysql_query($chkDelete, $connect) or die(mysql_error());  		

    $chkDelete = " DELETE from checktable	 WHERE agent_code = '$cfno' ";
    @mysql_query($chkDelete, $connect) or die(mysql_error());  	    
        
    if($connect) mysql_close($connect);
    exit;
    
}

if ($flag == "delete_all" ) { 	
 	
    $chkDelete = " TRUNCATE T_MAIL  ";
    @mysql_query($chkDelete, $connect) or die(mysql_error());  		

    $chkDelete = " TRUNCATE T_MAIL_ATTACHMENT  ";
    @mysql_query($chkDelete, $connect) or die(mysql_error());  		

    $chkDelete = " TRUNCATE checktable ";
    @mysql_query($chkDelete, $connect) or die(mysql_error());  	    
        
    if($connect) mysql_close($connect);
    exit;
    
}

if ($flag == "mail_detail_view" ) { 	
	$cfNo = $_GET["cf_no"] ;

	$sql = "select * from checktable where cf_no = '$cfNo'"; 
	error_log ("mail_detail_view:" . $sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	
	$result=mysql_query($sql, $connect) or die (mysql_error());

//{"cfNo":9,"bbsId":"mailtest@xdrm.co.kr","orgId":"/usr/local/imagefilter30/var/nexgen_data/hamful.docx","menuId":"hamful.docx",
// "wrtNo":"mailtest@xdrm.co.kr","title":"message","domain":"hello mail 5","port":"7775","filterServer":"hamful.docx_dir/img1.jpg",
// "oriCtn":"키워드: 123456789육두문자,주민번호: 930311-1184127","ret":3,"ssn":1,"acn":0,"brn":0,"hpn":0,"sid":0,"cdn":0,"email":0,"xwd":0,"yuri":0,"mailto":0,"pwd":2,
// "wrtDate":1605576983000,"admEdtYn":"N","orderNum":118940,"agentCode":"6",
// "codeDno":null,"filename":"hamful.docx","wrtNoAcType":"MAILTEST@XDRM.CO.KR","admEdtYnText":"차단모드","wrtNoDocType":"MAILTEST@XDRM.CO.KR"}
?>
<?
	$count = 0;
	
	while ($data = mysql_fetch_array($result)) {
	
		if ( $count != 0 ) { echo(","); }
		$strArray = explode('/',$data[org_id]);
		$filename = end($strArray);
		error_log ("mail_view_filename:" . $filename . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
?>
{"cfNo":,"bbsId":"","orgId":"","menuId":"","wrtNo":"","title":null,"domain":"","port":"","filterServer":"","oriCtn":"","ret":,"ssn":,"acn":,"brn":,"hpn":,"sid":,"cdn":,"email":,"xwd":,"yuri":,"mailto":,"pwd":,"wrtDate":null,"admEdtYn":"","orderNum":,"agentCode":"","codeDno":null,"filename":"","wrtNoAcType":"","admEdtYnText":"차단모드","wrtNoDocType":""}		
<?
		$count++;
	}
	if($connect) mysql_close($connect);

    exit;
}

if ($flag == "mail_view" ) { 	
	$mail_id = $_GET["mail_id"] ;

	$sql = "select M.*, (select cf_no from checktable where agent_code = M.SEQ limit 1) as cfNo, (select FILENAME from T_MAIL_ATTACHMENT where MAIL_SEQ = M.SEQ limit 1) as FILENAME from T_MAIL M where M.MAIL_ID = '$mail_id'"; 
	error_log ("mail_view:" . $sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	
	$result=mysql_query($sql, $connect) or die (mysql_error());
?>
	{"list":[
<?
	$count = 0;
	
	while ($data = mysql_fetch_array($result)) {
	
		if ( $count != 0 ) { echo(","); }
?>
		{
		"boxNo":""
		,"cfNo":""
		,"wrtDate":""		

<? 
	// T_MAIL 테이블 상태 업데이트 	수신(0), //A:  승인(1),    R: 반려(2),  결재취소(3),  스캔 검사 후 검출됨(4)  => box 내의 정보를 위해서 ???.
	
	if ($data[STATUS] == 0)	$strStatus = "수신";
	if ($data[STATUS] == 1)	$strStatus = "반려";
	if ($data[STATUS] == 2)	$strStatus = "승인";
	if ($data[STATUS] == 3)	$strStatus = "결재취소";
	if ($data[SENT_STATUS] == 0)	$strSentStatus = "미 발송";
	if ($data[SENT_STATUS] == 1)	$strSentStatus = "발송대기";
	if ($data[SENT_STATUS] == 2)	$strSentStatus = "발송완료";
	if ($data[SENT_STATUS] == 3)	$strSentStatus = "발송오류";
	$fileStatus = 0;
	if (strpos($data[FILENAME], "storage") != false)	$fileStatus = 1;
?>

		,"bbsId":""		
		,"menuId":""				
		,"email":""		
		,"title":""		
		,"ret":""		
		,"oriCtn":""		
		}
<?
		$count++;
	}
	if($connect) mysql_close($connect);

?>
	]}
<?
    exit;
}

// 조회 리스트 시작

if ($startDate == $endDate)
{
	$sql = "select M.*, (select cf_no from checktable where agent_code = M.SEQ limit 1) as cfNo, (select FILENAME from T_MAIL_ATTACHMENT where MAIL_SEQ = M.SEQ limit 1) as FILENAME from T_MAIL M where (STATUS = '0' or STATUS = '1' or STATUS = '2' or STATUS = '4') and (STATUS != '5' and (SENT_STATUS = '0' or SENT_STATUS = '1' or SENT_STATUS = '2')) and M.MAIL_DATE LIKE '%$startDate%' order by MAIL_DATE DESC"; 
} else
{
	$sql = "select M.*, (select cf_no from checktable where agent_code = M.SEQ limit 1) as cfNo, (select FILENAME from T_MAIL_ATTACHMENT where MAIL_SEQ = M.SEQ limit 1) as FILENAME from T_MAIL M where (STATUS = '0' or STATUS = '1' or STATUS = '2' or STATUS = '4') and (STATUS != '5' and (SENT_STATUS = '0' or SENT_STATUS = '1' or SENT_STATUS = '2')) and M.MAIL_DATE between '$startDate' and '$endDate' order by MAIL_DATE DESC"; 
}	
//$sql = "select M.*, (select cf_no from checktable where agent_code = M.SEQ limit 1) as cfNo, (select FILENAME from T_MAIL_ATTACHMENT where MAIL_SEQ = M.SEQ limit 1) as FILENAME from T_MAIL M where STATUS = '4' and M.MAIL_DATE between '2020-07-21' and '2020-11-30' order by MAIL_DATE DESC"; 
//$sql = "select M.*, (select cf_no from checktable where agent_code = M.SEQ limit 1) as cfNo, (select FILENAME from T_MAIL_ATTACHMENT where MAIL_SEQ = M.SEQ limit 1) as FILENAME from T_MAIL M where M.MAIL_DATE between '2020-07-21' and '2020-11-30' order by MAIL_DATE DESC"; 
error_log ("mail_box-->" . $sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");

$result=mysql_query($sql, $connect) or die (mysql_error());
?>
{"list":[
<?
$count = 0;

while ($data = mysql_fetch_array($result)) {

	if ( $count != 0 ) { echo(","); }
?>
	{
	"boxNo":""
	,"cfNo":""
	,"wrtDate":""		

<? 
// T_MAIL 테이블 상태 업데이트 	수신(0), //A:  승인(1),    R: 반려(2),  결재취소(3),  스캔 검사 후 검출됨(4)  => box 내의 정보를 위해서 ???.

if ($data[STATUS] == 0)	$strStatus = "수신";
if ($data[STATUS] == 1)	$strStatus = "반려";
if ($data[STATUS] == 2)	$strStatus = "승인";
if ($data[STATUS] == 3)	$strStatus = "결재취소";
if ($data[STATUS] == 4)	$strStatus = "검출";
if ($data[STATUS] == 5)	$strStatus = "통과";
if ($data[SENT_STATUS] == 0)	$strSentStatus = "미 발송";
if ($data[SENT_STATUS] == 1)	$strSentStatus = "발송대기";
if ($data[SENT_STATUS] == 2)	$strSentStatus = "발송완료";
if ($data[SENT_STATUS] == 3)	$strSentStatus = "발송오류";
$fileStatus = 0;
if (strpos($data[FILENAME], "storage") != false)	$fileStatus = 1;
?>

	,"bbsId":""		
	,"menuId":""				
	,"email":""		
	,"title":""		
	,"ret":""		
	,"oriCtn":""		
		
	}
<?
	$count++;
}
if($connect) mysql_close($connect);

?>
]}