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 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_list(self): query = ResourceQuery( """ r.resourceId, r.title, r.shareMode, r.createDate, r.href, r.subjectId, r.gradeId, r.rcmdPathInfo, r.delState, r.unitPathInfo, r.approvedPathInfo, 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 """ ) multiPushState = self.params.safeGetStringParam("multiPushState") recommendState = self.params.safeGetStringParam("recommendState") auditState = self.params.safeGetStringParam("auditState") query.shareMode = None query.unitId = None #不使用该字段 custormAndWhereClause = "r.unitPathInfo LIKE '%/" + str( self.unit.unitId) + "/%' And r.unitId != " + str( self.unit.unitId) + " And" if multiPushState == "1": custormAndWhereClause += " r.unitPathInfo LIKE '%/" + str( self.unit.parentId) + "/%' And" elif multiPushState == "0": custormAndWhereClause += " r.unitPathInfo NOT LIKE '%/" + str( self.unit.parentId) + "/%' And" if recommendState == "1": custormAndWhereClause += " r.rcmdPathInfo LIKE '%/" + str( self.unit.unitId) + "/%' And" elif recommendState == "0": custormAndWhereClause += " (r.rcmdPathInfo Is Null or r.rcmdPathInfo Not LIKE '%/" + str( self.unit.unitId) + "/%') And" if auditState == "0": custormAndWhereClause += " r.approvedPathInfo LIKE '%/" + str( self.unit.unitId) + "/%' And" elif auditState == "1": custormAndWhereClause += " (r.approvedPathInfo Is Null or r.approvedPathInfo NOT LIKE '%/" + str( self.unit.unitId) + "/%') And" if custormAndWhereClause[len(custormAndWhereClause) - 3:] == "And": custormAndWhereClause = custormAndWhereClause[ 0:len(custormAndWhereClause) - 3] query.custormAndWhereClause = custormAndWhereClause # 计算总量. pager = self.createPager() pager.pageSize = 20 pager.totalRows = query.count() # 得到资源. resource_list = query.query_map(pager) request.setAttribute("pager", pager) request.setAttribute("resource_list", resource_list) request.setAttribute("multiPushState", multiPushState) request.setAttribute("recommendState", recommendState) request.setAttribute("auditState", auditState)
def show_list(self): qry = ResourceQuery( """ r.resourceId,r.title,r.userId,r.pushState,r.unitId,r.href,r.pushUserId """ ) qry.pushState = 2 # 待推送 pager = self.params.createPager() pager.itemName = u"资源" pager.itemUnit = u"个" pager.pageSize = 25 pager.totalRows = qry.count() resource_list = qry.query_map(pager) request.setAttribute("resource_list", resource_list) request.setAttribute("pager", pager) return "/WEB-INF/push/admin_push_resource_list.ftl"
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 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"
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"
def get_request(self): query = ResourceQuery( """ r.resourceId, r.title, r.shareMode, r.createDate, r.href, r.subjectId, r.gradeId, r.rcmdPathInfo,r.unitId, r.delState, r.unitPathInfo, r.approvedPathInfo, r.downloadCount, r.commentCount, r.fsize, r.auditState, r.recommendState, r.tags, r.addIp, u.userId, u.loginName, u.nickName, sc.name as sysCateName """) query.unitId = None query.auditState = None query.delState = None multiPushState = self.params.safeGetStringParam("multiPushState") recommendState = self.params.safeGetStringParam("recommendState") auditState = self.params.safeGetStringParam("auditState") delState = self.params.safeGetStringParam("delState") custormAndWhereClause = "r.orginPathInfo LIKE '%/" + str( self.unit.unitId) + "/%' And r.unitId <> " + str( self.unit.unitId) + " And" # 得到全部的下级单位 unitList = self.unitService.getDownUnitList(self.unit) if recommendState == "1": strRcmd = "" for ut in unitList: strRcmd = strRcmd + " r.rcmdPathInfo LIKE '%/" + str( ut.unitId) + "/%' or" if strRcmd != "": strRcmd = strRcmd[0:len(strRcmd) - 2] custormAndWhereClause += " (" + strRcmd + ") And" elif recommendState == "0": strRcmd = "" for ut in unitList: strRcmd = strRcmd + " r.rcmdPathInfo Not LIKE '%/" + str( ut.unitId) + "/%' And" if strRcmd != "": strRcmd = strRcmd[0:len(strRcmd) - 3] custormAndWhereClause += " (r.rcmdPathInfo Is Null or (" + strRcmd + ")) And" if auditState == "0": strApprove = "" for ut in unitList: strApprove = strApprove + " r.approvedPathInfo LIKE '%/" + str( ut.unitId) + "/%' or" if strApprove != "": strApprove = strApprove[0:len(strApprove) - 2] custormAndWhereClause += "(" + strApprove + ") And" elif auditState == "1": strApprove = "" for ut in unitList: strApprove = strApprove + " r.approvedPathInfo NOT LIKE '%/" + str( ut.unitId) + "/%' And" if strApprove != "": strApprove = strApprove[0:len(strApprove) - 3] custormAndWhereClause += " (r.approvedPathInfo Is Null or (" + strApprove + ")) And" """ if auditState == "0": custormAndWhereClause += " r.approvedPathInfo LIKE '%/" + str(self.unit.unitId) + "/%' And" elif auditState == "1": custormAndWhereClause += " (r.approvedPathInfo Is NUll or r.approvedPathInfo NOT LIKE '%/" + str(self.unit.unitId) + "/%') And" if multiPushState == "1": custormAndWhereClause += " r.unitPathInfo LIKE '%/" + str(self.unit.parentId) + "/%' And" elif multiPushState == "0": custormAndWhereClause += " r.unitPathInfo NOT LIKE '%/" + str(self.unit.parentId) + "/%' And" if recommendState == "1": custormAndWhereClause += " r.rcmdPathInfo LIKE '%/" + str(self.unit.unitId) + "/%' And" elif recommendState == "0": custormAndWhereClause += " (r.rcmdPathInfo Is NULL or r.rcmdPathInfo NOT LIKE '%/" + str(self.unit.unitId) + "/%') And" """ if delState == "0": query.delState = False elif delState == "1": query.delState = True if custormAndWhereClause[len(custormAndWhereClause) - 3:] == "And": custormAndWhereClause = custormAndWhereClause[ 0:len(custormAndWhereClause) - 3] query.custormAndWhereClause = custormAndWhereClause #print custormAndWhereClause # 计算总量. pager = self.createPager() pager.pageSize = 20 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("delState", delState) request.setAttribute("multiPushState", multiPushState) request.setAttribute("recommendState", recommendState) request.setAttribute("auditState", auditState) #self.putSubjectList() #self.putGradeList() self.putResourceCategoryTree()