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 post(self, request):
try:
self.info['product_id'] = request.POST.get('product_id')
self.info['productTypeId'] = request.POST.get('type_id')
self.info['productName'] = request.POST.get('product_name')
self.info['productImg'] = request.POST.get('product_img')
self.info['hehecoin'] = request.POST.get('hhcoin')
self.info['price'] = request.POST.get('price')
self.info['remark'] = request.POST.get('remark')
self.info['notes'] = request.POST.get('notes')
self.info['user_goods_limit'] = request.POST.get(
'user_goods_limit') #个人总限量
mysql = Mysql()
sql = "UPDATE product SET productTypeId=%s, productName=%s,\
productImg=%s, hehecoin=%s, minPrice=%s, user_goods_limit=%s,\
maxPrice=%s, remark=%s, notes=%s WHERE id=%s"
mysql.update(sql,
param=[
self.info['productTypeId'],
self.info['productName'], self.info['productImg'],
self.info['hehecoin'], self.info['price'],
self.info['user_goods_limit'], self.info['price'],
self.info['remark'], self.info['notes'],
self.info['product_id']
])
mysql.dispose()
return JsonResponse({'ret': 0, 'msg': '编辑商品成功'})
except Exception as e:
print(e)
mysql.errdispose()
erroLog(e)
return JsonResponse({'ret': -2, 'msg': '编辑商品失败'})
def post(self, request):
try:
self.info['store_id'] = request.POST.get('store_id')
self.info['type_id'] = request.POST.get('type_id')
self.info['product_name'] = request.POST.get('product_name')
self.info['user_goods_limit'] = request.POST.get(
'user_goods_limit')
self.info['product_img'] = request.POST.get(
'product_img') #列表取第一张 多张逗号分隔
self.info['hhcoin'] = request.POST.get('hhcoin')
self.info['price'] = request.POST.get('price')
self.info['remark'] = request.POST.get('remark')
self.info['notes'] = request.POST.get('notes')
mysql = Mysql()
sql = "INSERT INTO product SET productTypeId=%s, productName=%s, \
user_goods_limit=%s, productImg=%s, upper_shelf=0, \
hehecoin=%s, minPrice=%s, maxPrice=%s, label=0, \
remark=%s, store_id=%s, notes=%s"
mysql.insertOne(
sql,
param=[
self.info['type_id'], self.info['product_name'],
self.info['user_goods_limit'], self.info['product_img'],
self.info['hhcoin'], self.info['price'],
self.info['price'], self.info['remark'],
self.info['store_id'], self.info['notes']
])
mysql.dispose()
return JsonResponse({'ret': 0, 'msg': '添加商品成功'})
except Exception as e:
print(e)
mysql.errdispose()
erroLog(e)
return JsonResponse({'ret': -2, 'msg': '添加商品失败'})
def get(self, request):
try:
qqq = 1
zzz
return HttpResponse(1)
except Exception as e:
erroLog(e)
return HttpResponse(1)
def post(self, request):
try:
unionid = request.POST.get('unionid')
position = request.POST.get('position')
mysql = Mysql()
sql = "SELECT * FROM h5_user WHERE unionid = %s FOR UPDATE"
user_info = mysql.getOne(sql, param=[unionid])
if not user_info:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '无用户信息'})
sql = 'SELECT * FROM gzh_user WHERE unionid = %s AND state = 1'
gzh_info = mysql.getOne(sql, param=[unionid])
if not gzh_info:
mysql.dispose()
return JsonResponse({'ret': -1, 'msg': '未关注公众号'})
sql = "SELECT COUNT(*) AS numbers FROM h5_luckdraw_log \
WHERE unionid = %s AND create_time BETWEEN %s AND %s"
numbers = mysql.getOne(
sql, param=[unionid, self.START_TIME, self.END_TIME])
if numbers:
if numbers.get('numbers') >= 12:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '当日抽奖次数达到上限'})
if user_info.get('lucky_draw_times') < 1:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '抽奖次数不足'})
sql = 'SELECT * FROM h5_luckdraw_log WHERE unionid = %s \
AND position = %s AND create_time BETWEEN %s AND %s'
luckdraw_postion = mysql.getOne(
sql, param=[unionid, position, self.START_TIME, self.END_TIME])
if luckdraw_postion:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '网络繁忙'})
sql = "UPDATE h5_user SET lucky_draw_times = \
lucky_draw_times - 1 WHERE unionid = %s"
mysql.update(sql, param=[unionid])
patch_id = randomH5Patch()
sql = "INSERT INTO h5_luckdraw_log SET unionid = %s, \
patch_id = %s, state = 0, position=%s"
mysql.insertOne(sql, param=[unionid, patch_id, position])
mysql.dispose()
return JsonResponse({
'ret': 0,
'msg': '抽奖成功',
'result': {
'patch_id': patch_id,
'patch_name': STAR_SIGIN[patch_id]
}
})
except Exception as e:
mysql.errdispose()
erroLog(e)
return JsonResponse({'ret': -2, 'msg': '网络错误'})
def save_data(self):
try:
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()
except Exception as e:
erroLog(e)
print(e)
def post(self, request):
try:
phone = request.POST.get('phone')
code = request.POST.get('code')
conn = Open_Redis().getConn(7)
if conn.exists(phone):
cache = conn.get(phone)
if cache.decode('utf-8') != code:
return HttpResponse(returnJson(-2, '验证码失效'))
token = getToken({'user_id' : 907}, 24)
token = {'token' : token}
return HttpResponse(returnJson(0, '登录成功', result=token))
return HttpResponse(returnJson(-1, '不存在验证码请重新发送'))
except Exception as e:
erroLog(e)
return HttpResponse(returnJson(-2, '网络错误'))
def get(self, request):
try:
unionid = request.GET.get('unionid')
if not unionid:
return JsonResponse({'ret': -2, 'msg': '缺少参数'})
mysql = Mysql()
sql = 'SELECT * FROM h5_user WHERE unionid = %s'
share_info = mysql.getOne(sql, param=[unionid])
if not share_info:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '公众号信息未授权'})
# sql = 'SELECT id FROM userInfo WHERE unionId = %s'
# user_id = mysql.getOne(sql, param=[unionid])
# if not user_id:
# mysql.dispose()
# return JsonResponse({
# 'ret' : -2,
# 'msg' : '小程序信息未授权'
# })
user_id = user_id.get('id')
sql = 'SELECT one, two, three, four, five, six, seven, \
eight, nine, ten, eleven, twelve \
FROM user_star_sign WHERE user_id = %s'
patch_info = mysql.getOne(sql, param=[user_id])
sql = "SELECT hu.nickname, hu.headimgurl \
FROM h5_help_log AS hl \
LEFT JOIN h5_user AS hu ON hl.help_unionid = hu.unionid \
WHERE leader_unionid = %s"
helpuser_info = mysql.getAll(sql, param=[unionid])
mysql.dispose()
data = {
'ret': 0,
'msg': '查询成功',
'resule': {
'patch_info': patch_info,
'help_user': helpuser_info,
'lucky_draw_times': share_info.get('lucky_draw_times')
}
}
return JsonResponse(data)
except Exception as e:
erroLog(e)
mysql.errdispose()
return JsonResponse({'ret': -2, 'msg': '网络错误'})
def get(self, request, **payload):
try:
user_id = payload.get('user_id')
mysql = Mysql()
data = {}
sql = "SELECT * FROM user_star_sign WHERE user_id = %s"
result = mysql.getAll(sql, param=[user_id])
data = {'ret': 0, 'result': result}
if not result:
sql = "INSERT INTO user_star_sign SET user_id = %s "
mysql.insertOne(sql, param=[user_id])
sql = "SELECT * FROM user_star_sign WHERE user_id = %s"
info = mysql.getAll(sql, param=[user_id])
data = {'ret': 0, 'msg': '查询成功', 'result': info}
sql = "SELECT unionId FROM userInfo WHERE id = %s"
user_info = mysql.getOne(sql, param=[user_id])
if user_info.get('unionId'):
sql = "SELECT * FROM h5_luckdraw_log WHERE unionid = %s AND state = 0"
luckdraw_log = mysql.getAll(sql,
param=[user_info.get('unionId')])
if luckdraw_log:
patch_list = []
for i in luckdraw_log:
patch_list.append(i.get('patch_id'))
sql = 'UPDATE h5_luckdraw_log SET state = 1 WHERE id = %s'
mysql.update(sql, param=[i.get('id')])
getPatch(user_id, patch_list, 3, 1, mysql)
data['msg'] = '查询成功 碎片领取成功'
sql = "SELECT * FROM user_star_sign WHERE user_id = %s"
info = mysql.getAll(sql, param=[user_id])
data['result'] = info
else:
data['msg'] = '查询成功 无碎片领取'
else:
data['ret'] = -1
data['msg'] = '查询成功 但未绑定unionid 可能会导致h5抽奖碎片领取失败'
mysql.dispose()
return HttpResponse(callJson(data))
except Exception as e:
print(e)
mysql.errdispose()
erroLog(e)
return JsonResponse({'ret': -2, 'msg': '网络错误'})
def post(self, request):
try:
phone = request.POST.get('phone')
print(phone)
if not phone:
print(phone)
return HttpResponse(returnJson(-2, '手机号码错误'))
conn = Open_Redis().getConn(7)
cache = conn.exists(phone)
if conn.exists(phone):
return HttpResponse(returnJson(-1, '已有验证码 请勿重新发送'))
code = sendSms(phone)
if code:
code = {'code' : code}
return HttpResponse(returnJson(0, '成功', code))
return HttpResponse(returnJson(-2, '验证码发送失败'))
except Exception as e:
erroLog(e)
return HttpResponse(returnJson(-2, '网络繁忙'))
def post(self, request):
try:
product_id = request.POST.get('product_id')
mysql = Mysql()
sql = "SELECT * FROM product WHERE id = %s AND upper_shelf=1"
check = mysql.getOne(sql, param=[product_id])
if check:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '删除失败 商品上架中'})
sql = "UPDATE product SET state = 0 WHERE id = %s"
mysql.update(sql, param=[product_id])
sql = "UPDATE stock SET state = 0 WHERE product_id = %s"
mysql.update(sql, param=[product_id])
mysql.dispose()
return JsonResponse({'ret': 0, 'msg': '删除成功'})
except Exception as e:
print(e)
mysql.errdispose()
erroLog(e)
return JsonResponse({'ret': -2, 'msg': '删除失败'})
def post(self, request):
try:
handle_type = request.POST.get('handle_type')
unionid = request.POST.get('unionid')
if handle_type == 'share':
mysql = Mysql()
sql = 'SELECT id as share_id FROM h5_user WHERE unionid = %s'
share_info = mysql.getOne(sql, param=[unionid])
if not share_info:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '公众号信息未授权'})
sql = 'SELECT * FROM gzh_user WHERE unionid = %s AND state = 1'
gzh_info = mysql.getOne(sql, param=[unionid])
if not gzh_info:
mysql.dispose()
return JsonResponse({'ret': -1, 'msg': '未关注公众号'})
mysql.dispose()
return JsonResponse({
'ret': 0,
'msg': '分享成功',
'result': share_info
})
if handle_type == 'help':
mysql = Mysql()
share_id = request.POST.get('share_id')
print(share_id)
unionid = request.POST.get('unionid')
sql = 'SELECT * FROM h5_user WHERE unionid = %s'
user_info = mysql.getOne(sql, param=[unionid])
if not share_id and not unionid:
return JsonResponse({'ret': -2, 'msg': '参错错误'})
if not user_info:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '助力者公众号信息未授权'})
sql = 'SELECT * FROM gzh_user WHERE unionid = %s AND state = 1'
gzh_info = mysql.getOne(sql, param=[unionid])
if not gzh_info:
mysql.dispose()
return JsonResponse({'ret': -1, 'msg': '未关注公众号'})
sql = 'SELECT * FROM h5_user WHERE id = %s FOR UPDATE'
share_info = mysql.getOne(sql, param=[share_id])
sql = 'SELECT * FROM h5_help_log WHERE leader_unionid = %s AND help_unionid = %s'
check = mysql.getOne(
sql, param=[share_info.get('unionid'), unionid])
if check or share_info.get('unionid') == unionid:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '已经助力, 请勿重复'})
sql = 'INSERT INTO h5_help_log SET leader_unionid = %s, help_unionid = %s'
mysql.insertOne(sql,
param=[share_info.get('unionid'), unionid])
sql = 'UPDATE h5_user SET lucky_draw_times = lucky_draw_times + 1, \
help_times = help_times + 1 WHERE id = %s'
mysql.update(sql, param=[share_id])
sql = 'UPDATE h5_user SET lucky_draw_times = lucky_draw_times + 1 \
WHERE unionid = %s'
mysql.update(sql, param=[unionid])
mysql.dispose()
return JsonResponse({'ret': 0, 'msg': '助力成功'})
return JsonResponse({'ret': -2, 'msg': '参数错误'})
except Exception as e:
erroLog(e)
return JsonResponse({'ret': -2, 'msg': '网络错误'})
def post(self, request, **payload):
try:
user_id = payload.get('user_id')
handle_type = request.POST.get('handle_type')
mysql = Mysql()
if handle_type == 'mobile':
sql = "SELECT mobile FROM userInfo WHERE id = %s"
check = mysql.getOne(sql, param=[user_id])
mysql.dispose()
if not check:
return JsonResponse({'ret': -2, 'msg': '请绑定手机号'})
state = starSignLog(user_id, 4)
if state:
return JsonResponse({'ret': -2, 'msg': '已经领取'})
path_type = randomPath()
path_type = [path_type]
suc = getPatch(user_id, path_type, 4, 1)
return JsonResponse(suc)
if handle_type == 'school':
sql = "SELECT school_id FROM userInfo WHERE id = %s"
check = mysql.getOne(sql, param=[user_id])
mysql.dispose()
if not check:
return JsonResponse({'ret': -2, 'msg': '请绑定校徽'})
state = starSignLog(user_id, 5)
if state:
return JsonResponse({'ret': -2, 'msg': '已经领取'})
path_type = randomPath()
path_type = [path_type]
suc = getPatch(user_id, path_type, 5, 1)
return JsonResponse(suc)
if handle_type == 'step':
sql = "SELECT * FROM coin_log WHERE userid = %s AND handleType = 3 \
AND handletime BETWEEN %s AND %s"
check = mysql.getOne(sql,
param=[user_id, START_TIME, END_TIME])
mysql.dispose()
if not check:
return JsonResponse({'ret': -2, 'msg': '未进行过微信步数'})
state = starSignLog(user_id, 6)
if state:
return JsonResponse({'ret': -2, 'msg': '已经领取'})
path_type = randomPath()
path_type = [path_type]
suc = getPatch(user_id, path_type, 6, 1)
return JsonResponse(suc)
if handle_type == 'answer':
sql = "SELECT * FROM quiz_log WHERE user_id = %s \
AND create_time BETWEEN %s AND %s"
check = mysql.getOne(sql,
param=[user_id, START_TIME, END_TIME])
mysql.dispose()
if not check:
return JsonResponse({'ret': -2, 'msg': '未进行过每日一答'})
state = starSignLog(user_id, 7)
if state:
return JsonResponse({'ret': -2, 'msg': '已经领取'})
path_type = randomPath()
path_type = [path_type]
suc = getPatch(user_id, path_type, 7, 1)
return JsonResponse(suc)
if handle_type == 'click_card':
sql = "SELECT * FROM click_card WHERE userid = %s \
AND checkTime BETWEEN %s AND %s"
check = mysql.getOne(sql,
param=[user_id, START_TIME, END_TIME])
mysql.dispose()
if not check:
return JsonResponse({'ret': -2, 'msg': '未进行过打卡'})
state = starSignLog(user_id, 8)
if state:
return JsonResponse({'ret': -2, 'msg': '已经领取'})
path_type = randomPath()
path_type = [path_type]
suc = getPatch(user_id, path_type, 8, 1)
return JsonResponse(suc)
if handle_type == 'see':
'''
0未进行
1已进行未领取
2已领取
'''
sql = 'SELECT mobile, school_id FROM userInfo WHERE id = %s'
user_info = mysql.getOne(sql, param=[user_id])
check_mobile = 1 if user_info.get('mobile') else 0
check_school = 1 if user_info.get('school_id') else 0
sql = 'SELECT id FROM coin_log WHERE userid = %s AND handleType = 3 \
AND handletime BETWEEN %s AND %s'
check_step = mysql.getOne(
sql, param=[user_id, START_TIME, END_TIME])
check_step = 1 if check_step else 0
sql = 'SELECT id FROM quiz_log WHERE user_id = %s \
AND create_time BETWEEN %s AND %s'
check_answer = mysql.getOne(
sql, param=[user_id, START_TIME, END_TIME])
check_answer = 1 if check_answer else 0
sql = "SELECT id FROM click_card WHERE userid = %s \
AND checkTime BETWEEN %s AND %s"
check_click_card = mysql.getOne(
sql, param=[user_id, START_TIME, END_TIME])
check_click_card = 1 if check_click_card else 0
sql = "SELECT id FROM star_sign_log WHERE user_id = %s AND handle_type = %s"
log_info = mysql.getOne(sql, param=[user_id, 4])
check_mobile = 2 if log_info else check_mobile
sql = "SELECT id FROM star_sign_log WHERE user_id = %s AND handle_type = %s"
log_info = mysql.getOne(sql, param=[user_id, 5])
check_school = 2 if log_info else check_school
sql = "SELECT id FROM star_sign_log WHERE user_id = %s AND handle_type = %s"
log_info = mysql.getOne(sql, param=[user_id, 6])
check_step = 2 if log_info else check_step
sql = "SELECT id FROM star_sign_log WHERE user_id = %s AND handle_type = %s"
log_info = mysql.getOne(sql, param=[user_id, 7])
check_answer = 2 if log_info else check_answer
sql = "SELECT id FROM star_sign_log WHERE user_id = %s AND handle_type = %s"
log_info = mysql.getOne(sql, param=[user_id, 8])
check_click_card = 2 if log_info else check_click_card
mysql.dispose()
data = {
'ret': 0,
'msg': '查询成功',
'result': {
'mobile': check_mobile,
'school': check_school,
'step': check_step,
'answer': check_answer,
'click_card': check_click_card
}
}
return JsonResponse(data)
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '参数错误'})
except Exception as e:
mysql.errdispose()
erroLog(e)
return JsonResponse({'ret': -2, 'msg': '网络错误'})
def post(self, request, **payload):
try:
user_id = payload.get('user_id')
handle_type = request.POST.get('handle_type')
#查看
if handle_type == 'see':
sql = "SELECT * FROM starry_market"
data = query(sql)
return HttpResponse(callJson(data))
#购买
if handle_type == 'buy':
patch_id = int(request.POST.get('patch_id'))
mysql = Mysql()
sql = "SELECT * FROM starry_market WHERE id = %s FOR UPDATE"
path_info = mysql.getOne(sql, param=[patch_id])
if path_info.get('number') <= 0:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '商品数量不足'})
need_hhcoin = path_info.get('hhcoin')
sql = "SELECT * FROM userInfo WHERE id = %s FOR UPDATE"
user_info = mysql.getOne(sql, param=[user_id])
if user_info.get('hhcoin') < need_hhcoin:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '盒盒币不足'})
up_sql, log_sql = Type_Log.coin_handle(user_id, 15,
need_hhcoin, 0)
mysql.update(up_sql)
mysql.insertOne(log_sql)
up_sql, log_sql = starryMarketLog(user_id, patch_id,
NUMBER_DICT[patch_id],
need_hhcoin, 0, 1, mysql)
mysql.update(up_sql)
mysql.insertOne(log_sql)
mysql.dispose()
getPatch(user_id, [patch_id], 10, 1)
return JsonResponse({'ret': 0, 'msg': '购买成功'})
#出售
if handle_type == 'sell':
patch_id = int(request.POST.get('patch_id'))
numbes = int(request.POST.get('numbes'))
print('patchid')
print(patch_id)
print('出售数量')
print(numbes)
if numbes <= 0:
return JsonResponse({'ret': -2, 'msg': '网络繁忙'})
mysql = Mysql()
sql = "SELECT * FROM starry_market WHERE id = %s FOR UPDATE"
path_info = mysql.getOne(sql, param=[patch_id])
sql = f"SELECT * FROM user_star_sign WHERE {NUMBER_DICT[patch_id]} >= {numbes} AND user_id = {user_id}"
user_path = mysql.getOne(sql)
if not user_path:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '用户碎片不足'})
sql = "SELECT * FROM userInfo WHERE id = %s FOR UPDATE"
user_info = mysql.getOne(sql, param=[user_id])
up_sql, log_sql = Type_Log.coin_handle(
user_id, 15, PATCH_SELL_MONEY[patch_id], 1)
mysql.update(up_sql)
mysql.insertOne(log_sql)
up_sql, log_sql = starryMarketLog(user_id, patch_id,
NUMBER_DICT[patch_id],
PATCH_SELL_MONEY[patch_id],
1, numbes, mysql)
mysql.update(up_sql)
mysql.insertOne(log_sql)
mysql.dispose()
getPatch(user_id, [patch_id], 10, 0)
return JsonResponse({'ret': 0, 'msg': '出售成功'})
#查看日志
if handle_type == 'log':
sql = "SELECT * FROM starry_market_log WHERE user_id = %s"
data = query(sql, param=[user_id])
return HttpResponse(callJson(data))
except Exception as e:
erroLog(e)
return JsonResponse({'ret': -2, 'msg': '网络错误'})
def post(self, request, **payload):
try:
user_id = request.session.get('user_id')
handle_type = request.POST.get('handle_type')
if handle_type == 'one':
mysql = Mysql()
sql = "SELECT * FROM userInfo WHERE id = %s FOR UPDATE"
user_info = mysql.getOne(sql, param=[user_id])
if user_info.get('hhcoin') < 50:
return JsonResponse({'ret': -2, 'msg': '盒盒币不足'})
up_sql, log_sql = Type_Log.coin_handle(user_id, 14, 50, 0)
mysql.update(up_sql)
mysql.insertOne(log_sql)
#抽碎片
path_type = randomWxPatch()
if isinstance(path_type, dict):
self.addHhcoin(user_id, [path_type.get('hhcoin')], mysql)
mysql.dispose()
return JsonResponse({
'ret': 0,
'msg': f"抽中盒盒币{path_type.get('hhcoin')}个",
'result': {
'patch': [],
'hhcoin': [path_type.get('hhcoin')]
}
})
getPatch(user_id, [path_type], 9, 1, mysql)
mysql.dispose()
data = {
'ret': 0,
'msg': f'抽奖成功, 获得了{STAR_SIGIN[path_type]}',
'result': {
'patch': [path_type],
'hhcoin': []
}
}
return JsonResponse(data)
if handle_type == 'ten':
mysql = Mysql()
sql = "SELECT * FROM userInfo WHERE id = %s FOR UPDATE"
user_info = mysql.getOne(sql, param=[user_id])
if user_info.get('hhcoin') < 450:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '盒盒币不足'})
up_sql, log_sql = Type_Log.coin_handle(user_id, 14, 450, 0)
mysql.update(up_sql)
mysql.insertOne(log_sql)
#抽碎片
result = list(map(randomWxPatch, [i for i in range(10)]))
patch_list = list(filter(lambda x: isinstance(x, int), result))
hhcoin_list = [
x.get('hhcoin') for x in result if x not in patch_list
]
self.addHhcoin(user_id, hhcoin_list, mysql)
getPatch(user_id, patch_list, 9, 1, mysql)
mysql.dispose()
data = {
'ret': 0,
'msg': '抽奖成功',
'result': {
'patch': patch_list,
'hhcoin': hhcoin_list
}
}
return JsonResponse(data)
if handle_type == 'log':
mysql = Mysql()
sql = "SELECT star_sign_id, create_time FROM star_sign_log \
WHERE user_id = %s AND handle_type = 9"
patch_info = mysql.getAll(sql, param=[user_id])
sql = "SELECT num, handletime FROM coin_log WHERE userid = %s \
AND handleType = 14 AND consumeType = 1"
hhcoin_info = mysql.getAll(sql, param=[user_id])
mysql.dispose()
data = {
'ret': 0,
'msg': '查询成功',
'result': {
'patch_info': patch_info,
'hhcoin_info': hhcoin_info
}
}
return HttpResponse(callJson(data))
else:
return JsonResponse({'ret': -2, 'msg': '参数错误'})
except Exception as e:
mysql.errdispose()
erroLog(e)
return JsonResponse({'ret': -2, 'msg': '网络错误'})