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_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 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)
