def show_specialSubject(self): qry = PhotoQuery(""" p.photoId, p.title, p.userId,p.href, p.userTrueName,u.loginName """) qry.specialSubjectId = self.specialSubject.specialSubjectId qry.extName = ".jpg" ssp_list = qry.query_map(6) qry = SpecialSubjectArticleQuery(""" ssa.articleId, ssa.title, ssa.userId, ssa.userTrueName, ssa.createDate, ssa.loginName, ssa.typeState """) qry.specialSubjectId = self.specialSubject.specialSubjectId ssa_list = qry.query_map(10) qry = SpecialSubjectQuery(""" ss.specialSubjectId, ss.objectGuid, ss.title,ss.logo,ss.description,ss.createDate,ss.expiresDate """) qry.objectId = self.subject.subjectId qry.objectType = "subject" ss_list = qry.query_map(10) if ssp_list != None and len(ssp_list) > 0: request.setAttribute("specialSubjectPhotoList", ssp_list) request.setAttribute("specialSubjectArticleList", ssa_list) request.setAttribute("specialSubjectList", ss_list) request.setAttribute("specialSubject", self.specialSubject) request.setAttribute("subject", self.subject) request.setAttribute("head_nav", "specialsubject") if self.unitId != None and self.unitId != 0: request.setAttribute("unitId", self.unitId) self.video_list() return "/WEB-INF/subjectpage/" + self.templateName + "/specialsubject_page.ftl"
def photoList(self): pager = self.params.createPager() pager.itemName = u"图片" pager.itemUnit = u"张" pager.pageSize = 48 qry = PhotoQuery(""" p.photoId, p.title, p.userId,p.href, p.userTrueName,u.loginName """) qry.specialSubjectId = self.specialSubjectId pager.totalRows = qry.count() photo_list = qry.query_map(pager) request.setAttribute("photo_list", photo_list) request.setAttribute("pager", pager) return "/WEB-INF/ftl/specialsubject/specialsubject_photo_list.ftl"
def get_method(self): qry = PhotoQuery( """ p.title, p.photoId, p.userId, p.createDate, p.href """) qry.specialSubjectId = self.specialSubject.specialSubjectId pager = self.params.createPager() pager.itemName = u"图片" pager.itemUnit = u"个" pager.pageSize = 20 pager.totalRows = qry.count() photo_list = qry.query_map(pager) request.setAttribute("photo_list", photo_list) request.setAttribute("pager", pager) request.setAttribute("specialSubject", self.specialSubject) return "/WEB-INF/subjectmanage/specialsubject_photo_list.ftl"
def show_specialsubject_photo_list(self): qry = PhotoQuery( """ p.photoId, p.title, p.userId,p.href, p.userTrueName,u.loginName """ ) qry.specialSubjectId = self.specialSubject.specialSubjectId pager = self.params.createPager() pager.itemName = u"图片" pager.itemUnit = u"个" pager.pageSize = 20 pager.totalRows = qry.count() photo_list = qry.query_map(pager) request.setAttribute("photo_list", photo_list) request.setAttribute("pager", pager) request.setAttribute("specialSubject", self.specialSubject) request.setAttribute("subject", self.subject) request.setAttribute("head_nav", "specialsubject") return "/WEB-INF/subjectpage/" + self.templateName + "/show_photo_list.ftl"