def post(self, request):
recurrence_id = request.POST.get('recurrence_id')
mysql = Mysql()
sql = f"DELETE FROM recurrence WHERE id = '{recurrence_id}'"
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def get(self, request):
mysql = Mysql()
sql = "SELECT p.*, pr.prize_detail, pr.all_limit, pr.one_limit FROM probability as p \
LEFT JOIN prize as pr ON p.prize_id = pr.id ORDER BY p.id"
info = mysql.getAll(sql)
mysql.dispose()
if info:
info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4)
return HttpResponse(info)
return 0
def del_(self):
self.info['cart_id'] = json.loads(self.info['cart_id'])
if not isinstance(self.info['cart_id'], list):
return HttpResponse(returnJson(-2, '参数错误'))
mysql = Mysql()
for i in self.info['cart_id']:
sql = "DELETE FROM cart WHERE id = %s"
mysql.delete(sql, param=[i])
mysql.dispose()
return HttpResponse(returnJson(0, '删除成功'))
def post(self, request):
address_id = request.POST.get('address_id')
mysql = Mysql()
sql = "DELETE FROM school_address WHERE id = '{address_id}'".format(
address_id=address_id)
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
area_name = request.POST.get('area_name')
mysql = Mysql()
sql = "INSERT INTO school_area SET area_name = '{area_name}'".format(
area_name=area_name)
suc = mysql.insertOne(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def get(self, request):
class_id = request.GET.get('class_id')
mysql = Mysql()
sql = "SELECT prize_type_id, prize_type_name FROM \
prize_type_class WHERE prize_class_id ='{class_id}'".format(class_id=class_id)
info = mysql.getAll(sql)
mysql.dispose()
if info:
info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4)
return HttpResponse(info)
return HttpResponse(0)
def get_one_activity(self):
mysql = Mysql()
sql = 'SELECT * FROM activity WHERE activityName LIKE "%{name}%"'.format(
name=self.__reqDtat['name'])
info = mysql.getAll(sql)
mysql.dispose()
if info:
iswin = 1
else:
iswin = 0
return info, iswin
def add_activity(self):
mysql = Mysql()
if self.__reqData['poster'] == 0:
sql = 'INSERT INTO activity(activityName, activityImg, startTime, endTime, poster, acti_class_id) VALUES("{name}","{img}","{start}","{end}","{poster}","{class_id}")'.format(
name=self.__reqData['activityName'],
img=self.__reqData['activityImg'],
start=self.__reqData['startTime'],
end=self.__reqData['endTime'],
poster=self.__reqData['poster'],
class_id=1)
mysql.insertOne(sql)
iswin = 1
elif self.__reqData['poster'] == 1:
sql = 'INSERT INTO activity(activityName, activityImg, startTime, endTime, poster, acti_class_id) VALUES("{name}","{img}","{start}","{end}","{poster}","{class_id}")'.format(
name=self.__reqData['activityName'],
img=self.__reqData['activityImg'],
start=self.__reqData['startTime'],
end=self.__reqData['endTime'],
poster=self.__reqData['poster'],
class_id=1)
print(sql)
act_info = mysql.insertOne(sql)
print(act_info)
# sql = 'SELECT id FROM activity WHERE activityName="{activityName}"'.format(activityName=self.__reqData['activityName'])
# act_info = mysql.getOne(sql)
act_dict = json.loads(self.__reqData['act_list'])
for k, v in act_dict.items():
stockProductId = v.get('stockProductId')
newPrice = v.get('newPrice')
newHHcoin = v.get('newHHcoin')
limitnum = v.get('limitnum')
sql = 'INSERT INTO activityproduct(activityId,stockProductId,newPrice,newHHcoin,limitnum) ' \
'VALUES({act_num},{stockProductId},{newPrice},{newHHcoin},{limitnum})'.format(
act_num=act_info, stockProductId=stockProductId, newPrice=newPrice,
newHHcoin=newHHcoin, limitnum=limitnum)
print(sql)
mysql.insertOne(sql)
sql = "UPDATE product, spec SET product.act_num='{act_num}', product.limitNum='{limitnum}', \
spec.limitNum='{limitnum}', spec.acti_hehecoin='{newHHcoin}', \
spec.acti_price='{newPrice}' \
WHERE spec.productId = product.id \
AND spec.id='{stockProductId}'".format(
act_num=act_info,
limitnum=limitnum,
newHHcoin=newHHcoin,
newPrice=newPrice,
stockProductId=stockProductId)
print(sql)
mysql.update(sql)
iswin = 1
else:
iswin = 0
mysql.dispose()
return iswin
def get(self, request):
quiz_id = request.GET.get("quiz_id")
mysql = Mysql()
sql = f"SELECT * FROM quiz_bank WHERE quiz_id = {quiz_id}"
info = mysql.getAll(sql)
mysql.dispose()
if info:
info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4, cls=ComplexEncode)
return HttpResponse(info)
return HttpResponse(0)
def post(self, request):
mer_userid = request.POST.get('mer_userid')
mysql = Mysql()
#sql = f"DELETE FROM mer_admin WHERE phone = '{phone}' "
sql = f"DELETE FROM mer_admin WHERE mer_userid = '{mer_userid}'"
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def merOrder(self):
mysql = Mysql()
# 获取userid
sql = "UPDATE mer_orders SET wxid = %s, state = '1', \
wx_money = %s, pay_time = NOW() WHERE order_num = %s "
state = mysql.update(sql,
param=[
self.Info['wxid'], self.Info['total_fee'],
self.Info['orderNum']
])
mysql.dispose()
def get(self, request):
prize_id = request.GET.get('prize_id')
mysql = Mysql()
sql = "SELECT stock.stock_name, stock.id, prize_stock.stock_numb FROM prize_stock \
LEFT JOIN stock ON prize_stock.stock_id = stock.id \
WHERE prize_stock.prize_id = '{prize_id}'".format(prize_id=prize_id)
info = mysql.getOne(sql)
mysql.dispose()
if info:
info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4)
return HttpResponse(info)
return HttpResponse(0)
def get(self, request, **payload):
mer_id = request.GET.get('mer_id') # list
mer_id = json.loads(mer_id)
mysql = Mysql()
data = {}
for i in mer_id:
sql = "SELECT * FROM mer_product WHERE mer_id = %s"
product = mysql.getAll(sql, param=i)
product = product if product else []
data[i] = product
mysql.dispose()
return HttpResponse(callJson(data))
def sel_activity_class(self):
mysql = Mysql()
if self.__reqData['parentId']:
sql = 'SELECT * FROM activity_class WHERE acti_parentId = "{parentId}"'.format(
id=self.__reqData['parentId'])
info = mysql.getAll(sql)
return info
else:
sql = 'SELECT * FROM activity_class WHERE acti_parentId = 0'
info = mysql.getAll(sql)
mysql.dispose()
return info
def edit_act(self):
mysql = Mysql()
if self.__reqData['poster'] == 0:
sql = "UPDATE activity SET activityName='{activityName}', activityImg='{activityImg}', startTime='{startTime}', endTime='{endTime}', acti_class_id='{class_id}' WHERE id = '{id}'".format(
activityName=self.__reqData['activityName'],
activityImg=self.__reqData['activityImg'],
startTime=self.__reqData['startTime'],
endTime=self.__reqData['endTime'],
id=self.__reqData['id'],
class_id=self.__reqData['class_id'])
print(sql)
mysql.update(sql)
iswin = 1
elif self.__reqData['poster'] == 1:
sql = "UPDATE activity SET activityName='{activityName}', activityImg='{activityImg}', startTime='{startTime}', endTime='{endTime}', acti_class_id='{class_id}' WHERE id = '{id}'".format(
activityName=self.__reqData['activityName'],
activityImg=self.__reqData['activityImg'],
startTime=self.__reqData['startTime'],
endTime=self.__reqData['endTime'],
id=self.__reqData['id'],
class_id=self.__reqData['class_id'])
mysql.update(sql)
if self.__reqData['act_list']:
act_dict = json.loads(self.__reqData['act_list'])
for k, v in act_dict.items():
newPrice = v.get('newPrice')
newHHcoin = v.get('newHHcoin')
limitnum = v.get('limitnum')
new_stockProductId = v.get('stockProductId')
sql1 = "INSERT INTO activityproduct(activityId,stockProductId,newPrice,newHHcoin,limitnum) \
VALUES('{act_num}','{stockProductId}','{newPrice}','{newHHcoin}','{limitnum}')".format(
act_num=self.__reqData['id'],
stockProductId=new_stockProductId,
newPrice=newPrice,
newHHcoin=newHHcoin,
limitnum=limitnum)
print(sql1)
mysql.insertOne(sql1)
sql = "UPDATE product, spec SET product.act_num='{actid}', product.limitNum='{limitnum}', \
spec.limitNum='{limitnum}', spec.acti_hehecoin='{newHHcoin}', \
spec.acti_price='{newPrice}' \
WHERE spec.productId = product.id \
AND spec.id='{stockProductId}'" .format\
(actid=self.__reqData['id'], limitnum=limitnum, newHHcoin=newHHcoin, newPrice=newPrice, stockProductId=new_stockProductId)
mysql.update(sql)
print(sql)
iswin = 1
else:
iswin = 2
else:
iswin = 0
mysql.dispose()
return iswin
def post(self, request):
self.params = {}
self.params['mer_userid'] = request.POST.get('mer_userid')
mysql = Mysql()
sql = "DELETE FROM mer_admin WHERE mer_userid \
= '{mer_userid}'".format(mer_userid=self.params['mer_userid'])
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
stock_id = request.POST.get('stock_id')
try:
mysql = Mysql()
sql = "UPDATE stock SET state = 0 WHERE id = %s"
mysql.update(sql, param=[stock_id])
mysql.dispose()
return JsonResponse({'ret': 0, 'msg': '删除成功'})
except Exception as e:
print(e)
mysql.errdispose()
return JsonResponse({'ret': -2, 'msg': '删除失败'})
def post(self, request):
order_num = request.POST.get('order_num')
mysql = Mysql()
sql = f"UPDATE orders SET state = '7' WHERE orderNum = '{order_num}'"
try:
mysql.update(sql)
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
school_id = request.POST.get('school_id')
address = str(request.POST.get('address'))
mysql = Mysql()
sql = "INSERT INTO school_address SET school_id='{school_id}', \
address='{address}'".format(school_id=school_id, address=address)
suc = mysql.insertOne(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
product_id = request.POST.get('product_id')
mysql = Mysql()
try:
sql = "UPDATE product SET label='0' WHERE id=%s"
mysql.update(sql, param=[product_id])
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
prize_id = request.POST.get('prize_id')
num = float(request.POST.get('num'))
mysql = Mysql()
sql = "UPDATE prize_phv SET num='{num}' WHERE prize_id='{prize_id}'".format(prize_id=prize_id, num=num)
try:
mysql.update(sql)
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
try:
self.__reqData = {}
self.__reqData['img_id'] = request.POST.get('img_id')
mysql = Mysql()
sql = "DELETE FROM banner WHERE id = %s"
suc = mysql.delete(sql, param=[self.__reqData['img_id']])
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def merPayOrder(self):
mysql = Mysql()
# 更新订单
sql = "UPDATE mer_pay SET wxid = %s, wx_money = %s, \
state = 1, pay_time=NOW() WHERE order_num = %s"
state = mysql.update(sql,
param=[
self.Info['wxid'], self.Info['total_fee'],
self.Info['orderNum']
])
mysql.update(sql)
mysql.dispose()
def post(self, request):
self.params = {}
self.params['product_id'] = request.POST.get('product_id')
mysql = Mysql()
sql = "DELETE FROM mer_product WHERE \
product_id = '{product_id}'".format(
product_id=self.params['product_id'])
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
area_name = request.POST.get('area_name')
area_id = request.POST.get('area_id')
mysql = Mysql()
sql = "UPDATE school_area SET area_name='{area_name}' WHERE \
id='{area_id}' ".format(area_name=area_name, area_id=area_id)
try:
mysql.update(sql)
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def get(self, request):
order_num = request.GET.get('order_num')
mysql = Mysql()
sql = f"SELECT * FROM as_orders WHERE order_id = '{order_num}'"
info = mysql.getOne(sql)
mysql.dispose()
if info:
info = json.dumps(info,
ensure_ascii=False,
sort_keys=True,
indent=4,
cls=ComplexEncode)
return HttpResponse(info)
return HttpResponse(0)
def post(self, request):
class_id = request.POST.get('class_id')
class_name = request.POST.get('class_name')
mysql = Mysql()
sql = "UPDATE prize_class SET class_name = '{class_name}' WHERE \
id = '{class_id}'".format(class_name=class_name, class_id=class_id)
try:
mysql.update(sql)
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
banner = request.POST.get('banner')
title = request.POST.get('title')
details = html.escape(request.POST.get('details'))
profile = request.POST.get('profile')
mysql = Mysql()
sql = f"INSERT INTO information SET banner='{banner}', \
title='{title}', details='{details}', profile='{profile}'"
suc = mysql.insertOne(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request, **payload):
try:
user_id = payload.get('user_id')
address = request.POST.get('address')
handle_type = request.POST.get('handle_type')
if handle_type == 'finish':
if not address:
return JsonResponse({'ret': -2, 'msg': '地址数据为空'})
mysql = Mysql()
sql = "SELECT * FROM user_star_sign WHERE user_id = %s FOR UPDATE"
mysql.getOne(sql, param=[user_id])
sql = "SELECT * FROM user_star_sign WHERE \
user_id = %s \
AND one > 0 \
AND two > 0 \
AND three > 0 \
AND four > 0 \
AND five > 0 \
AND six > 0 \
AND seven > 0 \
AND eight > 0 \
AND nine > 0 \
AND ten > 0 \
AND eleven > 0 \
AND twelve > 0 \
AND state = 0"
check = mysql.getOne(sql, param=[user_id])
if not check:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '碎片不足或已被领取'})
sql = "UPDATE user_star_sign SET address = %s, \
state = 1 WHERE user_id = %s"
mysql.update(sql, param=[address, user_id])
patch_type = [i for i in range(1, 13)]
getPatch(user_id, patch_type, 11, 0, mysql)
mysql.dispose()
return JsonResponse({'ret': 0, 'msg': '领取成功'})
if handle_type == 'update':
mysql = Mysql()
sql = "SELECT * FROM user_star_sign WHERE state = 1 \
AND user_id = %s FOR UPDATE"
user_info = mysql.getOne(sql, param=[user_id])
if not user_info:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '网络繁忙'})
sql = "UPDATE user_star_sign SET address = %s \
WHERE user_id = %s AND state = 1"
mysql.update(sql, param=[address, user_id])
mysql.dispose()
return JsonResponse({'ret': 0, 'msg': '领取成功'})
return JsonResponse({'ret': -2, 'msg': '参数错误'})
except Exception as e:
mysql.errdispose()
erroLog(e)
return JsonResponse({'ret': -2, 'msg': '网络错误'})
def get(self, request):
order_num = request.GET.get('order_num') #订单编号
mysql = Mysql()
sql = f"SELECT * FROM ordergoods WHERE order_id = '{order_num}'"
info = mysql.getAll(sql)
mysql.dispose()
if info:
info = json.dumps(info,
ensure_ascii=True,
sort_keys=False,
indent=4)
return HttpResponse(info)
else:
return HttpResponse(0)
