def tpl_extra(): menu_data = Crud.get_data(Menu, Menu.sort.desc()) rule = str(request.url_rule) #用户权限列表 auth_urls = [] if hasattr(current_user, 'id') and current_user.id != 1: auth_urls = session.get('auth_urls') # 如果有分页,去掉分页标签 has_pagination = rule.find("<") if has_pagination>0: rule = rule[0:has_pagination-1] #获取当前菜单信息,用于页面展示 active_menu = Menu.query.filter(Menu.url == rule).first() #配置项 conf_model_data = Crud.get_data(Conf, Conf.sort.desc()) conf_data,webconfig = [],{} for v in conf_model_data: conf = object_to_dict(v) if conf['optional_values']: conf['optional_values'] = (conf['optional_values']).split(',') conf_data.append(conf) webconfig[conf['ename']] = conf['default_value'] data = dict( online_time= datetime.now().strftime("%Y/%m/%d %H:%M:%S"), menu_tree=build_tree(menu_data, 0, 0), rule = rule, active_menu = active_menu, conf_data = conf_data, webconfig = webconfig, auth_urls = auth_urls ) return data
def article_list(): category_id = None page = 1 search = '' if request.args.get('category_id'): category_id = int(request.args.get('category_id')) if request.args.get('page'): page = int(request.args.get('page')) if request.args.get('search'): search = request.args.get('search') #产品可用标签 tag_data = Crud.get_data(Tag) #栏目树 category_data = Crud.get_data(Category, Category.sort.desc()) category_tree = build_tree(category_data, 0, 0) #产品栏目 article_category = [v for v in category_tree if v['type'] == 2 or v['type'] == 3 ] if category_id == None: article_data = Crud.search_data_paginate(Article,Article.title.like("%" + search + "%"),Article.sort.desc(),page,10) else: article_data = Crud.search_data_paginate(Article,and_(Article.category_id == category_id,Article.title.like("%" + search + "%")),Article.sort.desc(),page,10) return render_template("admin/article/article_list.html", category_id=category_id, article_data=article_data, article_category = article_category, tag_data = tag_data, )
def ad_list(space_id=None): sapce_data= Crud.get_data(Adspace) if space_id == None: ad_data = Crud.get_data(Ad,Ad.sort.desc()) else: ad_data = Crud.search_data(Ad,Ad.space_id == space_id,Ad.sort.desc()) return render_template("admin/ad/ad_list.html", space_id=space_id,ad_data=ad_data,sapce_data=sapce_data)
def reptile_list(): request_id = request.args.get('request_id') if request_id: request_id = int(request_id) if request.args.get('page'): page = int(request.args.get('page')) else: page = 1 request_data = Crud.get_data(ReptileRequest, ReptileRequest.create_time.desc()) if request_id: page_data = Crud.search_data_paginate( ReptileList, ReptileList.request_id == request_id, ReptileList.create_time.desc(), page, 20) else: page_data = Crud.get_data_paginate(ReptileList, ReptileList.create_time.desc(), page, 20) category_data = Crud.get_data(Category, Category.sort.desc()) category_tree = build_tree(category_data, 0, 0) return render_template("admin/reptile/reptile_list.html", request_data=request_data, page_data=page_data, category_tree=category_tree, request_id=request_id)
def interface(model_name=None): data = {} if model_name =='category': category_data = Crud.get_data(Category,Category.sort.desc()) data = build_tree(category_data, 0, 0) elif model_name == 'adspace': adspace_data = Crud.get_data(Adspace,Adspace.create_time.desc()) data = [ object_to_dict(v) for v in adspace_data] return jsonify(data)
def template_list(nav_id=None): data = Crud.get_data(Category, Category.sort.desc()) nav_tree = build_tree(data, 0, 0) if nav_id == None: template_data = Crud.get_data(Template, Template.sort.desc()) else: template_data = Crud.search_data(Template, Template.nav_id == nav_id, Template.sort.desc()) return render_template("admin/template/template_list.html", nav_tree=nav_tree, template_data=template_data, nav_id=nav_id)
def auth_list(menuid=None): if menuid == None: auth_data = Crud.get_data(Auth) else: auth_data = Crud.search_data(Auth, Auth.menu_id == menuid) return render_template("admin/auth/auth_list.html", menuid=menuid, auth_data=auth_data)
def getWebConfig(): ''' 获取站点配置信息 ''' webconfig = {} conf_model_data = Crud.get_data(Conf, Conf.sort.desc()) for v in conf_model_data: webconfig[v.ename] = v.default_value return webconfig
def webconfig(): data = Crud.get_data(Conf, Conf.sort.desc()) if request.method == 'GET': return render_template("admin/conf/webconfig.html") elif request.method == 'POST': form_data = request.form for v in data: v.default_value = form_data[v.ename] result = Crud.easy_update(data) if result: op_log("修改配置") return {"code":1, "msg": '保存成功'} return {"code":0, "msg": '保存失败,系统错误'}
def product_list(): category_id = None page = 1 search = '' if request.args.get('category_id'): category_id = int(request.args.get('category_id')) if request.args.get('page'): page = int(request.args.get('page')) if request.args.get('search'): search = request.args.get('search') #产品可用标签 tag_data = Crud.get_data(Tag) #栏目树 category_data = Crud.get_data(Category, Category.sort.desc()) category_tree = build_tree(category_data, 0, 0) #产品栏目 product_category = [ v for v in category_tree if v['type'] == 1 or v['type'] == 3 ] if category_id == None: product_data = Crud.search_data_paginate( Product, Product.title.like("%" + search + "%"), Product.sort.desc(), page, 10) else: product_data = Crud.search_data_paginate( Product, and_(Product.category_id == category_id, Product.title.like("%" + search + "%")), Product.sort.desc(), page, 10) return render_template( "admin/product/product_list.html", category_id=category_id, product_data=product_data, product_category=product_category, tag_data=tag_data, )
def admin_list(page=None): sql = ''' SELECT admin.id,admin.create_time,admin.username,admin.is_super,role.name as role_name, CASE admin.is_super WHEN 1 THEN '超级管理员' ELSE '普通管理员' END as admin_type FROM admin LEFT JOIN role on admin.role_id = role.id WHERE admin.is_del = 0 ORDER BY admin.create_time ASC ''' data = Crud.auto_select(sql) role_data = Crud.get_data(Role, 'create_time') return render_template("admin/admin/admin_list.html", admin_data=data.fetchall(), role_data=role_data)
def getCategory(): ''' 获取全部栏目 ''' return Crud.get_data(Category, Category.sort.desc())
def getTag(): ''' 获取标签信息 ''' return Crud.get_data(Tag, Tag.sort.desc())
def getTemplates(): ''' 获取网站模板页面设置 ''' return Crud.get_data(Template, Template.sort.desc())
def adspace_list(): list_data = Crud.get_data(Adspace, 'create_time') return render_template("admin/adspace/adspace_list.html", list_data=list_data)