def post(self, token):
args = parser.parse_args()
result = {}
#去除arg['pwd']两边的空格
pwd = args['pwd'].strip()
print(pwd)
if args['name'] == "":
result['code'] = 4010
result['message'] = "用户名不能为空！"
return jsonify(result)
elif args['phone'] == "":
result['code'] = 4011
result['message'] = "电话号码不能为空！"
return jsonify(result)
#用正则判断电话号码是否符合规定
elif re.match(r'^1[345789]\d{9}$', args['phone']) is None:
result['code'] = 4020
result['message'] = "此号码不存在！"
return jsonify(result)
elif pwd == "":
result['code'] = 4012
result['message'] = "密码不能为空！"
return jsonify(result)
elif len(pwd) < 6 or len(pwd) > 16:
result['code'] = 4021
result['message'] = "密码必须在6~16位之间！"
return jsonify(result)
mq = Mysqllink()
#查看phone是否已经被注册过
sql = 'select phone from users where phone=%s'
valu = args['phone']
n = mq.select(sql, valu)
if n:
result['code'] = 4022
result['message'] = "此号码已注册！"
return jsonify(result)
else:
now_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
# sql='insert into users value (null,%s,%s,%s,%s)'
sql = 'insert into users(name,phone,pwd,create_at) values (%s,%s,%s,%s)'
valu = (args['name'], args['phone'], args['pwd'], now_time)
#使用insert()向mysql添加数据
# mq.cursor.execute(sql,valu)
mq.insert(sql, valu)
#查询新增id：
ID = mq.cursor.lastrowid
result['code'] = 200
result['data'] = {
'user': {
'id': ID,
'name': args['name'],
'phone': args['phone'],
'pwd': args['pwd'],
'create_at': now_time
}
}
return jsonify(result)
def post(self, token):
args = parser.parse_args()
result = {}
pwd = args['pwd'].strip()
print(pwd)
if args['name'] == "":
result['code'] = 4010
result['message'] = "用户名不能为空！"
return jsonify(result)
elif args['phone'] == "":
result['code'] = 4011
result['message'] = "电话号码不能为空！"
return jsonify(result)
elif re.match(r'^1[345789]\d{9}$', args['phone']) is None:
result['code'] = 4020
result['message'] = "此号码不存在！"
return jsonify(result)
elif pwd == "":
result['code'] = 4012
result['message'] = "密码不能为空！"
return jsonify(result)
elif len(pwd) < 6 or len(pwd) > 16:
result['code'] = 4021
result['message'] = "密码必须在6~16位之间！"
return jsonify(result)
mq = Mysqllink()
sql = 'select phone from admin_users where phone=%s'
valu = args['phone']
n = mq.select(sql, valu)
if n:
result['code'] = 4022
result['message'] = "此号码已注册！"
return jsonify(result)
now_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
sql = 'insert into admin_users(name,phone,pwd,des,create_at,update_at,post_id,is_super) ' \
'values (%s,%s,%s,%s,%s,%s,%s,%s)'
valu = (args['name'], args['phone'], args['pwd'], args['des'],
now_time, now_time, args['post_id'], args['is_super'])
mq.insert(sql, valu)
ID = mq.cursor.lastrowid
result['code'] = 200
result['data'] = {
'admin_user': {
'id': ID,
'name': args['name'],
'phone': args['phone'],
'des': args['des'],
'create_at': now_time,
'update_at': now_time
}
}
return jsonify(result)
def post(self, token):
args = parser.parse_args()
result = {}
admin = args['admin_user_id']
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 'add_goods' not in rules:
result['code'] = 4002
result['code'] = "无此权限！"
return jsonify(result)
mq = Mysqllink()
sql = 'select * from goods where name=%s and price=%s and img=%s and origin=%s and unit=%s and sales=%s and des=%s and class_id=%s'
valu = (args['name'], args['price'], args['img'], args['origin'],
args['unit'], args['sales'], args['des'], args['class_id'])
n1 = mq.select(sql, valu)
if n1:
result['code'] = 4033
result['code'] = "此商品已存在！"
return jsonify(result)
now_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
sql = 'insert into goods values (null,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)'
valu = [
args['name'], args['img'], args['unit'], args['price'],
args['sales'], args['des'], args['origin'], now_time, now_time,
args['class_id']
]
n2 = mq.insert(sql, valu)
if n2:
ID = mq.cursor.lastrowid
result['code'] = 200
result['data'] = {
'id': 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': now_time
}
return jsonify(result)
else:
result['code'] = 4028
result['message'] = "添加失败！"
return jsonify(result)
def post(self, token):
args = parser.parse_args()
result = {}
name = args['name']
pid = args['pid']
if name == "":
result['code'] = 4031
result['message'] = "分类名不能为空！"
return jsonify(result)
mq = Mysqllink()
sql = 'select * from classes where name=%s'
n = mq.select(sql, name)
if n:
result['code'] = 4027
result['message'] = "此分类已存在！"
return jsonify(result)
now_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
tab = 'insert into classes(name,create_at,update_at,pid) values (%s,%s,%s,%s)'
valu = (name, now_time, now_time, pid)
n1 = mq.insert(tab, valu)
ID = mq.cursor.lastrowid
if n1:
result['code'] = 200
result['message'] = {'id': ID, 'name': name}
return jsonify(result)
else:
result['dode'] = 4028
result['message'] = "添加失败！"
return jsonify(result)
def post(self, token):
args = parser.parse_args()
result = {}
des = eval(args['des']) #eval()字符串转字典
name = args['name'].strip()
phone = args['phone'].strip()
user_id = args['user_id'].strip()
province = des['province'].strip()
city = des['city'].strip()
area = des['area'].strip()
detail = des['detail'].strip()
is_default = args['is_default'].strip()
print(des)
if user_id == "":
result['code'] = 4025
result['message'] = "未登录！"
return jsonify(result)
elif province == "" or city == "" or area == "" or detail == "" or phone == "" or name == "":
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()
valu = (user_id, name, phone, province, city, area, detail)
sql = 'select * from addrs where user_id=%s and name=%s and phone=%s and province=%s and ' \
'city=%s and area=%s and detail=%s'
n1 = mq.select(sql, valu)
now_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
if n1:
result['code'] = 4027
result['message'] = "此地址已存在！"
return jsonify(result)
else:
tab = 'insert into addrs values (null,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)'
valu = (name, phone, user_id, province, city, area, detail,
is_default, now_time, now_time)
n = mq.insert(tab, valu)
ID = mq.cursor.lastrowid
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_deafult': is_default
}
return jsonify(result)
else:
result['code'] = 4028
result['message'] = "地址添加失败！"
return jsonify(result)
def post(self, token):
mq = Mysqllink()
args = parser.parse_args()
result = {}
pwd = args['pwd'].strip()
print(pwd)
if args['name'] == "":
result['code'] = 1020
result['message'] = "用户名不能为空！"
return jsonify(result)
elif args['phone'] == "":
result['code'] = 1030
result['message'] = "电话号码不能为空！"
return jsonify(result)
elif re.match(r'^1[345789]\d{9}$', args['phone']) is None:
result['code'] = 1031
result['message'] = "此号码不存在！"
return jsonify(result)
elif pwd == "":
result['code'] = 1040
result['message'] = "密码不能为空！"
return jsonify(result)
elif len(pwd) < 6 or len(pwd) > 16:
result['code'] = 1051
result['message'] = "密码必须在6~16位之间！"
return jsonify(result)
# name = args['name']
# sql = 'select name from users where name=%s'
# n = mq.cursor.execute(sql, name)
feild1 = 'name'
tab = 'users'
cond = 'name="%s"' % args['name']
n = mq.select(feild1, tab, cond)
feild1 = 'phone'
cond = 'phone="%s"' % args['phone']
m = mq.select(feild1, tab, cond)
if n:
result['code'] = 1010
result['message'] = "用户名已存在！"
return jsonify(result)
elif m:
result['code'] = 1011
result['message'] = "此号码已注册！"
return jsonify(result)
now_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
print(now_time)
# sql='insert into users value (null,%s,%s,%s,%s)'
tab = 'users(name,phone,pwd,create_at)'
valu = (args['name'], args['phone'], args['pwd'], now_time)
# mq.cursor.execute(sql,pp)
mq.insert(tab, valu)
ID = mq.cursor.lastrowid
result['code'] = 2000
result['date'] = {
'user': {
'id': ID,
'name': args['name'],
'phone': args['phone'],
'pwd': args['pwd'],
'create_at': now_time
}
}
return jsonify(result)
