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