📄 province_stat.jsp

📁 很好的,网上商城在线购物网站系统,电子商务自助建站管理系统。适合电脑,手机,数码,化妆品,服装,运动鞋,首饰,母婴,成人用品,书籍,汽车,办公用品,音像制品的网店
💻 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">&nbsp;&nbsp; 统计报表 »   省份销售统计</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> &nbsp; &nbsp; &nbsp;结束日期 
              <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> &nbsp; &nbsp; &nbsp; <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="left" 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.getProvinceStat(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("province",0l));
%>
  <tr > 
    <td width="23%" height="50" align="left" valign="middle"  class="<%=className%>"  > 
      <%=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">&nbsp;&nbsp; 
            <%=(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">&nbsp;&nbsp; 
              <%=(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() + " &nbsp;&nbsp;总数：" + pc.getAllCount() + " &nbsp;&nbsp;");
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 + -