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)