def post(self, request, **payload): handle = payload.get('handle') self.info['user_id'] = payload.get('user_id') self.info['img'] = request.POST.get('img') self.info['wxname'] = request.POST.get('wxname') self.info['unionid'] = request.POST.get('unionid') if handle == 'sel': return self.getData() if handle == 'update': erro_list = ['[object Object]'] if self.info['unionid'] in erro_list or not self.info['unionid']: return HttpResponse(returnJson(-2, '参数错误')) return self.update() if handle == 'debug': err_info = request.POST.get('err_info') sql = 'INSERT INTO erro_log SET erro_detail = %s' mysql = Mysql() mysql.insertOne(sql, param=[err_info]) mysql.dispose() return HttpResponse(returnJson(0, '记录成功')) return HttpResponse(returnJson(-2, '非法路径'))
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 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 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 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 merCart(self, state): cache_name = str(self.params['user_id']) + 'mercart' if state == 'edit': open_redis = Open_Redis().getConn(1) open_redis.set(cache_name, self.params['cart_info'], ex=9000) return HttpResponse(returnJson(0, '操作成功')) if state == 'get': open_redis = Open_Redis().getConn(1) info = open_redis.get(cache_name) info = json.loads(info) if info else [] return HttpResponse(returnJson(0, '查询成功', info)) return HttpResponse(returnJson(-2, '非法路径'))
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 post(self, request): try: phone = request.POST.get('phone') code = request.POST.get('code') conn = Open_Redis().getConn(7) if conn.exists(phone): cache = conn.get(phone) if cache.decode('utf-8') != code: return HttpResponse(returnJson(-2, '验证码失效')) token = getToken({'user_id' : 907}, 24) token = {'token' : token} return HttpResponse(returnJson(0, '登录成功', result=token)) return HttpResponse(returnJson(-1, '不存在验证码请重新发送')) except Exception as e: erroLog(e) return HttpResponse(returnJson(-2, '网络错误'))
def see(self): sql = "SELECT \ c.id as cart_id, \ c.num, \ c.store_id, \ s.id, \ s.stock_name, \ s.img, \ s.product_id, \ s.stock_detail, \ s.upper_shelf, \ s.price, \ s.hehecoin, \ p.user_goods_limit, \ s.stock_num \ FROM \ cart AS c \ LEFT JOIN stock AS s ON c.stock_id = s.id \ LEFT JOIN product AS p ON s.product_id = p.id \ WHERE \ c.userid = %s \ ORDER BY \ c.handletime DESC" info = query(sql, param=[self.info['user_id']]) return HttpResponse(returnJson(0, '查询成功', info))
def see(self): sql = "SELECT checkTime FROM click_card \ WHERE userid = %s AND checkTime LIKE %s" info = query( sql, param=[self.info['user_id'], '%' + self.info['check_time'] + '%']) return HttpResponse(returnJson(0, '打卡成功', info))
def post(self, request, **payload): is_school = int(request.POST.get('is_school')) #0个人 1学校 if is_school == 0: sql = "SELECT * FROM last_ranklist" else: sql = "SELECT * FROM last_school_ranklist" info = query(sql) return HttpResponse(returnJson(0, '查询成功', info))
def post(self, request, **payload): self.params = {} self.params['start_time'] = request.POST.get('start_time') self.params['end_time'] = request.POST.get('end_time') self.params['is_school'] = int(request.POST.get('is_school')) # 0个人 1学校 if self.params['is_school'] == 0: sql = f'''SELECT \ SUM(d.wight) AS weight, \ u.id AS user_id, \ u.wxname, \ u.school_id, \ u.user_img, \ s.school_img \ FROM \ deliver AS d \ LEFT JOIN gzh_user AS g ON g.openid = d.openid \ LEFT JOIN userInfo AS u ON u.unionId = g.unionid \ LEFT JOIN school AS s ON u.school_id = s.id \ WHERE \ u.wxname IS NOT NULL \ AND g.openid NOT IN ('oLKbX1JCYRryfJsXPNvl69kNTXFU','oLKbX1BjDWpeyuVFPGzm9H7szvoo', \ 'oLKbX1CXeWasiulsOR-_CeYnlprk', 'oLKbX1KuMDzJe2e46z0WyLAhkKHQ', \ 'oLKbX1O-HV9pXabfE5BWB6jsMbQY', 'oICg44y-TQLpvENQFvVtTUEqXRT8',\ 'oLKbX1Hc8lNNZmNNQcM0WhvbvnhM','oLKbX1OJgSIZrb2Hxi2nYRnRPpTQ', 'oLKbX1GgjlWc155Qk927f7hHhWv8') \ AND d.create_time \ BETWEEN '{START_TIME}' AND '{END_TIME}' \ GROUP BY \ d.openid \ ORDER BY \ weight DESC \ LIMIT 0, \ 100''' else: sql = f'''SELECT \ SUM(d.wight) AS weight, \ u.id AS user_id, \ u.school_id, \ s.school_name, \ s.school_img \ FROM \ deliver AS d \ LEFT JOIN gzh_user AS g ON g.openid = d.openid \ LEFT JOIN userInfo AS u ON u.unionId = g.unionid \ LEFT JOIN school AS s ON u.school_id = s.id \ WHERE \ u.wxname IS NOT NULL \ AND u.school_id is NOT NULL \ AND d.create_time BETWEEN '{START_TIME}' AND '{END_TIME}' \ GROUP BY \ u.school_id \ ORDER BY \ weight DESC \ LIMIT 0, \ 100''' info = query(sql) return HttpResponse(returnJson(0, '查询成功', info))
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 post(self, request): self.info["pwd"] = request.POST.get("pwd") self.info["mobile"] = request.POST.get("mobile") sql = 'select * from users where mobile=%s and password=%s' user_info = queryOne(sql, param=[self.info["mobile"], self.info["pwd"]]) if not user_info: return HttpResponse(returnJson(-2, '登录失败')) payload = {'name': user_info.get('name')} token = getToken(payload, 2) data = { 'isAdmin': user_info.get('isAdmin'), 'name': user_info.get('name'), 'power': user_info.get('power'), 'token': token } return HttpResponse(returnJson(0, '登录成功', data))
def campus(self): sql = "SELECT SUM(d.wight) as wight, s.school_name \ FROM deliver AS d \ LEFT JOIN gzh_user AS g ON d.openid = g.openid \ LEFT JOIN userInfo AS u ON g.unionid = u.unionId \ LEFT JOIN school AS s ON s.id = u.school_id \ LEFT JOIN school_area AS sa ON sa.id = s.area_id \ WHERE u.school_id IS NOT NULL AND sa.id = %s GROUP BY u.school_id" info = query(sql, self.info['area_id']) return HttpResponse(returnJson(0, '查询成功', info))
def checkStep(self): date = datetime.datetime.today().isoformat().split('T')[0] sql = 'select * from coin_log where userid=%s and handleType=3 AND %s = %s' data = queryOne(sql, param=[ self.Info['user_id'], 'date_format(handletime,"%Y-%m-%d")', data ]) data = {'isok': True} if data else {'isok': False} return HttpResponse(returnJson(0, '查询成功', data))
def post(self, request): try: phone = request.POST.get('phone') print(phone) if not phone: print(phone) return HttpResponse(returnJson(-2, '手机号码错误')) conn = Open_Redis().getConn(7) cache = conn.exists(phone) if conn.exists(phone): return HttpResponse(returnJson(-1, '已有验证码 请勿重新发送')) code = sendSms(phone) if code: code = {'code' : code} return HttpResponse(returnJson(0, '成功', code)) return HttpResponse(returnJson(-2, '验证码发送失败')) except Exception as e: erroLog(e) return HttpResponse(returnJson(-2, '网络繁忙'))
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 do(self): mysql = Mysql() sql = "select * from click_card where \ to_days(checkTime)=to_days(now()) AND userid=%s" check = mysql.getOne(sql, param=[self.info['user_id']]) if check: # 已经打卡 mysql.dispose() return HttpResponse(returnJson(-2, '重复打卡')) # 打卡 sql = "INSERT INTO click_card SET userid = %s" suc = mysql.insertOne(sql, param=[self.info['user_id']]) up_sql, log_sql = Type_Log.coin_handle(user_id=self.info['user_id'], handle=2, num=10, asd=1) mysql.update(up_sql) mysql.insertOne(log_sql) mysql.dispose() return HttpResponse(returnJson(0, '打卡成功'))
def edit(self): if not isinstance(self.info['num'], int) or int(self.info['num']) <= 0: return HttpResponse(returnJson(-2, '商品数量出现错误')) mysql = Mysql() #新增数量判断 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) \ WHERE s.id = %s" product_id = mysql.getOne(sql, param=[self.info['stock_id']]) if not product_id: mysql.dispose() return HttpResponse(returnJson(-2, "库存编号错误")) if int(product_id.get('user_goods_limit')) > 0: limits = int(product_id.get('limits')) + num if product_id.get( 'limits') else num if limits > int(product_id.get('user_goods_limit')): mysql.dispose() return HttpResponse(returnJson(-2, "超出限量限制")) sql = "UPDATE cart SET num = %s WHERE userid = %s AND \ stock_id = %s AND store_id = %s" suc = mysql.update(sql, param=[ self.info['num'], self.info['user_id'], self.info['stock_id'], self.info['store_id'] ]) mysql.dispose() return HttpResponse(returnJson(0, "修改数量成功"))
def post(self, request, **payload): handle = payload.get('handle') self.info['user_id'] = payload.get('user_id') self.info['check_time'] = request.POST.get('check_time') if handle == 'do': return self.do() if handle == 'see': return self.see() return HttpResponse(returnJson(-2, '非法路径'))
def toBalance(self): mysql = Mysql() sql = "SELECT * FROM userInfo WHERE id = %s FOR UPDATE" user_info = mysql.getOne(sql, param=[self.info['user_id']]) user_hhcoin = user_info.get('hhcoin') if int(self.info['hhcoin']) > user_hhcoin or int(self.info['hhcoin']) <= 0: mysql.dispose() return HttpResponse(returnJson(-2, '传入金额出现问题')) up_sql, log_sql = Type_Log.coin_handle(user_id=self.info['user_id'], handle=13, num=self.info['hhcoin'], asd=0) mysql.update(up_sql) mysql.insertOne(log_sql) up_sql, log_sql = Type_Log.balance_log(user_id=self.info['user_id'], handle=13, money=self.info['hhcoin'], asd=1) mysql.update(up_sql) mysql.insertOne(log_sql) mysql.dispose() return HttpResponse(returnJson(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 do(self): mysql = Mysql() # 查答案 sql = "SELECT is_right FROM quiz_bank WHERE id = %s AND quiz_id = %s" check = mysql.getOne(sql, param=[self.info['answer_id'], self.info['quiz_id']]) right = int(check.get('is_right')) # 插记录 sql = "INSERT INTO quiz_log SET user_id = %s, \ quiz_id = %s, answer_id=%s, is_right = %s" mysql.insertOne(sql, param=[ self.info['user_id'], self.info['quiz_id'], self.info['answer_id'], right ]) # 放奖励 if right == 1: sql = "UPDATE userInfo SET correct = correct + 1 WHERE id = %s" mysql.update(sql, param=[self.info['user_id']]) up_sql, log_sql = Type_Log.coin_handle( user_id = self.info['user_id'], handle=7, num=15, asd=1) mysql.update(up_sql) mysql.insertOne(log_sql) mysql.dispose() return HttpResponse(returnJson(0, '答题成功', {'state' : 1})) else: sql = "SELECT id FROM quiz_bank WHERE quiz_id = %s AND is_right = 1" real_answer = mysql.getOne(sql, param=[self.info['quiz_id']]) sql = "UPDATE userInfo SET correct = 0 WHERE id = %s" mysql.update(sql, param=[self.info['user_id']]) mysql.dispose() data = { 'real_answer' : real_answer.get('id'), 'state' : 0 } return HttpResponse(returnJson(0, '答题成功', data))
def post(self, request, **payload): handle = payload.get('handle') #参数 self.params['user_id'] = payload.get('user_id') self.params['mer_id'] = request.POST.get('mer_id') self.params['mer_type'] = request.POST.get('mer_type') self.params['product_id'] = request.POST.get('product_id') self.params['cart_info'] = request.POST.get('cart_info') self.params['page'] = request.POST.get('page') self.params['row'] = request.POST.get('row') #pay self.params['sum_money'] = request.POST.get('sum_money') #order self.params['phone'] = request.POST.get('phone') self.params['name'] = request.POST.get('name') if handle == 'selMerList': return self.selMerList() if handle == 'selHotMer': return self.selHotMer() if handle == 'selRandMer': return self.selRandMer() if handle == 'selProduct': return self.selProduct() if handle == 'selProducts': return self.selProducts() if handle == 'selProductDetail': return self.selProductDetail() if handle == 'addMerHot': return self.addMerHot() if handle == 'merCart': state = payload.get('state') return self.merCart(state) if handle == 'payOrder': return self.payOrder() if handle == 'merPay': return self.merPay() return HttpResponse(returnJson(-2, '非法路径'))
def getData(self): mysql = Mysql() sql = 'SELECT \ u.money, u.hhcoin, \ s.school_name, \ s.school_img, \ s.id as school_id, \ u.openid, \ u.id as user_id, \ u.mobile, \ u.wxname \ FROM \ userInfo AS u \ LEFT JOIN school AS s ON u.school_id = s.id \ WHERE u.id = %s' data = mysql.getOne(sql, param=[self.info['user_id']]) #------增加盒盒币 sql = '''SELECT \ d.id as did, \ d.hhcoin, \ d.state, \ u.id, \ u.openid \ FROM \ deliverCoin AS d \ LEFT JOIN gzh_user AS g ON d.gzh_openid = g.openid \ LEFT JOIN userInfo AS u ON u.unionId = g.unionid \ WHERE u.unionId IS NOT NULL AND d.state = 0 AND u.openid = %s \ GROUP BY d.id ''' info = mysql.getAll(sql, param=[data.get('openid')]) if info: for i in info: if i.get('hhcoin') != 0: up_sql, ins_sql = Type_Log.coin_handle(user_id=i.get('id'), handle=5, num=i.get('hhcoin'), asd=1) up_suc = mysql.update(up_sql) ins_suc = mysql.insertOne(ins_sql) sql = "UPDATE deliverCoin SET state = 1 WHERE id = %s" mysql.update(sql, param=[i.get('did')]) mysql.dispose() return HttpResponse(returnJson(0, '查询成功', data))
def selProductDetail(self): 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 mysql.dispose() return HttpResponse(returnJson(0, '查询成功', data))
def post(self, request, **payload): handle = payload.get('handle') self.info['user_id'] = payload.get('user_id') self.info['stock_id'] = request.POST.get('stock_id') self.info['num'] = request.POST.get('num') self.info['store_id'] = request.POST.get('store_id') self.info['cart_id'] = request.POST.get('cart_id') if handle == 'see': return self.see() if handle == 'edit': return self.edit() if handle == 'add': return self.add() if handle == 'del': return self.del_() return HttpResponse(returnJson(-2, '非法路径'))
def post(self, request, **payload): sql = "SELECT mchState, address, addremark, jd, wd, zhi_weight, shu_weight, `Repair` \ FROM machine WHERE (jd AND wd) IS NOT NULL AND (jd AND wd) != ''" info = query(sql) return HttpResponse(returnJson(0, '查询成功', info))
def post(self, request, **payload): ''' 获取解密后的微信步数以及VIP信息 ''' handle = payload.get('handle') self.Info['openid'] = payload.get('openid') self.Info['sessionKey'] = payload.get('session_key') self.Info['user_id'] = payload.get('user_id') #用来判断是获取手机号还是微信步数, 0获取手机号, 1获取步数, 2获取unionid self.Info['iv'] = request.POST.get('iv') #加密算法的初始向量 self.Info['encryptedData'] = request.POST.get('encryptedData') self.Info["jscode"] = request.POST.get("jscode") if handle == "getPhone": data = self.get_data() print(data) phone = data.get('phoneNumber') self.save_data(data.get('phoneNumber')) return HttpResponse(returnJson(0, '获取手机号成功', {'phone': phone})) if handle == "getUnionid": data = self.get_data() print(data) unionId = data.get('unionId') return HttpResponse(returnJson(0, '获取数据成功', {'unionid': unionId})) if handle == 'checkStep': data = self.get_data() print(data) return self.checkStep() if handle == "getStep": data = self.get_data() print(data) stepInfoList = data.get('stepInfoList') yes_step = self.parse_stepnum(stepInfoList) mysql = Mysql() sql = "SELECT * FROM coin_log WHERE userid = %s \ AND handleType = 3 AND to_days(handletime) = to_days(now()) " check = mysql.getOne(sql, param=[self.Info['user_id']]) if check: mysql.dispose() return HttpResponse( returnJson(0, '获取数据成功', {'yes_step': yes_step})) else: hhcoin = 30 if int(int(yes_step) / 500) >= 30 else int( int(yes_step) / 500) up_sql, log_sql = Type_Log.coin_handle( user_id=self.Info['user_id'], handle=3, num=hhcoin, asd=1) mysql.update(up_sql) mysql.insertOne(log_sql) mysql.dispose() data = {"yes_step": yes_step, "hhcoin": hhcoin} return HttpResponse(returnJson(0, '获取数据成功', data)) if handle == 'getOpenid': return self.getOpenid() if handle == 'checkToken': return self.checkToken(request) return HttpResponse(returnJson(-2, '非法路径'))