<!-- #include file="../../include.asp" -->

<%
'<!--
'################################################
'	名称	:発信前仕入販売書類一覧表示
'	作成日	:2012/07/03
'	作成者	:小野
'	目的	:発信前の仕入販売書類を一覧表示する。
'	概要	:検認処理のため
'################################################
'-->
%>
<%
main()
Sub main()

	If Not(SessionCheck()) Then
		Exit Sub
	End If

	Dim KenninView
	KenninView = Request("KenninView")


	Dim Query
	Dim Content
	Dim ContentTG

	Dim EnshuCD
	Dim EnshuName
	EnshuCD = Request("EnshuCD")
	If GB_EnshuCD <> "" Then
		EnshuCD = GB_EnshuCD
	End If

	Dim ShiireUriageKennin

	If EnshuCD <> "" Then
		Query = "exec SPM演習取得 '" & GB_SystemCD & "', '" & EnshuCD & "'"
		Set Content = OpenQuery(Query)
		If Not(Content.BOF Or Content.EOF) Then
			EnshuName = Content.Fields("演習名称")
			ShiireUriageKennin = ";" & Content.Fields("仕入売上書類検認利用") & ";"
			ShiireUriageKennin = Replace(ShiireUriageKennin, ",", ";") '旧バージョン整合
		End If
	End If

	Dim BunsyoSyuruiCD
	BunsyoSyuruiCD = Request("BunsyoSyuruiCD")
	If BunsyoSyuruiCD = "" Then
		If InStr(ShiireUriageKennin, ";KI;") > 0 Then
			BunsyoSyuruiCD = "KI"
		ElseIf InStr(ShiireUriageKennin, ";KM;") > 0 Then
			BunsyoSyuruiCD = "KM"
		ElseIf InStr(ShiireUriageKennin, ";KC;") > 0 Then
			BunsyoSyuruiCD = "KC"
		ElseIf InStr(ShiireUriageKennin, ";KU;") > 0 Then
			BunsyoSyuruiCD = "KU"
		ElseIf InStr(ShiireUriageKennin, ";KB;") > 0 Then
			BunsyoSyuruiCD = "KB"
		ElseIf InStr(ShiireUriageKennin, ";KN;") > 0 Then
			BunsyoSyuruiCD = "KN"
		ElseIf InStr(ShiireUriageKennin, ";KX;") > 0 Then
			BunsyoSyuruiCD = "KX"
		ElseIf InStr(ShiireUriageKennin, ";KO;") > 0 Then
			BunsyoSyuruiCD = "KO"
		ElseIf InStr(ShiireUriageKennin, ";KY;") > 0 Then
			BunsyoSyuruiCD = "KY"
		ElseIf InStr(ShiireUriageKennin, ";KP;") > 0 Then
			BunsyoSyuruiCD = "KP"
		End If
	End If

	Dim SeitoCD
	SeitoCD = Request("SeitoCD")

%>
<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="../../binx/sj3web.css?<% = TimeUniq() %>" rel="stylesheet" type="text/css">
<title><% = AppTitle %></title>
<script language="JScript" src="../../include.js?<% = TimeUniq() %>"></script>
<script language="JScript" src="../../includesj.js?<% = TimeUniq() %>"></script>
<script language="JScript.Encode" src="../../include_enc.js?<% = TimeUniq() %>"></script>
<script language="JScript.Encode" src="../../includesj_enc.js?<% = TimeUniq() %>"></script>
<script type=""text/javascript"" src="../../javascript.js?<% = TimeUniq() %>"></script>
<SCRIPT LANGUAGE="JavaScript">
<!--
	HomeAlias = "<% = HomeAlias %>";
	HomeAliasSL = "<% = HomeAliasSL %>";
	ExitFlg = 0;
-->
</SCRIPT>
<SCRIPT LANGUAGE="JavaScript">
<!--
var lsURL="#"
function syokaibtn() {
	if(lsURL == "#") {
		alert("選択されていません");
	} else {
		tblbtn(lsURL); 
	}
}

//TRselect & URLset
function celsel(rw,selURL)
{
	var trw;
	trw=rw;
	lsURL=selURL;
	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";//選択行色変更
}

//-->
</SCRIPT>
</head>

<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="fm_enshucontrol07_bin.asp" onSubmit="return SubmitCheck();">
<input type="hidden" name="EnshuCD" value="<% = EnshuCD %>">

