<!-- #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")

%>
<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">
<!--
	ExitFlg = 1;
-->
</SCRIPT>

<body onkeydown="if(ExitFlg==2)ExitFlg=3;" onBeforeUnload="window.event.returnValue = ExitMsg(ExitFlg)" bgcolor="#8D9BCC" 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 InStr(RouteType, "MailOnly") > 0 Then
		Response.Write(HtmlDesign(6))
	Else
		Response.Write(HtmlDesign(1))
	End If

	Response.Write(HttpL1(3))

	If InStr(RouteType, "MailOnly") > 0 Then
		Response.Write(HttpL2("受発信文書ウィンドウ" ,"", "", "", "", "", "", "", "", "", "", ""))
	ElseIf RouteType = "MailOnly" Then
		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_1("照会", "syokaibtn()", "再表示", "tblbtn('" & Request.ServerVariables("PATH_INFO") & "?" & Request.ServerVariables("QUERY_STRING") & "')", "", "", "", "", "", ""))

	If PageType = "メール作成" Then
		Response.Write(HttpL3_2("受信文書", "tblbtn( 'fn_jyuhasshinbunsyo.asp?PageType=受信文書&RouteType=" & RouteType & "')", "発信文書", "tblbtn( 'fn_jyuhasshinbunsyo.asp?PageType=発信文書&RouteType=" & RouteType & "')", "メール作成", "", "受信メール", "tblbtn( 'fn_mailsakusei_ichiran.asp?PageType=受信メール&RouteType=" & RouteType & "')" ,"送信メール", "tblbtn( 'fn_mailsakusei_ichiran.asp?PageType=送信メール&RouteType=" & RouteType & "')"))
	ElseIf PageType = "受信メール" Then
	
	
		'Response.Write(HttpL3_2("受信文書", "tblbtn( 'fn_jyuhasshinbunsyo.asp?PageType=受信文書&RouteType=" & RouteType & "')", "発信文書", "tblbtn( 'fn_jyuhasshinbunsyo.asp?PageType=発信文書&RouteType=" & RouteType & "')", "メール作成", "tblbtn( 'fn_mailsakusei.asp?RouteType=" & RouteType & "')", "受信メール", "" ,"送信メール", "tblbtn( 'fn_mailsakusei_ichiran.asp?PageType=送信メール&RouteType=" & RouteType & "')"))
		
		Response.Write(HttpL3_3("受信文書", "tblbtn( 'fn_jyuhasshinbunsyo.asp?PageType=受信文書&RouteType=" & RouteType & "')", "発信文書", "tblbtn( 'fn_jyuhasshinbunsyo.asp?PageType=発信文書&RouteType=" & RouteType & "')", "", "", "受信メール", "" ,"送信メール", "tblbtn( 'fn_mailsakusei_ichiran.asp?PageType=送信メール&RouteType=" & RouteType & "')"))
		
	Else
	
	
		'Response.Write(HttpL3_2("受信文書", "tblbtn( 'fn_jyuhasshinbunsyo.asp?PageType=受信文書&RouteType=" & RouteType & "')", "発信文書", "tblbtn( 'fn_jyuhasshinbunsyo.asp?PageType=発信文書&RouteType=" & RouteType & "')", "メール作成", "tblbtn( 'fn_mailsakusei.asp?RouteType=" & RouteType & "')", "受信メール", "tblbtn( 'fn_mailsakusei_ichiran.asp?PageType=受信メール&RouteType=" & RouteType & "')" ,"送信メール", ""))
		
		Response.Write(HttpL3_3("受信文書", "tblbtn( 'fn_jyuhasshinbunsyo.asp?PageType=受信文書&RouteType=" & RouteType & "')", "発信文書", "tblbtn( 'fn_jyuhasshinbunsyo.asp?PageType=発信文書&RouteType=" & RouteType & "')", "", "", "受信メール", "tblbtn( 'fn_mailsakusei_ichiran.asp?PageType=受信メール&RouteType=" & RouteType & "')" ,"送信メール", ""))


	End If

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

<div id="L0" style="position: absolute; visibility: hidden; left: 0px; top: -2000px;">
<TABLE BORDER="0" WIDTH="680" HEIGHT="100%" 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;table-layout:fixed">
							<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="250" 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;table-layout:fixed">
							<%
								Dim Query
								Dim Content
								Dim ii, jj
								ii = 0


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


								If PageType = "受信メール" Then
									Query = "exec SPN学生メール受信一覧 '" & GB_SystemCD & "','" & Session("UserID") & "'"
								ElseIf PageType = "送信メール" Then
									Query = "exec SPN学生メール送信一覧 '" & GB_SystemCD & "','" & Session("UserID") & "'"
								End If

'Response.Write("Query:" & Query)

								Set Content = OpenQuery(Query)

								Do While Not(Content.BOF Or Content.EOF)

										Dim MailCD, Sakuseibi, TorihikisakiCD, Kenmai, Naiyo, KaifuFlg, GakuseiBango, SakujyoFlg, Kaisyamei, HyojiyoAtesakiMei

										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"))
												HyojiyoAtesakiMei = ConvKaisyaMeisyo(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))
													HyojiyoAtesakiMei = HyojiyoAtesakiMei + ConvKaisyaMeisyo(tmps(i))
												Next
											End If

											If PageType = "受信メール" Then
												Response.Write("<TR ALIGN=""CENTER"" STYLE=""cursor: hand;"" onClick=""celsel(" & ii & ",'" & TorihikisakiCD & "," & MailCD & "')"" onDblClick=""syokaibtn()"">" & vbCrLf)
											Else
												Response.Write("<TR ALIGN=""CENTER"" STYLE=""cursor: hand;"" onClick=""celsel(" & ii & ",'" & TorihikisakiCD & "," & MailCD & "')"" onDblClick=""syokaibtn()"">" & 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=""250""  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"">")
											'	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)
											
											
											
											
											Response.Write("</TR>")
											ii = ii + 1
										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=""250"" 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=""LEFT"">")
									'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>

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