📄 admin_total.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/gym.asp" -->
<!--#include file="inc/is_admin.asp" -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>预约统计</title>
<style type="text/css">
<!--
@import url("style.css");
-->
</style>
</head>
<%
'打开预约数据库--------------
set rs_preengage=server.CreateObject("adodb.recordset")
'取得预约总数-----------------
sql = "select count(*) as total from preengage "
rs_preengage.open sql,gym_conn,3,2
preengage_total=rs_preengage("total")
rs_preengage.close
'取得已付款预约总数-----------------
sql = "select count(*) as total from preengage where paid =1 "
rs_preengage.open sql,gym_conn,3,2
preengage_paid=rs_preengage("total")
rs_preengage.close
'取得未付款预约总数-----------------
preengage_notpaid = preengage_total - preengage_paid
'取得收入-----------------
sql = "select sum(cost) as total from preengage where paid =1"
rs_preengage.open sql,gym_conn,3,2
money = rs_preengage("total")
rs_preengage.close
'取得未付清预约款-----------------
sql = "select sum(cost) as total from preengage where paid =0"
rs_preengage.open sql,gym_conn,3,2
notmoney =rs_preengage("total")
rs_preengage.close
'场地排行榜前3名，这里对视图"ground_top3"进行查询-----------------
set ground_top3 = server.CreateObject("adodb.recordset")
sql = "select * from ground_top3 "
ground_top3.open sql,gym_conn,3,2
'用户预约数排行榜前3名
set user_top3 = server.CreateObject("adodb.recordset")
sql = "select top 3 user_name ,count(*) as total, sum (cost) as total_cost from preengage group by user_name order by total DESC "
user_top3.open sql,gym_conn,3,2
'打开用户资料数据库---------------
Set rs_user = Server.CreateObject("ADODB.Recordset")
'用户性别统计
sql = "select count(*) as male from user_reg where sex = '男'"
rs_user.Open sql,gym_conn,3,2
rs_user_male = rs_user("male")
rs_user.close
sql = "select count(*) as female from user_reg where sex = '女'"
rs_user.Open sql,gym_conn,3,2
rs_user_female = rs_user("female")
rs_user.close
rs_user_total = rs_user_male + rs_user_female
%>
<body>
<div align="center">
<table width="706" height="281" border="0" class="table_big">
<tr>
<td valign="top"><div align="center">
<!--#include file="inc/admin_head.asp" -->
<br>
<!-- 预约统计表格 -->
<table width="380" border="0" class="table_small">
<tr>
<td colspan="4"> </td>
</tr>
<tr>
<td colspan="4" class="text_title"><div align="left">预约统计</div></td>
</tr>
<tr>
<td colspan="4" class="table_title"> </td>
</tr>
<tr class="text">
<td width="70"><div align="left">预约总数：</div></td>
<td width="102"><div align="left"><%= preengage_total %></div></td>
<td width="89">已付款预约数：</td>
<td width="97"><div align="left"><%= preengage_paid %></div></td>
</tr>
<tr class="text">
<td><div align="left">实际收入：</div></td>
<td><div align="left"><%= money %></div></td>
<td>未付清预约款：</td>
<td class="text"><div align="left"><%= notmoney %></div></td>
</tr>
<tr class="text">
<td colspan="4"> </td>
</tr>
<tr class="text">
<td colspan="4"><div align="left"></div><div align="left"></div></td>
</tr>
</table>
<br>
<!-- 用户统计表格 -->
<table width="380" border="0" class="table_small">
<tr>
<td colspan="4"> </td>
</tr>
<tr>
<td colspan="4" class="text_title"><div align="left">用户统计</div></td>
</tr>
<tr>
<td colspan="4" class="table_title"> </td>
</tr>
<tr class="text">
<td><div align="left">用户总数：</div></td>
<td colspan="3"><div align="left"><%= rs_user_total %></div></td>
</tr>
<tr class="text">
<td width="75"><div align="left">男性比例：</div></td>
<td width="108"><div align="left"><%= (FormatNumber(rs_user_male/rs_user_total,4))*100 & "%" %></div></td>
<td width="74"><div align="left">女性比例：</div></td>
<td width="101"><div align="left"><%= (FormatNumber(rs_user_female/rs_user_total,4))*100 & "%" %></div></td>
</tr>
<tr class="text">
<td colspan="4"> </td>
</tr>
</table>
<br>
<!-- 热爱锻炼排行榜 -->
<table width="380" border="0" class="table_small">
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3" class="text_title"><div align="left"> 热爱锻炼排行榜</div></td>
</tr>
<tr>
<td colspan="3" class="table_title"> </td>
</tr>
<tr class="text">
<td width="150"><div align="left">用户名称</div></td>
<td width="93"><div align="left">预约总次数</div></td>
<td width="119"><div align="left">总消费额</div></td>
</tr>
<%
user_top3.movefirst
while (not user_top3.eof)
%>
<tr class="text">
<td><div align="left"><%= user_top3("user_name") %></div></td>
<td><div align="left"><%= user_top3("total") %></div></td>
<td><div align="left">
<div align="left"><%= user_top3("total_cost") %></div></td>
</tr>
<%
user_top3.movenext
wend
%>
<tr class="text">
<td colspan="3"><div align="left"></div><div align="left"></div></td>
</tr>
</table>
<br>
<!-- 热门场地排行榜 -->
<table width="380" border="0" class="table_small">
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3" class="text_title"><div align="left"> 热门场地排行榜</div></td>
</tr>
<tr>
<td colspan="3" class="table_title"> </td>
</tr>
<tr class="text">
<td width="171"><div align="left">场地名称</div></td>
<td width="86"><div align="left">费用</div></td>
<td width="105"><div align="left">预约总次数</div></td>
</tr>
<%
ground_top3.movefirst
while (not ground_top3.eof)
%>
<tr class="text">
<td><div align="left"><%= ground_top3("name") %></div></td>
<td><div align="left"><%= ground_top3("cost") %></div></td>
<td><div align="left"><%= ground_top3("total") %></div></td>
</tr>
<%
ground_top3.movenext
wend
%>
<tr class="text">
<td><div align="left"></div></td>
<td><div align="left"></div></td>
<td><div align="left"></div></td>
</tr>
</table>
<br>
<!--#include file="inc/foot.asp" -->
<br>
</div></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -