def query_group_list(self):
qry = GroupQuery(
""" g.groupId, g.groupIcon, g.groupTitle, g.createDate, g.userCount,g.parentId,
g.visitCount, g.articleCount, g.topicCount, g.resourceCount, g.groupIntroduce,g.XKXDName,g.XKXDId,
g.groupTags, subj.subjectName, grad.gradeName, sc.name as scName """
)
qry.subjectId = self.params.getIntParamZeroAsNull('subjectId')
qry.categoryId = self.params.getIntParamZeroAsNull('categoryId')
qry.gradeId = self.params.getIntParamZeroAsNull('gradeId')
qry.k = self.params.getStringParam("k")
if self.qrytype != None:
if self.qrytype == "best":
qry.isBestGroup = True
if self.qrytype == "rcmd":
qry.isRecommend = True
if self.qrytype == "hot":
qry.orderType = GroupQuery.ORDER_BY_VISITCOUNT_DESC
if self.qrytype == "new":
qry.orderType = GroupQuery.ORDER_BY_ID_DESC
pager = self.createPager()
pager.totalRows = qry.count()
group_list = qry.query_map(pager)
request.setAttribute("group_list", group_list)
#print "group_list = ", group_list
request.setAttribute("pager", pager)
request.setAttribute("subjectId", qry.subjectId)
request.setAttribute("categoryId", qry.categoryId)
request.setAttribute("gradeId", qry.gradeId)
request.setAttribute("k", qry.k)
def get_group_list(self):
qry = GroupQuery(""" subj.subjectId, g.createUserId, g.groupId, g.groupIcon, g.groupTitle, g.createDate,
u.loginName, u.nickName, g.userCount, g.visitCount, g.articleCount, g.topicCount,
g.resourceCount, g.groupTitle , g.groupIntroduce """)
pager = self.createPager()
# 根据页面参数处理.
type = self.params.getStringParam("type")
if type == "rcmd":
qry.isRecommend = True
elif type == "hot":
qry.orderType = GroupQuery.ORDER_BY_VISITCOUNT_DESC
elif type == "rcmd":
qry.isRecommend = True
else:
type = "new"
request.setAttribute("type", type)
qry.subjectId = self.get_current_subjectId()
qry.gradeId = self.get_current_gradeId()
qry.k = self.params.getStringParam("k")
#qry.sysCateId = self.params.getIntParamZeroAsNull("categoryId")
pager.totalRows = qry.count()
group_list = qry.query_map(pager)
request.setAttribute("group_list", group_list)
request.setAttribute("pager", pager)
def get_hot_group_list(self):
qry = GroupQuery(
""" g.groupId, g.groupIcon, g.groupTitle, g.createDate, g.groupIntroduce, g.createUserId,g.parentId,g.XKXDName,g.XKXDId,
u.loginName, u.nickName """)
qry.orderType = GroupQuery.ORDER_BY_VISITCOUNT_DESC # visitCount DESC
hot_group_list = qry.query_map()
request.setAttribute("hot_group_list", hot_group_list)
def genernate_xiezuozu_content(self, webpart):
cache_key = "sbj" + str(self.subject.subjectId) + "_" + str(webpart.getSubjectWebpartId()) + self.cacheKeyFix
content = cache.get(cache_key)
if content != None:
request.setAttribute(cache_key, content)
return
map = HashMap()
qry = GroupQuery(""" g.groupName,g.groupId, g.groupIcon, g.groupTitle, g.createDate, g.groupIntroduce """)
qry.subjectId = self.metaSubjectId
qry.gradeId = self.metaGradeId
new_group_list = qry.query_map(4)
map.put("new_group_list", new_group_list)
qry = GroupQuery(""" g.groupName,g.groupIcon, g.createDate, g.groupId, g.groupTitle, g.groupIntroduce """)
qry.subjectId = self.metaSubjectId
qry.gradeId = self.metaGradeId
qry.orderType = 8
hot_group_list = qry.query_map(4)
map.put("hot_group_list", hot_group_list)
Qry = GroupQuery(""" g.groupName,g.groupId, g.groupIcon, g.groupTitle, g.createDate, g.groupIntroduce """)
qry.subjectId = self.metaSubjectId
qry.gradeId = self.metaGradeId
qry.isRecommend = True
rcmd_group_list = qry.query_map(4)
map.put("rcmd_group_list", rcmd_group_list)
map.put("subject", self.subject)
map.put("SubjectRootUrl", self.subjectRootUrl)
map.put("webpart", webpart)
map.put("unitId", self.unitId)
content = self.templateProcessor.processTemplate(map, "/WEB-INF/subjectpage/" + self.templateName + "/xiezuozu.ftl", "utf-8")
request.setAttribute(cache_key, content)
cache.put(cache_key, content)
def get_hot_list(self):
qry = GroupQuery(""" subj.subjectId, g.createUserId, g.groupIcon, g.groupId, g.groupTitle, g.createDate, g.groupIntroduce,
u.loginName, u.nickName """)
qry.orderType = 2
qry.subjectId = self.subject.subjectId
hot_list = qry.query_map()
request.setAttribute("hot_list", hot_list)
def get_new_group_list(self):
qry = GroupQuery(""" subj.subjectId, g.createUserId, g.groupId, g.groupIcon, g.groupTitle, g.createDate,
u.loginName, u.nickName """)
qry.orderType = 1
qry.subjectId = self.get_current_subjectId()
qry.gradeId = self.get_current_gradeId()
new_group_list = qry.query_map(4)
request.setAttribute("new_group_list", new_group_list)
def get_hot_group_list(self):
qry = GroupQuery(
""" g.groupIcon, g.createDate, g.groupId, g.groupTitle, g.groupIntroduce """
)
qry.subjectId = self.get_subjectId()
qry.orderType = 8
hot_group_list = qry.query_map(3)
request.setAttribute("hot_group_list", hot_group_list)
def get_hot_group_list(self):
cache_key = "hot_group_list"
hot_group_list = cache.get(cache_key)
if hot_group_list == None:
qry = GroupQuery(
" g.groupId, g.groupIcon, g.groupTitle, g.createDate, g.groupIntroduce "
)
qry.orderType = GroupQuery.ORDER_BY_VISITCOUNT_DESC # visitCount DESC
hot_group_list = qry.query_map(7)
cache.put(cache_key, hot_group_list)
request.setAttribute("hot_group_list", hot_group_list)
