def get(self, *args, **kwargs):
data_box = {}
user_all = sess.query(User).all()
num = sess.query(func.count(User.id)).scalar()
data_box['user_all'] = user_all
data_box['num'] = num
self.render('../templates/admin_page/user-list.html', **data_box)
def get(self, *args, **kwargs):
data_box = {}
category = sess.query(Category).filter(Category.parent_id == 0)
category2 = sess.query(Category).filter(
Category.parent_id.in_([cate.id for cate in category]))
data_box['category_data1'] = category
data_box['category_data2'] = category2
self.render('../templates/admin_page/product-category-add.html',
**data_box)
def get(self, *args, **kwargs):
num = sess.query(func.count(Category.id)).scalar()
category1 = sess.query(Category).filter(Category.parent_id == 0)
data_box = {
'num': num,
'category_data': category1,
}
self.render('../templates/admin_page/product-category.html',
**data_box)
def get(self, *args, **kwargs):
# 获取回调的code
code = self.get_argument('code')
# 微博认证地址
access_token_url = "https://api.weibo.com/oauth2/access_token"
# 参数 向新浪接口发送请求
re_dict = requests.post(access_token_url,
data={
"client_id":
'2636039333',
"client_secret":
"4e2fbdb39432c31dc5c2f90be3afa5ce",
"grant_type":
"authorization_code",
"code":
code,
"redirect_uri":
"http://127.0.0.1:8000/md_admin/weibo",
})
re_dict = re_dict.text
re_dict = eval(re_dict)
uid = str(re_dict.get('uid'))
if uid:
# nick = '新浪微博登录的'+uid
_user = sess.query(User).filter(User.username == uid).first()
encoded_jwt = jwt.encode({'u_name': _user.username},
settings.jwt_code,
algorithm='HS256')
token = str(encoded_jwt, 'utf-8')
if _user:
self.redirect(
'http://127.0.0.1:8080/?u_name={}token={}'.format(
_user.username, token))
else:
user = User(username=uid,
password=settings.PASSWORD,
nick=uid,
phone='',
attributes=1)
encoded_jwt = jwt.encode({'u_name': user.username},
settings.jwt_code,
algorithm='HS256')
token = str(encoded_jwt, 'utf-8')
try:
sess.add(user)
_user = sess.query(User).filter(
User.username == uid).first()
self.redirect(
'http://127.0.0.1:8080/?u_name={}token={}'.format(
_user.username, token))
except:
pass
else:
# self.write(re_dict)
self.redirect('http://127.0.0.1:8080/login')
def get(self, *args, **kwargs):
id = self.get_argument('id')
goods = sess.query(Goods).filter(Goods.id == id).first()
if goods.is_shelves == 1:
goods = sess.query(Goods).filter(Goods.id == id).first()
goods.is_shelves = 0
self.redirect('/admin/goods_list')
else:
goods = sess.query(Goods).filter(Goods.id == id).first()
goods.is_shelves = 1
self.redirect('/admin/goods_list')
def get(self, *args, **kwargs):
id = self.get_argument('id')
cname = self.get_argument('cname')
num = sess.query(func.count(Category.id)).scalar()
category1 = sess.query(Category).filter(Category.parent_id == id)
data_box = {
'num': num,
'cname': cname,
'category_data': category1,
}
self.render('../templates/admin_page/product-category3.html',
**data_box)
def infinite(goodsList, id, num, start):
# 获取该分类下所有商品
good = sess.query(
Goods.gname, Goods.id, Goods.price, GoodsImg.image, GoodsImg.img_order,
Goods.describe).join(GoodsImg, GoodsImg.goods_id == Goods.id).filter(
and_(Goods.cate_id == id,
GoodsImg.img_order == 1)).limit(num).offset(start).all()
cate2 = sess.query(Category).filter(Category.parent_id == id).all()
for i in good:
goodsList.append(i)
if len(cate2) == 0:
pass
else:
for j in cate2:
infinite(goodsList, j.id, num, start)
def get(self, *args, **kwargs):
id = self.get_argument('id')
if id:
img = sess.query(GoodsImg).filter(GoodsImg.id == id).first()
sess.delete(img)
sess.commit()
self.redirect('/admin/picture')
def get(self, *args, **kwargs):
mes = {}
id = self.get_argument('id')
goods = sess.query(
Goods.gname, Goods.id, Goods.price, GoodsImg.image).join(
GoodsImg,
GoodsImg.goods_id == Goods.id).filter(Goods.id == id).first()
img = sess.query(GoodsImg).filter(GoodsImg.goods_id == id).all()
mes['img'] = img
mes['goods'] = goods
mes['code'] = 200
mes['message'] = '发送分类成功'
self.write(
json.dumps(mes, cls=AlchemyEncoder, ensure_ascii=False, indent=4))
def post(self, *args, **kwargs):
mes = {}
u_name = self.get_argument('u_name')
pwd = self.get_argument('pwd')
if not all([u_name, pwd]):
mes['code'] = 400
mes['message'] = '请输入账号密码'
self.write(json.dumps(mes))
else:
user = sess.query(User).filter(User.username == u_name).first()
if user is not None:
if user.password != pwd:
mes['code'] = 400
mes['message'] = '密码错误'
self.write(json.dumps(mes))
else:
encoded_jwt = jwt.encode({'u_name': user.username},
settings.jwt_code,
algorithm='HS256')
mes['code'] = 200
mes['token'] = str(encoded_jwt, 'utf-8')
mes['message'] = '登录成功'
self.write(json.dumps(mes))
else:
mes['code'] = 400
mes['message'] = '该账号不存在'
self.write(json.dumps(mes))
async def post(self):
tinymceHtml = self.get_argument('tinymceHtml')
goods_id = self.get_argument('goods_id')
gname = self.get_argument('gname')
u_name = self.get_argument('u_name')
# 1. 查询当前用户是否购买过该商品 买过--->可以评论 没买过--->不能评论
# 通过u_name ---> 查出用户id ---> 查出该用户的所有ststes=1订单（遍历订单获取订单ID） ---> 查询订单详情（获取订单详情字段）
# ---> 将json数据取出后遍历获取商品ID
# 判断 如果当前商品ID存在详情中商品ID内，则买过，反之没买过
# 2. 将发表的评论存到数据库
# goods = [(json.loads(i[0]))[0]['gname'] for i in sess.query(OrderDetail.goodslist).join(Order,Order.id==OrderDetail.order_id).join(User,User.id==Order.user_id).filter(User.username==u_name).all()]
goodslist = sess.query(OrderDetail.goodslist, User.id).join(
Order,
Order.id == OrderDetail.order_id).filter(Order.ststes == 1).join(
User, User.id == Order.user_id).filter(
User.username == u_name).all()
gList = []
id = 0
for i in goodslist:
goods = json.loads(i[0])
gname = goods[0]['gname']
gList.append(gname)
id = i[-1]
if gname in gList:
comments = Comments(content=tinymceHtml,
user_id=id,
goods_id=goods_id)
sess.add(comments)
sess.commit()
self.write(json.dumps({'code': 200, 'mes': '评论成功'}))
else:
self.write(json.dumps({'code': 100022, 'mes': '没有购买过该商品'}))
def get(self, *args, **kwargs):
id = self.get_argument('id')
if id:
goods = sess.query(Goods).filter(Goods.id == id).first()
sess.delete(goods)
sess.commit()
self.redirect('/admin/goods_list')
def get(self, *args, **kwargs):
goodsimg = sess.query(GoodsImg).all()
data_box = {
'goodsimg': goodsimg,
}
self.render('../templates/admin_page/picture-list.html', **data_box)
def get(self, *args, **kwargs):
id = self.get_argument('id')
category = sess.query(Category).filter(Category.id == id).first()
data_box = {
'cname': category.cname,
}
self.render('../templates/admin_page/cate-modify.html', **data_box)
def post(self, *args, **kwargs):
id = self.get_argument('id')
cname = self.get_argument('cname')
category = sess.query(Category).filter(Category.id == id).first()
if cname:
category.cname = cname
self.redirect('/admin/product_category')
def findend():
from db import sess
# logger.debug("findend()")
message_id = sess.query(func.max(Message.id)).scalar()
if message_id is None:
message_id = -1
return message_id
def get(self):
id = self.get_argument('id')
if id:
data_box = {}
user_show = sess.query(User).filter(User.id == id).first()
data_box['user_show'] = user_show
self.render('../templates/admin_page/user-modify.html', **data_box)
async def get(self):
mes = {}
content = self.get_argument("c")
goodsList = sess.query(Goods.gname,Goods.id,Goods.price,GoodsImg.image,GoodsImg.img_order,Goods.describe)\
.join(GoodsImg,GoodsImg.goods_id==Goods.id)\
.filter(Goods.gname.like("%"+content+"%")).all()
mes['code'] = 200
mes['goodsList'] = goodsList
self.write(
json.dumps(mes, cls=AlchemyEncoder, ensure_ascii=False, indent=4))
def get(self, *args, **kwargs):
user_id = self.get_cookie('userid')
if not user_id:
self.redirect('/admin/login')
else:
print(self.request.uri, '0-0-0-0-0-0-0-0-0')
data_box = {}
user = sess.query(User).filter(User.id == user_id).first()
data_box['user'] = user
self.render('../templates/admin_page/index.html', **data_box)
async def post(self):
mes = {}
code = self.get_argument('code')
coupons = sess.query(Coupons).filter(Coupons.code == code).first()
if coupons:
mes['discount'] = float(coupons.discount)
mes['code'] = 200
else:
pass
self.write(
json.dumps(mes, cls=AlchemyEncoder, ensure_ascii=False, indent=4))
def post(self, *args, **kwargs):
mes = {}
cur = int(self.get_argument('cur', 1)) # 当前页
num = int(self.get_argument('num')) # 每页数量
cateList = sess.query(Category).filter(Category.parent_id == 0).all()
goods = sess.query(Goods).all()
totalNum = len(goods)
start = (cur - 1) * num
goodsList = sess.query(
Goods.gname, Goods.id, Goods.price, GoodsImg.image,
GoodsImg.img_order, Goods.describe).join(
GoodsImg, GoodsImg.goods_id == Goods.id).filter(
GoodsImg.img_order == 1).limit(num).offset(start).all()
print(goodsList)
mes['cateList'] = cateList
mes['goodsList'] = goodsList
mes['count'] = totalNum
mes['code'] = 200
mes['message'] = '发送成功'
self.write(
json.dumps(mes, cls=AlchemyEncoder, ensure_ascii=False, indent=4))
def post(self):
id = self.get_argument('id')
if id:
data_box = {}
user_show = sess.query(User).filter(User.id == id).first()
nick = self.get_argument('nick')
gender = self.get_argument('gender')
phone = self.get_argument('phone')
user_show.nick = nick
user_show.gender = gender
user_show.phone = phone
self.redirect('/admin/user_list')
def post(self, *args, **kwargs):
mes = {}
oid = self.get_argument('o_id')
if oid:
orderList = sess.query(Order).filter(Order.id == oid).first()
mes['code'] = 200
mes['orderList'] = orderList
self.write(
json.dumps(mes,
cls=AlchemyEncoder,
ensure_ascii=False,
indent=4))
def post(self, *args, **kwargs):
mes = {}
user_id = self.get_argument('user_id')
if user_id is not None:
user = sess.query(User).filter(User.id == user_id).first()
user.is_activates = 1
mes['code'] = 200
mes['message'] = '激活成功'
self.write(json.dumps(mes))
else:
mes['code'] = 400
mes['message'] = '请求错误'
self.write(json.dumps(mes))
def post(self, *args, **kwargs):
id = self.get_argument('id')
gname = self.get_argument('gname')
describe = self.get_argument('describe')
specifications = self.get_argument('specifications')
price = self.get_argument('price')
cate = self.get_argument('cate')
if id:
goods = sess.query(Goods).filter(Goods.id == id).first()
goods.gname = gname
goods.describe = describe
goods.specifications = specifications
goods.price = price
goods.cate_id = cate
self.redirect('/admin/goods_list')
def post(self):
oid = self.get_argument('o_id')
if oid:
orderList = sess.query(Order).filter(Order.id == oid).first()
#调用退款方法
order_string = api_alipay_trade_refund(
#订单号，一定要注意，这是支付成功后返回的唯一订单号
out_trade_no=orderList.id,
#退款金额，注意精确到分，不要超过订单支付总金额
refund_amount=orderList.payment_amount,
#回调网址
notify_url='http://127.0.0.1:8000/alipayreturn')
print(order_string)
orderList.ststes = 2
orderList.commit()
def charm_permissions(self, *args, **kwargs):
# 获得当前url
current = self.request.uri
user_id = self.get_cookie('userid')
my_access = sess.query(Nodes.node_url, User.role_id).join(
Roles, User.role_id == Roles.id).join(
Role2Node, Roles.id == Role2Node.role_id).join(
Nodes, Role2Node.node_id == Nodes.id).filter(
User.id == user_id).all()
urlList = []
for val in my_access:
urlList.append(val[0])
if current in urlList:
return views(self, *args, **kwargs)
else:
pass
def get(self, *args, **kwargs):
id = self.get_argument('id')
if id:
category1 = sess.query(Category).filter(Category.id == id).first()
pid1 = category1.id
category2 = sess.query(Category).filter(
Category.parent_id == pid1).all()
if category2 != []:
for i in category2:
pid2 = i.id
category3 = sess.query(Category).filter(
Category.parent_id == pid2).all()
if category3 != []:
for j in category3:
pid3 = j.id
if pid3:
del_cate3 = sess.query(Category).filter(
Category.id == pid3).first()
sess.delete(del_cate3)
del_cate2 = sess.query(Category).filter(
Category.id == pid2).first()
sess.delete(del_cate2)
del_cate1 = sess.query(Category).filter(
Category.id == pid1).first()
sess.delete(del_cate1)
self.redirect('/admin/product_category')
else:
del_cate2 = sess.query(Category).filter(
Category.id == pid2).first()
sess.delete(del_cate2)
del_cate1 = sess.query(Category).filter(
Category.id == pid1).first()
sess.delete(del_cate1)
self.redirect('/admin/product_category')
else:
del_cate1 = sess.query(Category).filter(
Category.id == pid1).first()
sess.delete(del_cate1)
self.redirect('/admin/product_category')
def post(self, *args, **kwargs):
mes = {}
id = self.get_argument('id')
cur = int(self.get_argument('cur', 1)) # 当前页
num = int(self.get_argument('num')) # 每页数量
goods = sess.query(Goods).filter(Goods.cate_id == id).all()
print(id, '0-0-0-0-0-0-0')
totalNum = len(goods)
start = (cur - 1) * num
goodsList = []
infinite(goodsList, id, num, start)
mes['goods_list'] = goodsList
mes['count'] = totalNum
mes['code'] = 200
mes['message'] = '发送分类成功'
self.write(
json.dumps(mes, cls=AlchemyEncoder, ensure_ascii=False, indent=4))
def post(self):
# 1. 查询当前商品下的所有评论
# 通过商品ID查询Comments表中所有评论以及评论的用户
goods_id = self.get_argument('goods_id')
print(goods_id, '0-0-0-0-0-0')
if goods_id:
comments = sess.query(Comments).filter(
Comments.goods_id == goods_id).all()
print(comments, '-=-=-=-=-=-=-=-=-=')
self.write(
json.dumps({
'code': 200,
'comments': comments
},
cls=AlchemyEncoder,
ensure_ascii=False,
indent=4))
def post(self):
mes = {}
username = self.get_argument('username')
password = self.get_argument('password')
if not all([username, password]):
mes['message'] = '请输入账户密码'
self.write('输入账户密码')
elif re.match('\w{5,12}', username) is None:
self.write('账号不符合规范')
else:
user = sess.query(User).filter(User.username == username).first()
if user is not None:
if user.password != password:
self.write('密码不正确')
else:
self.set_cookie('userid', str(user.id))
self.redirect('/admin/index')
else:
self.write('没有该账号')
def query():
from db import sess
return sess.query(Message)
def query():
from db import sess
return sess.query(Player)
def query():
from db import sess
return sess.query(Person)
