def test_newniannianying(self):
datas = ExcelReader (self.excel).data
for d in datas:
with self.subTest (data=d):
driver = selenium.webdriver.Chrome ()
driver.get("http://192.168.1.249:9901/hkjf/loginAdmin.do?method=tologin")
driver.find_element_by_xpath (".//*[@id='login']").send_keys ("yradmin")
driver.find_element_by_xpath (".//*[@id='password']").send_keys ("a12345")
time.sleep (5)
driver.find_element_by_id("button").submit()
# driver.find_element_by_name('verifyCode').clear()
#driver.find_element_by_xpath (".//*[@id='apLogin']/div[1]/ul/li[3]/p[3]/img").send_keys(text)
#driver.find_element_by_xpath (".//*[@id='button']").click()
driver.find_element_by_xpath(".//*[@id='left']/div/ul/li[5]/div/span[1]").click()
driver.find_element_by_link_text("筹款中的借款标").click()
time.sleep(1)
handles=driver.current_window_handle
print(handles)
driver.switch_to_frame("contentIframe")
driver.find_element_by_link_text("添加").click()
time.sleep(2)
driver.find_element_by_id("select1_input").click()
#季季赢 按月付息 到期还本 年年li1_input_89bbee85-c85f-11e4-90b2-d89d67270c78_4
driver.find_element_by_id("li1_input_89bbee85-c85f-11e4-90b2-d89d67270c78_4").click()
driver.find_element_by_id("select2_input").click()
driver.find_element_by_id("li2_input_1").click()
# title="m爆款标201822802"
driver.find_element_by_id("loanTitle").send_keys(d['title'])
driver.find_element_by_id("loanBorrowershowname").send_keys(d['title'])
driver.find_element_by_id("projectCode").send_keys(d['title'])
driver.find_element_by_id("amount").send_keys("10000")
# 月数
driver.find_element_by_id("termvalue").send_keys("12")
driver.find_element_by_id("biddlimit").send_keys("365")
# 年利率
driver.find_element_by_id("rate").send_keys("10")
driver.find_element_by_id("raiseRate").send_keys("0")
driver.find_element_by_id("loanrate").send_keys("0")
driver.find_element_by_id("loanServiceRate").send_keys("0")
driver.find_element_by_id("select4_input").click() #标的属性
# 标的属性
# driver.find_element_by_id("li4_input_2").click()
#选择借款人
driver.find_element_by_xpath(".//*[@id='prodetail']/div[1]/table/tbody/tr[40]/td/input[2]").send_keys(Keys.SPACE)
# time.sleep(5)
WebDriverWait (driver, 10).until (EC.presence_of_element_located ((By.XPATH, "//html/body/div/div/div/div[2]/iframe")))
# a=driver.find_elements_by_xpath(".//*[@id='d86zjCDbir']/div[1]/div[2]/iframe")
# a=driver.find_element_by_xpath("//html/body/div[2]/div[1]/div[1]/div[2]")
a=driver.find_element_by_xpath("//html/body/div/div/div/div[2]/iframe")
driver.switch_to_frame(a)
# driver.switch_to_frame(a)
#dr.find_element_by_xpath(".//*[@id='d86zjCDbir']/div[1]/div[2]/iframe")
# driver.find_element_by_xpath("//form[@id='queryForm']/ul/li/span/input").send_keys("123")
driver.find_element_by_xpath(".//*[@id='loginName']").send_keys("transfer")
driver.find_element_by_link_text("查询").click()
time.sleep(3)
driver.find_element_by_link_text("选择").click()
time.sleep(1)
driver.switch_to_default_content()
driver.switch_to_frame("contentIframe")
driver.find_element_by_link_text("保存").submit()
time.sleep(2)
al=driver.switch_to_alert()
al.accept()
# 返回列表上架
driver.switch_to_default_content()
driver.find_element_by_link_text("筹款中的借款标").click()
driver.switch_to_frame("contentIframe")
driver.find_element_by_name("title").send_keys(d['title'])
driver.find_element_by_link_text("查询").click()
driver.find_element_by_link_text("上架").click()
time.sleep(1)
# i=driver.find_element_by_class_name("___boxDialog").find_elements_by_tag_name("input")
# driver.find_element(i[0]).click()
# a=driver.find_element_by_xpath("//html/body/div/div/div/div[2]/iframe") ???
driver.find_element_by_xpath("//html/body/div/div/div/div[3]/input[1]").click()
def test_newyyy(self):
datas = ExcelReader (self.excel).data
for d in datas:
with self.subTest(data=d):
driver=selenium.webdriver.Chrome()
# driver.get("http://192.168.1.249:8501/management/login.html")
driver.get ("http://192.168.1.249:8484/hk-management-services/index.html#/creditorProperty?bidInfoId=467")
driver.find_element_by_id("login").send_keys("18812345678")
driver.find_element_by_id("password").send_keys("a12345")
driver.find_element_by_id("submit").click()
time.sleep (1)
driver.find_element_by_xpath (".//*[@id='side-menu']/li[2]/a/span[1]").click ()
driver.find_element_by_xpath (".//*[@id='side-menu']/li[2]/ul[1]/li/a/span").click ()
time.sleep (1)
driver.find_element_by_link_text("添加").click()
time.sleep(1)
driver.find_element_by_name("bidProductId").click()
# 选择产品 散标
driver.find_element_by_xpath(".//*[@id='bidForm']/div/div/div[1]/select/option[8]").click()
driver.find_element_by_name ("loanUse").click ()
driver.find_element_by_xpath(".//*[@id='bidForm']/div/div/div[2]/select/option[2]").click()
driver.find_element_by_name("title").send_keys(d['title'])
driver.find_element_by_name("bidCode").send_keys(d['title'])
# 金额
driver.find_element_by_name("totalAmount").send_keys("10000")
# 几个月
driver.find_element_by_name("termValue").send_keys("12")
# 年利率
driver.find_element_by_name("interestRate").send_keys("10")
driver.find_element_by_name("raiseRate").send_keys("0")
driver.find_element_by_name("commissionRate").send_keys("0")
driver.find_element_by_name("serviceRate").send_keys("0")
# 是否允许提前还本
driver.find_element_by_name ("advanceRepayState").click ()
# 按日 默认
# driver.find_element_by_xpath (".//*[@id='repayCapArea']/span/div[1]/input[2]").click ()
driver.find_element_by_id ("returnCapDays").send_keys ("0")
# 选择借款人
driver.find_element_by_link_text ("请选择").click ()
time.sleep(1)
driver.find_element_by_name("login").send_keys("15302602360")
driver.find_element_by_id("searchForm-searchBtn").click()
driver.find_element_by_link_text("选择").click()
time.sleep (1)
driver.find_element_by_name("type").click()
time.sleep (1)
# 正常标 爆款标 推荐标
driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[27]/select/option[2]").click ()
time.sleep(1)
# driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[26]/select/option[3]").click ()
# driver.find_element_by_xpath(".//*[@id='bidForm']/div/div/div[26]/select/option[4]").click()
# 直投 or 匹配 默认直投
# driver.find_element_by_xpath(".//*[@id='matchTypeSpan']/div/input[2]").click()
driver.find_element_by_id ("startDate").click ()
# time.sleep(1)
frame = driver.find_element_by_xpath ("html/body/div[4]/iframe")
driver.switch_to_frame (frame)
driver.find_element_by_xpath (".//*[@id='dpTodayInput']").click ()
# time.sleep(1)
driver.switch_to_default_content ()
# time.sleep(1)
driver.find_element_by_id ("endDate").click ()
# time.sleep(1)
driver.switch_to_frame (frame)
# time.sleep(1)
driver.find_element_by_xpath (".//*[@id='dpTitle']/div[6]/a").click ()
driver.find_element_by_xpath (".//*[@id='dpTitle']/div[6]/a").click ()
driver.find_element_by_xpath ("html/body/div[1]/div[3]/table/tbody/tr[4]/td[3]").click ()
driver.find_element_by_xpath ("html/body/div[1]/div[3]/table/tbody/tr[4]/td[3]").click ()
# time.sleep(1)
driver.switch_to_default_content ()
# time.sleep (1)
driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[28]/button[1]").click ()
time.sleep(1)
def test_Login(self):
datas = ExcelReader(self.excel).data
for d in datas:
with self.subTest(data=d):
login_page = LoginPage()
# Step3: 输入用户名
login_page.set_username("88812345678")
# Step4: 输入密码
login_page.set_password("a12345")
# Step5: 单击登录按钮
login_page.click_login()
time.sleep(1)
# login_page.driver.close()
login_page.click_jkbgl()
login_page.click_ckzjkb()
time.sleep(1)
login_page.click_new()
time.sleep(1)
login_page.click_bidProduct()
# 选择产品
login_page.click_yyyay() #月月赢按月
# login_page.click_yyydq() #月月赢到期
login_page.click_loanuse()
login_page.click_loanuseli()
login_page.set_title(d['title'])
login_page.set_bidcode(d['title'])
login_page.set_totalAmount("10000")
login_page.set_termValue("12")
login_page.set_interestRate("10")
login_page.set_raiseRate("0")
login_page.set_shouxufei("0")
login_page.click_choose()
time.sleep(2)
login_page.set_loanuser("18888888888")
login_page.click_search()
login_page.click_searchok()
time.sleep(1)
login_page.click_type()
# 正常标、爆款标、推荐标
login_page.click_zcbiao()
login_page.click_save()
time.sleep(1)
login_page.click_ok()
time.sleep(1)
login_page.click_ckzjkb()
time.sleep(1)
login_page.set_mingcheng(d['title'])
login_page.click_sousuo()
time.sleep(1)
login_page.click_shangjia()
time.sleep(1)
login_page.click_shangjiaok()
login_page.driver.close()
con = db.Db()
connection = con.connection
fname = DATA_PATH + '/yueyueying.xlsx'
bk = xlrd.open_workbook(fname)
try:
sh = bk.sheet_by_name("Sheet1")
except:
print
"no sheet in %s named Sheet1" % fname
# 获取第一行第一列数据
cell_value = sh.cell_value(1, 0)
print("表格", cell_value)
# 通过cursor创建游标
cursor = con.cursor
cursor.execute("SELECT * from bid_info where name=%s",
(d['title'], ))
# 提交SQL
connection.commit()
t = cursor.fetchall()
print(t)
bidname = t[0]['name']
print(bidname)
cursor = con.cursor
cursor.execute("SELECT id from bid_info where name=%s",
(bidname, ))
# 提交SQL
connection.commit()
t = cursor.fetchall()
# a=t['tel']
a = t[0]['id']
content = {
'login':
'******',
'passwd':
'QW8EQ4lM09bcIHZM86COM0462PoQ+1QibJUzLsD0b7JuCUdAPrqTTvGmHSHYj3/4ME6OSTIBrjdBFmtDomdy0OcURcTEljx9LetZpEHz7uHaDje9iguklu/KfguL8QZrWQ8LgIyWe2Hxr+GfNyP0mIihASYFQGGSGtKi/Drcqn4='
}
headers = {
'User-Agent':
'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:47.0) Gecko/20100101 Firefox/47.0',
'Accept': 'application/json, text/javascript, */*; q=0.01',
'Accept-Language': 'zh-CN,zh;q=0.8,en-US;q=0.5,en;q=0.3',
'Accept-Encoding': 'gzip, deflate',
'Content-Type':
'application/x-www-form-urlencoded; charset=UTF-8',
'X-Requested-With': 'XMLHttpRequest',
'Referer':
'http://192.168.1.249:8584/hk-financial-services/index.html',
'Content-Length': '215',
'Cookie':
'container_flag=container_flag; JSESSIONID=4C9658B8B1E2B04BBD1A5121BDA80EB3;',
'submitToken':
'"SUBMIT_TOKEN:1f5832f3-3e02-4e8a-b264-fa5ce0eaf011";',
'ticket_admin':
'lNNabgYFTOyvXgCvOP1X9YB0B7bnzslM; submitToken_admin="SUBMIT_TOKEN:1f810b88-eb9f-4a88-ade9-50f0a5d64827"; ticket=2617gSHVCRVpSoyGybrt7DZQNEoszqPY',
'Connection': 'keep-alive'
}
r = requests.post(
'http://192.168.1.249:8584/hk-financial-services/indexController/fasterLogin.do',
data=content,
headers=headers) # 发送请求
print(r.text) # 获取响应报文
print(r.status_code)
print("登录")
c = r.cookies
# def test_invest(self): --投标 141 170
content1 = {
'bidId': a,
'money': '10000',
'investRedPacketId': '',
'investRaiseInterestId': ''
}
r1 = requests.post(
'http://192.168.1.249:8584/hk-financial-services/bidInfoController/invest.do',
data=content1,
cookies=c) # 发送请求
# return r.json
print(r1.text) # 获取响应报文
print(r1.status_code)
print("投资")
def test_Login(self):
# excel = DATA_PATH + '/register.xlsx'
datas = ExcelReader(self.excel).data
db = Db()
connection = db.connection
cursor = db.cursor
for d in datas:
with self.subTest(data=d):
cursor.execute(
"SELECT code from bidd_info where title='推荐季季按月1703'")
connection.commit()
t = cursor.fetchall()
# a=t['tel']
code = t[0]['code']
print('标的code:', code)
tel = int(float(d['title']))
print('用户：', tel)
# 用户登录
content = {
'access_token': '1b1d5757-9322-4d83-bb79-fed79f973dad',
'mobileUDID': '2cae768b2925730a',
'password':
'******',
'appVersion': 'v2.6.3',
'mobileModel': 'MI 4LTE',
'login': tel,
'mobileVersion': '6.0.1',
'mobileIp': '02:00:00:00:00:00',
'mobileMAC': '02:00:00:00:00:00',
'passLength': '6',
}
r = requests.post(
'http://192.168.1.249:9921/hkjfapp/user/doLogin',
data=content) # 发送请求
print('登录响应状态', r.status_code)
txt = r.text
print(r.text)
c = r.cookies
# r = re.findall (r'<input name="token" type="hidden" value="(.+?)"/>', txt)
usercode = re.findall(r'资","code":"(.+?)","gender":"', txt)
sessionid = re.findall(r',"sessionId":"(.+?)","userType', txt)
print(usercode, ' ', sessionid)
# 投标
content_tz = {
'amount': '10000',
'biddCode': code,
'investType': '1',
'sessionId': sessionid[0],
'signType': 'MD5',
'source': '4',
'userCode': usercode[0]
}
#描述 用户对标的进行指定金额的投资接口 签名生成方式，key保证a-z有序并且组装成URL请求形式，使用RSA生成签名，sign和空值key不参与组装，当使用md5签名时，将MD5秘钥加在原串的最后 &key=******
# URL1 = "http://192.168.1.249:9921/hkjfapp/invest/invest?"
a = Mysign.mysign(content_tz)
print(a)
a1 = a + '&key=AMvFWdickzxK/sCwiG5BVKu8HkqxcrQEjSKmvCfZ44QfNsKiV7pG1'
print(a1)
m = hashlib.md5() # 创建md5对象
m.update(
a1.encode(encoding='UTF-8')) # 生成加密串，其中password是要加密的字符串
# hashlib.md5('abcdefg'.encode(encoding='UTF-8')).hexdigest()
sign = m.hexdigest()
print(sign)
# # urlll=a+'&sign='+sign
# # print(urlll)
content_tz2 = {
'access_token': '1b1d5757-9322-4d83-bb79-fed79f973dad',
'amount': '10000',
'biddCode': code,
'investType': '1',
'sessionId': sessionid[0],
'sign': sign,
'signType': 'MD5',
'source': '4',
'userCode': usercode[0]
}
rtz = requests.post(
"http://192.168.1.249:9921/hkjfapp/invest/invest",
params=content_tz2,
cookies=c)
print('投资状态', rtz.status_code)
print(rtz.text)
def test_Login(self):
datas = ExcelReader(self.excel).data
for d in datas:
with self.subTest(data=d):
login_page = LoginPage()
# Step3: 输入用户名
login_page.set_username("88812345678")
# Step4: 输入密码
login_page.set_password("a12345")
# Step5: 单击登录按钮
login_page.click_login()
time.sleep(1)
# login_page.driver.close()
login_page.click_jkbgl()
login_page.click_ckzjkb()
time.sleep(1)
login_page.click_new()
time.sleep(1)
login_page.click_bidProduct()
# 选择产品
login_page.click_yyyay() #月月赢按月
# login_page.click_yyydq() #月月赢到期
login_page.click_loanuse()
login_page.click_loanuseli()
login_page.set_title(d['title'])
login_page.set_bidcode(d['title'])
login_page.set_totalAmount("10000")
login_page.set_termValue("12")
login_page.set_interestRate("10")
login_page.set_raiseRate("0")
login_page.set_shouxufei("0")
login_page.click_choose()
time.sleep(2)
login_page.set_loanuser("18888888888")
login_page.click_search()
login_page.click_searchok()
time.sleep(1)
login_page.click_type()
# 正常标、爆款标、推荐标
login_page.click_zcbiao()
login_page.click_save()
time.sleep(1)
login_page.click_ok()
time.sleep(1)
login_page.click_ckzjkb()
time.sleep(1)
login_page.set_mingcheng(d['title'])
login_page.click_sousuo()
time.sleep(1)
login_page.click_shangjia()
time.sleep(1)
login_page.click_shangjiaok()
login_page.driver.close()
con = db.Db()
connection = con.connection
fname = DATA_PATH + '/yueyueying.xlsx'
bk = xlrd.open_workbook(fname)
try:
sh = bk.sheet_by_name("Sheet1")
except:
print
"no sheet in %s named Sheet1" % fname
# 获取第一行第一列数据
cell_value = sh.cell_value(1, 0)
print("表格", cell_value)
# 通过cursor创建游标
cursor = con.cursor
cursor.execute("SELECT * from bid_info where name=%s",
(d['title'], ))
# 提交SQL
connection.commit()
t = cursor.fetchall()
print(t)
bidname = t[0]['name']
print(bidname)
cursor = con.cursor
cursor.execute("SELECT id from bid_info where name=%s",
(bidname, ))
# 提交SQL
connection.commit()
t = cursor.fetchall()
# a=t['tel']
a = t[0]['id']
#前台用户登录
user = '******'
content = {
'login':
user,
'passwd':
'QW8EQ4lM09bcIHZM86COM0462PoQ+1QibJUzLsD0b7JuCUdAPrqTTvGmHSHYj3/4ME6OSTIBrjdBFmtDomdy0OcURcTEljx9LetZpEHz7uHaDje9iguklu/KfguL8QZrWQ8LgIyWe2Hxr+GfNyP0mIihASYFQGGSGtKi/Drcqn4='
}
headers = {
'User-Agent':
'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:47.0) Gecko/20100101 Firefox/47.0',
'Accept': 'application/json, text/javascript, */*; q=0.01',
'Accept-Language': 'zh-CN,zh;q=0.8,en-US;q=0.5,en;q=0.3',
'Accept-Encoding': 'gzip, deflate',
'Content-Type':
'application/x-www-form-urlencoded; charset=UTF-8',
'X-Requested-With': 'XMLHttpRequest',
'Referer':
'http://192.168.1.249:8584/hk-financial-services/index.html',
'Content-Length': '215',
'Cookie':
'container_flag=container_flag; JSESSIONID=4C9658B8B1E2B04BBD1A5121BDA80EB3;',
'submitToken':
'"SUBMIT_TOKEN:1f5832f3-3e02-4e8a-b264-fa5ce0eaf011";',
'ticket_admin':
'lNNabgYFTOyvXgCvOP1X9YB0B7bnzslM; submitToken_admin="SUBMIT_TOKEN:1f810b88-eb9f-4a88-ade9-50f0a5d64827"; ticket=2617gSHVCRVpSoyGybrt7DZQNEoszqPY',
'Connection': 'keep-alive'
}
r = requests.post(
'http://192.168.1.249:8584/hk-financial-services/indexController/fasterLogin.do',
data=content,
headers=headers) # 发送请求
print(r.text) # 获取响应报文
print(r.status_code)
print("登录")
c = r.cookies
# 查询名下的可使用的加息券
user = '******'
cursor.execute("SELECT id from reg_user where login=%s",
(user, )) # 用户id
# 提交SQL
connection.commit()
uid = cursor.fetchall()
user_id = uid[0]['id']
print(user_id)
cursor.execute(
"SELECT id from vas_coupon_product where type='0'"
) # 卡券类型产品id
# 提交SQL
connection.commit()
pid = cursor.fetchall()
# pro_id = pid[0]['id']
print(pid)
# print(pro_id)
num = len(pid)
# print(len(pid))
lis = []
for p in pid:
pro_id = pid[num - 1]['id']
num = num - 1
# print(pro_id)
# 某某的加息券，适用于月月赢的id cur.execute("select * from user where userid = '%s' and password = '******'" %(userid,password))
# cursor.execute("SELECT * from vas_coupon_detail where acceptor_user_id='%s' and coupon_product_id in('%s') and state=1 and bid_product_type_range like'%2%'"
# %(user_id, pro_id))
cursor.execute(
"SELECT id from vas_coupon_detail where acceptor_user_id='%s' and coupon_product_id in('%s') and state=1 and find_in_set('2', bid_product_type_range)"
% (user_id, pro_id))
# userid='15510000011'
# password='******'
# cursor.execute("SELECT * from reg_user where login= '******' and passwd = '%s'" %(userid,password))
connection.commit()
jxqid = cursor.fetchall()
if type(jxqid) is tuple:
pass
else:
lis.append(jxqid)
print("lis 是：", lis)
n = len(lis)
# for a in lis:
# a=lis[n-1][0]
# n=n-1
# print(a['id'])
jxq_id = lis[n - 1][0]['id']
print(jxq_id)
# def test_invest(self): --投标 141 170
content1 = {
'bidId': a,
'money': '10000',
'investRedPacketId': '',
'investRaiseInterestId': jxq_id
}
r1 = requests.post(
'http://192.168.1.249:8584/hk-financial-services/bidInfoController/invest.do',
data=content1,
cookies=c) # 发送请求
# return r.json
print(r1.text) # 获取响应报文
print(r1.status_code)
print("投资")
# 后台登录
conten2 = {
'randomCode':
'123',
'rememberMe':
'0',
'login':
'******',
'passwd':
'H/SOSDPHotw0L2qVobGWQkipJ7HWEkabs5Q63qU8PW8NvPy5HYNwMZuu2bG03VxixQczvSQRaWlEDror33LOflH7DJUPRiwD/1iYB1w1qsBN0z/1KwargVhtGw/SMDUd9yTotjfG4NbiGH9yiiba8t1hHVVVCCJbv6PvEn1bBYs='
}
r2 = requests.post(
'http://192.168.1.249:8584/hk-management-services/managementLoginController/login',
data=conten2) # 发送请求
print(r2.text) # 获取响应报文
print(r2.status_code)
print("123")
c2 = r2.cookies
# def test_invest(self): --投标 141 170
content3 = {'id': a, 'reason': '满标审核通过', 'state': '4'}
# http://192.168.1.249:8584/hk-management-services/bidInfoController/auditBid
r3 = requests.post(
'http://192.168.1.249:8584/hk-management-services/bidInfoController/auditBid',
data=content3,
cookies=c2) # 发送请求
# return r.json
print(r3.text) # 获取响应报文
print(r3.status_code)
print("审核")
# http://192.168.1.249:8501/management/loanController/makeLoans?bidInfoId=302
# http://192.168.1.249:8584/hk-management-services/bidInfoController/auditBid
a1 = 'http://192.168.1.249:8584/hk-management-services/loanController/makeLoans?bidInfoId='
a2 = str(a)
add = a1 + a2
r4 = requests.post(add, cookies=c2)
# return r.json
print(r4.text) # 获取响应报文
print(r4.status_code)
print("放款")
def test_Login(self):
tels = ExcelReader (self.tel).data
for d in tels:
with self.subTest (data=d):
regtel=int(d['login'])
print(regtel)
cursor = Db ().get_cursor ()
connection = Db.get_connection (self)
# cursor.execute ("SELECT id from bid_info where name=%s", (bidname,))
cursor.execute("SELECT code from loginuser where LOGIN=%s",(regtel,)) #查询code
connection.commit ()
t1 = cursor.fetchall ()
code=t1[0]['code']
print (code)
cursor.execute ("SELECT ENTITY_STATUS from fn_account where user_code=%s", (code,)) #查询银行卡状态
connection.commit ()
t2 = cursor.fetchall ()
print(t2)
status = t2[0]['ENTITY_STATUS']
# 判断是否已经绑卡 0未绑卡
if status == 0:
print ('hello null')
cursor.execute ("update fn_account set bank_code=null,bank_account=null,entity_no=null,entity_status=0,entity_name=null,entity_bank=null,entity_dept=null,entity_province=null,entity_city=null,entity_addr=null where user_code=%s",
(code,))
# SELECT * FROM personinfo WHERE LOGIN_NAME='牟泓霏'
# UPDATE personinfo set login_name='',login_card='' where login_name='牟泓霏'
connection.commit ()
driver = webdriver.Chrome ()
driver.get (qturl)
WebDriverWait (driver, 10).until (EC.presence_of_element_located ((By.ID, 'login')))
driver.find_element_by_id ('login').send_keys (regtel)
time.sleep (1)
e1 = driver.find_element_by_xpath (".//*[@id='txt2']")
action = ActionChains (driver)
action.move_to_element (e1).click ().send_keys ('a12345').perform ()
driver.find_element_by_xpath (".//*[@id='logindiv']/div/div[2]").click ()
driver.find_element_by_link_text ("我的账号").click ()
time.sleep(2)
driver.find_element_by_link_text ("提现").click ()
time.sleep (3)
driver.find_element_by_id("entityNo").send_keys("6214830103287743")
driver.find_element_by_id("province").click()
driver.find_element_by_xpath(".//*[@id='province']/option[2]").click()
driver.find_element_by_id("city").click()
driver.find_element_by_xpath(".//*[@id='city']/option[1]").click()
driver.find_element_by_id("bank_entity_addr").send_keys("某支行")
driver.find_element_by_id("btn_sub").click()
driver.find_element_by_link_text("提现").click()
time.sleep(1)
driver.find_element_by_id ("tranAmt").send_keys ("0.02")
driver.find_element_by_id ("btn_sub").click ()
#已经绑卡 status=1
else:
print ('not null')
driver=webdriver.Chrome()
driver.get ('http://192.168.1.249:9901/hkjf/index.do?method=getIndexPage')
WebDriverWait (driver, 10).until (EC.presence_of_element_located ((By.ID, 'login')))
driver.find_element_by_id ('login').send_keys (regtel)
time.sleep (1)
e1 = driver.find_element_by_xpath (".//*[@id='txt2']")
action = ActionChains (driver)
action.move_to_element (e1).click ().send_keys ('a12345').perform ()
driver.find_element_by_xpath (".//*[@id='logindiv']/div/div[2]").click()
driver.find_element_by_link_text("我的账号").click()
driver.find_element_by_link_text("提现").click()
time.sleep(1)
# driver.find_element_by_id("entityNo").send_keys("6228481200290317812")
# driver.find_element_by_id("province").click()
# driver.find_element_by_xpath(".//*[@id='province']/option[2]").click()
# driver.find_element_by_id("city").click()
# driver.find_element_by_xpath(".//*[@id='city']/option[1]").click()
# driver.find_element_by_id("bank_entity_addr").send_keys("某支行")
# driver.find_element_by_id("btn_sub").click()
# driver.find_element_by_link_text("提现").click()
driver.find_element_by_id("tranAmt").send_keys("0.01")
driver.find_element_by_id("btn_sub").click()
#登录后台审核
driver.get("http://192.168.1.249:9901/hkjf/loginAdmin.do?method=tologin")
driver.find_element_by_id("login").send_keys("yradmin")
driver.find_element_by_id("password").send_keys("a12345")
time.sleep(8)
driver.find_element_by_id("button").click()
#提现审核
driver.find_element_by_xpath(".//*[@id='left']/div/ul/li[7]/div/span[1]").click()
time.sleep(0.5)
driver.find_element_by_link_text("提现审核").click()
driver.switch_to_frame("contentIframe")
time.sleep(1)
driver.find_element_by_id("tel").send_keys(regtel)
driver.find_element_by_link_text("查询").click()
time.sleep(1)
driver.find_element_by_xpath("//html/body/div/div[2]/div[2]/div/table/tbody/tr/td/input").click() #选择复选框
#交易流水号提取
driver.find_element_by_link_text("审核").click()
tfno = driver.find_element_by_xpath (".//*[@id='bindingfrom']/table/tbody/tr[3]/td[6]").text
driver.find_element_by_link_text("通过").click()
driver.switch_to_default_content ()
time.sleep(0.5)
#提现放款
driver.find_element_by_xpath(".//*[@id='left']/div/ul/li[7]/div/span[1]").click()
driver.find_element_by_link_text("提现放款审核").click()
driver.switch_to_frame("contentIframe")
time.sleep(0.5)
driver.find_element_by_id("flowId").send_keys(tfno)
driver.find_element_by_link_text("查询").click()
driver.find_element_by_link_text("放款").click()
time.sleep(0.5)
driver.find_element_by_link_text("通过").click()
time.sleep(0.5)
driver.close()
def test_ppy2s1(self):
connection = pymysql.connect(host='192.168.1.249',
port=3307,
user='******',
password='******',
db='p2p_product_hotcopy',
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor)
fname = DATA_PATH + '/yueyueying.xlsx'
fname2 = DATA_PATH + '/sanbiao.xlsx'
bk = xlrd.open_workbook(fname)
bk2 = xlrd.open_workbook(fname2)
shxrange = range(bk.nsheets)
shxrange2 = range(bk2.nsheets)
try:
sh = bk.sheet_by_name("Sheet1")
sh2 = bk2.sheet_by_name("Sheet1")
except:
print
"no sheet in %s named Sheet1" % fname
"no sheet in %s named Sheet1" % fname2
# 获取第一行第一列数据
cell_value = sh.cell_value(1, 0)
youxuan2 = sh.cell_value(2, 0)
cell_value2 = sh2.cell_value(1, 0)
print(cell_value)
print(youxuan2)
print(cell_value2)
# 通过cursor创建游标
cursor = connection.cursor()
# sql = "SELECT code FROM bidd_info where title='%s'",(cell_value) # 加str确认与%s匹配
#
# # 创建sql 语句，并执行
# # sql = "SELECT code FROM bidd_info ORDER BY id LIMIT 1"
# cursor.execute (sql)
# cursor.execute ("SELECT code FROM bidd_info where title=%s", (cell_value,))
cursor.execute("SELECT code FROM bidd_info where title=%s",
(cell_value, ))
# 提交SQL
connection.commit()
t = cursor.fetchall()
# a=t['tel']
biddtitle = t
biddcode = biddtitle[0]['code']
# [{'tel': '15912345678'}]
print(biddtitle)
print(biddcode)
# 查第二个名字
cursor.execute("SELECT code FROM bidd_info where title=%s",
(youxuan2, ))
# 提交SQL
connection.commit()
t2 = cursor.fetchall()
# a=t['tel']
biddtitle2 = t2
biddcode2 = biddtitle2[0]['code']
# [{'tel': '15912345678'}]
print(biddtitle2)
print(biddcode2)
datas = ExcelReader(self.excel).data
tzusers = ExcelReader(self.user).data
tzbidds = ExcelReader(self.bidd).data
for d in datas:
with self.subTest(data=d):
driver = webdriver.Chrome()
driver.get(
'http://192.168.1.249:9901/hkjf/index.do?method=getIndexPage'
)
WebDriverWait(driver, 10).until(
EC.presence_of_element_located((By.ID, 'login')))
for u in tzusers:
with self.subTest(tzuser=u):
# driver = webdriver.Chrome ()
# driver.get ('http://192.168.1.249:9901/hkjf/index.do?method=getIndexPage')
# WebDriverWait (driver, 10).until (EC.presence_of_element_located ((By.ID, 'login')))
driver.find_element_by_id('login').send_keys(
int(u['user']))
time.sleep(1)
e1 = driver.find_element_by_xpath(".//*[@id='txt2']")
action = ActionChains(driver)
action.move_to_element(e1).click().send_keys(
"2971055a690ad019e9fc08a9971080ccfd6a8b588c69acc28383a12d9cfdcb135a60550a4df643b9967c5fab90ce4eb8e3970c2c093fefe299662ac44e868763d281e8708ab625528d55c6a777b2700bcb9daf7e7e0c6805ffd13760d4ac0120d6f43c2dc05fc38fcff485eedd8859d79200ddb7a9a606b8548fa1d8def1dacc"
).perform()
driver.find_element_by_xpath(
".//*[@id='logindiv']/div/div[2]").submit()
# address=("http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail&code=ed791706-92f7-4435-b6f6-aa944ed87f4c")
ad1 = "http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail&code="
ad2 = biddcode
add = ad1 + ad2
driver.get(add)
time.sleep(1)
# driver.find_element_by_id ("projectCode").send_keys (d['title'])
t = driver.find_element_by_xpath(
"html/body/div[2]/div[2]/div[2]/div[2]/div[1]/span"
).text
# string转换为float类型
setlocale(LC_NUMERIC, 'English_US')
# 剩余可投金额
t1 = int(atof(t)) # 123456.0
print(t)
print(t1)
# 根据表格配置金额投资
# driver.find_element_by_id ("amount").send_keys (int (d['amount']))
# 剩余可投金额--全投
driver.find_element_by_id("amount").send_keys(t1)
driver.find_element_by_link_text("立即投资").click()
time.sleep(3)
driver.find_element_by_class_name("dialogBtn").click()
time.sleep(3)
# input class="dialogBtn" type="button" value="确定"
# 投第二个标
# ad1 = "http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail&code="
ad3 = biddcode2
addd = ad1 + ad3
driver.get(addd)
time.sleep(2)
# driver.find_element_by_id ("projectCode").send_keys (d['title'])
t = driver.find_element_by_xpath(
"html/body/div[2]/div[2]/div[2]/div[2]/div[1]/span"
).text
# string转换为float类型
setlocale(LC_NUMERIC, 'English_US')
# 剩余可投金额
t1 = int(atof(t)) # 123456.0
print(t)
print(t1)
# 根据表格配置金额投资
# driver.find_element_by_id ("amount").send_keys (int (d['amount']))
# 剩余可投金额--全投
driver.find_element_by_id("amount").send_keys(t1)
driver.find_element_by_link_text("立即投资").click()
time.sleep(3)
driver.find_element_by_class_name("dialogBtn").click()
# input class="dialogBtn" type="button" value="确定"
for d in datas:
with self.subTest(data=d):
driver = webdriver.Chrome()
driver.get(
"http://192.168.1.249:9901/hkjf/loginAdmin.do?method=tologin"
)
driver.find_element_by_xpath(
".//*[@id='login']").send_keys("yradmin")
driver.find_element_by_xpath(
".//*[@id='password']").send_keys("a12345")
time.sleep(5)
# 手动输入验证码
# driver.find_element_by_xpath (".//*[@id='apLogin']/div[1]/ul/li[3]/p[3]/img").send_keys(text)
driver.find_element_by_id("button").submit()
# driver.find_element_by_name('verifyCode').clear()
#driver.find_element_by_xpath (".//*[@id='apLogin']/div[1]/ul/li[3]/p[3]/img").send_keys(text)
#driver.find_element_by_xpath (".//*[@id='button']").click()
driver.find_element_by_xpath(
".//*[@id='left']/div/ul/li[5]/div/span[1]"
).click()
time.sleep(1)
driver.find_element_by_link_text(
"待审核的借款标").click()
driver.switch_to_frame("contentIframe")
# driver.find_element_by_name ("title").send_keys(biddtitle)
driver.find_element_by_name("title").send_keys(
cell_value)
driver.find_element_by_link_text("查询").click()
driver.find_element_by_link_text("审核").click()
time.sleep(1)
driver.find_element_by_id("content").send_keys(
"满标审核通过")
driver.find_element_by_link_text("通过").click()
time.sleep(2)
driver.find_element_by_name("title").send_keys(
youxuan2)
time.sleep(2)
driver.find_element_by_link_text("查询").click()
driver.find_element_by_link_text("审核").click()
time.sleep(1)
driver.find_element_by_id("content").send_keys(
"满标审核通过")
driver.find_element_by_link_text("通过").click()
time.sleep(2)
driver.switch_to_default_content()
time.sleep(2)
# 财务管理-放款
driver.find_element_by_xpath(
".//*[@id='left']/div/ul/li[7]/div/span[1]"
).click()
time.sleep(1)
driver.find_element_by_link_text(
"待放款的借款标").click()
driver.switch_to_frame("contentIframe")
driver.find_element_by_name("title").send_keys(
cell_value)
time.sleep(1)
driver.find_element_by_link_text("查询").click()
driver.find_element_by_link_text("放款").click()
time.sleep(1)
driver.find_element_by_xpath(
"//html/body/div/div/div/div[3]/input[1]"
).click()
time.sleep(2)
al1 = driver.switch_to_alert()
time.sleep(1)
al1.accept()
time.sleep(2)
# # 重新点击菜单 待放款的借款标
driver.switch_to_frame("contentIframe")
driver.find_element_by_name("title").send_keys(
youxuan2)
time.sleep(2)
driver.find_element_by_link_text("查询").click()
driver.find_element_by_link_text("放款").click()
time.sleep(2)
# a = driver.find_element_by_xpath ("//html/body/div/div/div/div[2]/iframe")
driver.find_element_by_xpath(
"//html/body/div/div/div/div[3]/input[1]"
).click()
time.sleep(3)
al1 = driver.switch_to_alert()
al1.accept()
time.sleep(2)
# # 匹配管理
# driver.switch_to_default_content ()
# time.sleep (2)
driver.find_element_by_xpath(
".//*[@id='left']/div/ul/li[6]/div/span[1]"
).click()
time.sleep(2)
driver.find_element_by_link_text(
"一个散标匹配多个优选").click()
driver.switch_to_frame("contentIframe")
driver.find_element_by_name("title").send_keys(
cell_value2)
driver.find_element_by_link_text("查询").click()
driver.find_element_by_link_text("匹配").click()
driver.find_element_by_link_text("选择").click()
time.sleep(2)
# 选择优选
a = driver.find_element_by_xpath(
"//html/body/div/div/div/div[2]/iframe")
driver.switch_to_frame(a)
driver.find_element_by_name("title").send_keys(
"m月月匹配201803190")
driver.find_element_by_link_text("查询").click()
time.sleep(2)
driver.find_element_by_id("types").click()
time.sleep(1)
driver.find_element_by_id("btn_sub").click()
time.sleep(2)
driver.switch_to_frame("contentIframe")
time.sleep(2)
driver.find_element_by_id("btn_sub").click()
def test_Login(self):
datas = ExcelReader(self.excel).data
login_page = TiyanjinPage()
driver = login_page.driver
# Step3: 输入用户名
login_page.set_admin("yradmin")
# Step4: 输入密码
login_page.set_password("a12345")
time.sleep(6)
# Step5: 单击登录按钮
login_page.click_login()
db = Db()
connection = db.connection
cursor = db.cursor
for d in datas:
with self.subTest(data=d):
# 获取用户code
cursor.execute("SELECT code from loginuser where tel=%s",
(d['tel']))
connection.commit()
t = cursor.fetchall()
# a=t['tel']
usercode = t[0]['code']
print('用户code:', usercode)
cursor.execute(
"SELECT * from fn_sim_account where STATUS=0 and USER_CODE=%s",
usercode)
connection.commit()
t = cursor.fetchall()
l = len(t)
if l == 0:
pass
else:
# DELETE from fn_sim_account where USER_CODE=
cursor.execute(
"DELETE from fn_sim_account where USER_CODE=%s",
usercode)
connection.commit()
login_page.click_tyjgl()
login_page.click_tyjff()
time.sleep(1)
driver.switch_to_frame("contentIframe")
login_page.set_tel(int(d['tel']))
login_page.click_sousuo()
login_page.click_choose()
# 发放体验金
login_page.click_fftyj()
login_page.set_money("10000") #金额
login_page.click_qrff()
driver.switch_to_default_content()
#新建体验标
login_page.click_jkbgl()
login_page.click_ckzjkb()
time.sleep(1)
driver.switch_to_frame("contentIframe")
login_page.click_new()
time.sleep(1)
login_page.click_bidProduct()
# 选择产品
login_page.click_tyb() # 体验标
login_page.click_loanuse()
login_page.click_loanuseli()
login_page.set_title(d['bidd'])
login_page.set_loanBorrowershowname(d['bidd'])
login_page.set_bidcode(d['bidd'])
login_page.set_totalAmount("10000")
login_page.set_termValue("12")
login_page.set_biddlimit("365")
login_page.set_interestRate("10")
login_page.set_raiseRate("0")
login_page.set_shouxufei("0")
login_page.click_type()
# 是否是新手标
# driver.find_element_by_xpath (".//*[@id='prodetail']/div[1]/table/tbody/tr[22]/td/span[1]/div[1]/input").send_keys (Keys.SPACE)
# 选择借款人
login_page.set_choose()
WebDriverWait(driver, 10).until(
EC.presence_of_element_located(
(By.XPATH, "//html/body/div/div/div/div[2]/iframe")))
a = driver.find_element_by_xpath(
"//html/body/div/div/div/div[2]/iframe")
driver.switch_to_frame(a)
login_page.set_loanuser("张效伟")
# login_page.set_loanuser("18301306330")
login_page.click_search()
time.sleep(3)
login_page.click_searchok()
time.sleep(1)
driver.switch_to_default_content()
driver.switch_to_frame("contentIframe")
# login_page.click_type()
# # 正常标、爆款标、推荐标
# login_page.click_zcbiao()
time.sleep(1)
login_page.click_save()
time.sleep(2)
al = driver.switch_to_alert()
al.accept()
# 返回列表上架
driver.switch_to_default_content()
login_page.click_ckzjkb()
driver.switch_to_frame("contentIframe")
login_page.set_mingcheng(d['bidd'])
login_page.click_sousuo2()
login_page.click_shangjia()
time.sleep(1)
driver.find_element_by_xpath(
"//html/body/div/div/div/div[3]/input[1]").click()
#用户投资
# cursor.execute ("SELECT code FROM bidd_info where title=%s", (cell_value,))
cursor.execute("SELECT code from bidd_info where title=%s",
(d['bidd']))
connection.commit()
t = cursor.fetchall()
# a=t['tel']
code = t[0]['code']
print('标的code:', code)
tel = int(float(d['tel']))
print('用户：', tel)
#SELECT * from fn_sim_account where USER_CODE=(SELECT code from loginuser where tel='13010000012')and STATUS=0;
#获取用户code
cursor.execute("SELECT code from loginuser where tel=%s",
(d['tel']))
connection.commit()
t = cursor.fetchall()
# a=t['tel']
usercode = t[0]['code']
print('用户code:', usercode)
# 用户登录
content = {
'login': tel,
'password':
'******',
'pwdLevel': '2',
'verify_code': '请输入计算结果',
'randCode': '请输入您的6位验证码',
'commendPhone': '请输入推荐码(推荐人手机号后8位)',
'loginregister': '请输入您的手机号',
'passwordresgister': '',
'token': '',
'modulus': '',
'exponent': '',
'newToken': '',
'phoneId': '',
'code': '',
'utype': '',
'csrftoken': '',
'pwdLevel': ''
}
r = requests.post(
'http://192.168.1.249:9901/hkjf/login.do?method=indexlogin',
data=content) # 发送请求
print('登录响应状态', r.status_code)
c = r.cookies
# 请求标的详情
content_xq = {'code': code, 'tempType': '2'}
rxq = requests.get(
"http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail",
params=content_xq,
cookies=c)
txt = rxq.text
r = re.findall(
r'<input name="token" type="hidden" value="(.+?)"/>',
txt)
# print("token的值是：",r)
print('详情响应code:', rxq.status_code)
# 用户投资
contenttz = {
'code': code,
'token': r,
'couponDetailCodeK': '',
'couponDetailCodeJ': '',
'confirmAmount': '10000',
'useAbleMoney': '10000'
}
rtz = requests.post(
'http://192.168.1.249:9901/hkjf/investController.do?method=goodsOpenInvest',
data=contenttz,
cookies=c) # 发送请求
# print (r1.text) # 获取响应报文
print('投资响应状态', rtz.status_code)
# #后台满标审核
driver.switch_to_default_content()
driver.find_element_by_xpath(
".//*[@id='left']/div/ul/li[5]/div/span[1]").click()
driver.find_element_by_link_text("待审核的借款标").click()
driver.switch_to_frame("contentIframe")
time.sleep(1)
driver.find_element_by_name("title").send_keys(d['bidd'])
driver.find_element_by_link_text("查询").click()
time.sleep(1)
driver.find_element_by_link_text("审核").click()
driver.find_element_by_id("content").send_keys("ok")
driver.find_element_by_link_text("通过").click()
#放款
driver.switch_to_default_content()
time.sleep(1)
driver.find_element_by_xpath(
".//*[@id='left']/div/ul/li[7]/div/span[1]").click()
time.sleep(0.5)
driver.find_element_by_link_text("待放款的借款标").click()
driver.switch_to_frame("contentIframe")
time.sleep(1)
driver.find_element_by_name("title").send_keys(d['bidd'])
driver.find_element_by_link_text("查询").click()
time.sleep(1)
driver.find_element_by_link_text("放款").click()
driver.find_element_by_xpath(
"//html/body/div/div/div/div[3]/input[1]").click()
driver.close()
def test_newyyy(self):
datas = ExcelReader (self.excel).data
for d in datas:
with self.subTest(data=d):
driver = selenium.webdriver.Chrome ()
driver.get (self.URL)
# http://192.168.1.249:8501/management/login.html
driver.find_element_by_id("login").send_keys("88812345678")
driver.find_element_by_id("password").send_keys("cxjmanage8123")
driver.find_element_by_id("submit").click()
time.sleep (1)
driver.find_element_by_xpath (".//*[@id='side-menu']/li[2]/a/span[1]").click ()
driver.find_element_by_xpath (".//*[@id='side-menu']/li[2]/ul[1]/li/a/span").click ()
time.sleep (1)
driver.find_element_by_link_text("添加").click()
time.sleep(1)
driver.find_element_by_name("bidProductId").click()
# 选择产品 月月赢
# 月月按月付息 .//*[@id='bidForm']/div/div/div[1]/select/option[2]
driver.find_element_by_xpath(".//*[@id='bidForm']/div/div/div[1]/select/option[2]").click()
# 季季按月付息 .//*[@id='bidForm']/div/div/div[1]/select/option[4]
# driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[1]/select/option[4]").click ()
# 年年按月付息 .//*[@id='bidForm']/div/div/div[1]/select/option[6]
# driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[1]/select/option[6]").click ()
driver.find_element_by_name ("loanUse").click()
driver.find_element_by_xpath(".//*[@id='bidForm']/div/div/div[2]/select/option[2]").click()
driver.find_element_by_name("title").send_keys(d['title'])
driver.find_element_by_name("bidCode").send_keys(d['title'])
# 金额
driver.find_element_by_name("totalAmount").send_keys("10000")
# 几个月
driver.find_element_by_name("termValue").send_keys("12")
# driver.find_element_by_name("stepValue").send_keys("100")
# 年利率
driver.find_element_by_name("interestRate").send_keys("10")
driver.find_element_by_name("raiseRate").send_keys("0")
# 手续费
driver.find_element_by_name("commissionRate").send_keys("0")
driver.find_element_by_name("serviceRate").send_keys("0")
driver.find_element_by_link_text("请选择").click()
time.sleep(1)
# 选择借款人
# 18301306330 14510000500
driver.find_element_by_name("login").send_keys("18888888888")
driver.find_element_by_id("searchForm-searchBtn").click()
driver.find_element_by_link_text("选择").click()
time.sleep (1)
driver.find_element_by_name("type").click()
# 正常标 爆款标 推荐标
driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[27]/select/option[2]").click ()
# driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[27]/select/option[3]").click ()
# driver.find_element_by_xpath(".//*[@id='bidForm']/div/div/div[27]/select/option[4]").click()
driver.find_element_by_id ("startDate").click ()
# time.sleep(1)
frame = driver.find_element_by_xpath ("html/body/div[4]/iframe")
driver.switch_to_frame (frame)
driver.find_element_by_xpath (".//*[@id='dpTodayInput']").click ()
# time.sleep(1)
driver.switch_to_default_content ()
# time.sleep(1)
driver.find_element_by_id ("endDate").click ()
# time.sleep(1)
driver.switch_to_frame (frame)
#
#
# time.sleep(1)
driver.find_element_by_xpath (".//*[@id='dpTitle']/div[6]/a").click ()
driver.find_element_by_xpath (".//*[@id='dpTitle']/div[6]/a").click ()
driver.find_element_by_xpath ("html/body/div[1]/div[3]/table/tbody/tr[4]/td[3]").click ()
driver.find_element_by_id ("dpOkInput").click ()
driver.switch_to_default_content ()
time.sleep (1)
driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[28]/button[1]").click ()
time.sleep (1)
driver.find_element_by_id ("alertOkBtn").click ()
time.sleep (1)
# 返回上架
# driver.find_element_by_xpath (".//*[@id='side-menu']/li[1]/ul[1]/li/a/span").click ()
# driver.find_element_by_xpath (".//*[@id='side-menu']/li[2]/a/span[1]").click ()
driver.find_element_by_xpath (".//*[@id='side-menu']/li[2]/ul[1]/li/a/span").click ()
time.sleep (1)
driver.find_element_by_name ("title").send_keys (d['title'])
driver.find_element_by_id ("searchForm-searchBtn").click ()
time.sleep (1)
driver.find_element_by_xpath (".//*[@id='mDataTable']/tbody/tr[1]/td[14]/a[2]").click ()
time.sleep (1)
driver.find_element_by_id ("confirmOkBtn").click ()
time.sleep(2)
logger.info(d['title'])
def test_Login(self):
datas = ExcelReader (self.excel).data
login_page = LoginPage ()
driver = login_page.driver
# Step3: 输入用户名
login_page.set_admin ("yradmin")
# Step4: 输入密码
login_page.set_password ("a12345")
time.sleep (6)
# Step5: 单击登录按钮
login_page.click_login ()
for d in datas:
with self.subTest (data=d):
# login_page = LoginPage ()
# driver=login_page.driver
# # Step3: 输入用户名
# login_page.set_admin ("yradmin")
# # Step4: 输入密码
# login_page.set_password ("a12345")
# time.sleep (6)
# # Step5: 单击登录按钮
# login_page.click_login ()
login_page.click_jkbgl()
login_page.click_ckzjkb()
time.sleep (1)
driver.switch_to_frame("contentIframe")
login_page.click_new()
time.sleep (1)
login_page.click_bidProduct()
# 选择产品
login_page.click_yyyay() #月月赢按月
# login_page.click_yyydq() #月月赢到期
login_page.click_loanuse()
login_page.click_loanuseli()
login_page.set_title(d['title'])
login_page.set_loanBorrowershowname(d['title'])
login_page.set_bidcode(d['title'])
login_page.set_totalAmount("1000000")
login_page.set_termValue("12")
login_page.set_biddlimit("365")
login_page.set_interestRate("10")
login_page.set_raiseRate("0")
login_page.set_shouxufei("0")
login_page.set_choose()
WebDriverWait (driver, 10).until (EC.presence_of_element_located ((By.XPATH, "//html/body/div/div/div/div[2]/iframe")))
a = driver.find_element_by_xpath ("//html/body/div/div/div/div[2]/iframe")
driver.switch_to_frame (a)
login_page.set_loanuser("张效伟")
# login_page.set_loanuser("18301306330")
login_page.click_search()
time.sleep(3)
login_page.click_searchok()
time.sleep(1)
driver.switch_to_default_content ()
driver.switch_to_frame ("contentIframe")
# login_page.click_type()
# # 正常标、爆款标、推荐标
# login_page.click_zcbiao()
time.sleep(1)
login_page.click_save()
time.sleep(2)
al = driver.switch_to_alert ()
al.accept ()
# 返回列表上架
driver.switch_to_default_content ()
login_page.click_ckzjkb()
driver.switch_to_frame ("contentIframe")
login_page.set_mingcheng(d['title'])
login_page.click_sousuo()
login_page.click_shangjia()
time.sleep(1)
driver.find_element_by_xpath ("//html/body/div/div/div/div[3]/input[1]").click ()
driver.switch_to_default_content()
driver.close()
def test_Login(self):
tels = ExcelReader(self.tel).data
for d in tels:
with self.subTest(data=d):
regtel = int(d['login'])
driver = webdriver.Chrome()
zcurl = qturl + '/regist.do?method=toRegist'
driver.get(zcurl)
driver.find_element_by_id("nickName").send_keys("hkjf")
driver.find_element_by_id("login").send_keys(regtel)
# 手动输入问题
time.sleep(5)
# driver.find_element_by_id("verify_code").send_keys('1')
driver.find_element_by_id("sendSmsBtn").click()
time.sleep(0.5)
time.sleep(2.5)
connection = Db().get_connection()
cursor = Db().get_cursor()
# cursor.execute ("SELECT id from bid_info where name=%s", (bidname,))
#SELECT * from sys_tel_message where tel='15912345678'
cursor.execute(
"SELECT * from sys_tel_message where tel=%s order by id desc limit 1",
(regtel, ))
connection.commit()
t = cursor.fetchall()
yzm = t[0]['MESSAGE_NOTE']
print(yzm)
cursor.execute("SELECT * FROM personinfo WHERE LOGIN_NAME=%s",
(d['name'], ))
# SELECT * FROM personinfo WHERE LOGIN_NAME='牟泓霏'
# UPDATE personinfo set login_name='',login_card='' where login_name='牟泓霏'
connection.commit()
t1 = cursor.fetchall()
print(t1)
print()
l = len(t1)
# print (l)
# 输入密码
txt2 = driver.find_element_by_id("txt2")
action_a = ActionChains(driver)
action_a.move_to_element(txt2).click().send_keys(
'a12345').send_keys(Keys.RETURN).perform()
# 推荐码
# driver.find_element_by_id("commendPhone").send_keys("01307172")
# 定位焦点方法
elem = driver.find_element_by_id("randCode")
action_a0 = ActionChains(driver)
action_a0.move_to_element(elem).click().send_keys(
yzm).send_keys(Keys.RETURN).perform()
driver.find_element_by_id("btn_sub").submit()
# #判断身份证，姓名是否已经被使用
# if l == 0:
# print ('hello null')
# driver.find_element_by_id ("loginName").send_keys (d['name']) # 姓名
# driver.find_element_by_id ("idCard").send_keys (d['idcard']) # 身份证
# driver.find_element_by_id ("email").send_keys ("*****@*****.**") # 邮箱
# driver.find_element_by_id ("btn_sub").click ()
# else:
# print ('not null')
# cursor.execute ("UPDATE personinfo set login_name='',login_card='' where login_name=%s", (d['name'],))
# # SELECT * FROM personinfo WHERE LOGIN_NAME='牟泓霏'
# # UPDATE personinfo set login_name='',login_card='' where login_name='牟泓霏'
# connection.commit ()
# # t1 = cursor.fetchall ()
# # print (t1)
# driver.find_element_by_id("loginName").send_keys(d['name']) #姓名
# driver.find_element_by_id("idCard").send_keys(d['idcard']) #身份证
# driver.find_element_by_id("email").send_keys("*****@*****.**") #邮箱
# driver.find_element_by_id("btn_sub").click()
# # time.sleep()
# # driver.find_element_by_link_text("跳过该环节>>").click()
driver.close()
def test_Login(self):
datas = ExcelReader(self.excel).data
for d in datas:
with self.subTest(data=d):
login_page = LoginPage()
# Step3: 输入用户名
login_page.set_username("88812345678")
# Step4: 输入密码
login_page.set_password("a12345")
# Step5: 单击登录按钮
login_page.click_login()
time.sleep(1)
# login_page.driver.close()
login_page.click_jkbgl()
login_page.click_ckzjkb()
time.sleep(1)
login_page.click_new()
time.sleep(1)
login_page.click_bidProduct()
# 选择产品
login_page.click_sanbiao()
login_page.click_loanuse()
login_page.click_loanuseli()
login_page.set_title(d['title'])
login_page.set_bidcode(d['title'])
login_page.set_totalAmount("10000")
login_page.set_termValue("6")
login_page.set_interestRate("10")
login_page.set_raiseRate("1")
login_page.set_shouxufei("1")
login_page.set_serviceRate("1")
login_page.click_tqhb() #提前还本
login_page.click_ayjx() #按月计息
login_page.set_returnCapDays("0")
login_page.click_choose()
time.sleep(2)
#13010000040
login_page.set_loanuser("13010000017")
login_page.click_search()
login_page.click_searchok()
time.sleep(1)
login_page.click_type()
# 正常标、爆款标、推荐标
login_page.click_zcbiao()
#匹配or直投
# login_page.click_zhitou() #直投类型
login_page.click_pipei() #匹配类型
login_page.click_save()
time.sleep(1)
login_page.click_ok()
# time.sleep (1)
# login_page.click_ckzjkb () #返回上架
# time.sleep (1)
# login_page.set_mingcheng(d['title'])
# login_page.click_sousuo()
# time.sleep(1)
# login_page.click_shangjia()
# time.sleep(1)
# login_page.click_shangjiaok()
login_page.driver.close()
import time
from utils.config import Config, DATA_PATH, REPORT_PATH
from utils.file_reader import ExcelReader
from selenium import webdriver
from selenium.webdriver.common.by import By
excel = DATA_PATH + '/renzi.xlsx'
datas = ExcelReader(excel).data
for d in datas:
driver = webdriver.Firefox()
driver.implicitly_wait(10)
driver.get('http://10.1.27.52:9011/')
driver.find_element(
By.XPATH, "//input[@widgetcode='JGTextBox1']").send_keys(d['username'])
driver.find_element(By.XPATH,
"//input[@widgetcode='JGPasswordBox1']").send_keys(
d['password'])
driver.find_element(By.XPATH, "//*[@widgetcode='JGButton1']").click()
time.sleep(1)
# fail_text = driver.find_element(By.ID, "dialog_content_div").text
# print("----->%s" % fail_text)
# if fail_text:
# print("fail_text %s" % fail_text)
#
# else:
# sucess_text = driver.find_element(By.XPATH, "//span[contains(text(),'登录时间')] ").text
# print('sucess_text %s' % sucess_text)
# driver.quit()
driver.find_element(
By.XPATH,
import os
from selenium.webdriver.common.by import By
import unittest
from utils.config import Config, DATA_PAHT
from utils.log import logger
from utils.file_reader import ExcelReader
from parameterized import parameterized
from test.page.login_page import LoginPage
from test.page.index_page import IndexPage
account_path = DATA_PAHT + '\\user_account.xlsx'
account = ExcelReader(account_path, sheet=1).data
class TestLogin(unittest.TestCase):
URL = Config().get('EAF-URL')
txtAccount = (By.ID, 'txtAccount')
txtPassword = (By.ID, 'txtPassword')
print('文件路径', account_path)
def setUp(self):
os.system('taskkill /f /im chromedriver.exe')
self.page = LoginPage().get(self.URL)
self.page.sleep(2)
def tearDown(self):
self.page.sleep(1.5)
self.page.quit()
@parameterized.expand(account)
def test_login(self, username, password):
def test_Login(self):
tels = ExcelReader(self.tel).data
for d in tels:
with self.subTest(data=d):
regtel = int(d['login'])
print(regtel)
driver = webdriver.Chrome()
driver.get(jkurl +
'/hk-financial-services/register/register.html')
driver.find_element_by_id("nickName").send_keys("hkjf")
driver.find_element_by_id("loginTmp").send_keys(regtel)
# 手动输入问题
time.sleep(8)
# input('请输入?计算结果！')
# driver.find_element_by_id("verify_code")sendSmsBtn
driver.find_element_by_id("smsCodeBtn").click()
time.sleep(0.5)
driver.find_element_by_xpath(
".//*[@id='dialog']/div/div/div[1]/button").click()
time.sleep(3)
con = db.Db()
connection = con.connection
cursor = con.cursor
# cursor.execute ("SELECT id from bid_info where name=%s", (bidname,))
#SELECT * from sys_tel_message where tel='15912345678'
cursor.execute(
"SELECT msg from sms_tel_msg WHERE tel=%s order by id desc limit 1",
(regtel, ))
# 提交SQL
connection.commit()
t = cursor.fetchall()
yzm = t[0]['msg']
print(yzm)
cursor.execute(
"SELECT real_name from reg_user_detail WHERE real_name=%s",
(d['name'], ))
# SELECT * FROM personinfo WHERE LOGIN_NAME='牟泓霏'
# UPDATE personinfo set login_name='',login_card='' where login_name='牟泓霏'
connection.commit()
t1 = cursor.fetchall()
print(t1)
print()
l = len(t1)
print(l)
# 输入密码
driver.find_element_by_id("passwdTmp").send_keys("a12345")
# 推荐码
driver.find_element_by_id("commendNo").send_keys("69321686")
# 定位焦点方法
elem = driver.find_element_by_id("smsCode")
action_a0 = ActionChains(driver)
action_a0.move_to_element(elem).click().send_keys(
yzm).send_keys(Keys.RETURN).perform()
driver.find_element_by_id("submitBtn").submit()
time.sleep(0.5)
#判断身份证，姓名是否已经被使用
if l == 0:
print('hello null')
driver.find_element_by_id("realName").send_keys(
d['name']) # 姓名
driver.find_element_by_id("idCard").send_keys(
d['idcard']) # 身份证
driver.find_element_by_id("email").send_keys(
"*****@*****.**") # 邮箱
driver.find_element_by_id("submitBtn").click()
else:
print('not null')
cursor.execute(
"SELECT reg_user_id from reg_user_detail where real_name=%s",
(d['name'], ))
connection.commit()
t2 = cursor.fetchall()
id = t2[0]['reg_user_id']
print(id)
# cursor.execute ("SELECT identify from reg_user where id=%s", (id,))
# connection.commit ()
cursor.execute(
"update reg_user set identify=0 where id=%s",
(id, )) # 清理实名状态
connection.commit()
cursor.execute(
"UPDATE reg_user_detail set real_name='',id_card='' where real_name=%s",
(d['name'], )) # 清理实名
connection.commit()
# t1 = cursor.fetchall ()
# print (t1)
driver.find_element_by_id("realName").send_keys(
d['name']) #姓名
driver.find_element_by_id("idCard").send_keys(
d['idcard']) #身份证
driver.find_element_by_id("email").send_keys(
"*****@*****.**") #邮箱
driver.find_element_by_id("submitBtn").click()
time.sleep(2)
# driver.find_element_by_link_text("跳过该环节>>").click()
driver.close()
def test_newsanbiaomonth(self):
datas = ExcelReader(self.excel).data
for d in datas:
with self.subTest(data=d):
driver = webdriver.Chrome()
driver.get(
"http://192.168.1.249:9901/hkjf/loginAdmin.do?method=tologin"
)
driver.find_element_by_xpath(".//*[@id='login']").send_keys(
"yradmin")
driver.find_element_by_xpath(".//*[@id='password']").send_keys(
"a12345")
time.sleep(5)
# 手动输入验证码
# driver.find_element_by_xpath (".//*[@id='apLogin']/div[1]/ul/li[3]/p[3]/img").send_keys(text)
driver.find_element_by_id("button").submit()
# driver.find_element_by_name('verifyCode').clear()
#driver.find_element_by_xpath (".//*[@id='apLogin']/div[1]/ul/li[3]/p[3]/img").send_keys(text)
#driver.find_element_by_xpath (".//*[@id='button']").click()
driver.find_element_by_xpath(
".//*[@id='left']/div/ul/li[5]/div/span[1]").click()
driver.find_element_by_link_text("筹款中的借款标").click()
time.sleep(1)
handles = driver.current_window_handle
print(handles)
driver.switch_to_frame("contentIframe")
driver.find_element_by_link_text("添加").click()
time.sleep(5)
driver.find_element_by_id("select1_input").click()
#月月赢 按月付息 到期还本
driver.find_element_by_id(
"li1_input_934981df-2ac6-11e5-9ecc-1051721c3a3e_0").click(
)
driver.find_element_by_id("select2_input").click()
driver.find_element_by_id("li2_input_1").click()
# title="m爆款标201822802"
driver.find_element_by_id("loanTitle").send_keys(d['title'])
driver.find_element_by_id("loanBorrowershowname").send_keys(
d['title'])
driver.find_element_by_id("projectCode").send_keys(d['title'])
driver.find_element_by_id("amount").send_keys("100000")
driver.find_element_by_id("termvalue").send_keys("1")
driver.find_element_by_id("biddlimit").send_keys("365")
driver.find_element_by_id("rate").send_keys("10")
driver.find_element_by_id("raiseRate").send_keys("0")
driver.find_element_by_id("loanrate").send_keys("0")
driver.find_element_by_id("loanServiceRate").send_keys("0")
driver.find_element_by_id("select4_input").click()
# 标的属性
# driver.find_element_by_id("li4_input_2").click()
# 是否提前还款
driver.find_element_by_name("isAdvReturnCap").send_keys(
Keys.SPACE)
# driver.find_element_by_id("returnCapDays").send_keys("0")
#选择借款人
# .//*[@id='prodetail']/div[1]/table/tbody/tr[22]/td/span[1]/div[1]/input
# .//*[@id='prodetail']/div[1]/table/tbody/tr[32]
# .//*[@id='prodetail']/div[1]/table/tbody/tr[44]/td/input[2]
driver.find_element_by_xpath(
".//*[@id='prodetail']/div[1]/table/tbody/tr[44]/td/input[2]"
).send_keys(Keys.SPACE)
# time.sleep(5)
WebDriverWait(driver, 15).until(
EC.presence_of_element_located(
(By.XPATH, "//html/body/div/div/div/div[2]/iframe")))
# a=driver.find_elements_by_xpath(".//*[@id='d86zjCDbir']/div[1]/div[2]/iframe")
# a=driver.find_element_by_xpath("//html/body/div[2]/div[1]/div[1]/div[2]")
a = driver.find_element_by_xpath(
"//html/body/div/div/div/div[2]/iframe")
driver.switch_to_frame(a)
# driver.switch_to_frame(a)
#dr.find_element_by_xpath(".//*[@id='d86zjCDbir']/div[1]/div[2]/iframe")
# driver.find_element_by_xpath("//form[@id='queryForm']/ul/li/span/input").send_keys("123")T
driver.find_element_by_xpath(
".//*[@id='loginName']").send_keys("颜祖佑")
driver.find_element_by_link_text("查询").click()
time.sleep(3)
driver.find_element_by_link_text("选择").click()
time.sleep(1)
driver.switch_to_default_content()
driver.switch_to_frame("contentIframe")
driver.find_element_by_link_text("保存").submit()
time.sleep(2)
al = driver.switch_to_alert()
al.accept()
# 返回列表上架
driver.switch_to_default_content()
driver.find_element_by_link_text("筹款中的借款标").click()
driver.switch_to_frame("contentIframe")
driver.find_element_by_name("title").send_keys(d['title'])
driver.find_element_by_link_text("查询").click()
def test_Login(self):
datas = ExcelReader(self.excel).data
for d in datas:
with self.subTest(data=d):
amount = 10000
# Step3: 输入用户名
# login_page.set_admin ("yradmin")
# # Step4: 输入密码
# login_page.set_password ("a12345")
# time.sleep (6)
# # Step5: 单击登录按钮
# login_page.click_login ()
#
# login_page.click_jkbgl ()
# login_page.click_ckzjkb ()
# time.sleep (1)
# driver.switch_to_frame ("contentIframe")
# login_page.click_new ()
# time.sleep (1)
# login_page.click_bidProduct ()
# # 选择产品
# login_page.click_yyyay() # 月月赢按月
# # login_page.click_nnydq () # 年年赢到期
# login_page.click_loanuse ()
# login_page.click_loanuseli ()
# login_page.set_title (d['title'])
# login_page.set_loanBorrowershowname (d['title'])
# login_page.set_bidcode (d['title'])
# login_page.set_totalAmount (amount)
# login_page.set_termValue ("3")
# login_page.set_biddlimit ("365")
# login_page.set_interestRate ("10")
# login_page.set_raiseRate ("0")
# login_page.set_shouxufei ("0")
# login_page.set_choose ()
# WebDriverWait (driver, 10).until (
# EC.presence_of_element_located ((By.XPATH, "//html/body/div/div/div/div[2]/iframe")))
# a = driver.find_element_by_xpath ("//html/body/div/div/div/div[2]/iframe")
# driver.switch_to_frame (a)
# login_page.set_loanuser ("transfer")
#
# # login_page.set_loanuser("18301306330")
# login_page.click_search ()
# time.sleep (3)
# login_page.click_searchok ()
# time.sleep (1)
# driver.switch_to_default_content ()
# driver.switch_to_frame ("contentIframe")
# # login_page.click_type()
# # # 正常标、爆款标、推荐标
# # login_page.click_zcbiao()
# time.sleep (1)
# login_page.click_save ()
# time.sleep (2)
# al = driver.switch_to_alert ()
# al.accept ()
# # 返回列表上架
# driver.switch_to_default_content ()
# login_page.click_ckzjkb ()
# driver.switch_to_frame ("contentIframe")
# login_page.set_mingcheng (d['title'])
# login_page.click_sousuo ()
#
# login_page.click_shangjia ()
# time.sleep (1)
# driver.find_element_by_xpath ("//html/body/div/div/div/div[3]/input[1]").click ()
connection = Db().get_connection()
cursor = Db().get_cursor()
# 通过cursor创建游标
cursor.execute("SELECT * from bidd_info where title=%s",
(d['title'], ))
# 提交SQL
connection.commit()
t = cursor.fetchall()
print(t)
bidname = t[0]['TITLE']
print(bidname)
cursor.execute("SELECT code from bidd_info where title=%s",
(bidname, ))
# 提交SQL
connection.commit()
t = cursor.fetchall()
# a=t['tel']
a = t[0]['code']
#登录前台投资
driver = webdriver.Chrome()
driver.get(
'http://192.168.1.249:9901/hkjf/index.do?method=getIndexPage'
)
WebDriverWait(driver, 10).until(
EC.presence_of_element_located((By.ID, 'login')))
driver.find_element_by_id('login').send_keys('13010000013')
time.sleep(1)
e1 = driver.find_element_by_xpath(".//*[@id='txt2']")
action = ActionChains(driver)
action.move_to_element(e1).click().send_keys(
"8b08c0bd2c536072a4bed2ddebcc4f01a73549106e04d12659aed56cf938d6b72f3a53149b488e4a309f2fe9851d8d3ad60a429cbe4e82dd16cfb1206dc7c7752ddf861a79374247777d76d3188061738b196fddd53e3f0ae1044c525fa9f35de6cfa0ce69dd2f2e30e4211acfd8a4d806d9c22bb5130aa68eceda6cc78c9630"
).perform()
driver.find_element_by_xpath(
".//*[@id='logindiv']/div/div[2]").submit()
time.sleep(1)
# address=("http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail&code=ed791706-92f7-4435-b6f6-aa944ed87f4c")
ad1 = "http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail&code="
ad2 = a
add = ad1 + ad2
driver.get(add)
time.sleep(1)
# driver.find_element_by_id ("projectCode").send_keys (d['title'])
driver.find_element_by_id("amount").send_keys(amount) #投资金额
driver.find_element_by_link_text("立即投资").click()
time.sleep(3)
driver.find_element_by_class_name("dialogBtn").click()
# 后台登录
driver.get(
"http://192.168.1.249:9901/hkjf/loginAdmin.do?method=tologin"
)
login_page.set_admin("yradmin")
# Step4: 输入密码
login_page.set_password("a12345")
time.sleep(6)
# Step5: 单击登录按钮
login_page.click_login()
login_page.click_jkbgl()
time.sleep(0.5)
#审核标的
driver.find_element_by_link_text("待审核的借款标").click()
driver.switch_to_frame("contentIframe")
time.sleep(0.5)
driver.find_element_by_name("title").send_keys(d['title'])
driver.find_element_by_link_text("查询").click()
driver.find_element_by_link_text("审核").click()
driver.find_element_by_id("content").send_keys("满标审核通过！")
driver.find_element_by_link_text("通过").click()
driver.switch_to_default_content()
#放款
driver.find_element_by_xpath(
".//*[@id='left']/div/ul/li[7]/div/span[1]").click()
time.sleep(0.5)
driver.find_element_by_link_text("待放款的借款标").click()
driver.switch_to_frame("contentIframe")
time.sleep(0.5)
driver.find_element_by_name("title").send_keys(d['title'])
driver.find_element_by_link_text('查询').click()
driver.find_element_by_link_text("放款").click()
time.sleep(0.8)
driver.find_element_by_xpath(
"//html/body/div/div/div/div[3]/input[1]").click()
driver.close()
def test_Login(self):
# excel = DATA_PATH + '/register.xlsx'
datas = ExcelReader(self.excel).data
for d in datas:
with self.subTest(data=d):
db = Db()
connection = db.connection
cursor = db.cursor
# cursor.execute ("SELECT message_note from sys_tel_message where tel='13301302026'")
cursor.execute(
"SELECT code from bidd_info where title='月月9438'")
connection.commit()
t = cursor.fetchall()
# a=t['tel']
code = t[0]['code']
print('标的code:', code)
tel = int(float(d['title']))
print('用户：', tel)
# 用户登录
content = {
'login': tel,
'password':
'******',
'pwdLevel': '2',
'verify_code': '请输入计算结果',
'randCode': '请输入您的6位验证码',
'commendPhone': '请输入推荐码(推荐人手机号后8位)',
'loginregister': '请输入您的手机号',
'passwordresgister': '',
'token': '',
'modulus': '',
'exponent': '',
'newToken': '',
'phoneId': '',
'code': '',
'utype': '',
'csrftoken': '',
'pwdLevel': ''
}
r = requests.post(
'http://192.168.1.249:9901/hkjf/login.do?method=indexlogin',
data=content) # 发送请求
print('登录响应状态', r.status_code)
print(r.text)
c = r.cookies
# 请求标的详情
content_xq = {'code': code, 'tempType': '2'}
rxq = requests.get(
"http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail",
params=content_xq,
cookies=c)
txt = rxq.text
r = re.findall(
r'<input name="token" type="hidden" value="(.+?)"/>',
txt)
# print("token的值是：",r)
print('详情响应code:', rxq.status_code)
# 用户投资
contenttz = {
'code': code,
'token': r,
'couponDetailCodeK': '',
'couponDetailCodeJ': '',
'confirmAmount': '1000',
'useAbleMoney': ''
}
rtz = requests.post(
'http://192.168.1.249:9901/hkjf/investController.do?method=goodsOpenInvest',
data=contenttz,
cookies=c) # 发送请求
print('投资响应状态', rtz.status_code)
