def get(self, n=1):
zsite_id = self.zsite_id
cid = self.cid
page_template = self.page_template
total = fav_po_count_by_user_id_cid(zsite_id, cid)
n = int(n)
page, limit, offset = page_limit_offset(
page_template,
total,
n,
PAGE_LIMIT
)
if n != 1 and offset >= total:
return self.redirect(page_template[:-3])
li = fav_po_list_by_user_id_cid(zsite_id, cid, limit, offset)
if cid == CID_WORD:
rid_po_list = [i for i in li if i.rid]
Po.mc_bind(rid_po_list, 'question', 'rid')
Zsite.mc_bind([i.target for i in rid_po_list], 'user', 'user_id')
self.render(
cid=cid,
total=total,
li=li,
page=page,
back_a='/fav',
)
def hero_page(n):
n = int(n)
count = zsite_show_count(CID_USER)
page, limit, offset = page_limit_offset('//hero.%s/-%%s' % SITE_DOMAIN,
count, n, 64)
zsite_list = zsite_show_list(CID_USER, limit, offset)
return zsite_list, page
def get(self, n=1):
zsite = self.zsite
zsite_id = self.zsite_id
user_id = self.current_user_id
cid = CID_EVENT
if zsite.cid == CID_SITE:
total = po_cid_count_by_zsite_id(zsite_id, cid)
template = '/ctrl/zsite/po_view/site_po_page.htm'
else:
total = event_join_count_by_user_id(zsite_id)
template = 'ctrl/zsite/event/event_page.htm'
page, limit, offset = page_limit_offset(
'/event-%s',
total,
n,
PAGE_LIMIT
)
if zsite.cid == CID_SITE:
li = feed_po_list_by_zsite_id(user_id, zsite_id, cid, limit, offset)
else:
li = event_list_join_by_user_id(zsite_id, limit, offset)
self.render(
template,
li=li,
cid=cid,
page=page,
total=total,
)
def get(self, cid, n=1):
cid = int(cid)
qs = Reply.where('cid = %s', cid)
total = qs.count()
page, limit, offset = page_limit_offset(
'/reply_list/%s-%%s'%cid,
total,
n,
PAGE_LIMIT,
)
li = qs.order_by('id desc')[offset: offset + limit]
txt_bind(li)
#print cid == CID_USER
if cid == CID_USER:
Wall.mc_bind(li, 'wall', 'rid')
wall_list = [i.wall for i in li]
Zsite.mc_bind(wall_list, 'from_user', 'from_id')
Zsite.mc_bind(wall_list, 'to_user', 'to_id')
else:
Po.mc_bind(li, 'po', 'rid')
Zsite.mc_bind(li, 'user', 'user_id')
self.render(
reply_list=li,
page=page,
)
def get(self, pid, cid=0, n=1):
pid = int(pid)
cid = int(cid)
_pid = pid_city(pid)
if not _pid:
return self.redirect('/')
if _pid != pid:
return self.redirect('/%s'%_pid)
if cid:
page_template = '/%s/%s-%%s' % (pid, cid)
else:
page_template = '/%s-%%s' % pid
total = event_count_by_city_pid_cid(pid, cid)
page, limit, offset = page_limit_offset(
page_template,
total,
n,
PAGE_LIMIT,
)
event_list = event_list_by_city_pid_cid(pid, cid, limit, offset)
return self.render(
pid=pid,
cid=cid,
event_list=event_list,
page=page,
)
def get(self, n=1):
qs = Po.where("state>%s", STATE_RM).where("zsite_id=user_id")
total = qs.count()
page, limit, offset = page_limit_offset("/po/zsite-%s", total, n, PAGE_LIMIT)
li = qs.order_by("id desc")[offset : offset + limit]
Po.mc_bind(li, "question", "rid")
self.render(po_list=li, page=page)
def get(self, n=1):
zsite = self.zsite
zsite_id = self.zsite_id
user_id = self.current_user_id
cid = CID_EVENT
if zsite.cid == CID_SITE:
total = po_cid_count_by_zsite_id(zsite_id, cid)
template = '/ctrl/zsite/po_view/site_po_page.htm'
else:
total = event_join_count_by_user_id(zsite_id)
template = 'ctrl/zsite/event/event_page.htm'
page, limit, offset = page_limit_offset('/event-%s', total, n,
PAGE_LIMIT)
if zsite.cid == CID_SITE:
li = feed_po_list_by_zsite_id(user_id, zsite_id, cid, limit,
offset)
else:
li = event_list_join_by_user_id(zsite_id, limit, offset)
self.render(
template,
li=li,
cid=cid,
page=page,
total=total,
)
def get(self, pid, cid=0, n=1):
pid = int(pid)
cid = int(cid)
_pid = pid_city(pid)
if not _pid:
return self.redirect('/')
if _pid != pid:
return self.redirect('/%s' % _pid)
if cid:
page_template = '/%s/%s-%%s' % (pid, cid)
else:
page_template = '/%s-%%s' % pid
total = event_count_by_city_pid_cid(pid, cid)
page, limit, offset = page_limit_offset(
page_template,
total,
n,
PAGE_LIMIT,
)
event_list = event_list_by_city_pid_cid(pid, cid, limit, offset)
return self.render(
pid=pid,
cid=cid,
event_list=event_list,
page=page,
)
def get(self, zsite_tag_id, n=1):
tag = ZsiteTag.mc_get(zsite_tag_id)
zsite_id = self.zsite_id
user_id = self.current_user_id
cid = self.cid
is_self = zsite_id == user_id
n = int(n)
total = zsite_tag_cid_count(zsite_tag_id, cid)
page, limit, offset = page_limit_offset(
'/tag/%s'%zsite_tag_id + self.page_template,
total,
n,
PAGE_LIMIT
)
if n != 1 and offset >= total:
return self.redirect(self.page_template[:-3])
po_list = Po.mc_get_list(po_id_list_by_zsite_tag_id_cid(zsite_tag_id, cid, limit, offset))
self.render(
cid=cid,
is_self=is_self,
total=total,
li=po_list,
page=page,
tag_name=Tag.get(tag.tag_id),
back_a='/tag/%s'%zsite_tag_id
)
def get(self, id, n=1):
po = self.po(id)
if po is None:
return
path = '/%s/fav' % id
total = vote_up_count(id)
page, limit, offset = page_limit_offset(
'%s-%%s' % path,
total,
n,
PAGE_LIMIT
)
if type(n) == str and offset >= total:
return self.redirect(path)
id_list = vote_user_id_list(id, limit, offset)
zsite_list = Zsite.mc_get_list(id_list)
self.render(
po=po,
zsite_list=zsite_list,
page=page,
title='分享',
path=path,
)
def get(self, state=STATE_NEW, n=1):
total = get_tem_total_by_state(state)
page, limit, offset = page_limit_offset('/mail/notify/%s-%%s' % state,
total, n, PAGE_LIMIT)
mail_po_list = get_tem_by_state(state, limit, offset)
self.render(mail_po_list=mail_po_list, total=total, page=page)
def get(self, n=1):
zsite_id = self.zsite_id
zsite = self.zsite
if zsite.cid == CID_SITE:
title = '收藏'
total = zsite_fav_count_by_zsite(zsite)
else:
title = '围观'
total = follow_count_by_to_id(zsite_id)
page, limit, offset = page_limit_offset(
'/follower-%s',
total,
n,
PAGE_LIMIT
)
if type(n) == str and offset >= total:
return self.redirect('/follower')
if zsite.cid == CID_SITE:
zsite_list = zsite_fav_list(zsite, limit, offset)
else:
ids = follow_id_list_by_to_id(zsite_id, limit, offset)
zsite_list = Zsite.mc_get_list(ids)
self.render(
'/ctrl/zsite/follow/_base.htm',
zsite_list=zsite_list,
page=page,
title=title,
path='/follower'
)
def get(self, id, n=1):
zsite = self.zsite
zsite_id = zsite.id
zsite_url = zsite.link
current_user_id = self.current_user_id
wall = Wall.mc_get(id)
if not wall:
return self.redirect('/')
zsite_id_list = wall.zsite_id_list()
if zsite_id not in zsite_id_list:
return self.redirect('/')
else:
other = wall.zsite_other(zsite_id)
if other.cid == CID_SITE or zsite_id == current_user_id:
return self.redirect('%s/wall/%s' % (other.link, id))
total = wall.reply_count
page, limit, offset = page_limit_offset(
'%s/wall/%s-%%s' % (zsite_url, id), total, n, PAGE_LIMIT)
if type(n) == str and offset >= total:
return self.redirect(zsite_url)
reply_list = wall.reply_list_reversed(limit, offset)
self.render(wall=wall,
zsite_id_list=zsite_id_list,
reply_list=reply_list,
page=page)
def get(self, cid=0, n=1):
if cid:
cid = int(cid)
if cid not in CID_ZSITE_TUPLE:
return self.redirect('/following')
zsite_id = self.zsite_id
if cid:
id_list = follow_id_list_by_from_id_cid(zsite_id, cid)
else:
id_list = follow_id_list_by_from_id(zsite_id)
total = len(id_list)
page, limit, offset = page_limit_offset(
'/following%s-%%s' % (cid or ''),
total,
n,
PAGE_LIMIT
)
if type(n) == str and offset >= total:
return self.redirect('/following%s' % (cid or ''))
id_list = id_list[offset: offset + limit]
following = Zsite.mc_get_list(id_list)
self.render(
zsite_list=following,
page=page,
title='关注',
path='/following%s'%(cid or '')
)
def get(self, id, n=1):
po = self.po(id)
if po is None:
return
path = '/%s/fav' % id
total = fav_user_count_by_po_id(id)
page, limit, offset = page_limit_offset(
'%s-%%s' % path,
total,
n,
PAGE_LIMIT
)
if type(n) == str and offset >= total:
return self.redirect(path)
zsite_list = fav_user_list_by_po_id(id, limit, offset)
self.render(
po=po,
zsite_list=zsite_list,
page=page,
title='收藏',
path=path,
)
def get(self, n=1):
zsite_id = self.zsite_id
zsite = self.zsite
if zsite.cid == CID_SITE:
title = '收藏'
total = zsite_fav_count_by_zsite(zsite)
else:
title = '围观'
total = follow_count_by_to_id(zsite_id)
page, limit, offset = page_limit_offset('/follower-%s', total, n,
PAGE_LIMIT)
if type(n) == str and offset >= total:
return self.redirect('/follower')
if zsite.cid == CID_SITE:
zsite_list = zsite_fav_list(zsite, limit, offset)
else:
ids = follow_id_list_by_to_id(zsite_id, limit, offset)
zsite_list = Zsite.mc_get_list(ids)
self.render('/ctrl/zsite/follow/_base.htm',
zsite_list=zsite_list,
page=page,
title=title,
path='/follower')
def get(self, n=1):
n = int(n)
total = weekly_mail_total()
page, limit, offset = page_limit_offset('/weekly/mail-%s', total, n,
PAGE_LIMIT)
wm_list = weekly_mail_list_limit(limit, offset)
self.render(wm_list=wm_list, page=page)
def get(self, n=1):
user_id = self.current_user_id
total = buzz_count(user_id)
page, limit, offset = page_limit_offset("/notice/buzz-%s", total, n, 100)
if type(n) == str and offset >= total:
return self.redirect("/notice/buzz")
self.render(buzz_list=buzz_list(user_id, limit, offset), page=page)
def get(self, n=1):
n = int(n)
count = zsite_user_verify_count()
page, limit, offset = page_limit_offset('/user_show_id_list-%s', count,
n, 64)
zsite_list = Zsite.where(cid=CID_USER).where(
'state>=%s' %
ZSITE_STATE_VERIFY).order_by('id desc')[offset:offset + limit]
self.render(zsite_list=zsite_list, page=page)
def get(self, cid, state, n=1):
path_base = self.request.path.split("-", 1)[0]
total = pic_reviewed_count_by_cid_state(cid, state)
page, limit, offset = page_limit_offset("%s-%%s" % path_base, total, n, PAGE_LIMIT)
if type(n) == str and offset >= total:
return self.redirect(path_base)
pic_list = pic_list_reviewed_by_cid_state(cid, state, limit, offset)
Zsite.mc_bind(pic_list, "user", "user_id")
self.render(cid=int(cid), state=int(state), pic_list=pic_list, total=total, page=page)
def get(self, n=1):
zsite_id = self.zsite_id
user_id = self.current_user_id
zsite = self.zsite
zsite_cid = zsite.cid
if zsite_cid == CID_SITE:
self.template = '/ctrl/zsite/po_view/site_po_page.htm'
else:
self.template = '/ctrl/zsite/po_view/po_page.htm'
cid = self.cid
page_template = self.page_template
n = int(n)
if zsite_cid == CID_SITE:
total = po_cid_count_by_zsite_id(zsite_id, cid)
else:
is_self = zsite_id == user_id
total = po_list_count(zsite_id, cid, is_self)
page, limit, offset = page_limit_offset(
page_template,
total,
n,
PAGE_LIMIT
)
if n != 1 and offset >= total:
return self.redirect(page_template[:-3])
if zsite_cid == CID_SITE:
po_list = feed_po_list_by_zsite_id(user_id, zsite_id, cid, limit, offset)
back_a = None
total = 0
else:
po_list = po_view_list(zsite_id, cid, is_self, limit, offset)
if cid == CID_WORD:
rid_po_list = [i for i in po_list if i.rid]
Po.mc_bind(rid_po_list, 'question', 'rid')
Zsite.mc_bind([i.target for i in rid_po_list], 'user', 'user_id')
if is_self:
back_a = '/feed'
else:
back_a = '/'
self.render(
cid=cid,
total=total,
li=po_list,
page=page,
back_a=back_a,
)
def render_zsite_site(self, n=1, page_template='/-%s'):
zsite_id = self.zsite_id
user_id = self.current_user_id
total = po_cid_count_by_zsite_id(zsite_id, 0)
page, limit, offset = page_limit_offset(page_template, total, n,
PAGE_LIMIT)
li = feed_po_list_by_zsite_id(user_id, zsite_id, 0, limit, offset)
page = page
return li, page
def get(self, n=1):
user_id = self.current_user_id
total = notice_count(user_id)
page, limit, offset = page_limit_offset("/notice-%s", total, n, PAGE_LIMIT)
if type(n) == str and offset >= total:
return self.redirect("/notice")
unread = notice_unread.get(user_id)
if unread:
notice_unread.set(user_id, 0)
self.render(notice_list=notice_list(user_id, limit, offset), page=page)
def get(self, n=1):
current_user = self.current_user
current_user_url = current_user.link
total = buzz_at_count(current_user.id)
page, limit, offset = page_limit_offset("%s/notice/buzz/at-%%s" % current_user_url, total, n, PAGE_LIMIT)
reply_list = buzz_at_list(current_user.id, limit, offset)
self.render(reply_list=reply_list, page=page)
def get(self, n=1):
zsite = self.zsite
zsite_url = zsite.link
total = zsite.reply_count
page, limit, offset = page_limit_offset('%s/wall-%%s' % zsite_url,
total, n, PAGE_LIMIT)
reply_list = zsite.reply_list_reversed(limit, offset)
self.render(reply_list=reply_list, page=page)
def get(self, n=1):
count = product_count()
page, limit, offset = page_limit_offset(
'/product-%s',
count,
n,
PAGE_LIMIT,
)
li = product_list(limit, offset)
Zsite.mc_bind(li, 'zsite', 'zsite_id')
self.render(li=li, page=str(page))
def get(self, n=1):
current_user = self.current_user
current_user_url = current_user.link
total = buzz_at_count(current_user.id)
page, limit, offset = page_limit_offset(
'%s/notice/buzz/at-%%s' % current_user_url, total, n, PAGE_LIMIT)
reply_list = buzz_at_list(current_user.id, limit, offset)
self.render(reply_list=reply_list, page=page)
def get(self, n=1):
qs = Zsite.where(cid=CID_COM)
total = qs.count()
page, limit, offset = page_limit_offset(
'/com-%s',
total,
n,
PAGE_LIMIT,
)
li = qs.order_by('id desc')[offset:offset + limit]
self.render(li=li, page=page)
def get(self, n=1):
user_id = self.current_user_id
total = buzz_count(user_id)
page, limit, offset = page_limit_offset('/notice/buzz-%s', total, n,
100)
if type(n) == str and offset >= total:
return self.redirect('/notice/buzz')
self.render(
buzz_list=buzz_list(user_id, limit, offset),
page=page,
)
def _page(self, n, rank, q):
page, limit, offset = page_limit_offset(
'/google_plus-%s',
GoogleRank.count(),
n,
50,
)
rank_list = GoogleRank.mc_get_list(GoogleRank.where().order_by('follower desc').col_list(limit, offset))
return self.render(
q=q, rank=rank, page=page, rank_list=rank_list, offset=offset
)
def get(self, n=1):
total = self._total()
n = int(n)
page, limit, offset = page_limit_offset(
self.page_url,
total,
n,
PAGE_LIMIT,
)
page_list = self._page_list(limit, offset)
return self.render(page_list=page_list, page=str(page), total=total)
def get(self, n):
page, limit, offset = page_limit_offset(
'/po/show-%s',
po_show_count(),
n,
PAGE_LIMIT,
)
li = po_show_list(limit, offset)
self.render(
po_list=li,
page=page,
)
def get(self, state, n=1):
state = int(state)
qs = Zsite.where(cid=CID_COM)
total = qs.count()
page, limit, offset = page_limit_offset(
'/com/%s-%%s' % state,
total,
n,
PAGE_LIMIT,
)
li = qs.order_by('id desc')[offset:offset + limit]
self.render(state=state, li=li, page=page)
def get(self, n=1):
total = Zsite.where().count()
page, limit, offset = page_limit_offset(href='/user_list-%s',
total=total,
n=n,
limit=PAGE_LIMIT)
user_list = Zsite.where(
cid=CID_USER).order_by('id desc')[offset:offset + limit]
self.render(
user_list=user_list,
page=page,
)
def get(self, n=1):
total = buzz_sys_count()
page, limit, offset = page_limit_offset(
'/buzz/sys-%s',
total,
n,
PAGE_LIMIT,
)
li = buzz_sys_list(limit, offset)
self.render(
li=li,
page=page,
)
def get(self, n=1):
total = buzz_sys_count()
page, limit, offset = page_limit_offset(
'/buzz/sys-%s',
total,
n,
PAGE_LIMIT,
)
li = buzz_sys_list(limit, offset)
self.render(
li=li,
page=page,
)
def get(self, n=1):
total = OauthClient.where().count()
page, limit, offset = page_limit_offset(href='/apply_list-%s',
total=total,
n=n,
limit=PAGE_LIMIT)
apply_list = OauthClient.where().order_by('id desc')[offset:offset +
limit]
self.render(
apply_list=apply_list,
page=page,
)
def get(self, n=1):
total = Trade.where('state=%s', TRADE_STATE_FINISH).count()
page, limit, offset = page_limit_offset(href='/trade_list-%s',
total=total,
n=n,
limit=PAGE_LIMIT)
trade_list = Trade.where(
'state=%s',
TRADE_STATE_FINISH).order_by('id desc')[offset:offset + limit]
self.render(
trade_list=trade_list,
page=page,
)
def get(self, n=1):
user_id = self.current_user_id
total = notice_count(user_id)
page, limit, offset = page_limit_offset('/notice-%s', total, n,
PAGE_LIMIT)
if type(n) == str and offset >= total:
return self.redirect('/notice')
unread = notice_unread.get(user_id)
if unread:
notice_unread.set(user_id, 0)
self.render(
notice_list=notice_list(user_id, limit, offset),
page=page,
)
def get(self, n=1):
total = Zsite.where().count()
page, limit, offset = page_limit_offset(
href='/user_list-%s',
total=total,
n=n,
limit=PAGE_LIMIT
)
user_list = Zsite.where(cid=CID_USER).order_by('id desc')[offset:offset+limit]
self.render(
user_list=user_list,
page=page,
)
def get(self, n=1):
total = Trade.where('state=%s', TRADE_STATE_FINISH).count()
page, limit, offset = page_limit_offset(
href='/trade_list-%s',
total=total,
n=n,
limit=PAGE_LIMIT
)
trade_list = Trade.where('state=%s', TRADE_STATE_FINISH).order_by('id desc')[offset:offset+limit]
self.render(
trade_list=trade_list,
page=page,
)
def get(self, gid=0, n=1):
gid = int(gid)
total = rss_total_gid(gid)
page, limit, offset = page_limit_offset(
'/rss/gid/%s-%%s'%gid,
total,
n,
PAGE_LIMIT
)
rss_list = get_rss_by_gid(gid, limit, offset)
self.render(
rss=rss_list,
page=page
)
def get(self, n=1):
total = OauthClient.where().count()
page, limit, offset = page_limit_offset(
href='/apply_list-%s',
total=total,
n=n,
limit=PAGE_LIMIT
)
apply_list = OauthClient.where().order_by('id desc')[offset:offset+limit]
self.render(
apply_list=apply_list,
page=page,
)
def get(self, n=1):
qs = Zsite.where(cid=CID_COM)
total = qs.count()
page, limit, offset = page_limit_offset(
'/com-%s',
total,
n,
PAGE_LIMIT,
)
li = qs.order_by('id desc')[offset: offset+limit]
self.render(
li=li,
page=page
)
def get(self, n=1):
count = product_count()
page, limit, offset = page_limit_offset(
'/product-%s',
count,
n,
PAGE_LIMIT,
)
li = product_list(limit, offset)
Zsite.mc_bind(li, 'zsite', 'zsite_id')
self.render(
li=li,
page=str(page)
)
def get(self, n=1):
n = int(n)
total = weekly_mail_total()
page, limit, offset = page_limit_offset(
'/weekly/mail-%s',
total,
n,
PAGE_LIMIT
)
wm_list = weekly_mail_list_limit(limit, offset)
self.render(
wm_list=wm_list,
page=page
)
def get(self, state=STATE_NEW, n=1):
total = get_tem_total_by_state(state)
page, limit, offset = page_limit_offset(
'/mail/notify/%s-%%s'%state,
total,
n,
PAGE_LIMIT
)
mail_po_list = get_tem_by_state(state, limit, offset)
self.render(
mail_po_list=mail_po_list,
total=total,
page=page
)
def get(self, tag_id, n):
zsite_id = self.zsite_id
current_user_id = self.current_user_id
tag_id = int(tag_id)
if tag_id == 0:
count = rec_read_log_count_by_user_id(current_user_id)
id_list_getter = lambda limit, offset: rec_read_log_by_user_id(
current_user_id, limit, offset)
page, limit, offset = page_limit_offset(
'javascript:tag_cid_page(%s,%%s)' % tag_id, count, n, PAGE_LIMIT)
li = id_list_getter(limit, offset)
page = str(page) or 0
self.finish({'li': po_json(current_user_id, li, 47), 'page': page})
def get(self, n):
zsite_id = self.zsite_id
current_user_id = self.current_user_id
can_admin = zsite_member_can_admin(zsite_id, current_user_id)
if can_admin:
return self.redirect('/review/admin')
count = po_review_count(zsite_id)
page, limit, offset = page_limit_offset(
'/review-%s',
count,
n,
PAGE_LIMIT,
)
review_list = po_review_list_by_zsite_id(zsite_id, limit, offset)
self.render(can_admin=can_admin, page=page, review_list=review_list)
def get(self, state=RSS_UNCHECK, n=1):
total = rss_po_total(state)
page, limit, offset = page_limit_offset(
'/rss/index/%s-%%s'%state,
total,
n,
PAGE_LIMIT
)
rss_po_list = rss_po_list_by_state(state, limit, offset)
self.render(
rss_po_list=rss_po_list,
page=page,
rss_state=state
)
def get(self, n=1):
total = self._total()
n = int(n)
page, limit, offset = page_limit_offset(
self.page_url,
total,
n,
PAGE_LIMIT,
)
page_list = self._page_list(limit, offset)
return self.render(
page_list=page_list,
page=str(page),
total=total
)
def get(self, state=0, n=1):
state = int(state)
total = site_count_by_state(state)
page, limit, offset = page_limit_offset(
'/site/%s-%%s'%state,
total,
n,
PAGE_LIMIT
)
site_id_list = site_id_list_by_state(state, limit, offset)
self.render(
site_id_list=site_id_list,
page=page
)
def render_zsite_site(self, n=1, page_template='/-%s'):
zsite_id = self.zsite_id
user_id = self.current_user_id
total = po_cid_count_by_zsite_id(zsite_id, 0)
page, limit, offset = page_limit_offset(
page_template,
total,
n,
PAGE_LIMIT
)
li = feed_po_list_by_zsite_id(
user_id, zsite_id, 0, limit, offset
)
page = page
return li, page
def get(self, state, n=1):
state = int(state)
qs = Zsite.where(cid=CID_COM)
total = qs.count()
page, limit, offset = page_limit_offset(
'/com/%s-%%s'%state,
total,
n,
PAGE_LIMIT,
)
li = qs.order_by('id desc')[offset:offset+limit]
self.render(
state=state,
li=li,
page=page
)
