def change_password(id):
if request.method == 'POST':
try:
user = User.query.filter_by(id=id).first()
if user.login_password == GetStringMD5(request.form['old_password']):
user.login_password = GetStringMD5(request.form['login_password'])
else:
raise Exception
# 事务提交
db.session.commit()
# 消息闪现
flash('修改密码成功，请重新登录！','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('修改密码失败，为保障账号安全，请重新登录后再尝试修改！','error')
logout_user()
return redirect("login")
else:
return render_template("change_password.html")
def edit_role(id):
if request.method == 'POST':
try:
chk = Role.query.filter("role_name='"+request.form['role_name']+"' and id<>"+str(id)).all()
if(chk):
# 消息闪现
flash('保存失败，角色名重复','error')
return redirect('System/role.page/1')
Role.query.filter_by(id=id).update({"role_name":request.form['role_name']})
# 事务提交
db.session.commit()
# 消息闪现
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
finally:
xmlUtil.updateDynDict('role_all')
return redirect('System/role.page/1')
elif request.method == 'GET':
role = Role.query.filter_by(id=id).first()
return render_template("System/role/edit_role.html",role=role)
def change_belong_user():
try:
user = User.query.filter_by(id=request.form['user_id']).first()
user.org_id = None
user.pId = request.form['belong_user']
sql = "FIND_IN_SET(id ,getUserList('"+request.form['user_id']+"'))"
users = User.query.filter(sql).order_by("id").all()
for obj in users:
if str(obj.id) == request.form['belong_user']:#环状结构 不允许
# 消息闪现
flash('保存失败 不允许环状结构! ','error')
return render_template("System/user/user.html")
# 事务提交
db.session.commit()
# 消息闪现
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return render_template("System/user/user.html")
def new_role():
if request.method == 'POST':
try:
chk = Role.query.filter_by(role_name=request.form['role_name']).all()
if(chk):
# 消息闪现
flash('保存失败，角色名重复','error')
return redirect('System/role.page/1')
# 保存角色
Role(request.form['role_name']).add()
# 事务提交
db.session.commit()
# 消息闪现
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
finally:
xmlUtil.updateDynDict('role_all')
return redirect('System/role.page/1')
elif request.method == 'GET':
return render_template("System/role/new_role.html")
def save_pgjl_info(id):
try:
info = Rcs_Application_Info.query.filter_by(id=id).first()
last_advice = request.form['last_advice']
last_approve = request.form['last_approve']
approve_advice = request.form['advice_end']
advice = Rcs_Application_Advice.query.filter_by(application_id=id,user_id=current_user.id).first()
if advice:
advice.approve_result = last_advice
advice.approve_ed = last_approve
else:
Rcs_Application_Advice(id,approve_advice,last_advice,last_approve,"2").add()
#进件标志
info.approve_type=Application_Type_Finish
#保存进件日志
Rcs_Application_Log(id,info.customer_id,info.customer_name,last_advice,last_approve).add()
#保存缺席专家日志
#未评估专家
expert = Rcs_Application_Expert.query.filter("application_id="+str(id)+" and expert_id not in (select user_id from rcs_application_advice where application_id="+str(id)+")").all()
for obj in expert:
Rcs_Application_Absent(id,info.card_id,info.customer_name,obj.expert_id,obj.rcs_expert_ibfk_1.real_name).add()
db.session.commit()
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return redirect("/zxpgjl/pgjl_info/"+str(id))
def new_zjxxgl_save():
try:
user_name = request.form['user_name']
sex = request.form['sex']
card_id = request.form['card_id']
phone = request.form['phone']
level = request.form['level']
org = request.form['org']
address = request.form['address']
hy = request.form['hy']
qy = request.form['qy']
product = request.form['product']
balance = request.form['balance']
zyzc = request.form['zyzc']
xrzw = request.form['xrzw']
expert_level = request.form['expert_level']
approve_role = request.form['approve_role']
gzr = request.form['gzr']
gzsd = request.form['gzsd']
user = User(user_name,GetStringMD5('111111'),user_name,sex,phone,1,'',card_id,level,org,None)
user.add()
db.session.flush()
Rcs_Expert_Information(user.id,address,hy,qy,product,balance,zyzc,xrzw,expert_level,approve_role,gzr,gzsd).add()
db.session.commit()
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return redirect('/pgzjgl/zjxxgl/1')
def interface_test_save():
companyName = request.form['companyName']
companyAbbr = request.form['companyAbbr']
contactPhone = request.form['contactPhone']
filingNumber = request.form['filingNumber']
companyAddress = request.form['companyAddress']
httpClient = None
try:
params = urllib.urlencode({'companyName': companyName, 'companyAbbr': companyAbbr,'contactPhone': contactPhone,
'filingNumber': filingNumber,'companyAddress': companyAddress})
headers = {"Content-type": "application/x-www-form-urlencoded"
, "Accept": "text/plain"}
httpClient = httplib.HTTPConnection("139.196.50.242/jbda/qkInterface/syncInstitution.do", 80, timeout=30)
httpClient.request("POST", "/PCCredit/ipad/customerInfor/insert.json", params, headers)
response = httpClient.getresponse().read()
if "errorcode" in response or response is None:
flash('同步失败','error')
else:
content = json.loads(response)
#返回状态
org_status = content["status"].encode("utf-8")
if str(org_status)=='0':
byCompanyCode = content["byCompanyCode"].encode("utf-8")
OrgTest(companyName,companyAbbr,contactPhone,filingNumber,companyAddress,byCompanyCode).add()
db.session.commit()
flash('同步成功','success')
except:
logger.exception('exception')
finally:
if httpClient:
httpClient.close()
return render_template("jbdaInterface/interface_test.html")
def save_advice(application_id):
try:
result = request.form['result']
advice = request.form['advice']
je = request.form['je']
info = Rcs_Application_Info.query.filter_by(id=application_id).first()
rcs = Rcs_Application_Advice.query.filter_by(application_id=info.id,user_id=current_user.id).first()
if rcs:
rcs.approve_advice = advice
rcs.approve_result = result
rcs.approve_ed = je
#普通专家
rcs.advice_type = "1"
else:
Rcs_Application_Advice(info.id,advice,result,je,"1").add()
expert = Rcs_Application_Expert.query.filter_by(application_id=info.id,expert_id=current_user.id).first()
if expert:
#设置专家已完成此进件评估
expert.operate = 1
#保存进件日志
Rcs_Application_Log(application_id,info.card_id,info.customer_name,result,je).add()
db.session.commit()
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return redirect("Process/dqdc/show_advice.page/"+str(application_id))
def xxlr_syb_bz_save(loan_apply_id):
try:
xxlr.xxlr_syb_bz_save(loan_apply_id,request)
return helpers.show_result_success("")
except:
logger.exception('exception')
return helpers.show_result_fail("")
def new_user(pId):
if request.method == 'GET':
roles = Role.query.order_by("id").all()
return render_template("System/user/new_user.html",roles=roles,pId=pId)
else:
try:
chk = User.query.filter_by(login_name=request.form['login_name']).all()
if(chk):
# 消息闪现
flash('保存失败，登录名重复','error')
return redirect('System/user.page/1')
level = request.form['level']
if('user' in pId):
user = User(request.form['login_name'],GetStringMD5(request.form['login_password']),
request.form['real_name'],request.form['sex'],request.form['mobile'],request.form['active'],request.form['email'],request.form['card_id'],level,
None,int(pId.split("_")[1]))
user.add()
else:
user = User(request.form['login_name'],GetStringMD5(request.form['login_password']),
request.form['real_name'],request.form['sex'],request.form['mobile'],request.form['active'],request.form['email'],request.form['card_id'],level,
int(pId.split("_")[1]),None)
user.add()
#清理缓存
db.session.flush()
UserRole(user.id,request.form['roles']).add()
# 专家
if level!='3':
#专家信息
address = request.form['address']
hy = request.form['hy']
qy = request.form['qy']
product = request.form['product']
balance = request.form['balance']
zyzc = request.form['zyzc']
xrzw = request.form['xrzw']
expert_level = request.form['expert_level']
approve_role = request.form['approve_role']
gzr = request.form['gzr']
gzsd = request.form['gzsd']
Rcs_Expert_Information(user.id,address,hy,qy,product,balance,zyzc,xrzw,expert_level,approve_role,gzr,gzsd).add()
# 事务提交
db.session.commit()
# 消息闪现
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
finally:
xmlUtil.updateDynDict('user_all')
return redirect('System/user.page/1')
def xxlr_upload_image(loan_apply_id):
try:
xxlr.upload_image(loan_apply_id,request)
# 消息闪现
flash('保存成功','success')
except:
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return redirect("/xxlr/image_list.page/"+str(loan_apply_id)+"/1/write")
def accessright_save_json(roleId):
try:
decodejson = json.loads(request.form['nodesJsonStr'])
access_right.accessright_save_json(roleId, decodejson)
# 消息闪现
flash('保存成功','success')
return helpers.show_result_success('') # 返回json
except:
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return helpers.show_result_fail('') # 返回json
def edit_zjxxgl_save(id):
try:
#获取专家信息
user = User.query.filter_by(id=id).first()
user_information = Rcs_Expert_Information.query.filter_by(expert_id=id).first()
user_name = request.form['user_name']
sex = request.form['sex']
card_id = request.form['card_id']
mobile = request.form['phone']
level = request.form['level']
org = request.form['org']
address = request.form['address']
hy = request.form['hy']
qy = request.form['qy']
product = request.form['product']
balance = request.form['balance']
zyzc = request.form['zyzc']
xrzw = request.form['xrzw']
expert_level = request.form['expert_level']
approve_role = request.form['approve_role']
gzr = request.form['gzr']
gzsd = request.form['gzsd']
user.login_name=user_name
user.real_name=user_name
user.sex=sex
user.card_id=card_id
user.mobile=mobile
user.user_type=level
user.org_id=org
user_information.address=address
user_information.hy=hy
user_information.qy=qy
user_information.product=product
user_information.balance=balance
user_information.zyzc=zyzc
user_information.xrzw=xrzw
user_information.expert_level=expert_level
user_information.approve_role=approve_role
user_information.gzr=gzr
user_information.gzsd=gzsd
db.session.commit()
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return redirect('/pgzjgl/zjxxgl')
def excel_import():
if request.method == 'POST':
try:
pldr.excel_import(request)
# 消息闪现
flash('保存成功','success')
except:
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return redirect("/mxpg/pldr/1")
else:
return redirect("/mxpg/pldr/1")
def _deco(*args, **kwargs):
try:
func(*args, **kwargs)
db.session.commit()
# 消息闪现
flash('保存成功','success')
except Exception:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return render_template("errors/500.html",error=Exception)
def save_jjfa():
try:
name = request.form['name']
card_id = request.form['card_id']
index_id = request.form['index_id']
bank_id = request.form['bank_id']
place_all = ''
place_all_name = ''
#联动1
regPermResidence_1 = request.form['regPermResidence_1']
indiv = Indiv_Brt_Place.query.filter_by(type_code=regPermResidence_1.split('_')[1]).first()
place_all_name+=indiv.type_name
place_all+=regPermResidence_1.split('_')[1]
place = Indiv_Brt_Place.query.filter_by(parent_code=regPermResidence_1.split('_')[1]).first()
if place:
#联动2
regPermResidence_2 = request.form['regPermResidence_2']
indiv_1 = Indiv_Brt_Place.query.filter_by(type_code=regPermResidence_2.split('_')[1]).first()
place_all+="|"+regPermResidence_2.split('_')[1]
place_all_name+=indiv_1.type_name
place_2 = Indiv_Brt_Place.query.filter_by(parent_code=regPermResidence_2.split('_')[1]).first()
if place_2:
regPermResidence_3 = request.form['regPermResidence_3']
indiv_2 = Indiv_Brt_Place.query.filter_by(type_code=regPermResidence_3.split('_')[1]).first()
place_all+="|"+regPermResidence_3.split('_')[1]
place_all_name+=indiv_2.type_name
org_id = request.form['org_id']
industry_id = request.form['industry_id']
district_id = request.form['district_id']
product_id = request.form['product_id']
approve_limit = request.form['approve_limit']
manager_id = request.form['manager_id']
sh_user = request.form['sh_user']
sp_user = request.form['sp_user']
#进件状态为1
approve_type = '1'
#进件模型类型,未定义
model_type=0
Rcs_Application_Info(index_id,name,card_id,product_id,approve_limit,org_id,place_all_name,place_all,industry_id,district_id,manager_id,sh_user,sp_user,approve_type,model_type,None).add()
db.session.commit()
# 消息闪现
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return redirect("/jjrwfa/jjfa/1")
def cspz_hknl_save(score):
try:
Rcs_Parameter.query.filter_by(parameter_name="hknl").delete()
Rcs_Parameter("hknl",score).add()
db.session.commit()
# 消息闪现
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return redirect("/mxpg/cspz_hknl")
def xxlr_hknl_bz(loan_apply_id):
try:
xxlr.compute_hknl_bz(loan_apply_id)
except:
logger.exception('exception')
sc_application_hknl = SC_Application_Hknl.query.filter_by(loan_apply_id=loan_apply_id).first()
#取出还款能力旧数据
form_data = {}
if(sc_application_hknl):
tmp = sc_application_hknl.form_data
for key_value in tmp.split('&'):
form_data[key_value.split("=")[0]]=key_value.split("=")[1]
return render_template("xxlr/hknl_bz.html",loan_apply_id=loan_apply_id,form_data=form_data)
def edit_select_delete(p_id):
select = Rcs_Parameter_Select.query.filter_by(id=p_id).first()
tree = Rcs_Parameter_Tree.query.filter_by(id=select.tree_id).first()
Rcs_Parameter_Select.query.filter_by(id=p_id).delete()
try:
db.session.commit()
# 消息闪现
flash('删除成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('删除失败','error')
return redirect("/parameter/model_"+tree.param_type)
def add_select_save(p_id):
try:
tree = Rcs_Parameter_Tree.query.filter_by(id=p_id).first()
name = request.form["name"]
score = request.form["score"]
Rcs_Parameter_Select(p_id,name,score).add()
db.session.commit()
# 消息闪现
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return redirect("/parameter/model_"+tree.param_type)
def change_belong_org():
try:
user = User.query.filter_by(id=request.form['user_id']).first()
user.pId = None
user.org_id = request.form['belong_org']
# 事务提交
db.session.commit()
# 消息闪现
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return render_template("System/user/user.html")
def add_tree_save(p_id):
try:
name = request.form["name"]
weight = request.form["weight"]
tree = Rcs_Parameter_Tree.query.filter_by(id=p_id).first()
Rcs_Parameter_Tree(tree.param_type,name,p_id,weight,int(tree.level_type)+1).add()
db.session.commit()
# 消息闪现
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return redirect("/parameter/model_"+tree.param_type)
def autoChild(p_id):
tree = Rcs_Parameter_Tree.query.filter_by(pId=p_id).all()
if tree:
return "false"
else:
try:
Rcs_Parameter_Tree.query.filter_by(id=p_id).delete()
db.session.commit()
# 消息闪现
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return "true"
def edit_tree_save(p_id):
try:
name = request.form["name"]
weight = request.form["weight"]
tree = Rcs_Parameter_Tree.query.filter_by(id=p_id).first()
tree.name = name
tree.weight = weight
db.session.commit()
# 消息闪现
flash('修改成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('修改失败','error')
return redirect("/parameter/model_"+tree.param_type)
def delete_role(id):
try:
UserRole.query.filter_by(role_id=id).delete()
Role.query.filter_by(id=id).delete()
# 事务提交
db.session.commit()
# 消息闪现
flash('删除成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('删除失败','error')
finally:
xmlUtil.updateDynDict('role_all')
return ''
def edit_select_save(p_id):
name = request.form["name"]
score = request.form["score"]
select = Rcs_Parameter_Select.query.filter_by(id=p_id).first()
select.name = name
select.score = score
tree = Rcs_Parameter_Tree.query.filter_by(id=select.tree_id).first()
try:
db.session.commit()
# 消息闪现
flash('修改成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('修改失败','error')
return redirect("/parameter/model_"+tree.param_type)
def disable_user(type,id):
try:
user = User.query.filter_by(id=id).first()
user.active = type
# 事务提交
db.session.commit()
# 消息闪现
flash('保存成功','success')
return helpers.show_result_success('保存成功')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return helpers.show_result_fail('保存失败')
finally:
xmlUtil.updateDynDict('user_all')
def refuse():
try:
id = request.form['hiddenId']
refuse_reason = request.form['refuse_reason']
#删除进件关系表
Rcs_Application_Expert.query.filter_by(application_id=id,expert_id=current_user.id).delete()
db.session.flush()
info = Rcs_Application_Info.query.filter_by(id=id).first()
Rcs_Expert_Refuse(current_user.id,current_user.real_name,id,info.customer_name,refuse_reason,None,'').add()
db.session.commit()
# 消息闪现
flash('拒绝成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('拒绝失败','error')
return redirect("zjzxpggl/yjsrw/1")
def has_refuse_save():
try:
id = request.form['hiddenId']
expert_id = request.form['expert']
refuse = Rcs_Expert_Refuse.query.filter_by(id=id).first()
users = User.query.filter_by(id=expert_id).first()
refuse.new_expert_id = expert_id
refuse.new_expert_name = users.real_name
#进件关系表添加记录
Rcs_Application_Expert(refuse.application_id,expert_id).add()
db.session.commit()
# 消息闪现
flash('重分配成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('重分配失败','error')
return redirect("/zjzxpggl/has_refuse/1")
def cancel_save(id):
try:
#删除未评估专家
Rcs_Application_Expert.query.filter_by(application_id=id,operate=0).delete()
db.session.flush()
#重新保存评估专家
expertId = request.form.getlist('expert')
for obj in expertId:
#判断是否重复
expert = Rcs_Application_Expert.query.filter_by(application_id=id,expert_id=obj).first()
if not expert:
Rcs_Application_Expert(id,int(obj)).add()
db.session.commit()
flash('撤销成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('撤销失败','error')
return redirect("/zxpgjl/pgjl_info/"+str(id))