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