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 get(self, token): args = parser.parse_args() result = {} admin_id = args['id'].strip() if admin_id == "": result['code'] = 4002 result['message'] = "无此权限!" return jsonify(result) mq = Mysqllink() sql = 'select * from users' mq.select(sql) user_all = mq.cursor.fetchall() user = [] for i in user_all: dic = {} dic.update({ 'id': i['id'], 'name': i['name'], 'phone': i['phone'], 'pwd': i['pwd'], 'create_at': i['create_at'] }) user.append(dic) result['code'] = 200 result['data'] = {'users': user} return jsonify(result)
def get(self, token): args = parser.parse_args() result = {} admin_user_id = args['admin_user_id'] mq = Mysqllink() #查看此管理员是不是超级管理员 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) #查看此管理员的所有信息 sql = 'select * from admin_users' mq.select(sql) admin_lis = mq.cursor.fetchall() data = [] for i in admin_lis: dic = {} dic.update({ 'id': i['id'], 'name': i['name'], 'phone': i['phone'], 'des': i['des'], 'pwd': i['pwd'], 'is_super': i['is_super'], 'create_at': i['create_at'], 'update_at': i['update_at'] }) data.append(dic) result['code'] = 200 result['data'] = {'admin_users': data} return jsonify(result)
def get(self, token): result = {} mq = Mysqllink() sql = 'select * from goods' mq.select(sql) goodss = mq.cursor.fetchall() message = [] for i in goodss: dic = {} price = str(i['price']) dic.update({ 'id': i['id'], 'name': i['name'], 'price': price, 'img': i['img'], 'unit': i['unit'], 'sales': i['sales'], 'des': i['des'], 'origin': i['origin'], 'class_id': i['class_id'], 'create_id': i['create_at'], 'update_at': i['update_at'] }) message.append(dic) result['code'] = 200 result['data'] = {'goods': message} 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 = {} 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 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 = {} 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 get(self, token): result = {} mq = Mysqllink() sql = 'select * from classes' mq.select(sql) classess = mq.cursor.fetchall() message = [] for i in classess: dic = {} dic.update({ 'id': i['id'], 'name': i['name'], 'create_at': i['create_at'], 'update_at': i['update_at'] }) message.append(dic) result['code'] = 200 result['data'] = {'classes': message} 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 get(self, token): args = parser.parse_args() result = {} id = args['user_id'] mq = Mysqllink() sql = 'select * from orders where user_id=%s' n = mq.select(sql, id) if n < 1: result['code'] = 4034 result['message'] = "无订单!" return jsonify(result) orders = mq.cursor.fetchall() print(orders) data1 = [] for i in orders: sql = 'select * from order_detail where order_id=%s' mq.select(sql, i['id']) order_detail = mq.cursor.fetchall() print(order_detail) data2 = [] for j in order_detail: dic1 = {} subtotal = str(j['subtotal']) dic1.update({'id': j['goods_id'], 'subtotal': subtotal}) data2.append(dic1) dic = {} total_price = str(i['total_price']) dic.update({ 'id': i['id'], 'status': i['status'], 'addr_id': i['addr_id'], 'production': data2, 'price': total_price, 'create_at': i['create_at'], 'update_at': i['update_at'] }) data1.append(dic) result['code'] = 200 result['data'] = {'orders': data1} return jsonify(result)
def get(self, token): args = parser.parse_args() result = {} user_id = args['user_id'].strip() if user_id == "": result['code'] = 4025 result['message'] = "未登录!" return jsonify(result) mq = Mysqllink() sql = 'select * from addrs where user_id=%s' n = mq.select(sql, user_id) if n < 1: result['code'] = 4029 result['message'] = "你还没有添加地址!" return jsonify(result) else: addrs = mq.cursor.fetchall() addr_all = [] for i in addrs: addr = {} addr.update({ 'id': i['id'], 'user_id': i['user_id'], 'phone': i['phone'], 'name': i['name'], 'des': { 'province': i['province'], 'city': i['city'], 'area': i['area'], 'detail': i['detail'] }, 'create_at': i['create_at'], 'update_at': i['update_at'] }) addr_all.append(addr) result['code'] = 200 result['data'] = {'user_id': user_id, 'addrs': addr_all} return jsonify(result)
def post(self, token): args = parser.parse_args() result = {} #去除phone和pwd两边的空格 phone = args['phone'].strip() pwd = args['pwd'].strip() if phone == "": result['code'] = 4011 result['message'] = "电话号码不能为空!" return jsonify(result) elif pwd == "": result['code'] = 4012 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) mq = Mysqllink() sql = 'select pwd from users where phone=%s' n = mq.select(sql, phone) passwd = mq.cursor.fetchall()[0]['pwd'] if n: if pwd == passwd: result['code'] = 200 result['data'] = "登陆成功!" return jsonify(result) else: result['code'] = 4023 result['message'] = "密码错误!" return jsonify(result) else: result['code'] = 4024 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)