def post(self, request):
try:
return JsonResponse({'ret': -2, 'msg': '下单失败'})
self.info['user_id'] = request.POST.get('user_id')
self.info['user_name'] = request.POST.get('user_name')
self.info['address'] = request.POST.get('address')
self.info['mobile'] = request.POST.get('mobile', False)
self.info['order_num'] = Basedmethod.OrderNum()
if not self.info['mobile']:
return JsonResponse({'ret': -2, 'msg': '没有手机号码'})
mysql = Mysql()
sql = "INSERT INTO oneyuanpurchase SET order_num = %s, user_name = %s,\
user_id = %s, address = %s, mobile = %s, state = 0, is_get=0"
mysql.insertOne(sql,
param=[
self.info['order_num'], self.info['user_name'],
self.info['user_id'], self.info['address'],
self.info['mobile']
])
mysql.dispose()
return JsonResponse({
'ret': 0,
'msg': '下单成功 请付款',
'wx_money': 100,
'order_num': self.info['order_num']
})
except Exception as e:
print(e)
mysql.errdispose()
return JsonResponse({'ret': -2, 'msg': '下单失败'})
def add(self):
if int(self.info['num']) <= 0:
return HttpResponse(returnJson(-2, '数量出现错误'))
mysql = Mysql()
sql = "SELECT id, num FROM cart WHERE userid=%s AND stock_id=%s AND store_id = %s"
data = mysql.getOne(sql,
param=[
self.info['user_id'], self.info['stock_id'],
self.info['store_id']
])
#新增数量判断
sql = "SELECT \
h.iNumUsed + h.iNumFreeze AS limits, \
p.id AS pid, \
s.id AS sid, \
p.user_goods_limit, \
h.iNumTotal \
FROM \
stock AS s \
LEFT JOIN product AS p ON s.product_id = p.id \
LEFT JOIN tbHold AS h ON h.sHoldKey = CONCAT('product_1909_', p.id) AND h.iUserId=%s \
WHERE s.id = %s"
product_id = mysql.getOne(
sql, param=[self.info['user_id'], self.info['stock_id']])
if not product_id:
return HttpResponse(returnJson(-2, "库存编号错误"))
if product_id.get('limits'):
limits = int(product_id.get('limits')) + self.info['num'] \
if product_id.get('iNumTotal') else self.info['num']
limits += int(info.get('num')) if data else 0
if limits > int(product_id.get('user_goods_limit')):
return HttpResponse(returnJson(-2, '超出限量限制'))
#加入购物车
if data:
sql = "UPDATE cart SET num = num + %s WHERE userid=%s \
AND stock_id=%s AND store_id = %s"
mysql.update(sql,
param=[
self.info['num'], self.info['user_id'],
self.info['stock_id'], self.info['store_id']
])
else:
sql = "INSERT INTO cart SET userid = %s, stock_id = %s, \
num = %s, store_id = %s"
mysql.insertOne(sql,
param=[
self.info['user_id'], self.info['stock_id'],
self.info['num'], self.info['store_id']
])
mysql.dispose()
return HttpResponse(returnJson(0, "加入购物车成功"))
def get_userinfo(self, access_token, openid):
mysql = Mysql()
sql = "SELECT * FROM h5_user WHERE openid = %s"
check = mysql.getOne(sql, param=[openid])
if check:
mysql.dispose()
return check
url = f'https://api.weixin.qq.com/sns/userinfo?access_token={access_token}&openid={openid}&lang=zh_CN'
response = requests.get(url)
response.encoding = 'utf-8'
response.text
user_info = response.json()
sql = 'INSERT INTO h5_user SET unionid=%s, openid=%s, \
city=%s, country=%s, headimgurl=%s, lucky_draw_times=1'
mysql.insertOne(sql,
param=[
user_info.get('unionid'),
user_info.get('openid'),
user_info.get('city'),
user_info.get('country'),
user_info.get('headimgurl')
])
mysql.dispose()
return user_info
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 post(self, request, **payload):
handle = payload.get('handle')
self.info['user_id'] = payload.get('user_id')
self.info['img'] = request.POST.get('img')
self.info['wxname'] = request.POST.get('wxname')
self.info['unionid'] = request.POST.get('unionid')
if handle == 'sel':
return self.getData()
if handle == 'update':
erro_list = ['[object Object]']
if self.info['unionid'] in erro_list or not self.info['unionid']:
return HttpResponse(returnJson(-2, '参数错误'))
return self.update()
if handle == 'debug':
err_info = request.POST.get('err_info')
sql = 'INSERT INTO erro_log SET erro_detail = %s'
mysql = Mysql()
mysql.insertOne(sql, param=[err_info])
mysql.dispose()
return HttpResponse(returnJson(0, '记录成功'))
return HttpResponse(returnJson(-2, '非法路径'))
def save_data(self):
try:
mysql = Mysql()
for i in range(3):
lottery_code = self.ran(6)
sql = "SELECT * from oneyuanpurchase WHERE order_num = %s AND lottery_code IS NULL limit 1"
order_id = mysql.getOne(sql, param=[self.Info['orderNum']])
sql = "UPDATE oneyuanpurchase SET lottery_code = %s, state = 1, \
is_get=0, wxid = %s, wx_money = %s WHERE id = %s"
mysql.update(sql,
param=[
lottery_code, self.Info['wxid'],
self.Info['total_fee'],
order_id.get('id')
])
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 erroLog(msg):
if msg:
mysql = Mysql()
sql = "INSERT INTO erro_log SET erro_detail = %s, create_time = NOW()"
mysql.insertOne(sql, param=[str(repr(msg))])
mysql.dispose()
return 1
else:
return 0
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 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 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, **payload):
user_id = payload.get('user_id')
hot_numbs = int(request.POST.get('hot_numbs'))
mer_id = request.POST.get('mer_id')
if hot_numbs > 5 or hot_numbs < 1:
return HttpResponse(0)
mysql = Mysql()
sql = "SELECT id FROM mer_hots WHERE mer_id = %s AND user_id = %s"
check = mysql.getOne(sql, param=[mer_id, user_id])
if check:
mysql.dispose()
return HttpResponse(2)
sql = "INSERT INTO mer_hots SET mer_id = %s, user_id = %s, hots = %s"
ins_suc = mysql.insertOne(sql, param=[mer_id, user_id, hot_numbs])
sql = "UPDATE merchant SET mer_hot = mer_hot + %s, \
mer_hot_numbs = mer_hot_numbs + 1 WHERE mer_id = %s"
up_suc = mysql.update(sql, param=[hot_numbs, mer_id])
if up_suc and ins_suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
bp_id = request.POST.get('bp_id')
user_id = request.POST.get('user_id')
link = request.POST.get('link')
try:
mysql = Mysql()
sql = "SELECT * FROM bargain_user WHERE user_id = %s \
AND bp_id = %s AND (state = 1 OR state = 2) FOR UPDATE"
check = mysql.getOne(sql, param=[user_id, bp_id])
if check:
msg = '该订单正在砍价中' if int(check.get('state')) == 1 else '有待支付订单'
mysql.dispose()
return JsonResponse({'ret': -2, 'msg': msg})
sql = "SELECT bp.*, s.price FROM bargain_product AS bp \
LEFT JOIN stock AS s ON bp.stock_id = s.id WHERE bp.id = %s"
bp_info = mysql.getOne(sql, param=[bp_id])
sql = "INSERT INTO bargain_user SET user_id = %s, \
bp_id = %s, nowcut_price = 0, present_price = %s, \
bargain_link=%s, state = 1"
bu_id = mysql.insertOne(
sql,
param=[user_id, bp_id,
int(bp_info.get('price') * 100), link])
mysql.dispose()
return JsonResponse({'ret': 0, 'msg': '发起砍价成功', 'bu_id': bu_id})
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
self.params = {}
self.params['mer_address'] = request.POST.get('mer_address')
self.params['mer_name'] = request.POST.get('mer_name')
self.params['mer_slogan'] = request.POST.get('mer_slogan')
self.params['mer_longitude'] = float(
request.POST.get('mer_longitude')) #经度
self.params['mer_latitude'] = float(
request.POST.get('mer_latitude')) #纬度
self.params['mer_img'] = request.POST.get('mer_img') #商户banner
self.params['mer_type'] = int(
request.POST.get('mer_type')) #属性1吃的2喝的3玩的
self.params['mer_logo'] = request.POST.get('mer_logo') #商户头像 mer_logo
self.params['mer_sales'] = float(
request.POST.get('mer_sales')) #折扣 mer_sales
mysql = Mysql()
sql = "INSERT INTO merchant SET mer_address='{mer_address}', mer_name='{mer_name}', \
mer_longitude='{mer_longitude}', mer_latitude='{mer_latitude}',mer_img='{mer_img}', \
mer_type='{mer_type}', mer_slogan='{mer_slogan}', mer_logo='{mer_logo}', \
mer_sales='{mer_sales}'" .format(mer_address=self.params['mer_address'], \
mer_name=self.params['mer_name'], mer_longitude=self.params['mer_longitude'], \
mer_latitude=self.params['mer_latitude'],mer_img=self.params['mer_img'], \
mer_type=self.params['mer_type'], mer_slogan=self.params['mer_slogan'], \
mer_logo=self.params['mer_logo'], mer_sales=self.params['mer_sales'])
print(sql)
suc = mysql.insertOne(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
else:
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
self.params = {}
self.params['phone'] = request.POST.get('phone')
self.params['user_name'] = request.POST.get('user_name')
self.params['password'] = request.POST.get('password') #可以随机生成密码
self.params['mer_id'] = request.POST.get('mer_id') #商户id 必传
mysql = Mysql()
sql = "SELECT is_admin FROM mer_admin WHERE mer_id = '{mer_id}' AND phone ='{phone}' \
AND is_admin = '1'".format(mer_id=self.params['mer_id'],
phone=self.params['phone'])
check = mysql.getOne(sql)
sql = "SELECT is_admin FROM mer_admin WHERE phone ='{phone}'".format(
phone=self.params['phone'])
check_phone = mysql.getOne(sql)
if check or check_phone:
mysql.dispose()
return HttpResponse(2)
sql = "INSERT INTO mer_admin SET phone='{phone}', user_name='{user_name}',\
`password`='{password}', is_admin='1', mer_id='{mer_id}'\
" .format(phone=self.params['phone'],password=self.params['password'], \
mer_id=self.params['mer_id'], user_name=self.params['user_name'])
suc = mysql.insertOne(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def addMerHot(self):
self.params['hot_numbs'] = int(request.POST.get('hot_numbs'))
if self.params['hot_numbs'] > 5 or self.params['hot_numbs'] < 1:
return HttpResponse(returnJson(-2, '增加热度失败'))
mysql = Mysql()
sql = "SELECT id FROM mer_hots WHERE mer_id = %s AND user_id = %s"
check = mysql.getOne(
sql, param=[self.params['mer_id'], self.params['user_id']])
if check:
mysql.dispose()
return HttpResponse(returnJson(-2, '已增加过热度，不能重复'))
sql = "INSERT INTO mer_hots SET mer_id = %s, user_id = %s, hots = %s"
ins_suc = mysql.insertOne(sql,
param=[
self.params['mer_id'],
self.params['user_id'],
self.params['hot_numbs']
])
sql = "UPDATE merchant SET mer_hot = mer_hot + %s, \
mer_hot_numbs = mer_hot_numbs + 1 WHERE mer_id = %s"
up_suc = mysql.update(
sql, param=[self.params['hot_numbs'], self.params['mer_id']])
mysql.dispose()
return HttpResponse(returnJson(0, '增加热度成功'))
def put(self, request):
mysql = Mysql()
coupon = QueryDict(request.body)
for k, v in coupon.items():
coupon_list = json.loads(k)
try:
for i in coupon_list.get('coupon_list'):
sql = "INSERT INTO prize_coupon SET prize_id='{prize_id}', \
coupon='{coupon}'".format(prize_id=coupon_list.get('prize_id'), coupon=i)
mysql.insertOne(sql)
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def isEsxit(self, openid):
'''
判断用户是否存在，不存在则插入
'''
mysql = Mysql()
sql = 'select id, mobile, school_id from userInfo where openid=%s'
data = mysql.getOne(sql, param=[openid])
if data:
print(f"***********用户已经存在了****id{data.get('id')}*********")
mysql.dispose()
data['isnew'] = 0
return data
else:
sql = "INSERT INTO userInfo(openid, createTime, isVip, vipEndTime, hhcoin) VALUE \
(%s, NOW(),1, DATE_ADD(Now(), INTERVAL 7 day ), 100)"
user_id = mysql.insertOne(sql, param=[openid])
if user_id:
mysql.dispose()
data = {}
data['id'] = user_id
data['mobile'] = None
data['school_id'] = None
data['isnew'] = 1
print(f"**************新增用户成功****id{user_id}**********")
return data
else:
mysql.errdispose()
print("**************新增用户失败****************")
return False
def post(self, request, **payload):
handle = payload.get('handle')
self.info['user_id'] = payload.get('user_id')
self.info['school_id'] = request.POST.get('school_id')
self.info['school_name'] = request.POST.get('school_name')
if handle == 'see':
sql = "SELECT * FROM school WHERE school_name LIKE %s"
self.info['school_name'] = '%' + self.info['school_name'] + '%'
info = query(sql, param=[self.info['school_name']])
return HttpResponse(returnJson(0, '查询成功', info))
if handle == 'update':
mysql = Mysql()
sql = "SELECT hhcoin, school_id FROM userInfo WHERE id = %s FOR UPDATE"
info = mysql.getOne(sql, param=[self.info['user_id']])
#已经绑定有 扣除盒盒币
if info.get('school_id'):
if int(info.get('hhcoin')) >= 1000:
up_sql, log_sql = Type_Log.coin_handle(
user_id=self.info['user_id'],
handle=0,
num=1000,
asd=0)
mysql.update(up_sql)
mysql.insertOne(log_sql)
sql = "UPDATE userInfo SET school_id = %s WHERE id = %s"
mysql.update(
sql,
param=[self.info['shcool_id'], self.info['user_id']])
mysql.dispose()
return HttpResponse(returnJson(0, '绑定成功'))
#盒盒币不足 返回2
else:
return HttpResponse(returnJson(-2, '盒盒币不足'))
#首次绑定
else:
sql = "UPDATE userInfo SET school_id = %s WHERE id = %s"
suc = mysql.update(
sql, param=[self.info['school_id'], self.info['user_id']])
mysql.dispose()
return HttpResponse(returnJson(0, '绑定成功'))
return HttpResponse(returnJson(-2, '非法路径'))
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):
class_name = request.POST.get('class_name')
mysql = Mysql()
sql = "INSERT INTO prize_class SET class_name = '{class_name}'".format(class_name=class_name)
suc = mysql.insertOne(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def add_activity_class(self):
mysql = Mysql()
sql = "INSERT INTO activity_class SET acti_classname = '{name}', \
acti_parentId = '{parentId}'".format(
name=self.__reqData['name'], parentId=self.__reqData['parentId'])
suc = mysql.insertOne(sql)
if suc:
return 1
else:
return 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 do(self):
mysql = Mysql()
sql = "select * from click_card where \
to_days(checkTime)=to_days(now()) AND userid=%s"
check = mysql.getOne(sql, param=[self.info['user_id']])
if check:
# 已经打卡
mysql.dispose()
return HttpResponse(returnJson(-2, '重复打卡'))
# 打卡
sql = "INSERT INTO click_card SET userid = %s"
suc = mysql.insertOne(sql, param=[self.info['user_id']])
up_sql, log_sql = Type_Log.coin_handle(user_id=self.info['user_id'],
handle=2,
num=10,
asd=1)
mysql.update(up_sql)
mysql.insertOne(log_sql)
mysql.dispose()
return HttpResponse(returnJson(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 toBalance(self):
mysql = Mysql()
sql = "SELECT * FROM userInfo WHERE id = %s FOR UPDATE"
user_info = mysql.getOne(sql, param=[self.info['user_id']])
user_hhcoin = user_info.get('hhcoin')
if int(self.info['hhcoin']) > user_hhcoin or int(self.info['hhcoin']) <= 0:
mysql.dispose()
return HttpResponse(returnJson(-2, '传入金额出现问题'))
up_sql, log_sql = Type_Log.coin_handle(user_id=self.info['user_id'],
handle=13, num=self.info['hhcoin'], asd=0)
mysql.update(up_sql)
mysql.insertOne(log_sql)
up_sql, log_sql = Type_Log.balance_log(user_id=self.info['user_id'],
handle=13, money=self.info['hhcoin'], asd=1)
mysql.update(up_sql)
mysql.insertOne(log_sql)
mysql.dispose()
return HttpResponse(returnJson(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):
store_id = request.POST.get('store_id')
stock_json = json.loads(request.POST.get('stock_json'))
# [{
# 'stock_name' : stock_name,
# 'price' : price,
# 'buying_price' : buying_price,
# 'hehecoin' : hehecoin,
# 'img' : img,
# 'stock_guige': stock_guige,
# 'product_id' : 22,
# 'store_id' : 33
# }]
print(stock_json)
try:
mysql = Mysql()
# sql = "INSERT INTO stock SET stock_name=%s , price=%s, \
# hehecoin=%s, img=%s, upper_shelf=0, store_id=%s, \
# stock_detail=%s, buying_price=%s, product_id=%s"
# stock_id = mysql.insertOne(sql, param=[
# stock_json.get('stock_name'),
# stock_json.get('price'),
# stock_json.get('hehecoin'),
# stock_json.get('img'),
# stock_json.get('store_id'),
# stock_json.get('stock_guige'),
# stock_json.get('buying_price'),
# stock_json.get('product_id')
# ])
sql = "INSERT INTO stock SET stock_name=%s , price=0, \
hehecoin=0, upper_shelf=0, store_id=%s, \
stock_detail=%s, buying_price=0, product_id=%s"
stock_id = mysql.insertOne(sql,
param=[
stock_json.get('stock_name'),
stock_json.get('store_id'),
stock_json.get('stock_guige'),
stock_json.get('product_id')
])
mysql.dispose()
return JsonResponse({
'ret': 0,
'msg': '新增库存成功',
'stock_id': stock_id
})
except Exception as e:
print('----------插入库存商品出现错误-------------')
mysql.errdispose()
return JsonResponse({'ret': -2, 'msg': '新增库存失败'})
def do(self):
mysql = Mysql()
# 查答案
sql = "SELECT is_right FROM quiz_bank WHERE id = %s AND quiz_id = %s"
check = mysql.getOne(sql, param=[self.info['answer_id'], self.info['quiz_id']])
right = int(check.get('is_right'))
# 插记录
sql = "INSERT INTO quiz_log SET user_id = %s, \
quiz_id = %s, answer_id=%s, is_right = %s"
mysql.insertOne(sql, param=[
self.info['user_id'], self.info['quiz_id'],
self.info['answer_id'], right
])
# 放奖励
if right == 1:
sql = "UPDATE userInfo SET correct = correct + 1 WHERE id = %s"
mysql.update(sql, param=[self.info['user_id']])
up_sql, log_sql = Type_Log.coin_handle(
user_id = self.info['user_id'], handle=7, num=15, asd=1)
mysql.update(up_sql)
mysql.insertOne(log_sql)
mysql.dispose()
return HttpResponse(returnJson(0, '答题成功', {'state' : 1}))
else:
sql = "SELECT id FROM quiz_bank WHERE quiz_id = %s AND is_right = 1"
real_answer = mysql.getOne(sql, param=[self.info['quiz_id']])
sql = "UPDATE userInfo SET correct = 0 WHERE id = %s"
mysql.update(sql, param=[self.info['user_id']])
mysql.dispose()
data = {
'real_answer' : real_answer.get('id'),
'state' : 0
}
return HttpResponse(returnJson(0, '答题成功', data))
def put(self, request):
phv = QueryDict(request.body)
print(phv)
for k, v in phv.items():
info = json.loads(k)
prize_id = info.get('prize_id')
num = float(info.get('num'))
mysql = Mysql()
sql = "INSERT INTO prize_phv SET prize_id='{prize_id}', num='{num}'".format(prize_id=prize_id, num=num)
suc = mysql.insertOne(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
