def wx_List_onsaleGood(req): """ 微信小程序获取商品列表 :param req: :return: """ post_dic = req.POST logger.debug("微信小程序获取特价商品列表传入参数:" + str(post_dic)) sql = "SELECT id,name,good_category_id as categoryId,price as minPrice,origin_price as originalPrice,status as statusStr,img_url as pic FROM good where status=1 and origin_price =0 " pageSize = int(post_dic['pageSize']) page = int(post_dic['page']) print(sql) db = Mysql() result = db.getAll(sql) # print(list(result)) result_list = list(result)[(page - 1) * pageSize:page * pageSize] resp = '' if result_list: resp = {"code": 0, "msg": "success", "data": result_list} else: resp = {"code": 700, "msg": "success,no data", "data": []} return HttpResponse(json.dumps(resp), content_type="application/json")
def get_person_love_top(req): """ 获取top10收藏商品 :param req: :return: """ db = Mysql() sql1 = "select b.name,a.count from (select good_id,count( good_id) as count from person_love GROUP BY good_id ) a INNER JOIN good b on a.good_id = b.id order by a.count desc ,b.id asc;" result = db.getAll(sql1) print(result) name_list = [] count_list = [] for x in result: name_list.append(x['name']) count_list.append(x['count']) dict = {} dict['name'] = name_list dict['count'] = count_list db.dispose() if result: resp = {"code": 0, "msg": "success", "data": dict} else: resp = {"code": 1, "msg": "internal_exceptions"} return HttpResponse(json.dumps(resp), content_type="application/json")
def manager_logout(req): """ 管理者账号退出登录 :param req: :return: """ token = req.GET.get('access_token') db = Mysql() result = db.getAll("select * from t_token where token = '%s'"%token) if result: if db.delete("DELETE FROM t_token where token = '%s'"%token): resp = { "code": 0 , "msg": "退出成功" , "data": { } } else: resp = { "code": 1 , "msg": "数据库异常,退出失败" , "data": { } } else: resp = { "code": 1 , "msg": "退出失败" , "data": { } } return HttpResponse(json.dumps(resp), content_type="application/json")
def change_assword(req): resp = '' token = req.POST.get('access_token') db =Mysql() result = db.getOne("select * from t_token a INNER JOIN manager b ON a.user_id = b.id and b.`password` ='%s' and a.token = '%s'"%(req.POST.get('oldPassword'),token)) if result: sql2 = "UPDATE manager SET `password` ='%s' WHERE id = '%s'"%(req.POST.get('password'),result['user_id']) if db.update(sql2): resp ={ "code": 0 ,"msg": "success" ,"data": { } } else: resp = { "code": 1 , "msg": "failed" , "data": { } } else: resp = { "code": 2 , "msg": "failed" , "data": { } } return HttpResponse(json.dumps(resp), content_type="application/json")
def manager_login(req): """ 管理者账号登录 :param req: :return: """ resp = '' username = req.POST.get('username') password = req.POST.get('password') sql = "SELECT * from manager where username ='******' and password='******'" % ( username, password) db = Mysql() result = db.getOne(sql) if result: access_token = jwt.create_token(username) in_result = db.insertOne( "INSERT INTO `vms`.`t_token`(`user_id`,`token`, `time`) VALUES ('%s','%s', now());" % (result['id'], access_token)) if in_result: # print(access_token) resp = { "code": 0, "msg": "登入成功", "data": { "access_token": access_token } } return HttpResponse(json.dumps(resp), content_type="application/json") resp = {"code": 1, "msg": "登入失败", "data": {}} return HttpResponse(json.dumps(resp), content_type="application/json")
def delonsale_good(req): """ 清除特价 :param req: :return: """ logger.debug('清除特价商品传入参数:' + str(req.POST)) id_list = req.POST.copy()['checkData'] if id_list: if 'all' in id_list: logger.debug("待清除所有特价商品") sql = 'UPDATE good SET origin_price =0' else: logger.debug("待清除的特价商品的ID:" + str(id_list)) sql = 'UPDATE good SET origin_price = 0 WHERE id IN (%s)' % ( id_list) else: resp = {"code": 1, "msg": "internal_exceptions"} db = Mysql() result = db.update(sql) # print(result) if result != 0: resp = {"code": 0, "msg": "success"} else: resp = {"code": 1, "msg": "internal_exceptions"} return HttpResponse(json.dumps(resp), content_type="application/json")
def list_good(req): """ 商品查询 :param req: :return: """ data = req.GET.copy() sql = 'select a.*,b.name as type from good a INNER JOIN good_category b ON a.good_category_id = b.id ORDER BY uploadtime desc' if 'title' in data or 'category' in data: good_name = data['title'] good_type = data['category'] print(good_type) if good_name != '' and good_type == '': sql = "select a.*,b.`name` as type from(select * from good where `name`='%s')a INNER JOIN good_category b ON a.good_category_id = b.id ORDER BY a.uploadtime desc" % ( good_name) elif good_name == '' and good_type != '': sql = "select a.*,b.`name` as type from(select * from good )a INNER JOIN (select * from good_category where `id`='%s') b ON a.good_category_id = b.id ORDER BY a.uploadtime desc" % ( good_type) elif good_name != '' and good_type != '': sql = "select a.*,b.`name` as type from(select * from good where `name`='%s' )a INNER JOIN (select * from good_category where `id`='%s') b ON a.good_category_id = b.id ORDER BY a.uploadtime desc" % ( good_name, good_type) else: pass db = Mysql() g_list = [] query_result = db.getAll(sql) db.dispose() if len(query_result) != 0: good_list = list(query_result) for x in good_list: if x['uploadtime'] != '': x['uploadtime'] = str(x['uploadtime']) g_list.append(x) if 'limit' in req.GET: limit = int(req.GET['limit']) page = int(req.GET['page']) resp = { "code": 0, "msg": "", "count": len(g_list), "data": g_list[(page - 1) * limit:page * limit] } logger.debug(g_list[(page - 1) * limit:page * limit]) else: resp = {"code": 0, "msg": "", "count": len(g_list), "data": g_list} else: resp = {"code": 0, "msg": "", "count": 0, "data": g_list} logger.debug('【商品接口数据】:' + json.dumps(resp)) return HttpResponse(json.dumps(resp), content_type="application/json")
def wx_list_type(req): """ 微信小程序获取全部分类 :param req: :return: """ sql = "SELECT * FROM good_category ORDER BY `sort`;" db = Mysql() result = db.getAll(sql) resp = {"code": 0, "msg": "success", "data": list(result)} db.dispose() return HttpResponse(json.dumps(resp), content_type="application/json")
def wx_good_detail(req): """ 微信小程序获取商品详情 :param req: :return: """ post_dic = req.POST logger.debug("微信小程序获取商品详情传入参数:" + str(post_dic)) sql = "SELECT * FROM good where id = %s;" % post_dic['id'] db = Mysql() result = db.getOne(sql) # print(result) images_str = "" info_str = "" print(result['img_urls']) if result['img_urls'] != '': images = result['img_urls'].split(',') if images: for img in images: images_str = images_str + "<p><img src=\"%s\" style=\"\" title=\"\"/></p>" % img else: images_str = "" print(images_str) good_info = result['good_info'] if not good_info: info_str = "品质消费,好而不贵。" else: info_str = good_info resp = { "code": 0, "msg": "success", "data": { "content": "<p><span style=\"color: rgb(102, 102, 102); font-family: Arial, "Microsoft YaHei", SimSun; font-size: 12px; margin:10px 10px 10px 10px;background-color: rgb(255, 255, 255);\">%s</span></p>" % info_str + images_str, "basicInfo": { "id": result['id'], "name": result['name'], "minPrice": result['price'], "originalPrice": result['origin_price'], "pic": result['img_url'], "categoryId": result['good_category_id'], "statusStr": result['status'] } } } db.dispose() return HttpResponse(json.dumps(resp), content_type="application/json")
def order_detail(req): logger.debug('订单详情传入参数:' + str(req.GET)) data = req.GET.copy() resp = '' db = Mysql() result = db.getOne( "SELECT c.*,d.name as type,d.price FROM ((SELECT a.*,b.name,b.phone FROM( SELECT * FROM vip_order WHERE `order_serial_number` = '%s') a INNER JOIN person b ON a.person_id = b.id)) c INNER JOIN order_category d ON c.order_category_id = d.id " % (data['order_serial_number'])) logger.debug(result) if result: valid_point = db.getOne( "select sum(point) as valid_point from point_detail where person_id = '%s'" % result['person_id'])['valid_point'] if not valid_point: valid_point = 0 logger.debug(valid_point) good_value_list = db.getAll( "select SUM(a.good_count) as good_count,b.name,b.price from (select good_id,good_count from order_good_item WHERE order_id = '%s' ) a INNER JOIN good b on a.good_id = b.id GROUP BY a.good_id" % result['id']) server_value_list = db.getAll( "select SUM(server_count) as server_count,b.name,b.price from (select server_id,server_count from order_server_item where order_id = '%s' ) a INNER JOIN server b on a.server_id = b.id GROUP BY a.server_id" % result['id']) # print(good_value_list) good_value = 0 server_value = 0 for x in good_value_list: good_value = good_value + (x['price'] * int(x['good_count'])) x['good_count'] = str(x['good_count']) logger.debug('商品消费为:' + str(good_value) + '元') for y in server_value_list: # print(y) server_value = server_value + (y['price'] * int(y['server_count'])) y['server_count'] = str(y['server_count']) logger.debug('服务消费为:' + str(server_value) + '元') # 目前除去优惠和延时费用的总消费价格 now_value = good_value + server_value resp = { "code": 0, "msg": "", "name": result['name'], "valid_point": valid_point, "site_money": float(result['price']), "money": str(now_value), "lay_value": result['lay_value'], "free_value": result['free_value'], "order_serial_number": result['order_serial_number'], "type": result['type'], "state": result['order_status'], "start_time": str(result['create_time']), "end_time": str(result['end_time']), "server": list(server_value_list), "good": list(good_value_list) } db.dispose() return HttpResponse(json.dumps(resp), content_type="application/json")
def list_server(req): """ 服务查询 :param req: :return: """ data = req.GET.copy() sql = 'select a.*,b.name as type from server a INNER JOIN server_category b ON a.server_category_id = b.id order by id' if 'servername' in data or 'type' in data: server_name = data['servername'] server_type = data['type'] if server_name != '' and server_type == '': sql = "select a.*,b.`name` as type from(select * from server where `name`='%s')a INNER JOIN server_category b ON a.server_category_id = b.id ORDER BY id " % ( server_name) elif server_name == '' and server_type != '': sql = "select a.*,b.`name` as type from(select * from server )a INNER JOIN (select * from server_category where `id`='%s') b ON a.server_category_id = b.id ORDER BY id " % ( server_type) elif server_name != '' and server_type != '': sql = "select a.*,b.`name` as type from(select * from server where `name`='%s' )a INNER JOIN (select * from server_category where `id`='%s') b ON a.server_category_id = b.id ORDER BY id" % ( server_name, server_type) else: pass db = Mysql() query_result = db.getAll(sql) db.dispose() server_list = list(query_result) if 'limit' in req.GET: limit = int(req.GET['limit']) page = int(req.GET['page']) resp = { "code": 0, "msg": "", "count": len(server_list), "data": server_list[(page - 1) * limit:page * limit] } else: resp = { "code": 0, "msg": "", "count": len(server_list), "data": server_list } logger.debug('【服务接口数据】:' + json.dumps(resp)) return HttpResponse(json.dumps(resp), content_type="application/json")
def grounding_good(req): """ 上架商品 :param req: :return: """ logger.debug('上架商品传入参数:' + str(req.POST)) id_list = req.POST.copy()['checkData'] logger.debug("上架商品的ID:" + str(id_list)) sql = 'UPDATE good SET status=1 WHERE id IN (%s)' % (id_list) db = Mysql() result = db.update(sql) print(result) if result == len(id_list.split(",")): resp = {"code": 0, "msg": "success"} else: resp = {"code": 1, "msg": "internal_exceptions"} return HttpResponse(json.dumps(resp), content_type="application/json")
def wx_del_love(req): """ 微信小程序删除收藏 :param req: :return: """ openid = req.POST['openid'] good_id = req.POST['id'] db = Mysql() sql = "delete from person_love where good_id=%s and openid = '%s' " % ( good_id, openid) print(sql) result = db.delete(sql) print(result) resp = {"code": 0, "msg": "success", "data": ''} return HttpResponse(json.dumps(resp), content_type="application/json")
def del_server(req): """ 服务删除(单个/批量删除) :param req: :return: """ id_list = req.POST.copy()['checkData'] logger.debug("删除数据的ID:" + str(id_list)) sql = 'DELETE FROM server WHERE id IN (%s)' % (id_list) db = Mysql() count = (db.delete(sql)) db.dispose() if count == len(id_list.split(",")): resp = {"code": 0, "msg": "success"} else: resp = {"code": 1, "msg": "internal_exceptions"} return HttpResponse(json.dumps(resp), content_type="application/json")
def list_order(req): data = req.GET.copy() sql = "select c.order_serial_number,d.name,c.person_id,d.phone,c.type,c.order_status as state,all_value,c.lay_value,c.free_value,c.notes from( select a.*,b.name as type from vip_order a INNER JOIN order_category b ON a.order_category_id = b.id order by id) c INNER JOIN person d on c.person_id = d.id ORDER BY c.order_serial_number desc" db = Mysql() n_list = [] query_result = db.getAll(sql) db.dispose() if len(query_result) != 0: order_list = list(query_result) # print(len(person_list)) # print req.GET limit = int(req.GET['limit']) page = int(req.GET['page']) for x in order_list: if x['state'] == 0: x['progress'] = '50%' elif x['state'] == 1 or x['state'] ==2: x['progress'] = '100%' else: x['progress'] = '0%' n_list.append(x) # print(len(n_list)) # print(n_list[(page - 1) * limit:page * limit]) resp = { "code": 0, "msg": "", "count": len(n_list), "data": n_list[(page - 1) * limit:page * limit] } else: resp = { "code": 0, "msg": "", "count": 0, "data": n_list } logger.debug('【订单接口数据】:' + json.dumps(resp)) return HttpResponse(json.dumps(resp), content_type="application/json")
def add_ad(req): """ 添加公告 :param req: :return: """ id_list = req.POST.copy() logger.debug("添加公告传入的参数:" + str(id_list)) sql = "INSERT INTO `ad`(`info`,`atime`) VALUES ('%s', now())" % ( id_list['ad']) print(sql) db = Mysql() count = (db.insertOne(sql)) db.dispose() if count: resp = {"code": 0, "msg": "success"} else: resp = {"code": 1, "msg": "internal_exceptions"} return HttpResponse(json.dumps(resp), content_type="application/json")
def wx_get_love_list(req): """ 微信小程序获取收藏列表 :param req: :return: """ openid = req.POST['openid'] db = Mysql() sql = "SELECT `id`,`name`,`good_category_id`,`price`,`origin_price`,`status`,`img_url`,`good_info` FROM good WHERE id IN (SELECT good_id FROM person_love WHERE openid = '%s')" % openid print(sql) result = db.getAll(sql) logger.debug(result) love_list = [] if result: love_list = list(result) else: pass resp = {"code": 0, "msg": "success", "data": love_list} return HttpResponse(json.dumps(resp), content_type="application/json")
def wx_List_Good(req): """ 微信小程序获取商品列表 :param req: :return: """ post_dic = req.POST logger.debug("微信小程序获取商品列表传入参数:" + str(post_dic)) sql = "SELECT id,name,good_category_id as categoryId,price as minPrice,origin_price as originalPrice,status as statusStr,img_url as pic FROM good where status=1" name_like = post_dic['nameLike'] typeId = str(post_dic['categoryId']) pageSize = int(post_dic['pageSize']) page = int(post_dic['page']) if typeId == '-1': sql = "SELECT id,name,good_category_id as categoryId,price as minPrice,origin_price as originalPrice,status as statusStr,img_url as pic FROM good where status=1 and origin_price !=0 " elif typeId: sql = sql + ' AND good_category_id = %s' % typeId else: pass if name_like != '': sql = sql + " AND UPPER(name) like UPPER('%{0}%')".format(name_like) else: pass db = Mysql() print(sql) result = db.getAll(sql) print(list(result)) result_list = list(result)[(page - 1) * pageSize:page * pageSize] resp = '' if result_list: resp = {"code": 0, "msg": "success", "data": result_list} else: resp = {"code": 700, "msg": "success,no data", "data": []} return HttpResponse(json.dumps(resp), content_type="application/json")
def del_vip_person(req): """ 会员删除(单个/批量删除) :param req: :return: """ id_list= req.POST.copy()['checkData'] # print (id_list) sql = 'DELETE FROM vms.person WHERE id IN (%s)'%(id_list) db = Mysql() exist = db.getAll("select * from vip_order where person_id in (%s) and order_status = 0"%(id_list)) if not exist: count = (db.delete(sql)) db.dispose() if count == len(id_list.split(",")): resp = { "code": 0, "msg": "success" } else: resp = { "code": 1, "msg": "internal_exceptions" } else: resp = { "code": 2, "msg": "person exist order" } return HttpResponse(json.dumps(resp), content_type="application/json")
def add_server(req): """ 添加服务 :param req: :return: """ logger.debug('添加服务传入参数:' + str(req.POST)) data = req.POST.copy() db = Mysql() is_exist = db.getAll('SELECT * from server where `name` =\'%s\'' % (data['name'])) if (is_exist): # 已存在该服务无法添加 resp = {"code": 2, "msg": "server_is_exist"} logger.debug('添加失败,服务已存在') else: sql = "INSERT INTO `server` ( `name`, `server_category_id`, `price`) VALUES ('%s', '%s', '%s');" % ( data['name'], data['type'], data['price']) logger.debug(sql) dd = db.insertOne(sql) db.dispose() if dd != 0: # 服务添加成功 resp = {"code": 0, "msg": "success"} logger.debug('商品添加成功') else: # 服务添加失败 resp = {"code": 1, "msg": "internal_exceptions"} logger.debug('服务异常,商品添加失败') return HttpResponse(json.dumps(resp), content_type="application/json")
def edit_server(req): """ 编辑服务 :param req: :return: """ logger.debug('更新服务传入参数:' + str(req.POST)) data = req.POST.copy() logger.debug(data) sql2 = "SELECT * from server where `name` ='%s' and id != '%s'" % (data['name'], data['id']) logger.debug(sql2) db = Mysql() is_exist = db.getAll(sql2) if(is_exist): # 无法更新为已存在服务 resp = { "code": 2, "msg": "server_is_exist" } logger.debug('更新失败,商品已存在') else: result = db.getOne("SELECT * from server where id = '%s'" % data['id']) # print(result) if result['name']== data['name'] and float(result['price']) == float(data['price']) and int(result['server_category_id']) == int(data['type']) : # 服务未更改无需更新 resp = { "code": 2, "msg": "nothing is changed" } logger.debug('服务异常,服务更新失败') else: sql = "UPDATE server SET `name` = '%s',server_category_id= '%s',price='%s' WHERE id='%s'" % (data['name'], data['type'], data['price'],data['id']) logger.debug(sql) dd = db.update(sql) # print(dd) db.dispose() if dd != 0: # 服务更新成功 resp = { "code": 0, "msg": "success" } logger.debug('服务更新成功') else: # 服务更新失败 resp = { "code": 1, "msg": "internal_exceptions" } logger.debug('服务异常,服务更新失败') return HttpResponse(json.dumps(resp), content_type="application/json")
def add_server(req): """ 添加分类 :param req: :return: """ logger.debug('添加分类传入参数:' + str(req.POST)) data = req.POST.copy() db = Mysql() is_exist = db.getAll( "SELECT * from good_category where `name` ='%s' or `sort` ='%s'" % (data['name'], data['sort'])) if is_exist: # 已存在该分类 resp = {"code": 2, "msg": "server_is_exist"} logger.debug('添加失败,分类或排序已存在,请修改后添加!') else: sql = "INSERT INTO `good_category`(`name`,`sort`) VALUES ('%s','%s');" % ( data['name'], data['sort']) logger.debug(sql) dd = db.insertOne(sql) db.dispose() if dd != 0: # 分类添加成功 resp = {"code": 0, "msg": "success"} logger.debug('分类添加成功') else: # 分类添加失败 resp = {"code": 1, "msg": "internal_exceptions"} logger.debug('分类异常,分类添加失败') return HttpResponse(json.dumps(resp), content_type="application/json")
def wx_get_ad(req): """ 微信小程序获取收藏列表 :param req: :return: """ db = Mysql() sql1 = "SELECT count(1) from `ad`;" result = db.getOne(sql1) if result['count(1)'] != 0: sql = "SELECT * from `ad` ORDER by `atime` desc LIMIT 1;" count = (db.getOne(sql)) print(count) db.dispose() if count: resp = {"code": 0, "msg": "success", "data": count['info']} else: resp = {"code": 1, "msg": "internal_exceptions"} else: resp = {"code": 2, "msg": "no ad"} return HttpResponse(json.dumps(resp), content_type="application/json")
def wx_add_love(req): """ 微信小程序添加收藏 :param req: :return: """ good_id = req.POST['id'] openid = req.POST['openid'] db = Mysql() sql = "INSERT INTO person_love(`good_id`,`openid`,`add_time`)VALUES(%s,'%s',now())" % ( good_id, openid) # print(sql) result = db.insertOne(sql) logger.debug(result) if int(result) > 0: resp = {"code": 1, "msg": "success", "data": ''} else: resp = {"code": 400, "msg": "fail", "data": ''} return HttpResponse(json.dumps(resp), content_type="application/json")
def onsale_good(req): """ 特价商品 :param req: :return: """ logger.debug('特价商品传入参数:' + str(req.POST)) orgin_price = req.POST.copy()['origin_price'] id = req.POST.copy()['id'] logger.debug("特价商品的ID:" + id) sql = 'UPDATE good SET origin_price=%s WHERE id = %s' % (orgin_price, id) db = Mysql() try: result = db.update(sql) except Exception as e: print(e) print(result) if result == 1: resp = {"code": 0, "msg": "success"} else: resp = {"code": 1, "msg": "internal_exceptions"} return HttpResponse(json.dumps(resp), content_type="application/json")
def wx_is_love(req): """ 微信小程序查看是否存在收藏 :param req: :return: """ logger.debug("微信小程序查看是否存在收藏传入参数: " + str(req.POST.copy())) good_id = req.POST['id'] openid = req.POST['openid'] resp = {"code": 700, "msg": "fail", "data": ''} db = Mysql() sql = "SELECT * FROM person_love WHERE good_id = '%s' and openid = '%s'" % ( good_id, openid) # print(sql) result = db.getAll(sql) logger.debug(result) if not result: resp = {"code": 0, "msg": "success", "data": ''} else: resp = {"code": 400, "msg": "success", "data": ''} db.dispose() return HttpResponse(json.dumps(resp), content_type="application/json")
def __deco(request, *para, **kw): if debug: print("JWT debug状态,未校验!") return func(request, *para, **kw) else: token = '' db = Mysql() if request.method == 'GET': token = request.GET.get('access_token') elif request.method == 'POST': token = request.POST.get('access_token') else: print('尚未处理的请求类型') if token is not None: try: payload = jwt.decode(token, 'mothanty', algorithms=['HS256']) except Exception as e: db.delete("DELETE FROM t_token WHERE token='%s'" % token) print(e) resp = { "code": 1001, "msg": "", "count": 0, "data": [] } return HttpResponse(json.dumps(resp), content_type="application/json") result = db.getAll( "select * from t_token where token = '%s' and DATE_SUB(now(), INTERVAL 1 HOUR)<time" % token) if payload: if result: db.update("UPDATE t_token set time = now() WHERE token ='%s'" % token) print (func.__name__ + '方法token校验--成功') return func(request, *para, **kw) print (func.__name__ + '方法token校验--失败') db.delete("DELETE FROM t_token WHERE token='%s'" % token) resp = { "code": 1001, "msg": "", "count": 0, "data": [] } return HttpResponse(json.dumps(resp), content_type="application/json")
def edit_good(req): """ 编辑商品 :param req: :return: """ logger.debug('更新商品传入参数:' + str(req.POST)) data = req.POST.copy() logger.debug(data) sql2 = "SELECT * from good where `name` ='%s' and id != '%s'" % (data['title'], data['id']) logger.debug(sql2) if float(data['origin_price']) > float(data['price']): resp = { "code": 3, "msg": "price_incorrect" } logger.debug('原价低于售价,请重新更新') else: db = Mysql() is_exist = db.getAll(sql2) if(is_exist): # 无法更新为已存在商品 resp = { "code": 2, "msg": "good_is_exist" } logger.debug('更新失败,商品已存在') else: count = str(int(data['count'])+int(data['add_count'])) sql = "UPDATE good SET `name` = '%s',good_category_id= '%s',price='%s',status='%s',uploadtime = now(),origin_price='%s' WHERE id=%s" % ( data['title'], data['type'], data['price'], count, data['origin_price'],data['id']) logger.debug(sql) dd = db.update(sql) db.dispose() if dd != 0: # 商品更新成功 resp = { "code": 0, "msg": "success" } logger.debug('商品更新成功') else: # 商品更新失败 resp = { "code": 1, "msg": "internal_exceptions" } logger.debug('服务异常,商品更新失败') return HttpResponse(json.dumps(resp), content_type="application/json")
def del_order(req): """ 废弃订单,将订单状态修改为2,此单消费货物返还。 :param req: :return: """ logger.debug('订单废弃传入参数:' + str(req.GET)) data = req.GET.copy() sql_list = [] sql = "UPDATE vip_order SET order_status = 2,all_value = '0',end_time=now() WHERE order_serial_number = '%s'"%data['order_serial_number'] sql2 = "select a.good_id,a.good_count from order_good_item a INNER JOIN vip_order b ON a.order_id = b.id and b. order_serial_number = '%s'" %data['order_serial_number'] db = Mysql() result = db.getAll(sql2) # print(result) if result: for x in result: good_id = x['good_id'] good_count = int(x['good_count']) sql_list.append("UPDATE good SET status = status+'%d' WHERE id = '%s'"%(good_count,good_id)) sql_list.append(sql) count = db.excuteManysql(sql_list) # print(count) if count == 1+len(result): resp = { "code": 0, "msg": "success" } logger.debug('订单废弃成功') else: resp = { "code": 1, "msg": "internal_exceptions" } else: count = db.update(sql) if count == 1: resp = { "code": 0, "msg": "success" } logger.debug('订单废弃成功') else: resp = { "code": 1, "msg": "internal_exceptions" } db.dispose() return HttpResponse(json.dumps(resp), content_type="application/json")
def edit_server(req): """ 编辑分类 :param req: :return: """ logger.debug('更新传入参数:' + str(req.POST)) data = req.POST.copy() logger.debug(data) sql2 = "SELECT * from good_category where `name` ='%s' and id != '%s'" % ( data['name'], data['id']) logger.debug(sql2) db = Mysql() is_exist = db.getAll(sql2) if is_exist: # 无法更新为已存在分类 resp = {"code": 2, "msg": "server_is_exist"} logger.debug('更新失败,分类已存在') else: result = db.getOne("SELECT * from good_category where id = '%s'" % data['id']) # print(result) if result['name'] == data['name'] and int(result['sort']) == int( data['sort']): # 分类未更改无需更新 resp = {"code": 2, "msg": "nothing is changed"} logger.debug('未变更,无需更新') else: sql = "UPDATE good_category SET `name` = '%s',`sort`= '%s' WHERE id='%s'" % ( data['name'], data['sort'], data['id']) logger.debug(sql) dd = db.update(sql) # print(dd) db.dispose() if dd != 0: # 分类更新成功 resp = {"code": 0, "msg": "success"} logger.debug('分类更新成功') else: # 分类更新失败 resp = {"code": 1, "msg": "internal_exceptions"} logger.debug('分类异常,分类更新失败') return HttpResponse(json.dumps(resp), content_type="application/json")