<!-- #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 %>