def get(self, *args, **kwargs): data_box = {} user_all = sess.query(User).all() num = sess.query(func.count(User.id)).scalar() data_box['user_all'] = user_all data_box['num'] = num self.render('../templates/admin_page/user-list.html', **data_box)
def get(self, *args, **kwargs): data_box = {} category = sess.query(Category).filter(Category.parent_id == 0) category2 = sess.query(Category).filter( Category.parent_id.in_([cate.id for cate in category])) data_box['category_data1'] = category data_box['category_data2'] = category2 self.render('../templates/admin_page/product-category-add.html', **data_box)
def get(self, *args, **kwargs): num = sess.query(func.count(Category.id)).scalar() category1 = sess.query(Category).filter(Category.parent_id == 0) data_box = { 'num': num, 'category_data': category1, } self.render('../templates/admin_page/product-category.html', **data_box)
def get(self, *args, **kwargs): # 获取回调的code code = self.get_argument('code') # 微博认证地址 access_token_url = "https://api.weibo.com/oauth2/access_token" # 参数 向新浪接口发送请求 re_dict = requests.post(access_token_url, data={ "client_id": '2636039333', "client_secret": "4e2fbdb39432c31dc5c2f90be3afa5ce", "grant_type": "authorization_code", "code": code, "redirect_uri": "http://127.0.0.1:8000/md_admin/weibo", }) re_dict = re_dict.text re_dict = eval(re_dict) uid = str(re_dict.get('uid')) if uid: # nick = '新浪微博登录的'+uid _user = sess.query(User).filter(User.username == uid).first() encoded_jwt = jwt.encode({'u_name': _user.username}, settings.jwt_code, algorithm='HS256') token = str(encoded_jwt, 'utf-8') if _user: self.redirect( 'http://127.0.0.1:8080/?u_name={}token={}'.format( _user.username, token)) else: user = User(username=uid, password=settings.PASSWORD, nick=uid, phone='', attributes=1) encoded_jwt = jwt.encode({'u_name': user.username}, settings.jwt_code, algorithm='HS256') token = str(encoded_jwt, 'utf-8') try: sess.add(user) _user = sess.query(User).filter( User.username == uid).first() self.redirect( 'http://127.0.0.1:8080/?u_name={}token={}'.format( _user.username, token)) except: pass else: # self.write(re_dict) self.redirect('http://127.0.0.1:8080/login')
def get(self, *args, **kwargs): id = self.get_argument('id') goods = sess.query(Goods).filter(Goods.id == id).first() if goods.is_shelves == 1: goods = sess.query(Goods).filter(Goods.id == id).first() goods.is_shelves = 0 self.redirect('/admin/goods_list') else: goods = sess.query(Goods).filter(Goods.id == id).first() goods.is_shelves = 1 self.redirect('/admin/goods_list')
def get(self, *args, **kwargs): id = self.get_argument('id') cname = self.get_argument('cname') num = sess.query(func.count(Category.id)).scalar() category1 = sess.query(Category).filter(Category.parent_id == id) data_box = { 'num': num, 'cname': cname, 'category_data': category1, } self.render('../templates/admin_page/product-category3.html', **data_box)
def infinite(goodsList, id, num, start): # 获取该分类下所有商品 good = sess.query( Goods.gname, Goods.id, Goods.price, GoodsImg.image, GoodsImg.img_order, Goods.describe).join(GoodsImg, GoodsImg.goods_id == Goods.id).filter( and_(Goods.cate_id == id, GoodsImg.img_order == 1)).limit(num).offset(start).all() cate2 = sess.query(Category).filter(Category.parent_id == id).all() for i in good: goodsList.append(i) if len(cate2) == 0: pass else: for j in cate2: infinite(goodsList, j.id, num, start)
def get(self, *args, **kwargs): id = self.get_argument('id') if id: img = sess.query(GoodsImg).filter(GoodsImg.id == id).first() sess.delete(img) sess.commit() self.redirect('/admin/picture')
def get(self, *args, **kwargs): mes = {} id = self.get_argument('id') goods = sess.query( Goods.gname, Goods.id, Goods.price, GoodsImg.image).join( GoodsImg, GoodsImg.goods_id == Goods.id).filter(Goods.id == id).first() img = sess.query(GoodsImg).filter(GoodsImg.goods_id == id).all() mes['img'] = img mes['goods'] = goods mes['code'] = 200 mes['message'] = '发送分类成功' self.write( json.dumps(mes, cls=AlchemyEncoder, ensure_ascii=False, indent=4))
def post(self, *args, **kwargs): mes = {} u_name = self.get_argument('u_name') pwd = self.get_argument('pwd') if not all([u_name, pwd]): mes['code'] = 400 mes['message'] = '请输入账号密码' self.write(json.dumps(mes)) else: user = sess.query(User).filter(User.username == u_name).first() if user is not None: if user.password != pwd: mes['code'] = 400 mes['message'] = '密码错误' self.write(json.dumps(mes)) else: encoded_jwt = jwt.encode({'u_name': user.username}, settings.jwt_code, algorithm='HS256') mes['code'] = 200 mes['token'] = str(encoded_jwt, 'utf-8') mes['message'] = '登录成功' self.write(json.dumps(mes)) else: mes['code'] = 400 mes['message'] = '该账号不存在' self.write(json.dumps(mes))
async def post(self): tinymceHtml = self.get_argument('tinymceHtml') goods_id = self.get_argument('goods_id') gname = self.get_argument('gname') u_name = self.get_argument('u_name') # 1. 查询当前用户是否购买过该商品 买过--->可以评论 没买过--->不能评论 # 通过u_name ---> 查出用户id ---> 查出该用户的所有ststes=1订单(遍历订单获取订单ID) ---> 查询订单详情(获取订单详情字段) # ---> 将json数据取出后遍历获取商品ID # 判断 如果当前商品ID存在详情中商品ID内,则买过,反之没买过 # 2. 将发表的评论存到数据库 # goods = [(json.loads(i[0]))[0]['gname'] for i in sess.query(OrderDetail.goodslist).join(Order,Order.id==OrderDetail.order_id).join(User,User.id==Order.user_id).filter(User.username==u_name).all()] goodslist = sess.query(OrderDetail.goodslist, User.id).join( Order, Order.id == OrderDetail.order_id).filter(Order.ststes == 1).join( User, User.id == Order.user_id).filter( User.username == u_name).all() gList = [] id = 0 for i in goodslist: goods = json.loads(i[0]) gname = goods[0]['gname'] gList.append(gname) id = i[-1] if gname in gList: comments = Comments(content=tinymceHtml, user_id=id, goods_id=goods_id) sess.add(comments) sess.commit() self.write(json.dumps({'code': 200, 'mes': '评论成功'})) else: self.write(json.dumps({'code': 100022, 'mes': '没有购买过该商品'}))
def get(self, *args, **kwargs): id = self.get_argument('id') if id: goods = sess.query(Goods).filter(Goods.id == id).first() sess.delete(goods) sess.commit() self.redirect('/admin/goods_list')
def get(self, *args, **kwargs): goodsimg = sess.query(GoodsImg).all() data_box = { 'goodsimg': goodsimg, } self.render('../templates/admin_page/picture-list.html', **data_box)
def get(self, *args, **kwargs): id = self.get_argument('id') category = sess.query(Category).filter(Category.id == id).first() data_box = { 'cname': category.cname, } self.render('../templates/admin_page/cate-modify.html', **data_box)
def post(self, *args, **kwargs): id = self.get_argument('id') cname = self.get_argument('cname') category = sess.query(Category).filter(Category.id == id).first() if cname: category.cname = cname self.redirect('/admin/product_category')
def findend(): from db import sess # logger.debug("findend()") message_id = sess.query(func.max(Message.id)).scalar() if message_id is None: message_id = -1 return message_id
def get(self): id = self.get_argument('id') if id: data_box = {} user_show = sess.query(User).filter(User.id == id).first() data_box['user_show'] = user_show self.render('../templates/admin_page/user-modify.html', **data_box)
async def get(self): mes = {} content = self.get_argument("c") goodsList = sess.query(Goods.gname,Goods.id,Goods.price,GoodsImg.image,GoodsImg.img_order,Goods.describe)\ .join(GoodsImg,GoodsImg.goods_id==Goods.id)\ .filter(Goods.gname.like("%"+content+"%")).all() mes['code'] = 200 mes['goodsList'] = goodsList self.write( json.dumps(mes, cls=AlchemyEncoder, ensure_ascii=False, indent=4))
def get(self, *args, **kwargs): user_id = self.get_cookie('userid') if not user_id: self.redirect('/admin/login') else: print(self.request.uri, '0-0-0-0-0-0-0-0-0') data_box = {} user = sess.query(User).filter(User.id == user_id).first() data_box['user'] = user self.render('../templates/admin_page/index.html', **data_box)
async def post(self): mes = {} code = self.get_argument('code') coupons = sess.query(Coupons).filter(Coupons.code == code).first() if coupons: mes['discount'] = float(coupons.discount) mes['code'] = 200 else: pass self.write( json.dumps(mes, cls=AlchemyEncoder, ensure_ascii=False, indent=4))
def post(self, *args, **kwargs): mes = {} cur = int(self.get_argument('cur', 1)) # 当前页 num = int(self.get_argument('num')) # 每页数量 cateList = sess.query(Category).filter(Category.parent_id == 0).all() goods = sess.query(Goods).all() totalNum = len(goods) start = (cur - 1) * num goodsList = sess.query( Goods.gname, Goods.id, Goods.price, GoodsImg.image, GoodsImg.img_order, Goods.describe).join( GoodsImg, GoodsImg.goods_id == Goods.id).filter( GoodsImg.img_order == 1).limit(num).offset(start).all() print(goodsList) mes['cateList'] = cateList mes['goodsList'] = goodsList mes['count'] = totalNum mes['code'] = 200 mes['message'] = '发送成功' self.write( json.dumps(mes, cls=AlchemyEncoder, ensure_ascii=False, indent=4))
def post(self): id = self.get_argument('id') if id: data_box = {} user_show = sess.query(User).filter(User.id == id).first() nick = self.get_argument('nick') gender = self.get_argument('gender') phone = self.get_argument('phone') user_show.nick = nick user_show.gender = gender user_show.phone = phone self.redirect('/admin/user_list')
def post(self, *args, **kwargs): mes = {} oid = self.get_argument('o_id') if oid: orderList = sess.query(Order).filter(Order.id == oid).first() mes['code'] = 200 mes['orderList'] = orderList self.write( json.dumps(mes, cls=AlchemyEncoder, ensure_ascii=False, indent=4))
def post(self, *args, **kwargs): mes = {} user_id = self.get_argument('user_id') if user_id is not None: user = sess.query(User).filter(User.id == user_id).first() user.is_activates = 1 mes['code'] = 200 mes['message'] = '激活成功' self.write(json.dumps(mes)) else: mes['code'] = 400 mes['message'] = '请求错误' self.write(json.dumps(mes))
def post(self, *args, **kwargs): id = self.get_argument('id') gname = self.get_argument('gname') describe = self.get_argument('describe') specifications = self.get_argument('specifications') price = self.get_argument('price') cate = self.get_argument('cate') if id: goods = sess.query(Goods).filter(Goods.id == id).first() goods.gname = gname goods.describe = describe goods.specifications = specifications goods.price = price goods.cate_id = cate self.redirect('/admin/goods_list')
def post(self): oid = self.get_argument('o_id') if oid: orderList = sess.query(Order).filter(Order.id == oid).first() #调用退款方法 order_string = api_alipay_trade_refund( #订单号,一定要注意,这是支付成功后返回的唯一订单号 out_trade_no=orderList.id, #退款金额,注意精确到分,不要超过订单支付总金额 refund_amount=orderList.payment_amount, #回调网址 notify_url='http://127.0.0.1:8000/alipayreturn') print(order_string) orderList.ststes = 2 orderList.commit()
def charm_permissions(self, *args, **kwargs): # 获得当前url current = self.request.uri user_id = self.get_cookie('userid') my_access = sess.query(Nodes.node_url, User.role_id).join( Roles, User.role_id == Roles.id).join( Role2Node, Roles.id == Role2Node.role_id).join( Nodes, Role2Node.node_id == Nodes.id).filter( User.id == user_id).all() urlList = [] for val in my_access: urlList.append(val[0]) if current in urlList: return views(self, *args, **kwargs) else: pass
def get(self, *args, **kwargs): id = self.get_argument('id') if id: category1 = sess.query(Category).filter(Category.id == id).first() pid1 = category1.id category2 = sess.query(Category).filter( Category.parent_id == pid1).all() if category2 != []: for i in category2: pid2 = i.id category3 = sess.query(Category).filter( Category.parent_id == pid2).all() if category3 != []: for j in category3: pid3 = j.id if pid3: del_cate3 = sess.query(Category).filter( Category.id == pid3).first() sess.delete(del_cate3) del_cate2 = sess.query(Category).filter( Category.id == pid2).first() sess.delete(del_cate2) del_cate1 = sess.query(Category).filter( Category.id == pid1).first() sess.delete(del_cate1) self.redirect('/admin/product_category') else: del_cate2 = sess.query(Category).filter( Category.id == pid2).first() sess.delete(del_cate2) del_cate1 = sess.query(Category).filter( Category.id == pid1).first() sess.delete(del_cate1) self.redirect('/admin/product_category') else: del_cate1 = sess.query(Category).filter( Category.id == pid1).first() sess.delete(del_cate1) self.redirect('/admin/product_category')
def post(self, *args, **kwargs): mes = {} id = self.get_argument('id') cur = int(self.get_argument('cur', 1)) # 当前页 num = int(self.get_argument('num')) # 每页数量 goods = sess.query(Goods).filter(Goods.cate_id == id).all() print(id, '0-0-0-0-0-0-0') totalNum = len(goods) start = (cur - 1) * num goodsList = [] infinite(goodsList, id, num, start) mes['goods_list'] = goodsList mes['count'] = totalNum mes['code'] = 200 mes['message'] = '发送分类成功' self.write( json.dumps(mes, cls=AlchemyEncoder, ensure_ascii=False, indent=4))
def post(self): # 1. 查询当前商品下的所有评论 # 通过商品ID查询Comments表中所有评论以及评论的用户 goods_id = self.get_argument('goods_id') print(goods_id, '0-0-0-0-0-0') if goods_id: comments = sess.query(Comments).filter( Comments.goods_id == goods_id).all() print(comments, '-=-=-=-=-=-=-=-=-=') self.write( json.dumps({ 'code': 200, 'comments': comments }, cls=AlchemyEncoder, ensure_ascii=False, indent=4))
def post(self): mes = {} username = self.get_argument('username') password = self.get_argument('password') if not all([username, password]): mes['message'] = '请输入账户密码' self.write('输入账户密码') elif re.match('\w{5,12}', username) is None: self.write('账号不符合规范') else: user = sess.query(User).filter(User.username == username).first() if user is not None: if user.password != password: self.write('密码不正确') else: self.set_cookie('userid', str(user.id)) self.redirect('/admin/index') else: self.write('没有该账号')
def query(): from db import sess return sess.query(Message)
def query(): from db import sess return sess.query(Player)
def query(): from db import sess return sess.query(Person)