📄 paiming.asp
字号:
<%
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''版权：野马原创 ''''
''''联系：ctplr@163.com ''''
''''说明：需要新功能联系我 ''''
''''QQ:2643148 ''''
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
%>
<!--#include file="check.asp"-->
<!--#include file="conn.asp"-->
<link href=left.css rel=stylesheet>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<%
if session("qx")<4 and session("qx")>0 then
act=request("act")
if act="" then
act="dft"
end if
if act="dft" then
%>
<center>
<form action="?act=paiming" method=post name=frm>
<table border='1' bordercolor='#0055aa' width="90%"><br>
<tr align="center" >
<td height="23" colspan="4" class=tdhead>
<img src="../images/User.gif" width="19" height="20">逐项手动排名
</td>
</tr>
<tr >
<td height="5" colspan="4" align="center" background="../images/loginLine.gif" > </td>
</tr>
<tr><td colspan="2" align="center" class=td1 >工 作 组
<select name="ptype" >
<option value=0>选择工作组</option>
<%
sql="select * from type"
rs1.open sql,cn,1,1
do while not rs1.eof
tname=rs1("typename")
%>
<option value=<%=rs1("type")%> ><%=tname%>
<%
rs1.movenext
loop
rs1.close
%>
</select>
排名数目<input type=text name=nnum size=6 value=10>
</td> <td class=td2><b>排名项目<Br></b></td>
<td valign=top class=td1>
<input type=radio name=ltype checked value=签到><font color=yellow>月签到数
<input type=radio name=ltype value=所有签到>总签到数</font>
<input type=radio name=ltype value=迟到><font color=#ff6600>月迟到数
<input type=radio name=ltype value=所有迟到>总迟到数</font><br>
</td></tr>
<tr > <td colspan=4 align=center class=td2>
<font color=#ffaa00>管理者是否参加排名 <input type=radio value=是 name=xz <%if session("qx")>3 then%> disabled<%end if%> >是 <input type=radio value=否 name=xz <%if session("qx")>3 then%> disabled<%end if%> checked>否
</font> </td>
</tr>
<tr > <td colspan=4 align=center class=td1>
<input type=radio value=page name=way checked>排名到页面预览<input type=radio value=db name=way <%if session("qx")>3 then%> disabled<%end if%>>排名并记录到数据库
</td>
</tr>
<tr >
<td height="5" colspan="4" align="center" bordercolor="#FF9900" background="../images/loginLine.gif" > </td>
</tr>
<tr><td colspan=4 align=center class=td3> <input type=submit value=开始排名 class=dbox > </td></tr>
</table>
</form>
</center>
<p></p><p></p>
<center>
<form action="?act=look" method=post name=frm>
<table border="1" bordercolor="#0055aa" width="90%"><br>
<tr align="center" >
<td height="23" colspan="4" class=tdhead>
<img src="../images/User.gif" width="19" height="20">查看数据库排名记录
</td>
</tr>
<tr >
<td height="5" colspan="4" align="center" bordercolor="#FF9900" background="../images/loginLine.gif" >
</td>
</tr>
<tr><td colspan="2" align="center" class=td2>察看<select name="ptype" >
<option value=0>选择工作组</option>
<%
sql="select * from type"
rs1.open sql,cn,1,1
do while not rs1.eof
tname=rs1("typename")
%>
<option value=<%=rs1("type")%> ><%=tname%>
<%
rs1.movenext
loop
rs1.close
%>
</select>前<input type=text name=nnum value=50 size=4 class=ebox>名<br>
</td> <td rowspan=2 class=td1>排名项目<Br></td>
<td class=td2 rowspan=2 valign=center>
<input type=radio name=ltype checked value="签到"><font color=yellow>月签到数
<input type=radio name=ltype value="所有签到">总签到数</font>
<input type=radio name=ltype value="迟到"><font color=#ff6600>月迟到数
<input type=radio name=ltype value="所有迟到">总迟到数</font><br>
</td></tr>
<tr >
</tr>
<tr >
<td height="5" colspan="4" align="center" background="../images/loginLine.gif" > </td>
</tr>
<tr><td colspan=4 align=center class=td3> <input type=submit value=查看排名 class=dbox > </td></tr>
</table>
</form>
</center>
<!--
<center>
<form action="?act=onekey" method=post name=frm>
<table border="1" bordercolor="#0055aa" width="90%"><br>
<tr align="center" >
<td height="23" colspan="4" class=tdhead>
<img src="../images/User.gif" width="19" height="20">一键排名
</td>
</tr>
<tr >
<td height="23" colspan="4" class=td2>
<ul>注意：
<li>在数据比较多的时候一键排名功能可能使电脑变慢
<li>建议选择没有登陆者的时候进行该操作
</ul>
</td>
</tr>
<tr align="center" >
<td height="23" colspan="4" class=td3>
<font color=yellow>排名数目</font><input type=text size='4' value='10' class='ebox' name='nnum'> <input type=submit value=开始一键排名 class=dbox >
</td>
</tr>
</table>
</form>
</center>
-->
<%end if
if act="paiming" then
if request("way")="page" then
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''排名到页面'''''''''''''''''''''''''''''''''
if request("ptype")=0 then
response.write "<script>alert('请选择工作组');history.back();</script>"
else
num=request.form("nnum")
if num=empty or num<1 then
num=10
end if
n=1
ptype=int(request("ptype"))
ltype=request("ltype")
sql="select * from type where type="&ptype
rs1.open sql,cn,1,1
gamename=rs1("typename")
rs1.close
if ltype="考勤" then
if request.form("xz")="否" then
sql="select * from ct_sql where type="&ptype&" and qx=5 order by monthfen desc"
else
sql="select * from ct_sql where type="&ptype&" order by monthfen desc"
end if
rs.open sql,cn,1,1
%>
<center><p align=center><font color=#ff6600 size=5><br> <%=gamename%> <%=ltype%> 排名</font> [<a href=# onclick="history.back()">返回</A>]</p>
<TABLE border=1 bordercolor=#0055aa >
<tr><td class=tdhead align=center><b>排名</b></td>
<td class=tdhead align=center><b>登陆帐号</b></td>
<td class=tdhead align=center><b>真实姓名</b></td>
<td class=tdhead align=center><b>本月考勤分</b></td>
</tr>
<% do while (not rs.eof and n<num+1)
pname=rs("username")
realname=rs("realname")
monthfen=rs("monthfen")
%>
<tr><td align=center class=td2><font color=#00ffcc><%=n%></td>
<td align=center class=td1><%=pname%></td>
<td align=center class=td2><%=realname%></td>
<td align=center class=td1><font color=#ff6600> <%=monthfen%> </td></tr>
<%
rs.movenext
n=n+1
loop
response.write "</TABLE>"
end if
if ltype="所有考勤" then
if request.form("xz")="否" then
sql="select * from ct_sql where type="&ptype&" and qx=5 order by allfen desc"
else
sql="select * from ct_sql where type="&ptype&" order by allfen desc"
end if
rs.open sql,cn,1,1
%>
<center><p align=center><font color=#ff6600 size=5><br> <%=gamename%><%=ltype%>排名</font> [<a href=# onclick="history.back()">BACK</A>]</p>
<TABLE border=1 bordercolor=#0055aa >
<tr><td class=tdhead align=center><b>排名</b></td>
<td class=tdhead align=center><b>登陆帐号</b></td>
<td class=tdhead align=center><b>真实姓名</b></td>
<td class=tdhead align=center><b>所有考勤分</b></td></tr>
<% do while (not rs.eof and n<num+1)
pname=rs("username")
realname=rs("realname")
allfen=rs("allfen")
%>
<tr><td align=center class=td2><font color=#00ffcc class=td2><%=n%></td>
<td align=center class=td1><%=pname%></td>
<td align=center class=td2><%=realname%></td>
<td align=center class=td1><font color=#ff6600> <%=allfen%> </td></tr>
<%
rs.movenext
n=n+1
loop
response.write "</TABLE>"
end if
if ltype="签到" then
if request.form("xz")="否" then
sql="select * from ct_sql where type="&ptype&" and qx=5 order by monthqdnum desc"
else
sql="select * from ct_sql where type="&ptype&" order by monthqdnum desc"
end if
rs.open sql,cn,1,1
%>
<center><p align=center><font color=#ff6600 size=5><br> <%=gamename%><%=ltype%>排名</font> [<a href=# onclick="history.back()">BACK</A>]</p>
<TABLE border=1 bordercolor=#0055aa>
<tr><td class=tdhead align=center><b>排名</b></td>
<td class=tdhead align=center><b>登陆帐号</b></td>
<td class=tdhead align=center><b>真实姓名</b></td>
<td class=tdhead align=center><b>本月签到</b></td></tr>
<% do while (not rs.eof and n<num+1)
pname=rs("username")
realname=rs("realname")
monthqdnum=rs("monthqdnum")
%>
<tr><td align=center class=td2><font color=#00ffcc><%=n%></td>
<td align=center class=td1><%=pname%></td>
<td align=center class=td2><%=realname%></td>
<td align=center class=td1><font color=#ff6600> <%=monthqdnum%> 次 </td></tr>
<%
rs.movenext
n=n+1
loop
response.write "</TABLE>"
end if
if ltype="所有签到" then
if request.form("xz")="否" then
sql="select * from ct_sql where type="&ptype&" and qx=5 order by allqdnum desc"
else
sql="select * from ct_sql where type="&ptype&" order by allqdnum desc"
end if
rs.open sql,cn,1,1
%>
<center><p align=center><font color=#ff6600 size=5><br> <%=gamename%><%=ltype%>排名</font> [<a href=# onclick="history.back()">BACK</A>]</p>
<TABLE border=1 bordercolor=#0055aa >
<tr><td class=tdhead align=center><b>排名</b></td>
<td class=tdhead align=center><b>登陆帐号</b></td>
<td class=tdhead align=center><b>真实姓名</b></td>
<td class=tdhead align=center><b>所有签到</b></td></tr>
<% do while (not rs.eof and n<num+1)
pname=rs("username")
realname=rs("realname")
allqdnum=rs("allqdnum")
%>
<tr><td align=center class=td2><font color=#00ffcc><%=n%></td>
<td align=center class=td1><%=pname%></td>
<td align=center class=td2><%=realname%></td>
<td align=center class=td1><font color=#ff6600> <%=allqdnum%>次 </td></tr>
<%
rs.movenext
n=n+1
loop
response.write "</TABLE>"
end if
if ltype="迟到" then
if request.form("xz")="否" then
sql="select * from ct_sql where type="&ptype&" and qx=5 order by monthlattertime desc"
else
sql="select * from ct_sql where type="&ptype&" order by monthlattertime desc"
end if
rs.open sql,cn,1,1
%>
<center><p align=center><font color=#ff6600 size=5><br> <%=gamename%><%=ltype%>排名</font> [<a href=# onclick="history.back()">BACK</A>]</p>
<TABLE border=1 bordercolor=#0055aa >
<tr><td class=tdhead align=center><b>排名</b></td>
<td class=tdhead align=center><b>登陆帐号</b></td>
<td class=tdhead align=center><b>真实姓名</b></td>
<td class=tdhead align=center><b>本月迟到</b></td></tr>
<% do while (not rs.eof and n<num+1)
pname=rs("username")
realname=rs("realname")
monthlattertime=rs("monthlattertime")
%>
<tr><td align=center class=td2><font color=#00ffcc><%=n%></td>
<td align=center class=td1><%=pname%></td>
<td align=center class=td2><%=realname%></td>
<td align=center class=td1><font color=#ff6600> <%=monthlattertime%> 次 </td></tr>
<%
rs.movenext
n=n+1
loop
response.write "</TABLE>"
end if
if ltype="所有迟到" then
if request.form("xz")="否" then
sql="select * from ct_sql where type="&ptype&" and qx=5 order by alllattertime desc"
else
sql="select * from ct_sql where type="&ptype&" order by alllattertime desc"
end if
rs.open sql,cn,1,1
%>
<center><p align=center><font color=#ff6600 size=5><br> <%=gamename%><%=ltype%>排名</font> [<a href=# onclick="history.back()">BACK</A>]</p>
<TABLE border=1 bordercolor=#0055aa >
<tr><td class=tdhead align=center><b>排名</b></td>
<td class=tdhead align=center><b>登陆帐号</b></td>
<td class=tdhead align=center><b>真实姓名</b></td>
<td class=tdhead align=center><b>所有迟到</b></td></tr>
<% do while (not rs.eof and n<num+1)
pname=rs("username")
realname=rs("realname")
alllattertime=rs("alllattertime")
%>
<tr><td align=center class=td2><font color=#00ffcc><%=n%></td>
<td align=center class=td1><%=pname%></td>
<td align=center class=td2><%=realname%></td>
<td align=center class=td1><font color=#ff6600> <%=alllattertime%>次 </td></tr>
<%
rs.movenext
n=n+1
loop
response.write "</TABLE>"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -