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

<%
'<!--
'################################################
'	 名称	:受発信文書
'	 作成日:2002/11/05
'	 作成者:山崎
'	 目的 :受発信文書の一覧を表示する
'	 概要	:
'################################################
'-->
'
%>

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

	Dim PageType, RouteType, UserID
	PageType = Request("PageType")
	RouteType = Request("RouteType")
	
	
	UserID = Request("UserID")
	if UserID <> "" then
		Session("UserID") = UserID
	end if
	
	Dim ShowDel
	ShowDel = Request("ShowDel")

'Response.Write("UserID:" & UserID & "<br>")
'Response.Write("EnshuCD:" & EnshuCD & "<br>")
'Response.Write("GB_GakuseiNo:" & GB_GakuseiNo & "<br>")
'Response.Write("UserID:" & Session("UserID") & "<br>")
'Response.Write("PageType:" & PageType & "<br>")
'Response.Write("RouteType:" & RouteType & "<br>")


%>
<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_jyuhasshinbunsyo_bin.asp">
<input type="hidden" name="SendValue" value="">
<input type="hidden" name="PageType" value="<% = PageType %>">
<input type="hidden" name="RouteType" value="<% = RouteType%>">



<%
	If InStr(RouteType, "MailOnly") > 0 Then
		Response.Write(HtmlDesign(6))
	ElseIf InStr(RouteType, "ViewOnly") > 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 InStr(RouteType, "ViewOnly") > 0 And InStr(RouteType, "RMail") > 0 Then
		Response.Write(HttpL2("照会・集計ウィンドウ" ,"tblbtn( '/sj4web/user/bk/menu_s_viewonly.asp')", "受発信文書", "", "受信文書", "", "", "", "", "", "", ""))
	ElseIf InStr(RouteType, "ViewOnly") > 0 And InStr(RouteType, "SMail") > 0	Then
		Response.Write(HttpL2("照会・集計ウィンドウ" ,"tblbtn( '/sj4web/user/bk/menu_s_viewonly.asp')", "受発信文書", "", "発信文書", "", "", "", "", "", "", ""))
	ElseIf InStr(RouteType, "ViewOnly") > 0 Then
		Response.Write(HttpL2("照会・集計ウィンドウ" ,"tblbtn( '/sj4web/user/bk/menu_s_viewonly.asp')", "受発信文書", "", "", "", PageType, "", "", "", "", ""))
	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/')", PageType	, "", "", ""))
	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/')", PageType, "", "", "", "", ""))
	End If

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

	If InStr(RouteType, "ViewOnly") > 0 Or InStr(RouteType, "MailOnly") > 0 Then
		Response.Write(HttpL3_1("照会", "syokaibtn()", "再表示", "tblbtn('" & Request.ServerVariables("PATH_INFO") & "?" & Request.ServerVariables("QUERY_STRING") & "')", "", "", "", "", "", ""))
	Else
		Response.Write(HttpL3_1("照会", "syokaibtn()", "削除", "SubmitCheck()", "再表示", "tblbtn('" & Request.ServerVariables("PATH_INFO") & "?" & Request.ServerVariables("QUERY_STRING") & "')", "", "", "", ""))
	End If



	If InStr(RouteType, "MailOnly") > 0 Then

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


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

		End If

	Else

		If PageType = "発信文書" Then
			Response.Write(HttpL3_2("", "", "", "", "", "", "", "", "", ""))
		ElseIf ShowDel = "1" Then
			Response.Write(HttpL3_2("削除済みを非表示", "tblbtn( 'fn_jyuhasshinbunsyo.asp?PageType=" & PageType & "&RouteType=" & RouteType & "')", "", "", "", "", "", "", "", ""))
		Else
			Response.Write(HttpL3_2("削除済みを表示", "tblbtn( 'fn_jyuhasshinbunsyo.asp?PageType=" & PageType & "&RouteType=" & RouteType & "&ShowDel=1')", "", "", "", "", "", "", "", ""))
		End If
	End If

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


%>

