def get_photo_category(self):
# 得到根一级图片分类.
photo_cates = self.get_photo_root_category()
# 得到每个分类的最新的 6 张图片.
qry = PhotoQuery(""" p.photoId, p.title, p.href, u.loginName """)
for c in photo_cates:
qry.sysCateId = c["categoryId"]
c["photo_list"] = qry.query_map(6)
#如果没有分类，则显示当前的全部图片
if len(photo_cates) == 0:
photo_cates = None
pager = self.params.createPager()
pager.itemName = u"图片"
pager.itemUnit = u"张"
pager.pageSize = 24
qry = PhotoQuery(
""" p.photoId, p.title, p.createDate, p.href, u.userId, u.loginName, u.nickName, p.summary """
)
qry.orderType = 0
pager.totalRows = qry.count()
photo_list_all = qry.query_map(pager)
request.setAttribute("photo_list_all", photo_list_all)
request.setAttribute("pager", pager)
#DEBUG: print "photo_cates = ", photo_cates
request.setAttribute("photo_cates", photo_cates)
def get_new_photo_list(self):
qry = PhotoQuery(
""" p.photoId, p.title, p.createDate, p.href, u.userId, u.loginName, u.nickName, p.summary """
)
qry.sysCateId = int(self.categoryId)
qry.orderType = 0 # photoId DESC
new_photo_list = qry.query_map(10)
request.setAttribute("new_photo_list", new_photo_list)
def get_photo_with_pager(self):
pager = self.params.createPager()
pager.itemName = u"图片"
pager.itemUnit = u"张"
pager.pageSize = 24
qry = PhotoQuery(
""" p.photoId, p.title, p.createDate, p.href, u.userId, u.loginName, u.nickName, p.summary """
)
qry.sysCateId = int(self.categoryId)
qry.orderType = 0
pager.totalRows = qry.count()
photo_list = qry.query_map(pager)
request.setAttribute("photo_list", photo_list)
request.setAttribute("pager", pager)
def List(self) :
# 构造查询.
query = PhotoQuery(""" p.photoId, p.title, p.summary, p.href, p.tags, stap.title as stapTitle,
sc.name as sysPhotoName, p.viewCount, p.createDate, p.addIp,
u.nickName, u.loginName, p.auditState, p.delState, p.isPrivateShow """)
query.unitId = self.unit.unitId
query.isPrivateShow = None
query.auditState = None
query.delState = None
auditState = self.params.safeGetStringParam("auditState")
if auditState=="1":
query.auditState = 1
elif auditState=="0":
query.auditState = 0
isPrivateShow = self.params.safeGetStringParam("isPrivateShow")
if isPrivateShow=="1":
query.isPrivateShow = 1
elif isPrivateShow=="0":
query.isPrivateShow = 0
query.k = self.params.safeGetStringParam("k")
query.f = self.params.safeGetStringParam("f")
query.sysCateId = self.params.getIntParamZeroAsNull("sc")
query.photoStaple = self.params.getIntParamZeroAsNull("ps")
self.putSysCategoryTree()
self.putPhotoStaple()
# TODO: 权限检查.
# 调用分页函数.
pager = self.createPager()
pager.totalRows = query.count()
# 得到所有照片的列表.
photoList = query.query_map(pager)
#print "photoList = ", photoList
# 传给页面.
request.setAttribute("photoList", photoList)
request.setAttribute("pager", pager)
request.setAttribute("auditState", auditState)
request.setAttribute("isPrivateShow", isPrivateShow)
request.setAttribute("k", query.k)
request.setAttribute("f", query.f)
request.setAttribute("sc", query.sysCateId)
request.setAttribute("ps", query.photoStaple)
def get_hot_photo_list(self):
qry = PhotoQuery(""" p.photoId, p.title,u.loginName """)
qry.sysCateId = int(self.categoryId)
qry.orderType = 2 # viewCount DESC
hot_photo_list = qry.query_map(20)
request.setAttribute("hot_photo_list", hot_photo_list)