<!-- #include virtual="/sj4web/include.asp" -->

<%
'<!--
'################################################
'	 名称	:メール一覧表示
'	 作成日:2002/9/18
'	 作成者:山崎
'	 目的 :メールの一覧表示をする。
'	 概要	:
'		<<表示>>
'	・メールの一覧表示
'
'################################################
'-->
'
%>

<%
main()
Sub main()
	If Not(SessionCheck()) Then
		Exit Sub
	End If

	Dim PageType
	PageType = Request("PageType")
	Dim RouteType
	RouteType = Request("RouteType")
	Dim TorihikisakiCD
	Dim MailCD
	TorihikisakiCD = Request("TorihikisakiCD")
	MailCD = Request("MailCD")

%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=shift_jis">
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="Cache-Control" content="no-cache">
<meta http-equiv="Expires" content="-1">
<link href="/sj4web/binx/sj3web.css" rel="stylesheet" type="text/css">
<title><% = AppTitle %></title>
<script language="JScript" src="/sj4web/include.js"></script>
<script language="JScript" src="/sj4web/includesj.js"></script>
<script language="JScript.Encode" src="/sj4web/include_enc.js"></script>
<script language="JScript.Encode" src="/sj4web/includesj_enc.js"></script>
</head>
<SCRIPT LANGUAGE="JavaScript">
mailblk();
<!--
	ExitFlg = 1;
-->
</SCRIPT>

<body onkeydown="if(ExitFlg==2)ExitFlg=3;" onBeforeUnload="window.event.returnValue = ExitMsg(ExitFlg)" bgcolor="#5C70B6" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form OnKeyDown="FormKeyDown(this)"	 name="form1" method="POST" action="fn_mailsakusei_ichiran_bin.asp">
<input type="hidden" name="RouteType" value="<% = RouteType %>">
<input type="hidden" name="PageType" value="<% = PageType %>">

<%
	If RouteType = "MailOnly" Then
		Response.Write(HtmlDesign(6))
	Else
		Response.Write(HtmlDesign(1))
	End If

	Response.Write(HttpL1(3))

	If RouteType = "MailOnly" Then
'		Response.Write(HttpL2("メールウィンドウ" ,"", "", "", "", "", "" , "", "", "", "", ""))
		Response.Write(HttpL2("受発信文書ウィンドウ" ,"", "", "", "", "", "", "", "", "", "", ""))
	ElseIf GB_Gyosyu <> "B" Then
		Response.Write(HttpL2("会社選択" ,"tblbtn( '/sj4web/user/bk/')", GB_GyosyuMeisyo, "tblbtn( '/sj4web/user/bk/menu_" & GB_Gyosyu & ".asp')", "社長室・総務部", "tblbtn( '/sj4web/user/bk/menu_s4.asp')", "受発信文書", "tblbtn( '/sj4web/user/bk/jyuhasshinbunsyo/')", "メール" , "", "", ""))
	Else
		Response.Write(HttpL2("会社選択" ,"tblbtn( '/sj4web/user/bk/')", ConvKubunMeisyo("業種CD", GB_Gyosyu) , "tblbtn( '/sj4web/user/bk/menu_" & GB_Gyosyu & ".asp')", "受発信文書", "tblbtn( '/sj4web/user/bk/jyuhasshinbunsyo/')", "メール", "", "", "", "", ""))
	End If


	Response.Write(HttpL3("","" ,"", "" ,"", "", "", "", "", "", "", "", "", "", "", ""))

	Response.Write(HttpL3_1("照会","syokaibtn();", "削除", "SubmitCheck()", "", "" ,"", "", "", ""))

	Response.Write(HttpL3_2("メール作成", "tblbtn( '/sj4web/user/bk/jyuhasshinbunsyo/fn_mailsakusei.asp?RouteType=" & RouteType & "')", "受信メール", "tblbtn( '/sj4web/user/bk/jyuhasshinbunsyo/fn_mailsakusei_ichiran.asp?PageType=受信メール&RouteType=" & RouteType & "')" ,"送信メール", "tblbtn( '/sj4web/user/bk/jyuhasshinbunsyo/fn_mailsakusei_ichiran.asp?PageType=送信メール&RouteType=" & RouteType & "')",	"", "", "", ""))

	Response.Write(HttpL4(PageType , ""))
%>

