def make_list(quantity, packing, price=None, selling=None): original_price = price items = [] while True: try: assortment = add_article() except: assortment = lots.get_lot_info_assortment() if not original_price: price = input("FOB price") item = { 'assortment_code': assortment['assortment_code'], 'quantity': quantity, 'packing': packing, 'fob': price, 'landed': price, 'assortment': assortment } if selling: item['selling'] = selling items.append(item) window.drag_window() keyboard.f12() choice = input("next") if 'n' in choice.lower(): return items
def set_availability_dates(from_date, to_date, cut_off_start_date, cut_off_start_time, cut_off_date, cut_off_time): time.sleep(1) window.drag_window() if not verify((('Available', 22, 54), ('Visible', 25, 56))): time.sleep(1) if not verify((('Available', 22, 54), ('Visible', 25, 56))): print("sent") keyboard.command("INSERT") keyboard.command("F6") for d in (from_date, to_date): keyboard.write_text(d) keyboard.command("enter") keyboard.write_text('0000') keyboard.command("enter") keyboard.write_text(cut_off_start_date) keyboard.command("enter") keyboard.write_text(cut_off_start_time) keyboard.command("enter") keyboard.write_text(cut_off_date) keyboard.command("enter") keyboard.write_text(cut_off_time) keyboard.command("enter") keyboard.command("enter") keyboard.f11()
def add_article(): window.drag_window() keyboard.command(('shift', 'F10')) assortment = lots.get_lot_info_assortment() assortment['system'] = 'f2_canada_real' assortment['category_name'] = assortment['catgeory'] assortment['category_code'] = assortment['category_num'] del assortment['purchase_date'] del assortment['lot_number'] del assortment['supplier_code'] del assortment['category_num'] del assortment['landed_price'] del assortment['catgeory'] insert_data.insert_assortment(**assortment) return assortment
def easter_list(virtual_purchase_order_id, system, monday_date, quantity, packing): year = dates.get_pricing_year(monday_date) week = dates.get_pricing_week(monday_date) known_prices = dict() while True: try: assortment = add_article() except: assortment = lots.get_lot_info_assortment() if assortment['name'] == '': print('Blank') print(lots.get_lot_info_assortment()) assortment_code = assortment['assortment_code'] grade = assortment['grade'] fob = input(f"What is the FOB price for {assortment['name']} {grade}") if float(fob) in known_prices: price = known_prices[float(fob)] else: price = input( f"What is the Selling price for {assortment['name']} {grade}") known_prices[float(fob)] = price if not get_data.check_assortment_price(assortment_code, week, year, system): insert_data.insert_weekly_price(system, week, year, assortment_code, price) else: print(price) update_data.update_weekly_price(system, year, week, assortment_code, price) landed = fob time.sleep(.5) window.drag_window() keyboard.f12() keyboard.command('down') insert_data.insert_virtual_purchase(assortment_code, quantity, packing, fob, landed, virtual_purchase_order_id, entered=False) input("next")
def make_list_from_file(system, filename, po_id): variety = '' order_date = get_data.get_virtual_purchase_order(po_id)[2] week = dates.get_week(order_date) year = dates.get_year(order_date) df = import_ecuador_prices(filename) for index, row in df.iterrows(): if not pd.isnull(row['$ fob']): if row['Variety'].strip() != variety: variety = row['Variety'].strip() window.drag_window() keyboard.write_text(variety) print_row_ecuador(row) answer = input("next") if answer == '': try: assortment = add_article() except: assortment = lots.get_lot_info_assortment() keyboard.f12() keyboard.command('down') insert_data.insert_virtual_purchase( assortment_code=assortment['assortment_code'], quantity=15, packing=row['St/bx'], fob="%0.2f" % row['$ fob'], landed="%0.2f" % row['$ fob'], virtual_purchase_order_id=po_id, entered=False) try: insert_data.insert_weekly_price( system, week, year, assortment['assortment_code'], row['selling']) except: update_data.update_weekly_price( system, year, week, assortment['assortment_code'], row['selling']) elif 'q' in answer: break elif 'n' in answer: pass return df
def Rosaprima_mday(): while True: try: assortment = add_article() except: assortment = lots.get_lot_info_assortment() assortment_code = assortment['assortment_code'] grade = assortment['grade'] quantity = 20 packing = 100 if str(grade) == '40': fob = .69 p = 125 elif str(grade) == '50': fob = .82 p = 100 elif str(grade) == '60': fob = .89 p = 100 elif str(grade) == '70': fob = .92 p = 75 elif str(grade) == '80': fob = .92 p = 75 landed = calc_landed(fob, p) virtual_purchase_order_id = 26 keyboard.f12() keyboard.command('down') print(assortment) input("next") time.sleep(.5) window.drag_window() insert_data.insert_virtual_purchase(assortment_code, quantity, packing, fob, landed, virtual_purchase_order_id, entered=False)
def get_lot_data(lot, system): lot_number = lot[0] purchase_date = lot[1] window.drag_window() keyboard.command("f7") keyboard.write_text(lot_number) keyboard.enter() for i in range(5): try: lot_main = parse.get_input_purchase_lots(system, purchase_date) break except: lot_main = False time.sleep(.1) if not lot_main or lot_number not in lot_main: return False lot_main = lot_main[lot_number] supplier_code = lot_main['supplier_code'] if not supplier_code or supplier_code[0] in ( 'M', '1') and 'f2_canada' in system: return False data = lots.get_lot_info_purchase(lot_number, purchase_date, supplier_code) keyboard.f12() return data