📄 product_report.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="admin_common.asp"-->
<!--#include file="../script/fixNumber.asp"-->
<SCRIPT language=javascript>
function explorer(iself,name1,name2,divID) {
if (iself.src.lastIndexOf(name1)==iself.src.length-name1.length) {
iself.src = name2;
document.all[divID].style.display='';
}
else {
iself.src = name1;
document.all[divID].style.display='none';
}
}
</SCRIPT>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Product 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">THỐNG KÊ SẢN PHẨM</font></strong>
</td>
</tr>
</table></td>
</tr>
<tr>
<td height="33" align="center" valign="middle"> </td>
</tr>
<tr>
<td style="padding-left:5px; padding-right:5px; " align="left" valign="top"><table width="100%%" border="0" cellspacing="0" cellpadding="0">
<tr align="center" valign="middle" bgcolor="#FFCC99">
<td width="3%"><strong><font face="arial, tahoma, verdana" size="2">STT</font></strong></td>
<td width="3%"> </td>
<td width="56%" align="left" style="padding-left:4px; "><strong><font face="arial, tahoma, verdana" size="2">Tên nhóm hàng</font></strong></td>
<td width="17%" align="left" style="padding-left:4px; "><strong><font face="arial, tahoma, verdana" size="2">Doanh thu <span style="color:#FF0000 ">(USD)</span></font></strong></td>
<td width="21%" align="center" style="padding-left:4px; "><strong><font face="arial, tahoma, verdana" size="2">Đã bán</font></strong></td>
</tr>
<tr>
<td colspan="5"><hr noshade size="1"></td>
</tr>
<%
var rsSP = Server.CreateObject("ADODB.Recordset");
var strSQL = "Select Sum(PBestSeller) As Count, Sum(PPrice*PBestSeller) As Total, CatName, CatID From vwProduct Group by CatID,CatName Order By Total Desc";
rsSP.Open(strSQL,oConn,3,1);
rsSP.PageSize=3;
var totalPage = rsSP.PageCount;
var intCurrentPage;
var i;
if(isNaN(Request.QueryString("page")))
{
intCurrentPage = 1;
}
else
{
intCurrentPage = parseInt(Request.QueryString("page"));
}
if (totalPage > 0)
{
rsSP.AbsolutePage = parseInt(intCurrentPage);
}
else
{
intCurrentPage = 0;
}
i=1;
var dem=1;
while((!rsSP.BOF)&&(!rsSP.EOF))
{
%>
<tr valign="middle" style="padding-bottom:3px; padding-top:3px; ">
<td align="center"><%=rsSP.PageSize * (intCurrentPage-1) + dem%></td>
<td align="center"><%if(rsSP.Fields("Count")>0){%><img name="image<%=dem%>" onClick="explorer(this,'images/plus.gif','images/sub.gif','div<%=dem%>');" src="images/plus.gif" width="9" height="9">
<%}%>
</td>
<td align="left" style="padding-left:4px; color:darkblue "><%=rsSP.Fields("CatName")%>
</td>
<td align="left" style="padding-left:4px; color:darkblue "><%=rsSP.Fields("Total")%></td>
<td align="center" style="padding-left:4px; color:darkblue "><%=rsSP.Fields("Count")%></td>
</tr>
<tr style="padding-bottom:3px; padding-top:3px; display:none" id="div<%=dem%>">
<td colspan="2" align="center" valign="middle"> </td>
<td colspan="3" align="left" valign="top" style="padding-left:4px; color:darkblue "><table width="100%%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#FFEFBF">
<td width="3%"><strong><font face="arial, tahoma, verdana" size="2" color="#0066FF">STT</font></strong></td>
<td width="1%"> </td>
<td width="55%" align="left" bgcolor="#FFEFBF" style="padding-left:4px; "><strong><font face="arial, tahoma, verdana" size="2" color="#0066FF">Tên loại hàng</font></strong></td>
<td width="20%" align="left" style="padding-left:4px; "><strong><font face="arial, tahoma, verdana" size="2" color="#0066FF">Doanh thu <span style="color:#FF0000 ">(USD)</span></font></strong></td>
<td width="21%" align="center" style="padding-left:4px; "><strong><font face="arial, tahoma, verdana" size="2" color="#0066FF">Đã bán</font></strong></td>
</tr>
<tr>
<td colspan="5"><hr noshade size="1"></td>
</tr>
<%
var rsSP2 = Server.CreateObject("ADODB.Recordset");
var strSQL = "Select Sum(PBestSeller) As Count, Sum(PPrice*PBestSeller) As Total, SubName, SubID From vwProduct ";
strSQL+= " Where CatID=" + parseInt(rsSP.Fields('CatID')) + " Group by SubID, SubName Order By Total Desc";
rsSP2.Open(strSQL,oConn,3,1);
var dem2=1;
while((!rsSP2.BOF)&&(!rsSP2.EOF))
{
%>
<tr style="padding-bottom:3px; padding-top:4px; ">
<td align="center" valign="middle"><%=dem2%></td>
<td align="center" valign="middle"></td>
<td align="left" valign="top" style="padding-left:4px; color: #996600 "><%=rsSP2.Fields("SubName")%></td>
<td align="left" valign="top" style="padding-left:4px; color:darkblue "><%=fixDecimalPlaces(rsSP2.Fields("Total"),2)%></td>
<td align="center" valign="top" style="padding-left:4px; color:darkblue "><%=rsSP2.Fields("Count")%></td>
</tr>
<%
dem2++;
rsSP2.MoveNext();}rsSP2.Close();
%>
</table></td>
</tr>
<%
if(i==rsSP.PageSize)
{
break;
}
i++;
dem++;
rsSP.MoveNext();}
%>
<tr>
<td colspan="5" align="center" valign="middle"><table width="100%%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
<%if (rsSP.PageCount > 1){%>
<tr>
<td align="center" valign="top">
<%
var intCount;
if(intCurrentPage>1)
Response.Write("<a href=?page=" + (intCurrentPage-1) + ">Trước</a>" + " |");
else
Response.Write("<font color='#999999' size='2'>Trước</font> |");
for(intCount = 1;intCount<=rsSP.PageCount;intCount++)
{
if (intCount == intCurrentPage)
Response.Write("<font color='#DD0000' size='2'>" + " " + intCount + "</font>" + " | ");
else{
Response.Write("<a href=?page=" + intCount + ">" + " " + intCount + "</a> " + " | ");
}
}
if(intCurrentPage!=rsSP.PageCount)
Response.Write("<a href=?page=" + (intCurrentPage+1) + ">Sau</a>");
else
Response.Write(" <font color='#999999' size='2'>Sau</font>");
%>
</td>
</tr>
<tr>
<td height="18" align="center" valign="top"><font color="darkblue" face="arial, tahoma, verdana" size="2">
Trang <%=intCurrentPage%>/ <%=rsSP.PageCount%></font>
</td>
</tr>
<%}rsSP.Close();%>
<tr>
<td> </td>
</tr>
<tr><td align="center" valign="middle"><span style="font-family:Arial, Tahoma, Verdana; font-weight:bold; color:#FF0000 ">
Danh sách 10 sản phẩm bán chạy nhất</span></td>
</tr>
<tr>
<td> </td>
</tr>
<%
var rsBS = Server.CreateObject("ADODB.Recordset");
var strSQL = "Select * From vwTop_10_Pro_seller";
rsBS.Open(strSQL,oConn,3,1);
%>
<tr>
<td align="left" valign="top">
<table style=" border:1px solid; border-collapse:collapse" width="100%" border="1" bordercolor="#0066CC" cellspacing="2" cellpadding="4">
<tr valign="top">
<td width="35" align="center"><strong><font face="arial, tahoma, verdana" size="2">Mã</font></strong></td>
<td width="441" align="center"><strong><font face="arial, tahoma, verdana" size="2">Tên sản phẩm</font></strong></td>
<td width="60" align="center"><strong><font face="arial, tahoma, verdana" size="2">Giá</font></strong><br>
<font color="#FF0000" size="1" face="arial, tahoma, verdana">(USD)</font></td>
<td width="133" align="center"><strong><font face="arial, tahoma, verdana" size="2">Hãng sản xuất</font></strong></td>
<td width="73" align="center"><strong><font face="arial, tahoma, verdana" size="2">Bảo hành</font></strong><br>
<font size="1" color="#FF0000" face="arial, tahoma, verdana">(Tháng)</font></td>
<td width="49" align="center"><strong><font face="arial, tahoma, verdana" size="2">Đã bán</font></strong></td>
</tr>
<%
var n=1;
while((!rsBS.BOF)&&(!rsBS.EOF))
{
if((n%2)==0)
{
%>
<tr>
<td align="left" valign="middle" class="list"><%=rsBS.Fields("PID")%></td>
<td align="left" valign="top" class="list"><a href="#" onClick="JavaScript:openPopup('popup_ProductDetail.asp?proID=<%=rsBS.Fields('PID')%>');" class="product"><%=rsBS.Fields("PName")%><%if(rsBS.Fields('PNew')==1){Response.Write(' <img src="../images/new.gif" border=0>');}%></a></td>
<td align="center" valign="top" class="list"><%=rsBS.Fields("PPrice")%></td>
<td width="133" align="center" valign="top" class="list"><%=rsBS.Fields("PCompany")%></td>
<td width="73" align="center" valign="middle" class="list"><%=rsBS.Fields("PWarranty")%></td>
<td align="center" valign="middle" class="list"><font color="#0066FF"><strong><%=rsBS.Fields("PBestSeller")%></strong></font></td>
</tr>
<%
} else {
%>
<tr bgcolor="#FFEFBF">
<td align="left" valign="middle" class="list"><%=rsBS.Fields("PID")%></td>
<td align="left" valign="top" bgcolor="#FFEFBF" class="list"><a href="#" onClick="JavaScript:openPopup('popup_ProductDetail.asp?proID=<%=rsBS.Fields('PID')%>');" class="product"><%=rsBS.Fields("PName")%><%if(rsBS.Fields('PNew')==1){Response.Write(' <img src="../images/new.gif" border=0>');}%></a></td>
<td align="center" class="list"><%=rsBS.Fields("PPrice")%></td>
<td width="133" align="center" valign="middle" class="list"><%=rsBS.Fields("PCompany")%></td>
<td align="center" valign="middle" class="list"><%=rsBS.Fields("PWarranty")%></td>
<td align="center" valign="middle" class="list"><font color="#FF0000"><strong><%=rsBS.Fields("PBestSeller")%></strong></font></td>
</tr>
<%
}
n++;
rsBS.MoveNext();
}
%>
</table></td></tr>
<tr>
<td> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -