def query_resource(self): qry = ResourceQuery( """ r.resourceId, r.title, r.href, r.fsize, r.createDate, u.loginName, u.nickName, grad.gradeName, sc.name as scName """) pager = self.createPager() # 根据页面参数处理. type = self.params.getStringParam("type") if type == "rcmd": qry.rcmdState = True elif type == "hot": qry.orderType = ResourceQuery.ORDER_TYPE_DOWNLOADCOUNT_DESC elif type == "cmt": qry.orderType = ResourceQuery.ORDER_TYPE_COMMENTCOUNT_DESC else: type = "new" request.setAttribute("type", type) qry.subjectId = self.subject.subjectId qry.k = self.params.getStringParam("k") qry.sysCateId = self.params.getIntParamZeroAsNull("categoryId") # 查询数据. pager.totalRows = qry.count() resource_list = qry.query_map(pager) request.setAttribute("resource_list", resource_list) request.setAttribute("pager", pager)
def get_resource_list(self): qry = ResourceQuery( " r.resourceId, r.href, r.title, r.fsize, r.createDate, u.loginName, u.nickName, r.subjectId as subjectId, grad.gradeName, sc.name as scName " ) type = self.params.getStringParam("type") if type == None or type == "": type = "new" list_type = "" if type == "hot": qry.orderType = ResourceQuery.ORDER_TYPE_VIEWCOUNT_DESC qry.custormAndWhereClause = " r.approvedPathInfo Like '%/" + str( self.unit.unitId) + "/%' " list_type = u"最高人气" elif type == "rcmd": #qry.rcmdState = True qry.custormAndWhereClause = " r.rcmdPathInfo Like '%/" + str( self.unit.unitId ) + "/%' And r.approvedPathInfo Like '%/" + str( self.unit.unitId) + "/%' " list_type = u"编辑推荐" elif type == "cmt": qry.orderType = ResourceQuery.ORDER_TYPE_COMMENTCOUNT_DESC qry.custormAndWhereClause = " r.approvedPathInfo Like '%/" + str( self.unit.unitId) + "/%' " list_type = u"评论最多" else: type = "new" qry.custormAndWhereClause = " r.approvedPathInfo Like '%/" + str( self.unit.unitId) + "/%' " list_type = u"最新资源" request.setAttribute("type", type) request.setAttribute("list_type", list_type) qry.gradelevel = self.params.getIntParamZeroAsNull("level") qry.subjectId = self.params.getIntParamZeroAsNull("subjectId") qry.sysCateId = self.params.getIntParamZeroAsNull("categoryId") qry.gradeId = self.params.getIntParamZeroAsNull("gradeId") qry.k = self.params.getStringParam("k") pager = self.createPager() pager.totalRows = qry.count() resource_list = qry.query_map(pager) request.setAttribute("resource_list", resource_list) request.setAttribute("pager", pager) request.setAttribute("subjectId", qry.subjectId) request.setAttribute("categoryId", qry.sysCateId)
def execute(self): self.userName = request.getAttribute("loginName") if self.userName == None or self.userName == '': response.getWriter().write(u"没有该用户。") return user = self.userService.getUserByLoginName(self.userName) if user == None: response.getWriter().write(u"不能加载当前用户。") return fc = FileCache() content = fc.getUserFileCacheContent(self.userName, "user_resources.html", 30) if content != "": response.getWriter().write(content) fc = None return qry = ResourceQuery(" r.createDate, r.resourceId, r.title, r.href") qry.userId = user.userId qry.orderType = 0 resource_list = qry.query_map(10) templateProcessor = __spring__.getBean("templateProcessor") map = HashMap() map.put("resource_list", resource_list) map.put("UserSiteUrl", self.getUserSiteUrl()) content = templateProcessor.processTemplate( map, "/WEB-INF/user/default/user_resources.ftl", "utf-8") fc.writeUserFileCacheContent(self.userName, "user_resources.html", content) response.getWriter().write(content) fc = None
def get_hot_resource_list(self): qry = ResourceQuery( """ r.createDate, r.resourceId, r.href, r.title, u.loginName, u.nickName, u.userId """ ) qry.subjectId = self.get_subjectId() qry.orderType = 2 hot_resource_list = qry.query_map(11) request.setAttribute("hot_resource_list", hot_resource_list)
def get_download_resource_list(self): qry = ResourceQuery( """ r.resourceId, r.href, r.title, r.downloadCount """) qry.subjectId = self.subject.metaSubject.msubjId qry.gradeId = self.subject.metaGrade.gradeId qry.FuzzyMatch = True qry.orderType = 4 download_resource_list = qry.query_map(20) request.setAttribute("download_resource_list", download_resource_list)
def get_download_resource_list(self): qry = ResourceQuery( """ r.resourceId, r.href, r.title, r.downloadCount """) qry.subjectId = self.params.getIntParamZeroAsNull("subjectId") qry.sysCateId = self.params.getIntParamZeroAsNull("categoryId") qry.k = self.params.getStringParam("k") qry.orderType = 4 download_resource_list = qry.query_map(20) request.setAttribute("download_resource_list", download_resource_list)
def genernate_resoure_content(self, webpart): cache_key = "unit" + str(self.unit.unitId) + "_" + str( webpart.getUnitWebpartId()) content = cache.get(cache_key) if content != None: request.setAttribute(cache_key, content) return map = HashMap() #最新资源 qry = ResourceQuery( """ r.resourceId, r.title, r.href, r.createDate, r.fsize, r.downloadCount, r.userId, r.subjectId as subjectId, grad.gradeName, sc.name as scName """ ) #qry.unitId = self.unit.unitId qry.custormAndWhereClause = " r.approvedPathInfo Like '%/" + str( self.unit.unitId) + "/%' " new_resource_list = qry.query_map(10) map.put("new_resource_list", new_resource_list) #本周热门资源 qry = ResourceQuery( """ r.resourceId, r.title, r.href, r.createDate, r.fsize, r.downloadCount, r.userId, msubj.msubjName, grad.gradeName, sc.name as scName """) qry.orderType = 4 # downloadCount DESC #qry.unitId = self.unit.unitId qry.custormAndWhereClause = " r.approvedPathInfo Like '%/" + str( self.unit.unitId) + "/%' " hot_resource_list = qry.query_map(10) map.put("hot_resource_list", hot_resource_list) #hot_resource_list = self.viewcount_svc.getViewCountListShared(12,7,10,self.unit.unitPath,self.unit.unitDepth); #map.put("hot_resource_list", hot_resource_list) # 推荐资源 qry = ResourceQuery( """ r.resourceId, r.title, r.href, r.createDate, r.fsize, r.downloadCount, r.userId,msubj.msubjName, grad.gradeName, sc.name as scName """) #qry.rcmdState = True #qry.unitId = self.unit.unitId qry.custormAndWhereClause = " r.approvedPathInfo Like '%/" + str( self.unit.unitId) + "/%' And r.rcmdPathInfo Like '%/" + str( self.unit.unitId) + "/%' " rcmd_resource_list = qry.query_map(10) map.put("rcmd_resource_list", rcmd_resource_list) map.put("unit", self.unit) map.put("webpart", webpart) map.put("UnitRootUrl", self.unitRootUrl) content = self.templateProcessor.processTemplate( map, "/WEB-INF/unitspage/" + self.templateName + "/resource.ftl", "utf-8") request.setAttribute(cache_key, content) cache.put(cache_key, content)
def query_resource(self): qry = ResourceQuery( """ r.resourceId, r.title, r.href, r.fsize, r.createDate, u.loginName, u.nickName, grad.gradeName, sc.name as scName """) pager = self.createPager() if self.unitId != None and self.unitId != 0: qry.custormAndWhereClause = " r.approvedPathInfo LIKE '%/" + str( self.unitId) + "/%'" # 根据页面参数处理. type = self.params.getStringParam("type") if type == "rcmd": qry.rcmdState = True if self.unitId != None and self.unitId != 0: # 覆盖掉前面的设置 qry.custormAndWhereClause = " r.rcmdPathInfo LIKE '%/" + str( self.unitId) + "/%'" elif type == "hot": qry.orderType = ResourceQuery.ORDER_TYPE_DOWNLOADCOUNT_DESC elif type == "cmt": qry.orderType = ResourceQuery.ORDER_TYPE_COMMENTCOUNT_DESC else: type = "new" request.setAttribute("type", type) qry.subjectId = self.get_current_subjectId() #qry.gradeId = self.get_current_gradeId() qry.gradeId = self.levelGradeId qry.gradelevel = self.params.getIntParamZeroAsNull("level") qry.FuzzyMatch = True qry.k = self.params.getStringParam("k") qry.sysCateId = self.params.getIntParamZeroAsNull("categoryId") # 查询数据. pager.totalRows = qry.count() resource_list = qry.query_map(pager) request.setAttribute("resource_list", resource_list) request.setAttribute("pager", pager)
def genernate_resoure_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 = ResourceQuery(""" r.resourceId, r.title, r.href, r.createDate, r.fsize, r.downloadCount, u.loginName, u.nickName, r.subjectId as subjectId, grad.gradeName, sc.name as scName """) qry.subjectId = self.metaSubjectId qry.gradeId = self.metaGradeId qry.FuzzyMatch = True if self.unitId != None and self.unitId != 0: qry.custormAndWhereClause = " r.approvedPathInfo LIKE '%/" + str(self.unitId) + "/%'" new_resource_list = qry.query_map(10) map.put("new_resource_list", new_resource_list) qry = ResourceQuery(""" r.resourceId, r.title, r.href, r.createDate, r.fsize, r.downloadCount, u.loginName, u.nickName, msubj.msubjName, grad.gradeName, sc.name as scName """) qry.orderType = 4 # downloadCount DESC qry.subjectId = self.metaSubjectId qry.gradeId = self.metaGradeId qry.FuzzyMatch = True if self.unitId != None and self.unitId != 0: qry.custormAndWhereClause = " r.approvedPathInfo LIKE '%/" + str(self.unitId) + "/%'" hot_resource_list = qry.query_map(10) map.put("hot_resource_list", hot_resource_list) #hot_resource_list = self.viewcount_svc.getViewCountListShared(12,7,10,self.unit.unitPath,self.unit.unitDepth); #map.put("hot_resource_list", hot_resource_list) # �Ƽ���Դ qry = ResourceQuery(""" r.resourceId, r.title, r.href, r.createDate, r.fsize, r.downloadCount, u.loginName, u.nickName, msubj.msubjName, grad.gradeName, sc.name as scName """) qry.rcmdState = True qry.subjectId = self.metaSubjectId qry.gradeId = self.metaGradeId qry.FuzzyMatch = True if self.unitId != None and self.unitId != 0: qry.custormAndWhereClause = " r.rcmdPathInfo LIKE '%/" + str(self.unitId) + "/%'" rcmd_resource_list = qry.query_map(10) map.put("rcmd_resource_list", rcmd_resource_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 + "/resource.ftl", "utf-8") request.setAttribute(cache_key, content) cache.put(cache_key, content)
def get_hot_resource_list(self): cache_key = "hot_resource_list" hot_resource_list = cache.get(cache_key) # hot_resource_list=None if hot_resource_list == None: qry = ResourceQuery( """ r.userId, r.resourceId, r.title, r.href, r.createDate, r.fsize, r.downloadCount, u.loginName, u.trueName, msubj.msubjName, grad.gradeName, sc.name as scName """ ) # qry.unit = self.unit qry.unitId = None qry.custormAndWhereClause = " r.approvedPathInfo Like '%/" + str( self.unit.unitId) + "/%' " qry.orderType = 4 # downloadCount DESC hot_resource_list = qry.query_map(10) cache.put(cache_key, hot_resource_list) request.setAttribute("hot_resource_list", hot_resource_list)
def resource(self): qry = ResourceQuery(""" r.resourceId, r.title, r.createDate, u.trueName, u.loginName, u.userIcon, subj.subjectName, r.summary, r.lastModified """) userId = request.getParameter("userId") if(request.getParameter("userId") != None): qry.userId = int(userId) request.setAttribute("showType", "user") qry.orderType = 0 result = qry.query_map(20) #print "result = ", result #return for a in result: str = a['lastModified'] str = CommonUtil.rssDateFormat(str) a['lastModifiedString'] = str request.setAttribute("resource_list", result) response.setContentType("text/xml; charset=UTF-8") return "/WEB-INF/ftl/site_rss_resource.ftl"
def execute(self): writer = response.getWriter() self.params = ParamUtil(request) loginName = request.getAttribute("loginName") if (loginName == None or loginName == ''): writer.write("没有该用户。") return # 加载当前用户对象. user = __jitar__.userService.getUserByLoginName(loginName) request.setAttribute("user", user) if self.canVisitUser(user) == False: return self.ACCESS_ERROR # loginUser 对象来自基类 BaseAdminAction . request.setAttribute("loginUser", self.loginUser) # 创建分页对象 pager = self.params.createPager() pager.setPageSize(20) qry = ResourceQuery( """ r.resourceId, r.title, r.createDate """) qry.userId = user.userId #if userStapleId != 0 : # qry.userStapleId = userStapleId #print "userStapleId = ", userStapleId pager.totalRows = qry.count() pager.itemName = u"资源" pager.itemUnit = u"个" qry.orderType = 0 result = qry.query_map(pager) request.setAttribute("user_resource_list", result) request.setAttribute("pager", pager) hql = """SELECT new Map(p.skin as skin) FROM Page p WHERE p.name = 'index' and p.objId = :userId and p.objType = 1 """ pageSkin = Command(hql).setInteger("userId", user.userId).first() # 构造页面数据,由于页面不是在数据库存在的,这里的数据是虚拟数据. #pages : [{id: ${page.pageId}, title: '${user.blogName!?js_string}', layoutId: ${page.layoutId!0} }], page = { "pageId": 0, "layoutId": 2, # 固定是布局2 "isSystemPage": "true", "owner": "user", "title": "", "skin": pageSkin["skin"] } request.setAttribute("page", page) # 构造widgets . widgets = [{ "id": "1", "pageId": 0, "columnIndex": 1, "title": u"个人档案", "module": "profile", "ico": "", "data": "" }, { "id": "2", "pageId": 0, "columnIndex": 1, "title": u"资源分类", "module": "user_rcate", "ico": "", "data": "" }, { "id": "placerholder1", "pageId": 0, "columnIndex": 2, "title": "", "module": "placeholder", "ico": "", "data": "" }] request.setAttribute("widgets", widgets) request.setAttribute("widget_list", widgets) response.setContentType("text/html; charset=UTF-8") return "/WEB-INF/user/default/user_resource_list.ftl"