📄 order_report.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="admin_common.asp"-->
<!--#include file="../script/convertDate.asp"-->
<!--#include file="../script/fixNumber.asp"-->
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Order 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Ê HÓA ĐƠN</font></strong>
</td>
</tr>
</table></td>
</tr>
<tr>
<td align="center" valign="middle"> </td>
</tr>
<tr>
<td align="center" valign="middle"><span style="font-family:Arial, Tahoma, Verdana; font-weight:bold; color:#FF0000 ">
Danh sách các đơn hàng có tổng tiền lớn nhất</span></td>
</tr>
<tr>
<form name="frmlist" action="main_List_Order.asp" method="post">
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="middle" style="padding-bottom:10px; padding-left:5px; padding-top:15px; color:darkblue ">
<img src="images/around2.gif"> <strong>Các đơn hàng đã thanh toán</strong>
</td>
</tr>
<%
var rsTopS = Server.CreateObject("ADODB.Recordset");
var strSQL = "Select * From vwTop_10_seller Order By OID Desc";
rsTopS.Open(strSQL,oConn,3,1);
var dem=1;
var n=1;
%>
<tr>
<td style="padding-left:5px; padding-right:5px; ">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top"> <table style=" border:1px solid; border-collapse:collapse" width="100%" border="1" bordercolor="#FFFFFF" cellspacing="0" cellpadding="2">
<tr valign="middle" bgcolor="#008000">
<td width="32" align="center"><strong><font color="#FFFFFF" face="arial, tahoma, verdana" size="2">STT</font></strong></td>
<td width="67" align="center">
<strong><font color="#FFFFFF" face="arial, tahoma, verdana" size="2">Mã hóa đơn</font></strong>
</td>
<td width="89" align="center"><strong><font color="#FFFFFF" face="arial, tahoma, verdana" size="2">Ngày
đặt</font></strong></td>
<td width="270" align="center" bgcolor="#008000"><strong><font color="#FFFFFF" face="arial, tahoma, verdana" size="2">Tên
khách hàng</font></strong></td>
<td width="204" align="center"><strong><font color="#FFFFFF" face="arial, tahoma, verdana" size="2">Email</font></strong></td>
<td width="122" align="right"><strong><font color="#FFFFFF" face="arial, tahoma, verdana" size="2">Tổng
tiền</font></strong> <font color="#FFFFFF" face="arial, tahoma, verdana" size="2">(USD)</font></td>
</tr>
<%
while((!rsTopS.BOF)&&(!rsTopS.EOF))
{
if((n%2)==0)
{
%>
<tr class="list">
<td align="center" valign="middle"><%=dem%></td>
<td align="center" valign="middle"><strong><%=rsTopS.Fields("OID")%></strong></td>
<td width="89" align="center" valign="middle" class="list"><%=convertDate(rsTopS.Fields("ODate"))%></td>
<td width="270" align="left" valign="middle"><a href="#" class="command" onClick="Javascript:openPopup('popup_OrderDetail.asp?oid=<%=rsTopS.Fields("OID")%>');">
<%=rsTopS.Fields("CName")%></a></td>
<td align="left" valign="middle" class="list"><%=rsTopS.Fields("CEmail")%></td>
<td align="right" valign="middle"><font color="#FF0000" face="arial, tahoma, verdana" size="2"><%=fixDecimalPlaces(rsTopS.Fields("OTotal"),2)%></font></td>
</tr>
<%
} else {
%>
<tr bgcolor="#FFEFBF" class="list">
<td align="center" valign="middle"><%=dem%></td>
<td align="center" valign="middle"><strong><%=rsTopS.Fields("OID")%></strong></td>
<td width="89" align="center" valign="middle" class="list"><%=convertDate(rsTopS.Fields("ODate"))%></td>
<td width="270" align="left" valign="middle" bgcolor="#FFEFBF"><a href="#" class="command" onClick="Javascript:openPopup('popup_OrderDetail.asp?oid=<%=rsTopS.Fields("OID")%>');">
<%=rsTopS.Fields("CName")%></a></td>
<td align="left" valign="middle" class="list"><%=rsTopS.Fields("CEmail")%></td>
<td align="right" valign="middle" class="list"><font color="#FF0000" face="arial, tahoma, verdana" size="2">
<%=fixDecimalPlaces(rsTopS.Fields("OTotal"),2)%>
</font></td>
</tr>
<%
}
n++;
rsTopS.MoveNext();
dem++;
}rsTopS.Close();
%>
</table></td>
</tr>
<tr>
<td height="25"> </td>
</tr>
<%
var rsTopO = Server.CreateObject("ADODB.Recordset");
var strSQL = "Select * From vwTop_10_order Order By OID Desc";
rsTopO.Open(strSQL,oConn,3,1);
var dem1=1;
var n1=1;
if((!rsTopO.BOF)&&(!rsTopO.EOF)){
%>
<tr>
<td align="left" valign="middle" style="padding-bottom:10px; padding-top:15px; color:darkblue "><img src="images/around2.gif"> <strong>Các đơn hàng chưa thanh toán</strong>
</td>
</tr>
<tr><td><table width="100%%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top"> <table style=" border:1px solid; border-collapse:collapse" width="100%" border="1" cellspacing="0" cellpadding="2">
<tr valign="middle" bgcolor="#008000">
<td width="32" align="center"><strong><font color="#FFFFFF" face="arial, tahoma, verdana" size="2">STT</font></strong></td>
<td width="67" align="center">
<strong><font color="#FFFFFF" face="arial, tahoma, verdana" size="2">Mã hóa đơn</font></strong>
</td>
<td width="89" align="center"><strong><font color="#FFFFFF" face="arial, tahoma, verdana" size="2">Ngày
đặt</font></strong></td>
<td width="270" align="center"><strong><font color="#FFFFFF" face="arial, tahoma, verdana" size="2">Tên
khách hàng</font></strong></td>
<td width="204" align="center"><strong><font color="#FFFFFF" face="arial, tahoma, verdana" size="2">Email</font></strong></td>
<td width="122" align="right"><strong><font color="#FFFFFF" face="arial, tahoma, verdana" size="2">Tổng
tiền</font></strong> <font color="#FFFFFF" face="arial, tahoma, verdana" size="2">(USD)</font></td>
</tr>
<%
while((!rsTopO.BOF)&&(!rsTopO.EOF))
{
if((n1%2)==0)
{
%>
<tr class="list">
<td align="center" valign="middle"><%=dem1%></td>
<td align="center" valign="middle"><strong><%=rsTopO.Fields("OID")%></strong></td>
<td width="89" align="center" valign="middle" class="list"><%=rsTopO.Fields("ODate")%></td>
<td width="270" align="left" valign="middle"><a href="#" class="command" onClick="Javascript:openPopup('popup_OrderDetail.asp?oid=<%=rsTopO.Fields("OID")%>');">
<%=rsTopO.Fields("CName")%></a></td>
<td align="left" valign="middle" class="list"><%=rsTopO.Fields("CEmail")%></td>
<td align="right" valign="middle"><font color="#FF0000" face="arial, tahoma, verdana" size="2"><%=rsTopO.Fields("OTotal")%></font></td>
</tr>
<%
} else {
%>
<tr bgcolor="#FFEFBF" class="list">
<td align="center" valign="middle"><%=dem1%></td>
<td align="center" valign="middle"><strong><%=rsTopO.Fields("OID")%></strong></td>
<td width="89" align="center" valign="middle" class="list"><%=rsTopO.Fields("ODate")%></td>
<td width="270" align="left" valign="middle"><a href="#" class="command" onClick="Javascript:openPopup('popup_OrderDetail.asp?oid=<%=rsTopO.Fields("OID")%>');">
<%=rsTopO.Fields("CName")%></a></td>
<td align="left" valign="middle" class="list"><%=rsTopO.Fields("CEmail")%></td>
<td align="right" valign="middle" class="list"><font color="#FF0000" face="arial, tahoma, verdana" size="2">
<%=rsTopO.Fields("OTotal")%>
</font></td>
</tr>
<%
}
n1++;
rsTopO.MoveNext();
dem1++;
}rsTopO.Close();
%>
</table></td>
</tr>
</table></td></tr>
<%}%>
</table></td>
</tr>
</table></td>
</form>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -