求助大神！

xu868890 2016-07-13 04:55:25

<%@ page import="ch.com.authority.UserEO"%>
<%@ page import="com.ch.exam.login.ExamUserManager"%>
<%@ page import="ch.com.lib.other.ReqUtil"%>
<%@ page import="ch.service.grid.view.CommonGridView"%>
<%@ page import="ch.com.lib.db.Params"%>
<%@ page import="com.ch.exam.clasz.ClaszService"%>
<%@ page import="com.ch.exam.clasz.ClaszUser"%>
<%@ page import="com.ch.wim.forum.TopicEO"%>
<%@ page import="com.ch.wim.forum.TopicService"%>
<%@ page import="com.ch.exam.setting.UserTagService"%>
<%@ page import="com.ch.exam.setting.UserTag"%>
<%@ page import="ch.com.lib.date.SystemDate"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<% String strSelectFlag = ReqUtil.getParameterClearXSS(request,"select_flag","1");
//论坛栏目分类
String strCatalog = ReqUtil.getParameterClearXSS(request,"ct");
String strOutline = ReqUtil.getParameterClearXSS(request,"outline");
String strTagParam = ReqUtil.getParameterClearXSS(request,"tag");//按某标签过滤
String strUserRecordId = "strUserRecordId";
UserEO userInfo = (UserEO) session.getAttribute(UserEO.USERINFO_KEY);
if(userInfo != null){
strUserRecordId = userInfo.getRecordId();
}
String strShowFull = ReqUtil.getParameterClearXSS(request,"show_full");
boolean showFull = "1".equals(strShowFull);
//开始日期
String strFromDate = ReqUtil.getParameterClearXSS(request,"fromdate");
//结束日期
String strToDate = ReqUtil.getParameterClearXSS(request,"todate");
//关键词
String strKeywords = ReqUtil.getParameterClearXSS(request,"kw");
//分类记录号
CommonGridView gvCommon = new CommonGridView("1DDDC99A0286B7B06D591E75EA5A28AE");
String strPage = ReqUtil.getParameterClearXSS(request,"page");
gvCommon.setId("public_createdtopic");
gvCommon.setLimit(50);
gvCommon.nextPage(strPage);
String strBaseQueryFilter = " wt.public_flag=?";//为完全公开的话题
Params baseQueryFilterParam = new Params();
baseQueryFilterParam.addParam("varchar", TopicEO.PUBLIC_TO_ALL);
if (ReqUtil.isNotBlank(strCatalog)){
strBaseQueryFilter += " and vwf.tree_id like (select c1.tree_id||'%' from v_wim_forum c1 where c1.record_id=?)";
baseQueryFilterParam.addParam("varchar", strCatalog);
}
gvCommon.setBaseQueryFilter(strBaseQueryFilter);
gvCommon.setBaseQueryFilterParam(baseQueryFilterParam);
String strFilter = "";
Params queryFilterParam = new Params();
if (!strKeywords.equals("")) {
if (strFilter.length() > 0)
strFilter += " and ";
strFilter += " wt.title like ?";
queryFilterParam.addParam("varchar", "%"+strKeywords+"%");
}
gvCommon.setQueryFilter(strFilter);
gvCommon.setQueryFilterParam(queryFilterParam);
int nOrderBy = ReqUtil.getParameterInt(request,"orderby",0);
int nSort = ReqUtil.getParameterInt(request,"sort",1);//缺省为降序
HashMap<String,String> mapOrderBy = new LinkedHashMap<String,String>();
mapOrderBy.put("发帖时间","wt.create_date");
mapOrderBy.put("回复数量","wt.replies_num");
mapOrderBy.put("浏览数量","wt.views_num");
mapOrderBy.put("用户评价","(1*wt.vote_1+2*wt.vote_2+3*wt.vote_3+4*wt.vote_4+5*wt.vote_5)");
mapOrderBy.put("回复时间","wp.create_date");
if(nOrderBy<0 || nOrderBy>=mapOrderBy.entrySet().size()){
nOrderBy=0;
}
String strOrderBy = (String)mapOrderBy.values().toArray()[nOrderBy];
strOrderBy += (nSort==0?" asc":" desc");
gvCommon.setOrderBy(strOrderBy);
gvCommon.load();
long count = gvCommon.getCount();
TopicService ts = new TopicService();
%>

<%
String theDay = SystemDate.getSystemDate(-7);
while (gvCommon.next()) {
String strRecordId = gvCommon.getString("record_id");
String strOwnerRecordId = gvCommon.getString("topic_user_record_id");
String strOwnerFaceUrl = ExamUserManager.getUserFaceUrl(strOwnerRecordId);
String strTitle = gvCommon.getString("topic_title");
//String strContentShow =ts.getContent(strRecordId);
String strCreateDate = gvCommon.getString("topic_date");
//strCreateDate，显示为新的回复
boolean isNew = theDay.compareTo(strCreateDate)<0;
if(strCreateDate.length()>16){
strCreateDate = strCreateDate.substring(5, 16);
}
String strCatalogRecordId = gvCommon.getString("resource_record_id");
String strCatalogName = gvCommon.getString("cat_name");
String strViewNum = gvCommon.getString("views_num");
int nReplies = gvCommon.getInt("replies_num");
int nReplyPages = (nReplies - 1) / 20 + 1;
String strAuthor = gvCommon.getString("topic_user_name");
int nStatus = gvCommon.getInt("status");
int nVote1 = gvCommon.getInt("vote_1"); //投票1分
int nVote2 = gvCommon.getInt("vote_2"); //投票2分
int nVote3 = gvCommon.getInt("vote_3"); //投票3分
int nVote4 = gvCommon.getInt("vote_4"); //投票4分
int nVote5 = gvCommon.getInt("vote_5"); //投票5分
int value=0;
float voteResult=nVote1+nVote2+nVote3+nVote4+nVote5;
if(voteResult>0){
float sum=1*nVote1+2*nVote2+3*nVote3+4*nVote4+5*nVote5;
value=Math.round(sum/voteResult);
}
String strLastPostRecordId = gvCommon
.getString("last_post_record_id");
String strPostUserRecordId = gvCommon
.getString("post_user_record_id");
String strPostUserName = gvCommon.getString("post_user_name");
String strPostDate = gvCommon.getString("post_date");
if(strPostDate.length()>10){
strPostDate = strPostDate.substring(5, 16);
}
%>

sql语句都在里面可是看不懂啊求大神解答这两段的sql是什么

...全文