def edit_customers(): this = 'edit' tsActive = 'manage_customers' getid = request.args.get('id') form = EditCustomersForm() userData = db_session.query(Users).filter(Users.id == getid).first() if form.validate_on_submit(): id = request.form.get('id') password = request.form.get('password') # 判断是否修改密码 if not password.strip(): return redirect('/manage/manage_customers?verify=0&status=0') # 如果修改密码 else: db_session.query(Users).filter(Users.id == id).update( {Users.password: password}) db_session.commit() db_session.close() flash("修改成功,<span id='time'>3</span>秒后自动跳转管理页。") return redirect('%s%s' % ('/manage/edit_customers?id=', id)) return render_template("edit_customers.html", this=this, pagename=tsActive, userData=userData, form=form)
def edit_wash(): getid = request.args.get('id') washData = db_session.query(Wash).filter(Wash.id == getid).\ with_entities(Wash.text, Wash.icon, Wash.id).first() form = EditWashForm() if washData: form.id.data = washData.id form.text.data = washData.text form.oldicon.data = washData.icon db_session.close() if form.validate_on_submit(): id = request.form.get('id') text = request.form.get('text') icon = request.form.get('icon') wash = Wash(text=text, icon=icon) db_session.query(Wash).filter(Wash.id == id).update({ Wash.text: text, Wash.icon: icon }) db_session.commit() # 记录日志 actions = ('%s%s%s' % ('修改洗涤说明', ':', id)) savelog(actions) db_session.close() flash("修改成功,<span id='time'>3</span>秒后自动跳转管理页。") return redirect('/manage/edit_wash') return render_template("edit_wash.html", pagename='manage_wash', this='edit', form=form)
def del_admin(): getid = int(request.args.get('id')) delg = db_session.query(Manage).filter(Manage.id == getid).first(); db_session.delete(delg) db_session.commit() db_session.close() return jsonify({"state":"ok"})
def add_group(): form = AddadminForm() if form.validate_on_submit(): name = request.form.get('name') powerlist = request.form.get('powerlist') group = Group(name=name, power=powerlist, addtime=datetime.datetime.now()) group_check = db_session.query(Group).filter( Group.name == name).first() if group_check: flash('用户组已存在') return redirect('/manage/add_group') if len(name) and len(powerlist): try: db_session.add(group) db_session.commit() db_session.close() except: flash("数据库错误!") return redirect('/manage/add_group') flash("添加成功,<span id='time'>3</span>秒后自动跳转管理页。") return redirect('/manage/add_group') return render_template("add_group.html", pagename='manage_group', form=form)
def edit_group(): getid = request.args.get('group_id') groupData = db_session.query(Group).filter(Group.group_id == getid).\ with_entities(Group.name, Group.power, Group.group_id).first() form = EditadminForm() if groupData: form.group_id.data = groupData.group_id form.name.data = groupData.name form.powerlist.data = groupData.power db_session.close() if form.validate_on_submit(): group_id = request.form.get('group_id') name = request.form.get('name') powerlist = request.form.get('powerlist') group = Group(name=name, power=powerlist) db_session.query(Group).filter(Group.group_id == group_id).update({ Group.name: name, Group.power: powerlist }) db_session.commit() db_session.close() flash("修改成功,<span id='time'>3</span>秒后自动跳转管理页。") return redirect('/manage/edit_group') return render_template("edit_group.html", pagename='manage_group', form=form)
def add_team(): form = AddTeamForm() if form.validate_on_submit(): title = request.form.get('title') team = Team(title=title, addtime=datetime.datetime.now()) team_check = db_session.query(Team).filter(Team.title == title).first() if team_check: flash('产品组已存在') return redirect('/manage/add_team') if len(title): try: db_session.add(team) db_session.commit() # 记录日志 actions = ('%s%s%s' % ('增加产品组', ':', title)) savelog(actions) db_session.close() except: flash("数据库错误!") return redirect('/manage/add_team') flash("添加成功,<span id='time'>3</span>秒后自动跳转管理页。") return redirect('/manage/add_team') return render_template("edit_team.html", pagename='manage_team', this='add', form=form)
def del_group(): getid = int(request.args.get('group_id')) delg = db_session.query(Group).filter(Group.group_id == getid).first() db_session.delete(delg) db_session.commit() db_session.close() return jsonify({"state": "ok"})
def edit_team(): getid = request.args.get('id') teamData = db_session.query(Team).filter(Team.id == getid).\ with_entities(Team.title, Team.id).first() form = EditTeamForm() if teamData: form.id.data = teamData.id form.title.data = teamData.title db_session.close() if form.validate_on_submit(): id = request.form.get('id') title = request.form.get('title') team = Team(title=title) db_session.query(Team).filter(Team.id == id).update( {Team.title: title}) db_session.commit() # 记录日志 actions = ('%s%s%s' % ('修改产品组', ':', title)) savelog(actions) db_session.close() flash("修改成功,<span id='time'>3</span>秒后自动跳转管理页。") return redirect('/manage/edit_team') return render_template("edit_team.html", pagename='manage_team', this='edit', form=form)
def add_silder(): this = 'add' form = AddsilderForm() if form.validate_on_submit(): title = request.form.get('title') url = request.form.get('url') picid = request.form.get('picid') sort = request.form.get('sort') silder = Silder(title=title, url=url, picid=picid, sort=sort) silder_check = db_session.query(Silder).order_by(Silder.id) if len(title): try: db_session.add(silder) db_session.commit() db_session.close() except: flash("数据库错误!") return redirect('/manage/add_silder') flash("添加成功,<span id='time'>3</span>秒后自动跳转管理页。") return redirect('/manage/add_silder') return render_template("edit_silder.html", pagename='silder', this=this, form=form)
def examine_customers(): getid = request.args.get('id') examine = request.args.get('examine', 0) teamid = request.args.get('teamid', 0) upusers = Users.query.filter(Users.id == getid) upusers.update({Users.verify: examine, Users.teamid: teamid}) db_session.commit() #发送短信 password 和 phone 作为参数发送 phone = '%s%s' % ('+', upusers.first().phone) pssw = upusers.first().password user = upusers.first().truename message = '%s%s%s%s%s%s%s' % ('【iShowRoom】尊敬的', user, ',您的帐号已审核通过,帐号:', phone, ',密码:', pssw, '。请您妥善保管密码,切勿泄漏给他人,若非您本人操作请忽略此短信!') result, err_message = message_validate(phone, message) if not result: return jsonify({'code': 0, 'message': err_message}) # 记录日志 actions = '%s%s' % ('审核通过客户:', phone) savelog(actions) db_session.close() return jsonify({"state": 'ok'})
def examineall_customers(): getid = request.form.getlist('id') examine = request.args.get('examine', 0) if len(getid) == 1: getid = request.form.get('id') try: upsort = db_session.query(Users).\ filter(Users.id == getid).\ update({Users.verify : examine}) db_session.commit() # 记录日志 # print upsort.phone actions = '%s%s' % ('审核通过客户:', upsort.phone) savelog(actions) except: return jsonify({"state": "数据库错误"}) else: for getid in getid: try: upsort = db_session.query(Users).\ filter(Users.id == getid).\ update({Users.verify : examine}) db_session.commit() # 记录日志 actions = '%s%s' % ('审核通过客户:', upsort.phone) savelog(actions) except: return jsonify({"state": "数据库错误"}) db_session.close() return jsonify({"state": 'ok'})
def lock_customers(): getid = int(request.args.get('id')) status = int(request.args.get('status')) Users.query.filter(Users.id == getid).update({Users.lock: status}) db_session.commit() db_session.close() return jsonify({"state": "ok"})
def del_colors(): getid = request.args.get('id') delcolors = db_session.query(ProColor).filter(ProColor.id == getid).first() colorpics = delcolors.colorpic.all() for picurl in colorpics: imgurl = picurl.picurl #获得图片物理地址 imgurl = actros_split(imgurl) delImage(imgurl) #删除物理图片 try: [db_session.delete(n) for n in colorpics] db_session.commit() except Exception as e: print (e) db_session.rollback() return jsonify({"state":"数据库错误"}) try: db_session.delete(delcolors) db_session.commit() except Exception as e: print (e) db_session.rollback() return jsonify({"state":"数据库错误"}) db_session.close() return jsonify({"state":'ok'})
def del_contact(): getid = int(request.args.get('id')) delg = db_session.query(ContactUs).filter(ContactUs.id == getid).first() db_session.delete(delg) db_session.commit() db_session.close() return jsonify({"state": "ok"})
def search_recommend(): titles = request.args.get('titles') recommendlist = db_session.query(Recommend).filter( Recommend.titles == titles).all() return render_template("manage_recommend.html", pagename='manage_recommend', recommendlist=recommendlist) db_session.close()
def search_classify(): classname = request.args.get('classname') classifylist = db_session.query(Classify).filter( Classify.classname == classname).all() return render_template("manage_classify.html", pagename='manage_classify', classifylist=classifylist) db_session.close()
def lock_admin(): getid = int(request.args.get('id')) status = int(request.args.get('status')) thstatus = Manage.query.filter_by(id = getid).first() thstatus.status = status db_session.add(thstatus) db_session.commit() db_session.close() return jsonify({"state":"ok"})
def contactus(): if current_user.group.power == 0: #超级管理员 contactlist = Manage.query.all() if current_user.group.power == 1: #组长 contactlist = Manage.query.filter_by(teamid=current_user.teamid).all() return render_template("contactus.html", pagename='contact_us', contactlist=contactlist) db_session.close()
def save_company(): getid = request.form.get('id') getcontent = cgi.escape(request.form.get('editor')) db_session.query(Company).filter(Company.id == getid).update( {Company.content: getcontent}) db_session.commit() db_session.close() return redirect('/manage/company?id=' + getid)
def del_team(): getid = int(request.args.get('id')) delg = db_session.query(Team).filter(Team.id == getid).first() db_session.delete(delg) db_session.commit() # 记录日志 actions = ('%s%s%s' % ('删除产品组', ':', getid)) savelog(actions) db_session.close() return jsonify({"state": "ok"})
def search_admin(): username = request.args.get('username') if current_user.teamid == 0: userlist = db_session.query(Manage).filter(Manage.username.like("%"+username+"%")).all() else: userlist = db_session.query(Manage).filter(Manage.username.like("%"+username+"%"), Manage.teamid == current_user.teamid).all() return render_template( "manage_user.html", pagename='manage_user', userlist=userlist) db_session.close()
def edit_contact(): this = 'edit' getid = request.args.get('id') contactData = db_session.query(ContactUs).filter(ContactUs.id == getid).\ with_entities(ContactUs.id, ContactUs.department, ContactUs.title, ContactUs.name, ContactUs.phone, ContactUs.mail, ContactUs.wechat, ContactUs.sort).first() form = EditusForm() if contactData: form.id.data = contactData.id form.department.data = contactData.department form.title.data = contactData.title form.name.data = contactData.name form.phone.data = contactData.phone form.mail.data = contactData.mail form.wechat.data = contactData.wechat form.sort.data = contactData.sort db_session.close() if form.validate_on_submit(): id = request.form.get('id') department = request.form.get('department') title = request.form.get('title') name = request.form.get('name') phone = request.form.get('phone') mail = request.form.get('mail') wechat = request.form.get('wechat') sort = request.form.get('sort') db_session.query(ContactUs).filter(ContactUs.id == id).update({ ContactUs.department: department, ContactUs.title: title, ContactUs.name: name, ContactUs.phone: phone, ContactUs.mail: mail, ContactUs.wechat: wechat, ContactUs.sort: sort }) db_session.commit() db_session.close() flash("修改成功,<span id='time'>3</span>秒后自动跳转管理页。") return redirect('/manage/edit_contact') return render_template("edit_contact.html", pagename='contact_us', this=this, form=form)
def manage_user(): status = request.args.get('status',0) if current_user.teamid == 0: userlist = db_session.query(Manage).filter(Manage.status == status).all() else: userlist = db_session.query(Manage).filter(Manage.status == status, Manage.teamid == current_user.teamid).all() return render_template( "manage_user.html", pagename='manage_user', userlist=userlist) db_session.close()
def del_address(): id = request.get_json().get('id') delad = Address.query.filter_by(id=id).first() db_session.delete(delad) try: db_session.commit() except Exception as e: print(e) db_session.rollback() return jsonify({'code': 0, 'message': '数据库错误'}) db_session.close() return jsonify({'code': 1, 'message': '删除成功'})
def add_news(): pid = int(request.args.get('pid')) if pid == 1: tsActive = "manage_news" elif pid == 2: tsActive = "help" elif pid == 3: tsActive = "manage_company" this = 'add' form = AddNewsForm() if form.validate_on_submit(): userid = int(request.form.get('userid')) title = request.form.get('title') getcontent = html.escape(request.form.get('editor')) display = int(request.form.get('display')) news = News(pid=pid, title=title, content=getcontent, display=display, userid=userid, teamid=current_user.teamid, addtime=datetime.datetime.now()) news_check = db_session.query(News).filter(News.title == title).first() if news_check: if pid == 1: flash('资讯已存在') elif pid == 2: flash('帮助已存在') return redirect('%s%s' % ('/manage/add_news?pid=', pid)) if len(title) and len(getcontent): try: db_session.add(news) db_session.commit() db_session.close() except: flash("数据库错误!") return redirect('%s%s' % ('/manage/add_news?pid=', pid)) flash("添加成功,<span id='time'>3</span>秒后自动跳转管理页。") return redirect('%s%s' % ('/manage/add_news?pid=', pid)) return render_template("edit_news.html", pagename=tsActive, this=this, pid=pid, form=form)
def up_pro_state(): getid = request.form.getlist('id') getstate = request.form.get('new_p') for i in range(len(getid)): upst = Product.query.filter_by(proid=getid[i]).first() upst.new_p = getstate db_session.add(upst) try: db_session.commit() except Exception as e: print (e) return jsonify({"state":"数据库错误"}) db_session.close() return jsonify({"state":'ok'})
class AddadminForm(FlaskForm): group = [(r.group_id, r.name) for r in db_session.query(Group).filter(Group.power != 0).all()] team = [(r.id, r.title) for r in db_session.query(Team)] login_size = HiddenField('login_size',default=0) teamid = HiddenField('teamid') username = TextField('用户名', validators=[Length(min=4,max=30,message=(u'用户名必须4~30个字符之间'))], render_kw={ "placeholder": "用户名", "class": "form-control", "onbeforepaste": "clipboardData.setData('text',clipboardData.getData('text').replace(/[\u4e00-\u9fa5]/g,''))", "onkeyup":"this.value=this.value.replace(/[\u4e00-\u9fa5]/g,'')", }) password = PasswordField('密码', validators=[Length(min=6,max=16,message=(u'密码必须6~16个字符之间'))], render_kw={"placeholder": "密码","class": "form-control","onkeyup": "KeyUp()"}) repassword = PasswordField('重复密码', render_kw={"placeholder": "重复密码","class": "form-control","onkeyup": "KeyUp()"}) status = SelectField('状态', coerce=int, choices = [(0, '正常'), (1, '锁定')],render_kw={"class": "form-control"}) purview = SelectField('职责', coerce=int, choices = [(0, '组长'), (1, '组员')],render_kw={"class": "form-control"},default=1) group_id = SelectField(u'管理组', coerce=int,choices = group, render_kw={"class": "form-control"},default=10) title = TextField('职位', validators=[Length(min=2,max=30,message=(u'职位必须2~30个字符之间'))], render_kw={"placeholder": "职位","class": "form-control"}) name = TextField('联系人', validators=[Length(min=2,max=5,message=(u'联系人必须2~5个字符之间'))], render_kw={"placeholder": "联系人","class": "form-control"}) phone = TextField('电话', validators=[Length(min=11,max=12,message=(u'电话必须11个字符'))], render_kw={"placeholder": "电话","class": "form-control"}) mail = TextField('邮件', validators=[Length(min=6, message=(u'邮件地址太短!')),Email(message=(u'您输入的不是一个邮件地址!'))],render_kw={"placeholder": "邮箱","class": "form-control"}) wechat = TextField('微信', validators=[Length(min=2,max=30,message=(u'微信必须2~30个字符之间'))], render_kw={"placeholder": "微信","class": "form-control"}) submit = SubmitField('添加',render_kw={"class": "btn btn-primary"}) teams = SelectField('所属组', coerce=int, choices = team, render_kw={"class": "form-control"}) db_session.close()
def del_silder(): getid = int(request.args.get('id')) picid = int(request.args.get('picid')) # print getid,picid delg = db_session.query(Silder).filter(Silder.id == getid).first() db_session.delete(delg) deli = db_session.query(Images).filter(Images.id == picid).first() imgurl = deli.picurl imgurl = actros_split(imgurl) delImage(imgurl) db_session.delete(deli) db_session.commit() db_session.close() return jsonify({"state": "ok"})
def my_info(): getid = request.args.get('getid') adminData = Manage.query.filter_by(id = getid).first() form = MyInfoForm() if adminData: form.getid.data = adminData.id form.username.data = adminData.username form.title.data = adminData.title form.name.data = adminData.name form.phone.data = adminData.phone form.mail.data = adminData.mail form.wechat.data = adminData.wechat if form.validate_on_submit(): getid = request.form.get('getid') password = request.form.get('password') title = request.form.get('title') name = request.form.get('name') phone = request.form.get('phone') mail = request.form.get('mail') wechat = request.form.get('wechat') thuser = Manage.query.filter_by(id = getid).first() thuser.title = title thuser.name = name thuser.phone = phone thuser.mail = mail thuser.wechat = wechat try: db_session.add(thuser) db_session.commit() except Exception as e: print (e) db_session.rollback() return jsonify({"state":"数据库错误"}) db_session.close() flash("修改成功,<span id='time'>3</span>秒后自动跳转管理页。") return redirect('/manage/my_info') return render_template( "admin_info.html", pagename='manage_user', form=form)
def pic_sorts(): picid = request.form.getlist('picid') sorts = [] for x in range(len(picid)): db_session.query(Images).\ filter(Images.id == picid[x]).\ update( { Images.sort : x } ) try: db_session.commit() db_session.close() except Exception as e: print (e) return jsonify({'state':'数据库错误'}) return jsonify({'state':'ok'})