自动化程序(已废弃)

import xlrd
import xlwt
from selenium import webdriver
import time
from selenium.webdriver.support.ui import Select
driver = webdriver.Firefox()
driver.get('http://192.168.200.101:4002/#/login')
def t (int):
    time.sleep(int)
def Refresh ():
    driver.refresh()
time.sleep(3)
driver.find_element_by_xpath(".//*[@id='firstname']").send_keys('123456@163.com') # u只是为了传入正确的中文。
driver.find_element_by_xpath(".//*[@id='secondname']").send_keys('123456')
# driver.find_element_by_xpath("html/body/div[2]/form/div/div[4]/label/input").click()
driver.find_element_by_xpath("html/body/div[2]/form/div/button").click()
t(3)
# 客服模式下的数据显示
# 获取页面第一行标签
'''
lineTag = driver.find_elements_by_class_name("top-box-title")
lineTag1 = driver.find_elements_by_class_name("top-box-data ng-binding")
lineTag2 = driver.find_elements_by_class_name("top-box-second")
lineTag3 = driver.find_elements_by_class_name("top-box-second-spn ng-binding")
i = []
for i in lineTag:
    if i.get_attribute("class") == "top-box-title":
        print(i.text)
        time.sleep(5)
'''

def First_value():
    #listClassO = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[1]/div/div[1]/p[1]").text
    listClassO2 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[1]/div/div[1]/p[2]").text
    #listClassT = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[2]/div/div[1]/p[1]").text
    listClassT2 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[2]/div/div[1]/p[2]").text
    #listClassS = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[3]/div/div[1]/p[1]").text
    listClassS2 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[3]/div/div[1]/p[2]").text
    #listClassF = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[4]/div/div[1]/p[1]").text
    listClassF2 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[4]/div/div[1]/p[2]").text
    #listClassC = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[5]/div/div[1]/p[1]").text
    listClassC2 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[5]/div/div[1]/p[2]").text
    #listFirst = [listClassO, listClassT, listClassS, listClassF, listClassC]
    listFirst2 = [listClassO2, listClassT2, listClassS2, listClassF2, listClassC2]
    #return listFirst
    return listFirst2
def Second_value():
    List1 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[1]/div/div[2]/p").text
    List11 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[1]/div/div[2]/p/span").text
    List2 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[2]/div/div[2]/p").text
    List22 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[2]/div/div[2]/p/span").text
    List3 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[3]/div/div[2]/p").text
    List33 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[3]/div/div[2]/p/span").text
    List4 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[4]/div/div[2]/p").text
    List44 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[4]/div/div[2]/p/span").text
    List5 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[5]/div/div[2]/p").text
    List55 = driver.find_element_by_xpath(".//*[@id='uiView']/div/div/div[1]/div[2]/div[5]/div/div[2]/p/span").text
    listSecond = [List1, List2, List3, List4, List5]
    listSecond2 = [List11, List22, List33, List44, List55]
    return listSecond2

#print(First_value())
#Second_value()
t(3)

First_value()

def PageSwithc():
    driver.find_element_by_xpath('html/body/div[1]/div/div/span/a').click()
    driver.find_element_by_xpath('html/body/div[1]/div/div/ul/a[2]').click()
# 会话
def Page1():
    # 挂起 在线
    driver.find_element_by_class_name('status').click()
    time.sleep(1)
    driver.find_element_by_id('dialog').click()
# 首页
def  Page2():
    driver.find_element_by_id('reportForm').click()
    time.sleep(1)
    # driver.refresh()


def xunhuan():
    time.sleep(1)
    PageSwithc()
    time.sleep(1)
    Page1()
    time.sleep(1)
    Page2()
    time.sleep(1)
    Page1()







#print(listFirst)
#print(listFirst2)
#list = [listFirst]

#print(list)

#driver.close()
#driver.quit()