<div id="L0" style="position: absolute; visibility: hidden; left: 0px; top: -2000px;">
<TABLE BORDER="0" WIDTH="680" HEIGHT="300" CELLSPACING="5" CELLPADDING="15" BGCOLOR="#FFFFFF" STYLE="BORDER:1px solid #000000">
	<TR>
		<TD ALIGN="CENTER" BACKGROUND="/sj4web/images/window_bk.gif">
			<TABLE WIDTH="600" BORDER="0" CELLSPACING="0" CELLPADDING="0" HEIGHT="100%">
				<TR>
					<TD HEIGHT="20" VALIGN="BOTTOM" WIDTH="600">
						<TABLE WIDTH="600" HEIGHT="20" BORDER="1" CELLPADDING="0" CELLSPACING="0" bordercolor="#5C70B6" background="/sj4web/images/window_bkd.gif" CLASS="tx1416" STYLE="border-collapse: collapse">
							<TR ALIGN="CENTER">
								<TD WIDTH="20" HEIGHT="20"> </TD>
								<TD WIDTH="100" HEIGHT="20"><%
									If PageType = "受信メール" Then
										Response.Write("受信日")
									ElseIf PageType = "送信メール" Then
										Response.Write("発信日")
									End If %></TD>
								<TD WIDTH="190" HEIGHT="20"><%
									If PageType = "受信メール" Then
										Response.Write("送信者")
									ElseIf PageType = "送信メール" Then
										Response.Write("受信者")
									End If %></TD>
								<TD HEIGHT="20">件名</TD>
								<% If PageType = "受信メール" Then %>
								<TD WIDTH="40" HEIGHT="20">開封</TD>
								<% End If %>
								<TD WIDTH="40" HEIGHT="20">削除</TD>
							</TR>
						</TABLE>
					</TD>
				</TR>
				<TR>
					<TD VALIGN="TOP">
						<DIV ID="Layer1" STYLE="position:relative; left:0px; top:0px; width:620px; height:100%; z-index:1; border: 1px none #000000; overflow: auto;">
							<TABLE ID="SyoukaiList" WIDTH="600" BORDER="1" CELLSPACING="0" CELLPADDING="0" bordercolor="#999999" BGCOLOR="#FFFFFF" STYLE="border-collapse: collapse">
<%
								Dim Sakuseibi, Kenmai, Naiyo, KaifuFlg, GakuseiBango, SakujyoFlg, Kaisyamei, HyojiyoAtesakiMei
								Dim Query
								Dim Content
								Dim ii, jj, iiDef
								ii = 0
								iiDef = -1

								If PageType = "受信メール" Then
									Query = "exec SPNメール受信一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "'"
								ElseIf PageType = "送信メール" Then
									Query = "exec SPNメール送信一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "'"
								End If

								Set Content = OpenQuery(Query)
								Do While Not(Content.BOF Or Content.EOF)


									If MailCD = Content.Fields("メールCD") Then
										iiDef = ii
									End IF
									
									MailCD = Content.Fields("メールCD")
									Sakuseibi = Content.Fields("作成日")
									TorihikisakiCD = Content.Fields("会社CD")
									Kenmai = Content.Fields("件名")
									Naiyo = Content.Fields("内容")
									KaifuFlg = Content.Fields("開封フラグ")
									GakuseiBango = Content.Fields("学生番号")
									SakujyoFlg = Content.Fields("削除フラグ")

									If SakujyoFlg = 0 Then
										HyojiyoAtesakiMei = ""
										If PageType = "受信メール" Then
											HyojiyoAtesakiMei = ConvKaisyaRyakuMeisyo(Content.Fields("作成会社CD"))
										ElseIf PageType = "送信メール" Then

											Dim tmps, i
											tmps = split(Content.Fields("表示用宛先CD"), ",")

											For i = 0 To UBound(tmps)
												If HyojiyoAtesakiMei <> "" Then
													HyojiyoAtesakiMei = HyojiyoAtesakiMei + ","
												End If
												If i mod 5 = 0 And i <> 0 Then
													HyojiyoAtesakiMei = HyojiyoAtesakiMei + ""
												End If
												HyojiyoAtesakiMei = HyojiyoAtesakiMei + ConvKaisyaRyakuMeisyo(tmps(i))
											Next
										End If

										If PageType = "受信メール" Then
											Response.Write("<TR ALIGN=""CENTER"" STYLE=""cursor: hand;"" onClick=""celsel(" & ii & ",'" & TorihikisakiCD & "," & MailCD & "')"" CLASS=""tx1618"">" & vbCrLf)
										Else
											Response.Write("<TR ALIGN=""CENTER"" STYLE=""cursor: hand;"" onClick=""celsel(" & ii & ",'," & MailCD & "')"" CLASS=""tx1618"">" & vbCrLf)
										End If

										Response.Write("<TD WIDTH=""20"" HEIGHT=""20"" ALIGN=""LEFT""><br></TD>" & vbCrLf)
										Response.Write("<TD WIDTH=""100"" HEIGHT=""20"" ALIGN=""LEFT"">" & Sakuseibi & "</TD>" & vbCrLf)
										Response.Write("<TD WIDTH=""190"" HEIGHT=""20"" ALIGN=""LEFT"">")
										Response.Write(Left(HyojiyoAtesakiMei, 16))
										If Len(HyojiyoAtesakiMei) > 16 Then 
											Response.Write("...")
										End If
										Response.Write("</TD>" & vbCrLf)
										Response.Write("<TD HEIGHT=""20"" ALIGN=""LEFT"">" & Kenmai & "</TD>" & vbCrLf)
										If PageType = "受信メール" Then
											Response.Write("<TD WIDTH=""40"" HEIGHT=""20"" ALIGN=""center"" CLASS=""tx1416"">")
											If KaifuFlg = 0 Then
												Response.Write("未")
											Else
												Response.Write("済")
											End If
											Response.Write("</TD>" & vbCrLf)
										End If
										Response.Write("<TD WIDTH=""40"" HEIGHT=""20"" ALIGN=""center"">")
										Response.Write("<input type='checkbox' name='SakujyoMailCD' value='" & MailCD & "' onClick='event.cancelBubble = true;'>")
										Response.Write("</TD>" & vbCrLf)
										ii = ii + 1
										Response.Write("</TR>")
									End If
									Content.MoveNext
								Loop

								For jj = ii To 15
									Response.Write("<TR ALIGN=""CENTER"">" & vbCrLf)
									Response.Write("<TD WIDTH=""20"" HEIGHT=""20""></TD>" & vbCrLf)
									Response.Write("<TD WIDTH=""100"" HEIGHT=""20""></TD>" & vbCrLf)
									Response.Write("<TD WIDTH=""190"" HEIGHT=""20""></TD>" & vbCrLf)
									Response.Write("<TD HEIGHT=""20""></TD>" & vbCrLf)
									If PageType = "受信メール" Then
										Response.Write("<TD WIDTH=""40"" HEIGHT=""20""></TD>" & vbCrLf)
									End If
									Response.Write("<TD WIDTH=""40"" HEIGHT=""20"" ALIGN=""center"">")
									Response.Write("</TD>" & vbCrLf)

									Response.Write("</TR>")
								Next
