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")