📄 agent_cz_log.asp
字号:
<!--#include file="chklogin.asp"-->
<%
if request.QueryString("agent_id")="" or isnull(request.QueryString("agent_id"))=true then
response.write"<script language=javascript>alert('无法获取代理商账号');history.back();</Script>"
response.end
end if
if myobj.ChkID(request.QueryString("agent_id"))=false then
response.write"<script language=javascript>alert('代理商账号格式错误');history.back();</Script>"
response.end
end if
set rs=server.createobject("adodb.recordset")
rs.open "select * from agents where agent_id='"&request.Querystring("agent_id")&"'",conn,1,1
if rs.eof then
rs.close
set rs=nothing
conn.close
set conn=nothing
response.write"<script>alert('该代理商并不存在');history.back();</Script>"
response.end
end if
rs.close
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>代理商账号充值记录</title>
<link href="images/style2.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body,td,th {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
color: #000000;
}
a:link {
color: #0000FF;
text-decoration: none;
}
a:visited {
color: #0000FF;
text-decoration: none;
}
a:hover {
color: #FF0000;
text-decoration: underline;
}
a:active {
text-decoration: none;
}
-->
</style>
<script language="JavaScript">
function tourl(form1_url){
location=form1_url;
for(var i=0;i<document.form1.elements.length;i++){
document.form1.elements[i].options[0].selected=true
}
}
</script>
</head>
<body leftMargin="0" topMargin="0" bgcolor="#FFFFFF">
<table width="550" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="550" height="25" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#3975CE">
<tr>
<td align="center"><strong class="font1">代理商：<%=request.Querystring("agent_id")%> 账号充值记录</strong></td>
</tr>
</table>
<table width="550" height="30" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#E7E7E7">
<tr>
<form name="form2" method="GET" action="<%=filename%>">
<%
set rs=server.createobject("adodb.recordset")
rs.open "select top 1 * from cz_log where agent_id='"&request.Querystring("agent_id")&"' order by cz_time",conn,1,1
min_year=year(rs("cz_time"))
rs.close
max_year=year(now)
%>
<td align="center" bgcolor="#F7F7F7">查询日期为：
<select name="cz_year" class="select1">
<%
for y=min_year to max_year
%>
<option value="<%=y%>" <%if cint(year(now))=cint(y) then%>selected<%end if%>><%=y%>年</option>
<%
next
%>
</select>
<select name="cz_month" class="select1">
<option value="" <%if Request.Querystring("action")<>"" and Request.Querystring("cz_month")="" then%>selected<%end if%>>无条件</option>
<%
for m=1 to 12
%>
<option value="<%=m%>" <%if cint(month(now))=cint(m) then%>selected<%end if%>><%=m%>月</option>
<%
next
%>
</select>
<select name="cz_day" class="select1">
<option value="">无条件</option>
<%
for d=1 to 31
%>
<option value="<%=d%>" <%if cint(day(now))=cint(d) then%>selected<%end if%>><%=d%>日</option>
<%
next
%>
</select>
的充值记录
<input name="action" type="hidden" id="action" value="search_time">
<input name="agent_id" type="hidden" id="agent_id" value="<%=request.Querystring("agent_id")%>">
<input name="Submit" type="submit" class="button1" value="确定">
<input name="button" type="button" class="button1" id="button" value="所有记录" onclick="self.location='agent_cz_log.asp?agent_id=<%=request.Querystring("agent_id")%>';"></td>
</form>
</tr>
</table>
<table width="550" height="30" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#E7E7E7">
<tr>
<form name="form2" method="GET" action="agent_czlog_del.asp?agent_id=<%=request.querystring("agent_id")%>" target="_blank">
<%
set rs=server.createobject("adodb.recordset")
rs.open "select top 1 * from cz_log where agent_id='"&request.Querystring("agent_id")&"' order by cz_time",conn,1,1
min_year=year(rs("cz_time"))
rs.close
max_year=year(now)
%>
<td align="center" bgcolor="#F7F7F7">删除该代理商：
<select name="cz_year" class="select1">
<%
for y=min_year to max_year
%>
<option value="<%=y%>" <%if cint(year(now))=cint(y) then%>selected<%end if%>><%=y%>年</option>
<%
next
%>
</select>
<select name="cz_month" class="select1">
<option value="" <%if Request.Querystring("action")<>"" and Request.Querystring("cz_month")="" then%>selected<%end if%>>无条件</option>
<%
for m=1 to 12
%>
<option value="<%=m%>" <%if cint(month(now))=cint(m) then%>selected<%end if%>><%=m%>月</option>
<%
next
%>
</select>
之前的所有充值记录
<input name="action" type="hidden" id="action" value="search_time">
<input name="agent_id" type="hidden" id="agent_id" value="<%=request.Querystring("agent_id")%>">
<input name="Submit" type="submit" class="button1" value="删除">
</td>
</form>
</tr>
</table>
<%
if Request("action")="" then
set rs=server.createobject("adodb.recordset")
rs.open "select sum(cz_money) from cz_log where agent_id='"&request.Querystring("agent_id")&"'",conn,1,1
stat_money=rs(0)
rs.close
set rs=server.createobject("adodb.recordset")
rs.open "select * from cz_log where agent_id='"&request.Querystring("agent_id")&"' order by id desc",conn,1,1
end if
if Request("action")="search_time" then
if isnull(Request.Querystring("cz_year"))=false and myobj.ChkNum(request.querystring("cz_year"))=false then
response.write"<script language=javascript>alert('年份值类型错误');history.back();</Script>"
response.end
end if
if isnull(Request.Querystring("cz_month"))=false and myobj.ChkNum(Request.Querystring("cz_month"))=false then
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -