def applymanager_list(currentpage=1, sumpage=8):
try:
id = flask_login.current_user.id
key = request.args.get('key')
key_type = request.args.get('key_type')
vcode = request.args.get('vcode')
offset=(int(currentpage)-1)*int(sumpage)
offset=int(offset)
tsql="select id,sqlx,uname,cardno,mob,sqsx,create_date,flag from bj_cert where apply_count='%s'"%(id)
countsql="select count(1) from bj_cert where apply_count='%s'"%(id)
if key:
tsql+=" and (uname like '%%%%%s%%%%' or danwei like '%%%%%s%%%%' or mob like '%%%%%s%%%%' or board like '%%%%%s%%%%' or car_no like '%%%%%s%%%%')"%(key,key,key,key,key)
countsql+=" and (uname like '%%%%%s%%%%' or danwei like '%%%%%s%%%%' or mob like '%%%%%s%%%%' or board like '%%%%%s%%%%' or car_no like '%%%%%s%%%%')"%(key,key,key,key,key)
if key_type and key_type!='0':
tsql +=" and sqlx='%s'"%(key_type)
countsql +=" and sqlx='%s'"%(key_type)
tsql+=" order by id desc limit %s offset %s"%(sumpage,offset)
trow=getSelectSql(tsql)
countresult=getSelectSql(countsql)
if(countresult[0][0]%sumpage==0):
countpage=countresult[0][0]/sumpage
else:
countpage=countresult[0][0]/sumpage+1
types=['登轮许可证','口岸限定区域许可证','口岸限定区域车辆通行证']
resp= render_template('ApplyManager/List.html', basepath=BASEPATH,userlist=trow,offset=offset,countpage=countpage,currentpage=currentpage,key=key,key_type=key_type,types=types,vcode=vcode)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def cmanager_list(currentpage=1, sumpage=8):
try:
key = request.args.get('key')
offset = (int(currentpage) - 1) * int(sumpage)
offset = int(offset)
tsql = "select name,remark,id from bj_company where 1=1"
countsql = "select count(1) from bj_company where 1=1"
if key:
tsql += " and name like '%%%%%s%%%%'" % (key)
countsql += " and name like '%%%%%s%%%%'" % (key)
tsql += " order by create_date limit %s offset %s" % (sumpage, offset)
trow = getSelectSql(tsql)
countresult = getSelectSql(countsql)
if (countresult[0][0] % sumpage == 0):
countpage = countresult[0][0] / sumpage
else:
countpage = countresult[0][0] / sumpage + 1
resp = render_template('ComManager/List.html',
basepath=BASEPATH,
userlist=trow,
offset=offset,
countpage=countpage,
currentpage=currentpage,
key=key)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(
render_template('error.html',
basepath=BASEPATH,
errormsg=('异常,详细 (%s)' % e)))
return resp
def usermanager_edit(id):
try:
sys = flask_login.current_user.sys
roles = flask_login.current_user.roles
if '超级管理员' in roles:
is_administrator='1'
else:
is_administrator='0'
sql="select bu.id,bu.name,bu.password from bj_company_user bu where bu.id='%s'"%(id)
user=getSelectSql(sql)
sql="select bcur.role_ref,br.name from bj_companyuser_role bcur left join bj_role br on br.id=bcur.role_ref where bcur.user_ref='%s'"%(id)
role=getSelectSql(sql)
sql="select id,name from bj_role where sys='%s'"%(sys)
roles=getSelectSql(sql)
resp= render_template('UserManager/Edit.html',
basepath=BASEPATH,
user=user,
roles=roles,
role=role,
is_administrator=is_administrator)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def countmanager_list(currentpage=1, sumpage=8):
try:
key = request.args.get('key')
offset = (int(currentpage) - 1) * int(sumpage)
offset = int(offset)
#已经可以释放的账号
sql = "select id from bj_company_user where statu=2 and now()>end_time+ '1 day'"
rows = getSelectSql(sql)
length = len(rows)
if length > 0:
uids = '('
if length == 1:
uids += str(rows[0][0])
else:
for r in rows:
uids += str(r[0]) + ','
uids = uids[:-1]
uids += ')'
sql = "update bj_company_user set statu=3,start_time=null,end_time=null where id in %s" % (
uids)
updateSql(sql)
# for r in rows:
# sql="select 1 from bj_company_user where start_time<=now() and now()<=end_time and id='%s'"
# updateSql(sql)
tsql = "select bcu.id,bcu.name,bcu.password,bcu.start_time,bcu.end_time,bcu.statu,bc.name as cname from bj_company_user bcu left join bj_company bc on bc.id=bcu.companyid where 1=1"
countsql = "select count(1) from bj_company_user bcu left join bj_company bc on bcu.companyid=bc.id where 1=1"
if key:
tsql += " and bcu.name like '%%%%%s%%%%' or bc.name like '%%%%%s%%%%'" % (
key, key)
countsql += " and bcu.name like '%%%%%s%%%%' or bc.name like '%%%%%s%%%%'" % (
key, key)
tsql += " order by bcu.create_date limit %s offset %s" % (sumpage,
offset)
trow = getSelectSql(tsql)
countresult = getSelectSql(countsql)
if (countresult[0][0] % sumpage == 0):
countpage = countresult[0][0] / sumpage
else:
countpage = countresult[0][0] / sumpage + 1
resp = render_template('CountManager/List.html',
basepath=BASEPATH,
userlist=trow,
offset=offset,
countpage=countpage,
currentpage=currentpage,
key=key)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(
render_template('error.html',
basepath=BASEPATH,
errormsg=('异常,详细 (%s)' % e)))
return resp
def usermanager_list(currentpage=1, sumpage=8):
try:
roles = flask_login.current_user.roles
if '超级管理员' in roles:
is_administrator='1'
else:
is_administrator='0'
key = request.args.get('key')
offset=(int(currentpage)-1)*int(sumpage)
offset=int(offset)
tsql="select * from bj_company_user where 1=1"
countsql="select count(1) from bj_company_user where 1=1"
user_id = flask_login.current_user.id
if is_administrator == '1':
sql="select id from bj_company_user where companyid=(select companyid from bj_company_user where id='%s')"%(user_id)
rows=getSelectSql(sql)
if len(rows)>0:
uids="("
for r in rows:
uids+=str(r.id)+','
uids=uids[:-1]+")"
else:
uids="(-1)"
tsql+=" and id in %s"%(uids)
countsql += " and id in %s" % (uids)
else:
tsql+=" and id='%s'"%(user_id)
countsql += " and id='%s'" % (user_id)
if key:
tsql+=" and name like '%%%%%s%%%%'"%(key)
countsql+=" and name like '%%%%%s%%%%'"%(key)
tsql+=" order by create_date limit %s offset %s"%(sumpage,offset)
trow=getSelectSql(tsql)
countresult=getSelectSql(countsql)
if(countresult[0][0]%sumpage==0):
countpage=countresult[0][0]/sumpage
else:
countpage=countresult[0][0]/sumpage+1
resp= render_template('UserManager/List.html',
basepath=BASEPATH,
userlist=trow,
offset=offset,
countpage=countpage,
currentpage=currentpage,
key=key,
is_administrator=is_administrator)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def rolemanager_detail(id):
try:
tsql="select create_date,name,remark from bj_role where id='%s'"%(id)
role=getSelectSql(tsql)
sql="select name from bj_menu where id in (select menu_ref from bj_role_menu where role_ref ='%s')"%(id)
menus=getSelectSql(sql)
resp= render_template('RoleManager/Detail_new.html', basepath=BASEPATH,role=role,menus=menus)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def applymanager_delete(cids):
try:
cids=cids.split(',')
dlt=''
for c in cids:
#删除前每次查看是否已经审批
sql = "select flag from bj_cert where id='%s'"%(c)
flag=getSelectSql(sql)[0][0]
if flag==1:
dlt='1'
continue
#开始删除
tsql="delete from bj_cert where id='%s'"%(c)
rs=updateSql(tsql)
if rs==1:
continue
else:
return '1'
#如果dlt为 1 则说明部分删除失败
if dlt=='1':
return '2'
return '0'
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def usermanager_detail(id):
try:
sql="select bu.id,bu.name,bu.password from bj_company_user bu where bu.id='%s'"%(id)
user=getSelectSql(sql)
sql="select br.name from bj_companyuser_role bur left join bj_role br on bur.role_ref=br.id where bur.user_ref='%s'"%(id)
roles=getSelectSql(sql)
# sql="select id,name from bj_role"
# roles=getSelectSql(sql)
resp= render_template('UserManager/Detail.html', basepath=BASEPATH,user=user,roles=roles)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def in_sql(unid):
print(1)
Unsql = "select * from bj_crews where \"UNID\"='%s'" % (unid)
Unsqlvalue = getSelectSql(Unsql)
if len(Unsqlvalue) > 0:
return 1
else:
return 0
def rolemanager_edit(id):
try:
sql="select id,name from bj_menu where pid='0' and sys='2'"
allmenues=getSelectSql(sql)
tsql="select name,remark,id from bj_role where id='%s'"%(id)
role=getSelectSql(tsql)
sql="select menu_ref from bj_role_menu where role_ref='%s'"%(id)
menus=getSelectSql(sql)
resp= render_template('RoleManager/Edit.html', basepath=BASEPATH,role=role,allmenues=allmenues,menus=menus)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def applymanager_sp():
try:
cid = request.args.get('cid')
sql="select * from bj_cert where id='%s'"%(cid)
cinfo=getSelectSql(sql)
sql="select bu.name from bj_user bu left join bj_user_role bur on bur.user_ref=bu.id left join bj_role br on br.id=bur.role_ref where br.name='经办人'"
jbr=getSelectSql(sql)
sql="select bu.name from bj_user bu left join bj_user_role bur on bur.user_ref=bu.id left join bj_role br on br.id=bur.role_ref where br.name='领导'"
ld=getSelectSql(sql)
resp= render_template('ApplyManager/Sp.html', basepath=BASEPATH,jbr=jbr,ld=ld,cinfo=cinfo)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def patrolmanager_detail(id):
try:
tsql="select case when zp.type=1 then '日常值班' when zp.type=2 then '领导值班' when zp.type=3 then '节假日值班' when zp.type=4 then '夜游值班' else '' end as zbtype,zp.content,case when zp.state=1 then '未处理' when zp.state=2 then '已处理' else '' end as state,zp.cl_result,zu.name sbname,zu1.name as clname,zp.remark from zdk_patrol zp left join zdk_user zu on zu.id=zp.sb_user left join zdk_user zu1 on zu1.id=zp.cl_user where zp.id='%s'"%(id)
trow=getSelectSql(tsql)[0]
resp= render_template('PatrolManager/Detail.html', basepath=BASEPATH,user=trow)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def rolemanager_add():
try:
sql="select id,name from bj_menu where pid='0' and sys='2'"
rows=getSelectSql(sql)
resp= render_template('RoleManager/Add.html', basepath=BASEPATH,rows=rows)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def applymanager_add():
try:
uid = flask_login.current_user.id
sql = "select main_count from bj_company_user where id='%s'" % (uid)
row = getSelectSql(sql)
if row[0][0]:
fid = row[0][0]
else:
fid = uid
sql = "select id from bj_company_user where statu=2 and now()<=end_time+ '1 day' and now()>=start_time and id='%s'" % (fid)
rows = getSelectSql(sql)
length = len(rows)
if length>0:
return make_response(render_template('error.html', basepath=BASEPATH, errormsg=('此账号暂停使用！')))
resp= render_template('ApplyManager/Add.html', basepath=BASEPATH)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def usermanager_add():
try:
sys = flask_login.current_user.sys
rsql="select id,name from bj_role where sys='%s'"%(sys)
roles=getSelectSql(rsql)
resp= render_template('UserManager/Add.html', basepath=BASEPATH,roles=roles)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def patrolmanager_edit(id):
try:
patrol_type=[[1,"日常值班"],[2,"领导值班"],[3,"节假日值班"],[4,"夜游值班"]]
tsql="select zp.id,zp.type,zp.content,zp.state,zp.cl_result,zu.name sbname,zu1.name as clname,zp.remark from zdk_patrol zp left join zdk_user zu on zu.id=zp.sb_user left join zdk_user zu1 on zu1.id=zp.cl_user where zp.id='%s'"%(id)
trow=getSelectSql(tsql)[0]
resp= render_template('PatrolManager/Edit.html', basepath=BASEPATH,user=trow,patrol_type=patrol_type)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def countmanager_edit(id):
try:
psql = "select id,name from bj_company"
companies = getSelectSql(psql)
sql = "select name,password,companyid,id from bj_company_user where id='%s'" % (
id)
uinfo = getSelectSql(sql)
resp = render_template('CountManager/Edit.html',
basepath=BASEPATH,
companies=companies,
uinfo=uinfo)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(
render_template('error.html',
basepath=BASEPATH,
errormsg=('异常,详细 (%s)' % e)))
return resp
def patrolmanager_list(currentpage=1, sumpage=8):
try:
key = request.args.get('key')
offset=(int(currentpage)-1)*int(sumpage)
offset=int(offset)
tsql="select zp.id,case when zp.type=1 then '日常值班' when zp.type=2 then '领导值班' when zp.type=3 then '节假日值班' when zp.type=4 then '夜游值班' else '' end as zbtype,zp.content,case when zp.state=1 then '未处理' when zp.state=2 then '已处理' else '' end as state,zp.cl_result,zu.name from zdk_patrol zp left join zdk_user zu on zu.id=zp.sb_user where 1=1"
countsql="select count(1) from zdk_patrol zp left join zdk_user zu on zu.id=zp.sb_user where 1=1"
if key:
tsql+=" and zu.name like '%%%%%s%%%%'"%(key)
countsql+=" and zu.name like '%%%%%s%%%%'"%(key)
tsql+=" order by zp.create_date limit %s offset %s"%(sumpage,offset)
trow=getSelectSql(tsql)
countresult=getSelectSql(countsql)
if(countresult[0][0]%sumpage==0):
countpage=countresult[0][0]/sumpage
else:
countpage=countresult[0][0]/sumpage+1
resp= render_template('PatrolManager/List.html', basepath=BASEPATH,userlist=trow,offset=offset,countpage=countpage,currentpage=currentpage,key=key)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def countmanager_add():
try:
psql = "select id,name from bj_company"
companies = getSelectSql(psql)
resp = render_template('CountManager/Add.html',
basepath=BASEPATH,
companies=companies)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(
render_template('error.html',
basepath=BASEPATH,
errormsg=('异常,详细 (%s)' % e)))
return resp
def deptmanager_detail(id):
try:
tsql = "select name,remark,id from bj_department where id='%s'" % (id)
dept = getSelectSql(tsql)
resp = render_template('DeptManager/Detail.html',
basepath=BASEPATH,
dept=dept)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(
render_template('error.html',
basepath=BASEPATH,
errormsg=('异常,详细 (%s)' % e)))
return resp
def cmanager_edit(id):
try:
tsql = "select name,remark,id from bj_company where id='%s'" % (id)
com = getSelectSql(tsql)
resp = render_template('ComManager/Edit.html',
basepath=BASEPATH,
com=com)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(
render_template('error.html',
basepath=BASEPATH,
errormsg=('异常,详细 (%s)' % e)))
return resp
def countmanager_detail(id):
try:
sql = "select bcu.id,bcu.name,bcu.password,bc.name as cname,case when bcu.statu=3 then '启用' else '停用' end as statu,bcu.start_time,bcu.end_time from bj_company_user bcu left join bj_company bc on bc.id=bcu.companyid where bcu.id='%s'" % (
id)
uinfo = getSelectSql(sql)
resp = render_template('CountManager/Detail.html',
basepath=BASEPATH,
uinfo=uinfo)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(
render_template('error.html',
basepath=BASEPATH,
errormsg=('异常,详细 (%s)' % e)))
return resp
def deptmanager_synchronization(id):
try:
tsql = "select * from zdk_user where id=%s" % (id)
trow = getSelectSql(tsql)[0]
re = wcmgr.getWc_Sdk(6).addUser(trow.phone, trow.name, trow.phone, [1],
None)
if (re == 0):
msg = {"msg": "OK"}
elif (re == 60104):
msg = {"msg": "Exist"}
else:
msg = {"msg": "Error"}
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
msg.append = {"msg": "Error"}
return json.dumps(msg, ensure_ascii=False)
def manager_changepwdpost():
id = flask_login.current_user.id
oldpassword = request.form.get('oldpassword')
newpassword = request.form.get('newpassword')
new2password = request.form.get('new2password')
msg = []
if newpassword != new2password:
msg.append({"state": "500", "msg": "新密码两次输入不同！"})
else:
tsql = "select * from bj_user where id=%s and password='******'" % (
id, oldpassword)
trow = getSelectSql(tsql)
if (len(trow) > 0):
isql = "update bj_user set password='******' where id=%s" % (
newpassword, id)
updateSql(isql)
msg.append({"state": "200", "msg": "密码修改成功！"})
else:
msg.append({"state": "500", "msg": "原密码错误！"})
return json.dumps(msg, ensure_ascii=False)
def applymanager_user_data(vcode):
try:
uinfo=[]
sql="select * from bj_cert where vcode='%s'"%(vcode)
rows=getSelectSql(sql)
for r in rows:
print(type(r.checktime))
fdate=''
if r.create_date:
fdate=r.create_date.strftime('%Y-%m-%d')
uinfo.append({
'board':r.board,
'uname':r.uname,
'gender': r.gender,
'birthday': r.birthday,
'cardno': r.cardno,
'address': r.address,
'mob': r.mob,
'ewm': r.ewm,
'sqlx': r.sqlx,
'danwei': r.danwei,
'zhiwu': r.zhiwu,
'sqsx': r.sqsx,
'jbr': r.jbr,
'pzbm': r.pzbm,
'pzld': r.pzld,
'fdate': fdate,
'cardno_pic': r.cardno_pic,
'car_no': r.car_no,
})
return json.dumps(uinfo, ensure_ascii=False)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def applymanager_getuinfo(cardno):
try:
sql="select * from bj_cert where cardno='%s' order by create_date desc limit 1"%(cardno)
row=getSelectSql(sql)
if len(row)>0:
r=row[0]
uinfo_dic={
"uname":r.uname,
"gender": r.gender,
"birthday": r.birthday,
"address": r.address,
"mob": r.mob,
"danwei": r.danwei,
"cardno_pic":r.cardno_pic
}
return json.dumps(uinfo_dic, ensure_ascii=False)
else:
return '1'
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def applymanager_save():
try:
machine_add = request.form.get('machine_add')
if machine_add=='1':
vcode = request.form.get('vcode')
login_id=37
else:
login_id = flask_login.current_user.id
vcode = flask_login.current_user.vcode
print(vcode)
ewm = request.form.get('ewm')
sqlx = request.form.get('sqlx')
cardno = request.form.get('cardno')
NameA = request.form.get('NameA')
Sex2 = request.form.get('Sex2')
Born2 = request.form.get('Born2')
Address = request.form.get('Address')
mob = request.form.get('mob')
danwei = request.form.get('danwei')
zhiwu = request.form.get('zhiwu')
# carno = request.form.get('carno')
board = request.form.get('board')
testy=request.form.get('testy')
shiyou = request.form.get('shiyou')
is_bhc = request.form.get('is_bhc')
cardno_pic = request.form.get('cardno_pic')
mytime=time.strftime( ISOTIMEFORMAT, time.localtime() )
id = request.form.get('id')
if id:
sql = "select flag from bj_cert where id='%s'"%(id)
flag=getSelectSql(sql)[0][0]
if flag=='2':
return '2'
tsql=""
else:
if sqlx=='1':
if is_bhc=='1':
board='本航次'
testy=''
tsql = "insert into bj_cert(uname,gender,birthday,cardno,address,board,ewm,sqlx,zhiwu,sqsx,shiyou,flag,vcode,cardno_pic,apply_count,create_date,danwei,mob) values " \
"('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" % \
(NameA,Sex2,Born2,cardno,Address,board,ewm,'登轮许可证',zhiwu,testy,shiyou,'2',vcode,cardno_pic,login_id,mytime,danwei,mob)
elif sqlx=='2':
tsql = "insert into bj_cert(uname,gender,birthday,cardno,address,ewm,sqlx,zhiwu,sqsx,shiyou,flag,vcode,cardno_pic,apply_count,create_date,danwei,mob) values " \
"('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" % \
(NameA,Sex2,Born2,cardno,Address,ewm,'口岸限定区域许可证',zhiwu,testy,shiyou,'2',vcode,cardno_pic,login_id,mytime,danwei,mob)
elif sqlx=='3':
tsql = "insert into bj_cert(uname,gender,birthday,cardno,address,ewm,sqlx,zhiwu,sqsx,shiyou,flag,vcode,cardno_pic,apply_count,create_date,danwei,mob) values " \
"('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" % \
(NameA,Sex2,Born2,cardno,Address,ewm,'口岸限定区域车辆通行证',zhiwu,testy,shiyou,'2',vcode,cardno_pic,login_id,mytime,danwei,mob)
rs=updateSql(tsql)
if rs==1:
return '0'
else:
return '1'
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
print(99)
resp = make_response(render_template('error.html', basepath=BASEPATH, errormsg=('异常,详细 (%s)' % e)))
return resp
def checklogin():
username = request.form['username']
password = request.form['password']
try:
if username is None or password is None:
result = {
"status": "error",
"message": "用户名、密码不能为空！",
}
else:
find_weixin_id = "select id from bj_company_user where name ='%s' and password='******'" % (
username, password)
rows = getSelectSql(find_weixin_id)
if len(rows) > 0:
uid = rows[0][0]
sql = "select main_count from bj_company_user where id='%s'" % (
uid)
row = getSelectSql(sql)
if row[0][0]:
fid = row[0][0]
else:
fid = uid
# 已经可以释放的账号
sql = "select id from bj_company_user where statu=2 and now()>end_time+ '1 day' and id='%s'" % (
fid)
rows = getSelectSql(sql)
length = len(rows)
if length > 0:
uids = '('
if length == 1:
uids += str(rows[0][0])
else:
for r in rows:
uids += str(r[0]) + ','
uids = uids[:-1]
uids += ')'
sql = "update bj_company_user set statu=3,start_time=null,end_time=null where id in %s" % (
uids)
updateSql(sql)
sql = "select 1 from bj_company_user where id='%s' and statu=3" % (
fid)
row = getSelectSql(sql)
if len(row) > 0:
#从odoo校验身份成功之后
#由flask-login设置session和cookie
user = User()
vcode = uuid.uuid1()
user.vcode = vcode
user.id = uid
flask_login.login_user(user)
result = {
"status": "ok",
"message": "登录成功！",
}
else:
result = {
"status": "error",
"message": "该账号暂停使用！",
}
else:
result = {
"status": "error",
"message": "用户名或密码错误！",
}
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
result = {
"status": "error",
"message": '错误:%s' % e,
}
return json.dumps(result, ensure_ascii=False)
def cert_menu():
try:
user_id = flask_login.current_user.id
#根据用户搜索出对应的角色
sql = "select role_ref from bj_companyuser_role where user_ref='%s'" % (
user_id)
rows = getSelectSql(sql)
rids = '('
length = len(rows)
if length > 1:
for r in rows:
rids += str(r[0]) + ','
rids = rids[:-1]
rids += ')'
elif length == 1:
rids += str(rows[0][0]) + ')'
else:
rids = '(-1)'
#根据角色搜索到对应的菜单
sql="select bm.id,bm.name,bm.is_last,bm.pid,bm.url from bj_menu bm " \
"left join bj_role_menu brm on brm.menu_ref=bm.id where " \
"brm.role_ref in %s and bm.pid='0' group by bm.id,bm.name,bm.is_last,bm.pid,bm.url order by bm.create_date"%(rids)
rows = getSelectSql(sql)
menu = []
for r in rows:
s_menu_list = []
pid = r.id
f_menu_dic = {
"title": r.name,
"icon": "fa-cubes",
}
sql = "select bm.id,bm.name,bm.is_last,bm.pid,bm.url from bj_menu bm where bm.pid='%s'" % (
pid)
sub_menus = getSelectSql(sql)
for s in sub_menus:
s_menu_dic = {
"spread": True,
"title": s.name,
"icon": "fa-table",
"href": s.url
}
s_menu_list.append(s_menu_dic)
if len(s_menu_list) > 0:
f_menu_dic["children"] = s_menu_list
else:
f_menu_dic["href"] = r.url
menu.append(f_menu_dic)
return json.dumps(menu, ensure_ascii=False)
except Exception as e:
exstr = traceback.format_exc()
print(exstr)
resp = make_response(
render_template('error.html',
basepath=BASEPATH,
errormsg=('异常,详细 (%s)' % e)))
return resp
