def get(self, request, **payload):
self.params = {}
self.params['product_id'] = request.GET.get('product_id')
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
return HttpResponse(callJson(data))
mysql.dispose()
return HttpResponse(0)
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 sel_activity_class(self):
mysql = Mysql()
if self.__reqData['parentId']:
sql = 'SELECT * FROM activity_class WHERE acti_parentId = "{parentId}"'.format(
id=self.__reqData['parentId'])
info = mysql.getAll(sql)
return info
else:
sql = 'SELECT * FROM activity_class WHERE acti_parentId = 0'
info = mysql.getAll(sql)
mysql.dispose()
return info
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 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):
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 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):
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):
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 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):
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 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 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 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(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 sel_class_list(self):
mysql = Mysql()
if self.__reqData['name']:
sql = "SELECT * FROM proclass WHERE `name` LIKE '%{name}%'".format(
name=self.__reqData['name'])
info = mysql.getAll(sql)
else:
sql = "SELECT * FROM proclass"
info = mysql.getAll(sql)
for i in info:
sql = "SELECT `name` FROM proclass WHERE id = %a"
parent_name = mysql.getOne(sql, param=[i.get('parentId')])
if parent_name:
i['parentName'] = parent_name.get('name')
else:
i['parentName'] = None
return info
def get(self, request):
mer_id = request.GET.get("mer_id")
start_time = request.GET.get('start_time')
end_time = request.GET.get('end_time')
handler = request.GET.get('handler')
mysql = Mysql()
if handler == 'online':
sql = f"SELECT m.*, u.wxname, u.user_img FROM mer_orders as m \
LEFT JOIN userInfo as u ON m.user_id = u.id \
WHERE m.mer_id = {mer_id} AND state = 1 AND \
m.create_time BETWEEN '{start_time}' AND '{end_time}'\
ORDER BY m.create_time DESC "
order_info = mysql.getAll(sql)
if order_info:
order_list = []
for i in order_info:
data = {}
sql = f'''SELECT * FROM mer_ordergoods WHERE order_num="{i.get('order_num')}"'''
order_goods = mysql.getAll(sql)
data['order'] = i
for x in order_goods:
specs = x.get('mer_stockname').split('-')
x['stock_name'] = specs[0]
x['spec'] = '-'.join(specs[1:len(specs)])
data['goods'] = order_goods
order_list.append(data)
mysql.dispose()
return HttpResponse(callJson(order_list))
mysql.dispose()
return HttpResponse(0)
if handler == 'underline':
sql = f"SELECT m.*, u.wxname, u.user_img FROM mer_pay \
AS m LEFT JOIN userInfo AS u ON m.user_id = u.id WHERE \
mer_id = {mer_id} AND state = 1 AND m.create_time BETWEEN \
'{start_time}' AND '{end_time}' ORDER BY m.create_time DESC"
info = mysql.getAll(sql)
mysql.dispose()
if info:
return HttpResponse(callJson(info))
return HttpResponse(0)
else:
return HttpResponse(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 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):
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):
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 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):
mysql = Mysql()
sql = 'select * from users'
data = mysql.getAll(sql)
mysql.dispose()
return JsonResponse({
'ret' : 0,
'msg' : '查询成功',
'result' : data
})
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):
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 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 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 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):
quiz_id = request.GET.get("quiz_id")
mysql = Mysql()
sql = f"SELECT * FROM quiz_bank WHERE quiz_id = {quiz_id}"
info = mysql.getAll(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)