'''
def write_Excel():
        wb = xlwt.Workbook(encoding='utf-8',style_compression=0) #创建文件
        Sheet = wb.add_sheet("zhangzhen") #改变sheet为zhangzhen
        Sheet.write(0, 0, "csid 客服id")
        Sheet.write(0, 1, "consulting_user 正在咨询用户数")
        Sheet.write(0, 2, "online_waiter 在线客服人数")
        Sheet.write(0, 3, "waiting 正在排队人数")
        Sheet.write(0, 4, "end_waiting 结束排队人数")
        Sheet.write(0, 5, "waiting_length waiting_length")
        Sheet.write(0, 6, "session 会话数量")
        Sheet.write(0, 7, "session_length 会话时长")
        wb.save("e:\zhangzhen.xls")  #保存文件
'''
'''
def write_Excel():
    MyBook = xlwt.Workbook(encoding='utf-8',style_compression=0)
    Sheet = MyBook.add_sheet("今日在线服务器数据趋势")
    list = ["正在咨询人数","正在排队人数","今日会话量","今日未接入会话量","今日满意度"]
    MyBook.save("f:\zhangzhen.xls")

write_Excel()

def read_Excel():
    wb2 =xlrd.open_workbook(r"e:\\originaldata.xlsx")
    Sheet1 = wb2.sheet_by_index(0) #第一个表(第一种)
    #Sheet2 = wb2.sheet_by_name(u'Sheet2') 第二种方法
    SheetName = wb2.sheet_names() #查看包含的工作表
    #print(Sheet2)
    #print(Sheet1)
    #print(SheetName[0])
    nrows = Sheet1.nrows #获取行数
    ncols = Sheet1.ncols #获取列数
    cell_value = Sheet1.cell_value(0,0)
    cell_value2 = Sheet1._cell_values
    print('nrows %d, ncols %d' % (nrows, ncols))
    #print(cell_value)
    #print(cell_value2)
    #print(len(cell_value2))
    for i in cell_value2:
       print(i)


from xlutils.copy import copy
from CIM自动化package import GetPageElenmet
import xlrd
import time
list = GetPageElenmet.First_value()
list2 = GetPageElenmet.Second_value()
rb = xlrd.open_workbook("f:\\zhangzhen.xls")
# MyBook1 = xlwt.Workbook(encoding='utf-8',style_compression=0)
wb = copy(rb)
# Sheet = wb.get_sheet(0)
'''
def value():
    Sheet.write(0, 0,"正在咨询人数")
    Sheet.write(1,0,list[0])
    Sheet.write(0, 1,"正在排队人数")
    Sheet.write(1,1,list[1])
    Sheet.write(0, 2,"今日会话量")
    Sheet.write(1,2,list[2])
    Sheet.write(0, 3,"今日未接入会话量")
    Sheet.write(1,3,list[3])
    Sheet.write(0, 4,"今日相对满意度")
    Sheet.write(1,4,list[4])
    MyBook.save("f:\zhangzhen.xls")
def form():
    Sheet.write(2,0,"排队量")
    Sheet.write(3,0,list[1])
    Sheet.write(2,1,"已接入会话量")
    Sheet.write(3,1,list[0])
    Sheet.write(2,2,"未接入会话量")
    Sheet.write(3,2,list[3]+list[2])
    Sheet.write(2,3,"总会话量")
    Sheet.write(3,3,)
    now = time.strftime("%H%M%S")
    Sheet.write(0,4,now)
    MyBook.save("f:\zhangzhen.xls")
value()
form()
'''
Sheet = wb.get_sheet("Sheet1")
'''
nrows =Sheet.nrows #行
ncols =Sheet.ncols #列
print(ncols)
print(nrows)
'''
print(list)
print(list2)
sh = rb.sheet_by_name("Sheet1")
ncols = sh.ncols  # 获取列数
print(ncols)
tag = ["正在咨询人数", "正在排队人数", "今日会话量", "今日未接入会话量", "今日相对满意度"]
tag2 = ["当前在线客服数", "今日平均排队时长", "今日平均会话时长", "接入率", "参评率"]
'''
def shijian():
    now = time.strftime("%H%M%S")
    M = time.strftime("%M")
    if M == 00:
        Sheet.write(0,7,"时间")
        Sheet.write(1,7,now)
'''
def sleeptime(hours, min, sec):
    return hours*3600+min*60+sec

def write_xls(now, ncol, ncol2):
    #第一栏数据
    for i in range(0, len(list)):
        Sheet.write(now, i, list[i])
    #第一栏标签
    for Tag in range(0, len(tag)):
        Sheet.write(1, Tag, tag[Tag])

    #第二栏标签
    for Tag2 in range(0, len(tag2)):
        Sheet.write(0, ncol, tag2[Tag2])
        ncol += 1

    #第二栏数据
    for value in range(0,len(list2)):
        Sheet.write(now,ncol2,list2[value])
        ncol2+=1
        wb.save("f:\zhangzhen.xls")

ncol = ncols+1
ncol2 = ncols+1
now=2
min = sleeptime(0,0,30)
while True:
    GetPageElenmet.PageSwithc()
    time.sleep(1)
    GetPageElenmet.Page1()
    write_xls(now,ncol,ncol2)
    now += 1
    time.sleep(min)
    # 首页
    GetPageElenmet.Page2()
    time.sleep(1)
    list = GetPageElenmet.First_value()
    list2 = GetPageElenmet.Second_value()
    time.sleep(1)
    #会话
    GetPageElenmet.Page1()



    #if(now>1000):
        #break








'''