def get_order():
low_stock = []
#Get data needed for order
results = Database.join(
"Products.order_qty, Products.id, Stock.stock_healthy, Stock.site_id, Stock.id",
"Stock", "Products", "product_id", "id")
for result in results:
if result[2] == 0:
address = Database.find("Sites", "name", result[3])[0][1]
low_stock.append([result[0], result[1], address])
#Set the all the stock that was low to ordered
Database.update("Stock", "stock_healthy", "NULL", "stock_healthy",
0)
order = ""
#Setup email without list formatting
for stock in low_stock:
line = ""
for info in stock:
line = line + " " + str(info)
order = order + "\n" + line
make_order(order)
def instant_order(stock_id):
#Get dat needed for order
product_id = Database.find("Stock", "id", stock_id)[0][1]
site_id = Database.find("Stock", "id", stock_id)[0][2]
order_qty = Database.find("Products", "id", product_id)[0][2]
address = Database.find("Sites", "name", site_id)[0][1]
details = product_id, order_qty, address
order = ""
#Setup email without list formatting
for detail in details:
order = order + str(detail) + " "
make_order(order)
