📄 default.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="admin_common.asp"-->
<!--#include file="../script/fixNumber.asp"-->
<%
var strSQL1 = "Select Count(CID) As TotalCust1 From vwCust";
rsCount_cust1 = oConn.Execute(strSQL1);
var strSQL2 = "Select Count(CID) As TotalCust2 From vwCust Where CDelete=1";
rsCount_cust2 = oConn.Execute(strSQL2);
var strSQL3= "Select Count(CID) As TotalCust3 From vwCust Where CDelete=0";
rsCount_cust3 = oConn.Execute(strSQL3);
var strSQL_1 = "Select Count(Distinct OID) As TotalOrder_1 From vwOrder";
rsCount_1 = oConn.Execute(strSQL_1);
var strSQL_2 = "Select Count(Distinct OID) As TotalOrder_2 From vwOrder Where OStatus=1 And ODelete=1";
rsCount_2 = oConn.Execute(strSQL_2);
var strSQL_3 = "Select Count(Distinct OID) As TotalOrder_3 From vwOrder Where OStatus=0 And ODelete=1";
rsCount_3 = oConn.Execute(strSQL_3);
var strSQL_4 = "Select Count(Distinct OID) As TotalOrder_4 From vwOrder Where ODelete=0";
rsCount_4 = oConn.Execute(strSQL_4);
var strSQL_sp1 = "Select Count(PID) As TotalPro_1 From vwProduct";
rsCount_sp1= oConn.Execute(strSQL_sp1);
var strSQL_sp2 = "Select Count(SubID) As TotalSub From vwSubCat Where SDelete=1";
rsCount_sp2= oConn.Execute(strSQL_sp2);
var strSQL_sp3 = "Select Count(Distinct CatID) As TotalCat From vwSubCat Where CatDelete=1";
rsCount_sp3= oConn.Execute(strSQL_sp3);
var strSQL_sp4 = "Select Count(PID) As TotalPro_2 From vwProduct Where PBestSeller>0";
rsCount_sp4= oConn.Execute(strSQL_sp4);
var strSQL_sp5 = "Select Count(PID) As TotalPro_3 From vwProduct Where PBestOrder>0";
rsCount_sp5 = oConn.Execute(strSQL_sp5);
var strSQL_dt = "Select Sum(OTotal) As DT From tblOrder Where OStatus=1 And ODelete=1";
rsCount_dt = oConn.Execute(strSQL_dt);
%>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Admin</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 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 CHUNG</font></strong>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%"> </td>
<td align="left" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top" height="15" width="20%" class="menubody">Khách hàng</td>
</tr>
<tr>
<td>
<table width="100%" border="1" style="border:1px; border-collapse:collapse; " bordercolor="#0066CC" cellspacing="0" cellpadding="3" class="menubody_down">
<tr align="left" valign="top">
<td width="25%" style="padding-bottom:5px; padding-top:3px; ">
<font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Tổng số thành viên</strong>
</font>
</td>
<td align="left"><%=rsCount_cust1.Fields("TotalCust1")%></td>
</tr>
<tr align="left" valign="top" bgcolor="#FFF0D2">
<td width="25%" style="padding-bottom:5px; padding-top:3px; ">
<font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Đã kích hoạt</strong>
</font>
</td>
<td align="left"><%=rsCount_cust2.Fields("TotalCust2")%></td>
</tr>
<tr align="left" valign="top">
<td width="25%" style="padding-bottom:5px; padding-top:3px; ">
<font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Chưa kích hoạt</strong>
</font>
</td>
<td align="left"><%=rsCount_cust3.Fields("TotalCust3")%></td>
</tr>
<tr align="left" valign="top" bgcolor="#FFF0D2">
<td width="25%" style="padding-bottom:5px; padding-top:3px; ">
<font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Tổng số lượt truy cập</strong>
</font>
</td>
<td align="left"><%=Application("visitors")%></td>
</tr>
<tr align="left" valign="top">
<td width="25%" style="padding-bottom:5px; padding-top:3px; ">
<font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Số khách đang Online</strong>
</font>
</td>
<td align="left"><%=Application("online")%></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td align="left" valign="top" height="15" width="20%" class="menubody">Hóa đơn</td>
</tr>
<tr>
<td><table width="100%" border="1" style="border:1px; border-collapse:collapse; " bordercolor="#0066CC" cellspacing="0" cellpadding="3" class="menubody_down">
<tr align="left" valign="top">
<td width="25%" style="padding-bottom:5px; padding-top:3px; ">
<font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Tổng số hóa đơn</strong>
</font>
</td>
<td align="left"><%=rsCount_1.Fields("TotalOrder_1")%></td>
</tr>
<tr bgcolor="#FFF5E1">
<td style="padding-bottom:5px; padding-top:3px; "><font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Đã thanh toán</strong>
</font></td>
<td><%=rsCount_2.Fields("TotalOrder_2")%></td>
</tr>
<tr>
<td style="padding-bottom:5px; padding-top:3px; "><font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Chưa thanh toán</strong>
</font></td>
<td><%=rsCount_3.Fields("TotalOrder_3")%></td>
</tr>
<tr bgcolor="#FFF5E1">
<td style="padding-bottom:5px; padding-top:3px; "><font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Trong kho</strong>
</font></td>
<td><%=rsCount_4.Fields("TotalOrder_4")%></td>
</tr>
<tr>
<td style="padding-bottom:5px; padding-top:3px; "><font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Tổng doanh thu</strong>
</font></td>
<td><%=fixDecimalPlaces(rsCount_dt.Fields("DT"),2)%> <font color="#FF0000">(USD)</font></td>
</tr> </table></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top" height="15" width="20%" class="menubody">Sản phẩm</td>
</tr>
<tr>
<td><table width="100%" border="1" style="border:1px; border-collapse:collapse; " bordercolor="#0066CC" cellspacing="0" cellpadding="3" class="menubody_down">
<tr align="left" valign="top">
<td width="25%" style="padding-bottom:5px; padding-top:3px; ">
<font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Tổng số nhóm hàng</strong>
</font>
</td>
<td align="left"><%=rsCount_sp3.Fields("TotalCat")%></td>
</tr>
<tr bgcolor="#FFFCF4">
<td style="padding-bottom:5px; padding-top:3px; "><font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Tổng số loại hàng</strong>
</font></td>
<td><%=rsCount_sp2.Fields("TotalSub")%></td>
</tr>
<tr>
<td style="padding-bottom:5px; padding-top:3px; "><font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Tổng số hàng</strong>
</font></td>
<td><%=rsCount_sp1.Fields("TotalPro_1")%></td>
</tr>
<tr bgcolor="#FFFCF4">
<td style="padding-bottom:5px; padding-top:3px; "><font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Số hàng đã bán</strong>
</font></td>
<td><%=rsCount_sp4.Fields("TotalPro_2")%></td>
</tr>
<tr>
<td style="padding-bottom:5px; padding-top:3px; "><font color="#000000" face="arial, tahoma, verdana" size="2">
<strong>Số lượng hàng đặt</strong>
</font></td>
<td><%=rsCount_sp5.Fields("TotalPro_3")%></td>
</tr> </table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top"> </td>
</tr>
<tr>
<td> </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 + -