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 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 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['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 post(self, request):
prize_id = request.POST.get('prize_id')
mysql = Mysql()
sql = "SELECT * FROM probability WHERE prize_id = '{prize_id}'".format(prize_id=prize_id)
info = mysql.getOne(sql)
if info:
mysql.dispose()
return HttpResponse(2) #转盘绑定了商品 不能删除
#检查奖品类型
sql = "SELECT * FROM prize WHERE id = '{prize_id}'".format(prize_id=prize_id)
prize_type = mysql.getOne(sql)
check_list = [5, 6, 7]
#--------盒盒币余额类型
if int(prize_type.get('prize_type')) in check_list:
#已在数据库做对应操作
print('删除phv类型')
#---------卷码类型
if int(prize_type.get('prize_type')) == 3:
#已在数据库做对应操作
print('删除cdk类型')
#删除奖品
sql = "DELETE FROM prize WHERE id='{prize_id}'".format(prize_id=prize_id)
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def get(self, request):
mer_id = request.GET.get('mer_id')
mysql = Mysql()
sql = f"SELECT mer_type FROM merchant WHERE mer_id = {mer_id}"
mer_type = mysql.getOne(sql)
mer_type = int(mer_type.get('mer_type'))
sql = f"SELECT SUM(wx_money+balance) as money, COUNT(*) as numbs FROM mer_orders \
WHERE TO_DAYS(create_time) = TO_DAYS(NOW()) AND mer_id = '{mer_id}' AND state = 1 "
mer_order = mysql.getOne(sql)
money1 = mer_order.get('money') if mer_order.get('money') else 0
numbs1 = mer_order.get('numbs')
sql = f"SELECT SUM(wx_money+balance) as money, COUNT(*) as numbs FROM mer_pay \
WHERE TO_DAYS(create_time) = TO_DAYS(NOW()) AND mer_id = '{mer_id}' AND state = 1"
mer_pay = mysql.getOne(sql)
money2 = mer_pay.get('money') if mer_pay.get('money') else 0
numbs2 = mer_pay.get('numbs')
info = mysql.getOne(sql)
mysql.dispose()
info = {'money': money1 + money2, 'numbs': numbs1 + numbs2}
return HttpResponse(callJson(info))
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:
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 update(self):
mysql = Mysql()
sql = "SELECT * FROM userInfo WHERE id = %s FOR UPDATE"
mysql.getOne(sql, param=[self.info['user_id']])
sql = "update userInfo set wxname=%s, user_img=%s, \
unionId=%s where id = %s"
mysql.update(sql,
param=[
self.info['wxname'], self.info['img'],
self.info['unionid'], self.info['user_id']
])
mysql.dispose()
return HttpResponse(returnJson(0, '更新用户信息成功'))
def post(self, request):
del_id = request.POST.get('id')
if int(del_id) == BOOK_ID:
return HttpResponse(0)
mysql = Mysql()
sql = "SELECT id FROM product WHERE productTypeId = %s"
info_one = mysql.getOne(sql, param=[del_id])
sql = "SELECT id FROM proclass WHERE parentId = %s"
info_two = mysql.getOne(sql, param=[del_id])
if info_one or info_two:
return HttpResponse(2)
else:
sql = "DELETE FROM proclass WHERE id = %s"
suc = mysql.delete(sql, param=[del_id])
return HttpResponse(suc)
def shopOrder(self):
mysql = Mysql()
sql = "SELECT o.product_id, o.stock_name, p.user_goods_limit FROM ordergoods \
AS o LEFT JOIN product AS p ON o.product_id = p.id WHERE o.order_id = %s"
info = mysql.getAll(sql, param=[self.Info['orderNum']])
sql = "SELECT createUser FROM orders WHERE orderNum = %s"
user_id = mysql.getOne(sql, param=[self.Info['orderNum']])
holds = []
for i in info:
if i.get('user_goods_limit') != 0:
key = 'product_1909_' + str(i.get('product_id'))
data = {}
data['key'] = key
data['ext'] = str(i.get('stock_name'))
holds.append(data)
if holds:
check = hold_shikou(holds=holds,
user_id=user_id.get('createUser'),
mysql=mysql)
if check['ret'] == -2:
raise Exception("实扣限量出现问题")
mysql = Mysql()
sql = "update orders set state = '1', wxid=%s where orderNum=%s"
suc = mysql.update(sql,
param=[self.Info['wxid'], self.Info['orderNum']])
mysql.dispose()
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 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 del_activity_class(self):
mysql = Mysql()
sql = "SELECT * FROM activity WHERE acti_class_id = '{id}'".format(
id=self.__reqData['id'])
info = mysql.getAll(sql)
if info:
#有活动
return 2
else:
sql = "SELECT * FROM activity_class WHERE acti_parentId = '{id}'".format(
id=self.__reqData['id'])
suc = mysql.getOne(sql)
if suc:
#分类下有子分类
return 3
else:
sql = "DELETE FROM activity_class WHERE id = '{id}'".format(
id=self.__reqData['id'])
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return 1
else:
mysql.errdispose()
return 0
def get(self, request):
user_id = request.GET.get("user_id")
row = request.GET.get('row')
page = request.GET.get('page')
mysql = Mysql()
page, row = Pagings.mysqlPagings(page=page, row=row)
sql = f"SELECT id, logtime, detail, prize_type, `get` FROM \
reward_log WHERE user_id = {user_id} AND prize_type !=8 \
ORDER BY logtime DESC limit {page}, {row}"
info = mysql.getAll(sql)
sql = f"SELECT COUNT(id) as c FROM reward_log WHERE \
user_id = {user_id} AND prize_type !=8"
sum_page = mysql.getOne(sql)
sum_page = math.ceil(int(sum_page.get('c')) / int(row))
mysql.dispose()
if info:
data = {}
data['sum_page'] = sum_page
data['info'] = info
data = json.dumps(data,
ensure_ascii=False,
sort_keys=True,
indent=4,
cls=ComplexEncode)
return HttpResponse(data)
return HttpResponse(0)
def post(self, request, **payload):
user_id = payload.get('user_id')
handle = payload.get('handle')
address_id = request.POST.get('address_id')
mysql = Mysql()
if handle == 'edit':
sql = "UPDATE userInfo SET address_id=%s WHERE id=%s"
mysql.update(sql, param=[address_id, user_id])
mysql.dispose()
return HttpResponse(returnJson(0, '更新成功'))
if handle == 'get':
mysql = Mysql()
sql = "SELECT address_id from userInfo WHERE id=%s"
info = mysql.getOne(sql, param=[user_id])
mysql.dispose()
info = info if info else []
return HttpResponse(returnJson(0, '查询成功', info))
if handle == 'del':
mysql = Mysql()
sql = "UPDATE userInfo SET address_id = null WHERE id=%s"
mysql.update(sql, param=[user_id])
mysql.dispose()
return HttpResponse(returnJson(0, '删除成功'))
if handle == 'default':
pass
else:
return HttpResponse(returnJson(-2, '参数错误'))
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 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 get(self, request):
title = request.GET.get('title')
news_id = request.GET.get('news_id')
row = request.GET.get('row')
page = request.GET.get('page')
mysql = Mysql()
if news_id:
sql = f"SELECT * FROM information WHERE title LIKE '%{title}%' ORDER BY create_time DESC "
info = mysql.getAll(sql)
mysql.dispose()
if info:
for i in info:
i['details'] = html.unescape(i.get('details'))
sum_page, info = Pagings.paging(info, row=row, page=page)
data = {}
data['sum_page'] = sum_page
data['info'] = info
data = json.dumps(data, ensure_ascii=False, sort_keys=True, indent=4, cls=ComplexEncode)
return HttpResponse(data)
return HttpResponse(0)
else:
print('id形式')
sql = f"SELECT * FROM information WHERE id = '{news_id}'"
info = mysql.getOne(sql)
info['details'] = html.unescape(info.get('details'))
mysql.dispose()
if info:
info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4, cls=ComplexEncode)
return HttpResponse(info)
else:
return HttpResponse(0)
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):
order_num = request.POST.get('order_num')
mer_id = request.POST.get('mer_id')
mysql = Mysql()
sql = f"SELECT `get`, state FROM mer_orders WHERE \
order_num = '{order_num}' AND mer_id = '{mer_id}'"
check_get = mysql.getOne(sql)
data = {}
if check_get:
if int(check_get.get('get')) == 1:
data['msg'] = "FAILE"
data['info'] = "二维码已经被扫描使用"
mysql.dispose()
return HttpResponse(callJson(data))
if int(check_get.get('state')) != 1:
data['msg'] = "FAILE"
data['info'] = "二维码未付款"
mysql.dispose()
return HttpResponse(callJson(data))
if int(check_get.get('get')) == 0:
sql = f'SELECT *, DATE_ADD(pay_time,INTERVAL 3 DAY) as c \
FROM mer_orders WHERE order_num="{order_num}"'
info = mysql.getOne(sql)
ex_time = info.get('c')
now_time = datetime.datetime.now()
if ex_time >= now_time:
print('没过期')
sql = f"UPDATE mer_orders SET `get` = 1 WHERE order_num = '{order_num}'"
suc = mysql.update(sql)
if suc:
data['msg'] = "OK"
data['info'] = "扫码成功"
mysql.dispose()
return HttpResponse(callJson(data))
if ex_time < now_time:
print('过期了')
data['msg'] = "FAILE"
data['info'] = "二维码过期"
return HttpResponse(callJson(data))
mysql.dispose()
data['msg'] = "FAILE"
data['info'] = "订单号错误"
return HttpResponse(callJson(data))
def post(self, request):
user_id = request.POST.get('user_id')
mysql = Mysql()
sql = f"SELECT * FROM userInfo WHERE id = '{user_id}'"
print(sql)
# info = mysql.getAll(sql)
info = mysql.getOne(sql)
mysql.dispose()
return JsonResponse(info)
def get(self, request, **payload):
user = request.GET.get('user')
mysql = Mysql()
sql = f"SELECT power FROM users WHERE mobile = '{user}'"
check = mysql.getOne(sql)
mysql.dispose()
if check:
return JsonResponse(check)
return HttpResponse(0)
def get(self, request, **payload):
user_id = payload.get('user_id')
row = request.GET.get('row')
page = request.GET.get('page')
mysql = Mysql()
page, row = Pagings.mysqlPagings(page=page, row=row)
sql = f"SELECT mp.order_num, mp.order_money, mp.wx_money, mp.balance, \
mp.hhcoin, mp.state, mp.create_time, mr.mer_name FROM mer_pay \
AS mp LEFT JOIN merchant AS mr ON mp.mer_id = mr.mer_id WHERE \
mr.mer_id IS NOT NULL AND mp.user_id = {user_id} limit {page}, {row}"
info = mysql.getAll(sql)
if info:
# 总页数
sql = f"SELECT ceil(COUNT(mp.id) / 5) AS sum_page \
FROM mer_pay AS mp WHERE mp.user_id = {user_id} "
sum_page = mysql.getOne(sql)
# 总金额
sql = f"SELECT sum(wx_money+balance+0.1*hhcoin) AS sum_money \
FROM mer_pay WHERE user_id = {user_id}"
sum_money = mysql.getOne(sql)
# 本月订单数
sql = f"SELECT COUNT(*) AS month_orders FROM mer_pay \
WHERE DATE_FORMAT( create_time, '%Y%m' ) = \
DATE_FORMAT( CURDATE( ) , '%Y%m' ) AND user_id = {user_id}"
month_orders = mysql.getOne(sql)
# 总订单数
sql = f"SELECT COUNT(id) AS sum_order FROM mer_pay WHERE user_id = {user_id}"
sum_order = mysql.getOne(sql)
# 本月金额
sql = f"SELECT SUM(wx_money+balance) AS month_money \
FROM mer_pay WHERE DATE_FORMAT( create_time, '%Y%m' ) \
= DATE_FORMAT( CURDATE( ) , '%Y%m' ) AND user_id = {user_id}"
month_money = mysql.getOne(sql)
data = {}
data['sum_page'] = sum_page.get('sum_page')
data['sum_money'] = sum_money.get('sum_money')
data['month_orders'] = month_orders.get('month_orders')
data['sum_order'] = sum_order.get('sum_order')
data['month_money'] = month_money.get('month_money')
data['info'] = info
mysql.dispose()
return HttpResponse(callJson(data))
mysql.dispose()
return HttpResponse(0)
def starSignLog(user_id, handle_type):
mysql = Mysql()
sql = f"SELECT * FROM star_sign_log WHERE user_id = {user_id} \
AND handle_type = {handle_type}"
data = mysql.getOne(sql)
mysql.dispose()
if data:
return True
return False
def get(self, request):
prize_id = request.GET.get('prize_id')
mysql = Mysql()
sql = "SELECT * FROM prize_phv WHERE 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 post(self, request):
try:
bu_id = request.POST.get('bu_id')
mysql = Mysql()
sql = "SELECT * FROM bargain_user WHERE id = %s AND order_num IS NOT NULL"
bu_info = mysql.getOne(sql, param=[bu_id])
if bu_info:
order_num = bu_info.get('order_num')
sql = "SELECT * FROM orders WHERE orderNum = %s AND state = 0"
order_info = mysql.getOne(sql, param=[order_num])
if order_info:
sql = "DELETE FROM orders WHERE orderNum = %s"
mysql.delete(sql, param=[order_num])
sql = "UPDATE bargain_user SET state = 1, order_num = NULL WHERE id = %s"
mysql.update(sql, param=[bu_id])
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
return HttpResponse(0)
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):
self.params = {}
self.params['product_id'] = request.GET.get('product_id')
mysql = Mysql()
data = {}
sql = "SELECT * FROM mer_product WHERE product_id \
= '{product_id}'".format(product_id=self.params['product_id'])
product_info = mysql.getOne(sql)
data['product_info'] = product_info
#商品所对应的库存商品
sql = "SELECT * FROM mer_stock WHERE product_id = \
'{product_id}'".format(product_id=self.params['product_id'])
stock_check = mysql.getOne(sql)
stock = mysql.getAll(sql)
data['stock'] = stock
if stock_check.get('stock_specs'):
#商品所拥有的规格以及 规格详情
sql = "SELECT * FROM mer_spec WHERE product_id \
= '{product_id}'".format(product_id=self.params['product_id'])
spec_info = mysql.getAll(sql)
list_a = []
for i in spec_info:
spec_dict = {}
sql = "SELECT spec_detail_id, detail_name FROM mer_specdetail WHERE spec_id = \
'{spec_id}'".format(spec_id=i.get('spec_id'))
spec_detail_info = mysql.getAll(sql)
spec_dict['spec_id'] = i.get('spec_id')
spec_dict['spec_name'] = i.get('spec_name')
#spec_dict['spec_detail'] = [x.get('detail_name') for x in spec_detail_info]
spec_dict['spec_detail'] = [x for x in spec_detail_info]
list_a.append(spec_dict)
data['spec'] = list_a
mysql.dispose()
data = json.dumps(data,
ensure_ascii=False,
sort_keys=True,
indent=4,
cls=ComplexEncode)
return HttpResponse(data)
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)
