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)