I need a php script written to help me manage alcohol stock.
I buy and sell stock on a daily basis, so should be designed to easily and quickly add stock in and remove stock sold.
I have approximately 200 items and I should be able to view at any time the amount of each item I have in stock
Main features are
Catagories - (add, remove) should be able to view all items in catagory at one time
Items - (add, remove), info about supplier, cost, portion size
Stock in - should be able to list all items in a catagory and add quantities
Stock out - should be able to list all items in a catagory and remove quantities
Cocktails - should be able to list ingredients in a cocktail from 'items' so when cocktail is sold it will remove stock from each item. eg vodka martini. I enter 3 sold and it should remove 3 portions of vodka and 3 portions martini from the 'items' stock
users - should be able to add users and give users rights to add/edit/view/remove eg, user 1 has all rights, user 2 can add items and quantities to stock but not remove them, user 3 can enter sales to remove stock but not add items or quantities.