def get(self, sid): result = {'total': 0, 'pages': 0, 'data': []} page = self.get_argument("page", 1) total = Consult.select().where(Consult.sid == sid).count() pages = 0 if total > 0: pages = total / 20 page = int(page) if total % 20 > 0: pages = pages + 1 result['total'] = total result['pages'] = pages if total > 0: result['data'] = [ consult for consult in Consult.select().where(Consult.sid == sid). order_by(Consult.replyed.desc()).paginate(page).dicts() ] self.write(simplejson.dumps(result))
def get(self, sid): result = {'total' : 0, 'pages' : 0, 'data' : []} page = self.get_argument("page", 1) total = Consult.select().where(Consult.sid == sid).count() pages = 0 if total > 0: pages = total / 20 page = int(page) if total % 20 > 0: pages = pages + 1 result['total'] = total result['pages'] = pages if total > 0: result['data'] = [consult for consult in Consult.select().where(Consult.sid == sid).order_by(Consult.replyed.desc()).paginate(page).dicts()] self.write(simplejson.dumps(result))
def get(self): page = int(self.get_argument("page", 1)) pagesize = self.settings['admin_pagesize'] cq = Consult.select() total = cq.count() consults = [] for consult in cq.order_by(Consult.posted.desc(), Consult.replyed.asc()).paginate(page, pagesize).dicts(): try: shop = Shop.get(id = consult['sid']) except: shop = Shop consult['shop'] = shop consults.append(consult) self.render('admin/consult.html', consults = consults, total = total, page = page, pagesize = pagesize)
def get(self): user = self.get_current_user() page = int(self.get_argument("page", 1)) pagesize = self.settings["admin_pagesize"] cq = Consult.select().where(Consult.uid == user.id) total = cq.count() consults = [] for consult in cq.paginate(page, pagesize).order_by(Consult.replyed.desc(), Consult.posted.desc()).dicts(): try: shop = Shop.get(id=consult["sid"]) except: shop = Shop consult["shop"] = shop consults.append(consult) self.render("user/consult.html", consults=consults, total=total, page=page, pagesize=pagesize)