<?php 
//*****************************************************************************
//* 
//* プログラム名：Webメール
//* プログラムID：WML030.php
//* 機能				：送信済み一覧画面
//* 作成者			：
//* 
//*****************************************************************************
header('Content-Type: text/html; charset=EUC-JP');
include("include/session_start.inc");
include("include/SessionChk.inc");
include('./include/smarty.conf');

//**** メニュー ****//
include("inc/header.inc");
include("menu_opacity.php");

//*** JavaScript ***//
include("inc/WML000.inc");
include("inc/WML001.inc");

//**** DB接続 ****//
$strDBinc="./include/dbcon.inc";
include($strDBinc);

//曜日配列
$youbi=array("日","月","火","水","木","金","土");

$syain_cd = $PHP_SYAIN_CD;
$strSQLseq="Select * from mail_TBL Where syain_cd='$syain_cd'";

//メール情報取得
$objRecseq = pg_exec($strSQLseq);
if($objRecseq==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}
if (pg_numrows($objRecseq) > 0){
		$objmail = pg_fetch_object($objRecseq, 0);
		$strMailAdd=$objmail->mail_add;
		$intSrvadd=$objmail->pop3_add;
		$strUserName=$objmail->mail_name;
		$strPASSWORD=$objmail->mail_pass;
		
		// 登録サーバー名取得
		$strSQLseq="Select * from mailAdmin_TBL Where srv_id=".$intSrvadd." and srv_flg=2";
		$objRecseq = pg_exec($strSQLseq);
		if($objRecseq==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
		}
		if (pg_numrows($objRecseq) > 0){
			 $objmail = pg_fetch_object($objRecseq, 0);
			 $strSrvName=$objmail->srv_add;
		}
}
 
$strMailAdd = $strMailAdd;
$strSQLseq="SELECT * FROM mail_send_tbl WHERE syain_cd='".$syain_cd."' ORDER BY send_date DESC";
$objRecseq = pg_exec($strSQLseq);
if($objRecseq==false){
	 echo("SQL実行に失敗しました(SELECT)");
	 exit;
}
$total_num=pg_numrows($objRecseq);


//文字化け対策
if (function_exists("mb_internal_encoding")) {
		mb_internal_encoding("SJIS");
}

if ($start_from==""){
		$start_from=0;
}
$strButton="";
if ($start_from!=0) {
		$intCnt=$start_from-10;
		$strButton .= '<input type="button" value="前の10件" onclick="WML030_Page('.$intCnt.');">';
}
$strButton .= '<input type="button" value="先頭へ戻る" onclick="WML030_Top();">';
if ($total_num > $start_from+10) {
		$intCnt=$start_from+10;
		$strButton .= '<input type="button" value="次の10件" onclick="WML030_Page('.$intCnt.');">';
}

$intSet=0;
for ($num=$start_from; $num < pg_numrows($objRecseq); $num++){
		if ($intSet >= 10) break;
		$objmail = pg_fetch_object($objRecseq, ($num));

		//添付ファイル
		if ($objmail->filename1!="" || $objmail->filename2!="" || $objmail->filename3!=""){
				$temp_flg[$intSet]=1;
		}else{
				$temp_flg[$intSet]=0;
		}

		//件名
		if ($objmail->subject!="") {
				$subject[$intSet] = decode_mimeheader($objmail->subject, 1);
				if($subject[$intSet]==""){
						$subject[$intSet] ='(no subject)';
				}
				$subject[$intSet] = htmlspecialchars($subject[$intSet], ENT_QUOTES);
		} else {
				$subject[$intSet] =  '(no subject)';
		}

		//キー
		$send_key[$intSet] = $objmail->send_date;


		//宛先
		if ($objmail->mail_to!="") {
				$strMailto = split(",",$objmail->mail_to);
				for($ii=0;$ii<count($strMailto);$ii++){
					if (trim(get_name($strMailto[$ii]), 1)==" "){
							$mail_to[$intSet] .= htmlspecialchars(decode_mimeheader($strMailto[$ii], 1), ENT_QUOTES);
					}else{
							$mail_to[$intSet] .=  htmlspecialchars(decode_mimeheader(get_name($strMailto[$ii]), 1), ENT_QUOTES);
					}
					if($ii<count($strMailto)-1){
						$mail_to[$intSet] .= ",";
					}
				}
		}else{
				$mail_to[$intSet] = '(Unknown)';
		}

		//送信日付
		if ($objmail->send_date!="") {
				$str_year=substr($objmail->send_date,0,4);
				$str_mon=substr($objmail->send_date,4,2);
				$str_day=substr($objmail->send_date,6,2);
				$str_hour=substr($objmail->send_date,8,2);
				$str_min=substr($objmail->send_date,10,2);
				$intYoubi=date("w", mktime (0,0,0,$str_mon,$str_day,$str_year));
				$strDate=$str_year."/".$str_mon."/".$str_day."(".$youbi[$intYoubi].")"." ".$str_hour.":".$str_min;
				$send_date[$intSet] =  $strDate;
		} else {
				$send_date[$intSet] =  '(Unknown)';
		}
		$Dt_Seq[$intSet]=$intSet;
		$intSet=$intSet+1;
} 

$o_smarty->assign('Dt_Seq',$Dt_Seq);

$o_smarty->assign('temp_flg',$temp_flg);
$o_smarty->assign('subject',$subject);
$o_smarty->assign('send_key',$send_key);
$o_smarty->assign('mail_to',$mail_to);
$o_smarty->assign('send_date',$send_date);

$o_smarty->assign('strButton',$strButton);
$o_smarty->assign('total_num',$total_num);

$o_smarty->assign('PHP_TITLE_NAME',$PHP_TITLE_NAME[18]);
$o_smarty->display('WML030.tpl');

?>