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"
