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 post(self, request):
self.params = {}
self.params['spec_id'] = request.POST.get('spec_id')
self.params['spd_id'] = request.POST.get('spec_detail_id')
self.params['check_num'] = int(
request.POST.get('check_num')) #第一次点击传 1第二次确认删除传2
mysql = Mysql()
try:
if self.params['check_num'] == 1:
sql = "SELECT * FROM mer_stock WHERE FIND_IN_SET \
('{spd_id}', mer_stock.stock_specs)".format(
spd_id=self.params['spd_id'])
stock_info = mysql.getAll(sql)
if stock_info:
mysql.dispose()
stock_info = json.dumps(stock_info,
ensure_ascii=False,
sort_keys=True,
indent=4)
return HttpResponse(stock_info)
else:
mysql.errdispose()
return HttpResponse('规格详情id错误')
if self.params['check_num'] == 2:
self.params['stock_list'] = json.loads(
request.POST.get('stock_list')) #stockid check_num=2传过来
sql = "DELETE FROM mer_specdetail WHERE spec_detail_id='{spd_id}'".format(
spd_id=self.params['spd_id'])
mysql.delete(sql)
sql = "SELECT * FROM mer_specdetail WHERE spec_id = '{spec_id}'".format(
spec_id=self.params['spec_id'])
check_spec = mysql.getOne(sql)
for i in self.params['stock_list']:
sql = "DELETE FROM mer_stock WHERE stock_id = '{stock_id}'".format(
stock_id=i)
mysql.delete(sql)
if check_spec:
pass
else:
#sql = "DELETE FROM mer_spec WHERE spec_id = '{spec_id}'".format(spec_id=self.params['spec_id'])
mysql.errdispose(sql)
return HttpResponse(2)
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(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 delete(self, request):
coupon = QueryDict(request.body)
for k, v in coupon.items():
info = json.loads(k)
coupon_id = info.get('coupon_id')
mysql = Mysql()
try:
for i in coupon_id:
sql = "DELETE FROM prize_coupon WHERE id = '{coupon_id}'".format(coupon_id=i)
mysql.delete(sql)
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
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 post(self, request):
quiz_id = request.POST.get('quiz_id')
mysql = Mysql()
sql = f"DELETE FROM daily_quiz WHERE id = '{quiz_id}'"
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
store_id = request.POST.get('store_id')
mysql = Mysql()
sql = f"DELETE FROM store WHERE id = '{store_id}'"
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
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 post(self, request):
news_id = request.POST.get('news_id')
mysql = Mysql()
sql = f"DELETE FROM information WHERE id = {news_id}"
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
mer_userid = request.POST.get('mer_userid')
mysql = Mysql()
#sql = f"DELETE FROM mer_admin WHERE phone = '{phone}' "
sql = f"DELETE FROM mer_admin WHERE mer_userid = '{mer_userid}'"
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
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 post(self, request):
address_id = request.POST.get('address_id')
mysql = Mysql()
sql = "DELETE FROM school_address WHERE id = '{address_id}'".format(
address_id=address_id)
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
self.params = {}
self.params['product_id'] = request.POST.get('product_id')
self.params['product_name'] = request.POST.get('product_name')
self.params['product_img'] = request.POST.get('product_img')
self.params['min_price'] = request.POST.get('min_price')
self.params['max_price'] = request.POST.get('max_price')
self.params['hhcoin'] = request.POST.get('hhcoin')
self.params['product_stock'] = json.loads(
request.POST.get('product_stock'))
#[{'stockname':'xx',hhcoin':1, 'price':22, 'stock_id':222, 'min_buy':1, 'max_buy':2}, {...}]
self.params['delete_stock'] = json.loads(
request.POST.get('delete_stock')) #[1,3,4,5]
print(self.params)
try:
mysql = Mysql()
sql = "UPDATE mer_product SET product_name='{product_name}', \
product_img='{product_img}', min_price='{min_price}', \
max_price='{max_price}', hhcoin='{hhcoin}' \
WHERE product_id='{product_id}'" .format(product_id=self.params['product_id'], \
product_name=self.params['product_name'], product_img=self.params['product_img'],\
min_price=self.params['min_price'], max_price=self.params['max_price'], \
hhcoin=self.params['hhcoin'])
mysql.update(sql)
for i in self.params['product_stock']:
sql = "UPDATE mer_stock SET stock_name='{stock_name}', \
price='{price}', hhcoin='{hhcoin}', min_buy='{min_buy}', max_buy='{max_buy}' \
WHERE stock_id ='{stock_id}'" .format(stock_name=i.get('stockname'), min_buy=i.get('min_buy'),\
price=i.get('price'), hhcoin=i.get('hhcoin'), stock_id=i.get('stock_id'), max_buy=i.get('max_buy'))
print(sql)
mysql.update(sql)
for x in self.params['delete_stock']:
sql = "DELETE FROM mer_stock WHERE stock_id = '{stock_id}'".format(
stock_id=x)
mysql.delete(sql)
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
self.params = {}
self.params['mer_userid'] = request.POST.get('mer_userid')
mysql = Mysql()
sql = "DELETE FROM mer_admin WHERE mer_userid \
= '{mer_userid}'".format(mer_userid=self.params['mer_userid'])
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
quiz_name = request.POST.get('quiz_name')
answer_list = json.loads(request.POST.get('answer_list'))
quiz_id = request.POST.get('quiz_id')
#[{answer:xxx,is_right:1}]
mysql = Mysql()
try:
sql = f"UPDATE daily_quiz SET quiz_name = '{quiz_name}' WHERE id = '{quiz_id}'"
mysql.update(sql)
sql = f"DELETE FROM quiz_bank WHERE quiz_id = {quiz_id}"
mysql.delete(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.update(sql)
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
self.params = {}
self.params['product_id'] = request.POST.get('product_id')
mysql = Mysql()
sql = "DELETE FROM mer_product WHERE \
product_id = '{product_id}'".format(
product_id=self.params['product_id'])
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
try:
self.__reqData = {}
self.__reqData['img_id'] = request.POST.get('img_id')
mysql = Mysql()
sql = "DELETE FROM banner WHERE id = %s"
suc = mysql.delete(sql, param=[self.__reqData['img_id']])
mysql.dispose()
return HttpResponse(1)
except Exception as e:
print(e)
mysql.errdispose()
return HttpResponse(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 del_act(self):
mysql = Mysql()
if self.__reqData['act_type'] == 1:
sql = "SELECT stockProductId FROM activityproduct WHERE activityId='{act_id}'".format(
act_id=self.__reqData['act_id'])
suc = mysql.getAll(sql)
for i in suc:
sql = "UPDATE product, spec SET product.act_num='0', product.limitNum='0', \
spec.limitNum='0', spec.acti_hehecoin='0', \
spec.acti_price='0' \
WHERE spec.productId = product.id \
AND spec.id='{stockProductId}'".format(
stockProductId=i.get('stockProductId'))
mysql.update(sql)
sql = "DELETE FROM activity WHERE id = '{act_id}'".format(
act_id=self.__reqData['act_id'])
del_one = mysql.delete(sql)
sql = "DELETE FROM activityproduct WHERE activityId = '{act_id}'".format(
act_id=self.__reqData['act_id'])
del_two = mysql.delete(sql)
if del_one and del_two:
iswin = 1
else:
iswin = 0
elif self.__reqData['act_type'] == 0:
sql = "DELETE FROM activity WHERE id = '{act_id}'".format(
act_id=self.__reqData['act_id'])
del_tre = mysql.delete(sql)
if del_tre:
iswin = 1
else:
iswin = 0
else:
iswin = "活动类型错误"
mysql.dispose()
return iswin
def post(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.getOne(sql)
if info:
mysql.dispose()
return HttpResponse(2) #分类下有奖品 不能删
sql = "DELETE FROM prize_class WHERE id = '{class_id}'".format(class_id=class_id)
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
area_id = request.POST.get('area_id')
mysql = Mysql()
sql = "SELECT id FROM school WHERE area_id = '{area_id}'".format(
area_id=area_id)
info = mysql.getOne(sql)
if info:
mysql.dispose()
return HttpResponse(2) #有学校绑定 要先删学校
sql = "DELETE FROM school_area WHERE id='{area_id}'".format(
area_id=area_id)
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
def post(self, request):
school_id = request.POST.get('school_id')
mysql = Mysql()
sql = "SELECT * FROM userInfo WHERE school_id = '{school_id}'".format(
school_id=school_id)
info = mysql.getOne(sql)
if info:
mysql.dispose()
return HttpResponse(2) #有学生绑定 要先删学生
sql = "DELETE FROM school WHERE id = '{school_id}'".format(
school_id=school_id)
suc = mysql.delete(sql)
if suc:
mysql.dispose()
return HttpResponse(1)
mysql.errdispose()
return HttpResponse(0)
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 del_one_activiryproduct(self, request):
mysql = Mysql()
sql = 'DELETE FROM activityproduct WHERE activityId="{act_id}" \
AND stockProductId = "{spec_id}"'.format(
act_id=request.GET.get('act_id'),
spec_id=request.GET.get('spec_id'))
del_info = mysql.delete(sql)
print(sql)
sql = "UPDATE product, spec SET product.act_num='0', product.limitNum='0', \
spec.limitNum='0', spec.acti_hehecoin='0', \
spec.acti_price='0' \
WHERE spec.productId = product.id \
AND spec.id='{spec_id}'".format(
spec_id=request.GET.get('spec_id'))
print(sql)
update_info = mysql.update(sql)
mysql.dispose()
if del_info and update_info:
iswin = 1
return iswin
else:
iswin = 0
return iswin
def post(self, request, **payload):
handle = payload.get('handle')
self.info['order_num'] = request.POST.get('order_num')
self.info['row'] = request.POST.get('row')
self.info['page'] = request.POST.get('page')
self.info['order_type'] = request.POST.get('order_type')
self.info['as_type'] = request.POST.get('as_type') # 退货0，换货1
self.info['order_state'] = request.POST.get('order_state') #订单状态
self.info['why'] = request.POST.get('why') #补充说明
#下单
self.info['user_id'] = payload.get('user_id') #用户id
self.info['sendTime'] = request.POST.get('send_time') #送货时间
self.info['address'] = request.POST.get('address') #收货地址
self.info['phone'] = request.POST.get('phone') #手机号码
self.info['remark'] = request.POST.get('remark') #备注
self.info['Consignee'] = request.POST.get('consignee') #收货人
self.info['order_num'] = getOrderNum('ShopOrder') #订单编号
self.info['freight'] = request.POST.get('freight') #运费状态，为0则运费为3，否则运费为0
self.info['stock_list'] = request.POST.get('stock_list')
#库存列表 传列表套对象[{stock_id:1,num:1, store_id:1},{stock_id:1,num:1, store_id:1}]
cache_name = 'order-' + self.info['order_num']
if handle == 'confirm':
mysql = Mysql()
sql = 'UPDATE orders SET state = %s WHERE orderNum = %s'
mysql.update(sql, param=[4, self.info['order_num']])
mysql.dispose()
return HttpResponse(returnJson(0, '确认成功'))
if handle == 'allOrders':
page, row = Pagings.mysqlPagings(self.info['page'], self.info['row'])
sql = "SELECT orderNum, balance, wxMoney, state \
FROM orders WHERE createUser = %s \
ORDER BY createTime DESC limit %s, %s"
info = query(sql, param=[self.info['user_id'], page, row])
data = self.orderDeatil(info)
return HttpResponse(returnJson(0, '查询成功', data))
if handle == 'typeOrder':
page, row = Pagings.mysqlPagings(self.info['page'], self.info['row'])
sql = "SELECT orderNum, orderMoney, heheCoin, \
wxMoney, balance, state FROM orders \
WHERE createUser = %s AND state = %s \
ORDER BY createTime DESC limit %s, %s"
info = query(sql, param=[self.info['user_id'], self.info['order_type'], page, row])
data = self.orderDeatil(info)
return HttpResponse(returnJson(0, '查询成功', data))
if handle == 'cancel':
return self.cancel()
if handle == 'placeOrder':
self.info['stock_list'] = json.loads(request.POST.get('stock_list'))
return self.placeOrder()
if handle == 'cancelAsOrder':
mysql = Mysql()
sql = "SELECT order_state FROM as_orders WHERE order_id = %s"
state = mysql.getOne(sql, param=[self.info['order_num']])
sql = "UPDATE orders SET state = %s WHERE orderNum = %s"
mysql.update(sql, param=[state.get('order_state'), self.info['order_num']])
sql = "DELETE FROM as_orders WHERE order_id = %s"
mysql.delete(sql, param=[self.info['order_num']])
mysql.dispose()
return HttpResponse(returnJson(0, '取消售后订单成功'))
if handle == 'selAsOrder':
sql = "SELECT * FROM as_orders WHERE order_id=%s"
info = query(sql, param=[self.info['order_num']])
return HttpResponse(returnJson(0, '查询成功', info))
if handle == 'upAsOrder':
mysql = Mysql()
sql = 'UPDATE orders SET state="3" WHERE orderNum = %s'
mysql.update(sql, param=[self.info['order_num']])
sql = "insert into as_orders SET order_id=%s, type=%s, \
why=%s, isCheck=0, create_time=NOW(), order_state=%s"
mysql.insertOne(sql, param=[
self.info['order_num'],
self.info['as_type'],
self.info['way'],
self.info['order_state']])
mysql.dispose()
return HttpResponse(returnJson(0, '提交售后成功'))
return HttpResponse(returnJson(-2, '非法路径'))
