def test_xhd_11_manager_approval(self):
"""高级审批经理审批"""
try:
# 获取审批经理ID
self.test_xhd_10_regional_prereview()
self.case_name = custom.get_current_function_name()
if self.next_user_id != self.senior_manager:
return
else:
# 下一个处理人重新登录
page = Login(self.next_user_id)
# 审批审核
result = self.PT.approval_to_review(page, self.apply_code,
u'高级审批经理审批')
if not result:
self.run_result = False
self.log.error("风控-高级审批经理审批失败")
raise AssertionError('风控-高级审批经理审批失败')
else:
self.log.info("风控-高级审批经理审批完成")
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code)
except Exception as e:
self.run_result = False
raise e
def test_10_part_authority_card_second_deal(self):
"""第二次权证办理"""
self.test_09_part_funds_raise()
self.case_name = custom.get_current_function_name()
page = Login(self.company["authority_member"]["user"])
# 修改数据库，将第一次请款修改为放款成功，然后才能发起第二次权证请款，否则第二次权证办理不能跟提交
db = database.DB()
sql_1 = "UPDATE house_common_loan_info t SET t.pay_date=sysdate, t.status='LOAN_PASS' \
WHERE t.apply_id= (SELECT t.apply_id FROM house_apply_info t \
WHERE t.apply_code =" + "'" + self.apply_code + "'" + ")"
contract_no = self.apply_code + '-3-02-1'
sql_2 = "UPDATE house_funds_info t SET t.Funds_Status = 21 \
WHERE t.apply_id = (SELECT t.apply_id FROM house_apply_info t \
WHERE t.apply_code = " + "'" + self.apply_code + "'" + ")" + "AND CONTRACT_NO =" + "'" + contract_no + "'"
db.sql_execute(sql_1)
db.sql_execute(sql_2)
db.sql_commit()
time.sleep(3)
# 权证员上传权证信息
res = self.WM.authority_card_transact_2(page, self.apply_code, 2,
self.env)
if not res:
self.log.error("上传权证资料失败")
raise ValueError("上传权证资料失败")
else:
self.log.info("权证办理完成")
self.next_user_id = common.get_next_user(page, self.apply_code)
def test_xhd_12_contract_signing(self):
"""签约"""
rec_bank_info = dict(
recBankNum=self.data['houseCommonLoanInfoList'][0]['recBankNum'],
recPhone=self.data['houseCommonLoanInfoList'][0]['recPhone'],
recBankProvince=self.data['houseCommonLoanInfoList'][0]
['recBankProvince'],
recBankDistrict=self.data['houseCommonLoanInfoList'][0]
['recBankDistrict'],
recBank=self.data['houseCommonLoanInfoList'][0]['recBank'],
recBankBranch=self.data['houseCommonLoanInfoList'][0]
['recBankBranch'],
)
# 获取合同打印专员ID
self.test_xhd_11_manager_approval()
self.case_name = custom.get_current_function_name()
# 下一个处理人重新登录
page = Login(self.next_user_id)
# 签约
rc = Cts.ContractSign(page, self.apply_code, rec_bank_info)
rs = rc.execute_enter_borroers_bank_info()
if not rs:
self.run_result = False
self.log.error("签约失败")
raise AssertionError('签约失败')
else:
rc.contract_submit()
self.log.info("签约成功")
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code)
def test_04_branch_director_upload_image(self):
"""分公司主管:上传权证资料"""
try:
self.case_name = custom.get_current_function_name()
custom.print_product_info(self.product_info)
custom.print_person_info(self.person_info)
# 1 客户信息-业务基本信息
if self.HAE.input_customer_base_info(self.page,
self.data['applyVo']):
self.log.info("录入基本信息完成")
# 2 客户基本信息 - 借款人/共贷人/担保人信息
self.HAE.input_customer_borrow_info(self.page,
self.data['custInfoVo'][0])
# 3 物业信息
self.HAE.input_all_bbi_property_info(
self.page, self.data['applyPropertyInfoVo'][0],
self.data['applyCustCreditInfoVo'][0], self.cust_name)
# 提交
self.HAE.submit(self.page)
self.log.info("申请件录入完成提交")
apply_code = self.AQ.get_applycode(self.page, self.cust_name)
if apply_code:
self.apply_code = apply_code
self.log.info("申请件查询完成")
print("apply_code:" + self.apply_code)
self.next_user_id = common.get_next_user(self.page,
self.apply_code)
# Login
page = Login(self.next_user_id)
res = self.PT.approval_to_review(page, self.apply_code,
u'分公司主管同意审批', 0, True)
if not res:
self.run_result = False
self.log.error("can't find applycode")
raise ValueError("can't find applycode")
else:
self.log.info("风控审批-分公司主管审批结束")
self.next_user_id = common.get_next_user(page, self.apply_code)
except Exception as e:
self.run_result = False
raise e
def test_03_receipt_first_approval(self):
"""第一次回执放款申请"""
self.test_02_part_receipt_manage_approval()
self.case_name = custom.get_current_function_name()
page = Login(self.next_user_id)
rec = self.PT.receipt_return(page, self.apply_code)
if not rec:
self.log.error("第一次回执放款申请失败")
raise ValueError('失败')
else:
self.log.info("第一次回执放款申请通过")
self.next_user_id = common.get_next_user(page, self.apply_code)
def test_13_part_finace_branch_manage_aproval_second(self):
"""第二次财务分公司主管审批"""
remark = u"财务分公司经理审批"
self.test_12_part_finace_transact_second()
self.case_name = custom.get_current_function_name()
page = Login(self.next_user_id)
result = self.FA.finace_approval(page, self.apply_code, remark)
if not result:
self.log.error("财务流程-分公司经理审批失败")
raise AssertionError('财务流程-分公司经理审批失败')
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code, 2)
def test_02_part_receipt_manage_approval(self):
"""回执分公司经理审批"""
self.test_01_part_receipt_director_approval()
self.case_name = custom.get_current_function_name()
page = Login(self.next_user_id)
rec = self.PT.receipt_return(page, self.apply_code)
if not rec:
self.log.error("回执审批经理审批失败")
raise ValueError('失败')
else:
self.log.info("回执审批经理审批通过")
self.next_user_id = common.get_next_user(page, self.apply_code)
def test_12_part_finace_transact_second(self):
"""第二次财务办理"""
self.test_11_part_warrent_request_money()
self.case_name = custom.get_current_function_name()
# 业务助理登录
page = Login(self.company["business_assistant"]["user"])
rs = self.FA.finace_transact(page, self.apply_code)
if not rs:
self.log.error("财务办理失败")
raise AssertionError('财务办理失败')
else:
self.log.info("财务办理结束！")
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code, 2)
def test_11_part_warrent_request_money(self):
"""第二次权证请款"""
self.test_10_part_authority_card_second_deal()
self.case_name = custom.get_current_function_name()
# 下一个处理人重新登录
page = Login(self.next_user_id)
# 部分请款
res = self.PT.part_warrant_apply(page, self.apply_code, 1)
if not res:
self.log.error("权证请款失败！")
raise ValueError('权证请款失败！')
else:
self.log.info("完成权证请款")
self.next_user_id = common.get_next_user(page, self.apply_code)
def test_one_person_sign(self):
"""单人签约"""
try:
self.before_contract_sign()
self.case_name = custom.get_current_function_name()
# 签约
common.make_signing(self.page, self.apply_code, self.rec_bank_info)
self.log.info("签约完成")
# 查看下一步处理人
self.next_user_id = common.get_next_user(self.page,
self.apply_code)
except Exception as e:
self.run_result = False
raise e
def risk_approval_result(self, res, mark, page, apply_code): """ 校验风控审批结果 :param res: 返回值传入 :param mark: 角色 :param page: 页面对象 :param apply_code: 申请件code :return: """ if not res: self.log.error(mark + ",审批失败") raise ValueError(mark + ",审批失败") else: self.log.info(mark + ",审批通过") self.next_user_id = common.get_next_user(page, apply_code)
def test_xhd_17_finace_approval_branch_manager(self):
"""财务分公司经理审批"""
remark = u"财务分公司经理审批"
# 下一个处理人
self.test_xhd_16_finace_transact()
self.case_name = custom.get_current_function_name()
page = Login(self.next_user_id)
result = self.FA.finace_approval(page, self.apply_code, remark)
if not result:
self.run_result = False
raise AssertionError('审批失败！')
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code, 1)
def test_14_part_finace_approval_risk_control_manager(self):
"""第二次财务风控经理审批"""
remark = u'风控经理审批'
self.test_13_part_finace_branch_manage_aproval_second()
self.case_name = custom.get_current_function_name()
page = Login(self.next_user_id)
result = self.FA.finace_approval(page, self.apply_code, remark)
if not result:
self.log.error("财务流程-风控经理审批出错")
raise AssertionError('财务流程-风控经理审批出错')
else:
self.log.info("财务流程-风控经理审批完成")
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code, 2)
def test_04_part_finace_transact(self):
"""部分请款-财务办理"""
# 权证请款
self.test_03_receipt_first_approval()
self.case_name = custom.get_current_function_name()
# 业务助理登录
page = Login(self.company["business_assistant"]["user"])
rs = self.FA.finace_transact(page, self.apply_code)
if not rs:
self.log.error("财务办理失败")
raise AssertionError('财务办理失败')
else:
self.log.info("财务办理结束！")
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code, 1)
def test_15_part_finace_approval_financial_accounting_second(self):
"""第二次财务会计审批"""
remark = u'财务会计审批'
self.test_14_part_finace_approval_risk_control_manager()
self.case_name = custom.get_current_function_name()
page = Login(self.next_user_id)
rs = self.FA.finace_approval(page, self.apply_code, remark)
if not rs:
self.log.error("财务流程-财务会计审批失败")
raise AssertionError('财务流程-财务会计审批失败')
else:
self.log.info("财务流程-财务会计审批完成")
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code, 2)
def test_gqt_10_regional_prereview(self):
"""区域预复核审批"""
# 获取区域预复核员ID
self.test_gqt_09_branch_manager_approval()
self.case_name = custom.get_current_function_name()
# 下一个处理人重新登录
page = Login(self.next_user_id)
# 审批审核
res = self.PT.approval_to_review(page, self.apply_code, u'区域预复核通过')
if not res:
self.run_result = False
raise ValueError("can't find applycode")
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code)
def test_gqt_09_branch_manager_approval(self):
"""分公司经理审批"""
# 获取分公司经理登录ID
self.test_gqt_08_branch_supervisor_approval()
self.case_name = custom.get_current_function_name()
# 下一个处理人重新登录
page = Login(self.next_user_id)
# 审批审核
res = self.PT.approval_to_review(page, self.apply_code, u'分公司经理同意审批')
if not res:
self.run_result = False
self.log.error("can't find applycode")
raise ValueError("can't find applycode")
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code)
def test_xhd_16_finace_transact(self):
"""财务办理"""
# 权证请款
self.test_xhd_15_warrant_apply()
self.case_name = custom.get_current_function_name()
# 业务助理登录
page = Login(self.company["business_assistant"]["user"])
result = self.FA.finace_transact(page, self.apply_code)
if not result:
self.run_result = False
self.log.error("财务办理失败")
raise AssertionError('财务办理失败')
else:
self.log.info("财务办理成功")
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code, 1)
def test_xhd_19_finace_approval_financial_accounting(self):
"""财务会计审批"""
remark = u'财务会计审批'
self.test_xhd_18_finace_approval_risk_control_manager()
self.case_name = custom.get_current_function_name()
page = Login(self.next_user_id)
result = self.FA.finace_approval(page, self.apply_code, remark)
if not result:
self.run_result = False
self.log.error("财务-财务会计审批出错！")
raise AssertionError('财务-财务会计审批出错')
else:
self.log.info("财务-财务会计审批完成！")
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code, 1)
def test_xhd_14_authority_card_member_transact(self):
"""权证办理"""
# 合规审查
self.test_xhd_13_compliance_audit()
self.case_name = custom.get_current_function_name()
# 权证员登录
page = Login(self.company["authority_member"]["user"])
# 权证员上传权证信息
res = self.WM.authority_card_transact(page, self.apply_code, self.env)
if not res:
self.run_result = False
self.log.error("权证员上传资料失败")
raise AssertionError('权证员上传资料失败')
else:
self.log.info("权证员上传资料成功！")
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code)
def test_07_senior_manager_upload_image(self):
"""高级审批经理-上传权证资料"""
try:
self.test_06_area_manage_upload_image()
self.case_name = custom.get_current_function_name()
# 高级审批审核，并上传资料
page = Login(self.next_user_id)
res = self.PT.approval_to_review(page, self.apply_code,
u'高级经理同意审批', 0, True)
if not res:
self.log.error("can't find applyCode")
raise ValueError("can't find applyCode")
else:
self.log.info("风控审批-高级经理审批结束")
self.next_user_id = common.get_next_user(page, self.apply_code)
except Exception as e:
self.run_result = False
raise e
def test_03_three_person_sign(self):
"""三人签约"""
try:
# 修改贷款金额
self.update_product_amount(600000)
self.before_contract_sign()
self.case_name = custom.get_current_function_name()
# 两个人签约
common.make_signing(self.page, self.apply_code, self.rec_bank_info,
3)
self.log.info("合同打印完成")
# 查看下一步处理人
self.next_user_id = common.get_next_user(self.page,
self.apply_code)
except Exception as e:
self.run_result = False
raise e
def test_gqt_11_manager_approval(self):
"""审批经理审批"""
# 获取审批经理ID
self.test_gqt_10_regional_prereview()
self.case_name = custom.get_current_function_name()
if self.next_user_id != self.senior_manager:
return
else:
# 下一个处理人重新登录
page = Login(self.next_user_id)
# 审批审核
res = self.PT.approval_to_review(page, self.apply_code, u'高级审批经理审批')
if not res:
self.run_result = False
self.log.error("can't find applycode")
raise ValueError("can't find applycode")
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code)
def test_gqt_19_funds_approval(self):
"""资金主管审批"""
remark = u'资金主管审批'
try:
self.test_gqt_18_finace_approval_risk_control_manager()
self.case_name = custom.get_current_function_name()
page = Login(self.next_user_id)
result = self.FA.finace_approval(page, self.apply_code, remark)
if result:
self.log.info("财务流程-资金主管审批结束")
else:
self.run_result = False
self.log.error("Error-资金主管审批报错！")
raise AssertionError('资金主管审批报错!')
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code, 1)
except Exception as e:
self.run_result = False
raise e
def test_gqt_20_finace_approval_financial_accounting(self):
"""财务会计审批"""
remark = u'财务会计审批'
try:
self.test_gqt_19_funds_approval()
self.case_name = custom.get_current_function_name()
page = Login(self.next_user_id)
result = self.FA.finace_approval(page, self.apply_code, remark)
if result:
self.log.info("财务流程-财务会计审批结束")
else:
self.run_result = False
self.log.error("Error-财务会计审批报错！")
raise AssertionError('Error-财务会计审批报错！')
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code, 1)
except Exception as e:
self.run_result = False
raise e
def test_05_branch_manage_upload_image(self):
"""分公司经理-上传权证资料"""
try:
self.test_04_branch_director_upload_image()
self.case_name = custom.get_current_function_name()
page = Login(self.next_user_id)
# 审批并上传权证资料
res = self.PT.approval_to_review(page, self.apply_code,
u'分公司经理同意审批', 0, True)
if not res:
self.run_result = False
self.log.error("can't find applycode")
raise ValueError("can't find applycode")
else:
self.log.info("风控审批-分公司经理审批结束")
self.next_user_id = common.get_next_user(page, self.apply_code)
except Exception as e:
self.run_result = False
raise e
def test_gqt_17_finace_approval_branch_manager(self):
"""财务分公司经理审批"""
remark = u"财务分公司经理审批"
try:
# 下一个处理人
self.test_gqt_16_finace_transact()
self.case_name = custom.get_current_function_name()
page = Login(self.next_user_id)
result = self.FA.finace_approval(page, self.apply_code, remark)
if not result:
self.run_result = False
raise ValueError('财务经理审批失败')
else:
self.log.info("财务流程-分公司经理审批结束")
self.next_user_id = common.get_next_user(page, self.apply_code, 1)
except Exception as e:
self.run_result = False
raise e
def test_xhd_09_branch_manager_approval(self):
"""分公司经理审批"""
try:
# 获取分公司经理登录ID
self.test_xhd_08_branch_supervisor_approval()
self.case_name = custom.get_current_function_name()
# 下一个处理人重新登录
page = Login(self.next_user_id)
# 审批审核
res = self.PT.approval_to_review(page, self.apply_code,
u'分公司经理同意审批')
if not res:
self.log.error("风控-分公司审批失败")
raise AssertionError('风控-分公司审批失败')
else:
self.log.info("风控-分公司经理完成!")
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code)
except Exception as e:
self.run_result = False
raise e
def test_xhd_10_regional_prereview(self):
"""区域预复核审批"""
try:
# 获取区域预复核员ID
self.test_xhd_09_branch_manager_approval()
self.case_name = custom.get_current_function_name()
# 下一个处理人重新登录
page = Login(self.next_user_id)
# 审批审核
rs = self.PT.approval_to_review(page, self.apply_code, u'区域预复核通过')
if not rs:
self.run_result = False
self.log.error("风控-区域预复核失败")
raise AssertionError('风控-区域预复核失败')
else:
self.log.info("风控-区域预复核成功！")
# 查看下一步处理人
self.next_user_id = common.get_next_user(page, self.apply_code)
except Exception as e:
self.run_result = False
raise e
def test_08_compliance_Officer_original(self):
"""合规审查员上传影像资料"""
try:
self.case_name = custom.get_current_function_name()
self.update_product_amount(2000000)
# ---------------------------------------------------------------------------------
# 1. 申请录入
# ---------------------------------------------------------------------------------
# 1 客户信息-业务基本信息
if self.HAE.input_customer_base_info(self.page,
self.data['applyVo']):
self.log.info("录入基本信息完成")
# 2 客户基本信息 - 借款人/共贷人/担保人信息
self.HAE.input_customer_borrow_info(self.page,
self.data['custInfoVo'][0])
# 3 物业信息
self.HAE.input_all_bbi_property_info(
self.page, self.data['applyPropertyInfoVo'][0],
self.data['applyCustCreditInfoVo'][0], self.cust_name)
# 提交
self.HAE.submit(self.page)
self.log.info("申请件录入完成提交")
apply_code = self.AQ.get_applycode(self.page, self.cust_name)
if apply_code:
self.apply_code = apply_code
self.log.info("申请件查询完成")
print("apply_code:" + self.apply_code)
# 流程监控
self.next_user_id = common.get_next_user(self.page,
self.apply_code)
# ---------------------------------------------------------------------------------------
# 2. 风控审批流程
# ---------------------------------------------------------------------------------------
# 下一个处理人重新登录
page = Login(self.next_user_id)
list_mark = ["分公司主管审批", "分公司经理审批", "区域预复核审批", "高级审批经理审批", "风控总监审批"]
for e in list_mark:
res = self.PT.approval_to_review(page, apply_code, e, 0)
self.risk_approval_result(res, e, page, apply_code)
# 下一个处理人重新登录
page = Login(self.next_user_id)
# -----------------------------------------------------------------------------
# 3. 合同打印
# -----------------------------------------------------------------------------
# 下一个处理人重新登录
page = Login(self.next_user_id)
res = ContractSign.ContractSign(page, self.apply_code,
self.rec_bank_info, 10)
res.execute_enter_borroers_bank_info()
res.contract_submit()
self.next_user_id = common.get_next_user(page, self.apply_code)
# 合规审查
# 下一个处理人重新登录
page = Login(self.next_user_id)
# 合规审查, 并上传影像资料
res = self.PT.compliance_audit(page, self.apply_code, True)
if res:
self.log.info("合规审批结束")
page.driver.quit()
else:
self.run_result = False
self.log.error("合规审查失败")
raise ValueError("合规审查失败")
except Exception as e:
self.run_result = False
raise e
