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'})
