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 recycle_list(self):
# 构造查询.
query = ResourceQuery(
""" r.resourceId, r.title, r.shareMode, r.createDate, u.loginName, u.nickName, r.subjectId, r.gradeId,
r.href, r.downloadCount, r.commentCount, r.fsize, sc.name as sysCateName, subj.subjectName """
)
query.auditState = None
query.delState = True # 获得被删除的.
query.shareMode = None
query.subjectId = self.params.getIntParamZeroAsNull("su")
request.setAttribute("su", query.subjectId)
query.gradeId = self.params.getIntParamZeroAsNull("gradeId")
request.setAttribute("gradeId", query.gradeId)
query.sysCateId = self.params.getIntParamZeroAsNull("sc")
request.setAttribute("sc", query.sysCateId)
query.kk = self.params.getStringParam("k")
request.setAttribute("k", query.kk)
query.f = self.params.getStringParam("f")
request.setAttribute("f", query.f)
# 计算总量.
pager = self.createPager()
pager.totalRows = query.count()
# 得到资源.
resource_list = query.query_map(pager)
request.setAttribute("pager", pager)
request.setAttribute("resource_list", resource_list)
self.putSubjectList()
self.putGradeList()
self.putResourceCategoryTree()
return self.RECYCLE_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 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 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 list(self):
# 构造查询.
query = ResourceQuery(
""" r.resourceId, r.title, r.shareMode, r.createDate, r.href, r.subjectId, r.gradeId,
r.downloadCount, r.commentCount, r.fsize, r.auditState, r.recommendState, r.tags, r.addIp, r.pushState,
u.userId, u.loginName, u.nickName, sc.name as sysCateName, subj.subjectName """
)
query.auditState = None
query.delState = False # 过滤被删除了的.
recommendState = self.params.safeGetStringParam("recommendState")
if recommendState == "1":
query.rcmdState = 1
elif recommendState == "0":
query.rcmdState = 0
auditState = self.params.safeGetStringParam("auditState")
if auditState == "1":
query.auditState = 1
elif auditState == "0":
query.auditState = 0
query.shareMode = None
query.unitId = self.unit.unitId
# 根据参数设置过滤条件.
type = self.params.getStringParam("type")
request.setAttribute("type", type)
if type == "rcmd": # 推荐.
query.rcmdState = True
elif type == "unaudit": # 待审核.
query.auditState = Resource.AUDIT_STATE_WAIT_AUDIT
query.subjectId = self.params.getIntParamZeroAsNull("su")
request.setAttribute("su", query.subjectId)
query.gradeId = self.params.getIntParamZeroAsNull("gradeId")
request.setAttribute("gradeId", query.gradeId)
query.sysCateId = self.params.getIntParamZeroAsNull("sc")
request.setAttribute("sc", query.sysCateId)
query.kk = self.params.getStringParam("k")
request.setAttribute("k", query.kk)
query.f = self.params.getStringParam("f")
request.setAttribute("f", query.f)
# 计算总量.
pager = self.createPager()
pager.pageSize = 10
pager.totalRows = query.count()
# 得到资源.
resource_list = query.query_map(pager)
request.setAttribute("pager", pager)
request.setAttribute("resource_list", resource_list)
self.putSubjectList()
self.putGradeList()
self.putResourceCategoryTree()
request.setAttribute("recommendState", recommendState)
request.setAttribute("auditState", auditState)
return "/WEB-INF/unitsmanage/unit_owner_resource.ftl"
