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"