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, '非法路径'))