########################
ask_for_next_item=True #
recp=""                #Initlizing varibles
########################
total_cost=0



while ask_for_next_item is True:



    print("Enter a GTIN8 Number:")

    product_ordered=input(">> ")

    print("Enter quantity:")



    quantity_ordered_str=input(">> ")

    quantity_ordered=int(quantity_ordered_str)



    f=open("database.csv","r")

    o=open('temp.csv', 'w')

    item_in_catalogue=False

    for line in f:

        items=line.split(",")

        if len(items)==6:

            code,desc,price,stock,reorder,target=items

            print (code,desc,price,stock,reorder,target)

            stock=int(stock)

            if code==product_ordered:

                print("found product")

                item_in_catalogue=True

                if stock==0:

                    print('Item out of stock')

                    quantity_ordered=0

                elif quantity_ordered>stock:

                    quantity_ordered=stock

                    print('Order being adjusted due to not enough stock: adjusting order to ', quantity_ordered, 'items')

                new_stock_level=stock-quantity_ordered

                stock=new_stock_level

                price_for_order=float(price)*quantity_ordered

                total_cost=total_cost+price_for_order

                print('Ordered item: {} of item {}'.format(quantity_ordered,desc))

            out_line='{},{},{},{},{},{}'.format(code,desc,price,stock,reorder,target)

            o.write(out_line)

    f.close()

    o.close()



    o=open("database.csv","w")

    f=open('temp.csv', 'r')

    for line in f:

        o.write(line)

    o.close()

    f.close()

    if item_in_catalogue==False:

        print("PRODUCT NOT FOUND")

        recp+=str(product_ordered)+" product not found"



    print("Order another item (y/n)?")

    another_item=input(" ")

    if another_item=="y":

        ask_for_next_item=True

    else:

        ask_for_next_item=False

        1

print("Order complete")

recp=recp+"Total cost of order "+\
             "{:.2f}".format(total_cost)+"\n"

print(recp)



print('Checking stock levels')
print('You need to order...')
f=open("database.csv","r")

for line in f:

    items=line.split(",")

    if len(items)==6:

      code,desc,price,stock,reorder,target=items

      stock=int(stock)

      reorder=int(reorder)

      target=int(target)

      if stock<=reorder:

          order_number=target-stock

          print("{} {} x {}".format(code, desc, order_number))