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 post(self, request):
store_id = request.POST.get('store_id')
name = request.POST.get('name')
phone = request.POST.get('phone')
address = request.POST.get('address')
store_name = request.POST.get('store_name')
password = request.POST.get('password')
mysql = Mysql()
sql = f"UPDATE store SET `name` = '{name}', phone = '{phone}', \
store_name = '{store_name}', `password` = '{password}', address =' {address}' WHERE id = '{store_id}'"
suc = mysql.update(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
school_img = request.POST.get('school_img')
english_name = request.POST.get('english_name')
school_name = request.POST.get('school_name')
school_motto = request.POST.get('school_motto')
area_id = request.POST.get('area_id')
mysql = Mysql()
sql = "INSERT INTO school SET school_name='{school_name}', school_img='{school_img}', \
english_name='{english_name}', school_motto='{school_motto}', area_id='{area_id}' \
" .format(school_img=school_img, school_name=school_name, school_motto=school_motto, \
area_id=area_id, english_name=english_name)
suc = mysql.insertOne(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
school_id = request.POST.get('school_id')
mysql = Mysql()
sql = "SELECT * FROM userInfo WHERE school_id = '{school_id}'".format(
school_id=school_id)
info = mysql.getOne(sql)
if info:
mysql.dispose()
return HttpResponse(2) #有学生绑定 要先删学生
sql = "DELETE FROM school WHERE id = '{school_id}'".format(
school_id=school_id)
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
wx_name = request.POST.get('wx_name')
wx_img = request.POST.get('wx_img')
openid = request.POST.get('openid')
mysql = Mysql()
sql = f"SELECT mer_userid FROM mer_admin WHERE openid = '{openid}'"
check_user = mysql.getOne(sql)
if check_user:
sql = f"UPDATE mer_admin SET wx_img='{wx_img}', wx_name='{wx_name}' WHERE openid='{openid}'"
suc = mysql.update(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
mysql.dispose()
return HttpResponse("openid不存在")
def post(self, request):
try:
mysql = Mysql()
sql = "SELECT product_id, new_img FROM stock \
WHERE product_id IS NOT NULL GROUP BY product_id "
store_info = mysql.getAll(sql)
for i in store_info:
sql = "UPDATE product SET productImg=%s WHERE id=%s"
mysql.update(sql,
param=[i.get('new_img'),
i.get('product_id')])
mysql.dispose()
return HttpResponse(1)
except Exception as e:
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
area_id = request.POST.get('area_id')
mysql = Mysql()
sql = "SELECT id FROM school WHERE area_id = '{area_id}'".format(
area_id=area_id)
info = mysql.getOne(sql)
if info:
mysql.dispose()
return HttpResponse(2) #有学校绑定 要先删学校
sql = "DELETE FROM school_area WHERE id='{area_id}'".format(
area_id=area_id)
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
name = request.POST.get('name')
phone = request.POST.get('phone')
pwd = request.POST.get('pwd')
mer_id = request.POST.get('mer_id')
mysql = Mysql()
sql = f"SELECT mer_userid FROM mer_admin WHERE phone = '{phone}'"
check_user = mysql.getOne(sql)
if check_user:
return HttpResponse(2) #已被注册
sql = f"INSERT INTO mer_admin SET phone='{phone}', user_name='{name}',\
`password`='{pwd}', is_admin='0', mer_id='{mer_id}'"
suc = mysql.insertOne(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
recurrence_no = request.POST.get('recurrence_no')
recurrence_name = request.POST.get('recurrence_name')
mysql = Mysql()
sql = f"SELECT id FROM recurrence WHERE recurrence_no='{recurrence_no}'"
check = mysql.getOne(sql)
if check:
mysql.dispose()
return HttpResponse(0)
sql = f"INSERT INTO recurrence SET recurrence_no \
= '{recurrence_no}', recurrence_name = '{recurrence_name}'"
suc = mysql.insertOne(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
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):
quiz_name = request.POST.get('quiz_name')
answer_list = json.loads(request.POST.get('answer_list'))
print(type(answer_list))
#[{answer:xxx,is_right:1}]
mysql = Mysql()
try:
sql = f"INSERT INTO daily_quiz SET quiz_name = '{quiz_name}'"
quiz_id = mysql.insertOne(sql)
for i in answer_list:
sql = f'''INSERT INTO quiz_bank SET quiz_id = "{quiz_id}",\
answer = "{i.get('answer')}", is_right = "{i.get('is_right')}"'''
mysql.insertOne(sql)
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
self.params = {}
self.params['mer_userid'] = request.POST.get('mer_userid')
self.params['user_name'] = request.POST.get('user_name')
self.params['phone'] = request.POST.get('phone')
self.params['password'] = request.POST.get('password') #可以随机生成密码
mysql = Mysql()
sql = "UPDATE mer_admin SET user_name='{user_name}', phone = {phone}, \
`password`='{password}' WHERE mer_userid='{mer_userid}'" .format(\
password=self.params['password'], phone =self.params['phone'], \
mer_userid=self.params['mer_userid'],user_name=self.params['user_name'])
print(sql)
try:
mysql.update(sql)
mysql.dispose()
return HttpResponse(1)
except Exception as e:
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
try:
product_id = request.POST.get('product_id')
mysql = Mysql()
sql = "SELECT * FROM stock WHERE product_id = %s AND state = 1"
stock_info = mysql.getAll(sql, param=[product_id])
if not stock_info:
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': '没有库存不能上架'})
sql = "UPDATE product SET upper_shelf = 1 WHERE id = %s"
mysql.update(sql, param=[product_id])
sql = "UPDATE stock SET upper_shelf = 1 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()
return JsonResponse({'ret': -2, 'msg': '上架出现错误'})
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):
prize_id = request.POST.get('prize_id')
prize_type = request.POST.get('prize_type') #1.商品 2.实物 3.二维码 4.cdk 5.盒盒币以及余额
prize_detail = request.POST.get('prize_detail')
class_id = request.POST.get('class_id')
all_limit = request.POST.get('all_limit')
one_limit = request.POST.get('one_limit')
mysql = Mysql()
sql = "UPDATE prize SET prize_type='{prize_type}', prize_detail='{prize_detail}', \
class_id='{class_id}', all_limit='{all_limit}', one_limit='{one_limit}' \
WHERE id = '{prize_id}'".format(prize_type=prize_type, prize_detail=prize_detail, \
class_id=class_id, prize_id=prize_id, all_limit=all_limit, one_limit=one_limit)
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')
school_img = request.POST.get('school_img')
english_name = request.POST.get('english_name')
school_name = request.POST.get('school_name')
school_motto = request.POST.get('school_motto')
area_id = request.POST.get('area_id')
mysql = Mysql()
sql = "UPDATE school SET school_name='{school_name}', school_img='{school_img}', \
english_name='{english_name}', school_motto='{school_motto}', area_id='{area_id}' WHERE id='{school_id}' \
" .format(school_img=school_img, school_name=school_name, school_motto=school_motto, \
area_id=area_id, english_name=english_name, school_id=school_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):
prize_type = request.POST.get('prize_type') #1.商品 2.实物 3.二维码 4.cdk 5.盒盒币以及余额
prize_detail = request.POST.get('prize_detail')
class_id = request.POST.get('class_id')
all_limit = request.POST.get('all_limit') #全体限量
one_limit = request.POST.get('one_limit') #个人限量
mysql = Mysql()
sql = "INSERT INTO prize SET prize_type='{prize_type}', prize_detail='{prize_detail}',\
class_id='{class_id}', all_limit='{all_limit}', one_limit='{one_limit}'".format(prize_type=prize_type, \
prize_detail=prize_detail, class_id=class_id, all_limit=all_limit, one_limit=one_limit)
suc = mysql.insertOne(sql)
if suc:
data = {}
data['prize_id'] = suc
data['state'] = 1
data = json.dumps(data, ensure_ascii=False, sort_keys=True, indent=4)
mysql.dispose()
return HttpResponse(data)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
self.params = {}
self.params['product_id'] = request.POST.get('product_id')
self.params['product_name'] = request.POST.get('product_name')
self.params['product_img'] = request.POST.get('product_img')
self.params['min_price'] = request.POST.get('min_price')
self.params['max_price'] = request.POST.get('max_price')
self.params['hhcoin'] = request.POST.get('hhcoin')
self.params['product_stock'] = json.loads(
request.POST.get('product_stock'))
#[{'stockname':'xx',hhcoin':1, 'price':22, 'stock_id':222, 'min_buy':1, 'max_buy':2}, {...}]
self.params['delete_stock'] = json.loads(
request.POST.get('delete_stock')) #[1,3,4,5]
print(self.params)
try:
mysql = Mysql()
sql = "UPDATE mer_product SET product_name='{product_name}', \
product_img='{product_img}', min_price='{min_price}', \
max_price='{max_price}', hhcoin='{hhcoin}' \
WHERE product_id='{product_id}'" .format(product_id=self.params['product_id'], \
product_name=self.params['product_name'], product_img=self.params['product_img'],\
min_price=self.params['min_price'], max_price=self.params['max_price'], \
hhcoin=self.params['hhcoin'])
mysql.update(sql)
for i in self.params['product_stock']:
sql = "UPDATE mer_stock SET stock_name='{stock_name}', \
price='{price}', hhcoin='{hhcoin}', min_buy='{min_buy}', max_buy='{max_buy}' \
WHERE stock_id ='{stock_id}'" .format(stock_name=i.get('stockname'), min_buy=i.get('min_buy'),\
price=i.get('price'), hhcoin=i.get('hhcoin'), stock_id=i.get('stock_id'), max_buy=i.get('max_buy'))
print(sql)
mysql.update(sql)
for x in self.params['delete_stock']:
sql = "DELETE FROM mer_stock WHERE stock_id = '{stock_id}'".format(
stock_id=x)
mysql.delete(sql)
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
try:
mysql = Mysql()
self.__reqData['name'] = request.POST.get('name')
self.__reqData['parent_id'] = request.POST.get('bigclass')
self.__reqData['img'] = request.POST.get('img')
self.__reqData['sort'] = request.POST.get('sort')
sql = 'INSERT INTO proclass (`name`,parentId,img,sort) VALUES (%s, %s, %s, %s)'
suc = mysql.insertOne(sql,
param=[
self.__reqData['name'],
self.__reqData['parent_id'],
self.__reqData['img'],
self.__reqData['sort']
])
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
quiz_name = request.POST.get('quiz_name')
answer_list = json.loads(request.POST.get('answer_list'))
quiz_id = request.POST.get('quiz_id')
#[{answer:xxx,is_right:1}]
mysql = Mysql()
try:
sql = f"UPDATE daily_quiz SET quiz_name = '{quiz_name}' WHERE id = '{quiz_id}'"
mysql.update(sql)
sql = f"DELETE FROM quiz_bank WHERE quiz_id = {quiz_id}"
mysql.delete(sql)
for i in answer_list:
sql = f'''INSERT INTO quiz_bank SET quiz_id = {quiz_id}, \
answer="{i.get('answer')}", is_right = "{i.get('is_right')}"'''
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['img_name'] = request.POST.get('img_name')
self.__reqData['text'] = request.POST.get('text')
self.__reqData['img_id'] = request.POST.get('img_id')
self.__reqData['banner_type'] = request.POST.get('banner_type')
self.__reqData['banner_path'] = request.POST.get('banner_path')
mysql = Mysql()
sql = "UPDATE banner SET img = %s, text = %s, banner_type = %s, \
banner_path = %s WHERE id = %s"
mysql.update(sql, param=[
self.__reqData['img_name'],
self.__reqData['text'],
self.__reqData['banner_type'],
self.__reqData['banner_path'],
self.__reqData['img_id']
])
mysql.dispose()
return HttpResponse(1)
except Exception as e:
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
try:
mysql = Mysql()
self.__reqData['name'] = request.POST.get('name')
self.__reqData['id'] = request.POST.get('id')
self.__reqData['img'] = request.POST.get('img', '')
self.__reqData['parentId'] = request.POST.get('parentId')
self.__reqData['sort'] = request.POST.get('sort')
sql = 'update proclass set name=%s,parentId=%s, img=%s, sort=%s \
where id = %s'
mysql.update(sql,
param=[
self.__reqData['name'],
self.__reqData['parentId'], self.__reqData['img'],
self.__reqData['sort'], self.__reqData['id']
])
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
probability_info = request.POST.get('probability_num') #[{id:1,probability_num:10,prize_id:1},{id:2,probability_num:10}]
probability_list = json.loads(probability_info)
mysql = Mysql()
try:
check_num = 0
for i in probability_list:
sql = "UPDATE probability SET probability_num='{probability_num}', \
prize_id='{prize_id}' WHERE id='{pro_id}'".format\
(probability_num=i.get('probability_num'), prize_id=i.get('prize_id'), pro_id=i.get('id'))
check_num += int(i.get('probability_num'))
mysql.update(sql)
print(check_num)
print(type(check_num))
if check_num != 100:
mysql.errdispose()
return HttpResponse(2) #概率和没有达到百分百
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def save_data(self):
try:
mysql = Mysql()
lottery_code = self.ran(6)
sql = "UPDATE oneyuanpurchase SET lottery_code = %s, state = 1, \
is_get=0, wxid = %s, wx_money = %s WHERE order_num = %s"
mysql.update(sql,
param=[
lottery_code, self.Info['wxid'],
self.Info['total_fee'], self.Info['orderNum']
])
sql = "SELECT user_id FROM oneyuanpurchase WHERE order_num = %s"
user = mysql.getOne(sql, param=[self.Info['orderNum']])
up_sql, log_sql = Type_Log.coin_handle(user_id=user.get('user_id'),
handle=12,
num=10,
asd=1)
mysql.update(up_sql)
mysql.insertOne(log_sql)
mysql.dispose()
except Exception as e:
print(e)
mysql.errdispose()
def post(self, request):
self.params = {}
self.params['spec_id'] = request.POST.get('spec_id')
self.params['spd_id'] = request.POST.get('spec_detail_id')
self.params['check_num'] = int(
request.POST.get('check_num')) #第一次点击传 1第二次确认删除传2
mysql = Mysql()
try:
if self.params['check_num'] == 1:
sql = "SELECT * FROM mer_stock WHERE FIND_IN_SET \
('{spd_id}', mer_stock.stock_specs)".format(
spd_id=self.params['spd_id'])
stock_info = mysql.getAll(sql)
if stock_info:
mysql.dispose()
stock_info = json.dumps(stock_info,
ensure_ascii=False,
sort_keys=True,
indent=4)
return HttpResponse(stock_info)
else:
mysql.errdispose()
return HttpResponse('规格详情id错误')
if self.params['check_num'] == 2:
self.params['stock_list'] = json.loads(
request.POST.get('stock_list')) #stockid check_num=2传过来
sql = "DELETE FROM mer_specdetail WHERE spec_detail_id='{spd_id}'".format(
spd_id=self.params['spd_id'])
mysql.delete(sql)
sql = "SELECT * FROM mer_specdetail WHERE spec_id = '{spec_id}'".format(
spec_id=self.params['spec_id'])
check_spec = mysql.getOne(sql)
for i in self.params['stock_list']:
sql = "DELETE FROM mer_stock WHERE stock_id = '{stock_id}'".format(
stock_id=i)
mysql.delete(sql)
if check_spec:
pass
else:
#sql = "DELETE FROM mer_spec WHERE spec_id = '{spec_id}'".format(spec_id=self.params['spec_id'])
mysql.errdispose(sql)
return HttpResponse(2)
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def turntable_prize(self, user_id):
turntable_id = self.turntable()
mysql = Mysql()
sql = "SELECT prize.id, prize_type, prize_detail FROM probability as p \
LEFT JOIN prize ON p.prize_id = prize.id WHERE p.id = {turntable}".format(
turntable=turntable_id)
info = mysql.getOne(sql)
data = {}
data['turntable_id'] = turntable_id
data['prize_id'] = info.get('id')
data['prize_type'] = info.get('prize_type')
data['prize_detail'] = info.get('prize_detail')
#查询限量总数
sql = "SELECT all_limit, one_limit FROM prize WHERE id = '{prize_id}'".format(
prize_id=data['prize_id'])
#奖品限量字典
limit_num = mysql.getOne(sql)
all_limit_num = int(limit_num.get('all_limit'))
one_limit_num = int(limit_num.get('one_limit'))
sql = "SELECT COUNT(id) as count FROM reward_log WHERE prize_id = '{prize_id}'".format(
prize_id=data['prize_id'])
#全部已抽中奖品总数
all_num = mysql.getOne(sql)
sql = "SELECT COUNT(id) as count FROM reward_log WHERE prize_id = '{prize_id}' \
AND user_id = '{user_id}'".format(prize_id=data['prize_id'],
user_id=user_id)
#个人抽中奖品总数
one_num = mysql.getOne(sql)
if all_num:
all_num = all_num.get('count')
if all_num >= all_limit_num and all_limit_num != 0:
print('总数被抽完')
#商品已被抽完
#mysql.dispose()
#return 2
data['prize_type'] == 8
else:
pass
if one_num:
one_num = one_num.get('count')
if one_num >= one_limit_num and one_limit_num != 0:
#个人中奖次数已达上限
print('个人次数抽完')
#mysql.dispose()
#return 3
data['prize_type'] == 8
else:
pass
#还有剩余总数 继续抽奖
try:
#自营类商品
if int(data['prize_type']) == 1:
print('自营商品')
#查询商品相关信息
sql = "SELECT prize_stock.stock_numb, stock.id, stock.stock_name \
FROM prize_stock LEFT JOIN stock ON prize_stock.stock_id = stock.id \
WHERE prize_stock.prize_id={prize_id}".format(
prize_id=data['prize_id'])
stock_info = mysql.getOne(sql)
data['stock_numb'] = int(stock_info.get('stock_numb'))
data['stock_id'] = stock_info.get('id')
data['stock_name'] = stock_info.get(
'stock_name') + data['prize_detail'] + str(
data['stock_numb']) + '份'
#查询以中总量
# sql = "SELECT COUNT(id) as count FROM reward_log WHERE prize_id = '{prize_id}'".format(prize_id=data['prize_id'])
# real_numb = mysql.getOne(sql)
# real_numb = int(real_numb.get('count'))
# #如果超过限量返回谢谢惠顾
# if real_numb >= data['stock_numb']:
# data['prize_type'] = 8
# int(data['prize_type']) == 8
# #没超过 让他中奖
# else:
re_log = Type_Log.reward_log(user_id=user_id,
prize_id=data['prize_id'],
detail=data['stock_name'],
prize_type=1,
get=0)
re_id = mysql.insertOne(re_log)
data['re_id'] = re_id
mysql.dispose()
return data
#外部类商品
if int(data['prize_type']) == 2:
print('外部商品')
re_log = Type_Log.reward_log(user_id=user_id,
prize_id=data['prize_id'],
detail=data['prize_detail'],
prize_type=2,
get=0)
re_id = mysql.insertOne(re_log)
data['re_id'] = re_id
mysql.dispose()
return data
#卷码类型
if int(data['prize_type']) == 3:
sql = "SELECT * FROM prize_coupon WHERE prize_id = '{prize_id}' \
AND `get` = '0' ORDER BY id".format(
prize_id=info.get('id'))
coupon = mysql.getOne(sql)
print('卷码')
if coupon:
print('还有卷码')
coupon_detail = coupon.get('coupon')
sql = "UPDATE prize_coupon SET `get` = 1 WHERE id = '{coupon_id}'".format(
coupon_id=coupon.get('id'))
mysql.update(sql)
detail = data['prize_detail'] + "：" + coupon_detail
data['prize_detail'] = detail
re_log = Type_Log.reward_log(user_id=user_id,
prize_id=data['prize_id'],
detail=detail,
prize_type=3,
get=1)
mysql.insertOne(re_log)
mysql.dispose()
return data
else:
print('卷码不够')
# sql = "SELECT probability.id, probability.prize_id FROM probability LEFT JOIN prize \
# ON prize.id = probability.prize_id WHERE prize.prize_type =8"
# probability_info = mysql.getOne(sql)
# data['turntable_id'] = probability_info.get('id')
# data['prize_id'] = probability_info.get('prize_id')
# data['prize_type'] = 9
# data['prize_detail'] = '谢谢惠顾'
# data['warning_info'] = '其实我是优惠卷 但是我没有了'
data['prize_type'] = 8
print(data['prize_type'])
#二维码类型
if int(data['prize_type']) == 4:
print('测试二维码')
re_log = Type_Log.reward_log(user_id=user_id,
prize_id=data['prize_id'],
detail=data['prize_detail'],
prize_type=4,
get=1)
mysql.insertOne(re_log)
mysql.dispose()
new_data = data
return new_data
#盒盒币
if int(data['prize_type']) == 5:
print('盒盒币')
sql = "SELECT num FROM prize_phv WHERE prize_id = {prize_id}".format(
prize_id=data['prize_id'])
num = mysql.getOne(sql)
num = int(num.get('num'))
up_sql, log_sql = Type_Log.coin_handle(user_id=user_id,
handle=6,
num=num,
asd=1)
mysql.update(up_sql)
mysql.insertOne(log_sql)
re_log = Type_Log.reward_log(user_id=user_id,
prize_id=data['prize_id'],
detail=data['prize_detail'],
prize_type=5,
get=1)
mysql.insertOne(re_log)
mysql.dispose()
return data
#账号vip
if int(data['prize_type']) == 6:
print('账号vip')
sql = "SELECT num FROM prize_phv WHERE prize_id = {prize_id}".format(
prize_id=info.get('id'))
vip_time = mysql.getOne(sql)
vip_time = int(vip_time.get('num'))
sql = "UPDATE userInfo SET vipEndTime = DATE_ADD(vipEndTime,INTERVAL {vip_time} MONTH) \
WHERE id = '{user_id}'".format(vip_time=vip_time,
user_id=user_id)
mysql.update(sql)
re_log = Type_Log.reward_log(user_id=user_id,
prize_id=data['prize_id'],
detail=data['prize_detail'],
prize_type=6,
get=1)
mysql.insertOne(re_log)
mysql.dispose()
return data
#余额
if int(data['prize_type']) == 7:
print('余额')
sql = "SELECT num FROM prize_phv WHERE prize_id = {prize_id}".format(
prize_id=info.get('id'))
money = mysql.getOne(sql)
money = float(money.get('num'))
up_sql, log_sql = Type_Log.balance_log(user_id=user_id,
handle=2,
money=money,
asd=1)
mysql.update(up_sql)
mysql.insertOne(log_sql)
re_log = Type_Log.reward_log(user_id=user_id,
prize_id=data['prize_id'],
detail=data['prize_detail'],
prize_type=7,
get=1)
mysql.insertOne(re_log)
mysql.dispose()
return data
#谢谢惠顾
if int(data['prize_type']) == 8:
print('谢谢惠顾')
data['turntable_id'] = 8
data['prize_id'] = 66
data['prize_type'] = 8
data['prize_detail'] = '谢谢惠顾'
re_log = Type_Log.reward_log(user_id=user_id,
prize_id=data['prize_id'],
detail=data['prize_detail'],
prize_type=8,
get=1)
mysql.insertOne(re_log)
mysql.dispose()
return data
#商品没了 继续抽 抽中为止(有风险已弃用)
if int(data['prize_type']) == 9:
print('商品没了 继续抽 抽中为止')
return self.turntable_prize(user_id=user_id)
except Exception as e:
print(e)
mysql.errdispose()
return False
def post(self, request, **payload):
try:
self.info['user_id'] = payload.get('user_id')
self.info['openid'] = payload.get('openid') # 用户openid
self.info['spbill_create_ip'] = '132.232.119.99' # 终端IP 1
self.info['amount'] = int(request.POST.get('amount')) #金额单位分
self.info['mch_appid'] = 'wx940c713eac9f7aca' # 商户账号appid
self.info['mchid'] = '1531704091' # 商户号
self.info['desc'] = '用户提现' #企业付款备注
self.info['check_name'] = "NO_CHECK" #校验用户姓名选项 NO_CHECK：不校验真实姓名 FORCE_CHECK：强校验真实姓名
self.info['partner_trade_no'] = getOrderNum('ToWx') #商户订单号
self.info['nonce_str'] = getNonceStr() #随机字符串
self.sigin = getSign(ks=self.info)
if self.info['amount'] < 2000:
return JsonResponse({
'ret' : -2,
'msg' : "提现金额过低 要求大于20"
})
mysql = Mysql()
userinfo = self.check_userinfo(mysql=mysql)
if userinfo.get('money') < 20:
mysql.dispose()
return JsonResponse({
'ret' : -2,
'msg' : "余额不足, 小于20"
})
check = self.check_cashout(mysql=mysql)
if check:
mysql.errdispose()
return JsonResponse({
'ret' : -2,
'msg' : "当日提现次数已经到达上限"
})
up_sql, log_sql = Type_Log.balance_log(user_id=self.info['user_id'],
money=self.info['amount']*0.01,
handle=5,
asd=0)
mysql.update(up_sql)
mysql.insertOne(log_sql)
sql = "INSERT INTO balance_towx SET order_num=%s, user_id=%s, \
balance=%s, wx_money=%s, state=2"
cash_id = mysql.insertOne(sql, param=[
self.info['partner_trade_no'],
self.info['user_id'],
self.info['amount']*0.01,
self.info['amount']
])
mysql.dispose()
response = self.request_wx()
mysql = Mysql()
state = self.retmsg(response, mysql=mysql, cash_id=cash_id)
mysql.dispose()
msg = '提现成功' if state else '提现失败'
ret = 0 if msg == '提现成功' else -2
return JsonResponse({
'ret' : ret,
'msg' : msg
})
except Exception as e:
print(e)
mysql.errdispose()
return JsonResponse({
'ret' : -2,
'msg' : "提现出现问题"
})
def get(self, request):
try:
mysql = Mysql()
sql = "SELECT COUNT(*) AS bl FROM bargain_log"
bl = mysql.getOne(sql)
sql = "SELECT COUNT(*) AS goumai FROM bargain_user WHERE state = 0"
goumai = mysql.getOne(sql)
sql = "SELECT COUNT(*) AS bu FROM bargain_user "
bu = mysql.getOne(sql)
sql = "SELECT COUNT(*) AS oneyuan FROM oneyuanpurchase"
oneyuan = mysql.getOne(sql)
data = {}
for i in range(1, 6):
sql = f"SELECT \
t.id, \
group_concat(DISTINCT(de.mchid)) '常用投递机器', \
t.sOpenid '微信openid', \
t.sNickName '微信昵称', \
t.dtLottTime, \
iCount '集赞人数', \
iSource '领奖码' \
FROM \
( \
SELECT \
j.id, \
j.sOpenid, \
j.dtLottTime, \
url_decode (j.sNickName) sNickName, \
count(d.sOpenid) iCount, \
CASE j.iSource \
WHEN 1 THEN \
concat('00', j.iSource, '-松江') \
WHEN 2 THEN \
concat('00', j.iSource, '-闵行') \
WHEN 3 THEN \
concat('00', j.iSource, '-奉贤') \
WHEN 4 THEN \
concat('00', j.iSource, '-临港') \
WHEN 5 THEN \
concat('00', j.iSource, '-虹口') \
ELSE \
j.iSource \
END iSource \
FROM \
tbActDianzan d \
LEFT JOIN tbActJizan j ON j.sOpenid = d.sJizanOpenid \
WHERE j.iSource = {i} \
GROUP BY \
d.sJizanOpenid \
) t \
LEFT JOIN deliver de ON t.sOpenid = de.openid \
WHERE \
t.iCount >= 30 \
GROUP BY \
t.sOpenid \
ORDER BY \
t.iCount DESC "
info = mysql.getAll(sql)
if i == 1:
data['松江'] = len(info)
if i == 2:
data['闵行'] = len(info)
if i == 3:
data['奉贤'] = len(info)
if i == 4:
data['临港'] = len(info)
if i == 5:
data['虹口'] = len(info)
print(data)
mysql.dispose()
return HttpResponse(f"一元购{oneyuan.get('oneyuan')}人购买, \
\r发起了{bu.get('bu')}条砍价, \
\r{bl.get('bl')}条砍价记录, \
\r实际完成砍价支付 {goumai.get('goumai')} 人 \
\r松江集赞满30的人数 {data.get('松江')}, \
\r闵行集赞满30的人数 {data.get('闵行')}, \
\r奉贤集赞满30的人数 {data.get('奉贤')}, \
\r临港集赞满30的人数 {data.get('临港')}, \
\r虹口集赞满30的人数 {data.get('虹口')} ")
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
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': '网络错误'})
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': '网络错误'})
