python的selenium的自动化点击简单应用

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
from selenium import webdriver
from time import sleep
#登录
driver=webdriver.Chrome()
driver.get('http://xxxxxxxxxx')
sleep(2)
driver.execute_script("document.querySelector('#ContentPlaceHolder1_txtUserName').value='happykkk'")
driver.execute_script("document.querySelector('#ContentPlaceHolder1_txtPassword').value='123456'")
driver.execute_script("document.querySelector('#ContentPlaceHolder1_btnOK').click()")
import pyodbc
DBfile = r"\login_information.mdb"
# 数据库文件
conn = pyodbc.connect(r"Driver={Driver do Microsoft Access (*.mdb)};DBQ=" + DBfile + ";Pwd=p123456")
cursor = conn.cursor()
SQL = "SELECT * from user_relation_autotransfer;"
cur=cursor.execute(SQL)
data=cur.fetchall()
#初始化dict
dic={'Team1':{},'Team2':{},'Team3':{},'Team4':{},'Team5':{},'team6':{},'Team7':{}}
for i in data:
if i[3]==True:
dic[i[1]][i[0]]=0
import json
from datetime import datetime
t=str(datetime.now())[:10]
with open(r'./transfer record{}.txt'.format(t),'r') as f1:
rest=json.load(f1)
#读取excel文件内容
import xlwings as xw #利用xlwings对数据进行读取
try:
filepath=r'C:11.xlsx'
app = xw.App(visible=False, add_book=False)
wb=app.books.open(filepath)
sht=wb.sheets[0]
taskdata=sht.range('A1').expand('table').value
print(taskdata)
wb.close()
app.quit()
app.kill()
except:
wb.close()
app.quit()
app.kill()

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
#利用先判断是否，data是指人员关系表。team是指要转的team，maker是指确认岗位的人，默认为None
def chooseperson(data,team,maker=None):
m=list(rest[team].keys())
v=list(rest[team].values())
if maker in m:
#先判断maker是否在该team中，转给谁的判断是：该组内谁的任务量最少的
nn=m.index(maker)
m.pop(nn)
v.pop(nn)
num=v.index(min(v))#确定最少的任务量
result=m[num]#要转的人
rest[team][result]+=1
#转完后统计
return result#返回结果
elif maker ==None:
num=v.index(min(v))
result=m[num]
rest[team][result]+=1
return result
else:#出现任务转错team类型，maker与team不匹配
for i in data:
if i[0]==maker:#重新确认要转的team
chooseperson(data,i[1],maker) #递归调用
def searchtask(driver,tasknum):
#点击搜索任务
#利用xpath
#
driver.find_element_by_xpath('//*[@id="ContentPlaceHolder1_lbtnSearch"]').click()
driver.execute_script("document.querySelector('#ContentPlaceHolder1_lbtnSearch').click()")
sleep(1.5)
#由于上面打开速度过快点错所以要sleep
driver.execute_script("document.querySelector('#ContentPlaceHolder1_TextBox1').value=''")
# driver.execute_script("document.querySelector('#ContentPlaceHolder1_cmbForm17').click()")
sleep(1)
#选择payroll Team
driver.execute_script("document.getElementById('ContentPlaceHolder1_cmbForm17').options[28].selected=true")
sleep(1)
#填写任务编号
driver.execute_script("document.querySelector('#ContentPlaceHolder1_TextBox2').value='%s'"%(tasknum))
#点击搜索
driver.execute_script("document.querySelector('#ContentPlaceHolder1_Button4').click()")
global rest#全局变量
#判断
def transfertask(driver,data,team,maker):
#点击勾选
sleep(1)
driver.execute_script("document.querySelector('#ContentPlaceHolder1_GridView1_chk1_0').click()")
#点击转移任务
sleep(1)
driver.execute_script("document.querySelector('#ContentPlaceHolder1_ImageButton5').click()")
person=chooseperson(data,team,maker)
print(person)
sleep(1.5)
driver.execute_script("document.querySelector('#ContentPlaceHolder1_TextBox8').value='%s'"%(person))
sleep(2)
#
driver.find_element_by_xpath('//*[@id="ContentPlaceHolder1_Button8"]').click()#点击go
driver.execute_script("document.querySelector('#ContentPlaceHolder1_Button9').click()")#点击取消
sleep(1.5)
driver.implicitly_wait(20)
global rest
import datetime
def writesheet(data1,i,person):#打算mark表
#
try:
team=''
for d in data1:
if d[0].split(' ')[0].title()==i[4].split(' ')[0].title():
team=d[1]
print(team)
datares=[i[0],team,i[2],'incorrect task allocation','Y',i[5],i[6],'Y',datetime.datetime.strftime(datetime.datetime.now(),'%Y%m%d')[:6],i[4],person]
filepath=r'\Transfer Record.xlsx'
#
filepath=r''
#
app = xw.App(visible=False, add_book=False)
#
wb=app.books.open(filepath)
wb=xw.Book(filepath)
sht=wb.sheets[0]
#
sht2=wb.sheets[1]
nrow = sht.range('A65536').end('up').row+1
print(nrow)
sht.range('A{}'.format(nrow)).value=datares
wb.save(filepath)
for i in taskdata:
tasknum=str(i[0]).split(".")[0]
searchtask(driver,tasknum)
sleep(1.5)
jud=driver.find_element_by_xpath('//*[@id="ContentPlaceHolder1_GridView1"]/tbody/tr[2]/td').text
#
print(jud)
if jud!="没有数据记录":
postype=driver.find_element_by_xpath('//*[@id="ContentPlaceHolder1_GridView1"]/tbody/tr[2]/td[4]').text
if postype=='maker岗位':
maker=None
transfertask(driver,data,i[2].title(),maker)
elif postype=='check岗位':
#点击查看任务详情
driver.execute_script("document.querySelector('#ContentPlaceHolder1_GridView1_linkButton1_0').click()")
sleep(1.5)
#获取人员名字
maker=driver.find_element_by_xpath('//*[@id="ContentPlaceHolder1_GridView5"]/tbody/tr[3]/td[3]').text
sleep(1)
print(maker)
driver.execute_script("document.querySelector('#ContentPlaceHolder1_Button9').click()")#退出
sleep(1.5)
searchtask(driver,tasknum)
sleep(1.5)
transfertask(driver,data,i[2].title(),maker)
with open(r'./transfer record{}.txt'.format(t),'w') as f:#记录rest，rest是记录下当天转给每个人的次数
f.write(json.dumps(rest))