def post(self, request): try: self.info['product_id'] = request.POST.get('product_id') self.info['productTypeId'] = request.POST.get('type_id') self.info['productName'] = request.POST.get('product_name') self.info['productImg'] = request.POST.get('product_img') self.info['hehecoin'] = request.POST.get('hhcoin') self.info['price'] = request.POST.get('price') self.info['remark'] = request.POST.get('remark') self.info['notes'] = request.POST.get('notes') self.info['user_goods_limit'] = request.POST.get( 'user_goods_limit') #个人总限量 mysql = Mysql() sql = "UPDATE product SET productTypeId=%s, productName=%s,\ productImg=%s, hehecoin=%s, minPrice=%s, user_goods_limit=%s,\ maxPrice=%s, remark=%s, notes=%s WHERE id=%s" mysql.update(sql, param=[ self.info['productTypeId'], self.info['productName'], self.info['productImg'], self.info['hehecoin'], self.info['price'], self.info['user_goods_limit'], self.info['price'], self.info['remark'], self.info['notes'], self.info['product_id'] ]) mysql.dispose() return JsonResponse({'ret': 0, 'msg': '编辑商品成功'}) except Exception as e: print(e) mysql.errdispose() erroLog(e) return JsonResponse({'ret': -2, 'msg': '编辑商品失败'})
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 post(self, request, **payload): user_id = payload.get('user_id') handle = payload.get('handle') address_id = request.POST.get('address_id') mysql = Mysql() if handle == 'edit': sql = "UPDATE userInfo SET address_id=%s WHERE id=%s" mysql.update(sql, param=[address_id, user_id]) mysql.dispose() return HttpResponse(returnJson(0, '更新成功')) if handle == 'get': mysql = Mysql() sql = "SELECT address_id from userInfo WHERE id=%s" info = mysql.getOne(sql, param=[user_id]) mysql.dispose() info = info if info else [] return HttpResponse(returnJson(0, '查询成功', info)) if handle == 'del': mysql = Mysql() sql = "UPDATE userInfo SET address_id = null WHERE id=%s" mysql.update(sql, param=[user_id]) mysql.dispose() return HttpResponse(returnJson(0, '删除成功')) if handle == 'default': pass else: return HttpResponse(returnJson(-2, '参数错误'))
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 save_data(self): try: mysql = Mysql() for i in range(3): lottery_code = self.ran(6) sql = "SELECT * from oneyuanpurchase WHERE order_num = %s AND lottery_code IS NULL limit 1" order_id = mysql.getOne(sql, param=[self.Info['orderNum']]) sql = "UPDATE oneyuanpurchase SET lottery_code = %s, state = 1, \ is_get=0, wxid = %s, wx_money = %s WHERE id = %s" mysql.update(sql, param=[ lottery_code, self.Info['wxid'], self.Info['total_fee'], order_id.get('id') ]) sql = "SELECT user_id FROM oneyuanpurchase WHERE order_num = %s" user = mysql.getOne(sql, param=[self.Info['orderNum']]) up_sql, log_sql = Type_Log.coin_handle( user_id=user.get('user_id'), handle=12, num=10, asd=1) mysql.update(up_sql) mysql.insertOne(log_sql) mysql.dispose() except Exception as e: print(e) mysql.errdispose()
def post(self, request): try: unionid = request.POST.get('unionid') position = request.POST.get('position') mysql = Mysql() sql = "SELECT * FROM h5_user WHERE unionid = %s FOR UPDATE" user_info = mysql.getOne(sql, param=[unionid]) if not user_info: mysql.dispose() return JsonResponse({'ret': -2, 'msg': '无用户信息'}) sql = 'SELECT * FROM gzh_user WHERE unionid = %s AND state = 1' gzh_info = mysql.getOne(sql, param=[unionid]) if not gzh_info: mysql.dispose() return JsonResponse({'ret': -1, 'msg': '未关注公众号'}) sql = "SELECT COUNT(*) AS numbers FROM h5_luckdraw_log \ WHERE unionid = %s AND create_time BETWEEN %s AND %s" numbers = mysql.getOne( sql, param=[unionid, self.START_TIME, self.END_TIME]) if numbers: if numbers.get('numbers') >= 12: mysql.dispose() return JsonResponse({'ret': -2, 'msg': '当日抽奖次数达到上限'}) if user_info.get('lucky_draw_times') < 1: mysql.dispose() return JsonResponse({'ret': -2, 'msg': '抽奖次数不足'}) sql = 'SELECT * FROM h5_luckdraw_log WHERE unionid = %s \ AND position = %s AND create_time BETWEEN %s AND %s' luckdraw_postion = mysql.getOne( sql, param=[unionid, position, self.START_TIME, self.END_TIME]) if luckdraw_postion: mysql.dispose() return JsonResponse({'ret': -2, 'msg': '网络繁忙'}) sql = "UPDATE h5_user SET lucky_draw_times = \ lucky_draw_times - 1 WHERE unionid = %s" mysql.update(sql, param=[unionid]) patch_id = randomH5Patch() sql = "INSERT INTO h5_luckdraw_log SET unionid = %s, \ patch_id = %s, state = 0, position=%s" mysql.insertOne(sql, param=[unionid, patch_id, position]) mysql.dispose() return JsonResponse({ 'ret': 0, 'msg': '抽奖成功', 'result': { 'patch_id': patch_id, 'patch_name': STAR_SIGIN[patch_id] } }) except Exception as e: mysql.errdispose() erroLog(e) return JsonResponse({'ret': -2, 'msg': '网络错误'})
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 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): 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): 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 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): 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 update(self): mysql = Mysql() sql = "SELECT * FROM userInfo WHERE id = %s FOR UPDATE" mysql.getOne(sql, param=[self.info['user_id']]) sql = "update userInfo set wxname=%s, user_img=%s, \ unionId=%s where id = %s" mysql.update(sql, param=[ self.info['wxname'], self.info['img'], self.info['unionid'], self.info['user_id'] ]) mysql.dispose() return HttpResponse(returnJson(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): prize_id = request.POST.get('prize_id') stock_numb = request.POST.get('stock_numb') stock_id = request.POST.get('stock_id') mysql = Mysql() try: sql = "UPDATE prize_stock SET stock_id = '{stock_id}', stock_numb ='{stock_numb}' \ WHERE prize_id = '{prize_id}'".format(prize_id=prize_id, stock_numb=stock_numb, stock_id=stock_id) mysql.update(sql) mysql.dispose() return HttpResponse(1) except Exception as e: print(e) mysql.errdispose() return HttpResponse(0)
def post(self, request): try: mysql = Mysql() product_id = request.POST.get('product_id') sql = "UPDATE product SET upper_shelf = 0 WHERE id = %s" mysql.update(sql, param=[product_id]) sql = "UPDATE stock SET upper_shelf = 0 WHERE product_id = %s" mysql.update(sql, param=[product_id]) mysql.dispose() return JsonResponse({'ret': 0, 'msg': '下架成功'}) except Exception as e: mysql.errdispose() print(e) return JsonResponse({'ret': -2, 'msg': '下架失败'})
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 post(self, request): try: stock_json = json.loads(request.POST.get('stock_json')) mysql = Mysql() sql = "UPDATE stock SET price=%s, \ hehecoin=%s, img=%s, upper_shelf=1,\ stock_detail=%s, buying_price=%s WHERE id=%s" suc = mysql.update( sql, [ stock_json.get('price'), stock_json.get('hehecoin'), stock_json.get('img'), #首张图片(关系到购物车) stock_json.get('stock_guige'), stock_json.get('buying_price'), stock_json.get('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') #订单编号 express_num = request.POST.get('express_num') # 快递单号 mysql = Mysql() sql = f"UPDATE orders SET state = '2', express_num = '{express_num}' WHERE state = '1' \ AND orderNum = '{order_num}'" print(sql) try: 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['mer_id'] = int(request.POST.get('mer_id')) self.params['mer_address'] = request.POST.get('mer_address') self.params['mer_name'] = request.POST.get('mer_name') self.params['mer_slogan'] = request.POST.get('mer_slogan') self.params['mer_longitude'] = float( request.POST.get('mer_longitude')) #经度 self.params['mer_latitude'] = float( request.POST.get('mer_latitude')) #纬度 self.params['mer_img'] = request.POST.get('mer_img') #商户banner self.params['mer_type'] = int( request.POST.get('mer_type')) #属性1吃的2喝的3玩的 self.params['mer_logo'] = request.POST.get('mer_logo') #商户头像 mer_logo self.params['mer_sales'] = float( request.POST.get('mer_sales')) #折扣 mer_sales mysql = Mysql() sql = "UPDATE merchant SET mer_address='{mer_address}', mer_name='{mer_name}', \ mer_longitude='{mer_longitude}', mer_latitude='{mer_latitude}',mer_img='{mer_img}', \ mer_type='{mer_type}', mer_slogan='{mer_slogan}', mer_logo='{mer_logo}', \ mer_sales='{mer_sales}' WHERE mer_id='{mer_id}'" .format(mer_address=self.params['mer_address'], \ mer_name=self.params['mer_name'], mer_longitude=self.params['mer_longitude'], \ mer_latitude=self.params['mer_latitude'], mer_img=self.params['mer_img'], mer_type=self.params['mer_type'], \ mer_id=self.params['mer_id'], mer_slogan=self.params['mer_slogan'], mer_logo=self.params['mer_logo'], \ mer_sales=self.params['mer_sales']) print(sql) suc = mysql.update(sql) print(suc) if suc: mysql.dispose() return HttpResponse(1) else: mysql.errdispose() return HttpResponse(0)
def post(self, request, **payload): user_id = payload.get('user_id') hot_numbs = int(request.POST.get('hot_numbs')) mer_id = request.POST.get('mer_id') if hot_numbs > 5 or hot_numbs < 1: return HttpResponse(0) mysql = Mysql() sql = "SELECT id FROM mer_hots WHERE mer_id = %s AND user_id = %s" check = mysql.getOne(sql, param=[mer_id, user_id]) if check: mysql.dispose() return HttpResponse(2) sql = "INSERT INTO mer_hots SET mer_id = %s, user_id = %s, hots = %s" ins_suc = mysql.insertOne(sql, param=[mer_id, user_id, hot_numbs]) sql = "UPDATE merchant SET mer_hot = mer_hot + %s, \ mer_hot_numbs = mer_hot_numbs + 1 WHERE mer_id = %s" up_suc = mysql.update(sql, param=[hot_numbs, mer_id]) if up_suc and ins_suc: mysql.dispose() return HttpResponse(1) mysql.errdispose() return HttpResponse(0)
def save_data(self): mysql = Mysql() try: order_num = self.Info['orderNum'] wxid = self.Info['wxid'] sql = f'''update orders set state = 1, wxid="{wxid}, payTime = NOW()" \ where orderNum="{order_num}"''' mysql.update(sql) bu_id = order_num[0:order_num.find('kanjia')] print(bu_id) sql = f"UPDATE bargain_user SET state = 0 WHERE id = {bu_id}" mysql.update(sql) mysql.dispose() except Exception as e: print(e) mysql.errdispose()
def addMerHot(self): self.params['hot_numbs'] = int(request.POST.get('hot_numbs')) if self.params['hot_numbs'] > 5 or self.params['hot_numbs'] < 1: return HttpResponse(returnJson(-2, '增加热度失败')) mysql = Mysql() sql = "SELECT id FROM mer_hots WHERE mer_id = %s AND user_id = %s" check = mysql.getOne( sql, param=[self.params['mer_id'], self.params['user_id']]) if check: mysql.dispose() return HttpResponse(returnJson(-2, '已增加过热度,不能重复')) sql = "INSERT INTO mer_hots SET mer_id = %s, user_id = %s, hots = %s" ins_suc = mysql.insertOne(sql, param=[ self.params['mer_id'], self.params['user_id'], self.params['hot_numbs'] ]) sql = "UPDATE merchant SET mer_hot = mer_hot + %s, \ mer_hot_numbs = mer_hot_numbs + 1 WHERE mer_id = %s" up_suc = mysql.update( sql, param=[self.params['hot_numbs'], self.params['mer_id']]) mysql.dispose() return HttpResponse(returnJson(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 save_data(self): try: 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() except Exception as e: erroLog(e) print(e)
def post(self, request): address_id = request.POST.get('address_id') school_id = request.POST.get('school_id') address = request.POST.get('address') mysql = Mysql() sql = "UPDATE school_address SET school_id='{school_id}', \ address='{address}' WHERE id='{address_id}'".format( school_id=school_id, address=address, address_id=address_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): try: mysql = Mysql() sql = "SELECT product_id, new_img FROM stock \ WHERE product_id IS NOT NULL GROUP BY product_id " store_info = mysql.getAll(sql) for i in store_info: sql = "UPDATE product SET productImg=%s WHERE id=%s" mysql.update(sql, param=[i.get('new_img'), i.get('product_id')]) mysql.dispose() return HttpResponse(1) except Exception as e: mysql.errdispose() return HttpResponse(0)
def post(self, request, **payload): handle = payload.get('handle') self.info['user_id'] = payload.get('user_id') self.info['school_id'] = request.POST.get('school_id') self.info['school_name'] = request.POST.get('school_name') if handle == 'see': sql = "SELECT * FROM school WHERE school_name LIKE %s" self.info['school_name'] = '%' + self.info['school_name'] + '%' info = query(sql, param=[self.info['school_name']]) return HttpResponse(returnJson(0, '查询成功', info)) if handle == 'update': mysql = Mysql() sql = "SELECT hhcoin, school_id FROM userInfo WHERE id = %s FOR UPDATE" info = mysql.getOne(sql, param=[self.info['user_id']]) #已经绑定有 扣除盒盒币 if info.get('school_id'): if int(info.get('hhcoin')) >= 1000: up_sql, log_sql = Type_Log.coin_handle( user_id=self.info['user_id'], handle=0, num=1000, asd=0) mysql.update(up_sql) mysql.insertOne(log_sql) sql = "UPDATE userInfo SET school_id = %s WHERE id = %s" mysql.update( sql, param=[self.info['shcool_id'], self.info['user_id']]) mysql.dispose() return HttpResponse(returnJson(0, '绑定成功')) #盒盒币不足 返回2 else: return HttpResponse(returnJson(-2, '盒盒币不足')) #首次绑定 else: sql = "UPDATE userInfo SET school_id = %s WHERE id = %s" suc = mysql.update( sql, param=[self.info['school_id'], self.info['user_id']]) mysql.dispose() return HttpResponse(returnJson(0, '绑定成功')) return HttpResponse(returnJson(-2, '非法路径'))
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': '网络错误'})