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"