def get(self, request):
self.params = {}
self.params['mer_id'] = request.GET.get('mer_id')
self.params['row'] = request.GET.get('row')
self.params['page'] = request.GET.get('page')
self.params['product_name'] = request.GET.get('product_name')
mysql = Mysql()
sql = "SELECT * FROM mer_product WHERE mer_id = {mer_id} AND product_name \
LIKE '%{product_name}%'".format(
mer_id=self.params['mer_id'],
product_name=self.params['product_name'])
print(sql)
info = mysql.getAll(sql)
mysql.dispose()
if info:
sumpage, info = Pagings.paging(info,
row=self.params['row'],
page=self.params['page'])
data = {}
data['sumpage'] = sumpage
data['info'] = info
data = json.dumps(data,
ensure_ascii=False,
sort_keys=True,
indent=4,
cls=ComplexEncode)
return HttpResponse(data)
return HttpResponse(0)
def get(self, request):
parentid = request.GET.get('parentid')
mysql = Mysql()
sql = 'SELECT * FROM proclass WHERE parentId = %s'
class_info = mysql.getAll(sql, param=[parentid])
mysql.dispose()
return HttpResponse(callJson(class_info))
def get(self, request):
recurrence_no = request.GET.get('recurrence_no')
recurrence_name = request.GET.get('recurrence_name')
row = int(request.GET.get('row'))
page = int(request.GET.get('page'))
mysql = Mysql()
if recurrence_no:
sql = f"SELECT * FROM recurrence WHERE recurrence_no \
= '{recurrence_no}'"
if recurrence_name:
sql = f"SELECT * FROM recurrence WHERE recurrence_name \
LIKE '%{recurrence_name}%'"
if not recurrence_no and not recurrence_name:
sql = "SELECT * FROM recurrence"
info = mysql.getAll(sql)
mysql.dispose()
if info:
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)
return HttpResponse(data)
return HttpResponse(0)
def get(self, request):
area_name = request.GET.get('area_name')
row = request.GET.get('row')
page = request.GET.get('page')
area_id = request.GET.get('area_id')
get_school = request.GET.get('get_school')
mysql = Mysql()
if int(get_school) == 0:
sql = "SELECT * FROM school_area WHERE area_name like '%{area_name}%'".format(
area_name=area_name)
if int(get_school) == 1:
sql = "SELECT * FROM school WHERE area_id = '{area_id}'".format(
area_id=area_id)
print(sql)
info = mysql.getAll(sql)
mysql.dispose()
if info:
sumpage, info = Pagings.paging(info, row=row, page=page)
data = {}
data['sumpage'] = sumpage
data['info'] = info
data = json.dumps(data,
ensure_ascii=False,
sort_keys=True,
indent=4)
return HttpResponse(data)
return HttpResponse(0)
def save_data(self, mobile):
mysql = Mysql()
sql = "update userInfo set mobile=%s where openid=%s"
checkOk = mysql.update(sql, param=[mobile, self.Info['openid']])
mysql.dispose()
print(f"用户 {self.Info['openid']} 更新手机号 {mobile}")
return True
def get(self, request):
start_time = request.GET.get('start_time')
end_time = request.GET.get('end_time')
row = request.GET.get('row')
page = request.GET.get('page')
mysql = Mysql()
sql = f"SELECT \
COUNT(*) AS numbs, \
s.store_name, \
sum(o.orderMoney) AS sum_money \
FROM orders AS o ON \
LEFT JOIN store AS s ON o.store_id = s.id \
WHERE o.state = 4 AND \
o.createTime BETWEEN '{start_time}' AND '{end_time}' GROUP BY s.id "
info = mysql.getAll(sql)
mysql.dispose()
if info:
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)
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 turntable(self):
mysql = Mysql()
sql = "SELECT * FROM probability ORDER BY id"
info = mysql.getAll(sql)
mysql.dispose()
random_list = []
id_list = []
for i in info:
random_list.append(i.get('probability_num'))
id_list.append(i.get('id'))
a = sum(random_list[0:1]) + 1
b = sum(random_list[0:2]) + 1
c = sum(random_list[0:3]) + 1
d = sum(random_list[0:4]) + 1
e = sum(random_list[0:5]) + 1
f = sum(random_list[0:6]) + 1
g = sum(random_list[0:7]) + 1
h = sum(random_list[0:8]) + 1
num = randint(1, 100)
if num in list(range(1, a)):
return id_list[0]
elif num in list(range(a, b)):
return id_list[1]
elif num in list(range(b, c)):
return id_list[2]
elif num in list(range(c, d)):
return id_list[3]
elif num in list(range(d, e)):
return id_list[4]
elif num in list(range(e, f)):
return id_list[5]
elif num in list(range(f, g)):
return id_list[6]
elif num in list(range(g, h)):
return id_list[7]
def get(self, request):
user_id = request.GET.get('user_id')
mysql = Mysql()
sql = f"SELECT \
o.orderNum, \
o.state, \
o.orderMoney, \
o.createTime, \
og.stock_name, \
og.stock_detail \
FROM \
orders AS o \
LEFT JOIN ordergoods AS og \
ON o.orderNum = og.order_id \
WHERE \
createUser = '******' \
AND orderNum LIKE '%kanjia%'"
data = mysql.getAll(sql)
mysql.dispose()
if data:
data = json.dumps(data,
ensure_ascii=False,
sort_keys=True,
indent=4,
cls=ComplexEncode)
return HttpResponse(data)
else:
return HttpResponse(0)
def get(self, request):
state = request.GET.get('state') #0未领取 1领取
re_id = request.GET.get('re_id')
row = request.GET.get('row')
page = request.GET.get('page')
mysql = Mysql()
sql = ""
if state:
sql = f"SELECT reward_log.*, userInfo.wxname, userInfo.user_img FROM reward_log \
LEFT JOIN userInfo ON reward_log.user_id = userInfo.id WHERE \
(prize_type = 1 or prize_type = 2) AND `get` = {state}"
else:
sql = "SELECT reward_log.*, userInfo.wxname, userInfo.user_img FROM reward_log \
LEFT JOIN userInfo ON reward_log.user_id = userInfo.id WHERE \
(prize_type = 1 or prize_type = 2)"
if re_id:
sql = f"SELECT reward_log.*, userInfo.wxname, userInfo.user_img FROM reward_log \
LEFT JOIN userInfo ON reward_log.user_id = userInfo.id WHERE \
(prize_type = 1 or prize_type = 2) AND reward_log.id = {re_id}"
info = mysql.getAll(sql)
mysql.dispose()
if info:
sumpage, info = Pagings.paging(info, row=row, page=page)
data = {}
data['sumpage'] = sumpage
data['info'] = info
data = json.dumps(data, ensure_ascii=False, sort_keys=True, indent=4, cls=ComplexEncode)
return HttpResponse(data)
return HttpResponse(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 get(self, request):
product_id = int(request.GET.get('product_id'))
mysql = Mysql()
sql = "SELECT * FROM stock WHERE product_id = %s AND state = 1"
info = mysql.getAll(sql, param=[product_id])
mysql.dispose()
if info:
return HttpResponse(callJson(info))
return HttpResponse(0)
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):
mysql = Mysql()
sql = "SELECT * FROM prize_class"
info = mysql.getAll(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, **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):
prize_id = request.GET.get('prize_id')
mysql = Mysql()
sql = "SELECT * FROM prize_coupon WHERE prize_id = '{prize_id}'".format(prize_id=prize_id)
info = mysql.getAll(sql)
if info:
info = json.dumps(info, sort_keys=True, ensure_ascii=False, indent=4)
return HttpResponse(info)
return HttpResponse(0)
def get(self, request):
store_id = request.GET.get('store_id')
order_num = request.GET.get('order_num') #订单编号
order_state = request.GET.get(
'order_state') #订单状态0待付款1代发货2待收货3售后4已完成5取消6抽奖
row = request.GET.get('row')
page = request.GET.get('page')
print(request.GET)
mysql = Mysql()
sql = "SELECT orders.*, userInfo.wxname, store.store_name FROM orders \
LEFT JOIN userInfo ON orders.createUser = userInfo.id \
LEFT JOIN store ON store.id = orders.store_id \
ORDER BY createTime DESC"
if order_num:
sql = f"SELECT orders.*, userInfo.wxname, store.store_name FROM orders \
LEFT JOIN userInfo ON orders.createUser = userInfo.id \
LEFT JOIN store ON store.id = orders.store_id \
WHERE orders.orderNum = '{order_num}' \
ORDER BY createTime DESC"
if order_state:
sql = f"SELECT orders.*, userInfo.wxname, store.store_name FROM orders \
LEFT JOIN userInfo ON orders.createUser = userInfo.id \
LEFT JOIN store ON store.id = orders.store_id \
WHERE orders.state = '{order_state}' \
ORDER BY createTime DESC"
if store_id:
sql = f"SELECT orders.*, userInfo.wxname, store.store_name FROM orders \
LEFT JOIN userInfo ON orders.createUser = userInfo.id \
LEFT JOIN store ON store.id = orders.store_id \
WHERE orders.store_id = '{store_id}' \
ORDER BY createTime DESC"
if store_id and order_state:
sql = f"SELECT orders.*, userInfo.wxname, store.store_name FROM orders \
LEFT JOIN userInfo ON orders.createUser = userInfo.id \
LEFT JOIN store ON store.id = orders.store_id \
WHERE orders.store_id = '{store_id}' AND orders.state = '{order_state}' \
ORDER BY createTime DESC"
info = mysql.getAll(sql)
mysql.dispose()
if info:
sumpage, info = Pagings.paging(info, row=row, page=page)
data = {}
data['sumpage'] = sumpage
data['info'] = info
data = json.dumps(data,
ensure_ascii=False,
sort_keys=True,
indent=4,
cls=ComplexEncode)
return HttpResponse(data)
return HttpResponse(0)
def get(self, request):
admin_id = request.GET.get('id')
mysql = Mysql()
sql = 'delete from users where id=%s'
state = mysql.delete(sql, param=[
admin_id
])
mysql.dispose()
state = 1 if state else 0
return JsonResponse({'state': state})
def get(self, request):
banner_path = request.GET.get('banner_path')
mysql = Mysql()
sql = "SELECT * FROM banner WHERE banner_path = %s ORDER BY banner_type"
info = mysql.getAll(sql, param=[banner_path])
mysql.dispose()
info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4)
if info:
return HttpResponse(info)
return HttpResponse(0)
def get(self, request):
mysql = Mysql()
sql = 'select * from users'
data = mysql.getAll(sql)
mysql.dispose()
return JsonResponse({
'ret' : 0,
'msg' : '查询成功',
'result' : data
})
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 get(self, request):
class_id = request.POST.get('class_id')
mysql = Mysql()
sql = "SELECT * FROM prize WHERE class_id='{class_id}'".format(class_id=class_id)
info = mysql.getAll(sql)
mysql.dispose()
if info:
info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4)
return HttpResponse(info)
return HttpResponse(0)
def sel_activity(self):
mysql = Mysql()
sql = 'SELECT * FROM activity'
info = mysql.getAll(sql)
if info:
iswin = 1
else:
iswin = 0
mysql.dispose()
return info, iswin
def get(self, request, **payload):
self.params = {}
self.params['mer_id'] = request.GET.get('mer_id')
mysql = Mysql()
sql = "SELECT * FROM mer_product WHERE mer_id = %s"
info = mysql.getAll(sql, param=[self.params['mer_id']])
mysql.dispose()
if info:
return HttpResponse(callJson(info))
return HttpResponse(0)
def get(self, request):
mer_id = request.GET.get('mer_id')
mysql = Mysql()
sql = f"SELECT mer_userid, user_name, wx_img, phone, is_admin, openid FROM mer_admin WHERE mer_id = {mer_id}"
info = mysql.getAll(sql)
mysql.dispose()
if info:
data = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4, cls=ComplexEncode)
return HttpResponse(data)
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):
mysql = Mysql()
sql = "SELECT p.*, pr.prize_detail, pr.all_limit, pr.one_limit FROM probability as p \
LEFT JOIN prize as pr ON p.prize_id = pr.id ORDER BY p.id"
info = mysql.getAll(sql)
mysql.dispose()
if info:
info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4)
return HttpResponse(info)
return 0
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 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 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
