def edit_dkfk(id):
try:
#保存SC_Approval_Decision剩余信息
approval_decision = SC_Approval_Decision.query.filter_by(loan_apply_id=id).first()
approval_decision.loan_date = request.form['loan_date']
approval_decision.first_repayment_date = request.form['first_repayment_date']
#approval_decision.management_coats = request.form['management_coats']
#approval_decision.agency_coats = request.form['agency_coats']
approval_decision.contract_date = request.form['contract_date']
approval_decision.loan_account = request.form['loan_account']
#approval_decision.bank_customer_no = request.form['bank_customer_no']
approval_decision.loan_contract_number = request.form['loan_contract_number']
approval_decision.guarantee_contract_number = request.form['guarantee_contract_number']
approval_decision.collateral_contract_number = request.form['collateral_contract_number']
#保存还款计划
repayment_plan_id = 0
repayment_plan = SC_Repayment_Plan.query.filter_by(loan_apply_id=id).first()
if repayment_plan:
repayment_plan_id = repayment_plan.id
repayment_plan.repayment_type=request.form['repayment_type']
repayment_plan.amount=request.form['amount']
repayment_plan.lending_date=request.form['loan_date']
repayment_plan.first_repayment_date=request.form['first_repayment_date']
repayment_plan.ratio=request.form['rates']
repayment_plan.installmenst=request.form['deadline']
repayment_plan.modify_user=current_user.id
repayment_plan.modify_date=datetime.datetime.now()
else:
repayment_plan_new = SC_Repayment_Plan(id,request.form['repayment_type'],request.form['amount'],
request.form['loan_date'],request.form['loan_date'],request.form['rates'],
request.form['deadline'])
repayment_plan_new.add()
db.session.flush()
repayment_plan_id = repayment_plan_new.id
#保存还款细则
SC_Repayment_plan_detail.query.filter_by(loan_apply_id=id,change_record=1).delete()
db.session.flush()
for i in range(1,int(request.form['deadline'])+1):
SC_Repayment_plan_detail(repayment_plan_id,id,None,request.form['rates'],
request.form['mybj%d' % i],request.form['mylx%d' % i],
request.form['mybx%d' % i],i,request.form['myrq%d' % i],None,1).add()
loan_apply = SC_Loan_Apply.query.filter_by(id=id).first()
loan_apply.process_status = PROCESS_STATUS_DKFKJH
# 事务提交
db.session.commit()
#计算绩效
reckonIncome(id)
# 消息闪现
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return redirect("Process/dkfk/dkfk")
def do_excel_import(id):
try:
# A岗 B岗 运营岗
A_loan_officer = request.form["A_loan_officer"]
B_loan_officer = request.form["B_loan_officer"]
yunying_loan_officer = request.form["yunying_loan_officer"]
# 贷审会
examiner_1 = request.form["examiner_1"]
examiner_2 = request.form["examiner_2"]
approver = request.form["approver"]
# 读文件 存DB
localexcel = SC_Local_Excel.query.filter_by(id=id).first()
file = os.path.join(LOCALEXCEL_FOLDER_ABS, "%d\\%s" % (current_user.id, localexcel.attachment))
loan_apply_id = record.read_file(
file, A_loan_officer, B_loan_officer, yunying_loan_officer, examiner_1, examiner_2, approver
)
# 保存SC_Approval_Decision剩余信息
approval_decision = SC_Approval_Decision(
loan_apply_id,
None,
1,
request.form["amount"],
request.form["deadline"],
request.form["rates"],
request.form["repayment_type"],
5000,
1,
1,
1,
"",
"",
"",
)
approval_decision.add()
db.session.flush()
# approval_decision = SC_Approval_Decision.query.filter_by(loan_apply_id=loan_apply_id).first()
approval_decision.loan_date = request.form["loan_date"]
approval_decision.first_repayment_date = request.form["first_repayment_date"]
# approval_decision.management_coats = request.form['management_coats']
# approval_decision.agency_coats = request.form['agency_coats']
approval_decision.contract_date = request.form["contract_date"]
approval_decision.loan_account = request.form["loan_account"]
# approval_decision.bank_customer_no = request.form['bank_customer_no']
approval_decision.loan_contract_number = request.form["loan_contract_number"]
approval_decision.guarantee_contract_number = request.form["guarantee_contract_number"]
approval_decision.collateral_contract_number = request.form["collateral_contract_number"]
# 保存还款计划
repayment_plan_id = 0
repayment_plan = SC_Repayment_Plan(
id,
request.form["repayment_type"],
request.form["amount"],
request.form["loan_date"],
request.form["loan_date"],
request.form["rates"],
request.form["deadline"],
)
repayment_plan.add()
db.session.flush()
repayment_plan.create_user = current_user.id
repayment_plan.create_date = datetime.datetime.now()
repayment_plan.modify_user = current_user.id
repayment_plan.modify_date = datetime.datetime.now()
repayment_plan_id = repayment_plan.id
# 保存还款细则
SC_Repayment_plan_detail.query.filter_by(loan_apply_id=loan_apply_id, change_record=1).delete()
db.session.flush()
for i in range(1, int(request.form["deadline"]) + 1):
SC_Repayment_plan_detail(
repayment_plan_id,
id,
None,
request.form["rates"],
request.form["mybj%d" % i],
request.form["mylx%d" % i],
request.form["mybx%d" % i],
i,
request.form["myrq%d" % i],
None,
1,
).add()
# 是否已同步
localexcel.is_sync = 1
# 事务提交
db.session.commit()
# 消息闪现
flash("保存成功", "success")
except:
# 回滚
db.session.rollback()
logger.exception("exception")
# 消息闪现
flash("保存失败", "error")
return redirect("Data/data_excel")