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