<%
	Response.Write(HtmlDesign(1))

	Response.Write(HttpL1(4))

	If GB_Admin = 1 Then
		Response.Write(HttpL2("運用管理メニュー" ,"tblbtn( '/" & HomeAlias & "/admin/admenu_w.asp')", "演習管理", "tblbtn( '/" & HomeAlias & "/admin/enshu/fm_enshu_ichiran.asp?EnshuCD=" & EnshuCD & "')", "演習コントロール", "tblbtn( '/" & HomeAlias & "/admin/enshu/fm_enshucontrol.asp?EnshuCD=" & EnshuCD & "')", "仕入販売書類検認", "", "", "", "", ""))	
	Else'If GB_Admin > 1 Then
		Response.Write(HttpL2("運用管理メニュー" ,"tblbtn( '/" & HomeAlias & "/admin/admenu_w.asp')", "演習管理", "tblbtn( '/" & HomeAlias & "/admin/enshu/fm_enshu1_view.asp?EnshuCD=" & EnshuCD & "')", "演習コントロール", "tblbtn( '/" & HomeAlias & "/admin/enshu/fm_enshucontrol.asp?EnshuCD=" & EnshuCD & "')", "仕入販売書類検認", "", "", "", "", ""))	
	End If

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

	Response.Write(HttpL3_1("照会", "syokaibtn()", "", "", "", "", "", "", "", ""))

	Response.Write(HttpL3_2("戻る", "tblbtn( '/" & HomeAlias & "/admin/enshu/fm_enshucontrol.asp?EnshuCD=" & EnshuCD & "')", "", "", "", "", "", "", "", ""))

	Response.Write(HttpL4("演習コントロール", "仕入販売書類の検認"))

	Response.Write(HttpL5("発信前の仕入販売書類を表示しています"))


%>

<div id="L0" style="position: absolute; visibility: hidden; left: 0px; top: -2000px;">
<table width="1" height="100%" border="0" cellspacing="5" cellpadding="5" bgcolor="#ffffff" style="border:1px solid #000000">
	<tr>
		<td align="center" background="/<% = HomeAlias %>/images/window_bk.gif?<% = GB_STU %>">
			<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
				<tr height="10">
					<td valign="top">
						<table height="30" border="0" cellpadding="0" cellspacing="0" class="tx1416">
							<tr>
								<td>
									<table height="30" border="0" cellpadding="0" cellspacing="0" class="tx1416">
										<tr>
											<td>
<% If ConvEnshuKubun(EnshuCD) = "P" Then %>
												<select size="1" class="tbox4" name="SeitoCD" onChange="tblbtn('fm_enshucontrol07.asp?EnshuCD=<% = EnshuCD %>&SeitoCD=' + this.value + '&KenninView=' + form1.KenninView.value + '&BunsyoSyuruiCD=' + form1.BunsyoSyuruiCD.value);">
													<option value=""><全ての生徒></option>