<div id="L0" style="position: absolute; visibility: hidden; left: 0px; top: -2000px;">
	<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="5">
	<tr>
		<td align="center" valign="middle">
		<table width="680" height="100%" border="0" cellspacing="5" cellpadding="15" bgcolor="#ffffff" style="border:1px solid #000000">
			<tr>
			<td align="center" background="/sj4web/images/window_bk.gif">
				<table width="600" height="100%" border="0" cellspacing="0" cellpadding="0">
				<tr>
					<td valign="middle">
					<object classid="clsid:5220cb21-c88d-11cf-b347-00aa00a28331">
						<param name="lpkpath" value="spread6.lpk">
					</object>
					<object width="600" height="100%" onMouseOver="SubmitFlg=1" classid="clsid:41f841c1-ae16-11d5-8817-0050da6ef5e5" codebase="/<% = HomeAlias %>/binx/spr32x60.cab#version=1,1,1,1" id="vaSpread1" border="0">
					</object>
					</td>
				</tr>
				</table>
			</td>
			</tr>
		</table>
		</td>
	</tr>
	</table>
</div>
</form>

</body>

<SCRIPT LANGUAGE="JavaScript">

	function syokaibtn()
	{
		if(document.vaSpread1.ActiveRow >= 1)
		{
			document.vaSpread1.Col = 1;
			document.vaSpread1.Row = document.vaSpread1.ActiveRow;
			tblbtn(document.vaSpread1.Text);
		}
		else
		{
			alert("選択されていません");
		}
	}

	function SubmitCheck()
	{

		form1.SendValue.value = "";
		document.vaSpread1.Row = document.vaSpread1.ActiveRow;
		document.vaSpread1.Col = 2;

		var Text1;
		Text1 = document.vaSpread1.Text;
		if(Text1 == "")
		{
			alert("削除する文書を選択してください")
			return;
		}


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



	function SpreadInit(fpSpread)
	{
		fpSpread.MaxRows = 0;
<%

		Dim Query
		Dim Content
		Dim ii
		ii = 1

		If PageType = "受信文書" Then
			Query = "exec SPN学生受信文書一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & Session("UserID") & "'"
		ElseIf PageType = "発信文書" Then
			Query = "exec SPN学生発信文書一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & Session("UserID") & "'"
		End If

		Set Content = OpenQuery(Query)


'		Response.Write("Query:" & Query & "<br>")
'		Exit Sub

		Dim TorihikisakiMeisyo,KaisyaCD
		Dim SakujyoFlg
		Dim NextUrl, Param

		Dim SakuseiKaisyaCD, SojyushinKubun


		Do While Not(Content.BOF Or Content.EOF)
			If ShowDel = 1 Or (ShowDel <> 1 And Content.Fields("削除フラグ") = 0) Then

				If PageType = "受信文書" Then
'					TorihikisakiMeisyo = Content.Fields("作成会社名称")
					TorihikisakiMeisyo = Content.Fields("取引先名称")
					KaisyaCD = Content.Fields("会社CD")

				ElseIf PageType = "発信文書" Then
					TorihikisakiMeisyo = Content.Fields("取引先名称")
					KaisyaCD = Content.Fields("会社CD")
				End If

				SakuseiKaisyaCD = Content.Fields("作成会社CD")
				SojyushinKubun = Content.Fields("送受信区分")
				SakujyoFlg = ConvFlagMeisyo(Content.Fields("削除フラグ"), 4)

				If PageType = "受信文書" Then
					NextUrl = Content.Fields("アドレス") & Content.Fields("文書内容CD") & "&RouteType=MailOnlyRMail&SakuseiKaisyaCD=" & SakuseiKaisyaCD & "&PageType=" & PageType & "&KaisyaCD1=" & KaisyaCD
				Else
					NextUrl = Content.Fields("アドレス") & Content.Fields("文書内容CD") & "&RouteType=MailOnlySMail&SakuseiKaisyaCD=" & SakuseiKaisyaCD & "&PageType=" & PageType & "&KaisyaCD1=" & KaisyaCD
				End If

				Param = Content.Fields("作成会社CD") & "," & Content.Fields("文書種類CD") & "," & Content.Fields("文書内容CD")

				Response.Write("		SpreadAddItem(fpSpread);" & vbCrLf)
				Response.Write("		fpSpread.Row = " & ii & ";" & vbCrLf)
				Response.Write("		fpSpread.Col = 1;" & vbCrLf)
				Response.Write("		fpSpread.Text = """ & NextUrl & """;" & vbCrLf)
				Response.Write("		fpSpread.Col = 2;" & vbCrLf)
				Response.Write("		fpSpread.Text = """ & Param & """;" & vbCrLf)
				Response.Write("		fpSpread.Col = 3;" & vbCrLf)
				Response.Write("		fpSpread.Text = """ & SakujyoFlg	& """;" & vbCrLf)
				Response.Write("		fpSpread.Col = 4;" & vbCrLf)
				Response.Write("		fpSpread.Text = """ & Content.Fields("処理日") & """;" & vbCrLf)
				Response.Write("		fpSpread.Col = 5;" & vbCrLf)
				Response.Write("		fpSpread.Text = """ & TorihikisakiMeisyo & """;" & vbCrLf)
				Response.Write("		fpSpread.Col = 6;" & vbCrLf)
				Response.Write("		fpSpread.Text = """ & Content.Fields("文書名称") & """;" & vbCrLf)
				If PageType = "受信文書" Then 
					Response.Write("	fpSpread.Col = 7;" & vbCrLf)
					Response.Write("	fpSpread.Text = """ & ConvFlagMeisyo(Content.Fields("開封フラグ"), 2) & """;" & vbCrLf)
				End If
				Response.Write("		fpSpread.Col = 0;" & vbCrLf)
				Response.Write("		fpSpread.Text = "" "";" & vbCrLf)
				ii = ii + 1
			End If
			Content.MoveNext
		Loop
%>
	}

</SCRIPT>

<SCRIPT FOR="vaSpread1" EVENT="KeyDown(KeyAsciiCode, KeyShift)" LANGUAGE="JavaScript">
	SpreadKeyDown(this, KeyAsciiCode, KeyShift);
</SCRIPT>

<SCRIPT FOR="vaSpread1" EVENT="ScriptLeaveCell(ColNo, RowNo, NewColNo, NewRowNo, Cancel)" LANGUAGE="VBScript">
	Dim tmp

	tmp = SpreadChange(Me, ColNo, RowNo)
	If tmp = "ERR" Then
		Cancel = true
		SpreadReFocus(Me)
	End If
</SCRIPT>

<SCRIPT FOR="vaSpread1" EVENT="Click(ColNo, RowNo)" LANGUAGE="JavaScript">
//	ヘッダー列クリック時にソートしない場合にはコメントアウトする
	SpreadClick(this, ColNo, RowNo);
</SCRIPT>

<SCRIPT FOR="vaSpread1" EVENT="EditMode(Col, Row, Mode, ChangeMade)" LANGUAGE="JavaScript">
	this.Col = Col;
	this.Row = Row;
	if(this.CellType == 12)
	{
		if(!Mode)
		{
			this.TypeCurrencyLeadingZero = 2;
		}
	}
	this.focus();
</SCRIPT>

<SCRIPT FOR="window" EVENT="onload" LANGUAGE="JavaScript">

	//	SpreadInit 第 3n + 1 引数 (nは整数)
	//	0:日付型 1:文字型 8:コンボボックス型 10:チェックボックス型 12:通貨型 13:数値型 21:勘定科目 22:摘要
	document.vaSpread1.Redraw = false;
	<% If PageType = "受信文書" Then %>
		SpreadLoad(document.vaSpread1, "", 1 ,3, "", 1 ,3, " ", 1 ,3, "処理日", 0, 12, "取引先", 1, 24, "文書名称", 1, 26, "開封", 1, 4);
	<% Else %>
		SpreadLoad(document.vaSpread1, "", 1 ,3, "", 1 ,3, " ", 1 ,3, "処理日", 0, 12, "取引先", 1, 24, "文書名称", 1, 30);
	<% End If %>

	document.vaSpread1.ScriptEnhanced = true;
	//その他の Spread に関する設定はここに入れる
	document.vaSpread1.OperationMode = 2;
	document.vaSpread1.Col = 1;
	document.vaSpread1.ColHidden = true;
	document.vaSpread1.TypeMaxEditLen = 200;

	document.vaSpread1.Col = 2;
	document.vaSpread1.ColHidden = true;
	document.vaSpread1.TypeMaxEditLen = 200;

	document.vaSpread1.Row = -1;
	document.vaSpread1.Col = -1;
	document.vaSpread1.BackColor = 0xE6E6E6;
	document.vaSpread1.Lock = true;

	SpreadInit(document.vaSpread1);
	document.vaSpread1.Redraw = true;
</SCRIPT>

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