%>
							</TABLE>
						</DIV>
					</TD>
				</TR>
				<TR>
					<TD HEIGHT="13" VALIGN="BOTTOM" WIDTH="600">
					</TD>
				</TR>
			</TABLE>
		</TD>
	</TR>
</TABLE>
</div>
</form>
</body>

<SCRIPT LANGUAGE="JavaScript">
<!--
function SubmitCheck()
{
	if(typeof(form1.SakujyoMailCD) != "object")
	{
		alert("削除するメールのチェックボックスにチェックを入れてください");
		return;
	}
	if(typeof(form1.SakujyoMailCD.length) != "number")
	{
		if(!form1.SakujyoMailCD.checked)
		{
			alert("削除するメールのチェックボックスにチェックを入れてください");
			return;
		}
	}
	else
	{
		var bExist = 0;
		for(ii = 0; ii < form1.SakujyoMailCD.length; ii++)
		{
			if(form1.SakujyoMailCD(ii).checked)bExist = 1;
		}
		if(bExist == 0)
		{
			alert("削除するメールのチェックボックスにチェックを入れてください");
			return;
		}
	}

	if(confirm("この操作は元に戻す事が出来ません。\r\n削除をしてもよろしいですか?"))
	{
		SubmitReal(form1);
	}

	return true;
}



var lsURL="#"
function syokaibtn()
{

	if(lsURL == "#")
	{
		alert("選択されていません");
	}
	else
	{
		tblbtn(lsURL);
	}
}

//TRselect & URLset
function celsel(rw,lsParam)
{
	for (k=0; k<document.all['SyoukaiList'].rows.length; k++)
	{
		document.all['SyoukaiList'].rows[k].style.backgroundColor ="";
	}										//セル色クリア
	document.all['SyoukaiList'].rows[rw].style.backgroundColor ="#ffcdde";		//選択行色変更

	var lsParamArray;
	lsParamArray = lsParam.split(",");
	lsURL = "fn_mailsakusei_view.asp?RouteType=<% = RouteType %>&PageType=<% = PageType %>&TorihikisakiCD=" + lsParamArray[0] + "&MailCD=" + lsParamArray[1]

}//-->
</SCRIPT>

<SCRIPT FOR="window" EVENT="onload" LANGUAGE="JavaScript">
<%
' 2006.12.08 演習一覧表示の機能を追加&モディファイ(伝票番号を引数に追加)
%>
<% If iiDef <> -1 Then %>
	celsel(<% = iiDef %>, "fn_mailsakusei_ichiran.asp?RouteType=<% = RouteType %>&PageType=<% = PageType %>&TorihikisakiCD=<% = TorihikisakiCD %>&MailCD=<% = MailCD %>")
	Layer1.scrollTop = <% = (iiDef - 5) * 20 %>;
<% End If %>
 <% = iiDef %>
</script>

<% = HtmlFooter %> 
</html>
<%
End Sub
%>