def add_safety(target_user, a):
browser.implicitly_wait(10)
browser.get(
'https://sysco.sprocketcmms.com/Default.aspx?screen=People&SSF=-134')
search_box = browser.find_element_by_link_text('Search')
search_box.click()
user_name_field = browser.find_element_by_id('UserName_txt0')
user_name_field.clear()
user_name_field.send_keys(target_user)
start_search = browser.find_element_by_id('SearchScreenBtnSearch')
start_search.click()
browser.find_element_by_link_text(target_user).click()
time.sleep(3)
if int(a) == 1:
print('Flagging OverrideWorkDay')
ignore_wdt = browser.find_element_by_id('StdSf_62_OverrideWorkDay_chk')
ignore_wdt.click()
groups_tab = browser.find_element_by_id('liGroups')
time.sleep(3)
groups_tab.click()
add_group = browser.find_element_by_id('txt_Group')
add_group.send_keys('Data-FSY')
submit_group = browser.find_element_by_xpath(
'//*[@id="divGroups"]/table/tbody/tr[1]/td[2]/input[2]')
submit_group.click()
time.sleep(1)
save_exit = browser.find_element_by_link_text('Save')
save_exit.click()
time.sleep(3)
browser.switch_to.alert.accept()
def find_schedule(schedule, location_based=0):
browser.implicitly_wait(10)
if location_based == 0:
browser.get(
'https://sysco.sprocketcmms.com/Default.aspx?screen=PM%20Projects&SSF=-108'
)
print('---> Loading Equipment Based View')
elif location_based == 1:
browser.get(
'https://sysco.sprocketcmms.com/Default.aspx?screen=PM%20Projects&SSF=244'
)
print('---> Loading Location Based View')
else:
print(
'--->!! Value outside of defined parameters\nlocation_based=0\nor\nlocation_based=1'
)
project_link = schedule
time.sleep(1)
search_link = browser.find_element_by_link_text('Search')
time.sleep(1)
search_link.click()
pm_number_field = browser.find_element_by_id('PMNumber_txt3')
pm_number_field.clear()
pm_number_field.send_keys(schedule)
search_button = browser.find_element_by_id('SearchScreenBtnSearch')
search_button.click()
time.sleep(1)
browser.find_element_by_partial_link_text(project_link).click()
def update_item_price(
target_agreement,
item_id,
item_price,
):
browser.get(
'https://sysco.sprocketcmms.com/Default.aspx?screen=Vendor%20Purchase%20Agreements'
)
parent_vpa = browser.find_element_by_link_text(target_agreement)
parent_vpa.click()
items_tab = browser.find_element_by_id('liItems')
items_tab.click()
search_id = browser.find_element_by_id(
'ajaxReport_itemsReport_promptsdivContainer_0_input')
search_id.clear()
search_id.send_keys(item_id)
id_search_button = browser.find_element_by_xpath(
'/html/body/form/div[3]/div[3]/div[2]/div/div[2]/div/div[1]/input')
id_search_button.click()
time.sleep(1)
get_edit = browser.find_element_by_link_text('Edit')
get_edit.click()
price_field = browser.find_element_by_id('StdSf581_Price_txt')
price_field.clear()
price_field.send_keys(item_price)
save_button = browser.find_element_by_xpath(
'/html/body/form/div[3]/div[3]/div[3]/div[3]/input[1]')
save_button.click()
time.sleep(1)
print('VPA {} item {} price updated to {}'.format(target_agreement,
item_id, item_price))
def correct_device_id(new_value, old_value):
device_id_field = browser.find_element_by_id(
'StdSf45_DeviceIdentifier_txt')
device_id_field.clear()
device_id_field.send_keys(new_value)
save_record = browser.find_element_by_id('liSave')
save_record.click()
time.sleep(1)
print('{} updated to {}'.format(old_value, new_value))
def add_user_group(group):
groups_tab = browser.find_element_by_id('liGroups')
groups_tab.click()
time.sleep(3)
add_group = browser.find_element_by_id('txt_Group')
add_group.send_keys(group)
submit_group = browser.find_element_by_xpath(
'//*[@id="divGroups"]/table/tbody/tr[1]/td[2]/input[2]')
submit_group.click()
time.sleep(3)
def set_default_password():
additional_tab = browser.find_element_by_id('liAdditional')
additional_tab.click()
time.sleep(3)
pw_field = browser.find_element_by_id('txtNewPass')
pw_field.clear()
pw_field.send_keys('sprocket')
confirm_pw_field = browser.find_element_by_id('txtConfirmNewPass')
confirm_pw_field.clear()
confirm_pw_field.send_keys('sprocket')
def correct_pmp_name(new_sch_name, archive_flag=0):
details_name = browser.find_element_by_id('Name_txt')
details_name.clear()
details_name.send_keys(new_sch_name)
if archive_flag == 0:
archive_flag_box = browser.find_element_by_id('Archived_chk')
archive_flag_box.click()
save_details = browser.find_element_by_link_text('Save')
save_details.click()
time.sleep(3)
def update_record(inv_id, oem_num, sds_bol):
browser.find_element_by_link_text(inv_id).click()
time.sleep(1)
edit_button = browser.find_element_by_id('btnEditRequest')
edit_button.click()
oem_field = browser.find_element_by_id('StdSf12_OEMNumber_txt')
oem_field.clear()
oem_field.send_keys(oem_num)
select1 = Select(browser.find_element_by_id('StdSf12_SDS_txt'))
select1.select_by_visible_text(sds_bol)
def search_id(inv_id):
search_button = browser.find_element_by_id('liSearch')
search_button.click()
product_id_field_search = browser.find_element_by_id(
'Product_Identifier_txt0')
product_id_field_search.clear()
product_id_field_search.send_keys(inv_id)
search_button = browser.find_element_by_id('SearchScreenBtnSearch')
search_button.click()
time.sleep(3)
def find_main(main_target):
browser.get('https://sysco.sprocketcmms.com/Default.aspx?screen=Inspection%20Manager')
search_box = browser.find_element_by_id('liSearch')
search_box.click()
search_by_name = browser.find_element_by_id('Inspection_Name_txt1')
search_by_name.clear()
search_by_name.send_keys(main_target)
submit_search = browser.find_element_by_id('SearchScreenBtnSearch')
submit_search.click()
time.sleep(2)
def fsi_page_four(target_request):
request = browser.find_element_by_id('txtRequestName')
request.send_keys(target_request)
time.sleep(1)
add4 = browser.find_element_by_id('lnkAddRequest')
time.sleep(1)
add4.click()
time.sleep(2)
finish4 = browser.find_element_by_id('btn_Step4_Finish')
finish4.click()
time.sleep(5)
browser.switch_to.alert.accept()
def search_equip(unit):
browser.get(
'https://sysco.sprocketcmms.com/Default.aspx?screen=Equipment&SSF=-102'
)
equip_search = browser.find_element_by_id('liSearch')
equip_search.click()
equip_field = browser.find_element_by_id('Equipment_txt4')
equip_field.clear()
equip_field.send_keys(unit)
submit_button = browser.find_element_by_id('SearchScreenBtnSearch')
submit_button.click()
time.sleep(1)
def fsi_page_two(unit, set=1):
type = ['Equipment', 'Location']
in_type = Select(browser.find_element_by_id('ddlAssetType'))
in_type.select_by_visible_text(type[set])
add_unit = browser.find_element_by_id('txtAddAsset')
add_unit.send_keys(unit)
add_submit = browser.find_element_by_link_text('Add')
add_submit.click()
time.sleep(3)
next2 = browser.find_element_by_id('btn_Step2_Next')
next2.click()
time.sleep(3)
def update_employee_tab():
browser.implicitly_wait(10)
employee_tab = browser.find_element_by_id('liEmployee')
employee_tab.click()
time.sleep(1)
remove_web_requester = browser.find_element_by_id('StdSf_102_License_ddl')
remove_web_requester.send_keys('User')
save_update_employee = browser.find_element_by_id('liSave')
save_update_employee.click()
time.sleep(5)
browser.switch_to.alert.accept()
time.sleep(1)
def archive_item(inventoryItemId):
browser.implicitly_wait(60)
base_url = 'https://sysco.sprocketcmms.com/Default.aspx?screen=Inventory%20Item&InstanceName='
target_item_url = '{}{}'.format(base_url, inventoryItemId)
browser.get(target_item_url)
time.sleep(5)
archive_chk_box = browser.find_element_by_id('StdSf12_Archived_chk')
archive_chk_box.click()
save_archive = browser.find_element_by_id('liSave')
save_archive.click()
time.sleep(5)
browser.find_element_by_id('liExit').click()
time.sleep(5)
def device_search(old_value):
browser.get('https://sysco.sprocketcmms.com/Default.aspx?screen=Devices')
search_button = browser.find_element_by_id('liSearch')
search_button.click()
device_id_search_field = browser.find_element_by_id(
'Device_Identifier_txt0')
device_id_search_field.clear()
device_id_search_field.send_keys(old_value)
start_search = browser.find_element_by_id('SearchScreenBtnSearch')
start_search.click()
time.sleep(1)
record_link = browser.find_element_by_link_text(old_value)
record_link.click()
time.sleep(1)
def nav_wo_record(target_id):
record_link = \
'https://sysco.sprocketcmms.com/Default.aspx?screen=Work%20Order%20Details&InstanceName={}'.format(target_id)
browser.get(record_link)
time.sleep(3)
inspection_tab = browser.find_element_by_id('liInspection')
inspection_tab.click()
def equipment_page(unit):
# Find and select Equipment
browser.implicitly_wait(15)
browser.get(
'https://sysco.sprocketcmms.com/Default.aspx?screen=Equipment&SSF=-102'
)
search_field = browser.find_element_by_link_text('Search')
search_field.click()
equip_search = browser.find_element_by_id('Equipment_txt4')
equip_search.clear()
equip_search.send_keys(unit)
searchButton = browser.find_element_by_id('SearchScreenBtnSearch')
searchButton.click()
time.sleep(5)
unit_link = browser.find_element_by_link_text(unit)
unit_link.click()
def remove_asset():
assets_tab = browser.find_element_by_id('liAssets')
assets_tab.click()
time.sleep(1)
remove_asset_link = browser.find_element_by_link_text('Remove')
remove_asset_link.click()
time.sleep(1)
browser.switch_to.alert.accept()
def remove_schedule():
sch_tab = browser.find_element_by_id('liSchedules')
sch_tab.click()
time.sleep(1)
remove_sch_link = browser.find_element_by_link_text('Remove')
remove_sch_link.click()
time.sleep(1)
browser.switch_to.alert.accept()
def user_details(target_id, first_name, last_name, a=1):
browser.get(
'https://sysco.sprocketcmms.com/Default.aspx?screen=People&SSF=-134')
create_new_person_button = browser.find_element_by_xpath(
'//*[@id="btnNewLink"]')
create_new_person_button.click()
time.sleep(3)
id_field = browser.find_element_by_id('StdSf_62_UserName_txt')
id_field.clear()
id_field.send_keys(target_id)
fname_field = browser.find_element_by_id('StdSf_62_FirstName_txt')
fname_field.clear()
fname_field.send_keys(first_name)
lname_field = browser.find_element_by_id('StdSf_62_LastName_txt')
lname_field.clear()
lname_field.send_keys(last_name)
ignore_wdt = browser.find_element_by_id('StdSf_62_OverrideWorkDay_chk')
ignore_wdt.click()
ignore_wd_termination = browser.find_element_by_id(
'StdSf_62_IgnoreWorkDayTermination_chk')
ignore_wd_termination.click()
access_flag = int(a)
if access_flag == 1:
access_food_safety = browser.find_element_by_id(
'StdSf_62_Food_Safety_chk')
access_food_safety.click()
save_initial = browser.find_element_by_id('liSave')
save_initial.click()
time.sleep(5)
browser.switch_to.alert.accept()
time.sleep(1)
def create_new(option, start, length):
browser.implicitly_wait(15)
war_tab = browser.find_element_by_link_text('Warranty')
time.sleep(1)
war_tab.click()
time.sleep(1)
war_link = browser.find_element_by_id('newWarranty_anchor')
war_link.click()
war_name = browser.find_element_by_id('newWarranty_WarrantyID')
war_name.send_keys(option)
war_start = browser.find_element_by_id('newWarranty_StartDate')
war_start.clear()
war_start.send_keys(start)
war_end = browser.find_element_by_id('newWarranty_EndDate')
war_end.clear()
war_end.send_keys(length)
war_save = browser.find_element_by_id('newWarranty_save')
war_save.click()
time.sleep(3)
def gen_number(unit_description, location, equipment_type, department,
manufacturer, inventory_number, start_date, gb_fuel_type,
equipment_system):
browser.get(
'https://sysco.sprocketcmms.com/Default.aspx?screen=Equipment&SSF=-102'
)
time.sleep(1)
new_equip_button = browser.find_element_by_id('btnNewLink')
new_equip_button.click()
field_id = browser.find_element_by_id('StdSf_70_EquipmentIdentifier_txt')
field_id.send_keys('AUTONUMBER')
desc_field = browser.find_element_by_id('StdSf_70_Description_txt')
desc_field.send_keys(unit_description)
location_field = browser.find_element_by_id('StdSf_70_LocationID_txt')
location_field.send_keys(location)
type_field = browser.find_element_by_id('StdSf_70_EquipmentTypeID_txt')
type_field.send_keys(equipment_type)
dept_field = browser.find_element_by_xpath(
'//*[@id="StdSf_70_Div1"]/p[8]/div/input')
dept_field.send_keys(department)
man_field = browser.find_element_by_id('StdSf_70_Manufacturer_txt')
man_field.send_keys(manufacturer)
inv_field = browser.find_element_by_id('StdSf_70_InventoryNumber_txt')
inv_field.send_keys(inventory_number)
start_date_field = browser.find_element_by_id('StdSf_70_DateInService_txt')
start_date_field.send_keys(start_date)
gb_type_field = browser.find_element_by_xpath(
'//*[@id="StdSf_70_Div3"]/p[12]/div/input')
gb_type_field.send_keys(gb_fuel_type)
equip_sys_field = browser.find_element_by_id(
'StdSf_70_EquipmentSystemID_txt')
equip_sys_field.send_keys(equipment_system)
browser.find_element_by_link_text('Save').click()
time.sleep(3)
def create_vpa(y, y_description, y_vendor_id, y_date, y_expire, PreferredVendor=1):
browser.get('https://sysco.sprocketcmms.com/Default.aspx?screen=Vendor%20Purchase%20Agreements')
vpa_new_button = browser.find_element_by_xpath('//*[@id="btnNewLink"]')
time.sleep(1)
vpa_new_button.click()
name_field = browser.find_element_by_id('StdSf580_Name_txt')
name_field.send_keys(y)
description_field = browser.find_element_by_id('StdSf580_Description_txt')
description_field.send_keys(y_description)
vendor_id_field = browser.find_element_by_id('StdSf580_VendorID_txt')
vendor_id_field.send_keys(y_vendor_id)
start_date_field = browser.find_element_by_id('StdSf580_StartDate_txt')
start_date_field.send_keys(y_date)
end_date_field = browser.find_element_by_id('StdSf580_EndDate_txt')
end_date_field.send_keys(y_expire)
preferred_vendor_check = browser.find_element_by_id('StdSf580_PreferredVendor_chk')
if PreferredVendor == 1:
preferred_vendor_check.click()
time.sleep(1)
browser.find_element_by_link_text('Save').click()
time.sleep(1)
browser.find_element_by_link_text('Exit').click()
else:
browser.find_element_by_link_text('Save').click()
time.sleep(1)
browser.find_element_by_link_text('Exit').click()
def clear_oos_field(unit):
unit_link = browser.find_element_by_link_text(unit)
unit_link.click()
time.sleep(1)
date_oos_field = browser.find_element_by_id(
'StdSf_70_DateOutOfService_txt')
date_oos_field.clear()
save_change = browser.find_element_by_link_text('Save')
save_change.click()
time.sleep(3)
exit_record = browser.find_element_by_link_text('Exit')
exit_record.click()
time.sleep(3)
def page_three_alt(sch_name, start, set=0):
set_lead_days = ['0', '7', '30']
pm_plan_link = browser.find_element_by_link_text(
'Add a new PM Project Plan Schedule')
pm_plan_link.click()
time.sleep(1)
name_page3 = browser.find_element_by_id('schedule_txtName')
name_page3.send_keys(sch_name)
start_page3 = browser.find_element_by_id('schedule_txtStartDate')
start_page3.send_keys(start)
lead_days = browser.find_element_by_id('schedule_txtLeadDays')
lead_days.clear()
lead_days.send_keys(set_lead_days[set])
daily3 = Select(browser.find_element_by_id('ddlRecurrenceType'))
daily3.select_by_visible_text('Does not repeat')
save_sch3 = browser.find_element_by_xpath(
'//*[@id="tblPMProjectPlanSchedule"]/table/tbody/tr[2]/td[2]/input')
time.sleep(1)
save_sch3.click()
time.sleep(1)
next3 = browser.find_element_by_id('btn_Step3_Next')
time.sleep(1)
next3.click()
time.sleep(1)
def page_three(sch_name, start, frequency, set=2, week_day=0):
set_lead_days = ['0', '7', '30']
pm_plan_link = browser.find_element_by_link_text(
'Add a new PM Project Plan Schedule')
pm_plan_link.click()
time.sleep(1)
name_page3 = browser.find_element_by_id('schedule_txtName')
name_page3.send_keys(sch_name)
start_page3 = browser.find_element_by_id('schedule_txtStartDate')
start_page3.send_keys(start)
lead_days = browser.find_element_by_id('schedule_txtLeadDays')
lead_days.send_keys(set_lead_days[set])
daily3 = Select(browser.find_element_by_id('ddlRecurrenceType'))
daily3.select_by_visible_text('Daily')
if week_day == 1:
browser.find_element_by_id('dr_chkEveryWeekday').click()
save_sch3 = browser.find_element_by_xpath(
'//*[@id="tblPMProjectPlanSchedule"]/table/tbody/tr[2]/td[2]/input'
)
time.sleep(1)
save_sch3.click()
time.sleep(1)
next3 = browser.find_element_by_id('btn_Step3_Next')
time.sleep(1)
next3.click()
time.sleep(1)
else:
target_frequency = browser.find_element_by_id('dailyR_txtEvery')
target_frequency.send_keys(frequency)
save_sch3 = browser.find_element_by_xpath(
'//*[@id="tblPMProjectPlanSchedule"]/table/tbody/tr[2]/td[2]/input'
)
time.sleep(1)
save_sch3.click()
time.sleep(1)
next3 = browser.find_element_by_id('btn_Step3_Next')
time.sleep(1)
next3.click()
time.sleep(1)
def remove_web_group():
browser.implicitly_wait(10)
group_tab = browser.find_element_by_id('liGroups')
group_tab.click()
time.sleep(3)
web_group = browser.find_element_by_xpath(
'//*[@id="groups_AssignedGroups"]/option[2]')
web_group.click()
remove_button = browser.find_element_by_xpath(
'//*[@id="divGroups"]/table/tbody/tr[2]/td[2]/input')
remove_button.click()
time.sleep(3)
save_groups = browser.find_element_by_link_text('Save')
save_groups.click()
time.sleep(5)
browser.switch_to.alert.accept()
time.sleep(1)
def add_item(target_agreement, item_id, item_price, status, vendor_id):
browser.get(
'https://sysco.sprocketcmms.com/Default.aspx?screen=Perform%20Inspection&ID=43579&InstanceName=43579'
)
target_vpa = browser.find_element_by_id('question_4881136')
target_vpa.send_keys(target_agreement)
product_id = browser.find_element_by_id('question_4881132')
product_id.send_keys(item_id)
price_field = browser.find_element_by_id('question_4881133')
price_field.send_keys(item_price)
purchase_status_field = browser.find_element_by_id('question_4881134')
purchase_status_field.send_keys(status)
vendor_id_field = browser.find_element_by_id('question_4881135')
vendor_id_field.send_keys(vendor_id)
is_true_field = browser.find_element_by_id('question_4881137')
is_true_field.send_keys('TRUE')
submit_btn = browser.find_element_by_id(
'ctl00_MainPage_PerformInspection_43579_submit')
submit_btn.click()
time.sleep(1)
print('-----> {} added'.format(item_id))
def fsi_page_one(sch_name, start, sch_on_comp_flag=1):
new_pm_btn = browser.find_element_by_id('btnNewLink')
new_pm_btn.click()
pm_name = browser.find_element_by_id('txtName')
pm_name.send_keys(sch_name)
new_des = browser.find_element_by_id('txtDescription')
new_des.send_keys(sch_name)
time.sleep(1)
pm_name.click()
new_enable_on = browser.find_element_by_id('txtEnableOn')
new_enable_on.send_keys(start)
time.sleep(3)
next1 = browser.find_element_by_id('btn_Step1_Next')
if sch_on_comp_flag == 1:
sch_on_completion = browser.find_element_by_id('ScheduleOnCompletion_chk')
sch_on_completion.click()
next1.click()
else:
time.sleep(1)
next1.click()
time.sleep(1)
