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)