def inbound(indls):
driver = get_driver()
login(driver, user, password)
navigate_in(driver, indls)
cursor = create_hana_connection()
item_list = get_indls_data_from_lips(cursor, indls)
pallets = []
for item in item_list:
matnr, quantity, charge = item
matnr = matnr.lstrip("0")
quantity = str(quantity)
pallets.append(input_pallet(driver, create_pallet(cursor)))
input_material(driver, matnr)
input_quantity(driver, quantity)
if charge == "X":
input_charge_date(driver, cursor, matnr)
close_pallet(driver)
navigate_out(driver)
print(f"PALLETS = {pallets}")
return pallets
def main_confirm_to(pallets):
driver = get_driver()
login(driver)
open_wm_cnf(driver)
confirm_to(driver, pallets)
close_browser(driver)
def web_driver_and_login(data):
data["web_driver"] = get_driver(data["system"])
login(data["web_driver"])
return data
driver.find_element(By.CSS_SELECTOR, "input[name*='answer_no']").click()
def exit_control(driver):
back_menu = driver.find_element_by_id("butback")
back_menu.click()
back_menu = driver.find_element_by_id("butback")
back_menu.click()
def control(driver, cursor, deliveries):
position_and_boxes_dict, type_consolidation_dict = get_data_for_control(cursor, deliveries)
empty_hu_list = get_empty_hu(cursor)
storage_types = "02", "03", "04"
for storage_type in storage_types:
control_over_type(driver, position_and_boxes_dict, type_consolidation_dict, empty_hu_list, storage_type)
change_workstation(driver, "all")
return driver
if __name__ == '__main__':
wd = get_driver()
login(wd)
cursora = create_hana_connection()
deliveris = ['2000003236', ]
control(wd, cursora, deliveris)
# print(get_data_for_control(cursora, deliveris))
while type_hu_dict[storage_type]:
type_hu_dict[storage_type] -= 1
data = get_sorting_data(driver)
add_box_to_sorted_cart(driver, data, empty_cart)
exit_cart_add2(driver)
def shipment_sorted(driver, cursor, route):
dlv_and_boxes_dict, type_hu_dict, empty_carts = get_data_for_route(
cursor, route)
storage_types = "02", "03", "04"
for storage_type in storage_types:
shipment_over_type(driver, route, type_hu_dict, storage_type,
empty_carts.pop())
change_workstation(driver, "all")
return driver
if __name__ == '__main__':
wd = get_driver("k4d")
login(wd)
cursora = create_hana_connection("k4d")
route = 100007
shipment_sorted(wd, cursora, route)
# print(get_data_for_route(cursora, route))
def driver():
return get_driver()
if material_type == "MASO":
partial_amount = str(
round(table_data["alt_amount"] / int(table_data["amount"]), 3))
input_quantity(driver, partial_amount)
if int(table_data["amount"]) > 1:
for _ in range(int(table_data["amount"]) - 1):
pick_meat(driver, box_no, partial_amount)
close_wmq_add(driver)
if ovozel_hu:
weight_ovozel(driver, ovozel_hu)
return picked_hu
# def get_no_items_in_transport_orders(cursor, transport_order):
#
# cursor.execute(f'select * from "SAPECP"."LTAP" where TANUM = {transport_order}')
# no_items = len(cursor.fetchall())
# return int(no_items)
if __name__ == '__main__':
wd = get_driver("k4t")
login(wd)
cursor = create_hana_connection()
picking(wd, cursor, "S1268")
# enter_wmq_add(wd)
# print(get_table_data(wd))