include "./db_conn.php";
$boxNo = $_GET["boxNo"] ;
error_log ("search_boxno:" . $boxNo . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
?>
$sql = "select FILENAME from T_MAIL_ATTACHMENT where MAIL_SEQ = '" . $boxNo . "' ";
error_log ("attachment_sql:" . $sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
$result=mysql_query($sql, $connect) or die (mysql_error());
$count = 0;
while ($data = mysql_fetch_array($result))
{
error_log ("##_search_files:" . $data[0] . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
// /tmp/l7mail/storage/filter_box/file/L7Mail-03-300607086-1609031329/hamful.docx
$files_explode = explode( '/', $data[0] );
$files_explode[6];
$files_explode[7];
$files = $files_explode[6] . "/" . $files_explode[7];
$count++;
}
if ($count < 0)
{
$files = "";
}
$sql_mail_content = "select EMCONTENTS from T_MAIL_SEARCH where EMSEQ = '" . $boxNo . "' ";
error_log ("search_sql_mail_content:" . $sql_mail_content . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
$result=mysql_query($sql_mail_content, $connect) or die (mysql_error());
$mail_search_count = 0;
while ($data = mysql_fetch_array($result))
{
$mail_search_count++;
if ($mail_search_count == 1)
{
$mail_body = $data[EMCONTENTS];
}
if ($mail_search_count == 2)
{
//str_replace(array('\r\n', '\n\r', '\n', '\r'), '
', $description);
//$mail_ocr_output = str_replace(array('\r\n', '\n\r', '\n', '\r'), '
', $data[EMCONTENTS]);
$mail_ocr_output = nl2br($data[EMCONTENTS]);
$mail_ocr_output = str_replace('\r\n', '
', $mail_ocr_output);
$mail_ocr_output = str_replace('..IMAGE_INDEX:', ' ', $mail_ocr_output);
$mail_ocr_output = str_replace("/usr/local/imagefilter30/var/nexgen_data/", "IMAGE: ", $mail_ocr_output);
}
}
$sql_mail_info = "select M.*, (select ADDR from T_MAIL_ADDR where MAIL_SEQ = M.SEQ limit 1) as RECEIVER from T_MAIL M where M.SEQ = '" . $boxNo . "' ";
error_log ("search_sql_mail_info:" . $sql_mail_info . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
$result=mysql_query($sql_mail_info, $connect) or die (mysql_error());
while ($data = mysql_fetch_array($result))
{
error_log ("search_data_plain:" . json_encode($mail_body) . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
error_log ("search_data_content:" . $mail_ocr_output . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
?>
{
"sender":""
,"receiver":""
,"subject":""
,"html":null
,"ocr":null
,"files":""
}
}
if($connect) mysql_close($connect);
?>