<?
	include "./db_conn.php";

	$searchData = $_GET["searchData"] ;

	$sql = "select EMSEQ from T_MAIL_SEARCH where EMCONTENTS LIKE '%$searchData%' order by EMSEQ DESC"; 
	error_log ("search_keyword:" . $searchData . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("##_search_keyword_sql:" . $sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	
	$search_result=mysql_query($sql, $connect) or die (mysql_error());

			
?>
{"list":[
<?
// 1. elasticsearch 안에 boxNo 가 있다 (mail SEQ)
// 2. boxNo 값은 checktable 의 agent_code 값과 일치한다.
// 3. cf_no 값도 있어야 한다.

	$count = 0;
	while ($search_data = mysql_fetch_array($search_result)) {

		$mail_seq = $search_data[0];	
		$sql = "select M.*, (select cf_no from checktable where agent_code = M.SEQ limit 1) as cfNo, (select ADDR from T_MAIL_ADDR where MAIL_SEQ = M.SEQ limit 1) as RECEIVER, (select FILENAME from T_MAIL_ATTACHMENT where MAIL_SEQ = M.SEQ limit 1) as FILENAME from T_MAIL M where M.SEQ = '" . $mail_seq . "' "; 
		error_log ("search_sql:" . $sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
		$result=mysql_query($sql, $connect) or die (mysql_error());
		while ($data = mysql_fetch_array($result)) 
		{
			if ( $count != 0) 
			{ echo(","); }
			error_log ("#########_cfNo:" . $data[cfNo] . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
?>
			{
			"boxNo":""
			,"cfNo":""
			,"wrtDate":""		
<? 
			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[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":""		
				
			}
<?
			// /usr/local/imagefilter30/var/nexgen_mail 아래 파일은 있으나 T_MAIL 테이블 삭제하면 json 결과 값이 잘 못나오고
			// 없는 것으로 간주하기 위해 여기서 count 를 증가함. 아래 count++ 를 주석처리 함. 

			// 검출이 되어야 증가
			$count++;
		}
	}
	
	if($connect) mysql_close($connect);
?>
]}