from selenium import webdriver
from selenium.webdriver.support.ui import Select
from selenium.webdrivr.common.keys import Keys
import pandas as pd
from datetime import datetime, date, time
import os
os.startfile(path_to_TimeSlip_program)

table = pd.read_excel('Timeslips.xlsx,
                      sheetname = 'July 2018,
                      header = 0,
                      index_col = 0,
                      parse_cols = "A, B, C, D, E",
                      convert_float = True)
print(table)
# use worksheet.nrows to iterate through each row
# use worksheet.row to access column data in each row
for current_row in range(worksheet.nrows):
    attorney_name = worksheet.row(current_row)[0]
    case_name = worksheet.row(current_row)[1]
    billing_date = worksheet.row(current_row)[2]
    work_type = worksheet.row(current_row)[3]
    billing_time = worksheet.row(current_row)[4]
    print attorney_name, case_name, billing_date, work_type, billing_time

# attorney_name is a dropdown menu, must select specific attorney name
attorney_name = Select(driver.find_element_by_name('attorney name'))
attorney_name.select_by_index(index)
attorney_name.select_by_visible_text("attorney name")
attorney_name.select_by_value(value)

# case_name is a dropdown menu, must select specific case name
case_name = Select(driver.find_element_by_name('case name'))
case_name_by_index(index)
case_name_by_visible_text("case name")
case_name_by_value(value)

# billing_date may be selected or entered using date format mm/dd/yy
billing_date = driver.find_element_by_id("billing-id"))
billing_date = driver.find_element_by_name("billing date"))
billing_date = driver.find_element_by_xpath("//input[@id='billing-id']")
billing_date.send_keys('billing_date', Keys.ENTER)


# work_type may be selected from a dropdown manu, auto-populating a description
# work_type description can be entered in a textbox
work_type = driver.find_element_by_id("work-id"))
work_type = driver.find_element_by_name("work type"))
work_type = driver.find_element_by_xpath("//input[@id='work-id']")
work_type.send_keys('work_type')

# billing time may be entered as a int or float (.1-10)
billing_time = driver.find_element_by_id("work-id"))
billing_time = driver.find_element_by_name("work type"))
billing_time = driver.find_element_by_xpath("//input[@id='work-id']")
billing_time.send_keys('billing_time)

driver.find_element_by_id("save").click()
driver.find_element_by_id("new slip").click()

# must hit save afterward
# must hit new slip to begin again
# repeat for each billing slip