def GET(self): user = nothing.get_current_user() if user: data = web.input() page = 1 item_num = config.item_num if "page" in data: page = int(data.page) fav_sql = "select * from favorite where username = '******' LIMIT %d,%d" % ( user.username, (page - 1) * item_num, (page - 1) * item_num + item_num + 1, ) favorites = [fav.item_id for fav in model.db.query(fav_sql)] hasnext = len(favorites) > item_num if hasnext: favorites.pop() items = [] if len(favorites) > 0: sql = "select * from item where" for index, i in enumerate(favorites): if index == len(favorites) - 1: sql += " id=%d" % i else: sql += " id=%d" % i + " or" items = [item for item in model.db.query(sql)] for item in items: item["favorited"] = True return nothing.render("edituser.html", {"items": items, "hasnext": hasnext, "haspre": page > 1}) raise web.seeother("/signin")
def GET(self): user = nothing.get_current_user() if user and user.isAdmin: data = web.input() page = 1 if 'page' in data: page = int(data.page) items,hasnext = nothing.get_items_by_page(page) return nothing.render('edititems.html',{'items':items,'page':page,'hasnext':hasnext,'haspre':page>1}) else: return "you has not login or you are not admin"
def GET(self,item_id): items = model.db.select('item',where='id=$item_id',vars=locals()) if len(items)>0: item = items[0] item['favorited'] = False user = nothing.get_current_user() if user: fs = model.db.query("select * from favorite where item_id=%d and username='******'" % (int(item_id),user.username)) item['favorited'] = len(fs)>0 return nothing.render('item.html', {'item':item}) return 'sorry,item not found'
def GET(self): user = nothing.get_current_user() if user and user.isAdmin: item_id = web.input().item_id items = model.db.select('item',where='id=$item_id',vars=locals()) if len(items)>0: item = items[0] return nothing.render('edititem.html',{'item':item}) else: return 'item not found' else: return "you has not login or you are not admin"
def GET(self,tag): data = web.input() page = 1 item_num = config.item_num if 'page' in data: page = int(data.page) sql = "select * from item where tag = '%s' LIMIT %d,%d" % (tag, (page-1)*item_num, (page-1)*item_num+item_num+1) items = [item for item in model.db.query(sql)] hasnext = len(items)>item_num if hasnext: items.pop() return nothing.render('tag.html', {'items':items,'hasnext':hasnext,'haspre':page>1})
def GET(self): user = nothing.get_current_user() if user and user.isAdmin: return nothing.render("deleteitem.html") else: return "you has not login or you are not admin"
def GET(self, name): user = model.get_user(name) if user: return nothing.render("viewuser.html", {"vuser": user}) return "user not found"