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 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 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 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 del_(self):
self.info['cart_id'] = json.loads(self.info['cart_id'])
if not isinstance(self.info['cart_id'], list):
return HttpResponse(returnJson(-2, '参数错误'))
mysql = Mysql()
for i in self.info['cart_id']:
sql = "DELETE FROM cart WHERE id = %s"
mysql.delete(sql, param=[i])
mysql.dispose()
return HttpResponse(returnJson(0, '删除成功'))
def merCart(self, state):
cache_name = str(self.params['user_id']) + 'mercart'
if state == 'edit':
open_redis = Open_Redis().getConn(1)
open_redis.set(cache_name, self.params['cart_info'], ex=9000)
return HttpResponse(returnJson(0, '操作成功'))
if state == 'get':
open_redis = Open_Redis().getConn(1)
info = open_redis.get(cache_name)
info = json.loads(info) if info else []
return HttpResponse(returnJson(0, '查询成功', info))
return HttpResponse(returnJson(-2, '非法路径'))
def selProduct(self):
mysql = Mysql()
sql = "SELECT * FROM mer_product WHERE mer_id = %s limit %s, %s"
page, row = Pagings.mysqlPagings(self.params['page'],
self.params['row'])
product = mysql.getAll(sql, param=[self.params['mer_id'], page, row])
for i in product:
sql = "SELECT * FROM mer_stock WHERE product_id = %s"
stock = mysql.getAll(sql, param=[i.get('product_id')])
if stock:
i['stock'] = stock
sql = "SELECT spec_id, spec_name FROM mer_spec WHERE product_id = %s"
spec_name = mysql.getAll(sql, param=[i.get('product_id')])
spec_info = []
if stock[0].get('stock_specs'):
for x in spec_name:
spec_deatil_dic = {}
spec_deatil_dic['spec'] = x
sql = "SELECT spec_detail_id, detail_name FROM mer_specdetail \
WHERE spec_id = %s"
spec_detail = mysql.getAll(sql,
param=[x.get('spec_id')])
spec_deatil_dic['spec_detail'] = spec_detail
spec_info.append(spec_deatil_dic)
i['spec_info'] = spec_info
mysql.dispose()
return HttpResponse(returnJson(0, '查询成功', product))
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 see(self):
sql = "SELECT \
c.id as cart_id, \
c.num, \
c.store_id, \
s.id, \
s.stock_name, \
s.img, \
s.product_id, \
s.stock_detail, \
s.upper_shelf, \
s.price, \
s.hehecoin, \
p.user_goods_limit, \
s.stock_num \
FROM \
cart AS c \
LEFT JOIN stock AS s ON c.stock_id = s.id \
LEFT JOIN product AS p ON s.product_id = p.id \
WHERE \
c.userid = %s \
ORDER BY \
c.handletime DESC"
info = query(sql, param=[self.info['user_id']])
return HttpResponse(returnJson(0, '查询成功', info))
def see(self):
sql = "SELECT checkTime FROM click_card \
WHERE userid = %s AND checkTime LIKE %s"
info = query(
sql,
param=[self.info['user_id'], '%' + self.info['check_time'] + '%'])
return HttpResponse(returnJson(0, '打卡成功', info))
def post(self, request, **payload):
is_school = int(request.POST.get('is_school')) #0个人 1学校
if is_school == 0:
sql = "SELECT * FROM last_ranklist"
else:
sql = "SELECT * FROM last_school_ranklist"
info = query(sql)
return HttpResponse(returnJson(0, '查询成功', info))
def post(self, request, **payload):
self.params = {}
self.params['start_time'] = request.POST.get('start_time')
self.params['end_time'] = request.POST.get('end_time')
self.params['is_school'] = int(request.POST.get('is_school')) # 0个人 1学校
if self.params['is_school'] == 0:
sql = f'''SELECT \
SUM(d.wight) AS weight, \
u.id AS user_id, \
u.wxname, \
u.school_id, \
u.user_img, \
s.school_img \
FROM \
deliver AS d \
LEFT JOIN gzh_user AS g ON g.openid = d.openid \
LEFT JOIN userInfo AS u ON u.unionId = g.unionid \
LEFT JOIN school AS s ON u.school_id = s.id \
WHERE \
u.wxname IS NOT NULL \
AND g.openid NOT IN
('oLKbX1JCYRryfJsXPNvl69kNTXFU','oLKbX1BjDWpeyuVFPGzm9H7szvoo', \
'oLKbX1CXeWasiulsOR-_CeYnlprk', 'oLKbX1KuMDzJe2e46z0WyLAhkKHQ', \
'oLKbX1O-HV9pXabfE5BWB6jsMbQY', 'oICg44y-TQLpvENQFvVtTUEqXRT8',\
'oLKbX1Hc8lNNZmNNQcM0WhvbvnhM','oLKbX1OJgSIZrb2Hxi2nYRnRPpTQ',
'oLKbX1GgjlWc155Qk927f7hHhWv8') \
AND d.create_time \
BETWEEN '{START_TIME}' AND '{END_TIME}' \
GROUP BY \
d.openid \
ORDER BY \
weight DESC \
LIMIT 0, \
100'''
else:
sql = f'''SELECT \
SUM(d.wight) AS weight, \
u.id AS user_id, \
u.school_id, \
s.school_name, \
s.school_img \
FROM \
deliver AS d \
LEFT JOIN gzh_user AS g ON g.openid = d.openid \
LEFT JOIN userInfo AS u ON u.unionId = g.unionid \
LEFT JOIN school AS s ON u.school_id = s.id \
WHERE \
u.wxname IS NOT NULL \
AND u.school_id is NOT NULL \
AND d.create_time BETWEEN '{START_TIME}' AND '{END_TIME}' \
GROUP BY \
u.school_id \
ORDER BY \
weight DESC \
LIMIT 0, \
100'''
info = query(sql)
return HttpResponse(returnJson(0, '查询成功', info))
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 post(self, request):
self.info["pwd"] = request.POST.get("pwd")
self.info["mobile"] = request.POST.get("mobile")
sql = 'select * from users where mobile=%s and password=%s'
user_info = queryOne(sql,
param=[self.info["mobile"], self.info["pwd"]])
if not user_info:
return HttpResponse(returnJson(-2, '登录失败'))
payload = {'name': user_info.get('name')}
token = getToken(payload, 2)
data = {
'isAdmin': user_info.get('isAdmin'),
'name': user_info.get('name'),
'power': user_info.get('power'),
'token': token
}
return HttpResponse(returnJson(0, '登录成功', data))
def campus(self):
sql = "SELECT SUM(d.wight) as wight, s.school_name \
FROM deliver AS d \
LEFT JOIN gzh_user AS g ON d.openid = g.openid \
LEFT JOIN userInfo AS u ON g.unionid = u.unionId \
LEFT JOIN school AS s ON s.id = u.school_id \
LEFT JOIN school_area AS sa ON sa.id = s.area_id \
WHERE u.school_id IS NOT NULL AND sa.id = %s GROUP BY u.school_id"
info = query(sql, self.info['area_id'])
return HttpResponse(returnJson(0, '查询成功', info))
def checkStep(self):
date = datetime.datetime.today().isoformat().split('T')[0]
sql = 'select * from coin_log where userid=%s and handleType=3 AND %s = %s'
data = queryOne(sql,
param=[
self.Info['user_id'],
'date_format(handletime,"%Y-%m-%d")', data
])
data = {'isok': True} if data else {'isok': False}
return HttpResponse(returnJson(0, '查询成功', data))
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, **payload):
handle = payload.get('handle')
user_id = payload.get('user_id')
name = request.POST.get('name')
phone = request.POST.get('phone')
address = request.POST.get('address')
address_id = request.POST.get('address_id')
if handle == 'add':
mysql = Mysql()
sql = "INSERT INTO user_address SET user_id=%s, `name`=%s, \
phone=%s, address=%s"
add_id = mysql.insertOne(sql,
param=[user_id, name, phone, address])
add_id = {'add_id': add_id}
mysql.dispose()
return HttpResponse(returnJson(0, '新增地址成功', add_id))
if handle == 'get':
sql = "SELECT * FROM user_address WHERE user_id=%s"
info = query(sql, param=[user_id])
return HttpResponse(returnJson(0, '查询成功', info))
if handle == 'edit':
mysql = Mysql()
sql = "UPDATE user_address SET user_id=%s, `name`=%s, \
phone=%s, address=%s WHERE id=%s"
mysql.update(sql,
param=[user_id, name, phone, address, address_id])
mysql.dispose()
return HttpResponse(returnJson(0, '编辑地址成功'))
if handle == 'del':
mysql = Mysql()
sql = "DELETE FROM user_address WHERE id=%s"
suc = mysql.delete(sql, param=[address_id])
mysql.dispose()
return HttpResponse(returnJson(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 edit(self):
if not isinstance(self.info['num'], int) or int(self.info['num']) <= 0:
return HttpResponse(returnJson(-2, '商品数量出现错误'))
mysql = Mysql()
#新增数量判断
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) \
WHERE s.id = %s"
product_id = mysql.getOne(sql, param=[self.info['stock_id']])
if not product_id:
mysql.dispose()
return HttpResponse(returnJson(-2, "库存编号错误"))
if int(product_id.get('user_goods_limit')) > 0:
limits = int(product_id.get('limits')) + num if product_id.get(
'limits') else num
if limits > int(product_id.get('user_goods_limit')):
mysql.dispose()
return HttpResponse(returnJson(-2, "超出限量限制"))
sql = "UPDATE cart SET num = %s WHERE userid = %s AND \
stock_id = %s AND store_id = %s"
suc = mysql.update(sql,
param=[
self.info['num'], self.info['user_id'],
self.info['stock_id'], self.info['store_id']
])
mysql.dispose()
return HttpResponse(returnJson(0, "修改数量成功"))
def post(self, request, **payload):
handle = payload.get('handle')
self.info['user_id'] = payload.get('user_id')
self.info['check_time'] = request.POST.get('check_time')
if handle == 'do':
return self.do()
if handle == 'see':
return self.see()
return HttpResponse(returnJson(-2, '非法路径'))
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 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 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 post(self, request, **payload):
handle = payload.get('handle')
#参数
self.params['user_id'] = payload.get('user_id')
self.params['mer_id'] = request.POST.get('mer_id')
self.params['mer_type'] = request.POST.get('mer_type')
self.params['product_id'] = request.POST.get('product_id')
self.params['cart_info'] = request.POST.get('cart_info')
self.params['page'] = request.POST.get('page')
self.params['row'] = request.POST.get('row')
#pay
self.params['sum_money'] = request.POST.get('sum_money')
#order
self.params['phone'] = request.POST.get('phone')
self.params['name'] = request.POST.get('name')
if handle == 'selMerList':
return self.selMerList()
if handle == 'selHotMer':
return self.selHotMer()
if handle == 'selRandMer':
return self.selRandMer()
if handle == 'selProduct':
return self.selProduct()
if handle == 'selProducts':
return self.selProducts()
if handle == 'selProductDetail':
return self.selProductDetail()
if handle == 'addMerHot':
return self.addMerHot()
if handle == 'merCart':
state = payload.get('state')
return self.merCart(state)
if handle == 'payOrder':
return self.payOrder()
if handle == 'merPay':
return self.merPay()
return HttpResponse(returnJson(-2, '非法路径'))
def getData(self):
mysql = Mysql()
sql = 'SELECT \
u.money, u.hhcoin, \
s.school_name, \
s.school_img, \
s.id as school_id, \
u.openid, \
u.id as user_id, \
u.mobile, \
u.wxname \
FROM \
userInfo AS u \
LEFT JOIN school AS s ON u.school_id = s.id \
WHERE u.id = %s'
data = mysql.getOne(sql, param=[self.info['user_id']])
#------增加盒盒币
sql = '''SELECT \
d.id as did, \
d.hhcoin, \
d.state, \
u.id, \
u.openid \
FROM \
deliverCoin AS d \
LEFT JOIN gzh_user AS g ON d.gzh_openid = g.openid \
LEFT JOIN userInfo AS u ON u.unionId = g.unionid \
WHERE u.unionId IS NOT NULL AND d.state = 0 AND u.openid = %s \
GROUP BY d.id '''
info = mysql.getAll(sql, param=[data.get('openid')])
if info:
for i in info:
if i.get('hhcoin') != 0:
up_sql, ins_sql = Type_Log.coin_handle(user_id=i.get('id'),
handle=5,
num=i.get('hhcoin'),
asd=1)
up_suc = mysql.update(up_sql)
ins_suc = mysql.insertOne(ins_sql)
sql = "UPDATE deliverCoin SET state = 1 WHERE id = %s"
mysql.update(sql, param=[i.get('did')])
mysql.dispose()
return HttpResponse(returnJson(0, '查询成功', data))
def selProductDetail(self):
data = {}
mysql = Mysql()
sql = "SELECT * FROM mer_stock WHERE product_id = %s"
stock = mysql.getAll(sql, param=[self.params['product_id']])
if stock:
data['stock'] = stock
sql = "SELECT spec_id, spec_name FROM mer_spec WHERE product_id = %s"
spec_name = mysql.getAll(sql, param=[self.params['product_id']])
spec_info = []
if stock[0].get('stock_specs'):
for i in spec_name:
spec_deatil_dic = {}
spec_deatil_dic['spec'] = i
sql = "SELECT spec_detail_id, detail_name FROM mer_specdetail \
WHERE spec_id = %s"
spec_detail = mysql.getAll(sql, param=[i.get('spec_id')])
spec_deatil_dic['spec_detail'] = spec_detail
spec_info.append(spec_deatil_dic)
data['spec_info'] = spec_info
mysql.dispose()
return HttpResponse(returnJson(0, '查询成功', data))
def post(self, request, **payload):
handle = payload.get('handle')
self.info['user_id'] = payload.get('user_id')
self.info['stock_id'] = request.POST.get('stock_id')
self.info['num'] = request.POST.get('num')
self.info['store_id'] = request.POST.get('store_id')
self.info['cart_id'] = request.POST.get('cart_id')
if handle == 'see':
return self.see()
if handle == 'edit':
return self.edit()
if handle == 'add':
return self.add()
if handle == 'del':
return self.del_()
return HttpResponse(returnJson(-2, '非法路径'))
def post(self, request, **payload):
sql = "SELECT mchState, address, addremark, jd, wd, zhi_weight, shu_weight, `Repair` \
FROM machine WHERE (jd AND wd) IS NOT NULL AND (jd AND wd) != ''"
info = query(sql)
return HttpResponse(returnJson(0, '查询成功', info))
def post(self, request, **payload):
'''
获取解密后的微信步数以及VIP信息
'''
handle = payload.get('handle')
self.Info['openid'] = payload.get('openid')
self.Info['sessionKey'] = payload.get('session_key')
self.Info['user_id'] = payload.get('user_id')
#用来判断是获取手机号还是微信步数, 0获取手机号, 1获取步数, 2获取unionid
self.Info['iv'] = request.POST.get('iv') #加密算法的初始向量
self.Info['encryptedData'] = request.POST.get('encryptedData')
self.Info["jscode"] = request.POST.get("jscode")
if handle == "getPhone":
data = self.get_data()
print(data)
phone = data.get('phoneNumber')
self.save_data(data.get('phoneNumber'))
return HttpResponse(returnJson(0, '获取手机号成功', {'phone': phone}))
if handle == "getUnionid":
data = self.get_data()
print(data)
unionId = data.get('unionId')
return HttpResponse(returnJson(0, '获取数据成功', {'unionid': unionId}))
if handle == 'checkStep':
data = self.get_data()
print(data)
return self.checkStep()
if handle == "getStep":
data = self.get_data()
print(data)
stepInfoList = data.get('stepInfoList')
yes_step = self.parse_stepnum(stepInfoList)
mysql = Mysql()
sql = "SELECT * FROM coin_log WHERE userid = %s \
AND handleType = 3 AND to_days(handletime) = to_days(now()) "
check = mysql.getOne(sql, param=[self.Info['user_id']])
if check:
mysql.dispose()
return HttpResponse(
returnJson(0, '获取数据成功', {'yes_step': yes_step}))
else:
hhcoin = 30 if int(int(yes_step) / 500) >= 30 else int(
int(yes_step) / 500)
up_sql, log_sql = Type_Log.coin_handle(
user_id=self.Info['user_id'], handle=3, num=hhcoin, asd=1)
mysql.update(up_sql)
mysql.insertOne(log_sql)
mysql.dispose()
data = {"yes_step": yes_step, "hhcoin": hhcoin}
return HttpResponse(returnJson(0, '获取数据成功', data))
if handle == 'getOpenid':
return self.getOpenid()
if handle == 'checkToken':
return self.checkToken(request)
return HttpResponse(returnJson(-2, '非法路径'))
