def __init__(self):
#初始化设备信息
try:
self.driver = connecthub(pc_type, pc_ip, 2)
if self.driver:
Log().info("连接服务器成功")
else:
Log().info("连接服务器失败")
except Exception as e:
Log().info(e)
#登录相关
self.com1 = appclass(self.driver, cpath2)
#订单相关
self.com2 = appclass(self.driver, cpath3)
def __init__(self, con_name, driver, cpath, pc_type, pc_ip, getparam, i):
# appclass.__init__(self,driver,cpath)
self.com = appclass()
self.con_name = con_name
self.com.driver = driver
self.cpath = cpath
self.pc_type = pc_type
self.pc_ip = pc_ip
self.getparam = getparam
self.i = i
def tests_r(self): #流程测试r合同
u'''即有宝流程测试r合同'''
# textval = MysqlUtil().mysql_getstring("SELECT t.con_name FROM (SELECT * FROM mobiletest_mobiledata WHERE con_name LIKE '%s%%' ORDER BY create_time DESC) t LIMIT 1"%con_name) #流程测试r合同
textvall = getyaml(PATH("..\config\yaml\jyb\dim.yaml")).get(
'name') #流程测试r合同
Log().info("名称：%s" % textvall) #流程测试r合同
com = appclass(self.driver, self.cpath) #流程测试r合同
com.elm_operate(42, "") #流程测试r合同
time.sleep(1) #流程测试r合同
if self.pc_type.split('：')[0] == "android真机": #流程测试r合同
com.elm_operate(43, "") #流程测试r合同
time.sleep(2) #流程测试r合同
com.elm_operate(44, "") #拍照确认 #流程测试r合同
else: #流程测试r合同
com.elm_operate(82, "") #流程测试r合同
time.sleep(2) #流程测试r合同
com.elm_operate(83, "") #拍照确认 #流程测试r合同
com.elm_operate(54, "") #流程测试r合同
com.elm_operate(51, "") #流程测试r合同
com.elm_operate(45, "") #流程测试r合同
time.sleep(20) #流程测试r合同
com.checkItem("授权", "客户信息页上传照片") #流程测试r合同
com.elm_operate(46, "") #流程测试r合同
time.sleep(10) #等下最新验证码生成 #流程测试r合同
if textvall.startswith('测试'): #流程测试r合同
pcode = "741852" #流程测试r合同
else: #流程测试r合同
pcode = OracleUtil(dbname).oracle_getstring(
"select code from (select * from cs_sms_authority where mobile='%s' order by create_time desc) where rownum=1"
% mobilephone) #流程测试r合同
time.sleep(3) #流程测试r合同
com.elm_operate(47, pcode) #输入验证码741852 #流程测试r合同
com.elm_operate(48, "") # 征信授权页完成 #流程测试r合同
time.sleep(5) #流程测试r合同
com.checkItem("PDF", "征信授权页保存") #流程测试r合同
com.elm_operate(49, "") #流程测试r合同
time.sleep(12) #流程测试r合同
stpr = MysqlUtil().mysql_getstring(
"SELECT con_status FROM mobiletest_mobiledata WHERE con_name ='%s'"
% textvall) #流程测试r合同
if com.findItem("基本信息") and stpr == 'pr': #流程测试r合同
Log().info("PDF列表页提交预审保存完成,r合同生成成功") #流程测试r合同
MysqlUtil().mysql_execute(
"UPDATE mobiletest_mobiledata SET con_status='r' WHERE con_name='%s'"
% textvall) #流程测试r合同
else: #流程测试r合同
Log().info("PDF列表页提交预审,r合同生成失败") #流程测试r合同
raise RunError('r合同生成异常')
def tests_s(self):
u'''即有宝流程测试s合同'''
com = appclass(self.driver, self.cpath)
com.elm_operate(42, "")
time.sleep(1)
com.elm_operate(43, "")
time.sleep(2)
com.elm_operate(44, "") #拍照确认
com.elm_operate(45, "")
Log().info("客户门店照片页完成")
com.elm_operate(46, "")
time.sleep(10) #等下最新验证码生成
V = OracleUtil(dbname)
pcode = V.oracle_getstring(
"select code from (select * from cs_sms_authority where mobile='%s' order by create_time desc) where rownum=1"
% mobilephone)
time.sleep(2)
com.elm_operate(47, pcode) #输入验证码
com.elm_operate(48, "") # 征信授权页完成
Log().info("征信授权页完成")
com.elm_operate(49, "")
Log().info("PDF列表页面完成")
com.elm_operate(50, "")
com.elm_operate(51, "")
com.elm_operate(52, "")
com.elm_operate(53, "")
Log().info("其他信息页完成")
for a in range(54, 67):
com.elm_operate(a, "")
com.swipeup()
com.elm_operate(67, "")
Log().info("基本信息页完成")
for b in range(68, 77):
com.elm_operate(b, "")
com.swipeup()
for v in range(77, 82):
com.elm_operate(v, "")
Log().info("单位信息页完成")
self.driver.quit()
def tests_r(self): #流程测试r合同
u'''即有宝流程测试r合同'''
# textval = MysqlUtil().mysql_getstring("SELECT t.con_name FROM (SELECT * FROM mobiletest_mobiledata WHERE con_name LIKE '%s%%' ORDER BY create_time DESC) t LIMIT 1"%con_name) #流程测试r合同
com = appclass(self.driver, self.cpath) #流程测试r合同
com.elm_operate(42, "") #流程测试r合同
time.sleep(1) #流程测试r合同
if self.pc_type == "android真机": #流程测试r合同
com.elm_operate(43, "") #流程测试r合同
time.sleep(2) #流程测试r合同
com.elm_operate(44, "") #拍照确认 #流程测试r合同
else: #流程测试r合同
com.elm_operate(82, "") #流程测试r合同
time.sleep(2) #流程测试r合同
com.elm_operate(83, "") #拍照确认 #流程测试r合同
com.elm_operate(45, "") #流程测试r合同
time.sleep(20) #流程测试r合同
com.checkItem("授权", "客户信息页上传照片") #流程测试r合同
com.elm_operate(46, "") #流程测试r合同
time.sleep(10) #等下最新验证码生成 #流程测试r合同
pcode = OracleUtil(dbname).oracle_getstring(
"select code from (select * from cs_sms_authority where mobile='%s' order by create_time desc) where rownum=1"
% mobilephone) #流程测试r合同
time.sleep(3) #流程测试r合同
com.elm_operate(47, pcode) #输入验证码 #流程测试r合同
com.elm_operate(48, "") # 征信授权页完成 #流程测试r合同
time.sleep(4) #流程测试r合同
com.checkItem("签章", "征信授权页下一步保存") #流程测试r合同
com.elm_operate(49, "") #流程测试r合同
time.sleep(3) #流程测试r合同
com.checkItem("其他信息", "PDF列表页下一步保存") #流程测试r合同
com.elm_operate(50, "") #流程测试r合同
com.elm_operate(51, "") #流程测试r合同
com.elm_operate(52, "") #流程测试r合同
com.elm_operate(53, "") #流程测试r合同
time.sleep(4) #流程测试r合同
if com.findItem("基本信息"): #流程测试r合同
Log().info("其他信息页下一步,r合同生成成功") #流程测试r合同
MysqlUtil().mysql_execute(
"UPDATE mobiletest_mobiledata SET con_status='r' WHERE con_name='%s'"
% newcon_name) #流程测试r合同
else: #流程测试r合同
Log().info("其他信息页下一步,r合同生成失败") #流程测试r合同
def tests_pr(self):
u'''即有宝流程测试pr合同'''
Log().info("订单流程开始")
time.sleep(5)
com = appclass(self.driver,self.cpath)
# com.capital_sel(getparam['paramk']) #资金池--暂屏蔽
com.swipeleft(3)
time.sleep(1)
com.elm_operate(0,"")
com.elm_operate(1,self.uname)
for x in range(2,4):
com.elm_operate(x,"")
time.sleep(3)
if com.findItem("ok"):
com.elm_operate(4,"")
if com.findItem("开启手势密码"):
# self.driver.tap([(0,60), (1080,210), (100, 100)], 100)
# com.elm_operate(5,"")
time.sleep(1)
if com.findItem("确定"):
com.elm_operate(6,"")
com.elm_operate(7,"")
time.sleep(4)
com.get_dbtext(1,self.getparam['parama'])
com.elm_operate(8,"")
time.sleep(1)
com.get_dbtext(0,self.getparam['paramb'])
com.elm_operate(9,"")
time.sleep(1)
com.get_dbtext(0,self.getparam['paramc'])
com.elm_allson_send(12,13,0,self.getparam['paramd'])
com.elm_allson_send(12,13,1,self.getparam['parame'])
com.elm_operate(14,"")
time.sleep(4)
com.checkItem("选择分期","新建订单页面一下一步保存")
#------------15,16
bx_one= self.driver.find_elements_by_id("com.giveu.corder:id/switch_insurance")
bbx= self.driver.find_elements_by_id("com.giveu.corder:id/switch_treasure")
print(bx_one)
if getparam['paramf'] == '不参加' and len(bx_one) > 0:
self.driver.find_element_by_id("com.giveu.corder:id/switch_insurance").click()
elif getparam['paramf'] == '保险' and len(bbx) > 0:
self.driver.find_element_by_id("com.giveu.corder:id/switch_treasure").click()
else:
print("pass")
time.sleep(2)
com.get_dbtext(0,self.getparam['paramg'])
com.swipeup()
com.elm_operate(17,"")
time.sleep(4)
com.checkItem("商品类型","新建订单页面二下一步保存")
etm=self.driver.find_element_by_id("com.giveu.corder:id/ll_item")
etms=etm.find_elements_by_id("com.giveu.corder:id/tv_choose_right")
time.sleep(1)
# com.elm_allson_click(18,19,0)
etms[0].click()
time.sleep(1)
com.get_dbtext(0,self.getparam['paramh'])
# com.elm_allson_click(18,19,1)
etms[1].click()
time.sleep(1)
com.get_dbtext(0,self.getparam['parami'])
com.elm_operate(20,"")
#预留21,22
qmb= self.driver.find_elements_by_id("com.giveu.corder:id/cb_insurance")
sspa= self.driver.find_elements_by_id("com.giveu.corder:id/cb_broken")
if self.getparam['paramj'] == '全面保' and len(qmb) > 0:
self.driver.find_element_by_id("com.giveu.corder:id/cb_insurance").click()
elif self.getparam['paramj'] == '碎碎平安' and len(sspa) > 0:
self.driver.find_element_by_id("com.giveu.corder:id/cb_broken").click()
else:
print("pass")
com.swipeup()
com.elm_operate(23,"")
time.sleep(4)
com.checkItem("身份证","新建订单页面三下一步保存")
#拍照
com.elm_operate(24,"")
com.elm_operate(25,"")
time.sleep(2)
com.swipedown()
com.elm_operate(26,con_name+chzw())
textval = com.get_elm_textval(26)
n={'name':textval}
wryaml(PATH("..\config\yaml\jyb\dim.yaml"),n)
time.sleep(2)
textvall=getyaml(PATH("..\config\yaml\jyb\dim.yaml")).get('name')
# pathcname=os.path.realpath(__file__)
# print(pathcname)
# change_name(pathcname,textval)
# Log().info("合同名更新完成")
# time.sleep(4)
for s in range(27,41):
com.elm_operate(s,"")
time.sleep(1)
com.swipeup()
com.elm_operate(41,"")
Log().info("订单名称：%s "%textval)
V = OracleUtil(dbname)
time.sleep(2)
cnoval =V.oracle_getstring("select contract_no from cs_credit where id_person=(select id from (select * from cs_person where name like '%s%%' order by create_time desc) where rownum=1)"%textval)
time.sleep(1)
print(cnoval)
A = MysqlUtil()
time.sleep(2)
A.mysql_execute("INSERT INTO mobiletest_mobiledata (contract_no,con_name,con_ident,con_phone,create_time,capital_source,con_status,username,runnum) VALUES ('%s','%s','%s','%s',NOW(),'%s','%s','%s','%s')"%(cnoval,textval,idcard,mobilephone,getparam['paramk'],getparam['paraml'],uname,markval))
if com.findItem("客户门店照片"):
Log().info("订单pr合同号生成成功：%s"%cnoval)
MysqlUtil().mysql_execute("UPDATE mobiletest_mobiledata SET con_status='pr' WHERE con_name='%s'"%textval)
else:
Log().info("订单pr合同号生成异常：%s"%cnoval)
def tests_s(self): #流程测试s合同
u'''即有宝流程测试s合同'''
# textval = MysqlUtil().mysql_getstring("SELECT t.con_name FROM (SELECT * FROM mobiletest_mobiledata WHERE con_name LIKE '%s%%' ORDER BY create_time DESC) t LIMIT 1"%con_name) #流程测试s合同
textvall=getyaml(PATH("..\config\yaml\jyb\dim.yaml")).get('name')#流程测试s合同
Log().info("名称：%s"%textvall) #流程测试s合同
com = appclass(self.driver,self.cpath) #流程测试s合同
for a in range(60,67): #流程测试s合同
com.elm_operate(a,"") #流程测试s合同
com.swipeup() #流程测试s合同
com.elm_operate(67,"") #流程测试s合同
time.sleep(4) #流程测试s合同
com.checkItem("单位信息","基本信息页下一步保存") #流程测试s合同
for b in range(68,77): #流程测试s合同
com.elm_operate(b,"") #流程测试s合同
com.swipeup() #流程测试s合同
for v in range(77,82): #流程测试s合同
com.elm_operate(v,"") #流程测试s合同
time.sleep(4) #流程测试s合同
com.checkItem("联系人","单位信息页下一步保存") #流程测试s合同
#-----Begin----填写联系人信息 --20181015 chenjingxu #流程测试s合同
#填写文本框内容 #流程测试s合同
Log().info("开始填写联系人信息") #流程测试s合同
HF = "未婚" #流程测试s合同
com3 = appclass(self.driver, PATH("..\config\yaml\jyb\jybcase2.yaml")) #流程测试s合同
#填写姓名和手机号 #流程测试s合同
if HF == "已婚": #流程测试s合同
for h in range(0, 7): #流程测试s合同
com3.elm_operate(h, "") #流程测试s合同
else: #流程测试s合同
for h in range(0, 5): #流程测试s合同
com3.elm_operate(h, "") #流程测试s合同
#选择与本人关系 #流程测试s合同
r = 0 #流程测试s合同
for s in range(9, 11): #流程测试s合同
lis = [12, 48] #流程测试s合同
com3.elm_operate(s, "") #流程测试s合同
print("没有点击打开弹窗") #流程测试s合同
time.sleep(0.5) #流程测试s合同
com3.elm_operate(lis[r], "") #流程测试s合同
r = r + 1 #流程测试s合同
#提交 #流程测试s合同
com3.elm_operate(13,"") #流程测试s合同
Log().info("恭喜，填写联系人信息成功！！！") #流程测试s合同
#第一步 填写银行卡号 #流程测试s合同
self.driver.activate_ime_engine("com.sohu.inputmethod.sogou.xiaomi/.SogouIME") #流程测试s合同
com3.elm_operate(21, "") #流程测试s合同
self.driver.activate_ime_engine("io.appium.android.ime/.UnicodeIME") #流程测试s合同
com3.elm_operate(52, "") #流程测试s合同
com3.elm_operate(53, "") #流程测试s合同
time.sleep(3) #流程测试s合同
# com3.elm_operate(30, "") #流程测试s合同
# time.sleep(4) #流程测试s合同
# MysqlUtiltwo().mysql_execute("update credit_bankcard_four set check_result=2000 where name='%s'"%textvall) #流程测试s合同
MysqlUtiltwo().mysql_execute("INSERT INTO credit_bankcard_four (`name`,bank_card,mobile,id_number,check_result,check_msg,sp_code,create_time,service_id,extra) VALUES ('%s','6228481359515816576','13300000000','511000198506020031','2000','全匹配','BAIRONG',NOW(),'10000',NULL)"%textvall) #流程测试s合同
time.sleep(2) #流程测试s合同
com3.elm_operate(55, "") #流程测试s合同
time.sleep(2) #流程测试s合同
send_codee =MysqlUtiltwo().mysql_getstring("SELECT t.sms_code FROM (SELECT * FROM sms_verify_info WHERE phone = '%s' ORDER BY sent_time DESC) t LIMIT 1"%mobilephone) #流程测试s合同
print(send_codee) #流程测试s合同
time.sleep(10) #流程测试s合同
com3.elm_operate(54,send_codee) #流程测试s合同
com3.elm_operate(15, "") #流程测试s合同
com3.checkItem("其他信息","绑定银行卡页保存")#流程测试s合同
#------------------------------------断 #流程测试s合同
#进入其他信息页 #流程测试s合同
com3.elm_operate(32, "") #流程测试s合同
com3.elm_operate(33, "") #流程测试s合同
com3.elm_operate(34, "") #流程测试s合同
com3.elm_operate(15, "") #流程测试s合同
time.sleep(1) #流程测试s合同
com3.checkItem("授权","其他信息页保存")#流程测试s合同
#跳过授权 #流程测试s合同
com3.elm_operate(15, "") #流程测试s合同
com3.checkItem("小问卷","跳过授权保存")#流程测试s合同
#小问卷 #流程测试s合同
com3.elm_operate(36, "") #流程测试s合同
com3.elm_operate(37, "") #流程测试s合同
com3.elm_operate(51, "") #流程测试s合同
com3.checkItem("影像证明","小问卷保存")#流程测试s合同
#上传影像证明 #流程测试s合同
com3.swipedown() #流程测试s合同
com3.elm_operate(38, "") #流程测试s合同
com3.elm_operate(39, "") #流程测试s合同
com3.elm_operate(40, "") #流程测试s合同
time.sleep(2) #流程测试s合同
self.driver.wait_activity("com.giveu.corder.ordercreate.activity.PhotoCertificateActivity", 20, 1) #流程测试s合同
com3.swipeup() #流程测试s合同
com3.elm_operate(41, "") #提交 #流程测试s合同
com3.elm_operate(42, "") #流程测试s合同
com3.elm_operate(43, "") #流程测试s合同
time.sleep(2) #流程测试s合同
if com3.findItem("成功提交"): #流程测试s合同
Log().info("即有宝S合同生成成功") #流程测试s合同
MysqlUtil().mysql_execute("UPDATE mobiletest_mobiledata SET con_status='s' WHERE con_name='%s'"%textvall) #流程测试s合同
else: #流程测试s合同
Log().info("即有宝S合同生成失败") #流程测试s合同
def tests_pr(self):
u'''即有宝流程测试pr合同'''
Log().info("订单流程开始")
time.sleep(5)
com = appclass(self.driver, self.cpath)
com.swipeleft(3)
time.sleep(1)
for x in range(4):
com.elm_operate(x, "")
time.sleep(3)
for z in range(4, 7): #300079wei4 842928wei5
com.elm_click(z)
time.sleep(0.5)
com.elm_operate(7, "")
time.sleep(4)
com.get_dbtext(1, self.getparam['parama'])
com.elm_operate(8, "")
time.sleep(1)
com.get_dbtext(0, self.getparam['paramb'])
com.elm_operate(9, "")
time.sleep(1)
com.get_dbtext(0, self.getparam['paramc'])
com.elm_operate(10, "")
time.sleep(1)
com.elm_operate(11, "")
com.elm_allson_send(12, 13, 0, self.getparam['paramd'])
com.elm_allson_send(12, 13, 1, self.getparam['parame'])
com.elm_operate(14, "")
time.sleep(4)
com.checkItem("选择分期", "新建订单页面一下一步保存")
#------------15,16
bx_one = self.driver.find_elements_by_id(
"com.giveu.corder:id/switch_insurance")
bbx = self.driver.find_elements_by_id(
"com.giveu.corder:id/switch_treasure")
print(bx_one)
if getparam['paramf'] == '不参加' and len(bx_one) > 0:
self.driver.find_element_by_id(
"com.giveu.corder:id/switch_insurance").click()
elif getparam['paramf'] == '保险' and len(bbx) > 0:
self.driver.find_element_by_id(
"com.giveu.corder:id/switch_treasure").click()
else:
print("pass")
time.sleep(2)
com.get_dbtext(0, self.getparam['paramg'])
com.swipeup()
com.elm_operate(17, "")
time.sleep(4)
com.checkItem("商品类型", "新建订单页面二下一步保存")
etm = self.driver.find_element_by_id("com.giveu.corder:id/ll_item")
etms = etm.find_elements_by_id("com.giveu.corder:id/tv_choose_right")
time.sleep(1)
# com.elm_allson_click(18,19,0)
etms[0].click()
time.sleep(1)
com.get_dbtext(0, self.getparam['paramh'])
# com.elm_allson_click(18,19,1)
etms[1].click()
time.sleep(1)
com.get_dbtext(0, self.getparam['parami'])
com.elm_operate(20, "")
#预留21,22
qmb = self.driver.find_elements_by_id(
"com.giveu.corder:id/cb_insurance")
sspa = self.driver.find_elements_by_id("com.giveu.corder:id/cb_broken")
if self.getparam['paramj'] == '全面保' and len(qmb) > 0:
self.driver.find_element_by_id(
"com.giveu.corder:id/cb_insurance").click()
elif self.getparam['paramj'] == '碎碎平安' and len(sspa) > 0:
self.driver.find_element_by_id(
"com.giveu.corder:id/cb_broken").click()
else:
print("pass")
com.swipeup()
com.elm_operate(23, "")
time.sleep(4)
com.checkItem("身份证", "新建订单页面三下一步保存")
#拍照
com.elm_operate(24, "")
com.elm_operate(25, "")
time.sleep(2)
com.elm_operate(26, con_name + chzw())
textval = com.get_elm_textval(26)
for s in range(27, 41):
com.elm_operate(s, "")
time.sleep(1)
com.swipeup()
com.elm_operate(41, "")
Log().info("订单名称：%s " % textval)
V = OracleUtil(dbname)
time.sleep(2)
cnoval = V.oracle_getstring(
"select contract_no from cs_credit where id_person=(select id from (select * from cs_person where name like '%s%%' order by create_time desc) where rownum=1)"
% textval)
time.sleep(1)
print(cnoval)
A = MysqlUtil()
time.sleep(2)
A.mysql_execute(
"INSERT INTO mobiletest_mobiledata (contract_no,con_name,con_ident,con_phone,create_time) VALUES ('%s','%s','%s','%s',NOW())"
% (cnoval, textval, idcard, mobilephone))
if cnoval == None:
Log().info("订单pr合同号生成异常：%s" % cnoval)
else:
Log().info("订单pr合同号生成成功：%s" % cnoval)
def tests_s(self):
u'''即有宝流程测试s合同'''
# textval = self.tests_pr()
textval = MysqlUtil().mysql_getstring(
"SELECT t.con_name FROM (SELECT * FROM mobiletest_mobiledata WHERE con_name LIKE '%s%%' ORDER BY create_time DESC) t LIMIT 1"
% con_name)
print(textval)
com = appclass(self.driver, self.cpath)
com.elm_operate(42, "")
time.sleep(1)
if self.pc_type == "android真机":
com.elm_operate(43, "")
time.sleep(2)
com.elm_operate(44, "") #拍照确认
else:
com.elm_operate(82, "")
time.sleep(2)
com.elm_operate(83, "") #拍照确认
com.elm_operate(45, "")
time.sleep(20)
com.checkItem("授权", "客户信息页上传照片")
com.elm_operate(46, "")
time.sleep(10) #等下最新验证码生成
pcode = OracleUtil(dbname).oracle_getstring(
"select code from (select * from cs_sms_authority where mobile='%s' order by create_time desc) where rownum=1"
% mobilephone)
time.sleep(3)
com.elm_operate(47, pcode) #输入验证码
com.elm_operate(48, "") # 征信授权页完成
time.sleep(4)
com.checkItem("签章", "征信授权页下一步保存")
com.elm_operate(49, "")
time.sleep(3)
com.checkItem("其他信息", "PDF列表页下一步保存")
com.elm_operate(50, "")
com.elm_operate(51, "")
com.elm_operate(52, "")
com.elm_operate(53, "")
time.sleep(4)
com.checkItem("基本信息", "其他信息页下一步保存")
for a in range(54, 67):
com.elm_operate(a, "")
com.swipeup()
com.elm_operate(67, "")
time.sleep(4)
com.checkItem("单位信息", "基本信息页下一步保存")
for b in range(68, 77):
com.elm_operate(b, "")
com.swipeup()
for v in range(77, 82):
com.elm_operate(v, "")
time.sleep(4)
com.checkItem("联系人", "单位信息页下一步保存")
#预留2
#-----Begin----填写联系人信息 --20181015 chenjingxu
#PS:新增联系人此处不做处理,但需要上一步提供婚否信息
#填写文本框内容
Log().info("开始填写联系人信息")
HF = "未婚"
com3 = appclass(self.driver, PATH("..\config\yaml\jyb\jybcase2.yaml"))
#填写姓名和手机号
if HF == "已婚":
for h in range(0, 7):
com3.elm_operate(h, "")
else:
for h in range(0, 5):
com3.elm_operate(h, "")
#选择与本人关系
#relation = ["兄弟", "同事-1"]
r = 0
for s in range(9, 11):
lis = [12, 48]
com3.elm_operate(s, "")
print("没有点击打开弹窗")
time.sleep(0.5)
com3.elm_operate(lis[r], "")
r = r + 1
#提交
com3.elm_operate(13, "")
Log().info("恭喜，填写联系人信息成功！！！")
#----End --填写联系人信息 -------------20181020 chenjingxu
#---Begin 绑定银行卡-------------------20181020 chenjingxu
#第一步 填写银行卡号
self.driver.activate_ime_engine(
"com.sohu.inputmethod.sogou.xiaomi/.SogouIME")
com3.elm_operate(14, "6228481359515816576")
self.driver.activate_ime_engine("io.appium.android.ime/.UnicodeIME")
com3.elm_operate(15, "")
Log().info("恭喜，绑定银行卡1成功！！！")
#第二步 先只填写支行，其它信息不校验
com3.elm_operate(23, "")
time.sleep(0.5)
com3.elm_operate(49, "")
com3.elm_operate(50, "")
com3.elm_operate(15, "")
time.sleep(4)
# sql = "update credit_bankcard_four set check_result=2000 where mobile=13300000000 and name like'回归%' and check_result=2008"
MysqlUtiltwo().mysql_execute(
"update credit_bankcard_four set check_result=2000 where name='%s'"
% textval)
time.sleep(2)
com3.elm_operate(15, "")
Log().info("恭喜，绑定银行卡2成功！！！")
#判断手机号跟银行预留手机号是否一致，然后执行SQL语句
#第四步，填写验证码
send_codee = MysqlUtiltwo().mysql_getstring(
"SELECT t.sms_code FROM (SELECT * FROM sms_verify_info WHERE phone = '%s' ORDER BY sent_time DESC) t LIMIT 1"
% mobilephone)
print(send_codee)
time.sleep(10)
com3.elm_operate(31, send_codee)
time.sleep(1)
com3.elm_operate(15, "")
time.sleep(5)
if com3.findItem("绑定银行卡"):
send_codee2 = MysqlUtiltwo().mysql_getstring(
"SELECT t.sms_code FROM (SELECT * FROM sms_verify_info WHERE phone = '%s' ORDER BY sent_time DESC) t LIMIT 1"
% mobilephone)
com3.elm_operate(31, send_codee2)
time.sleep(1)
com3.elm_operate(15, "")
Log().info("恭喜，绑定银行卡3成功！！！")
else:
Log().info("恭喜，绑定银行卡3成功！！！")
# ---End 绑定银行卡-------------------20181020 chenjingxu
# ---Begin 其它信息-------------------20181020 chenjingxu
com3.elm_operate(32, "")
com3.elm_operate(33, "")
com3.elm_operate(34, "")
com3.elm_operate(15, "")
Log().info("恭喜，填写其它信息成功！！！")
# ---End 其它信息-------------------20181020 chenjingxu
#跳过京东认证,富数认证，运营商认证--20181020 chenjingxu
com3.elm_operate(35, "")
com3.elm_operate(35, "")
com3.elm_operate(35, "")
Log().info("恭喜，跳过京东，富数，运营商认证成功！！！")
# ---Begin 小问卷-------------------20181020 chenjingxu
com3.elm_operate(36, "")
#单选写死，后续通过字典来实现动态选择
com3.elm_operate(37, "")
com3.elm_operate(51, "")
Log().info("恭喜，填写小问卷成功！！！")
# ---End 小问卷---------------------20181020 chenjingxu
#等待页面跳转完毕
time.sleep(2)
# ---Begin 影像证明-----------------20181020 chenjingxu
Log().info("上传影像证明")
com3.swipeup()
com3.swipeup()
com3.elm_operate(38, "")
time.sleep(1)
# ---start 影像证明-------------------20181020 chenjingxu
#act_camera = "com.android.camera/com.android.camera.Camera"
#driver.wait_activity(act_camera, 20, 1)
com3.elm_operate(39, "")
com3.elm_operate(40, "")
time.sleep(2)
self.driver.wait_activity(
"com.giveu.corder.ordercreate.activity.PhotoCertificateActivity",
20, 1)
com3.elm_operate(41, "")
Log().info("恭喜，上传影像证明成功！！！")
# ---End 影像证明-------------------20181020 chenjingxu
# ---Begin 输入登录密码进行验证-------------------20181020 chenjingxu
com3.elm_operate(42, "")
com3.elm_operate(43, "")
time.sleep(2)
com3.checkItem("成功提交", "即有宝S合同生成")
def tests_s(self): #流程测试s合同
u'''即有宝流程测试s合同'''
# textval = MysqlUtil().mysql_getstring("SELECT t.con_name FROM (SELECT * FROM mobiletest_mobiledata WHERE con_name LIKE '%s%%' ORDER BY create_time DESC) t LIMIT 1"%con_name) #流程测试s合同
com = appclass(self.driver, self.cpath) #流程测试s合同
for a in range(54, 67): #流程测试s合同
com.elm_operate(a, "") #流程测试s合同
com.swipeup() #流程测试s合同
com.elm_operate(67, "") #流程测试s合同
time.sleep(4) #流程测试s合同
com.checkItem("单位信息", "基本信息页下一步保存") #流程测试s合同
for b in range(68, 77): #流程测试s合同
com.elm_operate(b, "") #流程测试s合同
com.swipeup() #流程测试s合同
for v in range(77, 82): #流程测试s合同
com.elm_operate(v, "") #流程测试s合同
time.sleep(4) #流程测试s合同
com.checkItem("联系人", "单位信息页下一步保存") #流程测试s合同
#-----Begin----填写联系人信息 --20181015 chenjingxu #流程测试s合同
#填写文本框内容 #流程测试s合同
Log().info("开始填写联系人信息") #流程测试s合同
HF = "未婚" #流程测试s合同
com3 = appclass(self.driver,
PATH("..\config\yaml\jyb\jybcase2.yaml")) #流程测试s合同
#填写姓名和手机号 #流程测试s合同
if HF == "已婚": #流程测试s合同
for h in range(0, 7): #流程测试s合同
com3.elm_operate(h, "") #流程测试s合同
else: #流程测试s合同
for h in range(0, 5): #流程测试s合同
com3.elm_operate(h, "") #流程测试s合同
#选择与本人关系 #流程测试s合同
r = 0 #流程测试s合同
for s in range(9, 11): #流程测试s合同
lis = [12, 48] #流程测试s合同
com3.elm_operate(s, "") #流程测试s合同
print("没有点击打开弹窗") #流程测试s合同
time.sleep(0.5) #流程测试s合同
com3.elm_operate(lis[r], "") #流程测试s合同
r = r + 1 #流程测试s合同
#提交 #流程测试s合同
com3.elm_operate(13, "") #流程测试s合同
Log().info("恭喜，填写联系人信息成功！！！") #流程测试s合同
#----End --填写联系人信息 -------------20181020 chenjingxu #流程测试s合同
#---Begin 绑定银行卡-------------------20181020 chenjingxu #流程测试s合同
#第一步 填写银行卡号 #流程测试s合同
self.driver.activate_ime_engine(
"com.sohu.inputmethod.sogou.xiaomi/.SogouIME") #流程测试s合同
com3.elm_operate(14, "6228481359515816576") #流程测试s合同
self.driver.activate_ime_engine(
"io.appium.android.ime/.UnicodeIME") #流程测试s合同
com3.elm_operate(15, "") #流程测试s合同
Log().info("恭喜，绑定银行卡1成功！！！") #流程测试s合同
#第二步 先只填写支行，其它信息不校验 #流程测试s合同
com3.elm_operate(23, "") #流程测试s合同
time.sleep(0.5) #流程测试s合同
com3.elm_operate(49, "") #流程测试s合同
com3.elm_operate(50, "") #流程测试s合同
com3.elm_operate(15, "") #流程测试s合同
time.sleep(4) #流程测试s合同
MysqlUtiltwo().mysql_execute(
"update credit_bankcard_four set check_result=2000 where name='%s'"
% newcon_name) #流程测试s合同
time.sleep(2) #流程测试s合同
com3.elm_operate(15, "") #流程测试s合同
Log().info("恭喜，绑定银行卡2成功！！！") #流程测试s合同
#第四步，填写验证码 #流程测试s合同
send_codee = MysqlUtiltwo().mysql_getstring(
"SELECT t.sms_code FROM (SELECT * FROM sms_verify_info WHERE phone = '%s' ORDER BY sent_time DESC) t LIMIT 1"
% mobilephone) #流程测试s合同
print(send_codee) #流程测试s合同
time.sleep(10) #流程测试s合同
com3.elm_operate(31, send_codee) #流程测试s合同
time.sleep(1) #流程测试s合同
com3.elm_operate(15, "") #流程测试s合同
time.sleep(5) #流程测试s合同
if com3.findItem("绑定银行卡"): #流程测试s合同
send_codee2 = MysqlUtiltwo().mysql_getstring(
"SELECT t.sms_code FROM (SELECT * FROM sms_verify_info WHERE phone = '%s' ORDER BY sent_time DESC) t LIMIT 1"
% mobilephone) #流程测试s合同
com3.elm_operate(31, send_codee2) #流程测试s合同
time.sleep(1) #流程测试s合同
com3.elm_operate(15, "") #流程测试s合同
Log().info("恭喜，绑定银行卡3成功！！！") #流程测试s合同
else: #流程测试s合同
Log().info("恭喜，绑定银行卡3成功！！！") #流程测试s合同
# ---End 绑定银行卡-------------------20181020 chenjingxu #流程测试s合同
# ---Begin 其它信息-------------------20181020 chenjingxu #流程测试s合同
com3.elm_operate(32, "") #流程测试s合同
com3.elm_operate(33, "") #流程测试s合同
com3.elm_operate(34, "") #流程测试s合同
com3.elm_operate(15, "") #流程测试s合同
Log().info("恭喜，填写其它信息成功！！！") #流程测试s合同
# ---End 其它信息-------------------20181020 chenjingxu #流程测试s合同
#跳过京东认证,富数认证，运营商认证--20181020 chenjingxu #流程测试s合同
com3.elm_operate(35, "") #流程测试s合同
com3.elm_operate(35, "") #流程测试s合同
com3.elm_operate(35, "") #流程测试s合同
Log().info("恭喜，跳过京东，富数，运营商认证成功！！！") #流程测试s合同
# ---Begin 小问卷-------------------20181020 chenjingxu #流程测试s合同
com3.elm_operate(36, "") #流程测试s合同
#单选写死，后续通过字典来实现动态选择 #流程测试s合同
com3.elm_operate(37, "") #流程测试s合同
com3.elm_operate(51, "") #流程测试s合同
Log().info("恭喜，填写小问卷成功！！！") #流程测试s合同
# ---End 小问卷---------------------20181020 chenjingxu #流程测试s合同
#等待页面跳转完毕 #流程测试s合同
time.sleep(2) #流程测试s合同
# ---Begin 影像证明-----------------20181020 chenjingxu #流程测试s合同
Log().info("上传影像证明") #流程测试s合同
com3.swipeup() #流程测试s合同
com3.swipeup() #流程测试s合同
com3.elm_operate(38, "") #流程测试s合同
time.sleep(1) #流程测试s合同
# ---start 影像证明-------------------20181020 chenjingxu #流程测试s合同
#act_camera = "com.android.camera/com.android.camera.Camera" #流程测试s合同
#driver.wait_activity(act_camera, 20, 1) #流程测试s合同
com3.elm_operate(39, "") #流程测试s合同
com3.elm_operate(40, "") #流程测试s合同
time.sleep(2) #流程测试s合同
self.driver.wait_activity(
"com.giveu.corder.ordercreate.activity.PhotoCertificateActivity",
20, 1) #流程测试s合同
com3.elm_operate(41, "") #流程测试s合同
Log().info("恭喜，上传影像证明成功！！！") #流程测试s合同
# ---End 影像证明-------------------20181020 chenjingxu #流程测试s合同
# ---Begin 输入登录密码进行验证-------------------20181020 chenjingxu #流程测试s合同
com3.elm_operate(42, "") #流程测试s合同
com3.elm_operate(43, "") #流程测试s合同
time.sleep(2) #流程测试s合同
if com3.findItem("成功提交"): #流程测试s合同
Log().info("即有宝S合同生成成功") #流程测试s合同
MysqlUtil().mysql_execute(
"UPDATE mobiletest_mobiledata SET con_status='s' WHERE con_name='%s'"
% newcon_name) #流程测试s合同
else: #流程测试s合同
Log().info("即有宝S合同生成失败") #流程测试s合同
print("合同：'%s'" % conval)
raise RunError('指定合同未找到')
print("合同：'%s'" % conval)
raise RunError('指定合同未找到')
print("合同：'%s'" % conval)
raise RunError('指定合同未找到')
def tests_run(self):
u'''即有宝流程测试'''
driver = connecthub(self.pc_type,self.pc_ip)
if driver:
Log().info("连接服务器成功")
else:
Log().info("连接服务器失败")
time.sleep(5)
com = appclass(driver,self.cpath)
com.swipeleft(3)
time.sleep(1)
# for x in range(4):
# com.elm_operate(x,"")
com.elm_operate(0,"")
com.elm_operate(1,self.uname)
for x in range(2,4):
com.elm_operate(x,"")
time.sleep(1)
for z in range(4,7):
com.elm_click(z)
com.elm_operate(7,"")
time.sleep(4)
com.get_dbtext(1,self.getparam['parama'])
com.elm_operate(8,"")
time.sleep(1)
com.get_dbtext(0,self.getparam['paramb'])
com.elm_operate(9,"")
time.sleep(1)
com.get_dbtext(0,self.getparam['paramc'])
com.elm_operate(10,"")
time.sleep(1)
com.elm_operate(11,"")
com.elm_allson_send(12,13,0,self.getparam['paramd'])
com.elm_allson_send(12,13,1,self.getparam['parame'])
com.elm_operate(14,"")
Log().info("订单页面一完成")
#------------15,16
bx_one= driver.find_elements_by_id("com.giveu.corder:id/switch_insurance")
bbx= driver.find_elements_by_id("com.giveu.corder:id/switch_treasure")
print(bx_one)
if getparam['paramf'] == '不参加' and len(bx_one) > 0:
driver.find_element_by_id("com.giveu.corder:id/switch_insurance").click()
elif getparam['paramf'] == '免还大礼包' and len(bbx) > 0:
driver.find_element_by_id("com.giveu.corder:id/switch_treasure").click()
else:
print("pass")
time.sleep(2)
com.get_dbtext(0,self.getparam['paramg'])
com.swipeup()
com.elm_operate(17,"")
Log().info("订单页面二完成")
etm=driver.find_element_by_id("com.giveu.corder:id/ll_item")
etms=etm.find_elements_by_id("com.giveu.corder:id/tv_choose_right")
time.sleep(1)
# com.elm_allson_click(18,19,0)
etms[0].click()
time.sleep(1)
com.get_dbtext(0,self.getparam['paramh'])
# com.elm_allson_click(18,19,1)
etms[1].click()
time.sleep(1)
com.get_dbtext(0,self.getparam['parami'])
com.elm_operate(20,"")
#预留21,22
qmb= driver.find_elements_by_id("com.giveu.corder:id/cb_insurance")
sspa= driver.find_elements_by_id("com.giveu.corder:id/cb_broken")
if self.getparam['paramj'] == '全面保' and len(qmb) > 0:
driver.find_element_by_id("com.giveu.corder:id/cb_insurance").click()
elif self.getparam['paramj'] == '碎碎平安' and len(sspa) > 0:
driver.find_element_by_id("com.giveu.corder:id/cb_broken").click()
else:
print("pass")
com.swipeup()
com.elm_operate(23,"")
Log().info("订单页面三完成")
#拍照
com.elm_operate(24,"")
com.elm_operate(25,"")
time.sleep(2)
com.elm_operate(26,con_name+chzw())
textval = com.get_elm_textval(26)
for s in range(27,41):
com.elm_operate(s,"")
time.sleep(1)
com.swipeup()
com.elm_operate(41,"")
Log().info("订单：%s 已生成"%textval)
V = OracleUtil(dbname)
time.sleep(2)
cnoval =V.oracle_getstring("select contract_no from cs_credit where id_person=(select id from (select * from cs_person where name like '%s%%' order by create_time desc) where rownum=1)"%textval)
time.sleep(1)
print(cnoval)
A = MysqlUtil()
time.sleep(2)
A.mysql_execute("INSERT INTO mobiletest_mobiledata (contract_no,con_name,con_ident,con_phone,create_time) VALUES ('%s','%s','%s','%s',NOW())"%(cnoval,textval,idcard,mobilephone))
Log().info("订单合同号：%s"%cnoval)
#预留1
com.elm_operate(42,"")
time.sleep(1)
com.elm_operate(43,"")
time.sleep(2)
com.elm_operate(44,"") #拍照确认
com.elm_operate(45,"")
Log().info("客户门店照片页完成")
com.elm_operate(46,"")
time.sleep(10) #等下最新验证码生成
pcode =V.oracle_getstring("select code from (select * from cs_sms_authority where mobile='%s' order by create_time desc) where rownum=1"%mobilephone)
time.sleep(2)
com.elm_operate(47,pcode) #输入验证码
com.elm_operate(48,"") # 征信授权页完成
Log().info("征信授权页完成")
com.elm_operate(49,"")
Log().info("PDF列表页面完成")
com.elm_operate(50,"")
com.elm_operate(51,"")
com.elm_operate(52,"")
com.elm_operate(53,"")
Log().info("其他信息页完成")
for a in range(54,67):
com.elm_operate(a,"")
com.swipeup()
com.elm_operate(67,"")
Log().info("基本信息页完成")
for b in range(68,77):
com.elm_operate(b,"")
com.swipeup()
for v in range(77,82):
com.elm_operate(v,"")
Log().info("单位信息页完成")
driver.quit()
