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)