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 execute(self): self.params = ParamUtil(request) userId = self.params.safeGetIntParam("userId", 0) listCount = self.params.safeGetIntParam("count", 4) fwidth = self.params.safeGetIntParam("fwidth", 200) fheight = self.params.safeGetIntParam("fheight", 200) ftxtheight = self.params.safeGetIntParam("ftxtheight", 36) fbgcolor = self.params.safeGetStringParam("fbgcolor") if fbgcolor == "": fbgcolor = "#E5ECF4" if userId == 0: request.setAttribute("ErrText", "没有找到所查询的图片") return "/WEB-INF/ftl/webpart_error.ftl" user = user_svc.getUserById(userId) if user == None: request.setAttribute("ErrText", "没有找到该用户") return "/WEB-INF/ftl/webpart_error.ftl" qry = PhotoQuery(""" p.photoId, p.title, p.href """) qry.userId = userId qry.orderType = 0 qry.extName = ".jpg" qry.isPrivateShow = None result = qry.query_map(listCount) request.setAttribute("user", user) request.setAttribute("photo_list", result) request.setAttribute("fwidth", fwidth) request.setAttribute("fheight", fheight) request.setAttribute("ftxtheight", ftxtheight) request.setAttribute("fbgcolor", fbgcolor) response.contentType = "text/html; charset=UTF-8" return "/WEB-INF/user/default/flash_photo.ftl"