📄 city_stat.jsp
字号:
<%@ page contentType="text/html;charset=UTF-8"%>
<%@ include file="../../include.jsp"%>
<%
String st = StringUtil.getString(request,"st");
String en = StringUtil.getString(request,"en");
String st_t,en_t;
int ob = StringUtil.getInt(request,"ob",1);
TDate tDate = new TDate();
if ( !st.equals("") )
{
st_t = st;
}
else
{
st_t = tDate.getIntYear()+"-"+tDate.getIntMonth()+"-"+tDate.getIntDay();
}
if ( !en.equals("") )
{
en_t = en;
}
else
{
en_t = DateUtil.getIntCurrYear()+"-"+DateUtil.getIntCurrMonth()+"-"+DateUtil.getIntCurrDay();
}
int len = 450;
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>无标题文档</title>
<link href="../comm.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" href="../order/dynCalendar.css" type="text/css" media="screen">
<script language="javascript" src="../../common.js"></script>
<script src="../order/browserSniffer.js" type="text/javascript" language="javascript"></script>
<script src="../order/dynCalendar.js" type="text/javascript" language="javascript"></script>
<script language="javascript">
<!--
function stcalendarCallback(date, month, year)
{
day = date;
date = year+"-"+month+"-"+day;
document.filter_form.st_t.value = date;
//document.filter_form.startdate.value = year+"-"+month+"-"+day;
}
function encalendarCallback(date, month, year)
{
day = date;
date = year+"-"+month+"-"+day;
document.filter_form.en_t.value = date;
//document.filter_form.startdate.value = year+"-"+month+"-"+day;
}
//-->
</script>
<style type="text/css">
<!--
.unnamed1 {
background-color: #cccccc;
border-top-width: 1px;
border-right-width: 1px;
border-bottom-width: 1px;
border-left-width: 1px;
border-top-style: solid;
border-right-style: solid;
border-bottom-style: solid;
border-left-style: solid;
border-top-color: 666666;
border-right-color: 999999;
border-bottom-color: 999999;
border-left-color: 666666;
}
-->
</style>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<br>
<table width="98%" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td class="page-title"><img src="../imgs/page_title.gif" alt="title" width="17" height="12" align="absmiddle"> 统计报表 » 城市销售统计</td>
</tr>
</table>
<br>
<br>
<table width="98%" border="0" align="center" cellpadding="2" cellspacing="0">
<form name="filter_form" method="get" action="">
<tr>
<td width="100%" valign="middle"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>开始日期
<input name="st" type="text" id="st_t" size="9" value="<%=st_t%>" readonly>
<script language="JavaScript" type="text/javascript" >
<!--
stfooCalendar = new dynCalendar('stfooCalendar', 'stcalendarCallback', 'images/');
//-->
</script> 结束日期
<input name="en" type="text" id="en_t" size="9" value="<%=en_t%>" readonly>
<script language="JavaScript" type="text/javascript">
<!--
enfooCalendar = new dynCalendar('enfooCalendar', 'encalendarCallback', 'images/');
//-->
</script> <input name="Submit2" type="submit" class="short-button" onClick="filter();" value="重新统计"></td>
</tr>
</table></td>
</tr>
</form>
</table>
<br>
<table width="98%" border="0" align="center" cellpadding="3" cellspacing="0" class="thetable">
<thead>
<tr>
<td align="left" valign="middle" class="left-title"><a href="?ob=1&st=<%=st_t%>&en=<%=en_t%>" class="table-title">日
期</a></td>
<td width="58%" align="center" valign="middle" class="right-title"> </td>
<td width="9%" align="center" valign="middle" class="right-title"><a href="?ob=2&st=<%=st_t%>&en=<%=en_t%>" class="table-title">件</a></td>
<td width="10%" align="center" valign="middle" class="right-title"><a href="?ob=3&st=<%=st_t%>&en=<%=en_t%>" class="table-title">销售金额</a></td>
</tr>
</thead>
<%
PageCtrl pc = new PageCtrl();
pc.setPageNo(StringUtil.getInt(request,"p"));
pc.setPageSize(30);
DBRow rows[] = statMgr.getCityStat(st_t,en_t,ob,pc);
String className;
DBRow detailArea;
for ( int i=0; i<rows.length; i++ )
{
if ( i%2==0 )
{
className = "row-line1";
}
else
{
className = "row-line2";
}
detailArea = memberMgr.getDetailAreaById(rows[i].get("city",0l));
%>
<tr >
<td width="23%" height="50" align="left" valign="middle" class="<%=className%>" >
<%=memberMgr.getDetailAreaById(detailArea.get("parentid",0l)).getString("title")%> - <%=detailArea.getString("title")%> </td>
<td width="58%" align="left" valign="middle" class="<%=className%>" > <table width="<%=len%>" height="10" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="610" class="stat-column"><img src="stat_line2.gif" width="<%=rows[i].get("percentQ",0f)*len%>" height="8">
<%=(int)rows[i].get("total",0f)%>
/
<%=(int)(rows[i].get("percentQ",0f)*100)%>
%</td>
</tr>
</table>
<div style="padding-top:5px;">
<table width="<%=len%>" height="10" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="610" class="stat-column"><img src="stat_line3.gif" width="<%=rows[i].get("percentM",0f)*len%>" height="8">
<%=(int)rows[i].get("amount",0f)%>
/
<%=(int)(rows[i].get("percentM",0f)*100)%>
%</td>
</tr>
</table>
</div></td>
<td width="9%" align="center" valign="middle" class="<%=className%>" >
<%=(int)rows[i].get("total",0f)%>
</td>
<td width="10%" align="center" valign="middle" class="<%=className%>" >
<%=rows[i].get("amount",0f)%>
</td>
</tr>
<%
}
%>
</table>
<table width="98%" border="0" align="center" cellpadding="3" cellspacing="0">
<form name="dataForm" method="get">
<input type="hidden" name="p">
<input type="hidden" name="st" value="<%=st%>">
<input type="hidden" name="en" value="<%=en%>">
<input type="hidden" name="ob" value="<%=ob%>">
</form>
<tr>
<td height="1"></td>
</tr>
<tr>
<td height="28" align="right" valign="middle" class="turn-page-table">
<%
int pre = pc.getPageNo() - 1;
int next = pc.getPageNo() + 1;
out.println("页数：" + pc.getPageNo() + "/" + pc.getPageCount() + " 总数：" + pc.getAllCount() + " ");
out.println(HtmlUtil.aStyleLink("table-title","首页","javascript:go(1)",null,pc.isFirst()));
out.println(HtmlUtil.aStyleLink("table-title","上一页","javascript:go(" + pre + ")",null,pc.isFornt()));
out.println(HtmlUtil.aStyleLink("table-title","下一页","javascript:go(" + next + ")",null,pc.isNext()));
out.println(HtmlUtil.aStyleLink("table-title","末页","javascript:go(" + pc.getPageCount() + ")",null,pc.isLast()));
%>
跳转到
<input name="jump_p2" type="text" id="jump_p" style="width=28px;" value="<%=StringUtil.getInt(request,"p")%>">
<input name="Submit22" type="button" class="page-go" style="width:28px;padding-top:0px;" onClick="javascript:go(document.getElementById('jump_p2').value)" value="GO">
</td>
</tr>
</table>
<br>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -