def countmanager_bansave():
try:
if request.method == 'GET':
uids = request.args.get('uids')
uids = uids.split(',')
for u in uids:
tsql = "update bj_company_user set start_time=null,end_time=null,statu='3' where id='%s'" % (
u)
updateSql(tsql)
return '0'
uids = request.form.get('uids')
start_time = request.form.get('start_time')
end_time = request.form.get('end_time')
uids = uids.split(',')
for u in uids:
tsql = "update bj_company_user set start_time='%s',end_time='%s',statu='%s' where id='%s'" % (
start_time, end_time, 2, u)
updateSql(tsql)
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 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 patrolmanager_delete(id):
try:
tsql="delete from zdk_patrol where id=%s"%(id)
updateSql(tsql)
return redirect(url_for("patrolmanager_list"))
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 downloadimg():
re = wcmgr.getWc_Sdk(6).get_departmentuserdetailinfo(1, 1, 1)
userlist = json.loads(re.text)['userlist']
mytime = time.strftime(ISOTIMEFORMAT, time.localtime())
for user in userlist:
isql = "update zdk_user set head_url='%s' where phone='%s'" % (
user['avatar'], user['mobile'])
updateSql(isql)
logsql = "insert into zdk_log(sendmsg,recmsg) values('%s','微信头像同步成功')" % (
mytime)
updateSql(logsql)
print('微信头像同步成功')
def rolemanager_delete(id):
try:
sql="delete from bj_role_menu where role_ref='%s'"%(id)
updateSql(sql)
tsql="delete from bj_role where id=%s"%(id)
updateSql(tsql)
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 countmanager_delete(id):
try:
tsql = "delete from bj_company_user where id=%s" % (id)
updateSql(tsql)
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 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 insert_all(json_data, list):
print(3)
for x in json_data:
if x in list:
value = json_data[x]
sql = 'update bj_crews set "%s"=\'%s\' where "UNID"=\'%s\'' % (
x, value, json_data["UNID"])
rf = updateSql(sql)
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 patrolmanager_save():
try:
type = request.form.get('type')
content = request.form.get('content')
status = request.form.get('status')
result = request.form.get('result')
remark = request.form.get('remark')
mytime = time.strftime(ISOTIMEFORMAT, time.localtime())
patrol_id = request.form.get('id')
if patrol_id:
tsql = "update zdk_patrol set type='%s',content='%s',state='%s',cl_result='%s',remark='%s',create_date='%s' where id=%s" % (type,content,status,result, remark,mytime,patrol_id)
else:
pass
updateSql(tsql)
return redirect(url_for("patrolmanager_list"))
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_save():
try:
name = request.form.get('name')
menus = request.form.get('menus')
remark = request.form.get('remark')
mids=menus.split(',')
role_id = request.form.get('id')
if role_id:
tsql = "update bj_role set name='%s',remark='%s' where id=%s" % (name, remark, role_id)
updateSql(tsql)
sql="delete from bj_role_menu where role_ref='%s'"%(role_id)
updateSql(sql)
else:
sys = flask_login.current_user.sys
createpams={
"name":name,
"remark":remark,
"sys":sys
}
role_id = server.execute(info['db'], 1, info['password'], "bj.role", "create", createpams)
for m in mids:
sql="insert into bj_role_menu(role_ref,menu_ref) values('%s','%s')"%(role_id,m)
updateSql(sql)
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 cmanager_save():
try:
name = request.form.get('name')
remark = request.form.get('remark')
mytime = time.strftime(ISOTIMEFORMAT, time.localtime())
com_id = request.form.get('id')
if com_id:
tsql = "update bj_company set name='%s',remark='%s' where id=%s" % (
name, remark, com_id)
else:
tsql = "insert into bj_company(name,remark,create_date) values('%s','%s','%s')" % (
name, remark, mytime)
updateSql(tsql)
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_save():
try:
user_id = flask_login.current_user.id
companyid = flask_login.current_user.companyid
name = request.form.get('name')
pwd = request.form.get('pwd')
role_ref = request.form.get('roles')
uid=request.form.get('id')
mytime=time.strftime( ISOTIMEFORMAT, time.localtime() )
rids=role_ref.split(',')
if uid:
sql="delete from bj_companyuser_role where user_ref='%s'"%(uid)
updateSql(sql)
createpams = {
"name": name,
"password": pwd,
}
server.execute(info['db'], 1, info['password'], "bj.company.user", "write",int(uid), createpams)
else:
createpams = {
"name": name,
"password": pwd,
"companyid":companyid,
"main_count": user_id
}
uid = server.execute(info['db'], 1, info['password'], "bj.company.user", "create", createpams)
for r in rids:
if r:
sql="insert into bj_companyuser_role(user_ref,role_ref) values('%s','%s')"%(uid,r)
updateSql(sql)
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 countmanager_save():
try:
name = request.form.get('name')
pwd = request.form.get('pwd')
com = request.form.get('com')
cid = request.form.get('id')
mytime = time.strftime(ISOTIMEFORMAT, time.localtime())
if cid:
tsql = "update bj_company_user set name='%s',password='******',companyid='%s' where id='%s'" % (
name, pwd, com, cid)
else:
tsql = "insert into bj_company_user(name,password,companyid,create_date,statu) values('%s','%s','%s','%s','3')" % (
name, pwd, com, mytime)
updateSql(tsql)
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 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 insert_unid(unid):
print(2)
sql = 'insert into bj_crews ("UNID") values (\'%s\')' % (unid)
rs = updateSql(sql)
def delete(unid):
print(4)
sql = 'delete from bj_crews where "UNID"=\'%s\'' % (unid)
rf = updateSql(sql)
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)
