net_users.asp

泡泡堂服务端内有建站说明,喜欢玩泡泡堂的朋友下载开发.

<!-- #include file="net_head.asp" -->
<%
if (Trim(Request("year_from")) <> "") then
	cur_year	= CInt(Request ("year_from"))
	cur_month	= CInt(Request ("month_from"))
else
	cur_year	= Year	(Date())
	cur_month	= Month	(Date())
end if
fst_week  = Weekday (DateSerial(cur_year, cur_month, 1))
last_day  = Day(DateAdd("d", -1, DateAdd("m", 1, DateSerial(cur_year, cur_month, 1))))

if len(cur_month) = 1 then cur_month = "0" & cur_month
if cur_month = 12 then
	next_month = "01"
	next_year = cur_year + 1
else
	next_month = cur_month + 1
	next_year = cur_year
end if

sql = "SELECT   COUNT(*)  AS counter, LEFT(GaipDate, 10) AS GaipDate "
sql = sql & "FROM      IB_MEMBER "
sql = sql & "WHERE   (GaipDate >= '"& cur_year &"-"& cur_month &"-01') AND (GaipDate < '"& next_year &"-"& next_month &"-01') "
sql = sql & "AND partner_tag = 'NM' "
sql = sql & "GROUP BY LEFT(GaipDate, 10) "
sql = sql & "ORDER BY GaipDate "
set rs = DbCon.execute (sql)

sql = "select count(*) counter from ib_member "
sql = sql & "where partner_tag = 'NM' "
set rs1 = DbCon.execute (sql)

cur_users = Application.value ("users")
total_count = 0

if not rs1.EOF then
	nmmemb = rs1("counter")
end if
%>
<div align="center">
<table width="750" border="0" cellspacing="1" cellpadding="1" align="center">
  <tr> 
	<td bgcolor="#CCCCCC" height="50">
	  <div align="center"><font size="5" face="蹈框"><b>齿付喉 - 航霸烙 啊涝 沥焊</b></font></div>
	</td>
  </tr>
</table><br>
<table width="750" border=0 class="boardtext03">
	<tr> 
		<td  height="26" align="right"><a href="netmarble.asp"><b>&lt&lt Main...</b></a></td>
	</tr>
  <tr>
	<td width="250">
		<font size=2>
		泅犁 齿付喉 醚 啊涝磊 荐 : <b><%=formatnumber(nmmemb,0)%> 疙</b><br>
  </tr>
</table>

<form method="post" action="net_users.asp" name=calender>
<table border=0 width=600 cellpadding=0 cellspacing=0 class="boardtext03">
<tr>
	<td width=40% height="30" bgcolor=#E6E6E6 align=center style="font-size:13pt"><b>老磊喊 啊涝磊烹拌</b></td>
	<td width=60% bgcolor=#E6E6E6 align=left>
		<select name=year_from>
			<option value=<%=(cur_year-1)%>><%=(cur_year-1)%>
			<option value=<%=cur_year%> selected><%=cur_year%>
		</select>斥&nbsp;
		<select name=month_from>
		<%
		for i = 1 to 12
			str = " "
			if i=CInt(cur_month) then
				str = " selected"
			end if
		%>
			<option value=<%=i%><%=str%>><%=i%>
		<%
		next
		%>
		</select>岿&nbsp;
		&nbsp;
		<input type=submit value="炼雀">
	</td>
<tr>
	<td colspan=2 bgcolor="#3C57A2">
		<table border=0 width=653 cellpadding=0 cellspacing=1>
		<tr>
			<td width=14% bgcolor="#7FBBF1" align=center height=20>老</td>
			<td width=14% bgcolor="#7FBBF1" align=center height=20>岿</td>
			<td width=14% bgcolor="#7FBBF1" align=center height=20>拳</td>
			<td width=14% bgcolor="#7FBBF1" align=center height=20>荐</td>
			<td width=14% bgcolor="#7FBBF1" align=center height=20>格</td>
			<td width=14% bgcolor="#7FBBF1" align=center height=20>陛</td>
			<td width=14% bgcolor="#7FBBF1" align=center height=20>配</td>
		</tr>
<%
		if  fst_week <> 1 then Response.Write ("<tr>")
		for i=1 to fst_week-1 
			Response.Write ("<td bgcolor=#F1F8FC>&nbsp;</td>")
		next
	
		for i=1 to last_day 
			if Weekday(DateSerial(cur_year, cur_month, i)) = 1 then Response.Write ("<tr>")
			found = false
			regi_count = 0
			while ((not rs.EOF) and (not found))
				comp_day = CInt(trim(mid(rs("GaipDate"), 4, 2)))
				if comp_day = i then 
					regi_count = CInt (rs("counter"))
					found = true
					rs.MoveNext
				elseif comp_day < i then
					rs.MoveNext
				else 
					found = true
				end if
			wend
			total_count = total_count + regi_count
			
			tmp_year  = CStr(cur_year)
			tmp_month = CStr(cur_month)
			tmp_day = CStr(i)
			if (len(tmp_month) = 1) then tmp_month = "0" + tmp_month
			if (len(tmp_day) = 1) then tmp_day = "0" + tmp_day
			DateStr = "BGMain" & tmp_year & tmp_month & tmp_day
%>
			<td width=14% cellspacing=0 cellpadding=0>
				<table border=0 width=100% bordercolor="black" cellpadding=0 cellspacing=0  bgcolor="#6A819B">
				<tr>
					<td valign=bottom align=center height=20><font color="white"><%=CInt(cur_month)%>岿 <%=i%>老&nbsp;</font></td>
				<tr>
					<td align=center height=25><img src="http://61.78.55.11:8080/servlet/vNumber?number=<%=regi_count%>" width=90 height=20></td>
				</table>
			</td>
<%
			if Weekday(DateSerial(cur_year, cur_month, i)) = 7 then Response.Write ("</tr>")
		next

		for i=Weekday(DateSerial(cur_year, cur_month, last_day)) to 7-1
			Response.Write ("<td bgcolor=#F1F8FC>&nbsp;</td>")
		next

		if Weekday(DateSerial(sel_year, sel_month, last_day)) <> 7 then Response.Write ("</tr>")
%>
		</table></td></form>
</table>
<table width="650" border=0 class="boardtext03">
<tr><td align="right">
<font size="2"><b>捞锅崔 啊涝磊 荐 : <%=formatnumber(total_count,0)%> 疙</b>&nbsp;&nbsp;<br>
(^_^) 啊涝篮 拌加登绢具茄促~ 罗~~~~宽! 缺泼~!!</font>
</td></tr></table>
</div>
<!-- #include file="net_bottom.asp" -->