def email_list(recipient, products):
subject = "Purchase list for %s" % products[0].supplier
title = products[0].supplier
headers = ('category', 'client', 'grade','colour', 'comment', 'name', 'quantity')
rows = []
for p in products:
rows.append(p.tupple())
email.email_chart(title,headers,rows, subject, recipient,True)
def email_list_supplier(start_date,
end_date,
supplier_code,
day=dates.todays_date()):
supplier_code = supplier_code.upper()
supplier_file_name = "C:\\Users\\Antoine\\Desktop\\Tools\\frontend\\suppliers\\supplier_info.csv"
products = get_purchase_list_report(start_date, end_date, supplier_code)
suppliers = {}
with open(supplier_file_name, 'r') as file:
headers = file.readline().strip().split(',')
for line in file:
line = line.strip().split(',')
supplier = {}
for i in range(1, len(headers)):
supplier[headers[i]] = line[i]
suppliers[line[0]] = supplier
try:
supplier = suppliers[supplier_code]
except:
supplier = suppliers["METZ"]
subject = "FleuraMetz order for %s - %s" % (supplier['supplier_name'], day)
recipient = supplier['email']
intro_text = """ Hello {0},
Can I get the following for {1} please:
Thanks,
Antoine
""".format(supplier['sales_name'], day)
print(intro_text)
title = "Order for %s" % supplier['supplier_name']
headers = ('category', 'Product', 'grade', 'colour', 'quantity', 'Comment')
rows = []
product = {}
for p in products:
p = p.tupple()
if p[:-2] not in product:
product[p[:-2]] = p[-1]
else:
product[p[:-2]] = product[p[:-2]] + p[-1]
for p in product:
rows.append(p + (product[p], ))
rows.sort()
email.email_chart(title, headers, rows, subject, recipient, True)