<%
	Query = "exec SPM演習会社履歴 '" & GB_SystemCD & "', '" & EnshuCD & "', 0"	'ソート区分指定
	Set Content = OpenQuery(Query)
	Do While Not(Content.BOF Or Content.EOF)
		Response.Write("	<option value=""" & Content.Fields("学生番号") & """")
		If "" & Content.Fields("学生番号") = SeitoCD Then
			Response.Write(" selected")
		End If
		Response.Write(">" & Content.Fields("氏名") & "</option>" & vbCrLf)
		Content.MoveNext
	Loop
%>
												</select>
												&nbsp;
<% Else %>
												<input type="hidden" name="SeitoCD" value="<% = SeitoCD %>">
<% End If %>
												書類名
												<select size="1" class="tbox4" name="BunsyoSyuruiCD" onChange="tblbtn('fm_enshucontrol07.asp?EnshuCD=<% = EnshuCD %>&SeitoCD=' + form1.SeitoCD.value + '&KenninView=' + form1.KenninView.value + '&BunsyoSyuruiCD=' + this.value);">
													<% If InStr(ShiireUriageKennin, ";KI;") > 0 Then %><option value="KI"<% If BunsyoSyuruiCD = "KI" Then %> selected <% End If %>>見積依頼書</option><% End If %>
													<% If InStr(ShiireUriageKennin, ";KM;") > 0 Then %><option value="KM"<% If BunsyoSyuruiCD = "KM" Then %> selected <% End If %>>見積書</option><% End If %>
													<% If InStr(ShiireUriageKennin, ";KC;") > 0 Then %><option value="KC"<% If BunsyoSyuruiCD = "KC" Then %> selected <% End If %>>注文書</option><% End If %>
													<% If InStr(ShiireUriageKennin, ";KU;") > 0 Then %><option value="KU"<% If BunsyoSyuruiCD = "KU" Then %> selected <% End If %>>注文請書</option><% End If %>
													<% If InStr(ShiireUriageKennin, ";KB;") > 0 Then %><option value="KB"<% If BunsyoSyuruiCD = "KB" Then %> selected <% End If %>>物品受領書</option><% End If %>
													<% If InStr(ShiireUriageKennin, ";KN;") > 0 Then %><option value="KN"<% If BunsyoSyuruiCD = "KN" Then %> selected <% End If %>>納品請求書</option><% End If %>
													<% If InStr(ShiireUriageKennin, ";KX;") > 0 Then %><option value="KX"<% If BunsyoSyuruiCD = "KX" Then %> selected <% End If %>>管理部買入申込書</option><% End If %>
													<% If InStr(ShiireUriageKennin, ";KO;") > 0 Then %><option value="KO"<% If BunsyoSyuruiCD = "KO" Then %> selected <% End If %>>管理部宛物品受領書</option><% End If %>
													<% If InStr(ShiireUriageKennin, ";KY;") > 0 Then %><option value="KY"<% If BunsyoSyuruiCD = "KY" Then %> selected <% End If %>>管理部売渡申込書</option><% End If %>
													<% If InStr(ShiireUriageKennin, ";KP;") > 0 Then %><option value="KP"<% If BunsyoSyuruiCD = "KP" Then %> selected <% End If %>>管理部宛納品請求書</option><% End If %>
												</select>&nbsp;
												<select size="1" class="tbox4" name="KenninView" onChange="tblbtn('fm_enshucontrol07.asp?EnshuCD=<% = EnshuCD %>&SeitoCD=' + form1.SeitoCD.value + '&BunsyoSyuruiCD=' + form1.BunsyoSyuruiCD.value + '&KenninView=' + this.value);">
													<option value="0"<% If KenninView <> "1" Then %> selected <% End If %>>未検認</option>
													<option value="1"<% If KenninView = "1" Then %> selected <% End If %>>検認済み</option>
												</select>
											</td>
										</tr>
									</table>
								</td>
							</tr>
						</table>
						<TABLE WIDTH="820" HEIGHT="30" BORDER="1" CELLPADDING="0" CELLSPACING="0" BORDERCOLOR="#000000" BGCOLOR="#FFFFCC" CLASS="tx1416" STYLE="border-collapse: collapse">
							<TR ALIGN="CENTER">
								<TD HEIGHT="30" width="90" align="center">対象演習名</TD>
								<TD height="30" align="center">
									<% = EnshuMeisyo %>
								</TD>
							</TR>
						</table>
						<table BORDER="0" CELLPADDING="0" CELLSPACING="0">
							<TR>
								<TD VALIGN="BOTTOM" WIDTH="1">
									<TABLE HEIGHT="20" BORDER="1" WIDTH="820" CELLPADDING="3" CELLSPACING="0" BORDERCOLOR="#000000" BGCOLOR="#FFFFCC" CLASS="tx1416" STYLE="border-collapse: collapse">
										<TR ALIGN="CENTER">
											<% If ConvEnshuKubun(EnshuCD) = "P" Then %>
											<TD HEIGHT="20" WIDTH="140">学生氏名</TD>
											<% Else %>
											<TD HEIGHT="20" WIDTH="140">会社コード</TD>
											<% End If %>
											<TD HEIGHT="20" WIDTH="210">作成会社</TD>
											<TD HEIGHT="20">書類名</TD>
											<TD HEIGHT="20" WIDTH="82">処理日</TD>
											<TD HEIGHT="20" WIDTH="217">摘要</TD>
										</TR>
									</TABLE>
								</TD>
							</TR>
						</table>
					</TD>
				</TR>
				<TR>
					<TD VALIGN="TOP">
						<DIV ID="Layer1" STYLE="position:relative; left:0px; top:0px; width:840px; height:100%; z-index:1; border: 1px none #000000; overflow: auto;">
							<TABLE ID="SyoukaiList" BORDER="1" WIDTH="820" CELLSPACING="0" CELLPADDING="3" BGCOLOR="#FFFFFF" CLASS="tx1416" STYLE="border-collapse: collapse" BORDERCOLOR="#000000">
<%
	'取引のある口座開設は削除できないようにするための判定
	Dim ContentTorihiki
	Dim TorihikiCnt

	Dim ii
	ii = 0
	Query = "exec SPD仕入売上書類一覧 '" & GB_SystemCD & "', '" & EnshuCD & "', '', '', '" & BunsyoSyuruiCD & "'" '全会社取得
'Response.Write(Query)
'Exit Sub
	Set Content = OpenQuery(Query)
	Do While Not(Content.BOF Or Content.EOF)
																'同時同業の場合は選択生徒のみ表示
		If (ConvEnshuKubun(EnshuCD) = "G" Or SeitoCD = "" Or "" & ConvKaisyaGakuseiNo(EnshuCD, Content.Fields("作成会社CD")) = SeitoCD) And "" & Content.Fields("削除フラグ") <> "1" Then

			'  未発信文書のみ                               会社CD=作成会社CDの文書のみ
			If "" & Content.Fields("発行フラグ") <> "1" And Content.Fields("会社CD") = Content.Fields("作成会社CD") Then
			'  管理部書類は除外(一括処理が行われるため)
			If "" & Content.Fields("文書種類CD") = "KI" Or "" & Content.Fields("文書種類CD") = "KM" Or "" & Content.Fields("文書種類CD") = "KC" Or "" & Content.Fields("文書種類CD") = "KU" Or "" & Content.Fields("文書種類CD") = "KB" Or "" & Content.Fields("文書種類CD") = "KN" Or "" & Content.Fields("文書種類CD") = "KO" Or "" & Content.Fields("文書種類CD") = "KP" Or "" & Content.Fields("文書種類CD") = "KX" Or "" & Content.Fields("文書種類CD") = "KY" Then
			'  検認済みは除外                                                      検認済みのみ表示
			If (KenninView <> "1" And "" & Content.Fields("検認フラグ") <> "1") Or (KenninView = "1" And "" & Content.Fields("検認フラグ") = "1") Then

				Response.Write("<TR ALIGN=""CENTER"" style=""cursor:hand"" onClick=""celsel(" & ii & ",'fm_enshucontrol07_view.asp?EnshuCD=" & EnshuCD & "&SakuseiKaisyaCD=" & Content.Fields("作成会社CD") & "&BunsyoSyuruiCD=" & Content.Fields("文書種類CD") & "&BunsyoNaiyoCD=" & Content.Fields("文書内容CD") & "&SeitoCD=' + form1.SeitoCD.value + '&KenninView=' + form1.KenninView.value);"" onDblClick=""syokaibtn();"">" & vbCrLf)
				Response.Write("<TD HEIGHT=""20"" ALIGN=""LEFT"" WIDTH=""140"">")
				If ConvEnshuKubun(EnshuCD) = "P" Then
					Response.Write(ConvGakuseiShimei(ConvKaisyaGakuseiNo(EnshuCD, Content.Fields("作成会社CD"))))
				Else
					Response.Write(Content.Fields("作成会社CD"))
				End If
				Response.Write("</TD>" & vbCrLf)
				Response.Write("<TD HEIGHT=""20"" WIDTH=""210"" ALIGN=""LEFT"">" & ConvKaisyaMeisyoDx(EnshuCD, Content.Fields("作成会社CD")) & "</TD>" & vbCrLf)
				Response.Write("<TD HEIGHT=""20"" ALIGN=""LEFT"">")
				If Content.Fields("文書種類CD") = "KI" Then
					Response.Write("見積依頼書")
				ElseIf Content.Fields("文書種類CD") = "KM" Then
					Response.Write("見積書")
				ElseIf Content.Fields("文書種類CD") = "KC" Then
					Response.Write("注文書")
				ElseIf Content.Fields("文書種類CD") = "KU" Then
					Response.Write("注文請書")
				ElseIf Content.Fields("文書種類CD") = "KN" Then
					Response.Write("納品請求書")
				ElseIf Content.Fields("文書種類CD") = "KB" Then
					Response.Write("物品受領書")
				ElseIf Content.Fields("文書種類CD") = "KX" Then
					Response.Write("管理部買入申込書")
				ElseIf Content.Fields("文書種類CD") = "KO" Then
					Response.Write("管理部宛物品受領書")
				ElseIf Content.Fields("文書種類CD") = "KY" Then
					Response.Write("管理部売渡申込書")
				ElseIf Content.Fields("文書種類CD") = "KP" Then
					Response.Write("管理部宛納品請求書")
				End If
				Response.Write("</TD>" & vbCrLf)
				Response.Write("<TD HEIGHT=""20"" WIDTH=""82"" ALIGN=""CENTER"">" & Content.Fields("処理日") & "</TD>" & vbCrLf)
				Response.Write("<TD HEIGHT=""23"" WIDTH=""217"" ALIGN=""LEFT""><span style=""width:217px; height:14px; overflow:hidden"">" & Content.Fields("摘要") & "</span></TD>" & vbCrLf)
				Response.Write("</TR>" & vbCrLf)
				ii = ii + 1
			End If
			End If
			End If
		End If

		Content.MoveNext
	Loop

%>
							</TABLE>
						</DIV>
					</TD>
				</TR>
			</TABLE>
		</td>
	</tr>
</table>
</DIV>
</form>

</body>

<% = HtmlFooter %>
</html>
<SCRIPT LANGUAGE="JavaScript">

	function SubmitCheck() {
		if (form1.LimitDate.value == "") {
			alert("日付を入力してください ");
			form1.LimitDate.focus();
			return false;
		}
		if (!confirm("\n指定された日付までの手形取立・割引受付の満期処理(当座入出金)を行います。よろしいですか? \n\n(日付は会計期間外も指定出来ますので、西暦年の誤りにご注意ください) \n\n")) {
			return false;
		}
		SubmitReal(form1);
		return true;
	}

</script>

<%
End Sub
%>