def post(self, request): recurrence_id = request.POST.get('recurrence_id') mysql = Mysql() sql = f"DELETE FROM recurrence WHERE id = '{recurrence_id}'" suc = mysql.delete(sql) if suc: mysql.dispose() return HttpResponse(1) mysql.errdispose() 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 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): 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): area_name = request.POST.get('area_name') mysql = Mysql() sql = "INSERT INTO school_area SET area_name = '{area_name}'".format( area_name=area_name) suc = mysql.insertOne(sql) if suc: mysql.dispose() return HttpResponse(1) mysql.errdispose() return HttpResponse(0)
def get(self, request): class_id = request.GET.get('class_id') mysql = Mysql() sql = "SELECT prize_type_id, prize_type_name FROM \ prize_type_class WHERE prize_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_one_activity(self): mysql = Mysql() sql = 'SELECT * FROM activity WHERE activityName LIKE "%{name}%"'.format( name=self.__reqDtat['name']) info = mysql.getAll(sql) mysql.dispose() if info: iswin = 1 else: iswin = 0 return info, iswin
def add_activity(self): mysql = Mysql() if self.__reqData['poster'] == 0: sql = 'INSERT INTO activity(activityName, activityImg, startTime, endTime, poster, acti_class_id) VALUES("{name}","{img}","{start}","{end}","{poster}","{class_id}")'.format( name=self.__reqData['activityName'], img=self.__reqData['activityImg'], start=self.__reqData['startTime'], end=self.__reqData['endTime'], poster=self.__reqData['poster'], class_id=1) mysql.insertOne(sql) iswin = 1 elif self.__reqData['poster'] == 1: sql = 'INSERT INTO activity(activityName, activityImg, startTime, endTime, poster, acti_class_id) VALUES("{name}","{img}","{start}","{end}","{poster}","{class_id}")'.format( name=self.__reqData['activityName'], img=self.__reqData['activityImg'], start=self.__reqData['startTime'], end=self.__reqData['endTime'], poster=self.__reqData['poster'], class_id=1) print(sql) act_info = mysql.insertOne(sql) print(act_info) # sql = 'SELECT id FROM activity WHERE activityName="{activityName}"'.format(activityName=self.__reqData['activityName']) # act_info = mysql.getOne(sql) act_dict = json.loads(self.__reqData['act_list']) for k, v in act_dict.items(): stockProductId = v.get('stockProductId') newPrice = v.get('newPrice') newHHcoin = v.get('newHHcoin') limitnum = v.get('limitnum') sql = 'INSERT INTO activityproduct(activityId,stockProductId,newPrice,newHHcoin,limitnum) ' \ 'VALUES({act_num},{stockProductId},{newPrice},{newHHcoin},{limitnum})'.format( act_num=act_info, stockProductId=stockProductId, newPrice=newPrice, newHHcoin=newHHcoin, limitnum=limitnum) print(sql) mysql.insertOne(sql) sql = "UPDATE product, spec SET product.act_num='{act_num}', product.limitNum='{limitnum}', \ spec.limitNum='{limitnum}', spec.acti_hehecoin='{newHHcoin}', \ spec.acti_price='{newPrice}' \ WHERE spec.productId = product.id \ AND spec.id='{stockProductId}'".format( act_num=act_info, limitnum=limitnum, newHHcoin=newHHcoin, newPrice=newPrice, stockProductId=stockProductId) print(sql) mysql.update(sql) iswin = 1 else: iswin = 0 mysql.dispose() return iswin
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)
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 merOrder(self): mysql = Mysql() # 获取userid sql = "UPDATE mer_orders SET wxid = %s, state = '1', \ wx_money = %s, pay_time = NOW() WHERE order_num = %s " state = mysql.update(sql, param=[ self.Info['wxid'], self.Info['total_fee'], self.Info['orderNum'] ]) mysql.dispose()
def get(self, request): prize_id = request.GET.get('prize_id') mysql = Mysql() sql = "SELECT stock.stock_name, stock.id, prize_stock.stock_numb FROM prize_stock \ LEFT JOIN stock ON prize_stock.stock_id = stock.id \ WHERE prize_stock.prize_id = '{prize_id}'".format(prize_id=prize_id) info = mysql.getOne(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): mer_id = request.GET.get('mer_id') # list mer_id = json.loads(mer_id) mysql = Mysql() data = {} for i in mer_id: sql = "SELECT * FROM mer_product WHERE mer_id = %s" product = mysql.getAll(sql, param=i) product = product if product else [] data[i] = product mysql.dispose() return HttpResponse(callJson(data))
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 edit_act(self): mysql = Mysql() if self.__reqData['poster'] == 0: sql = "UPDATE activity SET activityName='{activityName}', activityImg='{activityImg}', startTime='{startTime}', endTime='{endTime}', acti_class_id='{class_id}' WHERE id = '{id}'".format( activityName=self.__reqData['activityName'], activityImg=self.__reqData['activityImg'], startTime=self.__reqData['startTime'], endTime=self.__reqData['endTime'], id=self.__reqData['id'], class_id=self.__reqData['class_id']) print(sql) mysql.update(sql) iswin = 1 elif self.__reqData['poster'] == 1: sql = "UPDATE activity SET activityName='{activityName}', activityImg='{activityImg}', startTime='{startTime}', endTime='{endTime}', acti_class_id='{class_id}' WHERE id = '{id}'".format( activityName=self.__reqData['activityName'], activityImg=self.__reqData['activityImg'], startTime=self.__reqData['startTime'], endTime=self.__reqData['endTime'], id=self.__reqData['id'], class_id=self.__reqData['class_id']) mysql.update(sql) if self.__reqData['act_list']: act_dict = json.loads(self.__reqData['act_list']) for k, v in act_dict.items(): newPrice = v.get('newPrice') newHHcoin = v.get('newHHcoin') limitnum = v.get('limitnum') new_stockProductId = v.get('stockProductId') sql1 = "INSERT INTO activityproduct(activityId,stockProductId,newPrice,newHHcoin,limitnum) \ VALUES('{act_num}','{stockProductId}','{newPrice}','{newHHcoin}','{limitnum}')".format( act_num=self.__reqData['id'], stockProductId=new_stockProductId, newPrice=newPrice, newHHcoin=newHHcoin, limitnum=limitnum) print(sql1) mysql.insertOne(sql1) sql = "UPDATE product, spec SET product.act_num='{actid}', product.limitNum='{limitnum}', \ spec.limitNum='{limitnum}', spec.acti_hehecoin='{newHHcoin}', \ spec.acti_price='{newPrice}' \ WHERE spec.productId = product.id \ AND spec.id='{stockProductId}'" .format\ (actid=self.__reqData['id'], limitnum=limitnum, newHHcoin=newHHcoin, newPrice=newPrice, stockProductId=new_stockProductId) mysql.update(sql) print(sql) iswin = 1 else: iswin = 2 else: iswin = 0 mysql.dispose() return iswin
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): stock_id = request.POST.get('stock_id') try: mysql = Mysql() sql = "UPDATE stock SET state = 0 WHERE id = %s" mysql.update(sql, param=[stock_id]) mysql.dispose() return JsonResponse({'ret': 0, 'msg': '删除成功'}) except Exception as e: print(e) mysql.errdispose() return JsonResponse({'ret': -2, 'msg': '删除失败'})
def post(self, request): order_num = request.POST.get('order_num') mysql = Mysql() sql = f"UPDATE orders SET state = '7' WHERE orderNum = '{order_num}'" try: mysql.update(sql) mysql.dispose() return HttpResponse(1) except Exception as e: print(e) mysql.errdispose() return HttpResponse(0)
def post(self, request): school_id = request.POST.get('school_id') address = str(request.POST.get('address')) mysql = Mysql() sql = "INSERT INTO school_address SET school_id='{school_id}', \ address='{address}'".format(school_id=school_id, address=address) suc = mysql.insertOne(sql) if suc: mysql.dispose() return HttpResponse(1) mysql.errdispose() return HttpResponse(0)
def post(self, request): product_id = request.POST.get('product_id') mysql = Mysql() try: sql = "UPDATE product SET label='0' WHERE id=%s" mysql.update(sql, param=[product_id]) 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') num = float(request.POST.get('num')) mysql = Mysql() sql = "UPDATE prize_phv SET num='{num}' WHERE prize_id='{prize_id}'".format(prize_id=prize_id, num=num) try: mysql.update(sql) mysql.dispose() return HttpResponse(1) except Exception as e: print(e) 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 merPayOrder(self): mysql = Mysql() # 更新订单 sql = "UPDATE mer_pay SET wxid = %s, wx_money = %s, \ state = 1, pay_time=NOW() WHERE order_num = %s" state = mysql.update(sql, param=[ self.Info['wxid'], self.Info['total_fee'], self.Info['orderNum'] ]) mysql.update(sql) mysql.dispose()
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): area_name = request.POST.get('area_name') area_id = request.POST.get('area_id') mysql = Mysql() sql = "UPDATE school_area SET area_name='{area_name}' WHERE \ id='{area_id}' ".format(area_name=area_name, area_id=area_id) try: mysql.update(sql) mysql.dispose() return HttpResponse(1) except Exception as e: print(e) mysql.errdispose() return HttpResponse(0)
def get(self, request): order_num = request.GET.get('order_num') mysql = Mysql() sql = f"SELECT * FROM as_orders WHERE order_id = '{order_num}'" info = mysql.getOne(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)
def post(self, request): class_id = request.POST.get('class_id') class_name = request.POST.get('class_name') mysql = Mysql() sql = "UPDATE prize_class SET class_name = '{class_name}' WHERE \ id = '{class_id}'".format(class_name=class_name, class_id=class_id) try: mysql.update(sql) mysql.dispose() return HttpResponse(1) except Exception as e: print(e) mysql.errdispose() return HttpResponse(0)
def post(self, request): banner = request.POST.get('banner') title = request.POST.get('title') details = html.escape(request.POST.get('details')) profile = request.POST.get('profile') mysql = Mysql() sql = f"INSERT INTO information SET banner='{banner}', \ title='{title}', details='{details}', profile='{profile}'" suc = mysql.insertOne(sql) if suc: mysql.dispose() return HttpResponse(1) mysql.errdispose() return HttpResponse(0)
def post(self, request, **payload): try: user_id = payload.get('user_id') address = request.POST.get('address') handle_type = request.POST.get('handle_type') if handle_type == 'finish': if not address: return JsonResponse({'ret': -2, 'msg': '地址数据为空'}) mysql = Mysql() sql = "SELECT * FROM user_star_sign WHERE user_id = %s FOR UPDATE" mysql.getOne(sql, param=[user_id]) sql = "SELECT * FROM user_star_sign WHERE \ user_id = %s \ AND one > 0 \ AND two > 0 \ AND three > 0 \ AND four > 0 \ AND five > 0 \ AND six > 0 \ AND seven > 0 \ AND eight > 0 \ AND nine > 0 \ AND ten > 0 \ AND eleven > 0 \ AND twelve > 0 \ AND state = 0" check = mysql.getOne(sql, param=[user_id]) if not check: mysql.dispose() return JsonResponse({'ret': -2, 'msg': '碎片不足或已被领取'}) sql = "UPDATE user_star_sign SET address = %s, \ state = 1 WHERE user_id = %s" mysql.update(sql, param=[address, user_id]) patch_type = [i for i in range(1, 13)] getPatch(user_id, patch_type, 11, 0, mysql) mysql.dispose() return JsonResponse({'ret': 0, 'msg': '领取成功'}) if handle_type == 'update': mysql = Mysql() sql = "SELECT * FROM user_star_sign WHERE state = 1 \ AND user_id = %s FOR UPDATE" user_info = mysql.getOne(sql, param=[user_id]) if not user_info: mysql.dispose() return JsonResponse({'ret': -2, 'msg': '网络繁忙'}) sql = "UPDATE user_star_sign SET address = %s \ WHERE user_id = %s AND state = 1" mysql.update(sql, param=[address, user_id]) mysql.dispose() return JsonResponse({'ret': 0, 'msg': '领取成功'}) return JsonResponse({'ret': -2, 'msg': '参数错误'}) except Exception as e: mysql.errdispose() erroLog(e) return JsonResponse({'ret': -2, 'msg': '网络错误'})
def get(self, request): order_num = request.GET.get('order_num') #订单编号 mysql = Mysql() sql = f"SELECT * FROM ordergoods WHERE order_id = '{order_num}'" info = mysql.getAll(sql) mysql.dispose() if info: info = json.dumps(info, ensure_ascii=True, sort_keys=False, indent=4) return HttpResponse(info) else: return HttpResponse(0)