<%@ page import = "bmx.admin.javaBeans.MsgUnitPriceBean,java.util.Hashtable,java.util.Vector,bmx.util.Util" %>
<%@ page import = "java.util.Date,java.util.Calendar,java.text.SimpleDateFormat,bmx.config.Config" %>
<%@include file="chkSession.jsp"%>
<%
String thisPage = Config.adminJspDir + "billingReport.jsp";
String unitPricePage = Config.adminJspDir + "msgUnitPriceSetup.jsp";
String summaryPage = Config.adminJspDir + "billingReportSummary.jsp";
String detailPage = Config.adminJspDir + "billingReportDetail.jsp"; String css1 = Config.cssDir + "FM.css";
String css2 = Config.cssDir + "esms.css";
String jsPage = Config.jsDir + "utils.js"; String sysMessage = "";
MsgUnitPriceBean mupBean = null;
Vector msgList = null;
Vector partList = null;
SimpleDateFormat dateFormatter = new SimpleDateFormat("yyyy.MM.dd");
Calendar calCurrentDate = Calendar.getInstance();
Calendar calLastMthStart = (Calendar) calCurrentDate.clone();
calLastMthStart.add(Calendar.MONTH, -1);
calLastMthStart.set(Calendar.DATE, 1);
Calendar calLastMthEnd = (Calendar) calCurrentDate.clone();
calLastMthEnd.set(Calendar.DATE, 1);
calLastMthEnd.add(Calendar.DATE, -1);
String currentDate = dateFormatter.format(calCurrentDate.getTime());
String lastMthStart = dateFormatter.format(calLastMthStart.getTime());
String lastMthEnd = dateFormatter.format(calLastMthEnd.getTime());
try {
mupBean = new MsgUnitPriceBean();
partList = mupBean.getPartList();
msgList = mupBean.getMsgList();
} catch (Exception e) {
System.out.println(e.getMessage());
sysMessage = e.getMessage();
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="<%= css1 %>">
<link rel="stylesheet" type="text/css" href="<%= css2 %>">
<title>Billing Report</title>
<script type="text/javascript" src="<%= jsPage %>" language="javascript"></script>
<script language="JavaScript"> function showReport(type) {
if (!isValidEntries()) {
return;
}
if (type == "summary") {
reportURI = "<%= summaryPage %>";
} else {
reportURI = "<%= detailPage %>";
} rptWin = window.open("", "BMXReportWin", "width=700,height=500,status=yes,resizable=yes,toolbar=no,menubar=no,scrollbars=yes");
document.fo_main.action = reportURI;
document.fo_main.target = "BMXReportWin";
document.fo_main.submit();
rptWin.focus();
} function isValidEntries() {
var startDate = trim(document.fo_main.tf_startDate.value);
var endDate = trim(document.fo_main.tf_endDate.value);
if (startDate != "" && !isDate(startDate)) {
alert("Invalid start date");
document.fo_main.tf_startDate.select();
document.fo_main.tf_startDate.focus();
return false;
} else if (endDate != "" && !isDate(endDate)) {
alert("Invalid end date");
document.fo_main.tf_endDate.select();
document.fo_main.tf_endDate.focus();
return false;
} else if (startDate != "" && endDate != "" && startDate > endDate) {
alert("Start date beyond end date");
document.fo_main.tf_startDate.select();
document.fo_main.tf_startDate.focus();
return false;
} else if (endDate != "" && endDate > "<%= currentDate %>") {
alert("End date beyond current date");
document.fo_main.tf_endDate.select();
document.fo_main.tf_endDate.focus();
return false;
} else {
return true;
}
}
</script>
</head><body>
<form name="fo_main" action="<%= thisPage %>" method="post">
<table width="720" cellspacing="0" cellpadding="5" border="0">
<tr>
<td width="100%"><font class="title">Billing Report</font></td>
</tr>
<tr>
<td class="errMsg"><%= sysMessage %> </td>
</tr>
<tr>
<td>
<table border="0" cellspacing="0" cellpadding="0" class="reportTable">
<tr>
<td>
<table cellspacing="1" cellpadding="5" border="0">
<tr>
<th rowspan="2">Participant</th>
<th rowspan="2">Message</th>
<th colspan="2">Period (yyyy.mm.dd)</th>
<th rowspan="2">
<input type="button" class="actButton" name="bt_priceSetup" value="Unit Price Setup" onclick="window.location.href='<%= unitPricePage %>'">
</th>
</tr>
<tr>
<th>Start Date</th>
<th>End Date</th>
</tr>
<tr class="global">
<td>
<select class="input" name="sb_participant">
<option value="">-- All --</option>
<%
for (int i=0; i<partList.size(); i++) {
Hashtable partRec = (Hashtable) partList.get(i);
String selPartID = (String) partRec.get("ID");
String selPartDesc = (String) partRec.get("Desc");
%>
<option value="<%= selPartID %>"><%= selPartID %></option>
<%
}
%>
</select>
</td>
<td>
<select class="input" name="sb_message">
<option value="">-- All --</option>
<%
for (int i=0; i<msgList.size(); i++) {
Hashtable msgRec = (Hashtable) msgList.get(i);
String selMsgID = (String) msgRec.get("ID");
String selMsgDesc = (String) msgRec.get("Desc");
%>
<option value="<%= selMsgID %>"><%= selMsgID %></option>
<%
}
%>
</select>
</td>
<td>
<input type="text" class="input" name="tf_startDate" size="10" maxlength="10" value="<%= lastMthStart %>">
</td>
<td>
<input type="text" class="input" name="tf_endDate" size="10" maxlength="10" value="<%= lastMthEnd %>">
</td>
<td nowrap align="center">
<input type="button" class="actButton" name="sb_summary" value="Summary" onclick="showReport('summary')">
<input type="button" class="actButton" name="sb_detail" value="Detail" onclick="showReport('detail')">
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table></form>
</body>
</html>
<%@ page import = "java.util.Date,java.util.Calendar,java.text.SimpleDateFormat,bmx.config.Config" %>
<%@include file="chkSession.jsp"%>
<%
String thisPage = Config.adminJspDir + "billingReport.jsp";
String unitPricePage = Config.adminJspDir + "msgUnitPriceSetup.jsp";
String summaryPage = Config.adminJspDir + "billingReportSummary.jsp";
String detailPage = Config.adminJspDir + "billingReportDetail.jsp"; String css1 = Config.cssDir + "FM.css";
String css2 = Config.cssDir + "esms.css";
String jsPage = Config.jsDir + "utils.js"; String sysMessage = "";
MsgUnitPriceBean mupBean = null;
Vector msgList = null;
Vector partList = null;
SimpleDateFormat dateFormatter = new SimpleDateFormat("yyyy.MM.dd");
Calendar calCurrentDate = Calendar.getInstance();
Calendar calLastMthStart = (Calendar) calCurrentDate.clone();
calLastMthStart.add(Calendar.MONTH, -1);
calLastMthStart.set(Calendar.DATE, 1);
Calendar calLastMthEnd = (Calendar) calCurrentDate.clone();
calLastMthEnd.set(Calendar.DATE, 1);
calLastMthEnd.add(Calendar.DATE, -1);
String currentDate = dateFormatter.format(calCurrentDate.getTime());
String lastMthStart = dateFormatter.format(calLastMthStart.getTime());
String lastMthEnd = dateFormatter.format(calLastMthEnd.getTime());
try {
mupBean = new MsgUnitPriceBean();
partList = mupBean.getPartList();
msgList = mupBean.getMsgList();
} catch (Exception e) {
System.out.println(e.getMessage());
sysMessage = e.getMessage();
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="<%= css1 %>">
<link rel="stylesheet" type="text/css" href="<%= css2 %>">
<title>Billing Report</title>
<script type="text/javascript" src="<%= jsPage %>" language="javascript"></script>
<script language="JavaScript"> function showReport(type) {
if (!isValidEntries()) {
return;
}
if (type == "summary") {
reportURI = "<%= summaryPage %>";
} else {
reportURI = "<%= detailPage %>";
} rptWin = window.open("", "BMXReportWin", "width=700,height=500,status=yes,resizable=yes,toolbar=no,menubar=no,scrollbars=yes");
document.fo_main.action = reportURI;
document.fo_main.target = "BMXReportWin";
document.fo_main.submit();
rptWin.focus();
} function isValidEntries() {
var startDate = trim(document.fo_main.tf_startDate.value);
var endDate = trim(document.fo_main.tf_endDate.value);
if (startDate != "" && !isDate(startDate)) {
alert("Invalid start date");
document.fo_main.tf_startDate.select();
document.fo_main.tf_startDate.focus();
return false;
} else if (endDate != "" && !isDate(endDate)) {
alert("Invalid end date");
document.fo_main.tf_endDate.select();
document.fo_main.tf_endDate.focus();
return false;
} else if (startDate != "" && endDate != "" && startDate > endDate) {
alert("Start date beyond end date");
document.fo_main.tf_startDate.select();
document.fo_main.tf_startDate.focus();
return false;
} else if (endDate != "" && endDate > "<%= currentDate %>") {
alert("End date beyond current date");
document.fo_main.tf_endDate.select();
document.fo_main.tf_endDate.focus();
return false;
} else {
return true;
}
}
</script>
</head><body>
<form name="fo_main" action="<%= thisPage %>" method="post">
<table width="720" cellspacing="0" cellpadding="5" border="0">
<tr>
<td width="100%"><font class="title">Billing Report</font></td>
</tr>
<tr>
<td class="errMsg"><%= sysMessage %> </td>
</tr>
<tr>
<td>
<table border="0" cellspacing="0" cellpadding="0" class="reportTable">
<tr>
<td>
<table cellspacing="1" cellpadding="5" border="0">
<tr>
<th rowspan="2">Participant</th>
<th rowspan="2">Message</th>
<th colspan="2">Period (yyyy.mm.dd)</th>
<th rowspan="2">
<input type="button" class="actButton" name="bt_priceSetup" value="Unit Price Setup" onclick="window.location.href='<%= unitPricePage %>'">
</th>
</tr>
<tr>
<th>Start Date</th>
<th>End Date</th>
</tr>
<tr class="global">
<td>
<select class="input" name="sb_participant">
<option value="">-- All --</option>
<%
for (int i=0; i<partList.size(); i++) {
Hashtable partRec = (Hashtable) partList.get(i);
String selPartID = (String) partRec.get("ID");
String selPartDesc = (String) partRec.get("Desc");
%>
<option value="<%= selPartID %>"><%= selPartID %></option>
<%
}
%>
</select>
</td>
<td>
<select class="input" name="sb_message">
<option value="">-- All --</option>
<%
for (int i=0; i<msgList.size(); i++) {
Hashtable msgRec = (Hashtable) msgList.get(i);
String selMsgID = (String) msgRec.get("ID");
String selMsgDesc = (String) msgRec.get("Desc");
%>
<option value="<%= selMsgID %>"><%= selMsgID %></option>
<%
}
%>
</select>
</td>
<td>
<input type="text" class="input" name="tf_startDate" size="10" maxlength="10" value="<%= lastMthStart %>">
</td>
<td>
<input type="text" class="input" name="tf_endDate" size="10" maxlength="10" value="<%= lastMthEnd %>">
</td>
<td nowrap align="center">
<input type="button" class="actButton" name="sb_summary" value="Summary" onclick="showReport('summary')">
<input type="button" class="actButton" name="sb_detail" value="Detail" onclick="showReport('detail')">
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table></form>
</body>
</html>
解决方案 »
- struts2怎么直接跳转,不通过配置文件
- 我写的一小段代码，没写完，不知道怎么完成，请各位看看
- Ajax问题
- lomboz与jsp工程中类问题
- 如何把xls中的信息导入oracle数据库，系统是JSP，Javabean
- 我的javascript想操作form中的数据，我怎么把我的form中的数据传到我的javascript中，最好给个例子
- 实在是不知道我的<xsl:eval>哪里错了,请大家执教
- jsp中连接oracle数据库的问题
- eclipse 中 jdbc 连接 mysql 插入数据中文乱码
- jsp中如何想数据库中增加数据?
- 在oracle与JSP中这条SQL语句怎么写，在线等待（能解决者80分）
- 各位水友，本人在小公司做事，一直想到大公司去，有什么好建议？
<%@ include file="incdb.jsp"%>
<jsp:useBean id="board" class="test.bbsboard" scope="page"/>
<%
java.sql.ResultSet sqlRst;
sqlRst=board.listBoard(7);
%><html><head>
<title>New Page 2</title>
<base target="rtop"><link rel="stylesheet" type="text/css" href="bbs03.css"><SCRIPT language=JavaScript>
<!--
var old_menu = '';
var old_cell = '';
function menuclick( submenu ,cellbar)
{
if( old_menu != submenu ) {
if( old_menu !='' ) {
old_menu.style.display = 'none';
old_cell.src= 'images/folder_01.gif';
}
submenu.style.display = 'block';
cellbar.src = 'images/folder_02.gif';
old_menu = submenu;
old_cell = cellbar; } else {
submenu.style.display = 'none';
cellbar.src= 'images/folder_01.gif';
old_menu = '';
old_cell = '';
}
}
-->
</SCRIPT>
</head><body><div align="center">
<center><table border="0" width="130">
<tr>
<td width="100%" align="center">
<div><a href="index.htm" target="_top">返回首页</a></div>
<DIV align=center class=parent><hr width="100" size="1"></div>
</td>
</tr>
<tr>
<td width="100%" align="center">
<div><a href="about.jsp" target="rtop">关于论坛</a></div>
<DIV align=center class=parent><hr width="100" size="1"></div>
</td>
</tr>
<tr>
<td width="100%" align="center">
<div><a href="query.jsp">帖子查询</a><br></div>
<DIV align=center class=parent><hr width="100" size="1"></div>
</td>
</tr>
<!---------------------------------->
<tr>
<td width="100%" align="center">
<DIV align=center onClick="menuclick(submenu1, bar1 );" style="CURSOR: hand">
<img src="images/folder_01.gif" id=bar1 width="16" height="16">
<A HREF="#" target="_self">论坛版面</a><BR></DIV>
</td>
</tr>
<tr>
<td width="100%" align="center">
<DIV align=center class=parent><hr width="100" size="1"></div> <DIV align=center id=submenu1 style="DISPLAY: none; ">
<%
while(sqlRst.next()){
%>
<a href="bbslist.jsp?boardid=<%=sqlRst.getString("boardid")%>"><%=sqlRst.getString("boardname")%></a><br>
<%
}
sqlRst.close();
%>
<hr width="100" size="1"> </div>
</td>
</tr>
<tr>
<td width="100%" align="center">
<!---------------------------------->
<DIV align=center onClick="menuclick(submenu2, bar2 );" style="CURSOR: hand">
<img src="images/folder_01.gif" id=bar2 width="16" height="16">
<A HREF="#" target="_self">排 行 榜</a><BR></DIV>
</td>
</tr>
<tr>
<td width="100%" align="center">
<DIV align=center class=parent><hr width="100" size="1"></div>
<DIV align=center id=submenu2 style="DISPLAY: none; "> <a href="point.jsp">-总排行榜</a><br>
<a href="point.jsp?pages=1">-个人积分排行</a><br>
<a href="point.jsp?pages=2">-版面点击排行</a><br>
<a href="point.jsp?pages=3">-版面积分排行</a><br>
<hr width="100" size="1">
</div>
</td>
</tr>
<tr>
<td width="100%" align="center">
<!---------------------------------->
<DIV align=center onClick="menuclick(submenu3, bar3 );" style="CURSOR: hand">
<img src="images/folder_01.gif" id=bar3 width="16" height="16">
<A HREF="#" target="_self">用户信息</a><BR></DIV>
</td>
</tr>
<tr>
<td width="100%" align="center">
<DIV align=center class=parent><hr width="100" size="1"></div>
<DIV align=center id=submenu3 style="DISPLAY: none; ">
<a href="registry.jsp" >用 户 注 册</a><br>
<a href="myinfo.jsp?pages=1">修改个人信息</a><br>
<a href="myinfo.jsp?pages=2">更改个人密码</a><br>
<a href="myinfo.jsp?pages=3">查询个人信息</a><br>
<hr width="100" size="1">
</div>
</td>
</tr>
<tr>
<td width="100%" align="center">
<!---------------------------------->
<DIV align=center onClick="menuclick(submenu4, bar4 );" style="CURSOR: hand">
<img src="images/folder_01.gif" id=bar4 width="16" height="16">
<A HREF="#" target="_self">管 理 员</A><BR></DIV>
</td>
</tr>
<tr>
<td width="100%" align="center">
<DIV align=center class=parent><hr width="100" size="1"></div>
<DIV align=center id=submenu4 style="DISPLAY: none; ">
<a href="adminlog.jsp" target="rtop">论坛管理</a><BR>
<a href="superlog.jsp">版面管理</a><BR>
<hr width="100" size="1">
</DIV>
</td>
</tr>
<tr>
<td width="100%" align="center">
<!---------------------------------->
<div>
Build By<br>
<a href="mailto:[email protected]">Anan</a><br>
2000.10<br>
<a href="http://ananonline.yeah.net" target="_top">安安在线<br></a></div>
</td>
</tr>
</table>
</center>
</div> </body>
</html>