def put(self, token):
args = parser.parse_args()
result = {}
mq = Mysqllink()
now_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
sql = 'update orders set status=%s,update_at=%s where id=%s'
valu = (args['status'], now_time, args['order_id'])
mq.update(sql, valu)
sql = 'select * from orders where id=%s'
mq.select(sql, args['order_id'])
orders = mq.cursor.fetchall()[0]
sql = 'select * from order_detail where order_id=%s'
mq.select(sql, orders['id'])
order_detail = mq.cursor.fetchall()
data = []
for i in order_detail:
dic = {}
subtotal = str(i['subtotal'])
dic.update({'id': i['goods_id'], 'subtotal': subtotal})
data.append(dic)
total_price = str(orders['total_price'])
result['code'] = 200
result['data'] = {
'order': {
'id': orders['id'],
'status': orders['status'],
'address': orders['addr_id'],
'production': data,
'price': total_price,
'create_at': orders['create_at'],
'update_at': orders['update_at']
}
}
return jsonify(result)
def put(self, token):
args = parser.parse_args()
result = {}
admin_user_id = args['admin_user_id']
if args['name']=="" or args['phone']=="" or args['pwd']=="" or args['des']=="" or args['post_id'] =="" \
or args['is_super']=="":
result = 4026
result = "信息不完善！"
return jsonify(result)
elif re.match(r'^1[345789]\d{9}$', args['phone']) is None:
result['code'] = 4020
result['message'] = "此号码不存在！"
return jsonify(result)
mq = Mysqllink()
sql = 'select * from admin_users where phone=%s and id!=%s'
valu = (args['phone'], admin_user_id)
n = mq.select(sql, valu)
if n:
result['code'] = 4022
result['message'] = "此号码已注册！"
return jsonify(result)
#查看此管理员是不是超级管理员
sql = 'select is_super from admin_users where id=%s'
mq.select(sql, admin_user_id)
super = mq.cursor.fetchall()[0]
is_super = super['is_super']
if is_super != 1:
result['code'] = 4002
result['message'] = "无此权限！"
return jsonify(result)
now_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
sql = 'update admin_users set name=%s,phone=%s,pwd=%s,des=%s,update_at=%s,post_id=%s,is_super=%s where id=%s'
valu = (args['name'], args['phone'], args['pwd'], args['des'],
now_time, args['post_id'], args['is_super'], args['id'])
mq.update(sql, valu)
sql = 'select create_at from admin_users where id=%s'
mq.select(sql, admin_user_id)
create_at = mq.cursor.fetchall()[0]['create_at']
print(create_at)
result['code'] = 200
result['data'] = {
'admin_user': [{
'id': admin_user_id,
'name': args['name'],
'phone': args['phone'],
'des': args['des'],
'create_at': create_at,
'update_at': now_time
}]
}
return jsonify(result)
def put(self, token):
args = parser.parse_args()
result = {}
admin = args['admin_user_id']
# print(admin)
if args['name'] == "" or args['price'] == "" or args['img'] == "" or args['origin'] == "" or \
args['unit'] == "" or args['sales'] == "" or args['des'] == "" or args['class_id'] == "":
result['code'] = 4033
result['message'] = "数据不完善！"
return jsonify(result)
qr = Query_rules()
sql = 'select post_id from admin_users where id=%s'
qr.select(sql, admin)
au_post_id = qr.cursor.fetchall()[0]['post_id']
qr.query_rule(au_post_id)
admin_rules = qr.cursor.fetchall()
rules = []
for i in admin_rules:
rules.append(i['name'])
if 'update_goods' not in rules:
result['code'] = 4002
result['code'] = "无此权限！"
return jsonify(result)
mq = Mysqllink()
now_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
sql = 'update goods set name=%s,img=%s,unit=%s,price=%s,sales=%s,des=%s,origin=%s,update_at=%s,class_id=%s where id=%s'
valu = (args['name'], args['img'], args['unit'], args['price'],
args['sales'], args['des'], args['origin'], now_time,
args['class_id'], args['id'])
n = mq.update(sql, valu)
if n:
sql = 'select create_at from goods where id=%s'
mq.select(sql, args['id'])
create_at = mq.cursor.fetchall()
result['code'] = 200
result['data'] = {
'id': args['id'],
'name': args['name'],
'price': args['price'],
'img': args['img'],
'origin': args['origin'],
'unit': args['unit'],
'sales': args['sales'],
'des': args['des'],
'class_id': args['class_id'],
'create_at': create_at,
'update_at': now_time
}
return jsonify(result)
else:
result['code'] = 4028
result['message'] = "更新失败！"
return jsonify(result)
def put(self, token):
args = parser.parse_args()
result = {}
user_id = args['user_id'].strip()
name = args['name'].strip()
id = args['id'].strip()
phone = args['phone'].strip()
des = eval(args['des'])
province = des['province'].strip()
city = des['city'].strip()
area = des['area'].strip()
detail = des['detail'].strip()
is_default = args['is_default'].strip()
if user_id == "":
result['code'] = 4025
result['message'] = "未登录！"
return jsonify(result)
elif city == "" or area == "" or detail == "" or name == "" or phone == "":
result['code'] = 4026
result['message'] = "地址信息不完善！"
return jsonify(result)
elif re.match(r'^1[345789]\d{9}$', phone) is None:
result['code'] = 4020
result['message'] = "此号码不存在！"
return jsonify(result)
mq = Mysqllink()
now_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
sql = 'update addrs set name=%s,phone=%s,province=%s,city=%s,area=%s,detail=%s,is_default=%s,update_at=%s where id=%s'
valu = (name, phone, province, city, area, detail, is_default,
now_time, id)
n = mq.update(sql, valu)
if n:
result['code'] = 200
result['data'] = {
'id': id,
'user_id': user_id,
'phone': phone,
'name': name,
'des': {
'province': province,
'city': city,
'area': area,
'detail': detail
},
'is_default': is_default
}
return jsonify(result)
else:
result['code'] = 430
result['message'] = "修改失败！"
return jsonify(result)