📄 activity_list.jsp
字号:
<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="cn.js.fan.db.*"%>
<%@ page import="cn.js.fan.base.*"%>
<%@ page import="cn.js.fan.util.*"%>
<%@ page import="cn.js.fan.web.*"%>
<%@ page import="com.redmoon.forum.person.*"%>
<%@ page import="com.redmoon.forum.setup.*"%>
<%@ page import="com.redmoon.forum.setup.*"%>
<%@ page import="com.redmoon.forum.plugin.activity.*"%>
<%@ taglib uri="/WEB-INF/tlds/LabelTag.tld" prefix="lt" %>
<%
String skincode = UserSet.getSkin(request);
if (skincode.equals(""))
skincode = UserSet.defaultSkin;
SkinMgr skm = new SkinMgr();
Skin skin = skm.getSkin(skincode);
if (skin==null)
skin = skm.getSkin(UserSet.defaultSkin);
String skinPath = skin.getPath();
String orderBy = ParamUtil.get(request, "orderBy");
if (orderBy.equals(""))
orderBy = "expire_date";
String sort = ParamUtil.get(request, "sort");
if (sort.equals(""))
sort = "desc";
String op = ParamUtil.get(request, "op");
String kind = ParamUtil.get(request, "kind");
String value = ParamUtil.get(request, "value");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link href="../../<%=skinPath%>/skin.css" rel="stylesheet" type="text/css">
<title>活动列表 - <%=Global.AppName%></title>
<style type="text/css">
<!--
body {
margin-top: 0px;
margin-left: 0px;
margin-right: 0px;
}
-->
</style>
<script>
var curOrderBy = "<%=orderBy%>";
var sort = "<%=sort%>";
function doSort(orderBy) {
if (orderBy==curOrderBy)
if (sort=="asc")
sort = "desc";
else
sort = "asc";
window.location.href = "activity_list.jsp?op=<%=op%>&value=<%=StrUtil.UrlEncode(value)%>&orderBy=" + orderBy + "&sort=" + sort;
}
</script>
</head>
<body>
<jsp:useBean id="StrUtil" scope="page" class="cn.js.fan.util.StrUtil"/>
<%@ include file="../../inc/header.jsp"%>
<div id="newdiv" name="newdiv">
<div align="center">
<br><strong><font color="#6666DF">活动列表</font><br><br></strong>
</div>
<%
int pagesize = 10;
Paginator paginator = new Paginator(request);
ActivityDb ad = new ActivityDb();
String sql = "select msg_id from " + ad.getTableName() + " order by " + orderBy + " " + sort;
if (op.equals("search")) {
if (kind.equals("msgId"))
sql = "select msg_id from " + ad.getTableName() + " where msg_id=" + value;
else {
sql = "select a.msg_id from " + ad.getTableName() + " a left join sq_message m on m.id=a.msg_id where m.title like " +StrUtil.sqlstr("%" + value + "%") + " order by " + orderBy + " " + sort;
}
}
int total = ad.getObjectCount(sql);
paginator.init(total, pagesize);
int curpage = paginator.getCurPage();
// 设置当前页数和总页数
int totalpages = paginator.getTotalPages();
if (totalpages==0)
{
curpage = 1;
totalpages = 1;
}
%>
<table width="98%" border="0" align="center" class="p9">
<tr>
<form action="activity_list.jsp?op=search" method="post">
<td width="46%" align="left">
<input name="value">
<select name="kind">
<option value="title">活动标题</option>
<option value="msgId">活动编号</option>
</select>
<input name="Submit" type="submit" class="singleboarder" value="<lt:Label res="res.label.forum.admin.user_m" key="search"/>">
</td>
</form>
<td width="54%" align="right">找到符合条件的记录 <b><%=paginator.getTotal() %></b> 条 每页显示 <b><%=paginator.getPageSize() %></b> 条 页次 <b><%=paginator.getCurrentPage() %>/<%=paginator.getTotalPages() %></b></td>
</tr>
</table>
<TABLE width="98%" border=0 align=center cellPadding=0 cellSpacing=1 bgcolor="#edeced">
<TBODY>
<TR align=center bgColor=#f8f8f8 class="td_title">
<TD width=7% height=23><strong>编号</strong></TD>
<TD width=42% height=23><strong>活动标题</strong></TD>
<TD width=7% height=23><strong>发布者</strong></TD>
<TD width=8%><strong>组织者</strong></TD>
<TD width=9%><strong>联系方式</strong></TD>
<TD width=13%><strong>参与者等级要求</strong></TD>
<TD width=14% height=23 onClick="doSort('expire_date')" style="cursor:hand"><strong>
截止时间</strong>
<%if (orderBy.equals("expire_date")) {
if (sort.equals("asc"))
out.print("<img src='../../admin/images/arrow_up.gif' width=8px height=7px>");
else
out.print("<img src='../../admin/images/arrow_down.gif' width=8px height=7px>");
}%> </TD>
</TR>
<%
Vector v = ad.list(sql, (curpage-1)*pagesize, curpage*pagesize-1);
Iterator ir = v.iterator();
com.redmoon.forum.person.UserMgr um = new com.redmoon.forum.person.UserMgr();
MsgMgr mm = new MsgMgr();
int i = 0;
while (ir.hasNext()) {
ad = (ActivityDb)ir.next();
MsgDb md = mm.getMsgDb(ad.getMsgId());
int level = ad.getUserLevel();
UserLevelDb uld = new UserLevelDb();
uld = uld.getUserLevelDb(level);
i++;
%>
<TR align=center bgColor=#f8f8f8>
<TD height=23><%=ad.getMsgId()%></TD>
<TD width=42% height=23 align="left"> <a href="<%=request.getContextPath()%>/forum/showtopic.jsp?rootid=<%=ad.getMsgId()%>" target="_blank"><%=md.getTitle()%></a></TD>
<TD width=7% height=23><a target="_blank" href="<%=request.getContextPath()%>/userinfo.jsp?username=<%=md.getName()%>"><%=um.getUser(md.getName()).getNick()%></a></TD>
<TD width=8%><a target="_blank" href="<%=request.getContextPath()%>/userinfo.jsp?username=<%=StrUtil.UrlEncode(ad.getOrganizer())%>"><%=StrUtil.getNullStr(um.getUser(ad.getOrganizer()).getNick())%></a></TD>
<TD width=9%><%=ad.getTel()%></TD>
<TD width=13%><%=uld.getDesc()%></TD>
<TD width=14% height=23><%=DateUtil.format(ad.getExpireDate(), "yyyy-MM-dd")%></TD>
</TR>
<%
}
%>
</TBODY>
</TABLE>
<table width="98%" border="0" cellspacing="1" cellpadding="3" align="center" class="9black">
<tr>
<td height="23"> <div align="right">
<%
String querystr = "op=" + op + "&kind=" + kind + "&value=" + StrUtil.UrlEncode(value) + "&orderBy=" + orderBy + "&sort=" + sort;
out.print(paginator.getCurPageBlock("activity_list.jsp?"+querystr));
%>
</div></td>
</tr>
</table>
</div>
<%@ include file="../../inc/footer.jsp"%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -