def get_group_photo_list(self):
qry = GroupMutilcatesQuery(
""" p.photoId, p.title, p.tags, p.userId, p.createDate,p.href,g.groupTitle,g.groupName """
)
qry.photoCateName = u"成果"
qry.groupCateId = self.categoryId
photo_list = qry.query_map(4)
request.setAttribute("photo_list", photo_list)
def get_group_video_list(self):
qry = GroupMutilcatesQuery(
""" v.videoId, v.title, v.tags, v.userId,v.href,v.flvHref,v.flvThumbNailHref,v.createDate,g.groupTitle,g.groupName """
)
qry.videoCateName = u"成果"
qry.groupCateId = self.categoryId
video_list = qry.query_map(4)
request.setAttribute("video_list", video_list)
def get_group_resource_list(self):
qry = GroupMutilcatesQuery(
""" r.resourceId, r.title,r.userId,r.downloadCount,r.createDate,r.href,g.groupTitle,g.groupName """
)
qry.resourceCateName = u"成果"
qry.groupCateId = self.categoryId
resource_list = qry.query_map(5)
request.setAttribute("resource_list", resource_list)
def get_group_article_list(self):
qry = GroupMutilcatesQuery(
""" a.articleId, a.title,a.userId,a.typeState,a.createDate,g.groupTitle,g.groupName """
)
qry.articleCateName = u"成果"
qry.groupCateId = self.categoryId
article_list = qry.query_map(5)
request.setAttribute("article_list", article_list)
def get_group_video_page_list(self):
qry = GroupMutilcatesQuery(
""" v.videoId, v.title, v.tags, v.userId,v.href,v.flvHref,v.flvThumbNailHref,v.createDate,g.groupTitle,g.groupName """
)
qry.videoCateName = u"成果"
qry.groupCateId = self.categoryId
pager = self.params.createPager()
pager.itemName = u"视频"
pager.itemUnit = u"个"
pager.pageSize = 20
pager.totalRows = qry.count()
video_list = qry.query_map(pager)
request.setAttribute("pager", pager)
request.setAttribute("video_list", video_list)
def get_group_photo_page_list(self):
qry = GroupMutilcatesQuery(
""" p.photoId, p.title, p.tags, p.userId, p.createDate,p.href,g.groupTitle,g.groupName """
)
qry.photoCateName = u"成果"
qry.groupCateId = self.categoryId
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("pager", pager)
request.setAttribute("photo_list", photo_list)
def get_group_resource_page_list(self):
qry = GroupMutilcatesQuery(
""" r.resourceId, r.title,r.userId,r.downloadCount,r.createDate,r.href,g.groupTitle,g.groupName """
)
qry.resourceCateName = u"成果"
qry.groupCateId = self.categoryId
pager = self.params.createPager()
pager.itemName = u"文章"
pager.itemUnit = u"篇"
pager.pageSize = 20
pager.totalRows = qry.count()
resource_list = qry.query_map(pager)
request.setAttribute("pager", pager)
request.setAttribute("resource_list", resource_list)
def get_group_article_page_list(self):
qry = GroupMutilcatesQuery(
""" a.articleId, a.title,a.userId,a.typeState,a.createDate,g.groupTitle,g.groupName """
)
qry.articleCateName = u"成果"
qry.groupCateId = self.categoryId
pager = self.params.createPager()
pager.itemName = u"文章"
pager.itemUnit = u"篇"
pager.pageSize = 20
pager.totalRows = qry.count()
article_list = qry.query_map(pager)
request.setAttribute("pager", pager)
request.setAttribute("article_list", article_list)