📄 report.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="admin_common.asp"-->
<!--#include file="../script/fixNumber.asp"-->
<%
var today = new Date();
maxYear = today.getYear();
year = String(Request.Form("year"));
if((year == "")||(year == "undefined"))
{
year = today.getYear();
}
var rs = Server.CreateObject("ADODB.Recordset");
var strSQL = "Select Month(ODate) As [Month], Sum(Total) As Total From vwDT Where Year(ODate)=" + year + " Group By Month(ODate)";
rs.Open(strSQL,oConn,3,1);
var total=0;
var jan=0,feb=0,mar=0,apr=0,may=0,jun=0,jul=0,aug=0,sep=0,oct=0,nov=0,dec=0;
while((!rs.BOF)&&(!rs.EOF))
{
var currAmount = parseFloat(rs.Fields("Total"));
var currMonth = parseInt(rs.Fields("Month"));
total+= currAmount;
switch (currMonth)
{
case 1: jan=currAmount;break;
case 2: feb=currAmount;break;
case 3: mar=currAmount;break;
case 4: apr=currAmount;break;
case 5: may=currAmount;break;
case 6: jun=currAmount;break;
case 7: jul=currAmount;break;
case 8: aug=currAmount;break;
case 9: sep=currAmount;break;
case 10: oct=currAmount;break;
case 11: nov=currAmount;break;
case 12: dec=currAmount;break;
default: break;
}
rs.MoveNext();
}
Jan=fixDecimalPlaces((jan/total)*100,1);
Feb=fixDecimalPlaces((feb/total)*100,1);
Mar=fixDecimalPlaces((mar/total)*100,1);
Apr=fixDecimalPlaces((apr/total)*100,1);
May=fixDecimalPlaces((may/total)*100,1);
Jun=fixDecimalPlaces((jun/total)*100,1);
Jul=fixDecimalPlaces((jul/total)*100,1);
Aug=fixDecimalPlaces((aug/total)*100,1);
Sep=fixDecimalPlaces((sep/total)*100,1);
Oct=fixDecimalPlaces((oct/total)*100,1);
Nov=fixDecimalPlaces((nov/total)*100,1);
Dec=fixDecimalPlaces((dec/total)*100,1);
%>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Report</title>
<body topmargin="0" rightmargin="0" leftmargin="0" bottommargin="0">
<div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0" background="images/menu_left_bg.gif">
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td width="160" background="images/menu_left_bg.gif" style="background-repeat:repeat "><!--#include file="lib/inc_menuleft.asp"--></td>
<td align="left" valign="top" bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="top" bgcolor="#004182" style="padding-top:5px; padding-bottom:10px; ">
<strong><font color="#FFFFFF" face="arial, tahoma, verdana"; size="5">BÁO CÁO DOANH THU</font></strong>
</td>
</tr>
</table></td>
</tr>
<tr>
<script>
function submitFrm()
{
document.frm.submit();
}
</script>
<form name="frm" action="" method="post">
<td height="25" align="left" valign="middle" style="padding-top:10; padding-bottom:10; ">
Chọn năm: <select name="year" class="textbox" onChange="submitFrm();">
<option value="">YEAR</option>
<%
var iYear;
for(iYear=2002;iYear<=maxYear;iYear++)
{
%>
<option value="<%=iYear%>" <%if(year==iYear){Response.Write('Selected');}%>><%=iYear%></option>
<%}%>
</select>
</td>
</form>
</tr>
<tr>
<td height="33" align="center" valign="middle" style=" padding-bottom:10; "><strong>CHI TIẾT DOANH THU CỦA CÔNG TY TRONG NĂM <%=year%></strong></td>
</tr>
<tr>
<td style=" padding-left:15px; padding-right:5px; " align="center" valign="middle"><table style="border-collapse:collapse " width="70%%" border="1" cellspacing="0" cellpadding="3">
<tr bgcolor="#000066">
<td align="center" valign="middle"><b>
<font face="Verdana" size="2" color="#FFFFFF">QUÝ</font></b></td>
<td align="center" valign="middle"><b>
<font face="Verdana" size="2" color="#FFFFFF">THÁNG</font></b></td>
<td width="44%" align="center" valign="middle"><b>
<font face="Verdana" size="2" color="#FFFFFF">DOANH THU<br>(USD)</font></b> </td>
<td width="30%" align="center" valign="middle"><b>
<font face="Verdana" size="2" color="#FFFFFF">TỔNG CỘNG<br>(USD)</font></b></td>
</tr>
<tr valign="middle">
<td width="16%" rowspan="3" align="center" bgcolor="#FFDDAA"><strong>I</strong></td>
<td width="10%" align="center">1</td>
<td align="center" class="list"><strong><%=fixDecimalPlaces(jan,2)%></strong></td>
<td rowspan="3" align="right" class="tdReport"><%=fixDecimalPlaces(jan+feb+mar,2)%></td>
</tr>
<tr valign="middle">
<td align="center">2</td>
<td align="center" class="list"><strong><%=fixDecimalPlaces(feb,2)%></strong></td>
</tr>
<tr valign="middle">
<td align="center">3</td>
<td align="center" class="list"><strong><%=fixDecimalPlaces(mar,2)%></strong></td>
</tr>
<tr valign="middle" bgcolor="#F9F9FF">
<td align="center"> </td>
<td align="center"> </td>
<td align="left"> </td>
<td align="right"> </td>
</tr>
<tr valign="middle">
<td width="16%" rowspan="3" align="center" bgcolor="#FFDDAA"><strong>II</strong></td>
<td width="10%" align="center">4</td>
<td align="center" class="list"><strong><%=fixDecimalPlaces(apr,2)%></strong></td>
<td rowspan="3" align="right" class="tdReport"><%=fixDecimalPlaces(apr+may+jun,2)%></td>
</tr>
<tr valign="middle">
<td align="center">5</td>
<td align="center" class="list"><strong><%=fixDecimalPlaces(may,2)%></strong></td>
</tr>
<tr valign="middle">
<td align="center">6</td>
<td align="center" class="list"><strong><%=fixDecimalPlaces(jun,2)%></strong></td>
</tr>
<tr valign="middle" bgcolor="#F9F9FF">
<td align="center"> </td>
<td align="center"> </td>
<td align="left"> </td>
<td align="right"> </td>
</tr>
<tr valign="middle">
<td width="16%" rowspan="3" align="center" bgcolor="#FFDDAA"><strong>III</strong></td>
<td width="10%" align="center">7</td>
<td align="center" class="list"><strong><%=fixDecimalPlaces(jul,2)%></strong></td>
<td rowspan="3" align="right" class="tdReport"><%=fixDecimalPlaces(jul+aug+sep,2)%></td>
</tr>
<tr valign="middle">
<td align="center">8</td>
<td align="center" class="list"><strong><%=fixDecimalPlaces(aug,2)%></strong></td>
</tr>
<tr valign="middle">
<td align="center">9</td>
<td align="center" class="list"><strong><%=fixDecimalPlaces(sep,2)%>
</strong></td>
</tr>
<tr valign="middle" bgcolor="#F9F9FF">
<td align="center"> </td>
<td align="center"> </td>
<td align="left"> </td>
<td align="right"> </td>
</tr>
<tr valign="middle">
<td width="16%" rowspan="3" align="center" bgcolor="#FFDDAA"><strong>IV</strong></td>
<td width="10%" align="center">10</td>
<td align="center" class="list"><strong><%=fixDecimalPlaces(oct,2)%></strong></td>
<td rowspan="3" align="right" class="tdReport"><%=fixDecimalPlaces(oct+nov+dec,2)%></td>
</tr>
<tr valign="middle">
<td align="center">11</td>
<td align="center" class="list"><strong><%=fixDecimalPlaces(nov,2)%></strong></td>
</tr>
<tr valign="middle">
<td align="center">12</td>
<td align="center" class="list"><strong><%=fixDecimalPlaces(dec,2)%></strong></td>
</tr>
<tr valign="middle">
<td height="26" colspan="3" align="right" bgcolor="#EBEBC2"><strong>Doanh thu cả năm</strong></td>
<td align="right" bgcolor="#EBEBC2"><strong><font color="darkblue"><%=total%></font></strong></td>
</tr>
</table></td>
</tr>
<tr>
<td height="33" align="center" valign="middle" style="padding-left:5px; padding-right:5px; "> </td>
</tr>
<tr>
<td height="44" align="center" valign="middle" style="padding-left:5px; padding-right:5px; "> </td>
</tr>
<tr>
<td style=" padding-right:5px; " align="center" valign="middle"><strong>BIỂU ĐỒ TỈ LỆ DOANH THU CỦA CÔNG TY TRONG NĂM <%=year%></strong></td>
</tr>
<tr>
<td align="left" valign="middle"><table width="70%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="52" align="center">
<b>Doanh thu<br>
%</b></td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
<td width="25" align="left"> </td>
</tr>
<tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -