def POST(self):
user = nothing.get_current_user()
if user:
username = user.username
user_data = web.input()
name = user_data.name
gender = int(user_data.gender)
mark = user_data.mark
mobile = user_data.mobile
telephone = user_data.telephone
adress1 = user_data.adress1
adress2 = user_data.adress2
model.db.update(
"user",
where="username=$username",
vars=locals(),
name=name,
gender=gender,
mark=mark,
mobile=mobile,
telephone=telephone,
adress1=adress1.encode(),
adress2=adress2.encode(),
)
user.name = name
user.gender = gender
user.mark = mark
user.mobile = mobile
user.telephone = telephone
user.adress1 = adress1
user.adress2 = adress2
raise web.seeother("/user/view/" + user.username)
raise web.seeother("/signin")
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:
data = web.input()
item_num = config.item_num
page = 1
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
item.creattime = str(item.creattime).split(".")[0]
web.header("Content-Type", "application/json")
dic = {"result": True, "items": items, "hasnext": hasnext, "haspre": page > 1}
return json.dumps(dic)
def POST(self):
user = nothing.get_current_user()
if user:
post_data = web.input(img={})
filedir = "/static/upload/avatar"
if not os.path.isdir("." + filedir):
os.mkdir("." + filedir)
if "img" in post_data: # to check if the file-object is created
filepath = post_data.img.filename.replace(
"\\", "/"
) # replaces the windows-style slashes with linux ones.
filename = (
str(user.id) + "." + filepath.split("/")[-1].split(".")[1]
) # splits the and chooses the last part (the filename with extension)
fout = open(
"." + filedir + "/" + filename, "wb"
) # creates the file where the uploaded file should be stored
fout.write(post_data.img.file.read()) # writes the uploaded file to the newly created file.
fout.close() # closes the file, upload complete.
pydic = {"imgurl": filedir + "/" + filename}
id = user.id
model.db.update("user", avatar_url=pydic["imgurl"], where="id=$id", vars=locals())
user.avatar_url = pydic["imgurl"]
web.header("Content-Type", "application/json")
return json.dumps(pydic)
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 POST(self):
user = nothing.get_current_user()
if user and user.isAdmin:
post_data = web.input()
title = post_data.title
price = float(post_data.price)
link = post_data.link
description = post_data.description
img = post_data.img
tag = post_data.tag
model.db.insert('item',title=title,price=price,link=link,description=description,img=img,tag=tag,author=user.username)
web.seeother('/admin')
else:
return "you has not login or you are not admin"
def POST(self):
user = nothing.get_current_user()
pyDict = {'result':'fail'}
if user:
data_input = web.input()
item_id = data_input.item_id
model.db.delete('favorite', where="item_id=$item_id", vars=locals())
sql = "update item set favorite=favorite-1 where id = %s" % item_id
model.db.query(sql)
pyDict = {'result':False,'item_id':item_id}
web.header('Content-Type', 'application/json')
return json.dumps(pyDict)
web.header('Content-Type', 'application/json')
return json.dumps(pyDict)
def POST(self):
user = nothing.get_current_user()
data_input = web.input()
item_id = data_input.item_id
pyDict = {'result':'fail'}
if user:
data_input = web.input()
item_id = data_input.item_id
model.db.insert('favorite',item_id=item_id,username=user.username)
sql = "update item set favorite=favorite+1 where id = %s" % item_id
model.db.query(sql)
pyDict = {'result':True,'item_id':item_id}
web.header('Content-Type', 'application/json')
return json.dumps(pyDict)
def POST(self):
user = nothing.get_current_user()
if user and user.isAdmin:
post_data = web.input()
item_id = post_data.item_id
title = post_data.title
price = float(post_data.price)
link = post_data.link
description = post_data.description
img = post_data.img
tag = post_data.tag
model.db.update('item',where='id=$item_id',title=title,price=price,link=link,description=description,img=img,tag=tag,author=user.username,vars=locals())
web.seeother('/item/view/'+item_id)
else:
return "you has not login or you are not admin"
def POST(self):
user = nothing.get_current_user()
if user:
username = user.username
user_data = web.input()
email = user_data.email
pwd = user_data.email_pwd
p_sha1 = hashlib.sha1(pwd).hexdigest()
result = {"result": False, "message": "密码错误"}
if user.password == p_sha1:
model.db.update("user", where="username=$username", vars=locals(), email=email)
web.config._session.user.email = email
web.header("Content-Type", "application/json")
result = {"result": True, "message": "修改成功"}
return json.dumps(result)
raise web.seeother("/signin")
def POST(self):
user = nothing.get_current_user()
if user:
data = web.input()
item_id = data.item_id
content = data.content
model.db.insert("comment", item_id=item_id, content=content, username=user.username)
sql = "update item set comments=comments+1 where id = %s" % item_id
model.db.query(sql)
dic = {
"result": True,
"username": user.username,
"content": content,
"create_time": str(datetime.datetime.now()),
"avatar_url": user.avatar_url,
}
web.header("Content-Type", "application/json")
return json.dumps(dic)
raise web.seeother("/signin")
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"
