def addContractEnd():
"""新增委托合同终止结算"""
try:
base=Base()
base.open(page.entrustContractPage, houseContractEndPage.addContractEndMould['tr_contract'], havaFrame=False)
#配置文件读取将要终止的委托合同
contractNum = get_conf('houseContractInfo', 'contractnum')
sql = "SELECT entrust_end_date from house_contract hc where hc.contract_num = '%s' and deleted = 0 and audit_status = 'APPROVED' and contract_status = 'EFFECTIVE'" % contractNum.encode('utf-8')
if sqlbase.get_count(sql) > 0:
base.input_text(houseContractEndPage.searchMould['contract_num_loc'], contractNum)
endDate = sqlbase.serach(sql)[0]
else:
consoleLog(u'未找到或不满足新增终止条件的合同 %s，开始随机查找符合条件的委托合同' % contractNum, level='w')
sql = "select house_contract.contract_num,house_contract.entrust_end_date from house_contract where house_contract.contract_id not in " \
"(select house_contract.contract_id from apartment ,apartment_contract ,house_contract where house_contract.contract_id=apartment.house_contract_id " \
"and apartment.house_id=apartment_contract.house_id and house_contract.deleted = 0 and house_contract.audit_status = 'APPROVED' and house_contract.contract_status = 'EFFECTIVE' " \
"and house_contract.city_code = 330100 and apartment_contract.real_due_date>NOW()) and contract_num<>'' limit 1"
if sqlbase.get_count(sql) > 0:
contractNum = sqlbase.serach(sql, needConvert=False)[0]
consoleLog(u'随机对委托合同 %s 做新增终止结算操作' % contractNum, level='w')
base.input_text(houseContractEndPage.searchMould['contract_num_loc'], contractNum)
endDate = sqlbase.serach(sql)[1]
else:
consoleLog(u'未找到符合条件的委托合同，跳过终止结算用例')
return
base.click(houseContractEndPage.searchMould['contract_search_button_loc'])
base.staleness_of(houseContractEndPage.addContractEndMould['tr_contract'])
base.context_click(houseContractEndPage.addContractEndMould['tr_contract'])#右击第一条数据
base.click(houseContractEndPage.addContractEndMould['end_button_loc'], index=1)
base.input_text(houseContractEndPage.addContractEndMould['penalty_loc'], 111)
base.type_select(houseContractEndPage.typeMould['end_type'], 'RETREATING') # 结算类型-正退
base.type_date(houseContractEndPage.typeMould['end_date'], endDate)
# 结算扣款
base.input_text(houseContractEndPage.addContractEndMould['penalty_remark_loc'], u'违约金陪入')
base.input_text(houseContractEndPage.addContractEndMould['return_rent_loc'], 222)
base.input_text(houseContractEndPage.addContractEndMould['return_rent_remark_loc'], u'返还房租')
base.input_text(houseContractEndPage.addContractEndMould['no_charge_loc'], 333)
base.input_text(houseContractEndPage.addContractEndMould['no_charge_remark_loc'], u'未扣款项')
base.input_text(houseContractEndPage.addContractEndMould['fitment_charge_loc'], 444)
base.input_text(houseContractEndPage.addContractEndMould['fitment_charge_remark_loc'], u'装修扣款')
base.input_text(houseContractEndPage.addContractEndMould['other_loc'], 555)
base.input_text(houseContractEndPage.addContractEndMould['other_remark_loc'], u'其他信息')
# 代垫费用
base.click(houseContractEndPage.addContractEndMould['tool_bar'], index=0)
base.type_select(houseContractEndPage.typeMould['return_type_loc'], 'LIQUIDATED') # 违约金赔出
base.input_text(houseContractEndPage.addContractEndMould['return_money_loc'], 666)
base.type_select(houseContractEndPage.typeMould['bear_type_loc'], 'COMPANY') # 承担方-公司
base.type_select(houseContractEndPage.typeMould['bear_name'], 'ISZTECH')
base.type_date(houseContractEndPage.typeMould['money_start_date'], '2017-07-07')
base.type_date(houseContractEndPage.typeMould['money_end_date'], '2017-08-08')
base.type_select(houseContractEndPage.typeMould['explain'], 'VACANCY') # 情况说明-空置期
base.type_select(houseContractEndPage.typeMould['dispute'], 'N')
base.type_date(houseContractEndPage.typeMould['receivable_date'], '2017-08-08')
# 打款信息
base.type_select(houseContractEndPage.typeMould['pay_type'], 'OWNER') # 打款类别-业主收款
base.input_text(houseContractEndPage.addContractEndMould['pay_name_loc'], 'AutoTest')
base.input_text(houseContractEndPage.addContractEndMould['pay_bank_loc'], u'中国银行')
base.input_text(houseContractEndPage.addContractEndMould['pay_bank_no_loc'], '12345678910')
# base.input_text(HouseContractEndPage.addContractEndMould['company_no_loc'],u'杭州爱上租科技有限公司')
base.click(houseContractEndPage.addContractEndMould['submit_loc'])
base.check_submit()
consoleLog(u'委托合同 %s 终止结算新增成功' % contractNum)
finally:
base.driver.quit()
def designSharehouse():
"""品牌合租公寓设计装修"""
def common():
#分割户型
base.click(designSharePage.designShareMould['add_house_btn'])
base.script("$('#rooms').numberspinner('setValue',2)") #设置户型为2居室
base.click(designSharePage.designShareMould['add_house_btn'])
base.type_select(designSharePage.typeMould['fitment_style'],
'SIMPLECHINESE')
base.script(
"$('[onclick=\"ShareWorkBlank.selectAll(this);\"]').click()")
base.type_select(designSharePage.typeMould['room1_no'], 'METH')
base.input_text(designSharePage.designShareMould['room_area'],
'50',
index=0)
base.type_select(designSharePage.typeMould['room1_orientation'],
'NORTH')
base.type_select(designSharePage.typeMould['room2_no'], 'ETH')
base.input_text(designSharePage.designShareMould['room_area'],
'20',
index=1)
base.type_select(designSharePage.typeMould['room2_orientation'],
'EAST')
base.click(designSharePage.designShareMould['save_btn'])
base.check_submit()
#派单
base.context_click(designSharePage.searchMould['tr_contract'])
base.click(designSharePage.designShareMould['design_btn_1'], index=0)
base.wait_element(designSharePage.designShareMould['save_btn_1'])
user = "******" \
"AND sp.position_name LIKE '%品牌公寓专员%' LIMIT 1"
base.type_select(designSharePage.typeMould['fitment_uid'],
sqlbase.serach(user)[0])
time.sleep(1)
base.click(designSharePage.designShareMould['save_btn_1'])
base.check_submit()
#交房
base.context_click(designSharePage.searchMould['tr_contract'])
base.click(designSharePage.designShareMould['design_btn_2'], index=0)
base.input_text(designSharePage.designShareMould['total_cost'],
'5000.00')
base.type_date(designSharePage.typeMould['decorate_start_date'],
'2017-01-01')
base.type_date(designSharePage.typeMould['hard_delivery_date'],
'2017-01-15')
base.type_date(designSharePage.typeMould['set_delivery_date'],
'2017-01-20')
base.click(designSharePage.designShareMould['save_btn_2'])
base.check_submit()
Base.succeed += 1
sql = "SELECT hh.house_code, hh.house_id, aa.apartment_code, aa.apartment_id FROM house_contract hc INNER JOIN apartment aa ON hc.contract_id = aa.house_contract_id " \
"INNER JOIN house hh ON hh.house_id = hc.house_id WHERE hc.contract_num = '%s' LIMIT 1" % base.contractNum.encode('utf-8')
info = sqlbase.serach(sql)
set_conf('houseInfo',
houseCode=info[0],
houseID=info[1],
apartmentCode=info[2],
apatmentID=info[3])
consoleLog(u'委托合同 %s 设计装修成功' % base.contractNum)
try:
base.solr('apartment', get_conf('testCondition', 'test'))
consoleLog(u'apartment-core增量成功')
except:
consoleLog(Exception.message, level='e')
consoleLog(u'执行solr增量出现问题，请查看solr是否正常', level='e')
try:
base = Base()
base.open(page.designSharePage,
designSharePage.searchMould['tr_contract'],
havaFrame=False)
# 配置文件读取委托合同信息
contractNum = get_conf('houseContractInfo', 'contractNum')
consoleLog(u'查询委托合同 %s 是否已操作过设计工程' % contractNum)
sql1 = "select * from house_contract where contract_num = '%s' and deleted = 0" % contractNum.encode(
'utf-8')
sql2 = "select * from house_contract hc INNER JOIN fitment_house fh on hc.contract_id = fh.contract_id where hc.contract_num = '%s' and hc.deleted = 0" % contractNum.encode(
'utf-8')
if sqlbase.get_count(sql1) > 0 and sqlbase.get_count(sql2) is 0:
base.input_text(designSharePage.searchMould['contract_num_loc'],
contractNum)
base.click(designSharePage.searchMould['search_btn_loc'])
base.staleness_of(designSharePage.searchMould['tr_contract'])
base.context_click(designSharePage.searchMould['tr_contract'])
base.click(designSharePage.designShareMould['design_btn'], index=0)
base.common()
else:
consoleLog(u'未找到委托合同 %s ，随机查询待设计的委托合同' % contractNum, level='w')
sql = "SELECT hc.contract_num FROM house_contract hc WHERE hc.deleted = 0 AND hc.city_code = 330100 AND hc.contract_status = 'EFFECTIVE' " \
"AND hc.apartment_type = 'BRAND' AND hc.entrust_type = 'SHARE' AND NOT EXISTS ( SELECT 1 FROM fitment_house fh WHERE " \
"fh.contract_id = hc.contract_id ) ORDER BY RAND() LIMIT 1"
if sqlbase.get_count(sql) != 0:
base.contractNum = sqlbase.serach(sql, False)[0]
base.input_text(
designSharePage.searchMould['contract_num_loc'],
contractNum)
base.click(designSharePage.searchMould['search_btn_loc'])
base.staleness_of(designSharePage.searchMould['tr_contract'])
base.context_click(designSharePage.searchMould['tr_contract'])
base.click(designSharePage.designShareMould['design_btn'],
index=0)
base.common()
else:
consoleLog(u'未找到待设计的品牌合租委托合同，跳过设计分割用例', level='e')
return
finally:
base.driver.quit()
def addApartmentContract():
"""新增出租合同终止结算"""
try:
base = Base()
base.open(page.apartmentContractPage,
apartmentContractEndPage.addContractEndMould['tr_contract'],
havaFrame=False)
#配置文件读取合同信息
contractNum = get_conf('apartmentContractInfo', 'contractnum')
endDate = None
sql = "SELECT rent_end_date from apartment_contract where contract_num = '%s' and deleted = 0" % contractNum.encode(
'utf-8')
if sqlbase.get_count(sql) > 0:
base.input_text(
apartmentContractEndPage.
addContractEndMould['contract_num_loc'], contractNum)
endDate = sqlbase.serach(sql)[0]
else:
sql = "SELECT contract_num,rent_end_date from apartment_contract where deleted = 0 and city_code = 330100 and audit_status = 'APPROVED' and contract_status = 'EFFECTIVE' " \
"and contract_type = 'NEWSIGN' and entrust_type = 'SHARE' limit 1"
if sqlbase.get_count(sql) > 0:
info = sqlbase.serach(sql)
contractNum = info[0]
endDate = info[1]
consoleLog(u'未找到测试合同，随机使用合同 %s 做新增终止结算用例' % contractNum,
level='w')
base.input_text(
apartmentContractEndPage.
addContractEndMould['contract_num_loc'], contractNum)
set_conf('apartmentContractInfo', contractnum=contractNum)
else:
consoleLog(u'未找到符合条件的可以做终止的出租合同，跳过出租合同终止步骤', level='w')
return
base.click(
apartmentContractEndPage.addContractEndMould['search_button_loc'])
base.staleness_of(
apartmentContractEndPage.addContractEndMould['tr_contract'])
base.context_click(
apartmentContractEndPage.addContractEndMould['tr_contract'])
base.click(
apartmentContractEndPage.addContractEndMould['end_button_loc'],
index=1)
base.click(apartmentContractEndPage.addContractEndMould['now_end_loc'])
base.input_text(
apartmentContractEndPage.addContractEndMould['receipt_num_loc'],
'AutoTest')
base.type_date(apartmentContractEndPage.typeMould['end_date'], endDate)
base.input_text(
apartmentContractEndPage.addContractEndMould['end_reason_loc'],
u'承租周期已完')
base.type_select(apartmentContractEndPage.typeMould['end_type'],
'RETREATING') # 正退
base.type_select(
apartmentContractEndPage.typeMould['receipt_type_loc'],
'PAYER') # 承租人
base.input_text(
apartmentContractEndPage.addContractEndMould['bank_loc'], u'中国银行')
base.dblclick(
apartmentContractEndPage.addContractEndMould['weiyuejin_loc'],
index=12)
base.input_text(
apartmentContractEndPage.
addContractEndMould['receivable_money_loc'], '888.88')
base.input_text(
apartmentContractEndPage.addContractEndMould['payable_money_loc'],
'666.66')
base.input_text(
apartmentContractEndPage.addContractEndMould['remark_loc'],
'AutoTest')
# base.click(base.addContractEndMould['submit_loc']) #不知道这步为什么会报错，改用js执行
base.script('$("#form_submit_btn").click()')
base.check_submit()
consoleLog(u'出租合同 %s 终止结算新增成功' % contractNum)
finally:
base.driver.quit()
