def test_015_del_Urge(self):
"""
删除催收数据
:return:
"""
user_uuids = xqkj_query.get_tbl_infos(
'Tbl_PlatformUserProfile', 'platform_user_profile_uuid',
'POSITION("{}" IN name)'.format(loginAction.sign))
user_uuid = xqkj_query.get_info(
'Tbl_PlatformUserProfile', 'platform_user_profile_uuid',
'email="{}"'.format(loginAction.super_email))
app_user_uuid = loginAction.get_user_uuid()
urge_uuids = xqkj_query.select_infos('Tbl_Urge', 'urge_uuid',
'user_uuid', user_uuids)
urge_uuids2 = xqkj_query.select_infos('Tbl_Urge', 'urge_uuid',
'user_uuid', user_uuid)
xqkj_query.delete_infos('Tbl_PlatformUserProfileCollection',
'platform_user_profile_uuid', user_uuids)
xqkj_query.delete_infos('Tbl_PlatformUserProfileCollection',
'platform_user_profile_uuid', user_uuid)
xqkj_query.delete_infos('Tbl_Urge', 'user_uuid', app_user_uuid)
xqkj_query.delete_infos('Tbl_Urge', 'user_uuid', user_uuids)
xqkj_query.delete_infos('Tbl_UrgeUserRelation', 'user_profile_uuid',
app_user_uuid)
xqkj_query.delete_infos('Tbl_UrgeUserRelation',
'platform_user_profile_uuid', user_uuids)
xqkj_query.delete_infos('Tbl_UrgeUserRelation',
'platform_user_profile_uuid', user_uuid)
xqkj_query.delete_infos('Tbl_UrgeFile', 'urge_uuid', urge_uuids)
xqkj_query.delete_infos('Tbl_UrgeFile', 'urge_uuid', urge_uuids2)
def test_037_test_api_78dk_app_process_saveContractSupplementImages(self):
"""
保存补充资料（新）
:return:
"""
global contract_uuid
contract_uuid = xqkj_query.get_contract_uuid_for_user(
loginAction.get_user_uuid())
loginAction.global_dict.set(contract_uuid=contract_uuid)
res = json.loads(
AppAction.test_api_78dk_app_process_saveContractSupplementImages(
datalist=[], contractuuid=contract_uuid))
Assertion.verity(res['code'], '10000')
def test_006_api_78dk_platform_prompt_urge_manual_allocation(self):
"""
Time :2019-10-08
author : 闫红
desc :手动分案v1.5.2，手动分案时，催收员必须是 开启分案 状态
"""
global app_user_uuid
app_user_uuid = loginAction.get_user_uuid()
res = json.loads(
WebAction.test_api_78dk_platform_prompt_urge_manual_allocation(
urgeuuid=userUuid, useruuids=[app_user_uuid]))
Assertion.verity(res['code'], '20000')
Assertion.verity(res['msg'], '您提交的参数异常')
def test_001_active_contract(self):
"""
激活订单，修改订单状态未机审通过
:return:
"""
global contract_uuid, app_user_uuid
app_user_uuid = loginAction.get_user_uuid()
contract_uuid = xqkj_query.get_contract_uuid_for_user(app_user_uuid)
# contract_uuid = '3222d8b7acac4a45a91f0b1b01bd6fec'
# contract_uuid = xqkj_query.get_contract_uuid_for_machine()
loginAction.global_dict.set(contract_uuid=contract_uuid)
loginAction.global_dict.set(app_user_uuid=app_user_uuid)
# 修改订单状态为机审通过
xqkj_query.update_contract_machine_pass(contract_uuid, app_user_uuid)
def test_001_api_78dk_app_process_saveOrcInfo(self):
"""
保存人脸识别结果
:return:
"""
global firstkey, secondkey, thirdkey, note, user_uuid
firstkey = secondkey = thirdkey = 'base64_1560837249133.jpeg'
note = ''
user_uuid = loginAction.get_user_uuid()
# firstkey, secondkey, thirdkey, note, user_uuid = xqkj_query.get_info(
# 'Tbl_UserOcrInfo', 'first_key,second_key,third_key,note,user_uuid')
loginAction.global_dict.set(user_uuid=user_uuid)
res = json.loads(
AppAction.test_api_78dk_app_process_saveOrcInfo(
firstkey=firstkey,
secondkey=secondkey,
thirdkey=thirdkey,
note=note,
contractuuid='',
result=1))
Assertion.verity(res['code'], '10000')
def test_016_del_bill(self):
"""
客户账单逾期流水表、客户账单流水表
:return:
"""
user_uuid = loginAction.get_user_uuid()
contract_uuids = xqkj_query.get_tbl_infos(
'Tbl_Contract', 'contract_uuid',
'user_uuid="{}"'.format(user_uuid))
user_bill_uuids = list()
if contract_uuids:
user_bill_uuids = xqkj_query.select_infos('Tbl_Contract',
'user_bill_uuid',
'contract_uuid',
contract_uuids)
xqkj_query.delete_info('Tbl_UserBill',
'user_uuid="{}"'.format(user_uuid))
xqkj_query.delete_infos('Tbl_UserBill', 'contract_uuid',
contract_uuids)
xqkj_query.delete_infos('Tbl_UserBillOverdueStream', 'contract_uuid',
contract_uuids)
xqkj_query.delete_infos('Tbl_UserBillOverdueStream', 'user_bill_uuid',
user_bill_uuids)
def test_021_api_78dk_app_process_getNewestIdCardInfo(self):
"""
查询身份证信息（最近的）
:return:
"""
global contract_uuid
contract_uuid = xqkj_query.get_contract_uuid_for_user(
loginAction.get_user_uuid())
loginAction.global_dict.set(contract_uuid=contract_uuid)
res = json.loads(
AppAction.test_api_78dk_app_process_getNewestIdCardInfo(
contractuuid=contract_uuid))
Assertion.verity(res['code'], '10000')
Assertion.verity(res['data']['cardScanIdcardNo'], card_scan_idcard_no)
Assertion.verity(res['data']['cardScanName'], card_scan_name)
Assertion.verity(res['data']['frontKey'], front_key)
Assertion.verity(res['data']['frontNote'], front_note)
Assertion.verityContain(res['data'], 'frontUrl')
Assertion.verity(res['data']['holdKey'], hold_key)
Assertion.verityContain(res['data'], 'holdUrl')
Assertion.verity(res['data']['oppositeKey'], opposite_key)
Assertion.verity(res['data']['oppositeNote'], opposite_note)
Assertion.verityContain(res['data'], 'oppositeUrl')
def test_001_api_78dk_platform_urge_addMessage(self):
"""
Time :2019-09-29
author : 闫红
desc :电话催收信息提交-v1.5.2,忘记还款
"""
global app_user_uuid, contract_uuid
contract_uuid = loginAction.global_dict.get('contract_uuid')
app_user_uuid = loginAction.get_user_uuid()
xqkj_query.get_bill_overdue(contract_uuid=contract_uuid,
user_uuid=app_user_uuid)
# app_user_uuid = "bb9a44e01ce44b56a0f1aa3d7c7d478f"
res = json.loads(
WebAction.test_api_78dk_platform_urge_addMessage(
communicatee='testAPI',
condition='testAPI',
remark='testAPI',
useruuid=app_user_uuid,
overduereason="forget_repay",
datalist=[],
replyrepaytime=''))
Assertion.verity(res['code'], '10000')
Assertion.verity(res['msg'], '成功')
def test_010_del_contract(self):
"""
删除订单信息
:return:
"""
user_uuid = loginAction.get_user_uuid()
contract_uuids = xqkj_query.get_tbl_infos(
'Tbl_Contract', 'contract_uuid',
'user_uuid="{}"'.format(user_uuid))
xqkj_query.delete_info('Tbl_Contract',
'user_uuid="{}"'.format(user_uuid))
xqkj_query.delete_infos('Tbl_ContractCustomerLabel', 'contract_uuid',
contract_uuids)
xqkj_query.delete_infos('Tbl_ContractImage', 'contract_uuid',
contract_uuids)
xqkj_query.delete_infos('Tbl_ContractInfo', 'contract_uuid',
contract_uuids)
xqkj_query.delete_infos('Tbl_ContractOperationLog', 'contract_uuid',
contract_uuids)
xqkj_query.delete_infos('Tbl_FinalCheckLog', 'contract_uuid',
contract_uuids)
xqkj_query.delete_infos('Tbl_FirstCheckLog', 'contract_uuid',
contract_uuids)
xqkj_query.delete_infos('Tbl_TelephoneCheckLog', 'contract_uuid',
contract_uuids)
xqkj_query.delete_infos('Tbl_QifaMachineLog', 'contract_uuid',
contract_uuids)
xqkj_query.delete_infos('Tbl_AuditComment', 'contract_uuid',
contract_uuids)
xqkj_query.delete_infos('Tbl_AuditCommentAttachment', 'contract_uuid',
contract_uuids)
xqkj_query.delete_infos('Tbl_AuditMonitor', 'contract_uuid',
contract_uuids)
xqkj_query.delete_infos('Tbl_SA_Contract', 'contract_uuid',
contract_uuids)
xqkj_query.delete_infos('Tbl_ContractStratege', 'contract_uuid',
contract_uuids)
def test_011_del_uerinfo(self):
"""
删除客户信息
:return:
"""
user_uuid = loginAction.get_user_uuid()
xqkj_query.delete_info('Tbl_UserBankCardInfo',
'user_uuid="{}"'.format(user_uuid))
xqkj_query.delete_info('Tbl_UserContactInfo',
'user_uuid="{}"'.format(user_uuid))
xqkj_query.delete_info('Tbl_UserIdCardInfo',
'user_uuid="{}"'.format(user_uuid))
xqkj_query.delete_info('Tbl_UserMailListInfo',
'user_uuid="{}"'.format(user_uuid))
xqkj_query.delete_info('Tbl_UserOcrInfo',
'user_uuid="{}"'.format(user_uuid))
xqkj_query.delete_info('Tbl_UserPersonalInfo',
'user_uuid="{}"'.format(user_uuid))
xqkj_query.delete_info('Tbl_UserPlaceOrderGps',
'user_uuid="{}"'.format(user_uuid))
xqkj_query.delete_info('Tbl_UserWorkInfo',
'user_uuid="{}"'.format(user_uuid))
xqkj_query.delete_info('Tbl_TransLog',
'user_id="{}"'.format(user_uuid))
def get_contract_uuid_for_user(user_uuid=None):
if user_uuid is None:
user_uuid = la.get_user_uuid()
la.LOGGER.info('user_uuid : {}'.format(user_uuid))
return mydb.select_one(la.DB, 'Tbl_Contract', 'contract_uuid',
"user_uuid='{}' ORDER BY id DESC".format(user_uuid))
def test_003_api_78dk_app_process_saveBankCardInfo(self):
"""
绑定银行卡1-输入银行卡信息
:return:
"""
xqkj_query.insert_user_bankinfo(loginAction.get_user_uuid())